private void _loadReport_mod_II()
{
string month = (string)Session["month"];
string year = (string)Session["year"];
string Company_id_inline = (string)Session["Company_id_inline_rpt"];
string leasing_Code_inline = (string)Session["leasing_Code_inline_rpt"];
string zone_id_inline = (string)Session["zone_id_inline_rpt"];
string report_header = "รายงานการชำระเงิน 2 ประจำเดือน " + DateTimeUtility.convertMonthToThai(month) + " " + (Convert.ToInt32(year) + 543);
package_login = (Base_Companys)Session["Package"];
acc_lgn = (Account_Login)Session["Login"];
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand("rpt_real_payment_monthly", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@i_month", month);
cmd.Parameters.AddWithValue("@i_year", year);
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_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_Payments"].Load(reader);
Payment_Summary_Monthly_mod_II rpt = new Payment_Summary_Monthly_mod_II();
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);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Payment_Summary_Monthly_Export --> _loadReport_mod_II() ";
Log_Error._writeErrorFile(error, ex);
}
catch (Exception ex)
{
error = "Exception ==> Payment_Summary_Monthly_Export --> _loadReport_mod_II() ";
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();
}
