public IEnumerable <SelectListItem> GetScanCodeList()
{
MethodReturnResult <IList <Equipment> > result = new MethodReturnResult <IList <Equipment> >();
IList <Equipment> lst = new List <Equipment>();
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
StringBuilder where = new StringBuilder();
where.AppendFormat(" {0} Name LIKE 'Reader%'"
, where.Length > 0 ? "AND" : string.Empty);
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
OrderBy = "Key",
Where = where.ToString()
};
result = client.Get(ref cfg);
}
if (result.Code <= 0 && result.Data != null)
{
lst = result.Data;
}
return(from item in lst
select new SelectListItem()
{
Value = item.Key,
Text = item.LineCode
});
}
/// <summary>
/// 取得设备代码
/// </summary>
/// <param name="routestepname">工序</param>
/// <param name="productionLineCode">线别</param>
/// <returns></returns>
public ActionResult GetEquipmentName(string EquipmentCode, string LineCode)
{
IList <Equipment> lstEquipments = new List <Equipment>();
//根据生产线和工序获取设备。
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
OrderBy = "LineCode",
Where = string.Format(@" Key = '{0}'and LineCode='{1}' ",
EquipmentCode,
LineCode)
};
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code <= 0 && result.Data != null)
{
lstEquipments = result.Data;
}
}
var lnq = from item in lstEquipments
select new
{
Value = item.Name,
Text = item.Name
};
return(Json(lnq, JsonRequestBehavior.AllowGet));
}
public ActionResult GetEquipmentState(string equipmentCode)
{
string stateName = string.Empty;
//根据生产线和工序获取设备。
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
MethodReturnResult <Equipment> result = client.Get(equipmentCode);
if (result.Code <= 0 && result.Data != null)
{
stateName = result.Data.StateName;
}
}
string stateColor = string.Empty;
if (!string.IsNullOrEmpty(stateName))
{
using (EquipmentStateServiceClient client = new EquipmentStateServiceClient())
{
MethodReturnResult <EquipmentState> result = client.Get(stateName);
if (result.Code <= 0 && result.Data != null)
{
stateColor = result.Data.StateColor;
}
}
}
return(Json(new
{
StateName = stateName,
StateColor = stateColor
}, JsonRequestBehavior.AllowGet));
}
public ActionResult GetEquipments(string routeOperationName, string productionLineCode)
{
IList <Equipment> lstEquipments = new List <Equipment>();
//根据生产线和工序获取设备。
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format(@"LineCode='{0}' AND EXISTS(FROM RouteOperationEquipment as p
WHERE p.Key.EquipmentCode=self.Key
AND p.Key.RouteOperationName='{1}')"
, productionLineCode
, routeOperationName)
};
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code <= 0 && result.Data != null)
{
lstEquipments = result.Data;
}
}
var lnq = from item in lstEquipments
select new
{
Key = item.Key,
Text = item.Key + "-" + item.Name
};
return(Json(lnq, JsonRequestBehavior.AllowGet));
}
public Equipment GetEquipment(string key)
{
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
MethodReturnResult <Equipment> result = client.Get(key);
if (result.Code <= 0)
{
return(result.Data);
}
}
return(null);
}
public ActionResult GetEquipmentName(string equipmentCode)
{
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
MethodReturnResult <Equipment> result = client.Get(equipmentCode);
if (result.Code <= 0)
{
return(Json(result.Data.Name, JsonRequestBehavior.AllowGet));
}
}
return(Json(equipmentCode, JsonRequestBehavior.AllowGet));
}
//
// GET: /FMM/Equipment/Modify
public async Task <ActionResult> Modify(string key)
{
EquipmentViewModel viewModel = new EquipmentViewModel();
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
MethodReturnResult <Equipment> result = await client.GetAsync(key);
if (result.Code == 0)
{
viewModel = new EquipmentViewModel()
{
AssetsNo = result.Data.AssetsNo,
AvTime = result.Data.AvTime,
ChamberIndex = result.Data.ChamberIndex,
GroupName = result.Data.GroupName,
IsBatch = result.Data.IsBatch,
IsChamber = result.Data.IsChamber,
IsMultiChamber = result.Data.IsMultiChamber,
LineCode = result.Data.LineCode,
LocationName = result.Data.LocationName,
MaxQuantity = result.Data.MaxQuantity,
MinQuantity = result.Data.MinQuantity,
Name = result.Data.Name,
No = result.Data.No,
ParentEquipmentCode = result.Data.ParentEquipmentCode,
RealEquipmentCode = result.Data.RealEquipmentCode,
RunRate = result.Data.RunRate,
StateName = result.Data.StateName,
TactTime = result.Data.TactTime,
TotalChamber = result.Data.TotalChamber,
Type = result.Data.Type,
WPH = result.Data.WPH,
Description = result.Data.Description,
Editor = result.Data.Editor,
EditTime = result.Data.EditTime,
CreateTime = result.Data.CreateTime,
Creator = result.Data.Creator,
Code = result.Data.Key
};
return(PartialView("_ModifyPartial", viewModel));
}
else
{
ModelState.AddModelError("", result.Message);
}
}
return(PartialView("_ModifyPartial"));
}
public async Task <ActionResult> Delete(string key)
{
MethodReturnResult result = new MethodReturnResult();
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
result = await client.DeleteAsync(key);
if (result.Code == 0)
{
result.Message = string.Format(FMMResources.StringResource.Equipment_Delete_Success
, key);
}
return(Json(result));
}
}
public async Task <ActionResult> Query(EquipmentQueryViewModel model)
{
if (ModelState.IsValid)
{
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
await Task.Run(() =>
{
StringBuilder where = new StringBuilder();
if (model != null)
{
if (!string.IsNullOrEmpty(model.Code))
{
where.AppendFormat(" {0} Key LIKE '{1}%'"
, where.Length > 0 ? "AND" : string.Empty
, model.Code);
}
if (!string.IsNullOrEmpty(model.Name))
{
where.AppendFormat(" {0} Name LIKE '{1}%'"
, where.Length > 0 ? "AND" : string.Empty
, model.Name);
}
if (!string.IsNullOrEmpty(model.GroupName))
{
where.AppendFormat(" {0} GroupName LIKE '{1}%'"
, where.Length > 0 ? "AND" : string.Empty
, model.GroupName);
}
}
PagingConfig cfg = new PagingConfig()
{
OrderBy = "Key",
Where = where.ToString()
};
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
public async Task <ActionResult> Save(EquipmentViewModel model)
{
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
Equipment obj = new Equipment()
{
Key = model.Code,
AssetsNo = model.AssetsNo,
AvTime = model.AvTime,
GroupName = model.GroupName,
ChangeStateName = null,
IsBatch = model.IsBatch,
IsMultiChamber = model.IsMultiChamber,
IsChamber = model.IsMultiChamber?false:model.IsChamber,
LineCode = model.LineCode,
LocationName = model.LocationName,
MaxQuantity = model.MaxQuantity,
MinQuantity = model.MinQuantity,
Name = model.Name,
No = model.No,
RealEquipmentCode = model.RealEquipmentCode,
RunRate = model.RunRate,
StateName = model.StateName,
TactTime = model.TactTime,
TotalChamber = model.TotalChamber,
Type = model.Type,
WPH = model.WPH,
Description = model.Description,
Editor = User.Identity.Name,
EditTime = DateTime.Now,
CreateTime = DateTime.Now,
Creator = User.Identity.Name
};
obj.ChamberIndex = obj.IsChamber ? model.ChamberIndex : null;
obj.ParentEquipmentCode = obj.IsChamber ? model.ParentEquipmentCode : null;
MethodReturnResult rst = await client.AddAsync(obj);
if (rst.Code == 0)
{
rst.Message = string.Format(FMMResources.StringResource.Equipment_Save_Success
, model.Code);
}
return(Json(rst));
}
}
public async Task <ActionResult> SaveModify(EquipmentViewModel model)
{
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
MethodReturnResult <Equipment> result = await client.GetAsync(model.Code);
if (result.Code == 0)
{
result.Data.AssetsNo = model.AssetsNo;
result.Data.AvTime = model.AvTime;
result.Data.GroupName = model.GroupName;
result.Data.IsBatch = model.IsBatch;
result.Data.IsMultiChamber = model.IsMultiChamber;
result.Data.IsChamber = model.IsMultiChamber?false:model.IsChamber;
result.Data.ChamberIndex = result.Data.IsChamber ? model.ChamberIndex : null;
result.Data.ParentEquipmentCode = result.Data.IsChamber ? model.ParentEquipmentCode:null;
result.Data.LineCode = model.LineCode;
result.Data.LocationName = model.LocationName;
result.Data.MaxQuantity = model.MaxQuantity;
result.Data.MinQuantity = model.MinQuantity;
result.Data.Name = model.Name;
result.Data.No = model.No;
result.Data.RealEquipmentCode = model.RealEquipmentCode;
result.Data.RunRate = model.RunRate;
result.Data.TactTime = model.TactTime;
result.Data.TotalChamber = model.TotalChamber;
result.Data.Type = model.Type;
result.Data.WPH = model.WPH;
result.Data.Description = model.Description;
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(FMMResources.StringResource.Equipment_SaveModify_Success
, model.Code);
}
return(Json(rst));
}
return(Json(result));
}
}
//
// GET: /ZPVM/RuleControlObject/
public async Task <ActionResult> Index(string code)
{
if (string.IsNullOrEmpty(code))
{
return(RedirectToAction("Index", "Rule"));
}
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
MethodReturnResult <Equipment> result = await client.GetAsync(code);
if (result.Code > 0 || result.Data == null)
{
return(RedirectToAction("Index", "Rule"));
}
ViewBag.Rule = result.Data;
}
using (EquipmentControlObjectServiceClient client = new EquipmentControlObjectServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
Where = string.Format(" Key.Code = '{0}'"
, code),
OrderBy = "Key"
};
MethodReturnResult <IList <EquipmentControlObject> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
return(View(new EquipmentControlObjectQueryViewModel()
{
Code = code
}));
}
/// <summary> 获取设备信息 </summary>
/// <param name="lotNumber">批次号</param>
/// <returns></returns>
public Equipment GetEquipment(string equipment)
{
Equipment Equipment = null;
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 0,
PageSize = 1,
Where = string.Format("Key='{0}' ", equipment)
};
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code <= 0 && result.Data.Count > 0)
{
Equipment = result.Data[0];
}
return(Equipment);
}
}
//
// GET: /FMM/Equipment/
public async Task <ActionResult> Index()
{
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
OrderBy = "Key"
};
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
return(View(new EquipmentQueryViewModel()));
}
/// <summary>
/// 取得设备组分类信息
/// </summary>
public IEnumerable <SelectListItem> GetEquipmentGroupList()
{
IList <Equipment> lst = new List <Equipment>();
PagingConfig cfg = new PagingConfig()
{
IsPaging = false
};
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code <= 0 && result.Data != null)
{
lst = result.Data;
}
}
var query = from item in lst
group item by new { t1 = item.GroupName }
into m
select new
{
Text = m.First().GroupName,
Value = m.First().Key,
} into r
orderby r.Text, r.Value
select r;
Dictionary <string, string> dic = new Dictionary <string, string>();
foreach (var data in query)
{
dic.Add(data.Text, data.Value);
}
return(from item in dic
select new SelectListItem()
{
Value = item.Key,
Text = item.Key
//Text = item.Key
});
}
public IEnumerable <SelectListItem> GetEquipmentCodeList()
{
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false
};
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code <= 0)
{
IEnumerable <SelectListItem> lst = from item in result.Data
select new SelectListItem()
{
Text = string.Format("{0}-{1}", item.Key, item.Name),
Value = item.Key
};
return(lst);
}
}
return(new List <SelectListItem>());
}
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 (EquipmentServiceClient client = new EquipmentServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
PageNo = pageNo,
PageSize = pageSize,
Where = where ?? string.Empty,
OrderBy = orderBy ?? string.Empty
};
MethodReturnResult <IList <Equipment> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
public ActionResult Save(LotBinViewModel model)
{
MethodReturnResult result = new MethodReturnResult();
try
{
string IPAddress = model.ScanIP;
string packalgeLine = string.Empty;
if (localName == "K01")
{
MethodReturnResult <Equipment> resultEquipment = new MethodReturnResult <Equipment>();
using (EquipmentServiceClient client = new EquipmentServiceClient())
{
resultEquipment = client.Get(IPAddress);
if (resultEquipment.Code > 0)
{
result.Code = resultEquipment.Code;
result.Message = resultEquipment.Message;
return(Json(result));
}
else
{
packalgeLine = resultEquipment.Data.LineCode;
}
}
}
if (localName == "G01")
{
packalgeLine = model.ScanIP;
}
InBinParameter p = new InBinParameter()
{
Creator = User.Identity.Name,
OperateComputer = Request.UserHostAddress,
Operator = User.Identity.Name,
BinNo = model.BinNo,
//ReasonCodeCategoryName = model.ReasonCodeCategoryName,
//ReasonCodeName = model.ReasonCodeName,
//Remark = model.Description,
PackageLine = packalgeLine,
ScanLotNumber = model.LotNumber,
ScanIP = model.ScanIP,
ScanNo = model.ScanNo,//
LotNumbers = new List <string>()
};
//char splitChar = ',';
////获取批次号值。
//string[] lotNumbers = Request["LotNumber"].ToUpper().Split(splitChar);
//p.LotNumbers = lotNumbers.ToList();
//for (int i = 0; i < p.LotNumbers.Count; i++)
//{
// string lotNumber = p.LotNumbers[i];
// //result = GetLot(lotNumber);
// if (result.Code > 0)
// {
// return Json(result);
// }
//}
using (LotBinServiceClient client = new LotBinServiceClient())
{
result = client.InBin(p);
}
if (result.Code == 0)
{
result.Message = string.Format("批次{0}入Bin成功.{1}", model.LotNumber, result.Message);
}
}
catch (Exception ex)
{
result.Code = 1000;
result.Message = ex.Message;
result.Detail = ex.ToString();
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
return(Json(result));
}
private void Form2_Load(object sender, EventArgs e)
{
HisServiceClient hisClient = new HisServiceClient();
EquipmentServiceClient equclient = new EquipmentServiceClient();
}
