public ActionResult GetMaterialLot(string materialLot, string materialCode, string orderNumber) { LineStoreMaterialDetail lineStoreMaterialDetail = new LineStoreMaterialDetail(); using (LineStoreMaterialServiceClient client = new LineStoreMaterialServiceClient()) { PagingConfig cfg = new PagingConfig() { PageSize = 1, Where = string.Format(@"Key.MaterialCode='{0}' AND Key.MaterialLot = '{1}' AND Key.OrderNumber = '{2}'" , materialCode , materialLot , orderNumber), OrderBy = "Key" }; MethodReturnResult <IList <LineStoreMaterialDetail> > result = client.GetDetail(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { lineStoreMaterialDetail = result.Data[0]; } } return(Json(new { @SupplierCode = lineStoreMaterialDetail.SupplierCode ?? string.Empty, @SupplierMaterialLot = lineStoreMaterialDetail.SupplierMaterialLot ?? string.Empty, @Attr1 = lineStoreMaterialDetail.Attr1 ?? string.Empty }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ParentQuery(MaterialReceiptDetailParentQueryViewModel model) { LineStoreMaterialDetail lsmd = null; MaterialReceiptDetail mrd = null; if (ModelState.IsValid && model.MaterialLot != null) { using (LineStoreMaterialServiceClient client = new LineStoreMaterialServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { Where = string.Format(" Key.MaterialLot Like '{0}'" , model.MaterialLot) }; MethodReturnResult <IList <LineStoreMaterialDetail> > result = client.GetDetail(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { lsmd = result.Data[0]; } }); } if (lsmd != null) { using (MaterialReceiptServiceClient client = new MaterialReceiptServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { OrderBy = "CreateTime Desc,Key.ReceiptNo,Key.ItemNo", Where = string.Format("MaterialLot LIKE '{0}'" , lsmd.Attr2) }; MethodReturnResult <IList <MaterialReceiptDetail> > result = client.GetDetail(ref cfg); if (result.Code == 0 && result.Data.Count > 0 && result.Data[0] != null) { ViewBag.lsmd = lsmd; ViewBag.mrd = result.Data[0]; } }); } } } if (Request.IsAjaxRequest()) { return(PartialView("_ParentListPartial")); } else { return(View("ParentQueryIndex")); } }
public LineStoreMaterialDetail GetLineStoreMaterialDetail(LineStoreMaterialDetailKey key) { LineStoreMaterialDetail obj = null; using (LineStoreMaterialServiceClient client = new LineStoreMaterialServiceClient()) { MethodReturnResult <LineStoreMaterialDetail> result = client.GetDetail(key); if (result.Code <= 0 && result.Data != null) { obj = result.Data; } } return(obj); }
public async Task <ActionResult> Query(MaterialSplitQueryViewModel MaterialSplitQueryViewModel) { MethodReturnResult <IList <LineStoreMaterialDetail> > result = new MethodReturnResult <IList <LineStoreMaterialDetail> >(); MaterialSplitViewModel model = new MaterialSplitViewModel(); LineStoreMaterialDetail lsmd = new LineStoreMaterialDetail(); model.count = MaterialSplitQueryViewModel.count; model.ParentMaterialLotNumber = MaterialSplitQueryViewModel.MaterialLotNumber; model.OrderNumber = MaterialSplitQueryViewModel.OrderNumber; if (ModelState.IsValid) { using (LineStoreMaterialServiceClient client = new LineStoreMaterialServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { Where = string.Format(" Key.MaterialLot LIKE '{0}' AND Key.OrderNumber='{1}'" , MaterialSplitQueryViewModel.MaterialLotNumber, MaterialSplitQueryViewModel.OrderNumber) }; result = client.GetDetail(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { ViewBag.ParentMaterial = result.Data[0]; lsmd = result.Data[0]; ViewBag.ParentCurrentQty = lsmd.CurrentQty; ViewBag.CurrentQty = lsmd.CurrentQty / MaterialSplitQueryViewModel.count; for (int i = 0; i < model.count; i++) { model.ChildViewModel.Add(new ChildViewModel() { Quantity = lsmd.CurrentQty / MaterialSplitQueryViewModel.count }); } } else { ViewBag.flag = 0; ViewBag.Message = "批次不存在"; } }); } } return(View("_MaterialSplit", model)); }
public ActionResult GetMaterialLot(string materialLot, string materialCode, string orderNumber) { LineStoreMaterialDetail lineStoreMaterialDetail = new LineStoreMaterialDetail(); if (materialLot.StartsWith("JNC") || materialLot.StartsWith("jnc")) { MaterialReceiptDetail obj = this.GetBox(materialLot); lineStoreMaterialDetail.Attr1 = obj.Attr1; lineStoreMaterialDetail.SupplierCode = "000000"; lineStoreMaterialDetail.LoadingQty = obj.Qty; lineStoreMaterialDetail.Attr2 = obj.Attr2; } else { using (LineStoreMaterialServiceClient client = new LineStoreMaterialServiceClient()) { PagingConfig cfg = new PagingConfig() { PageSize = 1, Where = string.Format(@"Key.MaterialCode='{0}' AND Key.MaterialLot = '{1}' AND Key.OrderNumber = '{2}'" , materialCode , materialLot , orderNumber), OrderBy = "Key" }; MethodReturnResult <IList <LineStoreMaterialDetail> > result = client.GetDetail(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { lineStoreMaterialDetail = result.Data[0]; } } } return(Json(new { @SupplierCode = lineStoreMaterialDetail.SupplierCode ?? string.Empty, @SupplierMaterialLot = lineStoreMaterialDetail.SupplierMaterialLot ?? string.Empty, @Attr1 = lineStoreMaterialDetail.Attr1 ?? string.Empty, @Attr2 = lineStoreMaterialDetail.Attr2 ?? string.Empty, @Qty = lineStoreMaterialDetail.LoadingQty }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ExportToExcel(LineStoreMaterialDetailQueryViewModel model) { IList <LineStoreMaterialDetail> lst = new List <LineStoreMaterialDetail>(); using (LineStoreMaterialServiceClient client = new LineStoreMaterialServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { IsPaging = false, OrderBy = "CreateTime Desc", Where = GetDetailWhereCondition(model) }; MethodReturnResult <IList <LineStoreMaterialDetail> > result = client.GetDetail(ref cfg); if (result.Code == 0) { lst = result.Data; } }); } //创建工作薄。 IWorkbook wb = new HSSFWorkbook(); //设置EXCEL格式 ICellStyle style = wb.CreateCellStyle(); style.FillForegroundColor = 10; //有边框 style.BorderBottom = BorderStyle.Thin; style.BorderLeft = BorderStyle.Thin; style.BorderRight = BorderStyle.Thin; style.BorderTop = BorderStyle.Thin; IFont font = wb.CreateFont(); font.Boldweight = 10; style.SetFont(font); ICell cell = null; IRow row = null; ISheet ws = null; for (int j = 0; j < lst.Count; j++) { if (j % 65535 == 0) { ws = wb.CreateSheet(); row = ws.CreateRow(0); #region //列名 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(StringResource.ItemNo); //项目号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_LineStoreName); //线边仓 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue("工单号"); //工单号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_MaterialCode); //物料编码 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue("物料名称"); //物料名称 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_MaterialLot); //物料批号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_ReceiveQty); //领料数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_LoadingQty); //上料数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_UnloadingQty); //下料数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_CurrentQty); //当前数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_SupplierMaterialLot); //供应商物料批次号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(LSMResources.StringResource.LineStoreMaterialDetailViewModel_SupplierCode); //供应商编码 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue("供应商名称"); //供应商名称 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue("效率档"); //效率档 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue("描述"); //描述 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue("编辑人"); //编辑人 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue("编辑时间"); //编辑时间 #endregion font.Boldweight = 5; } LineStoreMaterialDetail obj = lst[j]; Material m = model.GetMaterial(obj.Key.MaterialCode); Supplier s = model.GetSupplier(obj.SupplierCode); row = ws.CreateRow(j + 1); #region //数据 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(j + 1); //项目号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.Key.LineStoreName); //线边仓 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.Key.OrderNumber); //工单号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.Key.MaterialCode); //物料编码 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(m == null ? string.Empty : m.Name); //物料名称 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.Key.MaterialLot); //物料批号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.ReceiveQty); //领料数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.LoadingQty); //上料数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.UnloadingQty); //下料数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.CurrentQty); //当前数量 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.SupplierMaterialLot); //供应商物料批次号 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.SupplierCode); //供应商编码 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(s == null ? string.Empty : s.Name); //供应商名称 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.Attr1); //效率档 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.Description); //描述 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(obj.Editor); //编辑人 cell = row.CreateCell(row.Cells.Count); cell.CellStyle = style; cell.SetCellValue(string.Format("{0:yyyy-MM-dd HH:mm:ss}", obj.EditTime)); //编辑时间 #endregion } MemoryStream ms = new MemoryStream(); wb.Write(ms); ms.Flush(); ms.Position = 0; return(File(ms, "application/vnd.ms-excel", "LineStoreMaterialData.xls")); }