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