/// <summary>
/// 根据id 加载数据
/// </summary>
public void SearchData()
{
try
{
Search search = this.GetSearch();
if (!CurrentMaster.IsMain)
{
if (CurrentMaster.LookPower == (int)LookPowerEnum.查看自建)
{
search.AddCondition("CreaterId='" + CurrentMaster.Id + "'");//自己查看自己的
}
}
if (CurrentMaster.Attribute == (int)AdminTypeEnum.系统管理员)
{
search.AddCondition("Status=" + (int)StatusEnum.禁用);
}
else if (CurrentMaster.Attribute == (int)AdminTypeEnum.单位管理员 || CurrentMaster.Attribute == (int)AdminTypeEnum.供应商管理员 || CurrentMaster.Attribute == (int)AdminTypeEnum.维保公司管理员 || CurrentMaster.Attribute == (int)AdminTypeEnum.消防部门管理员)
{
//查看自己单位下的
search.AddCondition("SysId='" + CurrentMaster.Cid + "'");
search.AddCondition("Status=" + (int)StatusEnum.禁用);
}
LogInsert(OperationTypeEnum.访问, "二维码列表模块", "访问页面成功.");
WriteJsonToPage(new BllSysQRCode().SearchData(search));
}
catch (Exception ex)
{
LogInsert(OperationTypeEnum.异常, "二维码列表模块", "查询列表错误消息:" + ex.Message.ToString());
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public Page <ModEDynamic> getEDynamicSearch(Search search)
{
search.TableName = @"E_Dynamic e INNER JOIN Sys_Collection c ON c.CollId=e.Id "; //表名
search.KeyFiled = "e.Id"; //主键
search.AddCondition("e.Status=" + (int)StatusEnum.正常); //过滤条件
search.AddCondition("c.Type=" + (int)CollectionEnum.新闻收藏); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "c.CreateTime desc"; //排序
search.SelectedColums = "e.Id,e.Name,e.ReadNum,Img,e.Content,e.Template,e.CreateTime,e.Author";
return(DAL.getEDynamicSearch(search));
}
/// <summary>
/// 查询岗位列表
/// </summary>
public void SearchPostList()
{
Search search = this.GetSearch();
string id = Request["Id"].ToString();
search.AddCondition("Attribute=" + (int)CompanyType.部门);
if (id != "-1")
{
search.AddCondition("CreateCompanyId='" + id + "'");
}
WriteJsonToPage(new BllSysCompany().SearchData(search));
}
/// <summary>
/// 查询分公司列表
/// </summary>
public void SearchData()
{
Search search = this.GetSearch();
search.AddCondition("Attribute=" + (int)CompanyType.维保公司);
if (!CurrentMaster.IsMain)
{
if (CurrentMaster.LookPower == (int)LookPowerEnum.查看自建)
{
search.AddCondition("CreaterUserId='" + CurrentMaster.Id + "'");//自己查看自己的
}
}
WriteJsonToPage(new BllSysCompany().SearchData(search));
}
/// <summary>
/// 查询分公司列表
/// </summary>
public void SearchTopData()
{
Search search = this.GetSearch();
search.AddCondition("Attribute=" + Request["Attribute"]);
WriteJsonToPage(new BllSysCompany().SearchData(search));
}
//法律、新闻、消费知识 文档类型(2:消防知识 3:新闻管理 4:法律法规)
//[HttpGet]
public JsonResult GetDynamic(string GroupId)
{
try
{
LogErrorRecord.InfoFormat("参数请求url:{0}", Request.Url);
LogErrorRecord.InfoFormat("参数参数：GroupId={0}", GroupId);
CheckParams(GroupId, "文档类型不能为空！");
BllEDynamic bllEDynamic = new BllEDynamic();
if (jsonResult.success)
{
Search search = GetSearch();
search.AddCondition("GroupId='" + GroupId + "'");
Page <ModEDynamic> r = bllEDynamic.GetDynamic(search);
jsonResult.data = r.Items;
jsonResult.msg = "获取成功！";
}
}
catch (Exception ex)
{
LogErrorRecord.ErrorFormat("错误日志：{0},请求url:{1}", ex.Message, Request.Url);
jsonResult.success = false;
jsonResult.errorCode = -1;
jsonResult.msg = "常异:" + ex.Message;
}
return(Json(jsonResult, "application/json", JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 查询社会单位
/// </summary>
public void SearchIndex()
{
try
{
Search search = this.GetSearch();
search.AddCondition("EmployerId='" + CurrentMaster.Cid + "'");
search.AddCondition("SelectType=1");//查询单位管理的
LogInsert(OperationTypeEnum.访问, "关联单位模块", "访问页面成功.");
WriteJsonToPage(Bll.SearchData(search));
}
catch (Exception ex)
{
LogInsert(OperationTypeEnum.异常, "关联单位模块", "查询列表错误消息:" + ex.Message.ToString());
}
}
/// <summary>
/// 获取查询列表
/// </summary>
/// <returns></returns>
protected Search GetSearch()
{
//获取用户查看类型
string className = GetRequestQueryString("className");//页面类名
if (!String.IsNullOrEmpty(className))
{
if (!String.IsNullOrEmpty(CurrentMaster.RoleIdList))
{
CurrentMaster.LookPower = new BllSysMaster().GetLookPower(className, CurrentMaster.RoleIdList, CurrentMaster.Attribute);
}
}
else
{
CurrentMaster.LookPower = 0;//不需要控权
}
string conditionField = GetRequestQueryString("conditionField"); //查询字段
string condition = GetRequestQueryString("condition"); //查询比较符：包含、等于、大于、小于、不等于
string conditionValue = GetRequestQueryString("conditionValue"); //条件值
string sortName = GetRequestQueryString("sort"); //排序字段名
string order = GetRequestQueryString("dir"); //排序方向，只有 DESC和ASC
int start = int.Parse(Request["start"] == null ? "0" : Request["start"]);
var _pageSize = int.Parse(Request["limit"] == null ? "20" : Request["limit"]);
var _currentPage = start / _pageSize + 1;
Search search = new Search
{
PageSize = _pageSize,
CurrentPageIndex = _currentPage//当前页数
};
//排序处理
if (sortName.Length > 0)
{
search.SortField = string.Format("{0} {1}", sortName, order);
}
//条件处理
if (conditionField.Length > 0 && conditionValue.Length > 0)
{
search.AddCondition(conditionField, condition, conditionValue);
}
//表名及主键处理
EntityAttribute entityAtt = ReferanceAttribute.ReferanceEntityAttribute(typeof(T));
if (entityAtt != null)
{
search.TableName = entityAtt.TableName;
search.KeyFiled = entityAtt.PrimaryKey;
search.StatusDefaultCondition = string.Format("{0}.Status <> -1", entityAtt.TableName);
}
return(search);
}
/// <summary>
/// 获取文章分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"View_Dynamic"; //表名
search.KeyFiled = "Id"; //主键
search.AddCondition("Status!=" + (int)StatusEnum.除); //过滤条件
search.StatusDefaultCondition = "";
return(base.QueryPageToJson(search));
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"H_PurchaseDetail"; //表名
search.SelectedColums = "*"; //查询列
search.KeyFiled = "Id"; //主键
search.AddCondition("Status!=" + (int)StatusEnum.除); //过滤条件
search.StatusDefaultCondition = "";
return(base.QueryPageToJson(search));
}
public Dapper.Page <ModSysMaster> GetFriends(Search search)
{
search.TableName = @"Cor_View_Friends"; //表名
search.KeyFiled = "Id"; //主键
search.AddCondition("Status=" + (int)StatusEnum.正常); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc"; //排序
return(DAL.GetFriends(search));
}
/// <summary>
/// 分页获取
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public Dapper.Page <ModAdActiveView> Search(Search search)
{
search.TableName = @"Cor_Ad_Active"; //表名
search.KeyFiled = "Id"; //主键
search.AddCondition("Status=" + (int)StatusEnum.正常); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "IsTop desc,CreateTime desc"; //排序
return(DAL.Search(search));
}
/// <summary>
/// 分页查询列表
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public Page <ModSysCompany> SearchDataList(Search search)
{
search.TableName = @"View_SysCompany"; //表名
search.KeyFiled = "Id"; //主键
search.SelectedColums = "*";
search.AddCondition("Status=" + (int)StatusEnum.正常); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc";
return(DAL.SearchData(search));
}
/// <summary>
/// 列表
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"View_SysCompany"; //表名
search.KeyFiled = "Id"; //主键
search.SelectedColums = "*";
search.AddCondition("Status>" + (int)StatusEnum.除); //过滤条件,没有审批过的单位不能显示
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc";
return(base.QueryPageToJson(search));
}
/// <summary>
/// 获取文章分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public Page <ModEDynamic> GetDynamic(Search search)
{
search.TableName = @"E_Dynamic"; //表名
search.KeyFiled = "Id"; //主键
search.AddCondition("Status=" + (int)StatusEnum.正常); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "IsTop desc,Sort asc,CreateTime desc"; //排序
search.SelectedColums = "Id,Name,ReadNum,Img,Content,Template,CreateTime,Author";
return(dal.GetDynamic(search));
}
/// <summary>
/// 列表
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"Sys_HatCity"; //表名
search.KeyFiled = "Id"; //主键
search.SelectedColums = "*";
search.AddCondition("Status!=" + (int)StatusEnum.除); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "Id asc";
return(base.QueryPageToJson(search));
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"view_HFinanceDetail"; //表名
search.SelectedColums = "*"; //查询列
search.KeyFiled = "Id"; //主键
search.AddCondition("Status!=" + (int)StatusEnum.除); //过滤条件
search.StatusDefaultCondition = "";
//search.SortField = "CreateTime desc";
return(base.QueryPageToJson(search));
}
/// <summary>
/// 超级管理员获取管理员分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchDataByCompany(Search search)
{
search.TableName = @"View_Total_SysMaster"; //表名
search.SelectedColums = "*"; //查询列
search.KeyFiled = "Id"; //主键
search.AddCondition("(Status!=" + (int)StatusEnum.除 + " and Status!=-2)"); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "Status asc ,CreateTime asc";
return(base.QueryPageToJson(search));
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"Sys_OperateLog"; //表名
search.SelectedColums = "*"; //查询列
search.KeyFiled = "Id"; //主键
search.AddCondition("Status=" + (int)StatusEnum.正常); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc"; //排序
return(base.QueryPageToJson(search));
}
/// <summary>
/// 查询型号列表
/// </summary>
public void SearchModelData()
{
Search search = this.GetSearch();
if (!string.IsNullOrEmpty(Request["key"]))
{
search.AddCondition("LinkId='" + Request["key"].ToString() + "'");
}
WriteJsonToPage(new BllSysModel().SearchData(search));
}
public string SearchData(Search search)
{
search.TableName = @"dbo.Ad_AShare a LEFT JOIN dbo.Sys_Master m ON m.Id=a.CreaterId LEFT JOIN dbo.Sys_Master mc ON mc.id=a.Auditor"; //表名
search.SelectedColums = "a.*,m.UserName as PUserName,m.LoginName as PLoginName,mc.UserName as MUserName,mc.LoginName as MLoginName"; //查询列
search.KeyFiled = "a.Id"; //主键
search.AddCondition("1=1"); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "a.Status asc,a.CreateTime desc";
return(base.QueryPageToJson(search));
}
/// <summary>
/// 查询所有订单列表
/// </summary>
/// <param name="where">条件( and field=value and field=value)</param>
/// <returns>ModCompanyOrder</returns>
public string GetAllList(Search search)
{
search.TableName = @"view_OrderList as a inner join Sys_User as b on a.OrderUserId=b.Id"; //表名
search.KeyFiled = "a.Id"; //主键
search.SelectedColums = "a.*,b.Nickname as OrderName,b.Tel";
search.AddCondition("FlowStatus>0"); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc"; //排序
return(base.QueryPageToJson(search));
}
/// <summary>
/// 获取按钮分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"v_SysCompanyPaySet"; //表名
search.SelectedColums = "*"; //查询列
search.KeyFiled = "Id"; //主键
search.AddCondition("Status=" + (int)StatusEnum.正常 + ""); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "AddTime asc"; //排序
return(base.QueryPageToJson(search));
}
/// <summary>
/// 后台分页查询设备
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"View_AppointCheckNotes"; //表名
search.KeyFiled = "Id"; //主键
search.SelectedColums = "*";
search.AddCondition("1=1"); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc";
return(base.QueryPageToJson(search));
}
/// <summary>
/// 获取角色分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
search.TableName = @"Sys_Role left join Sys_Company on Sys_Role.CompanyId=Sys_Company.Id"; //表名
search.SelectedColums = "Sys_Role.*,Sys_Company.Name as CompanyName"; //查询列
search.KeyFiled = "Id"; //主键
search.AddCondition("Sys_Role.Status=" + (int)StatusEnum.正常); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc,RoleSort asc"; //排序
return(base.QueryPageToJson(search));
}
/// <summary>
/// 分页查询设备
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public Page <ModSysAppointed> GetAppointList(Search search)
{
search.TableName = @"View_Appointed"; //视图
search.KeyFiled = "Id"; //主键
search.AddCondition("Status=" + (int)StatusEnum.正常); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "(CASE MaintenanceStatus WHEN 0 THEN 2 ELSE MaintenanceStatus END ) asc,CreateTime desc"; //排序
//search.SelectedColums = "Id,Name,ReadNum,Mark,Img,CreateTime";
return(dal.GetAppointList(search));
}
public Page <CarOrderView> SearchData(Search search)
{
search.TableName = @" W_Order a LEFT JOIN W_Car c ON a.CId=c.Id LEFT JOIN Sys_Master mc ON mc.Id=a.CreateId "; //表名
search.SelectedColums = @"a.Id,a.name,a.Status,a.CreateTime,a.Phone,a.CId as carid,a.auditorId,a.auditor,a.CUserId as cUserId,a.CreateId,a.TermOfValidity,a.remarks,a.auditorRemarks,c.LicensePlate as carno,c.typename as cartTypeName,mc.RoleName as createname"; //查询列
search.KeyFiled = "a.Id"; //主键
search.AddCondition("1=1"); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "a.Status asc,a.CreateTime desc";
return(DAL.SearchData(search));
}
/// <summary>
/// 获取公告分页数据
/// </summary>
/// <param name="search">查询集合</param>
/// <returns></returns>
public string SearchData(Search search)
{
//更新过期广告
Expired();
search.TableName = @"Cor_Ad_Active"; //表名
search.KeyFiled = "Id"; //主键
search.AddCondition("Status!=" + (int)StatusEnum.除); //过滤条件
search.StatusDefaultCondition = "";
search.SortField = "CreateTime desc"; //排序
return(base.QueryPageToJson(search));
}
/// <summary>
/// 查询岗位管理
/// </summary>
public void SearchData()
{
try
{
Search search = this.GetSearch();
search.AddCondition("Attribute=" + (int)CompanyType.消防部门);
if (!CurrentMaster.IsMain)
{
if (CurrentMaster.LookPower == (int)LookPowerEnum.查看自建)
{
search.AddCondition("CreaterUserId='" + CurrentMaster.Id + "'");//自己查看自己的
}
}
WriteJsonToPage(bll.SearchData(search));
}
catch (Exception ex)
{
LogErrorRecord.Info("查询列表:" + ex);
}
}
/// <summary>
/// 超期未巡检列表统计
/// </summary>
public void SuperParentData()
{
try
{
BllSysAppointed Bll = new BllSysAppointed();
Search search = this.GetSearch();
if (Request["Id"].ToString() != "-1")
{
search.AddCondition("Cid='" + Request["Id"].ToString() + "'");
}
else
{
search.AddCondition("Cid in (select EmployerId from Sys_CompanyCognate where Cid='" + CurrentMaster.Cid + "' and Status=1 and SelectType=2)");
}
string searchType = Request["searchType"].ToString();
switch (int.Parse(searchType))
{
case 1: //全部
break;
case 2: //本月
search.AddCondition("datediff(month,MaintenanceDate,getdate())=0");
break;
case 3: //上月
search.AddCondition("datediff(month,MaintenanceDate,getdate())=1");
break;
}
search.AddCondition("MaintenanceDate<getDate()");
LogInsert(OperationTypeEnum.访问, "超期未巡检列表统计模块", "访问页面成功.");
WriteJsonToPage(Bll.SearchData(search));
}
catch (Exception ex)
{
LogErrorRecord.Info("查询列表:" + ex);
LogInsert(OperationTypeEnum.异常, "超期未巡检列表统计模块", "查询列表错误消息:" + ex.Message.ToString());
}
}
