/// <summary> /// 记录订单,订单留空,会自动生成,牛B吧 /// </summary> /// <param name="bookBuy"></param> /// <returns></returns> public int AddBookBuy(Res_BookBuy bookBuy) { if (string.IsNullOrEmpty(bookBuy.BookBuyCode)) { bookBuy.BookBuyCode = GetMaxBookBuyCode(bookBuy.TenantId); } return(_dataAccess.AddEntity(bookBuy)); }
public int AddSurveyInfo(SurveyInfo userSurveyInfo) { _dataAccess.AddEntity(userSurveyInfo); foreach (var user in userSurveyInfo.EvalUsers) { user.SurveyId = userSurveyInfo.SurveyId; } _dataAccess.AddEntities(userSurveyInfo.EvalUsers); return(userSurveyInfo.SurveyId); }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public int AddUser(SysUser user) { int userId = _dataAccess.AddEntity(user); if (userId > 0) { UpdateUserPostPromotion(user.PostId, new int[] { userId }); } return(userId); }
/// <summary> /// 添加标签,返回ID /// 如果已经存在,则返回ID /// </summary> /// <param name="tag"></param> /// <returns></returns> public int Insert(KL_Tags tag) { var list = _dataAccess.GetList <KL_Tags>(string.Format(" KL_Tags.TenantId = {0} and KL_Tags.TagName = '{1}'", tag.TenantId, tag.TagName.ReplaceSql())); if (list.Count > 0) { return(list[0].TagId); } _dataAccess.AddEntity(tag); return(tag.TagId); }
/// <summary> /// /// </summary> /// <param name="userId"></param> /// <param name="resourceId"></param> /// <param name="actionType"></param> /// <param name="resourceDesc"></param> /// <param name="isPrivate"></param> /// <returns></returns> public int AddActivity(int userId, int resourceId, ActionType actionType, string resourceDesc, int isPrivate = 0) { var activity = new IntUserActivity(); activity.ResourceId = resourceId; activity.ResourceName = resourceDesc; activity.ResourceType = (int)actionType; activity.UserId = userId; activity.IsPrivate = isPrivate; activity.ActionTime = DateTime.Now; _dataAccess.AddEntity(activity); return(activity.ActivityId); }
public int AddQuestion(Models.Cde.Cde_IndexQuestion question) { _dataAccess.AddEntity(question); if (question.Answers.Count > 0) { foreach (var answer in question.Answers) { answer.QuestionId = question.QuestionId; } _dataAccess.AddEntities(question.Answers); } return(question.QuestionId); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Group model) { model.MemberCount = 1; model.GroupId = _dataAccess.AddEntity(model); _dataAccess.AddEntity(new GroupMember { GroupId = model.GroupId, InviteTime = DateTime.Now, JoinTime = DateTime.Now, UserId = model.Creater, Status = 0 }); return(model.GroupId); }
/// <summary> /// 添加积分记录 /// </summary> /// <param name="ruleId"></param> /// <param name="integration"></param> /// <param name="userId"></param> /// <param name="tenantId"></param> /// <param name="desc"></param> public void AddIntegration(int ruleId, int integration, int userId, int tenantId, string desc = "") { var userIntegral = new UserIntegral(); userIntegral.RuleId = ruleId; userIntegral.Integral = integration; userIntegral.TimeToGet = DateTime.Now; userIntegral.UserId = userId; userIntegral.IntegralDesc = desc; #region 冗余处理 if (IsUseRedis) { var userTotal = rdHelper.HGet(userTotalIntegralKey, userId.ToString()); if (userTotal == null) { userTotal = ((int)_dataAccess.ExecuteScalar("select sum(integral) from int_userintegral where UserId=" + userId) + integration).ToString(); } else { userTotal = (userTotal.ToInt32() + integration).ToString(); } rdHelper.HSet(userTotalIntegralKey, userId.ToString(), userTotal.ToString()); } else { //使用MySql var existsSql = "SELECT COUNT(*) FROM Int_UserTotalIntegral WHERE UserId=" + userId; if (_dataAccess.ExecuteScalar(existsSql).ToInt32() == 0) { //新增 var insertSql = string.Format("INSERT into Int_UserTotalIntegral(UserId,TenantId,TotalIntegral)values({0},{1},{2});", userId, tenantId, integration); _dataAccess.ExecuteSql(insertSql); } else { _dataAccess.ExecuteSql( string.Format( "update Int_UserTotalIntegral set TotalIntegral=TotalIntegral+{0} WHERE UserId={1}", integration, userId)); } } #endregion _dataAccess.AddEntity(userIntegral); }
/// <summary> /// 发送站内信 /// </summary> /// <param name="title">标题</param> /// <param name="content">内容</param> /// <param name="recUserId">收件人</param> /// <param name="sendUserId">发件人</param> /// <param name="tenantId"></param> public void AddMessage(string title, string content, int[] recUserId, int sendUserId, int tenantId) { var messageContent = new SysUserMessageContent() { Title = title, MessageContent = content, CreateTime = DateTime.Now, TenantId = tenantId }; messageContent.MessageId = _dataAccess.AddEntity(messageContent); var list = new List <SysUserMessage>(); for (int i = 0; i < recUserId.Length; i++) { if (recUserId[i] > 0) { list.Add(new SysUserMessage { MessageId = messageContent.MessageId, SendStatus = 0, RecStatus = 0, SendUserId = sendUserId, RecUserId = recUserId[i], TenantId = tenantId }); } } _dataAccess.AddEntities(list); }
/// <summary> /// 创建角色 /// </summary> /// <param name="roleName"></param> /// <param name="desc"></param> /// <param name="roleCode"></param> /// <param name="tenantId"></param> /// <param name="createUser"></param> /// <param name="isDefault"></param> public int CreateRole(string roleName, string desc, string roleCode, int tenantId, int createUser, int isDefault) { var role = new SysRole { CreateTime = DateTime.Now, CreateUser = createUser, Description = desc, RoleName = roleName, TenantId = tenantId, IsDefault = isDefault, Status = 0, IsDelete = 0 }; return(_dataAccess.AddEntity(role)); }
/// <summary> /// 分享外部资源 /// </summary> /// <param name="tenantId"></param> /// <param name="userId"></param> /// <param name="resourceName">名称</param> /// <param name="recommend">心得</param> /// <param name="resourceUrl">链接</param> /// <returns></returns> public static int AddExternalShare(int tenantId, int userId, string resourceName, string recommend, string resourceUrl) { var model = new IntShared { TenantId = tenantId, ShareTime = DateTime.Now, UserId = userId, IsDelete = 0, Recommend = recommend, ResourceName = resourceName, ResourceUrl = resourceUrl, ObjectId = 0, ObjectType = 10, SourceId = 0 }; return(_dataAccess.AddEntity(model)); }
/// <summary> /// 新增问题 /// </summary> /// <param name="question"></param> /// <returns></returns> public int AddQuestion(IntQuestion question) { if (question.SortId != 0) { var allsorts = GetAllSorts(question.TenantId); QuestionSort sort = allsorts.First(p => p.SortId == question.SortId); while (sort.ParentId != 0) { sort = allsorts.First(p => p.SortId == sort.ParentId); } _dataAccess.UpdateFieldCalc("Int_QuestionSort", "QuestionCount", "QuestionCount+1", "SortId=" + sort.SortId); } var id = _dataAccess.AddEntity(question); //全文检索 SetQuestionFullSearch(question.QuestionId); return(id); }
public int AddReport(Cde_Report report) { int reportId = _dataAccess.AddEntity(report); foreach (var index in report.IndexList) { index.ReportId = reportId; } _dataAccess.AddEntities(report.IndexList); return(reportId); }
public SysTenant CreateTenant(string tenantName , string desc , string domainName , int createUser) { var tenant = new SysTenant { TenantName = tenantName, TenantDesc = desc, DomainName = domainName, CreateTime = DateTime.Now, JoinTime = DateTime.Now, Status = 0, ExpiredTime = DateTime.Now.AddYears(200), CreateUser = createUser }; _dataAccess.AddEntity(tenant); //var config = new TenantConfig(tenant.TenantId); //config.SaveConfig(); return(tenant); }
/// <summary> /// /// </summary> /// <param name="user"></param> public static void AddLoginLog(SysUser user) { var log = new SysLoginLog(); log.LoginTime = DateTime.Now; log.LogoutTime = DateTime.Now.AddMinutes(2); //log.OtherInfo = GetRequestParams(HttpContext.Current.Request); log.TenantId = user.TenantId; log.UserId = user.UserId; log.ClientIp = WebClient.GetClientIp(); _dataAccess.AddEntity(log); HttpContext.Current.Session["login-logId"] = log.LogId; }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <param name="tenantId"></param> /// <returns></returns> public static string GetConfig(string name, int tenantId) { var configKey = "SystemConfig:Tenant:" + tenantId + ":name:" + name; var configValue = CacheHelper.CacheService.Get <string>(configKey); if (configValue == null) { var sql = "select ConfigValue from Sys_Config where TenantId = " + tenantId + " and ConfigName='" + name.ReplaceSql() + "'"; configValue = DataAccess.ExecuteScalar(sql) as string; if (configValue == null) { configValue = string.Empty; var config = new Models.SysConfig(); config.ConfigCode = name; config.ConfigName = name; config.ConfigValue = configValue; config.TenantId = tenantId; DataAccess.AddEntity(config); CacheHelper.CacheService.Add(configKey, configValue, CachingExpirationType.Stable); } } return(configValue); }
/// <summary> /// 批量添加授权信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddAllTenantToWare(List <Sys_TenantToWare> list, string wareids) { var result = 0; var allList = _dataAccess.GetList <Sys_TenantToWare>(" WareID in (" + wareids.TrimEnd(',').TrimStart(',') + ")"); foreach (var item in list) { var single = allList.FirstOrDefault(p => p.WareID == item.WareID); if (single == null) { _dataAccess.AddEntity(item); } else { var openList = (single.OpenObject.TrimEnd(',') + "," + item.OpenObject.TrimStart(',')).Split(',').ToList().Distinct(); single.OpenObject = string.Join(",", openList); _dataAccess.UpdateEntity(single); } result++; } return(result == list.Count); }
public int AddConfig(Cde_Configuration config) { var model = _dataAccess.Get <Cde_Configuration>(config.TenantId, "TenantId"); if (model == null) { _dataAccess.AddEntity(config); } else { _dataAccess.UpdateEntity(config, "TenantId"); } return(1); }
/// <summary> /// 添加课程 /// </summary> /// <param name="course">课程实体</param> /// <returns></returns> public int AddCourse(ResCourse course) { course.LastUpdateTime = DateTime.Now; int id = _dataAccess.AddEntity(course); foreach (var exampaper in course.Exampapers) { exampaper.CourseId = id; } foreach (var file in course.BeforeLearnFiles) { file.CourseId = id; } foreach (var crowd in course.OpenCrowds) { crowd.CourseId = id; } _dataAccess.AddEntities(course.BeforeLearnFiles); _dataAccess.AddEntities(course.Exampapers); _dataAccess.AddEntities(course.OpenCrowds); BusinessCache.SystemCache.Instance.ClearCourses(); IndexCourse(id); return(id); }
/// <summary> /// 绑定用户到微信帐户,如果该openID已经绑定则取消原有,绑定新的 /// </summary> /// <param name="userId"></param> /// <param name="openId"></param> public void BindingUserAccount(int userId, string openId) { var model = _dataAccess.GetList <Wx_BindingAccount>(string.Format("openid = '{0}'", openId)).FirstOrDefault(); if (model == null) { _dataAccess.AddEntity(new Wx_BindingAccount { OpenID = openId, UserId = userId }); } else if (model.UserId != userId) { model.UserId = userId; _dataAccess.UpdateEntity(model); } }
//private static readonly List<SysLog> _logs = new List<SysLog>(OnceSaveNum); /// <summary> /// /// </summary> /// <param name="log"></param> public void AddLog(SysLog log) { //lock (LockHelper) //{ // if (_logs.Count >= OnceSaveNum) // { try { _dataAccess.AddEntity(log); } catch (Exception ex) { LogHelper.WriteLog("添加日志错误", ex); //throw; } }
private static readonly int REMOVEDIFF = 60; //多少秒执行一次删除不活动用户 /// <summary> /// Checks the online. /// </summary> /// <param name="userId">User identifier.</param> /// <param name="tenantId">Tenant identifier.</param> public static void CheckOnline(int userId, int tenantId) { lock (lockHelper) { string sessionId = System.Web.HttpContext.Current.Session.SessionID; //数据表中是否有用户的记录 OnlineUser onlineUser = _dataAccess.GetList <OnlineUser>("sys_onlineuser.UserId=" + userId).FirstOrDefault();// onlineUsers.Find(p => p.UserId == userId); if (onlineUser != null && onlineUser.SessionId != sessionId) { //SESSION变了??? //onlineUsers.Remove(onlineUser); _dataAccess.DeleteEntities <OnlineUser>("sys_onlineuser.UserId=" + userId); onlineUser = null; } if (onlineUser != null) { //有;更新我的状态 onlineUser.LastActiveTime = DateTime.Now; onlineUser.UserWhere = AtWhere(); onlineUser.UserId = userId; _dataAccess.UpdateEntity(onlineUser, "SessionId"); } else { //无;加入关于我的在线信息 onlineUser = new OnlineUser(); onlineUser.SessionId = sessionId; onlineUser.TenantId = tenantId; onlineUser.UserId = userId; onlineUser.LastActiveTime = DateTime.Now; onlineUser.LoginTime = DateTime.Now; onlineUser.VisitorIp = System.Web.HttpContext.Current.Request.UserHostAddress; onlineUser.UserWhere = AtWhere(); _dataAccess.AddEntity(onlineUser); } //如果离上次删除的时间间隔超过设定值 TimeSpan tsRemove = DateTime.Now - LastRemove; if (tsRemove.Seconds > REMOVEDIFF) { _dataAccess.ExecuteSql(string.Format(@"DELETE FROM sys_onlineuser where TIMESTAMPDIFF(SECOND,LastActiveTime,now())>{0};", OFFLINEDIFF * 60)); //重置上次删除时间 LastRemove = DateTime.Now; } } }
public void AddPostLearnRecord(int postId, int userId) { var model = _dataAccess.GetListBySql <AbPostLearnRecord>("select * from Ab_PostLearnRecord where PostId = " + postId + " and UserId = " + userId).FirstOrDefault(); if (model != null) { return; } model = new AbPostLearnRecord { PostId = postId, UserId = userId, EndTime = null, StartTime = DateTime.Now }; _dataAccess.AddEntity(model); }
public int AddExampaper(Cde_SurveyExampaper exampaper) { _dataAccess.AddEntity(exampaper); var questions = new List <Cde_SurveyQuestion>(); for (int index = 0; index < exampaper.Questions.Count; index++) { var question = exampaper.Questions[index]; questions.Add(new Cde_SurveyQuestion() { ExampaperID = exampaper.ExampaperID, QuestionID = question.QuestionId, ShowOrder = index }); } _dataAccess.AddEntities(questions); return(exampaper.ExampaperID); }
/// <summary> /// 学习指派 /// </summary> /// <param name="designateUser">指派者ID</param> /// <param name="userId">被指派者id</param> /// <returns></returns> public void GetDesignateDetail(int designateUser, int userId) { var userCourseListSql = string.Format(@"SELECT distinct u.UserId,u.Username,u.Realname,u.Sex,u.UserCode,dp.LevelPath,p.PostName,d.CourseId FROM Len_DesignateCourse d LEFT JOIN Sys_Users u ON u.UserId=d.UserId LEFT JOIN Sys_Department dp ON u.DeptId=dp.DeptId LEFT JOIN Sys_Posts p ON u.PostId=p.PostId WHERE DesignateUser={0} AND d.InfoType IN(0) and u.UserId={1}", designateUser, userId); var userCourseList = _dataAccess.FetchListBySql <DesignateUserList>(userCourseListSql); var courseIds = userCourseList.Select(p => p.CourseId).Distinct().GetString(); string[] courseId = courseIds.Split(','); //更新学习记录 if (userCourseList.Any()) { // var sql = string.Format(@"DELETE FROM dbo.Len_LearningRecord WHERE UserId = {0} AND CourseId IN ({1}) //AND LearnPath=0 AND SourceId=0 ", userId, courseIds); // var DeletelearnRecords = _dataAccess.ExecuteSql(sql); List <LenLearningRecord> learnRecords = new List <LenLearningRecord>(); foreach (var item in courseId) { var learnRecord = _dataAccess.GetList <LenLearningRecord>(string.Format(@"WHERE UserId = ({0}) AND CourseId = ({1}) AND LearnPath=0 AND SourceId=0 ", userId, Convert.ToInt32(item))); if (learnRecord.Count > 0) { _dataAccess.UpdateFieldCalc("dbo.Len_LearningRecord", "LearnProcess", "2", "where RecordId=" + learnRecord[0].RecordId); } else { LenLearningRecord lr = new LenLearningRecord(); lr.CourseId = Convert.ToInt32(item); lr.UserId = userId; lr.LearnProcess = 2; lr.LearnPath = 0; lr.SourceId = 0; lr.StartTime = DateTime.Now; lr.EndTime = DateTime.Now; lr.LastLearnTime = DateTime.Now; _dataAccess.AddEntity(lr); } } } }
public int SaveLearningRecord(int stageid, int abilityid, int applyId) { var record = _dataAccess.GetList <AbLearningRecord>("StageId=" + stageid + " AND AbilityId=" + abilityid + " AND ApplyId=" + applyId).FirstOrDefault(); if (record == null) { var promotion = _dataAccess.Get <PromotionStage>(stageid); return(_dataAccess.AddEntity(new AbLearningRecord() { StageId = stageid, AbilityId = abilityid, ApplyId = applyId, PromotionId = promotion.PromotionId })); } else { return(record.RecordId); } }
/// <summary> /// /// </summary> /// <param name="keyWord"></param> /// <param name="tenantId"></param> /// <returns></returns> public static int AddWord(string keyWord, int tenantId) { if (string.IsNullOrWhiteSpace(keyWord)) { return(0); } var exists = _dataAccess.GetList <Sys_SearchKeyWord>("KeyWord=@keyword AND TenantId=@tid", new { keyword = keyWord, tid = tenantId }).FirstOrDefault(); if (exists == null) { exists = new Sys_SearchKeyWord { KeyWord = keyWord, SearchCount = 1, TenantId = tenantId, Lookup = keyWord.GetPy(0) + " " + keyWord.GetPy(2) }; return(_dataAccess.AddEntity(exists)); } exists.SearchCount += 1; return(_dataAccess.UpdateEntity(exists)); }
/// <summary> /// /// </summary> /// <param name="post"></param> public void AddPost(SysPost post) { _dataAccess.AddEntity(post); }
public int Add(LenLearnPlan model) { return(_dataAccess.AddEntity(model)); }
/// <summary> /// 新增学习卡 /// </summary> /// <param name="card">实体</param> /// <returns></returns> public int AddCard(ResCard card) { return(_dataAccess.AddEntity(card)); }