protected void btn_ViewGift_Click(object sender, EventArgs e)
{
try
{
ErrorMsgLabel.Text = "";
BCO.MaintainGiftProfile bco = new BCO.MaintainGiftProfile(ConnectionDB);
Button btn = sender as Button;
rowid_mst = Convert.ToInt16(btn.Attributes["rowid_mst"].ToString());
string strItem = ((HiddenField)GridView1.Rows[rowid_mst].FindControl("HiddenField2")).Value.ToString();
string strPeriod = ((HiddenField)GridView1.Rows[rowid_mst].FindControl("HiddenField3")).Value.ToString();
string strVirtualCode = GridView1.Rows[rowid_mst].Cells[3].Text.ToString();
string strVirtualName = ((HiddenField)GridView1.Rows[rowid_mst].FindControl("HiddenField4")).Value.ToString();
ParameterList.Clear();
ParameterList.Add(strItem);
ParameterList.Add(strPeriod);
ParameterList.Add(strVirtualCode);
//取得贈品屬性資料
DataTable dt = bco.QueryGiftProfileByPK(ParameterList);
if (dt.Rows.Count > 0)
{
PanelGiftDetail.Visible = true;
txtVirtualCodeDetail.Text = strVirtualCode;
txtVirtualNameDetail.Text = strVirtualName;
DataRow dr = dt.Rows[0];
this.txtPACKAGE_UNIT.Text = dr["PACKAGE_UNIT"].ToString();
this.txtS_WEIGHT.Text = dr["S_WEIGHT"].ToString();
this.txtS_LENGTH.Text = dr["S_LENGTH"].ToString();
this.txtS_WIDTH.Text = dr["S_WIDTH"].ToString();
this.txtS_HEIGHT.Text = dr["S_HEIGHT"].ToString();
this.txtP_WEIGHT.Text = dr["P_WEIGHT"].ToString();
this.txtP_LENGTH.Text = dr["P_LENGTH"].ToString();
this.txtP_WIDTH.Text = dr["P_WIDTH"].ToString();
this.txtP_HEIGHT.Text = dr["P_HEIGHT"].ToString();
this.txtPURCHASE_DATE.Text = (dr["PURCHASE_DATE"].ToString() == "") ? "" : ((DateTime)dr["PURCHASE_DATE"]).ToString("yyyy/MM/dd");
this.txtPURCHASE_NO.Text = dr["PURCHASE_NO"].ToString();
this.txtPURCHASE_QTY.Text = dr["PURCHASE_QTY"].ToString();
this.txtACCEPT_DATE.Text = (dr["ACCEPT_DATE"].ToString() == "") ? "" : ((DateTime)dr["ACCEPT_DATE"]).ToString("yyyy/MM/dd");
this.txtACCEPT_QTY.Text = dr["ACCEPT_QTY"].ToString();
this.txtONWAY_QTY.Text = dr["ONWAY_QTY"].ToString();
this.txtDIS_DATE.Text = (dr["DIS_DATE"].ToString() == "") ? "" : ((DateTime)dr["DIS_DATE"]).ToString("yyyy/MM/dd");
this.txtDIS_QTY.Text = dr["DIS_QTY"].ToString();
this.txtOUT_ST_ACCEPT_DATE.Text = (dr["OUT_ST_ACCEPT_DATE"].ToString() == "") ? "" : ((DateTime)dr["OUT_ST_ACCEPT_DATE"]).ToString("yyyy/MM/dd");
this.txtST_ACCEPT_DATE.Text = (dr["ST_ACCEPT_DATE"].ToString() == "") ? "" : ((DateTime)dr["ST_ACCEPT_DATE"]).ToString("yyyy/MM/dd");
this.txtPICK_DATE.Text = (dr["PICK_DATE"].ToString() == "") ? "" : ((DateTime)dr["PICK_DATE"]).ToString("yyyy/MM/dd");
}
else
{
PanelGiftDetail.Visible = false;
txtVirtualCodeDetail.Text = "";
txtVirtualNameDetail.Text = "";
this.txtPACKAGE_UNIT.Text = "";
this.txtS_WEIGHT.Text = "";
this.txtS_LENGTH.Text = "";
this.txtS_WIDTH.Text = "";
this.txtS_HEIGHT.Text = "";
this.txtP_WEIGHT.Text = "";
this.txtP_LENGTH.Text = "";
this.txtP_WIDTH.Text = "";
this.txtP_HEIGHT.Text = "";
this.txtPURCHASE_DATE.Text = "";
this.txtPURCHASE_NO.Text = "";
this.txtPURCHASE_QTY.Text = "";
this.txtACCEPT_DATE.Text = "";
this.txtACCEPT_QTY.Text = "";
this.txtONWAY_QTY.Text = "";
this.txtDIS_DATE.Text = "";
this.txtDIS_QTY.Text = "";
this.txtOUT_ST_ACCEPT_DATE.Text = "";
this.txtST_ACCEPT_DATE.Text = "";
this.txtPICK_DATE.Text = "";
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
protected void Btn_GiftProfile_Click(object sender, EventArgs e)
{
#region 檢視贈品屬性
if (PanelGiftProfile.Visible == true)
{
PanelGiftProfile.Visible = false;
}
else
{
PanelGiftProfile.Visible = true;
BCO.MaintainGiftProfile bco = new BCO.MaintainGiftProfile(ConnectionDB);
string v_Item = this.SLP_SKU1.Text;
string v_Period = this.SLP_ItemPeriod1.Text;
string v_VirtualCode = this.txtVirtualCode.Text;
ArrayList returnList = new ArrayList();
returnList.Add(GetValueSetParameter(v_Item, "string"));
returnList.Add(GetValueSetParameter(v_Period, "string"));
returnList.Add(GetValueSetParameter(v_VirtualCode, "string"));
//取得贈品屬性資料
DataTable dt = bco.QueryGiftProfileByPK(returnList);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
this.txtPACKAGE_UNIT.Text = dr["PACKAGE_UNIT"].ToString();
this.txtS_WEIGHT.Text = dr["S_WEIGHT"].ToString();
this.txtS_LENGTH.Text = dr["S_LENGTH"].ToString();
this.txtS_WIDTH.Text = dr["S_WIDTH"].ToString();
this.txtS_HEIGHT.Text = dr["S_HEIGHT"].ToString();
this.txtP_WEIGHT.Text = dr["P_WEIGHT"].ToString();
this.txtP_LENGTH.Text = dr["P_LENGTH"].ToString();
this.txtP_WIDTH.Text = dr["P_WIDTH"].ToString();
this.txtP_HEIGHT.Text = dr["P_HEIGHT"].ToString();
this.txtPURCHASE_DATE.Text = (dr["PURCHASE_DATE"].ToString() == "") ? "" : ((DateTime)dr["PURCHASE_DATE"]).ToString("yyyy/MM/dd");
this.txtPURCHASE_NO.Text = dr["PURCHASE_NO"].ToString();
this.txtPURCHASE_QTY.Text = dr["PURCHASE_QTY"].ToString();
this.txtACCEPT_DATE.Text = (dr["ACCEPT_DATE"].ToString() == "") ? "" : ((DateTime)dr["ACCEPT_DATE"]).ToString("yyyy/MM/dd");
this.txtACCEPT_QTY.Text = dr["ACCEPT_QTY"].ToString();
this.txtONWAY_QTY.Text = dr["ONWAY_QTY"].ToString();
this.txtDIS_DATE.Text = (dr["DIS_DATE"].ToString() == "") ? "" : ((DateTime)dr["DIS_DATE"]).ToString("yyyy/MM/dd");
this.txtDIS_QTY.Text = dr["DIS_QTY"].ToString();
this.txtOUT_ST_ACCEPT_DATE.Text = (dr["OUT_ST_ACCEPT_DATE"].ToString() == "") ? "" : ((DateTime)dr["OUT_ST_ACCEPT_DATE"]).ToString("yyyy/MM/dd");
this.txtST_ACCEPT_DATE.Text = (dr["ST_ACCEPT_DATE"].ToString() == "") ? "" : ((DateTime)dr["ST_ACCEPT_DATE"]).ToString("yyyy/MM/dd");
this.txtPICK_DATE.Text = (dr["PICK_DATE"].ToString() == "") ? "" : ((DateTime)dr["PICK_DATE"]).ToString("yyyy/MM/dd");
}
else
{
this.txtPACKAGE_UNIT.Text = "";
this.txtS_WEIGHT.Text = "";
this.txtS_LENGTH.Text = "";
this.txtS_WIDTH.Text = "";
this.txtS_HEIGHT.Text = "";
this.txtP_WEIGHT.Text = "";
this.txtP_LENGTH.Text = "";
this.txtP_WIDTH.Text = "";
this.txtP_HEIGHT.Text = "";
this.txtPURCHASE_DATE.Text = "";
this.txtPURCHASE_NO.Text = "";
this.txtPURCHASE_QTY.Text = "";
this.txtACCEPT_DATE.Text = "";
this.txtACCEPT_QTY.Text = "";
this.txtONWAY_QTY.Text = "";
this.txtDIS_DATE.Text = "";
this.txtDIS_QTY.Text = "";
this.txtOUT_ST_ACCEPT_DATE.Text = "";
this.txtST_ACCEPT_DATE.Text = "";
this.txtPICK_DATE.Text = "";
}
}
SetPageStatus();
#endregion
}
