public MovoAlarmSoundSetEntity GetEntityByUserCodeTenantCode(ulong userCode, ulong tenantCode) { string cmdText = string.Format(@" select AlarmSoundID, RobAlarm, PowerDown, FatigueDriving, OverSpeed, StopCar, StopCarAccOn, AreaAlert, TraceAlert, TimingAlert from movo_alarm_sound_set where UserCode={0} and TenantCode={1}", userCode, tenantCode); using (DbDataReader sdr = MySqlDB.GetDataReader(CommandType.Text, cmdText)) { MovoAlarmSoundSetEntity res = new MovoAlarmSoundSetEntity(); res.UserCode = userCode; res.TenantCode = tenantCode; if (sdr != null && sdr.Read()) { res.AlarmSoundID = Convert.ToInt32(sdr["AlarmSoundID"]); res.RobAlarm = ConvertCommon.ConvertToBoolean(sdr["RobAlarm"]); res.PowerDown = ConvertCommon.ConvertToBoolean(sdr["PowerDown"]); res.FatigueDriving = ConvertCommon.ConvertToBoolean(sdr["FatigueDriving"]); res.OverSpeed = ConvertCommon.ConvertToBoolean(sdr["OverSpeed"]); res.StopCar = ConvertCommon.ConvertToBoolean(sdr["StopCar"]); res.StopCarAccOn = ConvertCommon.ConvertToBoolean(sdr["StopCarAccOn"]); res.AreaAlert = ConvertCommon.ConvertToBoolean(sdr["AreaAlert"]); res.TraceAlert = ConvertCommon.ConvertToBoolean(sdr["TraceAlert"]); res.TimingAlert = ConvertCommon.ConvertToBoolean(sdr["TimingAlert"]); sdr.Close(); } else { AddEntity(res); } return res; } }
public ResultEntity AddEntity(MovoAlarmSoundSetEntity entity) { ResultEntity res = new ResultEntity(); try { string cmdText = string.Format(@"insert into movo_alarm_sound_set (UserCode, TenantCode, RobAlarm, PowerDown, FatigueDriving, OverSpeed, StopCar, StopCarAccOn, AreaAlert, TraceAlert, TimingAlert) values({0}, {1}, @RobAlarm, @PowerDown, @FatigueDriving, @OverSpeed, @StopCar, @StopCarAccOn, @AreaAlert, @TraceAlert, @TimingAlert)", entity.UserCode, entity.TenantCode); MySqlParameter[] cmdParams = new MySqlParameter[] { new MySqlParameter("RobAlarm", entity.RobAlarm), new MySqlParameter("PowerDown", entity.PowerDown), new MySqlParameter("FatigueDriving", entity.FatigueDriving), new MySqlParameter("OverSpeed", entity.OverSpeed), new MySqlParameter("StopCar", entity.StopCar), new MySqlParameter("StopCarAccOn", entity.StopCarAccOn), new MySqlParameter("AreaAlert", entity.AreaAlert), new MySqlParameter("TraceAlert", entity.TraceAlert), new MySqlParameter("TimingAlert", entity.TimingAlert) }; int ri = MySqlDB.ExecuteNonQuery(CommandType.Text, cmdText, cmdParams); if (ri > 0) { res.State = true; res.Msg = "新增成功"; } else { res.State = false; res.Msg = "新增失败"; } } catch (Exception ex) { res.State = false; res.Msg = ex.Message; res.ex = ex; Logger.Error("MovoAlarmSoundSetDAL.AddEntity(MovoAlarmSoundSetEntity entity)" + ex.Message, ex); } return res; }
public ResultEntity UpdEntity(MovoAlarmSoundSetEntity entity) { ResultEntity res = new ResultEntity(); try { string cmdText = string.Format(@"update movo_alarm_sound_set set RobAlarm=@RobAlarm, PowerDown=@PowerDown, FatigueDriving=@FatigueDriving, OverSpeed=@OverSpeed, StopCar=@StopCar, StopCarAccOn=@StopCarAccOn, AreaAlert=@AreaAlert, TraceAlert=@TraceAlert, TimingAlert=@TimingAlert where UserCode={0} and TenantCode={1}", entity.UserCode, entity.TenantCode); MySqlParameter[] cmdParams = new MySqlParameter[] { new MySqlParameter("RobAlarm", entity.RobAlarm), new MySqlParameter("PowerDown", entity.PowerDown), new MySqlParameter("FatigueDriving", entity.FatigueDriving), new MySqlParameter("OverSpeed", entity.OverSpeed), new MySqlParameter("StopCar", entity.StopCar), new MySqlParameter("StopCarAccOn", entity.StopCarAccOn), new MySqlParameter("AreaAlert", entity.AreaAlert), new MySqlParameter("TraceAlert", entity.TraceAlert), new MySqlParameter("TimingAlert", entity.TimingAlert) }; int ri = MySqlDB.ExecuteNonQuery(CommandType.Text, cmdText, cmdParams); if (ri > 0) { res.State = true; res.Msg = "更新成功"; } else { res.State = false; res.Msg = "更新失败"; } } catch (Exception ex) { res.State = false; res.Msg = ex.Message; res.ex = ex; Logger.Error("MovoAlarmSoundSetDAL.UpdEntity(MovoAlarmSoundSetEntity entity)" + ex.Message, ex); } return res; }