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;
}
public ResultEntity DeleteMark(Guid id, string tenantCode)
{
ResultEntity res = new ResultEntity();
try
{
string cmdText = string.Format(@"update gps_map_mark set Abolish=1 where RecordID='{0}' and TenantCode='{1}'", id, tenantCode);
int ri = MySqlDB.ExecuteNonQuery(CommandType.Text, cmdText);
if (ri > 0)
{
res.State = true;
res.Msg = "success";
}
else
{
res.State = false;
res.Msg = "unsuccess";
}
}
catch (Exception ex)
{
res.State = false;
res.Msg = "error";
res.ex = ex;
Logger.Error("MarkSearchDAL.DeleteMark(Guid id, string tenantCode)" + ex.Message, ex);
}
return res;
}
/// <summary>
/// 采用事物添加车辆（movo_vehicle，gps_historydatastoreconfig，movo_vehiclelog）
/// </summary>
/// <param name="ve"></param>
/// <param name="conf"></param>
/// <param name="vlog"></param>
/// <returns></returns>
public ResultEntity AddVehicleOperTrans(EMVehicle ve, EHistoryDataStoreConfig conf, EMVehicleLog vlog)
{
ResultEntity res = new ResultEntity();
MySqlConnection con = new MySqlConnection(MySqlDB.ConnString);
con.Open();
MySqlTransaction trans = con.BeginTransaction();
MySqlCommand cmd = con.CreateCommand();
cmd.Transaction = trans;
try
{
cmd.CommandText = string.Format(@" insert into movo_vehicle(VehicleCode,LicenceNumber,GroupID,GPSTypeID,DeviceNo,SIMNo,GPSCode,TenantCode,InitMileage,ExpireTime,InstallTime,IsStop,CreateTime,IconType,GPSTypeName)
values(@VehicleCode,@LicenceNumber,@GroupID,@GPSTypeID,@DeviceNo,@SIMNo,@GPSCode,@TenantCode,@InitMileage,@ExpireTime,@InstallTime,@IsStop,@CreateTime,@IconType,@GPSTypeName)");
cmd.Parameters.AddRange(new MySqlParameter[] {
new MySqlParameter("VehicleCode", ve.VehicleCode ),
new MySqlParameter("LicenceNumber", ve.LicenceNumber),
new MySqlParameter("GroupID", ve.GroupID),
new MySqlParameter("GPSTypeID", ve.GPSTypeID),
new MySqlParameter("DeviceNo", ve.DeviceNo),
new MySqlParameter("SIMNo", ve.SIMNo),
new MySqlParameter("GPSCode", ve.GPSCode),
new MySqlParameter("TenantCode", ve.TenantCode),
new MySqlParameter("InitMileage",ve.InitMileage ),
new MySqlParameter("ExpireTime", ve.ExpireTime),
new MySqlParameter("InstallTime", ve.InstallTime),
new MySqlParameter("IsStop", ve.IsStop),
new MySqlParameter("CreateTime", ve.CreateTime),
new MySqlParameter("IconType", ve.IconType),
new MySqlParameter("GPSTypeName", ve.GPSTypeName)
});
int veCount = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (veCount < 1)
{
trans.Rollback();
res.State = false;
res.Msg = "车辆表【movo_vehicle】新增失败";
return res;
}
cmd.CommandText = string.Format(@"insert into gps_historydatastoreconfig(RecordID,VehicleCode,StoreTable,Enable,CreateDate,remark)
values(@RecordIDconf,@VehicleCodeconf,@StoreTableconf,@Enableconf,@CreateDateconf,@remarkconf)");
cmd.Parameters.AddRange(new MySqlParameter[] {
new MySqlParameter("RecordIDconf", conf.RecordID),
new MySqlParameter("VehicleCodeconf", conf.VehicleCode),
new MySqlParameter("StoreTableconf", conf.StoreTable.RecordID),
new MySqlParameter("Enableconf", conf.Enable),
new MySqlParameter("CreateDateconf", conf.CreateDate),
new MySqlParameter("remarkconf", conf.Remark)
});
int confCount = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (confCount < 1)
{
trans.Rollback();
res.State = false;
res.Msg = "车辆历史数据配置表【gps_historydatastoreconfig】新增失败";
return res;
}
cmd.CommandText = string.Format(@"insert into movo_vehiclelog(LogID,VehicleCode,LicenceNumber,GroupID,GPSTypeID,DeviceNo,SIMNo,GPSCode,TenantCode,BeginDate,EndDate,Operator,InitMileage)
values(@LogID,@VehicleCodelog,@LicenceNumberlog,@GroupIDlog,@GPSTypeIDlog,@DeviceNolog,@SIMNolog,@GPSCodelog,@TenantCodelog,@BeginDatelog,@EndDatelog,@Operatorlog,@InitMileagelog)");
cmd.Parameters.AddRange(new MySqlParameter[] {
new MySqlParameter("LogID", vlog.LogID),
new MySqlParameter("VehicleCodelog", vlog.VehicleCode),
new MySqlParameter("LicenceNumberlog", vlog.LicenceNumber),
new MySqlParameter("GroupIDlog", vlog.GroupID),
new MySqlParameter("GPSTypeIDlog", vlog.GPSTypeID),
new MySqlParameter("DeviceNolog", vlog.DeviceNo),
new MySqlParameter("SIMNolog", vlog.SIMNo),
new MySqlParameter("GPSCodelog", vlog.GPSCode),
new MySqlParameter("TenantCodelog", vlog.TenantCode),
new MySqlParameter("BeginDatelog", vlog.BeginDate),
new MySqlParameter("EndDatelog", vlog.EndDate),
new MySqlParameter("Operatorlog", vlog.Operator),
new MySqlParameter("InitMileagelog", vlog.InitMileage)
});
int logCount = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (logCount < 1)
{
trans.Rollback();
res.State = false;
res.Msg = "车辆操作日志表【movo_vehiclelog】新增失败";
return res;
}
trans.Commit();
res.State = true;
res.Msg = "新增车辆成功";
}
catch (Exception ex)
{
trans.Rollback();
res.State = false;
res.Msg = "新增车辆失败，" + ex.Message;
}
finally
{
con.Close();
}
return res;
}
