/// <summary>
/// 导出EXCEL
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnToExcel_Click(object sender, EventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
string p_ExportFile = string.Empty;
DataTable dt = (DataTable)gridView1.GridControl.DataSource;
DataTable dtnew = dt.Clone();
if (gridView1.RowFilter != string.Empty)
{
DataRow[] rows = dt.Select(gridView1.RowFilter);
foreach (DataRow row in rows)
{
dtnew.ImportRow(row);
}
}
else
{
dtnew = dt;
}
TemplateExcel.CaiWuDZToExcel(dtnew, txtFormDateE.DateTime.ToString("yyyy-MM-dd"), out p_ExportFile);
this.OpenFileNoConfirm(p_ExportFile);
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void btnXuatExcel_Click(object sender, EventArgs e)
{
if (cbxDate.Text.Trim() != "")
{
string username = cbxUser.SelectedValue.ToString();
string ThangNam = cbxDate.Text.Trim();
DateTime begin;
DateTime end;
DataTable result;
string format = "dd/MM/yyyy HH:mm:ss";
CultureInfo provider = CultureInfo.InvariantCulture;
if (rdNam.Checked)
{
begin = DateTime.ParseExact("01/01/" + ThangNam + " 00:00:00", format, provider);
end = DateTime.ParseExact("31/12/" + ThangNam + " 23:59:59", format, provider);
}
else
{
begin = DateTime.ParseExact("01/" + ThangNam + " 00:00:00", format, provider);
end = DateTime.ParseExact("01/" + ThangNam + " 23:59:59", format, provider).AddMonths(1).AddDays(-1);
}
result = Businesses.statistical.pointStatistical(username, begin, end, rdThang.Checked);
user author = Businesses.user.GetUsername(username);
var info = new DataTable();
info.Columns.Add("exporter");
info.Columns.Add("export_date");
info.Columns.Add("author_username");
info.Columns.Add("author_name");
info.Columns.Add("author_role");
info.Columns.Add("author_birthday");
info.Columns.Add("author_gender");
info.Columns.Add("author_point");
info.Rows.Add(Program.me.name, DateTime.Now.ToString(), author.username, author.name, author.usergroup1.name, author.birthday.Date.ToString("dd/MM/yyyy"), author.gender, author.point.ToString());
info.TableName = "info";
var data = new DataTable();
data.TableName = "data";
data.Columns.Add("date", typeof(string));
data.Columns.Add("income", typeof(string));
data.Columns.Add("spending", typeof(string));
foreach (DataRow row in result.Rows)
{
data.Rows.Add(row["date"], row["income"], row["spending"]);
}
var ds = new DataSet();
ds.Tables.Add(info);
ds.Tables.Add(data);
TemplateExcel.FillReport("export.xlsx", "TemplateTKDT.xlsx", ds, new string[] { "{", "}" });
Process.Start("export.xlsx");
}
}
public void test_01_create_excel_writer()
{
//wtf is dit uberhaupt?
TemplateExcel b = null;
String exception = "";
try
{
b = FileHandlerFactory <TemplateExcel> .create("TemplateExcel");
}catch (Exception e) {
exception = e.ToString();
}
Assert.AreEqual("", exception);
Assert.IsTrue(b != null);
}
/// <summary>
///导出 按制单时间
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnDaoItem_Click(object sender, EventArgs e)
{
try
{
if (chkMakeDate.Checked)
{
DataTable dt = (DataTable)gridView1.GridControl.DataSource;
string exportfile = string.Empty;
string strDate = txtQMakeDateS.DateTime.ToString("yyyy-MM-dd") + "至" + txtQMakeDateE.DateTime.ToString("yyyy-MM-dd");
TemplateExcel.ItemFileToExcel(dt, strDate, out exportfile);
this.OpenFileNoConfirm(exportfile);
FCommon.AddDBLog(this.Text, "导出报表", "", "");
}
else
{
this.ShowMessage("请选择要制单日期！");
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
public void BuildTemplate()
{
TemplateExcel.BuildTemplateOperacao(templateExcel);
}
