Exemplo n.º 1
0
 private void LoadFunction()
 {
     if (grdvGroup.GetRowCellValue(grdvGroup.FocusedRowHandle, colGroupID) != null)
     {
         busFunction = new BUS.BUStblFUNCTION();
         busGroupFunction = new BUS.BUStblGROUP_FUNCTION();
         busModule = new BUS.BUStblMODULE();
         int _groupID = (int)grdvGroup.GetRowCellValue(grdvGroup.FocusedRowHandle, colGroupID);
         var _Func = (from a in busGroupFunction.LayTatCatblGROUP_FUNCTION()
                      join b in busModule.LayTatCatblMODULE() on a.MODULEID equals b.MODULEID
                      join c in busFunction.LayTatCatblFUNCTION() on a.FUNCTIONID equals c.FUNCTIONID
                      where a.GROUPID == _groupID
                      orderby a.MODULEID ascending
                      select new
                      {
                          ModuleID = a.MODULEID,
                          ModuleName = b.MODULENAME,
                          FunctionID = a.FUNCTIONID,
                          FunctionName = c.FUNCTIONNAME,
                          Value = a.VALUE
                      });
         DataTable dt = clsXuLy.ConvertDataTable(_Func.ToList());
         grdFunction.DataSource = dt;
     }
     else
         grdFunction.DataSource = null;
 }
Exemplo n.º 2
0
        private void btnThem_Click(object sender, EventArgs e)
        {
            string _GroupName = "";
            frmAddGroup frm = new frmAddGroup();
            frm.ShowDialog();
            if (frm.txtGroupName.Text.Trim() != "")
            {
                _GroupName = frm.txtGroupName.Text;
                busGroupFunction = new BUS.BUStblGROUP_FUNCTION();
                var _busGroup = new BUS.BUStblGROUP();
                var _dtoGroup = new DTO.DTOtblGROUP();
                busFunction = new BUS.BUStblFUNCTION();
                _dtoGroup.GROUPNAME = _GroupName;
                _busGroup.ThemtblGROUP(_dtoGroup);
                LoadGroup();
                int _groupID = _busGroup.LayTatCatblGROUP().OrderBy(a => a.GROUPID).Last().GROUPID;

                #region Them FUNCTION
                var lst = (List<DTO.DTOtblFUNCTION>)busFunction.LayTatCatblFUNCTION();
                for (int i = 0; i < lst.Count; i++)
                {
                    var _dtoGroupFunction = new DTO.DTOtblGROUP_FUNCTION();
                    _dtoGroupFunction.GROUPID = _groupID;
                    _dtoGroupFunction.MODULEID = lst[i].MODULEID;
                    _dtoGroupFunction.FUNCTIONID = lst[i].FUNCTIONID;
                    _dtoGroupFunction.VALUE = false;
                    busGroupFunction.ThemtblGROUP_FUNCTION(_dtoGroupFunction);
                }
                #endregion

                #region Them MODULE
                var lstModule = busModule.LayTatCatblMODULE().ToList();
                for (int i = 0; i < lstModule.Count; i++)
                {
                    var _dtoGroupModule = new DTO.DTOtblGROUPMODULE();
                    _dtoGroupModule.GROUPID = _groupID;
                    _dtoGroupModule.MODULEID = lstModule[i].MODULEID;
                    _dtoGroupModule.VALUE = false;
                    busGroupModule.ThemtblGROUPMODULE(_dtoGroupModule);
                }
                #endregion
            }
        }