public string CreateData(string strUID, string strDate, DataTable dtData) { Int32 PID = 0; string[] sID_NO; string vID_NO; string sTemp = ""; string sPurchaseNo = ""; string strResult = string.Empty; try { ArrayList ParameterList = new ArrayList(); //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); MaintainPurchaseOrder PUR02_BCO = new MaintainPurchaseOrder(strConn); DataTable dtMANUFACTURE = dtData.DefaultView.ToTable(true, new string[] { "MANUFACTURE" }); for (int i = 0; i < dtMANUFACTURE.Rows.Count; i++) { ParameterList.Clear(); ParameterList.Add(strDate); //0.採購單日期 ParameterList.Add(strUID); //1.採購人員 ParameterList.Add(dtMANUFACTURE.Rows[i]["MANUFACTURE"].ToString()); //2.廠商編號 ParameterList.Add("25"); //3.CloseCase ParameterList.Add(strUID); //4.UID //寫入 Master Table vID_NO = PUR02_BCO.CreatePurchaseOrder(ParameterList, DBT); sID_NO = vID_NO.Split(new Char[] { ';' }); PID = int.Parse(sID_NO[0].ToString()); sPurchaseNo = sID_NO[1].ToString(); strResult += sPurchaseNo + ";"; ParameterList.Add(sPurchaseNo); ParameterList.Add(PID); DataTable DetailData = FilterDetail(dtData, dtMANUFACTURE.Rows[i]["MANUFACTURE"].ToString()); #region 新增明細資料與更新 VDS_MKT_PURCARD_MAIN.PUR_NO(雜誌採購卡) 或 VDS_MKT_BPURCARD_MAIN.PUR_NO(圖書採購卡) foreach (DataRow dRow in DetailData.Rows) { PUR02_BCO.CreatePurchaseOrderDetail(PID, ParameterList, dRow, DBT); //更新期別屬性檔(VDS_ITM_PERIOD_PROFILE)中,該品號期別的交貨日期、採購日、採購量與採購單號 PUR02_BCO.UpdatePeriodProfile(dRow["ITEM"].ToString().Trim(), dRow["PERIOD"].ToString().Trim(), dRow["PLAN_ACCEPT_DATE"].ToString().Trim(), ParameterList[0].ToString().Trim(), dRow["PURCHASE_QTY"].ToString().Trim(), sPurchaseNo, ParameterList[4].ToString().Trim(), DBT); //更新圖書採購卡或雜誌採購卡採購單號 if (dRow["PERIOD"].ToString().Trim() == "000000") //在圖書裡其period值絕對是000000 { PUR02_BCO.Update_B_PURCARD(sPurchaseNo, dRow["ITEM"].ToString().Trim(), ParameterList[4].ToString().Trim(), DBT); } else { PUR02_BCO.Update_PURCARD(sPurchaseNo, dRow["ITEM"].ToString().Trim(), dRow["PERIOD"].ToString().Trim(), ParameterList[4].ToString().Trim(), DBT); } } #endregion DataTable GiftData = Add_Gift(DetailData); #region 新增明細贈品資料 if (GiftData != null) { foreach (DataRow gRow in GiftData.Rows) { PUR02_BCO.CreatePurchaseOrderDetail(PID, ParameterList, gRow, DBT); //更新贈品屬性檔(VDS_MKT_GIFT_PROFILE)資料中,該品號期別的交貨日期、採購日、採購量與採購單號 PUR02_BCO.UpdateGiftProfile(gRow["ITEM"].ToString().Trim(), gRow["PERIOD"].ToString().Trim(), gRow["VIRTUAL_CODE"].ToString().Trim(), gRow["PLAN_ACCEPT_DATE"].ToString().Trim(), ParameterList[0].ToString().Trim(), gRow["PURCHASE_QTY"].ToString().Trim(), sPurchaseNo, ParameterList[4].ToString().Trim(), DBT); } } #endregion } DBT.Commit(); } catch (Exception ex) { if (DBT != null) DBT.Rollback(); throw ex; } finally { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) Conn.Close(); } return strResult; }