/// <summary>
/// 增、改K_SysRole表
/// </summary>
/// <param Name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param Name="paramsModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string tranType, KingTop.Model.SysManage.Role paramsModel)
{
string isOk = "";
try
{
SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.Output;
string cmdText = "proc_K_SysRoleSave";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("tranType", tranType),
new SqlParameter("RoleCode", paramsModel.RoleCode),
new SqlParameter("RoleName", paramsModel.RoleName),
new SqlParameter("SiteID", paramsModel.SiteID),
new SqlParameter("InputID", paramsModel.InputID),
new SqlParameter("InputPerson", paramsModel.InputPerson),
new SqlParameter("InputDate", paramsModel.InputDate),
new SqlParameter("RoleDescription", paramsModel.RoleDescription),
new SqlParameter("RoleOrder", paramsModel.RoleOrder),
returnValue
};
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, paras);
isOk = returnValue.Value.ToString();
}
catch (Exception ex)
{
isOk = ex.Message;
}
return(isOk);
}
protected void btnRole_Click(object sender, EventArgs e)
{
string id = hdnID.Value;
string returnMsg = "";
string tranType = "NEW";
KingTop.Model.SysManage.Role mode = new KingTop.Model.SysManage.Role();
if (id != "") // 修改关键字
{
#region 修改角色
// 权限验证，是否具有修改权限
if (IsHaveRightByOperCode("Edit"))
{
tranType = "EDIT";
mode.RoleCode = new Guid(id);
mode.RoleName = Utils.HtmlEncode(txtRoleName.Text.Trim());
mode.SiteID = SiteID;
mode.InputID = Utils.ParseInt(base.GetLoginAccountId().ToString(), 0);
mode.InputPerson = base.GetLoginAccountName();
mode.InputDate = DateTime.Now;
mode.RoleDescription = Utils.HtmlEncode(txtRoleDescription.Text.Trim());
mode.RoleOrder = Utils.ParseInt(txtRoleOrder.Text.Trim(), 0);
returnMsg = bll.Save(tranType, mode);
int MsgNum = Utils.ParseInt(returnMsg, 0);
string logTitle = Request.Form["hidLogTitle"];
if (logTitle != txtRoleName.Text)
{
logTitle = logTitle + " => " + txtRoleName.Text;
}
if (MsgNum == 1)
{
WriteLog(GetLogValue(logTitle, "Update", "RoleEdit", true), "", 2); //写日志
Utils.RunJavaScript(this, "type=1;title='" + txtRoleName.Text.Trim().Replace("'", "\\'") + "'");
}
else if (MsgNum == 2)
{
WriteLog(GetLogValue(logTitle, "Update", "RoleEdit", false), "名称已存", 3); //写日志
Utils.RunJavaScript(this, "type=2;title='" + txtRoleName.Text.Trim().Replace("'", "\\'") + "';errmsg='该名称已存在，请重写填写角色名称！';");
}
else
{
WriteLog(GetLogValue(logTitle, "Update", "RoleEdit", false), returnMsg, 3); //写日志
Utils.RunJavaScript(this, "type=2;title='" + txtRoleName.Text.Trim().Replace("'", "\\'") + "';errmsg='" + returnMsg.Replace("'", "\\'").Replace("\r\n", "<br>") + "';");
}
}
else
{
sbLog.Append("失败，无权限！");
Utils.RunJavaScript(this, "alert({msg:'你没有编辑角色的权限，请联系站点管理员！',title:'提示信息'})");
}
#endregion
}
else
{
#region 新增角色
// 权限验证，是否具有新增权限
if (IsHaveRightByOperCode("New"))
{
mode.RoleCode = Guid.NewGuid();
mode.RoleName = Utils.HtmlEncode(txtRoleName.Text.Trim());
mode.SiteID = SiteID;
mode.InputID = Utils.ParseInt(base.GetLoginAccountId().ToString(), 0);
mode.InputPerson = base.GetLoginAccountName();
mode.InputDate = DateTime.Now;
mode.RoleDescription = Utils.HtmlEncode(txtRoleDescription.Text.Trim());
mode.RoleOrder = Utils.ParseInt(txtRoleOrder.Text.Trim(), 0);
returnMsg = bll.Save(tranType, mode);
int MsgNum = Utils.ParseInt(returnMsg, 0);
if (MsgNum == 1)
{
WriteLog("新增" + txtRoleName.Text + "角色成功", "", 2);// 写入操作日志
Utils.RunJavaScript(this, "type=0;title='" + txtRoleName.Text.Trim().Replace("'", "\\'") + "'");
}
else if (MsgNum == 2)
{
WriteLog("新增" + txtRoleName.Text + "角色失败", "该名称已存在", 2);
Utils.RunJavaScript(this, "type=2;title='" + txtRoleName.Text.Trim().Replace("'", "\\'") + "';errmsg='该名称已存在，请重写填写角色名称！';");
}
else
{
WriteLog("新增" + txtRoleName.Text + "角色失败", returnMsg, 2);
Utils.RunJavaScript(this, "type=2;title='" + txtRoleName.Text.Trim().Replace("'", "\\'") + "';errmsg='" + returnMsg.Replace("'", "\\'").Replace("\r\n", "<br>") + "';");
}
}
else
{
Utils.RunJavaScript(this, "alert({msg:'你没有新增角色的权限，请联系站点管理员！',title:'提示信息'})");
}
#endregion
}
}
/// <summary>
/// 增、改K_SysRole表
/// </summary>
/// <param name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param name="AutModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string trantype, KingTop.Model.SysManage.Role RoleModel)
{
return(dal.Save(trantype, RoleModel));
}
