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);
}
}
