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