/// <summary>
/// 修改数据提取
/// </summary>
/// <param name="itemCode">项目代码</param>
/// <param name="fieldCode">字段代码</param>
/// <returns></returns>
public async Task <ActionResult> Modify(string itemCode, string fieldCode)
{
MethodReturnResult <DataAcquisitionField> result = new MethodReturnResult <DataAcquisitionField>();
try
{
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
result = await client.GetAsync(new DataAcquisitionFieldKey()
{
ItemCode = itemCode,
FieldCode = fieldCode
});
if (result.Code == 0)
{
DataAcquisitionFieldViewModel viewModel = new DataAcquisitionFieldViewModel()
{
ItemCode = result.Data.Key.ItemCode, //项目代码
FieldCode = result.Data.Key.FieldCode, //字段代码
FieldName = result.Data.FieldName, //字段说明
SerialNumber = result.Data.SerialNumber, //序号
DataType = result.Data.DataType, //数据类型
IsKEY = result.Data.IsKEY, //主键
IsControl = result.Data.IsControl, //控制
MaxLine = result.Data.MaxLine, //控制上限
MinLine = result.Data.MinLine, //控制下限
Creator = result.Data.Creator, //创建人
CreateTime = result.Data.CreateTime, //创建时间
Editor = result.Data.Editor, //编辑人
EditTime = result.Data.EditTime //编辑时间
};
return(PartialView("_ModifyPartial", viewModel));
}
else
{
ModelState.AddModelError("", result.Message);
}
}
}
catch (Exception ex)
{
result.Code = 1000;
result.Message = ex.Message;
result.Detail = ex.ToString();
}
return(PartialView("_ModifyPartial"));
}
/// <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> Save(DataAcquisitionFieldViewModel model)
{
MethodReturnResult result = new MethodReturnResult();
try
{
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
DataAcquisitionField obj = new DataAcquisitionField()
{
Key = new DataAcquisitionFieldKey()
{
ItemCode = model.ItemCode, //采集项目
FieldCode = model.FieldCode //采集字段
},
FieldName = model.FieldName, //字段说明
SerialNumber = model.SerialNumber, //序号
DataType = model.DataType, //数据类型
IsKEY = model.IsKEY, //主键
IsControl = model.IsControl, //控制
MaxLine = model.MaxLine, //控制上限
MinLine = model.MinLine, //控制下限
Creator = User.Identity.Name, //创建人
CreateTime = DateTime.Now, //创建时间
Editor = User.Identity.Name, //编辑人
EditTime = DateTime.Now //编辑时间
};
//增加对象
result = await client.AddAsync(obj);
if (result.Code == 0)
{
result.Message = string.Format(StringResource.DataAcquisitionField_Save_Success
, obj.Key);
}
}
}
catch (Exception ex)
{
result.Code = 1000;
result.Message = ex.Message;
result.Detail = ex.ToString();
}
return(Json(result));
}
public async Task <ActionResult> Query(DataAcquisitionFieldQueryViewModel model)
{
if (ModelState.IsValid)
{
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
await Task.Run(() =>
{
StringBuilder where = new StringBuilder();
if (model != null)
{
if (!string.IsNullOrEmpty(model.ItemCode))
{
where.AppendFormat(" Key.ItemCode = '{0}'", model.ItemCode);
}
if (!string.IsNullOrEmpty(model.FieldCode))
{
where.AppendFormat("{0} Key.FieldCode LIKE '{1}%'"
, where.Length > 0 ? "AND" : string.Empty
, model.FieldCode);
}
}
PagingConfig cfg = new PagingConfig()
{
Where = where.ToString(),
OrderBy = "Key.ItemCode,SerialNumber"
};
MethodReturnResult <IList <DataAcquisitionField> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
public async Task <ActionResult> Delete(string itemCode, string fieldCode)
{
MethodReturnResult result = new MethodReturnResult();
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
var key = new DataAcquisitionFieldKey()
{
ItemCode = itemCode,
FieldCode = fieldCode
};
result = await client.DeleteAsync(key);
if (result.Code == 0)
{
result.Message = string.Format(StringResource.DataAcquisitionField_Delete_Success
, key);
}
return(Json(result));
}
}
public async Task <ActionResult> SaveModify(DataAcquisitionFieldViewModel model)
{
using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
MethodReturnResult <DataAcquisitionField> result = await client.GetAsync(new DataAcquisitionFieldKey()
{
ItemCode = model.ItemCode,
FieldCode = model.FieldCode
});
if (result.Code == 0)
{
result.Data.FieldName = model.FieldName; //字段说明
result.Data.SerialNumber = model.SerialNumber; //序号
result.Data.DataType = model.DataType; //数据类型
result.Data.IsKEY = model.IsKEY; //主键
result.Data.IsControl = model.IsControl; //控制
result.Data.MaxLine = model.MaxLine; //控制上限
result.Data.MinLine = model.MinLine; //控制下限
result.Data.Creator = model.Creator; //创建人
result.Data.CreateTime = model.CreateTime; //创建时间
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.DataAcquisitionField_SaveModify_Success
, result.Data.Key);
}
return(Json(rst));
}
return(Json(result));
}
}
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 (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
PageNo = pageNo,
PageSize = pageSize,
Where = where ?? string.Empty,
OrderBy = orderBy ?? string.Empty
};
MethodReturnResult <IList <DataAcquisitionField> > 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);
}
public async Task <ActionResult> SaveModify(DataAcquisitionDataViewModel model)
{
MethodReturnResult result = new MethodReturnResult();
try
{
string itemCode = model.ItemCode;
IList <DataAcquisitionData> lstVal = new List <DataAcquisitionData>();
//取得字段列表
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)
{
result.Code = resultField.Code;
result.Message = resultField.Message;
result.Detail = resultField.Detail;
}
else
{
DateTime now = DateTime.Now;
foreach (DataAcquisitionField field in resultField.Data)
{
string fieldValue = Request[field.Key.FieldCode] ?? string.Empty;
DataAcquisitionData val = new DataAcquisitionData()
{
Key = new DataAcquisitionDataKey()
{
EDCTime = model.EDCTime,
ItemCode = model.ItemCode,
FieldCode = field.Key.FieldCode,
LineCode = model.ViewLineCode,
EquipmentCode = model.ViewEquipmentCode,
LocationName = ""
},
DataValue = fieldValue.Split(',')[0],
CreateTime = model.CreateTime,
Creator = model.Creator,
AuditTime = model.AuditTime,
Auditor = model.Auditor ?? string.Empty,
EditTime = now,
Editor = User.Identity.Name
};
lstVal.Add(val);
}
}
});
if (result.Code == 0)
{
using (DataAcquisitionDataServiceClient dataclient = new DataAcquisitionDataServiceClient())
{
result = await dataclient.ModifyAsync(lstVal);
if (result.Code == 0)
{
result.Message = string.Format(StringResource.DataAcquisitionData_Save_Success);
}
}
}
return(Json(result));
}
}
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));
}
}
