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