protected void Page_Load(object sender, EventArgs e)
{
if (Request["uid"] != null)
{
int uid = Convert.ToInt32(Request["uid"]);
int lineid = Convert.ToInt32(Request["line_id"]);
int count = LineCollectBll.GetCount("LineId=" + lineid + " and ClubId=" + uid);
if (count > 0)
{
Response.Write("has");
}
else
{
TravelAgent.Model.ClubLineCollect model = new TravelAgent.Model.ClubLineCollect();
model.LineId = lineid;
model.ClubId = uid;
model.CollectDate = DateTime.Now;
if (LineCollectBll.Add(model) > 0)
{
Response.Write("success");
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelAgent.Model.ClubLineCollect model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ClubLineCollect(");
strSql.Append("LineId,ClubId,CollectDate)");
strSql.Append(" values (");
strSql.Append("@LineId,@ClubId,@CollectDate)");
SqlParameter[] parameters =
{
new SqlParameter("@LineId", SqlDbType.Int),
new SqlParameter("@ClubId", SqlDbType.Int),
new SqlParameter("@CollectDate", SqlDbType.DateTime)
};
parameters[0].Value = model.LineId;
parameters[1].Value = model.ClubId;
parameters[2].Value = model.CollectDate;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelAgent.Model.ClubLineCollect model)
{
return(dal.Add(model));
}
