private void tsbExp_Click(object sender, EventArgs e) { SaveFileDialog dia = new SaveFileDialog(); dia.DefaultExt = "xls"; if (DialogResult.OK == dia.ShowDialog()) { GridError.SaveExcel(dia.FileName, "科目对应错误信息", FileFlags.AsDisplayed); } }
/// <summary> /// 设置列表显示样式 /// </summary> private void SetGridStyle() { //GridError.Cols["line"].Caption = "行号"; //GridError.Cols["acc"].Caption = "科目编码"; //GridError.Cols["name"].Caption = "科目名称"; //GridError.Cols["type"].Caption = "错误信息描述"; //GridError.Cols["auto"].Caption = "是否可自动添加科目"; GridError.Cols[1].Name = "acc"; GridError.Cols[2].Name = "name"; GridError.Cols[3].Name = "type"; GridError.Cols[4].Name = "auto"; GridError.Cols["acc"].TextAlign = TextAlignEnum.LeftCenter; GridError.Cols[1].Caption = "科目编码"; GridError.Cols[2].Caption = "科目名称"; GridError.Cols[3].Caption = "错误信息描述"; GridError.Cols[4].Caption = "是否可自动添加科目"; Hashtable htMapType = new Hashtable(); htMapType["0"] = "财务科目不存在"; htMapType["1"] = "财务科目非末级"; htMapType["2"] = "财务科目为空"; htMapType["3"] = "财务科目对应多个外部科目"; Hashtable htMapAuto = new Hashtable(); htMapAuto["0"] = "否"; htMapAuto["1"] = "是"; GridError.Cols["type"].DataMap = htMapType; GridError.Cols["auto"].DataMap = htMapAuto; for (int i = 0; i < GridError.Rows.Count; i++) { GridError.Rows[i].Height = 25; if (i >= GridError.Rows.Fixed) { GridError.Rows[i][0] = i - GridError.Rows.Fixed + 1; } } GridError.ExtendLastCol = true; GridError.AllowEditing = false; GridError.AutoSizeCols(); }