private void LoadPurchaseReturnHeaderList() { CreamBell_DMS_WebApps.App_Code.Global obj = new Global(); //string query= " Select A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO, SUM(B.AMOUNT) as TOTAMOUNT " + // " from [ax].[ACXPURCHRETURNHEADER] A INNER JOIN [ax].[ACXPURCHRETURNLINE] B ON A.PURCH_RETURNNO=B.PURCH_RETURNNO GROUP BY " + // " A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO "; string query = "Select A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO, SUM(B.AMOUNT) as TOTAMOUNT " + "from [ax].[ACXPURCHRETURNHEADER] A INNER JOIN [ax].[ACXPURCHRETURNLINE] B ON A.PURCH_RETURNNO=B.PURCH_RETURNNO AND A.SITE_CODE=B.SITEID " + "Where A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' " + " GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO Order By A.PURCH_RETURNDATE desc"; DataTable dt = obj.GetData(query); if (dt.Rows.Count > 0) { GridHeaderDetail.DataSource = dt; GridHeaderDetail.DataBind(); //GridHeaderDetail.Columns[5].Visible = false; } }
//GetPurchaseOrder(Convert.ToDateTime(txtFromDate.Text).ToString("dd-MMM-yyyy"), Convert.ToDateTime(txtToDate.Text).ToString("dd-MMM-yyyy")); private void SearchdataByFilter(string searchFilter, string searchText) { CreamBell_DMS_WebApps.App_Code.Global obj = new Global(); string query = " Select A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO, SUM(B.AMOUNT) as TOTAMOUNT " + " from [ax].[ACXPURCHRETURNHEADER] A INNER JOIN [ax].[ACXPURCHRETURNLINE] B ON A.PURCH_RETURNNO=B.PURCH_RETURNNO "; if (DDLSearchFilter.Text == "Receipt Number") { query = query + " where A.PURCH_RECIEPTNO ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO"; } if (DDLSearchFilter.Text == "Receipt Date") { query = query + " where A.PURCH_RECIEPTDATE ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO"; } if (DDLSearchFilter.Text == "Return Number") { query = query + " where A.PURCH_RETURNNO ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO"; } if (DDLSearchFilter.Text == "Return Date") { query = query + " where A.PURCH_RETURNDATE ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO"; } DataTable dt = obj.GetData(query); if (dt.Rows.Count > 0) { GridHeaderDetail.DataSource = dt; GridHeaderDetail.DataBind(); gridLineDetails.Visible = true; } else { this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('No Data Found !');", true); LoadPurchaseReturnHeaderList(); gridLineDetails.Visible = false; } }