/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MediaVideoGroup set "); strSql.Append("MediaVideoGroupName=@MediaVideoGroupName,"); strSql.Append("MediaVideoGroupDes=@MediaVideoGroupDes"); strSql.Append(" where MediaVideoGroupID=@MediaVideoGroupID "); SQLiteParameter[] parameters = { new SQLiteParameter("@MediaVideoGroupName", DbType.String), new SQLiteParameter("@MediaVideoGroupDes", DbType.String), new SQLiteParameter("@MediaVideoGroupID", DbType.Int32, 4) }; parameters[0].Value = model.MediaVideoGroupName; parameters[1].Value = model.MediaVideoGroupDes; parameters[2].Value = model.MediaVideoGroupID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MediaVideoGroup("); strSql.Append("MediaVideoGroupID,MediaVideoGroupName,MediaVideoGroupDes)"); strSql.Append(" values ("); strSql.Append("@MediaVideoGroupID,@MediaVideoGroupName,@MediaVideoGroupDes)"); SQLiteParameter[] parameters = { new SQLiteParameter("@MediaVideoGroupID", DbType.Int32, 4), new SQLiteParameter("@MediaVideoGroupName", DbType.String), new SQLiteParameter("@MediaVideoGroupDes", DbType.String) }; parameters[0].Value = model.MediaVideoGroupID; parameters[1].Value = model.MediaVideoGroupName; parameters[2].Value = model.MediaVideoGroupDes; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup model = new KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup(); if (row != null) { if (row["MediaVideoGroupID"] != null && row["MediaVideoGroupID"].ToString() != "") { model.MediaVideoGroupID = int.Parse(row["MediaVideoGroupID"].ToString()); } if (row["MediaVideoGroupName"] != null) { model.MediaVideoGroupName = row["MediaVideoGroupName"].ToString(); } if (row["MediaVideoGroupDes"] != null) { model.MediaVideoGroupDes = row["MediaVideoGroupDes"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup GetModel(int MediaVideoGroupID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MediaVideoGroupID,MediaVideoGroupName,MediaVideoGroupDes from MediaVideoGroup "); strSql.Append(" where MediaVideoGroupID=@MediaVideoGroupID "); SQLiteParameter[] parameters = { new SQLiteParameter("@MediaVideoGroupID", DbType.Int32, 4) }; parameters[0].Value = MediaVideoGroupID; KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup model = new KryptonAccessController.SQLite.Model.LCDRelation.MediaVideoGroup(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }