public ActionResult InsertPromotionFromActivity(string userId, string callBack)
{
CouponActivity couponDetail = ActivitySystem.GetCurrentCouponActivity();
bool result = ActivitySystem.InsertPromotionFromActivity(couponDetail, userId);
return(this.Jsonp(callBack, result));
}
public ActionResult UserIsClaimedCoupon(string userId, string callBack)
{
CouponActivity couponDetail = ActivitySystem.GetCurrentCouponActivity();
bool result = ActivitySystem.UserIsClaimedCoupon(couponDetail, userId);
return(this.Jsonp(callBack, result));
}
public ResponseModel CreateCouponActivity(CouponActivity model, List <string> areNum)
{
List <ManToArea> list = new List <ManToArea>();
var areaHis = _context.ManToAreas.Where(x => x.ActiveId == model.Id);
areNum.ForEach(x =>
{
var area = _context.Areas.FirstOrDefault(c => c.Num == x);
if (area != null)
{
var newArea = new ManToArea();
newArea.ActiveId = model.Id;
newArea.ActiveName = model.Remark;
newArea.AreaNum = area.Num;
newArea.AreaName = area.Name;
list.Add(newArea);
}
});
List <string> errorNum = new List <string>();
var tempModel = Utils.DeepCopyByReflect(model);
tempModel.EffectTime = model.EffectTime;
_context.CouponActivities.Add(tempModel);
_context.ManToAreas.RemoveRange(areaHis);
_context.ManToAreas.AddRange(list);
_response.Stutas = _context.SaveChanges() > 0;
_response.Result = errorNum;
return(_response);
}
public JsonResult SaveCouponActivityConfig(string configStr)
{
CouponActivity configObject = JsonConvert.DeserializeObject <CouponActivity>(configStr);
string userName = HttpContext.User.Identity.Name;
bool result = ActivityManager.SaveCouponActivityConfig(configObject, userName);
return(Json(result));
}
public ActionResult Create([Bind(Include = "ActivityName,ActivityStartDate,ActivityEndDate,CouponStartDate,CouponEndDate,Notes,CouponType")] CouponActivity entity)
{
if (!ModelState.IsValid)
{
return(View(entity));
}
entity.ActivityGUID = Guid.NewGuid().ToString("N");
var result = _couponContract.Insert(entity);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool SaveCouponActivityConfig(SqlConnection conn, CouponActivity configObject, string userName)
{
var result = false;
int rows = DALActivity.SaveCouponActivityConfig(conn, configObject, userName);
if (rows > 0)
{
result = true;
}
return(result);
}
public static bool InsertPromotionFromActivity(CouponActivity couponDetail, string user)
{
int rows = Tuhu.WebSite.Web.Activity.DataAccess.Activity.InsertPromotionFromActivity(couponDetail, user);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool UserIsClaimedCoupon(CouponActivity couponDetail, string userId)
{
var result = Tuhu.WebSite.Web.Activity.DataAccess.Activity.UserIsClaimedCoupon(couponDetail, userId);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Update([Bind(Include = "Id,ActivityName,ActivityStartDate,ActivityEndDate,CouponStartDate,CouponEndDate,Notes")] CouponActivity dto)
{
var entity = _couponContract.Entities.FirstOrDefault(e => e.Id == dto.Id);
entity.ActivityName = dto.ActivityName;
entity.ActivityStartDate = dto.ActivityStartDate;
entity.ActivityEndDate = dto.ActivityEndDate;
entity.CouponStartDate = dto.CouponStartDate;
entity.CouponEndDate = dto.CouponEndDate;
entity.Notes = dto.Notes;
var result = _couponContract.Update(new CouponActivity[] { entity });
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static int InsertPromotionFromActivity(CouponActivity couponDetail, string user)
{
using (var cmd = new SqlCommand("Gungnir..Activity_InsertPromotionData"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PromotionType", couponDetail.PromotionType);
cmd.Parameters.AddWithValue("@CouponRuleId", couponDetail.CouponRuleId);
cmd.Parameters.AddWithValue("@CouponDisCountMoney", couponDetail.CouponDisCountMoney);
cmd.Parameters.AddWithValue("@CouponUseMoney", couponDetail.CouponUseMoney);
cmd.Parameters.AddWithValue("@CouponValidityPeriod", couponDetail.ValidityPeriod);
cmd.Parameters.AddWithValue("@CouponDescription", couponDetail.CouponDescription);
cmd.Parameters.AddWithValue("@CodeChannel", couponDetail.CodeChannel);
cmd.Parameters.AddWithValue("@User", user);
return(DbHelper.ExecuteNonQuery(cmd));
}
}
public bool SaveCouponActivityConfig(CouponActivity configObject, string userName)
{
bool result = false;
try
{
result = DbGungnirManager.Execute(conn => handler.SaveCouponActivityConfig(conn, configObject, userName));
}
catch (Exception ex)
{
var exception = new ActivityException(1, "SaveCouponActivityConfig", ex);
Logger.Error("SaveCouponActivityConfig", exception);
throw ex;
}
return(result);
}
public static int SaveCouponActivityConfig(SqlConnection conn, CouponActivity configObject, string userName)
{
var sql = "";
if (configObject.ActivityId == -1)
{
sql = "INSERT INTO [Gungnir].[dbo].[PromotionActivityConfig](SmallImageUrl,BigImageUrl,ButtonBackGroundColor,ButtonTextColor,ButtonText,Url,IosJson,AndroidJson, IsSendCoupon, LayerButtonText, LayerButtonBackGroundColor,LayerButtonTextColor,PromotionRuleId,PromotionMinMoney,PromotionDiscount,StartDate, EndDate,PromotionDescription,PromotionCodeChannel,CreatedUser,ActivityKey) VALUES (@SmallImageUrl,@BigImageUrl,@ButtonBackGroundColor,@ButtonTextColor, @ButtonText,@Url,@IosJson,@AndroidJson,@IsSendCoupon, @LayerButtonText,@LayerButtonBackGroundColor,@LayerButtonTextColor,@PromotionRuleId,@PromotionMinMoney,@PromotionDiscount, @StartDate,@EndDate,@PromotionDescription,@PromotionCodeChannel,@CreatedUser,@ActivityKey) ";
}
else
{
sql = "INSERT INTO [Gungnir].[dbo].[PromotionActivityConfig](SmallImageUrl,BigImageUrl,ButtonBackGroundColor,ButtonTextColor,ButtonText,Url,IosJson,AndroidJson, IsSendCoupon, LayerButtonText, LayerButtonBackGroundColor,LayerButtonTextColor,PromotionRuleId,PromotionMinMoney,PromotionDiscount,StartDate, EndDate,PromotionDescription,PromotionCodeChannel,CreatedUser,ActivityId) VALUES (@SmallImageUrl,@BigImageUrl,@ButtonBackGroundColor,@ButtonTextColor, @ButtonText,@Url,@IosJson,@AndroidJson,@IsSendCoupon, @LayerButtonText,@LayerButtonBackGroundColor,@LayerButtonTextColor,@PromotionRuleId,@PromotionMinMoney,@PromotionDiscount, @StartDate,@EndDate,@PromotionDescription,@PromotionCodeChannel,@CreatedUser,@ActivityId )";
}
SqlParameter[] parameters =
{
new SqlParameter("@SmallImageUrl", configObject.SmallImageUrl),
new SqlParameter("@BigImageUrl", configObject.BigImageUrl),
new SqlParameter("@ButtonBackGroundColor", configObject.ButtonBackGroundColor),
new SqlParameter("@ButtonTextColor", configObject.ButtonTextColor),
new SqlParameter("@ButtonText", configObject.ButtonText),
new SqlParameter("@IosJson", configObject.IosJson),
new SqlParameter("@AndroidJson", configObject.AndroidJson),
new SqlParameter("@Url", configObject.Url),
new SqlParameter("@IsSendCoupon", configObject.IsSendCoupon),
new SqlParameter("@LayerButtonText", configObject.LayerButtonText),
new SqlParameter("@LayerButtonBackGroundColor", configObject.LayerButtonBackGroundColor),
new SqlParameter("@LayerButtonTextColor", configObject.LayerButtonTextColor),
//new SqlParameter("@PromotionType", configObject.PromotionType),
new SqlParameter("@PromotionRuleId", configObject.PromotionRuleId),
new SqlParameter("@PromotionMinMoney", configObject.PromotionMinMoney),
new SqlParameter("@PromotionDiscount", configObject.PromotionDiscount),
new SqlParameter("@StartDate", configObject.StartDate == DateTime.MinValue?DateTime.Today:configObject.StartDate),
new SqlParameter("@EndDate", configObject.EndDate == DateTime.MinValue?DateTime.Today:configObject.EndDate),
new SqlParameter("@PromotionDescription", configObject.PromotionDescription),
new SqlParameter("@PromotionCodeChannel", configObject.PromotionCodeChannel),
new SqlParameter("@CreatedUser", userName),
new SqlParameter("@ActivityId", configObject.ActivityId),
new SqlParameter("@ActivityKey", configObject.ActivityKey)
};
var rows = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters);
return(rows);
}
public static int UserIsClaimedCoupon(CouponActivity couponDetail, string userId)
{
using (var cmd = new SqlCommand("Gungnir..Activity_IsUserClaimedCoupon"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PromotionType", couponDetail.PromotionType);
cmd.Parameters.AddWithValue("@CouponRuleId", couponDetail.CouponRuleId);
cmd.Parameters.AddWithValue("@CouponDisCountMoney", couponDetail.CouponDisCountMoney);
cmd.Parameters.AddWithValue("@CouponUseMoney", couponDetail.CouponUseMoney);
cmd.Parameters.AddWithValue("@UserId", userId);
cmd.Parameters.Add(new SqlParameter("@Result", SqlDbType.Int)
{
Direction = ParameterDirection.Output
});
DbHelper.ExecuteNonQuery(cmd);
var result = Convert.ToInt32(cmd.Parameters["@Result"].Value);
return(result);
}
}
public CouponActivity GetCurrentCouponActivity(string id)
{
CouponActivity result = null;
try
{
result = DbGungnirReadOnlyManager.Execute(conn => handler.GetCurrentCouponActivity(conn, id)) ?? new CouponActivity()
{
ActivityId = -1,
ActivityKey = new Guid(Guid.NewGuid().ToString("N")),
StartDate = DateTime.Today,
EndDate = DateTime.Today
};
}
catch (Exception ex)
{
var exception = new ActivityException(1, "GetCurrentCouponActivity", ex);
Logger.Error("GetCurrentCouponActivity", exception);
throw ex;
}
return(result);
}
public ActionResult SaveCouponActivity(CouponActivity c, List <int> userType, string areaNums)
{
var loginUser = (UserInfo)ViewBag.User;
var areaList = areaNums.Split(',').ToList();
var userList = new List <UserInfo>();
Guid managerId = (Guid)ViewBag.ManagerId;
c.CreateTime = DateTime.Now;
c.CreateUserId = managerId;
c.CreateUserName = loginUser.UserName;
string userTypes = "";
userType.ForEach(x =>
{
userTypes += x;
userTypes += ",";
});
c.UserTypes = userTypes;
_active.CreateCouponActivity(c, areaList);
Response.Redirect("ShowCouponActivites");
return(View());
}
public string CreateOrder(string remark = "", string couponId = "")
{
var loginUser = (UserInfo)ViewBag.User;
var list = _order.GetShoppingCar(loginUser);
var totalPrice = list.Sum(x => x.Count * x.Price);
if (list != null && list.Count > 0 && totalPrice > 380)
{
var order = new OrderInfo();
var saleMan = _user.GetUserByUserId(loginUser.SaleManGuid);
order.Id = Guid.NewGuid();
order.CreateTime = DateTime.Now;
order.CreateUserId = loginUser.UserId;
order.CreateUserName = loginUser.UserName;
order.CreateUserType = loginUser.TypeName;
order.CreateUserNum = loginUser.UserNum;
order.StoreName = loginUser.SotreName;
order.CreateUserTel = loginUser.Tel;
order.CreateUserTypeId = loginUser.TypeId;
order.RootUserId = loginUser.CreateUserId;
order.RootUserName = loginUser.CreateUser;
order.SaleManGuid = loginUser.SaleManGuid;
order.SaleManName = loginUser.SaleManName;
order.ReceiveAddr = loginUser.Addr;
order.Province = loginUser.Province;
order.ProvinceNum = loginUser.ProvinceNum;
order.City = loginUser.City;
order.CityNum = loginUser.CityNum;
order.Area = loginUser.Area;
order.AreaNum = loginUser.AreaNum;
order.Stutas = (int)Common.Entities.OrderStatus.等待商家发货;
order.SaleManTel = saleMan == null ? "" : saleMan.Tel;
order.PayType = "货到付款";
order.Remark = remark;
Guid Cid = new Guid();
if (Guid.TryParse(couponId, out Cid))
{
Coupon c = _active.GetCouponById(Cid);
if (c != null)
{
order.LessMoney += c.LessMoney;
_active.SetCouponUse(Cid, order.Id);
}
}
Manjiujian mj = _active.CheckManjiujian(loginUser, ViewBag.ManagerId);
Manjiusong ms = _active.CheckManSong(loginUser, ViewBag.ManagerId);
CouponActivity ca = _active.CheckCouponActivity(loginUser, ViewBag.ManagerId);
if (mj != null)
{
order.Manjian = mj.LessMoeny;
}
if ((ms != null && ca == null) || (ms != null && ca != null && ms.LimitMoney > ca.SendMoney))
{
var model = _manager.GetGoodsWithPrice(ms.SendGoodId, loginUser.TypeId);
OrderItem item = new OrderItem();
item.IsGift = true;
item.Count = ms.SendGoodCount;
item.CreateUserId = loginUser.UserId;
item.Id = Guid.NewGuid();
item.LessPrice = 0;
item.Price = 0;
item.RealPrice = 0;
item.ProductId = model.Id;
item.ProductTittle = model.GoodsTittle;
item.TotalPrice = 0;
item.ProductType = model.FirstTypeName;
item.ProductTypeId = model.FirstTypeId;
item.ProductId = model.Id;
item.BarCode = model.BarCode;
item.Spec = model.Spec;
item.Unit = model.Unit;
item.SupplierId = model.SupplierId;
item.SupplierName = model.SupplierName;
item.BrandId = model.BrandId;
item.Brand = model.BrandName;
item.Pic = model.pic1;
var res = _order.AddOrderItem(item);
}
if ((ms == null && ca != null) || (ms != null && ca != null && ms.LimitMoney <= ca.SendMoney))
{
Coupon coupon = new Coupon();
coupon.BrandId = ca.BrandId;
coupon.BrandName = ca.BrandName;
coupon.CouponType = ca.CouponType;
coupon.CreateTime = DateTime.Now;
coupon.CreateUserId = ca.CreateUserId;
coupon.CreateUserName = ca.CreateUserName;
coupon.EffectTime = ca.EffectTime;
coupon.EndTime = DateTime.Now.AddDays(coupon.EffectTime);
coupon.Id = Guid.NewGuid();
coupon.IsUsed = false;
coupon.LessMoney = ca.LessMoney;
coupon.Limit = ca.Limit;
coupon.Remark = ca.Remark;
coupon.StartTime = ca.StartTime;
coupon.StoreId = loginUser.UserId;
coupon.StoreNum = loginUser.UserNum;
coupon.SupplierId = ca.SupplierId;
coupon.SupplierName = ca.SupplierName;
coupon.ActivityID = ca.Id;
List <UserInfo> userList = new List <UserInfo>();
userList.Add(loginUser);
_active.CreateCoupon(coupon, userList);
}
var dpses = _active.CheckDPS(list, loginUser.TypeId, loginUser.AreaNum);
foreach (var dps in dpses)
{
var model = _manager.GetGoodsWithPrice(dps.SendGoodsId, loginUser.TypeId);
OrderItem item = new OrderItem();
item.IsGift = true;
item.Count = dps.SendCount;
item.CreateUserId = loginUser.UserId;
item.Id = Guid.NewGuid();
item.LessPrice = 0;
item.Price = 0;
item.RealPrice = 0;
item.ProductId = model.Id;
item.ProductTittle = model.GoodsTittle;
item.TotalPrice = 0;
item.ProductType = model.FirstTypeName;
item.ProductTypeId = model.FirstTypeId;
item.ProductId = model.Id;
item.BarCode = model.BarCode;
item.Spec = model.Spec;
item.Unit = model.Unit;
item.SupplierId = model.SupplierId;
item.SupplierName = model.SupplierName;
item.BrandId = model.BrandId;
item.Brand = model.BrandName;
item.Pic = model.pic1;
var res = _order.AddOrderItem(item);
}
_response.Stutas = _order.SaveOrder(order, loginUser);
//保存订单成功后 保存销售订单到erp 系统中
if (_response.Stutas)
{
try
{
var res = _order.InsertErp(order.Id);
}
catch (Exception ex)
{
LogsHelper.WriteErrorLog(ex, "导入Erp");
}
}
}
else
{
_response.Msg = "总金额不足380无法下单！请继续添加商品！";
}
return(Utils.SerializeObject(_response));
}
public ActionResult GetCurrentCouponActivity(string callBack)
{
CouponActivity result = ActivitySystem.GetCurrentCouponActivity();
return(this.Jsonp(callBack, result));
}
public ActionResult CouponActivityConfig(string id = "-1")
{
CouponActivity model = ActivityManager.GetCurrentCouponActivity(id);
return(View(model));
}