DAL/TCWL_D_Management.cs

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

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

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

    public class TCWL_D_Management
    {
        public bool Add(TCWL_M_Management model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_KeHuXinXi(");
            builder.Append("KeHuBianHao,KeHuDengJi,KeHuLaiYuan,KeHuMingCheng,KeHuDiZhi,KeHuQuYu,KeHuJingLi,KeHuYouXianJi,DianHuaLeiXing,DianHuaHaoMa,ChuanZhen,YouBian,QQ,MSN,YouXiang,ZhuangTai,KeHuXinYuDu,GongXiangRenYuan,ChuangJianRen,KeHuSuoShu,GongSiID,ServiceID,Contact,Sex,Beizhu,Position,cSort)");
            builder.Append(" values (");
            builder.Append("@KeHuBianHao,@KeHuDengJi,@KeHuLaiYuan,@KeHuMingCheng,@KeHuDiZhi,@KeHuQuYu,@KeHuJingLi,@KeHuYouXianJi,@DianHuaLeiXing,@DianHuaHaoMa,@ChuanZhen,@YouBian,@QQ,@MSN,@YouXiang,@ZhuangTai,@KeHuXinYuDu,@GongXiangRenYuan,@ChuangJianRen,@KeHuSuoShu,@GongSiID,@ServiceID,@Contact,@Sex,@Beizhu,@Position,@cSort)");
            SqlParameter[] cmdParms = new SqlParameter[] { 
                new SqlParameter("@KeHuBianHao", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuDengJi", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuLaiYuan", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuMingCheng", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuDiZhi", SqlDbType.NVarChar, 250), new SqlParameter("@KeHuQuYu", SqlDbType.NVarChar, 200), new SqlParameter("@KeHuJingLi", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuYouXianJi", SqlDbType.NVarChar, 50), new SqlParameter("@DianHuaLeiXing", SqlDbType.NVarChar, 50), new SqlParameter("@DianHuaHaoMa", SqlDbType.NVarChar, 200), new SqlParameter("@ChuanZhen", SqlDbType.NVarChar, 50), new SqlParameter("@YouBian", SqlDbType.NVarChar, 50), new SqlParameter("@QQ", SqlDbType.NVarChar, 50), new SqlParameter("@MSN", SqlDbType.NVarChar, 50), new SqlParameter("@YouXiang", SqlDbType.NVarChar, 50), new SqlParameter("@ZhuangTai", SqlDbType.NVarChar, 50), 
                new SqlParameter("@KeHuXinYuDu", SqlDbType.NVarChar, 50), new SqlParameter("@GongXiangRenYuan", SqlDbType.NVarChar, 50), new SqlParameter("@ChuangJianRen", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuSuoShu", SqlDbType.NVarChar, 50), new SqlParameter("@GongSiID", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@Contact", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.NVarChar, 4), new SqlParameter("@Beizhu", SqlDbType.NVarChar, 200), new SqlParameter("@Position", SqlDbType.NVarChar, 50), new SqlParameter("@cSort", SqlDbType.NVarChar, 50)
             };
            cmdParms[0].Value = model.KeHuBianHao;
            cmdParms[1].Value = model.KeHuDengJi;
            cmdParms[2].Value = model.KeHuLaiYuan;
            cmdParms[3].Value = model.KeHuMingCheng;
            cmdParms[4].Value = model.KeHuDiZhi;
            cmdParms[5].Value = model.KeHuQuYu;
            cmdParms[6].Value = model.KeHuJingLi;
            cmdParms[7].Value = model.KeHuYouXianJi;
            cmdParms[8].Value = model.DianHuaLeiXing;
            cmdParms[9].Value = model.DianHuaHaoMa;
            cmdParms[10].Value = model.ChuanZhen;
            cmdParms[11].Value = model.YouBian;
            cmdParms[12].Value = model.QQ;
            cmdParms[13].Value = model.MSN;
            cmdParms[14].Value = model.YouXiang;
            cmdParms[15].Value = model.ZhuangTai;
            cmdParms[0x10].Value = model.KeHuXinYuDu;
            cmdParms[0x11].Value = model.GongXiangRenYuan;
            cmdParms[0x12].Value = model.ChuangJianRen;
            cmdParms[0x13].Value = model.KeHuSuoShu;
            cmdParms[20].Value = model.GongSiID;
            cmdParms[0x15].Value = model.ServiceID;
            cmdParms[0x16].Value = model.Contact;
            cmdParms[0x17].Value = model.Sex;
            cmdParms[0x18].Value = model.Beizhu;
            cmdParms[0x19].Value = model.Position;
            cmdParms[0x1a].Value = model.CSort;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool AddDaoRu(DataTable dt, string ServiceID)
        {
            int batchSize = dt.Rows.Count + 1;
            return DBHelper.Import(dt, batchSize, ServiceID);
        }

        public bool CheckName(string sqlWhere, string v, string srvid)