/// <summary>
/// 增加一条数据
/// </summary>
public bool Insert(XHD.Model.crm_customer_handnum modelhandnum, XHD.Model.CRM_Customer model)
{
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
string strWhere = string.Empty;
//1.更新crm_customer_handnum：更新上一条记录的结束时间
strSql = string.Format(@"update crm_customer_handnum set End_date='{0}' where id= (select max( bb1.id ) as a1 from (select id,Factory_Id,customer_id from crm_customer_handnum) as bb1 where bb1.customer_id='{1}') ",
modelhandnum.Start_date, modelhandnum.customer_id);
strSqlList.Add(strSql);
//2.crm_customer_handnum：保存新的更新记录
strSql = string.Format(@" INSERT INTO crm_customer_handnum(Factory_Id,customer_id,customer,BeSeats_id_old,BeSeats_old,BeSeats_uid_old,BeSeats_depid_old,BeSeats_depname_old,
emp_id,emp_uid,emp_name,Start_date,End_date,operation_emp_id,operation_emp_uid,operation_emp_name)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}','{11}','{12}','{13}','{14}','{15}')",
modelhandnum.Factory_Id, modelhandnum.customer_id, modelhandnum.customer, modelhandnum.BeSeats_id_old, modelhandnum.BeSeats_old,
modelhandnum.BeSeats_uid_old, modelhandnum.BeSeats_depid_old, modelhandnum.BeSeats_depname_old, modelhandnum.emp_id, modelhandnum.emp_uid,
modelhandnum.emp_name, modelhandnum.Start_date, modelhandnum.Start_date, modelhandnum.operation_emp_id, modelhandnum.operation_emp_uid, modelhandnum.operation_emp_name);
strSqlList.Add(strSql);
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows >= 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量转客户
/// </summary>
public bool Update_batch(XHD.Model.CRM_Customer model, string strWhere)
{
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");
if (strWhere.Trim() != "")
{
strSql.Append(" and " + strWhere);
}
MySqlParameter[] parameters =
{
new MySqlParameter("@Department_id", MySqlDbType.Int32, 4),
new MySqlParameter("@Department", MySqlDbType.VarChar, 250),
new MySqlParameter("@Employee_id", MySqlDbType.Int32, 4),
new MySqlParameter("@Employee", MySqlDbType.VarChar, 250),
new MySqlParameter("@Create_id", MySqlDbType.Int32, 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 = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XHD.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)");
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)");
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)
};
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;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.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;
XHD.Model.CRM_Customer model = new XHD.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(XHD.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("lastfollow=@lastfollow,");
strSql.Append("Create_id=@Create_id,");
strSql.Append("Create_name=@Create_name,");
strSql.Append("Create_date=@Create_date,");
strSql.Append("isDelete=@isDelete,");
strSql.Append("Delete_time=@Delete_time");
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("@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("@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.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Adds(XHD.Model.crm_customer_handnum modelhandnum, XHD.Model.CRM_Customer model, XHD.Model.ecs_admin_user adminModel, string c_tel)
{
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
string strWhere = string.Empty;
//1.更改客户表的信息
strSql = string.Format(@"update CRM_Customer set BeSeats_id='{0}',BeSeats_uid='{1}',BeSeats='{2}',BeSeats_depid='{3}',BeSeats_depname='{4}',emp_handnum='{5}' where id='{6}'",
model.BeSeats_id, model.BeSeats_uid, model.BeSeats, model.BeSeats_depid, model.BeSeats_depname, model.emp_handnum, model.id);
strSqlList.Add(strSql);
//2.更新crm_customer_handnum：更新上一条记录的结束时间
strSql = string.Format(@"update crm_customer_handnum set End_date='{0}' where id= (select max( bb1.id ) as a1 from (select id,Factory_Id,customer_id from crm_customer_handnum) as bb1 where bb1.customer_id='{1}') ",
modelhandnum.Start_date, modelhandnum.customer_id);
strSqlList.Add(strSql);
//3.crm_customer_handnum：保存新的更新记录
strSql = string.Format(@" INSERT INTO crm_customer_handnum(Factory_Id,customer_id,customer,BeSeats_id_old,BeSeats_old,BeSeats_uid_old,BeSeats_depid_old,BeSeats_depname_old,
emp_id,emp_uid,emp_name,Start_date,End_date,operation_emp_id,operation_emp_uid,operation_emp_name)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}','{11}','{12}','{13}','{14}','{15}')",
modelhandnum.Factory_Id, modelhandnum.customer_id, modelhandnum.customer, modelhandnum.BeSeats_id_old, modelhandnum.BeSeats_old,
modelhandnum.BeSeats_uid_old, modelhandnum.BeSeats_depid_old, modelhandnum.BeSeats_depname_old, modelhandnum.emp_id, modelhandnum.emp_uid,
modelhandnum.emp_name, modelhandnum.Start_date, modelhandnum.Start_date, modelhandnum.operation_emp_id, modelhandnum.operation_emp_uid, modelhandnum.operation_emp_name);
strSqlList.Add(strSql);
//4.更新商城上的客户与客服对应关系
if (!string.IsNullOrEmpty(c_tel))
{
//1.查询商城上是否存在该客户
if (model.Factory_Id == "1000")
{
strWhere = " and dealer_id=0";
}
else if (model.Factory_Id == "1005")
{
strWhere = " and dealer_id=4";
}
DataSet ds = _ecsuser.GetListId(" user_name in (" + c_tel.Trim() + ") " + strWhere + "");
//2.更改商城上对客户的座席
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int userId = Convert.ToInt32(ds.Tables[0].Rows[i]["user_id"]);
strSql = string.Format(@" update ecs_users set user_market_area='{0}', admin_user_name='{1}',admin_user_id='{2}',admin_u_real_name='{3}' where user_id = '{4}'",
adminModel.admin_market_area, adminModel.user_name, adminModel.user_id, adminModel.real_name, userId);
strSqlList.Add(strSql);
}
}
}
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows >= 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public XHD.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,isRead,isTop from CRM_Customer ");
strSql.Append("select top 1 * from CRM_Customer ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
XHD.Model.CRM_Customer model = new XHD.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());
}
if (ds.Tables[0].Rows[0]["isRead"] != null && ds.Tables[0].Rows[0]["isRead"].ToString() != "")
{
model.isRead = int.Parse(ds.Tables[0].Rows[0]["isRead"].ToString());
}
if (ds.Tables[0].Rows[0]["isImport"] != null && ds.Tables[0].Rows[0]["isImport"].ToString() != "")
{
model.isImport = int.Parse(ds.Tables[0].Rows[0]["isImport"].ToString());
}
if (ds.Tables[0].Rows[0]["Follow_up_dep_id"] != null && ds.Tables[0].Rows[0]["Follow_up_dep_id"].ToString() != "")
{
model.Follow_up_dep_id = int.Parse(ds.Tables[0].Rows[0]["Follow_up_dep_id"].ToString());
}
if (ds.Tables[0].Rows[0]["Follow_up_dep"] != null && ds.Tables[0].Rows[0]["Follow_up_dep"].ToString() != "")
{
model.Follow_up_dep = ds.Tables[0].Rows[0]["Follow_up_dep"].ToString();
}
if (ds.Tables[0].Rows[0]["Follow_up_id"] != null && ds.Tables[0].Rows[0]["Follow_up_id"].ToString() != "")
{
model.Follow_up_id = int.Parse(ds.Tables[0].Rows[0]["Follow_up_id"].ToString());
}
if (ds.Tables[0].Rows[0]["Follow_up"] != null && ds.Tables[0].Rows[0]["Follow_up"].ToString() != "")
{
model.Follow_up = ds.Tables[0].Rows[0]["Follow_up"].ToString();
}
if (ds.Tables[0].Rows[0]["To_follow_id"] != null && ds.Tables[0].Rows[0]["To_follow_id"].ToString() != "")
{
model.To_follow_id = int.Parse(ds.Tables[0].Rows[0]["To_follow_id"].ToString());
}
if (ds.Tables[0].Rows[0]["To_follow"] != null && ds.Tables[0].Rows[0]["To_follow"].ToString() != "")
{
model.To_follow = ds.Tables[0].Rows[0]["To_follow"].ToString();
}
if (ds.Tables[0].Rows[0]["isTop"] != null && ds.Tables[0].Rows[0]["isTop"].ToString() != "")
{
model.isTop = int.Parse(ds.Tables[0].Rows[0]["isTop"].ToString());
}
return model;
}
else
{
return null;
}
}
