public ActionResult GetEquipmentInfo(string EqpCode)
{
string strEqpInfo = "";
EquipmentLayoutDetailEqpInfoViewModel model = null;
using (EquipmentLayoutDetailServiceClient client = new EquipmentLayoutDetailServiceClient())
{
MethodReturnResult <DataTable> result = client.GetEquipmentInfo(EqpCode);
if (result != null && result.Code == 0)
{
if (result.Data != null && result.Data.Rows.Count > 0)
{
model = new EquipmentLayoutDetailEqpInfoViewModel()
{
EquipmentCode = result.Data.Rows[0]["EQUIPMENT_CODE"].ToString(),
EquipmentName = result.Data.Rows[0]["EQUIPMENT_NAME"].ToString(),
EquipmentStateName = result.Data.Rows[0]["EQUIPMENT_STATE_NAME"].ToString(),
EquipmentStateMinutes = result.Data.Rows[0]["MinutesQty"].ToString(),
Creator = result.Data.Rows[0]["CREATOR"].ToString(),
CREATE_TIME = result.Data.Rows[0]["Create_Time"].ToString(),
Description = result.Data.Rows[0]["Description"].ToString()
};
return(PartialView("_InfoPartial", model));
}
}
else
{
ModelState.AddModelError("", result.Message);
}
}
return(PartialView("_InfoPartial"));
}
public ActionResult GetEQPInfo(string LayoutName)
{
using (EquipmentLayoutDetailServiceClient client = new EquipmentLayoutDetailServiceClient())
{
MethodReturnResult <DataTable> result = client.GetEQPInfo(LayoutName);
return(Json(JsonConvert.SerializeObject(result.Data), JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> Query(EquipmentLayoutDetailQueryViewModel model)
{
using (EquipmentLayoutServiceClient client = new EquipmentLayoutServiceClient())
{
MethodReturnResult <EquipmentLayout> result = await client.GetAsync(model.LayoutName ?? string.Empty);
ViewBag.EquipmentLayout = result.Data;
}
using (EquipmentLayoutDetailServiceClient client = new EquipmentLayoutDetailServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format(" Key.LayoutName = '{0}'"
, model.LayoutName)
};
MethodReturnResult <IList <EquipmentLayoutDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
using (EquipmentStateServiceClient client = new EquipmentStateServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false
};
MethodReturnResult <IList <EquipmentState> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.StateList = result.Data;
}
});
}
return(PartialView("_ListPartial", new EquipmentLayoutDetailViewModel()
{
LayoutName = model.LayoutName
}));
}
//
// GET: /FMM/EquipmentLayoutDetail/
public async Task <ActionResult> Index(string layoutName)
{
using (EquipmentLayoutServiceClient client = new EquipmentLayoutServiceClient())
{
MethodReturnResult <EquipmentLayout> result = await client.GetAsync(layoutName ?? string.Empty);
if (result.Code > 0 || result.Data == null)
{
return(RedirectToAction("Index", "EquipmentLayout"));
}
ViewBag.EquipmentLayout = result.Data;
}
using (EquipmentLayoutDetailServiceClient client = new EquipmentLayoutDetailServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format(" Key.LayoutName = '{0}'"
, layoutName)
};
MethodReturnResult <IList <EquipmentLayoutDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
if (Request.IsAjaxRequest())
{
return(PartialView("_ListPartial", new EquipmentLayoutDetailViewModel()
{
LayoutName = layoutName
}));
}
else
{
return(View(new EquipmentLayoutDetailQueryViewModel()
{
LayoutName = layoutName
}));
}
}
public async Task <ActionResult> Delete(string layoutName, string equipmentCode)
{
MethodReturnResult result = new MethodReturnResult();
using (EquipmentLayoutDetailServiceClient client = new EquipmentLayoutDetailServiceClient())
{
result = await client.DeleteAsync(new EquipmentLayoutDetailKey()
{
LayoutName = layoutName,
EquipmentCode = equipmentCode
});
if (result.Code == 0)
{
result.Message = string.Format(FMMResources.StringResource.EquipmentLayoutDetail_Delete_Success
, equipmentCode);
}
return(Json(result));
}
}
public async Task <ActionResult> Save(EquipmentLayoutDetailViewModel model)
{
MethodReturnResult result = new MethodReturnResult();
try
{
using (EquipmentLayoutDetailServiceClient client = new EquipmentLayoutDetailServiceClient())
{
EquipmentLayoutDetail obj = new EquipmentLayoutDetail()
{
Key = new EquipmentLayoutDetailKey()
{
LayoutName = model.LayoutName,
EquipmentCode = model.EquipmentCode
},
Height = model.Height,
Left = model.Left,
Top = model.Top,
Width = model.Width,
Description = model.Description,
Editor = User.Identity.Name,
EditTime = DateTime.Now
};
result = await client.AddAsync(obj);
if (result.Code == 0)
{
result.Message = string.Format(FMMResources.StringResource.EquipmentLayoutDetail_Save_Success);
}
}
}
catch (Exception ex)
{
result.Code = 1000;
result.Message = ex.Message;
result.Detail = ex.ToString();
}
return(Json(result));
}
public ActionResult GetParameByEquCode(string EqpCode)
{
using (EquipmentLayoutDetailServiceClient client = new EquipmentLayoutDetailServiceClient())
{
MethodReturnResult <DataTable> result = client.GetParameByEqpCode(EqpCode);
var l = from t in result.Data.AsEnumerable()
group t by new
{
t1 = t.Field <string>("EQUIPMENT_CODE"),
t2 = t.Field <string>("EQUIPMENT_NAME"),
t3 = t.Field <string>("LINE_CODE"),
t4 = t.Field <string>("ROUTE_OPERATION_NAME")
} into m
select new
{
EQUIPMENT_CODE = m.First().Field <string>("EQUIPMENT_CODE"),
EQUIPMENT_NAME = m.First().Field <string>("EQUIPMENT_NAME"),
//LINE_CODE = m.First().Field<string>("LINE_CODE"),
//ROUTE_OPERATION_NAME = m.First().Field<string>("ROUTE_OPERATION_NAME"),
};
return(Json(l, JsonRequestBehavior.AllowGet));
}
}
