/// <summary> /// 得到一个对象实体 /// </summary> public DogApi.Model.DogModel DataRowToModel(DataRow row) { DogApi.Model.DogModel model = new DogApi.Model.DogModel(); if (row != null) { if (row["dogid"] != null && row["dogid"].ToString() != "") { model.dogid = int.Parse(row["dogid"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["age"] != null && row["age"].ToString() != "") { model.age = int.Parse(row["age"].ToString()); } if (row["typeid"] != null && row["typeid"].ToString() != "") { model.typeid = int.Parse(row["typeid"].ToString()); } //model.lat=row["lat"].ToString(); //model.lng=row["lng"].ToString(); //model.alt=row["alt"].ToString(); if (row["userName"] != null) { model.userName = row["userName"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DogApi.Model.DogModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dog set "); strSql.Append("name=@name,"); strSql.Append("age=@age,"); strSql.Append("typeid=@typeid,"); strSql.Append("lat=@lat,"); strSql.Append("lng=@lng,"); strSql.Append("alt=@alt,"); strSql.Append("userName=@userName"); strSql.Append(" where dogid=@dogid "); SQLiteParameter[] parameters = { new SQLiteParameter("@name", DbType.String, 50), new SQLiteParameter("@age", DbType.Int32, 4), new SQLiteParameter("@typeid", DbType.Int32, 4), new SQLiteParameter("@lat", DbType.Double, 8), new SQLiteParameter("@lng", DbType.Double, 8), new SQLiteParameter("@alt", DbType.Double, 8), new SQLiteParameter("@userName", DbType.String, 50), new SQLiteParameter("@dogid", DbType.Int32, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.age; parameters[2].Value = model.typeid; parameters[3].Value = model.lat; parameters[4].Value = model.lng; parameters[5].Value = model.alt; parameters[6].Value = model.userName; parameters[7].Value = model.dogid; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DogApi.Model.DogModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dog("); strSql.Append("dogid,name,age,typeid,lat,lng,alt,userName)"); strSql.Append(" values ("); strSql.Append("@dogid,@name,@age,@typeid,@lat,@lng,@alt,@userName)"); SQLiteParameter[] parameters = { new SQLiteParameter("@dogid", DbType.Int32, 4), new SQLiteParameter("@name", DbType.String, 50), new SQLiteParameter("@age", DbType.Int32, 4), new SQLiteParameter("@typeid", DbType.Int32, 4), new SQLiteParameter("@lat", DbType.Double, 8), new SQLiteParameter("@lng", DbType.Double, 8), new SQLiteParameter("@alt", DbType.Double, 8), new SQLiteParameter("@userName", DbType.String, 50) }; parameters[0].Value = GetMaxId(); parameters[1].Value = model.name; parameters[2].Value = model.age; parameters[3].Value = model.typeid; parameters[4].Value = model.lat; parameters[5].Value = model.lng; parameters[6].Value = model.alt; parameters[7].Value = model.userName; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DogApi.Model.DogModel GetModel(int dogid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select dogid,name,age,typeid,lat,lng,alt,userName from dog "); strSql.Append(" where dogid=@dogid "); SQLiteParameter[] parameters = { new SQLiteParameter("@dogid", DbType.Int32, 4) }; parameters[0].Value = dogid; DogApi.Model.DogModel model = new DogApi.Model.DogModel(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }