//確認審核、合約解除 protected void btnUpdate_Command(object sender, CommandEventArgs e) { try { DataSet ds1 = new DataSet(); DataTable dt1 = (DataTable)Session["VDM081_DT1_" + PageTimeStamp.Value]; if (e.CommandName == "btnUpdate")//審核確認 { ParameterList.Clear(); ParameterList.Add(txtVENDOR_CODE.Text); ParameterList.Add(dt1.Rows[0]["CNT_NO"].ToString());//V_OLD_CNT_NO ParameterList.Add(dt1.Rows[0]["EDIT_NO"].ToString());//N_EDIT_NO ParameterList.Add(GetValueSetParameter(dt1.Rows[0]["CREATEDATE"].ToString(), "datetime", false));//D_OLD_CREATEDATE ParameterList.Add(dt1.Rows[0]["CREATEUID"].ToString());//V_OLD_CREATEUID ParameterList.Add(GetValueSetParameter(dt1.Rows[0]["UPDATEDATE"].ToString(), "datetime", false));//D_OLD_UPDATEDATE ParameterList.Add(dt1.Rows[0]["UPDATEUID"].ToString());//V_OLD_UPDATEUID ParameterList.Add(1);//N_NEW_CNT_CONFIRM_CODE(1=已審核,0=未審核) -- 應該是不能修改的 ParameterList.Add(System.DateTime.Now);//D_NEW_CNT_CONFIRM_DATE ParameterList.Add(System.DateTime.Now);//D_NEW_UPDATEDATE ParameterList.Add(Session["UID"].ToString());//V_NEW_UPDATEUID BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB); bco.UpdateVDM_Contract_Confirm(ParameterList, null); ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "CompleteMSG", string.Format("alert('審核確認完成');", Session["UID"].ToString().Trim()), true); } else if (e.CommandName == "btnDelete")//合約解除 { ParameterList.Clear(); ParameterList.Add(txtVENDOR_CODE.Text); ParameterList.Add(dt1.Rows[0]["CNT_NO"].ToString());//V_OLD_CNT_NO ParameterList.Add(dt1.Rows[0]["EDIT_NO"].ToString());//N_EDIT_NO ParameterList.Add(GetValueSetParameter(dt1.Rows[0]["CREATEDATE"].ToString(), "datetime", false));//D_OLD_CREATEDATE ParameterList.Add(dt1.Rows[0]["CREATEUID"].ToString());//V_OLD_CREATEUID ParameterList.Add(GetValueSetParameter(dt1.Rows[0]["UPDATEDATE"].ToString(), "datetime", false));//D_OLD_UPDATEDATE ParameterList.Add(dt1.Rows[0]["UPDATEUID"].ToString());//V_OLD_UPDATEUID ParameterList.Add(0);//N_NEW_CNT_CONFIRM_CODE(1=已審核,0=未審核) -- 應該是不能修改的 ParameterList.Add(System.DBNull.Value);//D_NEW_CNT_CONFIRM_DATE ParameterList.Add(System.DateTime.Now);//D_NEW_UPDATEDATE ParameterList.Add(Session["UID"].ToString());//V_NEW_UPDATEUID BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB); if (bco.QueryisCheckOut(ParameterList) > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "ClientScript", "alert('此合約已經做過月結,無法解除');", true); return; } bco.UpdateVDM_Contract_Confirm(ParameterList, null); ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "CompleteMSG", string.Format("alert('合約解除完成');", Session["UID"].ToString().Trim()), true); } } catch (Exception ex) { if (ex.Message.IndexOf("資料已被他人異動") >= 0) { if (e.CommandName == "btnUpdate") ScriptManager.RegisterStartupScript(this, this.GetType(), "CompleteMSG", "alert('審核確認失敗,此資料已被其他使用者異動,請重新查詢!');", true); else ScriptManager.RegisterStartupScript(this, this.GetType(), "CompleteMSG", "alert('合約解除失敗,此資料已被其他使用者異動,請重新查詢!');", true); } else { ErrorMsgLabel.Text = ex.Message; } } }