public static String getTheQty(Entity.EntityMaterialRequest material)
{
int valueqtyPerASSYFinal = 0;
String connectionString = "ConnectToInterfaceDESA";
String queryString = @"SELECT [QUANTITY_PER_ASSEMBLY]
FROM [Traza_material].[dbo].[XXE_WMS_COGISCAN_WIP]
where MATERIAL ='" + material.partNumber + "' and OP_NUMBER= '" + material.batchId + "'";
DataTable queryTable = new DataTable();
string valueqtyPerASSY = "";
string valueqtyPerASSYOT = "";
string qtyMath = "";
String queryStringOT = @"SELECT [START_QUANTITY] ,[QUANTITY_COMPLETED] FROM [Traza_material].[dbo].[XXE_WIP_OT]
where WIP_ENTITY_NAME ='" + material.batchId + "'";
DataTable queryTableOT = new DataTable();
try
{
queryTable = Conectivity.ConnectItAndBringResults(queryString, connectionString);
DataRow qtyPerASSYRow = queryTable.Rows[0];
valueqtyPerASSY = qtyPerASSYRow[0].ToString();
queryTableOT = Conectivity.ConnectItAndBringResults(queryStringOT, connectionString);
DataRow qtyPerASSYRowOT = queryTableOT.Rows[0];
valueqtyPerASSYOT = qtyPerASSYRowOT[0].ToString();
string value1 = qtyPerASSYRowOT[0].ToString();
string value2 = qtyPerASSYRowOT[1].ToString();
int valueqtyPerASSYOTNum = Int32.Parse(value1) - Int32.Parse(value2);
int valueqtyPerASSYRowNum = Int32.Parse(qtyPerASSYRow[0].ToString());
valueqtyPerASSYFinal = valueqtyPerASSYOTNum * valueqtyPerASSYRowNum;
int valueqtyPerASSYDelta = Int32.Parse(valueqtyPerASSY) * Int32.Parse(material.remainingBoards);
/*
* TIEMPO DE PEDIDO SETEADO A 200 Minutos
*/
int time4Request = 200;
/*
*/
int InTime = Int32.Parse(material.minutos);
valueqtyPerASSYFinal = (time4Request * valueqtyPerASSYDelta) / InTime;
qtyMath = "(" + time4Request + "*" + valueqtyPerASSYDelta + ")/" + InTime + "--" + Int32.Parse(valueqtyPerASSY) + "*" + Int32.Parse(material.remainingBoards);
}
catch (Exception e) { queryTable = null; }
/*
* Evaluate Delta Monitoring
*/
string queryDeltaMonitorToSearch = @"SELECT `rawMaterialId` FROM `amr_deltamonitor`
WHERE `batchId` LIKE '" + material.batchId + "' AND `idMaquina` LIKE '" + material.idMaquina + "' AND `laneNumber` LIKE '" + material.laneNumber + "' AND `location` LIKE '" + material.location + "' AND `partNumber` LIKE '" + material.partNumber + "' AND `productPartNumber` LIKE '" + material.productPartNumber + "' AND `rawMaterialId` LIKE '" + material.rawMaterialId + "' AND `remainingBoards` LIKE '" + material.remainingBoards + "' AND `valueqtyPerASSYFinal` LIKE '" + valueqtyPerASSYFinal + "'";
DataTable dtqueryDeltaMonitorToSearch = Conectivity.ConnectItAndExecuteSPAndBringResultsMySQL(queryDeltaMonitorToSearch, "ConnectToMySQLAutoRequest");
if (dtqueryDeltaMonitorToSearch.Rows.Count == 15)
{
foreach (DataRow dtrDelta in dtqueryDeltaMonitorToSearch.Rows)
{
String dtrDeltaValue = dtrDelta[0].ToString();
int qtyPerASSY = Int32.Parse(valueqtyPerASSY);
int remainingBoards = Int32.Parse(material.remainingBoards);
int minutesLeft = Int32.Parse(material.minutos);
}
string valueFinal = valueqtyPerASSYFinal.ToString();
return(valueFinal);
}
else
{
string queryDeltaMonitor = @"
INSERT INTO `amr_deltamonitor`(`batchId`, `idMaquina`, `laneNumber`, `location`, `minutos`, `partNumber`, `productPartNumber`, `rawMaterialId`, `remainingBoards`, `timeStampRegistro`, `valueqtyPerASSYFinal`, `qtyMath`)
VALUES
('" + material.batchId + "','" + material.idMaquina + "','" + material.laneNumber + "','" + material.location + "','" + material.minutos + "','" + material.partNumber + "','" + material.productPartNumber + "','" + material.rawMaterialId + "','" + material.remainingBoards + "','" + material.timeStampRegistro + "','" + valueqtyPerASSYFinal + "','" + qtyMath + "')";
Conectivity.ConnectItAndExecuteSPAndBringResultsMySQL(queryDeltaMonitor, "ConnectToMySQLAutoRequest");
string valueFinal = valueqtyPerASSYFinal.ToString();
return(valueFinal + " - WAIT");
}
}
internal static string ExecuteSP_InsertIntoMaterialRequest(string sp, Entity.EntityMaterialRequest emrunity, bool p_2, string statusUbic)
{
string valueOPERATION_SEQ = "";
DataTable dt = new DataTable();
List <Entity.EntityInsertion> listaInsercion = new List <Entity.EntityInsertion>();
/*
* get te OPERATION_SEQ that belongs to each material per OP
*/
try
{
DataTable OPERATION_SEQ = getTheOPERATION_SEQ(emrunity.batchId);
DataRow OPERATION_SEQRow = OPERATION_SEQ.Rows[0];
valueOPERATION_SEQ = OPERATION_SEQRow[0].ToString();
}
catch (Exception e)
{
System.Console.WriteLine("ERROR-7501 - ERROR EN OBTENER [OPERATION_SEQ_NUM]: " + e.Message);
}
string qtyToRequest = emrunity.qtyDefined;
char[] delimiters = new char[] { '\r', ',' };
string[] parts = qtyToRequest.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);
qtyToRequest = parts[0].ToString();
if (String.IsNullOrEmpty(valueOPERATION_SEQ))
{
valueOPERATION_SEQ = "-1";
}
string wipLocation = valueOPERATION_SEQ;
string lineStatus = statusUbic;
listaInsercion.Add(new Entity.EntityInsertion()
{
sp = sp,
batchId = emrunity.batchId,
wipLocation = wipLocation,
rawMaterialId = emrunity.rawMaterialId,
partNumber = emrunity.partNumber,
unityOfMeasure = "EA",
qtyToRequest = qtyToRequest,
laneStatus = "",
laneDestiny = "",
locationOrigin = lineStatus,
status = lineStatus,
laneNumber = emrunity.laneNumber,
idMachine = emrunity.idMaquina,
location = emrunity.location
});
String connectionString = "ConnectToMySQLAutoRequest";
string returnedId = Conectivity.insertIntoMySqlDataBase(listaInsercion, connectionString);
try
{
if ((p_2) && ((returnedId != "")))
{
String insertIntoXXE_WMS_COGISCAN_PEDIDOS = @"
INSERT INTO [XXE_WMS_COGISCAN_PEDIDOS]
([OP_NUMBER]
,[ORGANIZATION_CODE]
,[OPERATION_SEQ]
,[ITEM_CODE]
,[ITEM_UOM_CODE]
,[QUANTITY]
,[PROD_LINE]
,[MAQUINA]
,[UBICACION]
,[STATUS]
,[INSERT_ID])
VALUES
( '" + emrunity.batchId + "', 'UP3', '" + valueOPERATION_SEQ + "', '" + emrunity.partNumber + "', 'EA', '" + qtyToRequest + "', '" + emrunity.laneNumber + "', '" + emrunity.idMaquina + "', '" + emrunity.location + "', 'NEW" + "'" + ", '" + returnedId + "')";
string connect = "ConnectToInterfaceDESA";
if (Conectivity.NotInTheInterface(returnedId))
{
Conectivity.InsertOnEBSInterface(insertIntoXXE_WMS_COGISCAN_PEDIDOS, connect);
Console.WriteLine("ID: " + returnedId + " insertado en la interfaz \n");
}
}
}
catch (Exception errorInterfaceInser)
{ Console.WriteLine("ERROR-10303 - ERROR EN LA INSERCION DE QUERY EN INTEFACE: " + errorInterfaceInser.Message); }
avoidSequence : string sequenceAvoided = "";
return(returnedId);
}
