protected void btnSearch_Click(object sender, EventArgs e) { //--- Multi Select List Box Values -- string strPartyName = string.Empty; foreach (ListItem item in lbPartyName.Items) { if (item.Selected) { strPartyName += "'" + item.Text + "'"; strPartyName += ","; } } //--- Multi Select List Box Values -- string strItemName = string.Empty; foreach (ListItem item in lbItemName.Items) { if (item.Selected) { strItemName += "'" + item.Text + "'"; strItemName += ","; } } LeadTime_Search repParamSearch = new LeadTime_Search(); if (lbPartyName.SelectedIndex > 0) { repParamSearch.PartyName = strPartyName.Remove(strPartyName.Length - 1, 1);// Remove last , } if (lbItemName.SelectedIndex > 0) { repParamSearch.ItemName = strItemName.Remove(strItemName.Length - 1, 1);// Remove last ,// lbItemName.SelectedItem.Text; } //repParamSearch.ItemName = lbItemName.SelectedItem.Text; repParamSearch.StartDate_PO = Page.Request.Form["_dtFromDate_PO"].ToString(); repParamSearch.EndtDate_PO = Page.Request.Form["_dtToDate_PO"].ToString(); repParamSearch.StartDate_GRN = Page.Request.Form["_dtFromDate_GRN"].ToString(); repParamSearch.EndtDate_GRN = Page.Request.Form["_dtToDate_GRN"].ToString(); repParamSearch.StartDate_Invoice = Page.Request.Form["_dtFromDate_Invoice"].ToString(); repParamSearch.EndtDate_Invoice = Page.Request.Form["_dtToDate_Invoice"].ToString(); bool blncontinue = true; if (blncontinue) { GenerateRDLCReport(repParamSearch); } }
protected void btnReset_Click(object sender, EventArgs e) { LeadTime_Search repParamSearch = new LeadTime_Search(); GenerateRDLCReport(repParamSearch); string PODateFrom = Request.Form["dtFromDate_PO"]; lbItemName.SelectedIndex = -1; lbPartyName.SelectedIndex = -1; //--- Set Current Date in Date Fileds Input Box lblmsg.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PopulateSearchDropdowns(); //applyrole(); //generate report LeadTime_Search repParamSearch = new LeadTime_Search(); //repParamSearch.StartDate_PO = "mad"; GenerateRDLCReport(repParamSearch); } }
private void GenerateRDLCReport(LeadTime_Search repParamSearch) { ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/rdlcs/Report_LeadTime.rdlc"); DataSet dt = (new Report_DL()).GetLeadTimeReportData(repParamSearch); if (dt != null) { ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource() { Name = "dsLeadTime", Value = dt.Tables[0] }); ReportViewer1.LocalReport.Refresh(); } }
public DataSet GetLeadTimeReportData(LeadTime_Search repParamSearch) { try { LeadTime_Report_List lstLeadTimeReport = new LeadTime_Report_List(); Common.OpenConnection(); String strSQL = "select * from View_Report_LeadTime"; string WhSQL = ""; string strconcat = ""; if (repParamSearch.PartyName != null && repParamSearch.PartyName != "" && repParamSearch.PartyName != "select") { WhSQL = WhSQL + strconcat + "popartyname In (" + repParamSearch.PartyName + ")"; strconcat = " and "; } if (repParamSearch.ItemName != null && repParamSearch.ItemName != "" && repParamSearch.ItemName != "select") { WhSQL = WhSQL + strconcat + "POStockItemName In (" + repParamSearch.ItemName + ")"; strconcat = " and "; } //--------------- PO Date ------------------- if (repParamSearch.StartDate_PO != null && repParamSearch.StartDate_PO != "") { WhSQL = WhSQL + strconcat + " PODate>='" + repParamSearch.StartDate_PO + "'"; strconcat = " and "; } if (repParamSearch.EndtDate_PO != null && repParamSearch.EndtDate_PO != "") { WhSQL = WhSQL + strconcat + " PODate<='" + repParamSearch.EndtDate_PO + "'"; strconcat = " and "; } //--------------- GRN Date ------------------- if (repParamSearch.StartDate_GRN != null && repParamSearch.StartDate_GRN != "") { WhSQL = WhSQL + strconcat + " GRNDate>='" + repParamSearch.StartDate_GRN + "'"; strconcat = " and "; } if (repParamSearch.EndtDate_GRN != null && repParamSearch.EndtDate_GRN != "") { WhSQL = WhSQL + strconcat + " GRNDate<='" + repParamSearch.EndtDate_GRN + "'"; strconcat = " and "; } //--------------- Invoice Date ------------------- if (repParamSearch.StartDate_Invoice != null && repParamSearch.StartDate_Invoice != "") { WhSQL = WhSQL + strconcat + " PurchaseDate>='" + repParamSearch.StartDate_Invoice + "'"; strconcat = " and "; } if (repParamSearch.EndtDate_Invoice != null && repParamSearch.EndtDate_Invoice != "") { WhSQL = WhSQL + strconcat + " PurchaseDate<='" + repParamSearch.EndtDate_Invoice + "'"; strconcat = " and "; } if (WhSQL != null && WhSQL != "") { strSQL = strSQL + " where " + WhSQL; } strSQL += " Order by podate, popartyname, POStockItemName"; SqlCommand cmd = new SqlCommand(strSQL, Common.conn); DataSet dsLeadTime = new DataSet(); using (SqlDataAdapter sda = new SqlDataAdapter()) { sda.SelectCommand = cmd; sda.Fill(dsLeadTime, "rpt_LeadTime"); } return(dsLeadTime); } catch (Exception ex) { return(null); } }