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