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()); } }
protected void dsUpdate(string rowId, string rowName, string rowValue) { DropDownList ddlPageNo = Pager1.FindControl("ddlPages") as DropDownList; int updRow = ((Convert.ToInt16(ddlPageNo.SelectedItem.Text) - 1) * PageSize) + Convert.ToInt16(rowId); dtWorkSheet = (DataTable)Session["dtWS"]; dtWorkSheet.Rows[updRow - dgOffSet][rowName.ToString()] = rowValue.ToString(); WSData.UpdGridData(dtWorkSheet.Rows[updRow - dgOffSet]["pWOWorkSheetID"].ToString(), rowName, rowValue); dgWorkSheet.DataSource = dtWorkSheet.DefaultView.ToTable(); dgWorkSheet.AllowPaging = true; dgWorkSheet.DataBind(); pnlWSGrid.Update(); Session["dtWS"] = dtWorkSheet.DefaultView.ToTable(); }
protected void txtParentItemNo_TextChanged(object sender, EventArgs e) { lblMessage.Text = ""; pnlStatus.Update(); TextBox _txtParentItemNo = sender as TextBox; DataSet dsItemDetail = BusinessLogic.GetProductInfo(hidItemNo.Value.ToString(), "000000", "01", "PFC"); string rowId = hidItemCtl.Value.ToString().Replace("dgWorkSheet_ctl", "").Replace("_txtParentItemNo", ""); if (dsItemDetail.Tables.Count > 1) //Valid Item { //Update the DataSet dsUpdate(rowId, "ParentItemNo", hidItemNo.Value.ToString()); //Set focus on ParentItemNo in next record string nextId = Convert.ToString(Convert.ToInt32(rowId) + 1); if (nextId == Convert.ToString(Convert.ToInt32(hidRowCount.Value) + dgOffSet) || nextId == Convert.ToString(PageSize + dgOffSet)) { nextId = dgOffSet.ToString(); } string nextCtl = "dgWorkSheet_ctl" + nextId.PadLeft(2, '0').ToString() + "_txtParentItemNo"; //ScriptManager.RegisterClientScriptBlock(_txtActionQty, _txtActionQty.GetType(), "focus", "document.getElementById('" + nextCtl + "').focus();document.getElementById('" + nextCtl + "').focus();", true); smWorkSheet.SetFocus(nextCtl.ToString()); } else //Invalid Item { DropDownList ddlPageNo = Pager1.FindControl("ddlPages") as DropDownList; int updRow = ((Convert.ToInt16(ddlPageNo.SelectedItem.Text) - 1) * PageSize) + Convert.ToInt16(rowId); dsWorkSheet = (DataSet)Session["dsWS"]; _txtParentItemNo.Text = dsWorkSheet.Tables[0].Rows[updRow - dgOffSet]["ParentItemNo"].ToString(); //Update the DataSet dsUpdate(rowId, "ParentItemNo", _txtParentItemNo.Text.ToString()); smWorkSheet.SetFocus(hidItemCtl.Value.ToString()); pnlWSGrid.Update(); DisplayStatusMessage("Item No " + hidItemNo.Value.ToString() + " not on file", "fail"); } //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "scroll", "ScrollIt();", true); }
protected void txtDueDt_TextChanged(object sender, EventArgs e) { lblMessage.Text = ""; pnlStatus.Update(); TextBox _txtDueDt = sender as TextBox; string rowId = _txtDueDt.ClientID.ToString().Replace("dgWorkSheet_ctl", "").Replace("_txtDueDt", ""); if (IsDate(_txtDueDt.Text)) { //Update the DataSet dsUpdate(rowId, "WODueDt", _txtDueDt.Text); //Set focus on DueDt in next record string nextId = Convert.ToString(Convert.ToInt32(rowId) + 1); if (nextId == Convert.ToString(Convert.ToInt32(hidRowCount.Value) + dgOffSet) || nextId == Convert.ToString(PageSize + dgOffSet)) { nextId = dgOffSet.ToString(); } string nextCtl = "dgWorkSheet_ctl" + nextId.PadLeft(2, '0').ToString() + "_txtDueDt"; //ScriptManager.RegisterClientScriptBlock(_txtDueDt, _txtDueDt.GetType(), "focus", "document.getElementById('" + nextCtl + "').focus();document.getElementById('" + nextCtl + "').focus();", true); smWorkSheet.SetFocus(nextCtl.ToString()); } else { DropDownList ddlPageNo = Pager1.FindControl("ddlPages") as DropDownList; int updRow = ((Convert.ToInt16(ddlPageNo.SelectedItem.Text) - 1) * PageSize) + Convert.ToInt16(rowId); dsWorkSheet = (DataSet)Session["dsWS"]; _txtDueDt.Text = String.Format("{0:MM/dd/yyyy}", dsWorkSheet.Tables[0].Rows[updRow - dgOffSet]["WODueDt"]); smWorkSheet.SetFocus(_txtDueDt.ClientID.ToString()); //Update the DataSet dsUpdate(rowId, "WODueDt", _txtDueDt.Text); pnlWSGrid.Update(); DisplayStatusMessage("Date format not valid", "fail"); } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "scroll", "ScrollIt();", true); }