/// <summary> /// 批量转客户 /// </summary> public bool Update_batch(Garfield.Model.CRM_Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CRM_Customer set "); strSql.Append("Department_id=@Department_id,"); strSql.Append("Department=@Department,"); strSql.Append("Employee_id=@Employee_id,"); strSql.Append("Employee=@Employee"); strSql.Append(" where Employee_id=@Create_id"); SqlParameter[] parameters = { new SqlParameter("@Department_id", SqlDbType.Int, 4), new SqlParameter("@Department", SqlDbType.VarChar, 250), new SqlParameter("@Employee_id", SqlDbType.Int, 4), new SqlParameter("@Employee", SqlDbType.VarChar, 250), new SqlParameter("@Create_id", SqlDbType.Int, 4) }; parameters[0].Value = model.Department_id; parameters[1].Value = model.Department; parameters[2].Value = model.Employee_id; parameters[3].Value = model.Employee; parameters[4].Value = model.Create_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Garfield.Model.CRM_Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CRM_Customer("); strSql.Append("Serialnumber,Customer,address,tel,fax,site,industry,Provinces_id,Provinces,City_id,City,CustomerType_id,CustomerType,CustomerLevel_id,CustomerLevel,CustomerSource_id,CustomerSource,DesCripe,Remarks,Department_id,Department,Employee_id,Employee,privatecustomer,lastfollow,Create_id,Create_name,Create_date,isDelete,Delete_time,industry_id)"); strSql.Append(" values ("); strSql.Append("@Serialnumber,@Customer,@address,@tel,@fax,@site,@industry,@Provinces_id,@Provinces,@City_id,@City,@CustomerType_id,@CustomerType,@CustomerLevel_id,@CustomerLevel,@CustomerSource_id,@CustomerSource,@DesCripe,@Remarks,@Department_id,@Department,@Employee_id,@Employee,@privatecustomer,@lastfollow,@Create_id,@Create_name,@Create_date,@isDelete,@Delete_time,@industry_id)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Serialnumber", SqlDbType.VarChar, 250), new SqlParameter("@Customer", SqlDbType.VarChar, 250), new SqlParameter("@address", SqlDbType.VarChar, 250), new SqlParameter("@tel", SqlDbType.VarChar, 250), new SqlParameter("@fax", SqlDbType.VarChar, 250), new SqlParameter("@site", SqlDbType.VarChar, 250), new SqlParameter("@industry", SqlDbType.VarChar, 250), new SqlParameter("@Provinces_id", SqlDbType.Int, 4), new SqlParameter("@Provinces", SqlDbType.VarChar, 250), new SqlParameter("@City_id", SqlDbType.Int, 4), new SqlParameter("@City", SqlDbType.VarChar, 250), new SqlParameter("@CustomerType_id", SqlDbType.Int, 4), new SqlParameter("@CustomerType", SqlDbType.VarChar, 250), new SqlParameter("@CustomerLevel_id", SqlDbType.Int, 4), new SqlParameter("@CustomerLevel", SqlDbType.VarChar, 250), new SqlParameter("@CustomerSource_id", SqlDbType.Int, 4), new SqlParameter("@CustomerSource", SqlDbType.VarChar, 250), new SqlParameter("@DesCripe", SqlDbType.VarChar, 4000), new SqlParameter("@Remarks", SqlDbType.VarChar, 4000), new SqlParameter("@Department_id", SqlDbType.Int, 4), new SqlParameter("@Department", SqlDbType.VarChar, 250), new SqlParameter("@Employee_id", SqlDbType.Int, 4), new SqlParameter("@Employee", SqlDbType.VarChar, 250), new SqlParameter("@privatecustomer", SqlDbType.VarChar, 50), new SqlParameter("@lastfollow", SqlDbType.DateTime), new SqlParameter("@Create_id", SqlDbType.Int, 4), new SqlParameter("@Create_name", SqlDbType.VarChar, 250), new SqlParameter("@Create_date", SqlDbType.DateTime), new SqlParameter("@isDelete", SqlDbType.Int, 4), new SqlParameter("@Delete_time", SqlDbType.DateTime), new SqlParameter("@industry_id", SqlDbType.Int, 4) }; parameters[0].Value = model.Serialnumber; parameters[1].Value = model.Customer; parameters[2].Value = model.address; parameters[3].Value = model.tel; parameters[4].Value = model.fax; parameters[5].Value = model.site; parameters[6].Value = model.industry; parameters[7].Value = model.Provinces_id; parameters[8].Value = model.Provinces; parameters[9].Value = model.City_id; parameters[10].Value = model.City; parameters[11].Value = model.CustomerType_id; parameters[12].Value = model.CustomerType; parameters[13].Value = model.CustomerLevel_id; parameters[14].Value = model.CustomerLevel; parameters[15].Value = model.CustomerSource_id; parameters[16].Value = model.CustomerSource; parameters[17].Value = model.DesCripe; parameters[18].Value = model.Remarks; parameters[19].Value = model.Department_id; parameters[20].Value = model.Department; parameters[21].Value = model.Employee_id; parameters[22].Value = model.Employee; parameters[23].Value = model.privatecustomer; parameters[24].Value = model.lastfollow; parameters[25].Value = model.Create_id; parameters[26].Value = model.Create_name; parameters[27].Value = model.Create_date; parameters[28].Value = model.isDelete; parameters[29].Value = model.Delete_time; parameters[30].Value = model.industry_id; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Garfield.Model.CRM_Customer GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,Serialnumber,Customer,address,tel,fax,site,industry,Provinces_id,Provinces,City_id,City,CustomerType_id,CustomerType,CustomerLevel_id,CustomerLevel,CustomerSource_id,CustomerSource,DesCripe,Remarks,Department_id,Department,Employee_id,Employee,privatecustomer,lastfollow,Create_id,Create_name,Create_date,isDelete,Delete_time from CRM_Customer "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Garfield.Model.CRM_Customer model = new Garfield.Model.CRM_Customer(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["Serialnumber"] != null && ds.Tables[0].Rows[0]["Serialnumber"].ToString() != "") { model.Serialnumber = ds.Tables[0].Rows[0]["Serialnumber"].ToString(); } if (ds.Tables[0].Rows[0]["Customer"] != null && ds.Tables[0].Rows[0]["Customer"].ToString() != "") { model.Customer = ds.Tables[0].Rows[0]["Customer"].ToString(); } if (ds.Tables[0].Rows[0]["address"] != null && ds.Tables[0].Rows[0]["address"].ToString() != "") { model.address = ds.Tables[0].Rows[0]["address"].ToString(); } if (ds.Tables[0].Rows[0]["tel"] != null && ds.Tables[0].Rows[0]["tel"].ToString() != "") { model.tel = ds.Tables[0].Rows[0]["tel"].ToString(); } if (ds.Tables[0].Rows[0]["fax"] != null && ds.Tables[0].Rows[0]["fax"].ToString() != "") { model.fax = ds.Tables[0].Rows[0]["fax"].ToString(); } if (ds.Tables[0].Rows[0]["site"] != null && ds.Tables[0].Rows[0]["site"].ToString() != "") { model.site = ds.Tables[0].Rows[0]["site"].ToString(); } if (ds.Tables[0].Rows[0]["industry"] != null && ds.Tables[0].Rows[0]["industry"].ToString() != "") { model.industry = ds.Tables[0].Rows[0]["industry"].ToString(); } if (ds.Tables[0].Rows[0]["Provinces_id"] != null && ds.Tables[0].Rows[0]["Provinces_id"].ToString() != "") { model.Provinces_id = int.Parse(ds.Tables[0].Rows[0]["Provinces_id"].ToString()); } if (ds.Tables[0].Rows[0]["Provinces"] != null && ds.Tables[0].Rows[0]["Provinces"].ToString() != "") { model.Provinces = ds.Tables[0].Rows[0]["Provinces"].ToString(); } if (ds.Tables[0].Rows[0]["City_id"] != null && ds.Tables[0].Rows[0]["City_id"].ToString() != "") { model.City_id = int.Parse(ds.Tables[0].Rows[0]["City_id"].ToString()); } if (ds.Tables[0].Rows[0]["City"] != null && ds.Tables[0].Rows[0]["City"].ToString() != "") { model.City = ds.Tables[0].Rows[0]["City"].ToString(); } if (ds.Tables[0].Rows[0]["CustomerType_id"] != null && ds.Tables[0].Rows[0]["CustomerType_id"].ToString() != "") { model.CustomerType_id = int.Parse(ds.Tables[0].Rows[0]["CustomerType_id"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerType"] != null && ds.Tables[0].Rows[0]["CustomerType"].ToString() != "") { model.CustomerType = ds.Tables[0].Rows[0]["CustomerType"].ToString(); } if (ds.Tables[0].Rows[0]["CustomerLevel_id"] != null && ds.Tables[0].Rows[0]["CustomerLevel_id"].ToString() != "") { model.CustomerLevel_id = int.Parse(ds.Tables[0].Rows[0]["CustomerLevel_id"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerLevel"] != null && ds.Tables[0].Rows[0]["CustomerLevel"].ToString() != "") { model.CustomerLevel = ds.Tables[0].Rows[0]["CustomerLevel"].ToString(); } if (ds.Tables[0].Rows[0]["CustomerSource_id"] != null && ds.Tables[0].Rows[0]["CustomerSource_id"].ToString() != "") { model.CustomerSource_id = int.Parse(ds.Tables[0].Rows[0]["CustomerSource_id"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerSource"] != null && ds.Tables[0].Rows[0]["CustomerSource"].ToString() != "") { model.CustomerSource = ds.Tables[0].Rows[0]["CustomerSource"].ToString(); } if (ds.Tables[0].Rows[0]["DesCripe"] != null && ds.Tables[0].Rows[0]["DesCripe"].ToString() != "") { model.DesCripe = ds.Tables[0].Rows[0]["DesCripe"].ToString(); } if (ds.Tables[0].Rows[0]["Remarks"] != null && ds.Tables[0].Rows[0]["Remarks"].ToString() != "") { model.Remarks = ds.Tables[0].Rows[0]["Remarks"].ToString(); } if (ds.Tables[0].Rows[0]["Department_id"] != null && ds.Tables[0].Rows[0]["Department_id"].ToString() != "") { model.Department_id = int.Parse(ds.Tables[0].Rows[0]["Department_id"].ToString()); } if (ds.Tables[0].Rows[0]["Department"] != null && ds.Tables[0].Rows[0]["Department"].ToString() != "") { model.Department = ds.Tables[0].Rows[0]["Department"].ToString(); } if (ds.Tables[0].Rows[0]["Employee_id"] != null && ds.Tables[0].Rows[0]["Employee_id"].ToString() != "") { model.Employee_id = int.Parse(ds.Tables[0].Rows[0]["Employee_id"].ToString()); } if (ds.Tables[0].Rows[0]["Employee"] != null && ds.Tables[0].Rows[0]["Employee"].ToString() != "") { model.Employee = ds.Tables[0].Rows[0]["Employee"].ToString(); } if (ds.Tables[0].Rows[0]["privatecustomer"] != null && ds.Tables[0].Rows[0]["privatecustomer"].ToString() != "") { model.privatecustomer = ds.Tables[0].Rows[0]["privatecustomer"].ToString(); } if (ds.Tables[0].Rows[0]["lastfollow"] != null && ds.Tables[0].Rows[0]["lastfollow"].ToString() != "") { model.lastfollow = DateTime.Parse(ds.Tables[0].Rows[0]["lastfollow"].ToString()); } if (ds.Tables[0].Rows[0]["Create_id"] != null && ds.Tables[0].Rows[0]["Create_id"].ToString() != "") { model.Create_id = int.Parse(ds.Tables[0].Rows[0]["Create_id"].ToString()); } if (ds.Tables[0].Rows[0]["Create_name"] != null && ds.Tables[0].Rows[0]["Create_name"].ToString() != "") { model.Create_name = ds.Tables[0].Rows[0]["Create_name"].ToString(); } if (ds.Tables[0].Rows[0]["Create_date"] != null && ds.Tables[0].Rows[0]["Create_date"].ToString() != "") { model.Create_date = DateTime.Parse(ds.Tables[0].Rows[0]["Create_date"].ToString()); } if (ds.Tables[0].Rows[0]["isDelete"] != null && ds.Tables[0].Rows[0]["isDelete"].ToString() != "") { model.isDelete = int.Parse(ds.Tables[0].Rows[0]["isDelete"].ToString()); } if (ds.Tables[0].Rows[0]["Delete_time"] != null && ds.Tables[0].Rows[0]["Delete_time"].ToString() != "") { model.Delete_time = DateTime.Parse(ds.Tables[0].Rows[0]["Delete_time"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Garfield.Model.CRM_Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CRM_Customer set "); strSql.Append("Serialnumber=@Serialnumber,"); strSql.Append("Customer=@Customer,"); strSql.Append("address=@address,"); strSql.Append("tel=@tel,"); strSql.Append("fax=@fax,"); strSql.Append("site=@site,"); strSql.Append("industry=@industry,"); strSql.Append("Provinces_id=@Provinces_id,"); strSql.Append("Provinces=@Provinces,"); strSql.Append("City_id=@City_id,"); strSql.Append("City=@City,"); strSql.Append("CustomerType_id=@CustomerType_id,"); strSql.Append("CustomerType=@CustomerType,"); strSql.Append("CustomerLevel_id=@CustomerLevel_id,"); strSql.Append("CustomerLevel=@CustomerLevel,"); strSql.Append("CustomerSource_id=@CustomerSource_id,"); strSql.Append("CustomerSource=@CustomerSource,"); strSql.Append("DesCripe=@DesCripe,"); strSql.Append("Remarks=@Remarks,"); strSql.Append("Department_id=@Department_id,"); strSql.Append("Department=@Department,"); strSql.Append("Employee_id=@Employee_id,"); strSql.Append("Employee=@Employee,"); strSql.Append("privatecustomer=@privatecustomer,"); strSql.Append("industry_id=@industry_id"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@Serialnumber", SqlDbType.VarChar, 250), new SqlParameter("@Customer", SqlDbType.VarChar, 250), new SqlParameter("@address", SqlDbType.VarChar, 250), new SqlParameter("@tel", SqlDbType.VarChar, 250), new SqlParameter("@fax", SqlDbType.VarChar, 250), new SqlParameter("@site", SqlDbType.VarChar, 250), new SqlParameter("@industry", SqlDbType.VarChar, 250), new SqlParameter("@Provinces_id", SqlDbType.Int, 4), new SqlParameter("@Provinces", SqlDbType.VarChar, 250), new SqlParameter("@City_id", SqlDbType.Int, 4), new SqlParameter("@City", SqlDbType.VarChar, 250), new SqlParameter("@CustomerType_id", SqlDbType.Int, 4), new SqlParameter("@CustomerType", SqlDbType.VarChar, 250), new SqlParameter("@CustomerLevel_id", SqlDbType.Int, 4), new SqlParameter("@CustomerLevel", SqlDbType.VarChar, 250), new SqlParameter("@CustomerSource_id", SqlDbType.Int, 4), new SqlParameter("@CustomerSource", SqlDbType.VarChar, 250), new SqlParameter("@DesCripe", SqlDbType.VarChar, 4000), new SqlParameter("@Remarks", SqlDbType.VarChar, 4000), new SqlParameter("@Department_id", SqlDbType.Int, 4), new SqlParameter("@Department", SqlDbType.VarChar, 250), new SqlParameter("@Employee_id", SqlDbType.Int, 4), new SqlParameter("@Employee", SqlDbType.VarChar, 250), new SqlParameter("@privatecustomer", SqlDbType.VarChar, 50), new SqlParameter("@industry_id", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.Serialnumber; parameters[1].Value = model.Customer; parameters[2].Value = model.address; parameters[3].Value = model.tel; parameters[4].Value = model.fax; parameters[5].Value = model.site; parameters[6].Value = model.industry; parameters[7].Value = model.Provinces_id; parameters[8].Value = model.Provinces; parameters[9].Value = model.City_id; parameters[10].Value = model.City; parameters[11].Value = model.CustomerType_id; parameters[12].Value = model.CustomerType; parameters[13].Value = model.CustomerLevel_id; parameters[14].Value = model.CustomerLevel; parameters[15].Value = model.CustomerSource_id; parameters[16].Value = model.CustomerSource; parameters[17].Value = model.DesCripe; parameters[18].Value = model.Remarks; parameters[19].Value = model.Department_id; parameters[20].Value = model.Department; parameters[21].Value = model.Employee_id; parameters[22].Value = model.Employee; parameters[23].Value = model.privatecustomer; parameters[24].Value = model.industry_id; parameters[25].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }