public int Update(ShopingCarInfo model) { string strSql = SQL_UPDATE + PK_PARA_SET; DbParameter[] paras = makeParameterForUpdate(model); return(Db.Helper.ExecuteNonQuery(strSql, paras)); }
public int Update(ShopingCarInfo 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, ShopingCarInfo model) { model.ID = dr.GetInt32(0); model.UserName = dr.GetString(1); model.LineID = dr.GetInt32(2); model.LineName = dr.GetString(3); model.GroupID = dr.GetInt32(4); model.GoDate = dr.GetDateTime(5); model.BackDate = dr.GetDateTime(6); model.PromotionID = dr.GetInt32(7); model.PromotionName = dr.GetString(8); model.BuyNum = dr.GetInt32(9); }
private DbParameter[] makeParameterForAdd(ShopingCarInfo model) { DbParameter[] paras = { Db.Helper.MakeInParameter("@UserName", model.UserName), Db.Helper.MakeInParameter("@LineID", model.LineID), Db.Helper.MakeInParameter("@LineName", model.LineName), Db.Helper.MakeInParameter("@GroupID", model.GroupID), Db.Helper.MakeInParameter("@GoDate", model.GoDate), Db.Helper.MakeInParameter("@BackDate", model.BackDate), Db.Helper.MakeInParameter("@PromotionID", model.PromotionID), Db.Helper.MakeInParameter("@PromotionName", model.PromotionName), Db.Helper.MakeInParameter("@BuyNum", model.BuyNum) }; return(paras); }
public int Add(ShopingCarInfo model) { DbParameter[] paras = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(SQL_ADD, paras)); }
public int Add(ShopingCarInfo model, DbTransaction tran) { DbParameter[] para = makeParameterForAdd(model); return(Db.Helper.ExecuteNonQuery(tran, SQL_ADD, para)); }