protected void Button1_Click(object sender, EventArgs e)
{
sys_RolesTable sat = BusinessFacade.sys_RolesDisp(RoleID);
sat.R_Description = (string)Common.sink(R_Description.UniqueID, MethodType.Post, 255, 0, DataType.Str);
sat.R_RoleName = (string)Common.sink(R_RoleName.UniqueID, MethodType.Post, 50, 1, DataType.Str);
switch (CMD)
{
case "New":
if (BusinessFacade.sys_Roles_PK(sat.R_RoleName, 0))
{
EventMessage.MessageBox(1, "数据输入出错", string.Format("存在相同的角色名称({0})", sat.R_RoleName)
, Icon_Type.Error, "history.back()", UrlType.JavaScript);
}
CMD_Txt = "增加";
sat.R_UserID = UserData.GetUserDate.UserID;
sat.DB_Option_Action_ = "Insert";
sat.R_UserID = Common.Get_UserID;
break;
case "Edit":
if (BusinessFacade.sys_Roles_PK(sat.R_RoleName, sat.RoleID))
{
EventMessage.MessageBox(1, "数据输入出错", string.Format("存在相同的角色名称({0})", sat.R_RoleName)
, Icon_Type.Error, "history.back()", UrlType.JavaScript);
}
CMD_Txt = "修改";
sat.DB_Option_Action_ = "Update";
break;
}
All_Title_Txt = CMD_Txt + App_Txt;
BusinessFacade.sys_RolesInsertUpdate(sat);
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", RoleID, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("RoleList.aspx"));
}
private void OnStart()
{
sys_RolesTable srt = BusinessFacade.sys_RolesDisp(RoleID);
RoleName_Txt.Text = srt.R_RoleName;
AppName_Txt.Text = BusinessFacade.sys_ApplicationsDisp(ApplicationID).A_AppName;
RoleUser_Txt.Text = BusinessFacade.sys_UserDisp(srt.R_UserID).U_LoginName;
}
private void InputData()
{
if (RoleID == 0)
{
return;
}
sys_RolesTable SAT = BusinessFacade.sys_RolesDisp(RoleID);
if (SAT.RoleID == 0)
{
return;
}
this.R_Description.Text = this.R_Description_Txt.Text = SAT.R_Description;
this.R_RoleName.Text = this.R_RoleName_Txt.Text = SAT.R_RoleName;
this.RoleID_Txt.Text = SAT.RoleID.ToString();
this.R_UserName.Text = BusinessFacade.sys_UserDisp(SAT.R_UserID).U_LoginName;
}
/// <summary>
/// 将记录集转为sys_RolesTable实体类
/// </summary>
/// <param name="dr">记录集</param>
/// <returns>sys_RolesTable</returns>
protected object Populatesys_Roles(IDataReader dr)
{
sys_RolesTable nc = new sys_RolesTable();
if (!Convert.IsDBNull(dr["RoleID"]))
{
nc.RoleID = Convert.ToInt32(dr["RoleID"]); // 角色ID自动ID
}
if (!Convert.IsDBNull(dr["R_UserID"]))
{
nc.R_UserID = Convert.ToInt32(dr["R_UserID"]); // 角角所属用户ID
}
if (!Convert.IsDBNull(dr["R_RoleName"]))
{
nc.R_RoleName = Convert.ToString(dr["R_RoleName"]).Trim(); // 角色名称
}
if (!Convert.IsDBNull(dr["R_Description"]))
{
nc.R_Description = Convert.ToString(dr["R_Description"]).Trim(); // 角色介绍
}
return(nc);
}
/// <summary>
/// 新增/删除/修改 sys_Roles
/// </summary>
/// <param name="fam">sys_RolesTable实体类</param>
/// <returns>返回0操正常</returns>
public override int sys_RolesInsertUpdate(sys_RolesTable fam)
{
int rInt = 0;
using (SqlConnection Conn = GetSqlConnection())
{
SqlCommand cmd = new SqlCommand("sys_RolesInsertUpdateDelete", Conn);
cmd.CommandType = CommandType.StoredProcedure;
//设置参数
cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录
cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = fam.RoleID; //角色ID自动ID
cmd.Parameters.Add("@R_UserID", SqlDbType.Int).Value = fam.R_UserID; //角角所属用户ID
cmd.Parameters.Add("@R_RoleName", SqlDbType.NVarChar).Value = fam.R_RoleName; //角色名称
cmd.Parameters.Add("@R_Description", SqlDbType.NVarChar).Value = fam.R_Description; //角色介绍
Conn.Open();
rInt = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
Conn.Dispose();
Conn.Close();
}
return(rInt);
}
/// <summary>
/// 绑定按钮
/// </summary>
private void BindButton()
{
switch (CMD)
{
case "New":
CMD_Txt = "增加";
HiddenDisp();
TopTr.Visible = false;
break;
case "Edit":
CMD_Txt = "修改";
HiddenDisp();
HeadMenuButtonItem Bm0 = new HeadMenuButtonItem();
Bm0.ButtonPopedom = PopedomType.List;
Bm0.ButtonUrl = string.Format("?CMD=Look&RoleID={0}", RoleID);
Bm0.ButtonIcon = "back.gif";
Bm0.ButtonName = "返回";
HeadMenuWebControls1.ButtonList.Add(Bm0);
HeadMenuButtonItem Bm1 = new HeadMenuButtonItem();
Bm1.ButtonPopedom = PopedomType.Delete;
Bm1.ButtonUrlType = UrlType.JavaScript;
Bm1.ButtonUrl = string.Format("DelData('?CMD=Delete&RoleID={0}')", RoleID);
HeadMenuWebControls1.ButtonList.Add(Bm1);
break;
case "Look":
HiddenInput();
HeadMenuButtonItem Bm2 = new HeadMenuButtonItem();
Bm2.ButtonPopedom = PopedomType.Edit;
Bm2.ButtonUrl = string.Format("?CMD=Edit&RoleID={0}", RoleID);
HeadMenuWebControls1.ButtonList.Add(Bm2);
break;
case "Delete":
CMD_Txt = "删除";
sys_RolesTable sat = new sys_RolesTable();
sat.RoleID = RoleID;
sat.DB_Option_Action_ = CMD;
BusinessFacade.sys_RolesInsertUpdate(sat);
BusinessFacade.sys_RoleApplication_Move(RoleID);
BusinessFacade.sys_RolePermission_Move(RoleID);
UserData.Move_RoleUserPermissionCache(RoleID);
EventMessage.MessageBox(1, "操作成功", "删除记录ID:(" + RoleID + ")成功！", Icon_Type.OK, Common.GetHomeBaseUrl("RoleList.aspx"));
break;
case "Move":
sys_RoleApplicationTable rt = new sys_RoleApplicationTable();
rt.A_ApplicationID = (int)Common.sink("ApplicationID", MethodType.Get, 255, 1, DataType.Int);
rt.A_RoleID = RoleID;
rt.DB_Option_Action_ = "Delete";
BusinessFacade.sys_RoleApplicationInsertUpdate(rt);
BusinessFacade.sys_RolePermission_Move(rt.A_RoleID, rt.A_ApplicationID);
UserData.Move_RoleUserPermissionCache(RoleID);
EventMessage.MessageBox(1, "操作成功", "移除应用ID:(" + rt.A_ApplicationID + ")成功！", Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("RoleManager.aspx?RoleID={0}&CMD=Look", RoleID)));
break;
case "MoveUser":
//检测删除权限
FrameWorkPermission.CheckPermissionVoid(PopedomType.Delete);
int UserID = (int)Common.sink("UserID", MethodType.Get, 255, 1, DataType.Int);
UserData.Move_UserPermissionCache(UserID);
sys_UserRolesTable su = new sys_UserRolesTable();
su.DB_Option_Action_ = "Delete";
su.R_RoleID = RoleID;
su.R_UserID = UserID;
BusinessFacade.sys_UserRolesInsertUpdate(su);
EventMessage.MessageBox(1, "操作成功", string.Format("从角色ID:{0}中移除用户ID:{1}成功！", RoleID, UserID), Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("RoleManager.aspx?RoleID={0}&CMD=Look", RoleID)));
break;
}
All_Title_Txt = CMD_Txt + App_Txt;
HeadMenuWebControls1.HeadOPTxt = TabOptionItem1.Tab_Name = All_Title_Txt;
}
/// <summary> /// 新增/删除/修改 sys_Roles /// </summary> /// <param name="fam">sys_RolesTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_RolesInsertUpdate(sys_RolesTable fam);
