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();
}
}
}
