/// <summary>
/// 更新工艺子流程日志
/// </summary>
/// <param name="log">日志对象</param>
/// <returns></returns>
public bool UpdateExProcessLog(ProcessData.ExProcessLog log)
{
try
{
bool isUpdate = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
DataModels.LExprocesslog data = dataContext.LExprocesslogs.SingleOrDefault(c => c.ExProcessLogId == log.ExProcessLogId);
data.FinishTime = log.FinishTime;
data.ProcessStatus = log.ProcessStatus.ToString();
data.ProduceMaterialType = log.ProduceMaterialType.ToString();
data.Production = log.Production;
data.TakeTime = log.TakeTime;
dataContext.Update <DataModels.LExprocesslog>(data);
isUpdate = true;
}
}
return(isUpdate);
}
catch
{
throw;
}
}
internal ExProcessLog(DataModels.LExprocesslog data) : this()
{
this.Id = data.Id;
this.ExProcessLogId = data.ExProcessLogId;
this.ProcessLogId = data.ProcessLogId;
this.ExProcessId = data.ExProcessId;
this.Created = data.Created;
this.CreateUser = data.CreateUser;
this.FinishTime = data.FinishTime;
this.ProcessStatus = SysHelper.Enums.EnumHelper.Parse <SysHelper.Enums.ProcessStatusType>(data.ProcessStatus);
this.ProduceMaterialType = SysHelper.Enums.EnumHelper.Parse <SysHelper.Enums.MaterialTypeEnum>(data.ProduceMaterialType);
this.Production = data.Production;
this.TakeTime = data.TakeTime;
}
internal DataModels.LExprocesslog ToData()
{
DataModels.LExprocesslog data = new DataModels.LExprocesslog();
data.Id = this.Id;
data.ExProcessLogId = this.ExProcessLogId;
data.ProcessLogId = this.ProcessLogId;
data.ExProcessId = this.ExProcessId;
data.Created = this.Created;
data.CreateUser = this.CreateUser;
data.FinishTime = this.FinishTime;
data.ProcessStatus = this.ProcessStatus.ToString();
data.ProduceMaterialType = this.ProduceMaterialType.ToString();
data.Production = this.Production;
data.TakeTime = this.TakeTime;
return(data);
}
/// <summary>
/// 添加工艺子流程日志数据
/// </summary>
/// <param name="log">日志对象</param>
/// <returns></returns>
public bool AddExProcessLog(ProcessData.ExProcessLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//{工艺主流程日志编号}-{子流程编码}-{2位流水号}
//获取工艺子流程数据
string strSQL = "select SortCode from p_exprocess where ExProcessId=?ExProcessId ";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>
{
new MySqlParameter("?ExProcessId", log.ExProcessId)
};
string strSortCode = MySqlHelper.ExecuteScalar(CommandType.Text, strSQL, sqlParameters.ToArray()).ToString();
//获取已经执行的流程数量
strSQL = "select count(*) from L_ExProcessLog where ProcessLogId=?ProcessLogId and ExProcessId=?ExProcessId";
sqlParameters.Clear();
sqlParameters.Add(new MySqlParameter("?ProcessLogId", log.ProcessLogId));
sqlParameters.Add(new MySqlParameter("?ExProcessId", log.ExProcessId));
int iNowSum = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, strSQL, sqlParameters.ToArray()));
string strNewLogCode = string.Format("{0}-{1}-{2:00}", log.ProcessLogId, strSortCode, iNowSum);
log.ExProcessLogId = strNewLogCode;
DataModels.LExprocesslog data = log.ToData();
dataContext.Insert <DataModels.LExprocesslog>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
