public ActionResult AjaxStationEquipmentsRepairAdd(int StoragesInfoID, string StationNum, string SparePartsCode, string Resonance, string PhenomenalDescription, string HandlingVResults, bool UpRepair, string Reportor, string Repairer, string ReportDate, string FaultStartDate, string FaultEndDate)
{
try
{
using (InfoManageDataContext context = new InfoManageDataContext())
{
if (FaultEndDate == AllConsts.MAX_DATE_HOUR_MINUTE && UpRepair == false)
return Json("结束时间空！", JsonRequestBehavior.AllowGet);
StationEquipmentsRepair newStationEquipmentsMaintenance = new StationEquipmentsRepair();
newStationEquipmentsMaintenance.StoragesInfoID = StoragesInfoID;
newStationEquipmentsMaintenance.StationNum = StationNum;
newStationEquipmentsMaintenance.SparePartsCode = SparePartsCode;
newStationEquipmentsMaintenance.FaultStartDate = DateTime.ParseExact(FaultStartDate, AllConsts.HOUR_MINUTE, System.Globalization.DateTimeFormatInfo.CurrentInfo);
if (FaultEndDate == AllConsts.MAX_DATE_HOUR_MINUTE)
newStationEquipmentsMaintenance.FaultEndDate = DateTime.ParseExact(AllConsts.MAX_DATE_HOUR_MINUTE, AllConsts.HOUR_MINUTE, System.Globalization.DateTimeFormatInfo.CurrentInfo);
else
newStationEquipmentsMaintenance.FaultEndDate = DateTime.ParseExact(FaultEndDate, AllConsts.HOUR_MINUTE, System.Globalization.DateTimeFormatInfo.CurrentInfo);
newStationEquipmentsMaintenance.Resonance = Resonance;
newStationEquipmentsMaintenance.PhenomenalDescription = PhenomenalDescription;
newStationEquipmentsMaintenance.HandlingVResults = HandlingVResults;
newStationEquipmentsMaintenance.UpRepair = UpRepair;
newStationEquipmentsMaintenance.Reportor = Reportor;
newStationEquipmentsMaintenance.Repairer = Repairer;
newStationEquipmentsMaintenance.ReportDate = DateTime.Now;
if (newStationEquipmentsMaintenance.FaultEndDate < newStationEquipmentsMaintenance.FaultStartDate)
return Json("开始时间不能大于结束时间！", JsonRequestBehavior.AllowGet);
StationEquipmentsRepair result = context.StationEquipmentsRepairs.Where(c => c.StationNum.Equals(StationNum) && c.ReportDate.Year.Equals(newStationEquipmentsMaintenance.ReportDate.Year) && c.ReportDate.Month.Equals(newStationEquipmentsMaintenance.ReportDate.Month) && c.ReportDate.Day.Equals(newStationEquipmentsMaintenance.ReportDate.Day)).FirstOrDefault();
if (result == null)
{
context.StationEquipmentsRepairs.Add(newStationEquipmentsMaintenance);
if (newStationEquipmentsMaintenance.UpRepair)
{
StoragesInfo storage = context.StoragesInfos.Where(c => c.StoragesInfoID.Equals(StoragesInfoID)).FirstOrDefault();
UpRequest newRequest = new UpRequest();
newRequest.IsBack = false;
newRequest.BackIsRead = false;
newRequest.Requester = newStationEquipmentsMaintenance.Reportor;
newRequest.RequestText = storage.StoragesInfoName + "," + StationNum + ",<code>设备</code>编号:" + SparePartsCode + ",请求维修！";
newRequest.RequestDate = DateTime.Now;
newRequest.RebackDate = newRequest.RequestDate;
newRequest.ToUnit = (int)AllConsts.BAOZHANG_UNIT_NUM;
context.UpRequests.Add(newRequest);
}
context.SaveChanges();
}
else
{
result.Resonance = newStationEquipmentsMaintenance.Resonance;
result.PhenomenalDescription = newStationEquipmentsMaintenance.PhenomenalDescription;
result.HandlingVResults = newStationEquipmentsMaintenance.HandlingVResults;
result.UpRepair = newStationEquipmentsMaintenance.UpRepair;
result.FaultStartDate = newStationEquipmentsMaintenance.FaultStartDate;
result.FaultEndDate = newStationEquipmentsMaintenance.FaultEndDate;
result.ReportDate = newStationEquipmentsMaintenance.ReportDate;
result.Reportor = newStationEquipmentsMaintenance.Reportor;
result.Repairer = newStationEquipmentsMaintenance.Repairer;
if (newStationEquipmentsMaintenance.UpRepair)
{
StoragesInfo storage = context.StoragesInfos.Where(c => c.StoragesInfoID.Equals(StoragesInfoID)).FirstOrDefault();
UpRequest newRequest = new UpRequest();
newRequest.IsBack = false;
newRequest.BackIsRead = false;
newRequest.Requester = newStationEquipmentsMaintenance.Reportor;
newRequest.RequestText = storage.StoragesInfoName + "," + StationNum + ",<code>设备</code>编号:" + SparePartsCode + ",请求维修！";
newRequest.RequestDate = DateTime.Now;
newRequest.RebackDate = newRequest.RequestDate;
newRequest.ToUnit = (int)AllConsts.BAOZHANG_UNIT_NUM;
context.UpRequests.Add(newRequest);
}
context.SaveChanges();
}
return Json("OK", JsonRequestBehavior.AllowGet);
}
}
catch
{
return Json("NO", JsonRequestBehavior.AllowGet);
}
}
public ActionResult AjaxSetUpRequest(string Requester, string RequestText, int ToUnit)
{
try
{
using (InfoManageDataContext context = new InfoManageDataContext())
{
UpRequest newRequest = new UpRequest();
newRequest.IsBack = false;
newRequest.BackIsRead = false;
newRequest.Requester = Requester;
newRequest.RequestText = RequestText;
newRequest.RequestDate = DateTime.Now;
newRequest.RebackDate = newRequest.RequestDate;
newRequest.ToUnit = ToUnit;
UpRequest olodRequest = context.UpRequests.Where(c => c.Requester.Equals(Requester) && c.RequestDate.Year.Equals(DateTime.Now.Year) && c.RequestDate.Month.Equals(DateTime.Now.Month) && c.RequestDate.Day.Equals(DateTime.Now.Day) && c.RequestDate.Hour.Equals(DateTime.Now.Hour) && c.RequestDate.Minute.Equals(DateTime.Now.Minute)).FirstOrDefault();
if (olodRequest == null)
{
context.UpRequests.Add(newRequest);
}
else
{
olodRequest.Requester = newRequest.Requester;
olodRequest.RequestText = newRequest.RequestText;
olodRequest.ToUnit = newRequest.ToUnit;
}
context.SaveChanges();
return Json("OK", JsonRequestBehavior.AllowGet);
}
}
catch
{
return Json("NO", JsonRequestBehavior.AllowGet);
}
}