D_Sample dSample = new D_Sample(); //样品管理
/// <summary>
/// 实验统计列表
/// </summary>
public ActionResult ExpeStatisticsList(E_ExpeStatisticsSearchParameter eSearchParameter)
{
//页面查询项数据
ViewBag.AreaList = new D_tb_Area().GetList(); //检验单位
ViewBag.ClientManageList = new D_tb_ClientManage().GetList(); //送/抽检单位
ViewBag.detectionAdressList = dSample.GetDetectionAdressList(); //抽检单位
ViewBag.ePageParameter = eSearchParameter; //反选查询项
//获取数据列表
DataTable dt = new DataTable();
int total = 0;
string strWhere = this.GetListByReportStrWhere(eSearchParameter);
int startindex = (eSearchParameter.page - 1) * eSearchParameter.pageSize + 1;
int endindex = eSearchParameter.page * eSearchParameter.pageSize;
dt = tDetectProject.GetListByReport(strWhere, "", startindex, endindex, ref total).Tables[0];
ViewBag.ReportListDt = dt;
ViewBag.page = Utils.ShowPage(total, eSearchParameter.pageSize, eSearchParameter.page, 10);
//本页合计
ViewBag.SumQualifiedLevel = dt.Compute("sum(QualifiedLevel)", "");
ViewBag.SumQualifiedLevelA = dt.Compute("sum(QualifiedLevelA)", "");
ViewBag.SumQualifiedLevelB = dt.Compute("sum(QualifiedLevelB)", "");
ViewBag.SumQualifiedLevelC = dt.Compute("sum(QualifiedLevelC)", "");
//总查询合计
DataRow row = dDetectProject.GetAllListCountForReport(strWhere.ToString());
ViewBag.TotalQualifiedLevel = row["QualifiedLevel"].ToString() == "" ? "0" : row["QualifiedLevel"].ToString();
ViewBag.TotalQualifiedLevelA = row["QualifiedLevelA"].ToString() == "" ? "0" : row["QualifiedLevelA"].ToString();
ViewBag.TotalQualifiedLevelB = row["QualifiedLevelB"].ToString() == "" ? "0" : row["QualifiedLevelB"].ToString();
ViewBag.TotalQualifiedLevelC = row["QualifiedLevelC"].ToString() == "" ? "0" : row["QualifiedLevelC"].ToString();
//列表统计
string[] echarts_samplename = new string[dt.Rows.Count];
int[] echarts_QualifiedLevelA = new int[dt.Rows.Count];
int[] echarts_QualifiedLevelB = new int[dt.Rows.Count];
int[] echarts_QualifiedLevelC = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
echarts_samplename[i] = dt.Rows[i]["name"].ToString();
echarts_QualifiedLevelA[i] = int.Parse(dt.Rows[i]["QualifiedLevelA"].ToString());
echarts_QualifiedLevelB[i] = int.Parse(dt.Rows[i]["QualifiedLevelB"].ToString());
echarts_QualifiedLevelC[i] = int.Parse(dt.Rows[i]["QualifiedLevelC"].ToString());
}
ViewBag.Echarts_SampleListJson = JsonConvert.SerializeObject(new {
samplename = echarts_samplename,
QualifiedLevelA = echarts_QualifiedLevelA,
QualifiedLevelB = echarts_QualifiedLevelB,
QualifiedLevelC = echarts_QualifiedLevelC
});
return(View());
}
/// <summary>
/// 时间统计-导出
/// </summary>
public FileResult ExportReport(E_ExpeStatisticsSearchParameter eSearchParameter)
{
//拼接查询条件
string strWhere = this.GetListByReportStrWhere(eSearchParameter);
DataTable dt = new DataTable();
dt = tDetectProject.GetExportListByReport(strWhere, "").Tables[0];
MemoryStream stream = new MemoryStream();
stream = PublicClass.ExportReportToExcel(dt);
string filename = "实验统计列表" + DateTime.Now.ToFileTime() + ".xls";
return(File(stream, "application/vnd.ms-excel", filename));
}
/// <summary>
/// 获取查询条件
/// </summary>
public string GetListByReportStrWhere(E_ExpeStatisticsSearchParameter eSearchParameter)
{
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(eSearchParameter.GHS)) //检验单位
{
strWhere.AddWhere("GHS like '" + eSearchParameter.GHS + "'");
}
if (!string.IsNullOrEmpty(eSearchParameter.Department)) //抽送检单位
{
strWhere.AddWhere("Department like '" + eSearchParameter.Department + "'");
}
if (!string.IsNullOrEmpty(eSearchParameter.DetectionAdress))//抽样地址
{
strWhere.AddWhere("DetectionAdress='" + eSearchParameter.DetectionAdress + "'");
}
if (!string.IsNullOrEmpty(eSearchParameter.samplenum))//样品名称
{
strWhere.AddWhere("name like '%" + eSearchParameter.samplenum + "%'");
}
if (!string.IsNullOrEmpty(eSearchParameter.projectname))//检验项目
{
strWhere.AddWhere("ProjectName like '%" + eSearchParameter.projectname + "%'");
}
if (!string.IsNullOrEmpty(eSearchParameter.testpersonnelname))//检验人
{
strWhere.AddWhere("TestPersonnelName like '%" + eSearchParameter.testpersonnelname + "%'");
}
if (!string.IsNullOrEmpty(eSearchParameter.txt_StartTime)) //检验开始日期
{
strWhere.AddWhere("DetectTime >= '" + eSearchParameter.txt_StartTime + "'");
}
if (!string.IsNullOrEmpty(eSearchParameter.txt_EndTime)) //检验结束日期
{
strWhere.AddWhere("DetectTime <= '" + eSearchParameter.txt_EndTime + "'");
}
return(strWhere.ToString());
}