/// <summary>
/// 调用存储过程查询警情详细信息
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="cid">车辆ID</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <param name="alarmtype">警情类型</param>
/// <returns></returns>
public static DataTable GetMilStatusInfoById(string sysflag, int cid, string stime, string etime, int alarmtype)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@C_ID", cid), new SqlParameter("@T_TimeBegin", stime), new SqlParameter("@T_TimeEnd", etime), new SqlParameter("@AlarmType", alarmtype) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QM_AlarmDetails"), Parameters, null, 300).Tables[0]);
}
/// <summary>
/// 查询电子栅栏车辆关联关系
/// </summary>
/// <param name="key"></param>
/// <param name="uid"></param>
/// <param name="fid"></param>
/// <returns></returns>
private DataTable[] getFenceCarList(string key, string uid, string fid)
{
DataTable[] list = new DataTable[2];
ComSqlHelper oSqlUtil = new ComSqlHelper();
try
{
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[2];
oaPara[0] = new SqlParameter("@Uid", uid);
oaPara[1] = new SqlParameter("@F_ID", fid);
DataSet ds = oSqlUtil.FillDataSet(key, WebProc.Proc("QSProc_QS_FenceCar_List"), oaPara, "fencecartable", 30);
if (ds.Tables.Count == 2)
{
list[0] = ds.Tables[0]; //电子围栏已关联车辆
list[1] = ds.Tables[1]; //电子围栏尚未关联车辆
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据用户名和手机号码获取用户实体信息
/// </summary>
/// <param name="sysflag"></param>
/// <param name="usernameormobilenum"></param>
/// <param name="pwd"></param>
/// <param name="username"></param>
/// <returns></returns>
private void GetUAppIDUserCheck(string sysflag, string usernameormobilenum, string pwd)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@nameormobile", usernameormobilenum), new SqlParameter("@pwd", pwd) };
DataTable dt = csh.FillDataSet(WebProc.GetAppSysflagKey(sysflag), WebProc.Proc("QWGProc_Appvd_GetUserByNameORMobilenum"), Parameters).Tables[0];
if (dt.Rows.Count > 0)
{
appvduser = new userinfos();
string dbpwd = dt.Rows[0]["PASSWORD"].ToString();
appvduser.uid = dt.Rows[0]["UID"].ToString();
appvduser.username = dt.Rows[0]["NAME"].ToString().Trim();
appvduser.pwd = dt.Rows[0]["PASSWORD"].ToString().Trim();
appvduser.mobilenum = dt.Rows[0]["MobileNum"].ToString().Trim();
appvduser.source = dt.Rows[0]["SourceId"].ToString();
appvduser.memo = dt.Rows[0]["MEMO"].ToString();
appvduser.email = dt.Rows[0]["Email"].ToString();
appvduser.fullname = dt.Rows[0]["FullName"].ToString();
appvduser.sex = dt.Rows[0]["SEX"].ToString();
appvduser.phoneno = dt.Rows[0]["PHONENO"].ToString();
appvduser.id_card_no = dt.Rows[0]["ID_CARD_NO"].ToString();
appvduser.adress = dt.Rows[0]["ADDRESS"].ToString();
appvduser.nativeplace = dt.Rows[0]["NATIVEPLACE"].ToString();
appvdreturn.userinfo = appvduser;
}
}
/// <summary>
/// 调用存储过程查询停车明细数据
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="cid">车辆ID</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <param name="stoptime">停车时长</param>
/// <returns></returns>
public static DataTable GetParkTotalInfoById(string sysflag, string cid, string stime, string etime, string stoptime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@C_NO", cid), new SqlParameter("@StartTime", stime), new SqlParameter("@ToTime", etime), new SqlParameter("@StopTime", stoptime) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QS_GetParkDetailsInFo"), Parameters, null, 300).Tables[0]);
}
/// <summary>
/// 调用存储过程查询字典项
/// </summary>
/// <param name="sysflag">系统标识</param>
/// <param name="dictType">字典类别</param>
/// <returns>查询结果</returns>
private DataTable daoGetDictByType(string sysflag, string dictType)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@dictType", dictType) };
return(csh.FillDataSet(sysflag, WebProc.Proc("ALProc_SelectDictByType"), Parameters, null, 1800).Tables[0]);
}
/// <summary>
/// 调用存储过程查询车辆超速详细信息
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="cid">车辆ID</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <param name="ispeed">超速速度</param>
/// <returns></returns>
public static DataTable GetMileageSpeedInfoById(string sysflag, string cid, string stime, string etime, string ispeed)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@c_ID", cid), new SqlParameter("@startTime", stime), new SqlParameter("@endTime", etime), new SqlParameter("@iSpeed", ispeed) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QS_SpeedEverySearch"), Parameters, null, 300).Tables[0]);
}
/// <summary>
/// 调用存储过程获取里程统计详细信息
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="cid">车辆ID</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <returns></returns>
public static DataTable GetCollectInfoById(string sysflag, int cid, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@C_No", cid), new SqlParameter("@T_TimeBegin", stime), new SqlParameter("@T_TimeEnd", etime) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QM_MileageDetails"), Parameters, null, 300).Tables[0]);
}
/// <summary>
/// 取得页面下拉框数据表格
/// </summary>
/// <param name="sysflag">sysflag</param>
/// <returns>DataTable</returns>
private DataTable[] GetAllCmb(string sysflag)
{
DataTable[] dtArr = new DataTable[4];
try
{
ComSqlHelper csh = new ComSqlHelper();
//调用存储过程取得DataSet
DataSet ds = csh.FillDataSet(sysflag, WebProc.Proc("ALProc_GetLogCmb"), null, null, 3600);
if (ds.Tables.Count == 4)
{
dtArr[0] = ds.Tables[0];
dtArr[1] = ds.Tables[1];
dtArr[2] = ds.Tables[2];
dtArr[3] = ds.Tables[3];
}
}
catch (Exception ex)
{
throw ex;
}
return(dtArr);
}
/// <summary>
/// 调用存储过程查询未上线车辆列表
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="uid">用户ID</param>
/// <param name="datime">车辆未在线天数</param>
/// <returns></returns>
public static DataTable GetCarOnLine(string sysflag, string uid, string datime, string onecaruser)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@UserName", uid), new SqlParameter("@NotOnLine", datime), new SqlParameter("@OneCarUser", onecaruser) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QC_CarOnLine"), Parameters, "onlinetbl", 600).Tables[0]);
}
public ResponseResult GetLastPhoto(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
try
{
ComSqlHelper csh = new ComSqlHelper();
string sysflag = inparams["sysflag"];
string cids = inparams["cids"];
SqlParameter[] Parameters0 = new SqlParameter[1];
Parameters0[0] = new SqlParameter("@CIDS", cids);
DataTable dt = csh.FillDataSet(sysflag, WebProc.Proc("GetLastPhotoByCids"), Parameters0).Tables[0];
int Total = dt.Rows.Count;
ResList res = new ResList();
res.page = 0;
res.size = 0;
res.total = Total;
res.records = dt;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, "");
}
return(Result);
}
/// <summary>
/// 调用存储过程获取用户登录统计信息
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="uname">用户名</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <returns></returns>
public static DataTable GetUCountLogin(string sysflag, string uname, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@Company", uname), new SqlParameter("@startTime", stime), new SqlParameter("@endtime", etime) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QS_SearchLogin"), Parameters, "userlogintb", 180).Tables[0]);
}
/// <summary>
/// 调用存储过程查询车辆行驶速度
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="cid">车辆ID</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <returns></returns>
public static DataTable GetSearhSpeeds(string sysflag, string cid, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@C_No", cid), new SqlParameter("@StartDate", stime), new SqlParameter("@EndDate", etime) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QS_GetSpeedInfo"), Parameters, null, 1800).Tables[0]);
}
private string getJsonQueryRourt(string key)
{
string r = "";
//string strCid = "";
try
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[0];
DataTable dt = new DataTable();
dt = oSqlUtil.FillDataSet(key, "QSProc_GetQsLine", oaPara, "RourtData", 30).Tables[0];
if (dt.Rows.Count > 0)
{
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd' 'HH':'mm':'ss";
r = JsonConvert.SerializeObject(dt, timeConverter);
}
}
catch (Exception)
{
r = "";
}
return(r);
}
private string getJsonQueryCarData(string key, string CID)
{
string r = "";
//string strCid = "";
try
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[2];
oaPara[0] = new SqlParameter("@cid", CID);
//oaPara[1] = new SqlParameter("@cid", CID);
DataTable dt = new DataTable();
dt = oSqlUtil.FillDataSet(key, "JLJGPT_CarInforCarDataSelect", oaPara, "CarData", 30).Tables[0];
if (dt.Rows.Count > 0)
{
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd' 'HH':'mm':'ss";
r = JsonConvert.SerializeObject(dt, timeConverter);
}
}
catch (Exception)
{
r = "";
}
return(r);
}
/// <summary>
/// 调用存储过程获取启动熄火车辆列表
/// </summary>
/// <param name="sysflag">系统标识</param>
/// <param name="cid">车辆ID</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <returns></returns>
public static DataTable GetStatusCars(string sysflag, string cid, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@CARID", int.Parse(cid)), new SqlParameter("@BTIME", stime), new SqlParameter("@ETIME", etime) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QP_ParkingInfo"), Parameters, null, 1800).Tables[0]);
}
/// <summary>
/// 根据用户ID获取用户实体信息
/// </summary>
/// <param name="sysflag"></param>
/// <param name="usernameormobilenum"></param>
/// <param name="pwd"></param>
/// <param name="username"></param>
/// <returns>返回用户对象实体</returns>
private userinfos GetUAppIDUserCheckByUpt(string sysflag, string uid)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@uid", uid) };
DataTable dt = csh.FillDataSet(WebProc.GetAppSysflagKey(sysflag), WebProc.Proc("QWGProc_App_GetUserInfo"), Parameters).Tables[0];
if (dt.Rows.Count > 0)
{
userinfos appvduser = new userinfos();
appvduser.uid = dt.Rows[0]["UID"].ToString().Trim();
appvduser.username = dt.Rows[0]["NAME"].ToString().Trim();
appvduser.pwd = dt.Rows[0]["PASSWORD"].ToString().Trim();
appvduser.mobilenum = dt.Rows[0]["MobileNum"].ToString().Trim();
appvduser.memo = dt.Rows[0]["MEMO"].ToString();
appvduser.email = dt.Rows[0]["Email"].ToString();
appvduser.fullname = dt.Rows[0]["FullName"].ToString();
appvduser.sex = dt.Rows[0]["Sex"].ToString();
appvduser.phoneno = dt.Rows[0]["PHONENO"].ToString();
appvduser.id_card_no = dt.Rows[0]["ID_CARD_NO"].ToString();
appvduser.nativeplace = dt.Rows[0]["NATIVEPLACE"].ToString();
appvduser.adress = dt.Rows[0]["ADDRESS"].ToString();
return(appvduser);
}
else
{
return(null);
}
}
/// <summary>
/// 从数据库获取车辆最后轨迹信息
/// </summary>
/// <param name="sysflag">系统标志</param>
/// <param name="cids">车辆id字符串已逗号（,）分割</param>
/// <returns>返回车辆最后轨迹信息</returns>
private DataTable GetCarsLastTrackForDB(string sysflag, string cids)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@cids", cids) };
return(csh.FillDataSet(sysflag, WebProc.Proc("QSProc_GetCarsLastTrack"), Parameters).Tables[0]);
}
private DataTable[] GetOneCarSearch(string sysflag, string cid)
{
DataTable[] dtArr = new DataTable[7];
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid)
};
DataSet ds = csh.FillDataSet(sysflag, WebProc.Proc("QWProc_Wm_Car_InitData_Edit0"), Parameters, null, 3600);
if (ds.Tables.Count == 7)
{
dtArr[0] = ds.Tables[0];
dtArr[1] = ds.Tables[1];
dtArr[2] = ds.Tables[2];
dtArr[3] = ds.Tables[3];
dtArr[4] = ds.Tables[4];
dtArr[5] = ds.Tables[5];
dtArr[6] = ds.Tables[6];
}
}
catch (Exception ex)
{
throw ex;
}
return(dtArr);
}
/// <summary>
/// 根据车辆ID取得编辑页dataTable
/// </summary>
/// <param name="sysflag"></param>
/// <param name="cid"></param>
/// <returns></returns>
private DataTable[] GetBaseInfoByCid(string sysflag, string cid)
{
DataTable[] dtArr = new DataTable[4];
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid)
};
//调用存储过程取得DataSet
DataSet ds = csh.FillDataSet(sysflag, WebProc.Proc("ALProc_QueryAllByCid"), Parameters, null, 3600);
if (ds.Tables.Count == 3)
{
dtArr[0] = ds.Tables[0];
dtArr[1] = ds.Tables[1];
dtArr[2] = ds.Tables[2];
}
}
catch (Exception ex)
{
throw ex;
}
return(dtArr);
}
public static DataTable GetSignalStatistics(string sysflag, string uid, string stime, string etime, string carnum, string cuid, string carownname, string line, string onecaruser)
{
int IsUnion = 0;
DateTime et = DateTime.Parse(etime).Date;
DateTime today = DateTime.Today;
if ((today - et).Days == 0) //结束时间是今天，则查询需要从作业表和轨迹表取数据
{
IsUnion = 1;
}
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@UID", uid),
new SqlParameter("@T_TimeBegin", stime),
new SqlParameter("@T_TimeEnd", etime),
new SqlParameter("@CarNum", carnum),
new SqlParameter("@CUID", cuid),
new SqlParameter("@CarOwnName", carownname),
new SqlParameter("@Line", line),
new SqlParameter("@OneCarUser", onecaruser),
new SqlParameter("@IsUnion", IsUnion)
};
return(csh.FillDataSet(sysflag, WebProc.Proc("QWCProc_IC_SignalStatRA"), Parameters, null, 3600).Tables[0]);
}
private DataTable GetCarListSearch(string sysflag, string sysuid, string carno, string cid, string cuid, string carownname, string line)
{
DataTable dt = new DataTable();
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CarNo", carno),
new SqlParameter("@Cid", cid),
new SqlParameter("@Cuid", cuid),
new SqlParameter("@CarOwnName", carownname),
new SqlParameter("@LineName", line),
new SqlParameter("@U_ID", sysuid)
};
dt = csh.FillDataSet(sysflag, WebProc.Proc("QWProc_Wm_Car_Select0"), Parameters, null, 3600).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
private DataTable[] getRegionCarList(string sysflag, string uid, string rid)
{
DataTable[] list = new DataTable[2];
ComSqlHelper oSqlUtil = new ComSqlHelper();
try
{
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[2];
oaPara[0] = new SqlParameter("@Uid", uid);
oaPara[1] = new SqlParameter("@RegionId", rid);
DataSet ds = oSqlUtil.FillDataSet(sysflag, WebProc.Proc("X80Proc_RegionCar_List"), oaPara, "regioncartable", 30);
if (ds.Tables.Count == 2)
{
list[0] = ds.Tables[0]; //活动区域已关联车辆
list[1] = ds.Tables[1]; //活动区域尚未关联车辆
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 调用存储过程获取试乘试驾信息列表
/// </summary>
/// <param name="sysflag">系统标识</param>
/// <param name="cid">车辆ID</param>
/// <param name="stime">开始时间</param>
/// <param name="etime">结束时间</param>
/// <returns></returns>
public static DataTable GetOutDriveSituation(string sysflag, string cid, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@CARID", int.Parse(cid)), new SqlParameter("@BTIME", stime), new SqlParameter("@ETIME", etime) };
return(csh.FillDataSet(sysflag, WebProc.Proc("X80Proc_XP_OutDriveInfo"), Parameters, null, 1800).Tables[0]);
}
private DataTable getFenceAlarmStatList(string key, string uid, string carno, string cuid, string ownname, string line, string st, string et)
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
try
{
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[7];
oaPara[0] = new SqlParameter("@UID", Int32.Parse(uid));
oaPara[1] = new SqlParameter("@CarNo", carno);
oaPara[2] = new SqlParameter("@CUID", cuid);
oaPara[3] = new SqlParameter("@CarOwnName", ownname);
oaPara[4] = new SqlParameter("@Line", line);
oaPara[5] = new SqlParameter("@StartTime", st);
oaPara[6] = new SqlParameter("@EndTime", et);
DataTable dt = new DataTable();
dt = oSqlUtil.FillDataSet(key, WebProc.Proc("QSProc_QS_FenceAlarmStat"), oaPara, "fencealarmstattable", 30).Tables[0];
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
private DataTable GetUserCars(string sysflag, string uid)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@uid", uid) };
DataTable dt = csh.FillDataSet(WebProc.GetAppSysflagKey(sysflag), WebProc.Proc("QWGProc_App_GetUserCars"), Parameters).Tables[0];
return(dt);
}
private DataTable GetAppAlarmAlert(string sysflag, string cid, string uid, DateTime st, DateTime et)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters = { new SqlParameter("@cid", cid), new SqlParameter("@uid", uid),
new SqlParameter("@st", st), new SqlParameter("@et", et) };
DataTable dt = csh.FillDataSet(WebProc.GetAppSysflagKey(sysflag), WebProc.Proc("QWGProc_App_GetAppAlarmAlert"), Parameters).Tables[0];
return(dt);
}
private DataTable GetFaultDetailList(string sysflag, string cid, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid),
new SqlParameter("@StartTime", stime),
new SqlParameter("@EndTime", etime)
};
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QM_FaultCodeStatisticDetail"), Parameters, null, 3600).Tables[0]);
}
private DataTable EnergyAnalysisDetail(string sysflag, string cid, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid),
new SqlParameter("@StartTime", stime),
new SqlParameter("@EndTime", etime)
};
return(csh.FillDataSet(sysflag, WebProc.Proc("LiuTe_EnergyAnalysis_QueryDetail"), Parameters, null, 3600).Tables[0]);
}
private DataTable GetStatDetailTable(string sysflag, string cid, string stime, string etime)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid),
new SqlParameter("@T_TimeBegin", stime),
new SqlParameter("@T_TimeEnd", etime)
};
return(csh.FillDataSet(sysflag, WebProc.Proc("QWGProc_QM_OfflineStatRADetail"), Parameters, null, 3600).Tables[0]);
}
private DataTable GetSignalInfoById(string sysflag, int cid, string stime, string etime, int signaltype)
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid),
new SqlParameter("@T_TimeBegin", stime),
new SqlParameter("@T_TimeEnd", etime),
new SqlParameter("@SignalType", signaltype)
};
return(csh.FillDataSet(sysflag, WebProc.Proc("QWCProc_IC_SignalStatDetailRA"), Parameters, null, 3600).Tables[0]);
}