/// <summary> /// 通过ID获取文章类型 /// </summary> /// <param name="Id"></param> /// <returns></returns> public ArticleType GetArticleTypeById(int Id) { ArticleType model = new ArticleType(); DataTable dt = dataBase.GetOnlyById4MySql(Id.ToString(), tableName).Tables[0]; if (dt != null) { return FillData.FillDataToEntity(model, dt); } else { return null; } }
/// <summary> /// 添加文章分类 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Insert(ArticleType model) { if (model != null) { string sql = FillData.AppendSqlToInsert(model); MySqlCommand cmd = new MySqlCommand(sql, DataBase.GetOpenConn4MySql()); MySqlParameter[] para = FillData.AppendParas(model); cmd.Parameters.AddRange(para); int result = cmd.ExecuteNonQuery(); if (result > 0) { return true; } return false; } else { return false; } }
public ActionResult Insert(string typeName, string mark) { try { ArticleType model = new ArticleType { Id = Guid.NewGuid().ToString("N"), TypeName = typeName, Mark = mark, CreateUser = CUR_USER.UserName, CreateTime = DateTime.Now }; if (_IArticleTypeService.Insert(model)) { return AlertMsg("添加成功!", Url.Action("AddArticle", "Home")); } else { return AlertMsgAndJs("添加失败!", "history.go(-1);"); } } catch (Exception e) { string error = string.Format("发生异常页: {0};异常信息: {1}", Request.Url, e.Message); log.Error(error); _ISysLogService.Insert(new SysLog() { Location = e.Source.ToString(), Content = "e.StackTrace:" + e.StackTrace + ",e.Data:" + e.Data, Error = e.Message, CreateUser = Session["UserName"] != null ? Session["UserName"].ToString() : "无用户名", RemoteHost = Request.UserHostAddress + ":" + Request.UserHostName, RequestData = Request.Params.ToString(), Browser = Request.Browser.Browser + Request.Browser.Version, ActionCode = Request.RawUrl, }); return AlertMsgAndJs("添加失败!", "history.go(-1);"); } }
public int Update(ArticleType model) { throw new NotImplementedException(); }
public bool Insert(ArticleType model) { return _IArticleTypeDao.Insert(model); }