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