/// <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()); } }