//Grid绑定数据源
private void BindGrid()
{
BLL.tb_SYS_Menu bllMenu = new BLL.tb_SYS_Menu();
DataSet dsMenu = bllMenu.GetList("1=1 order by MenuNO");
DataTable dtSource = PublicMethod.sortToTree(dsMenu.Tables[0], "MenuNO", "ID", "ParentID");
gridMenu.DataSource = dtSource;
gridMenu.DataBind();
}
//加载数据
private void LoadData()
{
//btnClose.OnClientClick = ActiveWindow.GetHidePostBackReference();
//绑定修改前数据
BLL.tb_SYS_Menu bllMenu = new BLL.tb_SYS_Menu();
DataSet dsMenu = bllMenu.GetList("ID='" + Request.QueryString["ID"] + "'");
nbbMenuNO.Text = dsMenu.Tables[0].Rows[0]["MenuNO"].ToString();
txbMenuName.Text = dsMenu.Tables[0].Rows[0]["MenuName"].ToString();
txbMenuUrl.Text = dsMenu.Tables[0].Rows[0]["MenuUrl"].ToString();
tgbParentName.Text = Request.QueryString["ParentName"].ToString();
//txbImageUrl.Text = dsMenu.Tables[0].Rows[0]["ImageUrl"].ToString();
ddlState.SelectedValue = dsMenu.Tables[0].Rows[0]["State"].ToString();
hdfParentID.Text = dsMenu.Tables[0].Rows[0]["ParentID"].ToString();
hdfParentNO.Text = (int.Parse(nbbMenuNO.Text) - 1).ToString();
}
//保存修改
protected void btnSave_Click(object sender, EventArgs e)
{
#region 逻辑检查
StringBuilder strWhere = new StringBuilder("MenuName='");
strWhere.Append(txbMenuName.Text.ToString());
strWhere.Append("' and ID!='");
strWhere.Append(Request.QueryString["ID"]);
strWhere.Append("'");
BLL.tb_SYS_Menu bllMenu = new BLL.tb_SYS_Menu();
DataSet dsMenu = bllMenu.GetList(strWhere.ToString());
if (dsMenu.Tables[0].Rows.Count > 0)
{
Alert.ShowInTop("该菜单名称已存在", "提示信息", MessageBoxIcon.Error);
return;
}
#endregion
#region 保存数据
Model.tb_SYS_Menu modelMenu = new Model.tb_SYS_Menu();
modelMenu.ID = Request.QueryString["ID"];
modelMenu.MenuNO = nbbMenuNO.Text.ToString();
modelMenu.MenuName = txbMenuName.Text.ToString();
modelMenu.MenuUrl = txbMenuUrl.Text.ToString();
//modelMenu.ImageUrl = txbImageUrl.Text.ToString();
modelMenu.ParentID = hdfParentID.Text.ToString();
modelMenu.State = ddlState.SelectedValue.ToString();
modelMenu.UpdateID = Session["AccountID"].ToString();
modelMenu.UpdateTime = DateTime.Now;
bool result = bllMenu.Update(modelMenu);
if (!result)
{
Alert.ShowInTop("更新失败", "提示信息", MessageBoxIcon.Error, ActiveWindow.GetHideRefreshReference());
}
else
{
Alert.ShowInTop("更新成功", "提示信息", MessageBoxIcon.Information, ActiveWindow.GetHideRefreshReference());
}
#endregion
//关闭本窗体，然后刷新父窗体
//PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
//保存修改
protected void btnSave_Click(object sender, EventArgs e)
{
#region 逻辑检查
BLL.tb_SYS_Menu bllMenu = new BLL.tb_SYS_Menu();
DataSet dsMenu = bllMenu.GetList("MenuName='" + txbMenuName.Text.ToString() + "'");
if (dsMenu.Tables[0].Rows.Count > 0)
{
Alert.ShowInTop("该菜单名称已存在", "提示信息", MessageBoxIcon.Error);
return;
}
#endregion
#region 保存数据
Model.tb_SYS_Menu modelMenu = new Model.tb_SYS_Menu();
modelMenu.ID = Guid.NewGuid().ToString();
modelMenu.MenuNO = nbbMenuNO.Text.ToString();
modelMenu.MenuName = txbMenuName.Text.ToString();
modelMenu.MenuUrl = txbMenuUrl.Text.ToString();
//modelMenu.ImageUrl = txbImageUrl.Text.ToString();
modelMenu.ParentID = hdfParentID.Text.ToString();
modelMenu.State = ddlState.SelectedValue.ToString();
modelMenu.CreateID = Session["AccountID"].ToString();
modelMenu.CreateTime = DateTime.Now;
bool result = bllMenu.Add(modelMenu);
if (!result)
{
Alert.ShowInTop("添加失败", "提示信息", MessageBoxIcon.Error, ActiveWindow.GetHideRefreshReference());
}
else
{
Alert.ShowInTop("添加成功", "提示信息", MessageBoxIcon.Information, ActiveWindow.GetHideRefreshReference());
}
#endregion
//关闭本窗体，然后刷新父窗体
//PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
