public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
Total_Balance_Payment_All rpt = new Total_Balance_Payment_All();
rpt.Site = this.Site;
return(rpt);
}
public void ExportReport_Mod_II(Total_Balance_Payment_All rpt)
{
/* Create Main Folder for Detected Images of Contact Leasing */
string mainDirectory = "Total_Balance_Payment";
string mainDirectoryPath = "C:/ReportExport/" + mainDirectory;
if (!Directory.Exists(mainDirectoryPath))
{
Directory.CreateDirectory(mainDirectoryPath);
}
string FilePath = "C:/ReportExport/" + mainDirectory + "/รายงานลูกหนี้คงค้างทั้งหมด_" + DateTimeUtility._dateToFile() + ".pdf";
if (File.Exists(FilePath))
{
File.Delete(FilePath);
}
/// Export Report to PDF File with Save As Mode
rpt.ExportToDisk(ExportFormatType.PortableDocFormat, @"C:/ReportExport/" + mainDirectory + "/รายงานลูกหนี้คงค้างทั้งหมด_" + DateTimeUtility._dateToFile() + ".pdf");
/// Display PDF File to PDF Program
/// Process process = new Process();
/// process.StartInfo.UseShellExecute = true;
/// process.StartInfo.FileName = FilePath;
/// process.Start();
WebClient User = new WebClient();
Byte[] FileBuffer = User.DownloadData(FilePath);
if (FileBuffer != null)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-length", FileBuffer.Length.ToString());
Response.BinaryWrite(FileBuffer);
}
User.Dispose();
rpt.Dispose();
GC.Collect();
}
private void _loadReport()
{
string deposit_no = (string)Session["deposit_no_rpt"];
string leasing_no = (string)Session["leasing_no_rpt"];
string idcard = (string)Session["idcard_rpt"];
string fname = (string)Session["fname_rpt"];
string lname = (string)Session["lname_rpt"];
string lost_str = (string)Session["lost_str_rpt"];
string lost_end = (string)Session["lost_end_rpt"];
string district = (string)Session["district_rpt"];
string province = (string)Session["province_rpt"];
string leasing_Code_inline = (string)Session["leasing_Code_inline_rpt"];
string Company_id_inline = (string)Session["Company_id_inline_rpt"];
string zone_id_inline = (string)Session["zone_id_inline_rpt"];
string report_header = " รายงานลูกหนี้คงเหลือ ";
bool chk_all = false;
if (leasing_Code_inline == "" && Company_id_inline == "" && zone_id_inline == "")
{
report_header = " รายงานลูกหนี้คงเหลือ (ทั้งหมด)";
chk_all = true;
}
package_login = (Base_Companys)Session["Package"];
acc_lgn = (Account_Login)Session["Login"];
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand("rpt_total_balance", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@i_Deps_no", deposit_no);
cmd.Parameters.AddWithValue("@i_Leasing_no", leasing_no);
cmd.Parameters.AddWithValue("@i_Cust_idcard", idcard);
cmd.Parameters.AddWithValue("@i_Cust_Fname", fname);
cmd.Parameters.AddWithValue("@i_Cust_LName", lname);
cmd.Parameters.AddWithValue("@i_Leasing_date_str", "");
cmd.Parameters.AddWithValue("@i_Leasing_date_end", "");
cmd.Parameters.AddWithValue("@i_Leasing_code_id", leasing_Code_inline);
cmd.Parameters.AddWithValue("@i_Company_id", Company_id_inline);
cmd.Parameters.AddWithValue("@i_Zone_id", zone_id_inline);
cmd.Parameters.AddWithValue("@i_lost_str", lost_str);
cmd.Parameters.AddWithValue("@i_lost_end", lost_end);
cmd.Parameters.AddWithValue("@i_district", district);
cmd.Parameters.AddWithValue("@i_province", province);
cmd.Parameters.AddWithValue("@i_row_str", 0);
cmd.Parameters.AddWithValue("@i_row_limit", 0);
MySqlDataReader reader = cmd.ExecuteReader();
Leasing_Ds ls_ds = new Leasing_Ds();
ls_ds.Clear();
ls_ds.Tables["Report_General_Leasings"].Load(reader);
if (chk_all)
{
Total_Balance_Payment_All rpt = new Total_Balance_Payment_All();
rpt.SetDataSource(ls_ds);
rpt.SetParameterValue("Reported_By_User", "ออกโดย : " + acc_lgn.Account_F_name);
rpt.SetParameterValue("Reported_Print_Date", "วันที่พิมพ์ : " + DateTimeUtility.convertDateTimeToPage(DateTimeUtility._dateTimeNOWForServer()));
rpt.SetParameterValue("Report_Header", report_header);
CRV_Display_Report.ReportSource = rpt;
/// Export Report to PDF File with Save As Mode
/// rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "หน้าการ์ด_" + cls.Deps_no);
/// Response.End();
ExportReport_Mod_II(rpt);
}
else
{
Total_Balance_Payment rpt = new Total_Balance_Payment();
rpt.SetDataSource(ls_ds);
rpt.SetParameterValue("Reported_By_User", "ออกโดย : " + acc_lgn.Account_F_name);
rpt.SetParameterValue("Reported_Print_Date", "วันที่พิมพ์ : " + DateTimeUtility.convertDateTimeToPage(DateTimeUtility._dateTimeNOWForServer()));
rpt.SetParameterValue("Report_Header", report_header);
CRV_Display_Report.ReportSource = rpt;
/// Export Report to PDF File with Save As Mode
/// rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "หน้าการ์ด_" + cls.Deps_no);
/// Response.End();
ExportReport_Mod_I(rpt);
}
}
catch (MySqlException ex)
{
error = "MysqlException ==> Total_Balance_Payment_Export --> _loadReport() ";
Log_Error._writeErrorFile(error, ex);
}
catch (Exception ex)
{
error = "Exception ==> Total_Balance_Payment_Export --> _loadReport() ";
Log_Error._writeErrorFile(error, ex);
}
finally
{
con.Close();
con.Dispose();
}
/// Acticity Logs System
///
string message = Messages_Logs._messageLogsNormal(acc_lgn.Account_F_name, " ออก" + report_header, acc_lgn.resu, package_login.Company_N_name);
new Activity_Log_Manager().addActivityLogs(message, acc_lgn.Account_id, package_login.Company_id);
/// Acticity Logs System
GC.Collect();
}
