//SetValue private void SetDataTableValuesAuction(List <InvoiceExpDTO> pLstAuctionDTO) { try { DtMatrixInvoice = this.UIAPIRawForm.DataSources.DataTables.Item("DT_NC"); DtMatrixInvoice.Rows.Clear(); int i = 0; foreach (InvoiceExpDTO lObjInvoiceExp in pLstAuctionDTO) { DtMatrixInvoice.Rows.Add(); DtMatrixInvoice.SetValue("#", i, i + 1); DtMatrixInvoice.SetValue("C_BP", i, lObjInvoiceExp.BussinesPartner); DtMatrixInvoice.SetValue("C_Cert", i, lObjInvoiceExp.Certificate); DtMatrixInvoice.SetValue("C_Inv", i, lObjInvoiceExp.DocNum); DtMatrixInvoice.SetValue("C_HeadInv", i, lObjInvoiceExp.HeadInvoice); DtMatrixInvoice.SetValue("C_HeadExp", i, lObjInvoiceExp.HeatExport); DtMatrixInvoice.SetValue("C_HeadNoCr", i, lObjInvoiceExp.HeadNoCruz); DtMatrixInvoice.SetValue("C_Amount", i, lObjInvoiceExp.Amount); DtMatrixInvoice.SetValue("C_DocEntry", i, lObjInvoiceExp.DocEntry); DtMatrixInvoice.SetValue("C_Paid", i, lObjInvoiceExp.PaidToDate); i++; } } catch (Exception ex) { UIApplication.ShowError("frm (BindDataMatrix) " + ex.Message); LogService.WriteError("frm (BindDataMatrix) " + ex.Message); LogService.WriteError(ex); } }
private void getCodes() { dtList.Rows.Clear(); string codeType = "Group"; if (opI.Selected) { codeType = "Item"; } string strSql = "SELECT \"Name\",\"U_Descr\" FROM \"@B1_QA_ATTR_CODES\" WHERE \"U_CodeType\" = '" + codeType + "'"; System.Data.DataTable dtCodes = Program.objHrmsUI.getDataTable(strSql, "gettingCodes"); int i = 0; foreach (System.Data.DataRow dr in dtCodes.Rows) { i++; dtList.Rows.Add(1); dtList.SetValue("Id", i - 1, i.ToString()); dtList.SetValue("Code", i - 1, dr["Name"].ToString()); dtList.SetValue("Name", i - 1, dr["U_Descr"].ToString()); } mtList.LoadFromDataSource(); }
private Boolean ValidarDataTable(String Cuenta, Int32 pRow) { try { for (Int32 i = 0; i < oDataTable.Rows.Count; i++) { if (((System.String)oDataTable.GetValue("Cuenta", i)) != "") { if ((((System.String)oDataTable.GetValue("Cuenta", i)).Trim() == Cuenta) && (pRow != i)) { FSBOApp.StatusBar.SetText("Cuenta " + Cuenta + " ya se encuentra ingresada en el formulario", BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Warning); oDataTable.SetValue("Cuenta", pRow, ""); oDataTable.SetValue("Descripcion", pRow, ""); return(false); } } } return(true); } catch (Exception a) { FSBOApp.StatusBar.SetText("ValidarDataTable: " + a.Message + " ** Trace: " + a.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error); OutLog("ValidarDataTable: " + a.Message + " ** Trace: " + a.StackTrace); return(false); } }
/// <summary> /// Fill Livestock Matrix Data By Parallel Loopps /// </summary> /// <param name="tableID"></param> /// <param name="dataTable"></param> /// <param name="client"></param> /// <param name="type"></param> private void FillMatrix1(string tableID, SAPbouiCOM.DataTable dataTable, string client, string type) { try { dataTable.Rows.Clear(); livestock = massInvoicingDAO.GetDistributedLiveStock(client, type); var columns = new List <string>(columnsExit.Keys); if (livestock.Count > 0) { Parallel.For(0, livestock.Count, row => { dataTable.Rows.Add(); }); Task.Factory.StartNew(() => { Parallel.For(0, livestock.Count, row => { dataTable.SetValue("C_#", row, row + 1); }); }); Parallel.ForEach(Partitioner.Create(0, livestock.Count), (range, state) => { for (int i = range.Item1; i < range.Item2; i++) { Parallel.ForEach(columns.Skip(1), column => { dataTable.SetValue(column, i, livestock[i].GetType().GetProperty(column.Replace("C_", String.Empty)).GetValue(livestock[i], null)); }); } }); BindDataMatrix(mtx1, tableID, columns); if (type.Equals("N")) { Task.Factory.StartNew(() => { batches = massInvoicingDAO.GetBatches(client, user.WhsCode, type); floorServiceLines = massInvoicingDAO.GetFloorServiceLines(client, user.WhsCode, type); }); } } else { ClearMtx(mtx1); } } catch (AggregateException ae) { ae.Handle(e => { HandleException(e, "(AE)"); return(true); }); } catch (Exception ex) { HandleException(ex, "(FillMatrix2)"); } }
/// <summary> /// Fill Client Matrix Data By Parallel Loopps /// </summary> /// <param name="tableID"></param> /// <param name="dataTable"></param> private void FillMatrix0(string tableID, SAPbouiCOM.DataTable dataTable, string type) { try { dataTable.Rows.Clear(); var columns = new List <string>(columnsClient.Keys); pendingInvoices = massInvoicingDAO.GetInvoicesPending(type); if (pendingInvoices.Count > 0) { //add empty rows to datatable Parallel.For(0, pendingInvoices.Count, row => { dataTable.Rows.Add(); }); //add the index column in a separate task Task.Factory.StartNew(() => { Parallel.For(0, pendingInvoices.Count, row => { dataTable.SetValue("C_#", row, row + 1); }); }); //popolate the empty rows of the matrix Parallel.ForEach(Partitioner.Create(0, pendingInvoices.Count), (range, state) => { for (int i = range.Item1; i < range.Item2; i++) { Parallel.ForEach(columns.Skip(1), column => { dataTable.SetValue(column, i, pendingInvoices[i].GetType().GetProperty(column.Replace("C_", String.Empty)).GetValue(pendingInvoices[i], null)); }); } }); //bind datatable with matrix BindDataMatrix(mtx0, tableID, columns); LogService.WriteInfo("(frmDelivery) Matriz Cargada correctamente"); } else { ClearMtx(mtx0); } } catch (AggregateException ae) { ae.Handle(e => { HandleException(e, "(AE)"); return(true); }); } catch (Exception ex) { if (!invoicedFlag) { HandleException(ex, "(FillMatrix0)"); } } }
}//fin InitForm public new void FormEvent(String FormUID, ref SAPbouiCOM.ItemEvent pVal, ref Boolean BubbleEvent) { Int32 nErr; String sErr; base.FormEvent(FormUID, ref pVal, ref BubbleEvent); try { if (pVal.ItemUID == "3") { if ((pVal.ColUID == "Code") && (!pVal.BeforeAction) && (pVal.EventType == BoEventTypes.et_COMBO_SELECT)) { if (pVal.Row == oDataTable.Rows.Count - 1) { if ((System.String)(oDataTable.GetValue("Code", oDataTable.Rows.Count - 1)) != "") { oDataTable.Rows.Add(1); oDataTable.SetValue("Code", oDataTable.Rows.Count - 1, ""); oDataTable.SetValue("Name", oDataTable.Rows.Count - 1, ""); } } } } if ((pVal.EventType == BoEventTypes.et_ITEM_PRESSED) && (pVal.BeforeAction)) { var paso = false; if ((pVal.ItemUID == "1") && ((oForm.Mode == BoFormMode.fm_ADD_MODE) || (oForm.Mode == BoFormMode.fm_UPDATE_MODE))) { BubbleEvent = false; if (LimpiarGrid()) { paso = CrearDatos(); } if ((paso) && (oForm.Mode != BoFormMode.fm_OK_MODE)) { oForm.Mode = BoFormMode.fm_OK_MODE; } } else if ((pVal.ItemUID == "1") && (oForm.Mode == BoFormMode.fm_OK_MODE)) { BubbleEvent = true; } } } catch (Exception e) { FCmpny.GetLastError(out nErr, out sErr); FSBOApp.StatusBar.SetText("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error); OutLog("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace); } }//fin FormEvent
private void loadSetting() { Program.objHrmsUI.loadSettings(); try { cardCode = Program.objHrmsUI.settings["WebCardCode"].ToString(); dtHead.SetValue("CardCode", 0, Program.objHrmsUI.settings["WebCardCode"].ToString()); dtHead.SetValue("slp", 0, Program.objHrmsUI.settings["WebSlpCode"].ToString()); dtHead.SetValue("branch", 0, Program.objHrmsUI.settings["WebBranch"].ToString()); dtHead.SetValue("Whs", 0, Program.objHrmsUI.settings["Warehouse"].ToString()); } catch { } }
private void getCodes() { dtList.Rows.Clear(); string codeType = "Group"; string strSql = "SELECT \"Code\" , \"Name\" FROM \"@B1_QA_OUSR\""; System.Data.DataTable dtCodes = Program.objHrmsUI.getDataTable(strSql, "gettingCodes"); int i = 0; foreach (System.Data.DataRow dr in dtCodes.Rows) { i++; dtList.Rows.Add(1); dtList.SetValue("Id", i - 1, i.ToString()); dtList.SetValue("Code", i - 1, dr["Code"].ToString()); dtList.SetValue("Name", i - 1, dr["Name"].ToString()); } mtList.LoadFromDataSource(); }
private void fillAddons() { dtHead.Rows.Clear(); string strSql = "Select * from [@B1_MODULES]"; System.Data.DataTable dtModules = Program.objHrmsUI.getDataTable(strSql, "Filling Module"); int i = 0; foreach (System.Data.DataRow dr in dtModules.Rows) { dtHead.Rows.Add(1); dtHead.SetValue("Id", i, (i + 1).ToString()); dtHead.SetValue("AC", i, dr["CODE"].ToString()); dtHead.SetValue("AN", i, dr["NAME"].ToString()); dtHead.SetValue("LK", i, dr["U_LicenseKey"].ToString()); dtHead.SetValue("Active", i, dr["U_Enabled"].ToString()); i++; } mtAddon.LoadFromDataSource(); }
private void FillOrderMatrix() { oForm.Freeze(true); dtWebO.Rows.Clear(); int i = 0; DateTime OrdersSinceCreateDate = Convert.ToDateTime(dtHead.GetValue("From", 0)); DateTime OrdersToCreateDate = Convert.ToDateTime(dtHead.GetValue("To", 0)); string LTDINCCard = Program.objHrmsUI.getSetting("INCCODE").ToString(); string strSql = "Select DocEntry, Convert(varchar(30),DocDate,101) as DocDate,OINV.DocNum from OINV where OINV.CardCode = '" + LTDINCCard + "' And DocDate between '" + OrdersSinceCreateDate.ToString("yyyyMMdd") + "' and '" + OrdersToCreateDate.ToString("yyyyMMdd") + "' order by DocNum"; System.Data.DataTable dtOrders = Program.dsLTD.getDataTable(strSql, "gettingOrders"); string selStatus = cbOS.Selected.Value.ToString(); foreach (System.Data.DataRow dr in dtOrders.Rows) { string orderStatus = "O"; string strId = dr["DocEntry"].ToString(); string pchEntry = getDocNum("LTD Inv # " + dr["DocNum"].ToString(), "OPOR"); if (pchEntry != "" && pchEntry != "0") { orderStatus = "C"; } if (selStatus == "01" || (selStatus == "02" && orderStatus == "O") || (selStatus == "03" && orderStatus == "C")) { dtWebO.Rows.Add(1); dtWebO.SetValue("Id", i, (i + 1).ToString()); dtWebO.SetValue("WebNum", i, dr["DocNum"].ToString()); dtWebO.SetValue("RdrNum", i, pchEntry); dtWebO.SetValue("RdrDT", i, dr["DocDate"].ToString()); i++; } } mtWO.LoadFromDataSource(); oForm.Freeze(false); lblStatus.Caption = ""; updateRetMatrix(); }
private void fillJeDetailHead(string docNum, int RowNum) { txDS.Value = "0.00"; txCS.Value = "0.00"; txDD.Value = ""; txDN.Value = ""; txRem.Value = ""; txRef1.Value = ""; txRef2.Value = ""; txPJ.Value = ""; txCJ.Value = ""; dtDet.Rows.Clear(); string jeType = "PP"; if (optPP.Selected) { jeType = "PP"; } if (optPC.Selected) { jeType = "PC"; } if (optC.Selected) { jeType = "C"; } try { if (jeType == "C") { btPost.Item.Enabled = false; } else { btPost.Item.Enabled = true; } } catch { } if (RowNum > 0) { txRem.Value = Convert.ToString(dtHead.GetValue("cRemarks", RowNum - 1)); txRef1.Value = Convert.ToString(dtHead.GetValue("cNum", RowNum - 1)); txPJ.Value = Convert.ToString(dtHead.GetValue("cPostedJE", RowNum - 1)); txCJ.Value = Convert.ToString(dtHead.GetValue("cCanceledJE", RowNum - 1)); oForm.DataSources.UserDataSources.Item("txDD").ValueEx = Convert.ToDateTime(dtHead.GetValue("cDate", RowNum - 1)).ToString("yyyyMMdd"); } chkPost.Checked = false; dtPendingJEs.Rows.Clear(); DataServices ds = new DataServices(Program.strConMena); string strSelect = " Select MenaCode as lineType ,acctCode,acctName,debit ,credit , project ,ocr1 ,ocr2 ,ocr3 ,ocr4 ,ocr5 from [dbo].[JE_PRL_getJEDetRows]('" + docNum + "') "; dtDet.Rows.Clear(); System.Data.DataTable dtRows = ds.getDataTable(strSelect, "Filling Detail"); if (dtRows != null && dtRows.Rows.Count > 0) { int i = 0; double debit = 0.00; double credit = 0.00; foreach (DataRow dr in dtRows.Rows) { double lineDebit = 0.00; double lineCredit = 0.00; lineDebit = Convert.ToDouble(dr["debit"].ToString()); lineCredit = Convert.ToDouble(dr["credit"].ToString()); debit += lineDebit; credit += lineCredit; dtDet.Rows.Add(1); dtDet.SetValue("cNum", i, i.ToString()); dtDet.SetValue("cType", i, Convert.ToString(dr["lineType"].ToString())); dtDet.SetValue("cCode", i, Convert.ToString(Program.objHrmsUI.getAcctSys(dr["lineType"].ToString().Replace("-", "")))); dtDet.SetValue("cName", i, Convert.ToString(Program.objHrmsUI.getAcctName(dr["lineType"].ToString().Replace("-", "")))); dtDet.SetValue("cDebit", i, Convert.ToString(dr["debit"].ToString())); dtDet.SetValue("cCredit", i, Convert.ToString(dr["credit"].ToString())); dtDet.SetValue("cProject", i, Convert.ToString(dr["project"].ToString())); dtDet.SetValue("cOcr1", i, Convert.ToString(dr["ocr1"].ToString())); dtDet.SetValue("cOcr2", i, Convert.ToString(dr["ocr2"].ToString())); dtDet.SetValue("cOcr3", i, Convert.ToString(dr["ocr3"].ToString())); dtDet.SetValue("cOcr4", i, Convert.ToString(dr["ocr4"].ToString())); dtDet.SetValue("cOcr5", i, Convert.ToString(dr["ocr5"].ToString())); i++; } mtDet.LoadFromDataSource(); txDS.Value = debit.ToString(); txCS.Value = credit.ToString(); } mtDet.LoadFromDataSource(); }
}//fin InitForm public new void FormEvent(String FormUID, ref SAPbouiCOM.ItemEvent pVal, ref Boolean BubbleEvent) { SAPbouiCOM.DataTable oDataTable; SAPbouiCOM.IChooseFromListEvent oCFLEvento = null; String sValue; String sValue2; base.FormEvent(FormUID, ref pVal, ref BubbleEvent); try { if ((pVal.ItemUID == "1") && (pVal.BeforeAction) && (pVal.EventType == BoEventTypes.et_ITEM_PRESSED)) { if ((oForm.Mode == BoFormMode.fm_ADD_MODE) || (oForm.Mode == BoFormMode.fm_UPDATE_MODE)) { BubbleEvent = false; if (ValidarDatos()) { GuardarDatos(); } } } if ((pVal.EventType == BoEventTypes.et_CHOOSE_FROM_LIST) && (!pVal.BeforeAction)) { oForm.Freeze(true); if (pVal.ColUID == "U_CtaSAP") { oCFLEvento = (SAPbouiCOM.IChooseFromListEvent)(pVal); oDataTable = oCFLEvento.SelectedObjects; if (oDataTable != null) { sValue = ((System.String)oDataTable.GetValue("FormatCode", 0)).Trim(); sValue2 = ((System.String)oDataTable.GetValue("AcctName", 0)).Trim(); if (ValidarDataTable(sValue)) { odt.SetValue("U_CtaSAP", pVal.Row, sValue); odt.SetValue("U_DescSAP", pVal.Row, sValue2); if ((odt.Rows.Count - 1 == pVal.Row) && (sValue != "")) { odt.Rows.Add(1); } oGrid.AutoResizeColumns(); if (oForm.Mode == BoFormMode.fm_OK_MODE) { oForm.Mode = BoFormMode.fm_UPDATE_MODE; } } } } } } catch (Exception e) { if (FCmpny.InTransaction) { FCmpny.EndTransaction(BoWfTransOpt.wf_RollBack); } FSBOApp.StatusBar.SetText(e.Message + " ** Trace: " + e.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error); OutLog("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace); } finally { oForm.Freeze(false); } }//fin FormEvent
}//fin InitForm public new void FormEvent(String FormUID, ref SAPbouiCOM.ItemEvent pVal, ref Boolean BubbleEvent) { SAPbouiCOM.DataTable oDataTable; SAPbouiCOM.IChooseFromListEvent oCFLEvento = null; String sValue; String sValue2; base.FormEvent(FormUID, ref pVal, ref BubbleEvent); try { if (pVal.EventType == BoEventTypes.et_ITEM_PRESSED) { if (pVal.BeforeAction == true) { if (((oForm.Mode == BoFormMode.fm_ADD_MODE) || (oForm.Mode == BoFormMode.fm_UPDATE_MODE)) && (pVal.ItemUID == "1")) { BubbleEvent = false; if (Validar()) { Guardar_Registros(); } } } if ((pVal.BeforeAction == false) && (pVal.ItemUID == "btn_Borrar")) { BorrarLinea(); } } if ((pVal.EventType == BoEventTypes.et_CHOOSE_FROM_LIST) && (!pVal.BeforeAction)) { oForm.Freeze(true); if (pVal.ColUID == "U_CardCode") { oCFLEvento = (SAPbouiCOM.IChooseFromListEvent)(pVal); oDataTable = oCFLEvento.SelectedObjects; if (oDataTable != null) { sValue = ((System.String)oDataTable.GetValue("CardCode", 0)).Trim(); sValue2 = ((System.String)oDataTable.GetValue("CardName", 0)).Trim(); for (Int32 iCont_1 = 0; iCont_1 < odt.Rows.Count; iCont_1++) { if (((System.String)odt.GetValue("U_CardCode", iCont_1)).Length > 0) { var CardCode = ((System.String)odt.GetValue("U_CardCode", iCont_1)); if (CardCode == sValue) { FSBOApp.StatusBar.SetText("Proveedor ya se encuentra en la lista Negra", BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Warning); return; } } } if (GlobalSettings.RunningUnderSQLServer) { s = @"SELECT COUNT(*) 'count' FROM [@VID_FELISTABL] WHERE U_CardCode = '{0}'"; } else { s = @"SELECT COUNT(*) ""count"" FROM ""@VID_FELISTABL"" WHERE ""U_CardCode"" = '{0}'"; } s = String.Format(s, sValue); oRecordSet.DoQuery(s); if (((System.Int32)oRecordSet.Fields.Item("count").Value) > 0) { FSBOApp.StatusBar.SetText("Codigo Proveedor se encuentra en la lista blanca, no se puede seleccionar -> Codigo " + sValue, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Warning); return; } odt.SetValue("U_CardCode", pVal.Row, sValue); odt.SetValue("U_CardName", pVal.Row, sValue2); odt.SetValue("U_Activado", pVal.Row, "Y"); if ((odt.Rows.Count - 1 == pVal.Row) && (sValue != "")) { odt.Rows.Add(1); } ogrid.AutoResizeColumns(); if (oForm.Mode == BoFormMode.fm_OK_MODE) { oForm.Mode = BoFormMode.fm_UPDATE_MODE; } } } } } catch (Exception e) { if (FCmpny.InTransaction) { FCmpny.EndTransaction(BoWfTransOpt.wf_RollBack); } FSBOApp.StatusBar.SetText(e.Message + " ** Trace: " + e.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error); OutLog("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace); } finally { if (oForm != null) { oForm.Freeze(false); } } }//fin FormEvent
private void getDocs() { string strWhs = ""; foreach (string whs in userWhs) { if (strWhs == "") { strWhs = "'" + whs + "'"; } else { strWhs += " ,'" + whs + "'"; } } string strOT = ""; foreach (string ot in userOT) { if (strOT == "") { strOT = "'" + ot + "'"; } else { strOT += " ,'" + ot + "'"; } } if (strOT == "" || strWhs == "") { return; } string strDocs = " SELECT t0.\"Comments\" , t0.\"TransType\", t0.BASE_REF,t0.\"CreatedBy\", t1.\"Name\" , t1.\"U_TblScm\" FROM OINM t0 INNER JOIN \"@B1_QA_OBJS\" t1 ON t0.\"TransType\" = CAST(t1.\"Code\" AS integer) "; strDocs += " WHERE t0.\"InQty\" > 0 AND t0.\"Warehouse\" IN (" + strWhs + ") AND t0.\"TransType\" IN (" + strOT + ") " + " AND NOT EXISTS (SELECT tObj.\"U_ObjType\" FROM \"@B1_QA_DOC\" tObj WHERE tObj.\"U_Final\" = 'Y' AND tObj.\"U_ObjType\" = t0.\"TransType\" AND tObj.\"U_DocEntry\" = t0.\"CreatedBy\" ) " + "GROUP BY t0.\"TransType\", t0.BASE_REF,t0.\"CreatedBy\", t1.\"Name\", t1.\"U_TblScm\" ,t0.\"Comments\" "; System.Data.DataTable dtdocs = Program.objHrmsUI.getDataTable(strDocs, "getting docs"); int i = 0; dtDoc.Rows.Clear(); foreach (System.Data.DataRow dr in dtdocs.Rows) { string DocType = dr["Name"].ToString(); string transType = dr["TransType"].ToString(); if (transType == "59") { string DE = dr["CreatedBy"].ToString(); string strProdNum = "SELECT \"U_B1_QA_INSP_PN\" FROM \"OIGN\" WHERE \"DocEntry\" ='" + DE + "'"; System.Data.DataTable dtProdNum = Program.objHrmsUI.getDataTable(strProdNum, "ProdNum"); if (dtProdNum != null && dtProdNum.Rows.Count > 0) { if (dtProdNum.Rows[0]["U_B1_QA_INSP_PN"] != DBNull.Value && Convert.ToInt32(dtProdNum.Rows[0]["U_B1_QA_INSP_PN"]) > 0) { DocType = "Offer for Inspection"; } } } i++; dtDoc.Rows.Add(1); dtDoc.SetValue("Id", i - 1, i.ToString()); dtDoc.SetValue("DE", i - 1, dr["CreatedBy"].ToString()); dtDoc.SetValue("DN", i - 1, dr["BASE_REF"].ToString()); dtDoc.SetValue("DT", i - 1, DocType); dtDoc.SetValue("Tbl", i - 1, dr["U_TblScm"].ToString()); dtDoc.SetValue("OT", i - 1, dr["TransType"].ToString()); } mtDocs.LoadFromDataSource(); }
private void fillJeDetailHead(string docNum) { txDS.Value = "0.00"; txCS.Value = "0.00"; chkPost.Checked = false; Hashtable hp = new Hashtable(); hp.Add("~p1", docNum); string strSelect = Program.objHrmsUI.getQryString("JE_getJEDetHead", hp); dtPendingJEs.Rows.Clear(); System.Data.DataTable dtJeHead = Program.objHrmsUI.getDataTable(strSelect, "Filling All Jes"); if (dtJeHead != null && dtJeHead.Rows.Count > 0) { foreach (DataRow dr in dtJeHead.Rows) { oForm.DataSources.UserDataSources.Item("txDD").ValueEx = Convert.ToDateTime(dr["docDate"]).ToString("yyyyMMdd"); txDN.Value = dr["docNum"].ToString(); txRem.Value = dr["Remarks"].ToString(); txRef1.Value = dr["Ref1"].ToString(); txRef2.Value = dr["Ref2"].ToString(); } } strSelect = @"SELECT case when ( t0.U_DAccCode in (select cardcode from ocrd)) then 'BP' else 'GL' end lineType, case when (t0.U_DAccCode in (select cardcode from ocrd)) then U_DAccCode else (select acctcode from oact where replace( t0.U_DAccCode,'-','') = oact.FormatCode ) end acctCode , t0.U_DAccName, t0.U_DebitAmt debit ,0 credit , t0.U_Project project ,t0.U_ProfitCode ocr1 , t0.U_OcrCode2 ocr2 , t0.U_OcrCode3 ocr3 , t0.U_OcrCode4 ocr4 , t0.U_OcrCode5 ocr5 FROM dbo.[@ABGP] t0 where t0.DocNum = '~p1'" ; strSelect = Program.objHrmsUI.getQryString("JE_getJEDetRows_D", hp); double debit = 0.00; double credit = 0.00; dtDet.Rows.Clear(); System.Data.DataTable dtRows = Program.objHrmsUI.getDataTable(strSelect, "Filling Detail"); if (dtRows != null && dtRows.Rows.Count > 0) { int i = 0; foreach (DataRow dr in dtRows.Rows) { double lineDebit = 0.00; double lineCredit = 0.00; lineDebit = Convert.ToDouble(dr["debit"].ToString()); lineCredit = Convert.ToDouble(dr["credit"].ToString()); debit += lineDebit; credit += lineCredit; dtDet.Rows.Add(1); dtDet.SetValue("cNum", i, i.ToString()); dtDet.SetValue("cType", i, Convert.ToString(dr["lineType"].ToString())); dtDet.SetValue("cCode", i, Convert.ToString(dr["acctCode"].ToString())); dtDet.SetValue("cName", i, Convert.ToString(dr["acctName"].ToString())); dtDet.SetValue("cDebit", i, Convert.ToString(dr["debit"].ToString())); dtDet.SetValue("cCredit", i, Convert.ToString(dr["credit"].ToString())); dtDet.SetValue("cProject", i, Convert.ToString(dr["project"].ToString())); dtDet.SetValue("cOcr1", i, Convert.ToString(dr["ocr1"].ToString())); dtDet.SetValue("cOcr2", i, Convert.ToString(dr["ocr2"].ToString())); dtDet.SetValue("cOcr3", i, Convert.ToString(dr["ocr3"].ToString())); dtDet.SetValue("cOcr4", i, Convert.ToString(dr["ocr4"].ToString())); dtDet.SetValue("cOcr5", i, Convert.ToString(dr["ocr5"].ToString())); i++; } } strSelect = Program.objHrmsUI.getQryString("JE_getJEDetRows_C", hp); dtRows = Program.objHrmsUI.getDataTable(strSelect, "Filling Detail"); if (dtRows != null && dtRows.Rows.Count > 0) { int i = 1; foreach (DataRow dr in dtRows.Rows) { double lineDebit = 0.00; double lineCredit = 0.00; lineDebit = Convert.ToDouble(dr["debit"].ToString()); lineCredit = Convert.ToDouble(dr["credit"].ToString()); debit += lineDebit; credit += lineCredit; dtDet.Rows.Add(1); dtDet.SetValue("cNum", i, i.ToString()); dtDet.SetValue("cType", i, Convert.ToString(dr["lineType"].ToString())); dtDet.SetValue("cCode", i, Convert.ToString(dr["acctCode"].ToString())); dtDet.SetValue("cName", i, Convert.ToString(dr["acctName"].ToString())); dtDet.SetValue("cDebit", i, Convert.ToString(dr["debit"].ToString())); dtDet.SetValue("cCredit", i, Convert.ToString(dr["credit"].ToString())); dtDet.SetValue("cProject", i, Convert.ToString(dr["project"].ToString())); dtDet.SetValue("cOcr1", i, Convert.ToString(dr["ocr1"].ToString())); dtDet.SetValue("cOcr2", i, Convert.ToString(dr["ocr2"].ToString())); dtDet.SetValue("cOcr3", i, Convert.ToString(dr["ocr3"].ToString())); dtDet.SetValue("cOcr4", i, Convert.ToString(dr["ocr4"].ToString())); dtDet.SetValue("cOcr5", i, Convert.ToString(dr["ocr5"].ToString())); i++; } } mtDet.LoadFromDataSource(); txDS.Value = debit.ToString(); txCS.Value = credit.ToString(); }
protected virtual void e_FormLoad(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent) { try { if (pVal.BeforeAction == false && bLoadInputEvents) { oform = oApplication.Forms.Item(pVal.FormUID); oform.ClientWidth = 450; oform.ClientHeight = 400; dtSearch = oform.DataSources.DataTables.Add("dtSearch"); // oform.Width = 600; oform.Title = sTitle; oform.State = BoFormStateEnum.fs_Maximized; SAPbouiCOM.Item oItem; IbtChoos = oform.Items.Item("1"); IbtChoos.Top = 350; btChoos = (SAPbouiCOM.Button)IbtChoos.Specific; btChoos.Caption = "Choose"; ISearchField = oform.Items.Item("2"); ISearchField.Top = 350; SAPbouiCOM.Columns oColumns; SAPbouiCOM.DataColumns dtCols; dtCols = dtSearch.Columns; SAPbouiCOM.Column oColumn; SAPbouiCOM.DataColumn dtCol; oItem = oform.Items.Add("mtSearch", BoFormItemTypes.it_MATRIX); oItem.Width = 440; oItem.Height = 290; oItem.Top = 60; oItem.Enabled = true; mtSearch = (SAPbouiCOM.Matrix)oItem.Specific; // mtSearch. oItem = oform.Items.Add("lbCritaria", BoFormItemTypes.it_STATIC); oItem.Top = 40; oItem.Left = 10; SAPbouiCOM.StaticText lblCri = (SAPbouiCOM.StaticText)oItem.Specific; lblCri.Caption = "Find"; oItem = oform.Items.Add("txCritaria", BoFormItemTypes.it_EDIT); oItem.Top = 40; oItem.Width = 300; oItem.Left = 130; //SAPbouiCOM.StaticText lblCri = oItem.Specific; if (flgMultiple) { } else { mtSearch.SelectionMode = BoMatrixSelect.ms_Single; } // mtSearch oColumns = mtSearch.Columns; //mtSearch.Layout = BoMatrixLayoutType.mlt_Vertical; oColumn = oColumns.Add("vFix", SAPbouiCOM.BoFormItemTypes.it_EDIT); // oColumn.Editable = false; oColumn.Width = 40; //oColumn.Visible = false; int i = 0; int j = 0; foreach (System.Data.DataColumn cl in dtTable.Columns) { dtOut.Columns.Add(cl.ColumnName); oColumn = oColumns.Add("v_" + i.ToString(), SAPbouiCOM.BoFormItemTypes.it_EDIT); oColumn.TitleObject.Caption = cl.Caption; oColumn.Width = 100; oColumn.Editable = false; dtCol = dtCols.Add("cd" + i.ToString(), BoFieldsType.ft_AlphaNumeric); oColumn.DataBind.Bind("dtSearch", "cd" + i.ToString()); // oColumn. i++; // col.DataBind.TableName = "dtSearch"; //col.DataBind } dtSearch.Rows.Clear(); i = 0; j = 0; foreach (DataRow dr in dtTable.Rows) { dtSearch.Rows.Add(1); j = 0; foreach (System.Data.DataColumn col in dtTable.Columns) { dtSearch.SetValue("cd" + j.ToString(), i, dr[j].ToString()); j++; } i++; } mtSearch.LoadFromDataSource(); oform = null; } } catch (Exception ex) { bLoadInputEvents = false; } }
private void InitiallizeForm() { oForm.Freeze(true); // Program.objHrmsUI.ExecQuery("Update B1_SCHMDT set u_upd='Y' where isnull(u_upd,'N') = 'N'", "Finalizing temp"); Program.objHrmsUI.ExecQuery("delete from [@B1_SCHMDT] where isnull(u_upd,'N') = 'N'", "Finalizing temp"); Program.objHrmsUI.ExecQuery("delete from [@B1_SCHMDY] where isnull(u_upd,'N') = 'N'", "Finalizing temp"); Program.objHrmsUI.ExecQuery("delete from [@B1_SO] where isnull(u_upd,'N') = 'N'", "Finalizing temp"); Program.objHrmsUI.ExecQuery("delete from [@B1_SCHOT] where isnull(u_upd,'N') = 'N'", "Finalizing temp"); cardCFL = (SAPbouiCOM.ChooseFromList)oForm.ChooseFromLists.Item("cflCRD"); SAPbouiCOM.Conditions oCons = cardCFL.GetConditions(); SAPbouiCOM.Condition oCon = oCons.Add(); oCon.Alias = "CardType"; oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL; oCon.CondVal = "C"; cardCFL.SetConditions(oCons); dtHead = oForm.DataSources.DataTables.Item("dtHead"); dtItem = oForm.DataSources.DataTables.Item("dtItem"); dtDate = oForm.DataSources.DataTables.Item("dtDate"); dtDays = oForm.DataSources.DataTables.Item("dtDays"); dtOSCN = oForm.DataSources.DataTables.Item("dtOSCN"); dtOT = oForm.DataSources.DataTables.Item("dtOT"); mtItem = (SAPbouiCOM.Matrix)oForm.Items.Item("mtItem").Specific; mtDate = (SAPbouiCOM.Matrix)oForm.Items.Item("mtDate").Specific; mtDay = (SAPbouiCOM.Matrix)oForm.Items.Item("mtDays").Specific; mtOSCN = (SAPbouiCOM.Matrix)oForm.Items.Item("mtOSCN").Specific; mtOT = (SAPbouiCOM.Matrix)oForm.Items.Item("mtOT").Specific; dtHead.Rows.Add(1); dtHead.SetValue("tsActive", 0, "Y"); txCode = (SAPbouiCOM.EditText)oForm.Items.Item("txCode").Specific; txName = (SAPbouiCOM.EditText)oForm.Items.Item("txName").Specific; txCT = (SAPbouiCOM.EditText)oForm.Items.Item("txCT").Specific; txOTDT = (SAPbouiCOM.EditText)oForm.Items.Item("txOTDT").Specific; txICode = (SAPbouiCOM.EditText)oForm.Items.Item("txICode").Specific; txOMDT = (SAPbouiCOM.EditText)oForm.Items.Item("txOMDT").Specific; txOICODE = (SAPbouiCOM.EditText)oForm.Items.Item("txOICODE").Specific; imgImage = (SAPbouiCOM.PictureBox)oForm.Items.Item("imgImage").Specific; txSL = (SAPbouiCOM.EditText)oForm.Items.Item("txSL").Specific; cbSP = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbSP").Specific; cbDays = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbDays").Specific; cbWeeks = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbWeeks").Specific; cbHH = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbHH").Specific; cbMM = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbMM").Specific; cbAP = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbAP").Specific; cbEWN = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbEWN").Specific; cbOTHH = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbOTHH").Specific; cbOTMM = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbOTMM").Specific; cbOTAP = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbOTAP").Specific; opOD = (SAPbouiCOM.OptionBtn)oForm.Items.Item("opOD").Specific; opOW = (SAPbouiCOM.OptionBtn)oForm.Items.Item("opOW").Specific; opOM = (SAPbouiCOM.OptionBtn)oForm.Items.Item("opOM").Specific; OMDY = (SAPbouiCOM.OptionBtn)oForm.Items.Item("OMDY").Specific; OMDT = (SAPbouiCOM.OptionBtn)oForm.Items.Item("OMDT").Specific; opOW.GroupWith("opOD"); opOM.GroupWith("opOD"); OMDY.GroupWith("OMDT"); opOD.Selected = true; OMDT.Selected = true; tbSO = (SAPbouiCOM.Folder)oForm.Items.Item("tbSO").Specific; tbTS = (SAPbouiCOM.Folder)oForm.Items.Item("tbTS").Specific; tbTS.Select(); fillCBs(); oForm.Freeze(false); txCode.Active = true; }
private void addWebOrder(string incrementId, Mag.MagentoService svc) { string mLogin = ""; svc.PreAuthenticate = true; Program.LoginToMagento(out mLogin, out svc); Mag.salesOrderPaymentEntity pmt = new Mag.salesOrderPaymentEntity(); Mag.shoppingCartPaymentEntity scpmt = new Mag.shoppingCartPaymentEntity(); Mag.salesOrderEntity soe = new Mag.salesOrderEntity(); Mag.shoppingCartInfoEntity cart = new Mag.shoppingCartInfoEntity(); Mag.shoppingCartPaymentMethodEntity pmtmethod = new Mag.shoppingCartPaymentMethodEntity(); soe = svc.salesOrderInfo(mLogin, incrementId); cart = svc.shoppingCartInfo(mLogin, Convert.ToInt32(soe.quote_id), soe.store_id); pmt = soe.payment; string WebID = soe.increment_id; DateTime utcDate = Convert.ToDateTime(soe.created_at); utcDate = DateTime.SpecifyKind(utcDate, DateTimeKind.Utc); DateTime localDT = utcDate.ToLocalTime(); string OrderDate = localDT.ToString(); string CCode = ""; if (cart.customer_id != null) { CCode = cart.customer_id; } else { CCode = soe.customer_id; } string CTel1 = soe.shipping_address.telephone; string CMail = soe.customer_email; string Contact = soe.customer_firstname + " " + soe.customer_lastname; string CNTel = soe.billing_address.telephone; string CNEmail = soe.customer_email; string bName = soe.billing_address.firstname + " " + soe.billing_address.lastname; string bStreet = soe.billing_address.street; string bCity = soe.billing_address.city; string bState = soe.billing_address.region; string bZipCode = soe.billing_address.postcode; string bPhone = soe.billing_address.telephone == null ? "" : soe.billing_address.telephone; string bEmail = soe.customer_email; string sName = soe.shipping_address.firstname + " " + soe.shipping_address.lastname; string sStreet = soe.shipping_address.street; string sCity = soe.shipping_address.city; string sState = soe.shipping_address.region; string sPhone = soe.shipping_address.telephone == null ? "" : soe.shipping_address.telephone; string sZipCode = soe.shipping_address.postcode; string sEmail = soe.customer_email; string shipcharge = "Ship Charge"; string sCompany = soe.shipping_address.company == null ? "" : soe.shipping_address.company; dtCard.Rows.Clear(); dtCard.Rows.Add(1); if (CCode == null) { CCode = "99999999"; } CCode = "W-" + CCode.PadLeft(8, '0'); dtCard.SetValue("BName", 0, bName); dtCard.SetValue("BStPO", 0, bStreet); string[] streetArr = bStreet.Split('\n'); string addr1B = ""; string addr2B = ""; if (streetArr.Length > 0) { addr1B = streetArr[0].ToString(); } if (streetArr.Length > 1) { addr2B = streetArr[1].ToString(); } dtCard.SetValue("BAdd1", 0, addr1B); dtCard.SetValue("BAdd2", 0, addr2B); //dtCard.SetValue("BCompany", 0, soe.com); dtCard.SetValue("BCity", 0, bCity); dtCard.SetValue("BState", 0, bState); dtCard.SetValue("BZip", 0, bZipCode); dtCard.SetValue("BTel", 0, bPhone); dtCard.SetValue("BEmail", 0, bEmail); dtCard.SetValue("SName", 0, sName); dtCard.SetValue("SStPO", 0, sStreet); streetArr = sStreet.Split('\n'); string addr1S = ""; string addr2S = ""; if (streetArr.Length > 0) { addr1S = streetArr[0].ToString(); } if (streetArr.Length > 1) { addr2S = streetArr[1].ToString(); } dtCard.SetValue("SAdd1", 0, addr1S); dtCard.SetValue("SAdd2", 0, addr2S); dtCard.SetValue("SCity", 0, sCity); dtCard.SetValue("SZip", 0, sZipCode); dtCard.SetValue("STel", 0, sPhone); dtCard.SetValue("SEmail", 0, sEmail); dtCard.SetValue("SState", 0, sState); dtCard.SetValue("SComp", 0, sCompany); Mag.shoppingCartPaymentEntity cpmt = new Mag.shoppingCartPaymentEntity(); cpmt = cart.payment; string numAtCard = soe.increment_id; string DiscCode = cart.coupon_code == null ? "" : cart.coupon_code; string BillingZip = soe.billing_address.postcode; string ordrsource = "W"; string CCName = cart.payment.cc_owner == null ? "" : cart.payment.cc_owner;; // soe.payment.cc_owner; string l4Digit = cart.payment.cc_last4 == null ? "" : cart.payment.cc_last4; string AuthNet = cart.payment.cc_ss_issue == null ? "" : cart.payment.cc_ss_issue; string ChargeAmount = soe.payment.amount_ordered; string MagentoId = soe.master_order_id; string TransDate = localDT.ToString(); string WebOrderAt = localDT.ToString(); string WebDiscP = cart.items[0].discount_percent.ToString(); string WebDiscAmonut = soe.discount_amount; string CardExp = cart.payment.cc_exp_month + "/1/" + cart.payment.cc_exp_year; string CardType = cart.payment.cc_type; DateTime expDate = Convert.ToDateTime(CardExp); expDate = expDate.AddMonths(1).AddDays(-1); string slpCode = "Websales"; dtORDR.Rows.Clear(); dtORDR.Rows.Add(1); dtORDR.SetValue("CreateDate", 0, Convert.ToDateTime(TransDate).ToString("yyyyMMdd")); try { dtORDR.SetValue("ShipDate", 0, Convert.ToDateTime(soe.ship_date)); } catch { dtORDR.SetValue("ShipDate", 0, Convert.ToDateTime(DateTime.Now.AddDays(1))); } try { dtORDR.SetValue("DelDate", 0, Convert.ToDateTime(soe.delivery_date)); } catch { dtORDR.SetValue("DelDate", 0, Convert.ToDateTime(DateTime.Now.Date.AddDays(1))); } dtORDR.SetValue("ShipDescr", 0, soe.shipping_description); dtORDR.SetValue("ShipAmount", 0, soe.shipping_amount); dtORDR.SetValue("CustFName", 0, soe.customer_firstname); dtORDR.SetValue("CustLName", 0, soe.customer_lastname); dtORDR.SetValue("CustEmail", 0, soe.customer_email); dtORDR.SetValue("isGuest", 0, soe.customer_is_guest); dtORDR.SetValue("CustGroup", 0, soe.customer_group_id); dtORDR.SetValue("Store", 0, soe.store_id); dtHead.SetValue("ProdType", 0, soe.items[0].product_type); dtHead.SetValue("ProdOpt", 0, soe.items[0].product_options); DateTime shipDate = DateTime.Now.AddDays(1); DateTime DeliveryDate = DateTime.Now.AddDays(1); try { shipDate = Convert.ToDateTime(soe.ship_date); } catch { } try { DeliveryDate = Convert.ToDateTime(soe.delivery_date); } catch { } string statuscomment = ""; string authTransId = ""; if (cart.payment.method == "authorizenet") { foreach (Mag.salesOrderStatusHistoryEntity status in soe.status_history) { if (status.comment == null) { continue; } if (status.comment.Contains("Authorize.Net Transaction ID")) { statuscomment = status.comment; } } int start = statuscomment.IndexOf('"'); statuscomment = statuscomment.Substring(start + 1); int len = statuscomment.IndexOf('"'); authTransId = statuscomment.Substring(0, len); } CCName = cart.payment.cc_ss_owner; // soe.payment.cc_owner; l4Digit = cart.payment.cc_last4; string strInsert = @"INSERT INTO [@B1_MORDR] ([Code] ,[Name] ,[U_CardCode] ,[U_Tel1] ,[U_Email] ,[U_Contact] ,[U_CNPhone] ,[U_CNEmail] ,[U_BName] ,[U_BStreet] ,[U_BCity] ,[U_BState] ,[U_BZip] ,[U_BPhone] ,[U_BEmail] ,[U_SName] ,[U_SStreet] ,[U_SCity] ,[U_SState] ,[U_SZip] ,[U_SPhone] ,[U_SEmail] ,[U_WEBID] ,[U_NumAtCard] ,[U_DiscCode] ,[U_CCName] ,[U_L4Dig] ,[U_AuthNetId] ,[U_CCAmnt] ,[U_MagentoID] ,[U_CCTDate] ,[U_CCExpDate] ,[U_CCType] ,[U_CCZip] ,[U_WODate] ,[U_WODiscP] ,[U_WODiscA] ,[U_DPMCreated] ,[U_WOSource] ,[U_Printed] ,[U_SlpCode] ,[U_SComp]) VALUES (@Code ,@Name ,@U_CardCode ,@U_Tel1 ,@U_Email ,@U_Contact ,@U_CNPhone ,@U_CNEmail ,@U_BName ,@U_BStreet ,@U_BCity ,@U_BState ,@U_BZip ,@U_BPhone ,@U_BEmail ,@U_SName ,@U_SStreet ,@U_SCity ,@U_SState ,@U_SZip ,@U_SPhone ,@U_SEmail ,@U_WEBID ,@U_NumAtCard ,@U_DiscCode ,@U_CCName ,@U_L4Dig ,@U_AuthNetId ,@U_CCAmnt ,@U_MagentoID ,@U_CCTDate ,@U_CCExpDate ,@U_CCType ,@U_CCZip ,@U_WODate ,@U_WODiscP ,@U_WODiscA ,@U_DPMCreated ,@U_WOSource ,@U_Printed ,@U_SlpCode ,@U_SComp )"; Hashtable hsp = new Hashtable(); hsp.Add("@Code", incrementId); hsp.Add("@Name", incrementId); hsp.Add("@U_CardCode", CCode); hsp.Add("@U_Tel1", CTel1 == null ? "" : CTel1); hsp.Add("@U_Email", CMail == null ? "" : CMail); hsp.Add("@U_Contact", Contact); hsp.Add("@U_CNPhone", CNTel == null ? "" : CNTel); hsp.Add("@U_CNEmail", CNEmail == null ? "" : CNEmail); hsp.Add("@U_BName", bName == null ? "" : bName); hsp.Add("@U_BStreet", bStreet == null ? "" : bStreet); hsp.Add("@U_BCity", bCity == null ? "" : bCity); hsp.Add("@U_BState", bState == null ? "" : bState); hsp.Add("@U_BZip", bZipCode == null ? "" : bZipCode); hsp.Add("@U_BPhone", bPhone == null ? "" : bPhone); hsp.Add("@U_BEmail", bEmail == null ? "" : bEmail); hsp.Add("@U_SName", sName == null ? "" : sName); hsp.Add("@U_SStreet", sStreet == null ? "" : sStreet); hsp.Add("@U_SCity", sCity == null ? "" : sCity); hsp.Add("@U_SState", sState == null ? "" : sState); hsp.Add("@U_SZip", sZipCode == null ? "" : sZipCode); hsp.Add("@U_SPhone", sPhone == null ? "" : sPhone); hsp.Add("@U_SEmail", sEmail == null ? "" : sEmail); hsp.Add("@U_WEBID", incrementId); hsp.Add("@U_NumAtCard", incrementId); hsp.Add("@U_DiscCode", DiscCode == null ? "" : DiscCode); hsp.Add("@U_CCName", bName == null ? "" : bName); hsp.Add("@U_L4Dig", l4Digit == null ? "" : l4Digit); hsp.Add("@U_AuthNetId", authTransId == null ? "" : authTransId); hsp.Add("@U_CCAmnt", ChargeAmount); hsp.Add("@U_MagentoID", soe.master_order_id == null ? "" : soe.master_order_id); hsp.Add("@U_CCTDate", Convert.ToDateTime(TransDate).ToShortDateString()); hsp.Add("@U_CCExpDate", expDate.Date.ToShortDateString()); hsp.Add("@U_CCType", CardType == null ? "" : CardType); hsp.Add("@U_CCZip", BillingZip == null ? "" : BillingZip); hsp.Add("@U_WODate", Convert.ToDateTime(WebOrderAt).ToShortDateString()); hsp.Add("@U_WODiscP", WebDiscP); hsp.Add("@U_WODiscA", WebDiscAmonut); hsp.Add("@U_DPMCreated", "N"); hsp.Add("@U_WOSource", "W"); hsp.Add("@U_Printed", "Y"); hsp.Add("@U_SlpCode", slpCode); hsp.Add("@U_SComp", sCompany); string orderREsult = Program.objHrmsUI.ExecQuery(strInsert, hsp, "addORDR"); int i = 0; bool shippingApplied = false; foreach (Mag.salesOrderItemEntity item in soe.items) { string stpo = soe.shipping_address.street; string[] street = soe.shipping_address.street.Split('\n'); string addr1 = ""; string addr2 = ""; if (street.Length > 0) { addr1 = street[0].ToString(); } if (street.Length > 1) { addr2 = street[1].ToString(); } string stpo2 = soe.shipping_address.street; string strStateCode = StateCode(soe.shipping_address.region); hsp.Clear(); hsp.Add("@Code", incrementId + "_" + i.ToString()); hsp.Add("@Name", incrementId + "_" + i.ToString()); hsp.Add("@U_ItemCode", item.sku); hsp.Add("@U_ItemName", item.name); hsp.Add("@U_Quantity", item.qty_ordered); hsp.Add("@U_Price", item.price); hsp.Add("@U_DiscP", item.discount_percent); hsp.Add("@U_ShipType", soe.shipping_description); hsp.Add("@U_ShipToName", sName); hsp.Add("@U_ShiptoImp", sName); hsp.Add("@U_CmpImp", sCompany); hsp.Add("@U_Addr1", addr1); hsp.Add("@U_Addr2", addr2); hsp.Add("@U_City", soe.shipping_address.city); hsp.Add("@U_State", strStateCode); hsp.Add("@U_Zipcode", sZipCode); hsp.Add("@U_Phone", sPhone); hsp.Add("@U_Email", sEmail); hsp.Add("@U_ArrDate", Convert.ToDateTime(DeliveryDate)); hsp.Add("@U_ShipDate", Convert.ToDateTime(shipDate)); hsp.Add("@U_GiftCardMsg", item.gift_message == null ? "" : item.gift_message.ToString()); hsp.Add("@U_ShiptoID", sName); string Freight1 = ""; string freightA = ""; if (!shippingApplied && Convert.ToDouble(soe.shipping_amount) > 0) { Freight1 = shipcharge; freightA = soe.shipping_amount; shippingApplied = true; } hsp.Add("@U_Freight", Freight1); hsp.Add("@U_FrAmt", freightA); hsp.Add("@U_ItemId", item.item_id); hsp.Add("@U_WEBID", soe.increment_id); hsp.Add("@U_SComp", sCompany); i++; string strRdr1Insert = @" INSERT INTO [@B1_MRDR1] ([Code] ,[Name] ,[U_ItemCode] ,[U_ItemName] ,[U_Quantity] ,[U_Price] ,[U_DiscP] ,[U_ShipType] ,[U_ShipToName] ,[U_ShiptoImp] ,[U_CmpImp] ,[U_Addr1] ,[U_Addr2] ,[U_City] ,[U_State] ,[U_Zipcode] ,[U_Phone] ,[U_Email] ,[U_ArrDate] ,[U_GiftCardMsg] ,[U_ShiptoID] ,[U_Freight] ,[U_FreightAmt] ,[U_SComp] ,[U_ItemId] ,[U_WEBID] ,[U_ShipDate]) VALUES (@Code ,@Name ,@U_ItemCode ,@U_ItemName ,@U_Quantity ,@U_Price ,@U_DiscP ,@U_ShipType ,@U_ShipToName ,@U_ShiptoImp ,@U_CmpImp ,@U_Addr1 ,@U_Addr2 ,@U_City ,@U_State ,@U_Zipcode ,@U_Phone ,@U_Email ,@U_ArrDate ,@U_GiftCardMsg ,@U_ShiptoID ,@U_Freight ,@U_FrAmt ,@U_SComp ,@U_ItemId ,@U_WEBID ,@U_ShipDate)"; string detailResult = Program.objHrmsUI.ExecQuery(strRdr1Insert, hsp, "Add Row"); } }
public override void etAfterCfl(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent) { base.etAfterCfl(ref pVal, ref BubbleEvent); SAPbouiCOM.IChooseFromListEvent oCFLEvento = (SAPbouiCOM.IChooseFromListEvent)pVal; SAPbouiCOM.DataTable dtSel = oCFLEvento.SelectedObjects; if (pVal.ItemUID == "txCode") { string CardCode = ""; string CardName = ""; if (dtSel != null && dtSel.Rows.Count > 0) { for (int i = 0; i < dtSel.Rows.Count; i++) { CardCode = dtSel.GetValue("CardCode", i).ToString(); CardName = dtSel.GetValue("CardName", i).ToString(); } // mtCus.SetLineData(pVal.Row); dtHead.Rows.Remove(0); dtHead.Rows.Add(1); dtHead.SetValue("CardCode", 0, CardCode); dtHead.SetValue("CardName", 0, CardName); AddNewCardSche(CardCode); getSchedule(); } } if (pVal.ItemUID == "txICode") { if (dtSel != null && dtSel.Rows.Count > 0) { string ItemCode = "", ItemName = ""; for (int i = 0; i < dtSel.Rows.Count; i++) { ItemCode = dtSel.GetValue("ItemCode", i).ToString(); ItemName = dtSel.GetValue("ItemName", i).ToString(); } // mtCus.SetLineData(pVal.Row); dtHead.SetValue("ItemCode", 0, ItemCode); dtHead.SetValue("ItemName", 0, ItemName); } } if (pVal.ItemUID == "txOICODE") { if (dtSel != null && dtSel.Rows.Count > 0) { string ItemCode = "", ItemName = ""; for (int i = 0; i < dtSel.Rows.Count; i++) { ItemCode = dtSel.GetValue("ItemCode", i).ToString(); ItemName = dtSel.GetValue("ItemName", i).ToString(); } // mtCus.SetLineData(pVal.Row); dtHead.SetValue("OSCNCode", 0, ItemCode); dtHead.SetValue("OSCNName", 0, ItemName); } } }