DAL/TCWL_D_AssignSalesOpportunities.cs

（开头部分） 9KB

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

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

    public class TCWL_D_AssignSalesOpportunities
    {
        public bool Add(TCWL_M_AssignSalesOpportunities model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_ZPXiaoShouJiHui(");
            builder.Append("ID,ZhiPaiName,ZhiPaiShiJian,ZhiPaiRenYuan,GongSiID,ServiceID,TimeStr)");
            builder.Append(" values (");
            builder.Append("@ID,@ZhiPaiName,@ZhiPaiShiJian,@ZhiPaiRenYuan,@GongSiID,@ServiceID,@TimeStr)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x24), new SqlParameter("@ZhiPaiName", SqlDbType.NVarChar, 50), new SqlParameter("@ZhiPaiShiJian", SqlDbType.DateTime), new SqlParameter("@ZhiPaiRenYuan", SqlDbType.NVarChar, 50), new SqlParameter("@GongSiID", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@TimeStr", SqlDbType.DateTime) };
            cmdParms[0].Value = model.ID;
            cmdParms[1].Value = model.ZhiPaiName;
            cmdParms[2].Value = model.ZhiPaiShiJian;
            cmdParms[3].Value = model.ZhiPaiRenYuan;
            cmdParms[4].Value = model.GongSiID;
            cmdParms[5].Value = model.ServiceID;
            cmdParms[6].Value = model.TimeStr;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public TCWL_M_AssignSalesOpportunities DataRowToModel(DataRow row)
        {
            TCWL_M_AssignSalesOpportunities opportunities = new TCWL_M_AssignSalesOpportunities();
            if (row != null)
            {
                if (row["ID"] != null)
                {
                    opportunities.ID = row["ID"].ToString();
                }
                if (row["ZhiPaiName"] != null)
                {
                    opportunities.ZhiPaiName = row["ZhiPaiName"].ToString();
                }
                if ((row["ZhiPaiShiJian"] != null) && (row["ZhiPaiShiJian"].ToString() != ""))
                {
                    opportunities.ZhiPaiShiJian = new DateTime?(DateTime.Parse(row["ZhiPaiShiJian"].ToString()));
                }
                if (row["ZhiPaiRenYuan"] != null)
                {
                    opportunities.ZhiPaiRenYuan = row["ZhiPaiRenYuan"].ToString();
                }
                if (row["GongSiID"] != null)
                {
                    opportunities.GongSiID = row["GongSiID"].ToString();
                }
                if (row["ServiceID"] != null)
                {
                    opportunities.ServiceID = row["ServiceID"].ToString();
                }
                if ((row["TimeStr"] != null) && (row["TimeStr"].ToString() != ""))
                {
后面还有 143 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。