/// <summary> /// 更新一条数据 /// </summary> public void Update(TravelAgent.Model.TourGuideSpot model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TourGuideSpot "); strSql.Append(" set guideid=@guideid,areaname=@areaname,routetime=@routetime,gallery=@gallery,sort=@sort,routeid=@routeid)"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@guideid", SqlDbType.Int), new SqlParameter("@areaname", SqlDbType.VarChar, 500), new SqlParameter("@routetime", SqlDbType.DateTime), new SqlParameter("@gallery", SqlDbType.VarChar, 500), new SqlParameter("@sort", SqlDbType.Int), new SqlParameter("@routeid", SqlDbType.Int), new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = model.guideid; parameters[1].Value = model.areaname; parameters[2].Value = model.routetime; parameters[3].Value = model.gallery; parameters[4].Value = model.sort; parameters[5].Value = model.routeid; parameters[6].Value = model.id; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(TravelAgent.Model.TourGuideSpot model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TourGuideSpot("); strSql.Append("guideid,areaname,routetime,gallery,sort,routeid)"); strSql.Append(" values ("); strSql.Append("@guideid,@areaname,@routetime,@gallery,@sort,@routeid)"); SqlParameter[] parameters = { new SqlParameter("@guideid", SqlDbType.Int), new SqlParameter("@areaname", SqlDbType.VarChar, 500), new SqlParameter("@routetime", SqlDbType.DateTime), new SqlParameter("@gallery", SqlDbType.VarChar, 500), new SqlParameter("@sort", SqlDbType.Int), new SqlParameter("@routeid", SqlDbType.Int) }; parameters[0].Value = model.guideid; parameters[1].Value = model.areaname; parameters[2].Value = model.routetime; parameters[3].Value = model.gallery; parameters[4].Value = model.sort; parameters[5].Value = model.routeid; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 取得所有游记配置列表 /// </summary> /// <param name="PId">父ID</param> /// <param name="KId">种类ID</param> /// <returns></returns> public List <TravelAgent.Model.TourGuideSpot> GetList() { List <TravelAgent.Model.TourGuideSpot> dt = new List <Model.TourGuideSpot>(); string sql = "select * from TourGuideSpot "; DataTable dts = DbHelperSQL.Query(sql).Tables[0]; for (int i = 0; i < dts.Rows.Count; i++) { int sid = Convert.ToInt32(dts.Rows[i]["id"]); TravelAgent.Model.TourGuideSpot ty = GetModel(sid); dt.Add(ty); } return(dt); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TravelAgent.Model.TourGuideSpot model) { TourGuideTempDAL.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TravelAgent.Model.TourGuideSpot model) { TourGuideTempDAL.Add(model); return(TourGuideTempDAL.GetMaxID("Id")); }