public Romanero_Vista() { InitializeComponent(); SQLiteManager.CheckFolders(); _cooperado = new Cooperado_Vista(); SetearSegundaPantalla(); SetearFechaHora(); SetearNombrePlanta(); _cooperado.PlantaInfo.Text = Nombre_Planta; PlantaInfo.Text = Nombre_Planta; WindowState = FormWindowState.Minimized; //SetStartUp(); OracleManager.SetConfiguracionDePuerto(PuertoSerial, _MarcasUsuario.ID_Planta, 2); TopMost = true; _cooperado.TopMost = true; try { PuertoSerial.Open(); } catch (Exception _error) { MessageBox.Show("Configuración del Serial Incorrecta. Error: " + _error.Message, "ERROR FATAL", MessageBoxButtons.OK, MessageBoxIcon.Error); } //EscribirEnLog(GetExecutingDirectoryName()); //PowerModeChangedEventHandler += new SystemEvents_PowerModeChanged(); }
public IList <MLoc> GetByExample(MLocParams location) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sql = new StringBuilder(); sql.Append("SELECT comp_code, loc_code, loc_des, loc_stat FROM m_loc WHERE 1=1 "); var parameters = new List <OracleParameter>(); if (!string.IsNullOrWhiteSpace(location.CompCode)) { sql.Append("AND comp_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, location.CompCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(location.LocCode)) { sql.Append("AND loc_code = :2 "); parameters.Add(new OracleParameter(":2", OracleDbType.Varchar2, location.LocCode, ParameterDirection.Input)); } var locations = new List <MLoc>(); OracleManager.ExecuteReader(cn, sql.ToString(), parameters, (reader) => locations.Add(getEntityFromReader(reader)) ); return(locations); } }
public IList <MCompH> GetByExample(MCompHParams example) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sql = new StringBuilder(); sql.Append("SELECT comp_code, comp_name, global_code, comp_stat FROM m_comp_h WHERE 1=1 "); var parameters = new List <OracleParameter>(); if (!string.IsNullOrWhiteSpace(example.CompCode)) { sql.Append("AND comp_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, example.CompCode, ParameterDirection.Input)); } IList <MCompH> companies = new List <MCompH>(); OracleManager.ExecuteReader(cn, sql.ToString(), parameters, (reader) => companies.Add(getEntityFromReader(reader)) ); return(companies); } }
private void RepetirClick(object sender, EventArgs e) { DialogResult resultado = MessageBox.Show("Esta acción anulará los valores anteriores y deberá comenzar el proceso de nuevo,¿Está seguro que desea continuar?", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); if (resultado == DialogResult.Yes) { OracleManager.VerificarIntegridadBaseDeDatos(_MarcasUsuario.Id_Planta); if (_MarcasUsuario.Intento <= 3) { InsertarEnBasesDeDatosRepeticion(_MarcasUsuario); Limpiar_Repeticion(); _MarcasUsuario.Intento++; Cooperado.LecturaText.Text = _MarcasUsuario.Intento.ToString(); LecturaText.Text = _MarcasUsuario.Intento.ToString(); _observador.EscribirPalabra_Archivo('R', @"C:/ROMANA/REFRACTO/ENVIO.txt"); //MessageBox.Show("Valores cargados por default.", "Nueva Repetición", // MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MedicionButton.Enabled = false; CapturarButton.Enabled = false; RepetirButton.Enabled = false; } } }
private void TickEvent(object sender, EventArgs e) { HoraInfo.Text = DateTime.Now.ToString("HH:mm:ss"); if (SQLiteManager.DebeEjecutarse()) { BringToFront(); Show(); TopMost = true; RefractoIcon.Visible = false; WindowState = FormWindowState.Maximized; SetearUI_Session(_userSession); SQLiteManager.EliminarRegistro(_userSession.Id_Recepcion); OracleManager.VerificarIntegridadBaseDeDatos(_userSession.Id_Planta); SQLiteManager.CambiarEstado_App(2); } if (SQLiteManager.DebeMinimizarse()) { Limpiar_UI(); //SQLiteManager.CambiarEstado_App(0); WindowState = FormWindowState.Minimized; _userSession.Clear_Session(); Hide(); RefractoIcon.Visible = true; RefractoIcon.ShowBalloonTip(1000); } else { _cooperado.BringToFront(); } }
private void InsertarEnBaseDeDatos(Session _userSession) { ScreenManager.TomarPantallazo(_userSession); SQLiteManager.InsertarDatos(_userSession); OracleManager.InsertarDatosEnPasarela(_userSession); OracleManager.InsertarFotoRecepcion(_userSession); }
private void Guardar_Click(object sender, EventArgs e) { if (Convert.ToInt32(PesoText.Text) > 0) { try { OracleManager.VerificarIntegridadBaseDeDatos(_MarcasUsuario.ID_Planta); _MarcasUsuario.Peso = Convert.ToInt32(PesoText.Text); InsertarEnBasesDeDatos(_MarcasUsuario); Limpiar_UI(); MessageBox.Show("Datos Guardados con éxito.Serás redireccionado " + "a la página web.", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); SQLiteManager.CambiarEstado_App(3); _MarcasUsuario.Clear_Session(); } catch (Exception _error) { EscribirEnLog("Error al Ingresar Datos. Error: " + _error.Message); MessageBox.Show("Intermitencia de enlace detectada, pruebe nuevamente.", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); } } else { MessageBox.Show("El peso ingresado no puede ser 0.", "Alerta", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); } }
protected override LRyderCiscoSncycCnt AddEntity(AccellosContext entityContext, LRyderCiscoSncycCnt entity) { string sql = @"INSERT INTO l_ryder_cisco_sncyc_cnt ( cust_code, loc_code, item_code, serial, pros_date_time, username, bulk_item, item_type) VALUES (:1, :2, :3, :4, :5, :6, :7, :8)"; IList <OracleParameter> parameters = new List <OracleParameter> { new OracleParameter(":1", OracleDbType.Varchar2, entity.CustCode, ParameterDirection.Input), new OracleParameter(":2", OracleDbType.Varchar2, entity.LocCode, ParameterDirection.Input), new OracleParameter(":3", OracleDbType.Varchar2, entity.ItemCode, ParameterDirection.Input), new OracleParameter(":4", OracleDbType.Varchar2, entity.Serial, ParameterDirection.Input), new OracleParameter(":5", OracleDbType.Date, entity.ProsDateTime, ParameterDirection.Input), new OracleParameter(":6", OracleDbType.Varchar2, entity.UserName, ParameterDirection.Input), new OracleParameter(":7", OracleDbType.Varchar2, entity.BulkItem, ParameterDirection.Input), new OracleParameter(":8", OracleDbType.Varchar2, entity.ItemType, ParameterDirection.Input) }; using (var cn = (OracleConnection)entityContext.DbConnection) { var result = OracleManager.ExecuteSql(cn, sql, parameters); return(entity); } }
private void InsertarEnBasesDeDatosRepeticion(Session _userSession) { _MarcasUsuario.Hora = DateTime.Now.ToString("HH:mm:ss"); _MarcasUsuario.Fecha = DateTime.Now.ToString("dd-MM-yyyy"); ScreenManager.TomarPantallazo(_userSession); SQliteManager.InsertarDatos(_userSession); OracleManager.InsertarFotoRecepcion(_userSession); }
public IList <LocationNotCountedModel> GetLocationsNotCounted(string compCode, string custCode) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sqlFormat = new StringBuilder(); sqlFormat.Append(@"SELECT loc.cust_code, loc.loc_code, loc.invt_lev1 as item_code, loc.on_hand_qty FROM (select l.comp_code, l.cust_code, l.loc_code, l.invt_lev1, l.on_hand_qty from c_loc l join m_item_h p on l.comp_code = p.comp_code and l.cust_code = p.cust_code and l.invt_lev1 = p.item_code where p.item_stat = 'A' and p.pros_prof_code = 'SN' and l.on_hand_qty > 0) loc LEFT JOIN (select cust_code, loc_code, item_code from l_ryder_cisco_sncyc_cnt group by cust_code, loc_code, item_code ) cyc ON loc.comp_code = '{0}' AND cyc.cust_code = loc.cust_code AND cyc.loc_code = loc.loc_code AND cyc.item_code = loc.invt_lev1 WHERE 1=1 AND cyc.item_code IS NULL "); var parameters = new List <OracleParameter>(); sqlFormat.Append("AND loc.cust_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, custCode, ParameterDirection.Input)); IList <LocationNotCountedModel> entities = new List <LocationNotCountedModel>(); var sql = string.Format(sqlFormat.ToString(), compCode); OracleManager.ExecuteReader(cn, sql, parameters, (reader) => entities.Add(new LocationNotCountedModel { CustomerCode = reader.GetString(reader.GetOrdinal("cust_code")), LocationCode = reader.GetString(reader.GetOrdinal("loc_code")), ItemCode = reader.GetString(reader.GetOrdinal("item_code")), OnHandQty = reader.GetInt32(reader.GetOrdinal("on_hand_qty")) } ) ); return(entities); } }
public IList <ScannedQtyMismatchModel> GetScannedQtyMismatches(string compCode, string custCode, string locCode) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sqlFormat = new StringBuilder(); sqlFormat.Append(@"SELECT cyc.cust_code, cyc.loc_code, cyc.item_code, loc.invt_lev1, cyc.cycle_count_qty, loc.on_hand_qty FROM (select cust_code, loc_code, item_code, count(serial) cycle_count_qty from l_ryder_cisco_sncyc_cnt group by cust_code, loc_code, item_code ) cyc JOIN c_loc loc ON loc.comp_code = '{0}' AND cyc.cust_code = loc.cust_code AND cyc.loc_code = loc.loc_code AND cyc.item_code = loc.invt_lev1 WHERE 1=1 AND loc.on_hand_qty <> cyc.cycle_count_qty "); var parameters = new List <OracleParameter>(); sqlFormat.Append("AND cyc.cust_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, custCode, ParameterDirection.Input)); sqlFormat.Append("AND cyc.loc_code = :2 "); parameters.Add(new OracleParameter(":2", OracleDbType.Varchar2, locCode, ParameterDirection.Input)); IList <ScannedQtyMismatchModel> entities = new List <ScannedQtyMismatchModel>(); var sql = string.Format(sqlFormat.ToString(), compCode); OracleManager.ExecuteReader(cn, sql, parameters, (reader) => entities.Add(new ScannedQtyMismatchModel { CustomerCode = reader.GetString(reader.GetOrdinal("cust_code")), LocationCode = reader.GetString(reader.GetOrdinal("loc_code")), ItemCode = reader.GetString(reader.GetOrdinal("item_code")), CycleCountQty = reader.GetInt32(reader.GetOrdinal("cycle_count_qty")), LocOnHandQty = reader.GetInt32(reader.GetOrdinal("on_hand_qty")) } ) ); return(entities); } }
private void CancelarClick(object sender, EventArgs e) { DialogResult result = MessageBox.Show("¿Estás seguro que deseas cerrar esta ventana?, El proceso deberá ser " + "reiniciado desde la página web.", "Confirmar Acción", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { Limpiar_UI(); SQLiteManager.CambiarEstado_App(4); OracleManager.InsertarEstadoApp(4, _MarcasUsuario.ID_Planta, 2); } }
private void Awake() { if (Instance != null) { Destroy(this); } else { Instance = this; } FirebaseCommunicator.LoggedIn.AddListener(OnLoggedIn); }
private void textBox_kartyaszam_TextChanged(object sender, EventArgs e) { string value = textBox_kartyaszam.Text; OracleManager oracleManager = new OracleManager(); if (!oracleManager.CheckData(value)) { textBox_kartyaszam.BackColor = Color.Red; } else { textBox_kartyaszam.BackColor = Color.White; } }
private void Consultor_Tick(object sender, EventArgs e) { if (SQliteManager.DebeEjecutarse()) { Configurar_Sesion(); if (_MarcasUsuario.NUM_TICKET > 0) { BringToFront(); OracleManager.VerificarIntegridadBaseDeDatos(_MarcasUsuario.Id_Planta); this.WindowState = FormWindowState.Maximized; TopMost = true; SQliteManager.CambiarEstado_App(2); SQliteManager.EliminarRegistro(_MarcasUsuario.Id_RecepcionUva); } else { SQliteManager.CambiarEstado_App(3); Limpiar_UI(); _MarcasUsuario.Clear_Session(); WindowState = FormWindowState.Minimized; MessageBox.Show("Hubo un problema de comunicación entre la página y la aplicación. " + "Por favor reinicie el proceso desde el ERP.", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); } } if (SQliteManager.DebeMinimizarse()) { Limpiar_UI(); _MarcasUsuario.Clear_Session(); WindowState = FormWindowState.Minimized; } if (SQliteManager.TrabajoEnProceso()) { if (WindowState != FormWindowState.Minimized) { WindowState = FormWindowState.Maximized; } if (Cooperado.WindowState != FormWindowState.Maximized) { Cooperado.WindowState = FormWindowState.Maximized; } } else { Cooperado.BringToFront(); } }
public IList <LRyderCiscoSncycCnt> GetByExample(LRyderCiscoSncycCntParams example) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sql = new StringBuilder(); sql.Append(@"SELECT cust_code, loc_code, item_code, serial, pros_date_time, username, bulk_item, item_type FROM l_ryder_cisco_sncyc_cnt WHERE 1=1 "); var parameters = new List <OracleParameter>(); if (!string.IsNullOrWhiteSpace(example.CustCode)) { sql.Append("AND cust_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, example.CustCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(example.LocCode)) { sql.Append("AND loc_code = :2 "); parameters.Add(new OracleParameter(":2", OracleDbType.Varchar2, example.LocCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(example.ItemCode)) { sql.Append("AND item_code = :3 "); parameters.Add(new OracleParameter(":3", OracleDbType.Varchar2, example.ItemCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(example.Serial)) { sql.Append("AND serial = :4 "); parameters.Add(new OracleParameter(":4", OracleDbType.Varchar2, example.Serial, ParameterDirection.Input)); } IList <LRyderCiscoSncycCnt> entities = new List <LRyderCiscoSncycCnt>(); OracleManager.ExecuteReader(cn, sql.ToString(), parameters, (reader) => entities.Add(getEntityFromReader(reader)) ); return(entities); } }
private bool XML_Valido(SerialPort puertoSerial) { if (Properties.Settings.Default.ID_Planta == ConfirmarPlanta()) { puertoSerial.PortName = Properties.Settings.Default.NombrePuerto; puertoSerial.BaudRate = Properties.Settings.Default.BaudRate; puertoSerial.Parity = OracleManager.ObtenerParidad(Properties.Settings.Default.Paridad); puertoSerial.DataBits = Properties.Settings.Default.Databits; Properties.Settings.Default.Save(); return(true); } else { EscribirEnLog("La configuración no es la Misma."); return(false); } }
public bool openSql(ref DataSet ds, string sqlstr) { if (DataSourceType == DataSourceType_MySql) { MySqlManager msm = new MySqlManager(); return(msm.openSql(ref ds, sqlstr)); } else if (DataSourceType == DataSourceType_Oracle) { OracleManager om = new OracleManager(); return(om.openSql(ref ds, sqlstr)); } else { return(false); } }
public bool executeSql(string sqlstr) { if (DataSourceType == DataSourceType_MySql) { MySqlManager msm = new MySqlManager(); return(msm.executeSql(sqlstr)); } else if (DataSourceType == DataSourceType_Oracle) { OracleManager om = new OracleManager(); return(om.executeSql(sqlstr)); } else { return(false); } }
public void Execute() { var ctx = new AccellosContext(); var copyFmt = @"INSERT INTO l_ryder_cisco_sncyc_cnt_hist SELECT s.cust_code, s.loc_code, s.item_code, s.serial, s.pros_date_time, s.username, s.bulk_item, s.item_type, 'OC' {0} "; var from = string.Format(FROM_FMT, this.Days); var copy = string.Format(copyFmt, from); var deleteFmt = @"DELETE FROM l_ryder_cisco_sncyc_cnt WHERE EXISTS ( SELECT * FROM c_pros_mvt m WHERE l_ryder_cisco_sncyc_cnt.cust_code = m.cust_code AND l_ryder_cisco_sncyc_cnt.item_code = m.invt_lev1 AND (l_ryder_cisco_sncyc_cnt.serial = m.pros_value OR l_ryder_cisco_sncyc_cnt.serial = ('S' || m.pros_value)) AND m.pros_trans_tp = 'CO' AND m.pros_trans_date BETWEEN sysdate - {0} AND sysdate )"; var delete = string.Format(deleteFmt, this.Days); var oracleParams = new List <OracleParameter>(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); using (var tx = cn.BeginTransaction()) { try { OracleManager.ExecuteSql(tx, copy, oracleParams); OracleManager.ExecuteSql(tx, delete, oracleParams); tx.Commit(); } catch (Exception) { tx.Rollback(); throw; } } } }
private static void LoadSchemas(StringBuilder sb, string connectionString, string sql) { sb.Append("PUBLIC;"); var manager = new OracleManager(connectionString); using (var reader = manager.ExecuteReader(System.Data.CommandType.Text, sql)) { while (reader.Read()) { string schemaName = reader.GetString(0); if (!excluded.Contains(schemaName)) { sb.Append(schemaName); sb.Append(";"); } } } }
public int GetSerialCount(string custCode, string locCode, string itemCode) { var ctx = new AccellosContext(); string sql = @"SELECT COUNT(serial) cnt FROM l_ryder_cisco_sncyc_cnt WHERE cust_code = :1 AND loc_code = :2 AND item_code = :3"; IList <OracleParameter> parameters = new List <OracleParameter> { new OracleParameter(":1", OracleDbType.Varchar2, custCode, ParameterDirection.Input), new OracleParameter(":2", OracleDbType.Varchar2, locCode, ParameterDirection.Input), new OracleParameter(":3", OracleDbType.Varchar2, itemCode, ParameterDirection.Input) }; using (var cn = (OracleConnection)ctx.DbConnection) { return(OracleManager.ExecuteScalar(cn, sql, parameters)); } }
private void GuardarButton_Click(object sender, EventArgs e) { DialogResult resultado = MessageBox.Show("¿Confirma guardar Grado?, Esta acción no puede deshacerse.", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); if (resultado == DialogResult.Yes) { OracleManager.VerificarIntegridadBaseDeDatos(_userSession.Id_Planta); InsertarEnBaseDeDatos(_userSession); SQLiteManager.CambiarEstado_App(3); Limpiar_UI(); Hide(); Thread.Sleep(2000); SQLiteManager.CambiarEstado_App(0); //SQLiteManager.CambiarEstado_Data(2, _userSession); } }
public IList <CLoc> GetByExample(CLocParams location) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sql = new StringBuilder(); sql.Append(@"SELECT comp_code, loc_code, cust_code, on_hand_qty, invt_access, invt_lev1, hold_code FROM c_loc WHERE 1=1 "); var parameters = new List <OracleParameter>(); if (!string.IsNullOrWhiteSpace(location.CompCode)) { sql.Append("AND comp_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, location.CompCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(location.LocCode)) { sql.Append("AND loc_code = :2 "); parameters.Add(new OracleParameter(":2", OracleDbType.Varchar2, location.LocCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(location.CustCode)) { sql.Append("AND cust_code = :3 "); parameters.Add(new OracleParameter(":3", OracleDbType.Varchar2, location.CustCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(location.InvtLev1)) { sql.Append("AND invt_lev1 = :4 "); parameters.Add(new OracleParameter(":4", OracleDbType.Varchar2, location.InvtLev1, ParameterDirection.Input)); } var locations = new List <CLoc>(); OracleManager.ExecuteReader(cn, sql.ToString(), parameters, (reader) => locations.Add(getEntityFromReader(reader)) ); return(locations); } }
private void Tempo_Tick(object sender, EventArgs e) { FechaHoraInfo.Text = DateTime.Now.ToString("dd-MM-yyyy") + " " + DateTime.Now.ToString("HH:mm:ss"); if (SQLiteManager.DebeEjecutarse()) { TopMost = true; Show(); //SendMessage(_cooperado.Handle, WM_SYSCOMMAND, (IntPtr)SC_MONITORPOWER, (IntPtr)MONITOR_ON); RomaneroIcon.Visible = false; SetearSegundaPantalla(); SQLiteManager.CambiarEstado_App(2); this.WindowState = FormWindowState.Maximized; SQLiteManager.Configurar_Session(ref _MarcasUsuario); OracleManager.VerificarIntegridadBaseDeDatos(_MarcasUsuario.ID_Planta); SQLiteManager.EliminarRegistro(_MarcasUsuario.Ticket, _MarcasUsuario.ID_Planta); MinimizeBox = false; ActualizarUI(_MarcasUsuario); } if (SQLiteManager.DebeMinimizarse()) { Limpiar_UI(); WindowState = FormWindowState.Minimized; } if (_cooperado.WindowState != FormWindowState.Maximized) { //_cooperado.WindowState = FormWindowState.Maximized; } if (SQLiteManager.AplicacionEnEjecucion()) { if (WindowState == FormWindowState.Minimized) { WindowState = FormWindowState.Maximized; } } if (WindowState != FormWindowState.Minimized) { if (_MarcasUsuario.Ticket == 0) { WindowState = FormWindowState.Minimized; } } }
public IList <CProsMvt> GetByExample(CProsMvtParams example) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sql = new StringBuilder(); sql.Append(@"SELECT loc_code, pros_code, invt_lev1, pros_trans_date, pros_trans_tp FROM c_pros_mvt WHERE 1=1 "); var parameters = new List <OracleParameter>(); if (!string.IsNullOrWhiteSpace(example.LocCode)) { sql.Append("AND loc_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, example.LocCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(example.InvtLev1)) { sql.Append("AND invt_lev1 = :2 "); parameters.Add(new OracleParameter(":2", OracleDbType.Varchar2, example.InvtLev1, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(example.ProsCode)) { sql.Append("AND pros_code = :3 "); parameters.Add(new OracleParameter(":3", OracleDbType.Varchar2, example.ProsCode, ParameterDirection.Input)); } var entities = new List <CProsMvt>(); OracleManager.ExecuteReader(cn, sql.ToString(), parameters, (reader) => entities.Add(getEntityFromReader(reader)) ); return(entities); } }
public Refracto_Vista() { if (File.Exists(ConfigPath)) { InitializeComponent(); FechaInfo.Text = DateTime.Now.ToString("dd-MM-yyyy"); HoraInfo.Text = DateTime.Now.ToString("HH:mm:ss"); SQLiteManager.CheckDataBase(); ID_Planta = ConfirmarPlanta(); if (!XML_Valido(PuertoSerial)) { OracleManager.SetConfiguracionDePuerto(PuertoSerial, ID_Planta, 1); } _cooperado = new Cooperado_Vista(); SetearSegundaPantalla(); _cooperado.TopMost = true; try { PuertoSerial.Open(); } catch (Exception _error) { MessageBox.Show("PuertoSerial mal configurado.Esto se debe a ERROR. " + "Verifique la conexión y vuelva a iniciar la App. Error: " + _error.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); Application.Exit(); } TopMost = true; _cooperado.PlantaInfo.Text = OracleManager.ObtenerNombrePlanta(ConfirmarPlanta()); //SetStartUp(); WindowState = FormWindowState.Minimized; EscribirEnLog(GetExecutingDirectoryName()); } else { MessageBox.Show("NO EXISTE ARCHIVO DE CONFIGURACIONES.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Exit(); } }
public IList <MItemH> GetByExample(MItemHParams example) { var ctx = new AccellosContext(); using (OracleConnection cn = (OracleConnection)ctx.DbConnection) { cn.Open(); StringBuilder sql = new StringBuilder(); sql.Append(@"SELECT cust_code, item_code, item_stat, comp_code, item_des1, pros_prof_code FROM m_item_h WHERE 1=1 "); var parameters = new List <OracleParameter>(); if (!string.IsNullOrWhiteSpace(example.CustCode)) { sql.Append("AND cust_code = :1 "); parameters.Add(new OracleParameter(":1", OracleDbType.Varchar2, example.CustCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(example.CompCode)) { sql.Append("AND comp_code = :2 "); parameters.Add(new OracleParameter(":2", OracleDbType.Varchar2, example.CompCode, ParameterDirection.Input)); } if (!string.IsNullOrWhiteSpace(example.ItemCode)) { sql.Append("AND item_code = :3 "); parameters.Add(new OracleParameter(":3", OracleDbType.Varchar2, example.ItemCode, ParameterDirection.Input)); } IList <MItemH> entities = new List <MItemH>(); OracleManager.ExecuteReader(cn, sql.ToString(), parameters, (reader) => entities.Add(getEntityFromReader(reader)) ); return(entities); } }
private void GuardarClick(object sender, EventArgs e) { DialogResult confirmacion = MessageBox.Show("¿DESEA COMPLETA EL PROCESO DE TOMA DE GRADO?, " + "ESTE PROCESO NO PUEDE DESHACERSE.", "ALERTA", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); if (confirmacion == DialogResult.Yes) { OracleManager.VerificarIntegridadBaseDeDatos(_MarcasUsuario.Id_Planta); InsertarEnBasesDeDatos(_MarcasUsuario); _MarcasUsuario.Clear_Session(); _observador.Intentos_Session = 0; _observador.EscribirPalabra_Archivo('F', @"C:/ROMANA/REFRACTO/ENVIO.txt"); Limpiar_UI(); MessageBox.Show("Los datos se han guardado con exito en la base de datos.", "Exito", MessageBoxButtons.OK, MessageBoxIcon.Information); SQliteManager.CambiarEstado_App(3); //Thread.Sleep(7000); //SQliteManager.CambiarEstado_App(4); GuardarButton.Enabled = false; } }
protected override MItemH GetEntity(AccellosContext entityContext, string id) { using (OracleConnection cn = (OracleConnection)entityContext.DbConnection) { cn.Open(); string sql = @"SELECT cust_code, item_code, item_stat, comp_code, item_des1, pros_prof_code FROM m_item_h WHERE item_code = :1"; var parameters = new List <OracleParameter> { new OracleParameter(":1", OracleDbType.Varchar2, id, ParameterDirection.Input) }; MItemH entity = null; OracleManager.ExecuteReader(cn, sql, parameters, (reader) => entity = getEntityFromReader(reader) ); return(entity); } }