protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
#region 檢查判斷
//系統日>=首次出貨日或進貨開始日就不可以刪除.
if (DateTime.Parse(GridView1.Rows[e.RowIndex].Cells[4].Text) <= DateTime.Today)
{
ErrorMsgLabel.Text = "不可刪除:首次出貨日須小於系統日 !!";
return;
}
if (DateTime.Parse(((Label)GridView1.Rows[e.RowIndex].FindControl("lblACCEPT_DATE_START")).Text) <= DateTime.Today)
{
ErrorMsgLabel.Text = "不可刪除:進貨開始日須小於系統日 !!";
return;
}
#endregion
DateTime processtime = DateTime.Now;
#region 檔期活動
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(GridView1.Rows[e.RowIndex].Cells[0].Text, "string", false)); //V_OLD_PROMOTE_ID
ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblCREATEDATE")).Text, "datetime", false)); //D_OLD_CREATEDATE
ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblCREATEUID")).Text, "string", false)); //V_OLD_CREATEUID
ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblUPDATEDATE")).Text, "datetime", false)); //D_OLD_UPDATEDATE
ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblUPDATEUID")).Text, "string", false)); //V_OLD_UPDATEUID
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false));
ParameterList.Add(processtime);
#endregion
STMModel.MaintainPromoteExhibition BCO = new STMModel.MaintainPromoteExhibition(ConnectionDB);
BCO.DeleteStoreBase(ParameterList, null);
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('刪除完成');", true);
databind();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
#region
string SessionIDName = string.Format("{0}", PAGE_DT_01);
STMModel.MaintainPromoteExhibition BCO = new STMModel.MaintainPromoteExhibition(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(this.SLP_VENDOR.Text);
ParameterList.Add(FIRST_DATE);
ParameterList.Add(RETURN_DATE);
DataTable Dt = BCO.ExpandStoreItemDiscount(ParameterList);
GridView1.DataSource = Dt;
Session[SessionIDName] = Dt;
GridView1.DataBind();
dtSelectDisChain = Dt;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", Dt.Rows.Count.ToString());
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
}
#endregion
}
/// <summary>
/// 繫結資料到控制項
/// </summary>
/// <param name="vdb"></param>
private void databind()
{
#region
//抓取本頁初次登記的時間
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
STMModel.MaintainPromoteExhibition BCO = new STMModel.MaintainPromoteExhibition(ConnectionDB);
ParameterList.Clear();
//檔期活動
ParameterList.Add(DBNull.Value);
ParameterList.Add(GetValueSetParameter(this.txtPROMOTE_ID.Text, "string", CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.txtPROMOTE_NAME.Text, "string", CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.SLP_PROMOTE_MONTH.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_ACCT_MONTH.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_COL_DAYS.Text, "string", false));
ParameterList.Add(DBNull.Value); //V_COL_DAYS_EXPLAIN
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_START.StartDate,"string",false));
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_START.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_END.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_END.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_FIRST_DATE.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_FIRST_DATE.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_START.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_START.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_END.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_END.EndDate, "string", false));
if (this.ddlPROMOTE_TYPE.SelectedValue == "0")
ParameterList.Add(DBNull.Value);
else
ParameterList.Add(this.ddlPROMOTE_TYPE.SelectedValue.ToString());
ParameterList.Add(DBNull.Value); //V_PROMOTE_TYPE_EXPLAIN
if (this.ddlDISCOUNT_TYPE.SelectedValue == "0")
ParameterList.Add(DBNull.Value);
else
ParameterList.Add(this.ddlDISCOUNT_TYPE.SelectedValue.ToString());
ParameterList.Add(DBNull.Value); //V_DISCOUNT_TYPE_EXPLAIN
ParameterList.Add(GetValueSetParameter(this.SLP_NOTES.Text, "string", false)); //N_NOTES
ParameterList.Add(DBNull.Value);
ParameterList.Add(((DropDownList)SLP_PRICE_SUBSIDY_PERCENT.FindControl("D1")).SelectedItem.Text);
ParameterList.Add(GetValueSetParameter(this.SLP_PRICE_SUBSIDY_PERCENT.Text, "Decimal", CheckBoxLikeSearch.Checked));
ParameterList.Add(((DropDownList)SLP_COST_SUBSIDY_PERCENT.FindControl("D1")).SelectedItem.Text);
ParameterList.Add(GetValueSetParameter(this.SLP_COST_SUBSIDY_PERCENT.Text, "Decimal", CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter("", "string", CheckBoxLikeSearch.Checked));
ParameterList.Add(DBNull.Value); //V_AC_UNAME
if (this.SLP_CONFIRM_CODE.Text == "")
ParameterList.Add(DBNull.Value);
else
ParameterList.Add(GetValueSetParameter(this.SLP_CONFIRM_CODE.Text, "string", false));
ParameterList.Add(DBNull.Value); //V_CONFIRM_CODE_EXPLAIN
ParameterList.Add(DBNull.Value); //N_DISCOUNT_KIND
ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_DATE.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_DATE.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_UID.Text, "string", false));
ParameterList.Add(DBNull.Value); //V_CREATEUNAME
ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_DATE.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_DATE.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_UID.Text, "string", false));
ParameterList.Add(DBNull.Value); //V_UPDATEUNAME
//折扣設定
ParameterList.Add(GetValueSetParameter(this.SLP_GROUP_NO.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_ITEM.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_PERIOD.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_COST_SUBSIDY_PERCENT2.Text, "Decimal", CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.SLP_PRICE_SUBSIDY_PERCENT2.Text, "Decimal", CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_DATE2.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_DATE2.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_UID2.Text, "string", false));
ParameterList.Add(DBNull.Value); //V_CREATEUNAME
ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_DATE2.StartDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_DATE2.EndDate, "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_UID2.Text, "string", false));
ParameterList.Add(DBNull.Value); //V_UPDATEUNAME
ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text, "int", false));
DataTable Dt = BCO.QuerySwitch(STMModel.MaintainPromoteExhibition.QueryType.QueryByLike , ParameterList);
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", Dt.Rows.Count.ToString());
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
ErrorMsgLabel.Text = "查無資料";
}
#region 將Key值存到Session中
ArrayList arl_Key = new ArrayList();
foreach (DataRow drRow in Dt.Rows)
{ arl_Key.Add("promote_id=" + drRow["PROMOTE_ID"].ToString()); }
Session["STM272_SortKey" + this.PageTimeStamp.Value] = arl_Key;
#endregion
#endregion
}//databind
private void QueryData(string v_promote_id)
{
bool AuthUpdateSTM22 = false;
try
{
#region 將變數資料清空
ds_Data.Tables.Clear();
#endregion
#region 檔期活動
STMModel.MaintainPromoteExhibition BCO = new STMModel.MaintainPromoteExhibition(ConnectionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(null);
ParameterList.Add(v_promote_id);
for (int i = 2; i <= 53; i++)
{
if ((i == 23) || (i == 25))
ParameterList.Add(">=");
else
ParameterList.Add(null);
}
ParameterList.Add("1");
Dt = BCO.QuerySwitch(STMModel.MaintainPromoteExhibition.QueryType.QueryByLike, ParameterList);
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
return;
}
this.txtPROMOTE_ID.Text = Dt.Rows[0]["PROMOTE_ID"].ToString();
this.txtPROMOTE_NAME.Text = Dt.Rows[0]["PROMOTE_NAME"].ToString();
this.txtPROMOTE_MONTH.Text = Dt.Rows[0]["PROMOTE_MONTH"].ToString();
this.txtACCT_MONTH.Text = Dt.Rows[0]["ACCT_MONTH"].ToString();
this.SLP_COL_DAYS.Text = Dt.Rows[0]["COL_DAYS"].ToString();
this.SLP_ACCEPT_DATE_START.Text = Dt.Rows[0]["ACCEPT_DATE_START"].ToString();
this.SLP_ACCEPT_DATE_END.Text = Dt.Rows[0]["ACCEPT_DATE_END"].ToString();
this.SLP_ACCEPT_FIRST_DATE.Text = Dt.Rows[0]["ACCPET_FIRST_DATE"].ToString();
this.hdfACCEPT_FIRST_DATE.Value = Dt.Rows[0]["ACCPET_FIRST_DATE"].ToString();
this.SLP_RETURN_DATE_START.Text = Dt.Rows[0]["RETURN_DATE_START"].ToString();
this.SLP_RETURN_DATE_END.Text = DateTime.Parse(Dt.Rows[0]["RETURN_DATE_END"].ToString()).ToString("yyyy/MM/dd");
if (Dt.Rows[0]["CONFIRM_CODE"].ToString() == "1")
this.txtCONFIRM_CODE.Text = "已審核";
else
this.txtCONFIRM_CODE.Text = "未審核";
this.ddlPROMOTE_TYPE.SelectedValue = Dt.Rows[0]["PROMOTE_TYPE"].ToString();
this.ddlDISCOUNT_TYPE.SelectedValue = Dt.Rows[0]["DISCOUNT_TYPE"].ToString();
this.SLP_NOTES.Text = Dt.Rows[0]["NOTES"].ToString();
this.SLP_PRICE_SUBSIDY_PERCENT.Text = Dt.Rows[0]["PRICE_SUBSIDY_PERCENT"].ToString();
this.SLP_COST_SUBSIDY_PERCENT.Text = Dt.Rows[0]["COST_SUBSIDY_PERCENT"].ToString();
string strPrefixed = "POP_STM2732";
Session[string.Format("{0}_FIRST_DATE", strPrefixed)] = this.SLP_ACCEPT_FIRST_DATE.Text;
Session[string.Format("{0}_RETURN_DATE", strPrefixed)] = this.SLP_RETURN_DATE_END.Text;
if (this.txtCONFIRM_CODE.Text == "已審核")
{ btnPASS.Enabled = false; }
if (this.txtCONFIRM_CODE.Text == "未審核")
{ btnNOPASS.Enabled = false; }
//檔期審核權限
DataTable DtC = GetFunctionCRUD("STM22");
if (DtC.Rows.Count > 0)
{ AuthUpdateSTM22 = bool.Parse(DtC.Rows[0]["CanUpdate"].ToString()); }
btnPASS.Enabled = (AuthUpdateSTM22) ? btnPASS.Enabled : false;
btnNOPASS.Enabled = (AuthUpdateSTM22) ? btnNOPASS.Enabled : false;
#endregion
#region 門市
STMModel.MaintainPromoteExhibition BCO_Store = new STMModel.MaintainPromoteExhibition(ConnectionDB);
DataTable Dt_Store;
ParameterList.Clear();
ParameterList.Add(v_promote_id);
Dt_Store = BCO_Store.QuerySwitch(STMModel.MaintainPromoteExhibition.QueryType.STORE, ParameterList);
GridView1.DataSource = Dt_Store;
//門市筆數
this.txtCount_Store.Value = GridView1.Rows.Count.ToString();
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
Session[SessionIDName] = Dt_Store;
//設定分頁大小
GridView1.PageIndex = 0;
GridView1.DataBind();
this.txtCount_Store.Value = GridView1.Rows.Count.ToString();
#endregion
#region 商品
STMModel.MaintainPromoteExhibition BCO_Item = new STMModel.MaintainPromoteExhibition(ConnectionDB);
DataTable Dt_Item;
ParameterList.Clear();
ParameterList.Add(v_promote_id);
ParameterList.Add(Session["UID"].ToString());
Dt_Item = BCO_Item.QuerySwitch(STMModel.MaintainPromoteExhibition.QueryType.ITEM, ParameterList);
DataView dv_Item = new DataView(Dt_Item);
dv_Item.RowFilter = "STORE = '" + (Dt_Store.Rows.Count == 0 ? "" : Dt_Store.Rows[0]["STORE"].ToString()) + "'";
//顯示商品Panel-門市代號
if (Dt_Store.Rows.Count != 0)
{
txtITEM_STORE.Text = Dt_Store.Rows[0]["STORE"].ToString();
lblITEM_STORE_NAME.Text = Dt_Store.Rows[0]["STORE_NAME"].ToString();
lblITEM_GROUP_NO.Text = Dt_Store.Rows[0]["GROUP_NO"].ToString();
lblITEM_COST.Text = Dt_Store.Rows[0]["PRICE_SUBSIDY_PERCENT"].ToString();
}
GridView2.DataSource = dv_Item;
string SessionIDName2 = string.Format("{0}_{1}", PAGE_DT_02, PageTimeStamp.Value);
Session[SessionIDName2] = dv_Item;
//設定分頁大小
GridView2.PageIndex = 0;
GridView2.DataBind();
//商品筆數
this.txtCount_Item.Value = Dt_Item.Rows.Count.ToString();
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
return;
}
#endregion
#region 將資料寫入變數
Dt.TableName = "VDS_STM_PROMOTE_MST";
Dt_Store.TableName = "VDS_STM_PROMOTE_STORE";
Dt_Item.TableName = "VDS_STM_PROMOTE_DTL";
ds_Data.Tables.Add(Dt.Copy());
ds_Data.Tables.Add(Dt_Store.Copy());
ds_Data.Tables.Add(Dt_Item.Copy());
//門市
DataSet ds_store = new DataSet();
ds_store.Tables.Add(Dt_Store.Copy());
DataColumn[] keys_store = new DataColumn[2];
keys_store[0] = ds_store.Tables[0].Columns["GROUP_NO"];
keys_store[1] = ds_store.Tables[0].Columns["STORE"];
ds_store.Tables[0].PrimaryKey = keys_store;
Session["STM272_Store" + PageTimeStamp.Value] = ds_store;
//商品
DataSet ds = new DataSet();
ds.Tables.Add(Dt_Item.Copy());
DataColumn[] keys = new DataColumn[4];
keys[0] = ds.Tables[0].Columns["PROMOTE_CODE"];
keys[1] = ds.Tables[0].Columns["STORE"];
keys[2] = ds.Tables[0].Columns["ITEM"];
keys[3] = ds.Tables[0].Columns["PERIOD"];
ds.Tables[0].PrimaryKey = keys;
Session["STM272_" + PageTimeStamp.Value] = ds;
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally { }
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
try
{
if (SLP_ACCEPT_DATE_START.Text.Trim() == string.Empty)
{
throw new Exception("進貨開始日未設定 !! ");
}
if (SLP_ACCEPT_FIRST_DATE.Text.Trim() == string.Empty)
{
throw new Exception("首次出貨日未設定 !! ");
}
DataSet ds_store = (DataSet)Session["STM272_store" + PageTimeStamp.Value];
DataRow[] drstore = (DataRow[])ds_store.Tables[0].Select("STORE='" + SLP_STORE.Text + "'");
if (drstore.Length > 0)
{
throw new Exception("門市代號不能重複 ");
}
if (this.SLP_PRICE_SUBSIDY_PERCENT2.Text.Length > 0)
{
if (Convert.ToDecimal(this.SLP_PRICE_SUBSIDY_PERCENT2.Text.Trim()) > 100 || Convert.ToDecimal(this.SLP_PRICE_SUBSIDY_PERCENT2.Text.Trim()) < 0)
{
throw new Exception("[門市補貼％]欄位請輸入100>門市補貼>0值<br/>");
}
else
{
String[] strPRICE_SUBSIDY_PERCENT2 = SLP_PRICE_SUBSIDY_PERCENT2.Text.Trim().Split('.');
if (strPRICE_SUBSIDY_PERCENT2.Length == 2)
{
if (Convert.ToDecimal(strPRICE_SUBSIDY_PERCENT2[1]) > 99)
{
throw new Exception("[門市補貼％]欄位小數只能二位<br/>");
}
}
}
}
//捉取門市資料
STMModel.MaintainPromoteExhibition BCO_GetStore = new STMModel.MaintainPromoteExhibition(ConnectionDB);
DataTable Dt_GetStore;
ParameterList.Clear();
ParameterList.Add(SLP_STORE.Text);
Dt_GetStore = BCO_GetStore.GetGroupStoreInfo(ParameterList);
if (Dt_GetStore == null || (Dt_GetStore != null && Dt_GetStore.Rows.Count <= 0))
{
throw new Exception("店群或門市錯誤,無法新增 !! ");
}
DataRow dr = ds_store.Tables[0].NewRow();
dr["GROUP_NO"] = Dt_GetStore.Rows[0]["GROUP_NO"].ToString();
dr["GROUP_NAME"] = Dt_GetStore.Rows[0]["GROUP_NAME"].ToString();
dr["STORE"] = Dt_GetStore.Rows[0]["STORE"].ToString();
dr["STORE_NAME"] = Dt_GetStore.Rows[0]["STORE_NAME"].ToString();
dr["AC_UID"] = Dt_GetStore.Rows[0]["AC_UID"].ToString();
dr["AC_UNAME"] = Dt_GetStore.Rows[0]["AC_UNAME"].ToString();
dr["PRICE_SUBSIDY_PERCENT"] = SLP_PRICE_SUBSIDY_PERCENT2.Text;
ds_store.Tables[0].Rows.Add(dr);
GridView1.DataSource = ds_store;
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
Session[SessionIDName] = ds_store;
GridView1.DataBind();
Session["STM272_store" + PageTimeStamp.Value] = ds_store;
//筆數加1
int count_store = 0;
if (txtCount_Store.Value.Length == 0)
{
count_store = 1;
}
else
{
count_store = int.Parse(this.txtCount_Store.Value) + 1;
}
txtCount_Store.Value = count_store.ToString();
//取得商品Table
DataSet ds_item = new DataSet();
DataTable Dt_Item = new DataTable();
ds_item = (DataSet)Session["STM272_" + PageTimeStamp.Value];
Dt_Item = ds_item.Tables[0];
int intCNT = Dt_Item.Rows.Count;
//自動展開商品
Item_Open(Dt_GetStore.Rows[0]["GROUP_NO"].ToString(), SLP_STORE.Text, SLP_PRICE_SUBSIDY_PERCENT2.Text, Dt_Item);
//非第一筆門市
if (intCNT > 0)
{
//顯示商品Panel-門市代號
txtITEM_STORE.Text = dr["STORE"].ToString();
lblITEM_STORE_NAME.Text = dr["STORE_NAME"].ToString();
lblITEM_GROUP_NO.Text = dr["GROUP_NO"].ToString();
lblITEM_COST.Text = SLP_PRICE_SUBSIDY_PERCENT2.Text;
//UPDATE折扣價格
Price_Into(SLP_STORE.Text, Dt_Item);
}
btnStoreCancel_Click(sender, e);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally
{
ScriptManager.RegisterStartupScript(
this.UpdatePanelLineItem,
typeof(UpdatePanel),
"UpdatePanel",
"window.setTimeout(function set_focus(){bConfirmState = true ;},1);", true);
}
}
protected void btnNOPASS_Click(object sender, EventArgs e)
{
#region 檢查判斷
//首次出貨日<=系統日就不可 審核解除.
if (DateTime.Parse(this.hdfACCEPT_FIRST_DATE.Value) <= DateTime.Today)
{
ErrorMsgLabel.Text = "首次出貨日(" + this.hdfACCEPT_FIRST_DATE.Value + ")小於等於生活日，不可解除審核";
return;
}
//20110712 正平註解掉
//if (DateTime.Parse(this.SLP_RETURN_DATE_END.Text) >= DateTime.Today)
//{
// ErrorMsgLabel.Text = "您無法解除進行中的檔期活動，如要修改此筆資料請結束此檔期活動迄日，在重新建立一筆新檔期活動 !!";
// return;
//}
#endregion
DateTime processtime = DateTime.Now;
STMModel.MaintainPromoteExhibition STM = new STMModel.MaintainPromoteExhibition(ConntionDB);
ParameterList.Clear();
ParameterList.Add(txtPROMOTE_ID.Text.Trim());//V_OLD_PROMOTE_ID
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_NEW_UPDATEUID
ParameterList.Add(processtime); //D_NEW_UPDATEDATE
STM.RevokePromoteExhibition(ParameterList);
QueryData(txtPROMOTE_ID.Text.Trim());
ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('審核解除成功');", true);
}
protected void btnPASS_Click(object sender, EventArgs e)
{
DateTime processtime = DateTime.Now;
STMModel.MaintainPromoteExhibition STM = new STMModel.MaintainPromoteExhibition(ConntionDB);
ParameterList.Clear();
ParameterList.Add(txtPROMOTE_ID.Text.Trim());//V_OLD_PROMOTE_ID
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_NEW_UPDATEUID
ParameterList.Add(processtime); //D_NEW_UPDATEDATE
STM.CheckPromoteExhibition(ParameterList);
QueryData(txtPROMOTE_ID.Text.Trim());
ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('審核成功');", true);
}
private void Price_Into(String Store, DataTable Dt_Item)
{
try
{
STMModel.MaintainPromoteExhibition STM = new STMModel.MaintainPromoteExhibition(ConntionDB);
#region 建立折扣價格Table
DataTable dt_Price = new DataTable();
#endregion
#region DB清除暫存工作資訊
ParameterList.Clear();
ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value);
STM.CLEARPRICEINFOLIST(ParameterList);
#endregion
#region 將商品資料寫入DB暫存Table
foreach (DataRow dr1 in Dt_Item.Rows)
{
if (dr1.RowState != DataRowState.Deleted)
{
ParameterList.Clear();
ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value);
ParameterList.Add(dr1["STORE"].ToString());
ParameterList.Add(dr1["ITEM"].ToString());
ParameterList.Add(dr1["PERIOD"].ToString());
ParameterList.Add(SLP_ACCEPT_FIRST_DATE.Text.Replace("/", ""));
ParameterList.Add(1);
STM.PREPPRICEINFOLIST(ParameterList);
}
}
#endregion
#region 捉價格資料，寫入折扣價格Table
ParameterList.Clear();
ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value);
dt_Price = STM.GETPRICEINFOLIST(ParameterList);
if (dt_Price == null || (dt_Price != null && dt_Price.Rows.Count <= 0))
{
return;
}
#endregion
#region 將折扣價格Table資料，update 至商品Table
foreach (DataRow dr1 in dt_Price.Rows)
{
object[] findPKs = new object[4];
int iSTMKind = int.Parse(dr1["PRICEDISCOUNTKIND"].ToString());
findPKs[0] = this.txtPROMOTE_ID.Text;
findPKs[1] = dr1["STORE"].ToString();
findPKs[2] = dr1["ITEM"].ToString();
findPKs[3] = dr1["PERIOD"].ToString();
DataRow dr = Dt_Item.Rows.Find(findPKs);
if (dr != null)
{
// PRICEDISCOUNTKIND
dr["COST_DIS_RATE"] = Decimal.Parse(dr1["COSTDISRATE"].ToString()) * 100;
dr["LIST_DIS_RATE"] = Decimal.Parse(dr1["T1_LISTDISRATE"].ToString()) * 100;
dr["NEW_COST_DIS_RATE"] = (Decimal.Parse(dr1["COSTDISRATE"].ToString()) * 100) - Decimal.Parse(dr["COST_SUBSIDY_PERCENT"].ToString());
dr["NEW_LIST_DIS_RATE"] = (Decimal.Parse(dr1["T1_LISTDISRATE"].ToString()) * 100) - Decimal.Parse(dr["PRICE_SUBSIDY_PERCENT"].ToString());
#region 將是否有商品折扣，有檔期折扣或是新成本折扣 > 新牌價折扣，如果沒有無法新增
if (iSTMKind == 0)
{
dr.Delete();
Dt_Item.AcceptChanges();
ErrorMsgLabel.Text = "無基本折扣 !! 無法新增";
}
else if (iSTMKind >= 64 && GetParameterValue(dr1["MESSAGE"].ToString(), "PROMOTE_CODE") != txtPROMOTE_ID.Text)
{
dr.Delete();
Dt_Item.AcceptChanges();
ErrorMsgLabel.Text = "已有檔期折扣，無法重複折扣 !! 無法新增";
}
else
{
Decimal rNewDisCost = Decimal.Parse(dr["NEW_COST_DIS_RATE"].ToString());
Decimal NEWDisPrice = Decimal.Parse(dr["NEW_LIST_DIS_RATE"].ToString());
if (rNewDisCost > NEWDisPrice)
{
dr.Delete();
Dt_Item.AcceptChanges();
ErrorMsgLabel.Text = "新成本折扣 > 新牌價折扣，無法新增";
}
}
#endregion
}
}
#endregion
#region 門市商品GRIDVIEW重新顯示資料
DataSet ds_item = new DataSet();
ds_item.Tables.Add(Dt_Item.Copy());
DataView dv_Item = new DataView(ds_item.Tables[0]);
dv_Item.RowFilter = "STORE = '" + Store + "' and ITEM <> 'NOITEM'";
GridView2.DataSource = dv_Item;
string SessionIDName2 = string.Format("{0}_{1}", PAGE_DT_02, PageTimeStamp.Value);
Session[SessionIDName2] = dv_Item;
GridView2.DataBind();
Session["STM272_" + PageTimeStamp.Value] = ds_item;
//商品筆數
this.txtCount_Item.Value = Dt_Item.Rows.Count.ToString();
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally { }
}
protected void btnEdt_Click(object sender, EventArgs e)
{
//檢核必輸入欄位
TextBox ACCEPT_DATE_START = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_ACCEPT_DATE_START).FindControl("TextBoxCode"));
TextBox ACCEPT_DATE_END = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_ACCEPT_DATE_END).FindControl("TextBoxCode"));
TextBox ACCEPT_FIRST_DATE = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_ACCEPT_FIRST_DATE).FindControl("TextBoxCode"));
TextBox RETURN_DATE_START = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_RETURN_DATE_START).FindControl("TextBoxCode"));
TextBox RETURN_DATE_END = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_RETURN_DATE_END).FindControl("TextBoxCode"));
TextBox txtCOL_DAYS = (TextBox)(SLP_COL_DAYS.TextBox_Code);
TextBox[] FieldIDs ={ txtPROMOTE_NAME, txtPROMOTE_MONTH.TextBoxCode_Object, txtACCT_MONTH.TextBoxCode_Object, ACCEPT_DATE_START, ACCEPT_DATE_END, ACCEPT_FIRST_DATE, RETURN_DATE_START, RETURN_DATE_END, txtCOL_DAYS };
string[] FieldNames ={ "檔期名稱", "活動月份", "結帳月份", "進貨開始日", "進貨結束日", "首次出貨日", "退貨開始日", "退貨結束日", "收款天數" };
int i = 0;
foreach (TextBox FieldName in FieldIDs)
{
if (FieldName.Text.Trim().Length == 0)
{
ErrorMsgLabel.Text = "必須輸入「" + FieldNames[i] + "」欄位";
return;
}
i++;
}
if (Request[SLP_COL_DAYS.TextBox_Name.UniqueID].ToString() == "查無資料")
{
ErrorMsgLabel.Text = "查無收款天數資料";
return;
}
if (SLP_NOTES.Text != "" && Request[SLP_NOTES.TextBox_Name.UniqueID].ToString() == "查無資料")
{
ErrorMsgLabel.Text = "查無檔期備註資料";
return;
}
//簡化至check_date
////進貨開始日須小於進貨結束日
//if ((SLP_ACCEPT_DATE_START.Text != "") || (SLP_ACCEPT_DATE_END.Text != ""))
//{
// if (DateTime.Parse(SLP_ACCEPT_DATE_START.Text) >= DateTime.Parse(SLP_ACCEPT_DATE_END.Text))
// {
// ErrorMsgLabel.Text = "進貨開始日須小於進貨結束日 !!";
// return;
// }
//}
//判斷是否已審核
if (txtCONFIRM_CODE.Text == "已審核")
{
ErrorMsgLabel.Text = "已審核資料不可修改，請先審核解除再進行修改 !!";
return;
}
//日期條件檢查
if (!check_date())
{
return;
}
DataSet ds1 = (DataSet)Session["STM272_" + PageTimeStamp.Value];
DataTable dtSTORE = ds1.Tables[0].DefaultView.ToTable(true, "STORE");
STMModel.MaintainPromoteExhibition STM = new STMModel.MaintainPromoteExhibition(ConnectionDB);
foreach (DataRow dr in dtSTORE.Rows)
{
if (!(STM.CheckDcDate(dr["STORE"].ToString(), ACCEPT_FIRST_DATE.Text)))
{
ErrorMsgLabel.Text = "檔期首次進貨日不在門市" + dr["STORE"].ToString() + "適用日期區間中!!";
return;
}
}
if (this.SLP_PRICE_SUBSIDY_PERCENT.Text.Length > 0)
{
if (Convert.ToDecimal(this.SLP_PRICE_SUBSIDY_PERCENT.Text.Trim()) > 100 || Convert.ToDecimal(this.SLP_PRICE_SUBSIDY_PERCENT.Text.Trim()) < 0)
{
ErrorMsgLabel.Text = "[門市補貼％]欄位請輸入100>門市補貼>0值<br/>";
return;
}
}
if (this.SLP_COST_SUBSIDY_PERCENT.Text.Length > 0)
{
if (Convert.ToDecimal(this.SLP_COST_SUBSIDY_PERCENT.Text.Trim()) > 100 || Convert.ToDecimal(this.SLP_COST_SUBSIDY_PERCENT.Text.Trim()) < 0)
{
ErrorMsgLabel.Text = "[出版社補貼％]欄位請輸入100>出版社補貼>0值<br/>";
return;
}
}
//儲存作業
int v_ID = 0;
#region
try
{
#region 取得畫面元件的值
DateTime processtime = DateTime.Now;
#endregion
#region 檔期活動
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_PROMOTE_MST"].Rows[0]["PROMOTE_ID"].ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_PROMOTE_MST"].Rows[0]["CREATEDATE"].ToString(), "datetime", false));
ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_PROMOTE_MST"].Rows[0]["CREATEUID"].ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_PROMOTE_MST"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false));
ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_PROMOTE_MST"].Rows[0]["UPDATEUID"].ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtPROMOTE_NAME.Text, "string", false)); //V_NEW_PROMOTE_NAME
ParameterList.Add(GetValueSetParameter(this.txtPROMOTE_MONTH.Text, "string", false)); //V_NEW_PROMOTE_MONTH
ParameterList.Add(GetValueSetParameter(this.txtACCT_MONTH.Text, "string", false)); //V_NEW_ACCT_MONTH
ParameterList.Add(GetValueSetParameter(this.SLP_COL_DAYS.Text, "string", false)); //V_NEW_COL_DAYS
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_START.Text, "date", false)); //D_NEW_ACCEPT_DATE_START
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_END.Text, "date", false)); //D_NEW_ACCEPT_DATE_END
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_FIRST_DATE.Text, "date", false)); //D_NEW_ACCPET_FIRST_DATE
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_START.Text, "date", false)); //D_NEW_RETURN_DATE_START
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_END.Text, "date", false)); //D_NEW_RETURN_DATE_END
ParameterList.Add(GetValueSetParameter(this.ddlPROMOTE_TYPE.Text, "int", false)); //N_NEW_PROMOTE_TYPE
ParameterList.Add(GetValueSetParameter(this.ddlDISCOUNT_TYPE.Text, "string", false)); //V_NEW_DISCOUNT_TYPE
ParameterList.Add(GetValueSetParameter(this.SLP_NOTES.Text, "string", false)); //N_NEW_NOTES
ParameterList.Add(GetValueSetParameter(this.SLP_PRICE_SUBSIDY_PERCENT.Text, "Decimal", false)); //N_PRICE_SUBSIDY_PERCENT
ParameterList.Add(GetValueSetParameter(this.SLP_COST_SUBSIDY_PERCENT.Text, "Decimal", false)); //N_COST_SUBSIDY_PERCENT
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_NEW_AC_UID
if (this.txtCONFIRM_CODE.Text == "已審核")
ParameterList.Add(1); //N_CONFIRM_CODE
else
ParameterList.Add(0); //N_CONFIRM_CODE
ParameterList.Add(64); //N_NEW_DISCOUNT_KIND
ParameterList.Add(processtime);
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false));
#endregion
#region 商品
DataSet ds = (DataSet)Session["STM272_" + PageTimeStamp.Value];
#endregion
STMModel.MaintainPromoteExhibition BCO = new STMModel.MaintainPromoteExhibition(ConnectionDB);
BCO.UpdateStoreBase(ParameterList, null, ds.Tables[0]);
QueryData(ds_Data.Tables["VDS_STM_PROMOTE_MST"].Rows[0]["PROMOTE_ID"].ToString());
ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('更新完成');", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
#endregion
}
protected void btnSave_Click(object sender, EventArgs e)
{
STMModel.MaintainPromoteExhibition STM = new STMModel.MaintainPromoteExhibition(ConntionDB);
//檢核必輸入欄位
TextBox ACCEPT_DATE_START = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_ACCEPT_DATE_START).FindControl("TextBoxCode"));
TextBox ACCEPT_DATE_END = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_ACCEPT_DATE_END).FindControl("TextBoxCode"));
TextBox ACCEPT_FIRST_DATE = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_ACCEPT_FIRST_DATE).FindControl("TextBoxCode"));
TextBox RETURN_DATE_START = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_RETURN_DATE_START).FindControl("TextBoxCode"));
TextBox RETURN_DATE_END = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_RETURN_DATE_END).FindControl("TextBoxCode"));
TextBox txtPROMOTE = (TextBox)(txtPROMOTE_MONTH.TextBoxCode_Object);
TextBox txtACCT = (TextBox)(txtACCT_MONTH.TextBoxCode_Object);
TextBox txtCOL_DAYS = (TextBox)(SLP_COL_DAYS.TextBox_Code);
//
//
TextBox[] FieldIDs ={ txtPROMOTE_ID, txtPROMOTE_NAME, txtPROMOTE_MONTH.TextBoxCode_Object, txtACCT_MONTH.TextBoxCode_Object, ACCEPT_DATE_START, ACCEPT_DATE_END, ACCEPT_FIRST_DATE, RETURN_DATE_START, RETURN_DATE_END, txtCOL_DAYS };
string[] FieldNames ={ "檔期編號", "檔期名稱", "活動月份", "結帳月份", "進貨開始日", "進貨結束日", "首次出貨日", "退貨開始日", "退貨結束日", "收款天數" };
int i = 0;
foreach (TextBox FieldName in FieldIDs)
{
if (FieldName.Text.Trim().Length == 0)
{
ErrorMsgLabel.Text = "必須輸入「" + FieldNames[i] + "」欄位";
return;
}
i++;
}
if (Request[SLP_COL_DAYS.TextBox_Name.UniqueID].ToString() == "查無資料")
{
ErrorMsgLabel.Text = "查無收款天數資料";
return;
}
if (SLP_NOTES.Text != "" && Request[SLP_NOTES.TextBox_Name.UniqueID].ToString() == "查無資料")
{
ErrorMsgLabel.Text = "查無檔期備註資料";
return;
}
//簡化至check_date
////進貨開始日須小於進貨結束日
//if ((SLP_ACCEPT_DATE_START.Text != "") || (SLP_ACCEPT_DATE_END.Text != ""))
//{
// if (DateTime.Parse(SLP_ACCEPT_DATE_START.Text) >= DateTime.Parse(SLP_ACCEPT_DATE_END.Text))
// {
// ErrorMsgLabel.Text = "進貨開始日須小於進貨結束日 !!";
// return;
// }
//}
//日期條件檢查
if (!check_date())
{
return;
}
DataSet ds1 = (DataSet)Session["STM272_" + PageTimeStamp.Value];
DataTable dtSTORE = ds1.Tables[0].DefaultView.ToTable(true, "STORE");
foreach (DataRow dr in dtSTORE.Rows)
{
DataRow[] drNoItem = (DataRow[])ds1.Tables[0].Select("STORE='" + dr["STORE"].ToString() + "' AND (ITEM='NOITEM' OR ITEM IS NULL)");
if (drNoItem.Length > 0)
{
ErrorMsgLabel.Text = "尚有門市未新增商品資料 !!";
return;
}
if (!(STM.CheckDcDate(dr["STORE"].ToString(), ACCEPT_FIRST_DATE.Text)))
{
ErrorMsgLabel.Text = "檔期首次進貨日不在門市" + dr["STORE"].ToString()+"適用日期區間中!!";
return;
}
}
if (this.SLP_PRICE_SUBSIDY_PERCENT.Text.Length > 0)
{
if (Convert.ToDecimal(this.SLP_PRICE_SUBSIDY_PERCENT.Text.Trim()) > 100 || Convert.ToDecimal(this.SLP_PRICE_SUBSIDY_PERCENT.Text.Trim()) < 0)
{
ErrorMsgLabel.Text = "[門市補貼％]欄位請輸入100>門市補貼>0值<br/>";
return;
}
}
if (this.SLP_COST_SUBSIDY_PERCENT.Text.Length > 0)
{
if (Convert.ToDecimal(this.SLP_COST_SUBSIDY_PERCENT.Text.Trim()) > 100 || Convert.ToDecimal(this.SLP_COST_SUBSIDY_PERCENT.Text.Trim()) < 0)
{
ErrorMsgLabel.Text = "[出版社補貼％]欄位請輸入100>出版社補貼>0值<br/>";
return;
}
}
STMModel.VDS_STM37_BCO bco37 = new STMModel.VDS_STM37_BCO(ConnectionDB);
string ProID = txtPROMOTE_ID.Text;
int N_CNT_M;
int N_CNT_N;
DataTable dt_s = bco37.QueryPromoteS(ProID, out N_CNT_M, out N_CNT_N);
if (N_CNT_M > 0)
{
this.ErrorMsgLabel.Text = "與特殊書展編號重複";
return;
}
//儲存作業
string v_ID = "";
#region
try
{
#region 取得畫面元件的值
DateTime processtime = DateTime.Now;
#endregion
#region 檔期活動
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txtPROMOTE_NAME.Text, "string", false)); //V_PROMOTE_NAME
ParameterList.Add(GetValueSetParameter(this.txtPROMOTE_MONTH.Text, "string", false)); //V_PROMOTE_MONTH
ParameterList.Add(GetValueSetParameter(this.txtACCT_MONTH.Text, "string", false)); //V_ACCT_MONTH
ParameterList.Add(GetValueSetParameter(this.SLP_COL_DAYS.Text, "string", false)); //V_COL_DAYS
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_START.Text, "date", false)); //D_ACCEPT_DATE_START
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_DATE_END.Text, "date", false)); //D_ACCEPT_DATE_END
ParameterList.Add(GetValueSetParameter(this.SLP_ACCEPT_FIRST_DATE.Text, "date", false)); //D_ACCPET_FIRST_DATE
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_START.Text, "date", false)); //D_RETURN_DATE_START
ParameterList.Add(GetValueSetParameter(this.SLP_RETURN_DATE_END.Text, "date", false)); //D_RETURN_DATE_END
ParameterList.Add(GetValueSetParameter(this.ddlPROMOTE_TYPE.SelectedValue.ToString(), "int", false)); //N_PROMOTE_TYPE
ParameterList.Add(GetValueSetParameter(this.ddlDISCOUNT_TYPE.SelectedValue.ToString(), "string", false)); //V_DISCOUNT_TYPE
ParameterList.Add(GetValueSetParameter(this.SLP_NOTES.Text, "string", false)); //N_NOTES
ParameterList.Add(GetValueSetParameter(this.SLP_PRICE_SUBSIDY_PERCENT.Text, "Decimal", false)); //N_PRICE_SUBSIDY_PERCENT
ParameterList.Add(GetValueSetParameter(this.SLP_COST_SUBSIDY_PERCENT.Text, "Decimal", false)); //N_COST_SUBSIDY_PERCENT
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_AC_UID
if (this.txtCONFIRM_CODE.Text == "已審核")
ParameterList.Add(1); //N_CONFIRM_CODE
else
ParameterList.Add(0); //N_CONFIRM_CODE
ParameterList.Add(64); //N_DISCOUNT_KIND固定
ParameterList.Add(processtime);
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false));
ParameterList.Add(processtime);
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtPROMOTE_ID.Text, "string", false));
#endregion
#region 商品
DataSet ds = (DataSet)Session["STM272_" + PageTimeStamp.Value];
#endregion
STMModel.MaintainPromoteExhibition BCO = new STMModel.MaintainPromoteExhibition(ConnectionDB);
v_ID = BCO.CreateStoreBase(ParameterList, null, ds.Tables[0]);
if ((v_ID == "") || (v_ID == null))
{
throw new Exception("新增0筆資料!");
}
else
{
QueryData(v_ID);
txtPROMOTE_ID.ReadOnly = true;
txtPROMOTE_ID.CssClass = "readtxtbox";
btnSave.Visible = false; //確定新增
btnAddCancle.Visible = false; //取消(回查詢頁)
btnEdt.Visible = CanUpdate; //確定更新
btnUpdateCancel.Visible = true; //取消
btnAdd.Visible = CanUpdate; //新增門市
btnAddItem.Visible = CanUpdate; //新增商品
btnUpdateItem.Visible = false;
GridView1.Columns[4].Visible = CanDelete; //商品 GRID "刪除"欄位
GridView2.Columns[8].Visible = CanDelete; //門市 GRID "刪除"欄位
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, true, string.Empty, this.btnEdt, WUI_GMToolbarV.ClickAction.ButtonClick);
ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('新增完成');", true);
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
#endregion
}
