public async Task <ActionResult> Query(MaterialReceiptQueryViewModel model) { using (ERPClient client = new ERPClient()) { MethodReturnResult ReturnResult = new MethodReturnResult(); MethodReturnResult <DataSet> result = client.GetERPMaterialReceipt(model.ReceiptNo); if (result.Code == 0) { if (result.Data.Tables[0].Rows.Count > 0) { WorkOrderServiceClient workClient = new WorkOrderServiceClient(); MethodReturnResult <WorkOrder> rst = await workClient.GetAsync(result.Data.Tables[0].Rows[0]["VPRODUCTBATCH"].ToString()); if (rst.Data == null) { ReturnResult.Code = 1001; ReturnResult.Message = string.Format(StringResource.ERPWorkOrder_Error_Query, model.ReceiptNo, result.Data.Tables[0].Rows[0]["VPRODUCTBATCH"].ToString()); } } else { ReturnResult.Code = 1001; ReturnResult.Message = string.Format(StringResource.ERPMaterialReceipt_Error_Query, model.ReceiptNo); } } else { ReturnResult.Code = result.Code; ReturnResult.Message = result.Message; } return(Json(ReturnResult)); } }
public async Task <ActionResult> Query(MaterialReceiptQueryViewModel model) { if (ModelState.IsValid) { using (MaterialReceiptServiceClient client = new MaterialReceiptServiceClient()) { await Task.Run(() => { StringBuilder where = new StringBuilder(); if (model != null) { if (!string.IsNullOrEmpty(model.ReceiptNo)) { where.AppendFormat(" {0} Key = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.ReceiptNo); } if (!string.IsNullOrEmpty(model.OrderNumber)) { where.AppendFormat(" {0} OrderNumber = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.OrderNumber); } if (model.StartReceiptDate != null) { where.AppendFormat(" {0} ReceiptDate >= '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.StartReceiptDate); } if (model.EndReceiptDate != null) { where.AppendFormat(" {0} ReceiptDate <= '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.EndReceiptDate); } } PagingConfig cfg = new PagingConfig() { OrderBy = "CreateTime Desc", Where = where.ToString() }; MethodReturnResult <IList <MaterialReceipt> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial")); } else { return(View("Index")); } }