public async Task <ActionResult> Query(WorkOrderPowersetQueryViewModel model)
{
if (ModelState.IsValid)
{
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
await Task.Run(() =>
{
StringBuilder where = new StringBuilder();
if (model != null)
{
where.AppendFormat(" Key.OrderNumber = '{0}' AND Key.MaterialCode='{1}'"
, model.OrderNumber
, model.MaterialCode);
}
PagingConfig cfg = new PagingConfig()
{
OrderBy = "Key",
Where = where.ToString()
};
MethodReturnResult <IList <WorkOrderPowerset> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
//
// GET: /ZPVM/WorkOrderPowerset/Modify
public async Task <ActionResult> Modify(string orderNumber, string materialCode, string code, int itemNo)
{
WorkOrderPowersetViewModel viewModel = new WorkOrderPowersetViewModel();
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
MethodReturnResult <WorkOrderPowerset> result = await client.GetAsync(new WorkOrderPowersetKey()
{
OrderNumber = orderNumber,
MaterialCode = materialCode,
Code = code,
ItemNo = itemNo
});
if (result.Code == 0)
{
viewModel = new WorkOrderPowersetViewModel()
{
OrderNumber = result.Data.Key.OrderNumber,
MaterialCode = result.Data.Key.MaterialCode,
Code = result.Data.Key.Code,
ArticleNo = result.Data.ArticleNo,
ItemNo = result.Data.Key.ItemNo,
PowerName = result.Data.PowerName,
SubWay = result.Data.SubWay,
StandardVPM = result.Data.StandardVPM,
StandardVoc = result.Data.StandardVoc,
StandardPower = result.Data.StandardPower,
StandardIsc = result.Data.StandardIsc,
StandardIPM = result.Data.StandardIPM,
StandardFuse = result.Data.StandardFuse,
PowerDifference = result.Data.PowerDifference,
MaxValue = result.Data.MaxValue,
MinValue = result.Data.MinValue,
Name = result.Data.Name,
Description = result.Data.Description,
MixColor = result.Data.MixColor,
IsUsed = result.Data.IsUsed,
CreateTime = result.Data.CreateTime,
Creator = result.Data.Creator,
Editor = result.Data.Editor,
EditTime = result.Data.EditTime
};
return(PartialView("_ModifyPartial", viewModel));
}
else
{
ModelState.AddModelError("", result.Message);
}
}
return(PartialView("_ModifyPartial", new WorkOrderPowersetViewModel()));
}
//
// GET: /ZPVM/WorkOrderPowersetDetail/
public async Task <ActionResult> Index(string OrderNumber, string MaterialCode, string code, int?itemNo)
{
if (string.IsNullOrEmpty(code) || itemNo == null)
{
return(RedirectToAction("Index", "WorkOrderPowerset"));
}
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
WorkOrderPowersetKey key = new WorkOrderPowersetKey()
{
MaterialCode = MaterialCode,
OrderNumber = OrderNumber,
Code = code,
ItemNo = itemNo.Value
};
MethodReturnResult <WorkOrderPowerset> result = await client.GetAsync(key);
if (result.Code > 0 || result.Data == null)
{
return(RedirectToAction("Index", "WorkOrderPowerset"));
}
ViewBag.WorkOrderPowerset = result.Data;
}
using (WorkOrderPowersetDetailServiceClient client = new WorkOrderPowersetDetailServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
Where = string.Format(" Key.Code = '{0}' AND Key.ItemNo='{1}' AND Key.MaterialCode='{2}' AND Key.OrderNumber='{3}'"
, code
, itemNo
, MaterialCode
, OrderNumber),
OrderBy = "Key.ItemNo"
};
MethodReturnResult <IList <WorkOrderPowersetDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
return(View(new WorkOrderPowersetDetailQueryViewModel()
{
OrderNumber = OrderNumber, MaterialCode = MaterialCode, Code = code, ItemNo = itemNo.Value
}));
}
//
// GET: /ZPVM/WorkOrderPowerset/
public async Task <ActionResult> Index(string OrderNumber, string MaterialCode)
{
if (string.IsNullOrEmpty(OrderNumber) || string.IsNullOrEmpty(MaterialCode))
{
return(RedirectToAction("Index", "WorkOrderRule"));
}
using (WorkOrderRuleServiceClient client = new WorkOrderRuleServiceClient())
{
MethodReturnResult <WorkOrderRule> result = await client.GetAsync(new WorkOrderRuleKey()
{
OrderNumber = OrderNumber,
MaterialCode = MaterialCode
});
if (result.Code > 0 || result.Data == null)
{
return(RedirectToAction("Index", "WorkOrderRule"));
}
ViewBag.Rule = result.Data;
}
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
Where = string.Format(" Key.OrderNumber = '{0}' AND Key.MaterialCode='{1}'"
, OrderNumber
, MaterialCode),
OrderBy = "Key"
};
MethodReturnResult <IList <WorkOrderPowerset> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
return(View(new WorkOrderPowersetQueryViewModel()
{
OrderNumber = OrderNumber, MaterialCode = MaterialCode
}));
}
public async Task <ActionResult> Save(WorkOrderPowersetViewModel model)
{
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
WorkOrderPowerset obj = new WorkOrderPowerset()
{
Key = new WorkOrderPowersetKey()
{
OrderNumber = model.OrderNumber,
MaterialCode = model.MaterialCode,
Code = model.Code.ToUpper(),
ItemNo = model.ItemNo ?? 0
},
ArticleNo = model.ArticleNo,
MaxValue = model.MaxValue,
MinValue = model.MinValue,
Name = model.Name.ToUpper(),
PowerDifference = model.PowerDifference,
PowerName = model.PowerName.ToUpper(),
StandardFuse = model.StandardFuse,
StandardIPM = model.StandardIPM,
StandardIsc = model.StandardIsc,
StandardPower = model.StandardPower,
StandardVoc = model.StandardVoc,
StandardVPM = model.StandardVPM,
SubWay = model.SubWay,
Description = model.Description,
IsUsed = model.IsUsed,
MixColor = model.MixColor,
Editor = User.Identity.Name,
EditTime = DateTime.Now,
CreateTime = DateTime.Now,
Creator = User.Identity.Name
};
MethodReturnResult rst = await client.AddAsync(obj);
if (rst.Code == 0)
{
rst.Message = string.Format(ZPVMResources.StringResource.WorkOrderPowerset_Save_Success
, obj.Key);
}
return(Json(rst));
}
}
public async Task <ActionResult> Delete(string orderNumber, string materialCode, string code, int itemNo)
{
MethodReturnResult result = new MethodReturnResult();
WorkOrderPowersetKey key = new WorkOrderPowersetKey()
{
OrderNumber = orderNumber,
MaterialCode = materialCode,
Code = code,
ItemNo = itemNo
};
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
result = await client.DeleteAsync(key);
if (result.Code == 0)
{
result.Message = string.Format(ZPVMResources.StringResource.WorkOrderPowerset_Delete_Success
, key);
}
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 (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
PageNo = pageNo,
PageSize = pageSize,
Where = where ?? string.Empty,
OrderBy = orderBy ?? string.Empty
};
MethodReturnResult <IList <WorkOrderPowerset> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
public List <string> GetCodeAndItemNo(OemData oemData)
{
List <string> dic = new List <string>();
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 0,
PageSize = 1,
Where = string.Format("PowerName='{0}' AND Key.OrderNumber='{1}'", oemData.PnName, oemData.OrderNumber.ToString().Trim().ToUpper())
};
MethodReturnResult <IList <WorkOrderPowerset> > result = client.Get(ref cfg);
if (result.Code == 0 && result.Data != null & result.Data.Count > 0)
{
dic.Add(result.Data[0].Key.Code);
dic.Add(result.Data[0].Key.ItemNo.ToString());
//string iii = dic[0];
return(dic);
}
}
return(null);
}
public ActionResult Save(NameplatePrintViewModel model)
{
System.DateTime dateStartTime;
System.DateTime dateEndTime;
TimeSpan tSpan;
string lotNumber = "";
MethodReturnResult result = new MethodReturnResult();
try
{
dateStartTime = System.DateTime.Now;
dateEndTime = System.DateTime.Now;
//获取批值。
lotNumber = model.LotNumber.ToUpper();
result = GetLot(lotNumber);
if (result.Code > 0)
{
return(Json(result));
}
Lot obj = (result as MethodReturnResult <Lot>).Data;
//获取打印机名称
ClientConfig printer = null;
if (!string.IsNullOrEmpty(model.PrinterName))
{
using (ClientConfigServiceClient client = new ClientConfigServiceClient())
{
MethodReturnResult <ClientConfig> rst = client.Get(model.PrinterName);
if (rst.Code > 0)
{
return(Json(rst));
}
printer = rst.Data;
}
}
//获取打印条码内容
PrintLabel label = null;
if (!string.IsNullOrEmpty(model.PrintLabelCode))
{
using (PrintLabelServiceClient client = new PrintLabelServiceClient())
{
MethodReturnResult <PrintLabel> rst = client.Get(model.PrintLabelCode);
if (rst.Code > 0)
{
return(Json(rst));
}
label = rst.Data;
}
}
//获取IV测试数据及其对应的分档数据。
IVTestData ivtest = null;
using (IVTestDataServiceClient client = new IVTestDataServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format(@"Key.LotNumber='{0}' AND IsDefault=1"
, model.LotNumber),
OrderBy = "Key.TestTime Desc"
};
MethodReturnResult <IList <IVTestData> > rst = client.Get(ref cfg);
if (rst.Code > 0)
{
return(Json(rst));
}
if (rst.Data.Count <= 0)
{
LogHelper.WriteLogInfo(string.Format("GetIVDataError>{0}IV测试数据不存在。", model.LotNumber));
rst.Message = string.Format("{0} IV测试数据不存在。", model.LotNumber);
rst.Code = 1000;
return(Json(rst));
}
ivtest = rst.Data[0];
}
//获取工单分档规则
WorkOrderPowerset wop = null;
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
MethodReturnResult <WorkOrderPowerset> rst = client.Get(new WorkOrderPowersetKey()
{
Code = ivtest.PowersetCode,
ItemNo = ivtest.PowersetItemNo ?? -1,
OrderNumber = obj.OrderNumber,
MaterialCode = obj.MaterialCode
});
if (rst.Code > 0)
{
return(Json(rst));
}
wop = rst.Data;
}
//根据物料编码获取物料数据，进一步获取产品类型。
Material material = null;
using (MaterialServiceClient client = new MaterialServiceClient())
{
MethodReturnResult <Material> rst = client.Get(obj.MaterialCode);
if (rst.Code > 0)
{
return(Json(rst));
}
material = rst.Data;
}
#region //检查打印铭牌的LOG日志
using (IVTestDataPrintLogServiceClient client = new IVTestDataPrintLogServiceClient())
{
int itemNo = 1;
if (model.IsRepeatPrint == false)
{
MethodReturnResult <IVTestDataPrintLog> rst = client.Get(new IVTestDataPrintLogKey()
{
LotNumber = ivtest.Key.LotNumber,
EquipmentCode = ivtest.Key.EquipmentCode,
TestTime = ivtest.Key.TestTime,
ItemNo = itemNo
});
if (rst.Code == 0 && rst.Data != null)
{
//表示重复打印过
result = new MethodReturnResult()
{
Code = 1001,
Message = string.Format("批次（{0}）已打印铭牌。", ivtest.Key.LotNumber)
};
return(Json(result));
}
}
}
#endregion //End 检查打印铭牌的LOG日志
bool bSuccess = true;
//打印动态内容。
if (printer != null && label != null)
{
//获取工单打印规则
WorkOrderPrintSet woprint = null;
using (WorkOrderPrintSetServiceClient client = new WorkOrderPrintSetServiceClient())
{
MethodReturnResult <WorkOrderPrintSet> rst = client.Get(new WorkOrderPrintSetKey()
{
OrderNumber = obj.OrderNumber,
MaterialCode = obj.MaterialCode,
LabelCode = model.PrintLabelCode
});
if (rst.Code > 0)
{
return(Json(rst));
}
woprint = rst.Data;
}
dynamic d = new ExpandoObject();
d.PrintQty = woprint.Qty;
d.LotNumber = lotNumber;
d.PM = ivtest.CoefPM;
d.ISC = ivtest.CoefISC;
d.VOC = ivtest.CoefVOC;
d.IPM = ivtest.CoefIPM;
d.VPM = ivtest.CoefVPM;
d.FF = ivtest.CoefFF;
d.StandardPower = string.Format("{0:0.0}", wop.StandardPower);
d.StandardFuse = wop.StandardFuse;
d.StandardIsc = wop.StandardIsc;
d.StandardVoc = wop.StandardVoc;
d.StandardVPM = wop.StandardVPM;
d.StandardIPM = wop.StandardIPM;
d.PowerName = wop.PowerName;
d.PowerDifference = wop.PowerDifference;
d.ProductType = string.Format("JNM{1}{2}-{0}"
, wop == null ? string.Empty : Convert.ToString(wop.StandardPower)
, material.Key.StartsWith("1201") ? "M" : "P"
, material.MainRawQtyPerLot);
d.ProductSpec = material.Spec.Replace("*", "x");
dateEndTime = System.DateTime.Now;
tSpan = dateEndTime - dateStartTime;
dateStartTime = dateEndTime;
LogHelper.WriteLogInfo(string.Format(@"BeforePrintLabel{3}>从{0:yyyy-MM-dd HH:mm:ss} 到 {1:yyyy-MM-dd HH:mm:ss} ,时间间隔{2}",
dateStartTime.ToString(), dateEndTime.ToString(), tSpan.TotalMilliseconds, lotNumber
)
);
//根据打印机类型，调用不同的打印方法。
using (IPrintHelper helper = PrintHelperFactory.CreatePrintHelper(label.Content))
{
if (printer.ClientType == EnumClientType.NetworkPrinter)
{
string[] vals = printer.IPAddress.Split(':');
string port = "9100";
if (vals.Length > 1)
{
port = vals[1];
}
bSuccess = helper.NetworkPrint(vals[0], port, label.Content, d);
}
else if (printer.ClientType == EnumClientType.RawPrinter)
{
bSuccess = helper.RAWPrint(printer.IPAddress, label.Content, d);
}
else
{
bSuccess = false;
result.Code = 1001;
result.Message = "打印失败,打印机类型不正确。";
return(Json(result));
}
}
if (bSuccess)
{
#region //Add Print Log
using (IVTestDataPrintLogServiceClient client = new IVTestDataPrintLogServiceClient())
{
int itemNo = 1;
IVTestDataPrintLog ivdpl = new IVTestDataPrintLog()
{
CoefFF = ivtest.CoefFF,
CoefIPM = ivtest.CoefIPM,
CoefISC = ivtest.CoefISC,
CoefPM = ivtest.CoefPM,
CoefVOC = ivtest.CoefVOC,
CoefVPM = ivtest.CoefVPM,
CreateTime = DateTime.Now,
Creator = User.Identity.Name,
CTM = ivtest.CTM,
LabelCode = model.PrintLabelCode,
PowersetCode = ivtest.PowersetCode,
PowersetItemNo = ivtest.PowersetItemNo.Value,
PowersetSubCode = ivtest.PowersetSubCode,
PrintTime = DateTime.Now,
Key = new IVTestDataPrintLogKey()
{
LotNumber = ivtest.Key.LotNumber,
EquipmentCode = ivtest.Key.EquipmentCode,
TestTime = ivtest.Key.TestTime,
ItemNo = itemNo
}
};
client.Add(ivdpl);
}
#endregion
}
}
else
{
bSuccess = false;
}
//返回打印结果。
StringBuilder sbMessage = new StringBuilder();
if (bSuccess == false)
{
result.Code = 1001;
sbMessage.AppendFormat("批次 {0} 打印操作失败。<br/>", model.LotNumber);
}
else
{
sbMessage.AppendFormat("批次 {0} 打印操作成功。<br/>", model.LotNumber);
}
sbMessage.Append("<table border='1px' width='100%'><tr><td>");
sbMessage.AppendFormat("<font size='14px' color='red'>档位：{0}</font>", wop.PowerName);
sbMessage.Append("</td><td>");
sbMessage.AppendFormat("<font size='14px' color='red'>子档位：{0}</font> ", ivtest.PowersetSubCode);
sbMessage.AppendFormat("<img src='/ZPVM/WorkOrderPowersetDetail/ShowPicture?OrderNumber={0}&MaterialCode={1}&Code={2}&ItemNo={3}&SubCode={4}&TimeStamp={5}' width='150px'/>"
, obj.OrderNumber
, obj.MaterialCode
, ivtest.PowersetCode
, ivtest.PowersetItemNo
, ivtest.PowersetSubCode
, DateTime.Now.Ticks);
sbMessage.Append("</td><td>");
sbMessage.AppendFormat("<font size='14px' color='blue'>花色：{0}</font><br/>", obj.Color);
sbMessage.Append("</td><td>");
sbMessage.AppendFormat("<br/><font size='14px' color='blue'>等级：{0}</font><br/>", obj.Grade);
sbMessage.Append("</td><tr></table>");
sbMessage.AppendFormat("<font size='10px' color='blue'>功率：{0}</font><br/>", ivtest.CoefPM);
sbMessage.AppendFormat("<font size='10px' color='blue'>ISC：{0}</font><br/>", ivtest.CoefISC);
sbMessage.AppendFormat("<font size='10px' color='blue'>IPM：{0}</font><br/>", ivtest.CoefIPM);
sbMessage.AppendFormat("<font size='10px' color='blue'>VOC：{0}</font><br/>", ivtest.CoefVOC);
sbMessage.AppendFormat("<font size='10px' color='blue'>VPM：{0}</font><br/>", ivtest.CoefVPM);
result.Message = sbMessage.ToString();
}
catch (Exception ex)
{
LogHelper.WriteLogError(string.Format(@"PrintLabel{0}失败", lotNumber), ex);
result.Code = 1000;
result.Message = ex.Message;
result.Detail = ex.ToString();
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
return(Json(result));
}
public async Task <ActionResult> SaveModify(WorkOrderPowersetViewModel model)
{
using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
{
WorkOrderPowersetKey key = new WorkOrderPowersetKey()
{
OrderNumber = model.OrderNumber,
MaterialCode = model.MaterialCode,
Code = model.Code,
ItemNo = model.ItemNo ?? 0
};
MethodReturnResult <WorkOrderPowerset> result = await client.GetAsync(key);
if (result.Code == 0)
{
result.Data.ArticleNo = model.ArticleNo;
result.Data.MaxValue = model.MaxValue;
result.Data.MinValue = model.MinValue;
result.Data.Name = model.Name;
result.Data.PowerDifference = model.PowerDifference;
result.Data.PowerName = model.PowerName;
result.Data.StandardFuse = model.StandardFuse;
result.Data.StandardIPM = model.StandardIPM;
result.Data.StandardIsc = model.StandardIsc;
result.Data.StandardPower = model.StandardPower;
result.Data.StandardVoc = model.StandardVoc;
result.Data.StandardVPM = model.StandardVPM;
result.Data.SubWay = model.SubWay;
result.Data.Description = model.Description;
result.Data.MixColor = model.MixColor;
result.Data.IsUsed = model.IsUsed;
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(ZPVMResources.StringResource.WorkOrderPowerset_SaveModify_Success
, model.Code);
}
return(Json(rst));
}
return(Json(result));
}
//using (WorkOrderPowersetServiceClient client = new WorkOrderPowersetServiceClient())
//{
// WorkOrderPowerset orderPowerset = new WorkOrderPowerset();
// orderPowerset.ArticleNo = model.ArticleNo;
// orderPowerset.MaxValue = model.MaxValue;
// orderPowerset.MinValue = model.MinValue;
// orderPowerset.Name = model.Name;
// orderPowerset.PowerDifference = model.PowerDifference;
// orderPowerset.PowerName = model.PowerName;
// orderPowerset.StandardFuse = model.StandardFuse;
// orderPowerset.StandardIPM = model.StandardIPM;
// orderPowerset.StandardIsc = model.StandardIsc;
// orderPowerset.StandardPower = model.StandardPower;
// orderPowerset.StandardVoc = model.StandardVoc;
// orderPowerset.StandardVPM = model.StandardVPM;
// orderPowerset.SubWay = model.SubWay;
// orderPowerset.Description = model.Description;
// orderPowerset.MixColor = model.MixColor;
// orderPowerset.IsUsed = model.IsUsed;
// orderPowerset.Editor = User.Identity.Name;
// orderPowerset.EditTime = DateTime.Now;
// MethodReturnResult rst = await client.ModifyAsync(orderPowerset);
// if (rst.Code == 0)
// {
// rst.Message = string.Format(ZPVMResources.StringResource.WorkOrderPowerset_SaveModify_Success
// , model.Code);
// }
// return Json(rst);
//}
}
