예제 #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Leadin.Model.Customer model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into tb_Customer(");
            strSql.Append("NumId,CompanyName,SourceId,ParentId,NameInfo,Phone,Tel,Email,WeChat,QQNum,Addressinfo,Explain,StateInfo,Remark,AddTime)");
            strSql.Append(" values (");
            strSql.Append("@NumId,@CompanyName,@SourceId,@ParentId,@NameInfo,@Phone,@Tel,@Email,@WeChat,@QQNum,@Addressinfo,@Explain,@StateInfo,@Remark,@AddTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@NumId",       SqlDbType.NVarChar, 100),
                new SqlParameter("@CompanyName", SqlDbType.NVarChar, 200),
                new SqlParameter("@SourceId",    SqlDbType.Int,        4),
                new SqlParameter("@ParentId",    SqlDbType.Int,        4),
                new SqlParameter("@NameInfo",    SqlDbType.NVarChar, 200),
                new SqlParameter("@Phone",       SqlDbType.NVarChar, 100),
                new SqlParameter("@Tel",         SqlDbType.NVarChar, 100),
                new SqlParameter("@Email",       SqlDbType.NVarChar, 100),
                new SqlParameter("@WeChat",      SqlDbType.NVarChar, 100),
                new SqlParameter("@QQNum",       SqlDbType.NVarChar, 100),
                new SqlParameter("@Addressinfo", SqlDbType.NVarChar, 500),
                new SqlParameter("@Explain",     SqlDbType.NText),
                new SqlParameter("@StateInfo",   SqlDbType.Int,        4),
                new SqlParameter("@Remark",      SqlDbType.NText),
                new SqlParameter("@AddTime",     SqlDbType.DateTime)
            };
            parameters[0].Value  = model.NumId;
            parameters[1].Value  = model.CompanyName;
            parameters[2].Value  = model.SourceId;
            parameters[3].Value  = model.ParentId;
            parameters[4].Value  = model.NameInfo;
            parameters[5].Value  = model.Phone;
            parameters[6].Value  = model.Tel;
            parameters[7].Value  = model.Email;
            parameters[8].Value  = model.WeChat;
            parameters[9].Value  = model.QQNum;
            parameters[10].Value = model.Addressinfo;
            parameters[11].Value = model.Explain;
            parameters[12].Value = model.StateInfo;
            parameters[13].Value = model.Remark;
            parameters[14].Value = model.AddTime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
예제 #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Leadin.Model.Customer GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 Id,NumId,CompanyName,SourceId,ParentId,NameInfo,Phone,Tel,Email,WeChat,QQNum,Addressinfo,Explain,StateInfo,Remark,AddTime from tb_Customer ");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Id", SqlDbType.Int, 4)
            };
            parameters[0].Value = Id;

            Leadin.Model.Customer model = new Leadin.Model.Customer();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
