public JsonResult UpdateUserInfo(JMP.MDL.CoBusinessPersonnel develop)
{
object result = new { success = 0, msg = "修改失败！" };
int u_id = string.IsNullOrEmpty(Request["u_id"]) ? 0 : int.Parse(Request["u_id"]);
string o_pwd = !string.IsNullOrEmpty(Request["upass"]) ? Request["upass"] : "";
string n_pwd = !string.IsNullOrEmpty(Request["xpass"]) ? Request["xpass"] : "";
var j_user = _coAgentService.FindById(UserInfo.UserId);
//判断是否修改了密码
if (!string.IsNullOrEmpty(o_pwd))
{
string temp = DESEncrypt.Encrypt(o_pwd);
if (temp == j_user.Password)
{
string u_password = DESEncrypt.Encrypt(n_pwd);
bool flag = _coAgentService.UpdatePwd(j_user.Id, u_password);
result = new { success = 1, msg = "修改成功！" };
}
else
{
result = new { success = 2, msg = "原密码输入错误！" };
}
}
return(Json(result));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.CoBusinessPersonnel GetModel(string userName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" from CoBusinessPersonnel ");
strSql.Append(" where LoginName=@LoginName");
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.NVarChar, -1)
};
parameters[0].Value = userName;
JMP.MDL.CoBusinessPersonnel model = new JMP.MDL.CoBusinessPersonnel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["CreatedById"].ToString() != "")
{
model.CreatedById = int.Parse(ds.Tables[0].Rows[0]["CreatedById"].ToString());
}
model.CreatedByName = ds.Tables[0].Rows[0]["CreatedByName"].ToString();
if (ds.Tables[0].Rows[0]["LoginCount"].ToString() != "")
{
model.LoginCount = int.Parse(ds.Tables[0].Rows[0]["LoginCount"].ToString());
}
if (ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
}
if (ds.Tables[0].Rows[0]["RoleId"].ToString() != "")
{
model.RoleId = int.Parse(ds.Tables[0].Rows[0]["RoleId"].ToString());
}
model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
model.DisplayName = ds.Tables[0].Rows[0]["DisplayName"].ToString();
model.EmailAddress = ds.Tables[0].Rows[0]["EmailAddress"].ToString();
model.MobilePhone = ds.Tables[0].Rows[0]["MobilePhone"].ToString();
model.QQ = ds.Tables[0].Rows[0]["QQ"].ToString();
model.Website = ds.Tables[0].Rows[0]["Website"].ToString();
if (ds.Tables[0].Rows[0]["CreatedOn"].ToString() != "")
{
model.CreatedOn = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedOn"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 随机获取一个当天登录过的商务姓名
/// </summary>
/// <returns></returns>
public JMP.MDL.CoBusinessPersonnel getModelLoginTime()
{
string sql = string.Format("select top 1 DisplayName from [dbo].[CoBusinessPersonnel] where CONVERT(varchar(10),LogintTime,110)=CONVERT(varchar(10),GETDATE(),110) order by newid()");
JMP.MDL.CoBusinessPersonnel model = new JMP.MDL.CoBusinessPersonnel();
DataSet ds = DbHelperSQL.Query(sql);
return(DbHelperSQL.ToModel <JMP.MDL.CoBusinessPersonnel>(ds.Tables[0]));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.CoBusinessPersonnel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CoBusinessPersonnel(");
strSql.Append("CreatedById,CreatedByName,LoginCount,State,RoleId,LoginName,Password,DisplayName,EmailAddress,MobilePhone,QQ,Website,CreatedOn");
strSql.Append(") values (");
strSql.Append("@CreatedById,@CreatedByName,@LoginCount,@State,@RoleId,@LoginName,@Password,@DisplayName,@EmailAddress,@MobilePhone,@QQ,@Website,@CreatedOn");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreatedById", SqlDbType.Int, 4),
new SqlParameter("@CreatedByName", SqlDbType.NVarChar, 50),
new SqlParameter("@LoginCount", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@RoleId", SqlDbType.Int, 4),
new SqlParameter("@LoginName", SqlDbType.NVarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 255),
new SqlParameter("@DisplayName", SqlDbType.NVarChar, 50),
new SqlParameter("@EmailAddress", SqlDbType.NVarChar, 255),
new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 20),
new SqlParameter("@QQ", SqlDbType.NVarChar, 15),
new SqlParameter("@Website", SqlDbType.NVarChar, 255),
new SqlParameter("@CreatedOn", SqlDbType.DateTime)
};
parameters[0].Value = model.CreatedById;
parameters[1].Value = model.CreatedByName;
parameters[2].Value = model.LoginCount;
parameters[3].Value = model.State;
parameters[4].Value = model.RoleId;
parameters[5].Value = model.LoginName;
parameters[6].Value = model.Password;
parameters[7].Value = model.DisplayName;
parameters[8].Value = model.EmailAddress;
parameters[9].Value = model.MobilePhone;
parameters[10].Value = model.QQ;
parameters[11].Value = model.Website;
parameters[12].Value = model.CreatedOn;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加修改商务信息
/// </summary>
/// <returns></returns>
public ActionResult BusinessPersonnelAdd()
{
GetListRote();
int id = string.IsNullOrEmpty(Request["id"]) ? 0 : int.Parse(Request["id"]);
if (id > 0)
{
co_model = bll_co.GetModel(id);
}
ViewBag.co_model = co_model;
return(View());
}
public ActionResult AppUserEdit()
{
int userId = !string.IsNullOrEmpty(Request["uid"]) ? int.Parse(Request["uid"]) : 0;
JMP.BLL.jmp_user bll = new JMP.BLL.jmp_user();
JMP.MDL.jmp_user model = bll.GetModel(userId);
ViewBag.UserData = model;
ViewBag.UploadUrl = ConfigurationManager.AppSettings["imgurl"];
string DisplayName = "";
//
switch (model.relation_type)
{
case 1:
co_model = bll_co.GetModel(model.relation_person_id);
if (co_model != null)
{
DisplayName = co_model.DisplayName;
}
break;
case 2:
modelAgent = bllAgent.GetModel(model.relation_person_id);
if (modelAgent != null)
{
DisplayName = modelAgent.DisplayName;
}
break;
}
ViewBag.DisplayName = DisplayName;
return(View());
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.CoBusinessPersonnel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CoBusinessPersonnel set ");
strSql.Append(" CreatedById = @CreatedById , ");
strSql.Append(" CreatedByName = @CreatedByName , ");
strSql.Append(" LoginCount = @LoginCount , ");
strSql.Append(" State = @State , ");
strSql.Append(" RoleId = @RoleId , ");
strSql.Append(" LoginName = @LoginName , ");
strSql.Append(" Password = @Password , ");
strSql.Append(" DisplayName = @DisplayName , ");
strSql.Append(" EmailAddress = @EmailAddress , ");
strSql.Append(" MobilePhone = @MobilePhone , ");
strSql.Append(" QQ = @QQ , ");
strSql.Append(" Website = @Website , ");
strSql.Append(" CreatedOn = @CreatedOn, ");
strSql.Append(" LogintTime=@LogintTime");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@CreatedById", SqlDbType.Int, 4),
new SqlParameter("@CreatedByName", SqlDbType.NVarChar, 50),
new SqlParameter("@LoginCount", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@RoleId", SqlDbType.Int, 4),
new SqlParameter("@LoginName", SqlDbType.NVarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 255),
new SqlParameter("@DisplayName", SqlDbType.NVarChar, 50),
new SqlParameter("@EmailAddress", SqlDbType.NVarChar, 255),
new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 20),
new SqlParameter("@QQ", SqlDbType.NVarChar, 15),
new SqlParameter("@Website", SqlDbType.NVarChar, 255),
new SqlParameter("@CreatedOn", SqlDbType.DateTime),
new SqlParameter("@LogintTime", SqlDbType.DateTime)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.CreatedById;
parameters[2].Value = model.CreatedByName;
parameters[3].Value = model.LoginCount;
parameters[4].Value = model.State;
parameters[5].Value = model.RoleId;
parameters[6].Value = model.LoginName;
parameters[7].Value = model.Password;
parameters[8].Value = model.DisplayName;
parameters[9].Value = model.EmailAddress;
parameters[10].Value = model.MobilePhone;
parameters[11].Value = model.QQ;
parameters[12].Value = model.Website;
parameters[13].Value = model.CreatedOn;
parameters[14].Value = model.LogintTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public JsonResult InsertOrUpdateBusinessPersonnel(JMP.MDL.CoBusinessPersonnel mode)
{
object retJson = new { success = 0, msg = "操作失败" };
string loname = Request["LoginName"];
string userName = Request["DisplayName"];
if (mode.Id > 0)
{
#region 修改商务
//修改前数据
co_model = bll_co.GetModel(mode.Id);
var modclone = co_model.Clone();
JMP.MDL.CoBusinessPersonnel co_mod = new JMP.MDL.CoBusinessPersonnel();
co_model.Password = DESEncrypt.Encrypt(mode.Password);
co_model.CreatedOn = DateTime.Now;
co_model.LoginName = mode.LoginName;
co_model.DisplayName = mode.DisplayName;
co_model.EmailAddress = mode.EmailAddress;
co_model.MobilePhone = mode.MobilePhone;
co_model.QQ = mode.QQ;
co_model.Website = mode.Website;
// mode.CreatedById = UserInfo.UserId;
// mode.CreatedByName = UserInfo.UserName;
// mode.LoginCount = co_model.LoginCount;
// mode.State = co_model.State;
// mode.LogintTime = co_model.LogintTime == null ? null : co_model.LogintTime;
if (bll_co.Update(co_model))
{
Logger.ModifyLog("修改商务信息", modclone, co_model);
retJson = new { success = 1, msg = "修改成功" };
}
else
{
retJson = new { success = 0, msg = "修改失败" };
}
#endregion
}
else
{
#region 添加商务
JMP.MDL.CoBusinessPersonnel co_mod = new JMP.MDL.CoBusinessPersonnel();
mode.Password = DESEncrypt.Encrypt(mode.Password);
mode.CreatedOn = DateTime.Now;
mode.CreatedById = UserInfo.UserId;
mode.CreatedByName = UserInfo.UserName;
mode.LoginCount = 0;
int roleId;
int.TryParse(ConfigReader.GetSettingValueByKey("RoleID"), out roleId);
mode.RoleId = roleId;
mode.State = 0;
int cg = bll_co.Add(mode);
if (cg > 0)
{
Logger.CreateLog("添加商务信息", mode);
retJson = new { success = 1, msg = "添加成功" };
}
else
{
retJson = new { success = 0, msg = "添加失败" };
}
#endregion
}
return(Json(retJson));
}
