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 = "查無資料"; } }