/// <summary>
/// 新增/删除/修改 sys_Module
/// </summary>
/// <param name="fam">sys_ModuleTable实体类</param>
/// <returns>返回0操正常</returns>
public override int sys_ModuleInsertUpdate(sys_ModuleTable fam)
{
int rInt = 0;
using (SqlConnection Conn = GetSqlConnection())
{
SqlCommand cmd = new SqlCommand("sys_ModuleInsertUpdateDelete", 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("@ModuleID", SqlDbType.Int).Value = fam.ModuleID; //功能模块ID号
cmd.Parameters.Add("@M_ApplicationID", SqlDbType.Int).Value = fam.M_ApplicationID; //所属应用程序ID
cmd.Parameters.Add("@M_ParentID", SqlDbType.Int).Value = fam.M_ParentID; //所属父级模块ID与ModuleID关联,0为顶级
cmd.Parameters.Add("@M_PageCode", SqlDbType.VarChar).Value = fam.M_PageCode; //模块编码Parent为0,则为S00(xx),否则为S00M00(xx)
cmd.Parameters.Add("@M_CName", SqlDbType.NVarChar).Value = fam.M_CName; //模块/栏目名称当ParentID为0为模块名称
cmd.Parameters.Add("@M_Directory", SqlDbType.NVarChar).Value = fam.M_Directory; //模块/栏目目录名
cmd.Parameters.Add("@M_OrderLevel", SqlDbType.VarChar).Value = fam.M_OrderLevel; //当前所在排序级别支持双层99级菜单
cmd.Parameters.Add("@M_IsSystem", SqlDbType.Int).Value = fam.M_IsSystem; //是否为系统模块1:是0:否如为系统则无法修改
cmd.Parameters.Add("@M_Close", SqlDbType.Int).Value = fam.M_Close; //是否关闭1:是0:否
cmd.Parameters.Add("@M_Icon", SqlDbType.NVarChar).Value = fam.M_Icon; //默认显示图标
Conn.Open();
rInt = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
Conn.Dispose();
Conn.Close();
}
return rInt;
}
protected void Button1_Click(object sender, EventArgs e)
{
sys_ModuleTable smt = new sys_ModuleTable();
smt = BusinessFacade.sys_ModuleDisp(ModuleID);
string OldPageCode = smt.M_PageCode;
smt.M_ApplicationID = S_ID;
smt.M_Close = (int) Common.sink(this.M_Close.UniqueID,MethodType.Post,255,1,DataType.Int);
smt.M_CName = (string)Common.sink(this.M_CName.UniqueID, MethodType.Post, 50, 1, DataType.Str);
smt.M_Directory = (string) Common.sink(this.M_Directory.UniqueID,MethodType.Post,255,0,DataType.Str);
smt.M_Icon = (string)Common.sink(this.M_Icon.UniqueID, MethodType.Post, 255, 0, DataType.Str);
//smt.M_IsSystem = (int) Common.sink(this.M_IsSystem.UniqueID,MethodType.Post,255,1,DataType.Int);
smt.M_PageCode = (string) Common.sink(this.M_PageCode.UniqueID,MethodType.Post,6,1,DataType.CharAndNum);
if (CMD == "New")
{
if (BusinessFacade.sys_Module_CheckPK(smt.M_ApplicationID, smt.M_PageCode,0))
EventMessage.MessageBox(1, "数据输入出错", string.Format("存在相同的模块编码({0})", smt.M_PageCode)
, Icon_Type.Error, "history.back()", UrlType.JavaScript);
QueryParam qp = new QueryParam();
qp.Orderfld = "M_OrderLevel";
qp.PageIndex = 1;
qp.PageSize = 1;
qp.Where = string.Format("Where M_ParentID={0} and M_Applicationid={1}", ModuleID, S_ID);
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
if (ModuleID == 0)
{
if (RecordCount != 0)
RecordCount = Convert.ToInt32(((sys_ModuleTable)lst[0]).M_OrderLevel.Substring(0,2))+1;
smt.M_OrderLevel = Common.FillZero(RecordCount.ToString(), 2) + "00";
}
else {
if (RecordCount !=0)
RecordCount = Convert.ToInt32(((sys_ModuleTable)lst[0]).M_OrderLevel.Substring(2, 2));
RecordCount++;
smt.M_OrderLevel = smt.M_OrderLevel.Substring(0, 2) + Common.FillZero(RecordCount.ToString(), 2);
}
smt.M_ParentID = ModuleID;
smt.DB_Option_Action_ = "Insert";
}
else if (CMD == "Edit")
{
if (BusinessFacade.sys_Module_CheckPK(smt.M_ApplicationID, smt.M_PageCode,ModuleID))
EventMessage.MessageBox(1, "数据输入出错", string.Format("存在相同的模块编码({0})", smt.M_PageCode)
, Icon_Type.Error, "history.back()", UrlType.JavaScript);
smt.DB_Option_Action_ = "Update";
}
smt.ModuleID = ModuleID;
if (smt.M_IsSystem!=1)
BusinessFacade.sys_ModuleInsertUpdate(smt);
if (!string.IsNullOrEmpty(OldPageCode) && OldPageCode != smt.M_PageCode)
{
//清除旧有PageCode所在用户的权限.
BusinessFacade.sys_RolePermission_DeleteForm(smt.M_ApplicationID, OldPageCode);
}
EventMessage.MessageBox(1, "操作成功", string.Format("增加/修改模块ID({0})成功!", ModuleID), Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("ModuleList.aspx?S_ID={0}&AppName={1}", S_ID, S_ID_Name)));
}
private void OnStart()
{
if (CMD == string.Empty)
{
TabOptionWebControls1.SelectIndex = 1;
}
//填充数据
sys_ModuleTable SMT = new sys_ModuleTable();
SMT = BusinessFacade.sys_ModuleDisp(ModuleID);
this.M_ApplicationID_Txt.Text = S_ID_Name;
if (ModuleID==0)
this.M_PageCode.Text = SMT.M_PageCode;
if (CMD == "New" && ModuleID != 0)
{
this.M_ParentID_Txt.Text = SMT.M_CName;
}
else
{
this.M_ParentID_Txt.Text = SMT.M_ParentID == 0 ? "无" : BusinessFacade.sys_ModuleDisp(SMT.M_ParentID).M_CName;
}
this.M_PageCode_Txt.Text = SMT.M_PageCode;
this.M_CName_Txt.Text = SMT.M_CName;
this.M_Directory_Txt.Text = SMT.M_Directory;
this.M_IsSystem_Txt.Text = SMT.M_IsSystem == 0 ? "否" : "是";
this.M_Close_Txt.Text = SMT.M_Close == 0 ? "否" : "是";
this.M_Icon_Txt.Text = SMT.M_Icon;
if (CMD == "Edit")
{
this.M_PageCode.Text = SMT.M_PageCode;
this.M_CName.Text = SMT.M_CName;
this.M_Directory.Text = SMT.M_Directory;
this.M_Icon.Text = SMT.M_Icon;
ListItem ditem1 = this.M_IsSystem.Items.FindByValue(SMT.M_IsSystem.ToString());
if (ditem1 != null)
ditem1.Selected = true;
ListItem ditem2 = this.M_Close.Items.FindByValue(SMT.M_Close.ToString());
if (ditem2 != null)
ditem2.Selected = true;
}
//绑定子模块
QueryParam qp = new QueryParam();
qp.Orderfld = " M_Applicationid,M_OrderLevel ";
qp.OrderType = 0;
qp.Where = string.Format("Where M_ParentID={0} and M_Applicationid={1}", ModuleID,S_ID);
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
//绑定排序
OrderByListItems.DataSource = lst;
OrderByListItems.DataTextField = "M_CName";
OrderByListItems.DataValueField = "ModuleID";
OrderByListItems.DataBind();
if (lst.Count > 0)
OrderByListItems.Rows = lst.Count;
//判断是否隐藏数据
if (CMD == "New" || CMD == "Edit")
HiddenDisp();
else
{
HiddenInput();
SubmitTr.Visible = false;
}
//判断是否生成增加子模块按钮
if (CMD!="New" && ModuleID !=0 && SMT.M_OrderLevel.Substring(2, 2) == "00")
{
HeadMenuButtonItem m2 = new HeadMenuButtonItem();
m2.ButtonName = "模块";
m2.ButtonPopedom = PopedomType.New;
m2.ButtonUrl = string.Format("?CMD=New&ModuleID={0}&S_ID={1}", ModuleID, S_ID);
HeadMenuWebControls1.ButtonList.Add(m2);
}
if (ModuleID !=0 && SMT.M_OrderLevel.Substring(2, 2) != "00")
{
TabOptionWebControls1.SelectIndex = 0;
TabOptionItem2.Visible = false;
TabOptionItem3.Visible = false;
TabOptionItem4.Visible = true;
BindPermissionList();
if (CMD == "Edit")
{
HeadMenuButtonItem m5 = new HeadMenuButtonItem();
m5.ButtonIcon = "back.gif";
m5.ButtonName = "返回";
m5.ButtonPopedom = PopedomType.List;
m5.ButtonUrl = string.Format("?ModuleID={0}&S_ID={1}", ModuleID, S_ID);
HeadMenuWebControls1.ButtonList.Add(m5);
}
}
//生成修改按钮
if (ModuleID != 0 && CMD=="")
{
HeadMenuButtonItem m3 = new HeadMenuButtonItem();
m3.ButtonName = "";
m3.ButtonPopedom = PopedomType.Edit;
m3.ButtonUrl = string.Format("?CMD=Edit&ModuleID={0}&S_ID={1}",ModuleID,S_ID);
HeadMenuWebControls1.ButtonList.Add(m3);
}
//生成删除按钮
if (CMD == "Edit")
{
HeadMenuButtonItem m4 = new HeadMenuButtonItem();
m4.ButtonPopedom = PopedomType.Delete;
m4.ButtonUrl = string.Format("DelData('?CMD=Delete&S_ID={0}&ModuleID={1}')", S_ID,ModuleID);
m4.ButtonUrlType = UrlType.JavaScript;
HeadMenuWebControls1.ButtonList.Add(m4);
}
//判断是否执行删除
if (CMD == "Delete")
{
SMT.DB_Option_Action_ = "Delete";
if (SMT.M_IsSystem != 1)
{
BusinessFacade.sys_ModuleInsertUpdate(SMT);
//删除角色权限表
BusinessFacade.sys_RolePermission_DeleteForm(SMT.M_ApplicationID, SMT.M_PageCode);
if (lst.Count > 0)
{
foreach (sys_ModuleTable var in lst)
{
SMT.ModuleID = var.ModuleID;
BusinessFacade.sys_ModuleInsertUpdate(SMT);
//删除角色权限表
BusinessFacade.sys_RolePermission_DeleteForm(var.M_ApplicationID, var.M_PageCode);
}
}
}
EventMessage.MessageBox(1, "操作成功", "删除记录ID:(" + ModuleID + ")成功！", Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("ModuleList.aspx?S_ID={0}&AppName={1}",S_ID,S_ID_Name)));
}
//Button1.Attributes.Add("Onclick", "javascript:return checkForm(aspnetForm);");
}
/// <summary>
/// 将记录集转为sys_ModuleTable实体类
/// </summary>
/// <param name="dr">记录集</param>
/// <returns>sys_ModuleTable</returns>
protected object Populatesys_Module(IDataReader dr)
{
sys_ModuleTable nc = new sys_ModuleTable();
if (!Convert.IsDBNull(dr["ModuleID"])) nc.ModuleID = Convert.ToInt32(dr["ModuleID"]); // 功能模块ID号
if (!Convert.IsDBNull(dr["M_ApplicationID"])) nc.M_ApplicationID = Convert.ToInt32(dr["M_ApplicationID"]); // 所属应用程序ID
if (!Convert.IsDBNull(dr["M_ParentID"])) nc.M_ParentID = Convert.ToInt32(dr["M_ParentID"]); // 所属父级模块ID与ModuleID关联,0为顶级
if (!Convert.IsDBNull(dr["M_PageCode"])) nc.M_PageCode = Convert.ToString(dr["M_PageCode"]).Trim(); // 模块编码Parent为0,则为S00(xx),否则为S00M00(xx)
if (!Convert.IsDBNull(dr["M_CName"])) nc.M_CName = Convert.ToString(dr["M_CName"]).Trim(); // 模块/栏目名称当ParentID为0为模块名称
if (!Convert.IsDBNull(dr["M_Directory"])) nc.M_Directory = Convert.ToString(dr["M_Directory"]).Trim(); // 模块/栏目目录名
if (!Convert.IsDBNull(dr["M_OrderLevel"])) nc.M_OrderLevel = Convert.ToString(dr["M_OrderLevel"]).Trim(); // 当前所在排序级别支持双层99级菜单
if (!Convert.IsDBNull(dr["M_IsSystem"])) nc.M_IsSystem = Convert.ToInt32(dr["M_IsSystem"]); // 是否为系统模块1:是0:否如为系统则无法修改
if (!Convert.IsDBNull(dr["M_Close"])) nc.M_Close = Convert.ToInt32(dr["M_Close"]); // 是否关闭1:是0:否
if (!Convert.IsDBNull(dr["M_Icon"])) nc.M_Icon = dr["M_Icon"].ToString().Trim(); // 模块/栏目名称当ParentID为0为模块名称
return nc;
}
/// <summary> /// 新增/删除/修改 sys_Module /// </summary> /// <param name="fam">sys_ModuleTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_ModuleInsertUpdate(sys_ModuleTable fam);
/// <summary>
/// 根据M_ApplicationID和M_PageCode返回 sys_ModuleTable实体类 单笔资料
/// </summary>
/// <param name="M_ApplicationID">功能模块ID号</param>
/// <param name="M_PageCode">M_PageCode</param>
/// <returns>返回sys_ModuleTable实体类 ModuleID为0则无记录</returns>
public static sys_ModuleTable sys_ModuleDisp(int M_ApplicationID, string M_PageCode)
{
sys_ModuleTable fam = new sys_ModuleTable();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.Where = string.Format(" Where sys_Module.M_ApplicationID = {0} and M_PageCode = '{1}'", M_ApplicationID, Common.inSQL(M_PageCode));
int RecordCount = 0;
ArrayList lst = sys_ModuleList(qp, out RecordCount);
if (RecordCount > 0)
{
fam = (sys_ModuleTable)lst[0];
}
return fam;
}
/// <summary>
/// 根据ID返回 sys_ModuleTable实体类 单笔资料
/// </summary>
/// <param name="ModuleID">功能模块ID号</param>
/// <returns>返回sys_ModuleTable实体类 ModuleID为0则无记录</returns>
public static sys_ModuleTable sys_ModuleDisp(int ModuleID)
{
sys_ModuleTable fam = new sys_ModuleTable();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.Where = " Where sys_Module.ModuleID = " + ModuleID;
int RecordCount = 0;
ArrayList lst = sys_ModuleList(qp, out RecordCount);
if (RecordCount > 0)
{
fam = (sys_ModuleTable)lst[0];
}
return fam;
}
/// <summary>
/// 新增/删除/修改 sys_Module
/// </summary>
/// <param name="fam">sys_ModuleTable实体类</param>
/// <returns>返回0操正常</returns>
public static int sys_ModuleInsertUpdate(sys_ModuleTable fam)
{
return DataProvider.Instance().sys_ModuleInsertUpdate(fam);
}
