/// <summary>
/// 绑定数据
/// </summary>
protected void Bind()
{
if (Request.QueryString["ID"] == null)
{
return;
}
SystemMenuModel = SystemMenuBll.GetModel(Convert.ToInt32(Request.QueryString["ID"]));
//模块名称
txtFullName.Text = SystemMenuModel.FullName;
//父级菜单ID
DDPLastModel.SelectedValue = SystemMenuModel.ParentID.ToString();
//分类
txtCategory.Text = SystemMenuModel.Category;
//地址
txtLocation.Text = SystemMenuModel.Location;
//显示顺序
txtSortCode.Text = SystemMenuModel.SortCode;
//级别层次
txtLevel.Text = SystemMenuModel.Level;
//模板代码
txtModuleID.Text = Request.QueryString["ID"];
//链接目标
ddlTarget.SelectedValue = SystemMenuModel.Target;
//分类
txtCategory.Text = SystemMenuModel.Category;
//图片
txtIcon.Text = SystemMenuModel.Icon;
//说明
txtRemark.Text = SystemMenuModel.Remark;
//权限字符串
txtMenuRole.Text = SystemMenuModel.MenuRole;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Haikan.SchoolProjectsCore.MDB.Model.SystemMenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SystemMenu set ");
strSql.Append("FullName=@FullName,");
strSql.Append("ParentID=@ParentID,");
strSql.Append("Category=@Category,");
strSql.Append("Icon=@Icon,");
strSql.Append("Target=@Target,");
strSql.Append("Level=@Level,");
strSql.Append("SortCode=@SortCode,");
strSql.Append("Location=@Location,");
strSql.Append("Remark=@Remark,");
strSql.Append("MenuRole=@MenuRole");
strSql.Append(" where ModuleID=@ModuleID");
SqlParameter[] parameters =
{
new SqlParameter("@FullName", SqlDbType.VarChar, 100),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Category", SqlDbType.VarChar, 100),
new SqlParameter("@Icon", SqlDbType.VarChar, 100),
new SqlParameter("@Target", SqlDbType.VarChar, 100),
new SqlParameter("@Level", SqlDbType.VarChar, 100),
new SqlParameter("@SortCode", SqlDbType.VarChar, 100),
new SqlParameter("@Location", SqlDbType.VarChar, 100),
new SqlParameter("@Remark", SqlDbType.VarChar, 100),
new SqlParameter("@MenuRole", SqlDbType.VarChar, 100),
new SqlParameter("@ModuleID", SqlDbType.Int, 4)
};
parameters[0].Value = model.FullName;
parameters[1].Value = model.ParentID;
parameters[2].Value = model.Category;
parameters[3].Value = model.Icon;
parameters[4].Value = model.Target;
parameters[5].Value = model.Level;
parameters[6].Value = model.SortCode;
parameters[7].Value = model.Location;
parameters[8].Value = model.Remark;
parameters[9].Value = model.MenuRole;
parameters[10].Value = model.ModuleID;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Haikan.SchoolProjectsCore.MDB.Model.SystemMenu DataRowToModel(DataRow row)
{
Haikan.SchoolProjectsCore.MDB.Model.SystemMenu model = new Haikan.SchoolProjectsCore.MDB.Model.SystemMenu();
if (row != null)
{
if (row["ModuleID"] != null && row["ModuleID"].ToString() != "")
{
model.ModuleID = int.Parse(row["ModuleID"].ToString());
}
if (row["FullName"] != null)
{
model.FullName = row["FullName"].ToString();
}
if (row["ParentID"] != null && row["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(row["ParentID"].ToString());
}
if (row["Category"] != null)
{
model.Category = row["Category"].ToString();
}
if (row["Icon"] != null)
{
model.Icon = row["Icon"].ToString();
}
if (row["Target"] != null)
{
model.Target = row["Target"].ToString();
}
if (row["Level"] != null)
{
model.Level = row["Level"].ToString();
}
if (row["SortCode"] != null)
{
model.SortCode = row["SortCode"].ToString();
}
if (row["Location"] != null)
{
model.Location = row["Location"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["MenuRole"] != null)
{
model.MenuRole = row["MenuRole"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Haikan.SchoolProjectsCore.MDB.Model.SystemMenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemMenu(");
strSql.Append("FullName,ParentID,Category,Icon,Target,Level,SortCode,Location,Remark,MenuRole)");
strSql.Append(" values (");
strSql.Append("@FullName,@ParentID,@Category,@Icon,@Target,@Level,@SortCode,@Location,@Remark,@MenuRole)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@FullName", SqlDbType.VarChar, 100),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Category", SqlDbType.VarChar, 100),
new SqlParameter("@Icon", SqlDbType.VarChar, 100),
new SqlParameter("@Target", SqlDbType.VarChar, 100),
new SqlParameter("@Level", SqlDbType.VarChar, 100),
new SqlParameter("@SortCode", SqlDbType.VarChar, 100),
new SqlParameter("@Location", SqlDbType.VarChar, 100),
new SqlParameter("@Remark", SqlDbType.VarChar, 100),
new SqlParameter("@MenuRole", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.FullName;
parameters[1].Value = model.ParentID;
parameters[2].Value = model.Category;
parameters[3].Value = model.Icon;
parameters[4].Value = model.Target;
parameters[5].Value = model.Level;
parameters[6].Value = model.SortCode;
parameters[7].Value = model.Location;
parameters[8].Value = model.Remark;
parameters[9].Value = model.MenuRole;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Haikan.SchoolProjectsCore.MDB.Model.SystemMenu GetModel(int ModuleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ModuleID,FullName,ParentID,Category,Icon,Target,Level,SortCode,Location,Remark,MenuRole from SystemMenu ");
strSql.Append(" where ModuleID=@ModuleID");
SqlParameter[] parameters =
{
new SqlParameter("@ModuleID", SqlDbType.Int, 4)
};
parameters[0].Value = ModuleID;
Haikan.SchoolProjectsCore.MDB.Model.SystemMenu model = new Haikan.SchoolProjectsCore.MDB.Model.SystemMenu();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 绑定选择框
/// </summary>
public void Bind()
{
// 首先绑定目录
var dsMenu = _systemMenuBll.GetList("category = '目录'");
MyMenus.DataSource = dsMenu;
MyMenus.DataBind();
// 然后绑定页面
foreach (Control item in MyMenus.Items)
{
// checkbox容器，用来装载
if (!(item.FindControl("MyCheckBoxList") is CheckBoxList checklist))
{
return;
}
// 隐藏域，当前目录的ID
if (!(item.FindControl("hfModuleID") is HiddenField hidId))
{
return;
}
// 查询所有二级页面
var ds = _systemMenuBll.GetList("ParentID=" + Convert.ToInt32(hidId.Value));
_systemMenuModel = _systemMenuBll.GetModel(Convert.ToInt32(hidId.Value));
if (ds.Tables[0].Rows.Count <= 0)
{
continue;
}
for (var i = 0; i < ds.Tables[0].Rows.Count; i++)
{
for (var j = 0; j < 12; j++)
{
switch (j)
{
case 0:
checklist.Items.Add(new ListItem(_systemMenuModel.FullName + "--" + ds.Tables[0].Rows[i]["FullName"] + "--" + "查看", _systemMenuModel.MenuRole + "||" + ds.Tables[0].Rows[i]["MenuRole"] + "Show||" + ds.Tables[0].Rows[i]["MenuRole"] + "List||" + ds.Tables[0].Rows[i]["MenuRole"]));
break;
case 1:
checklist.Items.Add(new ListItem("添加", ds.Tables[0].Rows[i]["MenuRole"] + "Add"));
break;
case 2:
checklist.Items.Add(new ListItem("修改", ds.Tables[0].Rows[i]["MenuRole"] + "Modify"));
break;
case 3:
checklist.Items.Add(new ListItem("删除", ds.Tables[0].Rows[i]["MenuRole"] + "Del"));
break;
case 4:
checklist.Items.Add(new ListItem("导入", ds.Tables[0].Rows[i]["MenuRole"] + "Import"));
break;
case 5:
checklist.Items.Add(new ListItem("导出", ds.Tables[0].Rows[i]["MenuRole"] + "Export"));
break;
case 6:
checklist.Items.Add(new ListItem("打印", ds.Tables[0].Rows[i]["MenuRole"] + "Print"));
break;
case 7:
checklist.Items.Add(new ListItem("查询", ds.Tables[0].Rows[i]["MenuRole"] + "Search"));
break;
case 8:
checklist.Items.Add(new ListItem("刷新", ds.Tables[0].Rows[i]["MenuRole"] + "Refresh"));
break;
case 9:
checklist.Items.Add(new ListItem("审批", ds.Tables[0].Rows[i]["MenuRole"] + "Accredit"));
break;
case 10:
checklist.Items.Add(new ListItem("查看全部", ds.Tables[0].Rows[i]["MenuRole"] + "AllShow"));
break;
}
}
}
}
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSubmit_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
{
if (Request.QueryString["id"] == null)
{
//模块名称
SystemMenuModel.FullName = txtFullName.Text;
SystemMenuModel.ParentID = Convert.ToInt32(DDPLastModel.SelectedValue);
//Icon图标
SystemMenuModel.Icon = txtIcon.Text;
//模块分类
SystemMenuModel.Category = txtCategory.Text;
//连接目标
SystemMenuModel.Target = ddlTarget.SelectedValue;
//级别层次
SystemMenuModel.Level = txtLevel.Text;
SystemMenuModel.Remark = txtRemark.Text;
//显示顺序
SystemMenuModel.SortCode = txtSortCode.Text;
//访问地址
SystemMenuModel.Location = txtLocation.Text;
//权限字符串
SystemMenuModel.MenuRole = txtMenuRole.Text;
//添加一条数据
if (SystemMenuBll.Add(SystemMenuModel) > 0)
{
//写系统日志
AddSystemLog("用户添加菜单信息", "添加");
AlertAndParentSkip("菜单信息添加成功!", "SystemMenuList.aspx");
}
}
else
{
SystemMenuModel = SystemMenuBll.GetModel(Convert.ToInt32(Request.QueryString["id"]));
SystemMenuModel.FullName = txtFullName.Text;
SystemMenuModel.ParentID = Convert.ToInt32(DDPLastModel.SelectedValue);
//Icon图标
SystemMenuModel.Icon = txtIcon.Text;
//模块分类
SystemMenuModel.Category = txtCategory.Text;
//连接目标
SystemMenuModel.Target = ddlTarget.SelectedValue;
//级别层次
SystemMenuModel.Level = txtLevel.Text;
//显示顺序
SystemMenuModel.SortCode = txtSortCode.Text;
SystemMenuModel.Remark = txtRemark.Text;
//访问地址
SystemMenuModel.Location = txtLocation.Text;
//权限字符串
SystemMenuModel.MenuRole = txtMenuRole.Text;
//更新一条数据
if (SystemMenuBll.Update(SystemMenuModel))
{
//写系统日志
AddSystemLog("用户修改菜单信息", "修改");
AlertAndParentSkip("菜单信息修改成功!", "SystemMenuList.aspx");
}
}
}
}
