public int DelPath(int int_0, string string_0)
{
string str = "AppSvr_DelPath";
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@pathID", int_0), new SqlParameter("@pathName", string_0) };
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public int DelRegion(string string_0)
{
string str = "AppSvr_DelRegion";
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@regionName", string_0) };
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public static int UpdateDriverInfor(int int_0, int int_1, DateTime dateTime_0, int int_2, string string_0, string string_1, string string_2, DateTime dateTime_1)
{
SqlDataAccess access = new SqlDataAccess();
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@carid", int_0), new SqlParameter("@Status", int_1), new SqlParameter("@ReportTime", dateTime_0), new SqlParameter("@ReadResult", int_2), new SqlParameter("@DriverName", string_0), new SqlParameter("@LaborQualificationNo", string_1), new SqlParameter("@releaseName", string_2), new SqlParameter("@validity", dateTime_1), new SqlParameter("@ErrMsg", SqlDbType.Int) };
object obj2 = 1;
access.updateBySp("WebGpsClient_UpdateDriverInforEx", parameterArray, "@ErrMsg", out obj2);
return Convert.ToInt32(obj2);
}
public static int UpdateDriverInfor(int int_0, string string_0, string string_1, string string_2, string string_3)
{
SqlDataAccess access = new SqlDataAccess();
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@carid", int_0), new SqlParameter("@IdentityCard", string_0), new SqlParameter("@LaborQualificationNo", string_1), new SqlParameter("@DriverName", string_2), new SqlParameter("@releaseName", string_3), new SqlParameter("@ErrMsg", SqlDbType.Int) };
object obj2 = 1;
access.updateBySp("WebGpsClient_UpdateDriverInfor", parameterArray, "@ErrMsg", out obj2);
return Convert.ToInt32(obj2);
}
public int UpdateTrafficPathAlarm_tmp(int int_0, int int_1, string string_0, string string_1, int int_2, int int_3, int int_4, int int_5, string string_2, string string_3, int int_6, int int_7, int int_8)
{
string str = "AppSvr_UpdateTrafficPathAlarm_tmp";
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@WrkID", int_0), new SqlParameter("@OrderID", int_1), new SqlParameter("@carID", string_0), new SqlParameter("@pathName", string_1), new SqlParameter("@choose", int_2), new SqlParameter("@topSpeed", int_3), new SqlParameter("@holdTime", int_4), new SqlParameter("@NewPathID", int_5), new SqlParameter("@BeginTime", string_2), new SqlParameter("@EndTime", string_3), new SqlParameter("@PathFlag", int_6), new SqlParameter("@DriEnough", int_7), new SqlParameter("@DriNoEnough", int_8) };
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public int UpdateRegionParam(int int_0, int int_1, int int_2, int int_3, int int_4, float float_0, float float_1, int int_5, string string_0, string string_1, int int_6, string string_2, string string_3, string string_4, int int_7, int int_8, int? nullable_0, int? nullable_1)
{
string str = "AppSvr_UpdateRegionParam_tmp";
SqlParameter[] parameterArray = new SqlParameter[0x12];
parameterArray[0] = new SqlParameter("@WrkID ", int_0);
parameterArray[1] = new SqlParameter("@OrderID ", int_1);
parameterArray[2] = new SqlParameter("@carID ", int_2);
parameterArray[3] = new SqlParameter("@regionID ", int_3);
parameterArray[4] = new SqlParameter("@param ", int_4);
parameterArray[5] = new SqlParameter("@toEndTime ", float_0);
parameterArray[6] = new SqlParameter("@toBackTime ", float_1);
parameterArray[7] = new SqlParameter("@regionType ", int_5);
parameterArray[8] = new SqlParameter("@time1 ", string_0);
parameterArray[9] = new SqlParameter("@time2 ", string_1);
parameterArray[10] = new SqlParameter("@regionFeature ", int_6);
parameterArray[11] = new SqlParameter("@AlarmCondition", string_2);
parameterArray[12] = new SqlParameter("@planUpTime ", string_3);
parameterArray[13] = new SqlParameter("@planDownTime ", string_4);
parameterArray[14] = new SqlParameter("@NewRegionID ", int_7);
parameterArray[15] = new SqlParameter("@AlarmFlag ", int_8);
if (!nullable_0.HasValue)
{
parameterArray[0x10] = new SqlParameter("@MaxSpeed ", DBNull.Value);
}
else
{
parameterArray[0x10] = new SqlParameter("@MaxSpeed ", nullable_0);
}
if (!nullable_1.HasValue)
{
parameterArray[0x11] = new SqlParameter("@HodeTime ", DBNull.Value);
}
else
{
parameterArray[0x11] = new SqlParameter("@HodeTime ", nullable_1);
}
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public int UpdateCarconfigOnDuty(string string_0, int int_0, int int_1, int int_2)
{
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@carid", string_0), new SqlParameter("@isOnDuty", int_0), new SqlParameter("@isCloseGsm", int_1), new SqlParameter("@isCloseDial", int_2) };
string str = "WebGpsClient_Updategpscarconfig";
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public int SaveCarSetParam(int int_0, string string_0, string string_1, string string_2)
{
string str = "Appsvr_GpsCarSetParam";
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@WrkID", int_0), new SqlParameter("@CarParamInfo", string_0), new SqlParameter("@MsgType", string_1), new SqlParameter("@Param", string_2) };
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public int SaveCarCmdParam(int int_0, string string_0, string string_1, string string_2, string string_3, string string_4, string string_5)
{
string str = "WebGpsClient_InsertCmdLog";
SqlParameter[] parameterArray = new SqlParameter[7];
parameterArray[0] = new SqlParameter("@WrkID", int_0);
parameterArray[1] = new SqlParameter("@UserID", string_1);
parameterArray[2] = new SqlParameter("@CmdType", string_2);
parameterArray[3] = new SqlParameter("@OrderCode", string_3);
if (string.IsNullOrEmpty(string_4))
{
parameterArray[4] = new SqlParameter("@OptCodeDetail", DBNull.Value);
}
else
{
parameterArray[4] = new SqlParameter("@OptCodeDetail", string_4);
}
parameterArray[5] = new SqlParameter("@CarIDandOrderId", string_0);
parameterArray[6] = new SqlParameter("@CmdContent", string_5);
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public int InsertTrafficSegmentParam(string string_0, int int_0, int int_1, int? nullable_0, int? nullable_1, int? nullable_2, int? nullable_3, int int_2, int int_3)
{
string str = "WebGpsClient_UpdateGpsPathSegmentParam";
SqlParameter[] parameterArray = new SqlParameter[9];
parameterArray[0] = new SqlParameter("@carID", string_0);
parameterArray[1] = new SqlParameter("@pathID", int_0);
parameterArray[2] = new SqlParameter("@PathSegmentID", int_1);
if (!nullable_0.HasValue)
{
parameterArray[3] = new SqlParameter("@topSpeed", DBNull.Value);
}
else
{
parameterArray[3] = new SqlParameter("@topSpeed", nullable_0);
}
if (!nullable_1.HasValue)
{
parameterArray[4] = new SqlParameter("@holdTime", DBNull.Value);
}
else
{
parameterArray[4] = new SqlParameter("@holdTime", nullable_1);
}
if (!nullable_2.HasValue)
{
parameterArray[5] = new SqlParameter("@DriEnough", DBNull.Value);
}
else
{
parameterArray[5] = new SqlParameter("@DriEnough", nullable_2);
}
if (!nullable_3.HasValue)
{
parameterArray[6] = new SqlParameter("@DriNoEnough", DBNull.Value);
}
else
{
parameterArray[6] = new SqlParameter("@DriNoEnough", nullable_3);
}
parameterArray[7] = new SqlParameter("@Flag", int_2);
parameterArray[8] = new SqlParameter("@PathWidth", int_3);
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
public int InsertIntoCaptureParam(string string_0, CaptureEx captureEx_0)
{
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CarId", string_0), new SqlParameter("@IsMultiFrame ", captureEx_0.IsMultiFrame), new SqlParameter("@CamerasID ", captureEx_0.CamerasID), new SqlParameter("@CaptureFlag ", captureEx_0.CaptureFlag), new SqlParameter("@CapTureMask ", captureEx_0.CaptureCache), new SqlParameter("@Times ", captureEx_0.Times), new SqlParameter("@CatchInterval ", captureEx_0.Interval), new SqlParameter("@Quality ", captureEx_0.Quality), new SqlParameter("@Brightness ", captureEx_0.Brightness), new SqlParameter("@Contrast ", captureEx_0.Contrast), new SqlParameter("@Saturation ", captureEx_0.Saturation), new SqlParameter("@Chroma ", captureEx_0.Chroma), new SqlParameter("@capWhenStop ", captureEx_0.CapWhenStop) };
string str = "WebGpsClient_UpdateImageControl";
SqlDataAccess access = new SqlDataAccess();
return access.updateBySp(str, parameterArray);
}
