SenBiTeSolution.DAL/tbl_ProductType.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using SenBiTeSolution.Model;
using SenBiTeSolution.DBUtility;
using System.Data.OleDb;
using System.Web.UI.WebControls;
using System.Data;

namespace SenBiTeSolution.DAL
{
    public class tbl_ProductType
    {
        //判断类别名是否存在
        public bool Exists(string typeName)
        {
            string sqlString = "select count(*) as DataCount from tbl_ProductType where TypeName='" + typeName + "'";

            return DbHelperOleDb.Exists(sqlString);
        }

        //新增类别
        public int AddProductType(Model.tbl_ProductType productType)
        {
            string sqlString = "insert into tbl_ProductType(TypeName,SordNO,CreateDate) values(@TypeName,@SordNO,@CreateDate)";

            OleDbParameter [] parameters = new OleDbParameter[3];

            parameters[0] = new OleDbParameter("@TypeName", OleDbType.VarChar, 20);
            parameters[0].Value = productType.TypeName;

            parameters[1] = new OleDbParameter("@SordNO", OleDbType.Integer, 4);
            parameters[1].Value = productType.SordNO;

            parameters[2] = new OleDbParameter("@CreateDate", OleDbType.VarChar, 20);
            parameters[2].Value = productType.CreateDate;

            return DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);
        }

        //修改类别
        public int UpdateProductType(Model.tbl_ProductType productType)
        {
            string sqlString = "update tbl_ProductType set TypeName=@TypeName,SordNO=@SordNO,CreateDate=@CreateDate where ID=@ID";

            OleDbParameter[] parameters = new OleDbParameter[4];

            parameters[0] = new OleDbParameter("@TypeName", OleDbType.VarChar, 20);
            parameters[0].Value = productType.TypeName;

            parameters[1] = new OleDbParameter("@SordNO", OleDbType.Integer, 4);
            parameters[1].Value = productType.SordNO;

            parameters[2] = new OleDbParameter("@CreateDate", OleDbType.VarChar, 20);
            parameters[2].Value = productType.CreateDate;

            parameters[3] = new OleDbParameter("@ID", OleDbType.Integer, 4);
            parameters[3].Value = productType.ID;