protected void btn_DeleteToDB_Click(object sender, EventArgs e)
{
#region
try
{
bool bResult = false;
#region 取得畫面元件的值
DateTime processtime = DateTime.Now;
#endregion
#region 取得刪除前舊值
DataTable dtTemp = dtMain;//20090722 modified:dtForMasterAndDetail
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
throw new Exception("抓取不到舊值,更新失敗!");
}
#endregion
#region 加入更新條件
//master
htParams.Clear();
//舊值
htParams.Add("ID", dtTemp.Rows[0]["ID"]);
htParams.Add("CODE", dtTemp.Rows[0]["CODE"]);
htParams.Add("CREATEDATE", dtTemp.Rows[0]["CREATEDATE"]);
htParams.Add("CREATEUID", dtTemp.Rows[0]["CREATEUID"]);
htParams.Add("UPDATEDATE", dtTemp.Rows[0]["UPDATEDATE"]);
htParams.Add("UPDATEUID", dtTemp.Rows[0]["UPDATEUID"]);
htParams.Add("ENABLE", dtTemp.Rows[0]["ENABLE"]);
htParams.Add("TYPE_RULE", dtTemp.Rows[0]["TYPE_RULE"]);
htParams.Add("CHAN_NO", dtTemp.Rows[0]["CHAN_NO"]);
htParams.Add("TRACK", dtTemp.Rows[0]["TRACK"]);
htParams.Add("TYPE_NO", dtTemp.Rows[0]["TYPE_NO"]);
htParams.Add("PO_SOURCE_NO_ST", dtTemp.Rows[0]["PO_SOURCE_NO_ST"]);
htParams.Add("PO_SOURCE_NO_END", dtTemp.Rows[0]["PO_SOURCE_NO_END"]);
htParams.Add("SEQ_NO", dtTemp.Rows[0]["SEQ_NO"]);
htParams.Add("ROOT_NO", dtTemp.Rows[0]["ROOT_NO"]);
//需要更新值
htParams.Add("NEW_UPDATEDATE", processtime);
htParams.Add("NEW_UPDATEUID", Session["UID"].ToString());
//detail
htParams2.Clear();
htParams2.Add("PIDForLog", dtTemp.Rows[0]["ID"]);
htParams2.Add("UIDForLog", dtTemp.Rows[0]["CREATEUID"]);
#endregion
ALOModel.MaintainChainPO BCO = new ALOModel.MaintainChainPO(ConnectionDB);
bResult = BCO.DeleteMasterAndDetail(htParams, htParams2, null);
CurrentPageMode = PageCurrentMode.Query;
ResultMsgLabel.Text = "刪除完成";
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
