public bool GetPreviousSequenceMachinesByProcessId(int processId, out List <ProductSequenceItem> machines)
{
machines = new List <ProductSequenceItem>(0);
var check = CheckIfInitialized();
if (!check)
{
return(false);
}
var result = new SqlParameter("@result", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
var parameters = new[]
{
new SqlParameter("@processId", SqlDbType.NVarChar, 30)
{
SqlValue = processId
},
result
};
try
{
var dataset = SqlHelper.ExecuteDataset(_dbConnection, CommandType.StoredProcedure, "GetPreviousSequenceMachinesByProcessId", parameters);
if (dataset.Tables.Count <= 0)
{
return(false);
}
var tables = dataset.Tables[0];
var rowCount = tables.Rows.Count;
if (rowCount <= 0)
{
return(false);
}
machines = new List <ProductSequenceItem>(rowCount);
foreach (DataRow row in tables.Rows)
{
var machine = new ProductSequenceItem
{
Id = row.Field <int>("Id"),
Level = row.Field <int>("Level"),
MachineFamilyId = row.Field <int>("MachineFamilyId"),
ProductSequenceId = row.Field <int>("ProductSequenceId"),
MachineFamilyname = row.Field <string>("MachineFamilyname")
};
machines.Add(machine);
}
return(true);
}
catch (Exception exception)
{
MachineHookException?.Invoke(@"Get Sequence Machine : " + exception.Message);
return(false);
}
}
public bool UnloadReference()
{
_thisMachinePreviousSequenceMachineFamily = new ProductSequenceItem();
_thisMachineReference = new Product();
return(true);
}
public bool GetMachineSequenceItem()
{
_thisMachineSequenceItem = new ProductSequenceItem();
var check = CheckIfInitialized();
if (!check)
{
return(false);
}
var result = new SqlParameter("@result", SqlDbType.Int)
{
Direction = ParameterDirection.Output,
};
var parameters = new[]
{
new SqlParameter("@SequenceId", SqlDbType.Int)
{
SqlValue = _thisMachineReference.SequenceId
},
new SqlParameter("@MachineFamilyId", SqlDbType.Int)
{
SqlValue = _thisMachine.MachineFamilyId
},
result
};
try
{
var prev = SqlHelper.ExecuteDataset(_dbConnection, CommandType.StoredProcedure,
"usp_GetMachineSequenceItem",
parameters);
var code = Convert.ToInt32(result.SqlValue.ToString());
if (code < 1)
{
return(false);
}
if (prev?.Tables.Count > 0)
{
if (prev.Tables[0].Rows.Count > 0)
{
var row = prev.Tables[0].Rows[0];
_thisMachineSequenceItem = new ProductSequenceItem()
{
Id = row.Field <int>("Id"),
Level = row.Field <int>("Level"),
MachineFamilyId = row.Field <int>("MachineFamilyId"),
ProductSequenceId = row.Field <int>("ProductSequenceId"),
MachineFamilyname = row.Field <string>("MachineFamilyname")
};
return(true);
}
}
}
catch (Exception exception)
{
MachineHookException?.Invoke(exception.Message);
}
return(false);
}
