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 }