public int Update(CICheckItem checkitem) { const string sql = @"UPDATE CICheckItem SET UpdateTime = @UpdateTime, Status = @Status, ValidateNote = @ValidateNote, DeployNote = @DeployNote, VersionCode = @VersionCode, DemandCode = @DemandCode, CodeList = @CodeList, Attachment = @Attachment, Remark = @Remark, Developer = @Developer, Tester = @Tester, AddTime = @AddTime, GetVssCnt = @GetVssCnt, ItemType = @ItemType, UserName = @UserName, PlanId = @PlanId WHERE ID=@ID " ; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, checkitem)); } }
/// <summary> /// 更新checkitem /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int UpdateCheckItem(CICheckItem checkItem, CILog log) { if (log != null) { new LogService().InsertLog(log); } return(_checkItemRepository.Update(checkItem)); }
public int Delete(CICheckItem checkitem) { const string sql = "DELETE FROM CICheckItem WHERE ID=@ID "; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, new { ID = checkitem.ID })); } }
public ActionResult AddItemToPlan(CICheckItem Item) { var model = new CheckItemModel(); model.CheckItem = Item; bool success = true; //验证代码清单 #region 格式验证 if (Item.DemandCode == "") { ErrorNotification("需求编号不能为空"); success = false; } #endregion if (string.IsNullOrEmpty(Item.ID)) { Item.AddTime = DateTime.Now; Item.UpdateTime = DateTime.Now; Item.Developer = CurrentUser.FullName; Item.UserName = CurrentUser.UserName; Item.Status = "计划中"; //验证需求编号 if (!_checkItemService.ExistsDemandCode(Item.DemandCode)) { success = false; ErrorNotification("需求或者bug编号不存在"); return(AddItemToPlan()); } int num = 0; if (success) { Item.ID = Guid.NewGuid().ToString(); num = _checkItemService.InsertCheckItem(Item); } if (num > 0) { SuccessNotification("添加成功"); } else { ErrorNotification("添加失败"); return(AddItemToPlan()); } } if (success) { return(Redirect(Url.Action("checklist", "checkitem"))); } else { return(AddItemToPlan()); } }
public int Insert(CICheckItem checkitem) { var sql = @"INSERT INTO CICheckItem (ID,UpdateTime,Status,ValidateNote,DeployNote,VersionCode,DemandCode,CodeList,Attachment,Remark,Developer,Tester,AddTime,GetVssCnt,ItemType,UserName,PlanId) VALUES (@ID,@UpdateTime,@Status,@ValidateNote,@DeployNote,@VersionCode,@DemandCode,@CodeList,@Attachment,@Remark,@Developer,@Tester,@AddTime,@GetVssCnt,@ItemType,@UserName,@PlanId)"; using (var conn = new DapperHelper().OpenConnection()) { return(conn.Execute(sql, checkitem)); } }
/// <summary> /// 根据计划编号 获取计划开放时间 判断是否能编辑 /// </summary> /// <param name="item"></param> /// <returns></returns> public bool IsCanEdit(CICheckItem item) { //如果当期时间在此记录的计划时间范围之类才允许修改或者删除 var list = from plan in this.PlanList where plan.ID == item.PlanId select plan; if (list != null && list.Count() > 0) { var p = list.First(); return(DateTime.Now > Convert.ToDateTime(p.BeginTime) && DateTime.Now < Convert.ToDateTime(p.EndTime)); } return(false); }
/// <summary> /// 更新checkitem /// </summary> /// <param name="checkitem"></param> /// <returns></returns> public int UpdateCheckItem(CICheckItem checkItem) { //记录日志 var logService = new LogService(); var log = new CILog(); log.Contents = "修改提交物,开发人员:" + checkItem.Developer; log.UserName = (new UserService()).GetUserFromCookie().UserName; log.LogTime = DateTime.Now; log.DemandCode = checkItem.DemandCode; log.CodeFile = checkItem.CodeList; logService.InsertLog(log); return(UpdateCheckItem(checkItem, log)); }
public CheckItemModel() { CheckItem = new CICheckItem(); plan = new CIVersionPlan(); PlanSelectItem = new List <SelectListItem>(); }
public ActionResult ItemEdit(CICheckItem Item) { var model = new CheckItemModel(); model.CheckItem = Item; bool success = true; //验证代码清单 #region 格式验证 Item.CodeList = Item.CodeList.Trim().Replace("(", "(").Replace(")", ")"); //if (Item.CodeList == "") //{ // ErrorNotification("代码不能为空"); // success = false; //} if (Item.DemandCode == "") { ErrorNotification("需求编号不能为空"); success = false; } var attachment = Request.Files["AttachmentFile"]; if ((attachment == null || attachment.FileName == "") && string.IsNullOrEmpty(Item.Attachment)) { success = false; ErrorNotification("提交物不能为空"); } else { if (attachment != null && attachment.FileName != "") { var folder = "/" + ConfigHelper.GetValue("uploadpath") + "/" + CurrentUser.UserName; if (!System.IO.Directory.Exists(Server.MapPath(folder))) { System.IO.Directory.CreateDirectory(Server.MapPath(folder)); } var savepath = Server.MapPath(folder + "/" + attachment.FileName); if (System.IO.File.Exists(savepath)) { System.IO.File.Delete(savepath); } attachment.SaveAs(savepath); Item.Attachment = Request.Url.Authority + folder + "/" + attachment.FileName; if (Item.Attachment.IndexOf("http://") < 0) { Item.Attachment = "http://" + Item.Attachment; } } } if (Item.DeployNote == "") { success = false; ErrorNotification("部署注意事项不能为空"); } var codelist = Item.CodeList; if (!string.IsNullOrEmpty(codelist)) { codelist = codelist.Replace("/", @"\");//统一替换成反斜杠 string[] stringSeparators = new string[] { "\r\n" }; string[] files = codelist.Split(stringSeparators, StringSplitOptions.None); foreach (var file in files) { //正则验证:^ccms_7|ccms_6(\/[\w-]*)(新增)|(修改)$ //必须是ccms_7或者ccms_v6开头 var v6 = file.ToLower().IndexOf(@"ccms_v6\"); var v7 = file.ToLower().IndexOf(@"ccms_v7\"); if (v6 != 0 && v7 != 0) { ErrorNotification(@"代码必须是ccms_v7\或者ccms_v6\开头:" + file); success = false; } //(新增)或者(修改)结尾 var posfixadd = file.LastIndexOf("(新增)"); var postfixmod = file.LastIndexOf("(修改)"); if (posfixadd == -1 && postfixmod == -1) { success = false; ErrorNotification("代码必须是(新增)或者(修改)结尾:" + file); } // 中间必须包含这个斜杠 / if (file.IndexOf(@"\") <= 0) { success = false; ErrorNotification(@"代码中间必须包含这个斜杠 \:" + file); } // 不能包含这个斜杠 \ //if (file.IndexOf("\\") >= 0) //{ // success = false; // ErrorNotification("代码不能包含这个斜杠 \\:" + file); //} } } #endregion if (string.IsNullOrEmpty(Item.ID)) { Item.AddTime = DateTime.Now; Item.UpdateTime = DateTime.Now; Item.Developer = CurrentUser.FullName; Item.UserName = CurrentUser.UserName; //验证需求编号 if (!_checkItemService.ExistsDemandCode(Item.DemandCode)) { success = false; ErrorNotification("需求或者bug编号不存在"); return(View(model)); } int num = 0; if (success) { Item.ID = Guid.NewGuid().ToString(); num = _checkItemService.InsertCheckItem(Item); } if (num > 0) { SuccessNotification("添加成功"); } else { ErrorNotification("添加失败"); return(View(model)); } } else { var oldmodel = _checkItemService.GetCheckItem(Item.ID); Item.AddTime = oldmodel.AddTime; Item.GetVssCnt = oldmodel.GetVssCnt; Item.Developer = oldmodel.Developer; Item.UpdateTime = DateTime.Now; Item.PlanId = oldmodel.PlanId; Item.UserName = oldmodel.UserName; model.plan = new VersionPlanService().GetPlan(Item.PlanId); int num = 0; if (success) { num = _checkItemService.UpdateCheckItem(Item); } if (num > 0) { SuccessNotification("修改成功"); } else { ErrorNotification("修改失败"); return(View(model)); } } if (success) { var url = PressRequest.GetUrlReferrer(); return(Redirect(url)); } else { return(View(model)); } }