/// <summary>
/// 质量分析查询
/// </summary>
/// <param name="page">页号</param>
/// <param name="rows">行数</param>
/// <returns></returns>
public EasyUIData getQualityList(String page, String rows, Plant plant)
{
IDao dao = new Dao(plant, false);
EasyUIData grid = new EasyUIData();
List <RTResExLimsPoint> limsPoint = new List <RTResExLimsPoint>();
String sql = "select count(1) over() allrowCount, LimsPoint_MATCODE,LimsPoint_SAMPLEPOINTDESC,LimsPoint_TESTNO,LimsPoint_ANALYLE,LimsPoint_fValue,LimsPoint_UNITS,Status,LimsPoint_High,LimsPoint_Low,Time from RTResEx_LimsPoint order by status asc , Time desc ";//LimsPoint_PLANT like '%二催化%'
DataSet ds = dao.executeQuery(sql, Int32.Parse(page), Int32.Parse(rows));
if (BeanTools.DataSetIsNotNull(ds))
{
grid.total = BeanTools.DBToInt(ds.Tables[0].Rows[0]["allrowCount"]); //获取总行数
foreach (DataRow dr in ds.Tables[0].Rows)
{
RTResExLimsPoint point = new RTResExLimsPoint();
String value = dr["LimsPoint_fValue"].ToString();
point.limsPointMatCode = (string)dr["LimsPoint_MATCODE"];
point.limsPointSamplePointDesc = dr["LimsPoint_SAMPLEPOINTDESC"].ToString();
point.limsPointTestNo = (string)dr["LimsPoint_TESTNO"];
point.limsPointAnalyle = (string)dr["LimsPoint_ANALYLE"];
if (value.Length > 4)
{
value = value.Substring(0, 4);
}
point.limsPointFValue = value;
point.limsPointUnits = (string)dr["LimsPoint_UNITS"];
point.status = (string)dr["Status"];
point.limsPointHigh = dr["LimsPoint_High"].ToString();
point.limsPointLow = dr["LimsPoint_Low"].ToString();
point.time = BeanTools.DataTimeToString(dr["Time"]);
limsPoint.Add(point);
}
}
grid.rows = limsPoint;
return(grid);
}