/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TravelAgent.Model.TourComment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TourComment set ");
strSql.Append(" contents=@contents,comment_type=@comment_type,comment_rel_id=@comment_rel_id,user_id=@user_id,nickname=@nickname,create_time=@create_time");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@contents", SqlDbType.VarChar, 100),
new SqlParameter("@comment_type", SqlDbType.Int, 11),
new SqlParameter("@comment_rel_id", SqlDbType.Int, 11),
new SqlParameter("@user_id", SqlDbType.Int, 11),
new SqlParameter("@nickname", SqlDbType.VarChar, 100),
new SqlParameter("@create_time", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 10)
};
parameters[0].Value = model.contents;
parameters[1].Value = model.comment_type;
parameters[2].Value = model.comment_rel_id;
parameters[3].Value = model.user_id;
parameters[4].Value = model.nickname;
parameters[5].Value = model.create_time;
parameters[6].Value = model.id;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TravelAgent.Model.TourComment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TourComment(");
strSql.Append(" contents,comment_type,comment_rel_id,user_id,nickname,create_time)");
strSql.Append(" values (");
strSql.Append(" @contents,@comment_type,@comment_rel_id,@user_id,@nickname,@create_time)");
SqlParameter[] parameters =
{
new SqlParameter("@contents", SqlDbType.VarChar, 100),
new SqlParameter("@comment_type", SqlDbType.Int, 11),
new SqlParameter("@comment_rel_id", SqlDbType.Int, 11),
new SqlParameter("@user_id", SqlDbType.Int, 11),
new SqlParameter("@nickname", SqlDbType.VarChar, 100),
new SqlParameter("@create_time", SqlDbType.DateTime)
};
parameters[0].Value = model.contents;
parameters[1].Value = model.comment_type;
parameters[2].Value = model.comment_rel_id;
parameters[3].Value = model.user_id;
parameters[4].Value = model.nickname;
parameters[5].Value = model.create_time;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
public List <TravelAgent.Model.TourComment> GetList(int comment_rel_id)
{
List <TravelAgent.Model.TourComment> dt = new List <Model.TourComment>();
string sql = string.Format("select * from TourComment where comment_rel_id='{0}' order by id desc ", comment_rel_id);
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.TourComment ty = GetModel(sid);
dt.Add(ty);
}
return(dt);
}
/// <summary>
/// 取得所有游记列表
/// </summary>
/// <param name="PId">父ID</param>
/// <param name="KId">种类ID</param>
/// <returns></returns>
public List <TravelAgent.Model.TourComment> GetList()
{
List <TravelAgent.Model.TourComment> dt = new List <Model.TourComment>();
string sql = "select * from TourComment ";
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.TourComment ty = GetModel(sid);
dt.Add(ty);
}
return(dt);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TravelAgent.Model.TourComment model)
{
TourGuideDAL.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelAgent.Model.TourComment model)
{
TourGuideDAL.Add(model);
return(TourGuideDAL.GetMaxID("Id"));
}