public void TestAddUh()
{
LbsModel.UserHobby uh = new LbsModel.UserHobby();
uh.U_ID = "2013zx";
uh.T_ID = 2;
Console.WriteLine(LbsDAl.UserHobbyDataAccess.AddUserHoby(uh));
}
/// <summary>
/// 添加用户爱好
/// </summary>
/// <param name="uh">用户爱好表实体类</param>
/// <returns>true or false</returns>
public static bool AddUserHoby(LbsModel.UserHobby uh)
{
string insert_command = "insert into userhobby (u_id,t_id,uh_createtime,uh_altertime)";
insert_command += " values (@u_id,@t_id,@uh_createtime,@uh_altertime)";
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_id", uh.U_ID),
new SqlParameter("@t_id", uh.T_ID),
new SqlParameter("@uh_createtime", uh.Uh_CreateTime),
new SqlParameter("@uh_altertime", uh.Uh_AlterTime)
};
int i = SQLHelper.ExecuteNonQuery(insert_command, CommandType.Text, p);
return(i > 0);
}
/// <summary>
/// 修改用户爱好
/// </summary>
/// <param name="uh">用户爱好实体类</param>
/// <param name="editAfter_t_id">修改值t_ID</param>
/// <returns>true or false</returns>
public static bool EditUserHobby(LbsModel.UserHobby uh, int editAfter_t_id)
{
string update_command = "update userhobby set u_id=@u_id,t_id=@editAfter_t_id,uh_createtime=@uh_createtime,uh_altertime=@uh_altertime";
update_command += " where t_id=@t_id and u_id=@u_id";
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_id", uh.U_ID),
new SqlParameter("@t_id", uh.T_ID),
new SqlParameter("@editAfter_t_id", editAfter_t_id),
new SqlParameter("@uh_createtime", uh.Uh_CreateTime),
new SqlParameter("@uh_altertime", uh.Uh_AlterTime)
};
int i = SQLHelper.ExecuteNonQuery(update_command, CommandType.Text, p);
return(i > 0);
}
/// <summary>
/// 根据用户ID和类型ID查询用户爱好
/// </summary>
/// <param name="u_ID">用户ID</param>
/// <param name="t_ID">用户爱好类型ID</param>
/// <returns>用户爱好信息实体类</returns>
public static LbsModel.UserHobby SelectByUT(string u_ID, int t_ID)
{
LbsModel.UserHobby uh = new LbsModel.UserHobby();
string selectAdInfo_command = "select * from userhobby ";
selectAdInfo_command += "where u_id=@u_id and t_id=@t_id";
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_id", u_ID),
new SqlParameter("@t_id", t_ID)
};
SqlDataReader sdr = SQLHelper.ExecuteDataReader(selectAdInfo_command, CommandType.Text, p);
//将数据库中的此用户信息放入实体类
while (sdr.Read())
{
uh.U_ID = sdr["u_id"].ToString();
uh.T_ID = (int)sdr["t_id"];
uh.Uh_CreateTime = sdr["uh_createtime"];
uh.Uh_AlterTime = sdr["uh_altertime"];
}
return(uh);
}
public void TestEditUh()
{
LbsModel.UserHobby uh = new LbsModel.UserHobby();
uh = LbsDAl.UserHobbyDataAccess.SelectByUT("2013zx", 2);
Console.WriteLine(LbsDAl.UserHobbyDataAccess.EditUserHobby(uh, 1));
}
