private void ShowRequireColumn() { DataTable dt = busReport.LoadImportCaption("admin", "VN", strFunctionID, true); for (int i = 0; i < grvMainData.Columns.Count; i++) { string filter = string.Concat(new string[] { " [Caption] = '" + grvMainData.Columns[i].FieldName.Trim() + "'" }); DataRow[] array = dt.Select(filter); if (array.Length > 0) { if (Convert.ToBoolean(array[0]["IsRequire"])) { grvMainData.Columns[i].AppearanceHeader.ForeColor = Color.Red; } } } }
public static void LoadReportCaption(string username, string language_id, string template, string function_id) { SYS_tblReportCaptionBUS busReport = new SYS_tblReportCaptionBUS(); DataTable dt = busReport.LoadImportCaption(username, language_id, function_id, true); Workbook wb = new Workbook(Temp + string.Format(@"\{0}", template)); Worksheet ws = wb.Worksheets[0]; int index = 0; int count = wb.Worksheets.Count; if (dt != null && dt.Rows.Count > 0) { try { FindOptions opts = new FindOptions(); opts.LookInType = LookInType.Values; opts.LookAtType = LookAtType.EntireContent; for (int i = 0; i < dt.Rows.Count; i++) { Cell cell = ws.Cells.Find("$" + dt.Rows[i]["ControlID"].ToString() + "$", null, opts); if (cell != null) { int column = cell.Column; ws.Replace("$" + dt.Rows[i]["ControlID"].ToString() + "$", dt.Rows[i]["Caption"].ToString()); if (Convert.ToBoolean(dt.Rows[i]["IsList"]) && cell != null) { string tmp = ""; tmp = ws.Cells[cell.Row + 1, cell.Column].Value + ""; DataTable dt2 = busReport.LoadComboDynamicList(username, language_id, "", dt.Rows[i]["TableName"] + "", "Code"); index++; if (dt2 != null && dt2.Rows.Count > 0) { wb.Worksheets[index].Name = dt.Rows[i]["TableName"] + ""; Worksheet ws1 = wb.Worksheets[index]; ws1.Cells.ImportDataTable(dt2, true, 0, 0, true, false); Range range = ws1.Cells.CreateRange(1, 0, dt2.Rows.Count, 1); range.Name = tmp; for (int j = 0; j < dt2.Rows.Count; j++) { AsposeCellsStyle.Cells.BackgroundColor(ws1.Cells[0, j], Color.Yellow); AsposeCellsStyle.Cells.Font.Color(ws1.Cells[0, j], Color.Red); } ws1.AutoFitColumns(); } CellArea cellArea; cellArea.StartRow = 2; cellArea.EndRow = ws.Cells.MaxRow; cellArea.StartColumn = cell.Column; cellArea.EndColumn = cell.Column; ValidationCollection validations = ws.Validations; Validation validation = validations[validations.Add(cellArea)]; validation.Type = ValidationType.List; validation.Operator = OperatorType.None; validation.InCellDropDown = true; validation.Formula1 = "=" + tmp; validation.ShowError = false; validation.AreaList.Add(cellArea); } } if (Convert.ToBoolean(dt.Rows[i]["IsRequire"])) { AsposeCellsStyle.Cells.Font.Color(cell, Color.Red); } } SaveExportCustom(wb, "HellDemons"); } catch (Exception ex) { Logger.Error(ex); return; } } }