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>
/// 修改一条记录
/// </summary>
/// <param name="Flower"></param>
/// <returns></returns>
public bool UpdateFlowerAppraise(Model.FlowerAppraise adv)
{
const string sql = @"UPDATE Adviertisement SET Title=@Title,UsersId=@UsersId,Content=@Content,
UpdateTime=@UpdateTime,Picture=@Picture,Pictures=@Pictures WHERE Id=@Id";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
adv.ArrangementId,
adv.UsersId,
adv.Content,
adv.UpdateTime,
adv.Pictures,
adv.ID,
})));
}
/// <summary>
/// 写入一条记录
/// </summary>
/// <param name="FlowerAppraise"></param>
/// <returns></returns>
public bool InsertFlowerAppraise(Model.FlowerAppraise adv)
{
const string sql = @"INSERT INTO FlowerAppraise(ArrangementId,UsersId,Content,CreateTime,UpdateTime,IsGood,Pictures)
VALUES(@ArrangementId,@UsersId,@Content,@CreateTime,@UpdateTime,@IsGood,@Pictures)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
adv.ArrangementId,
adv.UsersId,
adv.Content,
adv.CreateTime,
adv.UpdateTime,
adv.IsGood,
adv.Pictures
})));
}
/// <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));
}
