public ActionResult SetFlowerBad(Model.FlowerAppraise flowerAppraise) { if (flowerAppraise.Content != null) { Business.Sys_FlowerAppraise sys_FlowerAppraise = new Business.Sys_FlowerAppraise(); flowerAppraise.IsGood = "0"; flowerAppraise.UsersId = Utility.ChangeText.GetUsersId().ToString(); flowerAppraise.CreateTime = DateTime.Now; //同一登录人,对一个植物,一天只能提交一次 StringBuilder stb = new StringBuilder(); int userid = Utility.ChangeText.GetUsersId(); if (userid != 0) { stb.Append(" and UsersId=" + userid + ""); } if (!string.IsNullOrEmpty(flowerAppraise.ArrangementId)) { stb.Append(" and ArrangementId='" + flowerAppraise.ArrangementId + "'"); } string dt = DateTime.Now.ToShortDateString(); { stb.Append(" and CreateTime>'" + dt + "'"); } if (sys_FlowerAppraise.GetFlowerAppraiseCount(stb.ToString()).Count == 0) { sys_FlowerAppraise.InsertFlowerAppraise(flowerAppraise); Response.Write("<script>parent.layer.closeAll();</script>"); } else { ViewData["success"] = "今日已评价"; } } return(View()); }
/// <summary> /// 获得评价json数据 /// </summary> /// <author>wangwei</author> /// <returns></returns> public JsonResult GetAppraiseCount(string ArrangementId) { Business.Sys_FlowerAppraise sys_FlowerAppraise = new Business.Sys_FlowerAppraise(); StringBuilder sb = new StringBuilder(); var gcount = 0; var bcount = 0; if (ArrangementId != "") { sb.Append(" and ArrangementId=" + ArrangementId); List <Model.FlowerAppraise> list = sys_FlowerAppraise.GetFlowerAppraiseCount(sb.ToString()); gcount = list.Where(x => x.IsGood == "1").Count(); bcount = list.Where(x => x.IsGood == "0").Count(); } return(Json(new { gcount = gcount, bcount = bcount }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 好评提交 /// </summary> public ActionResult SetFlowerGood(string ArrangementId) { if (!string.IsNullOrEmpty(ArrangementId)) { Business.Sys_FlowerAppraise sys_FlowerAppraise = new Business.Sys_FlowerAppraise(); Model.FlowerAppraise flowerAppraise = new Model.FlowerAppraise(); flowerAppraise.IsGood = "1"; flowerAppraise.ArrangementId = ArrangementId; flowerAppraise.CreateTime = DateTime.Now; flowerAppraise.UsersId = Utility.ChangeText.GetUsersId().ToString(); //同一登录人,对一个植物,一天只能提交一次 StringBuilder stb = new StringBuilder(); int userid = Utility.ChangeText.GetUsersId(); if (userid != 0) { stb.Append(" and UsersId=" + userid + ""); } if (!string.IsNullOrEmpty(ArrangementId)) { stb.Append(" and ArrangementId='" + ArrangementId + "'"); } string dt = DateTime.Now.ToShortDateString(); { stb.Append(" and CreateTime>'" + dt + "'"); } if (sys_FlowerAppraise.GetFlowerAppraiseCount(stb.ToString()).Count == 0) { sys_FlowerAppraise.InsertFlowerAppraise(flowerAppraise); } else { return(Json(new { result = "OK", data = "0" }, "text/html", JsonRequestBehavior.AllowGet)); } } return(Json(new { result = "OK", data = "1" }, "text/html", JsonRequestBehavior.AllowGet)); }