private void btnConvertExcel_Click(object sender, EventArgs e)
{
//Class.ExportToExcel.Export2Excel(dgvPrintSaleDayExcel);
com = new SqlCommand();
com.Parameters.Clear();
com.Parameters.Add("@saleDate", SqlDbType.DateTime).Value = Convert.ToDateTime(saleDate);
com.CommandText = strExcelToFormula;
com.CommandType = CommandType.Text;
com.Connection = Conn;
dr = com.ExecuteReader();
DataTable dtFormula = new DataTable();
dtFormula.Load(dr);
dtFormula.Columns["ProductId"].ColumnName = "รหัสสินค้า";
dtFormula.Columns["SaleHeadId"].ColumnName = "ใบยืม";
dtFormula.Columns["SaleDetailQuantity"].ColumnName = "จำนวน";
dtFormula.Columns["SaleDetailPriceUnit"].ColumnName = "ราคาขาย";
dtFormula.Columns["Cash"].ColumnName = "ขายสด";
ds = new DataSet();
ds.Tables.Add(dtFormula);
dr.Close();
Class.ExportToExcel.Export2Excel(ds);
frmCheckSaleDaily frm = new frmCheckSaleDaily();
frm.Close();
}
private void btnConvertExcel_Click(object sender, EventArgs e)
{
Class.ExportToExcel.Export2Excel(dgvPrintSaleMonthExcel);
frmCheckSaleDaily frm = new frmCheckSaleDaily();
frm.Close();
}
