public int Update(OrderDetailInfo model) { string strSql = SQL_UPDATE + PK_PARA_SET; DbParameter[] paras = makeParameterForUpdate(model); return(Db.Helper.ExecuteNonQuery(strSql, paras)); }
public int Update(OrderDetailInfo model, DbTransaction tran) { string strSql = SQL_UPDATE + PK_PARA_SET; DbParameter[] para = makeParameterForUpdate(model); return(Db.Helper.ExecuteNonQuery(tran, strSql, para)); }
private void fillModel(DbDataReader dr, OrderDetailInfo model) { model.ID = dr.GetInt32(0); model.OrderNum = dr.GetString(1); model.GroupID = dr.GetInt32(2); model.LineID = dr.GetInt32(3); model.AddMemberName = dr.GetString(4); model.RealName = dr.GetString(5); model.Sex = dr.GetString(6); model.IDNum = dr.GetString(7); model.MobileNum = dr.GetString(8); model.AddTime = dr.GetDateTime(9); model.Remarks = dr.GetString(10); model.ExtraFields = FieldsHelper.XmlDeserialize(dr.GetString(11)); }
private DbParameter[] makeParameterForAdd(OrderDetailInfo model) { DbParameter[] paras = { Db.Helper.MakeInParameter("@OrderNum", model.OrderNum), Db.Helper.MakeInParameter("@GroupID", model.GroupID), Db.Helper.MakeInParameter("@LineID", model.LineID), Db.Helper.MakeInParameter("@AddMemberName", model.AddMemberName), Db.Helper.MakeInParameter("@RealName", model.RealName), Db.Helper.MakeInParameter("@Sex", model.Sex), Db.Helper.MakeInParameter("@IDNum", model.IDNum), Db.Helper.MakeInParameter("@MobileNum", model.MobileNum), Db.Helper.MakeInParameter("@AddTime", model.AddTime), Db.Helper.MakeInParameter("@Remarks", model.Remarks), Db.Helper.MakeInParameter("@ExtraFields", FieldsHelper.XmlSerialize(model.ExtraFields)) }; return(paras); }
public int Add(OrderDetailInfo model) { DbParameter[] paras = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(SQL_ADD, paras)); }
public int Add(OrderDetailInfo model, DbTransaction tran) { DbParameter[] para = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(tran, SQL_ADD, para)); }