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)); }