/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.ecs_admin_user GetModel(int user_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select user_id,user_name,real_name,email,password,ec_salt,add_time,last_login,last_ip,points,action_list,nav_list,lang_type,agency_id,suppliers_id,todolist,role_id,admin_market_area,user_tel,user_qq,nickname,status,is_lockable,higher,unix_timestamp from ecs_admin_user ");
strSql.Append(" where user_id=@user_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_id", MySqlDbType.Int32)
};
parameters[0].Value = user_id;
XHD.Model.ecs_admin_user model = new XHD.Model.ecs_admin_user();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XHD.Model.ecs_admin_user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ecs_admin_user(");
strSql.Append("user_name,real_name,email,password,ec_salt,add_time,last_login,last_ip,points,action_list,nav_list,lang_type,agency_id,suppliers_id,todolist,role_id,admin_market_area,user_tel,user_qq,nickname,status,is_lockable,higher,unix_timestamp)");
strSql.Append(" values (");
strSql.Append("@user_name,@real_name,@email,@password,@ec_salt,@add_time,@last_login,@last_ip,@points,@action_list,@nav_list,@lang_type,@agency_id,@suppliers_id,@todolist,@role_id,@admin_market_area,@user_tel,@user_qq,@nickname,@status,@is_lockable,@higher,@unix_timestamp)");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@real_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@email", MySqlDbType.VarChar, 60),
new MySqlParameter("@password", MySqlDbType.VarChar, 32),
new MySqlParameter("@ec_salt", MySqlDbType.VarChar, 10),
new MySqlParameter("@add_time", MySqlDbType.Int32, 11),
new MySqlParameter("@last_login", MySqlDbType.Int32, 11),
new MySqlParameter("@last_ip", MySqlDbType.VarChar, 15),
new MySqlParameter("@points", MySqlDbType.Int32, 11),
new MySqlParameter("@action_list", MySqlDbType.Text),
new MySqlParameter("@nav_list", MySqlDbType.Text),
new MySqlParameter("@lang_type", MySqlDbType.VarChar, 50),
new MySqlParameter("@agency_id", MySqlDbType.Int32, 5),
new MySqlParameter("@suppliers_id", MySqlDbType.Int32, 5),
new MySqlParameter("@todolist", MySqlDbType.LongText),
new MySqlParameter("@role_id", MySqlDbType.Int32, 5),
new MySqlParameter("@admin_market_area", MySqlDbType.VarChar, 60),
new MySqlParameter("@user_tel", MySqlDbType.VarChar, 30),
new MySqlParameter("@user_qq", MySqlDbType.VarChar, 20),
new MySqlParameter("@nickname", MySqlDbType.VarChar, 30),
new MySqlParameter("@status", MySqlDbType.Int32, 1),
new MySqlParameter("@is_lockable", MySqlDbType.Int32, 1),
new MySqlParameter("@higher", MySqlDbType.VarChar, 10),
new MySqlParameter("@unix_timestamp", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.user_name;
parameters[1].Value = model.real_name;
parameters[2].Value = model.email;
parameters[3].Value = model.password;
parameters[4].Value = model.ec_salt;
parameters[5].Value = model.add_time;
parameters[6].Value = model.last_login;
parameters[7].Value = model.last_ip;
parameters[8].Value = model.points;
parameters[9].Value = model.action_list;
parameters[10].Value = model.nav_list;
parameters[11].Value = model.lang_type;
parameters[12].Value = model.agency_id;
parameters[13].Value = model.suppliers_id;
parameters[14].Value = model.todolist;
parameters[15].Value = model.role_id;
parameters[16].Value = model.admin_market_area;
parameters[17].Value = model.user_tel;
parameters[18].Value = model.user_qq;
parameters[19].Value = model.nickname;
parameters[20].Value = model.status;
parameters[21].Value = model.is_lockable;
parameters[22].Value = model.higher;
parameters[23].Value = model.unix_timestamp;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.ecs_admin_user DataRowToModel(DataRow row)
{
XHD.Model.ecs_admin_user model = new XHD.Model.ecs_admin_user();
if (row != null)
{
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["user_name"] != null)
{
model.user_name = row["user_name"].ToString();
}
if (row["real_name"] != null)
{
model.real_name = row["real_name"].ToString();
}
if (row["email"] != null)
{
model.email = row["email"].ToString();
}
if (row["password"] != null)
{
model.password = row["password"].ToString();
}
if (row["ec_salt"] != null)
{
model.ec_salt = row["ec_salt"].ToString();
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = int.Parse(row["add_time"].ToString());
}
if (row["last_login"] != null && row["last_login"].ToString() != "")
{
model.last_login = int.Parse(row["last_login"].ToString());
}
if (row["last_ip"] != null)
{
model.last_ip = row["last_ip"].ToString();
}
if (row["points"] != null && row["points"].ToString() != "")
{
model.points = int.Parse(row["points"].ToString());
}
if (row["action_list"] != null)
{
model.action_list = row["action_list"].ToString();
}
if (row["nav_list"] != null)
{
model.nav_list = row["nav_list"].ToString();
}
if (row["lang_type"] != null)
{
model.lang_type = row["lang_type"].ToString();
}
if (row["agency_id"] != null && row["agency_id"].ToString() != "")
{
model.agency_id = int.Parse(row["agency_id"].ToString());
}
if (row["suppliers_id"] != null && row["suppliers_id"].ToString() != "")
{
model.suppliers_id = int.Parse(row["suppliers_id"].ToString());
}
if (row["todolist"] != null)
{
model.todolist = row["todolist"].ToString();
}
if (row["role_id"] != null && row["role_id"].ToString() != "")
{
model.role_id = int.Parse(row["role_id"].ToString());
}
if (row["admin_market_area"] != null)
{
model.admin_market_area = row["admin_market_area"].ToString();
}
if (row["user_tel"] != null)
{
model.user_tel = row["user_tel"].ToString();
}
if (row["user_qq"] != null)
{
model.user_qq = row["user_qq"].ToString();
}
if (row["nickname"] != null)
{
model.nickname = row["nickname"].ToString();
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
if (row["is_lockable"] != null && row["is_lockable"].ToString() != "")
{
model.is_lockable = int.Parse(row["is_lockable"].ToString());
}
if (row["higher"] != null)
{
model.higher = row["higher"].ToString();
}
if (row["unix_timestamp"] != null && row["unix_timestamp"].ToString() != "")
{
model.unix_timestamp = int.Parse(row["unix_timestamp"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XHD.Model.ecs_admin_user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ecs_admin_user set ");
strSql.Append("user_name=@user_name,");
strSql.Append("real_name=@real_name,");
strSql.Append("email=@email,");
strSql.Append("password=@password,");
strSql.Append("ec_salt=@ec_salt,");
strSql.Append("add_time=@add_time,");
strSql.Append("last_login=@last_login,");
strSql.Append("last_ip=@last_ip,");
strSql.Append("points=@points,");
strSql.Append("action_list=@action_list,");
strSql.Append("nav_list=@nav_list,");
strSql.Append("lang_type=@lang_type,");
strSql.Append("agency_id=@agency_id,");
strSql.Append("suppliers_id=@suppliers_id,");
strSql.Append("todolist=@todolist,");
strSql.Append("role_id=@role_id,");
strSql.Append("admin_market_area=@admin_market_area,");
strSql.Append("user_tel=@user_tel,");
strSql.Append("user_qq=@user_qq,");
strSql.Append("nickname=@nickname,");
strSql.Append("status=@status,");
strSql.Append("is_lockable=@is_lockable,");
strSql.Append("higher=@higher,");
strSql.Append("unix_timestamp=@unix_timestamp");
strSql.Append(" where user_id=@user_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@real_name", MySqlDbType.VarChar, 60),
new MySqlParameter("@email", MySqlDbType.VarChar, 60),
new MySqlParameter("@password", MySqlDbType.VarChar, 32),
new MySqlParameter("@ec_salt", MySqlDbType.VarChar, 10),
new MySqlParameter("@add_time", MySqlDbType.Int32, 11),
new MySqlParameter("@last_login", MySqlDbType.Int32, 11),
new MySqlParameter("@last_ip", MySqlDbType.VarChar, 15),
new MySqlParameter("@points", MySqlDbType.Int32, 11),
new MySqlParameter("@action_list", MySqlDbType.Text),
new MySqlParameter("@nav_list", MySqlDbType.Text),
new MySqlParameter("@lang_type", MySqlDbType.VarChar, 50),
new MySqlParameter("@agency_id", MySqlDbType.Int32, 5),
new MySqlParameter("@suppliers_id", MySqlDbType.Int32, 5),
new MySqlParameter("@todolist", MySqlDbType.LongText),
new MySqlParameter("@role_id", MySqlDbType.Int32, 5),
new MySqlParameter("@admin_market_area", MySqlDbType.VarChar, 60),
new MySqlParameter("@user_tel", MySqlDbType.VarChar, 30),
new MySqlParameter("@user_qq", MySqlDbType.VarChar, 20),
new MySqlParameter("@nickname", MySqlDbType.VarChar, 30),
new MySqlParameter("@status", MySqlDbType.Int32, 1),
new MySqlParameter("@is_lockable", MySqlDbType.Int32, 1),
new MySqlParameter("@higher", MySqlDbType.VarChar, 10),
new MySqlParameter("@unix_timestamp", MySqlDbType.Int32, 11),
new MySqlParameter("@user_id", MySqlDbType.Int32, 5)
};
parameters[0].Value = model.user_name;
parameters[1].Value = model.real_name;
parameters[2].Value = model.email;
parameters[3].Value = model.password;
parameters[4].Value = model.ec_salt;
parameters[5].Value = model.add_time;
parameters[6].Value = model.last_login;
parameters[7].Value = model.last_ip;
parameters[8].Value = model.points;
parameters[9].Value = model.action_list;
parameters[10].Value = model.nav_list;
parameters[11].Value = model.lang_type;
parameters[12].Value = model.agency_id;
parameters[13].Value = model.suppliers_id;
parameters[14].Value = model.todolist;
parameters[15].Value = model.role_id;
parameters[16].Value = model.admin_market_area;
parameters[17].Value = model.user_tel;
parameters[18].Value = model.user_qq;
parameters[19].Value = model.nickname;
parameters[20].Value = model.status;
parameters[21].Value = model.is_lockable;
parameters[22].Value = model.higher;
parameters[23].Value = model.unix_timestamp;
parameters[24].Value = model.user_id;
int rows = DbHelperMySQL.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);
}
}
