DAL/TCWL_D_SalesOpportunities.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_SalesOpportunities
    {
        public bool Add(TCWL_M_SalesOpportunities model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_XiaoShouJiHui(");
            builder.Append("ID,JiHuiBianHao,JiHuiLeiXing,XiaoShouRenYuan,KeHuMingCheng,KeHuID,JiHuiDengJi,JiHuiJieDuan,JiHuiZhuangTai,JiHuiLaiYuan,LianXiRen,LianXiDianHua,ChuangJianRen,ChuangJianRiQi,JiHuiMiaoShu,ChengGongLv,GongSiID,ServiceID,TimeStr,ZhiPaiRen,ZhuangTai,ZhuangTaiJiHua)");
            builder.Append(" values (");
            builder.Append("@ID,@JiHuiBianHao,@JiHuiLeiXing,@XiaoShouRenYuan,@KeHuMingCheng,@KeHuID,@JiHuiDengJi,@JiHuiJieDuan,@JiHuiZhuangTai,@JiHuiLaiYuan,@LianXiRen,@LianXiDianHua,@ChuangJianRen,@ChuangJianRiQi,@JiHuiMiaoShu,@ChengGongLv,@GongSiID,@ServiceID,@TimeStr,@ZhiPaiRen,@ZhuangTai,@ZhuangTaiJiHua)");
            SqlParameter[] cmdParms = new SqlParameter[] { 
                new SqlParameter("@ID", SqlDbType.NVarChar, 0x24), new SqlParameter("@JiHuiBianHao", SqlDbType.NVarChar, 50), new SqlParameter("@JiHuiLeiXing", SqlDbType.NVarChar, 50), new SqlParameter("@XiaoShouRenYuan", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuMingCheng", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuID", SqlDbType.NVarChar, 0x24), new SqlParameter("@JiHuiDengJi", SqlDbType.NVarChar, 50), new SqlParameter("@JiHuiJieDuan", SqlDbType.NVarChar, 50), new SqlParameter("@JiHuiZhuangTai", SqlDbType.NVarChar, 50), new SqlParameter("@JiHuiLaiYuan", SqlDbType.NVarChar, 50), new SqlParameter("@LianXiRen", SqlDbType.NVarChar, 50), new SqlParameter("@LianXiDianHua", SqlDbType.NVarChar, 50), new SqlParameter("@ChuangJianRen", SqlDbType.NVarChar, 50), new SqlParameter("@ChuangJianRiQi", SqlDbType.DateTime), new SqlParameter("@JiHuiMiaoShu", SqlDbType.NVarChar, 100), new SqlParameter("@ChengGongLv", SqlDbType.Int, 4), 
                new SqlParameter("@GongSiID", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@TimeStr", SqlDbType.DateTime), new SqlParameter("@ZhiPaiRen", SqlDbType.NVarChar, 20), new SqlParameter("@ZhuangTai", SqlDbType.NVarChar, 10), new SqlParameter("@ZhuangTaiJiHua", SqlDbType.NVarChar, 10)
             };
            cmdParms[0].Value = model.ID;
            cmdParms[1].Value = model.JiHuiBianHao;
            cmdParms[2].Value = model.JiHuiLeiXing;
            cmdParms[3].Value = model.XiaoShouRenYuan;
            cmdParms[4].Value = model.KeHuMingCheng;
            cmdParms[5].Value = model.KeHuID;
            cmdParms[6].Value = model.JiHuiDengJi;
            cmdParms[7].Value = model.JiHuiJieDuan;
            cmdParms[8].Value = model.JiHuiZhuangTai;
            cmdParms[9].Value = model.JiHuiLaiYuan;
            cmdParms[10].Value = model.LianXiRen;
            cmdParms[11].Value = model.LianXiDianHua;
            cmdParms[12].Value = model.ChuangJianRen;
            cmdParms[13].Value = model.ChuangJianRiQi;
            cmdParms[14].Value = model.JiHuiMiaoShu;
            cmdParms[15].Value = model.ChengGongLv;
            cmdParms[0x10].Value = model.GongSiID;
            cmdParms[0x11].Value = model.ServiceID;
            cmdParms[0x12].Value = model.TimeStr;
            cmdParms[0x13].Value = model.ZhiPaiRen;
            cmdParms[20].Value = model.ZhuangTai;
            cmdParms[0x15].Value = model.ZhuangTaiJiHua;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool closeChance(string ID)
        {
            string sqlString = string.Format("update TCWL_XiaoShouJiHui set JiHuiZhuangTai='关闭' where ID='{0}'", ID);
            try
            {
                DBHelper.ExecuteSQL(sqlString);
                return true;
            }
            catch (Exception)
            {
                return false;
            }