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);
}
