private void Data()
{
SqlDataReader rdr = null;
SqlCommand cmd = new SqlCommand("SHOWALL_STATEMENT_INFO", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@P_CustomerName", SqlDbType.NVarChar).Value = Customer_name.Trim();
cmd.Parameters.Add("@P_StartDate", SqlDbType.DateTime).Value = Start_Date.ToString("dd/MM/yyyy 00:00");
cmd.Parameters.Add("@P_EndDate", SqlDbType.DateTime).Value = End_Date.ToString("dd/MM/yyyy 23:59");
rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
DataTable dtPoHard = new DataTable();
dtPoHard.Load(rdr);
//dgvStatementHeadData.DataSource = dtPoHard;
Statement.CtrStatementDetailReport Ctr = new CtrStatementDetailReport();
Ctr.SetDataSource(dtPoHard);
CrvStatementDetail.ReportSource = Ctr;
CrvStatementDetail.Refresh();
CrvStatementDetail.Show();
}
//lblCheckSale.Text = "พบ : " + CheckResult.ToString() + " รายการ";
rdr.Close();
//CalculatePayMoney();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CtrStatementDetailReport rpt = new CtrStatementDetailReport();
rpt.Site = this.Site;
return rpt;
}