/** * 通过手机号和姓名获取会员信息 * */ public static List <MemberInfoData> GetMembers(String MbPhone, String MbName) { String connectStr = ConnectorInfo.connectStr; MySqlConnection conn = new MySqlConnection(connectStr); conn.Open(); MbPhone += "%"; MbName += "%"; List <MemberInfoData> memberInfoDatas = new List <MemberInfoData>(); String sql = "select * from memberinfo where MbPhone like '" + MbPhone + "' and MbName like '" + MbName + "'"; MySqlCommand mySqlCommand = new MySqlCommand(sql, conn); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); while (mySqlDataReader.Read()) { MemberInfoData memberInfoData = new MemberInfoData( mySqlDataReader.GetInt32("MbId"), mySqlDataReader.GetInt32("MtId"), mySqlDataReader.GetString("MbName"), mySqlDataReader.GetString("MbPhone"), mySqlDataReader.GetDouble("MbMoney")); memberInfoDatas.Add(memberInfoData); } return(memberInfoDatas); }
/** * 查找数据库中所有会员 * */ public static List <MemberInfoData> GetMembers() { String connectStr = ConnectorInfo.connectStr; MySqlConnection conn = new MySqlConnection(connectStr); conn.Open(); List <MemberInfoData> memberInfoDatas = new List <MemberInfoData>(); String sql = "select * from memberinfo"; MySqlCommand mySqlCommand = new MySqlCommand(sql, conn); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); while (mySqlDataReader.Read()) { //int mbId, int mtId, string mbName, string mbPhone, double mbMoney MemberInfoData memberInfoData = new MemberInfoData( mySqlDataReader.GetInt32("MbId"), mySqlDataReader.GetInt32("MtId"), mySqlDataReader.GetString("MbName"), mySqlDataReader.GetString("MbPhone"), mySqlDataReader.GetDouble("MbMoney") ); memberInfoDatas.Add(memberInfoData); } return(memberInfoDatas); }
/** * 对VIP账号信息进行模糊查询 * */ private void LoadVIP() { if (MemberPhone.Text == "" && MemberName.Text == "") { return; } String MbPhone = MemberPhone.Text; String MbName = MemberName.Text; List <MemberInfoData> memberInfoDatas = MemberInfoConnector.GetMembers(MbPhone, MbName); if (memberInfoDatas.Count > 1) { return; } else if (memberInfoDatas.Count == 0) { return; } else { MemberInfo = memberInfoDatas[0]; MemberMoney.Content = "¥" + MemberInfo.MbMoney; //加载账户余额 MemberType = MemberInfoConnector.GetMemberType(MemberInfo.MbId); //获得账户会员类型 MemberTypeLabel.Content = MemberType.MTitle; MemberDiscountLabel.Content = MemberType.MDiscount; //折扣 shouldPayLabel.Content = summaryMoney * MemberType.MDiscount; shouldPay = summaryMoney * MemberType.MDiscount; leftMoney = MemberInfo.MbMoney; } }
public static void ReLoadCacheData(string cacheName) { switch (cacheName) { case "": MemberInfoData.CreateData(); break; case "SmsCorpData": MemberInfoData.CreateData(); break; } }
private void CheckBox_Checked(object sender, RoutedEventArgs e) { if (IsVIP.IsChecked == true) { VIPGroup.IsEnabled = true; } else { VIPGroup.IsEnabled = false; shouldPayLabel.Content = summaryMoney; shouldPay = summaryMoney; MemberInfo = null; MemberType = null; } }
private IEnumerable<PocoMemberPlan> GetPocoMembers(MapperCollection mapper, ColumnInfo[] columnInfos, List<MemberInfo> memberInfos, string prefix = null) { var capturedMembers = memberInfos.ToArray(); var capturedPrefix = prefix; foreach (var columnInfo in columnInfos) { if (columnInfo.IgnoreColumn) continue; var memberInfoType = columnInfo.MemberInfo.GetMemberInfoType(); if (columnInfo.ReferenceType == ReferenceType.Many) { var genericArguments = memberInfoType.GetGenericArguments(); memberInfoType = genericArguments.Any() ? genericArguments.First() : memberInfoType.GetTypeWithGenericTypeDefinitionOf(typeof(IList<>)).GetGenericArguments().First(); } var childrenPlans = new PocoMemberPlan[0]; TableInfoPlan childTableInfoPlan = null; var members = new List<MemberInfo>(capturedMembers) { columnInfo.MemberInfo }; if (columnInfo.ComplexMapping || columnInfo.ReferenceType != ReferenceType.None) { if (capturedMembers.GroupBy(x => x.GetMemberInfoType()).Any(x => x.Count() >= 2)) { continue; } var childColumnInfos = GetColumnInfos(memberInfoType); if (columnInfo.ReferenceType != ReferenceType.None) { childTableInfoPlan = GetTableInfo(memberInfoType, childColumnInfos, members); } var newPrefix = JoinStrings(capturedPrefix, columnInfo.ReferenceType != ReferenceType.None ? "" : (columnInfo.ComplexPrefix ?? columnInfo.MemberInfo.Name)); childrenPlans = GetPocoMembers(mapper, childColumnInfos, members, newPrefix).ToArray(); } MemberInfo capturedMemberInfo = columnInfo.MemberInfo; ColumnInfo capturedColumnInfo = columnInfo; var accessors = GetMemberAccessors(members); var memberType = capturedMemberInfo.GetMemberInfoType(); var isList = IsList(capturedMemberInfo); var listType = GetListType(memberType, isList); var isDynamic = capturedMemberInfo.IsDynamic(); var fastCreate = GetFastCreate(memberType, mapper, isList, isDynamic); var columnName = GetColumnName(capturedPrefix, capturedColumnInfo.ColumnName ?? capturedMemberInfo.Name); var memberInfoData = new MemberInfoData(capturedMemberInfo); yield return tableInfo => { var pc = new PocoColumn { ReferenceType = capturedColumnInfo.ReferenceType, TableInfo = tableInfo, MemberInfoData = memberInfoData, MemberInfoChain = members, ColumnName = columnName, ResultColumn = capturedColumnInfo.ResultColumn, ForceToUtc = capturedColumnInfo.ForceToUtc, ComputedColumn = capturedColumnInfo.ComputedColumn, ComputedColumnType = capturedColumnInfo.ComputedColumnType, ColumnType = capturedColumnInfo.ColumnType, ColumnAlias = capturedColumnInfo.ColumnAlias, VersionColumn = capturedColumnInfo.VersionColumn, VersionColumnType = capturedColumnInfo.VersionColumnType, SerializedColumn = capturedColumnInfo.SerializedColumn }; pc.SetMemberAccessors(accessors); var childrenTableInfo = childTableInfoPlan == null ? tableInfo : childTableInfoPlan(); var children = childrenPlans.Select(plan => plan(childrenTableInfo)).ToList(); // Cascade ResultColumn down foreach (var child in children.Where(child => child.PocoColumn != null && pc.ResultColumn)) { child.PocoColumn.ResultColumn = true; } var pocoMember = new PocoMember() { MemberInfoData = memberInfoData, MemberInfoChain = members, IsList = isList, IsDynamic = isDynamic, PocoColumn = capturedColumnInfo.ComplexMapping ? null : pc, ReferenceType = capturedColumnInfo.ReferenceType, ReferenceMemberName = capturedColumnInfo.ReferenceMemberName, PocoMemberChildren = children, }; pocoMember.SetMemberAccessor(accessors[accessors.Count - 1], fastCreate, listType); return pocoMember; }; } }
internal static string GetMemberInfo(string scriptFile, int caret, bool collapseOverloads) { // Complete API for N++ Output.WriteLine("GetMemberInfo"); //Console.WriteLine("hint: " + hint); var script = new SourceInfo(scriptFile); string result = null; if (script.Content.IsEmpty()) { throw new Exception("The file containing code is empty"); } void loockupDirective(string directive) { var css_directive = CssCompletionData.AllDirectives .FirstOrDefault(x => x.DisplayText == directive); if (css_directive != null) { result = $"Directive: {css_directive.DisplayText}\n{css_directive.Description}"; result = result.NormalizeLineEnding().Replace("\r\n\r\n", "\r\n").TrimEnd(); } }; ParseAsCssDirective(script.Content, caret, loockupDirective, (directive, arg, extensions) => { if (LookopDirectivePath(script, caret, directive, arg) is string file) { result = $"File: {file}"; } else { loockupDirective(directive); } }); if (result.HasText()) { return(MemberInfoData.Serialize(new MemberInfoData { Info = result })); } if (!script.RawFile.EndsWith(".g.cs")) { CSScriptHelper.DecorateIfRequired(ref script.Content, ref caret); } Project project = CSScriptHelper.GenerateProjectFor(script); var sources = project.Files .Where(f => f != script.File) .Select(f => new Tuple <string, string>(File.ReadAllText(f), f)) .ToArray(); int methodStartPosTemp; var items = Autocompleter.GetMemberInfo(script.Content, caret, out methodStartPosTemp, project.Refs, sources, includeOverloads: !collapseOverloads); if (collapseOverloads) { items = items.Take(1); } result = items.Select(x => new MemberInfoData { Info = x, MemberStartPosition = methodStartPosTemp }) .Select(MemberInfoData.Serialize) .JoinSerializedLines(); return(result); }