public string Update(RRCCT rrcct)
{
string res;
StringBuilder query = new StringBuilder();
query.Append(" UPDATE RRCCT");
query.Append(" SET");
if (rrcct.RFEC17 != null)
{
query.Append(" RFEC17 = '" + rrcct.RFEC17 + "'");
}
if (rrcct.RFEC50 != null)
{
query.Append(" RFEC50 = '" + rrcct.RFEC50 + "'");
}
query.Append(" WHERE RCONSO = '" + rrcct.RCONSO + "'");
try
{
db.Execute(query.ToString(), rrcct);
res = "OK";
}
catch (iDB2SQLErrorException ex)
{
res = ex.Message;
}
catch (iDB2Exception ex)
{
res = ex.Message;
}
catch (Exception ex)
{
res = ex.Message;
}
return(res);
}
private string Conso(string consoli, string hora, string entrada, string planta)
{
string result = "";
bool sale = false;
bool entra = false;
var Prove = "";
mRHCC = null;
mRHCC = new RHCC()
{
HCONSO = consoli,
HPLTA = planta
};
mRHCC = dRHCC.GetConsoSalida(mRHCC);
if (mRHCC != null)
{
Prove = mRHCC.HPROVE;
entrada = "False";
if (mRHCC.HSTS >= 30 && mRHCC.HSTS <= 50)
{
sale = true;
entrada = "False";
}
else
{
mRFLOG.OPERACION = "Consulta RHCC Estado";
mRFLOG.EVENTO = "Consolidado " + consoli + " con estado " + mRHCC.HSTS;
mRFLOG.ALERT = "0";
mRFLOG.USUARIO = "";
result = dRFLOG.Add(mRFLOG);
if (result == "OK")
{
result = "RHCC Estado no esta entre 30 y 50";
}
}
if (mRHCC.HSTS > 50)
{
sale = false;
entrada = "False";
}
if (entrada == "OK")
{
mRRCC.RREPORT = "Llegada a Planta";
mRRCC.RCRTDAT = hora;
mRRCC.RAPP = "SMSENTRADA";
mRRCC.HCONSO = consoli;
result = dRRCC.Add(mRRCC);
if (result == "OK")
{
mRRCCT.RFEC17 = hora;
mRRCCT.RCONSO = consoli;
result = dRRCCT.Update(mRRCCT);
if (result == "OK" && entra)
{
mRHCC.HESTAD = "17";
mRHCC.HLLEGA = hora;
mRHCC.HCONSO = consoli;
mRHCC.HSTS = 20;
result = dRHCC.Update(mRHCC);
}
}
}
else
{
var condespacho = dRDCC.GetDespacho(consoli);
if (condespacho.Count != 0)
{
var existRRCC = dRRCC.FindConso(consoli, "SMSSALIDA");
if (existRRCC.Count == 0)
{
if (sale)
{
mRHCC = null;
mRHCC = new RHCC
{
HESTAD = "5",
HSALE = hora,
HCONSO = consoli,
HSTS = 50
};
result = dRHCC.Update(mRHCC);
}
else
{
result = "OK";
}
if (result == "OK")
{
mRRCC.RREPORT = "Salida de Planta";
mRRCC.RCRTDAT = hora;
mRRCC.RAPP = "SMSSALIDA";
mRRCC.HCONSO = consoli;
result = dRRCC.Add(mRRCC);
if (result == "OK")
{
mRDRIVERDAT = dRDRIVERDAT.GetInfo(consoli);
if (mRDRIVERDAT == null)
{
result = dRDRIVERDAT.Add(consoli);
}
if (result == "OK")
{
mRRCCT = null;
mRRCCT = new RRCCT();
mRRCCT.RFEC50 = hora;
mRRCCT.RCONSO = consoli;
result = dRRCCT.Update(mRRCCT);
}
}
}
var nRFTASK = new RFTASK()
{
TPRM = "|CONSO=" + consoli,
TKEY = consoli,
TKEYWORD = consoli,
TCRTUSR = "******"
};
result = dRFTASK.Add(nRFTASK);
}
else
{
result = "Ya se realizó la salida";
}
}
else
{
mRFLOG.OPERACION = "Consulta Despacho";
mRFLOG.EVENTO = "Consolidado " + consoli + " sin despacho";
mRFLOG.ALERT = "1";
result = dRFLOG.Add(mRFLOG);
}
}
if (Prove == "5115")
{
var nTra = new FiltroTrafico()
{
ACCION = "nuevotrafico",
USUARIO = "BSS2",
PASSWORD = "******",
CONSO = consoli
};
var t = new TraficoController();
t.Reporte(nTra);
}
}
else
{
mRFLOG.OPERACION = "Consulta Consolidado";
mRFLOG.EVENTO = "No Existe Consolidado " + consoli;
mRFLOG.ALERT = "1";
result = dRFLOG.Add(mRFLOG);
}
return(result);
}
