private string _3_Essay = "随笔"; //3对应【随笔】
/// <summary>
/// 通过ID查询
/// </summary>
/// <param name="id"></param>
/// <returns>没有数据的返回null</returns>
public Article GetById(string id)
{
Article model = new Article();
DataTable dt = _DataBase.GetOnlyById4MySql<Article>(id, model).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
return FillData.FillDataToEntity(model, dt);
}
else
{
return null;
}
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Insert(Article model)
{
if (model != null)
{
string sql = FillData.AppendSqlToInsert(model);
MySqlCommand cmd = new MySqlCommand(sql, DataBase.GetOpenConn4MySql());
MySqlParameter[] para = FillData.AppendParas<Article>(model);
cmd.Parameters.AddRange(para);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
return true;
}
return false;
}
else
{
return false;
}
}
public ActionResult Update(Article article)
{
if (article.Id != null)
{
var model = _IArticleService.GetById(article.Id);
model.TypeId = article.TypeId;
model.Title = article.Title;
model.Abstract = article.Abstract;
model.Pics = article.Pics;
model.Content = article.Content;
model.Tag = article.Tag;
model.ModifyTime = DateTime.Now;
model.ModifyUser = CUR_USER.UserName;
var result = _IArticleService.Update(model);
return AlertMsgAndJs("修改成功！", "history.go(-1);");
}
return AlertMsgAndJs("修改失败！", "history.go(-1);");
}
public ActionResult Insert(Article model)
{
model.Id = Guid.NewGuid().ToString("N");
model.UserId = CUR_USER.Id; //用户ID
model.CreateTime = DateTime.Now;
model.CreateUser = CUR_USER.UserName;
model.ModifyTime = DateTime.Now;
model.ModifyUser = CUR_USER.UserName;
var list = _IArticleService.Insert(model);
return AlertMsgAndJs("添加成功！", "history.go(-1);");
}
/// <summary>
/// 编辑文章
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Article model)
{
return _DataBase.UpdateModel<Article>(model);
}