/// <summary> /// 得到一个对象实体 /// </summary> public Blogs.Model.BlogCommentArticle DataRowToModel(DataRow row) { Blogs.Model.BlogCommentArticle model = new Blogs.Model.BlogCommentArticle(); if (row != null) { if (row["cmaid"] != null && row["cmaid"].ToString() != "") { model.cmaid = int.Parse(row["cmaid"].ToString()); } if (row["cmaarticle"] != null && row["cmaarticle"].ToString() != "") { model.cmaarticle = int.Parse(row["cmaarticle"].ToString()); } if (row["cmaauthor"] != null && row["cmaauthor"].ToString() != "") { model.cmaauthor = int.Parse(row["cmaauthor"].ToString()); } if (row["cmatitle"] != null) { model.cmatitle = row["cmatitle"].ToString(); } if (row["cmacontent"] != null) { model.cmacontent = row["cmacontent"].ToString(); } if (row["cmaaddtime"] != null && row["cmaaddtime"].ToString() != "") { model.cmaaddtime = DateTime.Parse(row["cmaaddtime"].ToString()); } if (row["cmaisdel"] != null && row["cmaisdel"].ToString() != "") { if ((row["cmaisdel"].ToString() == "1") || (row["cmaisdel"].ToString().ToLower() == "true")) { model.cmaisdel = true; } else { model.cmaisdel = false; } } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Blogs.Model.BlogCommentArticle model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BlogCommentArticle set "); strSql.Append("cmaarticle=@cmaarticle,"); strSql.Append("cmaauthor=@cmaauthor,"); strSql.Append("cmatitle=@cmatitle,"); strSql.Append("cmacontent=@cmacontent,"); strSql.Append("cmaaddtime=@cmaaddtime,"); strSql.Append("cmaisdel=@cmaisdel"); strSql.Append(" where cmaid=@cmaid"); SQLiteParameter[] parameters = { new SQLiteParameter("@cmaarticle", DbType.Int32, 4), new SQLiteParameter("@cmaauthor", DbType.Int32, 4), new SQLiteParameter("@cmatitle", DbType.String), new SQLiteParameter("@cmacontent", DbType.String), new SQLiteParameter("@cmaaddtime", DbType.DateTime), new SQLiteParameter("@cmaisdel", DbType.Boolean), new SQLiteParameter("@cmaid", DbType.Int32, 8) }; parameters[0].Value = model.cmaarticle; parameters[1].Value = model.cmaauthor; parameters[2].Value = model.cmatitle; parameters[3].Value = model.cmacontent; parameters[4].Value = model.cmaaddtime; parameters[5].Value = model.cmaisdel; parameters[6].Value = model.cmaid; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Blogs.Model.BlogCommentArticle model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BlogCommentArticle("); strSql.Append("cmaid,cmaarticle,cmaauthor,cmatitle,cmacontent,cmaaddtime,cmaisdel)"); strSql.Append(" values ("); strSql.Append("@cmaid,@cmaarticle,@cmaauthor,@cmatitle,@cmacontent,@cmaaddtime,@cmaisdel)"); SQLiteParameter[] parameters = { new SQLiteParameter("@cmaid", DbType.Int32, 8), new SQLiteParameter("@cmaarticle", DbType.Int32, 4), new SQLiteParameter("@cmaauthor", DbType.Int32, 4), new SQLiteParameter("@cmatitle", DbType.String), new SQLiteParameter("@cmacontent", DbType.String), new SQLiteParameter("@cmaaddtime", DbType.DateTime), new SQLiteParameter("@cmaisdel", DbType.bit, 1) }; parameters[0].Value = model.cmaid; parameters[1].Value = model.cmaarticle; parameters[2].Value = model.cmaauthor; parameters[3].Value = model.cmatitle; parameters[4].Value = model.cmacontent; parameters[5].Value = model.cmaaddtime; parameters[6].Value = model.cmaisdel; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Blogs.Model.BlogCommentArticle model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BlogCommentArticle("); strSql.Append("cmaarticle,cmaauthor,cmatitle,cmacontent,cmaaddtime,cmaisdel)"); strSql.Append(" values ("); strSql.Append("@cmaarticle,@cmaauthor,@cmatitle,@cmacontent,@cmaaddtime,@cmaisdel)"); strSql.Append(";select LAST_INSERT_ROWID()"); SQLiteParameter[] parameters = { new SQLiteParameter("@cmaarticle", DbType.Int32, 4), new SQLiteParameter("@cmaauthor", DbType.Int32, 4), new SQLiteParameter("@cmatitle", DbType.String), new SQLiteParameter("@cmacontent", DbType.String), new SQLiteParameter("@cmaaddtime", DbType.DateTime), new SQLiteParameter("@cmaisdel", DbType.Boolean) }; parameters[0].Value = model.cmaarticle; parameters[1].Value = model.cmaauthor; parameters[2].Value = model.cmatitle; parameters[3].Value = model.cmacontent; parameters[4].Value = model.cmaaddtime; parameters[5].Value = model.cmaisdel; object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Blogs.Model.BlogCommentArticle GetModel(int cmaid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select cmaid,cmaarticle,cmaauthor,cmatitle,cmacontent,cmaaddtime,cmaisdel from BlogCommentArticle "); strSql.Append(" where cmaid=@cmaid"); SQLiteParameter[] parameters = { new SQLiteParameter("@cmaid", DbType.Int32, 4) }; parameters[0].Value = cmaid; Blogs.Model.BlogCommentArticle model = new Blogs.Model.BlogCommentArticle(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }