public int GetQYWaringCount(Selectcarmonitor sm)
{
UserInfo user = new UserInfo();
user = (UserInfo)Session["LoginUser"];
if (sm.Businessdivisionid == null || sm.Businessdivisionid.Trim() == "")
{
sm.Businessdivisionid = user.EnterId;
}
if (sm.Businessdivisioncode == "true")
{
DeptInfo dif = new DeptInfo();
dif = deptInfoBll.GetDeptInfo(sm.Businessdivisionid);
sm.Businessdivisioncode = dif.Businessdivisioncode;
sm.Businessdivisionid = "";
}
else
{
sm.Businessdivisioncode = "";
}
int c = realtimeDataBll.GetQYWaringCount(sm);
return(c);
}
public string GetList(Selectcarmonitor rtv, string DeptCode, string SelType, int RowNumber)
{
UserInfo user = new UserInfo();
user = (UserInfo)Session["LoginUser"];
DeptInfo dif = new DeptInfo();
Hashtable ht = new Hashtable();
ht.Add("TerStatus", rtv.TerStatus);
ht.Add("TerNo", rtv.TerNo == null ? "" : rtv.TerNo.Trim().ToUpper());
//ht.Add("CarNo", rtv.CarNo == null ? "" : rtv.CarNo.Trim());
//ht.Add("CarAdminName", rtv.CarAdminName == null ? "" : rtv.CarAdminName.Trim());
ht.Add("StartData", rtv.StartData);
ht.Add("EndData", 0); // RowNumber * 20 + 1
ht.Add("ReplydataCode", rtv.ReplydataCode == null?"":rtv.ReplydataCode.Trim());
ht.Add("Northorsouth", rtv.Northorsouth);
if (rtv.Businessdivisionid != null && rtv.Businessdivisionid.Trim() == "")
{
if (user.EnterId != null)
{
ht.Add("Businessdivisionid", user.EnterId);
}
else
{
ht.Add("UserLname", user.UserLname);
}
}
else
{
ht.Add("Businessdivisionid", rtv.Businessdivisionid);
}
if (DeptCode == "true")
{
if (user.EnterId != null)
{
dif = deptInfoBll.GetDeptInfo(ht["Businessdivisionid"].ToString());
ht.Add("Businessdivisioncode", dif.Businessdivisioncode);
ht["Businessdivisionid"] = "";
}
}
if (SelType == "Ter" || SelType == "Dept")
{
ht.Add("SelType", "true");
}
else
{
ht.Add("SelType", "");
}
IList <Selectcarmonitor> irt = realtimeDataBll.SelectCarMonitor(ht);
string uu = ConvertToJson(irt);
return(uu);
}
public int GetQYWaringCount(Selectcarmonitor sm)
{
object count = ExecuteQueryForObject("RealtimeData.SelectQYWarningCount", sm);
return((int)count);
}
public IList <Selectcarmonitor> SelectTerMonitor(Selectcarmonitor scm)
{
return(ExecuteQueryForList <Selectcarmonitor>("RealtimeData.SelectTerMonitor", scm));
}
public IList <Selectcarmonitor> SelectTerMonitor(Selectcarmonitor scm)
{
return(_iRealtimeDataDao.SelectTerMonitor(scm));
}
public int GetQYWaringCount(Selectcarmonitor sm)
{
return(_iRealtimeDataDao.GetQYWaringCount(sm));
}
public string DownLoadExcel(Selectcarmonitor rtv, string DeptCode, string SelType, string ZLflag)
{
UserInfo user = new UserInfo();
user = (UserInfo)Session["LoginUser"];
DeptInfo dif = new DeptInfo();
Hashtable ht = new Hashtable();
ht.Add("TerStatus", rtv.TerStatus);
ht.Add("TerNo", rtv.TerNo);
ht.Add("CarNo", rtv.CarNo);
ht.Add("StartData", rtv.StartData);
ht.Add("EndData", rtv.EndData);
ht.Add("ReplydataCode", rtv.ReplydataCode);
ht.Add("Northorsouth", rtv.Northorsouth);
if (rtv.Businessdivisionid == null || rtv.Businessdivisionid.Trim() == "")
{
if (user.EnterId != null)
{
ht.Add("Businessdivisionid", user.EnterId);
}
else
{
ht.Add("UserLname", user.UserLname);
}
}
else
{
ht.Add("Businessdivisionid", rtv.Businessdivisionid);
}
if (DeptCode == "true")
{
if (user.EnterId != null)
{
dif = deptInfoBll.GetDeptInfo(ht["Businessdivisionid"].ToString());
ht.Add("Businessdivisioncode", dif.Businessdivisioncode);
ht["Businessdivisionid"] = "";
}
}
if (rtv.CarWorkVMP > 0)
{
ht.Add("SelType", "");
}
else
{
if (SelType == "Ter" || SelType == "Dept")
{
ht.Add("SelType", "true");
}
else
{
ht.Add("SelType", "");
}
}
IList <Selectcarmonitor> irt = realtimeDataBll.SelectCarMonitor(ht);
IList <Selectcarmonitor> lxirt = new List <Selectcarmonitor>();
IList <Selectcarmonitor> zxirt = new List <Selectcarmonitor>();
for (int i = 0; i < irt.Count; i++)
{
if (irt[i].StateName == "lx")
{
lxirt.Add(irt[i]);
}
else if (irt[i].StateName == "zx")
{
zxirt.Add(irt[i]);
}
}
ExcelUpLoad eu = new ExcelUpLoad();
MemoryStream ms = new MemoryStream();
if (ZLflag == "ZX")
{
ms = eu.CreateExcel(zxirt);
}
else if (ZLflag == "LX")
{
ms = eu.CreateExcel(lxirt);
}
else
{
ms = eu.CreateExcel(irt);
}
string xlsName = DateTime.Now.ToString("yyyyMMddHHmmssfff");
// 输出Excel
using (FileStream fs = new FileStream(HttpContext.Server.MapPath("../Files/车辆位置信息") + xlsName + ".xlsx", FileMode.Create, FileAccess.Write))
{
byte[] data = ms.ToArray();
fs.Write(data, 0, data.Length);
fs.Flush();
}
if (System.IO.File.Exists(HttpContext.Server.MapPath("../Files/车辆位置信息") + xlsName + ".xlsx"))
{
string ppphhh = "../../Files/车辆位置信息" + xlsName + ".xlsx";
new LogMessage().Save("文件:" + ppphhh + "");
return(ppphhh);
}
else
{
new LogMessage().Save("生成文件出错，请重新导出！");
return("生成文件出错，请重新导出！");
}
}
