public JsonResult CreateVehicleInFactory(VehicleInFactoryMaster vehicleInFactoryMaster) { try { vehicleInFactoryMaster.VehicleInFactoryDetails = (IList<VehicleInFactoryDetail>)TempData["vehicleInFactoryDetails"]; if (vehicleInFactoryMaster.VehicleInFactoryDetails == null || vehicleInFactoryMaster.VehicleInFactoryDetails.Count == 0) { throw new BusinessException(@Resources.CUST.VehicleInFactoryMaster.VehicleInFactory_IpNoIsEmpty); } vehicleInFactoryMgr.CreateVehicleInFactory(vehicleInFactoryMaster); SaveSuccessMessage(Resources.CUST.VehicleInFactoryMaster.VehicleInFactory_Created); return Json(new { OrderNo = vehicleInFactoryMaster.OrderNo }); } catch (BusinessException ex) { SaveBusinessExceptionMessage(ex); } catch (Exception ex) { SaveErrorMessage(ex); } TempData["vehicleInFactoryDetails"] = vehicleInFactoryMaster.VehicleInFactoryDetails; return Json(null); }
public void CreateVehicleInFactory(VehicleInFactoryMaster vehicleInFactoryMaster) { string hql = "select distinct(r.Plant) from IpMaster as i,Region as r where i.PartyTo = r.Code and i.IpNo in (?"; IList<object> param = new List<object>(); param.Add(vehicleInFactoryMaster.VehicleInFactoryDetails[0].IpNo); for (int i = 0; i < vehicleInFactoryMaster.VehicleInFactoryDetails.Count(); i++) { hql += ",?"; param.Add(vehicleInFactoryMaster.VehicleInFactoryDetails[i].IpNo); } hql += ")"; IList<string> plantList = genericMgr.FindAll<string>(hql, param.ToArray()); if (plantList != null && plantList.Count > 1) { throw new BusinessException("送货单对应多个工厂"); } vehicleInFactoryMaster.Plant = plantList[0]; vehicleInFactoryMaster.Status = CodeMaster.VehicleInFactoryStatus.Submit; vehicleInFactoryMaster.OrderNo = numberControlMgr.GetVehicleInFactoryNo(vehicleInFactoryMaster); genericMgr.Create(vehicleInFactoryMaster); foreach (VehicleInFactoryDetail vehicleInFactoryDetail in vehicleInFactoryMaster.VehicleInFactoryDetails) { vehicleInFactoryDetail.OrderNo = vehicleInFactoryMaster.OrderNo; genericMgr.Create(vehicleInFactoryDetail); } }
public string CreateVehicleInFactory(VehicleInFactoryMaster vehicleInFactoryMaster) { try { vehicleInFactoryMaster.VehicleInFactoryDetails = (IList<VehicleInFactoryDetail>)TempData["vehicleInFactoryDetails"]; if (vehicleInFactoryMaster.VehicleInFactoryDetails == null || vehicleInFactoryMaster.VehicleInFactoryDetails.Count == 0) { throw new BusinessException(@Resources.CUST.VehicleInFactoryMaster.VehicleInFactory_IpNoIsEmpty); } vehicleInFactoryMgr.CreateVehicleInFactory(vehicleInFactoryMaster); SaveSuccessMessage(@Resources.CUST.VehicleInFactoryMaster.VehicleInFactory_Created); return vehicleInFactoryMaster.OrderNo; } catch (BusinessException ex) { Response.TrySkipIisCustomErrors = true; Response.StatusCode = 500; Response.Write(ex.GetMessages()[0].GetMessageString()); TempData["vehicleInFactoryDetails"] = vehicleInFactoryMaster.VehicleInFactoryDetails; return string.Empty; } }
public string GetVehicleInFactoryNo(VehicleInFactoryMaster vehicleInFactoryMaster) { SqlParameter[] parm = new SqlParameter[3]; parm[0] = new SqlParameter("@Plant", SqlDbType.VarChar, 50); parm[0].Value = vehicleInFactoryMaster.Plant; parm[1] = new SqlParameter("@Status", SqlDbType.Int); parm[1].Value = vehicleInFactoryMaster.Status; parm[2] = new SqlParameter("@VehNo", SqlDbType.VarChar, 100); parm[2].Direction = ParameterDirection.InputOutput; sqlDao.ExecuteStoredProcedure("USP_GetDocNo_VEH", parm); return parm[2].Value.ToString(); }
public void TryCloseVehicleInFactory(VehicleInFactoryMaster vehicleInFactoryMaster) { if (vehicleInFactoryMaster.Status != com.Sconit.CodeMaster.VehicleInFactoryStatus.Close) { this.genericMgr.FlushSession(); string hql = "select count(*) as counter from VehicleInFactoryDetail where OrderNo = ? and IsClose = ?"; long counter = genericMgr.FindAll<long>(hql, new object[] { vehicleInFactoryMaster.OrderNo, false })[0]; if (counter == 0) { vehicleInFactoryMaster.Status = com.Sconit.CodeMaster.VehicleInFactoryStatus.Close; vehicleInFactoryMaster.CloseDate = DateTime.Now; vehicleInFactoryMaster.CloseUserId = SecurityContextHolder.Get().Id; vehicleInFactoryMaster.CloseUserName = SecurityContextHolder.Get().FullName; genericMgr.Update(vehicleInFactoryMaster); } else if(vehicleInFactoryMaster.Status == com.Sconit.CodeMaster.VehicleInFactoryStatus.Submit) { vehicleInFactoryMaster.Status = com.Sconit.CodeMaster.VehicleInFactoryStatus.InProcess; genericMgr.Update(vehicleInFactoryMaster); } } }
private IList<VehicleInFactoryDetail> TryLoadVehicleInFactoryDetailList(VehicleInFactoryMaster vehicleInFactoryMaster) { if (!string.IsNullOrWhiteSpace(vehicleInFactoryMaster.OrderNo)) { if (vehicleInFactoryMaster.VehicleInFactoryDetails == null) { string hql = "from VehicleInFactoryDetail where OrderNo = ?"; vehicleInFactoryMaster.VehicleInFactoryDetails = this.genericMgr.FindAll<VehicleInFactoryDetail>(hql, vehicleInFactoryMaster.OrderNo); } return vehicleInFactoryMaster.VehicleInFactoryDetails; } else { return null; } }