public void BSO_Set(BSO.SaveData data) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@BSO_Id", SqlDbType.BigInt, data.Id); parameters.AddInputParameter("@StatusId", SqlDbType.BigInt, data.StatusId); parameters.AddInputParameter("@DeliveryPointId", SqlDbType.BigInt, data.DeliveryPointId); parameters.AddInputParameter("@StatusDate", SqlDbType.DateTime, data.StatusDate); parameters.AddInputParameter("@Comment", SqlDbType.NVarChar, data.Comment); parameters.AddInputParameter("@UserID", SqlDbType.BigInt, data.UserId); parameters.AddInputParameter("@ResponsibleID", SqlDbType.BigInt, data.ResponsibleID); parameters.AddInputParameter("@ChangeDate", SqlDbType.DateTime, DateTime.Now); Execute_StoredProcedure("BSO_Set", parameters); }
public BSO.SaveData GetBSOSaveData() { BSO.SaveData data = new BSO.SaveData(); data.Id = Id; data.TemporaryPolicyNumber = TemporaryPolicyNumber; data.PolicyPartyNumber = PolicyPartyNumber; data.StatusId = StatusId; data.StatusDate = StatusDate; data.DeliveryCenterId = DeliveryCenterId; data.DeliveryPointId = DeliveryPointId; data.VisitGroupId = VisitGroupId; data.Comment = Comment; data.UserId = UserId; data.ChangeDate = ChangeDate; return(data); }
public long BSO_Save(BSO.SaveData data) { List <SqlParameter> parameters = new List <SqlParameter>(); //parameters.AddInputParameter("@BSO_Id", SqlDbType.BigInt, data.Id); parameters.AddInputParameter("@TemporaryPolicyNumber", SqlDbType.NVarChar, data.TemporaryPolicyNumber); parameters.AddInputParameter("@PolicyPartyNumber", SqlDbType.NVarChar, data.PolicyPartyNumber); parameters.AddInputParameter("@StatusId", SqlDbType.BigInt, data.StatusId); parameters.AddInputParameter("@StatusDate", SqlDbType.DateTime, data.StatusDate); parameters.AddInputParameter("@DeliveryCenterId", SqlDbType.BigInt, data.DeliveryCenterId); parameters.AddInputParameter("@DeliveryPointId", SqlDbType.BigInt, data.DeliveryPointId); parameters.AddInputParameter("@VisitGroupId", SqlDbType.BigInt, data.VisitGroupId); parameters.AddInputParameter("@Comment", SqlDbType.NVarChar, data.Comment); parameters.AddInputParameter("@UserID", SqlDbType.BigInt, data.UserId); parameters.AddInputParameter("@ResponsibleID", SqlDbType.BigInt, data.ResponsibleID); parameters.AddInputParameter("@ChangeDate", SqlDbType.DateTime, DateTime.Now); SqlParameter BSO_ID = parameters.AddInputOutputParameter("@BSO_ID", SqlDbType.BigInt, data.Id); Execute_StoredProcedure("BSO_Save", parameters); return((long)BSO_ID.Value); }
public ActionResult MassChanges(BSOListModel bsoListModel) { long newStatus = (long)bsoListModel.SearchCriteriaModel.CurrentStatusId; long? newDelivery = bsoListModel.SearchCriteriaModel.NewDeliveryPointId; long? newResponsible = bsoListModel.SearchCriteriaModel.NewResponsibleID; DateTime?newStatusDate = bsoListModel.SearchCriteriaModel.NewStatusDate; long countPrintBso = 0; //Регистратор не может изменить 'Точку выдачи' и 'Ответственного' if (Role.Registrator.Id == Role.GetRealRole(CurrentUser).Id) { bsoListModel.SearchCriteriaModel.NewDeliveryPointId = CurrentUser.DeliveryPoint.Id; newDelivery = CurrentUser.DeliveryPoint.Id; bsoListModel.SearchCriteriaModel.NewResponsibleID = bsoListModel.SearchCriteriaModel.ResponsibleID; newResponsible = bsoListModel.SearchCriteriaModel.ResponsibleID; bsoListModel.SearchCriteriaModel.Messages.Add("В роли Регистратор, вы не можете изменить Ответственного или Точку Выдачи"); } //Ответственный не может изменить 'Ответственного' if (Role.ResponsibleBSO.Id == Role.GetRealRole(CurrentUser).Id && (bsoListModel.SearchCriteriaModel.NewResponsibleID != bsoListModel.SearchCriteriaModel.ResponsibleID)) { bsoListModel.SearchCriteriaModel.NewResponsibleID = bsoListModel.SearchCriteriaModel.ResponsibleID; newResponsible = bsoListModel.SearchCriteriaModel.ResponsibleID; bsoListModel.SearchCriteriaModel.Messages.Add("В роли Ответственного, вы не можете изменить 'Ответственного'"); } BSOSearchCriteria oldCriteria = bsoListModel.SearchCriteriaModel.GetBSOSearchCriteria(); bsoListModel.SearchCriteriaModel.Validate(new ModelValidationContext() { currenUser = CurrentUser }); bsoListModel.SearchCriteriaModel.IsSuccessfullySaved = bsoListModel.SearchCriteriaModel.IsValid(); if (Request.IsAjaxRequest()) { if (bsoListModel.SearchCriteriaModel.IsValid()) { BSOSearchCriteria criteria = bsoListModel.SearchCriteriaModel.GetBSOSearchCriteria(); DataPage <BSOInfo> listBso = bsoBusinessLogic.BSO_Find( criteria, new List <SortCriteria <BSOSortField> >(), new PageRequest() { PageNumber = bsoListModel.PageNumber, PageSize = int.MaxValue }); BSOSaveDataModel bsoSaveDataModel = new BSOSaveDataModel() { StatusId = newStatus, ResponsibleID = newResponsible, PolicyPartyNumber = bsoListModel.SearchCriteriaModel.PolicyPartyNumber, DeliveryPointId = newDelivery, UserId = CurrentUser.Id, Comment = string.Format("Массовая смена статуса") }; if (listBso.Count == 0) { bsoListModel.SearchCriteriaModel.IsSuccessfullySaved = false; } foreach (var b in listBso) { //если не указана новая точка выдачи, то сохраняем прежную //если указана - записываем новую if (newDelivery == null) { bsoSaveDataModel.DeliveryPointId = b.DeliveryPointId; } else { bsoSaveDataModel.DeliveryPointId = newDelivery; } //если не указан новый ответственный, то сохраняем прежнего //если указан - записываем нового if (newResponsible == null) { bsoSaveDataModel.ResponsibleID = b.ResponsibleID; } else { bsoSaveDataModel.ResponsibleID = newResponsible; } //если не указана новая дата статуса, то сохраняем прежную //если указан - записываем новую if (newStatusDate == null) { bsoSaveDataModel.StatusDate = b.StatusDate; } else { bsoSaveDataModel.StatusDate = newStatusDate; } bsoSaveDataModel.Id = b.Id; BSO.SaveData save = bsoSaveDataModel.GetBSOSaveData(); bsoBusinessLogic.BSO_Set(save); } countPrintBso = listBso.Count; } else { //nothing } } else { return(RedirectToAction("Index", "BSO")); } DataPage <BSOInfo> bsos = bsoBusinessLogic.BSO_Find( oldCriteria, new List <SortCriteria <BSOSortField> >(), new PageRequest() { PageNumber = bsoListModel.PageNumber, PageSize = bsoListModel.PageSize }); BSOListModel model = new BSOListModel() { Items = bsos.Data.Select(item => new BSOBaseInfoModel(item)), SearchCriteriaModel = new BSOSearchCriteriaModel(oldCriteria), PageNumber = bsoListModel.PageNumber, PageSize = bsoListModel.PageSize, TotalCount = bsos.TotalCount }; model.SearchCriteriaModel.Messages.AddRange(bsoListModel.SearchCriteriaModel.Messages); model.SearchCriteriaModel.CurrentStatusId = newStatus; model.SearchCriteriaModel.NewDeliveryPointId = newDelivery; model.SearchCriteriaModel.NewResponsibleID = newResponsible; model.SearchCriteriaModel.IsSuccessfullySaved = bsoListModel.SearchCriteriaModel.IsSuccessfullySaved; model.GetAvailableBSOStatus(bsoListModel.SearchCriteriaModel.StatusId, true); //печатаем отчет, если статус изменился: На точке if (model.SearchCriteriaModel.CurrentStatusId == (long)ListBSOStatusID.OnDelivery && model.SearchCriteriaModel.IsSuccessfullySaved.Value) { model.FlagPrintReport = countPrintBso; } else { model.FlagPrintReport = 0; } return(PartialView("MassChanges", model)); }
public long BSO_Save(BSO.SaveData data) { return(BSODao.Instance.BSO_Save(data)); }
public void BSO_Set(BSO.SaveData data) { BSODao.Instance.BSO_Set(data); }