private void DisplayReportProductMovement() { ReportDocument cryRpt = new ReportDocument(); List <RPT_STOCK_MOV_4127> rt_RPT_STOCK_MOV = new List <RPT_STOCK_MOV_4127>(); rt_RPT_STOCK_MOV = Reports.RPT_STOCK_MOV_4127(string.Empty, CV_Code, CountStockDate_From, CountStockDate_To, ProductGroup, Size, string.Empty, string.Empty, string.Empty, string.Empty); foreach (var d in rt_RPT_STOCK_MOV) { d.pramCV_Code = CV_Code; if (d.pramCV_Code == "") { d.pramCV_Code = "ทั้งหมด"; } if (CV_Code == "") { d.pramAgent_Name = "ทั้งหมด"; } else { dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(CV_Code); d.pramAgent_Name = _agent.AgentName; } d.pramDate_From = CountStockDate_From; d.pramDate_To = CountStockDate_To; d.pramProduct_group = ProductGroup; if (d.pramProduct_group == "") { d.pramProduct_group = "เลือกทั้งหมด"; } d.pramSize = Size; if (d.pramSize == "") { d.pramSize = "เลือกทั้งหมด"; } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportProductMovement.rpt")); cryRpt.SetDataSource(rt_RPT_STOCK_MOV); ReportViewer.ToolPanelView = ToolPanelViewType.None; ReportViewer.HasCrystalLogo = false; //this.ReportViewer.PrintMode = PrintMode.ActiveX; ReportViewer.ReportSource = cryRpt; ReportViewer.RefreshReport(); //BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); //Response.ClearContent(); //Response.ClearHeaders(); //Response.ContentType = "application/pdf"; //Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length)).ToArray()); //Response.Flush(); //Response.Close(); }
private void DisplayReportDN_CN() { //ReportDocument cryRpt = new ReportDocument(); List <RPT_DN_CN_41224> rt_RPT_DN_CN = new List <RPT_DN_CN_41224>(); rt_RPT_DN_CN = Reports.RPT_DN_CN_41224(Region, AgentName, string.Empty, InvoiceDate, InvoiceDateTo, ddlType, CN_DN, Status, string.Empty); foreach (var d in rt_RPT_DN_CN) { d.paramRegion_Name = Request.QueryString["Region"]; if (d.paramRegion_Name == "") { d.paramRegion_Name = "เลือกทั้งหมด"; } if (AgentName != "") { _agent = dbo_AgentDataClass.Select_Record(AgentName); d.pramAgent_Name = _agent.AgentName; } else { d.pramAgent_Name = "เลือกทั้งหมด"; } d.pramDocNo = Request.QueryString["DebtID"]; d.pramType = Request.QueryString["ddlType"]; if (d.pramType == "") { d.pramType = "เลือกทั้งหมด"; } d.pramDebt_StartDate = Request.QueryString["InvoiceDate"]; d.pramDebt_EndDate = Request.QueryString["InvoiceDateTo"]; d.pramStatus = Request.QueryString["Status"]; if (d.pramStatus == "") { d.pramStatus = "เลือกทั้งหมด"; } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportReduceDebt.rpt")); cryRpt.SetDataSource(rt_RPT_DN_CN); ReportViewer1.ToolPanelView = ToolPanelViewType.None; ReportViewer1.HasCrystalLogo = false; ReportViewer1.ReportSource = cryRpt; ReportViewer1.RefreshReport(); //BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); //Response.ClearContent(); //Response.ClearHeaders(); //Response.ContentType = "application/pdf"; //Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length))); //Response.Flush(); //Response.Close(); }
private void DisplayReportReduceDebt_CustomerAndSP() { ReportDocument cryRpt = new ReportDocument(); connDB = new ConnectionManager(); List <RPT_SP_DEBT_41221> rt_RPT_CUSTOMER_SP = new List <RPT_SP_DEBT_41221>(); rt_RPT_CUSTOMER_SP = Reports.RPT_SP_DEBT_41221(Region, AgentName, SPName, DebtID, DebtName, DebtDate_From, DebtDate_To, Status, string.Empty, string.Empty); foreach (var d in rt_RPT_CUSTOMER_SP) { d.paramRegion_Name = Request.QueryString["Region"]; if (d.paramRegion_Name == "") { d.paramRegion_Name = "เลือกทั้งหมด"; } if (AgentName != "") { _agent = dbo_AgentDataClass.Select_Record(AgentName); d.pramAgent_Name = _agent.AgentName; } else { d.pramAgent_Name = "เลือกทั้งหมด"; } d.pramSP_Name = Request.QueryString["SPName"]; d.pramDebt_StartDate = Request.QueryString["DebtDate_From"]; d.pramDebt_EndDate = Request.QueryString["DebtDate_To"]; d.pramStatus = Request.QueryString["Status"]; if (d.pramStatus == "") { d.pramStatus = "เลือกทั้งหมด"; } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportReduceDebt_CustomerAndSP.rpt")); cryRpt.SetDataSource(rt_RPT_CUSTOMER_SP); ReportViewer1.ToolPanelView = ToolPanelViewType.None; ReportViewer1.HasCrystalLogo = false; ReportViewer1.ReportSource = cryRpt; ReportViewer1.RefreshReport(); //BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); //Response.ClearContent(); //Response.ClearHeaders(); //Response.ContentType = "application/pdf"; //Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length))); //Response.Flush(); //Response.Close(); }
private void SetUpDrowDownList() { try { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); dbo_AgentClass clsdbo_Agent = dbo_AgentDataClass.Select_Record(user_class.CV_CODE); ViewState["CV_Code"] = clsdbo_Agent == null ? string.Empty : clsdbo_Agent.CV_Code; pnlForm.Visible = false; pnlGrid.Visible = true; List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty , string.Empty, string.Empty, string.Empty, clsdbo_Agent == null ? string.Empty : clsdbo_Agent.CV_Code, null, string.Empty, string.Empty) .Where(f => f.Status == "Active") .Where(f => f.Position == "ซุปเปอร์ไวซ์เซอร์" || f.Position == "สาวส่งนม").ToList(); users.Insert(0, new dbo_UserClass() { FullName = "==ระบุ==", User_ID = string.Empty }); ddlSearchSP.DataSource = users; ddlSearchSP.DataBind(); txtSum.Text = string.Empty; if (grdCommission.Rows.Count > 0) { List <dbo_ClearingClass> item = new List <dbo_ClearingClass>(); grdCommission.DataSource = item; grdCommission.DataBind(); } ddlStatus.SelectedIndex = 0; txtClearing_No.Text = string.Empty; txtRequisition_No.Text = string.Empty; txtSearchClearing_Date_Begin.Text = DateTime.Now.ToShortDateString(); txtSearchClearing_Date_End.Text = DateTime.Now.ToShortDateString(); txtRequistionStart.Text = DateTime.Now.ToShortDateString(); txtRequistionEnd.Text = DateTime.Now.ToShortDateString(); } catch (Exception ex) { logger.Error(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); dbo_AgentClass clsdbo_Agent = dbo_AgentDataClass.Select_Record(user_class.CV_CODE); if (user_class.User_Group_ID != "Agent") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", "history.back();", true); } btnSearchSubmit_Click(sender, e); } txtStartDate.Text = DateTime.Now.ToShortDateString(); txtEndDate.Text = DateTime.Now.ToShortDateString(); }
private void SetUpDrowDownList() { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); try { //ddlAgentName List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty); dbo_AgentClass a = new dbo_AgentClass(); a.Prefix_ID = "เลือกทั้งหมด"; a.CV_Code = string.Empty; agent.Insert(0, a); ddlAgentName.DataSource = agent; ddlAgentName.DataBind(); } catch (Exception ex) { logger.Error(ex); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { dbo_UserClass user_class = dbo_UserDataClass.Select_Record(Request.Cookies["User_ID"].Value); if (user_class.User_Group_ID != "Agent") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", "history.back();", true); } else { dbo_AgentClass agent = dbo_AgentDataClass.Select_Record(user_class.CV_CODE); label_agent_name.Text = agent.AgentName; show_grid(user_class.CV_CODE); lblValue.Text = System.Convert.ToString(string.Format("{0:#,##0.00}", Grand_Total)); } } }
protected void GenerateReport(string RPT, string PRM, string Region, string AgentName, string Month_From, string Month_To, string Year, string ProductGroup, string Size, string Unit, string SPName, string CV_Code, string ProductName, string Temp1) { try { ReportDocument cryRpt = new ReportDocument(); string User_ID = Request.Cookies["User_ID"].Value; switch (RPT) { case "Requisition_No": List <RPT_Get_Requisition_No> rt_rqt = new List <RPT_Get_Requisition_No>(); dbo_AgentClass clsdbo_Agent = dbo_AgentDataClass.Select_Record(CV_Code); //dbo_RequisitionClearingClass rq_cl = dbo_RequisitionClearingDataClass.Search(string.Empty, string.Empty, string.Empty,null,null,null,null,string.Empty); List <dbo_RequisitionClearingClass> item = dbo_RequisitionClearingDataClass.Search(string.Empty, string.Empty, string.Empty, null, null, null, null, CV_Code); if (PRM == null) { rt_rqt = Reports.RPT_Get_Requisition_No_Search(PRM, SPName.Substring(0, 11)); logger.Debug("SPName " + SPName); if (SPName != "==ระบุ==") { // foreach (var d in rt_rqt) // { // d.AgentName = AgentName; // d.sp_name = SPName.Substring(11); // d.User_SP = SPName.Substring(0, 10); // d.Invoice_Address = clsdbo_Agent.Adress_Agent; // d.Tax_ID = clsdbo_Agent.Tax_ID; // } logger.Debug("before sending report"); cryRpt.Load(Server.MapPath("~/Report_From/RT_Requisition_DOC001.rpt")); cryRpt.SetDataSource(rt_rqt); } else { // Response.Redirect("กรุณาเลือกพนักงานขาย"); string script = "alert(\"กรุณาเลือกพนักงานขาย\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } else { rt_rqt = Reports.RPT_Get_Requisition_No_Search(PRM, string.Empty); int rqt_clm_tmp = rt_rqt.Where(f => f.clm_6 != 0 || f.clm_7 != 0 || f.clm_8 != 0 || f.clm_9 != 0 || f.clm_10 != 0).Count(); if (rqt_clm_tmp != 0) { cryRpt.Load(Server.MapPath("~/Report_From/RT_Requisition_DOC002.rpt")); cryRpt.SetDataSource(rt_rqt); } else { cryRpt.Load(Server.MapPath("~/Report_From/RT_Requisition_DOC001.rpt")); cryRpt.SetDataSource(rt_rqt); } } break; case "PO_Number": List <RPT_Get_PO_Number> rt_po = new List <RPT_Get_PO_Number>(); rt_po = Reports.RPT_Get_PO_Number_Search(PRM); cryRpt.Load(Server.MapPath("~/Report_From/RT_PO_DOC001.rpt")); cryRpt.SetDataSource(rt_po); break; case "Clearing_No": List <RPT_Get_Clearing_No> rt_clearing = new List <RPT_Get_Clearing_No>(); rt_clearing = Reports.RPT_Get_Clearing_No(PRM); cryRpt.Load(Server.MapPath("~/Report_From/RT_Clearing_DOC002.rpt")); cryRpt.SetDataSource(rt_clearing); ReportDocument subRepDoc = cryRpt.Subreports["RPT_Subsidy.rpt"]; List <RPT_Get_Clearing_No_Subsidy> rt_subsidy = new List <RPT_Get_Clearing_No_Subsidy>(); rt_subsidy = Reports.RPT_Get_Clearing_No_Subsidy(PRM); subRepDoc.SetDataSource(rt_subsidy); ReportDocument subRepDoc1 = cryRpt.Subreports["RPT_Deduct.rpt"]; List <RPT_Get_Clearing_No_Deduct> rt_deduct = new List <RPT_Get_Clearing_No_Deduct>(); rt_deduct = Reports.RPT_Get_Clearing_No_Deduct(PRM); subRepDoc1.SetDataSource(rt_deduct); break; case "StockOnHandList": if (Temp1 == "Temp1") { List <RPT_COUNT_STOCK_FORM_5> rt_StockOnHandList = new List <RPT_COUNT_STOCK_FORM_5>(); rt_StockOnHandList = Reports.RPT_COUNT_STOCK_FORM_5(null, CV_Code, null, null, null, null, null, null, null, null); cryRpt.Load(Server.MapPath("~/Report_From/RT_CountStock.rpt")); cryRpt.SetDataSource(rt_StockOnHandList); } else { List <RPT_COUNT_STOCK_FORM_5> rt_StockOnHandList = new List <RPT_COUNT_STOCK_FORM_5>(); rt_StockOnHandList = Reports.RPT_COUNT_STOCK_FORM_5(null, null, PRM, null, null, null, null, null, null, null); cryRpt.Load(Server.MapPath("~/Report_From/RT_CountStock.rpt")); cryRpt.SetDataSource(rt_StockOnHandList); } break; case "CommissionReqList": // List<RPT_COUNT_STOCK_FORM_5> rt_StockOnHandList = new List<RPT_COUNT_STOCK_FORM_5>(); List <RPT_RQ_CASH_FORM_4> rt_RQ_CASH_FORM_4 = new List <global::RPT_RQ_CASH_FORM_4>(); rt_RQ_CASH_FORM_4 = Reports.RPT_RQ_CASH_FORM_4(null, null, PRM, null, null, null, null, null, null, User_ID); cryRpt.Load(Server.MapPath("~/Report_From/RT_CM_Requisition.rpt")); cryRpt.SetDataSource(rt_RQ_CASH_FORM_4); break; case "RPT_Order": //List<RPT_Get_Clearing_No> rt_clearing = new List<RPT_Get_Clearing_No>(); //List<RPT_AnnualReport_4121> rt_RPT_Order = new List<RPT_AnnualReport_4121>(); //rt_clearing = Reports.RPT_Get_Clearing_No(PRM); //rt_RPT_Order = Reports.RPT_AnnualReport_4121(Region,AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit); cryRpt.Load(Server.MapPath("~/Report/RT_ReportOrders.rpt")); //cryRpt.SetDataSource(rt_RPT_Order); break; case "ReportOrdersGroupProducts": //List<RPT_AnnualReport_4121> rt_RPT_Order = new List<RPT_AnnualReport_4121>(); //rt_clearing = Reports.RPT_Get_Clearing_No(PRM); //rt_RPT_Order = Reports.RPT_AnnualReport_4121(Region, AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit); cryRpt.Load(Server.MapPath("~/Report/RT_ReportOrdersGroupProducts.rpt")); //cryRpt.SetDataSource(rt_RPT_Order); break; case "ReportOrdersYearlyTarget": //List<RPT_AnnualReport_4121> rt_RPT_Order = new List<RPT_AnnualReport_4121>(); //rt_clearing = Reports.RPT_Get_Clearing_No(PRM); //rt_RPT_Order = Reports.RPT_AnnualReport_4121(Region, AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit); cryRpt.Load(Server.MapPath("~/Report/RT_ReportOrdersYearlyTarget.rpt")); //cryRpt.SetDataSource(rt_RPT_Order); break; case "Other_Requisition_No": List <RPT_Get_OtherRequisition_No> rt_other = new List <RPT_Get_OtherRequisition_No>(); rt_other = Reports.RPT_Get_OtherRequisition_No(PRM); cryRpt.Load(Server.MapPath("~/Report_From/RT_OtherRequisition_DOC.rpt")); cryRpt.SetDataSource(rt_other); break; } // List<RT_PO_DOC> rt_doc = new List<RT_PO_DOC>(); if (cryRpt != null) { BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length)).ToArray()); Response.Flush(); Response.Close(); } else { } } catch (Exception ex) { logger.Error(ex.Message); //throw ex; } }
private void UpdateRecord() { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); dbo_UserClass oclsdbo_User = new dbo_UserClass(); // dbo_UserClass clsdbo_User = new dbo_UserClass(); oclsdbo_User.User_ID = txtCP_User_ID.Text; oclsdbo_User = dbo_UserDataClass.Select_Record(oclsdbo_User.User_ID); Validate("CPValidation"); SetDataCP(oclsdbo_User); if (IsValid) { string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; bool success = dbo_UserDataClass.Update(oclsdbo_User, User_ID); if (success) { bool flag = false; String strString = "0401,0402,0403,0404,0405"; String[] myArr = strString.Split(','); foreach (var d in myArr) { if (d == oclsdbo_User.Item_Value_ID) { flag = true; } } if (flag == true) { //Show("gg"); List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty); List <dbo_AgentClass> _cv_code = new List <dbo_AgentClass>(agent.Where(f => f.DM_ID == oclsdbo_User.User_ID.Trim() || f.GM_ID == oclsdbo_User.User_ID.Trim() || f.SD_ID == oclsdbo_User.User_ID.Trim() || f.SM_ID == oclsdbo_User.User_ID.Trim() || f.APV_ID == oclsdbo_User.User_ID.Trim()).Select(f => f)); if (_cv_code.Count > 0) { foreach (var d in _cv_code) { dbo_AgentClass oclsdbo_Agent = new dbo_AgentClass(); // dbo_AgentClass clsdbo_Agent = new dbo_AgentClass(); oclsdbo_Agent.CV_Code = d.CV_Code; oclsdbo_Agent = dbo_AgentDataClass.Select_Record(oclsdbo_Agent.CV_Code); if (d.APV_ID == oclsdbo_User.User_ID.Trim()) { oclsdbo_Agent.APV_ID = string.Empty; dbo_AgentDataClass.Update(oclsdbo_Agent, User_ID); //Show("APV_ID"); } else if (d.DM_ID == oclsdbo_User.User_ID.Trim()) { oclsdbo_Agent.DM_ID = string.Empty; dbo_AgentDataClass.Update(oclsdbo_Agent, User_ID); //Show("DM_ID"); } else if (d.GM_ID == oclsdbo_User.User_ID.Trim()) { oclsdbo_Agent.GM_ID = string.Empty; dbo_AgentDataClass.Update(oclsdbo_Agent, User_ID); //Show("GM_ID"); } else if (d.SD_ID == oclsdbo_User.User_ID.Trim()) { oclsdbo_Agent.SD_ID = string.Empty; dbo_AgentDataClass.Update(oclsdbo_Agent, User_ID); //Show("SD_ID"); } else if (d.SM_ID == oclsdbo_User.User_ID.Trim()) { oclsdbo_Agent.SM_ID = string.Empty; dbo_AgentDataClass.Update(oclsdbo_Agent, User_ID); //Show("SM_ID"); } } } } Show("บันทึกสำเร็จ"); } else { Show("error"); } } }
private void DisplayReportExpenditure() { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); try { List <RPT_EXPENSE_MONTHLY_41218> rt_RPT_EXPENSE_MONTHLY = new List <RPT_EXPENSE_MONTHLY_41218>(); string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty); if (user_class.User_Group_ID == "CP Meiji") { string region = user_class.Region; string[] regions = region.Split(','); List <dbo_AgentClass> cv_code_ = new List <dbo_AgentClass>(); foreach (string in_region in regions) { List <dbo_AgentClass> cv_code2 = new List <dbo_AgentClass>(agent.Where(f => f.Location_Region == in_region).Select(f => f)); foreach (dbo_AgentClass _cv in cv_code2) { //cv_code_.Add(_cv); List <RPT_EXPENSE_MONTHLY_41218> _inrpt = Reports.RPT_EXPENSE_MONTHLY_41218(string.Empty, _cv.CV_Code, MonthGroup, MonthGroupTo, Year, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); foreach (RPT_EXPENSE_MONTHLY_41218 rpt in _inrpt) { rt_RPT_EXPENSE_MONTHLY.Add(rpt); } } } foreach (var d in rt_RPT_EXPENSE_MONTHLY) { d.paramCV_Code = d.CV_Code; dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(d.paramCV_Code); d.paramCV_Name = _agent.AgentName; //user_class = dbo_UserDataClass.Select_Record(d.paramCV_Code); //d.paramCV_Name = user_class.AgentName; d.paramYear = Request.QueryString["Year"]; d.paramStartMonth = CV_Month(MonthGroup); d.paramEndMonth = CV_Month(MonthGroupTo); } } else { rt_RPT_EXPENSE_MONTHLY = Reports.RPT_EXPENSE_MONTHLY_41218(string.Empty, CV_CODE, MonthGroup, MonthGroupTo, Year, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); foreach (var d in rt_RPT_EXPENSE_MONTHLY) { d.paramCV_Code = CV_CODE; dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(d.paramCV_Code); d.paramCV_Name = _agent.AgentName; d.paramYear = Request.QueryString["Year"]; d.paramStartMonth = CV_Month(MonthGroup); d.paramEndMonth = CV_Month(MonthGroupTo); } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportExpenditure.rpt")); cryRpt.SetDataSource(rt_RPT_EXPENSE_MONTHLY); ReportViewer1.ToolPanelView = ToolPanelViewType.None; ReportViewer1.HasCrystalLogo = false; ReportViewer1.ReportSource = cryRpt; ReportViewer1.RefreshReport(); //BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); //Response.ClearContent(); //Response.ClearHeaders(); //Response.ContentType = "application/pdf"; //Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length))); //Response.Flush(); //Response.Close(); } catch (Exception ex) { logger.Error(ex.Message); } }
private void DisplayReportSummaryIncome() { try { List <RPT_SUMM_EXPENSE_41219> rt_RPT_EXPENSE = new List <RPT_SUMM_EXPENSE_41219>(); string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty); if (user_class.User_Group_ID == "CP Meiji") { string region = user_class.Region; string[] regions = region.Split(','); List <dbo_AgentClass> cv_code_ = new List <dbo_AgentClass>(); foreach (string in_region in regions) { List <dbo_AgentClass> cv_code2 = new List <dbo_AgentClass>(agent.Where(f => f.Location_Region == in_region).Select(f => f)); foreach (dbo_AgentClass _cv in cv_code2) { List <RPT_SUMM_EXPENSE_41219> _inrpt = Reports.RPT_SUMM_EXPENSE_41219(string.Empty, _cv.CV_Code, InvoiceDate, InvoiceDateTo, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); foreach (RPT_SUMM_EXPENSE_41219 rpt in _inrpt) { rt_RPT_EXPENSE.Add(rpt); } } } foreach (var d in rt_RPT_EXPENSE) { d.paramCV_Code = d.CV_Code; // dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(d.paramCV_Code); dbo_AgentClass _agent = agent.FirstOrDefault(f => f.CV_Code == d.CV_Code); if (_agent != null) { d.paramCV_Name = _agent.AgentName; } d.Temp0 = DateTime.Now.ToShortDateString(); } } else { rt_RPT_EXPENSE = Reports.RPT_SUMM_EXPENSE_41219(string.Empty, CV_CODE, InvoiceDate, InvoiceDateTo, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); foreach (var d in rt_RPT_EXPENSE) { d.paramCV_Code = d.CV_Code; // dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(d.paramCV_Code); dbo_AgentClass _agent = agent.FirstOrDefault(f => f.CV_Code == d.CV_Code); if (_agent != null) { d.paramCV_Name = _agent.AgentName; } d.Temp0 = DateTime.Now.ToShortDateString(); } } /* * rt_RPT_EXPENSE = Reports.RPT_SUMM_EXPENSE_41219(string.Empty, CV_CODE, InvoiceDate, InvoiceDateTo, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); * * foreach (var d in rt_RPT_EXPENSE) * { * d.paramCV_Code = CV_CODE; * user_class = dbo_UserDataClass.Select_Record(d.paramCV_Code); * d.paramCV_Name = user_class.AgentName; * } */ cryRpt.Load(Server.MapPath("~/Report/RT_ReportSummaryIncome.rpt")); cryRpt.SetDataSource(rt_RPT_EXPENSE); ReportViewer1.ToolPanelView = ToolPanelViewType.None; ReportViewer1.HasCrystalLogo = false; ReportViewer1.ReportSource = cryRpt; ReportViewer1.RefreshReport(); //BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); //Response.ClearContent(); //Response.ClearHeaders(); //Response.ContentType = "application/pdf"; //Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length))); //Response.Flush(); //Response.Close(); } catch (Exception ex) { logger.Error(ex.Message); } }
protected void GenerateReport(string RPT, string PRM, string Region, string AgentName, string SPName, string JoinDate_From, string JoinDate_To, string WorkingAge_From, string WorkingAge_To, string ApprovalStatus, string Position, string RequisitionDate_From, string RequisitionDate_To, string ProductGroup, string Size, string Clearing_Date_From, string Clearing_Date_TO, string User_ID, string Lebel_SP) { try { ReportDocument cryRpt = new ReportDocument(); switch (RPT) { case "ReportAllEmployee": ReportViewer1.ID = "รายงานจำนวนพนักงานทั้งหมดของศูนย์_" + datetime.Replace("/", string.Empty) + "_" + Time.Replace(":", string.Empty); List <RPT_SUMM_SP_BY_AGENT_41215> rt_RPT_Emp = new List <RPT_SUMM_SP_BY_AGENT_41215>(); rt_RPT_Emp = Reports.RPT_SUMM_SP_BY_AGENT_41215(Region, AgentName, ApprovalStatus, Position, JoinDate_From, JoinDate_To , WorkingAge_From, WorkingAge_To, SPName, string.Empty); if (rt_RPT_Emp.Count > 0) { foreach (RPT_SUMM_SP_BY_AGENT_41215 r in rt_RPT_Emp) { r.paramRegion_Name = Request.QueryString["RegionName"]; r.paramCV_Name = Request.QueryString["AgentFullName"]; r.paramSP_ID = Request.QueryString["SPName"]; if ((Request.QueryString["SPFullName"] != null) && (Request.QueryString["SPName"] != null)) { r.paramSP_Name = Request.QueryString["SPFullName"].Replace(Request.QueryString["SPName"], ""); } r.paramStartDate_From = Request.QueryString["JoinDate_From"]; r.paramStartDate_To = Request.QueryString["JoinDate_To"]; r.paramJoinDate_From = Request.QueryString["WorkingAge_From"]; r.paramJoinDate_To = Request.QueryString["WorkingAge_To"]; r.paramStatus = Request.QueryString["ApprovalStatus"]; r.paramPosition = Request.QueryString["PositionFullName"]; } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportAllEmployee.rpt")); cryRpt.SetDataSource(rt_RPT_Emp); break; case "ReportCommissions": ReportViewer1.ID = "รายงานค่าคอมมิชชั่น_" + datetime.Replace("/", string.Empty) + "_" + Time.Replace(":", string.Empty); List <RPT_SP_COMMISSION_41216> rt_RPT_Comm = new List <RPT_SP_COMMISSION_41216>(); rt_RPT_Comm = Reports.RPT_SP_COMMISSION_41216(string.Empty, AgentName, SPName, RequisitionDate_From, RequisitionDate_To, ProductGroup, Size, Lebel_SP, string.Empty, string.Empty); foreach (var d in rt_RPT_Comm) { if (AgentName == "") { d.paramCV_Code = "เลือกทั้งหมด"; d.paramCV_Name = "เลือกทั้งหมด"; } else { d.paramCV_Code = AgentName; //user_class = dbo_UserDataClass.Select_Record(AgentName); //d.paramCV_Name = user_class.AgentName; _agent = dbo_AgentDataClass.Select_Record(AgentName); d.paramCV_Name = _agent.AgentName; } d.paramStartDate = RequisitionDate_From; d.paramEndDate = RequisitionDate_To; if (SPName == "") { d.paramSP_ID = "เลือกทั้งหมด"; } else { d.paramSP_ID = SPName; } if (Lebel_SP == "") { d.paramSP_Name = "เลือกทั้งหมด"; } else { d.paramSP_Name = Lebel_SP.Substring(11); } if (ProductGroup == "") { d.paramProduct_Group = "เลือกทั้งหมด"; } else { d.paramProduct_Group = ProductGroup; } if (Size == "") { d.paramSize = "เลือกทั้งหมด"; } else { d.paramSize = Size; } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportCommissions.rpt")); cryRpt.SetDataSource(rt_RPT_Comm); break; case "ReportWithdrawalCommissions": ReportViewer1.ID = "รายงานการเบิกค่าคอมมิชชั่น_" + datetime.Replace("/", string.Empty) + "_" + Time.Replace(":", string.Empty); List <RPT_REQUES_COMMISSION_41217> rt_RPT_RqComm = new List <RPT_REQUES_COMMISSION_41217>(); rt_RPT_RqComm = Reports.RPT_REQUES_COMMISSION_41217(string.Empty, AgentName, SPName, Clearing_Date_From, Clearing_Date_TO, RequisitionDate_From, RequisitionDate_To, Lebel_SP, string.Empty, string.Empty); foreach (var d in rt_RPT_RqComm) { if (AgentName == "") { d.paramCV_Code = "เลือกทั้งหมด"; d.paramCV_Name = "เลือกทั้งหมด"; } else { d.paramCV_Code = AgentName; //user_class = dbo_UserDataClass.Select_Record(AgentName); //d.paramCV_Name = user_class.AgentName; _agent = dbo_AgentDataClass.Select_Record(AgentName); d.paramCV_Name = _agent.AgentName; } d.paramCR_StartDate = Clearing_Date_From; d.paramCR_EndDate = Clearing_Date_TO; d.paramRQ_StartDate = RequisitionDate_From; d.paramRQ_EndDate = RequisitionDate_To; if (SPName == "") { d.paramSP_ID = "เลือกทั้งหมด"; } else { d.paramSP_ID = SPName; } if (Lebel_SP == "") { d.paramSP_Name = "เลือกทั้งหมด"; } else { d.paramSP_Name = Lebel_SP.Substring(11); } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportWithdrawalCommissions.rpt")); cryRpt.SetDataSource(rt_RPT_RqComm); break; } //BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); //Response.ClearContent(); //Response.ClearHeaders(); //Response.ContentType = "application/pdf"; //Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length))); //Response.Flush(); //Response.Close(); ReportViewer1.ToolPanelView = ToolPanelViewType.None; ReportViewer1.HasCrystalLogo = false; ReportViewer1.ReportSource = cryRpt; ReportViewer1.RefreshReport(); } catch (Exception ex) { // logger.Error(ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { Page.Validate("NewsValidation"); if (IsValid) { DateTime startDate = Convert.ToDateTime(txtStart_Date.Text); DateTime endDate = Convert.ToDateTime(txtEnd_Date.Text); DateTime today = DateTime.Today; if (startDate < today) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ไม่สามารถระบุวันที่เริ่มย้อนหลังได้"); } else if (endDate < today) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ไม่สามารถระบุวันที่สิ้นสุดย้อนหลังได้"); } else if (startDate > endDate) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ไม่สามารถระบุวันที่เริ่มมากกว่าวันที่สิ้นสุดได้"); } else { string subject = txtSubject.Text; string newsType = ddlNewsType.SelectedValue.ToString(); string contents = txtContent.Text; string agentName = string.Empty; string cvCode = string.Empty; if (!string.IsNullOrEmpty(ddlAgentName.SelectedValue.ToString())) { agentName = ddlAgentName.SelectedItem.ToString(); cvCode = ddlAgentName.SelectedValue.ToString(); } string vdoHyperLink = txtVideo.Text; string userName = User_ID; string fileName = string.Empty; string contenttype = string.Empty; string imgName = string.Empty; string imgType = string.Empty; Byte[] fileBytes = null; Byte[] imgBytes = null; if (fulFileUpload.HasFile) { string filePath = fulFileUpload.PostedFile.FileName; fileName = Path.GetFileName(filePath); string fileExt = Path.GetExtension(fileName); contenttype = Common.Common.ContentType(fileExt); Stream fs = fulFileUpload.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); fileBytes = br.ReadBytes((Int32)fs.Length); } if (fulImgUpload.HasFile) { string imgPath = fulImgUpload.PostedFile.FileName; imgName = Path.GetFileName(imgPath); string imgExt = Path.GetExtension(imgName); imgType = Common.Common.ContentType(imgExt); Stream imgST = fulImgUpload.PostedFile.InputStream; BinaryReader imgBR = new BinaryReader(imgST); imgBytes = imgBR.ReadBytes((Int32)imgST.Length); } bool status = false; if (newsType == "ทั่วไป") { string newsID = generateNewsID(); status = dbo_NewsDataClass.InsertNews(newsID, newsType, agentName, subject, contents, fileName, contenttype, fileBytes, vdoHyperLink, startDate, endDate, imgName, imgType, imgBytes, userName, ddlAgentName.SelectedValue); } else { List <ListItem> selected = new List <ListItem>(); foreach (ListItem item in ddlAgentName.Items) { string newsID = generateNewsID(); if (item.Selected) { dbo_AgentClass agent = dbo_AgentDataClass.Select_Record(item.Value); selected.Add(item); status = dbo_NewsDataClass.InsertNews(newsID, newsType, agent.AgentName, subject, contents, fileName, contenttype, fileBytes, vdoHyperLink, startDate, endDate, imgName, imgType, imgBytes, userName, item.Value); } } } if (status) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); // Show("บันทึกสำเร็จ!"); Session["CreateNews_Status"] = "true"; Session["SaveNew"] = "SaveNew"; Response.Redirect("../Views/NewsList.aspx"); Session.Remove("fulFileUpload"); Session.Remove("fulImgUpload"); } } } else { // string script = @"swal({ // title: ""กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน"", // text: """", // type: ""error"", // confirmButtonText: ""ตกลง"" // });"; // ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน');", true); if (fulFileUpload.HasFile) { Session["fulFileUpload"] = fulFileUpload; lblfulFileUpload.Text = fulFileUpload.FileName; } if (fulImgUpload.HasFile) { Session["fulImgUpload"] = fulImgUpload; lblfulImgUpload.Text = fulImgUpload.FileName; } } }
protected void GenerateReport(string RPT, string PRM, string Region, string AgentName, string SPName, string InvoiceDate, string InvoiceDateTo, string ProductGroup, string Size, string CountStockDate_From, string CountStockDate_To, string productname, string RequisitionName, string Reason, string PRM1, string CV_Code) { try { ReportDocument cryRpt = new ReportDocument(); switch (RPT) { case "ReportSummaryPickingSPList": List <RPT_SUMM_RQ_SP_4126> rt_RPT_SUMM_RQ_SP = new List <RPT_SUMM_RQ_SP_4126>(); //rt_RPT_SUMM_RQ_SP = Reports.RPT_SUMM_RQ_SP_4126(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty,string.Empty); rt_RPT_SUMM_RQ_SP = Reports.RPT_SUMM_RQ_SP_4126(Region, AgentName, SPName, InvoiceDate, InvoiceDateTo, ProductGroup, Size, string.Empty, string.Empty, string.Empty); cryRpt.Load(Server.MapPath("~/Report/RT_ReportSummaryPickingSPList.rpt")); cryRpt.SetDataSource(rt_RPT_SUMM_RQ_SP); break; case "ReportProductMovement": List <RPT_STOCK_MOV_4127> rt_RPT_STOCK_MOV = new List <RPT_STOCK_MOV_4127>(); // rt_RPT_STOCK_MOV = Reports.RPT_STOCK_MOV_4127(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); rt_RPT_STOCK_MOV = Reports.RPT_STOCK_MOV_4127(string.Empty, CV_Code, CountStockDate_From, CountStockDate_To, ProductGroup, Size, string.Empty, string.Empty, string.Empty, string.Empty); foreach (var d in rt_RPT_STOCK_MOV) { d.pramCV_Code = CV_Code; if (d.pramCV_Code == "") { d.pramCV_Code = "ทั้งหมด"; } if (CV_Code == "") { d.pramAgent_Name = "ทั้งหมด"; } else { dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(CV_Code); d.pramAgent_Name = _agent.AgentName; } d.pramDate_From = CountStockDate_From; d.pramDate_To = CountStockDate_To; d.pramProduct_group = ProductGroup; if (d.pramProduct_group == "") { d.pramProduct_group = "เลือกทั้งหมด"; } d.pramSize = Size; if (d.pramSize == "") { d.pramSize = "เลือกทั้งหมด"; } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportProductMovement.rpt")); cryRpt.SetDataSource(rt_RPT_STOCK_MOV); break; case "ReportProductAdjustStock": List <RPT_ADJ_STOCK__4128> rt_RPT_ADJ_STOCK = new List <RPT_ADJ_STOCK__4128>(); //rt_RPT_ADJ_STOCK = Reports.RPT_ADJ_STOCK__4128(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); rt_RPT_ADJ_STOCK = Reports.RPT_ADJ_STOCK__4128(string.Empty, CV_Code, CountStockDate_From, CountStockDate_To, ProductGroup, Size, string.Empty, string.Empty, string.Empty, string.Empty); cryRpt.Load(Server.MapPath("~/Report/RT_ReportProductAdjustStock.rpt")); cryRpt.SetDataSource(rt_RPT_ADJ_STOCK); break; case "ReportSummaryPickingOtherProduct": List <RPT_SUMM_RQ_OTHER__4129> rt_RPT_SUMM_RQ_OTHER = new List <RPT_SUMM_RQ_OTHER__4129>(); //rt_RPT_SUMM_RQ_OTHER = Reports.RPT_SUMM_RQ_OTHER__4129(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); rt_RPT_SUMM_RQ_OTHER = Reports.RPT_SUMM_RQ_OTHER__4129(string.Empty, CV_Code, CountStockDate_From, CountStockDate_To, productname, RequisitionName, Reason, string.Empty, string.Empty, string.Empty); cryRpt.Load(Server.MapPath("~/Report/RT_ReportSummaryPickingOtherProduct.rpt")); cryRpt.SetDataSource(rt_RPT_SUMM_RQ_OTHER); break; case "Clearing_No": List <RPT_CLR_SALE_SUM_FORM_1_3> RPT_FORM_1_3 = new List <RPT_CLR_SALE_SUM_FORM_1_3>(); RPT_FORM_1_3 = Reports.RPT_CLR_SALE_SUM_FORM_1_3(PRM); cryRpt.Load(Server.MapPath("~/ViewsMockup/RT_SalesSummaryByProduct.rpt")); cryRpt.SetDataSource(RPT_FORM_1_3); break; case "Requisition_No": List <RPT_Get_Requisition_No> rt_rqt = new List <RPT_Get_Requisition_No>(); rt_rqt = Reports.RPT_Get_Requisition_No_Search(PRM, string.Empty); int rqt_clm_tmp = rt_rqt.Where(f => f.clm_6 != 0 || f.clm_7 != 0 || f.clm_8 != 0 || f.clm_9 != 0 || f.clm_10 != 0).Count(); if (rqt_clm_tmp != 0) { cryRpt.Load(Server.MapPath("~/ViewsMockup/RT_Requisition_DOC002.rpt")); cryRpt.SetDataSource(rt_rqt); } else { cryRpt.Load(Server.MapPath("~/ViewsMockup/RT_Requisition_DOC001.rpt")); cryRpt.SetDataSource(rt_rqt); } break; //Requisition_No1 case "Requisition_No1": //List<RPT_Get_Requisition_No> rt_rqt = new List<RPT_Get_Requisition_No>(); rt_rqt = Reports.RPT_Get_Requisition_No_Search(PRM1, string.Empty); int rqt_clm_tmp1 = rt_rqt.Where(f => f.clm_6 != 0 || f.clm_7 != 0 || f.clm_8 != 0 || f.clm_9 != 0 || f.clm_10 != 0).Count(); if (rqt_clm_tmp1 != 0) { cryRpt.Load(Server.MapPath("~/ViewsMockup/RT_Requisition_DOC002.rpt")); cryRpt.SetDataSource(rt_rqt); } else { cryRpt.Load(Server.MapPath("~/ViewsMockup/RT_Requisition_DOC001.rpt")); cryRpt.SetDataSource(rt_rqt); } break; } BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length))); Response.Flush(); Response.Close(); } catch (Exception ex) { logger.Error(ex.Message); } }
protected void btnPrint_Click(object sender, EventArgs e) { try { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); List <RPT_SUMM_EXPENSE_41219> rt_RPT_EXPENSE = new List <RPT_SUMM_EXPENSE_41219>(); string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty); if (user_class.User_Group_ID == "CP Meiji") { string region = user_class.Region; string[] regions = region.Split(','); List <dbo_AgentClass> cv_code_ = new List <dbo_AgentClass>(); foreach (string in_region in regions) { List <dbo_AgentClass> cv_code2 = new List <dbo_AgentClass>(agent.Where(f => f.Location_Region == in_region).Select(f => f)); foreach (dbo_AgentClass _cv in cv_code2) { List <RPT_SUMM_EXPENSE_41219> _inrpt = Reports.RPT_SUMM_EXPENSE_41219(string.Empty, user_class.CV_CODE, InvoiceDate.Text, InvoiceDateTo.Text, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); foreach (RPT_SUMM_EXPENSE_41219 rpt in _inrpt) { rt_RPT_EXPENSE.Add(rpt); } } } foreach (var d in rt_RPT_EXPENSE) { d.paramCV_Code = d.CV_Code; // dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(d.paramCV_Code); dbo_AgentClass _agent = agent.FirstOrDefault(f => f.CV_Code == d.CV_Code); if (_agent != null) { d.paramCV_Name = _agent.AgentName; } } } else { rt_RPT_EXPENSE = Reports.RPT_SUMM_EXPENSE_41219(string.Empty, user_class.CV_CODE, InvoiceDate.Text, InvoiceDateTo.Text, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); foreach (var d in rt_RPT_EXPENSE) { d.paramCV_Code = d.CV_Code; // dbo_AgentClass _agent = dbo_AgentDataClass.Select_Record(d.paramCV_Code); dbo_AgentClass _agent = agent.FirstOrDefault(f => f.CV_Code == d.CV_Code); if (_agent != null) { d.paramCV_Name = _agent.AgentName; } } } if (rt_RPT_EXPENSE.Count > 0) { //string User_ID = Request.Cookies["User_ID"].Value; string url = "../Report/ReportViewer_01.aspx?RPT=ReportSummaryIncome&InvoiceDate=" + InvoiceDate.Text + "&InvoiceDateTo=" + InvoiceDateTo.Text + "&CV_CODE=" + user_class.CV_CODE; string s = "window.open('" + url + "', 'popup_window', 'width=1024,height=768,left=100,top=100,resizable=yes');"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", s, true); } else { Messages.Show("ไม่พบข้อมูล กรุณาเลือกเงื่อนไขอีกครั้ง", this.Page); } } catch (Exception ex) { logger.Error(ex.Message); } }
private void DisplayReportOrders() { ReportDocument cryRpt = new ReportDocument(); List <RPT_AnnualReport_4121> rt_RPT_Order = new List <RPT_AnnualReport_4121>(); //rt_RPT_Order = Reports.RPT_AnnualReport_4121(Region, AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit, string.Empty); user_class = dbo_UserDataClass.Select_Record(User_ID); List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty); if (user_class.User_Group_ID == "CP Meiji") { string region = user_class.Region; string[] regions = region.Split(','); List <dbo_AgentClass> cv_code2 = new List <dbo_AgentClass>(agent.Where(f => regions.Contains(f.Location_Region)).Select(f => f)); List <dbo_AgentClass> cv_code1 = new List <dbo_AgentClass>(agent.Where(f => f.DM_ID == User_ID || f.GM_ID == User_ID.Trim() || f.SD_ID == User_ID.Trim() || f.SM_ID == User_ID.Trim() || f.APV_ID == User_ID.Trim()).Select(f => f)); if (cv_code1.Count > 0) { if (AgentName == string.Empty) { foreach (dbo_AgentClass _cv in cv_code1) { List <RPT_AnnualReport_4121> _inrpt = Reports.RPT_AnnualReport_4121(Region, _cv.CV_Code, Month_From, Month_To, Year, ProductGroup, Size, Unit, string.Empty); foreach (RPT_AnnualReport_4121 rpt in _inrpt) { rt_RPT_Order.Add(rpt); } } } else { foreach (dbo_AgentClass _cv in cv_code1) { List <RPT_AnnualReport_4121> _inrpt = Reports.RPT_AnnualReport_4121(Region, AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit, string.Empty); foreach (RPT_AnnualReport_4121 rpt in _inrpt) { rt_RPT_Order.Add(rpt); } } } } else { if (Region == string.Empty) { foreach (dbo_AgentClass _cv in cv_code2) { List <RPT_AnnualReport_4121> _inrpt = Reports.RPT_AnnualReport_4121(_cv.Location_ID, AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit, string.Empty); foreach (RPT_AnnualReport_4121 rpt in _inrpt) { rt_RPT_Order.Add(rpt); } } } else { foreach (dbo_AgentClass _cv in cv_code2) { List <RPT_AnnualReport_4121> _inrpt = Reports.RPT_AnnualReport_4121(Region, AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit, string.Empty); foreach (RPT_AnnualReport_4121 rpt in _inrpt) { rt_RPT_Order.Add(rpt); } } } } } else { rt_RPT_Order = Reports.RPT_AnnualReport_4121(Region, AgentName, Month_From, Month_To, Year, ProductGroup, Size, Unit, string.Empty); } foreach (var d in rt_RPT_Order) { if (Region == "") { d.paramRegion_Name = "เลือกทั้งหมด"; } else { d.paramRegion_Name = CV_RegionName(Region); } if (AgentName != "") { //user_class = dbo_UserDataClass.Select_Record(AgentName); //d.pramAgent_Name = user_class.AgentName; _agent = dbo_AgentDataClass.Select_Record(AgentName); d.pramAgent_Name = _agent.AgentName; } else { d.pramAgent_Name = "เลือกทั้งหมด"; } d.pramMonth_From = CV_Month(Month_From); d.pramMonth_To = CV_Month(Month_To); d.pramYear = Year; if (ProductGroup == "") { d.pramProduct_Group = "เลือกทั้งหมด"; } else { d.pramProduct_Group = ProductGroup; } if (Size == "") { d.pramSize = "เลือกทั้งหมด"; } else { d.pramSize = Size; } if (Unit == "จำนวนเงิน") { d.pramUnitType = "บาท"; } else if (Unit == "จำนวนหน่วย") { d.pramUnitType = "หน่วย"; } } cryRpt.Load(Server.MapPath("~/Report/RT_ReportOrders.rpt")); cryRpt.SetDataSource(rt_RPT_Order); ReportViewer.ToolPanelView = ToolPanelViewType.None; ReportViewer.HasCrystalLogo = false; //this.ReportViewer.PrintMode = PrintMode.ActiveX; ReportViewer.ReportSource = cryRpt; ReportViewer.RefreshReport(); //BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)); //Response.ClearContent(); //Response.ClearHeaders(); //Response.ContentType = "application/pdf"; //Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length)).ToArray()); //Response.Flush(); //Response.Close(); }