public bool SelectCouponWillExpiredList(int DayLimit, ref List <CouponInfo_MemberWeiXin> SendToUserList) { string query = string.Format("\r\n select \r\n datediff( day, GETDATE(), a.EndDate ) as ValidDays,\r\n b.OpenId, \r\n c.IsAllProduct,\r\n a.* from Hishop_Coupon_MemberCoupons a\r\n left join aspnet_Members b on a.MemberId= b.UserId \r\n left join Hishop_Coupon_Coupons c on a.CouponId= c.CouponId \r\n where \r\n a.Status=0 --未使用过\r\n and a.EndDate>= GETDATE()\r\n and ISNULL(ExpiredPromptTimes,0)=0\r\n and datediff( day, GETDATE(), a.EndDate ) between 0 and {0}\r\n and ( b.OpenId<>'' and b.OpenId is not null)\r\n\r\n ", DayLimit); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); System.Data.DataSet dataSet = this.database.ExecuteDataSet(sqlStringCommand); System.Data.DataTable dataTable = dataSet.Tables[0]; foreach (System.Data.DataRow dataRow in dataTable.Rows) { CouponInfo_MemberWeiXin couponInfo_MemberWeiXin = new CouponInfo_MemberWeiXin(); couponInfo_MemberWeiXin.CouponName = dataRow["CouponName"].ToString(); couponInfo_MemberWeiXin.CouponValue = Convert.ToDecimal(dataRow["CouponValue"].ToString()); couponInfo_MemberWeiXin.ConditionValue = Convert.ToDecimal(dataRow["ConditionValue"].ToString()); couponInfo_MemberWeiXin.IsAllProduct = (dataRow["IsAllProduct"].ToString() == "1"); couponInfo_MemberWeiXin.ValidDays = dataRow["ValidDays"].ToString(); couponInfo_MemberWeiXin.OpenId = dataRow["OpenId"].ToString(); couponInfo_MemberWeiXin.EndDate = Convert.ToDateTime(dataRow["EndDate"].ToString()); couponInfo_MemberWeiXin.Id = Convert.ToInt32(dataRow["Id"].ToString()); SendToUserList.Add(couponInfo_MemberWeiXin); } return(true); }
public static bool SaveWeiXinPromptInfo(CouponInfo_MemberWeiXin info) { return((new CouponDao()).SaveWeiXinPromptInfo(info)); }
public bool SaveWeiXinPromptInfo(CouponInfo_MemberWeiXin info) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("update Hishop_Coupon_MemberCoupons set ExpiredPromptTimes= isnull(ExpiredPromptTimes,0) + 1 where id=" + info.Id.ToString()); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }