/// <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
}