/// <summary>
/// 增、改K_SysAccount表
/// </summary>
/// <param Name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param Name="paramsModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string tranType, KingTop.Model.SysManage.Account paramsModel)
{
string isOk = "";
try
{
SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.Output;
string cmdText = "proc_K_SysAccountSave";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("tranType", tranType),
new SqlParameter("UserId", paramsModel.UserID),
new SqlParameter("UserName", paramsModel.UserName),
new SqlParameter("Password", paramsModel.PassWord),
new SqlParameter("Orders", paramsModel.Orders),
new SqlParameter("IsValid", paramsModel.IsValid),
returnValue
};
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, paras);
isOk = returnValue.Value.ToString();
}
catch (Exception ex)
{
isOk = ex.Message;
}
return(isOk);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
string returnMsg = string.Empty;
if (GetLoginAccountId() == "0" && string.IsNullOrEmpty(UserID)) //如果用户ID=0和用户ID的参数为空（超级管理员修改用户密码）
{
string SuperUserPassword = ConfigurationManager.AppSettings[SystemConst.CONFIG_SUPERUSER_PASSWORD];
if (!SecurityHelper.MD5(txtAccountPwd.Text).Equals(SuperUserPassword))
{
Utils.RunJavaScript(this, "alert({msg:'输入的旧密码不正确，请重新输入！',title:'提示信息'})");
return;
}
else
{
UpdateWebConfig_appSettings("SuperUserPassword", SecurityHelper.MD5(txtAccountNewPwd1.Text).ToString());
returnMsg = "1";
}
}
else
{
if (string.IsNullOrEmpty(UserID)) //如果是用户自己修改自己的密码，需要比对旧密码是否输入正确
{
DataTable dt = BllAccount.GetList("ONE", Utils.getOneParams(GetLoginAccountId()));
string oldPwd = string.Empty;
if (dt.Rows.Count > 0)
{
oldPwd = dt.Rows[0]["PassWord"].ToString();
}
if (SecurityHelper.MD5(txtAccountPwd.Text) != oldPwd)
{
Utils.RunJavaScript(this, "alert({msg:'输入的旧密码不正确，请重新输入！',title:'提示信息'})");
return;
}
}
KingTop.Model.SysManage.Account mode = new KingTop.Model.SysManage.Account();
mode.UserID = Utils.ParseInt(this.UserID, Utils.ParseInt(GetLoginAccountId(), 0));
mode.PassWord = SecurityHelper.MD5(txtAccountNewPwd1.Text).ToString();
returnMsg = BllAccount.Save("CHANGEPWD", mode);
}
try
{
if (Convert.ToInt32(returnMsg) > 0)
{
Utils.RunJavaScript(this, "alert({msg:'修改密码成功！',title:'提示信息'})");
WriteLog("修改" + txtAccountName.Text + "密码成功", "", 2);// 写入操作日志
PageInit();
}
}
catch
{
Utils.RunJavaScript(this, "alert({msg:" + returnMsg + ",title:'提示信息'})");
WriteLog("修改" + txtAccountName.Text + "密码失败", "", 2);// 写入操作日志
}
}
public KingTop.Model.SysManage.Account GetAccountByName(string UserName, string SiteID)
{
DataTable DTAccount = dal.GetList("LOGININFO", Utils.getTwoParams(UserName, SiteID));
KingTop.Model.SysManage.Account clsAcc = new KingTop.Model.SysManage.Account();
if (DTAccount.Rows.Count >= 1)
{
clsAcc.UserID = Utils.ParseInt(DTAccount.Rows[0]["UserID"], 1);
clsAcc.UserName = DTAccount.Rows[0]["UserName"].ToString();
clsAcc.PassWord = DTAccount.Rows[0]["Password"].ToString();
clsAcc.Orders = Utils.ParseInt(DTAccount.Rows[0]["Orders"], 0);
clsAcc.IsValid = Utils.ParseBool(DTAccount.Rows[0]["IsValid"]);
clsAcc.UserGroupCode = DTAccount.Rows[0]["UserGroupCode"].ToString();
}
return(clsAcc);
}
/// <summary>
/// 保存备忘录
/// </summary>
private string UpdateMorandum(string content)
{
try
{
string strMessage = "";
//先判断是不是超级用户
if (userID == "0")
{
string xml = Server.MapPath("~/SysAdmin/Configuraion/adminLoginInfo.config");
try
{
Utils.XmlUpdate(xml, "/root/Morandum", "", content);
}
catch (Exception exp)
{
strMessage = exp.ToString();
}
}
else
{
KingTop.Model.SysManage.Account modelAccount = new KingTop.Model.SysManage.Account();
Account bllAccount = new Account();
modelAccount.UserID = int.Parse(userID);
modelAccount.Memorandum = content;
strMessage = bllAccount.Save("MEMORANDUM", modelAccount);
//如数据操作出现异常，这行将报错
int.Parse(strMessage);
}
//写日志
WriteLog(GetLogValue("", "EDIT", "Memorandum", true), "", 2);
return("保存成功！");
}
catch
{
return("数据操作失败！");
}
}
/// <summary>
/// 增、改K_SysAccount表
/// </summary>
/// <param name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param name="AutModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string trantype, KingTop.Model.SysManage.Account AccountModel)
{
return(dal.Save(trantype, AccountModel));
}
