public async Task <ActionResult> Query(DataAcquisitionItemQueryViewModel model)
{
if (ModelState.IsValid)
{
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
await Task.Run(() =>
{
StringBuilder where = new StringBuilder();
//项目代码
if (!string.IsNullOrEmpty(model.ItemCode))
{
where.AppendFormat(" {0} Key LIKE '{1}%'"
, where.Length > 0 ? "AND" : string.Empty
, model.ItemCode);
}
//工序条件
if (model.RouteStepName != null && model.RouteStepName != "")
{
where.AppendFormat(" {0} RouteStepName = '{1}'"
, where.Length > 0 ? "AND" : string.Empty
, model.RouteStepName);
}
PagingConfig cfg = new PagingConfig()
{
OrderBy = "Key",
Where = where.ToString()
};
MethodReturnResult <IList <DataAcquisitionItem> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
public async Task <ActionResult> PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize)
{
if (ModelState.IsValid)
{
int pageNo = currentPageNo ?? 0;
int pageSize = currentPageSize ?? 20;
if (Request["PageNo"] != null)
{
pageNo = Convert.ToInt32(Request["PageNo"]);
}
if (Request["PageSize"] != null)
{
pageSize = Convert.ToInt32(Request["PageSize"]);
}
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
PageNo = pageNo,
PageSize = pageSize,
Where = where ?? string.Empty,
OrderBy = orderBy ?? string.Empty
};
MethodReturnResult <IList <DataAcquisitionItem> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
/// <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);
}
/// <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));
}
}
