/// <summary>
/// 繫結資料
/// </summary>
private void BindingData()
{
#region
try
{
if (dtDisTmpRecOld != null && dtDisTmpRecOld.Rows.Count > 0)
{
#region
SLP_PARAM1.Text = dtDisTmpRecOld.Rows[0]["DIS_TYPE"].ToString().Trim();
s_DIS_TYPE_Original = dtDisTmpRecOld.Rows[0]["DIS_TYPE"].ToString().Trim();
#endregion
}
if (dtDisItemOld != null && dtDisItemOld.Rows.Count > 0)
{
#region
txt1_PMA.Text = dtDisItemOld.Rows[0]["PMA"].ToString().Trim();
txt2_DisStoQty.Text = dtDisItemOld.Rows[0]["DIS_STO_QTY"].ToString().Trim() == "" ? "0" : dtDisItemOld.Rows[0]["DIS_STO_QTY"].ToString().Trim();
txt3_DisIsuQty.Text = dtDisItemOld.Rows[0]["DIS_ISU_QTY"].ToString().Trim() == "" ? "0" : dtDisItemOld.Rows[0]["DIS_ISU_QTY"].ToString().Trim();
txt4_DisMdcQty.Text = dtDisItemOld.Rows[0]["DIS_MDC_QTY"].ToString().Trim() == "" ? "0" : dtDisItemOld.Rows[0]["DIS_MDC_QTY"].ToString().Trim();
CRMModel.QueryCRMCommon BCO = new CRMModel.QueryCRMCommon(ConnectionDB);
ArrayList ParameterList1 = new ArrayList();//20091106
ParameterList1.Clear();
ParameterList1.Add(s_ITEM);
ParameterList1.Add(s_PERIOD);
ParameterList1.Add(0);
ParameterList1.Add(Session["UID"].ToString());
DataTable dt = BCO.QUERY_ITEM_PERIODSTOCK(ParameterList1);
if (dt != null && dt.Rows.Count > 0)
{
txt5_ReserveQty.Text = dt.Rows[0]["RESERVE_QTY"].ToString().Trim() == "" ? "0" : dtDisItemOld.Rows[0]["RESERVE_QTY"].ToString().Trim();
}
else
{
txt5_ReserveQty.Text = "0";
}
txt6_DisQty.Text = dtDisItemOld.Rows[0]["DIS_QTY"].ToString().Trim() == "" ? "0" : dtDisItemOld.Rows[0]["DIS_QTY"].ToString().Trim();
txt7_AcceptQty.Text = dtDisItemOld.Rows[0]["ACCEPT_QTY"].ToString().Trim() == "" ? "0" : dtDisItemOld.Rows[0]["ACCEPT_QTY"].ToString().Trim();
if (dtDisItemOld.Rows[0]["INCLUDE_NON_EFF"].ToString().Trim() == "1")
GetOrSetIncludeNonEff = 1;
else
GetOrSetIncludeNonEff = 0;
if (dtDisItemOld.Rows[0]["CHAN_TYPE"].ToString().Trim() == "1")
{
GetOrSetDisChanType = 1;
btn_ChanSetting_Dis.Enabled = true;
hiddenCurrentChan.Value = "1";
}
else
{
GetOrSetDisChanType = 0;
btn_ChanSetting_Dis.Enabled = false;
hiddenCurrentChan.Value = "0";
}
txt_Remark.Text = dtDisItemOld.Rows[0]["MEMO"].ToString().Trim();
s_ID_DisItem = dtDisItemOld.Rows[0]["ID"].ToString().Trim();
s_UPDATEDATE = dtDisItemOld.Rows[0]["UPDATEDATE"].ToString().Trim();
s_UPDATEUID = dtDisItemOld.Rows[0]["UPDATEUID"].ToString().Trim();
#endregion
}
if (dtDisItemReferOld != null && dtDisItemReferOld.Rows.Count > 0)
{
#region
gv_ItemRefer.DataSource = dtDisItemReferOld;
gv_ItemRefer.DataBind();
#endregion
}
if (dtDisChanOld != null && dtDisChanOld.Rows.Count > 0)
{
#region
gv_Chan.DataSource = dtDisChanOld;
gv_Chan.DataBind();
hiddenChanReferCounts.Value = dtDisChanOld.Rows.Count.ToString();
#endregion
}
hiddenOPValueStatus3.Value = "0";
hiddenOPValueStatus4.Value = "0";
hiddenOPValueStatus5.Value = "0";
hiddenOPValueStatus6.Value = "0";
hiddenOPValueStatus7.Value = "0";
hiddenOPValueStatus8.Value = "0";
if (dtDisAssistMainOld != null && dtDisAssistMainOld.Rows.Count > 0)
{
#region
for (Int32 i = 0; i <= dtDisAssistMainOld.Rows.Count - 1; i++)
{
if (!(dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "09" || dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "10"))
{
#region 通路
if (dtDisAssistMainOld.Rows[i]["CHAN_NO"].ToString().Trim() == "0")
{
rbtn_ChanAll2.Checked = true;
rbtn_ChanSingle2.Checked = false;
SLP_StoreChain1.Text = "";
SLP_StoreChain1.ReadOnly = true;
SLP_StoreChain1.IsRequired = false;
}
else
{
rbtn_ChanAll2.Checked = false;
rbtn_ChanSingle2.Checked = true;
SLP_StoreChain1.Text = dtDisAssistMainOld.Rows[i]["CHAN_NO"].ToString().Trim();
SLP_StoreChain1.ReadOnly = false;
SLP_StoreChain1.IsRequired = true;
}
#endregion
#region 01
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "01")
{
chk11.Checked = true;
}
#endregion
#region 02
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "02")
{
chk21.Checked = true;
}
#endregion
#region 03
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "03")
{
chk31.Checked = true;
if (dtDisAssistMainOld.Rows[i]["OPERATOR1"].ToString().Trim() == "1")
{
rbtn311.Checked = true;
rbtn312.Checked = false;
}
else
{
rbtn311.Checked = false;
rbtn312.Checked = true;
}
SLP_SLPNumber1.Text = dtDisAssistMainOld.Rows[i]["OP_VALUE1"].ToString().Trim();
if (dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "0")
{
OP_VALUE_3W.Checked = true;
OP_VALUE_3X.Text = dtDisAssistMainOld.Rows[i]["CHANGE_RATE"].ToString().Trim();
OP_VALUE_3Y.Checked = false;
OP_VALUE_3Z.Enabled = false;
}
else
{
OP_VALUE_3W.Checked = false;
OP_VALUE_3X.Text = "";
OP_VALUE_3Y.Checked = true;
OP_VALUE_3Z.Enabled = true;
}
hiddenOPValueStatus3.Value = dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim();
}
#endregion
#region 04
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "04")
{
chk41.Checked = true;
if (dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "0")
{
OP_VALUE_4W.Checked = true;
OP_VALUE_4X.Text = dtDisAssistMainOld.Rows[i]["CHANGE_RATE"].ToString().Trim();
OP_VALUE_4Y.Checked = false;
OP_VALUE_4Z.Enabled = false;
}
else
{
OP_VALUE_4W.Checked = false;
OP_VALUE_4X.Text = "";
OP_VALUE_4Y.Checked = true;
OP_VALUE_4Z.Enabled = true;
}
hiddenOPValueStatus4.Value = dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim();
}
#endregion
#region 05
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "05")
{
chk51.Checked = true;
if (dtDisAssistMainOld.Rows[i]["OPERATOR1"].ToString().Trim() == "1")
{
rbtn511.Checked = true;
rbtn512.Checked = false;
}
else
{
rbtn511.Checked = false;
rbtn512.Checked = true;
}
if (dtDisAssistMainOld.Rows[i]["OPERATOR2"].ToString().Trim() == "1")
{
rbtn521.Checked = true;
rbtn522.Checked = false;
}
else
{
rbtn521.Checked = false;
rbtn522.Checked = true;
}
SLP_SLPNumber2.Text = dtDisAssistMainOld.Rows[i]["OP_VALUE2"].ToString().Trim();
if (dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "0")
{
OP_VALUE_5W.Checked = true;
OP_VALUE_5X.Text = dtDisAssistMainOld.Rows[i]["CHANGE_RATE"].ToString().Trim();
OP_VALUE_5Y.Checked = false;
OP_VALUE_5Z.Enabled = false;
}
else
{
OP_VALUE_5W.Checked = false;
OP_VALUE_5X.Text = "";
OP_VALUE_5Y.Checked = true;
OP_VALUE_5Z.Enabled = true;
}
hiddenOPValueStatus5.Value = dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim();
}
#endregion
#region 06
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "06")
{
chk61.Checked = true;
SLP_SLPNumber3.Text = dtDisAssistMainOld.Rows[i]["OP_VALUE1"].ToString().Trim();
if (dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "0")
{
OP_VALUE_6W.Checked = true;
OP_VALUE_6X.Text = dtDisAssistMainOld.Rows[i]["CHANGE_RATE"].ToString().Trim();
OP_VALUE_6Y.Checked = false;
OP_VALUE_6Z.Enabled = false;
}
else
{
OP_VALUE_6W.Checked = false;
OP_VALUE_6X.Text = "";
OP_VALUE_6Y.Checked = true;
OP_VALUE_6Z.Enabled = true;
}
hiddenOPValueStatus6.Value = dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim();
}
#endregion
#region 07
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "07")
{
chk71.Checked = true;
SLP_SLPNumber4.Text = dtDisAssistMainOld.Rows[i]["OP_VALUE1"].ToString().Trim();
if (dtDisAssistMainOld.Rows[i]["OPERATOR2"].ToString().Trim() == "1")
{
rbtn721.Checked = true;
rbtn722.Checked = false;
}
else
{
rbtn721.Checked = false;
rbtn722.Checked = true;
}
SLP_SLPNumber5.Text = dtDisAssistMainOld.Rows[i]["OP_VALUE2"].ToString().Trim();
if (dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "0")
{
OP_VALUE_7W.Checked = true;
OP_VALUE_7X.Text = dtDisAssistMainOld.Rows[i]["CHANGE_RATE"].ToString().Trim();
OP_VALUE_7Y.Checked = false;
OP_VALUE_7Z.Enabled = false;
}
else
{
OP_VALUE_7W.Checked = false;
OP_VALUE_7X.Text = "";
OP_VALUE_7Y.Checked = true;
OP_VALUE_7Z.Enabled = true;
}
hiddenOPValueStatus7.Value = dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim();
}
#endregion
#region 08
if (dtDisAssistMainOld.Rows[i]["ASSIST_CODE"].ToString().Trim() == "08")
{
chk81.Checked = true;
if (dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "0")
{
OP_VALUE_8W.Checked = true;
OP_VALUE_8X.Text = dtDisAssistMainOld.Rows[i]["CHANGE_RATE"].ToString().Trim();
OP_VALUE_8Y.Checked = false;
OP_VALUE_8Z.Enabled = false;
}
else
{
OP_VALUE_8W.Checked = false;
OP_VALUE_8X.Text = "";
OP_VALUE_8Y.Checked = true;
OP_VALUE_8Z.Enabled = true;
}
hiddenOPValueStatus8.Value = dtDisAssistMainOld.Rows[i]["CHANGE_TYPE"].ToString().Trim();
}
#endregion
}
}
#endregion
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private bool GetItemPeriodStock(string strItem, string strPeriod)
{
#region
bool bResult = false;
try
{
CRMModel.QueryCRMCommon BCO = new CRMModel.QueryCRMCommon(ConnectionDB);
DataTable dtTemp = new DataTable();
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
dtTemp.Clear();
ParameterList.Add(strItem);
ParameterList.Add(strPeriod);
ParameterList.Add("2");
ParameterList.Add(Session["UID"].ToString());
dtTemp = BCO.QUERY_ITEM_PERIODSTOCK(ParameterList);
i_ONHD_QTY = 0;
i_RESERVE_QTY = 0;
i_DIS_ENABLE = 0;
if (dtTemp != null && dtTemp.Rows.Count != 0)
{
//2009-09-18 cyhsu add 因為庫存儲區可能有兩個以上所以要用彙總
foreach (DataRow dr in dtTemp.Rows)
{
i_ONHD_QTY += Int32.Parse(dr["ONHD_QTY"].ToString());//庫存數
i_RESERVE_QTY += Int32.Parse(dr["RESERVE_QTY"].ToString());//待出庫數
}
i_DIS_ENABLE = i_ONHD_QTY - i_RESERVE_QTY;//可出庫數
}
if (i_DIS_ENABLE < 1)
bResult = false;
else
bResult = true;
}
catch (Exception ex)
{
throw ex;
}
return bResult;
#endregion
}
private void GetItemPeriodStock(string strItem, string strPeriod)
{
#region
try
{
CRMModel.QueryCRMCommon BCO = new CRMModel.QueryCRMCommon(ConnectionDB);
DataTable dtTemp = new DataTable();
dtTemp.Clear();
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strItem);
ParameterList.Add(strPeriod);
ParameterList.Add("0");//2009-10-08 cyhsu :0進貨1退貨2庫存
ParameterList.Add(Session["UID"].ToString());
dtTemp = BCO.QUERY_ITEM_PERIODSTOCK(ParameterList);
i_ONHD_QTY = 0;
i_ACCEPT_QTY = 0;
i_RESERVE_QTY = 0;
i_DIS_QTY = 0;
i_DIS_MDC_QTY = 0;
i_DIS_ISU_QTY = 0;
if (dtTemp != null && dtTemp.Rows.Count != 0)
{
i_ONHD_QTY = Int32.Parse(dtTemp.Rows[0]["ONHD_QTY"].ToString());//庫存數
i_ACCEPT_QTY = Int32.Parse(dtTemp.Rows[0]["ONHD_QTY"].ToString());//到貨數
i_RESERVE_QTY = Int32.Parse(dtTemp.Rows[0]["RESERVE_QTY"].ToString());//保留數
i_DIS_QTY = 0;// Int32.Parse(dtTemp.Rows[0]["DIS_QTY"].ToString());//實配數
i_DIS_MDC_QTY = i_ONHD_QTY - i_DIS_QTY - i_RESERVE_QTY;//預留數
}
ALOModel.QueryALOCommon BCO2 = new ALOModel.QueryALOCommon(ConnectionDB);
ArrayList ParameterList1 = new ArrayList();
ParameterList1.Clear();
ParameterList1.Add(strItem);
ParameterList1.Add(strPeriod);
ParameterList1.Add(s_ROOT_NO);
i_DIS_ISU_QTY = BCO2.QueryPurchaseQty(ParameterList1);//採購數
}
catch (Exception ex)
{
throw ex;
}
#endregion
}