public static int AddApp(Models.WebApp model)
{
int id = 0;
string sql = @"INSERT INTO webapp
(Name,
DesignHTML,
PreviewHTML,
CreateTime,
Creator,
State,
IsDelete)
VALUES
(@Name,
@DesignHTML,
@PreviewHTML,
@CreateTime,
@Creator,
@State,0);select @@IDENTITY";
using (IDbConnection conn = DBHelper.OpenConnection())
{
id = conn.Query <int>(sql, model).FirstOrDefault();
}
return(id);
}
/// <summary>
/// 预览页面
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Preview(int id)
{
if (id <= 0)
{
return(Content("id错误"));
}
Models.WebApp app = WebAppService.GetAppById(id);
return(View(app));
}
public static Models.WebApp GetAppById(int id)
{
Models.WebApp model = null;
string sql = @"select * from webapp where AppId=@id";
using (IDbConnection conn = DBHelper.OpenConnection())
{
model = conn.Query <Models.WebApp>(sql, new { id = id }).FirstOrDefault();
}
return(model);
}
public static void UpdateApp(Models.WebApp model)
{
string sql = @"UPDATE webapp
SET
Name = @Name,
DesignHTML = @DesignHTML,
PreviewHTML = @PreviewHTML,
State = @State
WHERE AppId = @AppId";
using (IDbConnection conn = DBHelper.OpenConnection())
{
conn.Execute(sql, model);
}
}
