protected void ClearItemData(bool NewItem) { // if NewItem is true, we are clearing after an item is entered BOMGridView.DataBind(); DetailUpdatePanel.Update(); ItemDescLabel.Text = ""; Wgt100Label.Text = ""; QtyUOMLabel.Text = ""; StdCostLabel.Text = ""; UPCLabel.Text = ""; WebLabel.Text = ""; CategoryLabel.Text = ""; NetWghtLabel.Text = ""; SuperEqLabel.Text = ""; ListLabel.Text = ""; HarmCodeLabel.Text = ""; PackGroupLabel.Text = ""; PlatingLabel.Text = ""; GrossWghtLabel.Text = ""; PriceUMLabel.Text = ""; CFVLabel.Text = ""; PPILabel.Text = ""; ParentLabel.Text = ""; StockLabel.Text = ""; CostUMLabel.Text = ""; CatVelLabel.Text = ""; PkgVelLabel.Text = ""; CreatedLabel.Text = ""; SelectorUpdatePanel.Update(); HeaderUpdatePanel.Update(); //CategorySpecLabel.Text = ""; MessageUpdatePanel.Update(); // HeadImageUpdatePanel.Visible = false; // BodyImageUpdatePanel.Visible = false; }
protected void btnSearch_Click(object sender, EventArgs e) { //tPager.Visible = true; //BSSGridView.CurrentPageIndex = 0; //Pager1.GotoPageNumber = 0; //pnlPager.Update(); lblErrorMessage.Text = ""; lblSuccessMessage.Text = ""; MessageUpdatePanel.Update(); if (txtBranchNo.Text.Trim().Length == 0) { lblErrorMessage.Text = "You must enter a Branch Number."; MessageUpdatePanel.Update(); } else { lblErrorMessage.Text = ""; ClearDisplay(); //Validate Item Params if (string.IsNullOrEmpty(txtStrCat.Text)) { txtStrCat.Text = "00000"; if (string.IsNullOrEmpty(txtEndCat.Text)) { txtEndCat.Text = "99999"; } } else { if (string.IsNullOrEmpty(txtEndCat.Text)) { txtEndCat.Text = txtStrCat.Text; } } if (string.IsNullOrEmpty(txtStrSize.Text)) { txtStrSize.Text = "0000"; if (string.IsNullOrEmpty(txtEndSize.Text)) { txtEndSize.Text = "9999"; } } else { if (string.IsNullOrEmpty(txtEndSize.Text)) { txtEndSize.Text = txtStrSize.Text; } } if (string.IsNullOrEmpty(txtStrVar.Text)) { txtStrVar.Text = "000"; if (string.IsNullOrEmpty(txtEndVar.Text)) { txtEndVar.Text = "999"; } } else { if (string.IsNullOrEmpty(txtEndVar.Text)) { txtEndVar.Text = txtStrVar.Text; } } //Get the data using pSSLocExcelDump ds = SqlHelper.ExecuteDataset(cnERP, "pSSLocExcelDump", new SqlParameter("@LocID", txtBranchNo.Text.Trim()), new SqlParameter("@StrCat", txtStrCat.Text.Trim()), new SqlParameter("@StrSize", txtStrSize.Text.Trim()), new SqlParameter("@StrVar", txtStrVar.Text.Trim()), new SqlParameter("@EndCat", txtEndCat.Text.Trim()), new SqlParameter("@EndSize", txtEndSize.Text.Trim()), new SqlParameter("@EndVar", txtEndVar.Text.Trim())); if (ds.Tables.Count >= 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { DataView dv = new DataView(dt, hidRowFilter.Value.ToString(), hidSort.Value.ToString(), DataViewRowState.CurrentRows); // BSSGridView.DataSource = dv; lblSuccessMessage.Text = dt.Rows.Count.ToString().Trim() + " record(s) found. Click Excel button to Export"; Session["BSSData"] = dt; BSSGridView.DataBind(); ExcelUpdatePanel.Visible = true; SelectorUpdatePanel.Update(); DetailUpdatePanel.Update(); } else { lblErrorMessage.Text = "No Branch Status for Branch Location " + txtBranchNo.Text.Trim(); MessageUpdatePanel.Update(); Session["BSSData"] = null; BSSGridView.DataBind(); } MessageUpdatePanel.Update(); } } }
protected void btnSearch_Click(object sender, EventArgs e) { lblErrorMessage.Text = ""; lblSuccessMessage.Text = ""; MessageUpdatePanel.Update(); string Track = "Timer" + DateTime.Now.ToString("mm:ss"); if (txtCustNo.Text.Trim().Length == 0) { lblErrorMessage.Text = "You must enter a Customer Number."; MessageUpdatePanel.Update(); } else { try { lblErrorMessage.Text = ""; ClearDisplay(); //Get the data using pCustPriceGetHist Track += "|DataBeg" + DateTime.Now.ToString("mm:ss"); ds = SqlHelper.ExecuteDataset(ConnectionString, "pCustPriceGetHist", new SqlParameter("@CustNo", txtCustNo.Text.Trim()), new SqlParameter("@itemType", (rdoBulk.Checked ? "Bulk" : "Package"))); Track += "|DataEnd" + DateTime.Now.ToString("mm:ss"); if (ds.Tables.Count == 2) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { lblCustName.Text = dt.Rows[0]["CustomerName"].ToString(); lblBranch.Text = dt.Rows[0]["Branch"].ToString(); lblRecType.Text = ""; CPSMRecTypeHidden.Value = dt.Rows[0]["RecType"].ToString(); if (CPSMRecTypeHidden.Value.ToString() == "0") { lblRecType.Text = "These are New records wating for Targets."; } if (CPSMRecTypeHidden.Value.ToString() == "1") { lblRecType.Text = "These are Unprocessed waiting for Appproval."; } hidSort.Value = ""; hidSort.Attributes["sortType"] = "DESC"; hidRowFilter.Value = "GroupType = 'C'"; // Change Target column header based on item type CPSMGridView.Columns[7].HeaderText = (rdoBulk.Checked ? "Target" : "Bulk +"); DataView dv = new DataView(dt, hidRowFilter.Value.ToString(), hidSort.Value.ToString(), DataViewRowState.CurrentRows); CPSMGridView.DataSource = dv; Session["CPSMData"] = dt; Track += "|Session" + DateTime.Now.ToString("mm:ss"); CPSMGridView.DataBind(); Track += "|DataBind" + DateTime.Now.ToString("mm:ss"); if (ApprovalOKHidden.Value.ToUpper() == "TRUE") { ApproveUpdatePanel.Visible = true; SubmitUpdatePanel.Visible = false; } else { ApproveUpdatePanel.Visible = false; SubmitUpdatePanel.Visible = true; } if (hidShowCostBasis.Value == "TRUE") { ibtnSetBasis.Visible = true; } else { ibtnSetBasis.Visible = false; } if (hidPriceAnalysis.Value == "TRUE") { btnPriceAnalysis.Visible = true; } else { btnPriceAnalysis.Visible = false ; } ExcelUpdatePanel.Visible = true; SelectorUpdatePanel.Update(); DetailUpdatePanel.Update(); } else { lblErrorMessage.Text = "No Price Schedule Data For Customer " + txtCustNo.Text.Trim(); MessageUpdatePanel.Update(); Session["CPSMData"] = null; CPSMGridView.DataBind(); } Track += "|HdrBeg" + DateTime.Now.ToString("mm:ss"); dtSched = ds.Tables[1]; if (dtSched.Rows.Count > 0) { if (string.IsNullOrEmpty(lblCustName.Text.ToString())) { lblCustName.Text = dtSched.Rows[0]["CustomerName"].ToString(); } if (string.IsNullOrEmpty(lblBranch.Text.ToString())) { lblBranch.Text = dtSched.Rows[0]["Branch"].ToString(); } lblSched1.Text = dtSched.Rows[0]["ContractSchd1"].ToString(); lblSched2.Text = dtSched.Rows[0]["ContractSchd2"].ToString(); lblSched3.Text = dtSched.Rows[0]["ContractSchd3"].ToString(); lblSched4.Text = dtSched.Rows[0]["ContractSchedule4"].ToString(); lblSched5.Text = dtSched.Rows[0]["ContractSchedule5"].ToString(); lblSched6.Text = dtSched.Rows[0]["ContractSchedule6"].ToString(); lblSched7.Text = dtSched.Rows[0]["ContractSchedule7"].ToString(); lblTargetGross.Text = String.Format("{0:0.0}", dtSched.Rows[0]["TargetGrossMarginPct"]); lblWebDiscPct.Text = String.Format("{0:0.00}", dtSched.Rows[0]["WebDiscountPct"]); chkWebDiscInd.Checked = (dtSched.Rows[0]["WebDiscountInd"].ToString().ToUpper().Trim() == "1"); lblCustDefPrice.Text = dtSched.Rows[0]["CustomerDefaultPrice"].ToString(); lblCustPriceInd.Text = dtSched.Rows[0]["CustomerPriceInd"].ToString(); lblCreditInd.Text = dtSched.Rows[0]["CreditInd"].ToString(); lblActGrossMgnPct.Text = dtSched.Rows[0]["ActGrossMgnPct"].ToString(); lblDefaultCostPct.Text = dtSched.Rows[0]["TargetCostPlusPct"].ToString(); } else { lblErrorMessage.Text = "Customer " + txtCustNo.Text.Trim() + " Not On File"; MessageUpdatePanel.Update(); } Track += "|HdrEnd" + DateTime.Now.ToString("mm:ss"); lblSuccessMessage.Text = Track; MessageUpdatePanel.Update(); } } catch (Exception e3) { lblErrorMessage.Text = "pCustPriceGetHist Error " + e3.Message + ", " + e3.ToString(); MessageUpdatePanel.Update(); } } }