/// <summary>
/// 增加一个模块
/// </summary>
/// <param name="model">模块实体类</param>
/// <returns></returns>
public int CreateModule(Entity.BASE_MODULE model)
{
if (!ModuleExists(model.ModuleTag))
{
return(dal.CreateModule(model));
}
else
{
return(2);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">模块实体类</param>
/// <returns></returns>
public int UpdateModule(Entity.BASE_MODULE model)
{
if (!UpdateExists(model.ModuleID, model.ModuleTag))
{
return(dal.UpdateModule(model));
}
else
{
return(2);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">模块实体类</param>
/// <returns></returns>
public int UpdateModule(Entity.BASE_MODULE model)
{
int ret = 0;
if (!UpdateExists(model.ModuleID, model.ModuleTag))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_Module set ");
strSql.Append("ModuleTypeID=@ModuleTypeID,");
strSql.Append("ModuleName=@ModuleName,");
strSql.Append("ModuleTag=@ModuleTag,");
strSql.Append("ModuleURL=@ModuleURL,");
strSql.Append("ModuleDisabled=@ModuleDisabled,");
strSql.Append("ModuleOrder=@ModuleOrder,");
strSql.Append("ModuleDescription=@ModuleDescription,");
strSql.Append("IsMenu=@IsMenu");
strSql.Append(" where ModuleID=@ModuleID ");
SqlParameter[] parameters =
{
new SqlParameter("@ModuleID", SqlDbType.Int, 4),
new SqlParameter("@ModuleTypeID", SqlDbType.Int, 4),
new SqlParameter("@ModuleName", SqlDbType.NVarChar, 30),
new SqlParameter("@ModuleTag", SqlDbType.NVarChar, 50),
new SqlParameter("@ModuleURL", SqlDbType.NVarChar, 500),
new SqlParameter("@ModuleDisabled", SqlDbType.Bit, 1),
new SqlParameter("@ModuleOrder", SqlDbType.Int, 4),
new SqlParameter("@ModuleDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@IsMenu", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ModuleID;
parameters[1].Value = model.ModuleTypeID;
parameters[2].Value = model.ModuleName;
parameters[3].Value = model.ModuleTag;
parameters[4].Value = model.ModuleURL;
parameters[5].Value = model.ModuleDisabled;
parameters[6].Value = model.ModuleOrder;
parameters[7].Value = model.ModuleDescription;
parameters[8].Value = model.IsMenu;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
ret = 1;
}
}
else
{
ret = 2;
}
return(ret);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_MODULE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_Module set ");
strSql.Append(" ModuleTypeID = @ModuleTypeID , ");
strSql.Append(" ModuleName = @ModuleName , ");
strSql.Append(" ModuleTag = @ModuleTag , ");
strSql.Append(" ModuleURL = @ModuleURL , ");
strSql.Append(" ModuleDisabled = @ModuleDisabled , ");
strSql.Append(" ModuleOrder = @ModuleOrder , ");
strSql.Append(" ModuleDescription = @ModuleDescription , ");
strSql.Append(" IsMenu = @IsMenu ");
strSql.Append(" where ModuleID=@ModuleID ");
SqlParameter[] parameters =
{
new SqlParameter("@ModuleID", SqlDbType.Int, 4),
new SqlParameter("@ModuleTypeID", SqlDbType.Int, 4),
new SqlParameter("@ModuleName", SqlDbType.NVarChar, 30),
new SqlParameter("@ModuleTag", SqlDbType.NVarChar, 50),
new SqlParameter("@ModuleURL", SqlDbType.NVarChar, 500),
new SqlParameter("@ModuleDisabled", SqlDbType.Bit, 1),
new SqlParameter("@ModuleOrder", SqlDbType.Int, 4),
new SqlParameter("@ModuleDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@IsMenu", SqlDbType.Bit, 1)
};
parameters[8].Value = entity.ModuleID;
parameters[9].Value = entity.ModuleTypeID;
parameters[10].Value = entity.ModuleName;
parameters[11].Value = entity.ModuleTag;
parameters[12].Value = entity.ModuleURL;
parameters[13].Value = entity.ModuleDisabled;
parameters[14].Value = entity.ModuleOrder;
parameters[15].Value = entity.ModuleDescription;
parameters[16].Value = entity.IsMenu;
int rows = SqlServerHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_MODULE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_Module(");
strSql.Append("ModuleTypeID,ModuleName,ModuleTag,ModuleURL,ModuleDisabled,ModuleOrder,ModuleDescription,IsMenu");
strSql.Append(") values (");
strSql.Append("@ModuleTypeID,@ModuleName,@ModuleTag,@ModuleURL,@ModuleDisabled,@ModuleOrder,@ModuleDescription,@IsMenu");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ModuleTypeID", SqlDbType.Int, 4),
new SqlParameter("@ModuleName", SqlDbType.NVarChar, 30),
new SqlParameter("@ModuleTag", SqlDbType.NVarChar, 50),
new SqlParameter("@ModuleURL", SqlDbType.NVarChar, 500),
new SqlParameter("@ModuleDisabled", SqlDbType.Bit, 1),
new SqlParameter("@ModuleOrder", SqlDbType.Int, 4),
new SqlParameter("@ModuleDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@IsMenu", SqlDbType.Bit, 1)
};
parameters[0].Value = entity.ModuleTypeID;
parameters[1].Value = entity.ModuleName;
parameters[2].Value = entity.ModuleTag;
parameters[3].Value = entity.ModuleURL;
parameters[4].Value = entity.ModuleDisabled;
parameters[5].Value = entity.ModuleOrder;
parameters[6].Value = entity.ModuleDescription;
parameters[7].Value = entity.IsMenu;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 保存模块信息
/// </summary>
protected void m_btn_save_Click(object sender, EventArgs e)
{
Entity.BASE_MODULE model = new Entity.BASE_MODULE();
model.ModuleTypeID = int.Parse(txt_MT.SelectedValue);
model.ModuleName = txt_name.Text.Trim();
model.ModuleTag = txt_tag.Text.Trim();
model.ModuleURL = txt_url.Text.Trim();
if (txt_state.SelectedValue == "0")
{
model.ModuleDisabled = true;
}
else
{
model.ModuleDisabled = true;
}
model.ModuleOrder = int.Parse(txt_order.Text.Trim());
model.ModuleDescription = txt_Description.Text.Trim();
if (IsMenu.SelectedValue == "0")
{
model.IsMenu = false;
}
else
{
model.IsMenu = true;
}
if (!bll.ModuleExists(txt_tag.Text.Trim()))
{
int RowID = bll.CreateModule(model); //返回模块ID;
if (RowID != 0) //添加OK
{
ArrayList list = new ArrayList(); //建立事务列表
int n = int.Parse(AuthorityNum.Text);
for (int i = 0; i < n; i++)
{
if (Request.Form["Alist" + i.ToString()].ToString() == "1")//如果允许则插入记录
{
string item = string.Empty;
item = item + RowID.ToString() + "|" + Request.Form["Atag" + i.ToString()].ToString();
list.Add(item);
}
}
//权限加入是否成功！
if (bll.CreateAuthorityList(list))
{
clearTxt();
EditModulePanel.Visible = true;
Smart.Utility.JScript.Extjs("alert('添加成功!');window.parent.location.href='ModulesPage.aspx';");
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("添加操作失败!");
strinfo.Visible = true;
}
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("标识已存在,请更换后重试!");
strinfo.Visible = true;
}
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("添加操作失败!");
strinfo.Visible = true;
}
}
/// <summary>
/// 更新模块信息
/// </summary>
protected void btn_update_Click(object sender, EventArgs e)
{
Entity.BASE_MODULE model = new Entity.BASE_MODULE();
model.ModuleID = int.Parse(M_ID.Text);
model.ModuleTypeID = int.Parse(txt_MT.SelectedValue);
model.ModuleName = txt_name.Text.Trim();
model.ModuleTag = txt_tag.Text.Trim();
model.ModuleURL = txt_url.Text.Trim();
if (txt_state.SelectedValue == "0")
{
model.ModuleDisabled = false;
}
else
{
model.ModuleDisabled = true;
}
model.ModuleOrder = int.Parse(txt_order.Text.Trim());
model.ModuleDescription = txt_Description.Text.Trim();
if (IsMenu.SelectedValue == "0")
{
model.IsMenu = false;
}
else
{
model.IsMenu = true;
}
string[] vstr = Request.Form["verifystate"].Split(',');
switch (bll.UpdateModule(model))
{
case 1:
ArrayList list = new ArrayList(); //建立事务列表
int n = int.Parse(AuthorityNum.Text);
for (int i = 0; i < n; i++)
{
//判断权限是否有变化
if (vstr[i] != Request.Form["Alist" + i.ToString()].ToString())
{
string item = string.Empty;
item = item + model.ModuleID.ToString() + "|"
+ Request.Form["Atag" + i.ToString()].ToString() + "|"
+ Request.Form["Alist" + i.ToString()].ToString(); //判断插入增加还是删除
list.Add(item);
}
}
//权限更新是否成功！
if (bll.UpdateAuthorityList(list))
{
//BindPermissionUpdate(model.ModuleID);
Smart.Utility.JScript.Extjs("alert('更新成功!');window.parent.location.href='ModulesPage.aspx';");
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("更新操作失败!");
strinfo.Visible = true;
}
break;
case 2:
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("标识已经存在，请更换后重试!");
strinfo.Visible = true;
break;
default:
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("更新操作失败!");
strinfo.Visible = true;
break;
}
}
/// <summary>
/// 更新时初始化权限
/// </summary>
/// <param name="ModuleID"></param>
public void BindPermissionUpdate(int ModuleID)
{
#region 模块数据绑定
Entity.BASE_MODULE model = new Entity.BASE_MODULE();
model = bll.GetModuleModel(ModuleID);
M_ID.Text = model.ModuleID.ToString();
txt_MT.SelectedValue = model.ModuleTypeID.ToString();
txt_name.Text = model.ModuleName;
txt_tag.Text = model.ModuleTag;
txt_url.Text = model.ModuleURL;
if (model.ModuleDisabled)
{
txt_state.SelectedIndex = 0;
}
else
{
txt_state.SelectedIndex = 1;
}
txt_order.Text = model.ModuleOrder.ToString();
txt_Description.Text = model.ModuleDescription;
if (model.IsMenu)
{
IsMenu.SelectedIndex = 0;
}
else
{
IsMenu.SelectedIndex = 1;
}
#endregion
#region 权限数据绑定
StringBuilder strState = new StringBuilder(); //状态
StringBuilder strTag = new StringBuilder(); //标识
StringBuilder strVerify = new StringBuilder(); //对比状态
BLL.BASE_AUTHORITYDIR Abll = new BLL.BASE_AUTHORITYDIR();
DataSet MALDS = bll.GetAuthorityList(ModuleID);
DataSet ds = Abll.GetAuthorityList("", "order by AuthorityOrder asc");
int rcount = ds.Tables[0].Rows.Count;
AuthorityNum.Text = rcount.ToString();
if (rcount == 0)
{
divstate.InnerHtml = "暂无记录";
}
else
{
strVerify.Append("<input type=\"hidden\" name=\"verifystate\" id=\"verifystate\" value=\"");
strState.Append("<table width=\"340\" border=\"0\" cellpadding=\"0\" cellspacing=\"2\">");
for (int i = 0; i < rcount; i++)
{
bool v = false;
for (int k = 0; k < MALDS.Tables[0].Rows.Count; k++)
{
if (MALDS.Tables[0].Rows[k]["AuthorityTag"].ToString() == ds.Tables[0].Rows[i]["AuthorityTag"].ToString())
{
v = true;
break;
}
}
if ((i + 1) % 2 != 0)
{
#region 左边
if (v)//是否为可以使用的权限
{
strState.Append("<tr><td width=\"50\"><span class=\"RoleTitle\">" + ds.Tables[0].Rows[i]["AuthorityName"].ToString()
+ "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString()
+ "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString()
+ "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" checked=\"checked\" />"
+ "<label for=\"Alist" + i.ToString() + "_0\">允许</label></td><td>"
+ "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" />"
+ "<label for=\"Alist" + i.ToString() + "_1\">拒绝</label></td></tr></table></td>");
strVerify.Append("1,");
}
else
{
strState.Append("<tr><td width=\"50\"><span class=\"RoleTitle\">" + ds.Tables[0].Rows[i]["AuthorityName"].ToString()
+ "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString()
+ "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString()
+ "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" />"
+ "<label for=\"Alist" + i.ToString() + "_0\">允许</label></td><td>"
+ "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" checked=\"checked\" />"
+ "<label for=\"Alist" + i.ToString() + "_1\">拒绝</label></td></tr></table></td>");
strVerify.Append("0,");
}
#endregion
}
else
{
#region 右边
if (v)//是否为可以使用的权限
{
strState.Append("<td width=\"50\"><span class=\"RoleTitle\">" + ds.Tables[0].Rows[i]["AuthorityName"].ToString()
+ "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString()
+ "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString()
+ "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" checked=\"checked\" />"
+ "<label for=\"Alist" + i.ToString() + "_0\">允许</label></td><td>"
+ "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" />"
+ "<label for=\"Alist" + i.ToString() + "_1\">拒绝</label></td></tr></table></td></tr>");
strVerify.Append("1,");
}
else
{
strState.Append("<td width=\"50\"><span class=\"RoleTitle\">" + ds.Tables[0].Rows[i]["AuthorityName"].ToString()
+ "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString()
+ "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString()
+ "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" />"
+ "<label for=\"Alist" + i.ToString() + "_0\">允许</label></td><td>"
+ "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" checked=\"checked\" />"
+ "<label for=\"Alist" + i.ToString() + "_1\">拒绝</label></td></tr></table></td></tr>");
strVerify.Append("0,");
}
#endregion
}
//写入标识
strTag.Append("<input type=\"hidden\" name=\"Atag" + i.ToString() + "\" id=\"Atag" + i.ToString() + "\" value=\"" + ds.Tables[0].Rows[i]["AuthorityTag"] + "\" />");
}
strVerify.Append("\" />");
if ((rcount) % 2 == 0)
{
strState.Append("</table>");
}
else
{
strState.Append("<td width=\"50\"> </td><td width=\"100\"> </td></tr></table>");
}
divstate.InnerHtml = strState.ToString() + strTag.ToString() + strVerify.ToString();
}
#endregion
}
/// <summary>
/// 得到一个模块实体
/// </summary>
/// <param name="ModuleID">模块ID</param>
/// <returns></returns>
public Entity.BASE_MODULE GetModuleModel(int ModuleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Base_Module ");
strSql.Append(" where ModuleID=@ModuleID ");
SqlParameter[] parameters =
{
new SqlParameter("@ModuleID", SqlDbType.Int, 4)
};
parameters[0].Value = ModuleID;
Entity.BASE_MODULE model = new Entity.BASE_MODULE();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ModuleID"].ToString() != "")
{
model.ModuleID = int.Parse(ds.Tables[0].Rows[0]["ModuleID"].ToString());
}
if (ds.Tables[0].Rows[0]["ModuleTypeID"].ToString() != "")
{
model.ModuleTypeID = int.Parse(ds.Tables[0].Rows[0]["ModuleTypeID"].ToString());
}
model.ModuleName = ds.Tables[0].Rows[0]["ModuleName"].ToString();
model.ModuleTag = ds.Tables[0].Rows[0]["ModuleTag"].ToString();
model.ModuleURL = ds.Tables[0].Rows[0]["ModuleURL"].ToString();
if (ds.Tables[0].Rows[0]["ModuleDisabled"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["ModuleDisabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["ModuleDisabled"].ToString().ToLower() == "true"))
{
model.ModuleDisabled = true;
}
else
{
model.ModuleDisabled = false;
}
}
if (ds.Tables[0].Rows[0]["ModuleOrder"].ToString() != "")
{
model.ModuleOrder = int.Parse(ds.Tables[0].Rows[0]["ModuleOrder"].ToString());
}
model.ModuleDescription = ds.Tables[0].Rows[0]["ModuleDescription"].ToString();
if (ds.Tables[0].Rows[0]["IsMenu"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsMenu"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsMenu"].ToString().ToLower() == "true"))
{
model.IsMenu = true;
}
else
{
model.IsMenu = false;
}
}
return(model);
}
else
{
return(null);
}
}
