/// <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; } }
internal ProcessLog(DataModels.LProcesslog data) : this() { this.Id = data.Id; this.ProcessLogId = data.ProcessLogId; this.AssemblyLineId = data.AssemblyLineId; this.ProcessId = data.ProcessId; 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.LProcesslog ToData() { DataModels.LProcesslog data = new DataModels.LProcesslog(); data.Id = this.Id; data.ProcessLogId = this.ProcessLogId; data.AssemblyLineId = this.AssemblyLineId; data.ProcessId = this.ProcessId; 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 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; } }