/// <summary>
/// 初始化采集信息主界面
/// </summary>
/// <param name="eDCTime">采集时间</param>
/// <param name="itemCode">采集项目</param>
/// <param name="lineCode">线别</param>
/// <param name="equipmentCode">设备</param>
/// <param name="locationName">车间</param>
/// <returns></returns>
public ActionResult Index(DateTime eDCTime, string itemCode, string lineCode, string equipmentCode, string locationName)
{
MethodReturnResult result = new MethodReturnResult();
try
{
DataAcquisitionTransQueryViewModel model = new DataAcquisitionTransQueryViewModel()
{
EDCTime = eDCTime,
ItemCode = itemCode,
LineCode = lineCode,
EquipmentCode = equipmentCode,
LocationName = locationName,
PageSize = 20,
PageNo = 1
};
//初始化调用数据查询
return(Query(model));
}
catch (Exception e)
{
result.Code = 1002;
result.Message = e.Message;
result.Detail = e.ToString();
return(Json(result));
}
}
/// <summary>
/// 取得采集数据信息
/// </summary>
/// <param name="eDCTime">采集时间</param>
/// <param name="itemCode">项目代码</param>
/// <param name="lineCode">线别</param>
/// <param name="equipmentCode">设备代码</param>
/// <param name="locationName">车间</param>
/// <param name="DataAcquisitionTransQueryViewModel">返回模型数据</param>
/// <returns></returns>
private MethodReturnResult GetDataAcquisitionTrans(DateTime eDCTime, string itemCode, string lineCode, string equipmentCode, string locationName, ref DataAcquisitionTransQueryViewModel model)
{
MethodReturnResult result = new MethodReturnResult();
try
{
string where = "";
//取得项目信息
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
MethodReturnResult <DataAcquisitionItem> resultItem = client.Get(itemCode);
if (result.Code == 0)
{
//采集项目
ViewBag.DataAcquisitionItem = resultItem.Data;
//返回采集项目工序
model.RouteOperationName = resultItem.Data.RouteStepName;
}
}
//取得字段列表
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
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;
}
}
using (DataAcquisitionTransServiceClient client = new DataAcquisitionTransServiceClient())
{
//取得采集数据
where = string.Format("Key.EDCTime = '{0}' AND Key.ItemCode = '{1}' AND Key.LineCode = '{2}' AND Key.EquipmentCode = '{3}' AND Key.LocationName = '{4}'"
, eDCTime
, itemCode
, lineCode
, equipmentCode
, locationName);
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = where
};
MethodReturnResult <IList <DataAcquisitionTrans> > resultdata = client.Get(ref cfg);
if (resultdata.Code > 0)
{
result.Code = resultdata.Code;
result.Message = resultdata.Message;
result.Detail = resultdata.Detail;
return(result);
}
//model.Creator = resultdata.Data[0].Creator; //创建人
//model.CreateTime = resultdata.Data[0].CreateTime; //创建日期
//model.Auditor = resultdata.Data[0].Auditor; //审核人
//model.AuditTime = resultdata.Data[0].AuditTime; //审核日期
ViewBag.DataAcquisitionTransList = resultdata.Data;
}
}
catch (Exception e)
{
result.Code = 1002;
result.Message = e.Message;
result.Detail = e.ToString();
}
return(result);
}
public ActionResult Query(DataAcquisitionTransQueryViewModel model)
{
MethodReturnResult result = new MethodReturnResult();
DataAcquisitionTransGetParameter p = new DataAcquisitionTransGetParameter();
try
{
#region 取得数据
DataTable dt = new DataTable(); //采集结果集
PagingConfig cfg = new PagingConfig()
{
OrderBy = "",
Where = ""
};
using (DataAcquisitionTransServiceClient client = new DataAcquisitionTransServiceClient())
{
//初始化参数
p.EDCTime = model.EDCTime; //采集时间
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 + ";" +
"EDCTime=" + model.EDCTime + ";" +
"LocationName=" + model.LocationName + ";" +
"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));
}
