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