DAL/TCWL_D_CommunicationRecord.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_CommunicationRecord
    {
        public bool Add(TCWL_M_CommunicationRecord model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_KHJiaoWangJiLu(");
            builder.Append("ShiJian,DiDian,GaiYao,XiangXiXinXi,BeiZhu,KeHuBianHao,GongSiID,ServiceID)");
            builder.Append(" values (");
            builder.Append("@ShiJian,@DiDian,@GaiYao,@XiangXiXinXi,@BeiZhu,@KeHuBianHao,@GongSiID,@ServiceID)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ShiJian", SqlDbType.DateTime), new SqlParameter("@DiDian", SqlDbType.NVarChar, 50), new SqlParameter("@GaiYao", SqlDbType.NVarChar, 50), new SqlParameter("@XiangXiXinXi", SqlDbType.NVarChar, 50), new SqlParameter("@BeiZhu", SqlDbType.NVarChar, 50), new SqlParameter("@KeHuBianHao", SqlDbType.NVarChar, 50), new SqlParameter("@GongSiID", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50) };
            cmdParms[0].Value = model.ShiJian;
            cmdParms[1].Value = model.DiDian;
            cmdParms[2].Value = model.GaiYao;
            cmdParms[3].Value = model.XiangXiXinXi;
            cmdParms[4].Value = model.BeiZhu;
            cmdParms[5].Value = model.KeHuBianHao;
            cmdParms[6].Value = model.GongSiID;
            cmdParms[7].Value = model.ServiceID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public TCWL_M_CommunicationRecord DataRowToModel(DataRow row)
        {
            TCWL_M_CommunicationRecord record = new TCWL_M_CommunicationRecord();
            if (row != null)
            {
                if (row["ID"] != null)
                {
                    record.ID = row["ID"].ToString();
                }
                if ((row["ShiJian"] != null) && (row["ShiJian"].ToString() != ""))
                {
                    record.ShiJian = new DateTime?(DateTime.Parse(row["ShiJian"].ToString()));
                }
                if (row["DiDian"] != null)
                {
                    record.DiDian = row["DiDian"].ToString();
                }
                if (row["GaiYao"] != null)
                {
                    record.GaiYao = row["GaiYao"].ToString();
                }
                if (row["XiangXiXinXi"] != null)
                {
                    record.XiangXiXinXi = row["XiangXiXinXi"].ToString();
                }
                if (row["BeiZhu"] != null)
                {
                    record.BeiZhu = row["BeiZhu"].ToString();
                }