}//end InsertCancelButton_Click
/// <summary>
/// 由新增模式，確認新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void InsertButton_Click(object sender, EventArgs e)
{
#region
try
{
#region 取得畫面元件的值
string v_Chain_Code = ((STM_SLP_StoreChain)FormView1.FindControl("SLP_StoreChain1")).Text.Trim();
string v_Store_Code = ((PIC.VDS2G.WebUI.SLP.SLP_Store)FormView1.FindControl("SLP_Store1")).Text.Trim();
DateTime processtime = DateTime.Now;
#endregion
// 2009-05-04 cyhsu 在Server Site 存檔前，檢查門市與通路關連正確性
ArrayList ParameterList = new ArrayList();//20091113
#region 檢查通路與門市
//檢查門市是否屬於該通路
if ((v_Chain_Code != "") && (v_Store_Code != ""))
{
ParameterList.Clear();
ParameterList.Add(v_Chain_Code); // 通路
ParameterList.Add(v_Store_Code); // 門市
ParameterList.Add(Session["UID"].ToString());
PIC.VDS2G.BSM.CRM.QueryCRMCommon bco = new PIC.VDS2G.BSM.CRM.QueryCRMCommon(ConnectionDB);
bool b_CheckRes;
b_CheckRes = bco.CheckChanAndStore(ParameterList);
if (!b_CheckRes)
{
sb.Length = 0;
sb.AppendFormat("門市[{1}]不屬於通路[{0}]!",
v_Chain_Code,
v_Store_Code);
throw new Exception(sb.ToString());
}
}
#endregion
#region 加入輸入條件
#region Master
ParameterList.Clear();
ParameterList.Add(string.Format("{0}_{1}", v_Chain_Code, v_Store_Code));
ParameterList.Add(string.Format("{0}_{1}", v_Chain_Code, v_Store_Code));
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(v_Chain_Code);
ParameterList.Add(v_Store_Code);
#endregion
#region Detail
DataTable dtDetail = new DataTable();
dtDetail.Columns.Add("CREATEDATE");
dtDetail.Columns.Add("CREATEUID");
dtDetail.Columns.Add("UPDATEDATE");
dtDetail.Columns.Add("UPDATEUID");
dtDetail.Columns.Add("PMA");
dtDetail.Columns.Add("IS_DIS_BYPO");
dtDetail.Columns.Add("IS_MULTIPO");
//20090105 added for spec changed
dtDetail.Columns.Add("ROOT_NO");
for (Int32 i = 0; i <= GridView2.Rows.Count - 1; i++)
{
DataRow newRowDETL = dtDetail.NewRow();
CheckBox chk_ISEXISTED_Sgl = (CheckBox)GridView2.Rows[i].FindControl("chk_ISEXISTED_Sgl");
CheckBox chk_single = (CheckBox)GridView2.Rows[i].FindControl("chk_POSingle_Sgl");
CheckBox chk_multi = (CheckBox)GridView2.Rows[i].FindControl("chk_POMulti_Sgl");
Label lbl_PMA = (Label)GridView2.Rows[i].FindControl("lbl_PMA");
Label lbl_root_no = (Label)GridView2.Rows[i].FindControl("lbl_root_no");
if (chk_ISEXISTED_Sgl.Checked)
{
newRowDETL["CREATEDATE"] = processtime;
newRowDETL["CREATEUID"] = Session["UID"].ToString();
newRowDETL["UPDATEDATE"] = processtime;
newRowDETL["UPDATEUID"] = Session["UID"].ToString();
newRowDETL["PMA"] = lbl_PMA.Text.Trim();
newRowDETL["IS_DIS_BYPO"] = chk_single.Checked ? 1 : 0;
newRowDETL["IS_MULTIPO"] = chk_multi.Checked ? 1 : 0;
newRowDETL["ROOT_NO"] = lbl_root_no.Text.Trim();
dtDetail.Rows.Add(newRowDETL);
}
}
#endregion
#endregion
ALOModel.MaintainChainPOSetting BCO = new ALOModel.MaintainChainPOSetting(ConnectionDB);
string v_ID = "";
v_ID = BCO.CreateMasterAndDetail(ParameterList, dtDetail, null).ToString();
if (v_ID == "")
{
throw new Exception("新增0筆資料!");
}
else
{
b_CopyNew = false;
s_ID = v_ID;
ResultMsgLabel.Text = "新增完成";
SwitchFormviewMode(FormViewMode.ReadOnly);
aryParamsPKey.Clear();//清空ID ArrayList
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}//end InsertButton_Click
/// <summary>
/// 檢查畫面條件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected System.Text.StringBuilder CheckPage()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
TextBox txt_Store = (TextBox)this.slp_Store.FindControl("TextBoxCode");
TextBox txt_StoreChain = (TextBox)this.slp_StoreChain.FindControl("TextBoxCode");
#region 檢查必填欄位
if ((slp_Crm_Date.Text == "" || slp_Crm_Date.Text == "____/__/__") &&
slp_Store.Text == "" && slp_StoreChain.Text == "")
{
throw new Exception("請至少輸入一項查詢條件");
}
#endregion
//if (txt_Store.Text.Trim() == string.Empty)
//{ sb.Append("門市欄位不可空白\\r\\n"); }
//if (txt_StoreChain.Text.Trim() == string.Empty)
//{ sb.Append("通路欄位不可空白\\r\\n"); }
//檢查門市是否屬於該通路
if ((this.slp_Store.Text != "") && (this.slp_StoreChain.Text != ""))
{
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(this.slp_StoreChain.Text); // 通路
ParameterList.Add(this.slp_Store.Text); // 門市
ParameterList.Add(Session["UID"].ToString());
BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB);
bool b_CheckRes;
b_CheckRes = bco.CheckChanAndStore(ParameterList);
if (!b_CheckRes)
{
sb.AppendFormat("門市[{1}]不屬於通路[{0}]! 請重新輸入查詢條件!",
this.slp_StoreChain.Text,
this.slp_Store.Text);
}
}
return sb;
}
