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