/// <summary> /// 查詢配本通路 /// </summary> /// <param name="dis_no">配本序號</param> /// <param name="item">配本商品品號</param> /// <param name="period">配本商品期別</param> private void getDis_Chan(string dis_no, string item, string period) { try { ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(dis_no); //配本序號 ParameterList.Add(item); //配本商品品號 ParameterList.Add(period); //配本商品期別 BCO.MaintainDisChan bco = new BCO.MaintainDisChan(ConnectionDB); DataTable dt = new DataTable(); dt = bco.QueryDisChanFor111(ParameterList); SLP_CHAN_NO1.Text = ""; chkIS_LOCK.Checked = false; btnConfirm4.Enabled = false; btnRelease4.Enabled = false; hidChan_No.Value = ""; hidNum_Chan.Value = ""; lblChan_No_Count.Text = dt.Rows.Count.ToString(); lblChan_No.Text = ""; if (dt.Rows.Count == 0) { btnPrev3.Enabled = false; btnNext3.Enabled = false; btnQuery3.Enabled = false; btnQuery4.Enabled = false; } else { if (SLP_APPROVE_DATE.Text == "") { btnPrev3.Enabled = true; btnNext3.Enabled = true; btnQuery3.Enabled = true; btnQuery4.Enabled = true; } } string SessionIDName = "ALO121_dt3" + PageTimeStamp.Value; Session[SessionIDName] = dt; } catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; } }
/// <summary> /// 取得原始資料庫資料 /// </summary> private void GetAllOriginalDatatables() { #region try { #region ArrayList ParameterList1 = new ArrayList();//20091106 ParameterList1.Clear(); ParameterList1.Add(s_DISNO); ParameterList1.Add(s_ITEM); ParameterList1.Add(s_PERIOD); ParameterList1.Add(null);//CHAN_NO #region DIS_MAIN ALOModel.MaintainDisMain BCO1 = new ALOModel.MaintainDisMain(ConnectionDB); dtDisMainOld = BCO1.QueryByDisNo(ParameterList1); dtDisMain = dtDisMainOld.Copy(); DataColumn[] PrimaryKeys11 = new DataColumn[1]; PrimaryKeys11[0] = dtDisMainOld.Columns["DIS_NO"]; dtDisMainOld.PrimaryKey = PrimaryKeys11; DataColumn[] PrimaryKeys12 = new DataColumn[1]; PrimaryKeys12[0] = dtDisMain.Columns["DIS_NO"]; dtDisMain.PrimaryKey = PrimaryKeys12; #endregion #region DIS_ITEM ALOModel.MaintainDisItem BCO2 = new ALOModel.MaintainDisItem(ConnectionDB); dtDisItemOld = BCO2.QueryByDisNo(ParameterList1); dtDisItem = dtDisItemOld.Copy(); DataColumn[] PrimaryKeys21 = new DataColumn[3]; PrimaryKeys21[0] = dtDisItemOld.Columns["DIS_NO"]; PrimaryKeys21[1] = dtDisItemOld.Columns["ITEM"]; PrimaryKeys21[2] = dtDisItemOld.Columns["PERIOD"]; dtDisItemOld.PrimaryKey = PrimaryKeys21; DataColumn[] PrimaryKeys22 = new DataColumn[3]; PrimaryKeys22[0] = dtDisItem.Columns["DIS_NO"]; PrimaryKeys22[1] = dtDisItem.Columns["ITEM"]; PrimaryKeys22[2] = dtDisItem.Columns["PERIOD"]; dtDisItem.PrimaryKey = PrimaryKeys22; #endregion #region DIS_CHAN ALOModel.MaintainDisChan BCO3 = new ALOModel.MaintainDisChan(ConnectionDB); dtDisChanOld = BCO3.QueryDisChanFor111(ParameterList1); dtDisChan = dtDisChanOld.Copy(); DataColumn[] PrimaryKeys31 = new DataColumn[4]; PrimaryKeys31[0] = dtDisChanOld.Columns["DIS_NO"]; PrimaryKeys31[1] = dtDisChanOld.Columns["ITEM"]; PrimaryKeys31[2] = dtDisChanOld.Columns["PERIOD"]; PrimaryKeys31[3] = dtDisChanOld.Columns["CHAN_NO"]; dtDisChanOld.PrimaryKey = PrimaryKeys31; DataColumn[] PrimaryKeys32 = new DataColumn[4]; PrimaryKeys32[0] = dtDisChan.Columns["DIS_NO"]; PrimaryKeys32[1] = dtDisChan.Columns["ITEM"]; PrimaryKeys32[2] = dtDisChan.Columns["PERIOD"]; PrimaryKeys32[3] = dtDisChan.Columns["CHAN_NO"]; dtDisChan.PrimaryKey = PrimaryKeys32; #endregion #region DIS_CHAN_REFER //ALOModel.MaintainDisChanRefer BCO9 = new ALOModel.MaintainDisChanRefer(ConnectionDB); //dtDisChanReferOld = BCO9.QueryDisChanReferByDisNo(ParameterList1); //dtDisChanRefer = dtDisChanReferOld.Copy(); //DataColumn[] PrimaryKeys91 = new DataColumn[6]; //PrimaryKeys91[0] = dtDisChanReferOld.Columns["DIS_NO"]; //PrimaryKeys91[1] = dtDisChanReferOld.Columns["ITEM"]; //PrimaryKeys91[2] = dtDisChanReferOld.Columns["PERIOD"]; //PrimaryKeys91[3] = dtDisChanReferOld.Columns["CHAN_NO"]; //PrimaryKeys91[4] = dtDisChanReferOld.Columns["RITEM"]; //PrimaryKeys91[5] = dtDisChanReferOld.Columns["RPERIOD"]; //dtDisChanReferOld.PrimaryKey = PrimaryKeys91; //DataColumn[] PrimaryKeys92 = new DataColumn[6]; //PrimaryKeys92[0] = dtDisChanRefer.Columns["DIS_NO"]; //PrimaryKeys92[1] = dtDisChanRefer.Columns["ITEM"]; //PrimaryKeys92[2] = dtDisChanRefer.Columns["PERIOD"]; //PrimaryKeys92[3] = dtDisChanRefer.Columns["CHAN_NO"]; //PrimaryKeys92[4] = dtDisChanRefer.Columns["RITEM"]; //PrimaryKeys92[5] = dtDisChanRefer.Columns["RPERIOD"]; //dtDisChanRefer.PrimaryKey = PrimaryKeys92; #endregion #region DIS_ITEM_REFER ALOModel.MaintainDisItemRefer BCO4 = new ALOModel.MaintainDisItemRefer(ConnectionDB); dtDisItemReferOld = BCO4.QueryDisItemReferFor111(ParameterList1); dtDisItemRefer = dtDisItemReferOld.Copy(); DataColumn[] PrimaryKeys41 = new DataColumn[5]; PrimaryKeys41[0] = dtDisItemReferOld.Columns["DIS_NO"]; PrimaryKeys41[1] = dtDisItemReferOld.Columns["ITEM"]; PrimaryKeys41[2] = dtDisItemReferOld.Columns["PERIOD"]; PrimaryKeys41[3] = dtDisItemReferOld.Columns["RITEM"]; PrimaryKeys41[4] = dtDisItemReferOld.Columns["RPERIOD"]; dtDisItemReferOld.PrimaryKey = PrimaryKeys41; DataColumn[] PrimaryKeys42 = new DataColumn[5]; PrimaryKeys42[0] = dtDisItemRefer.Columns["DIS_NO"]; PrimaryKeys42[1] = dtDisItemRefer.Columns["ITEM"]; PrimaryKeys42[2] = dtDisItemRefer.Columns["PERIOD"]; PrimaryKeys42[3] = dtDisItemRefer.Columns["RITEM"]; PrimaryKeys42[4] = dtDisItemRefer.Columns["RPERIOD"]; dtDisItemRefer.PrimaryKey = PrimaryKeys42; #endregion #region DIS_TYPE_TMP ALOModel.MaintainDisTypeTmp BCO5 = new ALOModel.MaintainDisTypeTmp(ConnectionDB); dtDisTypeTmpOld = BCO5.QueryDisTypeTmp(ParameterList1); dtDisTypeTmp = dtDisTypeTmpOld.Copy(); DataColumn[] PrimaryKeys51 = new DataColumn[4]; PrimaryKeys51[0] = dtDisTypeTmpOld.Columns["DIS_NO"]; PrimaryKeys51[1] = dtDisTypeTmpOld.Columns["ITEM"]; PrimaryKeys51[2] = dtDisTypeTmpOld.Columns["PERIOD"]; PrimaryKeys51[3] = dtDisTypeTmpOld.Columns["DIS_TYPE"]; dtDisTypeTmpOld.PrimaryKey = PrimaryKeys51; DataColumn[] PrimaryKeys52 = new DataColumn[4]; PrimaryKeys52[0] = dtDisTypeTmp.Columns["DIS_NO"]; PrimaryKeys52[1] = dtDisTypeTmp.Columns["ITEM"]; PrimaryKeys52[2] = dtDisTypeTmp.Columns["PERIOD"]; PrimaryKeys52[3] = dtDisTypeTmp.Columns["DIS_TYPE"]; dtDisTypeTmp.PrimaryKey = PrimaryKeys52; #endregion #region DIS_TYPE_109_TMP ALOModel.MaintainDisType109Tmp BCO6 = new ALOModel.MaintainDisType109Tmp(ConnectionDB); dtDisType109TmpOld = BCO6.QueryDisType109Tmp(ParameterList1); dtDisTypeTmp109 = dtDisType109TmpOld.Copy(); DataColumn[] PrimaryKeys61 = new DataColumn[6]; PrimaryKeys61[0] = dtDisType109TmpOld.Columns["DIS_NO"]; PrimaryKeys61[1] = dtDisType109TmpOld.Columns["ITEM"]; PrimaryKeys61[2] = dtDisType109TmpOld.Columns["PERIOD"]; PrimaryKeys61[3] = dtDisType109TmpOld.Columns["RANK_CODE"]; PrimaryKeys61[4] = dtDisType109TmpOld.Columns["RANK_LEVEL"]; PrimaryKeys61[5] = dtDisType109TmpOld.Columns["PATTERN_NO"]; dtDisType109TmpOld.PrimaryKey = PrimaryKeys61; DataColumn[] PrimaryKeys62 = new DataColumn[6]; PrimaryKeys62[0] = dtDisTypeTmp109.Columns["DIS_NO"]; PrimaryKeys62[1] = dtDisTypeTmp109.Columns["ITEM"]; PrimaryKeys62[2] = dtDisTypeTmp109.Columns["PERIOD"]; PrimaryKeys62[3] = dtDisTypeTmp109.Columns["RANK_CODE"]; PrimaryKeys62[4] = dtDisTypeTmp109.Columns["RANK_LEVEL"]; PrimaryKeys62[5] = dtDisTypeTmp109.Columns["PATTERN_NO"]; dtDisTypeTmp109.PrimaryKey = PrimaryKeys62; #endregion #region DIS_ASSIST ALOModel.MaintainDisAssist BCO7 = new ALOModel.MaintainDisAssist(ConnectionDB); dtDisAssistMainOld = BCO7.QueryDisAssistMainWithoutChan(ParameterList1); dtDisAssistMain = dtDisAssistMainOld.Copy(); DataColumn[] PrimaryKeys71 = new DataColumn[4]; PrimaryKeys71[0] = dtDisAssistMainOld.Columns["DIS_NO"]; PrimaryKeys71[1] = dtDisAssistMainOld.Columns["ITEM"]; PrimaryKeys71[2] = dtDisAssistMainOld.Columns["PERIOD"]; PrimaryKeys71[3] = dtDisAssistMainOld.Columns["ASSIST_CODE"]; dtDisAssistMainOld.PrimaryKey = PrimaryKeys71; DataColumn[] PrimaryKeys72 = new DataColumn[4]; PrimaryKeys72[0] = dtDisAssistMain.Columns["DIS_NO"]; PrimaryKeys72[1] = dtDisAssistMain.Columns["ITEM"]; PrimaryKeys72[2] = dtDisAssistMain.Columns["PERIOD"]; PrimaryKeys72[3] = dtDisAssistMain.Columns["ASSIST_CODE"]; dtDisAssistMain.PrimaryKey = PrimaryKeys72; //20090818 added dtDisAssistDetlAll = BCO7.QueryDisAssistDetlWithoutChan(ParameterList1); #endregion #region DIS_REC ALOModel.MaintainDisTmpRec BCO8 = new ALOModel.MaintainDisTmpRec(ConnectionDB); ParameterList1.Clear(); ParameterList1.Add(s_ID_DisRec); dtDisTmpRecOld = BCO8.QueryById(ParameterList1); dtDisTmpRec = dtDisTmpRecOld.Copy(); DataColumn[] PrimaryKeys81 = new DataColumn[2]; PrimaryKeys81[0] = dtDisTmpRecOld.Columns["ID"]; PrimaryKeys81[1] = dtDisTmpRecOld.Columns["CODE"]; dtDisTmpRecOld.PrimaryKey = PrimaryKeys81; DataColumn[] PrimaryKeys82 = new DataColumn[2]; PrimaryKeys82[0] = dtDisTmpRec.Columns["ID"]; PrimaryKeys82[1] = dtDisTmpRec.Columns["CODE"]; dtDisTmpRec.PrimaryKey = PrimaryKeys82; #endregion #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }
private void GetCurrentDisChan() { #region ALOModel.MaintainDisChan BCO = new ALOModel.MaintainDisChan(ConnectionDB); ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(DIS_NO); ParameterList.Add(ITEM); ParameterList.Add(PERIOD); dtForCurrentDisChan = BCO.QueryDisChanFor111(ParameterList); if (dtForCurrentDisChan != null && dtForCurrentDisChan.Rows.Count > 0) { for (Int32 i = 0; i <= gv_Result.Rows.Count - 1; i++) { CheckBox chk_CHAN_NO_Sgl = (CheckBox)gv_Result.Rows[i].FindControl("chk_CHAN_NO_Sgl"); for (Int32 k = 0; k <= dtForCurrentDisChan.Rows.Count - 1; k++) { if (chk_CHAN_NO_Sgl.Text.Trim() == dtForCurrentDisChan.Rows[k]["CHAN_NO"].ToString().Trim()) { chk_CHAN_NO_Sgl.Checked = true; break; } } } } #endregion }
/// <summary> /// 配本通路資料聯繫 /// </summary> private void ALOStoreChainBind() { ALOModel.MaintainDisChan bco = new ALOModel.MaintainDisChan(ConnectionDB); #region 輸入變數 ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(DISNOTxt.Text); ParameterList.Add(SLP_SKU1.Text); ParameterList.Add(SLP_ItemPeriod1.Text); #endregion DataTable Dt = bco.QueryDisChanFor111(ParameterList); #region 將空白的資料做處理 for (int i = 0; i < Dt.Rows.Count; i++) { for (int j = 0; j < Dt.Columns.Count; j++) { if (Dt.Columns[j].DataType == typeof(System.String)) { if (Dt.Rows[i][j].GetType() == typeof(System.DBNull)) { Dt.Rows[i][j] = ""; } } if (Dt.Columns[j].DataType == typeof(System.Decimal)) { if (Dt.Rows[i][j].GetType() == typeof(System.DBNull)) { Dt.Rows[i][j] = 0; } } if (Dt.Columns[j].DataType == typeof(System.DateTime)) { if (Dt.Rows[i][j].GetType() == typeof(System.DBNull)) { Dt.Rows[i][j] = DateTime.Parse("1900/01/01"); } } } } #endregion #region 使用XML放置到前端資料 //舊資料 OLD_XMLStoreChainList.InnerHtml = (Dt.Rows.Count > 0) ? Dt.DataSet.GetXml() : ""; XML_StoreChainList.InnerHtml = (Dt.Rows.Count > 0) ? Dt.DataSet.GetXml() : ""; #endregion GridView_StoreChainList.DataSource = Dt; GridView_StoreChainList.DataBind(); StoreChainListCountHidden.Value = Dt.Rows.Count.ToString(); if (SLP_PARAM1.TextBox_Code.Text == "109") //如果為109紀錄通路 { Call109Process(); } }