public IHttpActionResult ReadMsg([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
List <string> msgIds = JsonConvert.DeserializeObject <List <string> >(Convert.ToString(value.msg_ids));
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
MessageDomain MD = new MessageDomain();
result = MD.ReadMsg(UserId, msgIds);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Message", "ReadMsg", "api/message/read", "阅读通知接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "请求失败,请重试";
return(Json(result));
}
}
public IHttpActionResult GetFaqDtlById(string user_id, string faq_id)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
VD.Run(user_id, new VerifyUser());
VD.Run(faq_id, new VerifyFaq());
FeedDomain FD = new FeedDomain();
result = FD.GetFaqDtlById(user_id, faq_id);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Feed", "GetTopicDtlById", "bus/feed/gettopicinfo", "根据话题ID获取话题的详细信息", $"用户ID：{user_id}；问答ID：{faq_id};", ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
public IHttpActionResult GetUnreadMessage(string userid)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
VD.Run(userid, new VerifyUser());
MessageDomain MD = new MessageDomain();
result = MD.UnreadMessage(userid);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Message", "GetUnreadMessage", "api/message/getunread", "获取用户未读通知数量", $"用户ID：{userid}", ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
public IHttpActionResult GetMessageInfo(string userid, int cursor, int count)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
VD.Run(userid, new VerifyUser());
MessageDomain MD = new MessageDomain();
result = MD.GetMessageInfo(userid, cursor, count);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Message", "GetMessageInfo", "api/message/getmsg", "获取用户收到的通知", $"用户ID：{userid}；已下发数：{cursor}；本次请求数：{count}", ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
public IHttpActionResult ShareContent([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string ContentId = Convert.ToString(value.content_id);
string ToSharedId = Convert.ToString(value.to_shared_id);
int ShareType = Convert.ToInt32(value.share_type);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
if (ShareType == 1)
{
VD.Run(ContentId, new VerifyFirstPath());
VD.Run(ToSharedId, new VerifyFaq());
}
FeedDomain FD = new FeedDomain();
result = FD.ShareContent(UserId, ContentId, ToSharedId, ShareType);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Feed", "ShareContent", "bus/feed/share", "分享接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "提交失败，请重试";
return(Json(result));
}
}
public IHttpActionResult GetPermission(string user_id)
{
RetJsonModel result = new RetJsonModel();
try
{
LoginDomain LD = new LoginDomain();
//数据校验
RunVerify VD = new RunVerify();
VD.Run(user_id, new VerifyUser());
result = LD.GetRolePermission(user_id);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Login", "GetPermission", "api/login/per", "获取当前账号拥有的权限", "当前登录用户ID：" + user_id, ex.Message.ToString(), "POST");
result.status = 0;
result.msg = "数据异常，请重试";
result.time = FunctionHelper.GetTimestamp();
result.data = new List <string>();
return(Json(result));
}
}
/// <summary>
/// 获取用户所有权限
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public RetJsonModel GetRolePermission(string userId)
{
var db = DBContext.GetInstance;
try
{
//返给前台的JSON实体
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = FunctionHelper.GetTimestamp();
List <string> data = db.Queryable <SYS_USER_PERMISSION>()
.Where(x => x.USER_ID == userId && x.STATE == "A")
.Select(x => x.PERMISSION_CODE).ToList();
jsonModel.status = 1;
jsonModel.msg = "成功";
jsonModel.data = data;
return(jsonModel);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult Get(string user_id, string path_id, int cursor, int count)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
VD.Run(user_id, new VerifyUser());
VD.Run(path_id, new VerifyFirstPath());
PlanDomain PD = new PlanDomain();
result = PD.GetPlanByPath(user_id, path_id, cursor, count);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Plan", "Get", "bus/plan/get", "根基规划id获取计划", "用户ID：" + user_id + "已经获取的卡片数量:" + cursor + ";本次请求的卡片数量:" + count + "计划头ID" + path_id, ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
/// <summary>
/// 分享计划
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="planId">计划头ID</param>
/// <returns></returns>
public RetJsonModel SharePlan(string userId, string planId)
{
var db = DBContext.GetInstance;
try
{
DateTime now = db.GetDate();
int timestamp = FunctionHelper.GetTimestamp();
var data = db.Queryable <BUS_PLAN_HEADER>()
.Where(x => x.STATE == "A" && x.ID == planId)
.First();
db.Ado.BeginTran();
//分享计划的方法
SharePlanFun(db, planId, now, timestamp);
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = timestamp;
jsonModel.status = 1;
jsonModel.msg = "分享成功";
db.Ado.CommitTran();
return(jsonModel);
}
catch (Exception ex)
{
db.Ado.RollbackTran();
throw ex;
}
}
/// <summary>
/// 点赞/取消点赞
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="typeId">被点赞的ID</param>
/// <param name="favourType">点赞类型(1:一级职业路径；2:二级职业路径；3:三级职业路径；4:一级评论；5:二级评论)</param>
/// <param name="pathType">职业路径等级</param>
/// <returns></returns>
public RetJsonModel Favour(string userId, string typeId, int favourType)
{
var db = DBContext.GetInstance;
try
{
DateTime now = db.GetDate();
int timestamp = FunctionHelper.GetTimestamp();
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = timestamp;
db.Ado.BeginTran();
//点赞
RunFavour RF = new RunFavour(favourType);
RF.Run(db, userId, typeId, favourType, now, timestamp);
db.Ado.CommitTran();
jsonModel.status = 1;
jsonModel.msg = "点赞成功";
return(jsonModel);
}
catch (Exception ex)
{
db.Ado.RollbackTran();
throw ex;
}
}
public IHttpActionResult PostPlan([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
int IsShare = Convert.ToInt32(value.is_share);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
PlanHeaderModel planModel = JsonConvert.DeserializeObject <PlanHeaderModel>(Convert.ToString(value.plan_info));
VD.Run(planModel.FIRST_PATH_ID, new VerifyFirstPath());
PlanDomain PD = new PlanDomain();
result = PD.PostPlan(UserId, IsShare, planModel);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Plan", "PostPlan", "bus/plan/post", "发布计划接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "发布失败，请重试";
return(Json(result));
}
}
public IHttpActionResult ChangeNickName([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string NickName = Convert.ToString(value.nick_name);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
UserDomain UD = new UserDomain();
result = UD.ChangeNickName(UserId, NickName);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("User", "ChangeNickName", "api/user/changename", "修改用户名", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "失败,请重试";
return(Json(result));
}
}
public IHttpActionResult PostComment([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string pathId = Convert.ToString(value.path_id);
string content = Convert.ToString(value.content);
int pathType = Convert.ToInt32(value.path_type);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
VD.Run(pathId, InterfaceArray.DicVD[pathType]);
UserDomain UD = new UserDomain();
result = UD.PublishComment(UserId, pathId, content, pathType);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("User", "PostComment", "api/user/p/comment", "发表对职业路线的评论", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "评论失败,请重试";
return(Json(result));
}
}
public IHttpActionResult PostCareerPath([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string FirstId = Convert.ToString(value.first_id);
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
VD.Run(FirstId, new VerifyFirstPath());
UserDomain UD = new UserDomain();
result = UD.FollowCareerPath(UserId, FirstId);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("User", "PostCareerPath", "api/user/path", "关注职业路径接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "关注失败,请重试";
return(Json(result));
}
}
public IHttpActionResult PostReviewerVote([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string modifyId = Convert.ToString(value.modify_id);
int isSupport = Convert.ToInt32(value.is_support);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
VD.Run(modifyId, new VerifyModifyPath());
UserDomain UD = new UserDomain();
result = UD.ReviewerVote(UserId, modifyId, isSupport);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("User", "PostReviewerVote", "api/user/p/rvote", "Reviewer表决接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "失败,请重试";
return(Json(result));
}
}
public IHttpActionResult PostFavour([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string TypeId = Convert.ToString(value.type_id);
int favourType = Convert.ToInt32(value.favour_type);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
VD.Run(TypeId, InterfaceArray.DicVD[favourType]);
UserDomain UD = new UserDomain();
result = UD.Favour(UserId, TypeId, favourType);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("User", "PostFavour", "api/user/p/favour", "点赞接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "失败,请重试";
return(Json(result));
}
}
public IHttpActionResult PostIsLogin([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
LoginDomain LD = new LoginDomain();
result = LD.IsLogin(UserId);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Login", "PostIsLogin", "api/login/status", "验证账号是否处在登陆中", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.msg = "数据异常，请重试";
result.time = FunctionHelper.GetTimestamp();
result.data = false;
return(Json(result));
}
}
public IHttpActionResult GetDetailedPage(string user_id, string path_id)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
if (!string.IsNullOrEmpty(user_id))
{
VD.Run(user_id, new VerifyUser());
}
VD.Run(path_id, new VerifyFirstPath());
FeedDomain FD = new FeedDomain();
result = FD.GetPathDetailedInfo(user_id, path_id);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Feed", "GetDetailedPage", "bus/feed/detailed", "获取职业路径详情页接口", "用户ID：" + user_id + "；职业路径ID：" + path_id, ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
public IHttpActionResult PostAduit([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
int isPass = Convert.ToInt32(value.is_pass);
int isDel = Convert.ToInt32(value.is_del);
string UserId = Convert.ToString(value.user_id);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
List <string> firstId = JsonConvert.DeserializeObject <List <string> >(Convert.ToString(value.first_id));
FeedDomain FD = new FeedDomain();
result = FD.AuditPath(firstId, isPass, isDel, UserId);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Feed", "PostAduit", "bus/feed/aduit", "审批职业路径接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "审核失败，请重试";
return(Json(result));
}
}
public IHttpActionResult PostModify([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string userId = Convert.ToString(value.user_id);
string pathId = Convert.ToString(value.path_id);
string content = Convert.ToString(value.content);
int pathClass = Convert.ToInt32(value.path_class);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(userId, new VerifyUser());
VD.Run(pathId, InterfaceArray.DicVD[pathClass]);
FeedDomain FD = new FeedDomain();
result = FD.ModifyPath(userId, pathId, pathClass, content);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Feed", "PostModify", "bus/feed/modify", "发起对某一级职业规划修改的接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
public IHttpActionResult UpdateStatus([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string PlanId = Convert.ToString(value.plan_id);
string PlanDtlId = Convert.ToString(value.plan_dtl_id);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
VD.Run(PlanId, new VerifyPlanHead());
VD.Run(PlanDtlId, new VerifyPlanDetail());
PlanDomain PD = new PlanDomain();
result = PD.UpdateStatus(UserId, PlanId, PlanDtlId);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Plan", "UpdateStatus", "bus/plan/complete", "完成计划接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "请求失败，请重试";
return(Json(result));
}
}
public IHttpActionResult GetHistortModify(string user_id, string path_id, int path_class, int cursor, int count)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
VD.Run(user_id, new VerifyUser());
VD.Run(path_id, InterfaceArray.DicVD[path_class]);
FeedDomain FD = new FeedDomain();
result = FD.GetHistortModify(user_id, path_id, path_class, cursor, count);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
string message = "用户ID：" + user_id + "；职业规划ID：" + path_id + "；职业规划等级：" + path_class + "；已下发数：" + cursor + "；本次请求数：" + count;
FunctionHelper.SaveFailLog("Feed", "GetHistortModify", "bus/feed/hmodify", "查询某一职业规划的历史修改记录", message, ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
public IHttpActionResult SharePlanCancel([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string PlanId = Convert.ToString(value.plan_id);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
VD.Run(PlanId, new VerifyPlanHead());
PlanDomain PD = new PlanDomain();
result = PD.SharePlanCancel(UserId, PlanId);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Plan", "SharePlanCancel", "bus/plan/sharecancel", "取消分享计划接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "取消失败，请重试";
return(Json(result));
}
}
public IHttpActionResult GetModifyDetailedInfo(string user_id, string modify_id)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
VD.Run(user_id, new VerifyUser());
VD.Run(modify_id, new VerifyModifyPath());
FeedDomain FD = new FeedDomain();
result = FD.GetModifyDetailedInfo(user_id, modify_id);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
string message = "用户ID：" + user_id + "；修改职业规划表ID：" + modify_id;
FunctionHelper.SaveFailLog("Feed", "GetModifyDetailedInfo", "bus/feed/hmodif/detailed", "查询修改职业规划的详情页", message, ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
/// <summary>
/// 删除计划
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="planId">计划头ID</param>
/// <returns></returns>
public RetJsonModel DeletePlan(string userId, string planId)
{
var db = DBContext.GetInstance;
try
{
int timestamp = FunctionHelper.GetTimestamp();
db.Ado.BeginTran();
db.Deleteable <BUS_PLAN_HEADER>()
.Where(x => x.ID == planId)
.ExecuteCommand();
db.Deleteable <BUS_PLAN_DETAIL>()
.Where(x => x.HEADER_ID == planId)
.ExecuteCommand();
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = timestamp;
jsonModel.status = 1;
jsonModel.msg = "删除成功";
db.Ado.CommitTran();
return(jsonModel);
}
catch (Exception ex)
{
db.Ado.RollbackTran();
throw ex;
}
}
public IHttpActionResult PublishQues([FromBody] dynamic value)
{
RetJsonModel result = new RetJsonModel();
try
{
string UserId = Convert.ToString(value.user_id);
string Desc = Convert.ToString(value.desc);
string TopicName = Convert.ToString(value.topic_name);
//数据校验
RunVerify VD = new RunVerify();
VD.Run(UserId, new VerifyUser());
FeedDomain FD = new FeedDomain();
result = FD.PublishQues(UserId, Desc, TopicName);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Feed", "PublishQues", "bus/feed/publishques", "问答-发起提问接口", Convert.ToString(value), ex.Message.ToString(), "POST");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "提交失败，请重试";
return(Json(result));
}
}
/// <summary>
/// 验证账号是否在登陆中
/// </summary>
/// <param name="userId">用户ID</param>
/// <returns></returns>
public RetJsonModel IsLogin(string userId)
{
var db = DBContext.GetInstance;
try
{
//返给前台的JSON实体
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = FunctionHelper.GetTimestamp();
SYS_USER_ACCOUNT account = db.Queryable <SYS_USER_ACCOUNT>()
.Where(x => x.STATE == "A" && x.ID == userId)
.First();
if (account != null && account.STATUS == 1)
{
jsonModel.status = 1;
jsonModel.msg = "账号登陆中";
jsonModel.data = true;
}
else
{
jsonModel.status = 0;
jsonModel.msg = "账号未登录";
jsonModel.data = false;
}
return(jsonModel);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult GetTabsInfo(string user_id)
{
RetJsonModel result = new RetJsonModel();
try
{
//数据校验
RunVerify VD = new RunVerify();
VD.Run(user_id, new VerifyUser());
FeedDomain FD = new FeedDomain();
result = FD.GetTabsInfo(user_id);
return(Json(result));
}
catch (Exception ex)
{
//记录失败日志
FunctionHelper.SaveFailLog("Feed", "GetTabsInfo", "bus/feed/gettabs", "下发用户个人页tab信息", $"用户ID：{user_id}", ex.Message.ToString(), "GET");
result.status = 0;
result.time = FunctionHelper.GetTimestamp();
result.msg = "数据异常，请重试";
return(Json(result));
}
}
/// <summary>
/// 普通用户投票
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="modifyId">修改职业规划ID</param>
/// <param name="isSupport">是否赞同(1:赞同；2:反对)</param>
/// <returns></returns>
public RetJsonModel NormalVote(string userId, string modifyId, int isSupport)
{
var db = DBContext.GetInstance;
try
{
DateTime now = db.GetDate();
int timestamp = FunctionHelper.GetTimestamp();
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = timestamp;
int count = db.Queryable <BUS_MODIFIED_VOTE>()
.Where(x => x.USER_ID == userId && x.MODIFY_PATH_ID == modifyId && x.STATE == "A")
.Count();
if (count != 0)
{
jsonModel.status = 0;
jsonModel.msg = "您已经参与过此投票";
return(jsonModel);
}
db.Ado.BeginTran();
//在投票记录表插入投票人的投票情况
BUS_MODIFIED_VOTE model = new BUS_MODIFIED_VOTE();
model.ID = Guid.NewGuid().ToString();
model.DATETIME_CREATED = now;
model.STATE = "A";
model.TIMESTAMP_INT = timestamp;
model.USER_ID = userId;
model.MODIFY_PATH_ID = modifyId;
model.IS_SUPPORT = isSupport;
db.Insertable(model).ExecuteCommand();
//根据赞成还是反对，更新修改职业规划表的投票情况
db.Updateable <BUS_MODIFY_PATH>()
.SetColumnsIF(isSupport == 1, x => new BUS_MODIFY_PATH()
{
DATETIME_MODIFIED = now,
SUPPORT = x.SUPPORT + 1
})
.SetColumnsIF(isSupport == 0, x => new BUS_MODIFY_PATH()
{
DATETIME_MODIFIED = now,
OPPOSE = x.OPPOSE + 1
}).Where(x => x.ID == modifyId && x.STATE == "A").ExecuteCommand();
db.Ado.CommitTran();
jsonModel.status = 1;
jsonModel.msg = "投票成功";
return(jsonModel);
}
catch (Exception ex)
{
db.Ado.RollbackTran();
throw ex;
}
}
/// <summary>
/// 登录方法
/// </summary>
/// <param name="userId">账号</param>
/// <param name="passWord">密码</param>
/// <returns></returns>
public RetJsonModel Login(string userId, string passWord)
{
var db = DBContext.GetInstance;
try
{
DateTime now = db.GetDate();
//返给前台的JSON实体
RetJsonModel jsonModel = new RetJsonModel();
jsonModel.time = FunctionHelper.GetTimestamp();
var data = db.Queryable <SYS_USER_ACCOUNT, SYS_USER_INFO>((a, b) => new object[] {
JoinType.Left, a.ID == b.USER_ID && a.STATE == b.STATE
}).Where((a, b) => a.ACCOUNT_NUMBER == userId && a.STATE == "A")
.Select((a, b) => new
{
a.ID,
a.PASSWORD,
b.NICK_NAME
}).First();
if (data != null)
{
if (data.PASSWORD == passWord)
{
db.Updateable <SYS_USER_ACCOUNT>().SetColumns(x => new SYS_USER_ACCOUNT()
{
STATUS = 1,
DATETIME_MODIFIED = now
}).Where(x => x.ID == data.ID).ExecuteCommand();
LoginReturnModel lrm = new LoginReturnModel();
lrm.user_info = new UserInfoReturnModel
{
USER_ID = data.ID,
NiCK_NAME = data.NICK_NAME
};
jsonModel.status = 1;
jsonModel.msg = "登录成功";
jsonModel.data = lrm;
}
else
{
jsonModel.status = 0;
jsonModel.msg = "密码错误，请重试";
}
}
else
{
jsonModel.status = 0;
jsonModel.msg = "账号不存在，请重试";
}
return(jsonModel);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult ArticleUpdate()
{
var ret = new RetJsonModel();
var articleContent = HttpUtility.UrlDecode(Request.Form["Content"]);
var userIdStr = Request.Form["UserID"];
var articeIdStr = Request.Form["ArticleID"];
try
{
var articleId = long.Parse(articeIdStr);
var userId = long.Parse(userIdStr);
var article = _db.Articles.Find(articleId);
if (Session["LoggedUserID"].Equals(userIdStr) && article.AuthorId == userId)
if (Session["LoggedUserID"].Equals(userIdStr) && article.AuthorId == userId)
{
if (articleContent != null)
article.Content = HttpUtility.HtmlEncode(articleContent.Replace("style=\"height:", "style=\"name:"));
article.ModifyDate = DateTime.Now;
_db.SaveChanges();
ret.IsAccept = 1;
ret.UserId = article.AuthorId.ToString();
}
else
{
ret.IsAccept = 0;
ret.Error = "Update Failed";
}
}
catch (Exception ex)
{
ret.IsAccept = 0;
ret.Error = ex.ToString();
}
return Json(ret);
}
public JsonResult FileUpload()
{
var retList = new LinkedList<RetJsonModel>();
for (var i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file == null) continue;
var ret = new RetJsonModel
{
ContentType = file.ContentType,
UserId = Session["LoggedUserID"].ToString()
};
if (ret.ContentType.Contains("image/"))
{
ret.IsAccept = 0;
ret.FileTypeAccept = "yes";
ret.FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + '_' + i + '_' + file.FileName;
if (!string.IsNullOrEmpty(ret.UserId))
{
ret.Url = "/Content/Users/" + ret.UserId + "/" + ret.FileName;
var path = Path.Combine(Server.MapPath("~/Content/Users/" + ret.UserId + ""), ret.FileName);
var stream = file.InputStream;
using (var fileStream = System.IO.File.Create(path))
{
stream.CopyTo(fileStream);
}
var resizer = new ImageResizer(@path);
var thumbtailPath = Path.Combine(Server.MapPath("~/Content/Users/" + ret.UserId + "/thumbtail/"), ret.FileName);
resizer.Resize(400, 400, ImageEncoding.Jpg90);
if (!Directory.Exists(Server.MapPath("~/Content/Users/" + ret.UserId + "/thumbtail/")))
Directory.CreateDirectory(Server.MapPath("~/Content/Users/" + ret.UserId + "/thumbtail/"));
resizer.SaveToFile(@thumbtailPath);
var image = new ImageViewModel();
var imageMetaDate = new ImageMetaData(Server.MapPath(ret.Url));
image.FileName = ret.FileName;
image.UpdateDate = DateTime.Now;
image.UserId = long.Parse(ret.UserId);
image.Url = ret.Url;
image.ContentType = file.ContentType;
_db.Images.Add(image);
imageMetaDate.FetchData();
var metadata = imageMetaDate.GetMetaData();
_db.ImageMetaData.Add(metadata);
_db.SaveChanges();
}
else
{
ret.IsAccept = 1;
ret.Error = "Member Session Expired";
}
}
else
{
ret.IsAccept = 1;
ret.FileName = file.FileName;
ret.Error = "Content Type Deny";
}
retList.AddLast(ret);
}
var javaScriptSerializer = new JavaScriptSerializer();
var jsonString = javaScriptSerializer.Serialize(retList);
return Json(jsonString);
}
public JsonResult TitleUpdate()
{
var ret = new RetJsonModel();
var titleStr = HttpUtility.UrlDecode(Request.Form["Title"]);
var subTitleStr = HttpUtility.UrlDecode(Request.Form["SubTitle"]);
var userIdStr = Request.Form["UserID"];
var articeIdStr = Request.Form["ArticleID"];
try
{
var articleId = long.Parse(articeIdStr);
var userId = long.Parse(userIdStr);
var article = _db.Articles.First(a => a.ArticleId == articleId);
if (Session["LoggedUserID"].Equals(userIdStr) && article.AuthorId == userId)
{
if (titleStr != null) article.Title = Regex.Replace(titleStr, "[^0-9a-zA-Z \u4E00-\u9FFF]+", "");
if (subTitleStr != null)
article.SubTitle = Regex.Replace(subTitleStr, "[^0-9a-zA-Z \u4E00-\u9FFF]+", "");
article.ModifyDate = DateTime.Now;
_db.SaveChanges();
ret.IsAccept = 1;
ret.UserId = article.AuthorId.ToString();
}
else
{
ret.IsAccept = 0;
ret.Error = "Update Failed";
}
}
catch (Exception ex)
{
ret.IsAccept = 0;
ret.Error = ex.ToString();
}
return Json(ret);
}
