public static string GetBarcode_Server(string strPar) { string strSKU = string.Empty; string strItemPeriod = string.Empty; string strBarcode = string.Empty; string strPeriod_Barcode = string.Empty; string strResult = ""; if (strPar != string.Empty) { #region 離開指定欄位時 int iPos = 0; iPos = strPar.IndexOf("____"); strSKU = strPar.Substring(0, iPos); strItemPeriod = strPar.Substring(iPos + 4, strPar.Length - iPos - 4); DataTable dt = null; ParameterList.Clear(); ParameterList.Add(strSKU); ParameterList.Add(strItemPeriod); MaintainChainItemInfo BCO = new MaintainChainItemInfo(ConntionDB); dt = BCO.QueryItemPeriodBarcode(ParameterList); if (dt.Rows.Count > 0) { strBarcode = dt.Rows[0]["BARCODE"].ToString().Trim(); strPeriod_Barcode = dt.Rows[0]["PERIOD_BARCODE"].ToString().Trim(); } #endregion } //最後一個參數是比對用的,萬一回傳的順序不一樣,可以用這個參數來識別 strResult = strBarcode + "<partition>" + strPeriod_Barcode + "<partition>" + strPar; return strResult; }
protected void btnDel_Click(object sender, EventArgs e) { try { string strNowDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); MaintainChainItemInfo BCO = new MaintainChainItemInfo(ConntionDB); bool bResult = false; //0.OLD_UPDATEDATE //1.OLD_UPDATEUID //2.UPDATEDATE //3.UPDATEUID //4.CHAN_NO //5.ITEM //6.PERIOD ParameterList.Clear(); ParameterList.Add(hdfUPDATEDATE.Value.ToString()); //0.OLD_UPDATEDATE ParameterList.Add(hdfUPDATEUID.Value.ToString()); //1.OLD_UPDATEUID ParameterList.Add(strNowDate); //2.UPDATEDATE ParameterList.Add(Session["UID"].ToString()); //3.UPDATEUID ParameterList.Add(SLP_StoreChain1.Text.Trim()); //4.CHAN_NO ParameterList.Add(SLP_SKU1.Text.Trim()); //5.ITEM ParameterList.Add(SLP_ItemPeriod1.Text.Trim()); //6.PERIOD bResult = BCO.DeleteChainItemInfo(ParameterList, null); Response.Redirect("MKT031.aspx?Code=MKT03", false); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
private void SaveData() { try { string strNowDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string strID = string.Empty; MaintainChainItemInfo BCO = new MaintainChainItemInfo(ConntionDB); bool bResult = false; switch (ViewState["Mode"].ToString().Trim()) { case "Insert": //0.NAME //1.CREATEDATE //2.CREATEUID //3.UPDATEDATE //4.UPDATEUID //5.ENABLE //6.CHAN_NO //7.ITEM //8.PERIOD //9.CHAN_CODE //10.EAN_CODE //11.BARCODE //12.PERIOD_BARCODE //13.DATASOURCE //14.MEMO //15.PRICES //16.COVER_PRICE //17.COST_PRICE //18.CHECK_FLAG //19.VDS_PRICE ParameterList.Clear(); ParameterList.Add(SLP_SKU1.Text.Trim()); //0.NAME ParameterList.Add(strNowDate); //1.CREATEDATE ParameterList.Add(Session["UID"].ToString()); //2.CREATEUID ParameterList.Add(strNowDate); //3.UPDATEDATE ParameterList.Add(Session["UID"].ToString()); //4.UPDATEUID ParameterList.Add("1"); //5.ENABLE ParameterList.Add(SLP_StoreChain1.Text.Trim()); //6.CHAN_NO ParameterList.Add(SLP_SKU1.Text.Trim()); //7.ITEM ParameterList.Add(SLP_ItemPeriod1.Text.Trim()); //8.PERIOD ParameterList.Add(txtCHAN_CODE.Text.Trim()); //9.CHAN_CODE ParameterList.Add(txtEAN_CODE.Text.Trim()); //10.EAN_CODE ParameterList.Add(txtBARCODE.Text.Trim()); //11.BARCODE ParameterList.Add(txtPERIOD_BARCODE.Text.Trim()); //12.PERIOD_BARCODE ParameterList.Add(ddlDATASOURCE.SelectedIndex + 1); //13.DATASOURCE ParameterList.Add(txtMEMO.Text.Trim()); //14.MEMO ParameterList.Add("0"); //15.PRICES ParameterList.Add("0"); //16.COVER_PRICE ParameterList.Add("0"); //17.COST_PRICE ParameterList.Add("0"); //18.CHECK_FLAG ParameterList.Add("0"); //19.VDS_PRICE bResult = BCO.CreateChainItemInfo(ParameterList, out strID, null); break; case "Edit": //0.NAME //1.OLD_UPDATEDATE //2.OLD_UPDATEUID //3.UPDATEDATE //4.UPDATEUID //5.ENABLE //6.CHAN_NO //7.ITEM //8.PERIOD //9.CHAN_CODE //10.EAN_CODE //11.BARCODE //12.PERIOD_BARCODE //13.DATASOURCE //14.MEMO //15.PRICES //16.COVER_PRICE //17.COST_PRICE //18.CHECK_FLAG //19.VDS_PRICE strID = hdfID.Value.Trim(); ParameterList.Clear(); ParameterList.Add(SLP_SKU1.Text.Trim()); //0.NAME ParameterList.Add(hdfUPDATEDATE.Value.ToString()); //1.OLD_UPDATEDATE ParameterList.Add(hdfUPDATEUID.Value.ToString()); //2.OLD_UPDATEUID ParameterList.Add(strNowDate); //3.UPDATEDATE ParameterList.Add(Session["UID"].ToString()); //4.UPDATEUID ParameterList.Add("1"); //5.ENABLE ParameterList.Add(SLP_StoreChain1.Text.Trim()); //6.CHAN_NO ParameterList.Add(SLP_SKU1.Text.Trim()); //7.ITEM ParameterList.Add(SLP_ItemPeriod1.Text.Trim()); //8.PERIOD ParameterList.Add(txtCHAN_CODE.Text.Trim()); //9.CHAN_CODE ParameterList.Add(txtEAN_CODE.Text.Trim()); //10.EAN_CODE ParameterList.Add(txtBARCODE.Text.Trim()); //11.BARCODE ParameterList.Add(txtPERIOD_BARCODE.Text.Trim()); //12.PERIOD_BARCODE ParameterList.Add(ddlDATASOURCE.SelectedIndex + 1); //13.DATASOURCE ParameterList.Add(txtMEMO.Text.Trim()); //14.MEMO ParameterList.Add("0"); //15.PRICES ParameterList.Add("0"); //16.COVER_PRICE ParameterList.Add("0"); //17.COST_PRICE ParameterList.Add("0"); //18.CHECK_FLAG ParameterList.Add("0"); //19.VDS_PRICE bResult = BCO.UpdateChainItemInfo(ParameterList, null); break; } Reload_Page("View", "SAVE", strID); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
private bool CheckPara() { string strMSG = string.Empty; if (SLP_StoreChain1.Text.Trim() == "") strMSG += "[通路]為必填欄位,不允許空白<BR>"; if (this.SLP_SKU1.Text.Trim() == "") strMSG += "[商品]為必填欄位,不允許空白<BR>"; if (this.SLP_ItemPeriod1.Text.Trim() == "") strMSG += "[期別]為必填欄位,不允許空白<BR>"; if (txtEAN_CODE.Text.Trim() == "") strMSG += "[EAN條碼]為必填欄位,不允許空白<BR>"; if (this.txtCHAN_CODE.Text.Trim() == "") strMSG += "[通路對照號]為必填欄位,不允許空白<BR>"; if (ViewState["Mode"].ToString() == "Insert" && strMSG == "") { MaintainChainItemInfo BCO = new MaintainChainItemInfo(ConntionDB); ParameterList.Clear(); ParameterList.Add(SLP_StoreChain1.Text); ParameterList.Add(SLP_SKU1.Text); ParameterList.Add(SLP_ItemPeriod1.Text); DataTable dt = BCO.QueryID(ParameterList); if (dt.Rows.Count > 0) strMSG += "通路、商品、期別資料已存在,請重新輸入"; } if (strMSG.Length > 0) { ErrorMsgLabel.Text = strMSG; return false; } else { return true; } }
//讀取資料 private void LoadData(bool bNoShowMSG) { MaintainChainItemInfo BCO = new MaintainChainItemInfo(ConntionDB); ParameterList.Clear(); ParameterList.Add(ViewState["ID"].ToString().Trim()); DataTable dt = BCO.QueryData(ParameterList); ErrorMsgLabel.Text = ""; if (bNoShowMSG == false) { if (!string.IsNullOrEmpty(Request.QueryString["MSG"])) { if (Request.QueryString["MSG"].ToString() == "SAVE") { ErrorMsgLabel.Text = "儲存完成<BR />"; } } } if (dt.Rows.Count > 0) { SLP_StoreChain1.Text = dt.Rows[0]["CHAN_NO"].ToString(); SLP_SKU1.Text = dt.Rows[0]["ITEM"].ToString(); SLP_ItemPeriod1.Text = dt.Rows[0]["PERIOD"].ToString(); txtEAN_CODE.Text = dt.Rows[0]["EAN_CODE"].ToString(); txtBARCODE.Text = dt.Rows[0]["BARCODE"].ToString(); txtPERIOD_BARCODE.Text = dt.Rows[0]["PERIOD_BARCODE"].ToString(); txtCHAN_CODE.Text = dt.Rows[0]["CHAN_CODE"].ToString(); ddlDATASOURCE.SelectedIndex = int.Parse(dt.Rows[0]["DATASOURCE"].ToString()) - 1; txtMEMO.Text = dt.Rows[0]["MEMO"].ToString(); hdfID.Value = dt.Rows[0]["ID"].ToString(); hdfUPDATEDATE.Value = dt.Rows[0]["UPDATEDATE"].ToString(); hdfUPDATEUID.Value = dt.Rows[0]["UPDATEUID"].ToString(); } else { btnDel.Visible = false; btnEdit.Visible = false; ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕繼續查詢"; } }
protected void ButtonQuery_Click(object sender, EventArgs e) { if (CheckPara() == true) { string strPar1 = string.Empty; string strPar2 = string.Empty; string strOutPar1 = string.Empty; string strOutPar2 = string.Empty; MaintainChainItemInfo BCO = new MaintainChainItemInfo(ConntionDB); ParameterList.Clear(); ParameterList.Add(SLP_StoreChain1.Text); strPar1 = SLP_RootNo1.Text.Trim(); strPar2 = SLP_RootNo2.Text.Trim(); ParaSwitch(strPar1, strPar2, out strOutPar1, out strOutPar2); ParameterList.Add(strOutPar1); ParameterList.Add(strOutPar2); strPar1 = SLP_PMA1.Text.Trim(); strPar2 = SLP_PMA2.Text.Trim(); ParaSwitch(strPar1, strPar2, out strOutPar1, out strOutPar2); ParameterList.Add(strOutPar1); ParameterList.Add(strOutPar2); strPar1 = SLP_Category1.Text.Trim(); strPar2 = SLP_Category2.Text.Trim(); ParaSwitch(strPar1, strPar2, out strOutPar1, out strOutPar2); ParameterList.Add(strOutPar1); ParameterList.Add(strOutPar2); strPar1 = SLP_SortOut1.Text.Trim(); strPar2 = SLP_SortOut2.Text.Trim(); ParaSwitch(strPar1, strPar2, out strOutPar1, out strOutPar2); ParameterList.Add(strOutPar1); ParameterList.Add(strOutPar2); strPar1 = SLP_SKU1.Text.Trim(); strPar2 = SLP_SKU2.Text.Trim(); ParaSwitch(strPar1, strPar2, out strOutPar1, out strOutPar2); ParameterList.Add(strOutPar1); ParameterList.Add(strOutPar2); ParameterList.Add(TextBoxRowCountLimit.Text.Trim()); DataTable dt = BCO.QueryByFind(ParameterList); ViewState[PageTimeStamp.Value] = dt; ErrorMsgLabel.Text = ""; if (dt.Rows.Count > 0) { GridView1.PageSize = (TextBoxPagesize.Text == "") ? 20 : (int.Parse(TextBoxPagesize.Text) < 0) ? 20 : int.Parse(TextBoxPagesize.Text); BindData(); } else { ErrorMsgLabel.Text = "查無資料"; GridView1.DataSource = null; GridView1.DataBind(); } } }