DAL/TCWL_D_Services.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_Services
    {
        public bool Add(TCWL_M_Services model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_FuWuGuanLi(");
            builder.Append("FuWuBianHao,GaiYao,FuWuQingQiu,FuWuLeiXing,WenTiLeiXing,JinJiChengDu,QingQiuRiQi,WenTiLaiYuan,KeHuMingCheng,LianXiRen,LianXiDianHua,LianXiYouXiang,LianXiDiZhi,ShouLiRen,ChuLiZhuangTai,WenTiMiaoShu,ChanPinLieBiao,YuanGongLieBiao,JieJueFanAn,ChuLiJieGuo,GongSiID,ServiceID)");
            builder.Append(" values (");
            builder.Append("@FuWuBianHao,@GaiYao,@FuWuQingQiu,@FuWuLeiXing,@WenTiLeiXing,@JinJiChengDu,@QingQiuRiQi,@WenTiLaiYuan,@KeHuMingCheng,@LianXiRen,@LianXiDianHua,@LianXiYouXiang,@LianXiDiZhi,@ShouLiRen,@ChuLiZhuangTai,@WenTiMiaoShu,@ChanPinLieBiao,@YuanGongLieBiao,@JieJueFanAn,@ChuLiJieGuo,@GongSiID,@ServiceID)");
            SqlParameter[] cmdParms = new SqlParameter[] { 
                new SqlParameter("@FuWuBianHao", SqlDbType.NVarChar, 50), new SqlParameter("@GaiYao", SqlDbType.NVarChar, 50), new SqlParameter("@FuWuQingQiu", SqlDbType.NVarChar, 50), new SqlParameter("@FuWuLeiXing", SqlDbType.NVarChar, 50), new SqlParameter("@WenTiLeiXing", SqlDbType.NVarChar, 50), new SqlParameter("@JinJiChengDu", SqlDbType.NVarChar, 50), new SqlParameter("@QingQiuRiQi", SqlDbType.DateTime), new SqlParameter("@WenTiLaiYuan", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuMingCheng", SqlDbType.NVarChar, 50), new SqlParameter("@LianXiRen", SqlDbType.NVarChar, 50), new SqlParameter("@LianXiDianHua", SqlDbType.NVarChar, 50), new SqlParameter("@LianXiYouXiang", SqlDbType.NVarChar, 50), new SqlParameter("@LianXiDiZhi", SqlDbType.NVarChar, 50), new SqlParameter("@ShouLiRen", SqlDbType.NVarChar, 50), new SqlParameter("@ChuLiZhuangTai", SqlDbType.NVarChar, 50), new SqlParameter("@WenTiMiaoShu", SqlDbType.NVarChar, 500), 
                new SqlParameter("@ChanPinLieBiao", SqlDbType.NVarChar, 50), new SqlParameter("@YuanGongLieBiao", SqlDbType.NVarChar, 50), new SqlParameter("@JieJueFanAn", SqlDbType.NVarChar, 500), new SqlParameter("@ChuLiJieGuo", SqlDbType.NVarChar, 500), new SqlParameter("@GongSiID", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50)
             };
            cmdParms[0].Value = model.FuWuBianHao;
            cmdParms[1].Value = model.GaiYao;
            cmdParms[2].Value = model.FuWuQingQiu;
            cmdParms[3].Value = model.FuWuLeiXing;
            cmdParms[4].Value = model.WenTiLeiXing;
            cmdParms[5].Value = model.JinJiChengDu;
            cmdParms[6].Value = model.QingQiuRiQi;
            cmdParms[7].Value = model.WenTiLaiYuan;
            cmdParms[8].Value = model.KeHuMingCheng;
            cmdParms[9].Value = model.LianXiRen;
            cmdParms[10].Value = model.LianXiDianHua;
            cmdParms[11].Value = model.LianXiYouXiang;
            cmdParms[12].Value = model.LianXiDiZhi;
            cmdParms[13].Value = model.ShouLiRen;
            cmdParms[14].Value = model.ChuLiZhuangTai;
            cmdParms[15].Value = model.WenTiMiaoShu;
            cmdParms[0x10].Value = model.ChanPinLieBiao;
            cmdParms[0x11].Value = model.YuanGongLieBiao;
            cmdParms[0x12].Value = model.JieJueFanAn;
            cmdParms[0x13].Value = model.ChuLiJieGuo;
            cmdParms[20].Value = model.GongSiID;
            cmdParms[0x15].Value = model.ServiceID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool Delete(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_FuWuGuanLi ");
            builder.Append(" where ID=@ID ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x24) };
            cmdParms[0].Value = ID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool DeleteList(string IDlist)
        {