/// <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;
}
}
