/// <summary>
/// 添加工艺子流程步骤日志表
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public bool AddExProcessStepLog(ProcessData.ExProcessStepLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//获取已经执行的步骤数量
string strSQL = "select count(*) from l_exprocesssteplog where ExProcessLogId=?ExProcessLogId";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>();
sqlParameters.Add(new MySqlParameter("?ExProcessLogId", log.ExProcessLogId));
int iNowSum = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, strSQL, sqlParameters.ToArray()));
//{工艺子流程日志编号}-{2位流水号}
string strNewLogCode = string.Format("{0}-{1:00}", log.ExProcessLogId, iNowSum);
log.ExProcessStepLogId = strNewLogCode;
DataModels.LExprocesssteplog data = log.ToData();
dataContext.Insert <DataModels.LExprocesssteplog>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
internal ExProcessStepLog(DataModels.LExprocesssteplog data) : this()
{
this.Id = data.Id;
this.ExProcessStepLogId = data.ExProcessStepLogId;
this.ExProcessLogId = data.ExProcessLogId;
this.Created = data.Created;
this.CreateUser = data.CreateUser;
this.ProcessDeviceId = data.ProcessDeviceId;
this.DeviceId = data.DeviceId;
this.StepId = data.StepId;
this.ActionType = SysHelper.Enums.EnumHelper.Parse <SysHelper.Enums.DeviceActionType>(data.ActionType);
}
internal DataModels.LExprocesssteplog ToData()
{
DataModels.LExprocesssteplog data = new DataModels.LExprocesssteplog();
data.Id = this.Id;
data.ExProcessStepLogId = this.ExProcessStepLogId;
data.ExProcessLogId = this.ExProcessLogId;
data.Created = this.Created;
data.CreateUser = this.CreateUser;
data.ProcessDeviceId = this.ProcessDeviceId;
data.DeviceId = this.DeviceId;
data.StepId = this.StepId;
data.ActionType = this.ActionType.ToString();
return(data);
}
