public IdentityRange GetIdentityRange(int accountType) { try { using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var query = $"SELECT * FROM AccSortCodes WHERE Code = {accountType}"; var command = new OdbcCommand(query); command.Connection = connection; using (var reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); return(new IdentityRange { Code = Convert.ToInt32(reader["Code"]), Desc = SafeConvert.ToString(reader["Desc"]), From = Convert.ToInt32(reader["From"]), To = Convert.ToInt32(reader["To"]) }); } return(null); }; } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public IEnumerable <Store> GetStores() { try { var stores = new List <Store>(); using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var query = $@"SELECT * FROM storeHDR"; var command = new OdbcCommand(query); command.Connection = connection; using (var reader = command.ExecuteReader()) { while (reader.Read()) { stores.Add(new Store { No = SafeConvert.ToInt32(reader["No"]), Name = SafeConvert.ToString(reader["Name"]) }); } } return(stores); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public void SetupForm(BLogic BL) { this.BL = BL; //this.variableTID = variableTID; UserInterfaceHelper.CenterWindow(this); UserInterfaceHelper.VisibleForms.Add(this); txtMonto.Text = SafeConvert.ToString(BL.CurrentTransaction.FoodToPay()); }
public Account GetAccount(int id) { try { using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var query = $@"SELECT * FROM Accounts WHERE AccNo = {id}"; var command = new OdbcCommand(query); command.Connection = connection; using (var reader = command.ExecuteReader()) { if (!reader.HasRows) { return(null); } reader.Read(); return(new Account { Id = Convert.ToInt32(reader["AccNo"]), ProviderId = SafeConvert.ToString(reader["AuxAccNo"]), Name = SafeConvert.ToString(reader["Name"]), Address = SafeConvert.ToString(reader["Address"]), City = SafeConvert.ToString(reader["City"]), ZipCode = SafeConvert.ToString(reader["ZipCode"]), ComercialReduc = Convert.ToSingle(reader["Reduc100"]) / 100, CreditLevel = Convert.ToSingle(reader["CreditLevel"]), Email = SafeConvert.ToString(reader["Email"]), OsekNo = SafeConvert.ToString(reader["OsekNo"]), Fax = SafeConvert.ToString(reader["Fax"]), Phone1 = SafeConvert.ToString(reader["Phone1"]), Phone2 = SafeConvert.ToString(reader["Phone2"]), SortCode1 = Convert.ToInt32(reader["SortCode1"]), SortCode2 = Convert.ToInt32(reader["SortCode2"]), SortCode3 = Convert.ToInt32(reader["SortCode34"]), SortCode4 = 0, SortCode5 = Convert.ToInt32(reader["SortCode5"]), SortCode6 = Convert.ToInt32(reader["SortCode6"]), VatFlag = SafeConvert.ToString(reader["VatFlag"]), CreatedDate = FromPervasiveDate(Convert.ToDouble(reader["Cdate"])), UpdatedDate = FromPervasiveDate(Convert.ToDouble(reader["Udate"])), RecurringPayment = Convert.ToSingle(reader["CreditDays"]), Balance = Convert.ToSingle(reader["GrandTotal"]), }); } } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public bool SetOrCreate(string sName, bool val) { bool bGood; int iInternalIndex=IndexOf(sName); if (iInternalIndex>=0) { bGood=ForceSet(iInternalIndex,sName,SafeConvert.ToString(val)); } else { bGood=ForceSet(iCount,sName,SafeConvert.ToString(val)); } return bGood; }
public static string _ToString(this object obj, string defaultValue) { string val = SafeConvert.ToString(obj); if (val == "") { return(defaultValue); } else { return(val); } }
//public static Bitmap AddWatermark( Bitmap srcBitmap, int posX, int posY, string watermarkPath, float transparency ) //{ // Bitmap destBitmap = new Bitmap ( srcBitmap.Width, srcBitmap.Height ); // using ( Graphics g = Graphics.FromImage ( destBitmap ) ) // { // //画原图 // g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High; // g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality; // g.DrawImage ( srcBitmap, 0, 0, srcBitmap.Width, srcBitmap.Height ); // //画水印图 // using ( Bitmap watermarkBitmap = new Bitmap ( System.Drawing.Image.FromFile ( watermarkPath ) ) ) // { // float [] [] ptsArray = { new float [] { 1, 0, 0, 0, 0 }, new float [] { 0, 1, 0, 0, 0 }, new float [] { 0, 0, 1, 0, 0 }, new float [] { 0, 0, 0, transparency, 0 }, new float [] { 0, 0, 0, 0, 1 } }; // ColorMatrix clrMatrix = new ColorMatrix ( ptsArray ); // ImageAttributes imgAttributes = new ImageAttributes (); // imgAttributes.SetColorMatrix ( clrMatrix, ColorMatrixFlag.Default, ColorAdjustType.Bitmap ); // g.DrawImage ( watermarkBitmap, new Rectangle ( posX, posY, watermarkBitmap.Width, watermarkBitmap.Height ), 0, 0, watermarkBitmap.Width, watermarkBitmap.Height, GraphicsUnit.Pixel, imgAttributes ); // } // } // return destBitmap; //} #endregion public static bool IsAllowedExtension(HttpPostedFile postFile) { string fileclass = string.Empty; //byte buffer; //buffer = postFile.InputStream.ReadByte(); fileclass = SafeConvert.ToString(postFile.InputStream.ReadByte()); //buffer = postFile.InputStream.ReadByte(); fileclass += SafeConvert.ToString(postFile.InputStream.ReadByte()); postFile.InputStream.Position = 0; if (fileclass == "255216" || fileclass == "7173" || fileclass == "6677" || fileclass == "13780") //说明255216是jpg;7173是gif;6677是BMP,13780是PNG;7790是exe,8297是rar { return(true); } else { return(false); } }
public QM_IQC_MIDDLE submitIQCInspectionDetailResult(IList <CV_QM_IQC_BOTTOM> list) { int i = 0, len = list.Count; int badQua = 0; DateTime now = SSGlobalConfig.Now; QM_IQC_MIDDLE middle = null; using (TransactionScope ts = new TransactionScope()) { for (i = 0; i < len; i++) { CV_QM_IQC_BOTTOM cv_bottom = list[i]; if (cv_bottom.SingleResult.Equals("NG")) { badQua++; } QM_IQC_BOTTOM tmp = new QM_IQC_BOTTOM() { KID = cv_bottom.KID, Value = cv_bottom.Value, SingleResult = cv_bottom.SingleResult, Abnormality = cv_bottom.AbnormalityCode, Reason = cv_bottom.CauseCode }; iqc_bottom_bo.UpdateSome(tmp); } //更新中表 middle = new QM_IQC_MIDDLE() { MGuid = list[0].MGuid, ItemResult = badQua == 0 ? "OK" : "NG", AcceptQua = SafeConvert.ToString(len - badQua), BadQua = SafeConvert.ToString(badQua), ItemStatus = "已检", ItemDate = now }; iqc_middle_bo.UpdateSome(middle); ts.Complete(); } return(middle); }
/// <summary> /// MES 发送邮件 /// </summary> /// <param name="em">事件模块</param> /// <param name="brief">邮件标题</param> /// <param name="content">邮件内容</param> public void Send(string em, string brief, string content, string attachments, string optor) { CV_PM_ALT_EVENT_TYPE type = _CV_PM_ALT_EVENT_TYPEBO.GetEntity(SafeConvert.ToString(em)); try { PM_ALT_EVENT_LOG log = new PM_ALT_EVENT_LOG { EventLogID = Guid.NewGuid(), CreatedBy = optor, CreatedOn = SSGlobalConfig.Now, EventBrief = string.Format(type.EventBrief, brief), EventContent = string.Format(type.EventContent, brief, content), Attachments = attachments, EventTypeID = type.EventTypeID, IsFinished = false, NotifiedCnt = 0 }; this.Insert(log); } catch { PM_ALT_EVENT_LOG log = new PM_ALT_EVENT_LOG { EventLogID = Guid.NewGuid(), CreatedBy = optor, CreatedOn = SSGlobalConfig.Now, EventBrief = string.Format(brief), EventContent = string.Format(content), Attachments = attachments, EventTypeID = type.EventTypeID, IsFinished = false, NotifiedCnt = 0 }; this.Insert(log); } }
public IEnumerable <ItemBarcode> GetBarcodes() { try { var barcodes = new List <ItemBarcode>(); using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var query = $@" SELECT * FROM BARCODES "; var command = new OdbcCommand(query); command.Connection = connection; using (var reader = command.ExecuteReader()) while (reader.Read()) { barcodes.Add(new ItemBarcode { ItemId = SafeConvert.ToString(reader["ItemNo"]), Barcode = SafeConvert.ToString(reader["Barcode"]), Notes = SafeConvert.ToString(reader["Remarks"]) }); } return(barcodes); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public static string _ToString(this object obj) { return(SafeConvert.ToString(obj)); }
private void CreditoForm_Load(object sender, EventArgs e) { txtMonto.Text = SafeConvert.ToString(BL.CurrentTransaction.FoodToPay()); }
public void Log(HttpRequestBase request, string info = "", long executionTime = 0) { var log = new LogItem(); var req = request; if (req != null) { log.IP = req.GetClientIpAddress(); if (req.UrlReferrer != null) { log.Referer = req.UrlReferrer.OriginalString; } var sb = new StringBuilder(); var count = 0; foreach (var name in req.Cookies) { var cookie = req.Cookies[name.ToString()]; if (cookie != null) { sb.Append((count == 0 ? "" : ",") + SafeClrConvert.ToString(cookie.Name) + "=" + cookie.Value); count++; } } log.Cookies = sb.ToString(); log.Method = req.HttpMethod; log.HostName = req.UserHostName; if (req.Url != null) { log.Url = req.Url.ToString(); } log.FormData = req.Form.Join(); log.Headers = req.Headers.Join(new List <string> { "cookie" }); if (string.Compare(req.HttpMethod, "post", true) == 0) { try { using (var receiveStream = req.InputStream) { using (var readStream = new StreamReader(receiveStream, Encoding.UTF8)) { log.Body = readStream.ReadToEnd(); } if (string.IsNullOrEmpty(log.Body)) { //body = req. } } } catch (Exception ex2) { log.Body = "DefaultRequestLogger.Log: " + ex2.Message; } } if (req.Browser != null) { log.Browser = req.Browser.Type + " " + req.Browser.Version; } try { var constrKey = ConfigurationManager.AppSettings["ActiveCnn"] ?? "ConStr"; var constr = ConfigurationManager.ConnectionStrings[constrKey].ConnectionString; if (!string.IsNullOrEmpty(constr)) { using (var con = new SqlConnection(constr)) { using (var cmd = new SqlCommand("usp1_log_request", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Browser", log.Browser); cmd.Parameters.AddWithValue("@IP", log.IP); cmd.Parameters.AddWithValue("@HostName", log.HostName); cmd.Parameters.AddWithValue("@Method", log.Method); cmd.Parameters.AddWithValue("@Url", log.Url); cmd.Parameters.AddWithValue("@Body", log.Body); cmd.Parameters.AddWithValue("@FormData", log.FormData); cmd.Parameters.AddWithValue("@Cookies", log.Cookies); cmd.Parameters.AddWithValue("@Headers", log.Headers); cmd.Parameters.AddWithValue("@Referer", log.Headers); cmd.Parameters.AddWithValue("@Info", SafeConvert.ToString(info).Left(500)); cmd.Parameters.AddWithValue("@ExecutionTime", executionTime); con.Open(); cmd.ExecuteNonQuery(); } } } else { _memoryLogger.Log(JsonConvert.SerializeObject(log)); } } catch (Exception _ex) { _memoryLogger.Log(_ex.Message + ": " + JsonConvert.SerializeObject(log)); } } }
}//FINISH PM_OnSerializeToDbTransItemInElement //ANTES DEL CIERRE DE LA TRANSACCION void PM_OnBeforeCloseTransaction(Transaction transaction, ref bool abort) { //throw new NotImplementedException(); // ARROJA ERROR SI EL SERVICIO NO ESTA DISPONIBLE if (webservice == null) { abort = true; BL.MsgError("WEBSERVICE NO COMUNICATION"); return; } else { string printoutType = ""; if (transaction.ManualPrintoutSelected == DbPayment.PrintoutType.KeepDefault || transaction.ManualPrintoutSelected == DbPayment.PrintoutType.NoPrintout) { printoutType = "39"; } if (transaction.ManualPrintoutSelected == DbPayment.PrintoutType.Invoice) { printoutType = "33"; } if (transaction.ManualPrintoutSelected == DbPayment.PrintoutType.Bill) { printoutType = "39"; } if (transaction.ManualPrintoutSelected == DbPayment.PrintoutType.Invoice && transaction.Customer == null) { BL.MsgError("WE NEED A CUSTOMER"); abort = true; return; } //string xmlData = ""; //string documentType = ""; DbCustomer receptorDTE = new DbCustomer(); receptorDTE = customer; XmlStringWriter writer = new XmlStringWriter(BL.DB); writer.WriteRaw(@"<?xml version=""1.0"" encoding=""ISO-8859-1""?>"); if (printoutType == "33")//FACTURA { //INICIO DTE writer.WriteStartElement("DTE"); writer.WriteAttribute("version", "1.0"); writer.WriteAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance"); writer.WriteAttribute("xmlns:xsd", "http://www.w3.org/2001/XMLSchema"); writer.WriteAttribute("xmlns", "http://www.sii.cl/SiiDte"); //FIN DTE } else//BOLETA { //INICIO EnvioBOLETA writer.WriteStartElement("EnvioBOLETA"); writer.WriteAttribute("version", "1.0"); writer.WriteAttribute("xmlns", "http://www.sii.cl/SiiDte"); writer.WriteAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance"); writer.WriteAttribute("xsi:schemaLocation", "http://www.sii.cl/SiiDte EnvioBOLETA_v11.xsd"); //FIN EnvioBoleta } //RUT RECEPTOR string rrecep; rrecep = getRutReceptorDTE(); //RUT RECEPTOR if (printoutType == "39")//BOLETA { //ONLY BOLETA writer.WriteStartElement("SetDTE"); writer.WriteAttribute("ID", string.Format("ENVBOL-{0}", transaction.TransDate.ToString("yyyyMMddHHmmss"))); writer.WriteStartElement("Caratula"); writer.WriteAttribute("version", "1.0"); //string shopRut = BL.DB.Shop["rut"].ToString(); //string shopRut = "76328464-6"; string shopRut = dataEmisor.RutBoleta; writer.WriteElement("RutEmisor", shopRut); //string RutEnvia = BL.DB.Shop["RutEnvia"].ToString(); //string RutEnvia = "8833649-6"; string RutEnvia = dataEmisor.RutRepLegal; writer.WriteElement("RutEnvia", RutEnvia); //string RutReceptor = BL.DB.Shop["RutReceptor"].ToString(); //string RutReceptor = "66666666-6"; writer.WriteElement("RutReceptor", rrecep); //DateTime FchResol = Convert.ToDateTime(BL.DB.Shop["FchResol"]); //DateTime FchResol = new DateTime(2014, 04, 22); DateTime FchResol = (dataEmisor.ResolDate); writer.WriteElement("FchResol", FchResol.ToString("yyyy-MM-dd")); //writer.WriteElement("NroResol", 0); writer.WriteElement("NroResol", dataEmisor.NumResol); writer.WriteElement("TmstFirmaEnv", DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss")); writer.WriteStartElement("SubTotDTE"); writer.WriteElement("TpoDTE", printoutType); writer.WriteElement("NroDTE", 1); writer.WriteEndElement(); writer.WriteEndElement(); writer.WriteStartElement("DTE"); writer.WriteAttribute("version", "1.0"); //END ONLY BOLETA } //string besRut = "76054473-6"; //MANAGE THIS FROM DB ON FRONTEND dataEmisor.Rut // string besRut = dataEmisor.Rut; if (printoutType == "39") { //ONLY BOLETA writer.WriteStartElement("Documento"); //string besRut = myClassPAramData["besRUT"].ToString(); string besRutBoletaE = dataEmisor.RutBoleta; solicitarFolio = webservice.Solicitar_Folio(besRutBoletaE, 39); writer.WriteAttribute("ID", string.Format("R{0}T{1}F{2}", besRutBoletaE, printoutType, solicitarFolio.Folio)); //END ONLY BOLETA } else { solicitarFolio = webservice.Solicitar_Folio(besRut, 33); writer.WriteStartElement("Documento"); } writer.WriteStartElement("Encabezado"); writer.WriteStartElement("IdDoc"); writer.WriteElement("TipoDTE", printoutType); writer.WriteElement("Folio", solicitarFolio.Folio); writer.WriteElement("FchEmis", DateTime.Now.ToString("yyyy-MM-dd")); if (printoutType == "39") { //SOLO BOLETA writer.WriteElement("IndServicio", 3); //SOLO BOLETA } else { //TermPagoGlosa //FchVenc writer.WriteElement("TermPagoGlosa", "30 dias Precio Contado"); ///////////////////////////////////////////ASK 4 THIS FIELD writer.WriteElement("FchVenc", "2016-06-30"); /////////////////////////////////////////////////////////////ASK 4 THIS FIELD } writer.WriteEndElement(); //IdDoc //FIN DATOS EMISOR if (printoutType == "39") { writer.WriteStartElement("Emisor"); writer.WriteElement("RUTEmisor", dataEmisor.Rut); writer.WriteElement("RznSocEmisor", dataEmisor.RazonEmisor); writer.WriteElement("GiroEmisor", dataEmisor.GiroEmisor); writer.WriteElement("CdgSIISucur", dataEmisor.CodigoSII); writer.WriteElement("DirOrigen", dataEmisor.DireccionEm); writer.WriteElement("CmnaOrigen", dataEmisor.ComunaEm); writer.WriteElement("CiudadOrigen", dataEmisor.CiudadEm); writer.WriteEndElement(); //Emisor } else { writer.WriteStartElement("Emisor"); //<Acteco>602300</Acteco> writer.WriteElement("Acteco", dataEmisor.ActEco); writer.WriteElement("RUTEmisor", dataEmisor.Rut); writer.WriteElement("RznSoc", dataEmisor.RazonEmisor); writer.WriteElement("GiroEmis", dataEmisor.GiroEmisor); writer.WriteElement("DirOrigen", dataEmisor.DireccionEm); writer.WriteElement("CmnaOrigen", dataEmisor.ComunaEm); writer.WriteElement("CiudadOrigen", dataEmisor.CiudadEm); writer.WriteElement("CdgVendedor", BL.CurrentOperator.Code); writer.WriteEndElement(); //Emisor } //OBJETO RECEPTOR DbCustomer receptorC = BL.DB.GetCustomerByCardNum((rrecep.Replace("-", "")), false); //OBJETO RECEPTOR writer.WriteStartElement("Receptor"); writer.WriteElement("RUTRecep", rrecep); if (printoutType == "33")//FACTURA { //<CdgIntRecep>76124037C</CdgIntRecep> writer.WriteElement("CdgIntRecep", getCodeIntRecep(rrecep)); writer.WriteElement("RznSocRecep", receptorC.C_o); //<GiroRecep>VENTA AL POR MAYOR DE OTROS PRODUCTOS N.</GiroRecep> writer.WriteElement("GiroRecep", receptorC.C_o); writer.WriteElement("DirRecep", receptorC.Street); writer.WriteElement("CmnaRecep", receptorC.Notes1); writer.WriteElement("CiudadRecep", receptorC.City); writer.WriteEndElement(); //Receptor } else//BOLETA { writer.WriteElement("RznSocRecep", null); writer.WriteElement("Contacto", null);//ASK NUM TELEFONO writer.WriteElement("DirRecep", null); writer.WriteElement("CmnaRecep", null); writer.WriteElement("CiudadRecep", null); writer.WriteElement("DirPostal", null); writer.WriteElement("CmnaPostal", null); writer.WriteElement("CiudadPostal", null); writer.WriteEndElement(); //Receptor } writer.WriteStartElement("Totales"); if (printoutType == "33")//FACTURA { double monto, neto, iva; string netoS, ivaS; monto = SafeConvert.ToInt32(transaction.Total); neto = monto * 0.81; iva = monto - neto; netoS = SafeConvert.ToString(neto); ivaS = SafeConvert.ToString(iva); writer.WriteElement("TpoMoneda", "PESO CL"); writer.WriteElement("MntNeto", netoS); writer.WriteElement("TasaIVA", "19.00"); writer.WriteElement("IVA", ivaS); } writer.WriteElement("MntTotal", SafeConvert.ToInt32(transaction.Total)); writer.WriteEndElement(); //Totales writer.WriteEndElement(); //Encabezado int position = 1; foreach (TransArticle art in transaction.GetItems <TransArticle>()) { writer.WriteStartElement("Detalle"); writer.WriteElement("NroLinDet", position); writer.WriteStartElement("CdgItem"); writer.WriteElement("TpoCodigo", "Interna"); writer.WriteElement("VlrCodigo", art.Data.Code); writer.WriteEndElement(); //CdgItem writer.WriteElement("NmbItem", art.Data.Description); if (printoutType == "33") { writer.WriteElement("DscItem", art.Data.Description); } writer.WriteElement("QtyItem", art.Data.MeasureUnit == DbArticle.Units.Pieces ? art.Quantity : 1); //writer.WriteElement("QtyItem", 1); writer.WriteElement("UnmdItem", null); writer.WriteElement("PrcItem", art.UnitPrice); //writer.WriteElement("MontoItem", art.TotalPrice); string totalprice = art.TotalPrice.ToString(); totalprice = totalprice.Replace(".00", ""); writer.WriteElement("MontoItem", totalprice); writer.WriteEndElement(); //Detalle position++; } writer.WriteEndElement(); //Documento writer.WriteEndElement(); //DTE if (printoutType == "39") { writer.WriteEndElement(); //SetDTE writer.WriteEndElement(); //EnvioBOLETA || DTE } string xmlString = writer.ToString(); if (printoutType == "33") { resultProcesarTXTDTE = webservice.Carga_TXTDTE(xmlString, "XML"); } else { resultProcesarTXTBoleta = webservice.Carga_TXTBoleta(xmlString, "XML"); } string fob; if (printoutType == "33") { fob = "Factura"; } else { fob = "Boleta"; } if (dataEmisor.SaveXML == 1) { //SAVE TO FILE XML string path = Path.GetPathRoot(Environment.SystemDirectory); System.IO.Directory.CreateDirectory("C:\\xmlTCPOS"); //System.IO.File.WriteAllText(@"C:\xmlTCPOS\" + fob + "" + DateTime.Now.ToString("yyyyMMddHHmm") + ".xml", xmlString); System.IO.File.WriteAllText(@"" + path + "xmlTCPOS\\" + fob + "" + DateTime.Now.ToString("yyyyMMddHHmm") + ".xml", xmlString); //END SAVE TO FILE XML } if (printoutType == "33") { if (resultProcesarTXTDTE.XML != "") { XmlDocument doc = new XmlDocument(); doc.LoadXml(resultProcesarTXTDTE.XML); XmlElement root = doc.DocumentElement; if (root == null) { abort = true; throw new Exception("XML BAD FORMAT"); } XmlNodeList SignatureValue = root.GetElementsByTagName("TED"); string signature = ""; foreach (XmlNode tableNode in SignatureValue) { signature = tableNode.InnerXml; } if (signature != "") { signature = string.Format("<TED version=\"1.0\">" + signature + "</TED>"); } transaction.SetCustomField("webservice_bes_signature", signature); transaction.SetCustomField("dte_doc_type", printoutType); XmlNodeList folioNUMValue = root.GetElementsByTagName("F"); string folioNUM = ""; foreach (XmlNode tableNode in folioNUMValue) { folioNUM = tableNode.InnerXml; } if (folioNUM != "") { folioNUM = string.Format("" + folioNUM + ""); } transaction.SetCustomField("webservice_bes_folionum", folioNUM); //GUARDA FOLIO 2 PRINT if (folioNUM != "") { transaction.SetCustomField("bes_folio_num", folioNUM); } //END GUARDA FOLIO 2 PRINT //PRINT TIPO DOC transaction.SetCustomField("tipo_documento", "FACTURA ELECTRONICA"); //END PRINT TIPO DOC } else { abort = true; BL.MsgError("No answer from webservice,\nelectronic invoice cannot be accepted\nPlease use another type of document"); } } else { //if response from webservice read xml response and get the signature, save it into transaction and print signature if (resultProcesarTXTBoleta.XML != "") { XmlDocument doc = new XmlDocument(); doc.LoadXml(resultProcesarTXTBoleta.XML); XmlElement root = doc.DocumentElement; if (root == null) { abort = true; throw new Exception("XML BAD FORMAT"); } //OBTENER TED Y GUARDAR XmlNodeList SignatureValue = root.GetElementsByTagName("TED"); string signature = ""; foreach (XmlNode tableNode in SignatureValue) { signature = tableNode.InnerXml; } if (signature != "") { signature = string.Format("<TED version=\"1.0\">" + signature + "</TED>"); } transaction.SetCustomField("webservice_bes_signature", signature); transaction.SetCustomField("dte_doc_type", printoutType); //FIN OBTENER TED Y GUARDAR //OBTENER FOLIONUM Y GUARDAR XmlNodeList folioNUMValue = root.GetElementsByTagName("F"); string folioNUM = ""; foreach (XmlNode tableNode in folioNUMValue) { folioNUM = tableNode.InnerXml; } if (folioNUM != "") { folioNUM = string.Format("" + folioNUM + ""); } transaction.SetCustomField("webservice_bes_folionum", folioNUM); //FIN FOLIONUM Y GUARDAR //GUARDA FOLIO 2 PRINT if (folioNUM != "") { transaction.SetCustomField("bes_folio_num", folioNUM); } //END GUARDA FOLIO 2 PRINT transaction.SetCustomField("tipo_documento", "BOLETA ELECTRONICA"); } else { abort = true; BL.MsgError("No answer from webservice,\nelectronic invoice cannot be accepted\nPlease use another type of document"); } } } }//FINISH PM_OnBeforeCloseTransaction
public static string _UrlEncodeByGB2312(this object obj) { return(System.Web.HttpUtility.UrlEncode(SafeConvert.ToString(obj), Encoding.GetEncoding("gb2312"))); }
}//FINISH PM_OnProcessUnknownIniParameter private void consultaCliente() { //if (true) // return; if (BL.CurrentTransaction != null && BL.CurrentTransaction.Customer == null) { //USING FORM using (RutForm rutForm = new RutForm()) { rutForm.SetupForm(BL); rutForm.Focus(); if (rutForm.ShowDialog() == DialogResult.OK) { rut = rutForm.txtRut.Text; if (validaRut(rut)) { //BL.MsgInfo("RUT VALIDO"); } else { BL.MsgInfo("RUT NO VALIDO"); return; } } else { customer = new DbCustomer(); } } //END USING FOMR KeypadParameters param = new KeypadParameters(""); //KeypadResult result; if (rut == null) { return; } rut = parseRUT(rut); string myCustomer = SafeConvert.ToString(BL.DB.CentralDbExecuteScalar("SELECT card_num FROM customers WHERE card_num = " + SqlHelper.Quote(rut))); customer = null; if (myCustomer != "") { customer = BL.DB.GetCustomerByCardNum(myCustomer, false); } if (customer == null) { customer = BL.DB.GetCustomerByCardNum(rut, false); } if (customer != null) { BL.AddCustomer(null, customer.CardNum, true); BL.RefreshTransactionItems(); } else { if (BL.MsgQuestion("Cliente no exite, deseas crearlo?", 5) == true) { //INICIO FORMULARIO NUEVO CLIENTE BL.MsgWarning("Has Decidido Guardar al Cliente"); using (NewCustomerForm customerForm = new NewCustomerForm()) { customerForm.SetupForm(BL, rut); customerForm.Focus(); if (customerForm.ShowDialog() == DialogResult.OK) { } } //FIN INGRESO FORMULARIO NUEVO CLIENTE } else { BL.MsgInfo("Has Decidido NO guardar al Cliente"); return; } } } }
public string strictWMSHut(QM_PROCESS_TOP param) { //获得该加严单已选的入库箱号 IList <QM_PROCESS_HUT> processHutList = getSequenceHut(param.Sequence); if (processHutList == null || processHutList.Count == 0) { return("尚未选择箱号"); } else { Inspection insInfo = new Inspection() { SESSIONID = SafeConvert.ToString(Guid.NewGuid()), QAORDERTYPE = param.Source == 5 ? "2" : "3", //质检来源 PRUEFLOS = param.Sequence, //检验批号 //MATNR 物料编码,MBLNR 物料凭证号,MJAHR 物料凭证年份 MATNR = param.MaterielID, MBLNR = "", MJAHR = "", LOSMENGE = param.SampleQua.Value, //抽样数量 WERKS = param.PlantID, //工厂编码 HutID = new List <InspectionHut>() //箱号 }; int i = 0, cnt = processHutList.Count; for (i = 0; i < cnt; i++) { insInfo.HutID.Add(new InspectionHut() { HutID = processHutList[i].HutID }); //箱号 } RetuenInspection rt = null; try { rt = api_wmsbo.strictWMSHut(insInfo); } catch (Exception ex) { return("调用WMS接口失败:" + ex.Message); } //rt = JsonConvert.DeserializeObject<RetuenInspection>("{\"Success\":true,\"Message\":\"成功\",\"PRUEFLOS\":\"FQC20180530006-01\",\"HutID\":[{\"HutID\":\"12000022\"},{\"HutID\":\"12000035\"}]}"); if (!rt.Success) { return("WMS回传信息:" + rt.Message); } else { for (i = 0; i < rt.HutID.Count; i++) { string cmd_updateHutSql = string.Format(CultureInfo.InvariantCulture, updateHutSql, rt.PRUEFLOS, rt.HutID[i].HutID); bsc_bo.ExecuteNonQueryBySql(cmd_updateHutSql); } //更新状态 param.SequenceStatus = "待检"; process_topbo.UpdateSome(param); return(""); } } }
public IEnumerable <Account> Find(AccountSearchParams searchParams) { try { var accounts = new List <Account>(); using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var query = $@" SELECT * FROM Accounts WHERE ({searchParams.AccountId} <= 0 OR AccNo = {searchParams.AccountId}) AND ('{searchParams.OsekNo ?? ""}' = '' OR OsekNo = '{searchParams.OsekNo}') AND ({searchParams.AccountType} <= 0 OR (AccNo BETWEEN {searchParams.IdentityRange?.From ?? 0} AND {searchParams.IdentityRange?.To ?? 0})) AND ({ PervasiveDBHelper.ToPervasiveDate(searchParams.FromUpdateDate)} <= 0 OR Udate >= { PervasiveDBHelper.ToPervasiveDate(searchParams.FromUpdateDate)}) ORDER BY Udate DESC "; var command = new OdbcCommand(query); command.Connection = connection; using (var reader = command.ExecuteReader()) { while (reader.Read()) { accounts.Add(new Account { Id = Convert.ToInt32(reader["AccNo"]), ProviderId = SafeConvert.ToString(reader["AuxAccNo"]), Name = SafeConvert.ToString(reader["Name"]), Address = SafeConvert.ToString(reader["Address"]), City = SafeConvert.ToString(reader["City"]), ZipCode = SafeConvert.ToString(reader["ZipCode"]), ComercialReduc = Convert.ToSingle(reader["Reduc100"]) / 100, CreditLevel = Convert.ToSingle(reader["CreditLevel"]), Email = SafeConvert.ToString(reader["Email"]), OsekNo = SafeConvert.ToString(reader["OsekNo"]), Fax = SafeConvert.ToString(reader["Fax"]), Phone1 = SafeConvert.ToString(reader["Phone1"]), Phone2 = SafeConvert.ToString(reader["Phone2"]), SortCode1 = Convert.ToInt32(reader["SortCode1"]), SortCode2 = Convert.ToInt32(reader["SortCode2"]), SortCode3 = Convert.ToInt32(reader["SortCode34"]), SortCode4 = 0, SortCode5 = Convert.ToInt32(reader["SortCode5"]), SortCode6 = Convert.ToInt32(reader["SortCode6"]), VatFlag = SafeConvert.ToString(reader["VatFlag"]), CreatedDate = FromPervasiveDate(Convert.ToDouble(reader["Cdate"])), UpdatedDate = FromPervasiveDate(Convert.ToDouble(reader["Udate"])) }); } } return(accounts); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public static string _UrlEncodeByUTF8(this object obj) { return(System.Web.HttpUtility.UrlEncode(SafeConvert.ToString(obj), Encoding.UTF8)); }
public IEnumerable <Item> Find(ItemSearchParams searchParams) { var hasSiteSync = this.IsColumnExists($"Items", "SITESYNC"); var hasKupaSync = this.IsColumnExists($"Items", "KUPASYNC"); var hasUpdDate = this.IsColumnExists($"Items", "UitemDate"); try { var items = new List <Item>(); // ignore tables search with updated-date filter but no updated-date column // to prevent receiving incorrect data var hasUpdDateFilter = searchParams.FromUpdateDate.HasValue || searchParams.ToUpdateDate.HasValue; if (searchParams.PauseIfNoUpdateDateColumn && !hasUpdDate && hasUpdDateFilter) { return(items); } using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var query = $@" SELECT * FROM Items WHERE ('{searchParams.ItemId ?? ""}' = '' OR ItemNo = '{searchParams.ItemId}') AND ('{searchParams.Barcode ?? ""}' = '' OR Barcode = '{searchParams.Barcode}') AND ({searchParams.SortCode} = 0 OR SortCode1 = {searchParams.SortCode} OR SortCode2 = {searchParams.SortCode} OR SortCode3 = {searchParams.SortCode}) "; /// AND (totqty >= {searchParams.QtyInStock}) if (searchParams.IsBlocked.HasValue) { query += $"AND(TITLE {(searchParams.IsBlocked.Value ? "=" : "<>")} '{ SafeConvert.ToPervasiveString("כ")}') "; } if (hasSiteSync) { query += $"AND SITESYNC = {(searchParams.SyncToSite ? 1 : 0)} "; } if (hasKupaSync) { query += $"AND KUPASYNC = {(searchParams.SyncToFunds ? 1 : 0)} "; } if (hasUpdDate) { query += $@" AND({ PervasiveDBHelper.ToPervasiveDate(searchParams.FromUpdateDate)} <= 0 OR UitemDate >= { PervasiveDBHelper.ToPervasiveDate(searchParams.FromUpdateDate)}) AND({ PervasiveDBHelper.ToPervasiveDate(searchParams.ToUpdateDate)} <= 0 OR UitemDate <= { PervasiveDBHelper.ToPervasiveDate(searchParams.ToUpdateDate)}) "; } query += "ORDER BY ItemNo DESC"; var command = new OdbcCommand(query); command.Connection = connection; /// throw new Exception(query); using (var reader = command.ExecuteReader()) { while (reader.Read()) { items.Add(new Item { Id = SafeConvert.ToString(reader["ItemNo"]), ItemNameHE = SafeConvert.ToString(reader["ItemName"]), ItemNameEN = SafeConvert.ToString(reader["Ename"]), Barcode = SafeConvert.ToString(reader["Barcode"]), Characteristic1 = SafeConvert.ToString(reader["ifun1"]), Characteristic2 = SafeConvert.ToString(reader["ifun2"]), CurrencyCode1 = SafeConvert.ToInt32(reader["FC1"]), CurrencyCode2 = SafeConvert.ToInt32(reader["FC2"]), CurrencyCode3 = SafeConvert.ToInt32(reader["FC3"]), CurrencyCode4 = SafeConvert.ToInt32(reader["FC4"]), CurrencyCode5 = SafeConvert.ToInt32(reader["FC5"]), CurrencyCode6 = SafeConvert.ToInt32(reader["FC6"]), CurrencyCode7 = SafeConvert.ToInt32(reader["FC7"]), CurrencyCode8 = SafeConvert.ToInt32(reader["FC8"]), CurrencyCode9 = SafeConvert.ToInt32(reader["FC9"]), CurrencyCode10 = SafeConvert.ToInt32(reader["FC10"]), Price1 = SafeConvert.ToSingle(reader["Prc1"]), Price2 = SafeConvert.ToSingle(reader["Prc2"]), Price3 = SafeConvert.ToSingle(reader["Prc3"]), Price4 = SafeConvert.ToSingle(reader["Prc4"]), Price5 = SafeConvert.ToSingle(reader["Prc5"]), Price6 = SafeConvert.ToSingle(reader["Prc6"]), Price7 = SafeConvert.ToSingle(reader["Prc7"]), Price8 = SafeConvert.ToSingle(reader["Prc8"]), Price9 = SafeConvert.ToSingle(reader["Prc9"]), Price10 = SafeConvert.ToSingle(reader["Prc10"]), SortCode1 = SafeConvert.ToInt32(reader["SortCode1"]), SortCode2 = SafeConvert.ToInt32(reader["SortCode2"]), SortCode3 = SafeConvert.ToInt32(reader["SortCode3"]), SupplerId1 = SafeConvert.ToInt32(reader["Supl1"]), SupplerId2 = SafeConvert.ToInt32(reader["Supl2"]), SupplerId3 = SafeConvert.ToInt32(reader["Supl3"]), SupplerId4 = SafeConvert.ToInt32(reader["Supl4"]), Unit = SafeConvert.ToString(reader["Unit"]), ///QtyInStock = SafeConvert.ToSingle(reader["totqty"]), VatFlag = SafeConvert.ToBoolean(reader["Patur"]), SyncToSite = SafeConvert.ToBoolean(reader.ReadOrDefault <bool>("SITESYNC")), SyncToFunds = SafeConvert.ToBoolean(reader.ReadOrDefault <bool>("KUPASYNC")), IsBlocked = SafeConvert.ToBoolean(reader["TITLE"]), UpdatedDate = FromPervasiveDate(Convert.ToDouble(reader.ReadOrDefault <double>("UitemDate"))), ProviderId = 0 }); } } return(items); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }