/// <summary>
/// 按指定顺序编号获取对应的工艺子流程数据
/// </summary>
/// <param name="strProcessId"></param>
/// <param name="iOrderIndex"></param>
/// <returns></returns>
public TeExProcess GetTeExProcess(string strProcessId, int iOrderIndex)
{
try
{
DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB();
//获取数据
DataModels.PExprocess data = dataContext.PExprocesses.SingleOrDefault(c => c.ProcessId == strProcessId & c.ProcessOrderId == iOrderIndex);
if (data != null)
{
TeExProcess item = new TeExProcess(data);
//提取对应的子集合
string strExProcessId = item.ExProcessId;
ExProcessStepCollection steps = GetExProcessSteps(strExProcessId);
foreach (ExProcessStep step in steps)
{
ExProcessStepParsCollection pars = GetExProcessStepPars(step.StepId);
step.StepPars = pars;
}
item.Steps = steps;
return(item);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取工业子流程所有信息
/// </summary>
/// <param name="strExProcessId">工业子流程编号</param>
/// <returns></returns>
public TeExProcess GetTeExProcess(string strExProcessId)
{
try
{
TeExProcess item = new TeExProcess();
string strSQL = "select *from p_exprocess where ExProcessId=?ExProcessId";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>
{
new MySqlParameter("?ExProcessId", strExProcessId)
};
DataSet dataSet = MySqlHelper.GetDataSet(CommandType.Text, strSQL, sqlParameters.ToArray());
if (dataSet.Tables.Count > 0)
{
DataTable table = dataSet.Tables[0];
if (table.Rows.Count > 0)
{
Dictionary <string, Type> dEnum = new Dictionary <string, Type>();
dEnum.Add("ParType", typeof(SysHelper.Enums.DeviceParameterType));
TeExProcessCollection infos = new TeExProcessCollection();
CreateDataList <TeExProcess>(infos, strSQL, sqlParameters, item, dEnum);
//item = EntityHelper.GetEntityListByDT<TeExProcess>(table.Rows[0], null);
item = infos[0];
#region 提前相关的步骤集合
ExProcessStepCollection steps = GetExProcessSteps(strExProcessId);
foreach (ExProcessStep step in steps)
{
ExProcessStepParsCollection pars = GetExProcessStepPars(step.StepId);
step.StepPars = pars;
}
item.Steps = steps;
#endregion
}
}
return(item);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取工业主流程包含的子流程数据
/// </summary>
/// <param name="strProcessId"></param>
/// <returns></returns>
public TeExProcessCollection GetTeExProcessCollection(string strProcessId)
{
try
{
TeExProcessCollection infos = new TeExProcessCollection();
//using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
//{
// var datas = (from c in dataContext.PExprocesses
// where c.ProcessId == strProcessId
// select c
// ).ToList();
// foreach(DataModels.PExprocess data in datas)
// {
// TeExProcess info = new TeExProcess();
// info.ProcessId = data.ProcessId;
// info.ExProcessId = data.ExProcessId;
// info.ExProcessTitle = data.ExProcessTitle;
// infos.Add(info);
// }
//}
string strSQL = "select *from v_exprocess where ProcessId=?ProcessId order by processOrderId";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>
{
new MySqlParameter("?ProcessId", strProcessId)
};
TeExProcess info = new TeExProcess();
Dictionary <string, Type> dEnum = new Dictionary <string, Type>();
dEnum.Add("ParType", typeof(SysHelper.Enums.DeviceParameterType));
//获取主数据
CreateDataList <TeExProcess>(infos, strSQL, sqlParameters, info, dEnum);
return(infos);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 生产线启动生产流程
/// </summary>
/// <param name="strAssemblyLineId"></param>
public void StartProcess(string strAssemblyLineId, string strCreateUser, DeviceAction deviceAction)
{
try
{
//读取生产线数据
DataHelper dataHelper = new DataHelper();
DataLogHelper logHelper = new DataLogHelper();
AssemblyLineInfo assembly = dataHelper.GetAssemblyLine(strAssemblyLineId);
//线程休眠的基础单位
int iSleepUnit = 1000;
if (assembly != null)
{
//获取生产线的所有设备信息
DeviceInfoCollection devices = dataHelper.GetAssemblyLineDevices(strAssemblyLineId);
//获取相应的工艺流程信息
TechnologicalProcess process = dataHelper.GetTechnologicalProcess(assembly.ProcessId);
DateTime dtMainStart = DateTime.Now;
#region 主工艺流程日志记录
ProcessLog proLog = new ProcessLog()
{
AssemblyLineId = strAssemblyLineId,
ProcessId = process.ProcessId,
Created = DateTime.Now,
CreateUser = strCreateUser,
ProcessStatus = SysHelper.Enums.ProcessStatusType.Start,
ProduceMaterialType = SysHelper.Enums.MaterialTypeEnum.Z,
Production = decimal.Zero,
TakeTime = 0
};
logHelper.AddMainProcessLog(proLog);
#endregion
//子工艺流程步骤数量
int iExProcessNum = 3;
#region 工艺子流程循环
for (int iExIndex = 1; iExIndex <= iExProcessNum; iExIndex++)
{
//提取子工艺流程审批环节
TeExProcess exProcess = dataHelper.GetTeExProcess(process.ProcessId, iExIndex);
if (exProcess != null)
{
//子工艺开始时间
DateTime dtExStart = DateTime.Now;
#region 子工艺流程日志记录
ExProcessLog exLog = new ExProcessLog()
{
ProcessLogId = proLog.ProcessLogId,
ExProcessId = exProcess.ExProcessId,
Created = DateTime.Now,
CreateUser = strCreateUser,
ProcessStatus = SysHelper.Enums.ProcessStatusType.Start,
ProduceMaterialType = SysHelper.Enums.MaterialTypeEnum.Z,
Production = decimal.Zero,
TakeTime = 0
};
//先记录数据
logHelper.AddExProcessLog(exLog);
#endregion
//是否达到启动条件
bool isStartExProcess = false;
#region 判断启动的设备参数是否达到启动条件
DeviceProduceLog deviceLog = logHelper.GetDeviceProduceLog(exProcess.StartDeviceId, exProcess.ParType);
if (deviceLog != null)
{
if (deviceLog.ParValue.Value >= exProcess.ParValue)
{
isStartExProcess = true;
}
}
//循环等待达到启动条件
while (!isStartExProcess)
{
//每个循环先暂停10秒
int iStartSleep = iSleepUnit * 10;
System.Threading.Thread.Sleep(iStartSleep);
deviceLog = logHelper.GetDeviceProduceLog(exProcess.StartDeviceId, exProcess.ParType);
if (deviceLog != null)
{
if (deviceLog.ParValue.Value >= exProcess.ParValue)
{
isStartExProcess = true;
}
}
}
#endregion
if (isStartExProcess)
{
#region 循环启动设备
foreach (ExProcessStep step in exProcess.Steps)
{
//先找到需要操作的设备
foreach (DeviceInfo device in devices)
{
if (device.ProcessDeviceId == step.ProcessDeviceId)
{
string strDeviceId = device.DeviceId;
//定义设备的操作类型
//提取步骤的参数控制数
foreach (ExProcessStepPars par in step.StepPars)
{
#region 记录操作的日志
DeviceActionLog actionLog = new DeviceActionLog()
{
DeviceId = strDeviceId,
Created = DateTime.Now,
CreateUser = strCreateUser,
SensorId = par.SensorId,
ActionType = par.ActionType,
ParType = par.ParType,
ParUnit = par.ParUnit,
ParValue = par.ParValue,
ToDeviceId = string.Empty,
ToSensorId = string.Empty
};
logHelper.AddDeviceActionLog(actionLog);
#endregion
//将操作放入委托里面进行执行(步骤执行完成才执行后续步骤)
if (deviceAction(strDeviceId, par.SensorId, par.ActionType, par.ParType, par.ParValue))
{
//判断是否需要等待
if (par.ParTime > 0)
{
int iSleepSet = par.ParTime * 60 * iSleepUnit;
System.Threading.Thread.Sleep(iSleepSet);
}
//判断是否是完成参数
if (par.IsFinish)
{
}
}
}
break;
}
}
}
#endregion
}
//子工艺完成时间
DateTime dtExEnd = DateTime.Now;
TimeSpan tSpan = dtExEnd - dtExStart;
//得到子工艺完成花费的分钟
exLog.TakeTime = Convert.ToInt32(tSpan.TotalMinutes);
exLog.FinishTime = dtExEnd;
exLog.ProcessStatus = SysHelper.Enums.ProcessStatusType.End;
//exLog.ProduceMaterialType = SysHelper.Enums.MaterialTypeEnum.
logHelper.UpdateExProcessLog(exLog);
}
}
#endregion
DateTime dtMainEnd = DateTime.Now;
TimeSpan mSpan = dtMainEnd - dtMainStart;
proLog.TakeTime = Convert.ToInt32(mSpan.TotalMinutes);
proLog.FinishTime = dtMainEnd;
proLog.ProcessStatus = SysHelper.Enums.ProcessStatusType.End;
logHelper.UpdateMainProcessLog(proLog);
}
}
catch (Exception ex)
{
throw ex;
}
}
