public static List <BaoYangYearCardPromotion> SelectBaoYangYearCardPromotion(SqlConnection conn, int yearCardId)
{
List <BaoYangYearCardPromotion> result = new List <BaoYangYearCardPromotion>();
var sql = @"SELECT
PKID,
YearCardId,
PromotionIndex,
PromotionPercentage,
CreateTime,
UpdateTime
FROM BaoYang..BaoYangYearCardPromotionPercentage (NOLOCK)
WHERE YearCardId = @YearCardId";
SqlParameter parameter = new SqlParameter("@YearCardId", yearCardId);
var dt = SqlHelper.ExecuteDataTable(conn, CommandType.Text, sql, parameter);
foreach (DataRow dr in dt.Rows)
{
BaoYangYearCardPromotion item = new BaoYangYearCardPromotion
{
Pkid = Convert.ToInt32(dr["PKID"]),
YearCardId = Convert.ToInt32(dr["YearCardId"]),
PromotionIndex = Convert.ToInt32(dr["PromotionIndex"]),
PromotionPercentage = Convert.ToDecimal(dr["PromotionPercentage"]),
CreateTime = dr["CreateTime"].ToString(),
UpdateTime = dr["UpdateTime"].ToString()
};
result.Add(item);
}
return(result);
}
public static bool AddYearCardPromotionPercentage(SqlConnection conn, BaoYangYearCardPromotion cardInfo)
{
var sql = @"INSERT INTO BaoYang..BaoYangYearCardPromotionPercentage
( YearCardId ,
PromotionIndex ,
PromotionPercentage ,
CreateTime ,
UpdateTime
)
VALUES ( @YearCardId ,
@PromotionIndex ,
@PromotionPercentage ,
GETDATE() ,
GETDATE()
)";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@YearCardId", cardInfo.YearCardId),
new SqlParameter("@PromotionIndex", cardInfo.PromotionIndex),
new SqlParameter("@PromotionPercentage", cardInfo.PromotionPercentage / 100)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
