public ActionResult GetList(E_PageParameter ePageParameter) { int pageIndex = Utils.GetInt(Request["page"]); ePageParameter.pageindex = pageIndex > 0 ? pageIndex - 1 : pageIndex; ePageParameter.pagesize = 20; List <tb_Sample> list = new List <tb_Sample>(); int count = 0; switch (CurrentUserInfo.DataRange) { case 3: //个人 ePageParameter.areaid = -1; ePageParameter.createuser = CurrentUserInfo.PersonnelID; break; case 2: //区域 ePageParameter.areaid = (int)CurrentUserInfo.AreaID; break; } list = _dSample.GetSampleList(ePageParameter, ref count); ViewBag.SampleList = list; ViewBag.arealist = _tArea.GetModelList((CurrentUserInfo.DataRange > 1 ? $"AreaID={CurrentUserInfo.AreaID}" : "")); ViewBag.ePageParameter = ePageParameter; ViewBag.page = Utils.ShowPage(count, ePageParameter.pagesize, pageIndex, 5); return(View("/views/Sample/SampleList.cshtml")); }
D_tb_InPersonnel dInPersonnel = new D_tb_InPersonnel();//人员管理 // // GET: /DetectProject/ public ActionResult ExpePlanList(E_PageParameter ePageParameter) { int pageIndex = Utils.GetInt(Request["page"]); ePageParameter.pageindex = pageIndex > 0 ? pageIndex - 1 : pageIndex; ePageParameter.pagesize = 20; ViewBag.ExpePlanList = this.GetList(ePageParameter); ViewBag.PersonnelList = dInPersonnel.GetList(new E_tb_InPersonnel() { }); ViewBag.ePageParameter = ePageParameter; ViewBag.page = Utils.ShowPage(ePageParameter.count, ePageParameter.pagesize, pageIndex, 5); ViewData["PlanTypeList"] = this.GetPlanTypeList(true); ViewData["ProjectList"] = PageTools.GetSelectList(tProject.GetList("").Tables[0], "ProjectID", "ProjectName", true); ViewData["AreaList"] = PageTools.GetSelectList(tArea.GetList("").Tables[0], "AreaID", "AreaName", true); return(View("/views/ExpePlan/ExpePlanList.cshtml")); //if (Request["ApprovalPersonnelName"] != null) // ViewData["ApprovalPersonnelName"] = Request["ApprovalPersonnelName"].ToString(); //else // ViewData["ApprovalPersonnelName"] = ""; //ViewBag._userName = CurrentUserInfo.UserName; //eExpePlan.AreaID = CurrentUserInfo.AreaID; //ViewBag.IsDisabled = (CurrentUserInfo.RoleID != 1) ? "true" : "false"; //权限判断 }
/// <summary> /// 获取查询条件 /// </summary> /// <param name="ePageParameter">查询参数实体</param> /// <returns>查询条件</returns> private string GetStrWhere(E_PageParameter ePageParameter) { //拼接查询条件 StringBuilder strwhere = new StringBuilder(); if (ePageParameter.areaid > 0) //单位 { strwhere.AddWhere($"A.AreaID={ePageParameter.areaid}"); } if (!string.IsNullOrEmpty(ePageParameter.samplename)) //样品名称 { strwhere.AddWhere($"A.name like '%{ePageParameter.samplename}%'"); } if (!string.IsNullOrEmpty(ePageParameter.detectionuser)) //抽样人 { strwhere.AddWhere($"A.detectionUser like '%{ePageParameter.detectionuser}%'"); } if (ePageParameter.createuser > 0) //创建人 { strwhere.AddWhere($"A.createUser={ePageParameter.createuser}"); } if (ePageParameter.starttime != null) //抽样时间 { strwhere.AddWhere($"A.detectionDate>=cast('{Convert.ToDateTime(ePageParameter.starttime).ToString("yyyy-MM-dd")}' as datetime)"); } if (ePageParameter.endtime != null) { strwhere.AddWhere($"A.detectionDate<=cast('{Convert.ToDateTime(ePageParameter.endtime).ToString("yyyy-MM-dd")}' as datetime)"); } return(strwhere.ToString()); }
public JsonResult GetTreeNodeList(E_PageParameter ePageParameter) { DbObject db = new DbObject(ePageParameter.connstring); List <E_TreeNode> NodeList = new List <E_TreeNode>(); var tables = db.GetTableViews(ePageParameter.dbname); foreach (var item in tables) { E_TreeNode nodetable = new E_TreeNode(); nodetable.id = 0; nodetable.name = item; nodetable.nodetype = 1; List <ColumnInfo> ColumnList = db.GetColumnInfoList(ePageParameter.dbname, item); List <E_TreeNode> columnnodelist = new List <E_TreeNode>(); foreach (var columnitem in ColumnList) { E_TreeNode nodecolumn = new E_TreeNode(); nodecolumn.id = 0; nodecolumn.name = columnitem.ColumnName + "(" + columnitem.TypeName + ")" + columnitem.Description; nodecolumn.children = null; nodecolumn.nodetype = 2; columnnodelist.Add(nodecolumn); } nodetable.children = columnnodelist; NodeList.Add(nodetable); } return(Json(NodeList, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 生成对象操作 /// </summary> public ActionResult BuilderDAL(E_PageParameter ePageParameter) { BuilderDALCode builderDAL = new BuilderDALCode(); DbObject db = new DbObject(ePageParameter.connstring); E_DALCode eDalCode = new E_DALCode(); string tname = ePageParameter.tablename.Replace(ePageParameter.prefix, ""); List <ColumnInfo> list = db.GetColumnInfoList(ePageParameter.dbname, ePageParameter.tablename); eDalCode.Fieldlist = list; eDalCode.TableName = ePageParameter.tablename; eDalCode.ModelName = "E_" + tname.Substring(0, 1).ToUpper() + tname.Substring(1, tname.Length - 1); eDalCode.Modelpath = "Model"; eDalCode.DbObject = db; eDalCode.Keys = list.Where(a => a.IsPrimaryKey).ToList(); eDalCode.DALpath = "DAL"; eDalCode.DALName = "D_" + tname.Substring(0, 1).ToUpper() + tname.Substring(1, tname.Length - 1); DataRow tableDescRow = db.GetTablesExProperty(ePageParameter.dbname).Select("objname='" + ePageParameter.tablename + "'").FirstOrDefault(); if (tableDescRow != null) { eDalCode.TableDescription = tableDescRow["value"]?.ToString(); } builderDAL.eDALCode = eDalCode; string modelStr = builderDAL.CreatDAL(); ViewBag.CodeHtml = modelStr; return(PartialView("~/Views/Code/BuilderDAL.cshtml")); }
/// <summary> /// 获取所有数据列表 /// 作者:小朱 /// </summary> /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns> public DataTable GetList(E_PageParameter ePageParameter) { DataTable dt = new DataTable(); int total = 0; string strWhere = GetWhere(ePageParameter); //dt = tTestReport.GetListByPage(strWhere, "UpdateTime DESC,T.SampleName ASC", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize, ref total).Tables[0]; int startindex = ePageParameter.pageindex * ePageParameter.pagesize + 1; int endindex = (ePageParameter.pageindex + 1) * ePageParameter.pagesize; dt = tTestReport.GetListByPage(strWhere, "TestTime DESC", startindex, endindex, ref total).Tables[0]; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string ApprovalPersonnelName = dt.Rows[i]["ApprovalPersonnelName"].ToString(); string RecordIDS = dt.Rows[i]["RecordIDS"].ToString(); StringBuilder strRecordIDS = new StringBuilder(); if (!string.IsNullOrEmpty(RecordIDS)) { string[] ArrRecordIDS = RecordIDS.Split(','); foreach (string item in ArrRecordIDS) { if (!string.IsNullOrEmpty(item)) { strRecordIDS.Append(string.Format("<a href='/OriginalRecord/OriginalRecordList?RecordID={0}&ApprovalPersonnelName={1}' style='color:Blue; font-weight:bold;'>{0}</a>,", item, ApprovalPersonnelName)); } } } dt.Rows[i]["RecordIDS"] = strRecordIDS.ToString().TrimEnd(','); string TaskNoS = dt.Rows[i]["TaskNoS"].ToString(); StringBuilder strTaskNoS = new StringBuilder(); if (!string.IsNullOrEmpty(TaskNoS)) { string[] ArrTaskNoS = TaskNoS.Split(','); foreach (string item in ArrTaskNoS) { if (!string.IsNullOrEmpty(item)) { strTaskNoS.Append(string.Format("<a href='/ExpePlan/ExpePlanList?PlanID={0}&ApprovalPersonnelName={1}' style='color:Blue; font-weight:bold;'>{0}</a>,", item, ApprovalPersonnelName)); } } } dt.Rows[i]["TaskNoS"] = strTaskNoS.ToString().TrimEnd(','); } } ePageParameter.count = total; return(dt); //string strJson = PublicClass.ToJson(dt, total); //if (strJson.Trim() == "") //{ // strJson = "{\"total\":0,\"rows\":[]}"; //} //return strJson; }
public FileResult ExportSample(E_PageParameter ePageParameter) { List <tb_Sample> list = _dSample.GetSampleList(ePageParameter); string filename = "样品列表" + DateTime.Now.ToFileTime() + ".xls"; string path = Server.MapPath("/upfile/sample/" + filename); NPOITools.RenderToExcel <tb_Sample>(list, path); return(File(path, "application/vnd.ms-excel", filename)); }
/// <summary> /// 获取实验考核数据列表 /// </summary> /// <param name="ePageParameter">页面参数实体</param> /// <returns></returns> public List <E_ExperimentCheck> GetExperimentCheckList(E_PageParameter ePageParameter, ref int count) { List <E_ExperimentCheck> list = new List <E_ExperimentCheck>(); //拼接查询条件 StringBuilder strwhere = new StringBuilder(); strwhere.AddWhere("PlanID is not null"); //排除无实验计划的记录 if (ePageParameter.starttime != null) { strwhere.AddWhere($"detectionDate>=cast('{Convert.ToDateTime(ePageParameter.starttime).ToString("yyyy-MM-dd")}' as datetime)"); } if (ePageParameter.endtime != null) { strwhere.AddWhere($"detectionDate<=cast('{Convert.ToDateTime(ePageParameter.endtime).ToString("yyyy-MM-dd")}' as datetime)"); } //主查询Sql StringBuilder search = new StringBuilder(); search.AppendFormat(@"select row_number()over(order by detectionDate desc) as rowid, A.id as sampleid,A.name as samplename,A.detectionDate,A.urgentlevel,C.ProjectID,C.ProjectName ,D.DetectTime,D.DetectPersonnelID,E.PersonnelName as detectpersonnelname from tb_Sample as A left join tb_ExpePlan as B on A.id=B.SampleID left join tb_Project as C on B.ProjectID=C.ProjectID left join tb_OriginalRecord as D on B.TaskNo=D.TaskNo left join tb_InPersonnel as E on D.DetectPersonnelID=E.PersonnelID {0}" , strwhere.ToString()); //当前页数据Sql StringBuilder currdata = new StringBuilder(); currdata.AppendFormat(@"select * from ( {0} ) as t where t.rowid between @pageindex*@pagesize+1 and (@pageindex+1)*@pagesize ", search.ToString()); //当前条件下的数据总量 StringBuilder totalcount = new StringBuilder(); totalcount.AppendFormat(@"select count(1) from ( {0} ) as t ", search.ToString()); //执行查询语句 using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString())) { list = conn.Query <E_ExperimentCheck>(currdata.ToString(), ePageParameter)?.ToList(); count = (int)conn.ExecuteScalar(totalcount.ToString(), ePageParameter); } return(list); }
public ActionResult SamplingSheet(E_PageParameter ePageParameter) { List <E_SamplingSheet> list = new List <E_SamplingSheet>(); list = _dSample.GetSamplingSheetList(ePageParameter); ViewBag.SamplingSheetList = list; ViewBag.sampleids = ePageParameter.sampleids; return(View("/views/sample/SamplingSheet.cshtml")); }
public FileResult ExportSamplingSheet(E_PageParameter ePageParameter) { List <E_SamplingSheet> list = _dSample.GetSamplingSheetList(ePageParameter); string filename = "分样单" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".doc"; string filetemplatepath = Server.MapPath("/upfile/template/分样单模板.docx"); string path = Server.MapPath("/upfile/samplingsheet/" + filename); NPOITools.RenderToWord <E_SamplingSheet>(list, filetemplatepath, path); return(File(path, "application/vnd.ms-word", filename)); }
/// <summary> /// 获取所有数据列表 /// </summary> /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns> public DataTable GetList(E_PageParameter ePageParameter) { int total = 0; StringBuilder strWhere = new StringBuilder(); if (ePageParameter.recordid > 0) { strWhere.AddWhere("T.RecordID=" + ePageParameter.recordid); } if (ePageParameter.areaid > 0) { strWhere.AddWhere("T.AreaID=" + ePageParameter.areaid); } if (ePageParameter.projectid > 0) { strWhere.AddWhere("T.ProjectID=" + ePageParameter.projectid); } if (ePageParameter.starttime != null) { strWhere.AddWhere("T.DetectTime>=cast('" + ePageParameter.starttime + "' as datetime)"); } if (ePageParameter.endtime != null) { strWhere.AddWhere("T.DetectTime<=cast('" + ePageParameter.endtime + "' as datetime)"); } if (!string.IsNullOrEmpty(ePageParameter.taskno)) { strWhere.AddWhere("T.TaskNo like '%" + ePageParameter.taskno + "%'"); } //添加数据权限判断 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 startindex = ePageParameter.pageindex * ePageParameter.pagesize + 1; int endindex = (ePageParameter.pageindex + 1) * ePageParameter.pagesize; dt = _dOriginalRecord.GetListByPage(strWhere.ToString(), "", startindex, endindex, ref total).Tables[0]; ePageParameter.count = total; return(dt); }
T_tb_TestReportData tTestReportData = new T_tb_TestReportData(); //检验报告数据 // // GET: /Laboratory/ public ActionResult OriginalRecordList(E_PageParameter ePageParameter) { int pageIndex = Utils.GetInt(Request["page"]); ePageParameter.pageindex = pageIndex > 0 ? pageIndex - 1 : pageIndex; ePageParameter.pagesize = 20; ViewData["AreaList"] = PageTools.GetSelectList(tArea.GetList("").Tables[0], "AreaID", "AreaName", true); ViewData["ProjectList"] = PageTools.GetSelectList(tProject.GetList("").Tables[0], "ProjectID", "ProjectName", true); ViewBag.OriginalRecordList = this.GetList(ePageParameter); ViewBag.ePageParameter = ePageParameter; ViewBag.page = Utils.ShowPage(ePageParameter.count, ePageParameter.pagesize, pageIndex, 5); return(View("/views/OriginalRecord/OriginalRecordList.cshtml")); }
D_Statistics dStatistics = new D_Statistics(); //数据统计 // // GET: /Laboratory/ public ActionResult TestReportList(E_PageParameter ePageParameter) { int pageIndex = Utils.GetInt(Request["page"]); ePageParameter.pageindex = pageIndex > 0 ? pageIndex - 1 : pageIndex; ePageParameter.pagesize = 20; ViewBag.arealist = tArea.GetModelList((CurrentUserInfo.DataRange > 1 ? $"AreaID={CurrentUserInfo.AreaID}" : "")); ViewBag.TestReportList = this.GetList(ePageParameter); ViewBag.ePageParameter = ePageParameter; ViewBag.page = Utils.ShowPage(ePageParameter.count, ePageParameter.pagesize, pageIndex, 5); ViewBag.NoFinishExpePlanCount = dStatistics.GetNoFinishExpePlanCount(CurrentUserInfo.PersonnelID); ViewBag.NoExamineTestReportCount = dStatistics.GetNoExamineTestReportCount(); ViewBag.NoApprovalTestReportCount = dStatistics.GetNoApprovalTestReportCount(); return(View("/views/TestReport/TestReportList.cshtml")); }
public ActionResult ExperimentCheck(E_PageParameter ePageParameter) { int pageIndex = Utils.GetInt(Request["page"]); ePageParameter.pageindex = pageIndex > 0 ? pageIndex - 1 : pageIndex; ePageParameter.pagesize = 20; D_ExperimentCheck dExperimentCheck = new D_ExperimentCheck(); List <E_ExperimentCheck> list = new List <E_ExperimentCheck>(); int count = 0; if (ePageParameter.issearch > 0) { list = dExperimentCheck.GetExperimentCheckList(ePageParameter, ref count); } ViewBag.ExperimentCheckList = list; ViewBag.ePageParameter = ePageParameter; ViewBag.page = Utils.ShowPage(count, ePageParameter.pagesize, pageIndex, 5); return(View("/views/labmanage/experimentcheck.cshtml")); }
/// <summary> /// 生成对象实体 /// </summary> public ActionResult BuilderModel(E_PageParameter ePageParameter) { DbObject db = new DbObject(ePageParameter.connstring); BuilderModelCode builderModel = new BuilderModelCode(); E_ModelCode eModelCode = new E_ModelCode(); eModelCode.Fieldlist = db.GetColumnInfoList(ePageParameter.dbname, ePageParameter.tablename); eModelCode.ModelName = ePageParameter.tablename.Replace(ePageParameter.prefix, ""); eModelCode.BaseClass = "E_BaseModel"; DataRow tableDescRow = db.GetTablesExProperty(ePageParameter.dbname).Select("objname='" + ePageParameter.tablename + "'").FirstOrDefault(); if (tableDescRow != null) { eModelCode.TableDescription = tableDescRow["value"]?.ToString(); } builderModel.eModelCode = eModelCode; string modelStr = builderModel.CreatModel(); ViewBag.CodeHtml = modelStr; return(PartialView("~/Views/Code/BuilderModel.cshtml")); }
/// <summary> /// 获取实验考核数据列表 /// </summary> /// <param name="ePageParameter">页面参数实体</param> /// <returns></returns> public List <tb_Sample> GetSampleList(E_PageParameter ePageParameter, ref int count) { List <Model.tb_Sample> list = new List <Model.tb_Sample>(); //主查询Sql StringBuilder search = new StringBuilder(); search.AppendFormat(@"select row_number()over(order by A.createDate desc) as rowid, A.*, B.PersonnelName as handleusername, C.ClientName as inspectcompanyname from tb_Sample as A left join tb_InPersonnel as B on A.handleUser=B.PersonnelID left join tb_ClientManage as C on A.InspectCompany=C.ClientID {0} ", GetStrWhere(ePageParameter)); //当前页数据Sql StringBuilder currdata = new StringBuilder(); currdata.AppendFormat(@"select * from ( {0} ) as t where t.rowid between @pageindex*@pagesize+1 and (@pageindex+1)*@pagesize ", search.ToString()); //当前条件下的数据总量 StringBuilder totalcount = new StringBuilder(); totalcount.AppendFormat(@"select count(1) from ( {0} ) as t ", search.ToString()); //执行查询语句 using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString())) { list = conn.Query <Model.tb_Sample>(currdata.ToString(), ePageParameter)?.ToList(); count = (int)conn.ExecuteScalar(totalcount.ToString(), ePageParameter); } return(list); }
/// <summary> /// 获取样品列表,不带分页 /// </summary> /// <param name="ePageParameter">查询参数实体</param> /// <returns>返回对应数据集合</returns> public List <tb_Sample> GetSampleList(E_PageParameter ePageParameter) { List <tb_Sample> list = new List <tb_Sample>(); //主查询Sql StringBuilder search = new StringBuilder(); search.AppendFormat(@"select row_number()over(order by A.createDate desc) as rowid, A.*, B.PersonnelName as handleusername, C.ClientName as inspectcompanyname from tb_Sample as A left join tb_InPersonnel as B on A.handleUser=B.PersonnelID left join tb_ClientManage as C on A.InspectCompany=C.ClientID {0} ", GetStrWhere(ePageParameter)); //执行查询语句 using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString())) { list = conn.Query <Model.tb_Sample>(search.ToString(), ePageParameter)?.ToList(); } return(list); }
/// <summary> /// 获取分样单数据 /// </summary> /// <param name="ePageParameter">查询参数实体</param> /// <returns>返回分样单数据</returns> public List <E_SamplingSheet> GetSamplingSheetList(E_PageParameter ePageParameter) { List <E_SamplingSheet> list = new List <E_SamplingSheet>(); //主查询Sql StringBuilder search = new StringBuilder(); search.AppendFormat(@"select A.samplenum,A.name as samplename, (C.ProjectName+'--'+B.InspectMethod) as checkprojectandstandard, A.storcondition,A.checkdepar, case when A.urgentlevel=1 then '普通' else '紧急' end asurgentlevel from dbo.tb_Sample as A left join dbo.tb_ExpePlan AS B on A.id=B.SampleID left join dbo.tb_Project as C on B.ProjectID=C.ProjectID where A.id in ({0})", ePageParameter.sampleids); //执行查询语句 using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString())) { list = conn.Query <E_SamplingSheet>(search.ToString(), ePageParameter)?.ToList(); } return(list); }
/// <summary> /// 生成对象控制器 /// </summary> public ActionResult BuilderControllers(E_PageParameter ePageParameter) { BuilderControllersCode builderControllers = new BuilderControllersCode(); DbObject db = new DbObject(ePageParameter.connstring); E_ControllersCode eControllersCode = new E_ControllersCode(); string tname = ePageParameter.tablename.Replace(ePageParameter.prefix, ""); List <ColumnInfo> list = db.GetColumnInfoList(ePageParameter.dbname, ePageParameter.tablename); eControllersCode.primarykeyname = list.Where(a => a.IsPrimaryKey).ToList().First().ColumnName; eControllersCode.modelname = "E_" + tname.Substring(0, 1).ToUpper() + tname.Substring(1, tname.Length - 1); eControllersCode.tablename = tname.Substring(0, 1).ToUpper() + tname.Substring(1, tname.Length - 1); DataRow tableDescRow = db.GetTablesExProperty(ePageParameter.dbname).Select("objname='" + ePageParameter.tablename + "'").FirstOrDefault(); if (tableDescRow != null) { eControllersCode.tabledescription = tableDescRow["value"]?.ToString(); } builderControllers.eControllersCode = eControllersCode; string modelStr = builderControllers.CreatControllers(); ViewBag.CodeHtml = modelStr; return(PartialView("~/Views/Code/BuilderControllers.cshtml")); }
/// <summary> /// 生成对象编辑页 /// </summary> public ActionResult BuilderPageEdit(E_PageParameter ePageParameter) { return(PartialView("~/Views/Code/BuilderPageEdit.cshtml")); }
/// <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> public string GetWhere(E_PageParameter ePageParameter) { string strWhere = ""; if (ePageParameter.reportid > 0) { strWhere = PageTools.AddWhere(strWhere, "T.ReportID=" + ePageParameter.reportid); } if (ePageParameter.areaid > 0) { strWhere = PageTools.AddWhere(strWhere, "T.AreaID=" + ePageParameter.areaid); } if (ePageParameter.issuedtimestart != null) { strWhere = PageTools.AddWhere(strWhere, "T.IssuedTime>=cast('" + ePageParameter.issuedtimestart.ToString() + "' as datetime)"); } if (ePageParameter.issuedtimeend != null) { strWhere = PageTools.AddWhere(strWhere, "T.IssuedTime<=cast('" + ePageParameter.issuedtimeend.ToString() + "' as datetime)"); } if (!string.IsNullOrEmpty(ePageParameter.samplenum)) { strWhere = PageTools.AddWhere(strWhere, "T.SampleNum like '%" + ePageParameter.samplenum + "%'"); } if (!string.IsNullOrEmpty(ePageParameter.samplename)) { strWhere = PageTools.AddWhere(strWhere, "T.SampleName like '%" + ePageParameter.samplename + "%'"); } if (!string.IsNullOrEmpty(ePageParameter.department)) { strWhere = PageTools.AddWhere(strWhere, "T.Department like '%" + ePageParameter.department + "%'"); } if (!string.IsNullOrEmpty(ePageParameter.maintestpersonne)) { strWhere = PageTools.AddWhere(strWhere, "D.PersonnelName like '%" + ePageParameter.maintestpersonne + "%'"); } if (ePageParameter.samplingtimestart != null) { strWhere = PageTools.AddWhere(strWhere, "SamplingTime>=cast('" + ePageParameter.samplingtimestart.ToString() + "' as datetime)"); } if (ePageParameter.samplingtimeend != null) { strWhere = PageTools.AddWhere(strWhere, "SamplingTime<=cast('" + ePageParameter.samplingtimeend.ToString() + "' as datetime)"); } if (ePageParameter.isexamine == 1) //已审核 { strWhere = PageTools.AddWhere(strWhere, "T.examinePersonnelID>0"); } else if (ePageParameter.isexamine == 2) //未审核 { strWhere = PageTools.AddWhere(strWhere, "(T.examinePersonnelID is null or T.examinePersonnelID=0)"); } if (ePageParameter.isapproval == 1) //已批准 { strWhere = PageTools.AddWhere(strWhere, "T.ApprovalPersonnelID>0"); } else if (ePageParameter.isapproval == 2) //未批准 { strWhere = PageTools.AddWhere(strWhere, "(T.ApprovalPersonnelID is null or T.ApprovalPersonnelID=0)"); } if (ePageParameter.expeplannopass > 0) //是否查询未完成的实验计划 { strWhere = PageTools.AddWhere(strWhere, "(T.ApprovalPersonnelID is null or T.ApprovalPersonnelID=0 or T.examinePersonnelID is null or T.examinePersonnelID=0 or T.MainTestPersonnelID is null or T.MainTestPersonnelID=0)"); } //添加数据权限判断 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; } //保密数据获取,只有设置保密的自己或者指定的审核人能看到对应的保密数据 strWhere = PageTools.AddWhere(strWhere, $"(issecrecy=0 or secrecyexaminepid={CurrentUserInfo.PersonnelID} or setsecrecypid={CurrentUserInfo.PersonnelID})"); return(strWhere); }