/// <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 }