DA/DBAccountday.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;

namespace DA
{
  public  class DBAccountday:IDisposable
    {
       private string sql;
       private SqlHelpers sqlh;
       // DataSet ds;
       private SqlDataReader dr;
        public DBAccountday()
        {
            sqlh = new SqlHelpers();
        }
        public DBAccountday(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }


        //Add T_ACCOUNT_DATE
        private string sqlInsert = @"INSERT INTO [T_ACCOUNT_DATE]  ([AccountDay] ,[AccountStart] ,[AccEnd]  ,[createuser] ,[createtime],[updateby],[updatetime],[ShopID],[obj1] ,[obj2]) VALUES  (@AccountDay ,@AccountStart ,@AccountEnd ,@createby ,@createtime ,@updateby ,@updatetime ,@ShopID,@obj1  ,@obj2);";

        //private string sqlInsert = @"INSERT INTO [T_ACCOUNT_DATE]  ([AccountDay] ,[AccountStart] ,[createtime],[updateby],[updatetime],[ShopID],[obj1] ,[obj2]) VALUES  (@AccountDay ,@AccountStart ,@createtime ,@updateby ,@updatetime ,@ShopID,@obj1  ,@obj2);";
        public int T_Account_date_Insert(CTaccount_date ctacc )
        {
            int ret = 0;

            List<SqlParameter> pars = new List<SqlParameter>();
            pars.Add(new SqlParameter("@AccountDay", SqlDbType.DateTime));
            pars[0].Value = ctacc.AccountDay;
            pars.Add(new SqlParameter("@AccountStart", SqlDbType.DateTime));
            pars[1].Value = ctacc.AccountStart;
            pars.Add(new SqlParameter("@AccountEnd", SqlDbType.DateTime));
            pars[2].Value = ctacc.AccountEnd;
            pars.Add(new SqlParameter("@createby", SqlDbType.NVarChar));
            pars[3].Value = ctacc.createby;
            pars.Add(new SqlParameter("@createtime", SqlDbType.DateTime));
            pars[4].Value = ctacc.createtime;
            pars.Add(new SqlParameter("@updateby", SqlDbType.NVarChar));
            pars[5].Value = ctacc.updateby;
            pars.Add(new SqlParameter("@updatetime", SqlDbType.DateTime));
            pars[6].Value = ctacc.updatetime;
            pars.Add(new SqlParameter("@ShopID", SqlDbType.NVarChar));
            pars[7].Value = ctacc.ShopID;
            pars.Add(new SqlParameter("@obj1", SqlDbType.NVarChar));
            pars[8].Value = ctacc.obj1;
            pars.Add(new SqlParameter("@obj2", SqlDbType.NVarChar));
            pars[9].Value = ctacc.obj2;
            ret=sqlh.ExcuteInsert(sqlInsert, pars);
            return ret;