public ActionResult Query(DataAcquisitionDataQueryViewModel model)
{
MethodReturnResult result = new MethodReturnResult();
DataAcquisitionDataGetParameter p = new DataAcquisitionDataGetParameter();
try
{
#region 取得数据
DataTable dt = new DataTable(); //采集结果集
PagingConfig cfg = new PagingConfig()
{
OrderBy = "",
Where = ""
};
using (DataAcquisitionDataServiceClient client = new DataAcquisitionDataServiceClient())
{
//初始化参数
p.StartDate = model.StartDate; //开始日期
p.EndDate = model.EndDate; //结束日期
p.ItemCode = model.ItemCode; //项目代码
p.LocationName = model.LocationName; //车间
p.LineCode = model.LineCode; //线别
p.EquipmentCode = model.EquipmentCode; //设备代码
p.PageSize = model.PageSize;
p.PageNo = model.PageNo;
MethodReturnResult <DataSet> rst = client.GetData(ref p);
if (rst.Code > 0) //产生错误
{
result.Code = rst.Code;
result.Message = rst.Message;
result.Detail = rst.Detail;
return(Json(result));
}
else
{
ViewBag.FieldData = rst.Data.Tables[0]; //采集字段数据
cfg.Records = p.Records; //总记录数
//根据报表格式及数据清单组合数据列表
result = CreateTableList(rst, ref dt);
if (result.Code > 0) //产生错误
{
return(Json(result));
}
}
}
#endregion
//回传参数
//创建Where条件
cfg.Where = "?ItemCode=" + model.ItemCode + ";" +
"StartDate=" + model.StartDate + ";" +
"EndDate=" + model.EndDate + ";" +
"LineCode=" + model.LineCode + ";" +
"EquipmentCode=" + model.EquipmentCode;
ViewBag.PagingConfig = cfg;
ViewBag.ListData = dt;
if (Request.IsAjaxRequest())
{
return(PartialView("_ListPartial", model));
}
else
{
return(View(model));
}
}
catch (Exception e)
{
result.Code = 1002;
result.Message = e.Message;
result.Detail = e.ToString();
}
return(Json(result));
}
/// <summary>
/// 初始化采集信息主界面
/// </summary>
/// <param name="itemCode">项目代码</param>
/// <returns></returns>
public async Task <ActionResult> Index(string itemCode)
{
MethodReturnResult result = new MethodReturnResult();
DataAcquisitionDataQueryViewModel model = new DataAcquisitionDataQueryViewModel()
{
StartDate = System.DateTime.Now.ToString("yyyy-MM-dd 00:00:00"),
EndDate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
EDCTime = System.DateTime.Now,
PageSize = 20,
PageNo = 1
};
try
{
//取得项目信息
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
await Task.Run(() =>
{
MethodReturnResult <DataAcquisitionItem> resultItem = client.Get(itemCode);
if (result.Code == 0)
{
ViewBag.DataAcquisitionItem = resultItem.Data;
model.RouteOperationName = resultItem.Data.RouteStepName;
model.ItemCode = itemCode;
}
});
}
//取得字段列表
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
await Task.Run(() =>
{
string where = string.Format("Key.ItemCode = '{0}'", itemCode);
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
OrderBy = "Key.ItemCode,SerialNumber",
Where = where
};
MethodReturnResult <IList <DataAcquisitionField> > resultField = client.Get(ref cfg);
if (resultField.Code == 0)
{
ViewBag.DataAcquisitionFieldList = resultField.Data;
}
});
}
if (Request.IsAjaxRequest())
{
return(PartialView("_ListPartial", model));
}
return(View(model));
}
catch (Exception e)
{
result.Code = 1002;
result.Message = e.Message;
result.Detail = e.ToString();
return(Json(result));
}
}
