/// <summary>
/// 确定明细信息
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public async Task <ActionResult> Detail(string itemCode)
{
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
MethodReturnResult <DataAcquisitionItem> result = await client.GetAsync(itemCode);
if (result.Code == 0)
{
DataAcquisitionItemViewModel viewModel = new DataAcquisitionItemViewModel()
{
ItemCode = result.Data.Key, //项目代码
ItemName = result.Data.ItemName, //项目名称
Description = result.Data.Description, //描述
RouteStepName = result.Data.RouteStepName, //工序名称
Creator = result.Data.Creator, //创建人
CreateTime = result.Data.CreateTime, //创建日期
Editor = result.Data.Editor, //编辑人
EditTime = result.Data.EditTime //编辑日期
};
return(PartialView("_InfoPartial", viewModel));
}
else
{
ModelState.AddModelError("", result.Message);
}
}
return(PartialView("_InfoPartial"));
}
public async Task <ActionResult> SaveModify(DataAcquisitionItemViewModel model)
{
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
MethodReturnResult <DataAcquisitionItem> result = await client.GetAsync(model.ItemCode);
if (result.Code == 0)
{
result.Data.Key = model.ItemCode; //项目代码
result.Data.ItemName = model.ItemName; //项目名称
result.Data.Description = model.Description; //项目描述
result.Data.RouteStepName = model.RouteStepName; //工序名称
result.Data.Editor = User.Identity.Name; //编辑人
result.Data.EditTime = DateTime.Now; //编辑日期
MethodReturnResult rst = await client.ModifyAsync(result.Data);
if (rst.Code == 0)
{
rst.Message = string.Format(StringResource.DataAcquisitionItem_SaveModify_Success
, model.ItemCode);
}
return(Json(rst));
}
return(Json(result));
}
}
public async Task <ActionResult> Save(DataAcquisitionItemViewModel model)
{
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
DataAcquisitionItem obj = new DataAcquisitionItem()
{
Key = model.ItemCode, //项目代码
ItemName = model.ItemName, //项目名称
Description = model.Description, //描述
RouteStepName = model.RouteStepName, //工序名称
Creator = User.Identity.Name, //创建人
CreateTime = DateTime.Now, //创建日期
Editor = User.Identity.Name, //编辑人
EditTime = DateTime.Now //编辑日期
};
MethodReturnResult rst = await client.AddAsync(obj);
if (rst.Code == 0)
{
rst.Message = string.Format(StringResource.DataAcquisitionItem_Save_Success
, model.ItemCode);
}
return(Json(rst));
}
}
/// <summary>
/// 根据采集项目初始化采集字段窗体
/// </summary>
/// <param name="itemCode">采集项目代码</param>
/// <returns></returns>
public async Task <ActionResult> Index(string itemCode)
{
//取得采集项目对象
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
MethodReturnResult <DataAcquisitionItem> result = await client.GetAsync(itemCode ?? string.Empty);
if (result.Code > 0 || result.Data == null)
{
return(RedirectToAction("Index", "DataAcquisitionItem"));
}
ViewBag.DataAcquisitionItem = result.Data;
}
//提取采集字段数据
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
await Task.Run(() =>
{
//string where = string.Format("Key.ItemCode = '{0}'", itemCode);
PagingConfig cfg = new PagingConfig()
{
Where = string.Format("Key.ItemCode = '{0}'", itemCode),
OrderBy = "Key.ItemCode,SerialNumber"
};
//提取数据
MethodReturnResult <IList <DataAcquisitionField> > result = client.Get(ref cfg);
if (result.Code > 0 || result.Data == null)
{
//错误信息处理
}
else
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
return(View(new DataAcquisitionFieldQueryViewModel()
{
ItemCode = itemCode
}));
}
public async Task <ActionResult> Delete(string itemCode)
{
MethodReturnResult result = new MethodReturnResult();
using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient())
{
result = await client.DeleteAsync(itemCode);
if (result.Code == 0)
{
result.Message = string.Format(StringResource.DataAcquisitionItem_Delete_Success
, itemCode);
}
return(Json(result));
}
}
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));
}
}
