/// <summary> /// 新增配本紀錄 /// </summary> private void AddALODisRecord() { try { ArrayList MainTableList = new ArrayList(); ALOModel.MaintainDisRecord MDR = new ALOModel.MaintainDisRecord(ConnectionDB); //配本序號 string DisNO = ""; #region 指定變數 ArrayList ParameterList = new ArrayList(); //20091105 added ParameterList.Clear(); //配本序號 ParameterList.Add(DISNOTxt.Text); //建立配本主檔DataTable if (FormStatusHidden.Value == "Add") { ParameterList.Add(AddDisMainDt()); } else { //舊資料 #region 使用XML轉回DataSet DataSet DisMainDs = new DataSet(); System.IO.StringReader DisMainSr = new System.IO.StringReader(OLD_DisMainXML.InnerHtml); DisMainDs.ReadXml(DisMainSr); DataTable OLDDisMainDt = null; if (DisMainDs.Tables.Count > 0) { OLDDisMainDt = DisMainDs.Tables[0]; #region 將DateTime 1900/01/01 轉回 null for (int i = 0; i < OLDDisMainDt.Rows.Count; i++) { for (int j = 0; j < OLDDisMainDt.Columns.Count; j++) { if (OLDDisMainDt.Columns[j].DataType == typeof(System.DateTime)) { if (DateTime.Parse(OLDDisMainDt.Rows[i][j].ToString()) == DateTime.Parse("1900/01/01")) { OLDDisMainDt.Rows[i][j] = Convert.DBNull; } } } } #endregion } #endregion MainTableList.Add(OLDDisMainDt); //新資料 #region 新資料 DataTable NewDisMainDt = OLDDisMainDt.Clone(); DataRow MainDr = NewDisMainDt.NewRow(); MainDr["DIS_NO"] = DISNOTxt.Text; MainDr["DIS_DATE"] = SLP_DISDate.Text; MainDr["ST_ACCEPT_DATE"] = SLP_STAcceptDate.Text; MainDr["APPROVE_DATE"] = SLP_ApproveDate.Text; MainDr["UPDATEDATE"] = DateTime.Now; MainDr["UPDATEUID"] = Session["UID"].ToString(); NewDisMainDt.Rows.Add(MainDr); #endregion MainTableList.Add(NewDisMainDt); ParameterList.Add(MainTableList); } //建立配本商品DataTable ParameterList.Add(AddDISItemDt()); //建立配本通路DataTable ParameterList.Add(AddDisChanDt()); //建立配本參照商品DataTable ParameterList.Add(AddDisItemReferDt()); //目前品號 ParameterList.Add(SLP_SKU1.Text); //目前期別 ParameterList.Add(SLP_ItemPeriod1.Text); //若配本方式109 處裡 ParameterList.Add(GetdtDisTypeTmp109()); //配本方式 '105','110' 處理 ParameterList.Add(GetDisTypeTmpDt()); //使用者 ParameterList.Add(Session["UID"].ToString()); #endregion //新增配本紀錄 MDR.CreateDisRecordFor111(ParameterList, ref DisNO, null ); //配本序號 DISNOTxt.Text = DisNO; } catch (Exception ex) { throw ex; } }