private void Databind() { BCO.MaintainStockTakeFreeze bco = new BCO.MaintainStockTakeFreeze(ConntionDB); DataTable Dt = null; Dt = bco.QueryLocateSection(this.SLP_CodeFile1.Text); this.ddlS.DataSource = Dt; this.ddlS.DataTextField = "LOCATE_SECTION"; this.ddlS.DataValueField = "LOCATE_SECTION"; this.ddlS.DataBind(); this.ddlS.Items.Insert(0, " "); this.ddlE.DataSource = Dt; this.ddlE.DataTextField = "LOCATE_SECTION"; this.ddlE.DataValueField = "LOCATE_SECTION"; this.ddlE.DataBind(); this.ddlE.Items.Insert(0, " "); }
protected void btnUnFree_Click(object sender, EventArgs e) { DataTable Dt = (DataTable)ViewState["Data"]; BCO.MaintainStockTakeFreeze bco = new BCO.MaintainStockTakeFreeze(ConntionDB); for (int i = 0; Dt.Rows.Count > i; i++) { string strCount = ""; ArrayList aList = new ArrayList(); aList.Add(GetValueSetParameter(Dt.Rows[i]["LOCATE_NO"].ToString(), "string")); aList.Add(GetValueSetParameter(Dt.Rows[i]["LOCATE_SECTION"].ToString(), "string")); aList.Add(GetValueSetParameter(Dt.Rows[i]["FREEZE_DATE"].ToString(), "datetime")); aList.Add(GetValueSetParameter(DateTime.Parse((Dt.Rows[i]["UPDATEDATE"].ToString())).ToString("yyyy/MM/dd hhmmss"), "string")); bco.QueryCheckTime(aList, out strCount); if (int.Parse(strCount) == 0) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "IVM031.aspx", "alert(' 資料已被其他使用者異動,更新失敗 ');", true); return; } } //for (int i = 0; Dt.Rows.Count > i; i++) //{ // BCO.MaintainStockTakeFreeze bco = new BCO.MaintainStockTakeFreeze(ConntionDB); // ArrayList aList = new ArrayList(); // aList.Add(GetValueSetParameter(Dt.Rows[i]["LOCATE_NO"].ToString(), "string")); // aList.Add(GetValueSetParameter(Dt.Rows[i]["LOCATE_SECTION"].ToString(), "string")); // aList.Add(GetValueSetParameter(Dt.Rows[i]["FREEZE_DATE"].ToString(), "datetime")); // //aList.Add(GetValueSetParameter(PageTimeStamp.Value, "datetime")); // aList.Add(GetValueSetParameter(Session["UID"].ToString(), "string")); bco.UpdUnFreezeLocateSec(Dt, Session["UID"].ToString(), DBT); //} this.gvData(); }
private DataTable queryData() { ResultMsgLabel.Text = ""; BCO.MaintainStockTakeFreeze bco = new BCO.MaintainStockTakeFreeze(ConntionDB); DataTable Dt = null; Dt = bco.PrintRpt01(); return Dt; }
private void gvData() { ResultMsgLabel.Text = ""; string strFreeze = string.Empty; string strUnFreeze = string.Empty; BCO.MaintainStockTakeFreeze bco = new BCO.MaintainStockTakeFreeze(ConntionDB); ArrayList aList = this.getParameterList(); DataTable Dt; Dt = bco.QueryByFind(aList, out strFreeze, out strUnFreeze); if (Dt.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "IVM031.aspx", "alert(' 查無資料 ');", true); } ViewState["Data"] = Dt; this.GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); this.GridView1.DataSource = Dt; this.GridView1.DataBind(); }
private void Databind() { BCO.MaintainStockTakeFreeze bco = new BCO.MaintainStockTakeFreeze(ConntionDB); DataTable Dt = null; Dt = bco.QueryLocateSection(this.SLP_CodeFile1.Text); this.ddlS.DataSource = Dt; this.ddlS.DataTextField = "LOCATE_SECTION"; this.ddlS.DataValueField = "LOCATE_SECTION"; this.ddlS.DataBind(); this.ddlS.Items.Insert(0, " "); this.ddlE.DataSource = Dt; this.ddlE.DataTextField = "LOCATE_SECTION"; this.ddlE.DataValueField = "LOCATE_SECTION"; this.ddlE.DataBind(); this.ddlE.Items.Insert(0, " "); if (ViewState["SLP_CodeFile1"] == null) { ViewState["ddlS"] = 0; ViewState["ddlE"] = 0; } else { if (ViewState["SLP_CodeFile1"].ToString() != this.SLP_CodeFile1.Text) { ViewState["ddlS"] = 0; ViewState["ddlE"] = 0; } } ViewState["SLP_CodeFile1"] = this.SLP_CodeFile1.Text; }
private void GetLOCATE_SECTION() { BCO.MaintainStockTakeFreeze bco = new BCO.MaintainStockTakeFreeze(ConntionDB); DataTable dt = bco.QueryLocateSection(this.SLP_CodeFile1.Text); DataTable TempTable = new DataTable(); TempTable.Columns.Add(new DataColumn("LOCATE_SECTION")); for (int i = 0; i < dt.Rows.Count; i++) { if (((String.Compare(dt.Rows[i]["LOCATE_SECTION"].ToString().Trim(), txtS.Text, true) > 0) && (String.Compare(dt.Rows[i]["LOCATE_SECTION"].ToString().Trim(), txtE.Text, true) < 0)) || (dt.Rows[i]["LOCATE_SECTION"].ToString().Trim().ToUpper() == txtS.Text.ToUpper()) || (dt.Rows[i]["LOCATE_SECTION"].ToString().Trim().ToUpper() == txtE.Text.ToUpper())) { DataRow dr = TempTable.NewRow(); dr["LOCATE_SECTION"] = dt.Rows[i]["LOCATE_SECTION"].ToString(); TempTable.Rows.Add(dr); } } TempTable.AcceptChanges(); Session["IVM043_SECTION_" + PageTimeStamp.Value] = TempTable; }