public ActionResult UpdateMaterialType(MaterialTypeModel model)
{
var result = new StandardJsonResult <bool>();
result.Try(() =>
{
if (!ModelState.IsValid)
{
throw new KnownException(ModelState.GetFirstError());
}
MaterialTypeDto m = new MaterialTypeDto();
m.Name = model.Name;
m.MaterialTypeID = model.MaterialTypeID;
m.Avaliable = model.Avaliable;
var mservice = ML.BC.Infrastructure.Ioc.GetService <IMaterialTypeManagementService>();
result.Value = mservice.Update(m);
});
if (result.Success)
{
result.Message = "修改成功";
}
else
{
result.Message = "修改失败";
}
return(result);
}
private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
materialTypeList = MaterialTypeController.Select().Where(w => w.MaterialGroup.Contains("UPPER")).ToList();
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.SelectByProductNo();
DataTable dt = new DelayDataSet().Tables["DelayTable"];
List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
var materialUpperIdList = materialTypeList.Select(s => s.MaterialTypeId).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <Int32> materialTypeIdList = rawMaterialList.Where(w => materialUpperIdList.Contains(w.MaterialTypeId)).Select(r => r.MaterialTypeId).Distinct().ToList();
// get assemblyline from productNo
//AssemblyMasterModel assemblyMaster = assemblyMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault();
// get sewingLing from productNo
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault();
//materialTypeIdList.Remove(6);
//materialTypeIdList.Remove(11);
//materialTypeIdList.Remove(12);
//materialTypeIdList.Remove(13);
//materialTypeIdList.Remove(14);
foreach (int materialTypeId in materialTypeIdList)
{
RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault();
if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date < DateTime.Now.Date &&
rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1))
{
DataRow dr = dt.NewRow();
// binding data to reportviewer
dr["SewingLine"] = sewingMaster.SewingLine;
dr["ProductNo"] = productNo;
if (order != null)
{
dr["ArticleNo"] = order.ArticleNo;
dr["ShoeName"] = order.ShoeName;
dr["Quantity"] = order.Quantity;
dr["ETD"] = order.ETD;
}
dr["SupplierETD"] = rawMaterial.ETD;
dr["Remarks"] = rawMaterial.Remarks;
MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault();
if (materialType != null)
{
dr["Supplier"] = materialType.Name;
}
dt.Rows.Add(dr);
}
}
}
e.Result = dt;
}
void threadLoad_DoWork(object sender, DoWorkEventArgs e)
{
materialTypeList = MaterialTypeController.Select();
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <Int32> materialTypeIdList = rawMaterialList.Select(r => r.MaterialTypeId).Distinct().ToList();
//Red!
materialTypeIdList.Remove(6);
materialTypeIdList.Remove(11);
materialTypeIdList.Remove(12);
materialTypeIdList.Remove(13);
foreach (int materialTypeId in materialTypeIdList)
{
RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault();
if (rawMaterial != null && rawMaterial.ETD.Date != dtDefault
//&& rawMaterial.ActualDate.Date == dtDefault
)
{
DeliveryStatusViewModel deliveryStatusView = new DeliveryStatusViewModel();
deliveryStatusView.ProductNo = productNo;
if (order != null)
{
deliveryStatusView.Country = order.Country;
deliveryStatusView.ArticleNo = order.ArticleNo;
deliveryStatusView.ShoeName = order.ShoeName;
deliveryStatusView.Quantity = order.Quantity;
deliveryStatusView.ETD = order.ETD;
}
MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault();
if (materialType != null)
{
deliveryStatusView.Supplier = materialType.Name;
}
deliveryStatusView.SupplierETD = rawMaterial.ETD;
if (rawMaterial.ActualDate != dtDefault)
{
deliveryStatusView.Actual = string.Format("{0:MM/dd/yyyy}", rawMaterial.ActualDate);
deliveryStatusView.IsFinished = true;
}
else
{
deliveryStatusView.Actual = rawMaterial.Remarks;
deliveryStatusView.IsFinished = false;
}
deliveryStatusViewList.Add(deliveryStatusView);
}
}
}
}
private void bwReport_DoWork(object sender, DoWorkEventArgs e)
{
DataTable dt = new DeliveryDataSet().Tables["DeliveryTable"];
List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
var materialUpperIdList = materialTypeList.Select(s => s.MaterialTypeId).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
//List<Int32> materialTypeIdList = rawMaterialList.Select(r => r.MaterialTypeId).Distinct().ToList();
List <Int32> materialTypeIdList = rawMaterialList.Where(w => materialUpperIdList.Contains(w.MaterialTypeId)).Select(r => r.MaterialTypeId).Distinct().ToList();
//Red!
//materialTypeIdList.Remove(11);
//materialTypeIdList.Remove(6);
//materialTypeIdList.Remove(12);
//materialTypeIdList.Remove(13);
//materialTypeIdList.Remove(14);
foreach (int materialTypeId in materialTypeIdList)
{
RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault();
if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date == dateSearch.Date &&
rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1))
{
DataRow dr = dt.NewRow();
dr["ProductNo"] = productNo;
if (order != null)
{
dr["ArticleNo"] = order.ArticleNo;
dr["ShoeName"] = order.ShoeName;
dr["Quantity"] = order.Quantity;
dr["ETD"] = order.ETD;
}
dr["SupplierETD"] = rawMaterial.ETD;
dr["Remarks"] = rawMaterial.Remarks;
MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault();
if (materialType != null)
{
dr["Supplier"] = materialType.Name;
}
dt.Rows.Add(dr);
}
}
}
e.Result = dt;
}
