/// <summary> /// 获取所有数据列表 /// 作者:小朱 /// </summary> /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns> public DataTable GetList(E_PageParameter ePageParameter) { StringBuilder strWhere = new StringBuilder(); if (ePageParameter.planid > 0) { strWhere.AddWhere("T.PlanID=" + ePageParameter.planid + " "); } if (ePageParameter.areaid > 0)//区域 { strWhere.AddWhere("T.AreaID=" + ePageParameter.areaid + " "); } if (ePageParameter.plantype > -1)//计划类别 { strWhere.AddWhere("T.PlanTypeID=" + ePageParameter.plantype + " "); } if (ePageParameter.starttime != null)//检验开始时间 { strWhere.AddWhere("InspectTime>=cast('" + ePageParameter.starttime.ToString() + "' as datetime) "); } if (ePageParameter.endtime != null)//送检结束时间 { strWhere.AddWhere("InspectTime<=cast('" + ePageParameter.endtime.ToString() + "' as datetime) "); } if (!string.IsNullOrEmpty(ePageParameter.taskno))//任务单号 { strWhere.AddWhere("T.TaskNo like '%" + ePageParameter.taskno.Trim() + "%' "); } if (ePageParameter.projectid > 0)//检验项目 { strWhere.AddWhere("T.ProjectID=" + ePageParameter.projectid + " "); } if (!string.IsNullOrEmpty(ePageParameter.samplename))//样品名称 { strWhere.AddWhere("C.name like '%" + ePageParameter.samplename + "%' "); } if (ePageParameter.status > 0)//样品名称 { strWhere.AddWhere("T.Status =" + ePageParameter.status); } if (ePageParameter.headpersonnelid > 0) //实验计划主要负责人 { strWhere.AddWhere("T.headpersonnelid=" + ePageParameter.headpersonnelid); } //添加数据权限判断 switch (CurrentUserInfo.DataRange) { case 2: //区域 strWhere.AddWhere("T.AreaID=" + CurrentUserInfo.AreaID + " "); break; case 3: //个人 strWhere.AddWhere("T.EditPersonnelID=" + CurrentUserInfo.PersonnelID + " "); break; } DataTable dt = new DataTable(); int total = 0; int startindex = ePageParameter.pageindex * ePageParameter.pagesize + 1; int endindex = (ePageParameter.pageindex + 1) * ePageParameter.pagesize; dt = tExpePlan.GetListByPage(strWhere.ToString(), "InspectTime desc", startindex, endindex, ref total).Tables[0]; ePageParameter.count = total; return(dt); }
/// <summary> /// 获取所有数据列表 /// 作者:小朱 /// </summary> /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns> public string GetList(int pageNumber, int pageSize, string AreaID, string PlanTypeID, string InspectTimeStart, string InspectTimeEnd, string TaskNo, string ProjectID, string PlanID, string SampleName, string Status) { DataTable dt = new DataTable(); int total = 0; string strWhere = ""; if (!string.IsNullOrEmpty(PlanID) && PlanID != "0") { strWhere = PageTools.AddWhere(strWhere, "T.PlanID=" + PlanID + " "); } if (!string.IsNullOrEmpty(AreaID))//区域 { strWhere = PageTools.AddWhere(strWhere, "T.AreaID=" + AreaID + " "); } if (!string.IsNullOrEmpty(PlanTypeID))//计划类别 { strWhere = PageTools.AddWhere(strWhere, "T.PlanTypeID=" + PlanTypeID + " "); } if (!string.IsNullOrEmpty(InspectTimeStart))//检验开始时间 { strWhere = PageTools.AddWhere(strWhere, "InspectTime>=cast('" + InspectTimeStart + "' as datetime) "); } if (!string.IsNullOrEmpty(InspectTimeEnd))//送检结束时间 { strWhere = PageTools.AddWhere(strWhere, "InspectTime<=cast('" + InspectTimeEnd + "' as datetime) "); } if (!string.IsNullOrEmpty(TaskNo))//任务单号 { strWhere = PageTools.AddWhere(strWhere, "T.TaskNo like '%" + TaskNo.Trim() + "%' "); } if (!string.IsNullOrEmpty(ProjectID))//检验项目 { strWhere = PageTools.AddWhere(strWhere, "T.ProjectID=" + ProjectID + " "); } if (!string.IsNullOrEmpty(SampleName))//样品名称 { strWhere = PageTools.AddWhere(strWhere, "C.name like '%" + SampleName + "%' "); } if (!string.IsNullOrEmpty(Status))//样品名称 { strWhere = PageTools.AddWhere(strWhere, "T.Status =" + Status); } //添加数据权限判断 switch (CurrentUserInfo.DataRange) { case 2: //区域 strWhere = PageTools.AddWhere(strWhere, "T.AreaID=" + CurrentUserInfo.AreaID + " "); break; case 3: //个人 strWhere = PageTools.AddWhere(strWhere, "T.EditPersonnelID=" + CurrentUserInfo.PersonnelID + " "); break; } try { dt = tExpePlan.GetListByPage(strWhere, "", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize, ref total).Tables[0]; } catch { } string strJson = PublicClass.ToJson(dt, total); if (strJson.Trim() == "") { strJson = "{\"total\":0,\"rows\":[]}"; } return(strJson); }