/// <summary>
/// Detalle de inspeccion del panel general
/// </summary>
/// <returns></returns>
private List <Detail> GetInspectionDetail()
{
string query = SqlServerQuery.ListFaultInfo(this);
DataTable dt = _sqlserver.Query(query);
List <Detail> detalles = new List <Detail>();
if (dt.Rows.Count > 0)
{
#region FILL_ERROR_DETAIL
foreach (DataRow r in dt.Rows)
{
int bid = int.Parse(r["bloque"].ToString());
Detail det = new Detail();
det.faultcode = r["faultcode"].ToString();
det.estado = r["estado"].ToString();
det.referencia = r["uname"].ToString();
det.bloqueId = bid;
//det.total_faultcode = int.Parse(r["total"].ToString());
det.descripcionFaultcode = r["descripcion"].ToString();
if (!DuplicatedInspectionDetail(det, detalles))
{
detalles.Add(det);
}
}
#endregion
}
return(detalles);
}
public void Seila()
{
var exp = "select * from Person.Person where FirstName = 'David' AND JobTitle = 'Developer'";
var q = new SqlServerQuery()
.Select("*")
.From("Person.Person")
.Where("{0} = {1} AND {2} = {3}", "FirstName", "'David'", "JobTitle", "'Developer'");
Assert.AreEqual(exp, q.ToString(), true);
}
public void Simple_Select_Using_Order_By()
{
var exp = "select * from Person.Person order by PersonID";
var q = new SqlServerQuery()
.Select("*")
.From("Person.Person")
.OrderBy("PersonID");
Assert.AreEqual(exp, q.ToString(), ignoreCase: true);
}
public void TestAnd_ValidateNull()
{
SqlServerQuery query = new SqlServerQuery();
query.Select("");
var sqlbuilder = query.GetSqlBuilder();
query.NewSqlBuilder();
// query.Less();
Expression <Func <Customer, bool> > _expression = null;
_query.And(_expression);
Assert.AreEqual(null, _query.GetPredicate());
}
public void Simple_Select_Should_Work_As_Expected()
{
var expected = "select * from HumanResources.Employee";
var expected2 = "select JobTitle, BirthDate FROM HumanResources.Employee";
var expected3 = "select * from Person.Person";
Query query = new SqlServerQuery();
query.Select("*").From("HumanResources.Employee");
Query query2 = new SqlServerQuery()
.Select("JOBTITLE", "BIRTHDATE")
.From("HumanResources.Employee");
Query query3 = new SqlServerQuery()
.Select("* FROM Person.Person");
Assert.AreEqual(expected, query.ToString(), true);
Assert.AreEqual(expected2, query2.ToString(), true);
Assert.AreEqual(expected3, query3.ToString(), true);
}
public BulkTask CreateTask(string taskName)
{
Check.NotEmpty(taskName, nameof(taskName));
var connectionString = _taskConfigurationObject.GetConfigurationValue <string>("connectionString");
var query = _taskConfigurationObject.GetConfigurationValue <string>("query");
var host = _taskConfigurationObject.GetConfigurationValue <string>("host");
var port = _taskConfigurationObject.GetConfigurationValue <int>("port");
var source = new SqlServerQuery(connectionString, query);
var bulkTaskConfiguration = new BulkTaskConfiguration(taskName, host, port)
{
IndexName = IndexTemplate, TypeName = Type
};
var chunkConfiguration = new ChunkConfiguration()
{
ChunkSize = ChunkSize
};
return(new BulkTask(bulkTaskConfiguration, chunkConfiguration, source, _logger));
}
public void HandleInspection(Machine inspMachine)
{
DateTime new_last_inspection = new DateTime(1, 1, 1);
inspMachine.LogBroadcast("info",
string.Format("{0} | Maquina {1} | Ultima inspeccion {2}",
inspMachine.smd,
inspMachine.line_barcode,
inspMachine.ultima_inspeccion
)
);
string query = SqlServerQuery.ListLastInspections(inspMachine.maquina, inspMachine.ultima_inspeccion);
DataTable dt = sqlserver.Query(query);
int totalRows = dt.Rows.Count;
aoiWorker.SetProgressTotal(totalRows);
if (totalRows > 0)
{
inspMachine.LogBroadcast("notify",
string.Format("Se encontraron ({0}) inspecciones.", totalRows)
);
int count = 0;
#region CREATE_INSPECTION_OBJECT
foreach (DataRow r in dt.Rows)
{
count++;
ZenithPanel panel = new ZenithPanel(sqlserver, r, inspMachine);
inspMachine.LogBroadcast("info",
string.Format("Programa: [{0}] | PanelBarcode: {1} | Bloques: {2} | Pendiente: {3}", panel.programa, panel.barcode, panel.pcbInfo.bloques, panel.pendiente)
);
if (!Config.debugMode)
{
// TENGO QUE DESCOMENTAR ESTO PARA GUARDAR EN TRAZA
panel.TrazaSave(aoiConfig.xmlExportPath);
aoiWorker.SetProgressWorking(count);
}
// Ultima inspeccion realizada en la maquina ORACLE.
new_last_inspection = DateTime.Parse(panel.fecha + " " + panel.hora);
}
if (new_last_inspection.Year.Equals(1))
{
new_last_inspection = oracle.GetSysDate();
}
#endregion
if (!Config.debugMode)
{
inspMachine.LogBroadcast("debug",
string.Format("Actualizando horario de ultima inspeccion de maquina {0}", new_last_inspection.ToString("HH:mm:ss"))
);
// TENGO QUE DESCOMENTAR ESTO PARA ACTUALIZAR LA ULTIMA INSPECCION
Machine.UpdateInspectionDate(inspMachine.mysql_id, new_last_inspection);
}
}
else
{
inspMachine.LogBroadcast("notify", "No se encontraron inspecciones");
}
inspMachine.Ping();
}
public void Simple_Select_With_WhereClause_Should_Work_As_Expected()
{
var exp = "select * from HumanResources.Employee where VacationHours >= 60";
var exp2 = "select * from HumanResources.Employee where JobTitle = 'Research and Development Engineer'";
Query query = new SqlServerQuery()
.Select("*")
.From("HumanResources.Employee")
.Where("VacationHours >= 60");
Query query2 = new SqlServerQuery()
.Select("*")
.From("HumanResources.Employee")
.Where("JobTitle = 'Research and Development Engineer'");
Assert.AreEqual(exp, query.ToString(), true);
Assert.AreEqual(exp2, query2.ToString(), true);
}
public void Calling_Method_Take_Passing_Negative_Number_Should_Throw()
{
var q = new SqlServerQuery()
.Select("*").From("Person.Person").OrderBy("PersonID").Take(-1);
}
public List <string> GetTables(string connectionString)
{
return(SqlServerQuery.GetTables(connectionString));
}
public void Simple_Select_With_WhereClause_Using_StartsWith()
{
var exp = "select * from Person.Person where FirstName LIKE 'Em%'";
var q = new SqlServerQuery()
.Select("*")
.From("Person.Person")
.WhereField("FirstName")
.StartsWith("Em");
Assert.AreEqual(exp, q.ToString(), true);
}
public void Simple_Select_With_WhereClause_Using_Contains()
{
var exp = "select * from HumanResources.Employee where JobTitle LIKE '%Manager%'";
var q = new SqlServerQuery()
.Select("*")
.From("HumanResources.Employee")
.WhereField("JobTitle")
.Contains("Manager");
Assert.AreEqual(exp, q.ToString(), true);
}
public HttpResponseMessage RemoveData([FromUri] string connectionString, [FromUri] string tableName, [FromBody] List <crud.web.Data.Data> row)
{
return(Request.CreateResponse(HttpStatusCode.OK, SqlServerQuery.DeleteData(connectionString, tableName, row)));
}
public JsonResult GetData(string connectionString, string tableName)
{
return(new JsonResult {
Data = JsonConvert.SerializeObject(SqlServerQuery.GetData(connectionString, tableName))
});
}
public void HandlePendientInspection()
{
List <Pendiente> pendList = Pendiente.Download(aoiConfig.machineNameKey);
aoiLog.debug("Verificando inspecciones pendientes. Total: " + pendList.Count);
if (pendList.Count > 0)
{
int count = 0;
aoiWorker.SetProgressTotal(pendList.Count);
foreach (Pendiente pend in pendList)
{
// Busco ultimo estado del barcode
string query = SqlServerQuery.ListPanelBarcodeInfo(pend);
DataTable dt = sqlserver.Query(query);
int totalRows = dt.Rows.Count;
if (totalRows > 0)
{
count++;
DataRow lastRow = dt.Rows[0];
Machine inspMachine = Machine.list.Single(obj => obj.tipo == aoiConfig.machineNameKey && obj.mysql_id == pend.idMaquina);
if (Config.isByPassMode(inspMachine))
{
// SKIP MACHINE
inspMachine.LogBroadcast("warning",
string.Format("{0} {1} | En ByPass, no se analiza modo pendiente de {2}",
inspMachine.maquina,
inspMachine.smd,
pend.barcode)
);
}
else
{
ZenithPanel panel = new ZenithPanel(sqlserver, lastRow, inspMachine);
if (panel.pendiente)
{
inspMachine.LogBroadcast("info",
string.Format("+ Sigue pendiente Programa: [{0}] | PanelBarcode: {1} | Bloques: {2} | Pendiente: {3}", panel.programa, panel.barcode, panel.totalBloques, panel.pendiente)
);
}
else
{
inspMachine.LogBroadcast("info",
string.Format("+ Inspeccion detectada! Programa: [{0}] | PanelBarcode: {1} | Bloques: {2} | Pendiente: {3}", panel.programa, panel.barcode, panel.totalBloques, panel.pendiente)
);
panel.pendienteDelete = true;
// TENGO QUE DESCOMENTAR ESTO PARA GUARDAR EN TRAZA
panel.TrazaSave(aoiConfig.xmlExportPath);
// ELIMINO LA INSPECCION PENDIENTE
Pendiente.Delete(panel);
}
}
}
else
{
aoiLog.debug("No se detectaron actualizaciones de estado");
}
}
}
}
public void Simple_Select_With_WhereClause_With_Two_Conditions_Should_Work_As_Expected()
{
var exp = "select * from HumanResources.Employee where VacationHours >= 60 AND SickLeaveHours < 100";
Query q = new SqlServerQuery()
.Select("*")
.From("HumanResources.Employee")
.Where("VacationHours >= 60")
.Where("SickLeaveHours < 100");
Assert.AreEqual(exp, q.ToString(), true);
}
public List <string> GetDatabases(string connectionString)
{
return(SqlServerQuery.Connect(connectionString));
}
