/// <summary> /// 將目前頁面Gridview資料存入DB中 /// </summary> private void SaveCurrentPageDataToDB() { #region try { #region //V_DIS_NO IN VARCHAR2, //V_ITEM IN VARCHAR2, //V_PERIOD IN VARCHAR2, //V_VALUE_ARR IN VARCHAR2,--更新陣列組合:ID_DIS_QTY, ID_DIS_QTY,.... //V_USER_ID IN VARCHAR2, //V_SESSION_ID IN VARCHAR2, //V_PG_ID IN VARCHAR2 string strVALUE_ARR = ""; Label lblID = null; TextBox txtDIS_QTY = null; ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(s_DIS_NO); ParameterList.Add(s_ITEM); ParameterList.Add(s_PERIOD); for (Int32 i = 0; i <= GridView1.Rows.Count - 1; i++) { lblID = (Label)GridView1.Rows[i].FindControl("lblID"); txtDIS_QTY = (TextBox)GridView1.Rows[i].FindControl("txtDIS_QTY"); strVALUE_ARR += string.Format("{0}_{1},", lblID.Text.Trim(), txtDIS_QTY.Text.Trim()); } if (strVALUE_ARR.Trim() != "") { if (strVALUE_ARR.Substring(strVALUE_ARR.Length - 1, 1) == ",") { strVALUE_ARR = strVALUE_ARR.Substring(0, strVALUE_ARR.Length - 1); } } ParameterList.Add(strVALUE_ARR); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(string.Format("{0}{1}", PageTimeStamp.Value, Session["UID"].ToString()));//無底線 ParameterList.Add(s_WorkId); #endregion ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB); BCO.UpdateALO12TmpDisQty(ParameterList, null); } catch (Exception ex) { throw ex; } #endregion }