protected string ReadUserEmail(string strUserGrade) { string str = string.Empty; Dictionary <decimal, decimal> moneyUsed = new Dictionary <decimal, decimal>(); foreach (string str2 in strUserGrade.Split(new char[] { ',' })) { UserGradeInfo info = UserGradeBLL.ReadUserGradeCache(Convert.ToInt32(str2)); moneyUsed.Add(info.MinMoney, info.MaxMoney); } List <string> list = UserBLL.ReadUserEmailByMoneyUsed(moneyUsed); foreach (string str2 in list) { if (str == string.Empty) { str = str2; } else { str = str + "," + str2; } } return(str); }
protected void SubmitButton_Click(object sender, EventArgs e) { UserGradeInfo userGrade = new UserGradeInfo(); userGrade.ID = RequestHelper.GetQueryString <int>("ID"); userGrade.Name = this.Name.Text; userGrade.MinMoney = Convert.ToDecimal(this.MinMoney.Text); userGrade.MaxMoney = Convert.ToDecimal(this.MaxMoney.Text); userGrade.Discount = Convert.ToDecimal(this.Discount.Text); string alertMessage = ShopLanguage.ReadLanguage("AddOK"); if (userGrade.ID == -2147483648) { base.CheckAdminPower("AddUserGrade", PowerCheckType.Single); int id = UserGradeBLL.AddUserGrade(userGrade); AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("UserGrade"), id); } else { base.CheckAdminPower("UpdateUserGrade", PowerCheckType.Single); UserGradeBLL.UpdateUserGrade(userGrade); AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("UserGrade"), userGrade.ID); alertMessage = ShopLanguage.ReadLanguage("UpdateOK"); } AdminBasePage.Alert(alertMessage, RequestHelper.RawUrl); }
public static List <UserGradeInfo> JoinUserGrade(int productID) { List <MemberPriceInfo> list = MemberPriceBLL.ReadMemberPriceByProduct(productID); List <UserGradeInfo> list2 = ReadUserGradeCacheList(); List <UserGradeInfo> list3 = new List <UserGradeInfo>(); foreach (UserGradeInfo info in list2) { bool flag = false; foreach (MemberPriceInfo info2 in list) { if (info.ID == info2.GradeID) { UserGradeInfo item = new UserGradeInfo(); item = (UserGradeInfo)ServerHelper.CopyClass(info); item.MemberPrice = info2; flag = true; list3.Add(item); break; } } if (!flag) { info.MemberPrice.Price = -1M; list3.Add(info); } } return(list3); }
public int AddUserGrade(UserGradeInfo userGrade) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@name", SqlDbType.NVarChar), new SqlParameter("@minMoney", SqlDbType.Decimal), new SqlParameter("@maxMoney", SqlDbType.Decimal), new SqlParameter("@discount", SqlDbType.Decimal) }; pt[0].Value = userGrade.Name; pt[1].Value = userGrade.MinMoney; pt[2].Value = userGrade.MaxMoney; pt[3].Value = userGrade.Discount; return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddUserGrade", pt))); }
public void UpdateUserGrade(UserGradeInfo userGrade) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@name", SqlDbType.NVarChar), new SqlParameter("@minMoney", SqlDbType.Decimal), new SqlParameter("@maxMoney", SqlDbType.Decimal), new SqlParameter("@discount", SqlDbType.Decimal) }; pt[0].Value = userGrade.ID; pt[1].Value = userGrade.Name; pt[2].Value = userGrade.MinMoney; pt[3].Value = userGrade.MaxMoney; pt[4].Value = userGrade.Discount; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateUserGrade", pt); }
public void Update(UserGradeInfo entity) { using (var conn = new SqlConnection(connectString)) { string sql = @"UPDATE UsrGrade SET Name = @Name, MinMoney = @MinMoney, MaxMoney = @MaxMoney, Discount = @Discount where Id=@Id"; conn.Execute(sql, entity); } }
public int Add(UserGradeInfo entity) { using (var conn = new SqlConnection(connectString)) { string sql = @"INSERT INTO UsrGrade( Name,MinMoney,MaxMoney,Discount) VALUES(@Name,@MinMoney,@MaxMoney,@Discount); select SCOPE_IDENTITY()"; return(conn.Query <int>(sql, entity).Single()); } }
public void PrepareUserGradeModel(SqlDataReader dr, List <UserGradeInfo> userGradeList) { while (dr.Read()) { UserGradeInfo item = new UserGradeInfo(); item.ID = dr.GetInt32(0); item.Name = dr[1].ToString(); item.MinMoney = dr.GetDecimal(2); item.MaxMoney = dr.GetDecimal(3); item.Discount = dr.GetDecimal(4); userGradeList.Add(item); } }
public static decimal ReadMemberPrice(UserGradeInfo userGrade, List <MemberPriceInfo> memberPriceList, ProductInfo product) { decimal d = (product.MarketPrice * userGrade.Discount) / 100M; foreach (MemberPriceInfo info in memberPriceList) { if (info.GradeID == userGrade.ID) { d = info.Price; break; } } return(Math.Round(d, 2)); }
public async Task <ActionResult> OnGetAsync() { Sessions = await Client.GetSessionsAsync(); Flights = await Client.GetFlightsAsync(Sessions.FirstOrDefault().Id); FlightPlans = await Client.GetFlightPlansAsync(Sessions.FirstOrDefault().Id); AtcFacilities = await Client.GetAtcFacilitiesAsync(new Guid("7e5dcd44-1fb5-49cc-bc2c-a9aab1f6a856")); User = await Client.GetUserGradeAsync(Flights.FirstOrDefault().UserId); return(Page()); }
/// <summary> /// 读取产品指定的会员价格 /// </summary> /// <param name="userGrade"></param> /// <param name="memberPriceList"></param> /// <param name="product"></param> /// <returns></returns> public static decimal ReadMemberPrice(UserGradeInfo userGrade, List <MemberPriceInfo> memberPriceList, ProductInfo product) { decimal result = product.MarketPrice * userGrade.Discount / 100; foreach (MemberPriceInfo memberPrice in memberPriceList) { if (memberPrice.GradeID == userGrade.ID) { result = memberPrice.Price; break; } } return(Math.Round(result, 2)); }
public static UserGradeInfo ReadUserGradeCache(int id) { UserGradeInfo info = new UserGradeInfo(); List <UserGradeInfo> list = ReadUserGradeCacheList(); foreach (UserGradeInfo info2 in list) { if (info2.ID == id) { return(info2); } } return(info); }
public static UserGradeInfo ReadUserGradeByMoney(decimal money) { UserGradeInfo info = new UserGradeInfo(); List <UserGradeInfo> list = ReadUserGradeCacheList(); foreach (UserGradeInfo info2 in list) { if ((money >= info2.MinMoney) && (money < info2.MaxMoney)) { return(info2); } } return(info); }
public UserController() { uid = RequestHelper.GetForm <int>("uid"); if (uid <= 0) { uid = RequestHelper.GetQueryString <int>("uid"); } user = UserBLL.ReadUserMore(uid); if (user != null && user.Id > 0) { userGradeInfo = UserGradeBLL.ReadByMoney(user.MoneyUsed); userGrade = userGradeInfo.Id; } }
/// <summary> /// 根据消费金额读取一条用户等级数据 /// </summary> /// <param name="id">消费金额</param> /// <returns>用户等级数据模型</returns> public static UserGradeInfo ReadByMoney(decimal money) { UserGradeInfo userGrade = new UserGradeInfo(); List <UserGradeInfo> userGradeList = ReadList(); foreach (UserGradeInfo temp in userGradeList) { if (money >= temp.MinMoney && money < temp.MaxMoney) { userGrade = temp; break; } } return(userGrade); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int userGradeID = RequestHelper.GetQueryString <int>("ID"); if (userGradeID != int.MinValue) { CheckAdminPower("ReadUserGrade", PowerCheckType.Single); UserGradeInfo userGrade = UserGradeBLL.Read(userGradeID); Name.Text = userGrade.Name; MinMoney.Text = userGrade.MinMoney.ToString(); MaxMoney.Text = userGrade.MaxMoney.ToString(); Discount.Text = userGrade.Discount.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { int queryString = RequestHelper.GetQueryString <int>("ID"); if (queryString != -2147483648) { // base.CheckAdminPower("ReadUserGrade", PowerCheckType.Single); UserGradeInfo info = UserGradeBLL.ReadUserGradeCache(queryString); this.Name.Text = info.Name; this.MinMoney.Text = info.MinMoney.ToString(); this.MaxMoney.Text = info.MaxMoney.ToString(); this.Discount.Text = info.Discount.ToString(); } } }
public UserController() { uid = RequestHelper.GetForm <int>("uid"); if (uid <= 0) { uid = RequestHelper.GetQueryString <int>("uid"); } user = UserBLL.ReadUserMore(uid); if (user != null && user.Id > 0) { userGradeInfo = UserGradeBLL.ReadByMoney(user.MoneyUsed); userGrade = userGradeInfo.Id; } user.UserName = System.Web.HttpUtility.UrlDecode(user.UserName, System.Text.Encoding.UTF8); //分销商等级标题 user.Distributor_Grade_Title = (DistributorGradeBLL.ReadList().FirstOrDefault(d => user.Total_Commission >= d.Min_Amount && user.Total_Commission < d.Max_Amount) ?? new DistributorGradeInfo()).Title; }
protected void SubmitButton_Click(object sender, EventArgs e) { UserGradeInfo userGrade = new UserGradeInfo(); userGrade.Id = RequestHelper.GetQueryString <int>("ID"); userGrade.Name = Name.Text; userGrade.MinMoney = Convert.ToDecimal(MinMoney.Text); userGrade.MaxMoney = Convert.ToDecimal(MaxMoney.Text); userGrade.Discount = Convert.ToDecimal(Discount.Text); if (userGrade.MinMoney >= userGrade.MaxMoney) { ScriptHelper.Alert("等级最高金额必须大于最低金额"); } #region 判断等级范围是否重叠 var gradeList = UserGradeBLL.ReadList().Where(k => k.Id != userGrade.Id).ToList(); if (gradeList.Any(k => (k.MinMoney >= userGrade.MinMoney && k.MaxMoney <= userGrade.MaxMoney) || (k.MinMoney <= userGrade.MinMoney && k.MaxMoney >= userGrade.MaxMoney) || (k.MinMoney < userGrade.MinMoney && k.MaxMoney > userGrade.MinMoney && k.MaxMoney < userGrade.MaxMoney) || (k.MinMoney > userGrade.MinMoney && k.MinMoney < userGrade.MaxMoney && k.MaxMoney > userGrade.MaxMoney))) { ScriptHelper.Alert("等级范围重叠,请重新输入"); } #endregion string alertMessage = ShopLanguage.ReadLanguage("AddOK"); if (userGrade.Id == int.MinValue) { CheckAdminPower("AddUserGrade", PowerCheckType.Single); int id = UserGradeBLL.Add(userGrade); AdminLogBLL.Add(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("UserGrade"), id); } else { CheckAdminPower("UpdateUserGrade", PowerCheckType.Single); UserGradeBLL.Update(userGrade); AdminLogBLL.Add(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("UserGrade"), userGrade.Id); alertMessage = ShopLanguage.ReadLanguage("UpdateOK"); } ScriptHelper.Alert(alertMessage, RequestHelper.RawUrl); }
/// <summary> /// 根据优惠活动选择的用户等级,获取对应的等级名称 /// </summary> /// <param name="userGrade"></param> /// <returns></returns> protected string GetUserGradeOfActivity(string userGrade = "") { string result = string.Empty; List <string> gradeNames = new List <string>(); if (!string.IsNullOrEmpty(userGrade)) { string[] a = userGrade.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (var b in a) { UserGradeInfo gd = userGrades.Find(k => k.Id.ToString() == b) ?? new UserGradeInfo(); if (gd.Id > 0) { gradeNames.Add(gd.Name); } } } if (gradeNames.Count > 0) { result = string.Join(",", gradeNames); } return(result); }
public static void Update(UserGradeInfo entity) { dal.Update(entity); }
public static void UpdateUserGrade(UserGradeInfo userGrade) { dal.UpdateUserGrade(userGrade); CacheHelper.Remove(cacheKey); }
public static int AddUserGrade(UserGradeInfo userGrade) { userGrade.ID = dal.AddUserGrade(userGrade); CacheHelper.Remove(cacheKey); return(userGrade.ID); }
public static int Add(UserGradeInfo entity) { return(dal.Add(entity)); }
protected override void PageLoad() { base.PageLoad(); if (CookiesHelper.ReadCookieValue("ProductShowWay") != string.Empty) { this.productShowWay = Convert.ToInt32(CookiesHelper.ReadCookieValue("ProductShowWay")); } int queryString = RequestHelper.GetQueryString <int>("Page"); if (queryString < 1) { queryString = 1; } int pageSize = 20; if (this.productShowWay == 2) { pageSize = 10; } int count = 0; ProductSearchInfo productSearch = new ProductSearchInfo(); productSearch.IsSale = 1; productSearch.ProductOrderType = CookiesHelper.ReadCookieValue("ProductOrderType"); if (RequestHelper.GetQueryString <int>("SearchType") == 2) { string str = StringHelper.SearchSafe(RequestHelper.GetQueryString <string>("ClassID")); int num5 = -2147483648; if (str == num5.ToString()) { str = string.Empty; } else { str = "|" + str + "|"; } productSearch.ClassID = str; productSearch.Key = StringHelper.SearchSafe(RequestHelper.GetQueryString <string>("ProductName")); productSearch.InBrandID = RequestHelper.GetQueryString <string>("BrandID"); productSearch.Tags = StringHelper.SearchSafe(RequestHelper.GetQueryString <string>("Tags")); } else { productSearch.IsNew = RequestHelper.GetQueryString <int>("IsNew"); productSearch.IsHot = RequestHelper.GetQueryString <int>("IsHot"); productSearch.IsSpecial = RequestHelper.GetQueryString <int>("IsSpecial"); productSearch.IsTop = RequestHelper.GetQueryString <int>("IsTop"); } if ((productSearch.ProductOrderType == "MemberPrice1") || (productSearch.ProductOrderType == "MemberPrice2")) { UserGradeInfo info2 = UserGradeBLL.ReadUserGradeCache(base.GradeID); if (productSearch.ProductOrderType == "MemberPrice2") { productSearch.OrderType = OrderType.Asc; } this.productList = ProductBLL.SearchProductList(queryString, pageSize, productSearch, ref count, info2.ID, info2.Discount / 100M); } else { this.productList = ProductBLL.SearchProductList(queryString, pageSize, productSearch, ref count); this.countPriceSingle = true; string strProductID = string.Empty; foreach (ProductInfo info3 in this.productList) { if (strProductID == string.Empty) { strProductID = info3.ID.ToString(); } else { strProductID = strProductID + "," + info3.ID.ToString(); } } if (strProductID != string.Empty) { this.memberPriceList = MemberPriceBLL.ReadMemberPriceByProductGrade(strProductID, base.GradeID); } } this.ajaxPagerClass.CurrentPage = queryString; this.ajaxPagerClass.PageSize = pageSize; this.ajaxPagerClass.Count = count; }