/// <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">系统标志</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]);
}
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>
/// <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>
/// 根据用户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);
}
}
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;
}
}
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="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;
}
}
private int InsertDriveLine(string sysflag, string uid, string lname, string centerlng, string centerlat, string lradius, string desc, string dealercode, string linemarkers)
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
try
{
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[8];
oaPara[0] = new SqlParameter("@L_Name", lname);
oaPara[1] = new SqlParameter("@L_CenterLng", centerlng);
oaPara[2] = new SqlParameter("@L_CenterLat", centerlat);
oaPara[3] = new SqlParameter("@L_RADIUS", lradius);
oaPara[4] = new SqlParameter("@L_Desc", desc);
oaPara[5] = new SqlParameter("@DEALERCODE", dealercode);
oaPara[6] = new SqlParameter("@UID", uid);
oaPara[7] = new SqlParameter("@MarkerS", linemarkers);
return(oSqlUtil.ExecuteSPNoQuery(sysflag, WebProc.Proc("X80Proc_DriveLine_Insert"), oaPara, false));
}
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 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]);
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="inparams"></param>
/// <returns></returns>
public ResponseResult userChgPwd(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
try
{
string key = inparams["sysflag"];
string uid = inparams["sysuid"];
string onecaruser = inparams["onecaruser"];
string newpwd = inparams["newpassword"];
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@UID", Int64.Parse(uid));
Parameters[1] = new SqlParameter("@NewPwd", newpwd);
Parameters[2] = new SqlParameter("@OneCarUser", onecaruser);
int status = csh.ExecuteSPNoQuery(key, WebProc.Proc("ChangePassword"), Parameters, false);
sys_user_chgpwd_res res = new sys_user_chgpwd_res();
res.status = status;
Result = new ResponseResult(ResState.Success, "", res);
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, null);
}
return(Result);
}
public ResponseResult userLogout(Dictionary <string, string> inparams)
{
ResponseResult Result = null;
//记录登出日志
try
{
string key = inparams["sysflag"];
string uid = inparams["sysuid"];
string onecaruser = inparams["onecaruser"];
string ip = GetClientIp();
string usertype = "";
if (onecaruser.Equals("1")) //单车用户
{
usertype = "0";
}
else//系统用户
{
usertype = "1";
}
SqlParameter[] ParametersLogout = new SqlParameter[3];
ParametersLogout[0] = new SqlParameter("@UserType", usertype);
ParametersLogout[1] = new SqlParameter("@UserIP", ip);
ParametersLogout[2] = new SqlParameter("@userID", uid);
csh.ExecuteSPNoQuery(key, WebProc.Proc("QWGProc_M_InsertCancelLogin"), ParametersLogout, false);
Result = new ResponseResult(ResState.Success, "退出成功！", "1");
}
catch (Exception ex)
{
Result = new ResponseResult(ResState.OperationFailed, ex.Message, null);
}
return(Result);
}
/// <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="DealerCode"></param>
/// <param name="OpType"></param>
/// <param name="M_Name"></param>
/// <param name="M_Lat"></param>
/// <param name="M_Lng"></param>
/// <param name="M_Desc"></param>
/// <param name="cuser"></param>
/// <param name="upuser"></param>
/// <returns></returns>
public int InsertMarker(string key, string RowId, string DealerCode, string OpType, string M_Name, string M_Lat, string M_Lng, string M_Desc, string cuser, string upuser)
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
try
{
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[9];
oaPara[0] = new SqlParameter("@DEALERCODE", DealerCode);
oaPara[1] = new SqlParameter("@Id", RowId);
oaPara[2] = new SqlParameter("@OpType", OpType);
oaPara[3] = new SqlParameter("@M_Name", M_Name);
oaPara[4] = new SqlParameter("@M_Lat", decimal.Parse(M_Lat));
oaPara[5] = new SqlParameter("@M_Lng", decimal.Parse(M_Lng));
oaPara[6] = new SqlParameter("@M_Desc", M_Desc);
oaPara[7] = new SqlParameter("@Create_User", Int32.Parse(cuser));
oaPara[8] = new SqlParameter("@Update_User", Int32.Parse(upuser));
return(oSqlUtil.ExecuteSPNoQuery(key, WebProc.Proc("X80Proc_Marker_Dealer"), oaPara, false));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加或更新电子围栏
/// </summary>
/// <param name="key"></param>
/// <param name="OpType"></param>
/// <param name="fid"></param>
/// <param name="fname"></param>
/// <param name="almtype"></param>
/// <param name="gratype"></param>
/// <param name="content"></param>
/// <param name="desc"></param>
/// <param name="cuser"></param>
/// <param name="upuser"></param>
/// <returns></returns>
public int InsertOrUpdateFence(string key, string OpType, string fid, string fname, string almtype, string gratype, string content, string desc, string cuser, string upuser)
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
try
{
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[9];
oaPara[0] = new SqlParameter("@OpType", OpType);
oaPara[1] = new SqlParameter("@F_ID", Int32.Parse(fid));
oaPara[2] = new SqlParameter("@F_Name", fname);
oaPara[3] = new SqlParameter("@F_AlarmType", Int32.Parse(almtype));
oaPara[4] = new SqlParameter("@F_GraphType", Int32.Parse(gratype));
oaPara[5] = new SqlParameter("@F_Content", content);
oaPara[6] = new SqlParameter("@F_Desc", desc);
oaPara[7] = new SqlParameter("@Create_User", Int32.Parse(cuser));
oaPara[8] = new SqlParameter("@Update_User", Int32.Parse(upuser));
return(oSqlUtil.ExecuteSPNoQuery(key, WebProc.Proc("QSProc_QS_Fence_InsertOrUpdate"), oaPara, false));
}
catch (Exception ex)
{
throw ex;
}
}
/// <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="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]);
}
private void loginlog(string sysflag, string uid, string uname, string usertype, string ip, string sysName)
{
try
{
if (sysName == "2")
{
sysName = "weixin";
}
else if (sysName == "0")
{
sysName = "android";
}
else if (sysName == "1")
{
sysName = "ios";
}
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] ParametersLogin = new SqlParameter[6];
ParametersLogin[0] = new SqlParameter("@UserID", Int32.Parse(uid));
ParametersLogin[1] = new SqlParameter("@UserName", uname);
ParametersLogin[2] = new SqlParameter("@UserType", usertype);
ParametersLogin[3] = new SqlParameter("@IP", ip);
ParametersLogin[4] = new SqlParameter("@Context", "用户登录成功！");
ParametersLogin[5] = new SqlParameter("@SysName", sysName);
csh.ExecuteSPNoQuery(sysflag, WebProc.Proc("QWGProc_COM_WebLoginRecord"), ParametersLogin, false);
}
catch (Exception ex)
{
LogHelper.WriteError("loginlog调用异常", ex);
}
}
/// <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="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>
/// 调用存储过程查询未上线车辆列表
/// </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]);
}
/// <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]);
}
/// <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="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]);
}
/// <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[] 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);
}
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]);
}
