protected void btnModify_Click(object sender, EventArgs e)
{
switch (OperationMode)
{
case OpMode.View:
try
{
OperationMode = OpMode.Edit;
SLP_VENDOR.ReadOnly = true;
DDL_PAY_KIND.Enabled = true;
DDL_TRAN_CORP.Enabled = true;
GridView1.Columns[2].Visible = true;
if (CanCreate == true)
{
btnAddTranItem.Visible = true;
}
else
{
btnAddTranItem.Visible = false;
}
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, true, "", btnModify,
WUI_GMToolbarV.ClickAction.ButtonClick);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, false, "", null,
WUI_GMToolbarV.ClickAction.ButtonClick);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Copy, false, "", null,
WUI_GMToolbarV.ClickAction.ButtonClick);
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally { Finally_Function(); }
break;
case OpMode.Edit:
try
{
if (string.IsNullOrEmpty(SLP_VENDOR.Text.Trim()) || string.IsNullOrEmpty(DDL_PAY_KIND.SelectedValue)
|| string.IsNullOrEmpty(DDL_TRAN_CORP.SelectedValue))
{
ErrorMsgLabel.Text = "供應商代號、商品收費方式、轉運商運費 需有值";
return;
}
DataTable dt = ItemData.GetChanges(DataRowState.Deleted);
int inCount = (dt == null ? 0 : dt.Rows.Count);
if ((DDL_PAY_KIND.SelectedValue == "1" || DDL_PAY_KIND.SelectedValue == "2"))
{
if (ItemData.Rows.Count > 0)
{
if (inCount != ItemData.Rows.Count)
{
ErrorMsgLabel.Text = "商品收費方式若為【全部要收】或【全部不收】，則不需設定明細資料，請先將所有品項刪除";
return;
}
}
}
else
{
if (ItemData.Rows.Count > 0)
{
if (inCount == ItemData.Rows.Count)
{
ErrorMsgLabel.Text = "商品收費方式如為單品要收或單品不收，就需設定明細資料";
return;
}
}
else
{
ErrorMsgLabel.Text = "商品收費方式如為單品要收或單品不收，就需設定明細資料";
return;
}
}
//把修改寫回資料庫
ArrayList parameterList = new ArrayList();
ArrayList parameterList2 = new ArrayList();
VAM24_BCO bco = new VAM24_BCO(ConnectionDB);
CAMCommon bco1 = new CAMCommon();
try
{
parameterList.Add(bco1.GetValueSetParameter(ViewState["CurrentID"].ToString(), "string", false)); //0
parameterList.Add(bco1.GetValueSetParameter(DDL_PAY_KIND.SelectedValue, "string", false)); //1
parameterList.Add(bco1.GetValueSetParameter(DDL_TRAN_CORP.SelectedValue, "string", false)); //2
parameterList.Add(bco1.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //3
for (int i = 0; i < ItemData.Rows.Count; i++)
{
if (ItemData.Rows[i].RowState != DataRowState.Deleted)
{
ArrayList detailParameter = new ArrayList();
detailParameter.Add(bco1.GetValueSetParameter(ItemData.Rows[i]["ITEM"].ToString(), "string", false));
detailParameter.Add(bco1.GetValueSetParameter(Session["UID"].ToString(), "string", false));
parameterList2.Add(detailParameter);
}
}
string strReturn = bco.UpdateTranShip(parameterList, parameterList2);
if (strReturn != "")
{
this.ErrorMsgLabel.Text = "更新失敗：" + strReturn;
return;
}
OperationMode = OpMode.View;
SetControlStatus();
BindData();
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, false, "", null,
WUI_GMToolbarV.ClickAction.ButtonClick);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, true, "", btnModify,
WUI_GMToolbarV.ClickAction.ButtonClick);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Copy, false, string.Empty, null, WUI_GMToolbarV.ClickAction.ButtonClick);
this.ErrorMsgLabel.Text = "更新成功";
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", string.Format("alert('更新成功');location.replace('VAM241.aspx?Code=" + Request["Code"].ToString() + "');"), true);
}
catch
{
throw;
}
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally { Finally_Function(); }
break;
}
}
protected void btnAddDetail_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(SLP_VENDOR.Text.Trim()) || string.IsNullOrEmpty(DDL_PAY_KIND.SelectedValue.Trim()))
{
ErrorMsgLabel.Text = "供應商代號、商品收費方式 需有值";
return;
}
if (DDL_PAY_KIND.SelectedValue == "1" || DDL_PAY_KIND.SelectedValue == "2")
{
ErrorMsgLabel.Text = "商品收費方式若為【全部要收】或【全部不收】，則不需設定明細資料";
return;
}
ArrayList ParameterList = new ArrayList();
ParameterList.Add(SLP_VENDOR.Text.Trim());
ParameterList.Add(SLP_ITEM.Text.Trim());
ParameterList.Add(Session["UID"].ToString());
VAM24_BCO bco = new VAM24_BCO(ConnectionDB);
string[] strResult = bco.CheckItem(ParameterList,null);
if (strResult[0] == "0")
{
ErrorMsgLabel.Text = strResult[1];
return;
}
DataRow[] dra1 = ItemData.Select(string.Format("ITEM = '{0}'", SLP_ITEM.Text));
if (dra1.Length > 0)
{
ErrorMsgLabel.Text = "品項不能重複";
return;
}
DoAddDetail();
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally { Finally_Function(); }
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strCODE;
try
{
if (string.IsNullOrEmpty(SLP_VENDOR.Text.Trim()) || string.IsNullOrEmpty(DDL_PAY_KIND.SelectedValue)
|| string.IsNullOrEmpty(DDL_TRAN_CORP.SelectedValue))
{
ErrorMsgLabel.Text = "供應商代號、商品收費方式、轉運商運費 需有值";
return;
}
DataTable dt = ItemData.GetChanges(DataRowState.Deleted);
int inCount = (dt == null ? 0 : dt.Rows.Count);
if ((DDL_PAY_KIND.SelectedValue == "1" || DDL_PAY_KIND.SelectedValue == "2"))
{
if (ItemData.Rows.Count > 0)
{
if (inCount != ItemData.Rows.Count)
{
ErrorMsgLabel.Text = "商品收費方式若為【全部要收】或【全部不收】，則不需設定明細資料，請先將所有品項刪除";
return;
}
}
}
else
{
if (ItemData.Rows.Count > 0)
{
if (inCount == ItemData.Rows.Count)
{
ErrorMsgLabel.Text = "商品收費方式如為單品要收或單品不收，就需設定明細資料。";
return;
}
}
else
{
ErrorMsgLabel.Text = "商品收費方式如為單品要收或單品不收，就需設定明細資料";
return;
}
}
ArrayList parameterList = new ArrayList();
parameterList.Clear();
ArrayList masterParameter = new ArrayList();
CAMCommon bco1 = new CAMCommon();
masterParameter.Add(bco1.GetValueSetParameter(SLP_VENDOR.Text, "string", false)); //0
masterParameter.Add(bco1.GetValueSetParameter(DDL_PAY_KIND.SelectedValue, "string", false)); //1
masterParameter.Add(bco1.GetValueSetParameter(DDL_TRAN_CORP.SelectedValue, "string", false)); //2
masterParameter.Add(bco1.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //3
string strITEM = string.Empty;
for (int i = 0; i < ItemData.Rows.Count; i++)
{
if (ItemData.Rows[i].RowState != DataRowState.Deleted)
{
ArrayList detailParameter = new ArrayList();
detailParameter.Add(bco1.GetValueSetParameter(ItemData.Rows[i]["ITEM"].ToString(), "string", false));
detailParameter.Add(bco1.GetValueSetParameter(Session["UID"].ToString(), "string", false));
parameterList.Add(detailParameter);
}
}
VAM24_BCO bco = new VAM24_BCO(ConnectionDB);
string[] strReturn = bco.CreateTranShip(masterParameter, parameterList);
if (strReturn[2] == "")
{
strCODE = strReturn[1];
//ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", string.Format("alert('新增成功');location.replace('VAM242.aspx?Code=" + Request["Code"].ToString() + "&Mode=View&ID=" + strCODE + "');"), true);
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", string.Format("alert('新增成功');location.replace('VAM241.aspx?Code=" + Request["Code"].ToString() + "');"), true);
}
else
{
this.ErrorMsgLabel.Text = "新增失敗：" + strReturn[2];
return;
}
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個
}
finally { Finally_Function(); }
}
private void FillTextBoxData(string strVENDOR)
{
VAM24_BCO BCO = new VAM24_BCO(ConnectionDB);
ArrayList parameterList = new ArrayList();
parameterList.Add(strVENDOR);
DataTable dt = BCO.GetTranShipMain(parameterList);
SLP_VENDOR.Text = dt.Rows[0]["VENDOR"].ToString();
DDL_PAY_KIND.SelectedValue = dt.Rows[0]["PAY_KIND"].ToString();
DDL_TRAN_CORP.SelectedValue = dt.Rows[0]["TRAN_CORP"].ToString();
txtCREATEDATE.Text = DateTime.Parse(dt.Rows[0]["CREATEDATE"].ToString()).ToString("yyyy/MM/dd");
SLP_CREATEUID.Text = dt.Rows[0]["CREATEUID"].ToString();
txtUPDATEDATE.Text = DateTime.Parse(dt.Rows[0]["UPDATEDATE"].ToString()).ToString("yyyy/MM/dd");
SLP_UPDATEUID.Text = dt.Rows[0]["UPDATEUID"].ToString();
}
private void BindData()
{
VAM24_BCO BCO = new VAM24_BCO(ConnectionDB);
ArrayList parameterList = new ArrayList();
parameterList.Add(ViewState["CurrentID"].ToString());
DataTable dt = BCO.GetTranItem(parameterList);
GridView1.DataSource = dt;
GridView1.DataBind();
ItemData = dt;
TabContainer2.Visible = true;
FillTextBoxData(ViewState["CurrentID"].ToString());
}
protected void btnDel_Click(object sender, EventArgs e)
{
try
{
string SessionIDName = "VAM241_" + PageTimeStamp.Value;
DataTable dtA = new DataTable();
dtA = (DataTable)Session[SessionIDName];
LinkButton btn = sender as LinkButton;
GridViewRow gr = (btn.BindingContainer as GridViewRow);
int i = gr.RowIndex;
DataRow drA = null;
if (dtA.Rows[i]["ITEM"].ToString().Trim()=="")
{
drA = dtA.Select("VENDOR='" + dtA.Rows[i]["VENDOR"].ToString() + "'")[0];
}
else
{
drA = dtA.Select("VENDOR='" + dtA.Rows[i]["VENDOR"].ToString() + "' And ITEM ='" + dtA.Rows[i]["ITEM"].ToString() + "'")[0];
}
CAMCommon CAMCommonBCO = new CAMCommon();
ArrayList ParameterDel = new ArrayList();
ParameterDel.Add(CAMCommonBCO.GetValueSetParameter(drA["VENDOR"].ToString(), "string", false));
ParameterDel.Add(CAMCommonBCO.GetValueSetParameter(drA["ITEM"].ToString(), "string", false));
ParameterDel.Add(CAMCommonBCO.GetValueSetParameter(Session["UID"].ToString(), "string", false));
VAM24_BCO BCO = new VAM24_BCO(ConntionDB);
string sMsg = BCO.DeleteTranShipItem(ParameterDel, null);
if (sMsg == "刪除成功")
{
drA.Delete();
dtA.AcceptChanges();
Session[SessionIDName] = dtA;
this.GridView1.DataSource = dtA;
this.GridView1.DataBind();
if (dtA.Rows.Count > 0)
{
StringCollection sc = new StringCollection();
foreach (DataRow dr in dtA.Rows)
{
sc.Add(dr["VENDOR"].ToString());
}
Session["VAM24CodeCollection"] = sc;
}
}
ErrorMsgLabel.Text = sMsg;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
private void BindData()
{
CAMCommon CAMCommonBCO = new CAMCommon();
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_VENDOR_S.Text, "string", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_VENDOR_E.Text, "string", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(DDL_PAY_KIND.SelectedValue, "string", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_ITEM_S.Text, "string", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_ITEM_E.Text, "string", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(DDL_TRAN_CORP.SelectedValue, "string", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_CREATEDATE.StartDate, "date", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_CREATEDATE.EndDate, "date", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_CREATEUID.Text, "string", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_UPDATEDATE.StartDate, "date", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_UPDATEDATE.EndDate, "date", false));
ParameterList.Add(CAMCommonBCO.GetValueSetParameter(SLP_UPDATEUID.Text, "string", false));
ParameterList.Add(TextBoxRowCountLimit.Text);
VAM24_BCO BCO = new VAM24_BCO(ConntionDB);
DataTable dt = BCO.QueryTranShipByFind(ParameterList);
string SessionIDName = "VAM241_" + PageTimeStamp.Value;
Session[SessionIDName] = dt;
GridView1.DataSource = dt;
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 20 : (int.Parse(TextBoxPagesize.Text) < 0) ? 20 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
if (dt.Rows.Count > 0)
{
StringCollection sc = new StringCollection();
foreach (DataRow dr in dt.Rows)
{
sc.Add(dr["VENDOR"].ToString());
}
Session["VAM24CodeCollection"] = sc;
}
else
{
ErrorMsgLabel.Text = "查無資料";
}
}
