public void AddMajorHandHeldCounterMainHoldToSap(string branchCode, string documentNo, string officerID1, string officerID2) { var counterHolds = GetHandHeldCounterMainHoldByDocumentNo(branchCode, documentNo); string accountingYear = string.Empty; string officerID = string.Empty; SAPProxyIII.ZDD_HH_CHKSTOCKTable tables = new SAPProxyIII.ZDD_HH_CHKSTOCKTable(); using (var sapConnection = new SAP.Connector.SAPConnection(GlobalContext.SapDestination)) { using (var prx = new SAPProxyIII.UWProxy()) { prx.Connection = sapConnection; foreach (var item in counterHolds) { var zdd = new SAPProxyIII.ZDD_HH_CHKSTOCK(); zdd.Iblnr = item.Iblnr; zdd.Gjahr = item.Gjahr; zdd.Zeili = item.Zeili; zdd.Matnr = item.Matnr; zdd.Ean11 = item.Ean11; zdd.Maktx = item.Maktx; zdd.Shelf = item.Shelf; zdd.Bin_Code = item.BinCode; zdd.Erfmg_Sku = item.ErfmgSku; zdd.Erfme_Sku = item.ErfmeSku; zdd.Ratio = item.Ratio; zdd.Erfmg_Sales = item.ErfmgSales; zdd.Erfme_Sales = item.ErfmeSales; accountingYear = item.Gjahr; officerID = item.Createuser; tables.Add(zdd); } try { prx.Zdd_Handheld_Checkstock(accountingYear, documentNo, "X", officerID1, officerID1, ref tables); using (var db = new DbManager(branchCode)) { db.SetCommand(GetSql(33), db.Parameter("@DocumentNo", documentNo)).ExecuteNonQuery(); } prx.CommitWork(); } catch (Exception ex) { prx.RollbackWork(); throw ex; } } } }
private void AddHandHeldCheckProductToSAP(string userCode, string userName, string employeeID, string locationCode, string warehouseCode, string branchCode, List <LocationDescription> locationDescriptions, List <ProductBarcode> products, string remark) { using (var sapConnection = new SAP.Connector.SAPConnection(GlobalContext.SapDestination)) { using (var prx = new SAPProxyIII.UWProxy()) { prx.Connection = sapConnection; SAPProxyIII.ZDD_HH_CHECKAREATable zdd_hh_checkarea = new SAPProxyIII.ZDD_HH_CHECKAREATable(); SAPProxyIII.ZDD_HH_CHECKAREA area = new SAPProxyIII.ZDD_HH_CHECKAREA(); foreach (var item in locationDescriptions) { #region เก็บข้อมูลลง Internal Table area.Bin_Code = locationCode; switch (item.ID + 1) { case 1: area.F01 = " "; if (item.Checked) { area.F01 = "X"; } break; case 2: area.F02 = " "; if (item.Checked) { area.F02 = "X"; } break; case 3: area.F03 = " "; if (item.Checked) { area.F03 = "X"; } break; case 4: area.F04 = " "; if (item.Checked) { area.F04 = "X"; } break; case 5: area.F05 = " "; if (item.Checked) { area.F05 = "X"; } break; case 6: area.F06 = " "; if (item.Checked) { area.F06 = "X"; } break; case 7: area.F07 = " "; if (item.Checked) { area.F07 = "X"; } break; case 8: area.F08 = " "; if (item.Checked) { area.F08 = "X"; } break; case 9: area.F09 = " "; if (item.Checked) { area.F09 = "X"; } break; case 10: area.F10 = 0; if (item.Checked) { short areaF10 = 0; Int16.TryParse(item.BlankNumber, out areaF10); area.F10 = areaF10; } break; case 11: area.F11 = " "; if (item.Checked) { area.F11 = "X"; } break; case 12: area.F12 = " "; if (item.Checked) { area.F12 = "X"; } break; case 13: area.F13 = " "; if (item.Checked) { area.F13 = "X"; } break; case 14: area.F14 = " "; if (item.Checked) { area.F14 = "X"; } break; case 15: area.F15 = " "; if (item.Checked) { area.F15 = "X"; } break; case 16: area.F16 = " "; if (item.Checked) { area.F16 = "X"; } break; case 17: area.F17 = " "; if (item.Checked) { area.F17 = "X"; } break; case 18: area.F18 = " "; if (item.Checked) { area.F18 = "X"; } break; case 19: area.F19 = " "; if (item.Checked) { area.F19 = "X"; } break; case 20: area.Expoint = 0; if (item.Checked) { short areaExpoint = 0; Int16.TryParse(item.BlankNumber, out areaExpoint); area.Expoint = areaExpoint; } break; default: break; } #endregion } area.Remark = remark; area.Lgort = warehouseCode; area.Werks = branchCode; using (DbManager db = new DbManager(branchCode)) { db.Command.CommandTimeout = 200; var sql = GetSql(28); var documentNo = this.GetHandHeldCheckProductDocumentNo(branchCode); try { db.BeginTransaction(); foreach (var item in products) { area.Matnr = item.ProductCode; area.Meins = item.UnitCode; zdd_hh_checkarea.Add(area); prx.Zdd_Handheld_Checkarea(userName, employeeID, ref zdd_hh_checkarea); if (zdd_hh_checkarea.Count > 0) { if (!string.IsNullOrEmpty(zdd_hh_checkarea[0].Chkareano)) { db.SetCommand(sql, db.Parameter("@DOCNO", documentNo), db.Parameter("@LOCATION", locationCode), db.Parameter("@DOCDATE", DateTime.Now.Date), db.Parameter("@USERID", userCode), db.Parameter("@OFFICERID", employeeID), db.Parameter("@CHKAREANO", zdd_hh_checkarea[0].Chkareano)) .ExecuteNonQuery(); documentNo = PrepareHandHeldCheckProductDocumentNo(documentNo); } } } prx.CommitWork(); db.CommitTransaction(); } catch (Exception ex) { prx.RollbackWork(); db.RollbackTransaction(); throw ex; } } } } }