private void fillModel(DbDataReader dr, TravelOrderInfo model) { model.OrderNum = dr.GetString(0); model.OrderType = dr.GetString(1); model.OrderStatus = dr.GetString(2); model.GroupID = dr.GetInt32(3); model.LineID = dr.GetInt32(4); model.TotalMoney = dr.GetDecimal(5); model.MoneyPayed = dr.GetDecimal(6); model.MoneyReturn = dr.GetDecimal(7); model.BuyNum = dr.GetInt32(8); model.CanChangeNum = dr.GetInt32(9); model.PromotionID = dr.GetInt32(10); model.CompanyRemarks = dr.GetString(11); model.AddTime = dr.GetDateTime(12); model.AddMemberName = dr.GetString(13); model.AddMemberMobile = dr.GetString(14); model.AddMemberRealName = dr.GetString(15); model.AddMemberRemarks = dr.GetString(16); model.InviteNum = dr.GetString(17); model.InviterUserName = dr.GetString(18); model.InviterRealName = dr.GetString(19); model.OperatorUserName = dr.GetString(20); model.OperatorRealName = dr.GetString(21); model.ExtraFields = FieldsHelper.XmlDeserialize(dr.GetString(22)); model.OrderHistory = dr.GetString(23); }
private DbParameter[] makeParameterForUpdate(TravelOrderInfo model) { DbParameter[] paras = { Db.Helper.MakeInParameter("@OrderType", model.OrderType), Db.Helper.MakeInParameter("@OrderStatus", model.OrderStatus), Db.Helper.MakeInParameter("@GroupID", model.GroupID), Db.Helper.MakeInParameter("@LineID", model.LineID), Db.Helper.MakeInParameter("@TotalMoney", model.TotalMoney), Db.Helper.MakeInParameter("@MoneyPayed", model.MoneyPayed), Db.Helper.MakeInParameter("@MoneyReturn", model.MoneyReturn), Db.Helper.MakeInParameter("@BuyNum", model.BuyNum), Db.Helper.MakeInParameter("@CanChangeNum", model.CanChangeNum), Db.Helper.MakeInParameter("@PromotionID", model.PromotionID), Db.Helper.MakeInParameter("@CompanyRemarks", model.CompanyRemarks), Db.Helper.MakeInParameter("@AddTime", model.AddTime), Db.Helper.MakeInParameter("@AddMemberName", model.AddMemberName), Db.Helper.MakeInParameter("@AddMemberMobile", model.AddMemberMobile), Db.Helper.MakeInParameter("@AddMemberRealName", model.AddMemberRealName), Db.Helper.MakeInParameter("@AddMemberRemarks", model.AddMemberRemarks), Db.Helper.MakeInParameter("@InviteNum", model.InviteNum), Db.Helper.MakeInParameter("@InviterUserName", model.InviterUserName), Db.Helper.MakeInParameter("@InviterRealName", model.InviterRealName), Db.Helper.MakeInParameter("@OperatorUserName", model.OperatorUserName), Db.Helper.MakeInParameter("@OperatorRealName", model.OperatorRealName), Db.Helper.MakeInParameter("@ExtraFields", FieldsHelper.XmlSerialize(model.ExtraFields)), Db.Helper.MakeInParameter("@OrderHistory", model.OrderHistory), Db.Helper.MakeInParameter("@OrderNum", model.OrderNum) }; return(paras); }
public int Update(TravelOrderInfo model, DbTransaction tran) { string strSql = SQL_UPDATE + PK_PARA_SET; DbParameter[] para = makeParameterForUpdate(model); return(Db.Helper.ExecuteNonQuery(tran, strSql, para)); }
public int Update(TravelOrderInfo model) { string strSql = SQL_UPDATE + PK_PARA_SET; DbParameter[] paras = makeParameterForUpdate(model); return(Db.Helper.ExecuteNonQuery(strSql, paras)); }
public int Add(TravelOrderInfo model, DbTransaction tran) { DbParameter[] para = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(tran, SQL_ADD, para)); }
public int Add(TravelOrderInfo model) { DbParameter[] paras = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(SQL_ADD, paras)); }