private void BindDataGrid()
{
sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn);
//dtQuoteAndOrder = eCommerceReport.GetQuote2OrderData(periodMonth, periodYear,customerNo);
//dtQuote2Order = eCommerceReport.CreateJoins(dtQuoteAndOrder, GetCustomers());
//dtQuote2Order.DefaultView.Sort = hidSort.Value;
DataTable dtCCR = CCR.GetContactReport(strBranch, strCustType, strContactType, strBG, strFilterDt);
if (dtCCR.Rows.Count > 0)
{
dtCCR.DefaultView.Sort = hidSort.Value;
dgReport.DataSource = dtCCR.DefaultView.ToTable();
//dgReport.DataBind();
Pager1.Visible = true;
Pager1.InitPager(dgReport, pagesize);
lblStatus.Visible = false;
}
else
{
Pager1.Visible = false;
lblStatus.Visible = true;
lblStatus.Text = "No Records Found";
}
}
private void BindDataGrid()
{
try
{
if (dtTotal.Rows.Count > 0)
{
GetTotal();
dgDayReport.DataSource = dsReport.Tables[0];
dgDayReport.Visible = true;
lblStatus.Visible = false;
Pager1.InitPager(dgDayReport, pagesize);
Pager1.Visible = true;
udpReportContent.Update();
}
else
{
dgDayReport.Visible = false;
Pager1.Visible = false;
lblStatus.Visible = true;
lblStatus.Text = "No Records Found";
}
}
catch (Exception ex)
{
throw ex;
}
//lblStatus.Text = "No Records Found";
//lblStatus.Visible = (dgDayReport.Items.Count < 1) ? true : false;
}
protected void BindDatagrid(string where)
{
lblMsg.Visible = false;
dgRequestQuote.Visible = true;
Pager1.Visible = true;
DataTable dtRequestQuote = requestQuote.GetRequestQuote(where);
if (dtRequestQuote.Rows.Count > 0)
{
dtRequestQuote.DefaultView.Sort = (hidSort.Value == "") ? "SessionID desc" : hidSort.Value;
dgRequestQuote.DataSource = dtRequestQuote.DefaultView.ToTable();
if (dtRequestQuote.Rows.Count >= 15)
{
Pager1.InitPager(dgRequestQuote, 15);
}
else
{
Pager1.InitPager(dgRequestQuote, dtRequestQuote.Rows.Count);
Pager1.Visible = false;
}
}
else
{
lblMsg.Visible = true;
dgRequestQuote.Visible = false;
Pager1.Visible = false;
}
upnlQuote.Update();
}
private void BindDataGrid()
{
if (PageMode != "pircemode")
{
string dbSourcetype = (PageMode != "itemhistory" ? "getgriditems" : "getitemhistory");
DataTable dtCompItems = GetCompetitorTablesData(dbSourcetype, hidRegionId.Value, ddlCompName.SelectedItem.Value, PFCItemNo, "");
if (dtCompItems != null)
{
if (PageMode == "itemhistory")
{
dgCompPrice.Columns[0].Visible = false;
}
dtCompItems.DefaultView.Sort = (hidSort.Value == "") ? "" : hidSort.Value;
dgCompPrice.DataSource = dtCompItems.DefaultView.ToTable();
Pager1.InitPager(dgCompPrice, 50);
Pager1.Visible = true;
//dgCompPrice.DataBind();
upnlGrid.Update();
if (dtCompItems.Rows.Count == 0)
{
DisplaStatusMessage("No Records Found", "Fail");
}
}
else
{
DisplaStatusMessage("No Records Found", "Fail");
}
}
}
protected void BindDataGrid()
{
if (txtSearchCustNo.Text.ToString() == (txtOrganizationNo.Text.ToString())) // keeps both grids if customer is requested again
{
dsItemAlias = SqlHelper.ExecuteDataset(cnxERP, CommandType.StoredProcedure, "[pMaintItemAlias]"
, new SqlParameter("@ItemNo", txtSearchItemNo.Text)
, new SqlParameter("@OrganizationNo", txtSearchCustNo.Text)); //See stored procedure to for code to allow null by case of LIKE statement
dgItemAliasGrid.DataSource = dsItemAlias.Tables[0].DefaultView.ToTable();
}
else
{
dsItemAlias = SqlHelper.ExecuteDataset(cnxERP, CommandType.StoredProcedure, "[pMaintItemAlias]"
, new SqlParameter("@ItemNo", txtSearchItemNo.Text)
, new SqlParameter("@OrganizationNo", txtSearchCustNo.Text)); //See stored procedure to for code to allow null by case of LIKE statement
dgItemAliasGrid.DataSource = dsItemAlias.Tables[0].DefaultView.ToTable();
ClearControls();
}
Pager1.InitPager(dgItemAliasGrid, 14);
divAliasGrid.Visible = true; //make div visible since it is set as false in page (grid)
pnlAliasGrid.Update(); //Refresh panels when clicking, all the time !
}
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(WOFind));
if (!IsPostBack)
{
GetSecurity();
dgFind.PageSize = PageSize;
ViewState["MaxRowCount"] = BusinessLogic.GetSQLWarningRowCount();
//ViewState["MaxRowCount"] = "9999";
BindFindControls();
ClearFindControls();
dtStartDt.SelectedDate = DateTime.Now.AddDays(-7).ToShortDateString();
dtEndDt.SelectedDate = DateTime.Now.ToShortDateString();
dtEmpty.Clear();
dgFind.DataSource = dtEmpty.DefaultView.ToTable();
dgFind.DataBind();
Pager1.InitPager(dgFind, PageSize);
}
}
private void BindDataGrid()
{
dtUnrcvdPO = (DataTable)Session["dtPO"];
TotLines = dtUnrcvdPO.DefaultView.ToTable().Rows.Count;
lblTotLines.Text = "Total number of lines: " + String.Format("{0:n0}", TotLines);
TotQtyOrd = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(QtyOrdered)", ""));
lblTotQtyOrd.Text = String.Format("{0:n0}", TotQtyOrd);
TotQtyRcvd = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(QtyReceived)", ""));
lblTotQtyRcvd.Text = String.Format("{0:n0}", TotQtyRcvd);
TotQtyDue = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(QtyDue)", ""));
lblTotQtyDue.Text = String.Format("{0:n0}", TotQtyDue);
TotExtCost = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(ExtendedCost)", ""));
lblTotExtCost.Text = String.Format("{0:c}", TotExtCost);
tblGrdTotals.Visible = true;
dtUnrcvdPOCat = SelectDistinct(dtUnrcvdPO.DefaultView.ToTable(), "CatNo");
//if (!string.IsNullOrEmpty(txtCat.Text.ToString()))
// dtUnrcvdPOCat.DefaultView.RowFilter = "CatNo = '" + txtCat.Text.ToString() + "'";
dtUnrcvdPOCat.DefaultView.Sort = "CatNo ASC";
dgUnrcvdPOCat.DataSource = dtUnrcvdPOCat.DefaultView.ToTable();
dgUnrcvdPOCat.AllowPaging = true;
dgUnrcvdPOCat.DataBind();
pnlRptGrid.Update();
Pager1.InitPager(dgUnrcvdPOCat, 1);
Pager1.Visible = true;
pnlPager.Update();
}
private void BindDataGrid()
{
sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn);
dsQuoteAnalysis = eCommerceReport.GetDtlData(periodMonth, periodYear, startDate, endDate, branchNo, customerNo, orderSource, sourceType, itemNotOrd, quoteNumber);
dtQuoteAnalysis = eCommerceReport.AverageCostJoins(dsQuoteAnalysis.Tables[0], eCommerceReport.GetAverageCost(dsQuoteAnalysis.Tables[0]));
DataColumn dcAverageCost = new DataColumn("MarginPercentage", System.Type.GetType("System.Double"));
dcAverageCost.Expression = "IIF([UnitPrice]=0, 0,(((UnitPrice - AvgCost) / UnitPrice) * 100))";
dtQuoteAnalysis.Columns.Add(dcAverageCost);
dtQuoteAnalysis.DefaultView.Sort = sortExpression;
if (dtQuoteAnalysis.Rows.Count > 0)
{
dgQuoteAnalysis.DataSource = dtQuoteAnalysis.DefaultView.ToTable();
Pager1.Visible = true;
Pager1.InitPager(dgQuoteAnalysis, pagesize);
lblStatus.Visible = false;
}
else
{
Pager1.Visible = false;
lblStatus.Visible = true;
lblStatus.Text = "No Records Found";
}
}
protected void BindGrid()
{
string GridColumns = "Hdr.BOLNo, max(BOLDate) as BolDate, sum(Det.UOMatlAmt) as BOLMatl";
GridColumns += ", sum(UODutyAmt + UOOceanFrghtAmt + UOBrokerageAmt + UODrayAmt + UOMerchProcFee + UOHarborMaintFee + isnull(UOMiscWghtFee,0) + UOTrkFrghtAmt) as BOLLanded";
GridColumns += ", 0.0 as APMatl, 0.0 as APLanded, 0.0 as GERvsAP, 0.0 as APVariance, 0.0 as GERTot, 0.0 as APTot, 0.0 as TotalVariance";
ds = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings["ReportsConnectionString"].ToString(), "[UGEN_SP_Select]",
new SqlParameter("@tableName", "GERHeaderHist Hdr inner join GERDetailHist Det on Hdr.BOLNo=Det.BOLNo"),
new SqlParameter("@displayColumns", GridColumns),
new SqlParameter("@whereCondition", "Hdr.BOLNo='" + BOL + "' group by Hdr.BOLNo order by Hdr.BOLNo"));
dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
lblErrorMessage.Text = "Nothing on file for BOL " + BOL;
}
else
{
//lblSuccessMessage.Text = "BOL " + BOL + " processed";
foreach (DataRow row in dt.Rows)
{
row["GERTot"] = (decimal)row["BOLMatl"] + (decimal)row["BOLLanded"];
GetNVData(row);
row["APTot"] = (decimal)row["APMatl"] + (decimal)row["APLanded"] + (decimal)row["APVariance"];
row["GERvsAP"] = (decimal)row["GERTot"] - ((decimal)row["APMatl"] + (decimal)row["APLanded"]);
row["TotalVariance"] = (decimal)row["GERTot"] - (decimal)row["APTot"];
}
}
ReconGrid.DataSource = dt.DefaultView.ToTable();
Pager1.InitPager(ReconGrid, pagesize);
}
private void BindDataGrid()
{
sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn);
//dtQuoteAndOrder = eCommerceReport.GetQuote2OrderData(periodMonth, periodYear,customerNo);
//dtQuote2Order = eCommerceReport.CreateJoins(dtQuoteAndOrder, GetCustomers());
//dtQuote2Order.DefaultView.Sort = hidSort.Value;
dtQuote2Order = eCommerceReport.GetQuote2OrderData(periodMonth, periodYear, startDate, endDate, locationCode, customerNo, repNo, priceCdCtl);
if (dtQuote2Order != null && dtQuote2Order.Rows.Count > 0)
{
dtQuote2Order.DefaultView.Sort = hidSort.Value;
dgQuote2Order.DataSource = dtQuote2Order.DefaultView.ToTable();
Pager1.Visible = true;
Pager1.InitPager(dgQuote2Order, pagesize);
lblStatus.Visible = false;
}
else
{
Pager1.Visible = false;
lblStatus.Visible = true;
lblStatus.Text = "No Records Found";
}
}
public void BindDataGrid()
{
stDate = Convert.ToDateTime(ddlStMonth.SelectedValue.ToString() + "/01/" + ddlStYear.SelectedValue.ToString());
endDate = Convert.ToDateTime(ddlEndMonth.SelectedValue.ToString() + "/28/" + ddlEndYear.SelectedValue.ToString());
PrintDialogue1.CustomerNo = custNumber;
PrintDialogue1.PageTitle = "Sales history for " + custNumber;
string TempUrl = "saleshistoryExport.aspx?CustomerNumber=" + custNumber + "&SONumber=" + hidSoNumber.Value.ToString() + "&frmMonth=" + ddlStMonth.SelectedValue.ToString() + "&frmYear=" + ddlStYear.SelectedValue.ToString() + "&endMonth=" + ddlEndMonth.SelectedValue.ToString() + "&endYear=" + ddlEndYear.SelectedValue.ToString();
PrintDialogue1.PageUrl = Server.UrlEncode(TempUrl);
dsSalesHistory = salesHis.GetSalesHistory(custNumber, stDate, endDate);
if (dsSalesHistory.Rows.Count > 0 && dsSalesHistory != null)
{
lblMsg.Visible = false;
}
else
{
lblMsg.Text = "No Records found";
lblMsg.Visible = true;
}
dsSalesHistory.DefaultView.Sort = (hidSort.Value == "") ? "itemNo asc" : hidSort.Value;
dgSalesHistory.DataSource = dsSalesHistory;
Pager1.InitPager(dgSalesHistory, pagesize);
upSalesHistoryGrid.Update();
}
public void BindDataGrid(DataTable dtCerts)
{
Session["CertsInformation"] = dtCerts;
gvCertificates.DataSource = dtCerts;
gvCertificates.DataBind();
Pager1.InitPager(gvCertificates, pageSize);
}
public void BindDataGrid()
{
adp = new SqlDataAdapter(cmdRGASummary, cnxNV);
adp.Fill(ds, "RGASummary");
GridView1.DataSource = ds.Tables["RGASummary"];
GridView1.DataBind();
Pager1.InitPager(GridView1, 20);
}
public void BindDataGrid()
{
String sortExpression = (hidSort.Value == "") ? " MarginPerLb DESC" : hidSort.Value;
adp = new SqlDataAdapter(cmd);
ds.Clear();
adp.Fill(ds, "Profit");
ds.Tables["Profit"].DefaultView.Sort = sortExpression;
GridView1.DataSource = ds.Tables["Profit"].DefaultView.ToTable();
if (ds.Tables["Profit"].Rows.Count > 0)
{
GrdTotMgnDollars = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(MarginDollars)", ""));
lblTotMgnDollars.Text = String.Format("{0:c}", GrdTotMgnDollars);
GrdTotProfit = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(Profit)", ""));
lblTotProfit.Text = String.Format("{0:c}", GrdTotProfit);
GrdTotPounds = Math.Round(Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(Lbs)", "")), 2);
lblTotPounds.Text = String.Format("{0:0,0.00}", GrdTotPounds);
GrdTotSales = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(SalesDollars)", ""));
lblTotSales.Text = String.Format("{0:c}", GrdTotSales);
if (GrdTotPounds == 0)
{
lblTotMgnPerLb.Text = "0";
}
else
{
lblTotMgnPerLb.Text = String.Format("{0:c}", GrdTotMgnDollars / GrdTotPounds);
}
if (GrdTotSales == 0)
{
lblTotMgnPct.Text = "0";
}
else
{
lblTotMgnPct.Text = String.Format("{0:N2}%", GrdTotMgnDollars / GrdTotSales * 100);
}
GrdTotSales = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(SalesDollars)", ""));
lblTotSales.Text = String.Format("{0:c}", GrdTotSales);
if (GrdTotPounds == 0)
{
lblTotPricePerLb.Text = "0";
}
else
{
lblTotPricePerLb.Text = String.Format("{0:c}", GrdTotSales / GrdTotPounds);
}
}
Pager1.InitPager(GridView1, 22);
}
protected void ibtnCancel_Click(object sender, ImageClickEventArgs e)
{
lblMessage.Text = "";
pnlStatus.Update();
ClearFindControls();
dgFind.DataSource = dtEmpty.DefaultView.ToTable();
dgFind.DataBind();
Pager1.InitPager(dgFind, PageSize);
pnlWOGrid.Update();
}
public void BindDataToGrid()
{
try
{
ExcelExport();
BindDataGridHeader();
System.Data.DataTable dt = (System.Data.DataTable)Session["BranchItem"];
dt.DefaultView.Sort = hidSort.Value;
Session["BranchItem"] = dt.DefaultView.ToTable();
dgAnalysis.DataSource = dt.DefaultView.ToTable();
if (dt.Rows.Count > 0)
{
Pager1.InitPager(dgAnalysis, pagesize);
DropDownList ddl = Pager1.FindControl("ddlPages") as DropDownList;
if (ddl.SelectedItem.Value.ToString() == ddl.Items.Count.ToString())
{
dgAnalysis.ShowFooter = true;
}
else
{
dgAnalysis.ShowFooter = false;
}
if (dgAnalysis.Items.Count <= 0)
{
dgAnalysis.Visible = false;
btnPrint.Visible = false;
tblPager.Visible = false;
lblStatus.Visible = true;
}
else
{
dgAnalysis.Visible = true;
btnPrint.Visible = true;
tblPager.Visible = true;
lblStatus.Visible = false;
}
}
else
{
dgAnalysis.Visible = false;
btnPrint.Visible = false;
tblPager.Visible = false;
lblStatus.Visible = true;
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}
public void BindDataGrid()
{
string sortExpression = (hidSort.Value == "") ? " [PO No] Asc" : hidSort.Value;
adp = new SqlDataAdapter(cmd);
ds.Clear();
adp.Fill(ds, "POVendorConf");
ds.Tables["POVendorConf"].DefaultView.Sort = sortExpression;
GridView1.DataSource = ds.Tables["POVendorConf"].DefaultView.ToTable();
GridView1.DataBind();
Pager1.InitPager(GridView1, 20);
}
public void BindDataGrid()
{
string sortExpression = (hidSort.Value == "") ? " [ItemNo], [Loc] Asc" : hidSort.Value;
adp = new SqlDataAdapter(cmd);
ds.Clear();
adp.Fill(ds, "AItems");
ds.Tables["AItems"].DefaultView.Sort = sortExpression;
GridView1.DataSource = ds.Tables["AItems"].DefaultView.ToTable();
GridView1.DataBind();
Pager1.InitPager(GridView1, 18);
}
private void BindDataGrid()
{
Pager1.Visible = true;
//string searchText = GetSearchText();
lblDeleteDate.Text = "";
string searchText = "DeleteDt is null";
Clear();
dtTablesData = glaccount.GetDataGridPostingRecords(searchText);
if (dtTablesData != null)
{
dtTablesData.DefaultView.Sort = (hidSort.Value == "") ? "pGLAcctMasterID desc" : hidSort.Value;
dgCountryCode.DataSource = dtTablesData.DefaultView.ToTable();
//dgCountryCode.DataBind();
Pager1.InitPager(dgCountryCode, 25);
if (dtTablesData.Rows.Count == 1)
{
if (Page.IsPostBack)
{
//
// Fetch Data From Table
//
hidPrimaryKey.Value = dtTablesData.Rows[0]["pGLAcctMasterID"].ToString().Trim();
dtTablesData = glPosting.GetPostingRecords("pGLAcctMasterID = '" + hidPrimaryKey.Value + "'");
DisplayRecord();
btnSave.Visible = (CountrySecurity != "") ? true : false;
//btnDelete.Visible = (CountrySecurity != "") ? true : false;
if (ViewState["Operation"].ToString() == "Save" || ViewState["Operation"].ToString() == "Delete" || ViewState["Operation"].ToString() == "Clear")
{
Clear();
}
}
else
{
btnSave.Visible = false;
btnDelete.Visible = false;
}
}
if (dtTablesData.Rows.Count == 0)
{
DisplaStatusMessage("No Records Found", "Fail");
}
}
else
{
DisplaStatusMessage("No Records Found", "Fail");
}
SelectItem(ddlLocation, Session["BranchID"].ToString());
UpdatePanels();
}
private void BindDataGrid()
{
dtWorkSheet = (DataTable)Session["dtWS"];
dtWorkSheet.DefaultView.Sort = (hidSort.Value == "") ? "ActionStatus ASC, WOItemNo ASC, PriorityCd ASC" : hidSort.Value;
dgWorkSheet.DataSource = dtWorkSheet.DefaultView.ToTable();
dgWorkSheet.AllowPaging = true;
dgWorkSheet.DataBind();
pnlWSGrid.Update();
hidRowCount.Value = dtWorkSheet.Rows.Count.ToString();
Session["dtWS"] = dtWorkSheet.DefaultView.ToTable();
Pager1.InitPager(dgWorkSheet, PageSize);
Pager1.Visible = true;
pnlPager.Update();
}
private void BindDataGrid()
{
dsExcessInv = (DataSet)Session["dsExInv"];
dtExcessInv = dsExcessInv.Tables[0];
dtExcessInv.DefaultView.Sort = (hidSort.Value == "") ? "ItemNo ASC, Branch ASC" : hidSort.Value;
dgExcessInv.DataSource = dtExcessInv.DefaultView.ToTable();
dgExcessInv.AllowPaging = true;
dgExcessInv.DataBind();
pnlRptGrid.Update();
hidRowCount.Value = dsExcessInv.Tables[0].Rows.Count.ToString();
Pager1.InitPager(dgExcessInv, PageSize);
Pager1.Visible = true;
pnlPager.Update();
}
public void BindDataToGrid()
{
try
{
dsVendorForeCast = vendorforeCast.GetVendorForeCastData(Session["VendorMultiplier"].ToString(), Session["VendorCategory"].ToString(), Session["VendorVariance"].ToString(), Session["VendorPlatingType"].ToString(), Session["VendorSort"].ToString());
dtVendorForeCast = dsVendorForeCast.Tables[0];
dtVFCSort = dsVendorForeCast.Tables[1];
//ExcelExport();
if (dtVFCSort.Rows.Count == 0)
{
lblStatus.Visible = true;
Pager1.Visible = false;
}
// Grand Total
foreCastUSG = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(ForeCastUSG)", "")));
usgUOM = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(USGUOM)", "")));
usgLBS = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(USGLBS)", "")));
usgKGS = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(USGKGS)", "")));
footerContent = "";
footerContent += "<table border='0' width='100%' cellpadding='0'cellspacing='0'>";
footerContent += "<tr><td style='width:511px' class='GridHead' align='right'>Grand Total</td>";
footerContent += "<td style='width:73px' class='GridHead' align='right'>" + foreCastUSG + "</td>";
footerContent += "<td style='width:74px' class='GridHead' align='right'>" + usgUOM + "</td>";
footerContent += "<td style='width:78px' class='GridHead' align='right'>" + usgLBS + "</td>";
footerContent += "<td class='GridHead' align='right'>" + usgKGS + "</td></tr></table>";
dgCategory.Columns[0].FooterText = footerContent;
dgCategory.DataSource = dtVFCSort;
Pager1.InitPager(dgCategory, 1);
if (dgCategory.CurrentPageIndex != Pager1.GetTotalNoOfPages - 1)
{
dgCategory.ShowFooter = false;
}
else
{
dgCategory.ShowFooter = true;
}
dgCategory.DataBind();
GetTotalPages();
}
catch (Exception ex) { //Response.Write(ex.Message.ToString());
}
}
private void BindDataGrid()
{
DataSet dsVendItems = new DataSet();
string pfcItemNo = txtSearchItemNo.Text;
if (txtCategory.Text.Trim() != "" ||
txtSize.Text.Trim() != "" ||
txtVar.Text.Trim() != "")
{
pfcItemNo = "Category-Size-Var";
pfcItemNo = (txtCategory.Text.Trim() != "" ? pfcItemNo.Replace("Category", txtCategory.Text) : pfcItemNo.Replace("Category", "%%%%%"));
pfcItemNo = (txtSize.Text.Trim() != "" ? pfcItemNo.Replace("Size", txtSize.Text) : pfcItemNo.Replace("Size", "%%%%"));
pfcItemNo = (txtVar.Text.Trim() != "" ? pfcItemNo.Replace("Var", txtVar.Text) : pfcItemNo.Replace("Var", "%%%"));
}
if (txtSearchItemNo.Text.Trim() != "")
{
pfcItemNo = txtSearchItemNo.Text;
}
dsVendItems = GetPriceCostTablesData(ViewState["GridViewMode"].ToString(), pfcItemNo, ddlSearchLocation.SelectedValue, "", "", "");
if (dsVendItems != null && dsVendItems.Tables.Count > 1)
{
dsVendItems.Tables[0].DefaultView.Sort = (hidSort.Value == "") ? "" : hidSort.Value;
Session["PriceCostExcelData"] = dsVendItems.Tables[0].DefaultView.ToTable();
dgPriceCost.DataSource = dsVendItems.Tables[0].DefaultView.ToTable();
Pager1.InitPager(dgPriceCost, 13);
Pager1.Visible = true;
if (dsVendItems.Tables[0].Rows.Count == 0)
{
DisplaStatusMessage("No Records Found", "Fail");
}
}
else
{
DisplaStatusMessage("No Records Found", "Fail");
dgPriceCost.DataSource = null;
dgPriceCost.DataBind();
}
upnlGrid.Update();
//ScriptManager.RegisterClientScriptBlock(dgVendorPrice, dgVendorPrice.GetType(), "setMenu", "RestoreControlPosition();", true);
}
public void BindDataGrid()
{
cmd = new SqlCommand("pACGetItemBranchDetail", cnxAC);
cmd.Parameters.AddWithValue("@BeginDt", Request.QueryString["BeginDt"].ToString());
cmd.Parameters.AddWithValue("@EndDt", Request.QueryString["EndDt"].ToString());
cmd.Parameters.AddWithValue("@ItemNo", Request.QueryString["ItemNo"].ToString());
cmd.Parameters.AddWithValue("@Branch", Request.QueryString["Branch"].ToString());
cmd.CommandType = CommandType.StoredProcedure;
adp = new SqlDataAdapter(cmd);
dsAC.Clear();
adp.Fill(dsAC, "AC");
String sortExpression = (hidSort.Value == "") ? " CurDate ASC" : hidSort.Value;
dsAC.Tables["AC"].DefaultView.Sort = sortExpression;
GridView1.DataSource = dsAC.Tables["AC"].DefaultView.ToTable();
Pager1.InitPager(GridView1, 22);
}
public void BindDataToGrid()
{
try
{
ExcelExport();
utility.CheckBrowserCompatibility(Request, dgReport);
dgReport.DataSource = dtReport;
Pager1.InitPager(dgReport, 2);
tdGrid.Visible = (dgReport.Items.Count < 1) ? false : true;
lblMsg.Visible = (dgReport.Items.Count < 1) ? true : false;
tdPager.Visible = (dgReport.Items.Count < 1) ? false : true;
foreach (DataGridItem dgItem in dgReport.Items)
{
Label lblCategory = dgItem.FindControl("lblCategory") as Label;
Label lblVariance = dgItem.FindControl("lblVariance") as Label;
Label lblPlating = dgItem.FindControl("lblPlating") as Label;
Label lblPlatingDescription = dgItem.FindControl("lblPlatingDescription") as Label;
Label lblFiscalMonth = dgItem.FindControl("FiscalMonth") as Label;
Label lblFiscalYear = dgItem.FindControl("FiscalYear") as Label;
Label lblMessage = dgItem.FindControl("lblMessage") as Label;
DataGrid dgData = dgItem.FindControl("dgAnalysis") as DataGrid;
utility.CheckBrowserCompatibility(Request, dgData);
// to pass parameter in get url function
strCategory = lblCategory.Text;
try
{
dt.DefaultView.RowFilter = "Category=" + lblCategory.Text + " and Plating='" + lblPlating.Text + "' and PlatingDescription='" + lblPlatingDescription.Text + "' and Variance='" + lblVariance.Text + "'";
string sortExpression = ((hidSort.Value != "") ? " " + hidSort.Value : "");
dt.DefaultView.Sort = sortExpression;
dgData.DataSource = dt.DefaultView;
dgData.DataBind();
dgData.Columns[6].Visible = (rdoReportVersion1.Checked == true) ? true : false;
dgData.Columns[9].Visible = (rdoReportVersion1.Checked == true) ? true : false;
dgData.Width = (rdoReportVersion1.Checked) ? 815 : 650;
}
catch (Exception ex) { }
lblMessage.Visible = (dgData.Items.Count >= 1) ? false : true;
}
}
catch (Exception ex) { }
}
private void BindDataToDataGrid()
{
try
{
whereCondition = "ContractNo='" + strContractNo + "' and Chain='" + Request.QueryString["ChainName"].Replace("||", "&").ToString() + "'";
dsReport = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings["ReportsConnectionString"].ToString(), "[ugen_sp_select]",
new SqlParameter("@tableName", "VMI_Contract"),
new SqlParameter("@displayColumns", "ContractNo,Chain,ItemNo,ItemDesc,SubItemNo,CrossRef,round(E_Profit_Pct*100,1) as E_Profit_Pct,convert(varchar,cast((cast(isnull(ContractPrice,0) as decimal(25,2))) as money),1) as ContractPrice,replace(convert(varchar,cast((cast(isnull(EAU_Qty,0) as bigint)) as money),1),'.00','') as EAU_Qty,convert(char(11),cast(StartDate as DateTime),101) as StartDate,convert(char(11),cast(EndDate as DateTime),101) as EndDate,Salesperson,OrderMethod,Vendor,Contact,ContactPhone, cast(isnull(MonthFactor,0) as decimal(25,1)) as MonthFactor,Closed,CustomerPO"),
new SqlParameter("@whereCondition", whereCondition));
dtReport = dsReport.Tables[0];
dgReport.DataSource = dtReport;
//dgReport.DataBind();
Pager1.InitPager(dgReport, pagesize);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private void BindDataGrid()
{
String sortExpression = (hidSort.Value == "") ? " Category ASC, ItemCVC ASC" : hidSort.Value;
strSQL = "SELECT *, DiscountPercent / 100 AS GridDiscPct FROM WebCategoryDiscount (NoLock)";
//strSQL = "SELECT *, DiscountPercent / 100 AS GridDiscPct FROM WebCategoryDiscount (NoLock)";
if (chkDelRec.Checked == false)
{
strSQL = strSQL + " WHERE DeleteDt = '' OR DeleteDt is null";
}
strSQL = strSQL + " ORDER BY " + sortExpression;
dsWebCatDisc = SqlHelper.ExecuteDataset(cnWebCatDisc, CommandType.Text, strSQL);
dsWebCatDisc.Tables[0].DefaultView.Sort = sortExpression;
dgWebCatDisc.DataSource = dsWebCatDisc.Tables[0].DefaultView.ToTable();
dgWebCatDisc.DataBind();
cnWebCatDisc.Close();
Pager1.InitPager(dgWebCatDisc, Convert.ToInt16(hidPageSize.Value));
pnlCatGrid.Update();
}
private void BindDataGrid()
{
sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn);
dsPurchFactor = MnthlyPrchasingBdgtData.GetAllFactors();
dtTotal = dsPurchFactor.Tables[0];
dtTotal.DefaultView.Sort = sortExpression;
dtTotal = dsPurchFactor.Tables[0].DefaultView.ToTable();
if (dtTotal.Rows.Count > 0)
{
dgPurchFactor.DataSource = dtTotal;
dgPurchFactor.DataBind();
Pager1.InitPager(dgPurchFactor, pagesize);
Pager1.Visible = true;
}
else
{
Pager1.Visible = false;
}
lblStatus.Text = "No Records Found";
lblStatus.Visible = (dgPurchFactor.Items.Count < 1) ? true : false;
}
private void BindDataGrid()
{
sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn);
dtECommSales = eCommerceReportV2.GetQuoteAndOrderData(periodMonth, periodYear, startDate, endDate, locationCode, customerNo, repNo, priceCdCtl, orderSource, itemNotOrd);
if (dtECommSales != null && dtECommSales.Rows.Count > 0)
{
dtECommSales.DefaultView.Sort = hidSort.Value;
dgECommSales.DataSource = dtECommSales.DefaultView.ToTable();
Pager1.Visible = true;
Pager1.InitPager(dgECommSales, pagesize);
lblStatus.Visible = false;
}
else
{
Pager1.Visible = false;
lblStatus.Visible = true;
lblStatus.Text = "No Records Found";
}
}
private void BindDataGrid()
{
sortExpression = ((hidSort.Value != "") ? " ORDER BY " + hidSort.Value : " ORDER BY " + keyColumn);
dsDayReport = DayInventoryReport.GetDayReport(strStatus, sortExpression);
dtTotal = dsDayReport.Tables[0].DefaultView.ToTable();
if (dtTotal.Rows.Count > 0)
{
GetTotal();
dgDayReport.DataSource = dsDayReport.Tables[0];
dgDayReport.DataBind();
Pager1.InitPager(dgDayReport, pagesize);
Pager1.Visible = true;
}
else
{
Pager1.Visible = false;
}
lblStatus.Text = "No Records Found";
lblStatus.Visible = (dgDayReport.Items.Count < 1) ? true : false;
}
