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