コード例 #1
0
        //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();
        }
コード例 #2
0
ファイル: Modify.aspx.cs プロジェクト: Marveliu/erp
        //加载数据
        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();
        }
コード例 #3
0
ファイル: Modify.aspx.cs プロジェクト: Marveliu/erp
        //保存修改
        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());
        }
コード例 #4
0
ファイル: List.aspx.cs プロジェクト: Marveliu/erp
        //删除选中记录集
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            #region  可用
            //int selectedCount = gridMenu.SelectedRowIndexArray.Length;
            //int deletedCount = 0;

            //StringBuilder sb = new StringBuilder();
            //foreach (int row in gridMenu.SelectedRowIndexArray)
            //{
            //    sb.Append("'");
            //    sb.Append(gridMenu.DataKeys[row][0].ToString());
            //    sb.Append("',");
            //}
            //sb.Append("''");

            //BLL.tb_SYS_Menu bllMenu = new BLL.tb_SYS_Menu();
            //bool result = bllMenu.DeleteList(sb.ToString());
            //if(result)
            //{
            //    deletedCount = selectedCount;
            //}
            //Alert.ShowInTop("你选择了" + selectedCount.ToString() + "行\n成功删除" + deletedCount.ToString() + "行");
            //BindGrid();
            #endregion

            #region 2016/01/30修正
            string id = gridMenu.DataKeys[gridMenu.SelectedRowIndex][0].ToString();

            BLL.tb_SYS_Menu bllMenu = new BLL.tb_SYS_Menu();
            string          result  = bllMenu.Delete(id);
            if (result == "0")
            {
                Alert.ShowInTop("删除成功", "提示信息", MessageBoxIcon.Information);
                BindGrid();
            }
            else
            {
                hdfMarkRawNO.Text = gridMenu.SelectedRowIndex.ToString();
                Alert.ShowInTop("该项被其他项引用,不能删除!", "提示信息", MessageBoxIcon.Error, "highlightRows();");
            }
            #endregion
        }
コード例 #5
0
        //保存修改
        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());
        }