public void GetOfficeFurOwner(HttpContext context) { string callback = context.Request["jsoncallback"]; //序列化 System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); EmsModel.JsonModel mod = new EmsBLL.EquipDetail().GetOfficeFurOwner(); mod = nameCommon.AddCreateNameForData(mod, 4, "OwnerUID", "", "", context.Request["Name"] ?? ""); StringBuilder orgJson = new StringBuilder(); if (mod.Status == "ok") { PagedDataModel <Dictionary <string, object> > pageModel = null; pageModel = mod.Data as PagedDataModel <Dictionary <string, object> >; List <Dictionary <string, object> > list = pageModel.PagedData as List <Dictionary <string, object> >; foreach (Dictionary <string, object> item in list) { if (!string.IsNullOrEmpty(item["CreateName"].ToString())) { orgJson.Append("<option value='" + item["OwnerUID"] + "'>" + item["CreateName"] + "</option>"); } } } //输出Json context.Response.Write(callback + "({\"result\":\"" + orgJson.ToString() + "\"})"); context.Response.End(); }
/// <summary> /// 遗忘提醒列表 /// </summary> /// <param name="context"></param> public void get_remind_list(HttpContext context) { Hashtable ht = new Hashtable(); HttpRequest Request = context.Request; try { string guid = Request["guid"]; //获取当前人的联系人(进行分页) if (dic_Self.ContainsKey(guid)) { int page_Index = Convert.ToInt32(Request["PageIndex"]); int page_Size = Convert.ToInt32(Request["PageSize"]); //进行分页 List <remind> list2 = GetPageByLinq(dic_Self[guid], page_Index, page_Size); //对象集合转为dic集合列表 List <Dictionary <string, object> > dicList = ConverList <remind> .ListToDic(list2); foreach (var item in dicList) { } //返回数据 PagedDataModel <Dictionary <string, object> > psd = new PagedDataModel <Dictionary <string, object> >() { PagedData = dicList, PageIndex = page_Index, PageSize = page_Size, RowCount = list2.Count }; //数据库包(json格式) jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = psd }; } else { bool ispage = false; if (!string.IsNullOrEmpty(context.Request["ispage"])) { ispage = Convert.ToBoolean(context.Request["ispage"]); } ht.Add("PageIndex", context.Request["PageIndex"] ?? "1"); ht.Add("PageSize", context.Request["PageSize"] ?? "10"); ht.Add("TableName", "remind"); //(select dbo.getlink_name(1) 这个是在数据库中建的函数 string fileds = "id,dbo.get_convert_date(rem_date)as rem_date,rem_content,rem_status,rem_isopen,dbo.get_am_pm(rem_date) as am_pm,dbo.get_hour_min(rem_date) as hour_min"; //新加字段fileds,主要是为了方便使用 jsonModel = Constant.remind_S.GetPage(ht, fileds, ispage, GetWhere(context)); } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = Constant.ErrorGetData(ex); } finally { context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 根据Id获取仪器设备历史列表数据 分页 /// </summary> /// <param name="Mod">查询条件</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">页容量,每页显示条数</param> /// <returns></returns> public EmsModel.JsonModel GetJsonModelByEquipId(Hashtable ht, bool ispage = true) { List <SqlParameter> pms = new List <SqlParameter>(); int PageIndex = 0, PageSize = 0, PageCount = 0, RowCount = 0; if (ispage) { //增加起始条数、结束条数 ht = common.AddStartEndIndex(ht); PageIndex = Convert.ToInt32(ht["PageIndex"]); PageSize = Convert.ToInt32(ht["PageSize"]); } DataTable modList = dal.GetListByPageAndEquipId(ht, ispage); //定义分页数据实体 PagedDataModel <Dictionary <string, object> > pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Rows.Count > 0) { //总条数 RowCount = Convert.ToInt32(ht["RowCount"].ToString()); if (ispage) { //总页数 PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = common.DataTableToList(modList); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "成功", Status = "ok", BackUrl = "" }; return(jsonModel); } else { jsonModel = new JsonModel() { Status = "no", Msg = "失败" }; return(jsonModel); } }
/// <summary> /// 获取盘点单列表数据 分页 /// </summary> /// <param name="ht">查询条件</param> /// <returns>符合数据</returns> public JsonModel GetInvenListDataPage(Hashtable ht, bool ispage = true) { try { //增加起始条数、结束条数 ht = common.AddStartEndIndex(ht); int PageIndex = Convert.ToInt32(ht["PageIndex"]); int PageSize = Convert.ToInt32(ht["PageSize"]); DataTable modList = dal.GetInvenListDataPage(ht, ispage); //定义分页数据实体 PagedDataModel <Dictionary <string, object> > pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Rows.Count <= 0) { jsonModel = new JsonModel() { Status = "no", Msg = "无数据" }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = common.DataTableToList(modList); //总条数 int RowCount = Convert.ToInt32(ht["RowCount"].ToString()); //总页数 int PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
/// <summary> /// 分页查询库存情况 /// </summary> /// <param name="ht"></param> /// <returns></returns> public JsonModel GetPageStock(Hashtable ht) { try { //增加起始条数、结束条数 ht = common.AddStartEndIndex(ht); int PageIndex = Convert.ToInt32(ht["PageIndex"]); int PageSize = Convert.ToInt32(ht["PageSize"]); DataTable dt = dal.GetListStock(ht); //定义分页数据实体 PagedDataModel <string> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (dt.Rows.Count <= 0) { jsonModel = new JsonModel() { Status = "no", Msg = "没有数据" }; return(jsonModel); } string jsondt = common.DataTableToJson(dt); List <string> list = new List <string>(); list.Add(jsondt); //总条数 int RowCount = dal.GetListByPageCountStock(ht); //总页数 int PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <string>() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
/// <summary> /// 查询根据条件 /// </summary> /// <param name="ht">查询条件</param> /// <returns>符合数据</returns> public JsonModel GetPage(Hashtable ht) { try { //增加起始条数、结束条数 ht = common.AddStartEndIndex(ht); int PageIndex = Convert.ToInt32(ht["PageIndex"]); int PageSize = Convert.ToInt32(ht["PageSize"]); List <EmsModel.View_EquipListDetail> modList = dal.GetList(ht); //定义分页数据实体 PagedDataModel <EmsModel.View_EquipListDetail> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Count <= 0) { jsonModel = new JsonModel() { Status = "no", Msg = "无数据" }; return(jsonModel); } var list = modList; //总条数 int RowCount = GetListByPageCount(ht); //总页数 int PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <EmsModel.View_EquipListDetail>() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
public EmsModel.JsonModel GetJsonModelEscheat2(string OrderID) { //当前页 int pageIndex = 1; //页容量 int pageSize = 999; EmsModel.OrderEquipDetail mod = new EmsModel.OrderEquipDetail(); mod.OrderId = Convert.ToInt32(OrderID); List <EmsModel.OrderEquipDetail> modList = new EmsBLL.OrderEquipDetail().GetListByPage(mod, 1, 999); //定义分页数据实体 PagedDataModel <EmsModel.OrderEquipDetail> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Count > 0) { var list = modList; //总条数 int rowCount = modList.Count; //总页数 int pageCount = (int)Math.Ceiling(rowCount * 1.0 / pageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <EmsModel.OrderEquipDetail>() { PageCount = pageCount, PagedData = list, PageIndex = pageIndex, PageSize = pageSize, RowCount = rowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "成功", Status = "ok", BackUrl = "" }; return(jsonModel); } else { jsonModel = new JsonModel() { Status = "no", Msg = "失败" }; return(jsonModel); } }
public JsonModel GetDataTableToJsonModel(DataTable modList) { JsonModel jsonModel = null; PagedDataModel <Dictionary <string, object> > pagedDataModel = null; int RowCount = 0; if (modList == null) { jsonModel = new JsonModel() { Status = "null", Msg = "无数据", errNum = 999 }; return(jsonModel); } RowCount = modList.Rows.Count; if (RowCount <= 0) { jsonModel = new JsonModel() { Status = "null", Msg = "无数据", errNum = 999 }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = common.DataTableToList(modList); int PageCount = (int)Math.Ceiling(RowCount * 1.0 / 10000); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = PageCount, PagedData = list, PageIndex = 1, PageSize = 10000, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { errNum = 0, Msg = "success", Data = pagedDataModel, Status = "ok" }; return(jsonModel); }
/// <summary> /// 导出盘点单信息 /// </summary> /// <param name="ht"></param> /// <returns></returns> public JsonModel ExportInventoryExcel(Hashtable ht) { try { //增加起始条数、结束条数 ht = common.AddStartEndIndex(ht); int PageIndex = Convert.ToInt32(ht["PageIndex"]); int PageSize = Convert.ToInt32(ht["PageSize"]); DataTable modList = dal.GetInvenListDataPage(ht, false); //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Rows.Count <= 0) { jsonModel = new JsonModel() { Status = "no", Msg = "无数据" }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = common.DataTableToList(modList); PagedDataModel <Dictionary <string, object> > pagedDataModel = null; pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = 1, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = 1 }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
public EmsModel.JsonModel GetJsonModel(EmsModel.Warehouse ware) { //当前页 int pageIndex = 1; //页容量 int pageSize = 16; List <EmsModel.Warehouse> modList = GetList(ware); //定义分页数据实体 PagedDataModel <EmsModel.Warehouse> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Count > 0) { var list = modList; //总条数 int rowCount = modList.Count; //总页数 int pageCount = (int)Math.Ceiling(rowCount * 1.0 / pageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <EmsModel.Warehouse>() { PageCount = pageCount, PagedData = list, PageIndex = pageIndex, PageSize = pageSize, RowCount = rowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "成功", Status = "ok", BackUrl = "" }; return(jsonModel); } else { jsonModel = new JsonModel() { Status = "no", Msg = "失败" }; return(jsonModel); } }
/// <summary> /// 获取房间的仪器设备信息 /// </summary> /// <param name="invenid">盘点单id</param> /// <param name="roomid">房间id</param> /// <returns></returns> public EmsModel.JsonModel GetJsonModelEquip(string invenid, string roomid) { //当前页 int pageIndex = 1; //页容量 int pageSize = 999; List <EmsModel.View_InvenRoomEquip> modList = dal.GetRoomEquipList(invenid, roomid); //定义分页数据实体 PagedDataModel <EmsModel.View_InvenRoomEquip> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Count > 0) { var list = modList; //总条数 int rowCount = modList.Count; //总页数 int pageCount = (int)Math.Ceiling(rowCount * 1.0 / pageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <EmsModel.View_InvenRoomEquip>() { PageCount = pageCount, PagedData = list, PageIndex = pageIndex, PageSize = pageSize, RowCount = rowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "成功", Status = "ok", BackUrl = "" }; return(jsonModel); } else { jsonModel = new JsonModel() { Status = "no", Msg = "失败" }; return(jsonModel); } }
/// <summary> /// 获取提醒设置实例 /// </summary> /// <param name="context"></param> public void get_remind_setting_info(HttpContext context) { HttpRequest Request = context.Request; Hashtable ht = new Hashtable(); try { string guid = Request["guid"]; //获取当前人的联系人(进行分页) if (dic_Self.ContainsKey(guid)) { int page_Index = Convert.ToInt32(Request["PageIndex"]); int page_Size = Convert.ToInt32(Request["PageSize"]); //对象集合转为dic集合列表 List <Dictionary <string, object> > dicList = ConverList <remind_setting> .ListToDic(dic_Self[guid]); //返回数据 PagedDataModel <Dictionary <string, object> > psd = new PagedDataModel <Dictionary <string, object> >() { PagedData = dicList, PageIndex = page_Index, PageSize = page_Size, RowCount = dicList.Count }; //数据库包(json格式) jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = psd }; } else { ht.Add("TableName", "remind_setting"); //(select dbo.getlink_name(1) 这个是在数据库中建的函数 string fileds = "*"; //新加字段fileds,主要是为了方便使用 jsonModel = Constant.remind_setting_S.GetPage(ht, fileds, false, GetWhere(context)); } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = Constant.ErrorGetData(ex); } finally { context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
public JsonModel GetJsonModelByDataTable(DataTable modList) { try { //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Rows.Count <= 0) { jsonModel = new JsonModel() { Data = "", Status = "no", Msg = "失败" }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = new BLLCommon().DataTableToList(modList); PagedDataModel <Dictionary <string, object> > pagedDataModel = null; pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = 1, PagedData = list, PageIndex = 1, PageSize = 1, RowCount = 1 }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel() { Data = "", Status = "error", Msg = ex.ToString() }; return(jsonModel); } }
/// <summary> /// 获得Model根据Id /// </summary> /// <param name="Id"></param> /// <returns></returns> public EmsModel.JsonModel GetExperiment(string Id) { try { DataTable modList = dal.GetData3(Id); PagedDataModel <Dictionary <string, object> > pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Rows.Count == 0) { jsonModel = new JsonModel() { Status = "no", Msg = "无数据" }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = com.DataTableToList(modList); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = 1, PagedData = list, PageIndex = 1, PageSize = 1, RowCount = 1 }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
/// <summary> /// 获得设备详情信息 /// </summary> /// <param name="ht">查询条件</param> /// <returns>符合数据</returns> public JsonModel GetEquipDetail(Hashtable ht) { try { DataTable dt = dal.GetEquipDetail(ht); //定义JSON标准格式实体中 JsonModel jsonModel = null; if (dt.Rows.Count <= 0) { jsonModel = new JsonModel() { Status = "no", Msg = "无数据" }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = common.DataTableToList(dt); PagedDataModel <Dictionary <string, object> > pagedDataModel = null; pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = 1, PagedData = list, PageIndex = 1, PageSize = 1, RowCount = 1 }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
/// <summary> /// 获取盘点计划列表数据 分页 /// </summary> /// <param name="Mod">查询条件</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">页容量,每页显示条数</param> /// <returns></returns> public EmsModel.JsonModel GetJsonModel(EmsModel.InventoryPlan Mod, int pageIndex, int pageSize) { List <EmsModel.InventoryPlan> modList = dal.GetListByPageAndSear(Mod, ((pageIndex - 1) * pageSize) + 1, (pageIndex * pageSize)); //定义分页数据实体 PagedDataModel <EmsModel.InventoryPlan> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Count > 0) { var list = modList; //总条数 int rowCount = dal.GetListByPageCountAndSear(Mod); //总页数 int pageCount = (int)Math.Ceiling(rowCount * 1.0 / pageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <EmsModel.InventoryPlan>() { PageCount = pageCount, PagedData = list, PageIndex = pageIndex, PageSize = pageSize, RowCount = rowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "成功", Status = "ok", BackUrl = "" }; return(jsonModel); } else { jsonModel = new JsonModel() { Status = "no", Msg = "失败" }; return(jsonModel); } }
/// <summary> /// 获取仪器设备分类数据 分页 /// </summary> /// <param name="Mod">查询条件</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">页容量,每页显示条数</param> /// <returns></returns> public EmsModel.JsonModel GetJsonModel(EmsModel.InstrumentEquip Mod, int pageIndex, int pageSize, string joinStr = "=", string selwareid = "") { List <EmsModel.InstrumentEquip> modList = dal.GetListByPageAndWareid(Mod, ((pageIndex - 1) * pageSize) + 1, (pageIndex * pageSize), joinStr, selwareid); //定义分页数据实体 PagedDataModel <EmsModel.InstrumentEquip> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Count > 0) { var list = modList; //总条数 int rowCount = dal.GetListByPageCountAndWareid(Mod, joinStr, selwareid); //总页数 int pageCount = (int)Math.Ceiling(rowCount * 1.0 / pageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <EmsModel.InstrumentEquip>() { PageCount = pageCount, PagedData = list, PageIndex = pageIndex, PageSize = pageSize, RowCount = rowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "成功", Status = "ok", BackUrl = "" }; return(jsonModel); } else { jsonModel = new JsonModel() { Status = "no", Msg = "失败" }; return(jsonModel); } }
public void ProcessRequest(HttpContext context) { evalCourse evalCourse = new evalCourse(); JsonModel jsonModel = new JsonModel(); PagedDataModel<evalCourse> jsonPagedDataModel = new PagedDataModel<evalCourse>(); jc_Public jcPublic = new jc_Public(); int totalcount = 0; var userId = context.Request.QueryString["userId"]; var evalStatus = context.Request.QueryString["evalStatus"]; var PageIndex = context.Request.QueryString["PageIndex"]; var PageSize = context.Request.QueryString["PageSize"]; if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(evalStatus) || string.IsNullOrEmpty(PageIndex) || string.IsNullOrEmpty(PageSize)) { jsonModel.Status = "0"; jsonModel.Message = "缺少必要参数!"; } else { string strWhere = "and u.evalUserId=" + userId + " and u.evalStatus=" + evalStatus; string strSql = @" SELECT u.evalUserId, c.evalCourseName, c.evalCourseTeacher, c.evalCourseDate,u.evalStatus,c.evalCourseId, c.evalSurveryId FROM jc_EvaluateCourseUser u, jc_EvaluateCourse c WHERE u.evalCourseId = c.evalCourseId "; jsonPagedDataModel.PagedData = evalCourse.GetevalCourseList(jcPublic.GetList(strSql + strWhere, "evalUserId", int.Parse(PageIndex), int.Parse(PageSize), out totalcount).Tables[0]); jsonPagedDataModel.PageCount = totalcount / int.Parse(PageIndex); jsonPagedDataModel.PageIndex = int.Parse(PageIndex); jsonPagedDataModel.RowCount = totalcount; jsonModel.Data = jsonPagedDataModel; jsonModel.Status = "1"; jsonModel.Message = "查询成功!"; } var js = new JavaScriptSerializer(); context.Response.Write(js.Serialize(jsonModel)); }
public virtual JsonModel GetPage_1(Hashtable ht, string fileds, bool IsPage = true, string where = "") { int RowCount = 0; BLLCommon common = new BLLCommon(); try { int PageIndex = 0; int PageSize = 0; if (IsPage) { //增加起始条数、结束条数 ht = common.AddStartEndIndex(ht); PageIndex = Convert.ToInt32(ht["PageIndex"]); PageSize = Convert.ToInt32(ht["PageSize"]); } DataTable modList = CurrentDal.GetListByPage_1(ht, fileds, out RowCount, IsPage, where); //定义分页数据实体 PagedDataModel <Dictionary <string, object> > pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList == null || modList.Rows.Count <= 0) { jsonModel = new JsonModel() { errNum = 999, errMsg = "无数据", retData = "" }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = common.DataTableToList(modList); if (IsPage) { //list.Add(common.DataTableToJson(modList)); //总条数 //int RowCount = modList.Rows.Count;// CurrentDal.GetRecordCount(ht, null); //总页数 int PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = pagedDataModel }; } else { jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = list }; } return(jsonModel); } catch (Exception ex) { LogHelper.Error(ex); JsonModel jsonModel = new JsonModel() { errNum = 400, errMsg = ex.Message, retData = "" }; return(jsonModel); } }
public JsonModel GetDataTableToJsonModel(DataTable modList, Hashtable ht) { JsonModel jsonModel = null; try { PagedDataModel <Dictionary <string, object> > pagedDataModel = null; int PageIndex = int.Parse(Convert.ToString(ht["PageIndex"])); int PageSize = int.Parse(Convert.ToString(ht["PageSize"])); int RowCount = 0; if (modList == null) { jsonModel = new JsonModel() { status = "null", errMsg = "无数据", errNum = 999 }; return(jsonModel); } RowCount = modList.Rows.Count; if (RowCount <= 0) { jsonModel = new JsonModel() { status = "null", errMsg = "无数据", errNum = 999 }; return(jsonModel); } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); DataTable newDt = GetPagedTable(modList, PageIndex, PageSize); list = common.DataTableToList(newDt); int PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = pagedDataModel, status = "ok" }; return(jsonModel); } catch (Exception ex) { jsonModel = new JsonModel() { errNum = 400, errMsg = ex.Message, retData = "" }; return(jsonModel); } }
/// <summary> /// 签到列表 /// </summary> /// <param name="context"></param> public void get_sign_list(HttpContext context, string guid) { HttpRequest Request = context.Request; try { //分页信息 int page_Index = RequestHelper.int_transfer(Request, "PageIndex"); int page_Size = RequestHelper.int_transfer(Request, "PageSize"); //開始日期 DateTime stardate = RequestHelper.DateTime_transfer(Request, "stardate"); //結束日期 DateTime enddate = RequestHelper.DateTime_transfer(Request, "enddate").AddDays(1); //部门的ID号【传参 】 string departmentID = RequestHelper.string_transfer(Request, "departmentID"); string memmberID = RequestHelper.string_transfer(Request, "memmberID"); var sign_in_selfs = from t in dic_Self[guid] select t; //指定签到客户 long sign_cust_id = RequestHelper.long_transfer(Request, "sign_cust_id"); //获取签到列表【筛选】 sign_in_selfs = get_signs_helper(stardate, enddate, sign_in_selfs, sign_cust_id); sign_in_selfs = Check_And_Get_List_dep(departmentID, memmberID, sign_in_selfs); int sign_count = sign_in_selfs.Count(); //进行分页 List <sign_in> list_sign_in_page = GetPageByLinq(sign_in_selfs.ToList(), page_Index, page_Size); //对象集合转为dic集合列表 List <Dictionary <string, object> > dicList = ConverList <sign_in> .ListToDic(list_sign_in_page); //客户列表,当前用户 List <cust_customer> cust_customer_selfs = cust_customer_handle.dic_Self[guid]; foreach (var item in dicList) { item["sign_date"] = Convert.ToDateTime(item["sign_date"]).ToString("yyyy-MM-dd HH:mm"); long sign_cust_id_c = Convert.ToInt64(item["sign_cust_id"]); cust_customer _cust_customer = (from t in cust_customer_selfs where sign_cust_id_c == (long)t.id select t).FirstOrDefault(); if (_cust_customer != null) { item.Add("cust_name", _cust_customer.cust_name); } } string status = string.Empty; //返回数据 PagedDataModel <Dictionary <string, object> > psd = new PagedDataModel <Dictionary <string, object> >() { PagedData = dicList, PageIndex = page_Index, PageSize = page_Size, RowCount = sign_count }; //数据包(json格式) jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = psd, status = status }; } catch (Exception ex) { LogHelper.Error(ex); jsonModel = Constant.ErrorGetData(ex); } finally { //管理者 if (Constant.dicLimit_P.ContainsKey(guid)) { jsonModel.status = "IsAdmin"; } context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 获取工作计划(分页) /// </summary> /// <param name="context"></param> public void get_workplan_list(HttpContext context, string guid) { HttpRequest Request = context.Request; try { //分页信息 int page_Index = RequestHelper.int_transfer(Request, "PageIndex"); int page_Size = RequestHelper.int_transfer(Request, "PageSize"); long wp_link_id = RequestHelper.long_transfer(Request, "wp_link_id"); //部门的ID号【传参 】 string departmentID = RequestHelper.string_transfer(Request, "departmentID"); string memmberID = RequestHelper.string_transfer(Request, "memmberID"); //工作计划,当前用户 List <workplan> workplan_selfs = workplan_handle.dic_Self[guid]; //通过部门获取数据【或者纯粹获取某个成员的工作计划】 workplan_selfs = Check_And_Get_List_dep(departmentID, memmberID, workplan_selfs).ToList(); int workplan_count = workplan_selfs.Count; //进行分页 List <workplan> workplans = GetPageByLinq(workplan_selfs, page_Index, page_Size); //对象集合转为dic集合列表 List <Dictionary <string, object> > dicList = ConverList <workplan> .ListToDic(workplans); if (workplans.Count > 0) { //数据对应 foreach (var item in dicList) { DateTime datetime_P = Convert.ToDateTime(item["wp_plandate"]); int pc = datetime_P.Hour; //工作计划具体时间 下午hh:mm 上午hh:mm if (pc > 12) { item["wp_plandate"] = datetime_P.ToString("yyyy年 MM月dd日"); } else { item["wp_plandate"] = datetime_P.ToString("yyyy年 MM月dd日"); } //联系人列表,当前用户 List <cust_linkman> cust_linkman_selfs = cust_linkman_handle.dic_Self[guid]; //联系人和职位 cust_linkman linkman = (from t in cust_linkman_selfs where t.id == wp_link_id select t).FirstOrDefault(); if (linkman != null) { item["link_name"] = linkman.link_name; item["link_position"] = linkman.link_position; item["cust_name"] = linkman.link_cust_name; } } } //返回数据 PagedDataModel <Dictionary <string, object> > psd = new PagedDataModel <Dictionary <string, object> >() { PagedData = dicList, PageIndex = page_Index, PageSize = page_Size, RowCount = workplan_count }; //数据包(json格式) jsonModel = Constant.get_jsonmodel(0, "success", psd); } catch (Exception ex) { LogHelper.Error(ex); jsonModel = Constant.ErrorGetData(ex); } finally { string status = string.Empty; //管理者 if (Constant.dicLimit_P.ContainsKey(guid)) { jsonModel.status = "IsAdmin"; } context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 获取联系人列表 /// </summary> /// <param name="context"></param> public void get_cust_linkman_list(HttpContext context, string guid) { HttpRequest Request = context.Request; try { int page_Index = RequestHelper.int_transfer(Request, "PageIndex"); int page_Size = RequestHelper.int_transfer(Request, "PageSize"); //通过客户信息ID号获取对应的联系人 long link_cust_id = RequestHelper.long_transfer(Request, "link_cust_id"); ////指定客户ID获取联系人【获取所有联系人】 //List<cust_linkman> list_linkman = null; //按联系人名称进行模糊搜索 string link_name = RequestHelper.string_transfer(Request, "link_name"); //部门的ID号【传参 】 string departmentID = RequestHelper.string_transfer(Request, "departmentID"); string memmberID = RequestHelper.string_transfer(Request, "memmberID"); //联系人列表,当前用户 var cust_linkman_selfs = from t in dic_Self[guid] select t; cust_linkman_selfs = Check_And_Get_List_dep(departmentID, memmberID, cust_linkman_selfs); if (link_cust_id > 0) { cust_linkman_selfs = (from t in cust_linkman_selfs where t.link_cust_id == link_cust_id && t.link_name.Contains(link_name) orderby t.id descending select t); } else { cust_linkman_selfs = (from t in cust_linkman_selfs where t.link_name.Contains(link_name) orderby t.id descending select t); } List <cust_linkman> list_linkmans = cust_linkman_selfs.ToList(); int all_count = list_linkmans.Count; //是否为页面 bool ispage = RequestHelper.bool_transfer(Request, "ispage"); if (ispage) { //进行分页 List <cust_linkman> list_linkman_page = GetPageByLinq(list_linkmans, page_Index, page_Size); //对象集合转为dic集合列表 List <Dictionary <string, object> > dic_list_linkman_page = ConverList <cust_linkman> .ListToDic(list_linkman_page); foreach (var item in dic_list_linkman_page) { string link_level = Convert.ToString(item["link_level"]); item["link_level_name"] = LevelHelper.Getlink_level(link_level); } //返回数据 PagedDataModel <Dictionary <string, object> > psd = new PagedDataModel <Dictionary <string, object> >() { PagedData = dic_list_linkman_page, PageIndex = page_Index, PageSize = page_Size, RowCount = all_count }; //数据库包(json格式) jsonModel = Constant.get_jsonmodel(0, "success", psd); } else { //数据库包(json格式)item["link_levelName"] = pub_param_handle.dic_linkMan_Grade[Convert.ToString(item["link_level"])]; jsonModel = Constant.get_jsonmodel(0, "success", list_linkmans); } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = Constant.ErrorGetData(ex); } finally { context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
public JsonModel GetPage(Hashtable ht) { try { //增加起始条数、结束条数 ht = common.AddStartEndIndex(ht); int PageIndex = Convert.ToInt32(ht["PageIndex"]); int PageSize = Convert.ToInt32(ht["PageSize"]); if (ht.Contains("RoleID") && !string.IsNullOrEmpty(ht["AdminRoleID"].ToString())) { string[] roles = ht["RoleID"].ToString().Split('㊣'); if (Array.IndexOf(roles, ht["AdminRoleID"].ToString()) != -1) { ht.Remove("Creator"); } } DataTable modList = dal.GetPage(ht); //定义分页数据实体 PagedDataModel <string> pagedDataModel = null; //定义JSON标准格式实体中 JsonModel jsonModel = null; if (modList.Rows.Count <= 0) { jsonModel = new JsonModel() { Status = "no", Msg = "无数据" }; return(jsonModel); } List <string> list = new List <string>(); list.Add(common.DataTableToJson(modList)); //总条数 int RowCount = Convert.ToInt32(ht["RowCount"].ToString()); //总页数 int PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); //将数据封装到PagedDataModel分页数据实体中 pagedDataModel = new PagedDataModel <string>() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { Data = pagedDataModel, Msg = "", Status = "ok", BackUrl = "" }; return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
/// <summary> /// 获取共享圈内容 /// </summary> /// <param name="context"></param> public void get_share_list(HttpContext context) { HttpRequest Request = context.Request; //当前用户ID string guid = RequestHelper.string_transfer(Request, "guid"); try { //请求参数 bool ispage = RequestHelper.bool_transfer(Request, "ispage"); //每一页包含的数量 int PageSize = RequestHelper.int_transfer(Request, "PageSize"); //第几页 int PageIndex = RequestHelper.int_transfer(Request, "PageIndex"); //封装到PagedDataModel的元数据 List <report> report_List = new List <report>(); //进行分页 List <share> list2 = GetPageByLinq(list_All, PageIndex, PageSize); //数据对应 foreach (var fp in list2) { List <workreport> list1 = (from t in workreport_handle.list_All where t.id == Convert.ToInt64(fp.table_id) select t).ToList(); //跟进记录(对应页面的实体类型) report report = new report(); List <praise> list_praise = (from t in praise_handle.list_All where t.praise_table_id == Convert.ToInt64(fp.id) && t.praise_userid == guid && t.praise_type == "2" select t).ToList(); string is_praise = ""; if (list_praise.Count > 0) { is_praise = "1"; } else { is_praise = "0"; } //附件跟进记录(对应页面的实体类型【通过数据库映射填充实体所需部分信息】) foreach (var work_report in list1) { report.report_info = new report_info() { report_content = work_report.report_content, report_username = work_report.report_username, report_createdate = Convert.ToDateTime(work_report.report_createdate).ToString("yyyy-MM-dd"), work_report_id = Convert.ToInt64(work_report.id), report_startdate = Convert.ToDateTime(work_report.report_startdate).ToString("yyyy-MM-dd"), report_enddate = Convert.ToDateTime(work_report.report_enddate).ToString("yyyy-MM-dd"), report_plan = work_report.report_plan, is_praise = is_praise, id = Convert.ToInt32(fp.id), report_type = (int)work_report.report_type, }; } #region 获取图片 if (Constant.list_picture_All != null) { //获取指定的图片【类型 和ID】 List <picture> list_picture = (from t in Constant.list_picture_All where t.pic_en_table == "workreport" && t.pic_table_id == Convert.ToInt32(fp.id) select t).ToList <picture>(); List <Dictionary <string, object> > list_picture_1 = ConverList <picture> .ListToDic(list_picture); report.picture = list_picture_1; } #endregion #region 获取评论 var d = comment_handle.list_All.Where(i => i.com_type == "3").ToList(); //获取指定的图片【类型 和ID】 List <comment> list_p = (from t in comment_handle.list_All where t.com_table_id == Convert.ToInt32(fp.id) && t.com_isdelete == "0" && t.com_type == "3" select t).ToList <comment>(); List <Dictionary <string, object> > list = ConverList <comment> .ListToDic(list_p); report.comment = list; #endregion #region 获取点赞人 List <praise> list_praises = (from t in praise_handle.list_All where t.praise_table_id == Convert.ToInt32(fp.id) && t.praise_type == "2" select t).ToList <praise>(); List <Dictionary <string, object> > list_p1 = ConverList <praise> .ListToDic(list_praises); report.praise = list_p1; #endregion report_List.Add(report); } //返回数据 PagedDataModel <report> psd = new PagedDataModel <report>() { PagedData = report_List, PageIndex = PageIndex, PageSize = PageSize, RowCount = list_All.Count }; //数据包(json格式) jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = psd }; } catch (Exception ex) { jsonModel = Constant.ErrorGetData(ex.Message); } finally { #region 没有缓存机制的情况下用的 //string jsonString = Constant.bbc.ConverDatetime(Constant.jss.Serialize(jsonModel)); //context.Response.Write("{\"result\":" + jsonString + "}"); #endregion string result = Constant.jss.Serialize(jsonModel); context.Response.Write("{\"result\":" + result + "}"); } }
private void SearchFromIndexData(HttpContext context) { string indexPath = context.Server.MapPath("~/IndexData"); FSDirectory directory = FSDirectory.Open(new DirectoryInfo(indexPath), new NoLockFactory()); IndexReader reader = IndexReader.Open(directory, true); IndexSearcher searcher = new IndexSearcher(reader); //--------------------------------------这里配置搜索条件 //PhraseQuery query = new PhraseQuery(); //foreach(string word in Common.SplitContent.SplitWords(Request.QueryString["SearchKey"])) { // query.Add(new Term("content", word));//这里是 and关系 //} //query.SetSlop(100); //关键词Or关系设置 BooleanQuery queryOr = new BooleanQuery(); TermQuery query = null; foreach (string word in Common.SplitContent.SplitWords(context.Request["SearchKey"])) { query = new TermQuery(new Term("CreativeHTML", word)); queryOr.Add(query, BooleanClause.Occur.SHOULD); //这里设置 条件为Or关系 query = new TermQuery(new Term("Description", word)); queryOr.Add(query, BooleanClause.Occur.SHOULD); //这里设置 条件为Or关系 } //-------------------------------------- TopScoreDocCollector collector = TopScoreDocCollector.create(1000, true); //searcher.Search(query, null, collector); searcher.Search(queryOr, null, collector); int PageIndex = int.Parse(Convert.ToString(context.Request["PageIndex"])); int PageSize = int.Parse(Convert.ToString(context.Request["PageSize"])); ScoreDoc[] docs = collector.TopDocs((PageIndex - 1) * PageSize, PageIndex * PageSize).scoreDocs;//取前十条数据 可以通过它实现LuceneNet搜索结果分页 List <PZYM.Shop.Model.Books> bookResult = new List <PZYM.Shop.Model.Books>(); DataTable dt = new DataTable(); dt.TableName = "ds"; dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("Description", typeof(string)); dt.Columns.Add("CreativeHTML", typeof(string)); dt.Columns.Add("MenuId", typeof(int)); for (int i = 0; i < docs.Length; i++) { int docId = docs[i].doc; Document doc = searcher.Doc(docId); PZYM.Shop.Model.Books book = new PZYM.Shop.Model.Books(); book.Description = Common.SplitContent.HightLight(context.Request["SearchKey"], doc.Get("Description")); book.CreativeHTML = Common.SplitContent.HightLight(context.Request["SearchKey"], doc.Get("CreativeHTML")); book.Id = Convert.ToInt32(doc.Get("Id")); //bookResult.Add(book); DataRow dr = dt.NewRow(); dr["Description"] = book.Description; dr["CreativeHTML"] = book.CreativeHTML; //string CreativeHTML = book.CreativeHTML; //Regex objRegex = new Regex("/<[^>]*>/g", RegexOptions.IgnoreCase); //dr["CreativeHTML"] = objRegex.Replace(book.CreativeHTML, ""); dr["Id"] = book.Id; dr["MenuId"] = Convert.ToInt32(doc.Get("MenuId")); dt.Rows.Add(dr); } JsonModel jsonModel = null; int RowCount = 0; PagedDataModel <Dictionary <string, object> > pagedDataModel = null; if (dt == null) { jsonModel = new JsonModel() { status = "no", errMsg = "无数据" }; } RowCount = dt.Rows.Count; if (RowCount <= 0) { jsonModel = new JsonModel() { status = "no", errMsg = "无数据" }; } List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); list = DataTableToList(dt); int PageCount = (int)Math.Ceiling(RowCount * 1.0 / PageSize); pagedDataModel = new PagedDataModel <Dictionary <string, object> >() { PageCount = PageCount, PagedData = list, PageIndex = PageIndex, PageSize = PageSize, RowCount = RowCount }; //将分页数据实体封装到JSON标准实体中 jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = pagedDataModel }; System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); context.Response.Write("{\"result\":" + jss.Serialize(jsonModel) + "}"); }
/// <summary> /// 获取跟进记录列表 /// </summary> /// <param name="context"></param> public void get_follow_up_list(HttpContext context, string guid) { HttpRequest Request = context.Request; try { //缓存应用 if (Data_check_helper.check_Self(handertype, guid)) { //是否分页 bool ispage = RequestHelper.bool_transfer(Request, "ispage"); //每一页包含的数量 int PageSize = RequestHelper.int_transfer(Request, "PageSize"); //第几页 int PageIndex = RequestHelper.int_transfer(Request, "PageIndex"); //封装到PagedDataModel的元数据 List <follow> follow_List = new List <follow>(); //跟进客户的客户ID int follow_cust_id = RequestHelper.int_transfer(Request, "follow_cust_id"); //跟进客户的联系人ID int link_l_id = RequestHelper.int_transfer(Request, "link_id"); //筛选日期 string riqi = RequestHelper.string_transfer(Request, "riqi"); //我的跟进GUID string is_self_guid = RequestHelper.string_transfer(Request, "is_self_guid"); //部门的ID号【传参 】 string departmentID = RequestHelper.string_transfer(Request, "departmentID"); string memmberID = RequestHelper.string_transfer(Request, "memmberID"); var data_list = from t in dic_Self[guid] select t; data_list = Check_And_Get_List_dep(departmentID, memmberID, data_list); List <follow_up> follow_ups = GetPage_Helper(data_list, follow_cust_id, link_l_id, riqi, is_self_guid).ToList(); int follow_count = follow_ups.Count; follow_ups = follow_ups.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList(); //数据对应 foreach (var fp in follow_ups) { //跟进记录(对应页面的实体类型) follow follow = new follow(); //评论数量 int list_praise_count = praise_handle.list_All.Count(t => t.praise_table_id == (long)fp.id && t.praise_userid == guid && t.praise_type == "1"); //是否包含评论 string is_praise = list_praise_count > 0 ? "1" : "0"; //附件跟进记录(对应页面的实体类型【通过数据库映射填充实体所需部分信息】) int picture_count = 0; if (Constant.list_picture_All != null) { //获取指定的图片【类型 和ID】 picture_count = Constant.list_picture_All.Count(t => t.pic_en_table == "follow_up" && t.pic_table_id == Convert.ToInt32(fp.id)); } follow.follow_up_info = new follow_up_info() { follow_content = fp.follow_content, follow_cust_id = (long)fp.follow_cust_id, follow_date = ((DateTime)fp.follow_date).ToString("yyyy-MM-dd"), follow_link_id = (long)fp.follow_link_id, follow_username = fp.follow_username, is_praise = is_praise, id = (long)fp.id, picture_count = picture_count, follow_createdate = Convert.ToString(fp.follow_createdate), }; //获取跟进类型 string type_string = Convert.ToString(fp.follow_type); if (!string.IsNullOrEmpty(type_string) && pub_param_handle.dic_follow_Level.ContainsKey(type_string)) { follow.follow_up_info.follow_type = pub_param_handle.dic_follow_Level[type_string]; } //获取客户和联系人 get_customer_linkman(guid, fp, follow); //获取图片评论和点赞 get_picture_praise_comment(fp, follow); follow_List.Add(follow); } //返回数据 PagedDataModel <follow> psd = new PagedDataModel <follow>() { PagedData = follow_List, PageIndex = PageIndex, PageSize = PageSize, RowCount = follow_count }; //数据包(json格式) jsonModel = new JsonModel() { errNum = 0, errMsg = "success", retData = psd }; } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = Constant.ErrorGetData(ex.Message); } finally { if (Constant.dicLimit_P.ContainsKey(guid)) { jsonModel.status = "IsAdmin"; } string result = Constant.jss.Serialize(jsonModel); context.Response.Write("{\"result\":" + result + "}"); } }
/// <summary> /// 获取报告列表 /// </summary> /// <param name="context"></param> public void get_workreport_list(HttpContext context, string guid) { HttpRequest Request = context.Request; try { int page_Index = RequestHelper.int_transfer(Request, "PageIndex"); int page_Size = RequestHelper.int_transfer(Request, "PageSize"); int type = RequestHelper.int_transfer(Request, "type"); string report_reader = RequestHelper.string_transfer(Request, "report_reader"); int report_type = RequestHelper.int_transfer(Request, "report_type"); //用户ID【指定自己下属的】 string report_userid = RequestHelper.string_transfer(Request, "report_userid"); //部门的ID号【传参 】 string departmentID = RequestHelper.string_transfer(Request, "departmentID"); string memmberID = RequestHelper.string_transfer(Request, "memmberID"); //筛选报告 var workreports = select_report_list(guid, type, report_type, report_userid); workreports = Check_And_Get_List_dep(departmentID, memmberID, workreports); int workreport_count = workreports.Count(); //进行分页 List <workreport> list_workreport = GetPageByLinq(workreports.ToList(), page_Index, page_Size); //对象集合转为dic集合列表 List <Dictionary <string, object> > dicList = ConverList <workreport> .ListToDic(list_workreport); foreach (var item in dicList) { item["report_startdate"] = Convert.ToDateTime(item["report_startdate"]).ToString("yyyy-MM-dd"); item["report_enddate"] = Convert.ToDateTime(item["report_enddate"]).ToString("yyyy-MM-dd"); item["report_createdate"] = Convert.ToDateTime(item["report_createdate"]).ToString("yyyy-MM-dd"); } //返回数据 PagedDataModel <Dictionary <string, object> > psd = new PagedDataModel <Dictionary <string, object> >() { PagedData = dicList, PageIndex = page_Index, PageSize = page_Size, RowCount = workreport_count }; //数据库包(json格式) jsonModel = Constant.get_jsonmodel(0, "success", psd); } catch (Exception ex) { jsonModel = Constant.ErrorGetData(ex); } finally { //管理者 若为1 代表当前人为管理员 若为0则为普通员工 if (Constant.dicLimit_P.ContainsKey(guid)) { jsonModel.status = "IsAdmin"; } context.Response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 为返回的数据添加用户姓名列 /// </summary> /// <param name="jsonModel">数据</param> /// <param name="type">type 0获取所有学生(默认);1获取所有教师;2 根据UniqueNo获取用户;3 根据UniqueNo获取学生;4 获取所有用户信息</param> /// <param name="oneUserField">第一个需要返回用户姓名的列</param> /// <param name="uniqueNos">uniqueNos字符串,以逗号分隔,默认为空</param> /// <param name="twoUserField">第二个需要返回用户姓名的列</param> /// <param name="name">根据名称搜索</param> /// <param name="learnYearField">学年学期字段</param> /// <param name="AcademicId">默认0 当前学期; 历史学期 传学期id</param> /// <returns></returns> public JsonModel AddCreateNameForData(JsonModel jsonModel, int type = 0, string oneUserField = "CreateUID", string uniqueNos = "", string twoUserField = "", string name = "", string learnYearField = "", string AcademicId = "0") { if (jsonModel.Status == "ok") { List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); List <Dictionary <string, object> > classList = new List <Dictionary <string, object> >(); List <Dictionary <string, object> > learnYearList = new List <Dictionary <string, object> >(); PagedDataModel <Dictionary <string, object> > pageModel = null; pageModel = jsonModel.Data as PagedDataModel <Dictionary <string, object> >; list = pageModel.PagedData as List <Dictionary <string, object> >; List <Dictionary <string, object> > allList = new List <Dictionary <string, object> >(); allList = GetUnifiedUserData(type, uniqueNos, name, AcademicId); if (!string.IsNullOrEmpty(name)) { List <string> stuUniqueNo = (from dic in allList select dic["UniqueNo"].ToString()).ToList(); list = (from dic in list where stuUniqueNo.Contains(dic[oneUserField].ToString()) select dic).ToList(); } if (!string.IsNullOrEmpty(learnYearField)) { learnYearList = GetStudySectionData(); } foreach (Dictionary <string, object> item in list) { try { Dictionary <string, object> dicItem = (from dic in allList where dic["UniqueNo"].ToString() == item[oneUserField].ToString() select dic).FirstOrDefault(); item.Add("CreateName", dicItem == null ? "" : dicItem["Name"].ToString()); item.Add("OneLoginName", dicItem == null ? "" : dicItem["LoginName"].ToString()); item.Add("AbsHeadPic", dicItem == null ? "" : dicItem["AbsHeadPic"].ToString()); if (dicItem != null && dicItem.ContainsKey("OrgName")) { item.Add("OrgName", dicItem["OrgName"].ToString()); } if (dicItem != null && dicItem.ContainsKey("GradeName")) { item.Add("GradeName", dicItem["GradeName"].ToString()); } if (!string.IsNullOrEmpty(twoUserField)) { Dictionary <string, object> dicItem_two = (from dic in allList where dic["UniqueNo"].ToString() == item[twoUserField].ToString() select dic).FirstOrDefault(); item.Add("TwoUserName", dicItem_two == null ? "" : dicItem_two["Name"].ToString()); item.Add("TwoAbsHeadPic", dicItem_two == null ? "" : dicItem_two["AbsHeadPic"].ToString()); } if (!string.IsNullOrEmpty(learnYearField)) { Dictionary <string, object> learnItem = (from dic in learnYearList where dic["Id"].ToString() == item[learnYearField].ToString() select dic).FirstOrDefault(); item.Add("LearnYearName", learnItem == null ? "" : learnItem["Academic"].ToString()); item.Add("StartDate", learnItem == null ? "" : learnItem["StartDate"].ToString()); item.Add("EndDate", learnItem == null ? "" : learnItem["EndDate"].ToString()); } } catch (Exception ex) { LogService.WriteErrorLog(ex.Message); } } pageModel.PagedData = list; jsonModel.Data = pageModel; } return(jsonModel); }
/// <summary> /// 为返回的数据添加用户姓名列 /// </summary> /// <param name="jsonModel">数据</param> /// <param name="type">type 0获取所有学生(默认);1获取所有教师;2 根据UniqueNo获取用户;3 根据UniqueNo获取学生;4 获取所有用户信息</param> /// <param name="ispage">数据是否是分页的</param> /// <param name="oneUserField">第一个需要返回用户姓名的列</param> /// <param name="uniqueNos">uniqueNos字符串,以逗号分隔,默认为空</param> /// <param name="twoUserField">第二个需要返回用户姓名的列</param> /// <param name="name">根据名称搜索</param> /// <param name="AcademicId">默认0 当前学期; 历史学期 传学期id</param> /// <returns></returns> public JsonModel AddCreateNameForData(JsonModel jsonModel, int type = 0, bool ispage = false, string oneUserField = "CreateUID", string uniqueNos = "", string twoUserField = "", string name = "", string AcademicId = "0") { if (jsonModel.errNum == 0) { List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); List <Dictionary <string, object> > classList = new List <Dictionary <string, object> >(); PagedDataModel <Dictionary <string, object> > pageModel = null; if (ispage) { pageModel = jsonModel.retData as PagedDataModel <Dictionary <string, object> >; list = pageModel.PagedData as List <Dictionary <string, object> >; } else { list = jsonModel.retData as List <Dictionary <string, object> >; } List <Dictionary <string, object> > allList = new List <Dictionary <string, object> >(); allList = GetUnifiedUserData(type, uniqueNos, name, AcademicId); if (!string.IsNullOrEmpty(name)) { List <string> stuUniqueNo = (from dic in allList select dic["UniqueNo"].ToString()).ToList(); list = (from dic in list where stuUniqueNo.Contains(dic[oneUserField].ToString()) select dic).ToList(); } foreach (Dictionary <string, object> item in list) { try { Dictionary <string, object> dicItem = (from dic in allList where dic["UniqueNo"].ToString() == item[oneUserField].ToString() select dic).FirstOrDefault(); item.Add("CreateName", dicItem == null?"":dicItem["Name"].ToString()); item.Add("AbsHeadPic", dicItem == null ? "" : dicItem["AbsHeadPic"].ToString()); item.Add("Sex", dicItem == null ? "" : dicItem["Sex"].ToString()); if (dicItem != null && dicItem.ContainsKey("OrgName")) { item.Add("OrgName", dicItem["OrgName"].ToString()); } if (dicItem != null && dicItem.ContainsKey("GradeName")) { item.Add("GradeName", dicItem["GradeName"].ToString()); } if (!string.IsNullOrEmpty(twoUserField)) { Dictionary <string, object> dicItem_two = (from dic in allList where dic["UniqueNo"].ToString() == item[twoUserField].ToString() select dic).FirstOrDefault(); item.Add("TwoUserName", dicItem_two == null?"": dicItem_two["Name"].ToString()); item.Add("TwoAbsHeadPic", dicItem_two == null ? "" : dicItem_two["AbsHeadPic"].ToString()); } } catch (Exception ex) { LogService.WriteErrorLog(ex.Message); } } if (ispage) { pageModel.PagedData = list; jsonModel.retData = pageModel; } else { jsonModel.retData = list; } } return(jsonModel); }