public async Task AddServer(string serverAddress) { if (_serverAddresses.Exists(x => x == serverAddress)) { throw new Exception("Server already exists"); } _serverAddresses.Add(serverAddress); var session = _sessionFactory.Create(); await session.AddAsync(new Server(serverAddress)); }
public async Task InitSettings() { var session = _sessionFactory.Create(); var areSettingsExisting = session.Get <Settings>().Any(); if (!areSettingsExisting) { await session.AddAsync(new Settings(DEFAULT_PERIOD, isRunning : false)); } }
public IEnumerable <Category> Execute(IEnumerable <WcfHierarchicalTaxon> departments) { _session = SessionFactory.Create(ConnectionString); var sfCategories = departments.ToList(); var categories = new List <Category>(); try { foreach (var sfCategory in sfCategories) { var category = BuildCategory(sfCategory); if (category == null) { continue; } categories.Add(BuildCategory(sfCategory)); } BuildParentChildCategoryRelationships(categories, sfCategories); } finally { _session.Close(); } return(categories); }
public async Task <ActionResult <Session> > Create() { UserModel user = await userManager.GetUserAsync(HttpContext.User); if (user?.UserId == null) { return(StatusCode(StatusCodes.Status403Forbidden)); } Session session = SessionFactory.Create(user); await sessionService.Create(session); Game game = new Game { Id = session.Id }; Board board = BoardFactory.New(session.Id); GameOperations.AddPlayer(game, user.UserId); await gameService.Create(game); await boardService.Create(board); user.AddSession(session); await userManager.UpdateAsync(user); return(CreatedAtRoute("GetSession", new { id = session.Id }, session)); }
/// <summary> /// Persist categories and parent/child category relationships to Ucommerce /// </summary> /// <param name="categories">transformed categories</param> public void Send(IEnumerable <Category> categories) { var newCategories = categories.ToList(); _session = SessionFactory.Create(ConnectionString); try { WriteCategories(newCategories); } catch (Exception ex) { Log.Fatal($"A fatal exception occurred trying to write category data to Ucommerce: \n{ex}"); throw new MigrationException("A fatal exception occurred trying to write category data to Ucommerce", ex); } try { WriteCategoryRelationships(newCategories); } catch (Exception ex) { Log.Fatal($"A fatal exception occurred trying to write product definition data to Ucommerce: \n{ex}"); throw new MigrationException("A fatal exception occurred trying to write category data to Ucommerce", ex); } Log.Info("category migration done."); }
public override string SetNewData(XtraReport report, string defaultUrl) { // Save a report to the storage under a new URL. // The defaultUrl parameter contains the report display name specified by a user. if (CanSetData(defaultUrl)) { SetData(report, defaultUrl); } else { using (var session = SessionFactory.Create()) { MemoryStream ms = new MemoryStream(); report.SaveLayout(ms); var reportEntity = new ReportEntity(session) { Url = defaultUrl, Layout = ms.ToArray() }; session.CommitChanges(); } } return(defaultUrl); }
public override Dictionary <string, string> GetUrls() { // Get URLs and display names for all reports available in the storage using (var session = SessionFactory.Create()) { return(session.Query <ReportEntity>().ToDictionary <ReportEntity, string, string>(report => report.Url, report => report.Url)); } }
protected override void TestFilterByOneWithManyProducts_Impl() { using (var session = SessionFactory.Create()) { foreach (var num in Enumerable.Range(1, 3000)) { var product = new Product { Code = num.ToString(), Name = new MultiCulturalString(ru, "RU_" + num) .SetLocalizedString(en, "EN_" + num) }; session.Add(product); } } using (var session = SessionFactory.Create()) { Func <Product> actualProduct = () => session.AsQueryable <Product>() .SingleOrDefault(p => p.Name.ToString() == "RU_2017"); Assert.That(actualProduct, Is.Not.Null.After(100)); } }
public ActionResult Create(FormCollection collection, long id = 0) { var model = new TrainManagementItem { TrainManId = id }; TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); var trainMan = session.Load<TrainManagement>(id); if (trainMan == null) { FlashError("培训不存在,请联系管理员!"); return Close(); } model.Year = trainMan.Year; model.TrainManName = trainMan.Name; model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; ViewData.Model = model; if (session.Create(model)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return View(); } }
public override bool CanSetData(string url) { // Check if the URL is available in the report storage. using (var session = SessionFactory.Create()) { return(session.GetObjectByKey <ReportEntity>(url) != null); } }
public ActionResult Create(FormCollection collection) { var model = new SchoolSection(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); if (session.Load<SchoolSection>(m => m.Name.Equals(model.Name)) != null) { FlashWarn("校区{0}已经存在,创建失败。", model.Name); return View(model); } model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; ViewData.Model = model; if (session.Create(model)) { session.Commit(); FlashSuccess("创建校区[{0}]成功!", model.Name); return Close(); } session.Rollback(); FlashFailure("创建校区[{0}]失败!", model.Name); return View(); } }
public void Setup() { this.sessionFactory = SessionFactory.Create(); this.employeeNHibernate = new EmployeeNH(this.sessionFactory); this.BeginTransaction(); }
public ActionResult Create(FormCollection collection) { var model = new TrainManagement(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; ViewData.Model = model; if (session.Create(model)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return View(); } }
public IEnumerable <ProductDefinition> Execute(IEnumerable <ProductTypeViewModel> sfProductTypes) { _session = SessionFactory.Create(ConnectionString); var productDefinitionList = new List <ProductDefinition>(); try { foreach (var sfProductType in sfProductTypes) { var definition = _session.Query <ProductDefinition>() .FirstOrDefault(a => a.Name == sfProductType.Title); if (definition != null) { continue; } var newDefinition = (new ProductDefinition() { Name = sfProductType.Title }); AddInventoryDefinitionField(newDefinition); AddCustomDefinitionFields(newDefinition, sfProductType); productDefinitionList.Add(newDefinition); } } finally { _session.Close(); } return(productDefinitionList); }
public ActionResult Create(FormCollection collection) { var model = new Role(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { if (session.Load<Role>(m => m.Name.Equals(model.Name)) != null) { FlashFailure("角色名称[{0}]已经存在,创建失败!", model.Name); return View(model); } model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; ViewData.Model = model; if (session.Create(model)) { FlashSuccess("角色[{0}]创建成功", model.Name); return Close(); } FlashFailure("创建角色[{0}]失败!", model.Name); return View(model); } }
public override string SetNewData(DevExpress.XtraReports.UI.XtraReport report, string defaultUrl) { // Save a report to the storage under a new URL. // The defaultUrl parameter contains the report display name specified by a user. if (CanSetData(defaultUrl)) { SetData(report, defaultUrl); } else { using (var session = SessionFactory.Create()) { MemoryStream ms = new MemoryStream(); report.SaveLayout(ms); var reportEntity = new TSOUTERREPORT(session) { Url = defaultUrl }; this.SaveToFile(reportEntity.Url, ms); session.CommitChanges(); } } return(defaultUrl); }
public ActionResult Create(FormCollection collection) { var model = new SchoolDepartment(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { //model.ParentId //model.LeaderId model.LeaderName = model.LeaderId == 0 ? "" : session.Load<User>(model.LeaderId).Realname; if (session.Load<SchoolDepartment>(m => m.Name.Equals(model.Name)) != null) { FlashFailure("部门[{0}]已经存在", model.Name); return View(model); } model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; ViewData.Model = model; if (session.Create(model)) { FlashSuccess("部门[{0}]创建成功", model.Name); return Close(); } FlashFailure("创建部门[{0}]失败!", model.Name); return View(); } }
public ScannedServersService(SessionFactory sessionFactory) { _sessionFactory = sessionFactory; var session = sessionFactory.Create(); _serverAddresses = session.Get <Server>().Select(x => x.Address).ToList(); }
public override byte[] GetData(string url) { // Get the report data from the storage. using (var session = SessionFactory.Create()) { var report = session.GetObjectByKey <ReportEntity>(url); return(report.Layout); } }
public List <GeneralType> GetPackageType() { using (ISession session = SessionFactory.Create()) { List <PackageTypeModel> packageTypeModel = RepositoriyFactory.GetRepo <IPackageTypeRepository>(session).GetPackageTypes().Where(x => x.IsHandlingUnitOnly == true).ToList(); return(GeneralTypeMapper.MapPackageToGeneralTypes(packageTypeModel)); } }
public List <Accessorial> GetNonCommercialAccessorials() { using (ISession session = SessionFactory.Create()) { List <AccessorialModel> accessorialModels = RepositoriyFactory.GetRepo <IAccessorialRepository>(session).GetNonSpecificAccessorials(); return(AccessorialMapper.MapToAccessorials(accessorialModels)); } }
public List <DisabledDate> GetDisabledDates() { using (ISession session = SessionFactory.Create()) { List <HolidayModel> holidays = RepositoriyFactory.GetRepo <IHolidayRepository>(session).GetHolidays(); return(HolidayMapper.MapToDisabledDates(holidays)); } }
public List <Accessorial> GetDestinationSiteAccessorials() { using (ISession session = SessionFactory.Create()) { List <AccessorialModel> accessorialModels = RepositoriyFactory.GetRepo <IAccessorialRepository>(session).GetDestinationSiteAccessorials(); return(AccessorialMapper.MapToAccessorials(accessorialModels)); } }
public List <GeneralType> GetFreightClass() { using (ISession session = SessionFactory.Create()) { List <FreightClassModel> freightClasses = RepositoriyFactory.GetRepo <IFreightClassRepository>(session).FreightClasses(); return(GeneralTypeMapper.MapFreightClassesToGeneralTypes(freightClasses)); } }
public TSOUTERREPORT GetObjectByUrl(string url) { using (var session = SessionFactory.Create()) { var reports = session.Query <TSOUTERREPORT>() .Where(e => e.Url == url).FirstOrDefault(); return(reports); } }
public FileProviderExtension() { ServerSettings serverSettings = AppGroupSettings.GetServerSettings(); this.Session = SessionFactory.Create(serverSettings); this.LocalStorage = new LocalStorage(); this.LocationMapper = new LocationMapper(serverSettings.ServerUri, this.LocalStorage.StorageRootPath); this.StorageManager = new StorageManager(this.LocationMapper, this.Session, this.LocalStorage); }
private static void ConfigAuthSession(BaseUser user, WeatherClientType clientType) { // clean all existing Cache //Mobizone.TSIC.Cache.DataCache.RemoveAllCacheBySession(); var session = SessionFactory.Create <IBLSessionPersisiter>(); var clientSession = SessionFactory.Create <IClientSessionPersisiter>(); session.RemoveSession(); clientSession.RemoveSession(); IBaseUserBL bl = BLLFactory.Create <IBaseUserBL>(); session.UserID = user.ID; session.BaseEmployee = user.BASE_EMPLOYEE; session.ProdType = 1; //登录成功默认PND //var division = BLLFactory.Create<IBaseDictBL>().GetItemNameByCached(BaseDictType.DictTypeDivision,user.BaseEmployee.DIVISION); //if(division == BaseDictType.DivisionTypeMND) { // session.ProdType = 2; //} clientSession.ClientType = clientType; //session.UserType = user.UserType; session.Roles = ExpendRole(bl.GetUserRoles(user.ID)); // load all the role //// Data Auth //var orgBL = BLLFactory.Create<IBaseOrgBL>(); ISet <decimal> authOrg = new HashSet <decimal>(); //var splitDate = DateTime.Parse("2012-03-07 03:00:00"); //if(user.Updated == null || user.Updated < splitDate) { // // 老式的ETMS授权 // authOrg = orgBL.FilterAbtCityOrgByCached(user.OrgAuth); //} else { // authOrg = orgBL.ExpendOrgToAbtCityByCached(user.OrgAuth); //} //var userOrg = user.BaseEmployee.OrgID; //if(null != userOrg) { // authOrg.Add(userOrg.Value); // //展开到城市一级 // session.DataCenterCityAuth = orgBL.ExpendOrgToCenterCityByCached(userOrg.Value); //} //// Data Auth: PGS 自动授权 所有PG所在雅培城市 //if(session.Roles.Contains(WeatherRole.PGM_PGS)) { // var empBL = BLLFactory.Create<IBaseEmployeeBL>(); // var orgs = empBL.GetChildAbtCityBind(session.BaseEmployee.ID); // authOrg.AddAll(orgs); //} session.DataOrgAuth = authOrg; }
public CustomerInfo GetCustomerInfo(String email) { using (ISession session = SessionFactory.Create()) { UserPersonalInfoModel userPersonalInfoModel = RepositoriyFactory.GetRepo <IUserPersonalInfoRepositoriy>(session).GetUserPersonalInfo(email); CustomerUserModel customerUser = RepositoriyFactory.GetRepo <ICustomerUserRepository>(session).GetCustomerUser(userPersonalInfoModel.UserPersonalInfoId); CustomerModel customer = RepositoriyFactory.GetRepo <ICustomerRepository>(session).GetCustomer(customerUser.CustomerId); return(CustomerMapper.MapToCustomerInfo(customer)); } }
public ActionResult Delete(string url) { using (var session = SessionFactory.Create()) { var report = session.GetObjectByKey <ReportEntity>(url); session.Delete(report); session.CommitChanges(); } return(Index()); }
protected void AndGivenAValidSessionFactory() { _sessionFactory = new SessionFactory(_conString, _config); using (var session = _sessionFactory.Create()) { // test connection session.Dispose(); } }
public override byte[] GetData(string url) { // Get the report data from the storage. using (var session = SessionFactory.Create()) { MemoryStream vs = this.ReadFromFile(url); return(vs.ToArray()); //return report.Layout; } }
public bool RemoveSession() { var session = SessionFactory.Create <IBLSessionPersisiter>(); session.RemoveSession(); var clientSession = SessionFactory.Create <IClientSessionPersisiter>(); clientSession.RemoveSession(); return(true); }
public override void OnException(HttpActionExecutedContext actionExecutedContext) { if (actionExecutedContext.Exception == null) { return; } HttpContext.Current.Response.TrySkipIisCustomErrors = true; var exception = actionExecutedContext.Exception; try { var clientSession = SessionFactory.Create <IClientSessionPersisiter>(); var session = SessionFactory.Create <IBLSessionPersisiter>(); string info = clientSession.ClientType.ToString() + ";" + clientSession.ClientVersion; if (session.BaseEmployee != null) { info += ";" + session.BaseEmployee.ID; } log.Fatal(string.Format("ErrorInfo={{{2}}}\nurl={{{0}}}\n body={{{1}}}", actionExecutedContext.Request.RequestUri, actionExecutedContext.Request.Content.ReadAsStringAsync().Result, info)); } catch { } log.Fatal(exception); if (exception.InnerException != null) { exception = exception.InnerException; log.Fatal(exception.InnerException); } var controller = actionExecutedContext.ActionContext.ControllerContext.Controller as TSICAppJsonAPIController; if (controller != null) { actionExecutedContext.Response = actionExecutedContext.Request.CreateResponse(HttpStatusCode.InternalServerError, new AppJsonResponse() { Meta = new JsonAsyncObjectMetaData() { Type = "ExceptionModel", Uri = "Exception", }, Data = new ExceptionModel() { Message = exception.Message, Type = exception.GetType().FullName, } }); } else { actionExecutedContext.Response = actionExecutedContext.Request.CreateResponse( HttpStatusCode.InternalServerError, new ErrorList { Status = "Error", Message = exception.Message }); } }
/// <summary> /// Initializes the message context. /// </summary> /// <param name="messageContext">The message context.</param> /// <param name="args">The args.</param> /// <param name="currentSession">The current session.</param> private static void InitializeContext(IMessageContext messageContext, OutputGatewayEventHandlerArgs <TMessage, MessageHeader> args, Session currentSession) { messageContext.MessageInfo.Body = args.Message; messageContext.MessageInfo.Header = (MessageHeader)args.Header.Clone(); messageContext.MessageInfo.CurrentSession = currentSession; messageContext.MessageInfo.CurrentCallContext = args.Header.CallContext != null ? (Session)args.Header.CallContext.Clone() : SessionFactory.Create(); }
public void TestExtendedSettings() { IApplication app = new NullApplication(); IMessageStoreFactory storeFactory = new MemoryStoreFactory(); SessionFactory factory = new SessionFactory(app, storeFactory); SessionID sessionID = new SessionID("FIX.4.2", "SENDER", "TARGET"); Dictionary settings = new Dictionary(); settings.SetString(SessionSettings.USE_DATA_DICTIONARY, "N"); settings.SetString(SessionSettings.SEND_REDUNDANT_RESENDREQUESTS, "Y"); settings.SetString(SessionSettings.RESEND_SESSION_LEVEL_REJECTS, "Y"); settings.SetString(SessionSettings.MILLISECONDS_IN_TIMESTAMP, "Y"); settings.SetString(SessionSettings.CONNECTION_TYPE, "initiator"); settings.SetString(SessionSettings.HEARTBTINT, "30"); settings.SetString(SessionSettings.START_TIME, "12:00:00"); settings.SetString(SessionSettings.END_TIME, "12:00:00"); settings.SetString(SessionSettings.ENABLE_LAST_MSG_SEQ_NUM_PROCESSED, "Y"); settings.SetString(SessionSettings.MAX_MESSAGES_IN_RESEND_REQUEST, "2500"); settings.SetString(SessionSettings.SEND_LOGOUT_BEFORE_TIMEOUT_DISCONNECT, "Y"); settings.SetString(SessionSettings.IGNORE_POSSDUP_RESEND_REQUESTS, "Y"); Session session = factory.Create(sessionID, settings); Assert.That(session.SendRedundantResendRequests); Assert.That(session.ResendSessionLevelRejects); Assert.That(session.MillisecondsInTimeStamp); settings.SetString(SessionSettings.SEND_REDUNDANT_RESENDREQUESTS, "N"); settings.SetString(SessionSettings.RESEND_SESSION_LEVEL_REJECTS, "N"); settings.SetString(SessionSettings.MILLISECONDS_IN_TIMESTAMP, "N"); session = factory.Create(sessionID, settings); Assert.That(!session.SendRedundantResendRequests); Assert.That(!session.ResendSessionLevelRejects); Assert.That(!session.MillisecondsInTimeStamp); Assert.That(session.EnableLastMsgSeqNumProcessed); Assert.That(session.MaxMessagesInResendRequest, Is.EqualTo(2500)); Assert.That(session.SendLogoutBeforeTimeoutDisconnect); Assert.That(session.IgnorePossDupResendRequests); }
public static void WriteLog(ControllerContext controllerContext, ViewDataDictionary viewData) { var cc = controllerContext.Controller.ControllerContext; var category = GetCategory(controllerContext); var title = GetTitle(controllerContext); var log = new ActionLog { Controller = cc.RouteData.GetRequiredString("controller"), Action = cc.RouteData.GetRequiredString("action"), Url = controllerContext.HttpContext.Request.Path, CreatedAt = DateTime.Now, CreatedBy = "SYSTEM", Address = controllerContext.HttpContext.Request.UserHostAddress, Actor = TryGetUserName(controllerContext), Method = controllerContext.HttpContext.Request.HttpMethod, Category = GetCategory(controllerContext), Title = title.Equals(category) ? "查询" : title, Result = TryGetResult(controllerContext), ModelId = cc.RouteData.Values.ContainsKey("id") ? cc.RouteData.GetRequiredString("id") : null, Description = viewData.ContainsKey(Const.ToLogMessage) ? viewData[Const.ToLogMessage].ToString() : null }; if (log.Description == null && viewData.ContainsKey(Const.ToLogModel)) { // 取得描述 var model = viewData.ContainsKey(Const.ToLogModel) ? viewData[Const.ToLogModel] : viewData.Model; if (model != null) { if (!model.GetType().IsGenericType) { log.Description = model.Print(); } else { var objs = (IEnumerable<object>)model; log.Description = string.Join(";" + Environment.NewLine, objs.Select(m => m.Print())); } } } using (var ds = new SessionFactory().OpenSession()) { if (!ds.Create(log)) { Log.Error("记录日志失败:{0}", log.ToString()); } } }
public ActionResult Create(FormCollection collection) { var model = new TrainNeed(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); var dept = new Criteria<Department>(session) .AndIn<User>(m => m.Id, n => n.DepartmentId, m => m.Code.Equals(CurrentAccountNo)).Load(); var models = session.Find<TrainNeed>(m => !m.IsCollected && m.Status.Equals(TrainNeedStatus.已提交部门负责人) && m.DeptId == dept.Id && m.Type.Equals(TrainNeedType.员工)); if (models == null || !models.Any()) { FlashWarn("没有未汇总的需求!"); return Close(); } foreach (var trainNeed in models) { trainNeed.IsCollected = true; } model.DeptId = dept != null ? dept.Id : 0; model.Dept = dept != null ? dept.Name : null; model.IsCollected = false; model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; model.Type = TrainNeedType.部门; ViewData.Model = model; ViewData["StaffNeeds"] = models; var exist = session.Load<TrainNeed>(m => m.Type.Equals(TrainNeedType.部门) && m.DeptId.Equals(model.DeptId) && m.Year.Equals(model.Year)); if (exist != null) { ModelState.AddModelError("Year", "本部门该年度部门培训需求已经存在!"); return View(model); } if (session.Create(model) && session.Update(models)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return View(); } }
public ActionResult Create(FormCollection collection) { var model = new TrainNeed(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); var models = session.Find<TrainNeed>(m => !m.IsCollected && m.Status.Equals(TrainNeedStatus.已提交培训部门) && m.Type.Equals(TrainNeedType.部门)); if (models == null || !models.Any()) { FlashWarn("没有未汇总的需求!"); return Close(); } foreach (var trainNeed in models) { trainNeed.IsCollected = true; } model.IsCollected = false; model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; model.Type = TrainNeedType.公司; ViewData["StaffNeeds"] = models; ViewData.Model = model; var exist = session.Load<TrainNeed>(m => m.Type.Equals(TrainNeedType.公司) && m.Year.Equals(model.Year)); if (exist != null) { ModelState.AddModelError("Year", "该年度公司培训需求已经存在!"); return View(model); } if (session.Create(model) && session.Update(models)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return View(); } }
public ActionResult Create(FormCollection collection) { var model = new InstitutionManagement { UploadPerson = CurrentAccountNo.GetName() }; TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { for (var i = 0; i < Request.Files.Count; i++) { // 检查文件后缀名 var file = Request.Files[i]; if (file == null || file.ContentLength <= 0) continue; var ext = Path.GetExtension(file.FileName); if (string.IsNullOrEmpty(ext) || (!ext.Equals(".doc") && !ext.Equals(".docx"))) { FlashFailure("文件 '{0}' 后缀名不符合要求 (doc,docx)", file.FileName); return View(); } var uppath = Server.MapPath("~/upload/"); var item = new UploadFile(); item.SaveFile(file, uppath, CurrentAccountNo); item.CreateHtml(); model.FileId = item.Id; model.FileName = file.FileName; } session.BeginTransaction(); model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; ViewData.Model = model; if (session.Create(model)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return View(); } }
public ActionResult Create(FormCollection collection) { var model = new TrainNeed(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); model.StaffCode = CurrentAccountNo; model.StaffName = CurrentAccountNo.GetName(); var dept = new Criteria<Department>(session) .AndIn<User>(m => m.Id, n => n.DepartmentId, m => m.Code.Equals(CurrentAccountNo)).Load(); model.DeptId = dept != null ? dept.Id : 0; model.Dept = dept != null ? dept.Name : null; model.IsCollected = false; model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; model.Type = TrainNeedType.员工; model.Status = ""; var exist = session.Load<TrainNeed>(m => m.Type.Equals(TrainNeedType.员工) && m.DeptId.Equals(model.DeptId) && m.Year.Equals(model.Year) && m.StaffCode.Equals(CurrentAccountNo)); if (exist != null) { ModelState.AddModelError("Year", "您该年度需求已经存在!"); return View(model); } ViewData.Model = model; if (session.Create(model)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return View(); } }
public ActionResult Create(FormCollection collection) { var view = new TrainExperienceView(); TryUpdateModel(view, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(view); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); var model = new TrainExperience { CreatedAt = DateTime.Now, CreatedBy = CurrentAccountNo, TrainManItemId = view.TrainManItemId, Experience = view.Experience, Status = "", ApproveStatus = "" }; if (null != session.Load<TrainExperience>(m => m.TrainManItemId.Equals(model.TrainManItemId))) { ModelState.AddModelError("TrainManName", "该培训心得已经存在!"); return View(view); } ViewData.Model = view; if (session.Create(model)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return View(); } }
public new ActionResult User(FormCollection collection, long[] ids) { if (ids.Length == 0) { FlashInfo("请选择要查看用户的角色。"); return Close(); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); var roles = session.Find<Role>(m => m.Id.In(ids)); if (roles == null || roles.Count == 0) { FlashInfo("请选择要查看用户的角色。"); return Close(); } ViewData["roleName"] = string.Join(",", roles.Select(m => m.Name)); var roleIds = roles.Select(m => m.Id).ToList(); var userIds = Request.Params["select_id"].ToLongArray(); session.Delete<AccountRoleRef>(m => m.RoleId.In(ids)); if (userIds.Length > 0) { var q = new Criteria<Account>(session) .AndIn<User>(m => m.Name, n => n.Code, n => n.Id.In(userIds)) .Select(m => m.Id); var accountIds = q.To<long>(); if (accountIds.Count < userIds.Length) { FlashWarn("有{0}个用户没有激活,请全部激活后再操作。", userIds.Length - accountIds.Count); return Close(); } var toCreateItems = (from accountId in accountIds from roleId in roleIds select new AccountRoleRef { AccountId = accountId, RoleId = roleId, CreatedAt = DateTime.Now, CreatedBy = CurrentAccountNo }).ToArray(); if (toCreateItems.Length > 0) { if (session.Create(toCreateItems)) { session.Commit(); FlashSuccess("给角色分配用户成功!"); return Close(); } } session.Rollback(); FlashFailure("给角色分配用户失败!"); return User(ids); } session.Commit(); FlashSuccess("取消角色全部用户成功!"); return Close(); } }
public ActionResult Pintask(FormCollection collection, long[] ids) { if (ids.Length == 0) { FlashInfo("请选择要查看用户的角色。"); return Close(); } using (var session = new SessionFactory().OpenSession()) { var roles = session.Find<Role>(m => m.Id.In(ids)); if (roles == null || roles.Count == 0) { FlashInfo("请选择要查看用户的角色。"); return Close(); } ViewData["roleName"] = string.Join(",", roles.Select(m => m.Name)); var roleIds = roles.Select(m => m.Id).ToList(); var navIds = Request.Params["select_id"].ToLongArray(); session.Delete<AccountNavigationRef>(m => m.Type.Equals(NavigationPriviledge.RoleType) && m.OwnerId.In(ids)); var toCreateItems = (from navId in navIds from roleId in roleIds select new AccountNavigationRef { OwnerId = roleId, NavigationId = navId, Type = AccountNavigationRef.RoleType, CreatedAt = DateTime.Now, CreatedBy = CurrentAccountNo }).ToArray(); if (toCreateItems.Length > 0) { if (session.Create(toCreateItems)) { FlashSuccess("给角色设置常用功能成功!"); return Close(); } } FlashFailure("给角色设置常用功能失败!"); return Pintask(ids); } }
//public bool AddOrganization(Organization organization) //{ // if (organization == null || organization.Id <= 0) return false; // if (Id <= 0) return false; // var q = new Criteria<AccountOrganizationRef>().Where(m => m.AccountId.Equals(Id) && m.OrganizationId.Equals(organization.Id)); // if (q.Count() > 0) return true; // var r = new AccountOrganizationRef { AccountId = Id, OrganizationId = organization.Id }; // var db = new SessionFactory().OpenSession(); // return db.Create(r); //} public bool AddRole(Role role) { if (role == null || role.Id <= 0) return false; if (Id <= 0) return false; Criteria<AccountRoleRef> q = new Criteria<AccountRoleRef>().Where(m => m.AccountId.Equals(Id) && m.RoleId.Equals(role.Id)); if (q.Count() > 0) return true; Session db = new SessionFactory().OpenSession(); var r = new AccountRoleRef { AccountId = Id, RoleId = role.Id }; return db.Create(r); }
public ActionResult Exam(FormCollection collection, long[] ids) { if (ids.Length == 0) { FlashWarn("考试不存在!请联系管理员!"); return Close(); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); var trainManagementItem = session.Load<TrainManagementItem>(ids[0]); if (trainManagementItem == null) { session.Rollback(); FlashWarn("培训明细不存在!请联系管理员!"); return Close(); } var exam = session.Load<Exam>(m => m.TrainManId == trainManagementItem.TrainManId); if (exam == null) { session.Rollback(); FlashWarn("考试不存在!请联系管理员!"); return Close(); } ViewData["ExamContent"] = exam.HtmlContent; var models = session.Find<Question>(m => m.ExamId == exam.Id); if (models == null || !models.Any()) { session.Rollback(); FlashWarn("考试题目未设置!"); return Close(); } var answerList = new List<ExamAnswer>(); foreach (var question in models) { var answerStr = GetDbQueryPara(question.Id + ""); var answer = new ExamAnswer { CreatedAt = DateTime.Now, CreatedBy = "SYSTEM", Answer = answerStr, QuestionId = question.Id, StaffCode = CurrentAccountNo, StaffName = CurrentAccountNo.GetName(), TrainManagementItemId = trainManagementItem.Id }; if(question.Type.Contains("选")) { answer.Score = answer.Answer.Replace(",", "").ToUpper().Equals(question.RightAnswer.ToUpper()) ? question.Value : 0; } answerList.Add(answer); } trainManagementItem.ExamStatus = ExamStatusConst.已考试; trainManagementItem.UpdatedAt = DateTime.Now; trainManagementItem.UpdatedBy = "SYSTEM"; if (session.Update(trainManagementItem) && session.Create(answerList)) { session.Commit(); Response.Write("<script>window.close()</script>"); return Close(); } session.Rollback(); FlashError("提交试卷不成功,请联系管理员!"); return View(models); } }
//#region 通用控制器模块 //public ActionResult CommonCreate<TModel>(FormCollection collection, // Func<Session, bool> onTouch = null, // Func<TModel, Session, bool> beforePersistance = null, // Func<TModel, Session, bool> afterPersistance = null // ) where TModel : class, new() //{ // using (var session = new SessionFactory().OpenSession()) // { // try // { // session.BeginTransaction(); // if (onTouch != null && !onTouch(session)) // { // return Close(); // } // var model = new TModel(); // TryUpdateModel(model, collection); // if (!ModelState.IsValid) // { // // ReSharper disable Mvc.ViewNotResolved // return View(model); // // ReSharper restore Mvc.ViewNotResolved // } // if (beforePersistance != null && !beforePersistance(model, session)) // { // return Close(); // } // if (typeof(TModel).GetInterface("IDboFollow") == typeof(IDboFollow)) // { // model.SetPropertyValue("CreatedAt", DateTime.Now); // model.SetPropertyValue("CreatedBy", CurrentAccountNo); // } // if (session.Create(model)) // { // if (afterPersistance == null || afterPersistance(model, session)) // { // session.Commit(); // FlashSuccess("{0}创建成功", SchemaHelper.GetObjectName<TModel>()); // return Close(); // } // } // session.Rollback(); // FlashFailure("创建{0}失败!", SchemaHelper.GetObjectName<TModel>()); // return View(model); // } // catch (Exception ex) // { // session.Rollback(); // FlashError("发生错误:{0}", ex.Message); // return View(); // } // } //} //#endregion protected void CreateLog(string result = null, string description = null) { using (var session = new SessionFactory().OpenSession()) { var log = new ActionLog { Controller = ControllerName, Action = ActionName, ModelId = ModelId, UserId = CurrentAccountId, Url = Url, CreatedAt = DateTime.Now, CreatedBy = "SYSTEM", Address = Request.UserHostAddress, Actor = CurrentAccountNo, Category = GetCategory(), Title = GetTitle(), Result = result, Description = description }; if (!session.Create(log)) { Log.Error("记录日志失败:{0}", log.ToString()); } } }
public ActionResult Create(FormCollection collection) { var model = new Record(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; model.Time = DateTime.Now; model.Undertaker = CurrentAccountNo.GetName(); var dept = new Criteria<Department>(session) .AndIn<User>(m => m.Id, n => n.DepartmentId, m => m.Code.Equals(CurrentAccountNo)).Load(); model.DeptId = dept != null ? dept.Id : 0; model.Dept = dept != null ? dept.Name : null; model.State = ""; model.ApproveState = ""; ViewData.Model = model; if (session.Create(model)) { session.Commit(); FlashSuccess("创建记录成功!"); return Close(); } session.Rollback(); FlashFailure("创建记录失败!"); return Close(); } }
public ActionResult AddNavigation() { string url = Request.Params["nav"]; string handleId = Request.Params["handleId"]; try { CurrentAccountId = UserActivity.UserNameIdMapHolder.GetId(CurrentAccountNo); } catch (Exception e) { Log.Error("系统获取用户ID失败,错误信息:{0}", e.Message); } using (var session = new SessionFactory().OpenSession()) { const string sql = "SELECT id FROM `navigations` WHERE `id` IN ( SELECT `navigation_id` FROM `navigation_priviledges` WHERE (`flag` = 1 AND `owner_id` IN (SELECT `role_id` FROM `account_role_refs` WHERE `account_id` IN ( SELECT `id` FROM `accounts` WHERE `name` = '{0}'))) OR (`flag` = 2 AND `owner_id` IN ( SELECT `id` FROM `accounts` WHERE `name` = '{0}'))) AND `url` = '{1}'"; var exceptId = session.ExecuteScalar<string>(string.Format(sql, CurrentAccountNo, url.Replace("'", "''"))).TryToLong(); if (!exceptId.HasValue) { return new JsonResult { Data = new { status = 100, message = "你未被授权,不能添加该项快捷操作!", handleId }, ContentEncoding = Encoding.UTF8 }; } var item = session.Load<AccountNavigationRef>( m => m.Type.Equals(2) && m.OwnerId.Equals(CurrentAccountId) && m.NavigationId.Equals(exceptId)); if (item != null) { return new JsonResult { Data = new { status = 100, message = "你已添加该项快捷操作!", handleId }, ContentEncoding = Encoding.UTF8 }; } item = new AccountNavigationRef { Type = 2, OwnerId = CurrentAccountId, NavigationId = exceptId.GetValueOrDefault(0), CreatedAt = DateTime.Now, CreatedBy = CurrentAccountNo }; if (session.Create(item)) { return new JsonResult { Data = new { status = 200, message = "增加成功!", handleId }, ContentEncoding = Encoding.UTF8 }; } return new JsonResult { Data = new { status = 100, message = "操作失败!", handleId }, ContentEncoding = Encoding.UTF8 }; } }
public ActionResult Create(FormCollection collection) { var model = new User(); TryUpdateModel(model, collection.ToValueProvider()); if (!ModelState.IsValid) { return View(model); } if (model.Name.Equals("root", StringComparison.CurrentCultureIgnoreCase)) { ModelState.AddModelError("Name", "该名称已被使用"); return View(model); } using (var session = new SessionFactory().OpenSession()) { session.BeginTransaction(); if (session.Load<User>(m => m.Name.Equals(model.Name)) != null) { FlashWarn("用户{0}已经存在,创建失败。", model.Name); return View(model); } if (session.Load<User>(m => m.Code.Equals(model.Code)) != null) { FlashWarn("工号{0}已经存在,创建失败。", model.Code); return View(model); } model.IsActive = false; model.CreatedAt = DateTime.Now; model.CreatedBy = CurrentAccountNo; ViewData.Model = model; if (session.Create(model) && model.InitAccount(session, CurrentAccountNo)) { session.Commit(); UserActivity.UserNameIdMapHolder.Reset(); FlashSuccess("创建用户[{0}]成功!", model.Name); return Close(); } session.Rollback(); FlashFailure("创建用户[{0}]失败!", model.Name); return View(); } }