protected void ButtonQuery_Click(object sender, EventArgs e)
{
try
{
//清除目前選擇DATA
this.SelectLabelCode.Text = "";
this.SelectLabelName.Text = "";
GridView1.PageSize = Convert.ToInt32(TextBoxPagesize.Text.Trim());
VDMModel.MaintainVendorAgm bco = new VDMModel.MaintainVendorAgm(ConntionDB);
firstpage = 0;
firstindex = -1;
ParameterList.Clear();
ParameterList.Add(TextBoxRowCountLimit.Text.Trim());
ParameterList.Add("%" + TextBoxCode.Text.Trim() + "%");
databind(bco.QueryByLikeForSLP(ParameterList));
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}//ButtonQuery_Click
//匯出
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
this.ErrorMsgLabel.Text = "";
string s_CheckPage = CheckPage(sender);
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
return;
}
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter((this.ddlPAY_TYPE.Text == "" ? "0" : ddlPAY_TYPE.Text), "int", this.CheckBoxLikeSearch.Checked));
//ParameterList.Add(0); //PAY_TYPE欄位，先放0，待SLP有值後再用上面的Code
ParameterList.Add(GetValueSetParameter(this.txtCOL_DAYS.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.txtCNT_NO.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.EndDate, "date", false));
//是否停止往來
if (this.rdoSTOP_DATE1.Checked == true)
ParameterList.Add(GetValueSetParameter("1", "string", false));
else if (this.rdoSTOP_DATE2.Checked == true)
ParameterList.Add(GetValueSetParameter("2", "string", false));
else
ParameterList.Add(GetValueSetParameter("3", "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B2.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E2.Text, "string", false));
//是否最新合約
if (this.rdoIS_NEW1.Checked == true)
ParameterList.Add(GetValueSetParameter("Y", "string", false));
else
ParameterList.Add(GetValueSetParameter("N", "string", false));
//審核
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_CODE.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.EndDate, "date", false));
//建立人員
ParameterList.Add(GetValueSetParameter(this.txtCREATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
//維護日期
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.EndDate, "date", false));
//維護人員
ParameterList.Add(GetValueSetParameter(this.txtUPDATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(TextBoxRowCountLimit.Text.Trim().Length == 0 ? "10" : TextBoxRowCountLimit.Text);
//廠商名稱
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_NAME.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
DataTable dt_Return = new DataTable();
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
dt_Return = bco.QueryAgmByALL(ParameterList);
if (dt_Return.Rows.Count <= 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM021", string.Format("alert('查無資料');", Session["UID"].ToString().Trim()), true);
return;
}
Response.Clear();
string sFileName = HttpUtility.UrlEncode("VDM02供應商合約_" + DateTime.Now.ToString("yyyyMMdd_hhmmss") + ".xls", System.Text.Encoding.UTF8);
Response.AddHeader("content-disposition", "attachment;filename=" + sFileName);
Response.ContentType = "application/vnd.ms-excel;charset='utf-8'";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
GridView1.DataSource = dt_Return;
GridView1.DataBind();
GridView1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
}
catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); }
finally { }
}
}//page_load
protected void ButtonQuery_Click(object sender, EventArgs e)
{
try
{
this.ErrorMsgLabel.Text = "";
string s_CheckPage = CheckPage(sender);
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
return;
}
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter((this.ddlPAY_TYPE.Text == "" ? "0" : ddlPAY_TYPE.Text), "int", this.CheckBoxLikeSearch.Checked));
//ParameterList.Add(0); //PAY_TYPE欄位，先放0，待SLP有值後再用上面的Code
ParameterList.Add(GetValueSetParameter(this.txtCOL_DAYS.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_NO.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.EndDate, "date", false));
//是否停止往來
if (this.rdoSTOP_DATE1.Checked == true)
ParameterList.Add(GetValueSetParameter("1", "string", false));
else if (this.rdoSTOP_DATE2.Checked == true)
ParameterList.Add(GetValueSetParameter("2", "string", false));
else
ParameterList.Add(GetValueSetParameter("3", "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B2.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E2.Text, "string", false));
//是否最新合約
if (this.rdoIS_NEW1.Checked == true)
ParameterList.Add(GetValueSetParameter("Y", "string", false));
else
ParameterList.Add(GetValueSetParameter("N", "string", false));
//審核
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_CODE.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.EndDate, "date", false));
//建立人員
ParameterList.Add(GetValueSetParameter(this.txtCREATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
//維護日期
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.EndDate, "date", false));
//維護人員
ParameterList.Add(GetValueSetParameter(this.txtUPDATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(TextBoxRowCountLimit.Text.Trim().Length == 0 ? "10" : TextBoxRowCountLimit.Text);
//廠商名稱
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_NAME.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
DataTable dt_Return = new DataTable();
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
dt_Return = bco.QueryAgmByALL(ParameterList);
if (dt_Return.Rows.Count <= 0)
{
//btnExport.Visible = false;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM021", string.Format("alert('查無資料');", Session["UID"].ToString().Trim()), true);
gv_VDM021.DataSource = dt_Return;
gv_VDM021.DataBind();
return;
}
string SessionIDName = "VDM021_gv_ItemInfo" + PageTimeStamp.Value;
gv_VDM021.Visible = true;
Session["SessionID"] = SessionIDName;
Session[SessionIDName] = dt_Return;
gv_VDM021.DataSource = dt_Return;
if (TextBoxPagesize.Text == "")
gv_VDM021.PageSize = 10;
else
gv_VDM021.PageSize = Convert.ToInt32(TextBoxPagesize.Text);
gv_VDM021.PageIndex = 0;
gv_VDM021.DataBind();
//btnExport.Visible = true;
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "VDM021.aspx?Code=VDM02", null, WUI_GMToolbarV.ClickAction.LinkURL);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, true, "", btnExport, WUI_GMToolbarV.ClickAction.ButtonClick);
#region 將Key值存到Session中
ArrayList arl_Key = new ArrayList();
foreach (DataRow drRow in dt_Return.Rows)
{ arl_Key.Add(drRow["CNT_NO"].ToString() + "|" + drRow["EDIT_NO"].ToString()); }
Session["VDM021_SortKey" + PageTimeStamp.Value] = arl_Key;
#endregion
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.ToString();
}
finally { }
}
protected void btnAdd_Mode_Command(object sender, CommandEventArgs e)
{
btnDel.Visible = false;
if (e.CommandName == "btnAdd_Mode")
{
ClearAllField();
slpRESUME_DATE_B.Text = slpCNT_VALID_DATE.Text;
slpRESUME_DATE_E.Text = slpCNT_END_DATE.Text;
txtEDIT_NO.Text = "1";
this.SLP_SLPDate1.Text = System.DateTime.Now.ToShortDateString();
this.SLP_User1.Text = Session["UID"].ToString();
this.SLP_SLPDate2.Text = System.DateTime.Now.ToShortDateString();
this.SLP_User2.Text = Session["UID"].ToString();
}
else if (e.CommandName == "btnCopy_Mode")
{
ClearCopyField();
slpRESUME_DATE_B.Text = slpCNT_VALID_DATE.Text;
slpRESUME_DATE_E.Text = slpCNT_END_DATE.Text;
txtEDIT_NO.Text = "1";
this.SLP_SLPDate1.Text = System.DateTime.Now.ToShortDateString();
this.SLP_User1.Text = Session["UID"].ToString();
this.SLP_SLPDate2.Text = System.DateTime.Now.ToShortDateString();
this.SLP_User2.Text = Session["UID"].ToString();
}
else if (e.CommandName == "btnModify_Mode")
{
btnAdd.CommandName = "確定修改";
}
if (slpCNT_CONFIRM_CODE.Text == "1") //已審核
{
DisableForm(true);//true 不可修改
SpecCalc(true);//false 不可修改 -> 特殊計算處理
btnAdd.Enabled = false;
slpRESUME_DATE_B.ReadOnly = true;
if (Request["VDM021"].ToString() != "ADD")
{
GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.UpdateEdit;
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "VDM021.aspx?Code=VDM02", null, WUI_GMToolbarV.ClickAction.LinkURL);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, false, "", btnAdd, WUI_GMToolbarV.ClickAction.ButtonClick);
}
//最新合約資料才可新增履歷
ParameterList.Clear();
ParameterList.Add(txtVENDOR_CODE.Text); //廠商統編
ParameterList.Add(txtCNT_NO.Text); //合約編號
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
string Dt = bco.QueryMaxEditNo(ParameterList);
if (txtEDIT_NO.Text != Dt)
{
slpRESUME_DATE_E.ReadOnly = true;
btnADD_RESUME.Enabled = false;
btnExtendDate.Enabled = false;
}
else
{
slpRESUME_DATE_E.ReadOnly = false;
btnADD_RESUME.Enabled = true;
btnExtendDate.Enabled = true;
}
}
else //未審核
{
DisableForm(false);//true 不可修改
if (txtEDIT_NO.Text.Trim() != "1") //只有異動序號在1的時候才可以修改
{
slpCNT_VALID_DATE.ReadOnly = true;
slpCNT_END_DATE.ReadOnly = true;
}
SpecCalc(false);//false 不可修改 -> 特殊計算處理
btnAdd.Enabled = true;
//slpCNT_CONFIRM_DATE.Text = DateTime.Today.ToString();
if (Request["VDM021"].ToString() != "ADD")
{
GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.UpdateEdit;
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "VDM021.aspx?Code=VDM02", null, WUI_GMToolbarV.ClickAction.LinkURL);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, true, "", btnAdd, WUI_GMToolbarV.ClickAction.ButtonClick);
}
}
btnAdd_Mode.Visible = false;
btnModify_Mode.Visible = false;
btnCopy_Mode.Visible = false;
btnAdd.Visible = true;
slpACCEPT_RATE.ReadOnly = true;
slpRETURN_RATE.ReadOnly = true;
radFixAmt.Checked = true;
radFixPercent.Checked = false;
slpPAY_TYPE.Text = "";
slpPAY_TYPE.ReadOnly = true;
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, false, "", btnDel, WUI_GMToolbarV.ClickAction.ButtonClick);
UpdatePanel1.Update();
UpdatePanel2.Update();
UpdatePanel3.Update();
UpdatePanel4.Update();
UpdatePanel4_1.Update();
UpdatePanel5.Update();
UpdatePanel6.Update();
UpdatePanel_SUBSIDY2.Update();
UpdatePanel9.Update();
UpdatePanel7.Update();
}
//新增履歷(Confirm確認後的處理)
//strExtend 0:新增履歷 1:延長結束日履歷
private void AddResume(string strExtend)
{
DataSet ds = new DataSet();
string SessionIDName = "VDM022_" + PageTimeStamp.Value;
ds = (DataSet)Session[SessionIDName];
try
{
#region 異動合約主檔履歷結束日
ParameterList.Clear();
ParameterList.Add(txtVENDOR_CODE.Text);
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["CNT_NO"].ToString());//V_OLD_CNT_NO
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["EDIT_NO"].ToString());//N_EDIT_NO
ParameterList.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["CREATEDATE"].ToString(), "datetime", false));//D_OLD_CREATEDATE
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["CREATEUID"].ToString());//V_OLD_CREATEUID
ParameterList.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false));//D_OLD_UPDATEDATE
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["UPDATEUID"].ToString());//V_OLD_UPDATEUID
ParameterList.Add(slpRESUME_DATE_E.Text);//N_RESUME_DATE_E 履歷迄日
ParameterList.Add(System.DateTime.Now);//D_NEW_UPDATEDATE
ParameterList.Add(Session["UID"].ToString());//V_NEW_UPDATEUID
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
bco.UpdateResumeEDate(ParameterList, null);
#endregion
//把所有資料存到DataSet後傳給VDM101
DataTable dt = ds.Tables["Table_0"];
dt.Rows[0]["EDIT_NO"] = Int16.Parse(dt.Rows[0]["EDIT_NO"].ToString()) + 1;
dt.Rows[0]["VENDOR_CODE"] = txtVENDOR_CODE.Text;
dt.Rows[0]["PAY_TYPE"] = ddlPAY_TYPE.Text;
dt.Rows[0]["COL_DAYS"] = txtCOL_DAYS.Text;
dt.Rows[0]["CNT_VALID_DATE"] = slpCNT_VALID_DATE.Text;
dt.Rows[0]["CNT_END_DATE"] = slpCNT_END_DATE.Text;
dt.Rows[0]["CNT_CONFIRM_CODE"] = slpCNT_CONFIRM_CODE.Text;
dt.Rows[0]["CNT_CONFIRM_DATE"] = System.DBNull.Value;
dt.Rows[0]["CNT_NO"] = txtCNT_NO.Text;
dt.Rows[0]["TRACE_DATE_B"] = System.DBNull.Value;//VARCHAR2(6)型態
dt.Rows[0]["TRACE_DATE_E"] = System.DBNull.Value;//VARCHAR2(6)型態
dt.Rows[0]["STOP_DATE"] = System.DBNull.Value;
dt.Rows[0]["RESUME_DATE_B"] = DateTime.Parse(slpRESUME_DATE_E.Text).AddDays(1).ToShortDateString();//履歷迄日+1
dt.Rows[0]["RESUME_DATE_E"] = slpCNT_END_DATE.Text;//合約迄日
if (slpBELOW_SUBVEN.Text.Trim().Length == 0) dt.Rows[0]["BELOW_SUBVEN"] = System.DBNull.Value;
else dt.Rows[0]["BELOW_SUBVEN"] = slpBELOW_SUBVEN.Text;
if (slpBELOW_SUBVEN_PAY_TYPE.Text.Trim().Length == 0) dt.Rows[0]["BELOW_SUBVEN_PAY_TYPE"] = System.DBNull.Value;
else dt.Rows[0]["BELOW_SUBVEN_PAY_TYPE"] = slpBELOW_SUBVEN_PAY_TYPE.Text;
if (slpBELOW_SUBVEN_TYPE.Text.Trim().Length == 0) dt.Rows[0]["BELOW_SUBVEN_TYPE"] = System.DBNull.Value;
else dt.Rows[0]["BELOW_SUBVEN_TYPE"] = slpBELOW_SUBVEN_TYPE.Text;
if (slpBELOW_SUBVEN_RATE.Text.Trim().Length == 0) dt.Rows[0]["BELOW_SUBVEN_RATE"] = System.DBNull.Value;
else dt.Rows[0]["BELOW_SUBVEN_RATE"] = slpBELOW_SUBVEN_RATE.Text;
ds.Tables["Table_7"].Rows[0]["COUNT_TYPE"] = rdoCOUNT_TYPE1.Checked == true ? "1" : "2";
ds.Tables["Table_7"].Rows[0]["PAY_TYPE"] = SLP_CodeFile4.Text;
ds.Tables["Table_7"].Rows[0]["ANNUAL_RULE"] = SLP_CodeFile3.SelectedValue;
foreach (DataRow dr in ds.Tables["Table_1"].Rows) //店群門市
dr["EDIT_NO"] = dt.Rows[0]["EDIT_NO"];
foreach (DataRow dr in ds.Tables["Table_2"].Rows) //單品
dr["EDIT_NO"] = dt.Rows[0]["EDIT_NO"];
foreach (DataRow dr in ds.Tables["Table_3"].Rows) //獎勵金
dr["EDIT_NO"] = dt.Rows[0]["EDIT_NO"];
ds.AcceptChanges();
Session[SessionIDName] = ds;
string strUrl = string.Format("location.replace('VDM101.aspx?Code=VDM10&arl_Key=" + Request.QueryString["arl_Key"] + "&SessionIDName=" + SessionIDName + "&ROWNUM=" + ViewState["ROWNUM"].ToString() + "&EXTEND=" + strExtend + "');", Session["UID"].ToString().Trim());
ScriptManager.RegisterStartupScript(Page, GetType(), "AddResume", strUrl, true);
}
catch (Exception ex)
{
if (ex.Message.IndexOf("資料已被他人異動") >= 0)
ScriptManager.RegisterStartupScript(this, this.GetType(), "DelComplete", "alert('履歷異動失敗，此資料已被其他使用者異動，請重新查詢！');", true);
else
{
lblErrMsg1.Text = ex.Message;
UpdatePanel2.Update();
}
}
}
//停止往來計算
protected void STOP_COUNT()
{
try
{
ParameterList.Clear();
ParameterList.Add(slpSTOP_DATE.Text);//V_TRACE_YM_S 0
ParameterList.Add(txtVENDOR_CODE.Text);//V_VENDOR_CODE 1
ParameterList.Add(txtCNT_NO.Text);//V_CNT_NO 2
ParameterList.Add(ViewState["EDIT_NO"].ToString());//N_EDIT_NO 3
ParameterList.Add(Session["UID"].ToString());//V_USER_ID 4
//異動合約主檔資料的PK欄位
string SessionIDName = "VDM022_" + PageTimeStamp.Value;
DataSet ds = (DataSet)Session[SessionIDName];
ParameterList.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["CREATEDATE"].ToString(), "datetime", false));//D_OLD_CREATEDATE 5
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["CREATEUID"].ToString());//V_OLD_CREATEUID 6
ParameterList.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false));//D_OLD_UPDATEDATE 7
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["UPDATEUID"].ToString());//V_OLD_UPDATEUID 8
ParameterList.Add(System.DateTime.Now);//D_NEW_UPDATEDATE 9
ParameterList.Add(Session["UID"].ToString());//V_NEW_UPDATEUID 10
string V_MSG, V_STATUS_CREATEUID;
DateTime D_STATUS_CREATEDATE;
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
//((ScriptManager)Page.Controls[0].Controls[3].FindControl("ScriptManager1")).AsyncPostBackTimeout = 1800;
bco.StopCloseMonth(ParameterList, null, out V_MSG, out V_STATUS_CREATEUID, out D_STATUS_CREATEDATE);
if (V_MSG != "")
{
lblErrMsg1.Text = V_MSG + "，結帳人員：" + V_STATUS_CREATEUID + "，結帳時間：" + D_STATUS_CREATEDATE.ToString() + "。";
}
else
{
ds.AcceptChanges();
Session[SessionIDName] = ds;
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "btnSTOP_COUNT", "if (confirm('停止往來帳款試算成功，查詢 【供應商各項扣款表】？')){document.location.replace('../VAM/VAM134R.aspx');}else {document.location.replace('VDM021.aspx');}", true);"VDM022.aspx?arl_Key=VDM021_SortKey" + PageTimeStamp.Value + "&VDM021=EDIT&CNT_NO=" + e.Row.Cells[2].Text + "&EDIT_NO=" + e.Row.Cells[7].Text
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "btnSTOP_COUNT", "if (confirm('停止往來帳款試算成功，查詢 【供應商各項扣款表】？')){document.location.replace('../VAM/VAM131.aspx?Code=VAM13');} else {document.location.replace('VDM022.aspx?arl_Key=" + Request.QueryString["arl_Key"] + "&isToolBar=N&Code=VDM02&VDM021=EDIT&CNT_NO=" + txtCNT_NO.Text + "&EDIT_NO=" + txtEDIT_NO.Text + "');}", true);
}
UpdatePanel2.Update();
}
catch (Exception ex)
{
lblErrMsg1.Text = "帳款往來計算不成功 !! " + ex.Message;
UpdatePanel2.Update();
}
}
//停止往來計算(檢核)
protected void STOP_COUNT_Check()
{
try
{
TextBox tb = (TextBox)slpSTOP_DATE.FindControl("TextBoxCode");
if (slpSTOP_DATE.Text.Trim().Length == 0)
{
string sc = "alert('請輸入停止往來日');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
if (DateTime.Parse(slpSTOP_DATE.Text) < DateTime.Parse(slpRESUME_DATE_B.Text) || DateTime.Parse(slpSTOP_DATE.Text) > DateTime.Parse(slpRESUME_DATE_E.Text))
{
string sc = "alert('停止往來日必須介於履歷起始日與履歷結束日中間');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
//找出最大的結帳年月
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
string maxYM = bco.QueryMaxYM();
if (maxYM == "")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", "alert('無結帳年月，請重新輸入');", true);
return;
}
if (DateTime.Parse(slpSTOP_DATE.Text) <= DateTime.Parse(maxYM.Substring(0, 4) + "/" + maxYM.Substring(4, 2) + "/26"))
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", "alert('輸入的日期已結過帳，請重新輸入');", true);
return;
}
if (DateTime.Parse(slpSTOP_DATE.Text) < DateTime.Today)
{
string sc = "if(confirm('您所輸入的停止往來日小於系統日期，是否仍確定更新？')){this.disabled=true;__doPostBack('STOP_COUNT','');} else {";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);}";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
STOP_COUNT();
UpdatePanel2.Update();
}
catch (Exception ex)
{
lblErrMsg1.Text = "帳款往來計算不成功 !! " + ex.Message;
UpdatePanel2.Update();
}
}
//追溯計算(檢核)
protected void RE_COUNT_Check()
{
try
{
if (slpTRACE_DATE_B.Text.Trim().Length < 6)
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_B.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('請輸入正確之日期格式(YYYY/MM)');";
if (slpTRACE_DATE_B.Text.Trim().Length == 0)
sc = "alert('請輸入追溯年月(起)');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
if (slpTRACE_DATE_E.Text.Trim().Length < 6)
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('請輸入正確之日期格式(YYYY/MM)');";
if (slpTRACE_DATE_E.Text.Trim().Length == 0)
sc = "alert('請輸入追溯年月(迄)');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
string trace1 = slpTRACE_DATE_B.Text.Substring(0, 4) + "/" + slpTRACE_DATE_B.Text.Substring(4, 2) + "/01";
string trace2 = slpTRACE_DATE_E.Text.Substring(0, 4) + "/" + slpTRACE_DATE_E.Text.Substring(4, 2) + "/01";
DateTime dt;
if (!DateTime.TryParse(trace1, out dt))
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_B.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('請輸入正確之日期格式(YYYY/MM)');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
if (!DateTime.TryParse(trace2, out dt))
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('請輸入正確之日期格式(YYYY/MM)');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
if (DateTime.Parse(trace1) > DateTime.Parse(trace2))
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_B.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('追溯年月(起)不可大於追溯年月(迄)');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
if (DateTime.Parse(trace2).Year > DateTime.Today.Year)
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('追溯年月(迄)不可大於系統年月，請重新設定');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
if (DateTime.Parse(trace2).Year == DateTime.Today.Year && DateTime.Parse(trace2).Month > DateTime.Today.Month)
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)slpTRACE_DATE_E.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('追溯年月(迄)不可大於系統年月，請重新設定');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
if (txtYEAR_MONTH.Text.Trim().Length < 6)
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)txtYEAR_MONTH.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('請輸入正確之日期格式(YYYY/MM)');";
if (txtYEAR_MONTH.Text.Trim().Length == 0)
sc = "alert('請輸入追溯掛帳年月');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
string trace3 = txtYEAR_MONTH.Text.Substring(0, 4) + "/" + txtYEAR_MONTH.Text.Substring(4, 2) + "/01";
if (!DateTime.TryParse(trace3, out dt))
{
TextBox tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)txtYEAR_MONTH.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string sc = "alert('請輸入正確之日期格式(YYYY/MM)');";
sc += @"window.setTimeout(function set_focus(){document.all['" + tb.ClientID + "'].focus();document.all['" + tb.ClientID + "'].select();}, 1800);";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", sc, true);
return;
}
//找出最大的結帳年月
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
string maxYM = bco.QueryMaxYM();
if (!(string.Compare(txtYEAR_MONTH.Text, maxYM) > 0))
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", "alert('該合約已結帳至" + maxYM + "月，請重新輸入掛帳年月');", true);
return;
}
TextBox Tb = (TextBox)((ASP.wui_slp_slp_numberupdown_ascx)txtYEAR_MONTH.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode");
string Sc = @"if(confirm('避免供應商追溯金額為負值，請再度確認掛帳年月，以免產生負值的各項扣款報表，是否確定進行追溯？')){this.disabled=true;__doPostBack('RE_COUNT','');} else {";
Sc += @"window.setTimeout(function set_focus(){document.all['" + Tb.ClientID + "'].focus();document.all['" + Tb.ClientID + "'].select();}, 1800);}";
//string Sc = @"if(confirm('避免供應商追溯金額為負值，請再度確認掛帳年月，以免產生負值的各項扣款報表，是否確定進行追溯？')){this.disabled=true;__doPostBack('RE_COUNT','');}";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022.aspx", Sc, true);
UpdatePanel2.Update();
}
catch (Exception ex)
{
lblErrMsg1.Text = "帳款追溯不成功 !! " + ex.Message;
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "btnSTOP_COUNT_fail", "alert('帳款追溯不成功 !! " + ex.Message + "');", true);
UpdatePanel2.Update();
}
}
protected void btnExtendDate_Click(object sender, EventArgs e)
{
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
string strLastMonth = bco.GetLastCheckMonth();
slpRESUME_DATE_E.Text = strLastMonth.Substring(0, 4) + "/" + strLastMonth.Substring(4, 2) + "/25";
UpdatePanel2.Update();
if (DateTime.Parse(slpRESUME_DATE_B.Text) >= DateTime.Parse(slpRESUME_DATE_E.Text))
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "ClientScript", "alert('履歷結束日須大於履歷起始日');", true);
return;
}
//if (DateTime.Parse(slpCNT_END_DATE.Text) <= DateTime.Parse(slpRESUME_DATE_E.Text))
//{
// ScriptManager.RegisterStartupScript(Page, this.GetType(), "ClientScript", "alert('履歷結束日須小於合約結束日');", true);
// return;
//}
if (ViewState["STOP_DATE"].ToString() != "")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "ClientScript", "alert('該份合約已終止往來，無法新增履歷');", true);
return;
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "if (confirm('確定執行後舊合約的【履歷結束日】將無法還原，是否確定新增履歷')){this.disabled=true;__doPostBack('AddResume2','');}", true);
}
//刪除
protected void btnDel_Click(object sender, EventArgs e)
{
if (slpCNT_CONFIRM_CODE.SelectedValue == "1")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022_alert", "alert('請先進行合約解除再刪除');", true);
return;
}
try
{
DataSet ds = new DataSet();
DateTime DTime = DateTime.Now;
ds = (DataSet)Session["VDM022_" + PageTimeStamp.Value];
ArrayList ArrList1 = new ArrayList();
ArrList1.Add(ds.Tables["Table_0"].Rows[0]["VENDOR_CODE"].ToString());//V_OLD_VENDOR_CODE
ArrList1.Add(ds.Tables["Table_0"].Rows[0]["CNT_NO"].ToString());//V_OLD_CNT_NO
ArrList1.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["EDIT_NO"].ToString(), "int", false));//N_OLD_EDIT_NO
ArrList1.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["CREATEDATE"].ToString(), "datetime", false));//D_OLD_CREATEDATE
ArrList1.Add(ds.Tables["Table_0"].Rows[0]["CREATEUID"].ToString());//V_OLD_CREATEUID
ArrList1.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false));//D_OLD_UPDATEDATE
ArrList1.Add(ds.Tables["Table_0"].Rows[0]["UPDATEUID"].ToString());//V_OLD_UPDATEUID
ArrList1.Add(DTime);//D_NEW_UPDATEDATE
ArrList1.Add(Session["UID"].ToString());//V_NEW_UPDATEUID
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
bco.DeleteVDM022(ArrList1, null);
ScriptManager.RegisterStartupScript(this, this.GetType(), "DelComplete", "alert('刪除完成！');location.replace('VDM021.aspx?Code=VDM02');", true);
}
catch (Exception ex)
{
if (ex.Message.IndexOf("資料已被他人異動") >= 0)
ScriptManager.RegisterStartupScript(this, this.GetType(), "DelComplete", "alert('刪除失敗，此資料已被其他使用者異動，請重新查詢！');", true);
else
{
ErrorMsgLabel.Text = ex.Message;
UpdatePanel6.Update();
}
}
}
private void Bind_CODE_FILE_Control()
{
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
DataTable dtResult = new DataTable();
#region 油價補貼/離島配送費的收取方式選項資料載入
ParameterList.Clear();
ParameterList.Add("I3"); //CATEGORY
ParameterList.Add("2"); //SCODE
dtResult = bco.Query_SYS_CODE_DETL(ParameterList);
ParameterList.Clear();
ParameterList.Add("I3"); //CATEGORY
ParameterList.Add("4"); //SCODE
dtResult.Merge(bco.Query_SYS_CODE_DETL(ParameterList));
ddlSUBSIDY2_PAY_TYPE.Items.Clear();
ddlSUBSIDY1_PAY_TYPE.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
ddlSUBSIDY2_PAY_TYPE.Items.Add(new ListItem(dtResult.Rows[i]["EXPLAIN"].ToString(), dtResult.Rows[i]["SCODE"].ToString().Trim()));
ddlSUBSIDY1_PAY_TYPE.Items.Add(new ListItem(dtResult.Rows[i]["EXPLAIN"].ToString(), dtResult.Rows[i]["SCODE"].ToString().Trim()));
}
ddlSUBSIDY2_PAY_TYPE.SelectedValue = "4"; //"牌價"
ddlSUBSIDY1_PAY_TYPE.SelectedValue = "4"; //"牌價"
#endregion
#region 油價補貼 補貼規則選項載入
ParameterList.Clear();
ParameterList.Add("I4"); //CATEGORY
ParameterList.Add("2"); //SCODE
dtResult = bco.Query_SYS_CODE_DETL(ParameterList);
ParameterList.Clear();
ParameterList.Add("I4"); //CATEGORY
ParameterList.Add("3"); //SCODE
dtResult.Merge(bco.Query_SYS_CODE_DETL(ParameterList));
ParameterList.Clear();
ParameterList.Add("I4"); //CATEGORY
ParameterList.Add("6"); //SCODE
dtResult.Merge(bco.Query_SYS_CODE_DETL(ParameterList));
ParameterList.Clear();
ParameterList.Add("I4"); //CATEGORY
ParameterList.Add("7"); //SCODE
dtResult.Merge(bco.Query_SYS_CODE_DETL(ParameterList));
ddlSUBSIDY2_RULE.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
ddlSUBSIDY2_RULE.Items.Add(new ListItem(dtResult.Rows[i]["EXPLAIN"].ToString(), dtResult.Rows[i]["SCODE"].ToString().Trim()));
}
ddlSUBSIDY2_RULE.SelectedValue = "6"; //店進-店退
ViewState["Temp_SUBSIDY2_RULE_Selected_OLD"] = ddlSUBSIDY2_RULE.SelectedValue;
#endregion
#region 離島配送費 補貼規則選項載入
ParameterList.Clear();
ParameterList.Add("I4"); //CATEGORY
ParameterList.Add("6"); //SCODE
dtResult = bco.Query_SYS_CODE_DETL(ParameterList);
ParameterList.Clear();
ParameterList.Add("I4"); //CATEGORY
ParameterList.Add("7"); //SCODE
dtResult.Merge(bco.Query_SYS_CODE_DETL(ParameterList));
ddlSUBSIDY1_RULE.Items.Clear();
for (int i = 0; i < dtResult.Rows.Count; i++)
{
ddlSUBSIDY1_RULE.Items.Add(new ListItem(dtResult.Rows[i]["EXPLAIN"].ToString(), dtResult.Rows[i]["SCODE"].ToString().Trim()));
}
ddlSUBSIDY1_RULE.SelectedValue = "6"; //店進-店退
#endregion
}
//確定新增 / 確定修改
protected void btnAdd_Command(object sender, CommandEventArgs e)
{
string strScript;
if (((DropDownList)SLP_CodeFile4.FindControl("D1")).SelectedItem.Text == "冊")
{
strScript = "alert('年度獎勵金〔收取方式=冊〕 暫不提供使用，請重新選擇');";
strScript += "try { document.getElementById('" + ((DropDownList)SLP_CodeFile4.FindControl("D1")).ClientID + "').focus();}catch(e){}";
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", strScript, true);
return;
}
DataSet ds = new DataSet();
ds = (DataSet)Session["VDM022_" + PageTimeStamp.Value];
//牌價檢核 -- 獎勵金
foreach (GridViewRow ddr in GridView_3.Rows)
{
if (((Label)ddr.FindControl("lblPAY_TYPE_Name")).Text == "牌價")
foreach (DataRow dr in ds.Tables["Table_3"].Rows)
{
if (dr.RowState != DataRowState.Deleted)
{
if (dr["PAY_TYPE"].ToString() == "4")
{
DataRow[] drs = ds.Tables["Table_4"].Select("PID='" + dr["ID"].ToString() + "'");
if (drs.Length == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('" + TargetType[Int16.Parse(dr["TARGET_TYPE"].ToString())] + "沒有設定店群，收取方式不能選擇牌價，請重新設定');", true);
return;
}
}
}
}
}
//牌價檢核 -- 年度獎勵金
if (((DropDownList)SLP_CodeFile4.FindControl("D1")).SelectedItem.Text == "牌價")
{
if (ds.Tables["Table_6"].Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('年度獎勵金沒有設定店群，收取方式不能選擇牌價，請重新設定');", true);
return;
}
}
if (rdoCOUNT_TYPE2.Checked)
{
if (GridView_6.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('年度獎勵金設定[計算方式]＝部份店群，請設定店群、門市資料');", true);
return;
}
}
#region 油價補貼 資料檢核
//收取方式的規則-成本
if (ddlSUBSIDY2_PAY_TYPE.SelectedValue == "2")
{
//if (rblSUBSIDY2_COUNT_TYPE.SelectedValue == "2")
//{
// ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為成本時，計算方式不能選擇部份店群，請重新設定');", true);
// return;
//}
if (!((ddlSUBSIDY2_RULE.SelectedValue == "2") || (ddlSUBSIDY2_RULE.SelectedValue == "3")))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為成本時，只允許選取[廠進-廠退]或[廠進]規則，請重新設定');", true);
return;
}
}
//收取方式的規則-牌價
if (ddlSUBSIDY2_PAY_TYPE.SelectedValue == "4")
{
if (rblSUBSIDY2_COUNT_TYPE.SelectedValue == "1")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為牌價時，計算方式不能選擇全店群，請重新設定');", true);
return;
}
if (!((ddlSUBSIDY2_RULE.SelectedValue == "6") || (ddlSUBSIDY2_RULE.SelectedValue == "7")))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為牌價時，只允許選取[店進-店退]或[店進]規則，請重新設定');", true);
return;
}
}
if (rblSUBSIDY2_COUNT_TYPE.SelectedValue == "2")
{
if (this.GridView_SUBSIDY2.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼計算方式選擇部分店群，但是尚未設定計算店群');", true);
return;
}
}
//檢查油價補貼設定，若計算方式非不計算，則費率%必須要輸入
if (rblSUBSIDY2_COUNT_TYPE.SelectedValue != "0")
{
if (slpSUBSIDY2_RATE.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼若計算方式非不計算，則費率%必須要輸入');", true);
return;
}
}
#endregion
//檢查離島配送設定，若計算方式非不計算，則費率%必須要輸入
if (rblSUBSIDY1_COUNT_TYPE.SelectedValue != "0")
{
if (slpSUBSIDY1_RATE.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('離島配送若計算方式非不計算，則費率%必須要輸入');", true);
return;
}
}
//檢查離島配送費設定，收取方式只能設定為牌價
if (ddlSUBSIDY1_PAY_TYPE.SelectedValue != "4")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('離島配送費的收取方式只能設定為牌價');", true);
return;
}
string s_CheckPage = CheckPage(sender, ds);
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "document.getElementById('" + VDM022_txtFocus.ClientID + "').focus();document.getElementById('" + VDM022_txtFocus.ClientID + "').select();", true);
return;
}
try
{
DateTime DTime = DateTime.Now;
if (e.CommandName == "確定新增")
{
//檢核合約期間是否重複
ParameterList.Clear();
ParameterList.Add(txtVENDOR_CODE.Text); //廠商統編
ParameterList.Add(DateTime.Parse(slpCNT_END_DATE.Text).ToString("yyyy/MM/dd")); //合約結束日
ParameterList.Add(DateTime.Parse(slpCNT_VALID_DATE.Text).ToString("yyyy/MM/dd")); //合約生效日
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
int dupRec = bco.CheckContDup(ParameterList);
if (dupRec != 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('合約期間重複，請重新設定');", true);
return;
}
ParameterList.Clear();
ParameterList.Add(txtVENDOR_CODE.Text); //0.
ParameterList.Add(1);//1.N_EDIT_NO
ParameterList.Add(GetValueSetParameter(this.slpCNT_VALID_DATE.Text.Trim(), "date", false)); //2.
ParameterList.Add(0);//3.N_CNT_CONFIRM_CODE(1=已審核,0=未審核)
ParameterList.Add(System.DBNull.Value);//4.D_CNT_CONFIRM_DATE
ParameterList.Add(GetValueSetParameter(this.slpCNT_END_DATE.Text.Trim(), "date", false));//5.D_CNT_END_DATE
ParameterList.Add(GetValueSetParameter(this.slpBELOW_SUBVEN.Text.Trim(), "float", false));//6.N_BELOW_SUBVEN
ParameterList.Add(txtCOL_DAYS.Text);//7.N_COL_DAYS
ParameterList.Add(GetValueSetParameter(this.ddlPAY_TYPE.Text.Trim(), "int", false));//8.N_PAY_TYPE結帳方式 1:月結,2:期別結
ParameterList.Add(System.DBNull.Value);//9.D_STOP_DATE
ParameterList.Add(System.DBNull.Value);//10.V_TRACE_DATE_B
ParameterList.Add(System.DBNull.Value);//11.V_TRACE_DATE_E
ParameterList.Add(slpCNT_VALID_DATE.Text);//12.D_RESUME_DATE_B=合約起日
ParameterList.Add(slpCNT_END_DATE.Text);//13.D_RESUME_DATE_E=合約迄日
ParameterList.Add(slpBELOW_SUBVEN_TYPE.Text); //14.
ParameterList.Add(GetValueSetParameter(this.slpBELOW_SUBVEN_RATE.Text.Trim(), "float", false));//15.N_BELOW_SUBVEN_RATE
ParameterList.Add(slpBELOW_SUBVEN_PAY_TYPE.Text); //16.
ParameterList.Add((GetRowCount(ds.Tables["Table_2"]) == 0 ? 0 : 1));//17.N_BELOW_SUBVEN_ITEM_FLAG 單品FLAG(0:無設定單品1:有設定單品)
ParameterList.Add((GetRowCount(ds.Tables["Table_1"]) == 0 ? 0 : 1));//18.N_BELOW_SUBVEN_STORE_FLAG 排除店群門市FLAG(0:無設定1:有設定)
ParameterList.Add(System.DBNull.Value); //19.V_TRACING_CHECK_MONTH
ParameterList.Add(Session["UID"].ToString());//20.V_CREATEUID
ParameterList.Add(DTime); //21.D_CREATEDATE
ParameterList.Add(Session["UID"].ToString());//22.V_UPDATEUID
ParameterList.Add(DTime); //23.D_UPDATEDATE
ParameterList.Add(""); //24.V_CNT_NO 履歷使用(這邊沒用到)
ParameterList.Add(rblSUBSIDY2_TYPE.SelectedValue); //25.油價補貼 補貼類別
ParameterList.Add(rblSUBSIDY2_COUNT_TYPE.SelectedValue);//26.油價補貼 計算方式
ParameterList.Add(slpSUBSIDY2_RATE.Text.Trim()); //27.油價補貼 費率
ParameterList.Add(ddlSUBSIDY2_PAY_TYPE.SelectedValue); //28.油價補貼 收取方式
ParameterList.Add(ddlSUBSIDY2_RULE.SelectedValue); //29.油價補貼 規則
ParameterList.Add(rblSUBSIDY1_COUNT_TYPE.SelectedValue);//30.離島配送費 計算方式
ParameterList.Add(slpSUBSIDY1_RATE.Text.Trim()); //31.離島配送費 費率
ParameterList.Add(ddlSUBSIDY1_PAY_TYPE.SelectedValue); //32.離島配送費 收取方式
ParameterList.Add(ddlSUBSIDY1_RULE.SelectedValue); //33.離島配送費 規則
ParameterList.Add(rblSUBSIDY4_COUNT_TYPE.SelectedValue);//34.轉運費 計算方式
//新增年度獎勵金
ArrayList ArrList = new ArrayList();
ArrList.Add(1);//N_EDIT_NO
ArrList.Add(1);//ANNUAL_TYPE 固定給1
ArrList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", false));
ArrList.Add(GetValueSetParameter((rdoCOUNT_TYPE1.Checked ? "1" : "2"), "int", false));//COUNT_TYPE計算方式，1.全店群2.部份店群
ArrList.Add(GetValueSetParameter(SLP_CodeFile4.Text.Trim(), "int", false));//PAY_TYPE收取方式(1:冊,2:成本,3:零售價,4:牌價,5:本體價)
ArrList.Add(GetValueSetParameter(SLP_CodeFile3.SelectedValue, "int", false));//ANNUAL_RULE規則(廠商進＋廠商退、廠商進-廠商退、廠商進、廠商退 、店群進＋店群退、店群進-店群退、店群進、店群退)
ArrList.Add(Session["UID"].ToString());//V_CREATEUID
ArrList.Add(DTime);//D_CREATEDATE
ArrList.Add(Session["UID"].ToString());//V_UPDATEUID
ArrList.Add(DTime);//D_UPDATEDATE
string V_CNT_NO = "";
//給店群門市的TARGET_NO值
foreach (DataRow dr in ds.Tables["Table_3"].Rows)
foreach (DataRow Dr in ds.Tables["Table_4"].Rows)
if (Dr["PID"].ToString() == dr["ID"].ToString())
Dr["TARGET_NO"] = dr["TARGET_TYPE"];
//BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
bco.CreateVendorAgm(ParameterList, ArrList, ds, null, false, out V_CNT_NO);
txtCNT_NO.Text = V_CNT_NO;
ArrayList arl_Key = new ArrayList();
arl_Key.Add(V_CNT_NO + "|" + "1");//新增的Edit_No = 1
Session["VDM021_SortKey" + PageTimeStamp.Value] = arl_Key;
ScriptManager.RegisterStartupScript(this, this.GetType(), "ClientScript", "alert('新增完成');location.replace('VDM022.aspx?arl_Key=VDM021_SortKey" + PageTimeStamp.Value + "&isToolBar=N&Code=VDM02&VDM021=EDIT&CNT_NO=" + V_CNT_NO + "&EDIT_NO=1');", true);
}
else //確定修改
{
ParameterList.Clear();
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["VENDOR_CODE"].ToString()); //0.V_OLD_VENDOR_CODE
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["CNT_NO"].ToString()); //1.V_OLD_CNT_NO
ParameterList.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["EDIT_NO"].ToString(), "int", false)); //2.N_OLD_EDIT_NO
ParameterList.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["CREATEDATE"].ToString(), "datetime", false)); //3.D_OLD_CREATEDATE
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["CREATEUID"].ToString()); //4.V_OLD_CREATEUID
ParameterList.Add(GetValueSetParameter(ds.Tables["Table_0"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false)); //5.D_OLD_UPDATEDATE
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["UPDATEUID"].ToString()); //6.V_OLD_UPDATEUID
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", false)); //7.V_NEW_VENDOR_CODE
ParameterList.Add(txtCNT_NO.Text); //8.V_NEW_CNT_NO
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["EDIT_NO"].ToString()); //9.N_NEW_EDIT_NO(因畫面上無此欄位可供變更)
ParameterList.Add(GetValueSetParameter(this.slpCNT_VALID_DATE.Text.Trim(), "date", false)); //10.D_NEW_CNT_VALID_DATE
ParameterList.Add(slpCNT_CONFIRM_CODE.SelectedValue); //11.N_NEW_CNT_CONFIRM_CODE(1=已審核,0=未審核) -- 應該是不能修改的
ParameterList.Add(GetValueSetParameter(slpCNT_CONFIRM_DATE.Text.Trim(), "date", false)); //12.D_NEW_CNT_CONFIRM_DATE
ParameterList.Add(GetValueSetParameter(slpCNT_END_DATE.Text.Trim(), "date", false)); //13.D_NEW_CNT_END_DATE
ParameterList.Add(GetValueSetParameter(slpBELOW_SUBVEN.Text.Trim(), "float", false)); //14.N_NEW_BELOW_SUBVEN
ParameterList.Add(txtCOL_DAYS.Text); //15.N_NEW_COL_DAYS
ParameterList.Add(GetValueSetParameter(ddlPAY_TYPE.Text, "int", false)); //16.N_NEW_PAY_TYPE結帳方式 1:月結,2:期別結
ParameterList.Add(System.DBNull.Value); //17.D_NEW_STOP_DATE
ParameterList.Add(System.DBNull.Value); //18.V_NEW_TRACE_DATE_B
ParameterList.Add(System.DBNull.Value); //19.V_NEW_TRACE_DATE_E
if (txtEDIT_NO.Text.Trim() == "1")
{
ParameterList.Add(slpCNT_VALID_DATE.Text); //20.D_NEW_RESUME_DATE_B=合約生效日(2009/7/23修改)
ParameterList.Add(slpCNT_END_DATE.Text); //21.D_NEW_RESUME_DATE_E=合約終止日(2009/7/23修改)
}
else
{
ParameterList.Add(slpRESUME_DATE_B.Text); //20.D_NEW_RESUME_DATE_B=合約生效日
ParameterList.Add(slpRESUME_DATE_E.Text); //21.D_NEW_RESUME_DATE_E=合約終止日
}
ParameterList.Add(GetValueSetParameter(slpBELOW_SUBVEN_TYPE.Text, "int", false)); //22.N_NEW_BELOW_SUBVEN_TYPE
ParameterList.Add(GetValueSetParameter(this.slpBELOW_SUBVEN_RATE.Text.Trim(), "float", false)); //23.N_NEW_BELOW_SUBVEN_RATE
ParameterList.Add(GetValueSetParameter(slpBELOW_SUBVEN_PAY_TYPE.Text, "int", false)); //24.N_NEW_BELOW_SUBVEN_PAY_TYPE
ParameterList.Add((GetRowCount(ds.Tables["Table_2"]) == 0 ? 0 : 1)); //25.N_NEW_BELOW_SUBVEN_ITEM_FLAG 單品FLAG(0:無設定單品1:有設定單品)
ParameterList.Add((GetRowCount(ds.Tables["Table_1"]) == 0 ? 0 : 1)); //26.N_NEW_BELOW_SUBVEN_STORE_FLAG 排除店群門市FLAG(0:無設定1:有設定)
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["TRACING_CHECK_MONTH"].ToString()); //27.V_NEW_TRACING_CHECK_MONTH
ParameterList.Add(DTime); //28.D_NEW_UPDATEDATE
ParameterList.Add(Session["UID"].ToString());//29.V_NEW_UPDATEUID
ParameterList.Add(rblSUBSIDY2_TYPE.SelectedValue); //30.油價補貼 補貼類別
ParameterList.Add(rblSUBSIDY2_COUNT_TYPE.SelectedValue);//31.油價補貼 計算方式
ParameterList.Add(slpSUBSIDY2_RATE.Text.Trim()); //32.油價補貼 費率
ParameterList.Add(ddlSUBSIDY2_PAY_TYPE.SelectedValue); //33.油價補貼 收取方式
ParameterList.Add(ddlSUBSIDY2_RULE.SelectedValue); //34.油價補貼 規則
ParameterList.Add(rblSUBSIDY1_COUNT_TYPE.SelectedValue);//35.離島配送費 計算方式
ParameterList.Add(slpSUBSIDY1_RATE.Text.Trim()); //36.離島配送費 費率
ParameterList.Add(ddlSUBSIDY1_PAY_TYPE.SelectedValue); //37.離島配送費 收取方式
ParameterList.Add(ddlSUBSIDY1_RULE.SelectedValue); //38.離島配送費 規則
ParameterList.Add(rblSUBSIDY4_COUNT_TYPE.SelectedValue);//39.轉運費 計算方式
//新增年度獎勵金
ArrayList ArrList = new ArrayList();
ArrList.Add(ds.Tables["Table_7"].Rows[0]["CNT_NO"].ToString());//V_OLD_CNT_NO
ArrList.Add(GetValueSetParameter(ds.Tables["Table_7"].Rows[0]["EDIT_NO"].ToString(), "int", false));//N_OLD_EDIT_NO
ArrList.Add(1);//N_OLD_ANNUAL_TYPE 固定給1
ArrList.Add(ds.Tables["Table_7"].Rows[0]["UPDATEUID"].ToString());//V_OLD_UPDATEUID
ArrList.Add(GetValueSetParameter(ds.Tables["Table_7"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false));//D_OLD_UPDATEDATE
ArrList.Add(ds.Tables["Table_7"].Rows[0]["CREATEUID"].ToString());//V_OLD_CREATEUID
ArrList.Add(GetValueSetParameter(ds.Tables["Table_7"].Rows[0]["CREATEDATE"].ToString(), "datetime", false));//D_OLD_CREATEDATE
ArrList.Add(txtCNT_NO.Text);//V_NEW_CNT_NO
ArrList.Add(ds.Tables["Table_7"].Rows[0]["EDIT_NO"].ToString());//N_NEW_EDIT_NO(因畫面上無此欄位可供變更)
ArrList.Add(1);//ANNUAL_TYPE 固定給1
ArrList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", false));
ArrList.Add(GetValueSetParameter((rdoCOUNT_TYPE1.Checked ? "1" : "2"), "int", false));//COUNT_TYPE計算方式，1.全店群2.部份店群
ArrList.Add(GetValueSetParameter(SLP_CodeFile4.Text.Trim(), "int", false));//PAY_TYPE收取方式(1:冊,2:成本,3:零售價,4:牌價,5:本體價)
ArrList.Add(GetValueSetParameter(SLP_CodeFile3.SelectedValue, "int", false));//ANNUAL_RULE規則(廠商進＋廠商退、廠商進-廠商退、廠商進、廠商退 、店群進＋店群退、店群進-店群退、店群進、店群退)
ArrList.Add(DTime);//D_UPDATEDATE
ArrList.Add(Session["UID"].ToString());//V_UPDATEUID
//int N_ID;
//string V_CODE;
//string V_CNT_NO = "";
//給店群門市的TARGET_NO值
foreach (DataRow dr in ds.Tables["Table_3"].Rows)
if (dr.RowState != DataRowState.Deleted)
foreach (DataRow Dr in ds.Tables["Table_4"].Rows)
if (Dr.RowState != DataRowState.Deleted)
if (Dr["PID"].ToString() == dr["ID"].ToString())
Dr["TARGET_NO"] = dr["TARGET_TYPE"];
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
bco.UpdateVDM_Contract(ParameterList, ArrList, ds, null);
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('修改完成');", true);
//資料要重新查詢，因為已異動過，若不重查，使用者於檢視頁按下編輯鈕後，再按修改審核、解除等按鈕時會產生資料已異動的錯誤
Session.Remove("VDM022_" + PageTimeStamp.Value);
BuildDataSet(); //建立DATATABLE架構
ds.AcceptChanges();
ds = QueryData(ViewState["CNT_NO"].ToString(), ViewState["EDIT_NO"].ToString(), false);
//獎勵金的預設值
btnCancel_1_Command(null, new CommandEventArgs("btnCancel_3", null));
ReadOnlyMode();
btnAdd_Mode.Visible = true;
btnModify_Mode.Visible = true;
btnCopy_Mode.Visible = true;
btnDel.Visible = true;
Session["VDM022_" + PageTimeStamp.Value] = ds;
Cruise(txtCNT_NO.Text, ViewState["EDIT_NO"].ToString());//檢視模式的巡航鈕
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, true, "", btnDel, WUI_GMToolbarV.ClickAction.ButtonClick);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, false, "", btnAdd, WUI_GMToolbarV.ClickAction.ButtonClick);
UpdatePanel1.Update();
UpdatePanel2.Update();
UpdatePanel3.Update();
UpdatePanel4.Update();
UpdatePanel4_1.Update();
UpdatePanel5.Update();
UpdatePanel6.Update();
UpdatePanel_SUBSIDY2.Update();
UpdatePanel9.Update();
UpdatePanel7.Update();
}
}
catch (Exception ex)
{
if (ex.Message.IndexOf("資料已被他人異動,資料更新失敗") != -1)
ScriptManager.RegisterStartupScript(this, this.GetType(), "ClientScript", "alert('更新失敗，此資料已被其他使用者異動，請重新查詢再進行儲存');", true);
else
{
ErrorMsgLabel.Text = ex.Message;
UpdatePanel6.Update();
}
}
}
private DataSet QueryData(string CNT_NO, string EDIT_NO, bool isToolBar)
{
//處理若使用者刪除資料，於另一Tab頁按上、下筆時會查不到資料，此時將以下按鈕Disable
btnAdd_Mode.Enabled = true;
btnDel.Enabled = true;
btnModify_Mode.Enabled = true;
btnCopy_Mode.Enabled = true;
btnStoreGroup.Enabled = true;
btnSingleBook.Enabled = true;
btnSetLvel.Enabled = true;
ClearAllField();
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
DataSet ds = new DataSet();
string SessionIDName = "VDM022_" + PageTimeStamp.Value;
ds = (DataSet)Session[SessionIDName];
DataTable dt = new DataTable();
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
dt = bco.QueryAgmByEdit(ParameterList);
dt.TableName = "Table_0"; //VDS_VDM_CONTRACT_MST
ds.Tables.Add(dt.Copy());
if (dt.Rows.Count > 0)
{
txtVENDOR_CODE.Text = dt.Rows[0]["VENDOR_CODE"].ToString();
txtEDIT_NO.Text = dt.Rows[0]["EDIT_NO"].ToString();
ddlPAY_TYPE.Text = dt.Rows[0]["PAY_TYPE"].ToString();
txtCOL_DAYS.Text = dt.Rows[0]["COL_DAYS"].ToString();
slpCNT_VALID_DATE.Text = dt.Rows[0]["CNT_VALID_DATE"].ToString();
slpCNT_END_DATE.Text = dt.Rows[0]["CNT_END_DATE"].ToString();
foreach (ListItem li in slpCNT_CONFIRM_CODE.Items)
li.Selected = (li.Value == dt.Rows[0]["CNT_CONFIRM_CODE"].ToString() ? true : false);
slpCNT_CONFIRM_DATE.Text = dt.Rows[0]["CNT_CONFIRM_DATE"].ToString();
txtCNT_NO.Text = dt.Rows[0]["CNT_NO"].ToString();
slpTRACE_DATE_B.Text = dt.Rows[0]["TRACE_DATE_B"].ToString();
slpTRACE_DATE_E.Text = dt.Rows[0]["TRACE_DATE_E"].ToString();
txtYEAR_MONTH.Text = dt.Rows[0]["TRACING_CHECK_MONTH"].ToString();
slpSTOP_DATE.Text = dt.Rows[0]["STOP_DATE"].ToString();
slpRESUME_DATE_B.Text = dt.Rows[0]["RESUME_DATE_B"].ToString();
slpRESUME_DATE_E.Text = dt.Rows[0]["RESUME_DATE_E"].ToString();
slpBELOW_SUBVEN.Text = dt.Rows[0]["BELOW_SUBVEN"].ToString();
slpBELOW_SUBVEN_PAY_TYPE.Text = dt.Rows[0]["BELOW_SUBVEN_PAY_TYPE"].ToString();
slpBELOW_SUBVEN_TYPE.Text = dt.Rows[0]["BELOW_SUBVEN_TYPE"].ToString();
slpBELOW_SUBVEN_RATE.Text = dt.Rows[0]["BELOW_SUBVEN_RATE"].ToString();
SLP_SLPDate1.Text = dt.Rows[0]["CREATEDATE"].ToString();//建立日期
SLP_User1.Text = dt.Rows[0]["CREATEUID"].ToString();//建立人員
SLP_SLPDate2.Text = dt.Rows[0]["UPDATEDATE"].ToString();//異動日期
SLP_User2.Text = dt.Rows[0]["UPDATEUID"].ToString();//異動人員
ViewState["EDIT_NO"] = dt.Rows[0]["EDIT_NO"].ToString();
ViewState["STOP_DATE"] = dt.Rows[0]["STOP_DATE"].ToString(); //該份合約已終止往來，無法新增履歷
dt = bco.QueryAnnualByEdit(ParameterList);
dt.TableName = "Table_7"; //VDS_VDM_CONTRACT_ANNUAL
ds.Tables.Add(dt.Copy());
if (dt.Rows.Count > 0)
{
rdoCOUNT_TYPE1.Checked = dt.Rows[0]["COUNT_TYPE"].ToString() == "1" ? true : false;
rdoCOUNT_TYPE2.Checked = dt.Rows[0]["COUNT_TYPE"].ToString() == "2" ? true : false;
SLP_CodeFile4.Text = dt.Rows[0]["PAY_TYPE"].ToString();
foreach (ListItem li in SLP_CodeFile3.Items)
li.Selected = (li.Value == dt.Rows[0]["ANNUAL_RULE"].ToString() ? true : false);
//部分店群
if (rdoCOUNT_TYPE1.Checked)
{
btnSetCountStore.Enabled = false;
}
else
{
if (((DropDownList)SLP_CodeFile4.FindControl("D1")).SelectedValue != "1")
{
btnSetCountStore.Enabled = true;
}
else
{
btnSetCountStore.Enabled = false;
}
}
}
dt = bco.QueryTargetByEdit(ParameterList);
if (dt.Rows.Count > 0)
{
if (ViewState["ROWNUM"] != null)//取得最大筆數值，以便以後可以新增Detail資料
ViewState["ROWNUM"] = Int32.Parse(ViewState["ROWNUM"].ToString()) + dt.Rows.Count;
else
ViewState["ROWNUM"] = dt.Rows.Count;
//DataRow[] drs = dt.Select("VENDOR_CODE like '%'", "ROW_ID desc");
//ViewState["ROW_ID"] = drs[0]["ROW_ID"];
ds = FillDataSet(ds, null, dt, "Table_3");
Session["VDM022_" + PageTimeStamp.Value] = ds;
GridView_3.DataSource = ds.Tables["Table_3"];
g = 1;
GridView_3.DataBind();
}
dt = bco.QueryStoreByEdit(ParameterList);
if (dt.Rows.Count > 0)
{
ViewState["ROWNUM"] = dt.Rows.Count;
DataRow[] drs = dt.Select("COUNT_TYPE='1'"); //COUNT_TYPE 設定類別：1.未達銷售補貼(排除)2.獎勵金(排除)3.年度獎勵金 4.油價補貼
if (drs.Length > 0)
ds = FillDataSet(ds, drs, null, "Table_1");
GridView_1.DataSource = ds.Tables["Table_1"];
g = 1;
GridView_1.DataBind();
drs = dt.Select("COUNT_TYPE='2'");
if (drs.Length > 0)
ds = FillDataSet(ds, drs, null, "Table_4");
//GridView_4.DataSource = ds.Tables["Table_4"];
GridView_4.DataSource = null;
g = 1;
GridView_4.DataBind();
drs = dt.Select("COUNT_TYPE='3'");
if (drs.Length > 0)
ds = FillDataSet(ds, drs, null, "Table_6");
GridView_6.DataSource = ds.Tables["Table_6"];
g = 1;
GridView_6.DataBind();
//油價補貼
drs = dt.Select("COUNT_TYPE='4'");
if (drs.Length > 0)
ds = FillDataSet(ds, drs, null, "Table_SUBSIDY2");
GridView_SUBSIDY2.DataSource = ds.Tables["Table_SUBSIDY2"];
g = 1;
GridView_SUBSIDY2.DataBind();
}
dt = bco.QueryItemByEdit(ParameterList);
if (dt.Rows.Count > 0)
{
if (ViewState["ROWNUM"] != null)
ViewState["ROWNUM"] = Int32.Parse(ViewState["ROWNUM"].ToString()) + dt.Rows.Count;
else
ViewState["ROWNUM"] = dt.Rows.Count;
ds = FillDataSet(ds, null, dt, "Table_2");
GridView_2.DataSource = ds.Tables["Table_2"];
g = 1;
GridView_2.DataBind();
}
ParameterList.Clear();
if (ds.Tables["Table_7"].Rows.Count > 0)
{
ParameterList.Add(ds.Tables["Table_7"].Rows[0]["ID"].ToString());
dt = bco.QueryRangeByEdit(ParameterList);
if (dt.Rows.Count > 0)
{
if (ViewState["ROWNUM"] != null)
ViewState["ROWNUM"] = Int32.Parse(ViewState["ROWNUM"].ToString()) + dt.Rows.Count;
else
ViewState["ROWNUM"] = dt.Rows.Count;
ds = FillDataSet(ds, null, dt, "Table_5");
// GridView_5.DataSource = ds.Tables["Table_5"];
DataView dv_Table_5 = ds.Tables["Table_5"].DefaultView;
dv_Table_5.Sort = "TARGET_AMT";
GridView_5.DataSource = dv_Table_5;
g = 1;
GridView_5.DataBind();
}
}
//載入預設值
//油價補貼
rblSUBSIDY2_TYPE.SelectedValue = "2";
rblSUBSIDY2_COUNT_TYPE.SelectedValue = "0";
ddlSUBSIDY2_PAY_TYPE.SelectedValue = "4";
ddlSUBSIDY2_RULE.SelectedValue = "6";
ViewState["Temp_SUBSIDY2_RULE_Selected_OLD"] = ddlSUBSIDY2_RULE.SelectedValue;
slpSUBSIDY2_RATE.Text = "";
btnSUBSIDY2_StoreGroup.Enabled = false;
//離島配送費
rblSUBSIDY1_COUNT_TYPE.SelectedValue = "0";
ddlSUBSIDY1_PAY_TYPE.SelectedValue = "4";
ddlSUBSIDY1_RULE.SelectedValue = "6";
slpSUBSIDY1_RATE.Text = "";
//轉運費
rblSUBSIDY4_COUNT_TYPE.SelectedValue = "0";
#region 油價補貼
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(2);
dt = bco.QuerySUBSIDYByEdit(ParameterList);
ds = FillDataSet(ds, null, dt, "Table_SUBSIDY_DATA_2");
if (dt.Rows.Count > 0)
{
rblSUBSIDY2_TYPE.SelectedValue = "2";
rblSUBSIDY2_COUNT_TYPE.SelectedValue = dt.Rows[0]["COUNT_TYPE"].ToString();
slpSUBSIDY2_RATE.Text = dt.Rows[0]["SUBSIDY_RATE"].ToString();
ddlSUBSIDY2_PAY_TYPE.SelectedValue = dt.Rows[0]["PAY_TYPE"].ToString();
ddlSUBSIDY2_RULE.SelectedValue = dt.Rows[0]["SUBSIDY_RULE"].ToString();
ViewState["Temp_SUBSIDY2_RULE_Selected_OLD"] = ddlSUBSIDY2_RULE.SelectedValue;
}
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(3);
dt = bco.QuerySUBSIDYByEdit(ParameterList);
ds = FillDataSet(ds, null, dt, "Table_SUBSIDY_DATA_3");
if (dt.Rows.Count > 0)
{
rblSUBSIDY2_TYPE.SelectedValue = "3";
rblSUBSIDY2_COUNT_TYPE.SelectedValue = dt.Rows[0]["COUNT_TYPE"].ToString();
slpSUBSIDY2_RATE.Text = dt.Rows[0]["SUBSIDY_RATE"].ToString();
ddlSUBSIDY2_PAY_TYPE.SelectedValue = dt.Rows[0]["PAY_TYPE"].ToString();
ddlSUBSIDY2_RULE.SelectedValue = dt.Rows[0]["SUBSIDY_RULE"].ToString();
ViewState["Temp_SUBSIDY2_RULE_Selected_OLD"] = ddlSUBSIDY2_RULE.SelectedValue;
//油價補貼的店群設定讀取在上方已先執行
}
if (rblSUBSIDY2_COUNT_TYPE.SelectedValue == "2")
{
btnSUBSIDY2_StoreGroup.Enabled = true;
}
else
{
btnSUBSIDY2_StoreGroup.Enabled = false;
}
#endregion
#region 離島配送費
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(1);
dt = bco.QuerySUBSIDYByEdit(ParameterList);
ds = FillDataSet(ds, null, dt, "Table_SUBSIDY_DATA_1");
if (dt.Rows.Count > 0)
{
rblSUBSIDY1_COUNT_TYPE.SelectedValue = dt.Rows[0]["COUNT_TYPE"].ToString();
slpSUBSIDY1_RATE.Text = dt.Rows[0]["SUBSIDY_RATE"].ToString();
ddlSUBSIDY1_PAY_TYPE.SelectedValue = dt.Rows[0]["PAY_TYPE"].ToString();
ddlSUBSIDY1_RULE.SelectedValue = dt.Rows[0]["SUBSIDY_RULE"].ToString();
}
#endregion
#region 轉運費
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(4);
dt = bco.QuerySUBSIDYByEdit(ParameterList);
ds = FillDataSet(ds, null, dt, "Table_SUBSIDY_DATA_4");
if (dt.Rows.Count > 0)
{
rblSUBSIDY4_COUNT_TYPE.SelectedValue = dt.Rows[0]["COUNT_TYPE"].ToString();
}
#endregion
ds.AcceptChanges();
Session["VDM022_" + PageTimeStamp.Value] = ds;
return ds;
}
else
{
if (isToolBar)
//lblErrMsg.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕繼續查詢";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022_alert", "alert('此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕繼續查詢');", true);
else
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VDM022_alert", "alert('無法取得資料');", true);
//lblErrMsg.Text = "無法取得資料";
ClearAllField();
ReadOnlyMode();
DisableForm(true);
btnAdd_Mode.Enabled = false;
btnDel.Enabled = false;
btnModify_Mode.Enabled = false;
btnCopy_Mode.Enabled = false;
btnStoreGroup.Enabled = false;
btnSingleBook.Enabled = false;
btnSetLvel.Enabled = false;
return null;
}
}
//確定新增 / 確定修改
protected void btnAdd_Click(object sender, EventArgs e)
{
this.ErrorMsgLabel.Text = "";
DataSet ds = new DataSet();
ds = (DataSet)Session[Request.QueryString["SessionIDName"]];
ds.AcceptChanges();
if (slpCNT_END_DATE.Text.Trim().Length == 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VDM101", "alert('請輸入合約結束日');", true);
return;
}
if (DateTime.Parse(slpRESUME_DATE_B.Text) >= DateTime.Parse(slpCNT_END_DATE.Text))
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VDM101", "alert('合約結束日須大於履歷起始日');", true);
return;
}
string strScript;
if (((DropDownList)SLP_CodeFile4.FindControl("D1")).SelectedItem.Text == "冊")
{
strScript = "alert('年度獎勵金〔收取方式=冊〕 暫不提供使用，請重新選擇');";
strScript += "try { document.getElementById('" + ((DropDownList)SLP_CodeFile4.FindControl("D1")).ClientID + "').focus();}catch(e){}";
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VDM101", strScript, true);
return;
}
//牌價檢核 -- 獎勵金
if (((DropDownList)slpPAY_TYPE.FindControl("D1")).SelectedItem.Text == "牌價")
{
foreach (DataRow dr in ds.Tables["Table_3"].Rows)
{
if (dr["PAY_TYPE"].ToString() == "4")
{
DataRow[] drs = ds.Tables["Table_4"].Select("PID='" + dr["ID"].ToString());
if (drs.Length == 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VDM101", "alert('" + TargetType[Int16.Parse(dr["TARGET_TYPE"].ToString())] + "沒有設定店群，收取方式不能選擇牌價，請重新設定');", true);
return;
}
}
}
}
//牌價檢核 -- 年度獎勵金
if (((DropDownList)SLP_CodeFile4.FindControl("D1")).SelectedItem.Text == "牌價")
{
if (ds.Tables["Table_6"].Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VDM101", "alert('年度獎勵金沒有設定店群，收取方式不能選擇牌價，請重新設定');", true);
return;
}
}
if (rdoCOUNT_TYPE2.Checked)
{
if (GridView_6.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VDM022", "alert('年度獎勵金設定[計算方式]＝部份店群，請設定店群、門市資料');", true);
return;
}
}
#region 油價補貼 資料檢核
//收取方式的規則-成本
if (ddlSUBSIDY2_PAY_TYPE.SelectedValue == "2")
{
//if (rblSUBSIDY2_COUNT_TYPE.SelectedValue == "2")
//{
// ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為成本時，計算方式不能選擇部份店群，請重新設定');", true);
// return;
//}
if (!((ddlSUBSIDY2_RULE.SelectedValue == "2") || (ddlSUBSIDY2_RULE.SelectedValue == "3")))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為成本時，只允許選取[廠進-廠退]或[廠進]規則，請重新設定');", true);
return;
}
}
//收取方式的規則-牌價
if (ddlSUBSIDY2_PAY_TYPE.SelectedValue == "4")
{
if (rblSUBSIDY2_COUNT_TYPE.SelectedValue == "1")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為牌價時，計算方式不能選擇全店群，請重新設定');", true);
return;
}
if (!((ddlSUBSIDY2_RULE.SelectedValue == "6") || (ddlSUBSIDY2_RULE.SelectedValue == "7")))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼的收取方式為牌價時，只允許選取[店進-店退]或[店進]規則，請重新設定');", true);
return;
}
}
if (rblSUBSIDY2_COUNT_TYPE.SelectedValue == "2")
{
if (this.GridView_SUBSIDY2.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼計算方式選擇部分店群，但是尚未設定計算店群');", true);
return;
}
}
//檢查油價補貼設定，若計算方式非不計算，則費率%必須要輸入
if (rblSUBSIDY2_COUNT_TYPE.SelectedValue != "0")
{
if (slpSUBSIDY2_RATE.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('油價補貼若計算方式非不計算，則費率%必須要輸入');", true);
return;
}
}
#endregion
//檢查離島配送設定，若計算方式非不計算，則費率%必須要輸入
if (rblSUBSIDY1_COUNT_TYPE.SelectedValue != "0")
{
if (slpSUBSIDY1_RATE.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM022", "alert('離島配送若計算方式非不計算，則費率%必須要輸入');", true);
return;
}
}
string s_CheckPage = CheckPage(sender, ds);
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VDM101", "document.getElementById('" + VDM101_txtFocus.ClientID + "').focus();", true);
return;
}
try
{
if (btnAdd.Text == "確定新增")
{
ParameterList.Clear();
ParameterList.Add(txtVENDOR_CODE.Text); //0.
ParameterList.Add(ds.Tables["Table_0"].Rows[0]["EDIT_NO"].ToString());//1.N_EDIT_NO
ParameterList.Add(GetValueSetParameter(this.slpCNT_VALID_DATE.Text.Trim(), "date", false)); //2.
ParameterList.Add(0);//3.N_CNT_CONFIRM_CODE(1=已審核,0=未審核)
ParameterList.Add(System.DBNull.Value);//4.D_CNT_CONFIRM_DATE
ParameterList.Add(GetValueSetParameter(this.slpCNT_END_DATE.Text.Trim(), "date", false));//5.D_CNT_END_DATE
ParameterList.Add(GetValueSetParameter(this.slpBELOW_SUBVEN.Text.Trim(), "float", false));//65.N_BELOW_SUBVEN
ParameterList.Add(txtCOL_DAYS.Text);//7.N_COL_DAYS
ParameterList.Add(GetValueSetParameter(this.ddlPAY_TYPE.Text.Trim(), "int", false));//8.N_PAY_TYPE結帳方式 1:月結,2:期別結
ParameterList.Add(System.DBNull.Value); //9.D_STOP_DATE
ParameterList.Add(System.DBNull.Value); //10.V_TRACE_DATE_B
ParameterList.Add(System.DBNull.Value); //11.V_TRACE_DATE_E
ParameterList.Add(slpRESUME_DATE_B.Text);//12.D_RESUME_DATE_B
if (Request["EXTEND"].ToString() == "1")
ParameterList.Add(slpCNT_END_DATE.Text);//13.D_RESUME_DATE_E
else
ParameterList.Add(slpRESUME_DATE_E.Text);//13.D_RESUME_DATE_E
ParameterList.Add(slpBELOW_SUBVEN_TYPE.Text); //14.
ParameterList.Add(GetValueSetParameter(this.slpBELOW_SUBVEN_RATE.Text.Trim(), "float", false));//15.N_BELOW_SUBVEN_RATE
ParameterList.Add(slpBELOW_SUBVEN_PAY_TYPE.Text);//16.
ParameterList.Add((ds.Tables["Table_2"].Rows.Count == 0 ? 0 : 1));//17.N_BELOW_SUBVEN_ITEM_FLAG 單品FLAG(0:無設定單品1:有設定單品)
ParameterList.Add((ds.Tables["Table_1"].Rows.Count == 0 ? 0 : 1));//18.N_BELOW_SUBVEN_STORE_FLAG 排除店群門市FLAG(0:無設定1:有設定)
ParameterList.Add(System.DBNull.Value); //19.V_TRACING_CHECK_MONTH
ParameterList.Add(Session["UID"].ToString());//20.V_CREATEUID
ParameterList.Add(System.DateTime.Now); //21.D_CREATEDATE
ParameterList.Add(Session["UID"].ToString());//22.V_UPDATEUID
ParameterList.Add(System.DateTime.Now); //23.D_UPDATEDATE
ParameterList.Add(txtCNT_NO.Text); //24.V_CNT_NO
ParameterList.Add(rblSUBSIDY2_TYPE.SelectedValue); //25.油價補貼 補貼類別
ParameterList.Add(rblSUBSIDY2_COUNT_TYPE.SelectedValue);//26.油價補貼 計算方式
ParameterList.Add(slpSUBSIDY2_RATE.Text.Trim()); //27.油價補貼 費率
ParameterList.Add(ddlSUBSIDY2_PAY_TYPE.SelectedValue); //28.油價補貼 收取方式
ParameterList.Add(ddlSUBSIDY2_RULE.SelectedValue); //29.油價補貼 規則
ParameterList.Add(rblSUBSIDY1_COUNT_TYPE.SelectedValue);//30.離島配送費 計算方式
ParameterList.Add(slpSUBSIDY1_RATE.Text.Trim()); //31.離島配送費 費率
ParameterList.Add(ddlSUBSIDY1_PAY_TYPE.SelectedValue); //32.離島配送費 收取方式
ParameterList.Add(ddlSUBSIDY1_RULE.SelectedValue); //33.離島配送費 規則
ParameterList.Add(rblSUBSIDY4_COUNT_TYPE.SelectedValue);//34.轉運費 計算方式
//新增年度獎勵金
ArrayList ArrList = new ArrayList();
ArrList.Add(ds.Tables["Table_0"].Rows[0]["EDIT_NO"].ToString());//N_EDIT_NO 年度獎勵金的EDIT_NO以合約主檔的為主，就不再另外處理
ArrList.Add(1);//ANNUAL_TYPE 固定給1
ArrList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", false));
ArrList.Add(GetValueSetParameter((rdoCOUNT_TYPE1.Checked ? "1" : "2"), "int", false));//COUNT_TYPE計算方式，1.全店群2.部份店群
ArrList.Add(GetValueSetParameter(SLP_CodeFile4.Text.Trim(), "int", false));//PAY_TYPE收取方式(1:冊,2:成本,3:零售價,4:牌價,5:本體價)
ArrList.Add(GetValueSetParameter(SLP_CodeFile3.SelectedValue, "int", false));//ANNUAL_RULE規則(廠商進＋廠商退、廠商進-廠商退、廠商進、廠商退 、店群進＋店群退、店群進-店群退、店群進、店群退)
ArrList.Add(Session["UID"].ToString());//V_CREATEUID
ArrList.Add(System.DateTime.Now);//D_CREATEDATE
ArrList.Add(Session["UID"].ToString());//V_UPDATEUID
ArrList.Add(System.DateTime.Now);//D_UPDATEDATE
int N_ID;
string V_CODE;
string V_CNT_NO = "";
//給店群門市的TARGET_NO值
foreach (DataRow dr in ds.Tables["Table_3"].Rows)
foreach (DataRow Dr in ds.Tables["Table_4"].Rows)
if (Dr["PID"].ToString() == dr["ID"].ToString())
Dr["TARGET_NO"] = dr["TARGET_TYPE"];
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
bco.CreateVendorAgm(ParameterList, ArrList, ds, null, true);
ds.AcceptChanges();
Session[Request.QueryString["SessionIDName"]] = ds;
ArrayList arl_Key = new ArrayList();
arl_Key = (ArrayList)Session[Request.QueryString["arl_Key"]];
arl_Key.Add(txtCNT_NO.Text + "|" + txtEDIT_NO.Text);
Session[Request.QueryString["arl_Key"]] = arl_Key;
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", string.Format("alert('新增完成');location.replace('VDM022.aspx?Code=VDM02&arl_Key={0}&VDM021=EDIT&CNT_NO={1}&EDIT_NO={2}');", Request.QueryString["arl_Key"], txtCNT_NO.Text, txtEDIT_NO.Text), true);
//Response.Redirect("VDM022.aspx?arl_Key=" + Request.QueryString["arl_Key"] + "&VDM021=EDIT&CNT_NO=" + txtCNT_NO.Text + "&EDIT_NO=" + txtEDIT_NO.Text);
}
}
catch (Exception ex)
{
if (ex.Message.IndexOf("資料已被他人異動") >= 0)
ScriptManager.RegisterStartupScript(this, this.GetType(), "DelComplete", "alert('新增失敗，此資料已被其他使用者新增，請重新查詢！');", true);
else
lblErrMsg.Text = ex.Message;
}
}
private void QueryData(string CNT_NO, string EDIT_NO, bool isToolBar)
{
DataTable dtTemp;
ClearAllField();
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
string SessionIDName = "VDM081_" + PageTimeStamp.Value;
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
DataTable dt1 = bco.QueryAgmByEdit(ParameterList);
if (dt1.Rows.Count > 0)
{
Panel2.Visible = false;
Panel3.Visible = false;
Panel4.Visible = false;
Panel5.Visible = false;
Panel6.Visible = false;
Panel7.Visible = false;
Panel8.Visible = false;
Panel9.Visible = false;
Panel10.Visible = false;
Panel11.Visible = false;
Panel12.Visible = false;
//1.
Session["VDM081_DT1_" + PageTimeStamp.Value] = dt1;
txtVENDOR_CODE.Text = dt1.Rows[0]["VENDOR_CODE"].ToString();
txtEDIT_NO.Text = dt1.Rows[0]["EDIT_NO"].ToString();
ddlPAY_TYPE.Text = dt1.Rows[0]["PAY_TYPE"].ToString();
txtCOL_DAYS.Text = dt1.Rows[0]["COL_DAYS"].ToString();
slpCNT_VALID_DATE.Text = dt1.Rows[0]["CNT_VALID_DATE"].ToString();
slpCNT_END_DATE.Text = dt1.Rows[0]["CNT_END_DATE"].ToString();
foreach (ListItem li in slpCNT_CONFIRM_CODE.Items)
li.Selected = (li.Value == dt1.Rows[0]["CNT_CONFIRM_CODE"].ToString() ? true : false);
slpCNT_CONFIRM_DATE.Text = dt1.Rows[0]["CNT_CONFIRM_DATE"].ToString();
txtCNT_NO.Text = dt1.Rows[0]["CNT_NO"].ToString();
//2. BELOW_SUBVEN is not null AND ! = 0 才顯示
if ((dt1.Rows[0]["BELOW_SUBVEN"].ToString() != "0") && (dt1.Rows[0]["BELOW_SUBVEN"].ToString() != ""))
{
Panel2.Visible = true;
slpBELOW_SUBVEN.Text = dt1.Rows[0]["BELOW_SUBVEN"].ToString();
slpBELOW_SUBVEN_PAY_TYPE.Text = dt1.Rows[0]["BELOW_SUBVEN_PAY_TYPE"].ToString();
slpBELOW_SUBVEN_TYPE.Text = dt1.Rows[0]["BELOW_SUBVEN_TYPE"].ToString();
slpBELOW_SUBVEN_RATE.Text = dt1.Rows[0]["BELOW_SUBVEN_RATE"].ToString();
}
//3 & 7
DataTable dt2 = bco.QueryStoreByEdit(ParameterList);
if (dt2.Rows.Count > 0)
{
Session["VDM081_DT2_" + PageTimeStamp.Value] = dt2;
dtTemp = Fill_DataTable(dt2, "COUNT_TYPE='1'");
GridView_1.DataSource = dtTemp; ////COUNT_TYPE 設定類別：1.未達銷售補貼(排除)2.獎勵金(排除)3.年度獎勵金
GridView_1.DataBind();
if (dtTemp.Rows.Count > 0)
Panel3.Visible = true;
dtTemp = Fill_DataTable(dt2, "COUNT_TYPE='3'");
GridView_6.DataSource = dtTemp;
GridView_6.DataBind();
if (dtTemp.Rows.Count > 0)
Panel7.Visible = true;
}
//4
DataTable dt3 = bco.QueryItemByEdit(ParameterList);
if (dt3.Rows.Count > 0)
{
Session["VDM081_DT3_" + PageTimeStamp.Value] = dt3;
GridView_2.DataSource = dt3;
GridView_2.DataBind();
if (dt3.Rows.Count > 0)
Panel4.Visible = true;
}
//5.1
DataTable dt4 = bco.QueryTargetByEdit(ParameterList);
if (dt4.Rows.Count > 0)
{
iGV3_NO = 0;
Session["VDM081_DT4_" + PageTimeStamp.Value] = dt4;
Repeater1.DataSource = dt4;
Repeater1.DataBind();
if (dt4.Rows.Count > 0)
Panel5.Visible = true;
}
//6 & 8
DataTable dt5 = bco.QueryAnnualByEdit(ParameterList);
if (dt5.Rows.Count > 0)
{
Session["VDM081_DT5_" + PageTimeStamp.Value] = dt5;
rdoCOUNT_TYPE1.Checked = dt5.Rows[0]["COUNT_TYPE"].ToString() == "1" ? true : false;
rdoCOUNT_TYPE2.Checked = dt5.Rows[0]["COUNT_TYPE"].ToString() == "2" ? true : false;
SLP_CodeFile4.Text = dt5.Rows[0]["PAY_TYPE"].ToString();
foreach (ListItem li in SLP_CodeFile3.Items)
li.Selected = (li.Value == dt5.Rows[0]["ANNUAL_RULE"].ToString() ? true : false);
ParameterList.Clear();
ParameterList.Add(dt5.Rows[0]["ID"].ToString());
DataTable dt6 = bco.QueryRangeByEdit(ParameterList);
if (dt6.Rows.Count > 0)
{
Panel6.Visible = true;
Session["VDM081_DT6_" + PageTimeStamp.Value] = dt6;
DataView dv6 = dt6.DefaultView;
dv6.Sort = "TARGET_AMT";
GridView_5.DataSource = dv6;
GridView_5.DataBind();
if (dt6.Rows.Count > 0)
Panel8.Visible = true;
}
}
#region 油價補貼
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(2);
DataTable dt7 = bco.QuerySUBSIDYByEdit(ParameterList);
if (dt7.Rows.Count > 0)
{
Panel9.Visible = true;
Session["VDM081_DT7_" + PageTimeStamp.Value] = dt7;
rblSUBSIDY2_TYPE.SelectedValue = "2";
rblSUBSIDY2_COUNT_TYPE.SelectedValue = dt7.Rows[0]["COUNT_TYPE"].ToString();
slpSUBSIDY2_RATE.Text = dt7.Rows[0]["SUBSIDY_RATE"].ToString();
ddlSUBSIDY2_PAY_TYPE.SelectedValue = dt7.Rows[0]["PAY_TYPE"].ToString();
ddlSUBSIDY2_RULE.SelectedValue = dt7.Rows[0]["SUBSIDY_RULE"].ToString();
}
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(3);
dt7 = bco.QuerySUBSIDYByEdit(ParameterList);
if (dt7.Rows.Count > 0)
{
Panel9.Visible = true;
Session["VDM081_DT7_" + PageTimeStamp.Value] = dt7;
rblSUBSIDY2_TYPE.SelectedValue = "3";
rblSUBSIDY2_COUNT_TYPE.SelectedValue = dt7.Rows[0]["COUNT_TYPE"].ToString();
slpSUBSIDY2_RATE.Text = dt7.Rows[0]["SUBSIDY_RATE"].ToString();
ddlSUBSIDY2_PAY_TYPE.SelectedValue = dt7.Rows[0]["PAY_TYPE"].ToString();
ddlSUBSIDY2_RULE.SelectedValue = dt7.Rows[0]["SUBSIDY_RULE"].ToString();
}
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
DataTable dt8 = bco.QueryStoreByEdit(ParameterList);
if (dt8.Rows.Count > 0)
{
Session["VDM081_DT8_" + PageTimeStamp.Value] = dt8;
dtTemp = Fill_DataTable(dt8, "COUNT_TYPE='4'");
GridView_7.DataSource = dtTemp;
GridView_7.DataBind();
if (dtTemp.Rows.Count > 0)
Panel10.Visible = true;
}
#endregion
#region 離島配送費
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(1);
DataTable dt9 = bco.QuerySUBSIDYByEdit(ParameterList);
if (dt9.Rows.Count > 0)
{
Panel11.Visible = true;
Session["VDM081_DT9_" + PageTimeStamp.Value] = dt9;
rblSUBSIDY1_COUNT_TYPE.SelectedValue = dt9.Rows[0]["COUNT_TYPE"].ToString();
slpSUBSIDY1_RATE.Text = dt9.Rows[0]["SUBSIDY_RATE"].ToString();
ddlSUBSIDY1_PAY_TYPE.SelectedValue = dt9.Rows[0]["PAY_TYPE"].ToString();
ddlSUBSIDY1_RULE.SelectedValue = dt9.Rows[0]["SUBSIDY_RULE"].ToString();
}
#endregion
#region 轉運費
ParameterList.Clear();
ParameterList.Add(CNT_NO);
ParameterList.Add(Int16.Parse(EDIT_NO));
ParameterList.Add(4);
DataTable dt10 = bco.QuerySUBSIDYByEdit(ParameterList);
if (dt10.Rows.Count > 0)
{
Panel12.Visible = true;
Session["VDM081_DT10_" + PageTimeStamp.Value] = dt10;
rblSUBSIDY4_COUNT_TYPE.SelectedValue = dt10.Rows[0]["COUNT_TYPE"].ToString();
}
#endregion
}
if (slpCNT_CONFIRM_CODE.Text == "1") //已審核
{
btnUpdate.Enabled = false;
btnDelete.Enabled = true;
}
else
{
btnUpdate.Enabled = true;
btnDelete.Enabled = false;
}
}
//確認審核、合約解除
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;
}
}
}
