DAL/TCWL_D_KaoQinSheZhi.cs

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

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

namespace DAL
{
    using Common;
    using Model;
    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Text;

    public class TCWL_D_KaoQinSheZhi
    {
        public bool Add(TCWL_M_KaoQinSheZhi model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_KaoQinSheZhi(");
            builder.Append("KaoQinShiJian1,KaoQinShiJian2,KaoQinShiJian3,KaoQinShiJian4,AddUser,ServiceID,Setting,DiffTime)");
            builder.Append(" values (");
            builder.Append("@KaoQinShiJian1,@KaoQinShiJian2,@KaoQinShiJian3,@KaoQinShiJian4,@AddUser,@ServiceID,@Setting,@DiffTime)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@KaoQinShiJian1", SqlDbType.VarChar, 50), new SqlParameter("@KaoQinShiJian2", SqlDbType.VarChar, 50), new SqlParameter("@KaoQinShiJian3", SqlDbType.VarChar, 50), new SqlParameter("@KaoQinShiJian4", SqlDbType.VarChar, 50), new SqlParameter("@AddUser", SqlDbType.NVarChar, 0x24), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@Setting", SqlDbType.Int, 4), new SqlParameter("@DiffTime", SqlDbType.Int, 4) };
            cmdParms[0].Value = model.KaoQinShiJian1;
            cmdParms[1].Value = model.KaoQinShiJian2;
            cmdParms[2].Value = model.KaoQinShiJian3;
            cmdParms[3].Value = model.KaoQinShiJian4;
            cmdParms[4].Value = model.AddUser;
            cmdParms[5].Value = model.ServiceID;
            cmdParms[6].Value = model.Setting;
            cmdParms[7].Value = model.DiffTime;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public DataTable GetTb(string ServiceID, string v)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select  top 1 ID,KaoQinShiJian1,KaoQinShiJian2,KaoQinShiJian3,KaoQinShiJian4,Setting,DiffTime from TCWL_KaoQinSheZhi ");
            if (v == "0")
            {
                builder.Append(" where ServiceID=@ServiceID ");
            }
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ServiceID", SqlDbType.NVarChar, 0x24) };
            cmdParms[0].Value = ServiceID;
            DataSet set = DBHelper.Query(builder.ToString(), cmdParms);
            if ((set.Tables.Count > 0) && (set.Tables[0].Rows.Count > 0))
            {
                return set.Tables[0];
            }
            return null;
        }

        public bool Update(TCWL_M_KaoQinSheZhi model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("update TCWL_KaoQinSheZhi set ");
            builder.Append("KaoQinShiJian1=@KaoQinShiJian1,");
            builder.Append("KaoQinShiJian2=@KaoQinShiJian2,");
            builder.Append("KaoQinShiJian3=@KaoQinShiJian3,");
            builder.Append("KaoQinShiJian4=@KaoQinShiJian4,");
            builder.Append("AddUser=@AddUser,");
            builder.Append("Setting=@Setting,");
            builder.Append("TimeStr='" + DateTime.Now + "',");
            builder.Append("DiffTime=@DiffTime");