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