private void pObjMtxRoutes_ClickBefore(object sboObject, SAPbouiCOM.SBOItemEventArg pVal, out bool BubbleEvent) { BubbleEvent = true; try { if (pVal.Row > 0) { SetRoutes(pVal.Row); pObjMtxRoutes.SelectRow(pVal.Row, true, false); //pIntCode = (int)(lObjDtRoutes.Columns.Item("Code").Cells.Item(pVal.Row - 1).Value); //pIntRow = pVal.Row; } else { pRoutes = null; //pIntCode = 0; //pIntRow = 0; } } catch (Exception ex) { LogService.WriteError(ex.Message); LogService.WriteError(ex); UIApplication.ShowMessageBox(ex.Message); } }
public SalesOrderLinesDTO GetSalesOrderLinesDTO(string pStrDocNum, string pSTrTicket) { SalesOrderLinesDTO mObjSalesOrderLines = new SalesOrderLinesDTO(); List <CommissionDebtDTO> lLstDebt = new List <CommissionDebtDTO>(); SAPbobsCOM.Recordset lObjResults = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); try { Dictionary <string, string> lLstParams = new Dictionary <string, string>(); lLstParams.Add("DocNum", pStrDocNum); lLstParams.Add("Ticket", pSTrTicket); string lStrQuery = this.GetSQL("GetSOLines").Inject(lLstParams); lObjResults.DoQuery(lStrQuery); if (lObjResults.RecordCount > 0) { for (int i = 0; i < lObjResults.RecordCount; i++) { mObjSalesOrderLines.ItemCode = lObjResults.Fields.Item("ItemCode").Value.ToString(); mObjSalesOrderLines.Description = lObjResults.Fields.Item("ItemName").Value.ToString(); mObjSalesOrderLines.Folio = lObjResults.Fields.Item("U_GLO_Ticket").Value.ToString(); mObjSalesOrderLines.Shared = lObjResults.Fields.Item("U_TR_Shared").Value.ToString() == "N" ? false : true; mObjSalesOrderLines.PayloadType = lObjResults.Fields.Item("U_TR_LoadType").Value.ToString(); mObjSalesOrderLines.VehicleType = lObjResults.Fields.Item("U_TR_VehicleType").Value.ToString(); mObjSalesOrderLines.Route = Convert.ToInt16(lObjResults.Fields.Item("U_TR_Paths").Value.ToString()); mObjSalesOrderLines.Employee = lObjResults.Fields.Item("SlpName").Value.ToString(); mObjSalesOrderLines.Asset = lObjResults.Fields.Item("OcrCode2").Value.ToString(); mObjSalesOrderLines.TotKm = lObjResults.Fields.Item("U_TR_TotKm").Value.ToString(); mObjSalesOrderLines.Extra = lObjResults.Fields.Item("U_TR_AdditionalExpense").Value.ToString(); mObjSalesOrderLines.KmA = lObjResults.Fields.Item("U_TR_TypeA").Value.ToString(); mObjSalesOrderLines.KmB = lObjResults.Fields.Item("U_TR_TypeB").Value.ToString(); mObjSalesOrderLines.KmC = lObjResults.Fields.Item("U_TR_TypeC").Value.ToString(); mObjSalesOrderLines.KmD = lObjResults.Fields.Item("U_TR_TypeD").Value.ToString(); mObjSalesOrderLines.KmE = lObjResults.Fields.Item("U_TR_TypeE").Value.ToString(); mObjSalesOrderLines.KmF = lObjResults.Fields.Item("U_TR_TypeF").Value.ToString(); mObjSalesOrderLines.Heads = lObjResults.Fields.Item("U_TR_Heads").Value.ToString(); mObjSalesOrderLines.TotKg = lObjResults.Fields.Item("U_TR_TotKilos").Value.ToString(); mObjSalesOrderLines.Bags = lObjResults.Fields.Item("U_GLO_BagsBales").Value.ToString(); mObjSalesOrderLines.UnitPrice = float.Parse(lObjResults.Fields.Item("Price").Value.ToString()); } } } catch (Exception ex) { LogService.WriteError("CommissionDAO (GetCommissionDebt): " + ex.Message); LogService.WriteError(ex); UIApplication.ShowError(string.Format("GetCommissionDebt: {0}", ex.Message)); } finally { MemoryUtility.ReleaseComObject(lObjResults); } return(mObjSalesOrderLines); }
private bool CheckMtxItems() { mBoolInsurance = false; mObjSalesOrderLines = null; for (int i = 1; i <= mObjMtxSO.RowCount; i++) { mObjTxtItem = (SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("1").Cells.Item(i).Specific; if (!string.IsNullOrEmpty(mObjTxtItem.Value) && TransportsItem(mObjTxtItem.Value)) { SetSalesOrderLine(i); } else if (Insuranceline(mObjTxtItem.Value)) { mBoolInsurance = true; } } return(mObjSalesOrderLines != null || mBoolInsurance ? true : false); }
private void SetRoutes(int pIntRow) { pRoutes = new SalesOrderLinesDTO(); pRoutes.Route = (int)(lObjDtRoutes.Columns.Item("Code").Cells.Item(pIntRow - 1).Value); pRoutes.RouteName = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cName").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.Origin = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cOrign").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.MOrigin = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cMOrgn").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.Destination = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cDest").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.MDestination = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cMDest").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.KmA = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cKmA").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.KmB = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cKmB").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.KmC = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cKmC").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.KmD = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cKmD").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.KmE = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cKmE").Cells.Item(pIntRow).Specific).Value.ToString(); pRoutes.KmF = ((SAPbouiCOM.EditText)pObjMtxRoutes.Columns.Item("cKmF").Cells.Item(pIntRow).Specific).Value.ToString(); }
private void SetSalesOrderLine(int pIntRow) { mObjSalesOrderLines = new SalesOrderLinesDTO(); mObjSalesOrderLines.ItemCode = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("1").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.Description = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("3").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.Shared = ((SAPbouiCOM.EditText)mObjUFForm.Items.Item("U_TR_Shared").Specific).Value == "N" ? false : true; mObjSalesOrderLines.Folio = ((SAPbouiCOM.EditText)mObjUFForm.Items.Item("U_GLO_Ticket").Specific).Value; //mObjSalesOrderLines.Shared = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_Compartido").Cells.Item(pIntRow).Specific).Value == "N" ? false : true; //mObjTransportService.GetRouteService().CheckIfShared(mObjSalesOrderLines.Folio) ? true : false; mObjSalesOrderLines.PayloadType = ((SAPbouiCOM.ComboBox)mObjMtxSO.Columns.Item("U_TR_LoadType").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.VehicleType = ((SAPbouiCOM.ComboBox)mObjMtxSO.Columns.Item("U_TR_VehicleType").Cells.Item(pIntRow).Specific).Value; string lStrRoute = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_Paths").Cells.Item(pIntRow).Specific).Value; lStrRoute = string.IsNullOrEmpty(lStrRoute) ? "0" : lStrRoute; mObjSalesOrderLines.Route = Convert.ToInt32(lStrRoute); string lStr = ((SAPbouiCOM.ComboBox)mObjMtxSO.Columns.Item("27").Cells.Item(pIntRow).Specific).Selected.Description; mObjSalesOrderLines.Employee = ((SAPbouiCOM.ComboBox)mObjMtxSO.Columns.Item("27").Cells.Item(pIntRow).Specific).Selected.Description; mObjSalesOrderLines.Asset = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("2003").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.TotKm = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TotKm").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.Extra = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_AdditionalExpen").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.KmA = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TypeA").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.KmB = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TypeB").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.KmC = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TypeC").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.KmD = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TypeD").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.KmE = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TypeE").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.KmF = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TypeF").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.TotKg = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_TotKilos").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.Heads = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_Heads").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.Bags = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_GLO_BagsBales").Cells.Item(pIntRow).Specific).Value; mObjSalesOrderLines.Varios = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("U_TR_OtherLoad").Cells.Item(pIntRow).Specific).Value; string lStrUnitPrice = ((SAPbouiCOM.EditText)mObjMtxSO.Columns.Item("14").Cells.Item(pIntRow).Specific).Value; lStrUnitPrice = Regex.Replace(lStrUnitPrice, "[^0-9.]", ""); mObjSalesOrderLines.UnitPrice = float.Parse(lStrUnitPrice); }