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