private void GiftBind()
{
try
{
ErrorMsgLabel.Text = "";
VGIModel.MaintainAccept dbo = new VGIModel.MaintainAccept(ConntionDB);
DataTable dtTemp = dbo.QueryGift(SLP_SKU.Text, txtPeriod.Text, txtPurNo.Text);
DataTable dtResult;
//新增模式時,如果採購數量為零時不顯示
if (PageMode == "1" || PageMode == "")
{
dtResult = dtTemp.Clone();
DataRow[] Dr_Array = dtTemp.Select("PURCHASE_QTY <> 0 ");
foreach (DataRow DrOld in Dr_Array)
{
dtResult.ImportRow(DrOld);
}
}
else
{
dtResult = dtTemp;
}
dtResult.DefaultView.Sort = "VIRTUAL_CODE asc";
dlGift.DataSource = dtResult.DefaultView;
dlGift.DataBind();
string strItem = SLP_SKU.Text;
string strPeriod = txtPeriod.Text;
DataTable dtGift;
if (Session["GiftOLDData_" + PageTimeStamp.Value] != null)
{
dtGift = (DataTable)Session["GiftOLDData_" + PageTimeStamp.Value];
for (int i = 0; i < dtGift.Rows.Count; i++)
{
for (int j = 0; j < dlGift.Items.Count; j++)
{
if (dtGift.Rows[i]["VIRTUAL_CODE"].ToString() == ((Label)dlGift.Items[j].FindControl("lblVirtualCode")).Text && dtGift.Rows[i]["ITEM"].ToString() == strItem && dtGift.Rows[i]["PERIOD"].ToString() == strPeriod)
{
((PIC.VDS2G.WebUI.SLP.SLPNumber)dlGift.Items[j].FindControl("SLP_GiftAccQty")).Text = dtGift.Rows[i]["Accept_Qty"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftPack")).Text = dtGift.Rows[i]["Package_Unit"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftSWe")).Text = dtGift.Rows[i]["S_Weight"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftSL")).Text = dtGift.Rows[i]["S_Length"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftSWi")).Text = dtGift.Rows[i]["S_Width"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftSH")).Text = dtGift.Rows[i]["S_Height"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftPWe")).Text = dtGift.Rows[i]["P_Weight"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftPL")).Text = dtGift.Rows[i]["P_Length"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftPWi")).Text = dtGift.Rows[i]["P_Width"].ToString();
((TextBox)dlGift.Items[j].FindControl("txt_GiftPH")).Text = dtGift.Rows[i]["P_Height"].ToString();
((HiddenField)dlGift.Items[j].FindControl("GiftAccQty_Old")).Value = dtGift.Rows[i]["Old_Qty"].ToString();
}
else
{
((TextBox)dlGift.Items[j].FindControl("txt_GiftPack")).Text = SLP_PackNum.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftSWe")).Text = SLP_SWeight.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftSL")).Text = SLP_SLength.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftSWi")).Text = SLP_SWidth.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftSH")).Text = SLP_SHeigh.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftPWe")).Text = SLP_PWeight.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftPL")).Text = SLP_PLength.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftPWi")).Text = SLP_PWidth.Text;
((TextBox)dlGift.Items[j].FindControl("txt_GiftPH")).Text = SLP_PHeigh.Text;
}
}
}
}
else
{
for (int x = 0; x < dlGift.Items.Count; x++)
{
string strGiftItem = strItem;
string strGiftPeriod = strPeriod;
string strGiftVirCode = ((Label)dlGift.Items[x].FindControl("lblVirtualCode")).Text;
ParameterList.Clear();
ParameterList.Add(strGiftItem);
ParameterList.Add(strGiftPeriod);
ParameterList.Add(strGiftVirCode);
ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd"));
DataTable Dt_Temp = dbo.GetGiftDetail(ParameterList);
if (Dt_Temp.Rows.Count > 0)
{
((TextBox)dlGift.Items[x].FindControl("txt_GiftPack")).Text = Dt_Temp.Rows[0]["package_unit"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftSWe")).Text = Dt_Temp.Rows[0]["s_weight"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftSL")).Text = Dt_Temp.Rows[0]["s_length"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftSWi")).Text = Dt_Temp.Rows[0]["s_width"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftSH")).Text = Dt_Temp.Rows[0]["s_height"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftPWe")).Text = Dt_Temp.Rows[0]["p_weight"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftPL")).Text = Dt_Temp.Rows[0]["p_length"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftPWi")).Text = Dt_Temp.Rows[0]["p_Width"].ToString();
((TextBox)dlGift.Items[x].FindControl("txt_GiftPH")).Text = Dt_Temp.Rows[0]["p_height"].ToString();
}
else
{
((TextBox)dlGift.Items[x].FindControl("txt_GiftPack")).Text = SLP_PackNum.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftSWe")).Text = SLP_SWeight.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftSL")).Text = SLP_SLength.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftSWi")).Text = SLP_SWidth.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftSH")).Text = SLP_SHeigh.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftPWe")).Text = SLP_PWeight.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftPL")).Text = SLP_PLength.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftPWi")).Text = SLP_PWidth.Text;
((TextBox)dlGift.Items[x].FindControl("txt_GiftPH")).Text = SLP_PHeigh.Text;
}
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
