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