internal static DataTable ExecuteSpDefaultStorage(String sp, String parameter, Boolean developerMode)
{
String connectionString = "ConnectToMaidana";
DataTable dt = new DataTable();
String queryForWareHouse = @"SELECT * FROM `ins_result` WHERE `id_instruction` = '16' AND `field2` = '" + parameter + "' ORDER BY `field2` DESC";
dt = Conectivity.ConnectItAndExecuteMYSQL(queryForWareHouse, connectionString);
return(dt);
}
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);
}
internal static DataTable GetLPNFromInterface()
{
String connectionString = "ConnectToInterfaceDESA";
String queryString = "SELECT * FROM [Traza_material].[dbo].[XXE_WMS_COGISCAN_PEDIDO_LPNS] WHERE STATUS = 'NEW'";
DataTable queryTable = new DataTable();
try
{
queryTable = Conectivity.ConnectItAndBringResults(queryString, connectionString);
}
catch (Exception e) { queryTable = null; LogThis.LogThisValue(e); }
return(queryTable);
}
static public DataSet showData()
{
DataSet db = new DataSet();
String connectionString = "ConectCYGNUSDBAP3";
String queryString = "_AC_SP_EXCEL_PRODUCCION_Push";
DataTable queryTable = new DataTable();
try
{
queryTable = Conectivity.ConnectItAndExecuteSPAndBringResults(queryString, connectionString);
}
catch (Exception e) { db = null; LogThis.LogThisValue(e); }
return(db);
}
/*****************************************************************************************************/
/******************************* PIZARRA DATABASE ****************************************************/
internal static String IAServerInsertionLog(Entity.EntityInitRawMaterial q, string p)
{
if (p != null)
{
String partNumber = SQLDataManager.selectValuesFromMateriales(q.NumMaterial);
String lastInserted = "";
String connectionStringFromAppConfig = "ConnectToMySQL";
String insertStringToMateriales =
"INSERT INTO materiales(NumMaterial,Material,Orig_Ubic_Alm,Orig_Cant,Conf_Fecha,Conf_Hora,Conf_Usuario,Descripcion,Cantidad,Num_Pallet,Num_Ord_Transp,TimeStamp) values ('" + q.NumMaterial + "','"
+ partNumber + "','"
+ q.Orig_Ubic_Alm + "','"
+ q.Orig_Cant + "','"
+ q.Conf_Fecha + "','"
+ q.Conf_Hora + "','"
+ q.Conf_Usuario + "','"
+ q.Descripcion + "','"
+ q.Cantidad + "','"
+ q.Num_Pallet + "','"
+ q.Num_Ord_Transp +
"',NOW())";
DataTable queryTable = new DataTable();
try
{
Conectivity.ConnectItAndExecuteMYSQL(insertStringToMateriales, connectionStringFromAppConfig);
lastInserted = GetLastMySQLInsertedId("materiales", "idMateriales", "ConnectToMySQL");
if (lastInserted == null || lastInserted == "")
{
lastInserted = "1";
}
String insertStringToDetMateriales = "INSERT INTO wsmensajeresponse(idMateriales,detalleMensaje) VALUES ('" + lastInserted + "','" + p + "')";
Conectivity.ConnectItAndExecuteMYSQL(insertStringToDetMateriales, connectionStringFromAppConfig);
}
catch (Exception e)
{ System.Console.WriteLine(e.Message); }
return(p);
}
else
{
return(null);
}
}
/*****************************************************************************************************/
/******************************* SYGNUS DATABASE ******************************************************/
static public DataTable getTypeData(String idMaterial, String fechaIni, String fechaFin, String ubicacion)
{
String queryString = "EXEC [dbo].[_AC_SP_EXCEL_PRODUCCION_Push] @IdUbicacion = " +
ubicacion + ", @FechaDesde = " +
fechaIni + ", @FechaHasta = " +
fechaFin + ", @IdMaterial = " +
idMaterial + "";
String connectionString = "ConectCYGNUSDBAP3";
DataTable queryTable = new DataTable();
try
{ queryTable = Conectivity.ConnectItAndBringResults(queryString, connectionString); }
catch (Exception e) { queryTable = null; LogThis.LogThisValue(e); }
return(queryTable);
}
private static DataTable getTheOPERATION_SEQ(string OP)
{
String connectionString = "ConnectToInterfaceDESA";
String queryString = @"SELECT [OPERATION_SEQ_NUM]
FROM [Traza_material].[dbo].[XXE_WMS_COGISCAN_WIP]
where OP_NUMBER ='" + OP + "'";
DataTable queryTable = new DataTable();
try
{
queryTable = Conectivity.ConnectItAndBringResults(queryString, connectionString);
}
catch (Exception e) { queryTable = null; }
return(queryTable);
}
internal static string selectValuesFromMateriales(string p)
{
String connectionString = "ConectCYGNUSDBAP3";
String queryString = "Select * from Materiales where NumMaterial='" + p + "'";
DataTable queryTable = new DataTable();
String value = "";
try
{
queryTable = Conectivity.ConnectItAndBringResults(queryString, connectionString);
DataRow dtr = queryTable.Rows[0];
value = dtr["DatosPrivados2"].ToString();
}
catch (Exception e) { queryTable = null; LogThis.LogThisValue(e); }
return(value);
}
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);
}