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; }
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 } }