public void addRequirementImg(HttpContext context) { RequirementImg requirementImg = new RequirementImg(); requirementImg.Requirement.Id = Convert.ToInt32(context.Request["Id"]); Dictionary <String, Object> dictionary = new Dictionary <string, object>(); string savepath = ""; if (context.Request.Files.Count > 0) { HttpPostedFile file1 = context.Request.Files["smallImg"]; savepath = FileUtil.uploadImg(file1, "../images/"); } requirementImg.ImgPath = savepath; requirementImg.ImgStatus = 0; Boolean flag = requirementService.addRequirementImg(requirementImg); if (flag) { dictionary.Add("success", "true"); } else { dictionary.Add("success", "false"); } context.Response.Write(JsonUtil.toJson(dictionary).ToString()); }
public List <RequirementImg> queryRequirementImgByRequirementId(int requirementId) { String sql = "SELECT * FROM tb_requirement_img WHERE requirement_id = @requirement_id"; SqlCommand cmd = DbUtil.getCommand(sql); cmd.Parameters.Add(new SqlParameter("@requirement_id", requirementId)); List <RequirementImg> list = new List <RequirementImg>(); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { RequirementImg requirementImg = new RequirementImg(); requirementImg.Id = sdr.GetInt32(0); requirementImg.ImgPath = sdr.GetString(1); requirementImg.ImgStatus = sdr.GetInt32(2); requirementImg.Requirement.Id = sdr.GetInt32(3); list.Add(requirementImg); } } sdr.Close(); DbUtil.close(cmd); return(list); }
public Boolean updateRequirement(Requirement requirement, List <RequirementImg> list) { requirement.ModifyTime = DateTime.Now; if (list.Count != 0) { //删除原有的图片 RequirementImg requirementImg = requirementImgDao.queryRequirementFirstImgByRequirementId(requirement.Id); List <RequirementImg> listExsit = requirementImgDao.queryRequirementDescImgByRequirementId(requirement.Id); listExsit.Add(requirementImg); foreach (RequirementImg s in listExsit) { if (s.ImgPath != null) { File.Delete(s.ImgPath); } } requirementImgDao.deleteRequirementImgByRequirementId(requirement.Id); //插入新图片 foreach (RequirementImg s in list) { requirementImgDao.insertRequirementImg(s); } } return(requirementDao.updateRequirementById(requirement)); }
public void listByName(HttpContext context) { context.Response.ContentType = "text/plain"; context.Request.ContentEncoding = Encoding.UTF8; context.Response.ContentEncoding = Encoding.UTF8; List <Requirement> list = requirementService.getRequirementListByName(context.Request["searchname"].ToString()); StringBuilder jsonString = new StringBuilder(); Dictionary <String, Object> dictionary = new Dictionary <string, object>(); //jsonString.Append("\"supply\":"); string imgPath = "hotel1.jpg"; if (list.Count == 0) { context.Response.Write("{\"success\":\"false\"}"); return; } jsonString.Append("["); int i = 1; foreach (Requirement requirement in list) { RequirementImg requirementImg = requirementService.getRequirementFirstImg(requirement.Id); if (requirementImg.ImgPath != null) { imgPath = System.IO.Path.GetFileName(requirementImg.ImgPath); } dictionary.Add("Id", requirement.Id); dictionary.Add("Name", requirement.RequirementName); dictionary.Add("Desc", requirement.RequirementDesc); dictionary.Add("categoryId", requirement.RequirementCategory.Id); dictionary.Add("priority", requirement.Priority); dictionary.Add("userId", requirement.User.Id); dictionary.Add("nickName", requirement.User.NickName); dictionary.Add("teleNumber", requirement.User.TeleNumber); dictionary.Add("createTime", requirement.CreateTime); dictionary.Add("modifyTime", requirement.ModifyTime); dictionary.Add("Status", requirement.RequirementStatus); dictionary.Add("FirstImgPath", imgPath); dictionary.Add("success", "true"); jsonString.Append(JsonUtil.toJson(dictionary)); if (i < list.Count) { jsonString.Append(","); } i++; dictionary.Clear(); } jsonString.Append("]"); context.Response.Write(jsonString.ToString()); }
public Boolean removeRequirementById(int requirementId) { RequirementImg requirementImg = requirementImgDao.queryRequirementFirstImgByRequirementId(requirementId); List <RequirementImg> list = requirementImgDao.queryRequirementDescImgByRequirementId(requirementId); list.Add(requirementImg); foreach (RequirementImg s in list) { if (s.ImgPath != null) { File.Delete(s.ImgPath); } } Boolean flagRequirementImg = requirementImgDao.deleteRequirementImgByRequirementId(requirementId); Boolean flagRequirement = requirementDao.deleteRequirementById(requirementId); return(flagRequirement); }
public void allRequirementList(HttpContext context) { context.Response.ContentType = "text/plain"; List <Requirement> list = requirementService.getAllRequirementListWithoutBanned(); StringBuilder jsonString = new StringBuilder(); Dictionary <String, Object> dictionary = new Dictionary <string, object>(); jsonString.Append("["); int i = 1; foreach (Requirement requirement in list) { string imgPath = "defaultImg.jpg"; RequirementImg requirementImg = requirementService.getRequirementFirstImg(requirement.Id); if (requirementImg.ImgPath != null && requirementImg.ImgPath != "") { imgPath = System.IO.Path.GetFileName(requirementImg.ImgPath); } dictionary.Add("Id", requirement.Id); dictionary.Add("Name", requirement.RequirementName); dictionary.Add("Desc", requirement.RequirementDesc); dictionary.Add("categoryId", requirement.RequirementCategory.Id); dictionary.Add("priority", requirement.Priority); dictionary.Add("userId", requirement.User.Id); dictionary.Add("nickName", requirement.User.NickName); dictionary.Add("teleNumber", requirement.User.TeleNumber); dictionary.Add("createTime", requirement.CreateTime); dictionary.Add("modifyTime", requirement.ModifyTime); dictionary.Add("Status", requirement.RequirementStatus); dictionary.Add("FirstImgPath", imgPath); dictionary.Add("success", "true"); jsonString.Append(JsonUtil.toJson(dictionary)); if (i < list.Count) { jsonString.Append(","); } i++; dictionary.Clear(); } jsonString.Append("]"); context.Response.Write(jsonString.ToString()); }
public Boolean insertRequirementImg(RequirementImg requirementImg) { String sql = "INSERT INTO tb_requirement_img(img_path,img_status,requirement_id) VALUES(@img_path,@img_status,@requirement_id)"; SqlCommand cmd = DbUtil.getCommand(sql); cmd.Parameters.Add(new SqlParameter("@img_path", requirementImg.ImgPath)); cmd.Parameters.Add(new SqlParameter("@img_status", requirementImg.ImgStatus));//0缩略图,1详情图 cmd.Parameters.Add(new SqlParameter("@requirement_id", requirementImg.Requirement.Id)); int i = cmd.ExecuteNonQuery(); DbUtil.close(cmd); if (i > 0) { return(true); } else { return(false); } }
public RequirementImg queryRequirementFirstImgByRequirementId(int requirementId) { String sql = "SELECT * FROM tb_requirement_img WHERE requirement_id = @requirement_id AND img_status = 0"; SqlCommand cmd = DbUtil.getCommand(sql); cmd.Parameters.Add(new SqlParameter("@requirement_id", requirementId)); SqlDataReader sdr = cmd.ExecuteReader(); RequirementImg requirementImg = new RequirementImg(); if (sdr.HasRows) { sdr.Read(); requirementImg.Id = sdr.GetInt32(0); requirementImg.ImgPath = sdr.GetString(1); requirementImg.ImgStatus = sdr.GetInt32(2); requirementImg.Requirement.Id = sdr.GetInt32(3); } sdr.Close(); DbUtil.close(cmd); return(requirementImg); }
public void updateMyRequirement(HttpContext context) { context.Response.ContentType = "text/plain"; Requirement requirement = new Requirement(); requirement.Id = Convert.ToInt32(context.Request["Id"]); requirement.RequirementName = context.Request["Name"]; requirement.RequirementDesc = context.Request["Desc"]; requirement.RequirementCategory.Id = Convert.ToInt32(context.Request["CategoryId"]); Dictionary <String, Object> dictionary = new Dictionary <string, object>(); string savepath = ""; List <RequirementImg> list = new List <RequirementImg>(); if (context.Request.Files.Count > 0) { for (int i = 0; i < context.Request.Files.Count; i++) { RequirementImg requirementImg = new RequirementImg(); requirementImg.Requirement.Id = Convert.ToInt32(context.Request["Id"]); HttpPostedFile file1 = context.Request.Files["descImg" + i]; requirementImg.ImgStatus = Convert.ToInt32(context.Request["status" + i]); savepath = FileUtil.uploadImg(file1, "../images/"); requirementImg.ImgPath = savepath; list.Add(requirementImg); } } Boolean flag = requirementService.updateRequirement(requirement, list); if (flag) { dictionary.Add("success", "true"); } else { dictionary.Add("success", "false"); } context.Response.Write(JsonUtil.toJson(dictionary).ToString()); }
public Boolean addRequirementImg(RequirementImg requirementImg) { return(requirementImgDao.insertRequirementImg(requirementImg)); }