public List <SYS_DataGridResult> GetAllGridColList(SYS_DataGridParam param) { #region condtion defined Guid?[] arrDGID = new Guid?[] { }; List <SYS_DataGridResult> ret = new List <SYS_DataGridResult>(); #endregion #region 表格定义配置 WhereClip whereClip = WhereClip.All; ret = this.SelectList <SYS_DataGridResult>(whereClip); if (ret.Count > 0) { arrDGID = ret.Select(a => a.DGGUID).ToArray(); } else { return(ret); } #endregion #region index defined Guid?companyID = this.SessionInfo.CompanyID; Guid?userGuid = this.SessionInfo.UserGuid; List <SYS_UserGridColIndex> colIdxList = this.SelectList <SYS_UserGridColIndex>(SYS_UserGridColIndex._.DGGUID.In(arrDGID) && SYS_UserGridColIndex._.CompanyID == companyID && SYS_UserGridColIndex._.UserGUID == userGuid , SYS_UserGridColIndex._.DGGUID.Asc && SYS_UserGridColIndex._.DisplayIndex.Asc); List <SYS_UserGridColIndex> findIdxList = null; foreach (SYS_DataGridResult info in ret) { findIdxList = colIdxList.Where(a => a.DGGUID == info.DGGUID).ToList(); info.ColIndexList = findIdxList; } #endregion #region width defined List <SYS_UserGridColWidth> colWdthList = this.SelectList <SYS_UserGridColWidth>(SYS_UserGridColWidth._.DGGUID.In(arrDGID) && SYS_UserGridColWidth._.CompanyID == companyID && SYS_UserGridColWidth._.UserGUID == userGuid , SYS_UserGridColWidth._.DGGUID.Asc && SYS_UserGridColWidth._.CWID.Asc); List <SYS_UserGridColWidth> findWdthList = null; foreach (SYS_DataGridResult info in ret) { findWdthList = colWdthList.Where(a => a.DGGUID == info.DGGUID).ToList(); info.ColWidthList = findWdthList; } #endregion #region name defined List <SYS_UserGridColName> colNameList = this.SelectList <SYS_UserGridColName>(SYS_UserGridColName._.DGGUID.In(arrDGID) && SYS_UserGridColName._.CompanyID == companyID , SYS_UserGridColName._.DGGUID.Asc && SYS_UserGridColName._.CNID.Asc); List <SYS_UserGridColName> findNameList = null; foreach (SYS_DataGridResult info in ret) { findNameList = colNameList.Where(a => a.DGGUID == info.DGGUID).ToList(); info.ColNameList = findNameList; } #endregion return(ret); }
public void GetGridColListInForm(List <UcDataGridView> lstDgv) { _isFormPeriod = true; #region 获取相关的参数 List <string> lstGridNames = new List <string>(); List <string> lstFormName = new List <string>(); List <string> lstUConName = new List <string>(); string name = ""; foreach (UcDataGridView dgv in lstDgv) { lstGridNames.Add(dgv.Name); name = dgv.FindForm().Name; if (!lstFormName.Contains(name)) { lstFormName.Add(dgv.FindForm().Name); } Control parentCon = dgv.Parent; while (parentCon != null && parentCon.GetType().BaseType != typeof(ucBaseUserControl)) { parentCon = parentCon.Parent; } if (parentCon != null) { name = (parentCon as ucBaseUserControl).Name; if (!lstUConName.Contains(name)) { lstUConName.Add(name); } } } #endregion #region 设置相关窗体表格变量 SYS_DataGridParam param = new SYS_DataGridParam() { ParentNames = lstUConName.ToArray(), GridNames = lstGridNames.ToArray(), FormNames = lstFormName.ToArray() }; ExeResult rst = WCFBLL.Execute("ZNLCRM.BLL.Sys.SYS_DataGridBLL", "GetGridColList", param); if (rst.Complete == ExeComplete.ErrorEx) { MessageBox.Show(rst.DebugMsg, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (rst.Complete == ExeComplete.WarnEx) { MessageBox.Show(rst.Message, "警告提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (rst.Complete == ExeComplete.Succeed) { DataGridSettingInForm = rst.Result as List <SYS_DataGridResult>; } #endregion }
private void GetGridColSetList(SYS_DataGridParam param) { List <SYS_DataGridResult> ret = new List <SYS_DataGridResult>(); ExeResult rst = WCFBLL.Execute("ZNLCRM.BLL.Sys.SYS_DataGridBLL", "GetGridColList", param); if (rst.Complete == ExeComplete.ErrorEx) { MessageBox.Show(rst.DebugMsg, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (rst.Complete == ExeComplete.WarnEx) { MessageBox.Show(rst.Message, "警告提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (rst.Complete == ExeComplete.Succeed) { ret = rst.Result as List <SYS_DataGridResult>; SetDataGridSettingVar(ret); } }
public List <SYS_DataGridResult> GetGridColList(SYS_DataGridParam param) { #region condtion defined Guid?[] arrDGID = new Guid?[] { }; List <SYS_DataGridResult> ret = new List <SYS_DataGridResult>(); if (param.GridNames == null || param.FormNames == null || param.ParentNames == null || param.GridNames.Length <= 0 || param.FormNames.Length <= 0 || param.ParentNames.Length <= 0) { throw new WarnException("请指定表格条件!"); } #endregion #region 表格定义配置 WhereClip whereClip = WhereClip.All; string[] parentNames = param.ParentNames.Where(a => a != null).ToArray(); whereClip = whereClip && SYS_DataGrid._.GridName.In(param.GridNames) && SYS_DataGrid._.FormName.In(param.FormNames); if (parentNames.Length > 0) { whereClip = whereClip && SYS_DataGrid._.ParentName.In(parentNames); } ret = this.SelectList <SYS_DataGridResult>(whereClip); if (ret.Count > 0) { arrDGID = ret.Select(a => a.DGGUID).ToArray(); } else { return(ret); } #endregion #region index defined Guid?companyID = this.SessionInfo.CompanyID; Guid?userGuid = this.SessionInfo.UserGuid; List <SYS_UserGridColIndex> colIdxList = this.SelectList <SYS_UserGridColIndex>(SYS_UserGridColIndex._.DGGUID.In(arrDGID) && SYS_UserGridColIndex._.CompanyID == companyID && SYS_UserGridColIndex._.UserGUID == userGuid , SYS_UserGridColIndex._.DisplayIndex.Asc); List <SYS_UserGridColIndex> findIdxList = null; foreach (SYS_DataGridResult info in ret) { findIdxList = colIdxList.Where(a => a.DGGUID == info.DGGUID).ToList(); info.ColIndexList = findIdxList; } #endregion #region width defined List <SYS_UserGridColWidth> colWdthList = this.SelectList <SYS_UserGridColWidth>(SYS_UserGridColWidth._.DGGUID.In(arrDGID) && SYS_UserGridColWidth._.CompanyID == companyID && SYS_UserGridColWidth._.UserGUID == userGuid , SYS_UserGridColWidth._.CWID.Asc); List <SYS_UserGridColWidth> findWdthList = null; foreach (SYS_DataGridResult info in ret) { findWdthList = colWdthList.Where(a => a.DGGUID == info.DGGUID).ToList(); info.ColWidthList = findWdthList; } #endregion #region name defined List <SYS_UserGridColName> colNameList = this.SelectList <SYS_UserGridColName>(SYS_UserGridColName._.DGGUID.In(arrDGID) && SYS_UserGridColName._.CompanyID == companyID , SYS_UserGridColName._.CNID.Asc); List <SYS_UserGridColName> findNameList = null; foreach (SYS_DataGridResult info in ret) { findNameList = colNameList.Where(a => a.DGGUID == info.DGGUID).ToList(); info.ColNameList = findNameList; } #endregion return(ret); }