App_Code/BLL/ProductClass.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using SystemDAL;
using SystemModel;
using System.Data.OleDb;
using Wuqi.Webdiyer;
/// <summary>
/// ProductSort 的摘要说明
/// </summary>
/// 
namespace SystemProductSort
{
    public class ProductSort
    {
        public ProductSort()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        /// <summary>
        /// 用于后台按分类快捷查询datalist
        /// </summary>
        /// <param name="M"></param>
        /// <returns></returns>
        public static DataSet GetMsg()
        {
            string sqlstr = "select * from productclass";
            try
            {
                DAL dal = new DAL();
                return dal.OleExecuteDataSetOleDb(sqlstr);
            }
            catch (Exception E)
            {
                throw E;
            }
        }
        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="name">名称</param>
        /// <returns>int</returns>
        public static int insert(string name, string name2, int classid)
        {
            string sqlstr = "insert into productclass(psname,psname_en,pbcid) values(@name,@name2,@classid)";
            try
            {
                OleDbParameter[] OleDbParameter =
                {
                    new OleDbParameter("@name",name),
                     new OleDbParameter("@name2",name2),
                     new OleDbParameter("@classid",classid)