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