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