/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TravelAgent.Model.TourGuideGallery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TourGuideGallery ");
strSql.Append(" set guideid=@guideid,image=@image,routetime=@routetime,areaname=@areaname,routeid=@routeid,spotid=@spotid,width=@width,height=@height ");
strSql.Append(" where");
strSql.Append(" id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@guideid", SqlDbType.Int),
new SqlParameter("@image", SqlDbType.VarChar, 500),
new SqlParameter("@routetime", SqlDbType.Date),
new SqlParameter("@areaname", SqlDbType.VarChar, 500),
new SqlParameter("@routeid", SqlDbType.Int),
new SqlParameter("@spotid", SqlDbType.Int),
new SqlParameter("@width", SqlDbType.Int),
new SqlParameter("@height", SqlDbType.Int),
new SqlParameter("@id", SqlDbType.Int)
};
parameters[0].Value = model.guideid;
parameters[1].Value = model.image;
parameters[2].Value = model.routetime;
parameters[3].Value = model.areaname;
parameters[4].Value = model.routeid;
parameters[5].Value = model.spotid;
parameters[6].Value = model.width;
parameters[7].Value = model.height;
parameters[8].Value = model.id;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TravelAgent.Model.TourGuideGallery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TourGuideGallery(");
strSql.Append("guideid,image,routetime,areaname,routeid,spotid,width,height)");
strSql.Append(" values (");
strSql.Append("@guideid,@image,@routetime,@areaname,@routeid,@spotid,@width,@height)");
SqlParameter[] parameters =
{
new SqlParameter("@guideid", SqlDbType.Int),
new SqlParameter("@image", SqlDbType.VarChar, 500),
new SqlParameter("@routetime", SqlDbType.Date),
new SqlParameter("@areaname", SqlDbType.VarChar, 500),
new SqlParameter("@routeid", SqlDbType.Int),
new SqlParameter("@spotid", SqlDbType.Int),
new SqlParameter("@width", SqlDbType.Int),
new SqlParameter("@height", SqlDbType.Int)
};
parameters[0].Value = model.guideid;
parameters[1].Value = model.image;
parameters[2].Value = model.routetime;
parameters[3].Value = model.areaname;
parameters[4].Value = model.routeid;
parameters[5].Value = model.spotid;
parameters[6].Value = model.width;
parameters[7].Value = model.height;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 取得所有游记配置列表
/// </summary>
/// <param name="PId">父ID</param>
/// <param name="KId">种类ID</param>
/// <returns></returns>
public List <TravelAgent.Model.TourGuideGallery> GetList()
{
List <TravelAgent.Model.TourGuideGallery> dt = new List <Model.TourGuideGallery>();
string sql = "select * from TourGuideGallery ";
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.TourGuideGallery ty = GetModel(sid);
dt.Add(ty);
}
return(dt);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TravelAgent.Model.TourGuideGallery model)
{
TourGuideTempDAL.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelAgent.Model.TourGuideGallery model)
{
TourGuideTempDAL.Add(model);
return(TourGuideTempDAL.GetMaxID("Id"));
}
