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