SenBiTeSolution.DAL/tbl_Product.cs

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

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

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

using SenBiTeSolution.Model;
using System.Data.OleDb;
using SenBiTeSolution.DBUtility;
using System.Data;

namespace SenBiTeSolution.DAL
{
    public class tbl_Product
    {
        //添加产品
        public int AddProduct(Model.tbl_Product product)
        {
            string sqlString = "insert into tbl_Product(BianHao,CaiZhi,ChangHe,ProductImg,PeoductDetail,Type_Id,CreateDate) values(@BianHao,@CaiZhi,@ChangHe,@ProductImg,@PeoductDetail,@Type_Id,@CreateDate)";

            OleDbParameter[] parameters = new OleDbParameter[7];
            parameters[0] = new OleDbParameter("@BianHao", OleDbType.VarChar, 30);
            parameters[0].Value = product.BianHao;

            parameters[1] = new OleDbParameter("@CaiZhi", OleDbType.VarChar, 30);
            parameters[1].Value = product.CaiZhi;

            parameters[2] = new OleDbParameter("@ChangHe", OleDbType.VarChar, 30);
            parameters[2].Value = product.ChangHe;

            parameters[3] = new OleDbParameter("@ProductImg", OleDbType.VarChar,200);
            parameters[3].Value = product.ProductImg;

            parameters[4] = new OleDbParameter("@PeoductDetail", OleDbType.VarChar, 3000);
            parameters[4].Value = product.PeoductDetail;

            parameters[5] = new OleDbParameter("@Type_Id", OleDbType.Integer, 4);
            parameters[5].Value = product.Type_Id;

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

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

        //修改产品
        public int UpdateProduct(Model.tbl_Product product)
        {
            string sqlString = "update tbl_Product set BianHao=@BianHao,CaiZhi=@CaiZhi,ChangHe=@ChangHe,ProductImg=@ProductImg,peoductDetail=@peoductDetail,Type_Id=@Type_Id,CreateDate=@CreateDate where ID=@ID";

            OleDbParameter[] parameters = new OleDbParameter[8];

            parameters[0] = new OleDbParameter("@BianHao", OleDbType.VarChar, 30);
            parameters[0].Value = product.BianHao;

            parameters[1] = new OleDbParameter("@CaiZhi", OleDbType.VarChar, 30);
            parameters[1].Value = product.CaiZhi;

            parameters[2] = new OleDbParameter("@ChangHe", OleDbType.VarChar, 30);
            parameters[2].Value = product.ChangHe;