/// <summary>
/// 获取最新的行程
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public static List <Tab_travel> GetNewTravel(int count)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@Count", count)
};
SqlDataReader dr = SQLHelper.ExecuteReader("GetNewTravel", CommandType.StoredProcedure, p);
List <Tab_travel> list = new List <Tab_travel>();
while (dr.Read())
{
Tab_travel tab_travel = new Tab_travel();
tab_travel.U_emaile = Convert.ToString(dr["u_emaile"]);
tab_travel.U_name = Convert.ToString(dr["u_name"]);
tab_travel.T_title = Convert.ToString(dr["t_title"]);
tab_travel.T_depart = Convert.ToString(dr["t_depart"]);
tab_travel.T_destination = Convert.ToString(dr["t_destination"]);
tab_travel.T_day1 = Convert.ToString(dr["t_day1"]);
tab_travel.T_day2 = Convert.ToString(dr["t_day2"]);
tab_travel.T_day3 = Convert.ToString(dr["t_day3"]);
tab_travel.T_day4 = Convert.ToString(dr["t_day4"]);
tab_travel.T_day5 = Convert.ToString(dr["t_day5"]);
tab_travel.T_startTime = Convert.ToDateTime(dr["t_startTime"]);
tab_travel.T_sumTime = Convert.ToInt32(dr["t_sumTime"]);
list.Add(tab_travel);
}
return(list);
}
/// <summary>
/// 获取所有的行程
/// </summary>
/// <returns></returns>
public static List <Tab_travel> GetAllTravel()
{
SqlDataReader dr = SQLHelper.ExecuteReader("GetAllTravel", CommandType.StoredProcedure, null);
List <Tab_travel> List = new List <Tab_travel>();
while (dr.Read())
{
Tab_travel tab_travel = new Tab_travel();
tab_travel.U_emaile = Convert.ToString(dr["u_emaile"]);
tab_travel.U_name = Convert.ToString(dr["u_name"]);
tab_travel.T_title = Convert.ToString(dr["t_title"]);
tab_travel.T_depart = Convert.ToString(dr["t_depart"]);
tab_travel.T_destination = Convert.ToString(dr["t_destination"]);
tab_travel.T_day1 = Convert.ToString(dr["t_day1"]);
tab_travel.T_day2 = Convert.ToString(dr["t_day2"]);
tab_travel.T_day3 = Convert.ToString(dr["t_day3"]);
tab_travel.T_day4 = Convert.ToString(dr["t_day4"]);
tab_travel.T_day5 = Convert.ToString(dr["t_day5"]);
tab_travel.UploadTime = Convert.ToDateTime(dr["UploadTime"]);
tab_travel.T_startTime = Convert.ToDateTime(dr["t_startTime"]);
tab_travel.T_sumTime = Convert.ToInt32(dr["t_sumTime"]);
List.Add(tab_travel);
}
return(List);
}
/// <summary>
/// 通过id获取行程
/// </summary>
/// <param name="u_id"></param>
/// <returns></returns>
public static Tab_travel GetTravelByID(int u_id)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_id", u_id)
};
SqlDataReader dr = SQLHelper.ExecuteReader("GetTravelByID", CommandType.StoredProcedure, p);
Tab_travel tab_travel = new Tab_travel();
if (dr.Read())
{
tab_travel.U_emaile = Convert.ToString(dr["u_emaile"]);
tab_travel.U_name = Convert.ToString(dr["u_name"]);
tab_travel.T_title = Convert.ToString(dr["t_title"]);
tab_travel.T_depart = Convert.ToString(dr["t_depart"]);
tab_travel.T_destination = Convert.ToString(dr["t_destination"]);
tab_travel.T_day1 = Convert.ToString(dr["t_day1"]);
tab_travel.T_day2 = Convert.ToString(dr["t_day2"]);
tab_travel.T_day3 = Convert.ToString(dr["t_day3"]);
tab_travel.T_day4 = Convert.ToString(dr["t_day4"]);
tab_travel.T_day5 = Convert.ToString(dr["t_day5"]);
tab_travel.UploadTime = Convert.ToDateTime(dr["UploadTime"]);
tab_travel.T_startTime = Convert.ToDateTime(dr["t_startTime"]);
tab_travel.T_sumTime = Convert.ToInt32(dr["t_sumTime"]);
}
return(tab_travel);
}
protected void Page_Load(object sender, EventArgs e)
{
//"123,46;345,123;45,123"
String route = Request["route"];
//BLL.addModel(route);
Response.ContentType = "text/json";
Response.Write("{'code':0,'errorinfo'}");
Tab_travel tab_travel = new Tab_travel();
Travel.Model.Tab_travel ta = new Tab_travel();
ta.T_day1 = route;
ta.U_emaile = "*****@*****.**";
Travel.BLL.TravelBusiness.AddTravel(tab_travel);
Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('成功')</script>");
//string u_emaile = "*****@*****.**";
//string u_password = "******";
//if (string.IsNullOrEmpty(u_emaile) || string.IsNullOrEmpty(u_password))
//{
// Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('账号或密码不能为空')</script>");
//}
//else
//{
// if (Travel.BLL.UserBusiness.Login(u_emaile, u_password))
// {
// //登录成功
// Session["u_emaile"] = u_emaile;
// Session["LastLoginTime"] = DateTime.Now.ToString();
// //给当前用户颁发一个身份凭证
// FormsAuthentication.RedirectFromLoginPage(u_emaile, false);
// //跳转到指定界面
// Response.Redirect("User/Personal_details.aspx");
// }
// else
// {
// Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('账号或密码输入错误！请重试')</script>");
// }
//}
}
/// <summary>
/// 添加行程
/// </summary>
/// <param name="travel"></param>
/// <returns></returns>
public static bool AddTravel(Tab_travel travel)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_emaile", travel.U_emaile),
new SqlParameter("@t_title", travel.T_title),
new SqlParameter("@t_depart", travel.T_depart),
new SqlParameter("@t_destination", travel.T_destination),
new SqlParameter("@UploadTime", travel.UploadTime),
new SqlParameter("@t_startTime", travel.T_startTime),
new SqlParameter("@t_sumTime", travel.T_sumTime),
};
int i = SQLHelper.ExecuteNonQuery("AddTravel", CommandType.StoredProcedure, p);
return(i > 0);
}
/// <summary>
/// 修改行程
/// </summary>
/// <param name="travel"></param>
/// <returns></returns>
public static bool ChangeTravel(Tab_travel travel)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_id", travel.U_id),
new SqlParameter("@t_title", travel.T_title),
new SqlParameter("@t_depart", travel.T_depart),
new SqlParameter("@t_destination", travel.T_destination),
new SqlParameter("@t_day1", travel.T_day1),
new SqlParameter("@t_day2", travel.T_day2),
new SqlParameter("@t_day3", travel.T_day3),
new SqlParameter("@t_day4", travel.T_day4),
new SqlParameter("@t_day5", travel.T_day5),
new SqlParameter("@UploadTime", travel.UploadTime),
new SqlParameter("@t_startTime", travel.T_startTime),
new SqlParameter("@t_sumTime", travel.T_sumTime)
};
int i = SQLHelper.ExecuteNonQuery("ChangeTravel", CommandType.StoredProcedure, p);
return(i > 0);
}
/// <summary>
/// 修改行程
/// </summary>
/// <param name="travel"></param>
/// <returns></returns>
public static bool ChangeTravel(Tab_travel travel)
{
return(DAL.TravelAccess.ChangeTravel(travel));
}
/// <summary>
/// 添加行程
/// </summary>
/// <param name="travel"></param>
/// <returns></returns>
public static bool AddTravel(Tab_travel travel)
{
return(DAL.TravelAccess.AddTravel(travel));
}
