/// <summary> /// 得到一个对象实体 /// </summary> public RoadSolution.Model.PersonPosition GetModel(string PositionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from PersonPosition "); strSql.Append(" where PositionID='" + PositionID + "'"); RoadSolution.Model.PersonPosition model = new RoadSolution.Model.PersonPosition(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); model.PositionID = PositionID; if (ds.Tables[0].Rows.Count > 0) { model.UserID = ds.Tables[0].Rows[0]["UserID"].ToString(); model.PositionDate = ds.Tables[0].Rows[0]["PositionDate"].ToString(); if (ds.Tables[0].Rows[0]["PositionTime"].ToString() != "") { model.PositionTime = DateTime.Parse(ds.Tables[0].Rows[0]["PositionTime"].ToString()); } if (ds.Tables[0].Rows[0]["Lat"].ToString() != "") { model.Lat = decimal.Parse(ds.Tables[0].Rows[0]["Lat"].ToString()); } if (ds.Tables[0].Rows[0]["Lng"].ToString() != "") { model.Lng = decimal.Parse(ds.Tables[0].Rows[0]["Lng"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(RoadSolution.Model.PersonPosition model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PersonPosition set "); strSql.Append("UserID='" + model.UserID + "',"); strSql.Append("PositionDate='" + model.PositionDate + "',"); strSql.Append("PositionTime='" + model.PositionTime + "',"); strSql.Append("Lat=" + model.Lat + ","); strSql.Append("Lng=" + model.Lng + ""); strSql.Append(" where PositionID='" + model.PositionID + "'"); DbHelperSQL.ExecuteSql(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(RoadSolution.Model.PersonPosition model) { model.PositionID = GetMaxId().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PersonPosition("); strSql.Append("PositionID,UserID,PositionDate,PositionTime,Lat,Lng"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.PositionID + "',"); strSql.Append("'" + model.UserID + "',"); strSql.Append("'" + model.PositionDate + "',"); strSql.Append("'" + model.PositionTime + "',"); strSql.Append("" + model.Lat + ","); strSql.Append("" + model.Lng + ""); strSql.Append(")"); DbHelperSQL.ExecuteSql(strSql.ToString()); return(model.PositionID); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(RoadSolution.Model.PersonPosition model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(RoadSolution.Model.PersonPosition model) { return(dal.Add(model)); }