/// <summary> /// 更新一条数据 /// </summary> public int Update(Model.Barries model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE Barries SET "); strSql.Append("LON=@in_LON,"); strSql.Append("LAT=@in_LAT,"); strSql.Append("PID=@in_PID,"); strSql.Append("BarriesName=@in_BarriesName"); strSql.Append(" WHERE ID=@in_ID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_LON", SqlDbType.Decimal), new SqlParameter("@in_LAT", SqlDbType.Decimal), new SqlParameter("@in_PID", SqlDbType.Int), new SqlParameter("@in_BarriesName", SqlDbType.NVarChar), new SqlParameter("@in_ID", SqlDbType.Int) }; cmdParms[0].Value = model.LON; cmdParms[1].Value = model.LAT; cmdParms[2].Value = model.PID; cmdParms[3].Value = model.Name; cmdParms[4].Value = model.ID; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.Barries GetModel(DbDataReader dr) { Model.Barries model = new Model.Barries(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.LON = DbHelperSQL.GetDouble(dr["LON"]); model.LAT = DbHelperSQL.GetDouble(dr["LAT"]); model.PID = DbHelperSQL.GetInt(dr["PID"]); model.Name = DbHelperSQL.GetString(dr["BarriesName"]); model.UID = DbHelperSQL.GetInt(dr["UID"]); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Barries GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM Barries "); strSql.Append(" WHERE ID=" + ID); Model.Barries model = null; using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return(model); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Barries model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO Barries("); strSql.Append("LON,LAT,PID,BarriesName,UID)"); strSql.Append(" VALUES ("); strSql.Append("@in_LON,@in_LAT,@in_PID,@in_BarriesName,@in_UID)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_LON", SqlDbType.Decimal), new SqlParameter("@in_LAT", SqlDbType.Decimal), new SqlParameter("@in_PID", SqlDbType.Int), new SqlParameter("@in_BarriesName", SqlDbType.NVarChar), new SqlParameter("@in_UID", SqlDbType.Int) }; cmdParms[0].Value = model.LON; cmdParms[1].Value = model.LAT; cmdParms[2].Value = model.PID; cmdParms[3].Value = model.Name; cmdParms[4].Value = -1; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }