/// <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));
}
