public static bool AddBaoYangYearCardDetail(SqlConnection conn, BaoYangYearCardDetail details)
{
var sql = @"INSERT INTO BaoYang..BaoYangYearCardDetail
( YearCardId ,
PromotionIndex ,
PackageType ,
BaoYangType ,
PID ,
ProductCount ,
CreateTime
)
VALUES ( @YearCardId ,
@PromotionIndex ,
@PackageType ,
@BaoYangType ,
@PID ,
@ProductCount ,
GETDATE()
)";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@YearCardId", details.YearCardId),
new SqlParameter("@PromotionIndex", details.PromotionIndex),
new SqlParameter("@PackageType", details.PackageType),
new SqlParameter("@BaoYangType", details.BaoYangType),
new SqlParameter("@PID", details.Pid),
new SqlParameter("@ProductCount", details.ProductCount)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
public static List <BaoYangYearCardDetail> SelectBaoYangYearCardDetails(SqlConnection conn, int pkid)
{
List <BaoYangYearCardDetail> result = new List <BaoYangYearCardDetail>();
var sql = @"SELECT
bc.PKID,
bc.YearCardId,
bc.PackageType ,
bc.BaoYangType ,
bc.PID,
c.DisplayName,
bc.PromotionIndex,
bc.ProductCount,
ISNULL(bp.PromotionPercentage,0) AS PromotionPercentage
FROM baoyang..BaoYangYearCardDetail (NOLOCK) AS bc
LEFT JOIN Tuhu_productcatalog..[CarPAR_zh-CN] (NOLOCK) AS c
ON c.PID = bc.PID
LEFT JOIN BaoYang..BaoYangYearCardPromotionPercentage (NOLOCK) AS bp
ON bp.YearCardId = bc.YearCardId AND bp.PromotionIndex = bc.PromotionIndex
WHERE bc.YearCardId = @Pkid
ORDER BY bc.PKID ASC";
SqlParameter parameter = new SqlParameter("@Pkid", pkid);
var dt = SqlHelper.ExecuteDataTable(conn, CommandType.Text, sql, parameter);
foreach (DataRow dr in dt.Rows)
{
BaoYangYearCardDetail item = new BaoYangYearCardDetail
{
Pkid = Convert.ToInt32(dr["PKID"]),
YearCardId = Convert.ToInt32(dr["YearCardId"]),
PackageType = dr["PackageType"].ToString(),
BaoYangType = dr["BaoYangType"].ToString(),
Pid = dr["PID"].ToString(),
DisplayName = dr["DisplayName"].ToString(),
PromotionIndex = Convert.ToInt32(dr["PromotionIndex"]),
ProductCount = Convert.ToInt32(dr["ProductCount"]),
PromotionPercentage = Convert.ToDecimal(dr["PromotionPercentage"] ?? 0)
};
result.Add(item);
}
return(result);
}
