public ActionResult Put([FromBody] Model.Activity activity) { activity.activityIntroduction = activity.activityIntroduction.Replace($"https://{HttpContext.Request.Host.Value}/", ""); try { int n = DAL.Activity.Instance.Upadate(activity); if (n != 0) { return(Json(Result.Ok("修改活动成功", activity.activityId))); } else { return(Json(Result.Err("activityId不存在"))); } } catch (Exception ex) { if (ex.Message.ToLower().Contains("null")) { return(Json(Result.Err("活动名称、结束时间、活动图片、活动审核情况、用户不能为空"))); } else { return(Json(Result.Err(ex.Message))); } } }
public ActionResult PutRecommend([FromBody] Model.Activity activity) { try { var re = ""; if (activity.recommend == "否") { re = "取消"; } var n = DAL.Activity.Instance.UpadateRecommend(activity); if (n != 0) { return(Json(Result.Ok($"{re}审核活动成功", activity.activityId))); } else { return(Json(Result.Err("activityId不存在"))); } } catch (Exception ex) { if (ex.Message.ToLower().Contains("null")) { return(Json(Result.Err("推荐活动情况不能为空"))); } else { return(Json(Result.Err(ex.Message))); }; } }
public ActionResult PutVerify([FromBody] Model.Activity activity) { try { var n = DAL.Activity.Instance.UpadateVerify(activity); if (n != 0) { return(Json(Result.Ok("审核活动成功", activity.activityId))); } else { return(Json(Result.Err("activityId不存在"))); } } catch (Exception ex) { if (ex.Message.ToLower().Contains("null")) { return(Json(Result.Err("活动审核情况不能为空"))); } else { return(Json(Result.Err(ex.Message))); }; } }
//根据环节实例id获取下一环节信息 public string GetNextActivity(int activityInstId) { Model.Activity activity = (Model.Activity)service.GetDataList("t.*", @"inner join OA_ACTIVITY_INST ai on ai.activityid=t.id", "and ai.id=" + activityInstId)[0]; List <CommonAttribute> listActivity = service.GetDataList("t.*", "", "and t.processid=" + activity.ProcessId + " order by t.sort"); Model.Activity nextActivity = new Model.Activity(); for (int i = 0; i < listActivity.Count; i++) { if (listActivity[i].Id == activity.Id) { if (i < (listActivity.Count - 1)) { nextActivity = (Model.Activity)listActivity[i + 1]; } else { //下一环节为结束 nextActivity.Id = 0; nextActivity.Name = "结束环节"; nextActivity.ProcessId = activity.ProcessId; nextActivity.Sort = 9999; } break; } } return(Newtonsoft.Json.JsonConvert.SerializeObject(nextActivity)); }
public ActionResult upImg(int id, List <IFormFile> files) { var path = System.IO.Path.Combine(_hostingEnvironment.WebRootPath, "img", "Activity"); var fileName = $"{path}/{id}"; try { var ext = DAL.Upload.Instance.UpImg(files[0], fileName); if (ext == null) { return(Json(Result.Err("请上传图片文件"))); } else { var file = $"img/Activity/{id}{ext}"; Model.Activity activity = new Model.Activity() { activityId = id, activityIntroduction = file }; var n = DAL.Activity.Instance.UpadateImg(activity); if (n > 0) { return(Json(Result.Ok("上传成功", file))); } else { return(Json(Result.Err("请输入正确的活动id"))); } } } catch (Exception ex) { return(Json(Result.Err(ex.Message)));; } }
public ActionResult Post([FromBody] Model.Activity activity) { activity.activityIntroduction = activity.activityIntroduction.Replace($"https://{HttpContext.Request.Host.Value}/", ""); activity.recommend = "否"; try { int n = DAL.Activity.Instance.Add(activity); return(Json(Result.Ok("发布活动成功", n))); } catch (Exception ex) { if (ex.Message.ToLower().Contains("foreign key")) { return(Json(Result.Err("合法用户才能添加记录"))); } else if (ex.Message.ToLower().Contains("null")) { return(Json(Result.Err("活动名称、结束时间、活动图片、活动审核情况、用户不能问空"))); } else { return(Json(Result.Err(ex.Message))); } } }
public ActionResult Put([FromBody] Model.Activity activity) { try { var n = DAL.Activity.Instance.Update(activity); if (n != 0) { return(Json(Result.Ok("修改成功"))); } else//复制UsersController.cs对应代码,UserInfo改为Activity,user改为activity { return(Json(Result.Err("activityID不存在"))); } } catch (Exception ex) { if (ex.Message.ToLower().Contains("null"))//复制UsersController.cs对应代码 { return(Json(Result.Err("活动名称、结束时间、活动图片、活动审核情况不能为空"))); } else { return(Json(Result.Err(ex.Message))); } } }//复制UsersController.cs对应代码
public int UpdateImg(Model.Activity active) { using (IDbConnection cn = new MySqlConnection(cns)){ string sql = "update activity set activitypicture=@activityPicture where activityid=@activityId"; return(cn.Execute(sql, active)); } }
public int UptZt(int aid) { //string sql = "SELECT * FROM Activity;"; string sql2 = $"insert into Lognote values (NULL,'修改状态',NOW(),'Activity配置表');"; DapperHelper.Execute(sql2); //List<Model.Activity> la = DapperHelper.GetList<Model.Activity>(sql); Model.Activity aa = lst.Where(x => x.ActivityId.Equals(aid)).FirstOrDefault(); string sql1 = ""; if (aa.State == 0) { sql1 = $"UPDATE Activity SET State=State+1 where ActivityId={aid}"; } else { sql1 = $"UPDATE Activity SET State=State-1 where ActivityId={aid}"; } int i = DapperHelper.Execute(sql1); if (i > 0) { //lst = DapperHelper.GetList<Model.Activity>("SELECT * FROM Activity"); //rh.SetList(lst, redisKey); lst[lst.IndexOf(lst.FirstOrDefault(x => x.ActivityId == aid))] = aa; rh.SetList(lst, redisKey); } return(i); }
public ActionResult upImg(int id, List <IFormFile> files) { var path = System.IO.Path.Combine(_hostingEnvironment.WebRootPath, "img", "Activity"); var fileName = $"{path}/{id}"; try { var ext = DAL.Upload.Instance.UpImg(files[0], fileName); if (ext == null) { return(Json(Result.Err("请上传图片文件"))); } else { var file = $"img/Activity/{id}{ext}"; Model.Activity activity = new Model.Activity() { activityId = id, activityPicture = file }; } } catch (Exception ex) { if (ex.Message.ToLower().Contains("null")) { return(Json(Result.Err("推荐活动情况不能为空"))); } else { return(Json(Result.Err(ex.Message))); } } }
public int Add(Model.Activity active) //添加新活动并返回id { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "insert into activity(activityname,endtime,activitypicture,activityintroduction,summary,activityverify,activitystatus,username,recommend) values(@activityName, @endTime, @activityPicture, @activityIntroduction, @summary, @activityVerify, @activityStatus, @userName, @recommend);"; return(cn.ExecuteScalar <int>(sql, active)); } }
public int UpdateRecommend(Model.Activity activity) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "update activity set recommend=@recommend,recommendTime=@recommendTime where activityid=@activityId"; return(cn.Execute(sql, activity)); } }
public int UpdateVerify(Model.Activity active) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "update activity set activityverify=@activityVerify,where activityid=@activityId"; return(cn.Execute(sql, active)); } }
public int Update(Model.Activity active) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "update activity set activityname=@activityName, endtime=@endTime, activitypicture=@activityPicture, activityintroduction=@activityIntroduction, summary=@summary, activityverify=@activityVerify, activitystatus=@activityStatus where activityid=@activityId"; return(cn.Execute(sql, active)); } }
public Boolean AddRoles(int activityId, int[] roleIds) { Model.Activity activity = GetActivityById(activityId); foreach (int roleId in roleIds) { activity.AddRole(roleId); } return(true); }
public int Add(Model.Activity active) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "insert into Activity(ActivityName,EndTime,ActivityPicture,ActivityIntroduction,Summary,ActivityVerify,ActivityStatus,UserName) values(@ActivityName,@EndTime,@ActivityPicture,@ActivityIntroduction,@Summary,@ActivityVerify,@ActivityStatus,@UserName);"; //sql语句可复制题目给出的SQL sql += "SELECT @@IDENTITY"; return(cn.ExecuteScalar <int>(sql, active)); } }
public int Update(Model.Activity active) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "update Activity set ActivityName=@ActivityName,EndTime=@EndTime,ActivityPicture=@ActivityPicture,ActivityIntroduction=@ActivityIntroduction,Summary=@Summary,ActivityVerify=@ActivityVerify,ActivityStatus=@ActivityStatus where ActivityID=@ActivityID"; return(cn.Execute(sql, active)); }//复制UserInfo类对应代码,UserInfo全改为Activity,user全改为active //sql语句可复制题目给出的SQL }
public IActionResult ActivityShowFT(int ftid) { try { //获取全部数据 var ls = _activityRepository.Query(); Model.Activity aa = ls.FirstOrDefault(x => x.ActivityId.Equals(ftid)); return(Ok(aa)); } catch (Exception) { throw; } }
/// <summary> /// Updates Process and Activity and Refreshes operators status /// </summary> /// <param name="processVm"></param> public void Refresh(ProcessEditorVm processVm) { if (processVm != null) { Process = processVm.Model; Activity = processVm.ActivityModel; IsEnabled = true; } else { Process = null; Activity = null; IsEnabled = false; } refresh(); }
public int Uptdate(Model.Activity Model) { string sql = $"update Activity set ActivityName='{Model.ActivityName}', BeginTime='{Model.BeginTime}', EndTime='{Model.EndTime}', Slideshow='{Model.Slideshow}', State={Model.State},CreateDate='{Model.CreateDate}', ActivityTime={Model.ActivityTime} where ActivityId={Model.ActivityId}"; string sql2 = $"insert into Lognote values (NULL,'修改',NOW(),'Activity配置表');"; DapperHelper.Execute(sql2); int i = DapperHelper.Execute(sql); if (i > 0) { lst[lst.IndexOf(lst.FirstOrDefault(x => x.ActivityId == Model.ActivityId))] = Model; //重新存入 rh.SetList(lst, redisKey); } return(i); }
public int Insert(Model.Activity Model) { string sql = $"INSERT INTO Activity VALUES (NULL,'{Model.ActivityName}','{Model.BeginTime}','{Model.EndTime}','{Model.Slideshow}',{Model.State},NOW(),{Model.ActivityTime});"; string sql2 = $"insert into Lognote values (NULL,'添加',NOW(),'Activity配置表');"; DapperHelper.Execute(sql2); int i = DapperHelper.Execute(sql); if (i > 0) { Model = DapperHelper.GetList <Model.Activity>("select * from Activity order by ActivityId desc LIMIT 1").FirstOrDefault(); lst.Add(Model); //重新放入缓存 rh.SetList(lst, redisKey); } return(i); }
public int UptZt(int sid) { string sql = "select a.*,b.ActivityId,c.CommodityPic,b.ActivityName,b.BeginTime,b.EndTime,c.ShopPrice,NOW() times,c.CommodityName FROM SeckillCom a JOIN Activity b ON a.ActivityId=b.ActivityId JOIN Commodity c ON a.CommodityId=c.CommodityId"; List <Model.Activity> la = DapperHelper.GetList <Model.Activity>(sql); Model.Activity aa = la.FirstOrDefault(x => x.ActivityId.Equals(sid)); string sql1 = ""; if (aa.State == 0) { sql1 = $"UPDATE SeckillCom SET State=State+1 where SeckillComId={sid}"; } else { sql1 = $"UPDATE SeckillCom SET State=State-1 where SeckillComId={sid}"; } return(DapperHelper.Execute(sql1)); }
public ActionResult PutRecommend([FromBody]Model.Activity activity) { activity.recommendTime = DateTime.Now; try { var re = ""; if (activity.recommend == "否") re = "取消"; var n = DAL.Activity.Instance.UpdateRecommend(activity); if (n != 0) return Json(Result.Ok($"{re}推荐活动成功", activity.activityId)); else return Json(Result.Err("activityId不存在")); } catch(Exception ex) { if (ex.Message.ToLower().Contains("null")) return Json(Result.Err("推荐活动情况不能为空")); else return Json(Result.Err(ex.Message)); } }
public async Task <long> InsertActivity(Model.Activity data, long caseID) { var caseParam = new DynamicParameters(); caseParam.Add("@Type", data.Type); caseParam.Add("@RefID", data.RefID); caseParam.Add("@Action", data.Action); caseParam.Add("@Notes", data.Notes); caseParam.Add("@CaseID", caseID); caseParam.Add("@UserID", data.User?.ID ?? null); caseParam.Add("@Out", dbType: DbType.Int64, direction: ParameterDirection.Output); await SqlMapper.ExecuteAsync(_unitOfWork.Connection, "InsertActivity", caseParam, commandType : CommandType.StoredProcedure, transaction : _unitOfWork.Transaction); var activityID = caseParam.Get <long>("@Out"); return(activityID); }
public ActionResult Post([FromBody] Model.Activity activity) { try { int n = DAL.Activity.Instance.Add(activity); return(Json(Result.Ok("添加成功", n))); } catch (Exception ex) {//复制UsersController.cs对应代码,UserInfo改为Activity,user改为activity,Ok("添加成功")改为Ok("添加成功",n) if (ex.Message.ToLower().Contains("foreign key")) { return(Json(Result.Err("合法用户才能添加记录"))); } else if (ex.Message.ToLower().Contains("null"))//复制UsersController.cs对应代码 { return(Json(Result.Err("活动名称、结束时间、活动图片、活动审核情况、用户名不能为空"))); } else { return(Json(Result.Err(ex.Message))); } } }//复制UsersController.cs对应代码
public int Delete(string ids) { string sql = $"DELETE FROM Activity WHERE ActivityId IN ({ids})"; string sql2 = $"insert into Lognote values (NULL,'删除',NOW(),'Activity配置表');"; DapperHelper.Execute(sql2); int i = DapperHelper.Execute(sql); if (i > 0) { //如果是批量删除的话需要字符串截取 string[] arr = ids.Split(','); foreach (var item in arr) { //找到要删除的对象 Model.Activity ac = lst.FirstOrDefault(x => x.ActivityId.ToString().Equals(item)); lst.Remove(ac); } //重新存入 rh.SetList(lst, redisKey); } return(i); }
public InsertActivityCommand(Model.Activity data, Officer user, long caseID) { _data = data; _user = user; _caseID = caseID; }
public Object CreateProject(Model.Project project, string userName) { //获取创建人 Model.User user = new UserController().GetUserByName(userName); project.CreateUserId = user.Id; project.CurrentUserId = user.Id; //新建项目 Dictionary <string, string> backData = (Dictionary <string, string>)project.Create(); int projectId = Convert.ToInt32(backData["Id"]); try { //新建表单实例 Model.FormInst formInst = new Model.FormInst(); formInst.ProjectId = projectId; FormTempController formTempController = new FormTempController(); Model.FormTemp formTemp = (Model.FormTemp)formTempController.GetFormTempByBusinessId(project.BusinessId); formInst.Name = formTemp.Name; formInst.FormTempId = formTemp.Id; formInst.Content = System.IO.File.ReadAllBytes(path); formInst.Create(); //新建流程实例 ProcessController processController = new ProcessController(); Model.Process process = (Model.Process)processController.GetProcessByBusinessId(project.BusinessId); Model.Process_Inst process_Inst = new Model.Process_Inst(); process_Inst.ProcessId = process.Id; process_Inst.ProjectId = projectId; process_Inst.CreateUserId = user.Id; int processInstId = (int)process_Inst.Create(); //新建环节实例 ActivityController activityController = new ActivityController(); Model.Activity activity = (Model.Activity)activityController.GetActivityByProcessId(process.Id); Model.Activity_Inst activity_Inst = new Model.Activity_Inst(); activity_Inst.ActivityId = activity.Id; activity_Inst.ProcessInstId = processInstId; activity_Inst.ProjectId = project.Id; int activityInstId = (int)activity_Inst.Create(); //新建工作项 Model.WorkItem workItem = new Model.WorkItem(); workItem.ProjectId = projectId; workItem.State = 0; workItem.ActivityInstId = activityInstId; workItem.ReceiveUserId = user.Id; int workItemId = (int)workItem.Create(); project.WorkItemId = workItemId; project.Update(); //新建材料清单模板实例 MaterialTempController materialTempController = new MaterialTempController(); Model.MaterialTemp materialTemp = (Model.MaterialTemp)materialTempController.GetMaterialTempByBusinessId(project.BusinessId); Model.MaterialTemp_Inst materialTemp_Inst = new Model.MaterialTemp_Inst(); materialTemp_Inst.MaterialTempId = materialTemp.Id; materialTemp_Inst.Name = materialTemp.Name; materialTemp_Inst.ProjectId = projectId; materialTemp_Inst.Create(); } catch (Exception e) { Util.Log.LogHelper.WriteLog(e.Message); } //返回项目数据 return(Newtonsoft.Json.JsonConvert.SerializeObject(backData)); }
public async Task <long> InsertAttachment(long id, [FromBody] Model.Activity data, Guid userID, string username) { return(await _activityService.InsertActivity(data, new Officer(userID, username), id)); }
/// <summary> /// 添加 /// </summary> /// <param name="a"></param> /// <returns></returns> public int AddActivity(Model.Activity a) { string sql = $"insert into Activity values (null,'{a.ActivityName}', '{a.BeginTime}', '{a.EndTime}', '{a.Slideshow}', {a.State},'{a.CreateDate}', {a.ActivityTime})"; return(DapperHelper.Execute(sql)); }
/// <summary> /// 修改 /// </summary> /// <param name="a"></param> /// <returns></returns> public int UptActivity(Model.Activity a) { throw new NotImplementedException(); }
/// <summary> /// Creates an instance of ActivityVm and initializes it with the given model /// <para>parameter can't be null</para> /// </summary> /// <param name="model">Activity model (no entity reference required)</param> public ActivityVm(Model.Activity model) { Model = model; }