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