/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="usercid">所属部门</param>
/// <param name="department">所属部门</param>
/// <param name="name">真实姓名</param>
/// <param name="phone">联系电话</param>
/// <param name="weixin">微信号</param>
/// <returns>返回类</returns>
public SpRequestMsg UpdateUser(string department, string name, string phone, string weixin, string usercid)
{
//TODO
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
ISPService service = SpServiceFactory.CreateServiceBase();
try
{
string Uname = "UPDATE p_user SET xm = '" + name + "' WHERE cid = " + usercid + "";
string Uphone = "UPDATE p_user SET dh = " + phone + " WHERE cid = " + usercid + "";
string Uweixin = "UPDATE p_user SET wx = " + weixin + " WHERE cid = " + usercid + "";
ApplicationManager.DefaultConnection.ExcuteData(Uname);
ApplicationManager.DefaultConnection.ExcuteData(Uphone);
ApplicationManager.DefaultConnection.ExcuteData(Uweixin);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "信息修改成功！";
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "信息修改请求异常,详情" + ex.Message;
}
return(pSpRequestMsg);
}
/// <summary>
/// 密码修改
/// </summary>
/// <param name="cid">用户唯一编号</param>
/// <param name="userName">用户名</param>
/// <param name="oldPassword">旧密码</param>
/// <param name="newPassword">新密码</param>
/// <param name="rePassword">重复密码</param>
/// <returns></returns>
public SpRequestMsg UpdatePassword(string cid, string userName, string oldPassword, string newPassword, string rePassword)
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
ISPService service = SpServiceFactory.CreateServiceBase();
try {
string oldPwd = Sp.BaseFrame.Common.Util.AESEncryptionUtils.Encrypt(oldPassword);
MySqlParameter[] parameters = { new MySqlParameter("?mm", oldPwd) };
//判断是否存在
DataTable dtExist = ApplicationManager.DefaultConnection.QueryData("select mm from p_user where mm=?mm", parameters, 0).Tables[0];
if (dtExist.Rows.Count > 0)
{
pSpRequestMsg.success = true;
pSpRequestMsg.message = "密码匹配正确!";
if (newPassword != rePassword)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "前后密码输入不一致!";
}
else
{
string NewPwd = Sp.BaseFrame.Common.Util.AESEncryptionUtils.Encrypt(newPassword);//加密新添加密码
string updata = "UPDATE p_user SET mm = '" + NewPwd + "' WHERE cid = " + cid + " ";
ApplicationManager.DefaultConnection.ExcuteData(updata);
pSpRequestMsg.message = "密码修改成功！";
}
}
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "密码修改请求异常,详情" + ex.Message;
}
return(pSpRequestMsg);
}