private void fillModel(DbDataReader dr, TravelGroupInfo model)
{
model.ID = dr.GetInt32(0);
model.LineID = dr.GetInt32(1);
model.Name = dr.GetString(2);
model.TotalNum = dr.GetInt32(3);
model.RemainNum = dr.GetInt32(4);
model.JoinNum = dr.GetInt32(5);
model.PromotionNum = dr.GetInt32(6);
model.GroupNum = dr.GetString(7);
model.GoDate = dr.GetDateTime(8);
model.BackDate = dr.GetDateTime(9);
model.GatheringTime = dr.GetString(10);
model.GatheringPlace = dr.GetString(11);
model.TransferPlace = dr.GetString(12);
model.GoTravel = dr.GetString(13);
model.BackTravel = dr.GetString(14);
model.OuterPrice = dr.GetDecimal(15);
model.InnerPrice = dr.GetDecimal(16);
model.Deposit = dr.GetDecimal(17);
model.GruopLeader = dr.GetString(18);
model.TravelGuide = dr.GetString(19);
model.IsDel = dr.GetInt32(20);
model.IsPublish = dr.GetInt32(21);
model.Remarks = dr.GetString(22);
model.AddUserName = dr.GetString(23);
model.AddUserRealName = dr.GetString(24);
model.AddTime = dr.GetDateTime(25);
model.ExtraFields = FieldsHelper.XmlDeserialize(dr.GetString(26));
}
private DbParameter[] makeParameterForUpdate(TravelGroupInfo model)
{
DbParameter[] paras =
{
Db.Helper.MakeInParameter("@LineID", model.LineID),
Db.Helper.MakeInParameter("@Name", model.Name),
Db.Helper.MakeInParameter("@TotalNum", model.TotalNum),
Db.Helper.MakeInParameter("@RemainNum", model.RemainNum),
Db.Helper.MakeInParameter("@JoinNum", model.JoinNum),
Db.Helper.MakeInParameter("@PromotionNum", model.PromotionNum),
Db.Helper.MakeInParameter("@GroupNum", model.GroupNum),
Db.Helper.MakeInParameter("@GoDate", model.GoDate),
Db.Helper.MakeInParameter("@BackDate", model.BackDate),
Db.Helper.MakeInParameter("@GatheringTime", model.GatheringTime),
Db.Helper.MakeInParameter("@GatheringPlace", model.GatheringPlace),
Db.Helper.MakeInParameter("@TransferPlace", model.TransferPlace),
Db.Helper.MakeInParameter("@GoTravel", model.GoTravel),
Db.Helper.MakeInParameter("@BackTravel", model.BackTravel),
Db.Helper.MakeInParameter("@OuterPrice", model.OuterPrice),
Db.Helper.MakeInParameter("@InnerPrice", model.InnerPrice),
Db.Helper.MakeInParameter("@Deposit", model.Deposit),
Db.Helper.MakeInParameter("@GruopLeader", model.GruopLeader),
Db.Helper.MakeInParameter("@TravelGuide", model.TravelGuide),
Db.Helper.MakeInParameter("@IsDel", model.IsDel),
Db.Helper.MakeInParameter("@IsPublish", model.IsPublish),
Db.Helper.MakeInParameter("@Remarks", model.Remarks),
Db.Helper.MakeInParameter("@AddUserName", model.AddUserName),
Db.Helper.MakeInParameter("@AddUserRealName", model.AddUserRealName),
Db.Helper.MakeInParameter("@AddTime", model.AddTime),
Db.Helper.MakeInParameter("@ExtraFields", FieldsHelper.XmlSerialize(model.ExtraFields)),
Db.Helper.MakeInParameter("@ID", model.ID)
};
return(paras);
}
public int Update(TravelGroupInfo model, DbTransaction tran)
{
string strSql = SQL_UPDATE + PK_PARA_SET;
DbParameter[] para = makeParameterForUpdate(model);
return(Db.Helper.ExecuteNonQuery(tran, strSql, para));
}
public int Update(TravelGroupInfo model)
{
string strSql = SQL_UPDATE + PK_PARA_SET;
DbParameter[] paras = makeParameterForUpdate(model);
return(Db.Helper.ExecuteNonQuery(strSql, paras));
}
public int Add(TravelGroupInfo model, DbTransaction tran)
{
DbParameter[] para = makeParameterForAdd(model);
return(Db.Helper.ExecuteNonQuery(tran, SQL_ADD, para));
}
public int Add(TravelGroupInfo model)
{
DbParameter[] paras = makeParameterForAdd(model);
return(Db.Helper.ExecuteNonQuery(SQL_ADD, paras));
}
