/// <summary>
/// 获取系统日志
/// </summary>
private string GetSysLog(HttpContext context)
{
var jr = new PagingResultModel <List <OperationLogModel> >()
{
rows = new List <OperationLogModel>(),
total = 0
};
string typeid = context.Request.Params["typeID"];
string partname = context.Request.Params["partName"];
string tsp = context.Request.Params["timeSpan"];
string pageindex = context.Request.Params["pageNumber"];
string pagesize = context.Request.Params["pageSize"];
try
{
int logcount = 0;
jr.rows = opl_bll.GetSysLog(int.Parse(typeid), partname, tsp, int.Parse(pagesize), int.Parse(pageindex), out logcount);
jr.total = logcount;
return(JsonConvert.SerializeObject(jr));
}
catch (Exception err)
{
throw err;
}
}
/// <summary>
/// 获取实时报警信息
/// </summary>
private string GetCurrentAlarmLog(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
int cityid = string.IsNullOrEmpty(context.Request.Params["cityID"]) ? 0 : int.Parse(context.Request.Params["cityID"]);
int propertyid = string.IsNullOrEmpty(context.Request.Params["propertyID"]) ? 0 : int.Parse(context.Request.Params["propertyID"]);
string partname = context.Request.Params["partName"];
int systypeid = string.IsNullOrEmpty(context.Request.Params["systypeID"]) ? 0 : int.Parse(context.Request.Params["systypeID"]);
var pr = new PagingResultModel <List <ViewAlarmlogModel> >()
{
total = 0,
rows = new List <ViewAlarmlogModel>()
};
pr.rows = alarm_bll.GetCurrentAlarmLog(cityid, propertyid, partname, systypeid, pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取设备类型
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetDeviceType(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageIndex"];
string _psize = context.Request.Params["pageSize"];
string _name = context.Request.Params["name"];
System.Text.StringBuilder strWhere = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
var pr = new PagingResultModel <DataTable>()
{
total = 0,
rows = new DataTable()
};
pr.rows = bll.GetList(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取菜单列表
/// </summary>
private string GetMenuList(HttpContext context)
{
int pagesize = 10;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
var pr = new PagingResultModel <List <SysMenuModel> >()
{
total = 0,
rows = new List <SysMenuModel>()
};
SysMenuBLL menu_bll = new SysMenuBLL();
List <SysMenuModel> list = menu_bll.GetMenuList(string.Empty, out rowcount);
pr.rows = list.Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList();;
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
private string GetAllCommunity(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
System.Text.StringBuilder strWhere = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
var pr = new PagingResultModel <List <CommunityInfoModel> >()
{
total = 0,
rows = new List <CommunityInfoModel>()
};
pr.rows = community_bll.GetAllCommunity(pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取工单设备
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetOrderEquipment(HttpContext context)
{
#region 分页参数
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
string orderSN = context.Request.Params["orderSN"];
#endregion
int rowcount = 0;
var pr = new PagingResultModel <List <EccmOrderDeviceStandardModel> >()
{
total = 0,
rows = new List <EccmOrderDeviceStandardModel>()
};
pr.rows = _devBLL.GetOrderEquipmentList(orderSN, pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取全部启用角色列表
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetAllRoles(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
var pr = new PagingResultModel <List <RoleInfoModel> >()
{
total = 0,
rows = new List <RoleInfoModel>()
};
pr.rows = role_bll.GetPagingRoles(" isDel=0", pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取实施记录
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetOrderImplementList(HttpContext context)
{
#region 分页参数
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
int orderID = string.IsNullOrEmpty(context.Request.Params["orderID"]) ? 0 : int.Parse(context.Request.Params["orderID"]);
#endregion
int rowcount = 0;
var pr = new PagingResultModel <List <EccmRepairOrderImplementModel> >()
{
total = 0,
rows = new List <EccmRepairOrderImplementModel>()
};
pr.rows = _implementBLL.GetOrderImplementList(orderID, pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取指定设备房的维保计划
/// </summary>
private string GetMaintenancesetting(HttpContext context)
{
int pagesize = 10;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
int houseid = string.IsNullOrEmpty(context.Request.Params["devhouseID"]) ? 0 : int.Parse(context.Request.Params["devhouseID"]);
int systypeid = string.IsNullOrEmpty(context.Request.Params["systypeID"]) ? 0 : int.Parse(context.Request.Params["systypeID"]);
var pr = new PagingResultModel <List <ViewMainTenanceSettingModel> >()
{
total = 0,
rows = new List <ViewMainTenanceSettingModel>()
};
pr.rows = msetting_bll.GetMaintenancesetting(houseid, systypeid, pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取用户报修订单列表
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetRepairUserOrderList(HttpContext context)
{
#region 分页参数
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
int communityID = string.IsNullOrEmpty(context.Request.Params["communityID"]) ? 0 : int.Parse(context.Request.Params["communityID"]);
string timespan = context.Request.Params["timeSpan"];
string status = context.Request.Params["status"];
int uid = 0;// int.Parse(context.Request.Cookies["EccmUserinfo"].Values["userid"]);
HttpCookie cook = HttpContext.Current.Request.Cookies["EccmUserinfo"];
if (cook != null)
{
//解密Cookie
HttpCookie decodeCookie = HttpSecureCookie.Decode(cook);
uid = int.Parse(decodeCookie.Values["userid"]);
}
var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
DateTime begintime = DateTime.Parse(ts[0].Value);
DateTime endtime = DateTime.Parse(ts[1].Value).AddDays(1);
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat(" and r.r_stime>'{0}' and r.r_stime<'{1}'", begintime, endtime);
strWhere.AppendFormat(" and community_id={0} ", communityID);
strWhere.AppendFormat(" and ru.uid_receiver={0} ", uid);
strWhere.AppendFormat(" and ru.receiver_type={0} ", 3);//1巡检2维保3维修
if (!string.IsNullOrEmpty(status))
{
strWhere.AppendFormat(" and r_state={0} ", status);
}
if (strWhere.Length > 0)
{
strWhere.Remove(0, 4);
}
#endregion
int rowcount = 0;
var pr = new PagingResultModel <List <EccmRepairOrderModel> >()
{
total = 0,
rows = new List <EccmRepairOrderModel>()
};
pr.rows = _reqairBLL.GetRepairUserOrderList(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 历史报警记录
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string GetHistoryAlarmElevator(HttpContext context)
{
#region 分页
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
int cityid = string.IsNullOrEmpty(context.Request.Params["cityID"]) ? 0 : int.Parse(context.Request.Params["cityID"]);
int propertyid = string.IsNullOrEmpty(context.Request.Params["propertyID"]) ? 0 : int.Parse(context.Request.Params["propertyID"]);
string partname = context.Request.Params["partName"];
string timespan = context.Request.Params["timeSpan"];
var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
DateTime begintime = DateTime.Parse(ts[0].Value);
DateTime endtime = DateTime.Parse(ts[1].Value).AddDays(1);
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat(" and insertTime>'{0}' and insertTime<'{1}'", begintime, endtime);
if (cityid != 0)
{
strWhere.AppendFormat(" and cityID={0}", cityid);
}
if (propertyid != 0)
{
strWhere.AppendFormat(" and propertyID={0}", propertyid);
}
if (!string.IsNullOrEmpty(partname))
{
strWhere.AppendFormat(" and communityName like '%{0}%'", partname);
}
if (strWhere.Length > 0)
{
strWhere.Remove(0, 4);
}
#endregion
var pr = new PagingResultModel <List <ViewAlarmelevatorModel> >()
{
total = 0,
rows = new List <ViewAlarmelevatorModel>()
};
int rowcount = 0;
pr.rows = _alarmBLL.GetHistoryAlarmElevator(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 查询计划
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetPlan(HttpContext context)
{
var jr = new JsonResultModel <DataTable>()
{
IsSucceed = false,
Data = null,
Msg = "查询失败",
RedirectUrl = string.Empty
};
#region 分页参数
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
int communityID = string.IsNullOrEmpty(context.Request.Params["communityID"]) ? 0 : int.Parse(context.Request.Params["communityID"]);
string timespan = context.Request.Params["timeSpan"];
var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
DateTime begintime = DateTime.Parse(ts[0].Value);
DateTime endtime = DateTime.Parse(ts[1].Value).AddDays(1);
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat(" and p.plan_creat_time>='{0}' and p.plan_creat_time<='{1}'", begintime, endtime);
strWhere.AppendFormat(" and p.communityID={0} ", communityID);
strWhere.Append(" and p.is_delete=0 ");
if (strWhere.Length > 0)
{
strWhere.Remove(0, 4);
}
#endregion
EccmPlanBLL bll = new EccmPlanBLL();
int rowcount = 0;
var pr = new PagingResultModel <DataTable>()
{
total = 0,
rows = new DataTable()
};
DataTable dt = bll.GetPlanList(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.rows = dt;
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 实时报警记录
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string GetCurrentAlarmElevator(HttpContext context)
{
#region 分页
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
int cityid = string.IsNullOrEmpty(context.Request.Params["cityID"]) ? 0 : int.Parse(context.Request.Params["cityID"]);
int propertyid = string.IsNullOrEmpty(context.Request.Params["propertyID"]) ? 0 : int.Parse(context.Request.Params["propertyID"]);
string partname = context.Request.Params["partName"];
StringBuilder strWhere = new StringBuilder();
if (cityid != 0)
{
strWhere.AppendFormat(" and cityID={0}", cityid);
}
if (propertyid != 0)
{
strWhere.AppendFormat(" and propertyID={0}", propertyid);
}
if (!string.IsNullOrEmpty(partname))
{
strWhere.AppendFormat(" and communityName like '%{0}%'", partname);
}
if (strWhere.Length > 0)
{
strWhere.Remove(0, 4);
}
#endregion
var pr = new PagingResultModel <List <ViewAlarmelevatorModel> >()
{
total = 0,
rows = new List <ViewAlarmelevatorModel>()
};
int rowcount = 0;
pr.rows = _alarmBLL.GetCurrentAlarmElevator(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 消防泵房
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetDeviceFirePump(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
int devid = string.IsNullOrEmpty(context.Request.Params["devid"]) ? 0 : int.Parse(context.Request.Params["devid"]);
//string timespan = context.Request.Params["timeSpan"];
//var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
//DateTime beginTime = DateTime.Parse(ts[0].Value);
//DateTime endTime = DateTime.Parse(ts[1].Value);
/*
* 设置当前时间为默认时间，由时间范围改为开始时间和结束时间
* 2017年5月5日 11:06:08 BY 潘阳
*/
string beginTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string endTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (context.Request.Params["begindate"] != null)
{
beginTime = DateTime.Parse(context.Request.Params["begindate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
if (context.Request.Params["enddate"] != null)
{
endTime = DateTime.Parse(context.Request.Params["enddate"].ToString()).AddMinutes(1).ToString("yyyy-MM-dd HH:mm:ss");
}
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
var pr = new PagingResultModel <List <PumpHouseRdModel> >()
{
total = 0,
rows = new List <PumpHouseRdModel>()
};
pr.rows = dl.GetDevidFirePumpInfo(devid.ToString(), pageindex, pagesize, out rowcount, beginTime.ToString(), endTime.ToString());
pr.total = rowcount;
string strJson = JsonHelper.SerializeObject(pr);
return(strJson);
}
/// <summary>
/// 获取用户角色信息
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetUserWithRole(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
string _role = context.Request.Params["roleType"];
string _nickname = context.Request.Params["nickname"];
System.Text.StringBuilder strWhere = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
if (!string.IsNullOrEmpty(_role))
{
if (int.Parse(_role) > 0)
{
strWhere.AppendFormat("where rid={0}", _role);
}
}
if (!string.IsNullOrEmpty(_nickname))
{
if (strWhere.Length > 4)
{
strWhere.AppendFormat(" and nickName like '%{0}%'", _nickname);
}
else
{
strWhere.AppendFormat(" where nickName like '%{0}%'", _nickname);
}
}
var pr = new PagingResultModel <DataTable>()
{
total = 0,
rows = new DataTable()
};
pr.rows = user_bll.GetPagingUserinfoWithRole(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
public static PagingResultModel <TQuery> ToPagingResult <TQuery>(this IQueryable <TQuery> query, GridRequestModel gridRequest)
{
var rowCount = query.ToFutureValue(q => q.Count());
var query1 = query
.Skip((gridRequest.Page - 1) * gridRequest.Rows)
.Take(gridRequest.Rows);
var dbModel = query1.ToList();
var gridData = new PagingResultModel <TQuery>(dbModel, rowCount.Value);
return(gridData);
}
/// <summary>
/// 获取数据分析结果 (最大值，最小值，差值，平均值)
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetAnalysis(HttpContext context)
{
string columnName = context.Request.Params["columnname"];
string tableName = context.Request.Params["tablename"];
var pr = new PagingResultModel <List <DataAnalysisModel> >()
{
total = 0,
rows = new List <DataAnalysisModel>()
};
pr.rows = dl.GetColumnAnalysis(columnName, tableName);
return(JsonConvert.SerializeObject(pr));
}
PagingResultModel <DocumentDetails> IDocumentRepository.GetAllDocumentsByPage(DocumentsPagingQueryModel query)
{
var result = new PagingResultModel <DocumentDetails>
{
ItemsPerPage = query.ResultsPerPage
};
var documents = _dbContext.Document.Include(x => x.Case).Include(x => x.DocumentCategory).Include(h => h.DocumentHistory).Include(f => f.FileType).ToList();
var filteredDocuments = documents.Where(doc => doc.IsDeleted == false && SearchByMultipleProperties(query, doc))
.Select(d => DocumentRepository.MapToDocumentDetailsDto(d, _dbContext)).ToList();
result.TotalItems = filteredDocuments.Count;
result.Results = filteredDocuments.Skip(query.ResultsPerPage * (query.PageNumber - 1)).Take(query.ResultsPerPage).ToList();
return(result);
}
/// <summary>
/// 获取能耗记录
/// </summary>
private string GetEnergyLog(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
//小区编号
int communityid = string.IsNullOrEmpty(context.Request.Params["communityID"]) ? 0 : int.Parse(context.Request.Params["communityID"]);
//父类型ID
int ptypeid = string.IsNullOrEmpty(context.Request.Params["pTypeID"]) ? 0 : int.Parse(context.Request.Params["pTypeID"]);
//统计年月
string egydate = context.Request.Params["egyDate"];
System.Text.StringBuilder strWhere = new System.Text.StringBuilder();
strWhere.AppendFormat(" where communityID={0}", communityid);
if (ptypeid != 0)
{
strWhere.AppendFormat(" and pID={0}", ptypeid);
}
if (!string.IsNullOrEmpty(egydate))
{
string[] yearmonth = egydate.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries);
strWhere.AppendFormat(" and year='{0}' and month='{1}'", yearmonth[0], yearmonth[1]);
}
var pr = new PagingResultModel <List <EnergyInfoModel> >()
{
total = 0,
rows = new List <EnergyInfoModel>()
};
pr.rows = energyinfo_bll.GetEnergyLog(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonHelper.SerializeObject(pr));
}
/// <summary>
/// 获取维保列表
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetMaintenanceOrderList(HttpContext context)
{
#region 分页参数
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
int communityID = string.IsNullOrEmpty(context.Request.Params["communityID"]) ? 0 : int.Parse(context.Request.Params["communityID"]);
string timespan = context.Request.Params["timeSpan"];
string status = context.Request.Params["status"];
var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
DateTime begintime = DateTime.Parse(ts[0].Value);
DateTime endtime = DateTime.Parse(ts[1].Value).AddDays(1);
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat(" and order_time>'{0}' and order_time<'{1}'", begintime, endtime);
strWhere.AppendFormat(" and community_id={0} ", communityID);
if (!string.IsNullOrEmpty(status))
{
strWhere.AppendFormat(" and order_stats={0} ", status);
}
if (strWhere.Length > 0)
{
strWhere.Remove(0, 4);
}
#endregion
int rowcount = 0;
var pr = new PagingResultModel <DataTable>()
{
total = 0,
rows = new DataTable()
};
pr.rows = _bll.GetMaintenanceOrderList(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取小区和电梯信息列表
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string GetListCommunityElevator(HttpContext context)
{
#region 分页参数
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request["pageNumber"];
string _psize = context.Request["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
string searchText = context.Request.Params["searchText"];
int property = string.IsNullOrEmpty(context.Request["property"]) ? 0 : int.Parse(context.Request["property"]);
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat(@" and c.propertyMId = {0} ", property);
if (!string.IsNullOrEmpty(searchText))
{
strWhere.AppendFormat(@" and c.communityName like '%{0}%' ", searchText);
}
if (strWhere.Length > 0)
{
strWhere.Remove(0, 4);
}
#endregion
int rowcount = 0;
var pr = new PagingResultModel <List <ElevatorInfoModel> >()
{
total = 0,
rows = new List <ElevatorInfoModel>()
};
pr.rows = _infoBLL.GetListElevatorInfo(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 配电室
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetDevidSwitch(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
//string timespan = context.Request.Params["timeSpan"];
//var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
//DateTime beginTime = DateTime.Parse(ts[0].Value);
//DateTime endTime = DateTime.Parse(ts[1].Value);
string beginTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string endTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (context.Request.Params["begindate"] != null)
{
beginTime = DateTime.Parse(context.Request.Params["begindate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
if (context.Request.Params["enddate"] != null)
{
endTime = DateTime.Parse(context.Request.Params["enddate"].ToString()).AddMinutes(1).ToString("yyyy-MM-dd HH:mm:ss");
}
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
int devid = string.IsNullOrEmpty(context.Request.Params["devid"]) ? 0 : int.Parse(context.Request.Params["devid"]);
var pr = new PagingResultModel <List <SwitchRoomRdModel> >()
{
total = 0,
rows = new List <SwitchRoomRdModel>()
};
pr.rows = dl.GetDevidSwitchInfo(devid.ToString(), pageindex, pagesize, out rowcount, beginTime.ToString(), endTime.ToString());
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取小区电梯集合
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetListInElevatorInfo(HttpContext context)
{
#region 分页参数
int pagesize = 1;
int pageindex = 1;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
#endregion
#region 查询条件
int communityID = string.IsNullOrEmpty(context.Request.Params["communityID"]) ? 0 : int.Parse(context.Request.Params["communityID"]);
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat(@" and communityID={0} ", communityID);
if (strWhere.Length > 0)
{
strWhere.Remove(0, 4);
}
#endregion
int rowcount = 0;
var pr = new PagingResultModel <List <ElevatorInfoModel> >()
{
total = 0,
rows = new List <ElevatorInfoModel>()
};
pr.rows = _infoBLL.GetList(strWhere.ToString(), pageindex, pagesize, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取历史报警信息
/// </summary>
private string GetAlarmLog(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
int cityid = string.IsNullOrEmpty(context.Request.Params["cityID"]) ? 0 : int.Parse(context.Request.Params["cityID"]);
int propertyid = string.IsNullOrEmpty(context.Request.Params["propertyID"]) ? 0 : int.Parse(context.Request.Params["propertyID"]);
string partname = context.Request.Params["partName"];
int systypeid = string.IsNullOrEmpty(context.Request.Params["systypeID"]) ? 0 : int.Parse(context.Request.Params["systypeID"]);
string timespan = context.Request.Params["timeSpan"];
var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
DateTime begintime = DateTime.Parse(ts[0].Value);
DateTime endtime = DateTime.Parse(ts[1].Value);
var pr = new PagingResultModel <List <ViewAlarmlogModel> >()
{
total = 0,
rows = new List <ViewAlarmlogModel>()
};
pr.rows = alarm_bll.GetAlarmLog(cityid, propertyid, partname, systypeid, pageindex, pagesize, begintime, endtime, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取设备房安装的设备集合
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetEquinfoByhouseid(HttpContext context)
{
int pagesize = 10;
int pageindex = 1;
int houseid = 0;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
string _houseid = context.Request.Params["houseID"]; //获取小区ID
//string _propertyID = context.Request.Params["propertyID"];
System.Text.StringBuilder strWhere = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
if (!string.IsNullOrEmpty(_houseid))
{
houseid = int.Parse(_houseid);
}
var equlist = equinfo_bll.GetEquListByHouseID(houseid, pagesize, pageindex, out rowcount);
var pr = new PagingResultModel <List <EquipmentInfoModel> >()
{
total = rowcount,
rows = equlist
};
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取小区对应设备房列表
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetDevByCid(HttpContext context)
{
int pagesize = 10;
int pageindex = 1;
int communityid = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
string _communityid = context.Request.Params["communityID"];
bool _timeliness = string.IsNullOrEmpty(context.Request.Params["timeliness"]) ? false : true;
System.Text.StringBuilder strWhere = new System.Text.StringBuilder();
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
if (!string.IsNullOrEmpty(_communityid))
{
communityid = int.Parse(_communityid);
}
var devlist = GetAllDevinfo(_timeliness);
var pr = new PagingResultModel <List <DevInfoModel> >()
{
total = 0,
rows = new List <DevInfoModel>()
};
pr.rows = devlist.Where(d => d.communityID == communityid).ToList();
pr.total = pr.rows.Count;
return(JsonConvert.SerializeObject(pr));
}
/// <summary>
/// 获取工单信息
/// </summary>
private string GetOrderLog(HttpContext context)
{
int pagesize = 1;
int pageindex = 1;
int rowcount = 0;
string _pindex = context.Request.Params["pageNumber"];
string _psize = context.Request.Params["pageSize"];
if (!string.IsNullOrEmpty(_pindex))
{
pageindex = int.Parse(_pindex);
}
if (!string.IsNullOrEmpty(_psize))
{
pagesize = int.Parse(_psize);
}
int communityid = string.IsNullOrEmpty(context.Request.Params["communityID"]) ? 0 : int.Parse(context.Request.Params["communityID"]);
int devhouseid = string.IsNullOrEmpty(context.Request.Params["devhouseID"]) ? 0 : int.Parse(context.Request.Params["devhouseID"]);
int ordertype = string.IsNullOrEmpty(context.Request.Params["orderType"]) ? 0 : int.Parse(context.Request.Params["orderType"]);
string timespan = context.Request.Params["timeSpan"];
var ts = System.Text.RegularExpressions.Regex.Matches(timespan, "[0-9]{4}-[0-9]{1,2}-[0-9]{1,2}");
DateTime begintime = DateTime.Parse(ts[0].Value);
DateTime endtime = DateTime.Parse(ts[1].Value);
var pr = new PagingResultModel <List <MainTenanceLogModel> >()
{
total = 0,
rows = new List <MainTenanceLogModel>()
};
pr.rows = mlog_bll.GetMaintenanceLog(communityid, devhouseid, ordertype, begintime, endtime, pagesize, pageindex, out rowcount);
pr.total = rowcount;
return(JsonConvert.SerializeObject(pr));
}
