DAL/TCWL_D_Contact.cs

（开头部分） 20KB

这里只显示每个文件的开头 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_Contact
    {
        public bool Add(TCWL_M_Contact model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_KHLianXiRen(");
            builder.Append("LianXiRenBianHao,LianXiRenMingCheng,YingWenMingCheng,ZhuangTai,XingBie,ZhiWei,JueCeDengJi,HunFou,DianHuaLeiXing,DianHuaHaoMa,ChuShengRiQi,ChuanZhen,QQ,MSN,YouXiang,AiHao,BeiZhu,KeHuBianHao,GongSiID,ServiceID)");
            builder.Append(" values (");
            builder.Append("@LianXiRenBianHao,@LianXiRenMingCheng,@YingWenMingCheng,@ZhuangTai,@XingBie,@ZhiWei,@JueCeDengJi,@HunFou,@DianHuaLeiXing,@DianHuaHaoMa,@ChuShengRiQi,@ChuanZhen,@QQ,@MSN,@YouXiang,@AiHao,@BeiZhu,@KeHuBianHao,@GongSiID,@ServiceID)");
            SqlParameter[] cmdParms = new SqlParameter[] { 
                new SqlParameter("@LianXiRenBianHao", SqlDbType.NVarChar, 50), new SqlParameter("@LianXiRenMingCheng", SqlDbType.NVarChar, 50), new SqlParameter("@YingWenMingCheng", SqlDbType.NVarChar, 50), new SqlParameter("@ZhuangTai", SqlDbType.NVarChar, 50), new SqlParameter("@XingBie", SqlDbType.NVarChar, 50), new SqlParameter("@ZhiWei", SqlDbType.NVarChar, 50), new SqlParameter("@JueCeDengJi", SqlDbType.NVarChar, 50), new SqlParameter("@HunFou", SqlDbType.NVarChar, 50), new SqlParameter("@DianHuaLeiXing", SqlDbType.NVarChar, 50), new SqlParameter("@DianHuaHaoMa", SqlDbType.NVarChar, 50), new SqlParameter("@ChuShengRiQi", SqlDbType.DateTime), new SqlParameter("@ChuanZhen", SqlDbType.NVarChar, 50), new SqlParameter("@QQ", SqlDbType.NVarChar, 50), new SqlParameter("@MSN", SqlDbType.NVarChar, 50), new SqlParameter("@YouXiang", SqlDbType.NVarChar, 50), new SqlParameter("@AiHao", 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.LianXiRenBianHao;
            cmdParms[1].Value = model.LianXiRenMingCheng;
            cmdParms[2].Value = model.YingWenMingCheng;
            cmdParms[3].Value = model.ZhuangTai;
            cmdParms[4].Value = model.XingBie;
            cmdParms[5].Value = model.ZhiWei;
            cmdParms[6].Value = model.JueCeDengJi;
            cmdParms[7].Value = model.HunFou;
            cmdParms[8].Value = model.DianHuaLeiXing;
            cmdParms[9].Value = model.DianHuaHaoMa;
            cmdParms[10].Value = model.ChuShengRiQi;
            cmdParms[11].Value = model.ChuanZhen;
            cmdParms[12].Value = model.QQ;
            cmdParms[13].Value = model.MSN;
            cmdParms[14].Value = model.YouXiang;
            cmdParms[15].Value = model.AiHao;
            cmdParms[0x10].Value = model.BeiZhu;
            cmdParms[0x11].Value = model.KeHuBianHao;
            cmdParms[0x12].Value = model.GongSiID;
            cmdParms[0x13].Value = model.ServiceID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public TCWL_M_Contact DataRowToModel(DataRow row)
        {
            TCWL_M_Contact contact = new TCWL_M_Contact();
            if (row != null)
            {
                if (row["ID"] != null)
                {
                    contact.ID = row["ID"].ToString();
                }
                if (row["LianXiRenBianHao"] != null)
                {
                    contact.LianXiRenBianHao = row["LianXiRenBianHao"].ToString();
                }
                if (row["LianXiRenMingCheng"] != null)
后面还有 323 行代码，购买后查看完整代码

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

AI 解读 AI

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

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