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