public int Edittrip(B2b_com_protrip tourJourney)
{
using (var helper = new SqlHelper())
{
int r = new InternalB2b_com_protrip(helper).Edittrip(tourJourney);
return(r);
}
}
internal B2b_com_protrip GetLineTripById(int tripid, int productid)
{
string sql = @"SELECT [id]
,[ActivityArea]
,[Traffic]
,[ScenicActivity]
,[Description]
,[Hotel]
,[Dining]
,[productid]
,creator
,createdate
FROM [EtownDB].[dbo].[b2b_com_protrip] where productid=@productid and id=@tripid";
try
{
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@productid", productid);
cmd.AddParam("@tripid", tripid);
B2b_com_protrip u = null;
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
u = new B2b_com_protrip()
{
Id = reader.GetValue <int>("id"),
ActivityArea = reader.GetValue <string>("ActivityArea"),
Traffic = reader.GetValue <string>("Traffic"),
ScenicActivity = reader.GetValue <string>("ScenicActivity"),
Description = reader.GetValue <string>("Description"),
Hotel = reader.GetValue <string>("hotel"),
Dining = reader.GetValue <string>("Dining"),
Productid = reader.GetValue <int>("productid"),
Creator = reader.GetValue <int>("creator"),
CreateDate = reader.GetValue <DateTime>("createdate")
};
}
}
return(u);
}
catch (Exception e)
{
return(null);
}
}
internal int Edittrip(B2b_com_protrip tourJourney)
{
if (tourJourney.Id == 0)//新插入
{
string sql = @"INSERT INTO [EtownDB].[dbo].[b2b_com_protrip]
([ActivityArea]
,[Traffic]
,[ScenicActivity]
,[Description]
,[Hotel]
,[Dining]
,[productid]
,[Creator]
,[CreateDate])
VALUES
(@ActivityArea
,@Traffic
,@ScenicActivity
,@Description
,@Hotel
,@Dining
,@productid
,@Creator
,@CreateDate);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@ActivityArea", tourJourney.ActivityArea);
cmd.AddParam("@Traffic", tourJourney.Traffic);
cmd.AddParam("@ScenicActivity", tourJourney.ScenicActivity);
cmd.AddParam("@Description", tourJourney.Description);
cmd.AddParam("@Hotel", tourJourney.Hotel);
cmd.AddParam("@Dining", tourJourney.Dining);
cmd.AddParam("@productid", tourJourney.Productid);
cmd.AddParam("@Creator", tourJourney.Creator);
cmd.AddParam("@CreateDate", tourJourney.CreateDate);
object o = cmd.ExecuteScalar();
return(o == null ? 0 : int.Parse(o.ToString()));
}
else//编辑
{
string sql = @"UPDATE [EtownDB].[dbo].[b2b_com_protrip]
SET [ActivityArea] = @ActivityArea
,[Traffic] = @Traffic
,[ScenicActivity] = @ScenicActivity
,[Description] = @Description
,[Hotel] = @Hotel
,[Dining] = @Dining
,[productid] = @productid
,[Creator] = @Creator
,[CreateDate] = @CreateDate
WHERE id=@Id";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@Id", tourJourney.Id);
cmd.AddParam("@ActivityArea", tourJourney.ActivityArea);
cmd.AddParam("@Traffic", tourJourney.Traffic);
cmd.AddParam("@ScenicActivity", tourJourney.ScenicActivity);
cmd.AddParam("@Description", tourJourney.Description);
cmd.AddParam("@Hotel", tourJourney.Hotel);
cmd.AddParam("@Dining", tourJourney.Dining);
cmd.AddParam("@productid", tourJourney.Productid);
cmd.AddParam("@Creator", tourJourney.Creator);
cmd.AddParam("@CreateDate", tourJourney.CreateDate);
cmd.ExecuteNonQuery();
return(tourJourney.Id);
}
}
