public ActionResult Add(Model.FlowerActive Flower)
{
Flower.CreateTime = DateTime.Now;
Flower.UpdateTime = DateTime.Now;
Flower.UsersId = Utility.ChangeText.GetUsersId().ToString();
Business.Sys_FlowerActive Sys_FlowerActive = new Business.Sys_FlowerActive();
Sys_FlowerActive.InsertFlowerActive(Flower);
return(View());
}
public ActionResult Edit(Model.FlowerActive Flower)
{
Business.Sys_FlowerActive Sys_FlowerActive = new Business.Sys_FlowerActive();
Flower.UpdateTime = DateTime.Now;
Flower.UsersId = Utility.ChangeText.GetUsersId().ToString();
//ViewData["success"] = "修改失败";
if (Sys_FlowerActive.UpdateFlowerActive(Flower))
{
// ViewData["success"] = "修改成功";
}
Response.Write("<script>parent.layer.closeAll();</script>");
return(Content(""));
}
/// <summary>
/// 写入一条记录
/// </summary>
/// <param name="Flower"></param>
/// <returns></returns>
public bool InsertFlowerActive(Model.FlowerActive Flower)
{
const string sql = @"INSERT INTO FlowerActive(FlowerId,UsersId,Content,CreateTime,UpdateTime)
VALUES(@FlowerId,@UsersId,@Content,@CreateTime,@UpdateTime)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
Flower.FlowerId,
Flower.UsersId,
Flower.Content,
Flower.CreateTime,
Flower.UpdateTime,
})));
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="Flower"></param>
/// <returns></returns>
public bool UpdateFlowerActive(Model.FlowerActive Flower)
{
const string sql = @"UPDATE FlowerActive SET FlowerId=@FlowerId,UsersId=@UsersId,Content=@Content,
UpdateTime=@UpdateTime WHERE Id=@Id";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
Flower.FlowerId,
Flower.UsersId,
Flower.Content,
Flower.UpdateTime,
Flower.Id,
})));
}
public ActionResult Add(Model.FlowerActive Flower)
{
Flower.CreateTime = DateTime.Now;
Flower.UpdateTime = DateTime.Now;
Flower.UsersId = Utility.ChangeText.GetUsersId().ToString();
Business.Sys_FlowerActive Sys_FlowerActive = new Business.Sys_FlowerActive();
//ViewData["success"] = "添加失败";
if (Sys_FlowerActive.InsertFlowerActive(Flower))
{
// ViewData["success"] = "添加成功";
}
Response.Write("<script>parent.layer.closeAll();</script>");
return(View());
}
