private void SaveDiscountProductInfo(HttpContext context) { decimal num3; decimal num4; decimal num5; int num = Globals.RequestFormNum("ProductId"); int num2 = Globals.RequestFormNum("LimitedTimeDiscountId"); decimal.TryParse(Globals.RequestFormStr("Discount"), out num3); decimal.TryParse(Globals.RequestFormStr("Minus"), out num4); decimal.TryParse(Globals.RequestFormStr("FinalPrice"), out num5); LimitedTimeDiscountProductInfo info = new LimitedTimeDiscountProductInfo { ProductId = num, LimitedTimeDiscountId = num2, Discount = num3, Minus = num4, FinalPrice = num5 }; if (LimitedTimeDiscountHelper.UpdateLimitedTimeDiscountProduct(info)) { context.Response.Write("{\"msg\":\"success\"}"); } else { context.Response.Write("{\"msg\":\"fial\"}"); } }
private void grdProducts_ItemCommand(object sender, System.Web.UI.WebControls.RepeaterCommandEventArgs e) { if (e.CommandName == "MoveProduct") { object commandArgument = e.CommandArgument; if (!string.IsNullOrEmpty(commandArgument.ToString())) { bool flag = LimitedTimeDiscountHelper.DeleteDiscountProduct(commandArgument.ToString()); if (flag) { this.ShowMsgAndReUrl("移除成功", true, "LimitedTimeDiscountProduct.aspx?id=" + Globals.RequestQueryNum("id")); } } } if (e.CommandName == "Stop") { int num = 0; if (int.TryParse(e.CommandArgument.ToString(), out num)) { LimitedTimeDiscountProductInfo discountProductInfoById = LimitedTimeDiscountHelper.GetDiscountProductInfoById(num); int status = (discountProductInfoById.Status == 3) ? 1 : 3; if (!string.IsNullOrEmpty(num.ToString())) { bool flag2 = LimitedTimeDiscountHelper.ChangeDiscountProductStatus(num.ToString(), status); if (flag2) { this.ShowMsgAndReUrl("状态修改成功", true, "LimitedTimeDiscountProduct.aspx?id=" + Globals.RequestQueryNum("id")); } } } } }
private void IsDiscountProduct(System.Web.HttpContext context) { int num = Globals.RequestFormNum("productId"); if (num > 0) { LimitedTimeDiscountProductInfo discountProductInfoByProductId = LimitedTimeDiscountHelper.GetDiscountProductInfoByProductId(num); if (discountProductInfoByProductId != null) { LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(discountProductInfoByProductId.LimitedTimeDiscountId); MemberInfo currentMember = MemberProcessor.GetCurrentMember(); int num2 = 0; int num3 = discountInfo.LimitNumber; if (discountInfo != null) { if (currentMember != null) { if (MemberHelper.CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, currentMember.UserId)) { int limitedTimeDiscountUsedNum = ShoppingCartProcessor.GetLimitedTimeDiscountUsedNum(discountProductInfoByProductId.LimitedTimeDiscountId, null, num, currentMember.UserId, false); if (discountInfo.LimitNumber == 0) { num2 = discountInfo.LimitedTimeDiscountId; } else if (discountInfo.LimitNumber - limitedTimeDiscountUsedNum > 0) { num2 = discountInfo.LimitedTimeDiscountId; num3 = discountInfo.LimitNumber - limitedTimeDiscountUsedNum; } else { num3 = 0; } } } else { num2 = discountInfo.LimitedTimeDiscountId; } } if (discountInfo != null) { context.Response.Write(string.Concat(new object[] { "{\"msg\":\"success\",\"ActivityName\":\"", Globals.String2Json(discountInfo.ActivityName), "\",\"FinalPrice\":\"", discountProductInfoByProductId.FinalPrice.ToString("f2"), "\",\"LimitedTimeDiscountId\":\"", num2, "\",\"LimitNumber\":\"", discountInfo.LimitNumber, "\",\"RemainNumber\":\"", num3, "\"}" })); } } } }
private void SaveDiscountProduct(HttpContext context) { Globals.RequestFormNum("id"); foreach (string str2 in Globals.RequestFormStr("discountProductList").Trim(new char[] { ',' }).Split(new char[] { ',' })) { string[] strArray2 = str2.Split(new char[] { '^' }); LimitedTimeDiscountProductInfo info = new LimitedTimeDiscountProductInfo(); if (((!string.IsNullOrEmpty(strArray2[0]) && !string.IsNullOrEmpty(strArray2[1])) && !string.IsNullOrEmpty(strArray2[4])) && (!string.IsNullOrEmpty(strArray2[2]) || !string.IsNullOrEmpty(strArray2[3]))) { int id = Globals.ToNum(strArray2[0]); LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(id); info.LimitedTimeDiscountId = id; info.ProductId = Globals.ToNum(strArray2[1]); info.Discount = (string.IsNullOrEmpty(strArray2[2]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[2]); info.Minus = (string.IsNullOrEmpty(strArray2[3]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[3]); info.FinalPrice = decimal.Parse(strArray2[4]); if (discountInfo != null) { info.BeginTime = discountInfo.BeginTime; info.EndTime = discountInfo.EndTime; } info.CreateTime = DateTime.Now; info.Status = 1; LimitedTimeDiscountHelper.AddLimitedTimeDiscountProduct(info); } } context.Response.Write("{\"msg\":\"success\"}"); }
public bool UpdateLimitedTimeDiscountProductById(LimitedTimeDiscountProductInfo info) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE [Hishop_LimitedTimeDiscountProduct] SET [Discount]=@Discount,[Minus]=@Minus,[IsDehorned]=@IsDehorned,[IsChamferPoint]=@IsChamferPoint,[FinalPrice]=@FinalPrice WHERE LimitedTimeDiscountProductId=@LimitedTimeDiscountProductId"); this.database.AddInParameter(sqlStringCommand, "Discount", System.Data.DbType.Decimal, info.Discount); this.database.AddInParameter(sqlStringCommand, "Minus", System.Data.DbType.Decimal, info.Minus); this.database.AddInParameter(sqlStringCommand, "IsDehorned", System.Data.DbType.Int32, info.IsDehorned); this.database.AddInParameter(sqlStringCommand, "IsChamferPoint", System.Data.DbType.Int32, info.IsChamferPoint); this.database.AddInParameter(sqlStringCommand, "FinalPrice", System.Data.DbType.Decimal, info.FinalPrice); this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountProductId", System.Data.DbType.Int32, info.LimitedTimeDiscountProductId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public LimitedTimeDiscountProductInfo GetDiscountProductInfoById(int id) { LimitedTimeDiscountProductInfo result = null; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_LimitedTimeDiscountProduct WHERE LimitedTimeDiscountProductId = @LimitedTimeDiscountProductId"); this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountProductId", System.Data.DbType.Int32, id); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { result = ReaderConvert.ReaderToModel <LimitedTimeDiscountProductInfo>(dataReader); } return(result); }
public LimitedTimeDiscountProductInfo GetDiscountProductInfoByProductId(int productId) { LimitedTimeDiscountProductInfo result = null; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_LimitedTimeDiscountProduct WHERE ProductId = @productId and Status=1 and BeginTime <=GETDATE() and EndTime>=GETDATE() "); this.database.AddInParameter(sqlStringCommand, "productId", System.Data.DbType.Int32, productId); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { result = ReaderConvert.ReaderToModel <LimitedTimeDiscountProductInfo>(dataReader); } return(result); }
public LimitedTimeDiscountProductInfo GetLimitedTimeDiscountProductByLimitIdAndProductId(int limitedTimeDiscountId, int productId) { LimitedTimeDiscountProductInfo result = null; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT top 1 * FROM Hishop_LimitedTimeDiscountProduct WHERE LimitedTimeDiscountId = @LimitedTimeDiscountId and ProductId=@ProductId and Status=1 and BeginTime<=getdate() and getdate()< EndTime order by LimitedTimeDiscountProductId desc"); this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountId", System.Data.DbType.Int32, limitedTimeDiscountId); this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, productId); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { result = ReaderConvert.ReaderToModel <LimitedTimeDiscountProductInfo>(dataReader); } return(result); }
public LimitedTimeDiscountProductInfo GetLimitedTimeDiscountProductByLimitIdAndProductIdAndUserId(int limitedTimeDiscountId, int productId, int userId) { LimitedTimeDiscountProductInfo info = null; LimitedTimeDiscountProductInfo limitedTimeDiscountProductByLimitIdAndProductId = this.GetLimitedTimeDiscountProductByLimitIdAndProductId(limitedTimeDiscountId, productId); if (limitedTimeDiscountProductByLimitIdAndProductId != null) { LimitedTimeDiscountInfo discountInfo = this.GetDiscountInfo(limitedTimeDiscountProductByLimitIdAndProductId.LimitedTimeDiscountId); if ((discountInfo != null) && new MemberDao().CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, userId)) { info = limitedTimeDiscountProductByLimitIdAndProductId; } } return(info); }
public bool AddLimitedTimeDiscountProduct(LimitedTimeDiscountProductInfo info) { this.DeleteDiscountProduct(info.LimitedTimeDiscountId, info.ProductId); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO [Hishop_LimitedTimeDiscountProduct] ([LimitedTimeDiscountId],[ProductId],[Discount],[Minus],[IsDehorned],[IsChamferPoint],[FinalPrice],[CreateTime],[BeginTime],[EndTime],[Status]) VALUES (@LimitedTimeDiscountId,@ProductId,@Discount,@Minus,@IsDehorned,@IsChamferPoint,@FinalPrice,@CreateTime,@BeginTime,@EndTime,@Status);"); this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountId", System.Data.DbType.Int32, info.LimitedTimeDiscountId); this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, info.ProductId); this.database.AddInParameter(sqlStringCommand, "Discount", System.Data.DbType.Decimal, info.Discount); this.database.AddInParameter(sqlStringCommand, "Minus", System.Data.DbType.Decimal, info.Minus); this.database.AddInParameter(sqlStringCommand, "IsDehorned", System.Data.DbType.Int32, info.IsDehorned); this.database.AddInParameter(sqlStringCommand, "IsChamferPoint", System.Data.DbType.Int32, info.IsChamferPoint); this.database.AddInParameter(sqlStringCommand, "FinalPrice", System.Data.DbType.Decimal, info.FinalPrice); this.database.AddInParameter(sqlStringCommand, "CreateTime", System.Data.DbType.DateTime, info.CreateTime); this.database.AddInParameter(sqlStringCommand, "BeginTime", System.Data.DbType.DateTime, info.BeginTime); this.database.AddInParameter(sqlStringCommand, "EndTime", System.Data.DbType.DateTime, info.EndTime); this.database.AddInParameter(sqlStringCommand, "Status", System.Data.DbType.Int32, info.Status); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
private void SaveDiscountProduct(System.Web.HttpContext context) { Globals.RequestFormNum("id"); string text = Globals.RequestFormStr("discountProductList").Trim(new char[] { ',' }); string[] array = text.Split(new char[] { ',' }); string[] array2 = array; for (int i = 0; i < array2.Length; i++) { string text2 = array2[i]; string[] array3 = text2.Split(new char[] { '^' }); LimitedTimeDiscountProductInfo limitedTimeDiscountProductInfo = new LimitedTimeDiscountProductInfo(); if (!string.IsNullOrEmpty(array3[0]) && !string.IsNullOrEmpty(array3[1]) && !string.IsNullOrEmpty(array3[4]) && (!string.IsNullOrEmpty(array3[2]) || !string.IsNullOrEmpty(array3[3]))) { int num = Globals.ToNum(array3[0]); LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(num); limitedTimeDiscountProductInfo.LimitedTimeDiscountId = num; limitedTimeDiscountProductInfo.ProductId = Globals.ToNum(array3[1]); limitedTimeDiscountProductInfo.Discount = ((string.IsNullOrEmpty(array3[2]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[2])); limitedTimeDiscountProductInfo.Minus = ((string.IsNullOrEmpty(array3[3]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[3])); limitedTimeDiscountProductInfo.FinalPrice = decimal.Parse(array3[4]); if (discountInfo != null) { limitedTimeDiscountProductInfo.BeginTime = discountInfo.BeginTime; limitedTimeDiscountProductInfo.EndTime = discountInfo.EndTime; } limitedTimeDiscountProductInfo.CreateTime = System.DateTime.Now; limitedTimeDiscountProductInfo.Status = 1; LimitedTimeDiscountHelper.AddLimitedTimeDiscountProduct(limitedTimeDiscountProductInfo); } } context.Response.Write("{\"msg\":\"success\"}"); }
private void UpdateDiscountProductList(System.Web.HttpContext context) { int id = Globals.RequestFormNum("LimitedTimeDiscountId"); string text = Globals.RequestFormStr("discountProductList").Trim(new char[] { ',' }); string[] array = text.Split(new char[] { ',' }); string[] array2 = array; for (int i = 0; i < array2.Length; i++) { string text2 = array2[i]; string[] array3 = text2.Split(new char[] { '^' }); for (int j = 0; j < array3.Length; j++) { if (!string.IsNullOrEmpty(array3[0]) && !string.IsNullOrEmpty(array3[1]) && !string.IsNullOrEmpty(array3[4]) && (!string.IsNullOrEmpty(array3[2]) || !string.IsNullOrEmpty(array3[3]))) { LimitedTimeDiscountProductInfo limitedTimeDiscountProductInfo = new LimitedTimeDiscountProductInfo(); int limitedTimeDiscountProductId = Globals.ToNum(array3[0]); LimitedTimeDiscountHelper.GetDiscountInfo(id); limitedTimeDiscountProductInfo.LimitedTimeDiscountProductId = limitedTimeDiscountProductId; limitedTimeDiscountProductInfo.Discount = ((string.IsNullOrEmpty(array3[2]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[2])); limitedTimeDiscountProductInfo.Minus = ((string.IsNullOrEmpty(array3[3]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[3])); limitedTimeDiscountProductInfo.FinalPrice = decimal.Parse(array3[4]); LimitedTimeDiscountHelper.UpdateLimitedTimeDiscountProductById(limitedTimeDiscountProductInfo); } } } context.Response.Write("{\"msg\":\"success\"}"); }
private void IsDiscountProduct(HttpContext context) { int productId = Globals.RequestFormNum("productId"); if (productId > 0) { LimitedTimeDiscountProductInfo discountProductInfoByProductId = LimitedTimeDiscountHelper.GetDiscountProductInfoByProductId(productId); if (discountProductInfoByProductId != null) { LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(discountProductInfoByProductId.LimitedTimeDiscountId); MemberInfo currentMember = MemberProcessor.GetCurrentMember(); int limitedTimeDiscountId = 0; if (discountInfo != null) { if (currentMember != null) { if (MemberHelper.CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, currentMember.UserId)) { int num3 = ShoppingCartProcessor.GetLimitedTimeDiscountUsedNum(limitedTimeDiscountId, null, productId, currentMember.UserId, false); if ((discountInfo.LimitNumber - num3) > 0) { limitedTimeDiscountId = discountInfo.LimitedTimeDiscountId; } } } else { limitedTimeDiscountId = discountInfo.LimitedTimeDiscountId; } } if (discountInfo != null) { context.Response.Write(string.Concat(new object[] { "{\"msg\":\"success\",\"ActivityName\":\"", discountInfo.ActivityName, "\",\"FinalPrice\":\"", discountProductInfoByProductId.FinalPrice.ToString("f2"), "\",\"LimitedTimeDiscountId\":\"", limitedTimeDiscountId, "\",\"LimitNumber\":\"", discountInfo.LimitNumber, "\"}" })); } } } }
private void UpdateDiscountProductList(HttpContext context) { int id = Globals.RequestFormNum("LimitedTimeDiscountId"); foreach (string str2 in Globals.RequestFormStr("discountProductList").Trim(new char[] { ',' }).Split(new char[] { ',' })) { string[] strArray2 = str2.Split(new char[] { '^' }); for (int i = 0; i < strArray2.Length; i++) { if (((!string.IsNullOrEmpty(strArray2[0]) && !string.IsNullOrEmpty(strArray2[1])) && !string.IsNullOrEmpty(strArray2[4])) && (!string.IsNullOrEmpty(strArray2[2]) || !string.IsNullOrEmpty(strArray2[3]))) { LimitedTimeDiscountProductInfo info = new LimitedTimeDiscountProductInfo(); int num3 = Globals.ToNum(strArray2[0]); LimitedTimeDiscountHelper.GetDiscountInfo(id); info.LimitedTimeDiscountProductId = num3; info.Discount = (string.IsNullOrEmpty(strArray2[2]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[2]); info.Minus = (string.IsNullOrEmpty(strArray2[3]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[3]); info.FinalPrice = decimal.Parse(strArray2[4]); LimitedTimeDiscountHelper.UpdateLimitedTimeDiscountProductById(info); } } } context.Response.Write("{\"msg\":\"success\"}"); }
public string GetLimitedTimeDiscountIdByProductId(int userid, string skuId, int productId) { int num = 0; LimitedTimeDiscountProductInfo limitedTimeDiscountProductByProductId = this.GetLimitedTimeDiscountProductByProductId(productId); if (limitedTimeDiscountProductByProductId != null) { int limitedTimeDiscountId = limitedTimeDiscountProductByProductId.LimitedTimeDiscountId; LimitedTimeDiscountInfo discountInfo = new LimitedTimeDiscountDao().GetDiscountInfo(limitedTimeDiscountId); if (discountInfo != null) { bool flag = false; if (new MemberDao().CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, userid)) { int limitNumber = discountInfo.LimitNumber; if (limitNumber != 0) { int num4 = limitNumber - new ShoppingCartDao().GetLimitedTimeDiscountUsedNum(limitedTimeDiscountId, skuId, productId, userid, true); if (num4 > 0) { flag = true; } } else { flag = true; } } if (flag) { num = limitedTimeDiscountId; } } } return(num.ToString()); }
public static bool UpdateLimitedTimeDiscountProduct(LimitedTimeDiscountProductInfo info) { return(LimitedTimeDiscountHelper._act.UpdateLimitedTimeDiscountProduct(info)); }
public static bool AddLimitedTimeDiscountProduct(LimitedTimeDiscountProductInfo info) { return(_act.AddLimitedTimeDiscountProduct(info)); }
public static bool UpdateLimitedTimeDiscountProductById(LimitedTimeDiscountProductInfo info) { return(_act.UpdateLimitedTimeDiscountProductById(info)); }