DA/DBStockBillLists.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;
namespace DA
{
   public  class DBStockBillLists: IDisposable 
    {
          string sql;
        SqlHelpers sqlh;
       //DataSet ds;
       SqlDataReader dr;
        public DBStockBillLists()
        {
            sqlh = new SqlHelpers();
        }
       public DBStockBillLists(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }
        /// <summary>
        ///DB   插入进货明细的方法
        /// </summary>
        /// <param name="sbl"></param>
       public void DBStockBillListsInsert(CStockBillLists sbl)
        {
            List<SqlParameter> pars = new List<SqlParameter>();
            pars.Add(new SqlParameter("@sId", SqlDbType.VarChar, 20));
            pars[0].Value = sbl.SId;
            pars.Add(new SqlParameter("@mssId", SqlDbType.Int));
            pars[1].Value = sbl.MsId;
            pars.Add(new SqlParameter("@msPrice", SqlDbType.Decimal));
            pars[2].Value = sbl.MsPrice;
            pars.Add(new SqlParameter("@msAmount", SqlDbType.Int));
            pars[3].Value = sbl.MsAmount;
            pars.Add(new SqlParameter("@mssMoney", SqlDbType.Decimal));
            pars[4].Value = sbl.MsMoney;
            pars.Add(new SqlParameter("@mssRemark", SqlDbType.VarChar, 50));
            pars[5].Value = sbl.MsRemark;
            sql = "insert into StockBillLists values(@sId,@mssId,@msPrice,@msAmount,@mssMoney,@mssRemark)";
           sqlh.NonQuery(sql, pars, CommandType.Text);
        }

        /// <summary>
        ///Db   修改进货明细的方法
        /// </summary>
        /// <param name="sbl"></param>
       public void DBStockBillListsUpdate(CStockBillLists sbl)
        {
            List<SqlParameter> pars = new List<SqlParameter>();
            pars.Add(new SqlParameter("@sId", SqlDbType.VarChar, 20));
            pars[0].Value = sbl.SId;
            pars.Add(new SqlParameter("@msId", SqlDbType.Int));
            pars[1].Value = sbl.MsId;