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