//確認審核、合約解除
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;
}
}
}
