private void btnIn_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] { new DataColumn("DTPN"), new DataColumn("TK"), new DataColumn("LOAI_CT"), new DataColumn("SO_CT"), new DataColumn("NGAY_CT"),
new DataColumn("SO_HOADON"), new DataColumn("NGAY_HOADON"),new DataColumn("TEN_KH"),new DataColumn("NGUOI_GD"), new DataColumn("MA_CTRINH"),
new DataColumn("MADM"), new DataColumn("DIENGIAI"), new DataColumn("DONVI"), new DataColumn("SOLUONG", System.Type.GetType("System.Double")), new DataColumn("DAI"), new DataColumn("RONG"),
new DataColumn("SOM2"), new DataColumn("DONGIA", System.Type.GetType("System.Double")), new DataColumn("TKDU")
, new DataColumn("NO_VND",System.Type.GetType("System.Double")), new DataColumn("CO_VND", System.Type.GetType("System.Double")), new DataColumn("NO_USD", System.Type.GetType("System.Double")), new DataColumn("CO_USD", System.Type.GetType("System.Double")) });
_db = new dbVstoreAppDataContext(Const.builder.ConnectionString);
var list = this._db.KT_CTuGocs.Where(u => u.NGAY_CTU.Value != null && u.NGAY_CTU.Value.Date >= dtpTuNgay.Value.Date && u.NGAY_CTU.Value.Date <= dtpDenngay.Value.Date
&& (u.TK_NO == cboTaikhoan.Text || cboTaikhoan.Text == "") && (u.MA_DTPN_NO == cboMaDT.Text || cboMaDT.Text == ""));
foreach (var item in list)
{
DataRow dr = dt.NewRow();
dr["DTPN"] = item.MA_DTPN_NO;
dr["MA_CTRINH"] = item.MA_CTRINH;
dr["TK"] = item.TK_NO;
dr["LOAI_CT"] = item.MA_CTU;
dr["SO_CT"] = item.SO_CTU;
dr["NGAY_CT"] = item.NGAY_CTU;
dr["SO_HOADON"] = item.HD_SO;
dr["NGAY_HOADON"] = item.HD_NGAY;
dr["TEN_KH"] = item.TEN_KH;
dr["NGUOI_GD"] = item.TEN_KH_GD;
dr["MADM"] = item.MA_DM_XUAT;
dr["DIENGIAI"] = item.DIEN_GIAI;
dr["DONVI"] = item.DON_VI1;
dr["SOLUONG"] = Utils.CDblDef(item.SO_LUONG, 0);
dr["DAI"] = "";
dr["RONG"] = "";
dr["SOM2"] = "";
dr["DONGIA"] = Utils.CDblDef(item.DON_GIA_VND, 0);
dr["TKDU"] = item.TK_CO == cboTaikhoan.Text ? item.TK_NO : item.TK_CO;
dr["NO_VND"] = item.TK_NO == cboTaikhoan.Text ? Utils.CDblDef(item.THANH_TIEN_VND, 0) : 0;
dr["CO_VND"] = item.TK_CO == cboTaikhoan.Text ? Utils.CDblDef(item.THANH_TIEN_VND, 0) : 0;
dr["NO_USD"] = Utils.CDblDef(50000, 0);
dr["CO_USD"] = Utils.CDblDef(50000, 0);
dt.Rows.Add(dr);
}
ExcelUtlity Utlity = new ExcelUtlity();
if(rdMauchuan.Checked)
Utlity.WriteDataTableToExcel_SOCTCN11_Mauchuan(dt, cboTaikhoan.Text, cboMaDT.Text, dtpTuNgay.Value, dtpDenngay.Value, dtNgayin.Value);
else if(rdInchitietquycach.Checked)
Utlity.WriteDataTableToExcel_SOCTCN30_InChiTietQuyCach(dt, cboTaikhoan.Text, cboMaDT.Text, dtpTuNgay.Value, dtpDenngay.Value, dtNgayin.Value);
else if (rdViewtatcaDT.Checked)
Utlity.WriteDataTableToExcel_SOCTCN11_03_V_ViewtatcaDT(dt, list, dtpTuNgay.Value, dtpDenngay.Value, dtNgayin.Value);
else if (rdSubtotaltheochungtu.Checked)
Utlity.WriteDataTableToExcel_SOCTCN11_04_V_Subtotaltheochungtu(dt, list, cboTaikhoan.Text, cboMaDT.Text, dtpTuNgay.Value, dtpDenngay.Value, dtNgayin.Value);
else if (rdSubtotaltheothang.Checked)
Utlity.WriteDataTableToExcel_SOCTCN11_05_V_Subtotaltheothang(dt, cboTaikhoan.Text, cboMaDT.Text, dtpTuNgay.Value, dtpDenngay.Value, dtNgayin.Value);
else if (rdSubtotaltheocongtrinh.Checked)
Utlity.WriteDataTableToExcel_SOCTCN11_06_V_Subtotaltheocongtrinh(dt, cboTaikhoan.Text, cboMaDT.Text, dtpTuNgay.Value, dtpDenngay.Value, dtNgayin.Value);
else
Utlity.WriteDataTableToExcel_SOCTCN11_Mauchuan(dt, cboTaikhoan.Text, cboMaDT.Text, dtpTuNgay.Value, dtpDenngay.Value, dtNgayin.Value);
}
