public ActionResult Show(string id)
{
int newsId = 0;
if (!string.IsNullOrEmpty(id))
{
Int32.TryParse(id, out newsId);
}
SinglePageModel model = new SinglePageModel();
model.SinglePage = singlePageService.GetSingPageById(id.ToString());
if (model.SinglePage == null)
{
model.SinglePage = new SinglePage();
model.SinglePage.Title = "该记录不存在或已被删除";
}
return View(model);
}
public static SinglePageModel Get(string serialno)
{
string sql = "select * from odnshop_singlepage where serialno = '" + serialno + "'";
SinglePageModel info = null;
DataTable dt = MySqlDbHelper.Query(sql).Tables[0];
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
info = PopulateModel(dr, new SinglePageModel());
}
return(info);
}
public static void Add(SinglePageModel model)
{
string sql = @"INSERT INTO odnshop_singlepage(serialno ,title ,content) VALUES (?serialno,?title,?content)";
MySqlParameter[] parameters =
{
new MySqlParameter("?serialno", MySqlDbType.VarChar, 45),
new MySqlParameter("?title", MySqlDbType.VarChar, 200),
new MySqlParameter("?content", MySqlDbType.Text)
};
parameters[0].Value = model.serialno;
parameters[1].Value = model.title;
parameters[2].Value = model.content;
MySqlDbHelper.ExecuteSql(sql, parameters);
}
private static SinglePageModel PopulateModel(DataRow dr, SinglePageModel entity)
{
if (dr == null)
{
return(null);
}
SinglePageModel baseEntity = (SinglePageModel)Activator.CreateInstance(entity.GetType());
foreach (PropertyInfo propertyInfo in entity.GetType().GetProperties())
{
try
{
baseEntity.GetType().GetProperty(propertyInfo.Name).SetValue(baseEntity, dr[propertyInfo.Name], null);
}
catch { }
}
return(baseEntity);
}
public static void Update(SinglePageModel model)
{
string sql = @"update odnshop_singlepage set
serialno = ?serialno,
title = ?title,
content = ?content where pageid = ?pageid";
MySqlParameter[] parameters =
{
new MySqlParameter("?serialno", MySqlDbType.VarChar, 45),
new MySqlParameter("?title", MySqlDbType.VarChar, 200),
new MySqlParameter("?content", MySqlDbType.Text),
new MySqlParameter("?pageid", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.serialno;
parameters[1].Value = model.title;
parameters[2].Value = model.content;
parameters[3].Value = model.pageid;
MySqlDbHelper.ExecuteSql(sql, parameters);
}
