public override async Task <bool> process() { var _xconn = xmlMsgIn.Data.Element("connection"); //get the connection data var _parameters = xmlMsgIn.Data.Element("parameterCollection").Elements("parameter"); //get the parameters list string _dataBase = _xconn.Element("DataBase").Value.ToString(); //get the database string _procedureName = xmlMsgIn.Data.Element("procedureName").Value.ToString(); // get the procedure name var _server = new cServer(_xconn.Element("server")); //create the server object from the connection data try { using (var _conn = new cAccesoDatosNet(_server, _dataBase)) //create the normal connection using (var _sp = new SP(_conn, _procedureName)) // create the normal SP { _parameters.ToList().ForEach(p => { _sp.AddParameterValue(p.Element("parameterName").Value.ToString(), p.Element("parameterValue").Value.ToString()); }); //adds the parameters and the values to the sp from the parameter list await _sp.ExecuteAsync(); //execute the sp if (_sp.LastMsg.Substring(0, 2) != "OK") { throw new Exception(_sp.LastMsg); //error message } XElement _msgOut = new XElement("result"); //create the msgout xml data _msgOut.Add(_sp.XOutParameters.Root); //adds the out parameters to the data xmlMsgOut = new XDocument(_msgOut); // returns } } catch (Exception ex) { xmlMsgOut = new XDocument(new XElement("result", "ERROR: " + ex.Message)); } MsgOut = xmlMsgOut.ToString(); return(true); }
public override async Task <bool> process() { var _xconn = xmlMsgIn.Data.Element("connection"); //get the connection data string _dataBase = _xconn.Element("DataBase").Value.ToString(); //get the database var _server = new cServer(_xconn.Element("server")); //create the server object from the connection data string _sql = xmlMsgIn.Data.Element("sql").Value.ToString(); //get the sql using (var _conn = new cAccesoDatosNet(_server, _dataBase)) //create the normal connection using (var _rs = new DynamicRS(_sql, _conn)) // create the normal recordset { try { await _rs.OpenAsync(); //execute the recordset xmlMsgOut = _rs.XMLData; //create the msgout xml data xmlMsgOut.Root.Name = "result"; } catch (Exception ex) { xmlMsgOut = XDocument.Parse((new XElement("result", "ERROR: " + ex.Message)).ToString()); //returns error } } MsgOut = xmlMsgOut.ToString(); return(true); }
private void btnPrint_Click(object sender, EventArgs e) { if (MessageBox.Show(string.Format("This will print {0} unit labels. Are you sure?", txtQty.Text), "SIMPLISTICA", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int _labelInit = 0; txtPrinter.Text = Values.LabelPrinterAddress.ToString(); using (var _conn = new cAccesoDatosNet(Values.gDatos.Server, "REPAIRS", Values.gDatos.User, Values.gDatos.Password)) using (var _sp = new SP(_conn, "pGetContador")) { _sp.AddParameterValue("@Contador", ""); _sp.AddParameterValue("@Serv", ""); _sp.AddParameterValue("@Codigo", cboService.Value + "_UNIT_ETIQ"); _sp.AddParameterValue("@Incremento", Convert.ToInt32(txtQty.Value)); _sp.Execute(); _labelInit = Convert.ToInt32(_sp.ReturnValues()["@Contador"]); } if (txtCharacter.Text == "") { throw (new Exception("Wrong character for labels.")); } string _printerAddress = ""; int _printerResolution = 0; using (var _RS = new DynamicRS(string.Format("select descripcion,cmp_varchar,cmp_integer from ETIQUETAS..datosEmpresa where codigo='{0}'", Values.LabelPrinterAddress), Values.gDatos)) { _RS.Open(); _printerAddress = _RS["cmp_varchar"].ToString(); _printerResolution = Convert.ToInt32(_RS["cmp_integer"]); //_printerType = _RS["descripcion"].ToString().Split('|')[0]; } var _label = new ZPLLabel(70, 32, 3, _printerResolution); var _unitLabel = new SingleBarcode(_label); //_label.addLine(35, 3, 0, "C", "", "[BC][UNITNUMBER]", 0, 2.5F, 1,true); //var _param = new Dictionary<string, string>(); using (var _printer = new cRawPrinterHelper(_printerAddress)) { var _delimiterLabel = new ZPLLabel(_unitLabel.Label.width, _unitLabel.Label.height, 3, _unitLabel.Label.dpi); delimiterLabel.delim(_delimiterLabel, "START UNIT LABELS", "-"); _printer.SendUTF8StringToPrinter(_delimiterLabel.ToString(), 1); //for (var i = _labelInit; i < _labelInit + Convert.ToInt32(txtQty.Value); i++) for (var i = _labelInit + Convert.ToInt32(txtQty.Value) - 1; i >= _labelInit; i--) { _unitLabel.Parameters["VALUE"] = txtCharacter.Text + i.ToString().PadLeft(8, '0'); for (var j = 0; j < Convert.ToInt32(txtQtyLabel.Text); j++) { _printer.SendUTF8StringToPrinter(_unitLabel.ToString(), 1); } } delimiterLabel.delim(_delimiterLabel, "END UNIT LABLES", "-"); _printer.SendUTF8StringToPrinter(_delimiterLabel.ToString(), 1); } } }
// Add the results of a query to the current area public bool AddQuery(string pSQL, cAccesoDatosNet pConn, EspackFont pFont = null, bool pHideTitles = false) { using (var _rs = new DynamicRS(pSQL, pConn)) { _rs.Open(); if (_rs.RecordCount == 0) { MessageBox.Show("The query returned no data.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else { Dictionary <string, List <string> > _matrix = new Dictionary <string, List <string> >(); foreach (var _item in _rs.Fields) { _matrix[_item.ToString()] = new List <string>(); } int _col; _rs.ToList().ForEach(_row => { _col = 0; _row.ItemArray.ToList().ForEach(_column => { _matrix[_matrix.Keys.ToList()[_col]].Add(_column.ToString()); _col++; }); }); foreach (var _key in _matrix.Keys) { Areas.Add(CurrentArea = new EspackPrintingArea(EnumDocumentZones.BODY, pFont, pDocking: EnumZoneDocking.RIGHTWARDS)); // Add current column title if (!pHideTitles) { AddText(true, _key.ToString(), true); CurrentArea.PermanentRows++; } // Add data for current column foreach (var _item in _matrix[_key]) { AddText(_item.ToString(), true); CurrentArea.DataRows++; } } } } return(true); }
public void Source(string pSQL, cAccesoDatosNet pConn) { noChange = true; _SQL = pSQL; _RS = new DynamicRS(_SQL, pConn); _RS.Open(); DataSource = null; DataSource = _RS.DataObject; if (_RS.FieldCount > 1) { DisplayMember = _RS.Fields[1]; } ValueMember = _RS.Fields[0]; SelectedItem = null; noChange = false; }
static void Main(string[] args) { string pe; string pa; pe = IntToLetters(128); pa = IntToLettersRec(128); using (var _conn = new cAccesoDatosNet("DB01", "SISTEMAS", "sa", "5380")) { using (var _rs = new StaticRS("select UserCode,Name,Surname1,Surname2,EmailAddress from Users", _conn)) { _rs.Open(); _rs.SaveExcelFile(@"D:\text.xlsx"); } } }
public static object CreateObject(string objectClass, string objectType, object param1 = null, object param2 = null, string serial = null) { switch (objectClass) { case "Conn": object _conn; if (objectType == "Socks") { _conn = new cAccesoDatosXML(); } else { _conn = new cAccesoDatosNet(); } EspackCommServer.Server.Serial = serial; return(_conn); case "SP": if (objectType == "Socks") { return(new SPXML((cAccesoDatosXML)param1, (string)param2)); } else { return(new SP((cAccesoDatosNet)param1, (string)param2)); } case "RS": if (objectType == "Socks") { return(new XMLRS((string)param1, (cAccesoDatosXML)param2)); } else { return(new DynamicRS((string)param1, (cAccesoDatosNet)param2)); } default: return(null); } }
public override async Task <bool> process() { XElement _xServer = xmlMsgIn.Data.Element("server"); var _server = new cServer(); _server.xServer = _xServer; var _conn = new cAccesoDatosNet(_server, xmlMsgIn.Data.Element("DataBase").Value); try { await _conn.ConnectAsync(); xmlMsgOut = new XDocument(new XElement("result", "OK")); } catch (Exception ex) { xmlMsgOut = new XDocument(new XElement("result", "ERROR: " + ex.Message)); } MsgOut = xmlMsgOut.ToString(); return(true); }
public SP_Controls(cAccesoDatosNet pConn, string pSPName = "") : base(pConn, pSPName) { }
public DynamicRS_Controls(string Sql, cAccesoDatosNet Conn) : base(Sql, Conn) { }
public async Task LaunchApp(bool temp = false) { //if (!Special && !External) //{ // SetStatus(AppBotStatus.PENDING_UPDATE); // //if (!await CheckUpdated().ConfigureAwait(false)) // if (!await CheckUpdated(true)) // { // Application.DoEvents(); // ActiveThreads++; // var _thread = new cUpdaterThread(debugBox, ActiveThreads); // // launch task not async // await _thread.Process(); // } // SetStatus(AppBotStatus.UPDATED); //} if (DBServer.HostName != gDatos.Server && DBServer.User != "procesos") { var _datos = new cAccesoDatosNet(); _datos.User = gDatos.User; _datos.Password = gDatos.Password; _datos.DataBase = gDatos.DataBase; _datos.Server = DBServer.HostName; // check the password in the new server var _SP = new SP(_datos, "pLogOnUser"); _SP.AddParameterValue("User", DBServer.User); _SP.AddParameterValue("Ticket", DBServer.Password); _SP.AddParameterValue("Origin", "LOGON_CS"); try { _SP.Execute(); } catch (Exception ex) { MessageBox.Show(ex.Message + "\nIf you have recently changed your password, wait a couple of minutes before opening this app.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } string _tempPath = string.Format("{0}\\{1}", Path.GetTempPath(), this.Code); if (temp) { //copy to temp folder DirectoryInfo _dir = new DirectoryInfo(_tempPath); if (_dir.Exists) { try { _dir.Delete(true); } catch (Exception ex) { MessageBox.Show(ex.Message + "\nIt looks like the application is already open.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } var _odir = new DirectoryInfo(LOCAL_PATH + Code + "/"); _odir.DirectoryCopy(_tempPath); _tempPath = string.Format("{0}\\{1}", _tempPath, ExeName); } else { _tempPath = LocalPath; } // Use ProcessStartInfo class ProcessStartInfo startInfo = new ProcessStartInfo(); startInfo.UseShellExecute = false; startInfo.FileName = _tempPath; startInfo.WindowStyle = ProcessWindowStyle.Maximized; startInfo.Arguments = string.Format("/srv={0} /db={1} /usr={2} /pwd={3} /loc={4} /app={5}{6}{7}", DBServer.IP.ToString(), DataBase, DBServer.User, DBServer.Password, "OUT", Name, External ? " /ext=1" : "", Code == "logon"?" /noxml=1":""); try { Process exeProcess = Process.Start(startInfo); OnAfterLaunch(new EventArgs()); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }