/// <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"));
}
