/// <summary>
/// 更新工艺主流程日志
/// </summary>
/// <param name="log">日志对象</param>
/// <returns></returns>
public bool UpdateMainProcessLog(ProcessData.ProcessLog log)
{
try
{
bool isUpdate = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
DataModels.LProcesslog data = dataContext.LProcesslogs.SingleOrDefault(c => c.ProcessLogId == log.ProcessLogId);
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.LProcesslog>(data);
isUpdate = true;
}
}
return(isUpdate);
}
catch
{
throw;
}
}
public bool AddProcessLog(ProcessData.ProcessLog log)
{
try
{
bool isAdd = false;
return(isAdd);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加工艺主流程日志
/// </summary>
/// <param name="log">日志对象</param>
/// <returns></returns>
public bool AddMainProcessLog(ProcessData.ProcessLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
//提取得到新的流水号
//{生产线编号}-{年月日}-{2位流水号}
//string strYMD = DateTime.Now.ToString("yyMMdd");
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//先查询日志集合
string strSQL = "select count(*) from l_processlog where AssemblyLineId=?AssemblyLineId and DATE_FORMAT(created,'%Y%m%d') = ?NowDate";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>
{
new MySqlParameter("?AssemblyLineId", log.AssemblyLineId)
, new MySqlParameter("?NowDate", log.Created)
};
int iNowSum = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, strSQL, sqlParameters.ToArray()));
string strNewLogCode = string.Format("{0}-{1:yyMMdd}-{2:00}", log.AssemblyLineId, log.Created, iNowSum);
log.ProcessLogId = strNewLogCode;
DataModels.LProcesslog data = log.ToData();
dataContext.Insert <DataModels.LProcesslog>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
