Beispiel #1
0
        private void LoadPageInformations()
        {
            try
            {
                string strDept         = "";
                string strBrand        = "";
                string strRange        = "";
                string strSite         = "";
                string strFromItem     = "";
                string strToItem       = "";
                string strAsOnDate     = "";
                string strShowZeroQty  = "N";
                string strShowInactive = "N";
                for (int i = 0; i < ddlDept_webBI_StockBalance.Items.Count; i++)
                {
                    if (ddlDept_webBI_StockBalance.Items[i].Selected == true)
                    {
                        strDept = strDept + ddlDept_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
                    }
                }
                for (int i = 0; i < ddlBrand_webBI_StockBalance.Items.Count; i++)
                {
                    if (ddlBrand_webBI_StockBalance.Items[i].Selected == true)
                    {
                        strBrand = strBrand + ddlBrand_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
                    }
                }
                for (int i = 0; i < ddlRange_webBI_StockBalance.Items.Count; i++)
                {
                    if (ddlRange_webBI_StockBalance.Items[i].Selected == true)
                    {
                        strRange = strRange + ddlRange_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
                    }
                }
                for (int i = 0; i < ddlSite_webBI_StockBalance.Items.Count; i++)
                {
                    if (ddlSite_webBI_StockBalance.Items[i].Selected == true)
                    {
                        strSite = strSite + ddlSite_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
                    }
                }
                for (int i = 0; i < ddlFItem_webBI_StockBalance.Items.Count; i++)
                {
                    if (ddlFItem_webBI_StockBalance.Items[i].Selected == true)
                    {
                        strFromItem = strFromItem + ddlFItem_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
                    }
                }

                //strFromItem = ddlFItem_webBI_StockBalance.Items[ddlFItem_webBI_StockBalance.SelectedIndex].Value;
                //strToItem = ddlTItem_webBI_StockBalance.Items[ddlTItem_webBI_StockBalance.SelectedIndex].Value;
                strAsOnDate = dtAsOnDate_webBI_StockBalance.Value.ToString();
                if (chkShowZeroQtyItems_webBI_StockBalance.Checked)
                {
                    strShowZeroQty = "Y";
                }
                if (chkShowInActive_webBI_StockBalance.Checked)
                {
                    strShowInactive = "Y";
                }
                string postData = "{\"toDate\":\"" + strAsOnDate.Trim() + "\"," +
                                  "\"Site\":\"" + strSite.Trim() + "\"," +
                                  "\"Dept\":\"" + strDept.Trim() + "\"," +
                                  "\"Brand\":\"" + strBrand.Trim() + "\"," +
                                  "\"fromItem\":\"" + strFromItem.Trim() + "\"," +
                                  "\"toItem\":\"" + strToItem.Trim() + "\"," +
                                  "\"Range\":\"" + strRange.Trim() + "\"," +
                                  "\"showInActive\":\"" + strShowInactive.Trim() + "\"," +
                                  "\"showZeroQty\":\"" + strShowZeroQty.Trim() + "\"}";
                oDT_General = oCommonEngine.GetDataTableFromAPI(Login.strAPIURL + "/api/webInventory_StockBalance", postData);
                ReportDataSource rds = new ReportDataSource("ds_webBI_StockBalance", oDT_General);
                this.rv_webBI_StockBalance.LocalReport.DataSources.Clear();
                this.rv_webBI_StockBalance.LocalReport.DataSources.Add(rds);

                string postData1Title = "{\"fromDate\":\"" + strAsOnDate.Trim() + "\"," +
                                        "\"toDate\":\"" + strSite.Trim() + "\"," +
                                        "\"ReportTitle\":\"" + "Stock Balance" + "\"," +
                                        "\"site\":\"" + strSite.Trim() + "\"}";
                //oDT_GeneralTitle = oCommonEngine.GetDataTableFromAPI(Login.strAPIURL + "/api/webBI_ReportTittle", postData1Title);
                oDT_GeneralTitle = oCommonEngine.ExecuteDataTable("select '' as fromDate,'' as toDate ,'Goods Receive Note Print' as reportTitle,'' as site ,'' as userCode,'' as siteText, Comp_Title1 as companyHeader1,Comp_Title2 as companyHeader2,Comp_Title3 as companyHeader3,Comp_Title4 as companyHeader4,Footer_1 as companyFooter1,Footer_2 as companyFooter2,Footer_3 as companyFooter3,Footer_4 as companyFooter4 from Title where Product_License='" + ddlSite_webBI_StockBalance.Value + "'");
                ReportDataSource titledatasource = new ReportDataSource("ds_webBI_ReportTittle", oDT_GeneralTitle);
                this.rv_webBI_StockBalance.LocalReport.DataSources.Add(titledatasource);

                this.rv_webBI_StockBalance.LocalReport.ReportPath = "rpt_webBI_StockBalance.rdlc";
                this.rv_webBI_StockBalance.LocalReport.Refresh();
                this.rv_webBI_StockBalance.SizeToReportContent = true;
                this.rv_webBI_StockBalance.Width          = Unit.Percentage(100);
                this.rv_webBI_StockBalance.Height         = Unit.Percentage(100);
                this.rv_webBI_StockBalance.AsyncRendering = false;
                this.rv_webBI_StockBalance.ZoomMode       = ZoomMode.FullPage;
                oCommonEngine.SetAlert(this.Page, "Report Loaded Sucessfully...!", Utilities.CommonEngine.MessageType.Success, Utilities.CommonEngine.MessageDuration.Short);
            }
            catch (Exception)
            {
                throw;
            }
        }
        private void LoadPageInformations()
        {
            try
            {
                string strDiv      = "";
                string stritemCode = "";
                string strRange    = "";
                string strBrand    = "";
                string strDate     = "";
                strDiv      = ddlDiv_StockCount.Items[ddlDiv_StockCount.SelectedIndex].Value.ToString().Trim();
                stritemCode = ddlItem_StockCount.Items[ddlItem_StockCount.SelectedIndex].Value.ToString().Trim();
                strBrand    = ddlBrand_StockCount.Items[ddlBrand_StockCount.SelectedIndex].Value.ToString().Trim();
                strRange    = ddlRange_StockCount.Items[ddlRange_StockCount.SelectedIndex].Value.ToString().Trim();
                strDate     = dtDate_StockCount.Value.ToString();

                if (stritemCode == "")
                {
                    stritemCode = "%";
                }
                if (strRange == "")
                {
                    strRange = "%";
                }
                if (strBrand == "")
                {
                    strBrand = "%";
                }
                string postData = "{\"div\":\"" + strDiv.Trim() + "\"," +
                                  "\"itemCode\":\"" + stritemCode.Trim() + "\"," +
                                  "\"itemBrand\":\"" + strBrand.Trim() + "\"," +
                                  "\"itemRange\":\"" + strRange.Trim() + "\"," +
                                  "\"date\":\"" + strDate.Trim() + "\"}";
                oDT_General = oCommonEngine.GetDataTableFromAPI(System.Configuration.ConfigurationManager.AppSettings["SequoiaUri"] + "api/stockCount", postData);
                if (oDT_General.Rows.Count > 0 && tblStockCount.Rows.Count == 1)
                {
                    for (int i = 0; i < oDT_General.Rows.Count; i++)
                    {
                        HtmlTableRow  _Row  = new HtmlTableRow();
                        HtmlTableCell Col_1 = new HtmlTableCell();
                        Col_1.InnerText = oDT_General.Rows[i]["ItemCode"].ToString();
                        Col_1.Attributes.Add("style", "width: 5 %; text-align:center");
                        _Row.Controls.Add(Col_1);

                        HtmlTableCell Col_2 = new HtmlTableCell();
                        Col_2.Attributes.Add("style", "width: 10 %; text-align:center");
                        Col_2.InnerText = oDT_General.Rows[i]["ItemName"].ToString();
                        _Row.Controls.Add(Col_2);

                        HtmlTableCell Col_3 = new HtmlTableCell();
                        Col_3.Attributes.Add("style", "width: 10 %; text-align:center");
                        Col_3.InnerText = oDT_General.Rows[i]["ItemBrand"].ToString();
                        _Row.Controls.Add(Col_3);

                        HtmlTableCell Col_4 = new HtmlTableCell();
                        Col_4.Attributes.Add("style", "width: 10 %; text-align:center");
                        Col_4.InnerText = oDT_General.Rows[i]["ItemRange"].ToString();
                        _Row.Controls.Add(Col_4);

                        HtmlTableCell Col_5 = new HtmlTableCell();
                        Col_5.Attributes.Add("style", "width: 10 %; text-align:center");
                        Col_5.InnerText = oDT_General.Rows[i]["ItemUOM"].ToString();
                        _Row.Controls.Add(Col_5);

                        HtmlTableCell Col_6 = new HtmlTableCell();
                        Col_6.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_6.InnerText = oDT_General.Rows[i]["AWHQ"].ToString();
                        _Row.Controls.Add(Col_6);

                        HtmlTableCell Col_7 = new HtmlTableCell();
                        Col_7.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_7.InnerText = oDT_General.Rows[i]["AW01"].ToString();
                        _Row.Controls.Add(Col_7);

                        HtmlTableCell Col_8 = new HtmlTableCell();
                        Col_8.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_8.InnerText = oDT_General.Rows[i]["AW02"].ToString();
                        _Row.Controls.Add(Col_8);

                        HtmlTableCell Col_9 = new HtmlTableCell();
                        Col_9.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_9.InnerText = oDT_General.Rows[i]["AW03"].ToString();
                        _Row.Controls.Add(Col_9);

                        HtmlTableCell Col_10 = new HtmlTableCell();
                        Col_10.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_10.InnerText = oDT_General.Rows[i]["AW04"].ToString();
                        _Row.Controls.Add(Col_10);

                        HtmlTableCell Col_11 = new HtmlTableCell();
                        Col_11.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_11.InnerText = oDT_General.Rows[i]["AW05"].ToString();
                        _Row.Controls.Add(Col_11);

                        HtmlTableCell Col_12 = new HtmlTableCell();
                        Col_12.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_12.InnerText = oDT_General.Rows[i]["AW06"].ToString();
                        _Row.Controls.Add(Col_12);

                        HtmlTableCell Col_13 = new HtmlTableCell();
                        Col_13.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_13.InnerText = oDT_General.Rows[i]["AW07"].ToString();
                        _Row.Controls.Add(Col_13);

                        HtmlTableCell Col_14 = new HtmlTableCell();
                        Col_14.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_14.InnerText = oDT_General.Rows[i]["AW08"].ToString();
                        _Row.Controls.Add(Col_14);

                        HtmlTableCell Col_15 = new HtmlTableCell();
                        Col_15.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_15.InnerText = oDT_General.Rows[i]["AW09"].ToString();
                        _Row.Controls.Add(Col_15);

                        HtmlTableCell Col_16 = new HtmlTableCell();
                        Col_16.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_16.InnerText = oDT_General.Rows[i]["AW10"].ToString();
                        _Row.Controls.Add(Col_16);

                        HtmlTableCell Col_17 = new HtmlTableCell();
                        Col_17.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_17.InnerText = oDT_General.Rows[i]["AW11"].ToString();
                        _Row.Controls.Add(Col_17);

                        HtmlTableCell Col_18 = new HtmlTableCell();
                        Col_18.Attributes.Add("style", "width: 5 %; text-align:center");
                        Col_18.InnerText = oDT_General.Rows[i]["balance"].ToString();
                        _Row.Controls.Add(Col_18);

                        tblStockCount.Rows.Add(_Row);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
        }