/// <summary>
/// 编辑顾客信息
/// </summary>
/// <param name="ui_Customer"></param>
public int EditCustomer(v3_userVModel ui_Customer)
{
StringBuilder strSql = new StringBuilder();
DataTable obj = new DataTable();
strSql.Clear();
strSql.Append("select count(*) as cnt from vp_userinfo where Ledger=@Ledger and Uid!=@Crm_id and UserNo=@CrmNo");
obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger, Crm_id = ui_Customer.Crm_id, CrmNo = ui_Customer.CrmNo });
if (CommFunc.ConvertDBNullToInt32(obj.Rows[0]["cnt"]) > 0)
{
throw new Exception("证件号有重复");
}
ui_Customer.Passwd = "123456";
if (ui_Customer.Crm_id == 0)
{
obj = null;
strSql.Clear();
strSql.Append("select max(Uid) as id from sys_user where Ledger=@Ledger");
obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger });
ui_Customer.Crm_id = obj.Rows.Count > 0 ? CommFunc.ConvertDBNullToInt32(obj.Rows[0]["id"]) + 1 : 1;
}
strSql.Clear();
strSql.Append("insert into sys_user(Ledger,Uid,USign,UPasswd,UName,Role_id,Disabled,UserType,Create_by,Create_dt,Update_by,Update_dt)values");
strSql.Append("(@Ledger,@Crm_id,@MPhone,GetENCODE(@Passwd,@EncryptPwd),@CrmName,0,0,100,@SysUid,now(),@SysUid,now())");
strSql.Append(" ON DUPLICATE KEY UPDATE ");
strSql.Append("UName=@CrmName,");
strSql.Append("Update_by=@SysUid,");
strSql.Append("Update_dt=now();");
strSql.Append("insert into sys_userinfo(Ledger,Uid,UserNo,Sex,TelNo,Phone,Email,Status,Period,Create_by,Create_dt,Update_by,Update_dt,Remark,Contract)values");
strSql.Append("(@Ledger,@Crm_id,@CrmNo,0,@MPhone,@Phone,@Email,0,'',@SysUid,now(),@SysUid,now(),@Remark,@Contract)");
strSql.Append(" ON DUPLICATE KEY UPDATE ");
strSql.Append("UserNo=@CrmNo,");
strSql.Append("TelNo=@MPhone,");
strSql.Append("Phone=@Phone,");
strSql.Append("Email=@Email,");
strSql.Append("Remark=@Remark,");
strSql.Append("Contract=@Contract,");
strSql.Append("Update_by=@SysUid,");
strSql.Append("Update_dt=now();");
//strSql.Clear();
//strSql.Append(" INSERT INTO v3_user(Ledger ,Crm_id ,CrmNo ,CrmName ,MPhone ,IsAdmin,Email ,Phone ,Remark ,Passwd ,Create_by ,Create_dt ,Update_by , Update_dt , Contract )");
//strSql.Append(" VALUES (@Ledger,@Crm_id,@CrmNo,@CrmName,@MPhone,@IsAdmin,@Email,@Phone,@Remark,GetENCODE(@Passwd,@EncryptPwd),@SysUid,now(),@SysUid,now(),@Contract)");
//strSql.Append(" ON DUPLICATE KEY UPDATE ");
//strSql.Append("CrmNo=@CrmNo,");
//strSql.Append("CrmName=@CrmName,");
//strSql.Append("Phone=@Phone,");
//strSql.Append("Mphone=@Mphone,");
//strSql.Append("Email=@Email,");
//strSql.Append("IsAdmin=@IsAdmin,");
//strSql.Append("Remark=@Remark,");
//strSql.Append("Update_by=@SysUid,");
//strSql.Append("Update_dt=now(),");
//strSql.Append("Contract=@Contract");
return(SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Crm_id = ui_Customer.Crm_id, CrmNo = ui_Customer.CrmNo, CrmName = ui_Customer.CrmName, MPhone = ui_Customer.MPhone, IsAdmin = ui_Customer.IsAdmin, Email = ui_Customer.Email, Phone = ui_Customer.Phone, Remark = ui_Customer.Remark, Passwd = ui_Customer.Passwd, EncryptPwd = EncryptPwd, SysUid = this.SysUid, Contract = ui_Customer.Contract }));
}
/// <summary>
/// 设置客户信息
/// </summary>
/// <param name="nAct">nAct：新增=1,修改=2,删除=3</param>
/// <param name="model"></param>
/// <returns></returns>
public APIRst SetCustomer(int nAct, v3_userVModel model)
{
APIRst rst = new APIRst();
try
{
if (nAct != 1 && nAct != 2 && nAct != 3)
{
throw new Exception("执行操作类型错误");
}
if (nAct != 3 && Convert.IsDBNull(model.CrmNo))
{
throw new Exception("请输入证件号");
}
if (nAct == 1 && bll.IsExistSameCrmNo(model.CrmNo))
{
throw new Exception("证件号" + model.CrmNo + "重复");
}
if (nAct != 3 && string.IsNullOrEmpty(model.CrmName))
{
throw new Exception("请输入姓名");
}
if (nAct != 1 && model.Crm_id == 0)
{
throw new Exception("获取数据错误");
}
if (nAct == 3)
{
bll.DelCustomer(model.Crm_id);//删除
}
else
{
bll.EditCustomer(model, nAct);
}
DataTable dtSource = bll.GetCustomerList(model.Crm_id);
object data = this.GetTableToList(dtSource, 0, 0);
object obj = new { total = dtSource.Rows.Count, data = data };
rst.data = obj;
}
catch (Exception ex)
{
rst.rst = false;
rst.err.code = (int)ResultCodeDefine.Error;
rst.err.msg = ex.Message;
FileLog.WriteLog("设置客户信息错误:" + ex.Message + ex.StackTrace);
}
return(rst);
}
public APIRst SetCustomer(int nAct, v3_userVModel model)
{
return(infoHelper.SetCustomer(nAct, model));
}
public void EditCustomer(v3_userVModel model, int nAct)
{
dal.EditCustomer(model);
}
