internal static DataTable ExecuteSp(String sp, String parameter, Boolean developerMode) { string call = "CALL "; String spName = call + sp + "('" + parameter + @"');"; String connectionString = "ConnectToMySQLAutoRequest"; DataTable dt = new DataTable(); dt = Conectivity.ConnectItAndExecuteSPAndBringResultsMySQL(spName, connectionString); return(dt); }
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"); } }