/// <summary>
/// 获取优惠券信息
/// </summary>
/// <returns></returns>
public JsonResult <Result <dynamic> > GetCouponDetail(string openId, int couponId = 0)
{
if (couponId <= 0)
{
return(Json(ErrorResult <dynamic>("参数错误")));
}
CouponInfo coupon = CouponApplication.GetCouponInfo(couponId);
if (coupon == null)
{
return(Json(ErrorResult <dynamic>("错误的优惠券编号")));
}
else
{
return(JsonResult <dynamic>(new
{
CouponId = coupon.Id,
CouponName = coupon.CouponName,
Price = coupon.Price,
SendCount = coupon.Num,
UserLimitCount = coupon.PerMax,
OrderUseLimit = Math.Round(coupon.OrderAmount, 2),
StartTime = coupon.StartTime.ToString("yyyy-MM-dd HH:mm:ss"),
ClosingTime = coupon.EndTime.ToString("yyyy-MM-dd HH:mm:ss"),
CanUseProducts = "",
ObtainWay = coupon.ReceiveType,
NeedPoint = coupon.NeedIntegral,
UseWithGroup = false,
UseWithPanicBuying = false,
UseWithFireGroup = false,
Remark = coupon.Remark,
UseArea = coupon.UseArea
}));
}
}
public JsonResult GetWXCardData(long id)
{
WXJSCardModel wXJSCardModel = new WXJSCardModel();
bool flag = true;
ICouponService couponService = ServiceHelper.Create <ICouponService>();
CouponRecordInfo couponRecordById = null;
if (flag)
{
couponRecordById = couponService.GetCouponRecordById(id);
if (couponRecordById == null)
{
flag = false;
}
}
CouponInfo couponInfo = null;
if (flag)
{
couponInfo = couponService.GetCouponInfo(couponRecordById.ShopId, couponRecordById.CouponId);
if (couponInfo == null)
{
flag = false;
}
}
if (flag && couponInfo.IsSyncWeiXin == 1 && base.PlatformType == ChemCloud.Core.PlatformType.WeiXin)
{
wXJSCardModel = ser_wxcard.GetJSWeiXinCard(couponRecordById.CouponId, couponRecordById.Id, ThisCouponType);
}
return(Json(wXJSCardModel));
}
private void CanAddOrEditCoupon(CouponInfo info)
{
List <long> list = (
from a in context.CouponInfo
where (a.EndTime > DateTime.Now) && a.ShopId == info.ShopId && (int)a.ReceiveType != 1 && (int)a.ReceiveType != 2
select a.Id).ToList();
List <CouponSettingInfo> couponSettingInfos = (
from a in context.CouponSettingInfo
where list.Contains(a.CouponID)
select a).ToList();
if (info.Himall_CouponSetting != null && info.Himall_CouponSetting.Count > 0)
{
if (couponSettingInfos.Count((CouponSettingInfo a) => a.PlatForm == PlatformType.Wap) >= 5)
{
if (!list.Any((long d) => d == info.Id))
{
throw new HimallException("最多添加5个移动端优惠券");
}
}
if (couponSettingInfos.Count((CouponSettingInfo a) => a.PlatForm == PlatformType.PC) >= 5)
{
if (!list.Any((long d) => d == info.Id))
{
throw new HimallException("最多添加5个PC端个优惠券");
}
}
}
}
public static CouponInfo UseCoupon(decimal orderAmount, string claimCode)
{
if (!string.IsNullOrEmpty(claimCode))
{
CouponInfo coupon = GetCoupon(claimCode);
if (coupon != null)
{
decimal?amount;
if (coupon.Amount.HasValue)
{
amount = coupon.Amount;
if (!((amount.GetValueOrDefault() > 0M) && amount.HasValue) || (orderAmount < coupon.Amount.Value))
{
}
}
if ((coupon.Amount.HasValue && (!(((amount = coupon.Amount).GetValueOrDefault() == 0M) && amount.HasValue) || (orderAmount <= coupon.DiscountValue))))
{
return(coupon);
}
if (coupon.Amount == 0M && orderAmount >= coupon.DiscountValue)
{
return(coupon);
}
}
}
return(null);
}
/// <summary>
/// 发放单品促销活动优惠劵
/// </summary>
/// <param name="partUserInfo">用户信息</param>
/// <param name="couponTypeId">优惠劵类型id</param>
/// <param name="orderInfo">订单信息</param>
/// <param name="ip">ip</param>
public static void SendSinglePromotionCoupon(PartUserInfo partUserInfo, int couponTypeId, OrderInfo orderInfo, string ip)
{
CouponTypeInfo couponTypeInfo = GetCouponTypeById(couponTypeId);
if (couponTypeInfo == null || couponTypeInfo.State == 0 || couponTypeInfo.UserRankLower > partUserInfo.UserRid || couponTypeInfo.OrderAmountLower > orderInfo.OrderAmount)
{
return;
}
CouponInfo couponInfo = new CouponInfo();
couponInfo.CouponSN = Coupons.GenerateCouponSN();
couponInfo.Uid = partUserInfo.Uid;
couponInfo.CouponTypeId = couponTypeId;
couponInfo.Oid = 0;
couponInfo.UseTime = new DateTime(1900, 1, 1);
couponInfo.UseIP = "";
couponInfo.Money = couponTypeInfo.Money;
couponInfo.ActivateTime = couponInfo.CreateTime = DateTime.Now;
couponInfo.ActivateIP = couponInfo.CreateIP = ip;
couponInfo.CreateUid = 0;
couponInfo.CreateOid = orderInfo.Oid;
CreateCoupon(couponInfo);
}
/// <summary>
/// 后台批量生成优惠劵
/// </summary>
/// <param name="couponTypeId">优惠劵类型id</param>
/// <param name="storeId">店铺id</param>
/// <param name="money">优惠劵金额</param>
/// <param name="count">数量</param>
/// <param name="sendUid">发放人id</param>
/// <param name="sendTime">发放时间</param>
/// <param name="sendIP">发放ip</param>
public static void AdminBatchGenerateCoupon(int couponTypeId, int storeId, int money, int count, int sendUid, DateTime sendTime, string sendIP)
{
if (count > 100)
{
ThreadPool.QueueUserWorkItem(new WaitCallback(AdminGenerateCoupon), new object[7] {
couponTypeId, storeId, money, count, sendUid, sendTime, sendIP
});
}
else
{
for (int i = 0; i < count; i++)
{
CouponInfo couponInfo = new CouponInfo();
couponInfo.CouponSN = Coupons.GenerateCouponSN();
couponInfo.Uid = 0;
couponInfo.CouponTypeId = couponTypeId;
couponInfo.StoreId = storeId;
couponInfo.Oid = 0;
couponInfo.UseTime = new DateTime(1900, 1, 1);
couponInfo.UseIP = "";
couponInfo.Money = money;
couponInfo.ActivateTime = new DateTime(1900, 1, 1);
couponInfo.ActivateIP = "";
couponInfo.CreateUid = sendUid;
couponInfo.CreateOid = 0;
couponInfo.CreateTime = sendTime;
couponInfo.CreateIP = sendIP;
CreateCoupon(couponInfo);
}
}
}
/// <summary>
/// 验证优惠劵编号
/// </summary>
/// <returns></returns>
public ActionResult VerifyCouponSN()
{
string couponSN = WebHelper.GetQueryString("couponSN");//优惠劵编号
if (couponSN.Length == 0)
{
return(AjaxResult("emptycouponsn", "请输入优惠劵编号"));
}
else if (couponSN.Length != 16)
{
return(AjaxResult("errorcouponsn", "优惠劵编号不正确"));
}
CouponInfo couponInfo = Coupons.GetCouponByCouponSN(couponSN);
if (couponInfo == null)//不存在
{
return(AjaxResult("noexist", "优惠劵不存在"));
}
else if (couponInfo.Oid > 0)//已使用
{
return(AjaxResult("used", "优惠劵已使用"));
}
else if (couponInfo.Uid > 0)//已激活
{
return(AjaxResult("activated", "优惠劵已激活"));
}
else//未激活
{
return(AjaxResult("nonactivated", "优惠劵未激活"));
}
}
/// <summary>
/// 新增状态下的数据保存
/// </summary>
/// <returns></returns>
public override bool SaveAddNew()
{
CouponInfo info = new CouponInfo();//必须使用存在的局部变量，因为部分信息可能被附件使用
SetInfo(info);
try
{
#region 新增数据
bool succeed = BLLFactory <Coupon> .Instance.Insert(info);
if (succeed)
{
//可添加其他关联操作
return(true);
}
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmGenerateCoupon));
MessageDxUtil.ShowError(ex.Message);
}
return(false);
}
/// <summary>
/// 编辑状态下的数据保存
/// </summary>
/// <returns></returns>
public override bool SaveUpdated()
{
CouponInfo info = BLLFactory <Coupon> .Instance.FindByID(ID);
if (info != null)
{
SetInfo(info);
try
{
#region 更新数据
bool succeed = BLLFactory <Coupon> .Instance.Update(info, info.ID);
if (succeed)
{
//可添加其他关联操作
return(true);
}
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmGenerateCoupon));
MessageDxUtil.ShowError(ex.Message);
}
}
return(false);
}
/// <summary>
/// 数据显示的函数
/// </summary>
public override void DisplayData()
{
InitDictItem();//数据字典加载（公用）
if (!string.IsNullOrEmpty(ID))
{
#region 显示信息
CouponInfo info = BLLFactory <Coupon> .Instance.FindByID(ID);
if (info != null)
{
txtID.Text = ID;
CouponCategoryInfo info2 = BLLFactory <CouponCategory> .Instance.FindByID(info.CouponCategory_ID);
if (info2 != null)
{
txtCategory.SelectedText = info2.HandNo + "-" + info2.Name;
}
txtMobilePhone.Text = info.MobilePhone;
txtLoginName.Text = info.LoginName;
txtEndTime.DateTime = info.EndTime;
txtStartTime.DateTime = info.StartTime;
txtEnabled.SelectedIndex = info.DELETED;
txtCreator.Text = info.Creator;
txtCreateTime.SetDateTime(info.CreateTime);
}
#endregion
}
else
{
txtCreator.Text = Portal.gc.UserInfo.LoginName; //默认为当前登录用户
txtCreateTime.DateTime = DateTime.Now; //默认当前时间
txtID.Text = Guid.NewGuid().ToString();
}
}
/// <summary>
/// 编辑或者保存状态下取值函数
/// </summary>
/// <param name="info"></param>
private void SetInfo(CouponInfo info)
{
info.ID = txtID.Text.Trim();
if (string.IsNullOrEmpty(ID))
{
info.Creator = Portal.gc.UserInfo.LoginName;
info.Creator_ID = Portal.gc.UserInfo.ID.ToString();
info.CreateTime = DateTime.Now;
}
info.CouponCategory_ID = (txtCategory.SelectedItem as CListItem).Value;
CouponCategoryInfo couponCategoryInfo = BLLFactory <CouponCategory> .Instance.FindByID(info.CouponCategory_ID);
if (couponCategoryInfo != null)
{
info.CouponCategory_Name = couponCategoryInfo.Name;
info.Company_ID = couponCategoryInfo.BelongCompanys;
OUInfo ouInfo = BLLFactory <OU> .Instance.FindByID(info.Company_ID);
info.Company_Name = ouInfo.Name;
}
info.MobilePhone = txtMobilePhone.Text;
info.LoginName = txtLoginName.Text;
info.StartTime = txtStartTime.DateTime;
info.EndTime = txtEndTime.DateTime;
info.DELETED = txtEnabled.SelectedIndex;
}
public bool AddCouponProducts(int couponId, bool IsAllProduct, IList <string> productIDs)
{
try
{
CouponInfo couponDetails = this.GetCouponDetails(couponId);
if (couponDetails != null)
{
if (IsAllProduct)
{
couponDetails.IsAllProduct = true;
couponDetails.ProductNumber = 0;
}
else
{
couponDetails.IsAllProduct = false;
couponDetails.ProductNumber = productIDs.Count;
}
if (IsAllProduct)
{
DbCommand command = this.database.GetSqlStringCommand("update Hishop_Coupon_Coupons set IsAllProduct=@IsAllProduct , ProductNumber=@ProductNumber WHERE CouponId = @CouponId");
this.database.AddInParameter(command, "CouponId", DbType.Int32, couponId);
this.database.AddInParameter(command, "ProductNumber", DbType.Int32, couponDetails.ProductNumber);
this.database.AddInParameter(command, "IsAllProduct", DbType.Boolean, couponDetails.IsAllProduct);
this.database.ExecuteNonQuery(command);
command = this.database.GetSqlStringCommand("Delete from Hishop_Coupon_Products WHERE CouponId = @CouponId");
this.database.AddInParameter(command, "CouponId", DbType.Int32, couponId);
this.database.ExecuteNonQuery(command);
return(true);
}
string str = "";
if (productIDs.Count > 0)
{
foreach (string str2 in productIDs)
{
str = str + "," + str2;
}
}
str = str.Substring(1);
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("Delete from Hishop_Coupon_Products WHERE CouponId ={0} and ProductId in ( {1} )", couponId, str));
this.database.ExecuteNonQuery(sqlStringCommand);
StringBuilder builder = new StringBuilder();
foreach (string str3 in productIDs)
{
builder.AppendFormat(" insert into Hishop_Coupon_Products(couponId , ProductId) values({0} , {1}) ", couponDetails.CouponId, str3);
}
sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
this.database.ExecuteNonQuery(sqlStringCommand);
sqlStringCommand = this.database.GetSqlStringCommand("update Hishop_Coupon_Coupons set IsAllProduct=@IsAllProduct , ProductNumber=(select count(productId) from Hishop_Coupon_Products where CouponId = @CouponId) WHERE CouponId = @CouponId");
this.database.AddInParameter(sqlStringCommand, "CouponId", DbType.Int32, couponId);
this.database.AddInParameter(sqlStringCommand, "IsAllProduct", DbType.Boolean, couponDetails.IsAllProduct);
this.database.ExecuteNonQuery(sqlStringCommand);
return(true);
}
return(false);
}
catch (Exception)
{
return(false);
}
}
public void Update(CouponInfo couponInfo)
{
IDataParameter[] parms = null;
var SQL_UPDATE = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(couponInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(SQL_UPDATE, parms);
}
public int Insert(CouponInfo couponInfo)
{
var couponID = 0;
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(couponInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SQL_INSERT, parms);
couponID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(couponID);
}
public bool AddCouponProducts(int couponId, int productID)
{
bool result;
try
{
CouponInfo couponDetails = this.GetCouponDetails(couponId);
if (couponDetails != null)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat(" insert into Hishop_Coupon_Products(couponId , ProductId) values({0} , {1}) ", couponDetails.CouponId, productID);
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
this.database.ExecuteNonQuery(sqlStringCommand);
sqlStringCommand = this.database.GetSqlStringCommand("update Hishop_Coupon_Coupons set IsAllProduct=0 , ProductNumber=(select count(productId) from Hishop_Coupon_Products where CouponId = @CouponId) WHERE CouponId = @CouponId");
this.database.AddInParameter(sqlStringCommand, "CouponId", System.Data.DbType.Int32, couponId);
this.database.ExecuteNonQuery(sqlStringCommand);
result = true;
}
else
{
result = false;
}
}
catch (Exception)
{
result = false;
}
return(result);
}
public int Insert(CouponInfo couponInfo)
{
var couponId = 0;
IDataParameter[] parms = null;
var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(couponInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
couponId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(couponId);
}
private void GetCouponInfo(HttpContext context)
{
context.Response.ContentType = "application/json";
StringBuilder builder = new StringBuilder("{");
int result = 0;
if (!int.TryParse(context.Request["id"], out result))
{
builder.Append("\"Status\":\"0\"}");
context.Response.Write(builder.ToString());
}
CouponInfo coupon = CouponHelper.GetCoupon(result);
if (coupon == null)
{
builder.Append("\"Status\":\"1\"}");
context.Response.Write(builder.ToString());
}
else
{
var type = new {
Status = 2,
Count = coupon.StockNum - coupon.ReceiveNum,
BeginTime = coupon.BeginDate,
EndTime = coupon.EndDate
};
IsoDateTimeConverter converter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
context.Response.Write(JsonConvert.SerializeObject(type, Formatting.Indented, new JsonConverter[] { converter }));
}
}
public void Update(CouponInfo couponInfo)
{
IDataParameter[] parms = null;
var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(couponInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
ExecuteNonQuery(sqlUpdate, parms);
}
/// <summary>
/// 后台生成优惠劵
/// </summary>
/// <param name="o">参数对象</param>
private static void AdminGenerateCoupon(object o)
{
object[] parms = (object[])o;
int couponTypeId = (int)parms[0];
int storeId = (int)parms[1];
int money = (int)parms[2];
int count = (int)parms[3];
int sendUid = (int)parms[4];
DateTime sendTime = (DateTime)parms[5];
string sendIP = (string)parms[6];
for (int i = 0; i < count; i++)
{
CouponInfo couponInfo = new CouponInfo();
couponInfo.CouponSN = Coupons.GenerateCouponSN();
couponInfo.Uid = 0;
couponInfo.CouponTypeId = couponTypeId;
couponInfo.StoreId = storeId;
couponInfo.Oid = 0;
couponInfo.UseTime = new DateTime(1900, 1, 1);
couponInfo.UseIP = "";
couponInfo.Money = money;
couponInfo.ActivateTime = new DateTime(1900, 1, 1);
couponInfo.ActivateIP = "";
couponInfo.CreateUid = sendUid;
couponInfo.CreateOid = 0;
couponInfo.CreateTime = sendTime;
couponInfo.CreateIP = sendIP;
AdminCoupons.CreateCoupon(couponInfo);
}
}
public string GetPrizeType(PrizeTypes PrizeType, int PrizeValue)
{
string result = string.Empty;
switch (PrizeType)
{
case PrizeTypes.Integral:
result = PrizeValue + "积分; ";
break;
case PrizeTypes.Coupou:
{
CouponInfo coupon = CouponHelper.GetCoupon(PrizeValue);
result = ((coupon == null) ? " " : ((!(coupon.ClosingTime > coupon.StartTime)) ? (coupon.Price + "元优惠券<font style='color:red;'>(已失效)</font>; ") : (coupon.Price + "元优惠券; ")));
break;
}
case PrizeTypes.Gift:
{
GiftInfo giftDetails = GiftHelper.GetGiftDetails(PrizeValue);
result = ((giftDetails == null) ? " " : (giftDetails.Name + "; "));
break;
}
}
return(result);
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
CouponInfo coupon = new CouponInfo();
coupon.ID = RequestHelper.GetQueryString <int>("ID");
coupon.Name = this.Name.Text;
coupon.Money = Convert.ToDecimal(this.Money.Text);
coupon.UseMinAmount = Convert.ToDecimal(this.UseMinAmount.Text);
coupon.UseStartDate = Convert.ToDateTime(this.UseStartDate.Text);
coupon.UseEndDate = Convert.ToDateTime(this.UseEndDate.Text).AddDays(1.0).AddSeconds(-1.0);
string alertMessage = ShopLanguage.ReadLanguage("AddOK");
if (coupon.ID == -2147483648)
{
base.CheckAdminPower("AddCoupon", PowerCheckType.Single);
coupon.ID = CouponBLL.AddCoupon(coupon);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("Coupon"), coupon.ID);
}
else
{
base.CheckAdminPower("UpdateCoupon", PowerCheckType.Single);
CouponBLL.UpdateCoupon(coupon);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("Coupon"), coupon.ID);
alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
}
AdminBasePage.Alert(alertMessage, RequestHelper.RawUrl);
}
public bool SendCouponToMemebers(int couponId, List <int> userIds)
{
int num = userIds.Count <int>();
StringBuilder builder = new StringBuilder();
builder.Append("Insert into Hishop_Coupon_MemberCoupons(CouponId,MemberId,ReceiveDate,[Status],CouponName,ConditionValue,BeginDate,EndDate,CouponValue) values ");
CouponInfo couponDetails = this.GetCouponDetails(couponId);
for (int i = 0; i < num; i++)
{
builder.AppendFormat("({0},{1},GETDATE(),0,'{2}',{3},'{4}','{5}',{6})", new object[] { couponId, userIds[i], couponDetails.CouponName, couponDetails.ConditionValue, couponDetails.BeginDate, couponDetails.EndDate, couponDetails.CouponValue });
if (i != (num - 1))
{
builder.Append(",");
}
else
{
builder.Append(";");
}
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
int num3 = this.database.ExecuteNonQuery(sqlStringCommand);
if (num3 > 0)
{
sqlStringCommand = this.database.GetSqlStringCommand(string.Format("Update Hishop_Coupon_Coupons set ReceiveNum=ReceiveNum+{0} where CouponId={1}; ", num3, couponId));
this.database.ExecuteNonQuery(sqlStringCommand);
return(true);
}
return(false);
}
/// <summary>
/// 领取优惠劵
/// </summary>
/// <param name="partUserInfo">用户信息</param>
/// <param name="couponTypeInfo">优惠劵类型信息</param>
/// <param name="pullTime">领取时间</param>
/// <param name="pullIP">领取ip</param>
/// <returns></returns>
public static string PullCoupon(PartUserInfo partUserInfo, CouponTypeInfo couponTypeInfo, DateTime pullTime, string pullIP)
{
int sendCount = GetSendCouponCount(couponTypeInfo.CouponTypeId);
BrnShop.Core.BSPCache.Insert(CacheKeys.SHOP_COUPONTYPE_SENDCOUNT + couponTypeInfo.CouponTypeId, sendCount + 1);
string couponSN = GenerateCouponSN();
CouponInfo couponInfo = new CouponInfo();
couponInfo.CouponSN = couponSN;
couponInfo.Uid = partUserInfo.Uid;
couponInfo.CouponTypeId = couponTypeInfo.CouponTypeId;
couponInfo.Oid = 0;
couponInfo.UseTime = new DateTime(1900, 1, 1);
couponInfo.UseIP = "";
couponInfo.Money = couponTypeInfo.Money;
couponInfo.ActivateTime = pullTime;
couponInfo.ActivateIP = pullIP;
couponInfo.CreateUid = partUserInfo.Uid;
couponInfo.CreateOid = 0;
couponInfo.CreateTime = pullTime;
couponInfo.CreateIP = pullIP;
CreateCoupon(couponInfo);
return(couponSN);
}
public ActionResult Add()
{
CouponInfo model = new CouponInfo();
long shopId = CurrentSellerManager.ShopId;
var couponser = _iCouponService;
model = new CouponInfo();
model.StartTime = DateTime.Now;
model.EndTime = model.StartTime.AddMonths(1);
model.ReceiveType = CouponInfo.CouponReceiveType.ShopIndex;
model.CanVshopIndex = CurrentSellerManager.VShopId > 0;
model.Himall_CouponSetting.Clear();
if (model.CanVshopIndex)
{
model.Himall_CouponSetting.Add(new CouponSettingInfo()
{
Display = 1, PlatForm = Himall.Core.PlatformType.Wap
});
}
model.Himall_CouponSetting.Add(new CouponSettingInfo()
{
Display = 1, PlatForm = Himall.Core.PlatformType.PC
});
model.FormIsSyncWeiXin = false;
model.ShopId = shopId;
ViewBag.EndTime = _iMarketService.GetMarketService(CurrentSellerManager.ShopId, MarketType.Coupon).MarketServiceRecordInfo.Max(item => item.EndTime).ToString("yyyy-MM-dd");
ViewBag.CanAddIntegralCoupon = couponser.CanAddIntegralCoupon(shopId);
return(View(model));
}
protected void dlCouponList_ItemDataBound(object sender, DataListItemEventArgs e)
{
CouponInfo couponItem = e.Item.DataItem as CouponInfo;
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
ITextControl lblTitle = e.Item.FindControl("lblTitle") as ITextControl;
ITextControl lblStatus = e.Item.FindControl("lblStatus") as ITextControl;
ITextControl lblDiscount = e.Item.FindControl("lblDiscount") as ITextControl;
ITextControl lblDiscountType = e.Item.FindControl("lblDiscountType") as ITextControl;
ITextControl lblTotalAmount = e.Item.FindControl("lblTotalAmount") as ITextControl;
LinkButton lbRemove = e.Item.FindControl("lbRemove") as LinkButton;
HyperLink hlEditLink = e.Item.FindControl("hlEditLink") as HyperLink;
lblTitle.Text = couponItem.Title;
lblTotalAmount.Text = String.Format("{0:C}", couponItem.TotalAmount);
lblStatus.Text = couponItem.Active ? "Active" : "Inactive";
if ((int)couponItem.DiscountType == 1)
{
lblDiscountType.Text = "%";
lblDiscount.Text = String.Format("{0:0.##}%", Math.Round(couponItem.Discount, 2));
}
else
{
lblDiscountType.Text = "$";
lblDiscount.Text = String.Format("{0:C}", couponItem.Discount);
}
hlEditLink.NavigateUrl = "CouponItem.aspx?cId=" + couponItem.CouponId;
}
}
public bool Add(CouponInfo couponInfo)
{
couponInfo.CouponId = GetNextId();
Parameters cmdParams = GetParameters(couponInfo);
return(DBHelper.ExecuteSql("INSERT INTO PE_Coupon (CouponID, CouponName, CouponNumPattern, Money, State, UserGroup, BeginDate, EndDate, LimitNum, ProductLimitType, ProductLimitContent, CouponCreateType, CouponCreateContent, OrderTotalMoney, UseEndDate) VALUES (@CouponID, @CouponName, @CouponNumPattern, @Money, @State, @UserGroup, @BeginDate, @EndDate, @LimitNum, @ProductLimitType, @ProductLimitContent, @CouponCreateType, @CouponCreateContent, @OrderTotalMoney, @UseEndDate)", cmdParams));
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!int.TryParse(this.Page.Request.QueryString["couponId"], out this.couponId))
{
base.GotoResourceNotFound();
return;
}
this.btnEditCoupons.Click += new System.EventHandler(this.btnEditCoupons_Click);
if (!this.Page.IsPostBack)
{
CouponInfo coupon = CouponHelper.GetCoupon(this.couponId);
if (coupon == null)
{
base.GotoResourceNotFound();
return;
}
if (coupon.ClosingTime.CompareTo(System.DateTime.Now) < 0)
{
this.ShowMsg("该优惠券已经结束！", false);
return;
}
Globals.EntityCoding(coupon, false);
this.lblEditCouponId.Text = coupon.CouponId.ToString();
this.txtCouponName.Text = coupon.Name;
if (coupon.Amount.HasValue)
{
this.txtAmount.Text = string.Format("{0:F2}", coupon.Amount);
}
this.txtDiscountValue.Text = coupon.DiscountValue.ToString("F2");
this.calendarEndDate.SelectedDate = new System.DateTime?(coupon.ClosingTime);
this.calendarStartDate.SelectedDate = new System.DateTime?(coupon.StartTime);
this.txtNeedPoint.Text = coupon.NeedPoint.ToString();
}
}
private void GetCouponInfo(System.Web.HttpContext context)
{
context.Response.ContentType = "application/json";
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder("{");
int couponId = 0;
if (!int.TryParse(context.Request["id"], out couponId))
{
stringBuilder.Append("\"Status\":\"0\"}");
context.Response.Write(stringBuilder.ToString());
}
CouponInfo coupon = CouponHelper.GetCoupon(couponId);
if (coupon == null)
{
stringBuilder.Append("\"Status\":\"1\"}");
context.Response.Write(stringBuilder.ToString());
return;
}
var value = new
{
Status = 2,
Count = coupon.StockNum - coupon.ReceiveNum,
BeginTime = coupon.BeginDate,
EndTime = coupon.EndDate
};
IsoDateTimeConverter isoDateTimeConverter = new IsoDateTimeConverter();
isoDateTimeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
context.Response.Write(JsonConvert.SerializeObject(value, Formatting.Indented, new JsonConverter[]
{
isoDateTimeConverter
}));
}
public void SaveCover(CouponInfo model)
{
string integralCover = model.IntegralCover;
if (!string.IsNullOrWhiteSpace(integralCover) && integralCover.IndexOf("temp", StringComparison.InvariantCultureIgnoreCase) > -1)
{
string mapPath = IOHelper.GetMapPath(model.IntegralCover);
if (!File.Exists(mapPath))
{
model.IntegralCover = "";
}
else
{
FileInfo fileInfo = new FileInfo(mapPath);
string str = string.Format("/Storage/Shop/{0}/Coupon/", model.ShopId);
string mapPath1 = IOHelper.GetMapPath(str);
long id = model.Id;
string str1 = string.Concat(id.ToString(), fileInfo.Extension);
Directory.CreateDirectory(mapPath1);
IOHelper.CopyFile(mapPath, mapPath1, true, str1);
str = Path.Combine(str, str1);
model.IntegralCover = str;
}
context.SaveChanges();
}
}
/// <summary>
/// 查询数据操作
/// </summary>
private void btnSearch_Click(object sender, EventArgs e)
{
couponInfo = null;
if (this.txtID.Text.Length == 0)
{
MessageDxUtil.ShowTips("请输入兑换码");
this.txtID.Focus();
return;
}
else if (this.txtFullName.Text.Length == 0)
{
MessageDxUtil.ShowTips("请输入联系人");
this.txtFullName.Focus();
return;
}
else if (this.txtMobilePhone.Text.Length == 0)
{
MessageDxUtil.ShowTips("请输入联系方式");
this.txtMobilePhone.Focus();
return;
}
BindData();
CheckCoupon();
}
