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