/// <summary>
/// 根据主键查询--本月促销
/// </summary>
/// <returns></returns>
public static MyResponseBase Pr_Notice_ByCurrMonth()
{
var domain = new SoftProjectAreaEntityDomain();
domain.Sys_HOperControl = null;
string sql = string.Format("SELECT * FROM Pr_Notice WHERE YEAR(PromotionStartDate)=YEAR(GETDATE()) AND MONTH(PromotionStartDate)=MONTH(getdate()) ORDER BY PromotionStartDate DESC ");
var resp = domain.Query16(sql);
return resp;
}
/// <summary>
/// 根据主键查询--显示
/// </summary>
/// <returns></returns>
public static List<SoftProjectAreaEntity> P_Product_ByNewHome()
{
var domain = new SoftProjectAreaEntityDomain();
domain.Sys_HOperControl = null;
string sql = string.Format("SELECT TOP 10 * FROM V_P_Product WHERE BNewID=1 ORDER BY CREATEDATE DESC");
var resp = domain.Query16(sql);
return resp.Items;
}
/// <summary>
/// 根据主键查询--本月促销
/// </summary>
/// <returns></returns>
public static MyResponseBase Pr_Notice_ByCurrMonth()
{
var domain = new SoftProjectAreaEntityDomain();
domain.Sys_HOperControl = null;
string sql = string.Format("SELECT * FROM Pr_Notice WHERE YEAR(PromotionStartDate)=YEAR(GETDATE()) AND MONTH(PromotionStartDate)=MONTH(getdate()) ORDER BY PromotionStartDate DESC ");
var resp = domain.Query16(sql);
return(resp);
}
/// <summary>
/// 根据主键查询--显示
/// </summary>
/// <returns></returns>
public static List <SoftProjectAreaEntity> P_Product_ByNewHome()
{
var domain = new SoftProjectAreaEntityDomain();
domain.Sys_HOperControl = null;
string sql = string.Format("SELECT TOP 10 * FROM V_P_Product WHERE BNewID=1 ORDER BY CREATEDATE DESC");
var resp = domain.Query16(sql);
return(resp.Items);
}