예제 #3
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Leadin.Model.Customer DataRowToModel(DataRow row)
 {
     Leadin.Model.Customer model = new Leadin.Model.Customer();
     if (row != null)
     {
         if (row["Id"] != null && row["Id"].ToString() != "")
         {
             model.Id = int.Parse(row["Id"].ToString());
         }
         if (row["NumId"] != null)
         {
             model.NumId = row["NumId"].ToString();
         }
         if (row["CompanyName"] != null)
         {
             model.CompanyName = row["CompanyName"].ToString();
         }
         if (row["SourceId"] != null && row["SourceId"].ToString() != "")
         {
             model.SourceId = int.Parse(row["SourceId"].ToString());
         }
         if (row["ParentId"] != null && row["ParentId"].ToString() != "")
         {
             model.ParentId = int.Parse(row["ParentId"].ToString());
         }
         if (row["NameInfo"] != null)
         {
             model.NameInfo = row["NameInfo"].ToString();
         }
         if (row["Phone"] != null)
         {
             model.Phone = row["Phone"].ToString();
         }
         if (row["Tel"] != null)
         {
             model.Tel = row["Tel"].ToString();
         }
         if (row["Email"] != null)
         {
             model.Email = row["Email"].ToString();
         }
         if (row["WeChat"] != null)
         {
             model.WeChat = row["WeChat"].ToString();
         }
         if (row["QQNum"] != null)
         {
             model.QQNum = row["QQNum"].ToString();
         }
         if (row["Addressinfo"] != null)
         {
             model.Addressinfo = row["Addressinfo"].ToString();
         }
         if (row["Explain"] != null)
         {
             model.Explain = row["Explain"].ToString();
         }
         if (row["StateInfo"] != null && row["StateInfo"].ToString() != "")
         {
             model.StateInfo = int.Parse(row["StateInfo"].ToString());
         }
         if (row["Remark"] != null)
         {
             model.Remark = row["Remark"].ToString();
         }
         if (row["AddTime"] != null && row["AddTime"].ToString() != "")
         {
             model.AddTime = DateTime.Parse(row["AddTime"].ToString());
         }
     }
     return(model);
 }
예제 #4
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Leadin.Model.Customer model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update tb_Customer set ");
            strSql.Append("NumId=@NumId,");
            strSql.Append("CompanyName=@CompanyName,");
            strSql.Append("SourceId=@SourceId,");
            strSql.Append("ParentId=@ParentId,");
            strSql.Append("NameInfo=@NameInfo,");
            strSql.Append("Phone=@Phone,");
            strSql.Append("Tel=@Tel,");
            strSql.Append("Email=@Email,");
            strSql.Append("WeChat=@WeChat,");
            strSql.Append("QQNum=@QQNum,");
            strSql.Append("Addressinfo=@Addressinfo,");
            strSql.Append("Explain=@Explain,");
            strSql.Append("StateInfo=@StateInfo,");
            strSql.Append("Remark=@Remark,");
            strSql.Append("AddTime=@AddTime");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@NumId",       SqlDbType.NVarChar,  100),
                new SqlParameter("@CompanyName", SqlDbType.NVarChar,  200),
                new SqlParameter("@SourceId",    SqlDbType.Int,         4),
                new SqlParameter("@ParentId",    SqlDbType.Int,         4),
                new SqlParameter("@NameInfo",    SqlDbType.NVarChar,  200),
                new SqlParameter("@Phone",       SqlDbType.NVarChar,  100),
                new SqlParameter("@Tel",         SqlDbType.NVarChar,  100),
                new SqlParameter("@Email",       SqlDbType.NVarChar,  100),
                new SqlParameter("@WeChat",      SqlDbType.NVarChar,  100),
                new SqlParameter("@QQNum",       SqlDbType.NVarChar,  100),
                new SqlParameter("@Addressinfo", SqlDbType.NVarChar,  500),
                new SqlParameter("@Explain",     SqlDbType.NText),
                new SqlParameter("@StateInfo",   SqlDbType.Int,         4),
                new SqlParameter("@Remark",      SqlDbType.NText),
                new SqlParameter("@AddTime",     SqlDbType.DateTime),
                new SqlParameter("@Id",          SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.NumId;
            parameters[1].Value  = model.CompanyName;
            parameters[2].Value  = model.SourceId;
            parameters[3].Value  = model.ParentId;
            parameters[4].Value  = model.NameInfo;
            parameters[5].Value  = model.Phone;
            parameters[6].Value  = model.Tel;
            parameters[7].Value  = model.Email;
            parameters[8].Value  = model.WeChat;
            parameters[9].Value  = model.QQNum;
            parameters[10].Value = model.Addressinfo;
            parameters[11].Value = model.Explain;
            parameters[12].Value = model.StateInfo;
            parameters[13].Value = model.Remark;
            parameters[14].Value = model.AddTime;
            parameters[15].Value = model.Id;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }