private void button1_Click(object sender, EventArgs e) { try { if (openFileDialog1.ShowDialog() == DialogResult.OK) { List<byte> bytes = new List<byte>(); BinaryReader br = new BinaryReader(File.Open(openFileDialog1.FileName, FileMode.Open)); while (!(br.BaseStream.Position >= br.BaseStream.Length)) { bytes.Add(br.ReadByte()); } br.Close(); //BitArray plain = new BitArray(bytes.ToArray()); StringBuilder sb = new StringBuilder(); foreach (byte b in bytes) { sb.Append(Convert.ToString(b, 2).PadLeft(8, '0')); } richTextBox1.Text = sb.ToString(); sb.Clear(); LFSR lfsr = new LFSR(new List<int>() { 28, 3 }, Services.StringToBooleanArray(textBox1.Text).ToList(), bytes.ToArray()); byte[] cipher = lfsr.GetNewBitArray(); foreach (byte b in cipher) { string curByte = Convert.ToString(b, 2).PadLeft(8, '0'); for (int i = 0; i < 8; i++) { sb.Append(curByte[i]); } sb.Append(" "); } richTextBox3.Text = sb.ToString(); sb.Clear(); richTextBox2.Text = Services.BoolArrayToString(lfsr.Key); if (saveFileDialog1.ShowDialog() == DialogResult.OK) { BinaryWriter bw = new BinaryWriter(File.Create(saveFileDialog1.FileName)); bw.Write(Services.BitArrayToByteArray(new BitArray(cipher))); bw.Close(); } } } catch { } finally { } }
private static void DataTableToJson(StringBuilder result, StringBuilder temp, DataTable table, string idColumn, string textColumn, string relativeColumn, object parentId) { result.Append(temp.ToString()); temp.Clear(); if (table.Rows.Count > 0) { temp.Append("["); string filer = string.Format("{0}='{1}'", relativeColumn, parentId); DataRow[] rows = table.Select(filer); if (rows.Length > 0) { foreach (DataRow row in rows) { temp.Append("{\"id\":\"" + row[idColumn] + "\",\"text\":\"" + row[textColumn] + "\",\"state\":\"open\""); if (table.Select(string.Format("{0}='{1}'", relativeColumn, row[idColumn])).Length > 0) { temp.Append(",\"children\":"); DataTableToJson(result, temp, table, idColumn, textColumn, relativeColumn, row[idColumn]); result.Append(temp.ToString()); temp.Clear(); } result.Append(temp.ToString()); temp.Clear(); temp.Append("},"); } temp = temp.Remove(temp.Length - 1, 1); } temp.Append("]"); result.Append(temp.ToString()); temp.Clear(); } }
private static string[] GetSeparators(string text) { List<string> separators = new List<string>(); StringBuilder separator = new StringBuilder(); for (int i = 0; i < text.Length; i++) { if (text[i] == ' ' || text[i] == '.' || text[i] == ',' || text[i] == '!' || text[i] == '?') { separator.Append(text[i]); } else if (separator.Length > 0) { separators.Add(separator.ToString()); separator.Clear(); } } if (separator.Length > 0) { separators.Add(separator.ToString()); separator.Clear(); } return separators.ToArray(); }
private static void ImprimeGrafico(IEnumerable<ProcessoExecutado> processosExecutados, int tempoTotalExecucao) { ImprimeCabecalhoGrafico(); List<ProcessoExecutado> listProcessos = processosExecutados.ToList(); string linhaPadrao = PreencheLinhaProcessamentoVazia(tempoTotalExecucao); var linha = new StringBuilder(); linha.Append(linhaPadrao); listProcessos.Where(p => p.Tarefa.GetType() == typeof(Tarefa1)).ToList().ForEach(p => PreencheLinhaProcessamentoComInformacoes(p, ref linha)); SysConsole.WriteLine(linha.ToString()); linha.Clear(); linha.Append(linhaPadrao); listProcessos.Where(p => p.Tarefa.GetType() == typeof(Tarefa2)).ToList().ForEach(p => PreencheLinhaProcessamentoComInformacoes(p, ref linha)); SysConsole.WriteLine(linha.ToString()); linha.Clear(); linha.Append(linhaPadrao); listProcessos.Where(p => p.Tarefa.GetType() == typeof(Tarefa3)).ToList().ForEach(p => PreencheLinhaProcessamentoComInformacoes(p, ref linha)); SysConsole.WriteLine(linha.ToString()); linha.Clear(); linha.Append(linhaPadrao); listProcessos.Where(p => p.Tarefa.GetType() == typeof(Tarefa4)).ToList().ForEach(p => PreencheLinhaProcessamentoComInformacoes(p, ref linha)); SysConsole.WriteLine(linha.ToString()); }
static void Main(string[] args) { //We are given a string containing a list of forbidden words and a text containing //some of these words. Write a program that replaces the forbidden words with asterisks.Example: //Microsoft announced its next generation PHP compiler today. //It is based on .NET Framework 4.0 and is implemented as a dynamic language in CLR. //Words: "PHP, CLR, Microsoft" //The expected result: //********* announced its next generation *** compiler today. //It is based on .NET Framework 4.0 and is implemented as a dynamic language in ***. string text = "Microsoft announced its next generation PHP compiler today."+ "It is based on .NET Framework 4.0 and is implemented as a dynamic language in CLR."; string wordOne = "Microsoft"; StringBuilder b = new StringBuilder(); for (int i = 0; i < wordOne.Length; i++) b.Append("*"); string starsOne = b.ToString(); b.Clear(); string wordTwo = "PHP"; for (int i = 0; i < wordTwo.Length; i++) b.Append("*"); string starsTwo = b.ToString(); b.Clear(); string wordThree = "CLR"; for (int i = 0; i < wordThree.Length; i++) b.Append("*"); string starsThree = b.ToString(); b.Clear(); StringBuilder sb = new StringBuilder(text); sb.Replace(wordOne, starsOne); sb.Replace(wordTwo, starsTwo); sb.Replace(wordThree, starsThree); Console.WriteLine(sb.ToString()); //text.IndexOf(wordOne); }
public static void SavePuzzleState(SodukoPiece[,] p,int[,] originalState, int[,] currentPositions) { var state = new ApplicationDataCompositeValue(); StringBuilder sb = new StringBuilder(); foreach (SodukoPiece piece in p) { sb.Append(piece.GetInfoAsString()); } state["Pieces"] = sb.ToString(); sb.Clear(); foreach (int i in originalState) { sb.Append(i.ToString()); sb.Append(";"); } state["OriginalState"] = sb.ToString(); sb.Clear(); foreach (int i in currentPositions) { sb.Append(i.ToString()); sb.Append(";"); } state["CurrentPos"] = sb.ToString(); ApplicationData.Current.LocalSettings.Values["PuzzleState"] = state; }
/// <summary> /// 根据参数获取禁毒日志记录 /// </summary> /// <param name="param"></param> /// <returns></returns> public List <HCQ2_Model.Bane_LogDetail> GetLogDataByParams(HCQ2_Model.BaneUser.BaneLogParam param) { sb?.Clear(); sb.AppendFormat(@"SELECT TOP {0} * FROM (SELECT ROW_NUMBER() OVER(ORDER BY log_id ASC) rowNUmber,* FROM Bane_LogDetail WHERE 1=1 ", param.rows); if (param.user_id > 0) { sb.AppendFormat(" AND user_id={0} ", param.user_id); } if (!string.IsNullOrEmpty(param.log_title)) { sb.AppendFormat(" AND log_title LIKE '%{0}%' ", param.log_title); } if (!string.IsNullOrEmpty(param.log_date_start) && !string.IsNullOrEmpty(param.log_date_end)) { sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23) BETWEEN '{0}' AND '{1}' ", param.log_date_start, param.log_date_end); } else if (!string.IsNullOrEmpty(param.log_date_start) && string.IsNullOrEmpty(param.log_date_end)) { sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23)>='{0}' ", param.log_date_start); } else if (string.IsNullOrEmpty(param.log_date_start) && !string.IsNullOrEmpty(param.log_date_end)) { sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23)<='{0}' ", param.log_date_end); } sb.AppendFormat(") logs WHERE logs.rowNUmber>{0};", (param.page - 1) * param.rows); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.Bane_LogDetail>(dt)); }
private static List<CipherElement> BuilderCipher(string cipherTodecode) { char? letter = null; List<CipherElement> elements = new List<CipherElement>(); StringBuilder digits = new StringBuilder(); foreach (var item in cipherTodecode) { if(char.IsLetter(item)) { if (letter !=null) { CipherElement element = new CipherElement(); element.Letter = letter; element.Digits = digits.ToString(); elements.Add(element); digits.Clear(); } letter = item; } else { digits.Append(item); } } CipherElement Lastelement = new CipherElement(); Lastelement.Letter = letter; Lastelement.Digits = digits.ToString(); elements.Add(Lastelement); digits.Clear(); return elements; }
// Enumeratori public IEnumerator GetEnumerator() { StringBuilder sout = new StringBuilder(); sout.Clear(); foreach(char c in t) { if(s.Contains(c.ToString())) { if( ((sout.ToString()).Trim()).Length > 0) { yield return sout.ToString().Trim(); sout.Clear(); } } else { sout.Append(c); } } if (((sout.ToString()).Trim()).Length > 0) { yield return sout.ToString().Trim(); sout.Clear(); } yield break; }
static void Main() { string text = "Sos, bob ili potop, ABBA slusham az!"; string[] words = text.Split(' ', ',', '.'); string element = ""; StringBuilder firstPart = new StringBuilder(); StringBuilder secondPart = new StringBuilder(); for (int i = 0; i < words.Length; i++) { element = words[i]; string firstHalf = ""; string secondHalf = ""; if (element.Length % 2 == 0 && element!= "") { for (int j = 0; j < element.Length / 2; j++) { firstPart.Append(element[j]); } for (int j = element.Length - 1; j >= element.Length / 2; j--) { secondPart.Append(element[j]); } firstHalf = firstPart.ToString(); secondHalf = secondPart.ToString(); firstPart.Clear(); secondPart.Clear(); int compare = string.Compare(firstHalf, secondHalf, StringComparison.InvariantCultureIgnoreCase); if (compare == 0) { Console.WriteLine(element); } } else if(element.Length % 2 != 0 && element!= "") { for (int j = 0; j < element.Length / 2; j++) { firstPart.Append(element[j]); } for (int j = element.Length - 1; j >= element.Length / 2 + 1; j--) { secondPart.Append(element[j]); } firstHalf = firstPart.ToString(); secondHalf = secondPart.ToString(); firstPart.Clear(); secondPart.Clear(); int compare = string.Compare(firstHalf, secondHalf, StringComparison.InvariantCultureIgnoreCase); if (compare == 0) { Console.WriteLine(element); } } } }
public void MaximumDraws() { // This function has a objetive to solve this challenge: https://www.hackerrank.com/challenges/maximum-draws // The first line contains the number of test cases. // The next T lines contains an integer N which indicates the total pairs of socks present in the drawer. StringBuilder vs_Input = new StringBuilder(); string vs_received = string.Empty; string vs_expected = string.Empty; vs_expected = "2\n3"; vs_Input.Append("2\n"); vs_Input.Append("1\n"); vs_Input.Append("2\n"); vs_received = HackerHank.Challengers.MaximumDraws(vs_Input.ToString()); Assert.AreEqual(vs_expected, vs_received); vs_Input.Clear(); // Second test vs_expected = "5"; vs_Input.Append("1\n"); vs_Input.Append("4\n"); vs_received = HackerHank.Challengers.MaximumDraws(vs_Input.ToString()); Assert.AreEqual(vs_expected, vs_received); // Third test vs_Input.Clear(); vs_expected = "4"; vs_Input.Append("1\n"); vs_Input.Append("3\n"); vs_received = HackerHank.Challengers.MaximumDraws(vs_Input.ToString()); Assert.AreEqual(vs_expected, vs_received); }
/// <summary> /// Method to save device detail /// </summary> /// <param name="deviceMl"></param> /// <returns></returns> public int SaveDevice(DeviceModel deviceMl) { // Creating instance of the string builder class to hold the tracing data StringBuilder objStringBuilderTrace = new StringBuilder(); device objDevice = new device(); // Append tracing into string builder objStringBuilderTrace.AppendLine("Start method : SaveDevice(DeviceModel deviceML) :: JetstreamLaunchpad.DAL.Device class : DBDevice.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); // Clear StringBuilder object objStringBuilderTrace.Clear(); objDevice.LogicalDeviceId = deviceMl.LogicalDeviceId; objDevice.DeviceName = deviceMl.DeviceName; objDevice.SerialNumber = deviceMl.SerialNumber; objDevice.DeviceGuid = deviceMl.DeviceGuid; objDevice.Region = deviceMl.Region; ObjTersoDataContext.devices.Add(objDevice); ObjTersoDataContext.SaveChanges(); var deviceId = deviceMl.DeviceId; // Append tracing into string builder objStringBuilderTrace.AppendLine("End method : SaveDevice(DeviceModel deviceML) :: JetstreamLaunchpad.DAL.Device class : DBDevice.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); objStringBuilderTrace.Clear(); return deviceId; }
static void Main(string[] args) { System.Array.Sort(args); for (int i = 0; i < args.Length; i++) { Console.WriteLine((i+1) + ". " + args[i]); } Console.WriteLine(); StringBuilder sb = new StringBuilder(); sb.Clear(); for (int i = 0; i < args.Length; i++) { sb.Append(args[i]); } Console.WriteLine(sb.ToString()); Console.WriteLine(); for (int i = 0; i < args.Length; i++) { sb.Clear(); sb.Append(args[i].Length); sb.Append(" "); sb.Append(args[i]); Console.WriteLine(sb); } Console.ReadLine(); }
static string[] Extraxt(string address) { string[] info = new string[3]; StringBuilder sb = new StringBuilder(); int firstSepIndex = address.IndexOf("://"); //index of the first seperator int secondSepIndex = address.IndexOf('/', firstSepIndex + 3); //index of the second separator for (int i = 0; i < firstSepIndex; i++) //protocol { sb.Append(address[i]); } info[0] = sb.ToString(); sb.Clear(); for (int i = firstSepIndex + 3; i < secondSepIndex; i++) //server { sb.Append(address[i]); } info[1] = sb.ToString(); sb.Clear(); for (int i = secondSepIndex; i < address.Length; i++) //resource { sb.Append(address[i]); } info[2] = sb.ToString(); return info; }
private static IEnumerable<string> IterateParameters(string s, string escapeChar) { bool isParameter = false; var sb = new StringBuilder(); foreach (var c in s) { if (sb.ToString().EndsWith(escapeChar)) { if (isParameter) throw new InvalidOperationException("Invalid query"); isParameter = true; sb.Clear(); } if (isParameter && sb.Length == 0 && char.IsLetter(c)) sb.Append(c); else if (isParameter && sb.Length > 0 && char.IsLetterOrDigit(c)) sb.Append(c); else if (isParameter) { yield return sb.ToString(); isParameter = false; sb.Clear(); } else { sb.Append(c); } } if (sb.Length > 0 && isParameter) yield return sb.ToString(); }
private static void SimpleTest(Enums.MediaType type) { #region 建立一个item StringBuilder st = new StringBuilder(); string[] article = File.ReadAllLines(@"1.txt"); ItemToDuplication s = new ItemToDuplication(new Item()); s.ItemID = "source"; s.MediaType = type; s.SpliteTitle = article[0]; s.PubDate = DateTime.Now; st.Clear(); for (int i = 1; i < article.Length; ++i) st.Append(article[i]); s.SpliteText = st.ToString(); #endregion //将刚才建立的item添加到myDetector中 myDetector.TestAndTryAdd(s); #region 建立一个测试item article = File.ReadAllLines(@"2.txt"); //s = new ItemToDuplication(); s.ItemID = "test"; s.MediaType = type; s.SpliteTitle = article[0]; s.PubDate = DateTime.Now; st.Clear(); for (int i = 1; i < article.Length; ++i) st.Append(article[i]); s.SpliteText = st.ToString(); #endregion //测试转载检测 string id = null; id = myDetector.TestAndTryAdd(s); if (id != null) Console.WriteLine("Copied Item: " + id); else Console.WriteLine("Not copied."); }
public ISet<Word> Read(string source) { ISet<Word> result = new HashSet<Word>(); string readstring = GetString(source); bool skiptonextspace = false; StringBuilder stringbuilder = new StringBuilder(20); foreach (char c in readstring) { if (!skiptonextspace) { if (char.IsLetter(c)) { stringbuilder.Append(c); } else if (IsSpecialCharacter(c)) { string newstring = stringbuilder.ToString(); if (newstring.Length > 0) { // Only add if the new word isn't the empty string. newstring = newstring.ToLowerInvariant(); result.Add(new Word(newstring)); stringbuilder.Clear(); } } else { // The word contains a number or a symbol not listed in 'specialchars' and the program skips to the next word. stringbuilder.Clear(); skiptonextspace = true; } } else if (c == ' ') { skiptonextspace = false; } } return result; }
/// <summary> /// Method to save user detail into database /// </summary> /// <param name="userMl"></param> /// <returns></returns> public int SaveUserDetails(UsersModel userMl) { // Creating instance of the string builder class to hold the tracing data StringBuilder objStringBuilderTrace = new StringBuilder(); user objUserDetail = new user(); // Append tracing into string builder objStringBuilderTrace.AppendLine("Start method : SaveUserDetails(UsersModel userML) :: JetstreamLaunchpad.DAL.Users class : DBUsers.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); // Clear StringBuilder object objStringBuilderTrace.Clear(); objUserDetail.FirstName = userMl.FirstName; objUserDetail.LastName = userMl.LastName; objUserDetail.EmailAddress = userMl.EmailAddress; objUserDetail.PassNumber = userMl.PassNumber; objUserDetail.PassRFID = userMl.PassRFID != null ? userMl.PassRFID.ToUpper() : userMl.PassRFID; objUserDetail.Status = userMl.Status; ObjTersoDataContext.users.Add(objUserDetail); ObjTersoDataContext.SaveChanges(); var userId = objUserDetail.UserId; // Append tracing into string builder objStringBuilderTrace.AppendLine("End method : SaveUserDetails(UsersModel userML) :: JetstreamLaunchpad.DAL.Users class : DBUsers.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); objStringBuilderTrace.Clear(); return userId; }
static void ReadWords() { int N = int.Parse(Console.ReadLine()); for (int i = 0; i < N; i++) { string inputLine = Console.ReadLine().ToLower(); var word = new StringBuilder(); for (int j = 0; j < inputLine.Length; j++) { if (inputLine[j] >= 'a' && inputLine[j] <= 'z') { word.Append(inputLine[j]); } else if (inputLine[j] >= 'A' && inputLine[j] <= 'Z') { word.Append((char)inputLine[j] - 'A' + 'a'); } else if (word.Length > 0) { AddWord(word.ToString()); word.Clear(); } } if (word.Length > 0) { AddWord(word.ToString()); word.Clear(); } } }
private static IEnumerable<string> SplitAndLower(string source) { var strings = new List<string>(); var builder = new StringBuilder(); foreach (var character in source) { if (IsSeparator(character)) { if (builder.Length > 0) { strings.Add(builder.ToString()); } builder.Clear(); continue; } else if (char.IsUpper(character) && builder.Length > 0) { strings.Add(builder.ToString()); builder.Clear(); } builder.Append(char.ToLowerInvariant(character)); } if (builder.Length > 0) { strings.Add(builder.ToString()); } return strings; }
static void Main() { StringBuilder sb = new StringBuilder(); int n = int.Parse(Console.ReadLine()); int step = int.Parse(Console.ReadLine()); for (int i = 0; i < n; i++) { sb.Append(Convert.ToString(int.Parse(Console.ReadLine()), 2).PadLeft(8, '0')); } char[] numsBytes = sb.ToString().ToCharArray(); sb.Clear(); numsBytes[0] = (numsBytes[0] == '0') ? '1' : '0'; for (int i = step; i < numsBytes.Length; i += step) { numsBytes[i] = (numsBytes[i] == '0') ? '1' : '0'; } int counter = 0; for (int i = 0; i < numsBytes.Length; i++) { sb.Append(numsBytes[i]); ++counter; if (counter == 8) { Console.WriteLine(Convert.ToInt16(sb.ToString(), 2)); sb.Clear(); counter = 0; } } Console.Read(); }
public void LoadData() { StringBuilder sBuilder = new StringBuilder(_maxBufferSize); // Assum 1024 is a big enough number to contain all chars NativeMethods.GetLicensedFeatureListDelimitedBy_Win32(_delimiter, sBuilder, _maxBufferSize); string strFeatures = sBuilder.ToString(); sBuilder.Clear(); if (string.IsNullOrEmpty(strFeatures)) { return; } string[] features = strFeatures.Split(_delimiter.ToCharArray()); foreach (string feature in features) { NativeMethods.GetFeatureDetailsDelimitedBy_Win32(feature, _delimiter, sBuilder, _maxBufferSize); string strDetails = sBuilder.ToString(); sBuilder.Clear(); if (string.IsNullOrEmpty(strDetails)) { continue; } string[] details = strDetails.Split(_delimiter.ToCharArray()); if (details.Length < 6) { continue; } Licences.Add(new Licence(details[0], GetFeatureDisplayName(details[0]), details[0], details[1], details[2], details[3], details[4], details[5])); } }
public int InsertModel(SphinxExcludeQuery model) { StringBuilder sqlStr = new StringBuilder(); try { sqlStr.AppendFormat("select count(product_id) from sphinx_exclude where product_id={0}", model.product_id); if(accessMySql.getDataTable(sqlStr.ToString()).Rows[0][0].ToString()!="0") { return -1; } sqlStr.Clear(); sqlStr.AppendFormat("select count(product_id) from product where product_id={0}",model.product_id); if (accessMySql.getDataTable(sqlStr.ToString()).Rows[0][0].ToString() == "0") { return -2; } sqlStr.Clear(); sqlStr.AppendFormat("insert sphinx_exclude(product_id,kdate,kuser) values({0},'{1}','{2}')", model.product_id, Common.CommonFunction.DateTimeToString(DateTime.Now),(System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); return accessMySql.execCommand(sqlStr.ToString()); } catch (Exception ex) { throw new Exception("SphinxExcludeDao-->InsertModel-->" + ex.Message + sqlStr.ToString(), ex); } }
static void Main() { secretCode = Console.ReadLine(); chipher = Console.ReadLine(); StringBuilder sbNumber = new StringBuilder(); char key = new char(); for (int i = 0; i < chipher.Length; i++) { if (chipher[i] >= 'A' && chipher[i] <= 'Z') { if (key > 0) { chiphers.Add(sbNumber.ToString(), key); sbNumber.Clear(); } key = chipher[i]; } else { sbNumber.Append(chipher[i]); } } if (sbNumber.Length > 0) { chiphers.Add(sbNumber.ToString(), key); sbNumber.Clear(); } Solve(0, new List<char>()); Console.WriteLine(endResult.Count); Console.WriteLine(string.Join(Environment.NewLine, endResult.OrderBy(s => s))); }
private static string[] GetWords(string text) { List<string> words = new List<string>(); StringBuilder word = new StringBuilder(); for (int i = 0; i < text.Length; i++) { char c = text[i]; if (char.IsLetter(c)) { word.Append(c); } else { if (word.Length > 1) { words.Add(word.ToString()); } word.Clear(); } } if (word.Length > 1) { words.Add(word.ToString()); word.Clear(); } return words.ToArray(); }
internal ComplexParseResult(List<ParseResult> parts) { List<ParseResult> my = new List<ParseResult>(); StringBuilder sb = new StringBuilder(); int totalLength = 0; foreach (ParseResult part in flatten(parts)) { if (part.type == ParseResultType.UNPARSED) { sb.Append(((UnparsedParseResult)part).text); } else { if (sb.Length > 0) { my.Add(ParseResult.unparsed(sb.ToString())); totalLength += sb.Length; sb.Clear(); } my.Add(part); totalLength += part.length; } } if (sb.Length > 0) { my.Add(ParseResult.unparsed(sb.ToString())); totalLength += sb.Length; sb.Clear(); } this.totalLength = totalLength; this.parts = new ReadOnlyCollection<ParseResult>(my); }
public Task<ILifecycleContext> Execute(ILifecycleContext context) { var svcDef = context.ServiceDefinition; var enumWriter = context.EnumWriter; var modelWriter = context.ModelWriter; var sb = new StringBuilder(); // Enums First var template = context.ApiEnumTemplate; foreach (var obj in svcDef.Enums.SelectMany(x => x)) { using (var sw = new StringWriter(sb.Clear())) { template(sw, obj); } enumWriter(obj.Name, sb.ToString(), obj); } // Models Second template = context.ApiModelTemplate; foreach (var obj in svcDef.Models.SelectMany(x => x)) { using (var sw = new StringWriter(sb.Clear())) { template(sw, obj); } modelWriter(obj.Name, sb.ToString(), obj); } return Task.FromResult(context); }
/// <summary> /// Method to save item /// </summary> /// <param name="itemMl"></param> /// <returns></returns> public int SaveItem(ItemModel itemMl) { // Creating instance of the string builder class to hold the tracing data StringBuilder objStringBuilderTrace = new StringBuilder(); item objItem = new item(); // Append tracing into string builder objStringBuilderTrace.AppendLine("Start method : SaveItem(ItemModel itemML) :: JetstreamLaunchpad.DAL.Item class : DBItem.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); // Clear StringBuilder object objStringBuilderTrace.Clear(); objItem.Material = itemMl.Material; objItem.Batch = itemMl.Batch; objItem.ExpirationDate = itemMl.ExpirationDate; objItem.EPC = itemMl.EPC; ObjTersoDataContext.items.Add(objItem); ObjTersoDataContext.SaveChanges(); var itemId = itemMl.ItemId; // Append tracing into string builder objStringBuilderTrace.AppendLine("End method : SaveItem(ItemModel itemML) :: JetstreamLaunchpad.DAL.Item class : DBItem.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); objStringBuilderTrace.Clear(); return itemId; }
/// <summary> /// 根据条件 获取项目台账数据集合 /// </summary> /// <param name="param"></param> /// <returns></returns> public List <ItemPreserveModel> GetInitData(ItemPreserveParam param) { sb?.Clear(); sb.Append(string.Format(@"SELECT TOP {0} tt.*,code.ip_status_text,record.tail_after FROM (SELECT ROW_NUMBER() OVER(ORDER BY ip_id) AS RowNumber, ip_id, unit_name, unit_code, ip_status, area_code, pact_money, pay_money, CONVERT(varchar(100), pay_date, 23) AS pay_date, pay_cash_money, pra_cash_money, duty_person, touch_phone, CONVERT(varchar(100), pact_start, 23) AS pact_start, record_name, CONVERT(varchar(100), update_date, 23) AS update_date, user_note FROM BB_ItemPreserve WHERE 1=1 ", param.rows)); _param?.Clear(); if (!string.IsNullOrEmpty(param.unit_code)) { sb.Append(" AND unit_code = @unit_code "); _param.Add("@unit_code", param.unit_code); } else if (!string.IsNullOrEmpty(param.area_code)) { sb.Append(" AND area_code = @area_code "); _param.Add("@area_code", param.area_code); } else { sb.Append(" AND 1=0 "); } if (!string.IsNullOrEmpty(param.status)) { sb.Append(" AND ip_status = @status "); _param.Add("@status", param.status); } sb.Append(string.Format(@" ) tt LEFT JOIN (SELECT DATEDIFF(dd,tt.track_date,GETDATE()) AS tail_after,tt.unit_code FROM (SELECT ROW_NUMBER() OVER(PARTITION BY unit_code ORDER BY track_date ASC) AS RowNumber,unit_code,track_date FROM BB_TrackRecord WHERE tr_status='02') AS tt WHERE tt.RowNumber=1) record ON tt.unit_code=record.unit_code LEFT JOIN (SELECT item1.*,item2.* FROM (SELECT item_id, item_code FROM dbo.T_ItemCode WHERE item_code = 'ItemStatus') item1 INNER JOIN (SELECT code_name AS ip_status_text, code_value AS ip_status, item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code ON tt.ip_status = code.ip_status WHERE tt.RowNumber > {0} ORDER BY tt.RowNumber;", (param.page - 1) * param.rows)); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <ItemPreserveModel>(dt)); }
/// <summary> /// Method to get item by itemid /// </summary> /// <param name="itemId"></param> /// <returns></returns> public ItemModel GetItemByItemId(int itemId) { // Creating instance of the string builder class to hold the tracing data StringBuilder objStringBuilderTrace = new StringBuilder(); ItemModel itemMl = new ItemModel(); // Append tracing into string builder objStringBuilderTrace.AppendLine("Start method : GetItemByItemId(int itemId) :: JetstreamLaunchpad.DAL.Item Class : DBItem.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); // Clear StringBuilder object objStringBuilderTrace.Clear(); var item = ObjTersoDataContext.items.FirstOrDefault(x => x.ItemId == itemId); if (item != null) { itemMl.ItemId = item.ItemId; itemMl.Material = item.Material; itemMl.Batch = item.Batch; itemMl.ExpirationDate = item.ExpirationDate; itemMl.ExpirationDateString = item.ExpirationDate != null ? String.Format("{0:MM/dd/yyyy}", item.ExpirationDate.Value) : string.Empty; itemMl.EPC = item.EPC; } // Append tracing into string builder objStringBuilderTrace.AppendLine("End method : GetItemByItemId(int itemId) :: JetstreamLaunchpad.DAL.Item Class : DBItem.cs"); // Writing trace log into the log file SaveLogger.SaveLoggerTrace(objStringBuilderTrace.ToString()); objStringBuilderTrace.Clear(); return itemMl; }
public static string[] Split(string words, StringSplitOptions splitOptions, bool splitOnCaseDifference) { if (string.IsNullOrEmpty(words)) { return new string[] { words }; } string[] initial = words.Split(_separators, splitOptions); List<string> final = new List<string>(); int finalIndex = 0; for (int i = 0; i < initial.Length; i++) { StringBuilder sb = new StringBuilder(); string w = initial[i]; bool isUpper = char.IsUpper(w[0]); sb.Append(w[0]); for (int c = 1; c < w.Length; c++) { if (splitOnCaseDifference && char.IsUpper(w[c])) { final.Insert(finalIndex++, sb.ToString()); sb.Clear(); } sb.Append(w[c]); } if (sb.Length > 0) { final.Insert(finalIndex++, sb.ToString()); sb.Clear(); } } return final.ToArray(); }
public void downloadLZHFiles(List<string> lstDates, JRDBMember jrdbMem, string appPath) { try{ StringBuilder sb = new StringBuilder(); string strDownLoadFolder = sb.Append(appPath).Append("\\temp").ToString(); if(Directory.Exists(strDownLoadFolder) == false) Directory.CreateDirectory(strDownLoadFolder); sb.Clear(); WebClient wc = new WebClient(); wc.Credentials = new NetworkCredential(jrdbMem.UserID, jrdbMem.PassWord); for (int i = 0; i < lstDates.Count; i++) { sb.Append(strKYLzhUrl).Append(strKYFilePrefix).Append(lstDates[i]).Append(".lzh"); string strDLKYFileURL = sb.ToString(); sb.Clear(); sb.Append(appPath).Append("\\temp\\").Append(strKYFilePrefix).Append(lstDates[i]).Append(".lzh"); string strDLKYFile = sb.ToString(); sb.Clear(); sb.Append(strCYLzhUrl).Append(strCYFilePrefix).Append(lstDates[i]).Append(".lzh"); string strDLCYFileURL = sb.ToString(); sb.Clear(); sb.Append(appPath).Append("\\temp\\").Append(strCYFilePrefix).Append(lstDates[i]).Append(".lzh"); string strDLCYFile = sb.ToString(); sb.Clear(); wc.DownloadFile(strDLKYFileURL, strDLKYFile); wc.DownloadFile(strDLCYFileURL, strDLCYFile); } wc.Dispose(); } catch (Exception e) { string s = e.Message; } }
/// <summary> /// 随机获取题目 /// </summary> /// <param name="howLen">随机几条</param> /// <returns></returns> public List <BaneTopicModel> GetAnswerQuestion(int howLen) { sb?.Clear(); sb.AppendFormat(@"SELECT * FROM (SELECT TOP {0} sub_id,sub_title AS issue_title,sub_value,sub_essay FROM dbo.Bane_QuestionInfo ORDER BY NEWID()) answer ORDER BY answer.sub_id;", howLen); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <BaneTopicModel>(dt)); }
/// <summary> /// 获取分享人员数据 /// </summary> /// <returns></returns> public List <HCQ2_Model.SelectModel.ListBoxModel> GetShareDataByPerson() { sb?.Clear(); sb.Append(@"SELECT text=u.user_name,CAST(u.user_id AS NVARCHAR(100)) AS value FROM (SELECT user_name,user_id FROM dbo.T_User WHERE reg_from=0) u LEFT JOIN (SELECT UnitID,user_id FROM dbo.T_Org_User) o ON u.user_id=o.user_id;"); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString()); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.SelectModel.ListBoxModel>(dt)); }
/// <summary> /// 获取分享人员数据 /// </summary> /// <returns></returns> public List <HCQ2_Model.SelectModel.ListBoxModel> GetShareDataByPerson() { sb?.Clear(); sb.Append(@"SELECT text=(CASE WHEN ISNULL(b.UnitName,'')<>'' THEN u.user_name+'('+ISNULL(b.UnitName,'')+')' ELSE u.USER_NAME END),CAST(u.user_id AS NVARCHAR(100)) AS value FROM (SELECT user_name,user_id FROM dbo.T_User WHERE reg_from=0) u LEFT JOIN (SELECT UnitID,user_id FROM dbo.T_Org_User) o ON u.user_id=o.user_id LEFT JOIN (SELECT UnitID,UnitName FROM dbo.B01) b ON o.UnitID=b.UnitID ORDER BY b.UnitName"); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString()); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.SelectModel.ListBoxModel>(dt)); }
/// <summary> /// 获取项目月增长 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <HCQ2_Model.APPModel.ResultApiModel.ChartProject> GetProjectMonthGrow(HCQ2_Model.APPModel.ParamModel.DebtAllGrantModel model) { sb?.Clear(); sb.Append(string.Format(@"SELECT CAST(SUBSTRING(T.createDate,6,2) AS INT) AS month,COUNT(T.UnitID) AS projectCount FROM (SELECT CONVERT(varchar(7),B0183,120) AS createDate,UnitID FROM dbo.B01 WHERE ISNULL(B0183,'')<>'' AND CONVERT(varchar(7),B0183,120) BETWEEN @startDate AND @endDate )T GROUP BY T.createDate;")); _param?.Clear(); _param.Add("@startDate", model.startDate); _param.Add("@endDate", model.endDate); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.APPModel.ResultApiModel.ChartProject>(dt)); }
/// <summary> /// 获取权限集合 /// </summary> /// <param name="perName"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <param name="perType">权限类别</param> /// <param name="sm_code">模块代码</param> /// <returns></returns> public List <T_Permissions> GetLimitData(string perName, int page, int rows, string perType, string sm_code) { sb?.Clear(); _param.Clear(); sb.Append(string.Format(@"SELECT TOP {0} per.*,fig.pc_openUrl,fig.pc_saveUrl,fig.pc_width,fig.pc_height FROM (SELECT *,ROW_NUMBER() OVER(ORDER BY per_id) AS 'rowNumber' FROM dbo.T_Permissions WHERE 1=1 ", rows)); if (!string.IsNullOrEmpty(sm_code)) { sb.Append(string.Format(" AND sm_code=@sm_code ")); _param.Add("@sm_code", sm_code); } if (!string.IsNullOrEmpty(perName)) { sb.Append(string.Format(" AND per_name LIKE '%@per_name%' ")); _param.Add("@per_name", perName); } if (!string.IsNullOrEmpty(perType)) { sb.Append(string.Format(" AND per_type=@per_type ")); _param.Add("@per_type", perType); } sb.Append(string.Format(@" ) per INNER JOIN (SELECT per_type,pc_openUrl,pc_saveUrl,pc_width,pc_height FROM dbo.T_PermissConfig) fig ON per.per_type = fig.per_type WHERE per.rowNumber>{0};", (page - 1) * rows)); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_Permissions>(dt)); }
/// <summary> /// 实现根据组织机构获取用户 /// </summary> /// <param name="unitid"></param> /// <param name="keyword"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <returns></returns> public List <T_User> GetUserByUnitID(int folder_id, string keyword, int page, int rows) { if (folder_id <= 0) { return(null); } sb?.Clear(); sb.AppendFormat(@"SELECT TOP {0} users.* FROM (SELECT * FROM dbo.T_User WHERE 1=1 ", rows); if (!string.IsNullOrEmpty(keyword)) { sb.AppendFormat(" AND user_name LIKE '%{0}%' ", keyword); } sb.AppendFormat(@") users INNER JOIN (SELECT ROW_NUMBER() OVER(ORDER BY user_id ASC) AS rowNumber,user_id FROM dbo.T_Org_User WHERE UnitID IN(SELECT folder_id FROM dbo.T_OrgFolder WHERE folder_path LIKE (SELECT folder_path FROM T_OrgFolder WHERE folder_id={0})+'%')) org ON org.user_id = users.user_id WHERE org.rowNumber>{1};", folder_id, (page - 1) * rows); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_User>(dt)); //只查询自己本身所在区域用户 //if (string.IsNullOrEmpty(keyword)) // return (from user in db.Set<T_User>() // join org in db.Set<T_Org_User>() // on user.user_id equals org.user_id // where org.UnitID.Equals(folder_id.ToString()) // select user).OrderBy(u => u.user_id).ToList().Skip(rows*(page - 1)).Take(rows).ToList(); //return (from user in db.Set<T_User>() // join org in db.Set<T_Org_User>() // on user.user_id equals org.user_id // where org.UnitID.Equals(folder_id.ToString()) && user.user_name.Contains(keyword) // select user).OrderBy(u => u.user_id).ToList().Skip(rows*(page - 1)).Take(rows).ToList(); }
private void OnCanvasDraw(CanvasControl sender, CanvasDrawEventArgs args) { if (String.IsNullOrWhiteSpace(_data)) { CommandsList.Text = string.Empty; return; } if (_errorGeometry == null) { _errorGeometry = CanvasObject.CreateGeometry(sender, ErrorString); } _logger?.Clear(); CommandsList.Text = string.Empty; try { var geometry = CanvasObject.CreateGeometry(sender, _data, _logger); CommandsList.Text = _logger.ToString(); args.DrawingSession.FillGeometry(geometry, _fillColor); args.DrawingSession.DrawGeometry(geometry, _strokeColor, _strokeThickness); } catch (Exception e) { args.DrawingSession.FillGeometry(_errorGeometry, Colors.Red); CommandsList.Text = "Parsing error! Invalid input data!"; } }
public void DidDetect(NFCNdefReaderSession session, NFCNdefMessage[] messages) { _data?.Clear(); foreach (NFCNdefMessage message in messages) { foreach (NFCNdefPayload record in message.Records) { var typeNameFormat = record.TypeNameFormat; //var identifier = record.Identifier?.ToArray(); var type = record.Type; var payload = record.Payload; if (payload.Length > 0) { ReadData(payload.ToArray()); } else { ReadData(type.ToArray()); } } } if (_data.ToString().Length > 0) { MessagingCenter.Send <string>(_data.ToString(), "data"); } }
/// <summary> /// 获取指定企业的所属队伍 /// </summary> /// <param name="unitID"></param> /// <returns></returns> public List <ComProModel> GetComProData(string unitID) { if (string.IsNullOrEmpty(unitID)) { return(null); } sb?.Clear(); sb.Append(string.Format(@"SELECT info.* FROM (SELECT DISTINCT in_team FROM dbo.A01 WHERE UnitID = @UnitID AND ISNULL(in_team, '') <> '') team INNER JOIN (SELECT com_id AS com_value, dwmc AS com_text FROM dbo.T_CompProInfo) info ON team.in_team = info.com_value")); _param?.Clear(); _param.Add("@UnitID", unitID); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <ComProModel>(dt)); }
/// <summary> /// 已检人数 /// </summary> /// <returns></returns> public int GetDetectionCount(int user_id) { sb?.Clear(); if (user_id > 0) { sb.AppendFormat(@"SELECT COUNT(*) FROM (SELECT user_identify FROM Bane_UrinalysisRecord WHERE LEFT(CONVERT(varchar(100),GETDATE(),23),7)=LEFT(CONVERT(varchar(100),ur_reality_date,23),7)) record INNER JOIN (SELECT user_id,user_identify FROM dbo.Bane_User) users ON users.user_identify = record.user_identify INNER JOIN (SELECT person_id FROM dbo.T_UserUnitPersonRelation WHERE user_id={0}) relation ON users.user_id=relation.person_id;", user_id); } else { sb.Append(@"SELECT COUNT(*) FROM Bane_UrinalysisRecord WHERE LEFT(CONVERT(varchar(100),GETDATE(),23),7)=LEFT(CONVERT(varchar(100),ur_reality_date,23),7);"); } return(HCQ2_Common.Helper.ToInt(HCQ2_Common.SQL.SqlHelper.ExecuteScalar(sb.ToString()))); }
/// <summary> /// 获取跟踪记录集合 /// </summary> /// <param name="param"></param> /// <returns></returns> public List <TrackRecordModel> GetInitData(TrackRecordParam param) { sb?.Clear(); sb.Append(string.Format(@"SELECT TOP {0} tt.*,code.tr_status_text FROM (SELECT ROW_NUMBER() OVER(ORDER BY tr_id) AS RowNumber,tr_id,area_code,unit_name,unit_code,fa_number,tr_status, CONVERT(varchar(100),track_date,23) AS track_date,track_name,tr_note FROM BB_TrackRecord WHERE 1=1 ", param.rows)); _param?.Clear(); //项目/区域 if (!string.IsNullOrEmpty(param.unit_code)) { sb.Append(" AND unit_code = @unit_code "); _param.Add("@unit_code", param.unit_code); } else if (!string.IsNullOrEmpty(param.area_code)) { sb.Append(" AND area_code = @area_code "); _param.Add("@area_code", param.area_code); } else { sb.Append(" AND 1=0 "); } //设备编码 if (!string.IsNullOrEmpty(param.fa_number)) { sb.Append(" AND fa_number = @fa_number "); _param.Add("@fa_number", param.fa_number); } //状态 if (!string.IsNullOrEmpty(param.trackStatus)) { sb.Append(" AND tr_status = @tr_status "); _param.Add("@tr_status", param.trackStatus); } //跟踪时间 if (!string.IsNullOrEmpty(param.trackDate)) { sb.Append(string.Format(" AND CONVERT(varchar(100),track_date,23)=@track_date ")); _param.Add("@track_date", param.trackDate); } sb.Append(string.Format(@" ) tt LEFT JOIN(SELECT item1.*,item2.* FROM (SELECT item_id, item_code FROM dbo.T_ItemCode WHERE item_code = 'TrackStatus') item1 INNER JOIN (SELECT code_name AS tr_status_text, code_value AS tr_status, item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code ON tt.tr_status = code.tr_status WHERE tt.RowNumber > {0} ORDER BY tt.RowNumber;", (param.page - 1) * param.rows)); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <TrackRecordModel>(dt)); }
/// <summary> /// 获取用户获取积分详情 /// </summary> /// <param name="user_identify">身份证</param> /// <returns></returns> public List <AnswerIntegralDetial> GetIntegralScoreById(string user_identify) { sb?.Clear(); sb.AppendFormat(@"SELECT his_title AS hs_title,CONVERT(varchar(100),his_time,20) AS answer_date,his_total AS hs_total FROM dbo.Bane_IntegralScoreDetial WHERE user_identify='{0}' ORDER BY answer_date ASC;", user_identify); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <AnswerIntegralDetial>(dt)); }
/// <summary> /// 根据指定试题ID 获取答题选项 /// </summary> /// <param name="sub_ids"></param> /// <returns></returns> public List <Bane_QuestionValue> GetOptionsById(List <int> sub_ids) { sb?.Clear(); sb.AppendFormat(@"SELECT * FROM dbo.Bane_QuestionValue WHERE sub_id IN({0});", string.Join(",", sub_ids)); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <Bane_QuestionValue>(dt)); }
private void Keylogger_FormClosed(object sender, FormClosedEventArgs e) { SB?.Clear(); MsgPack msgpack = new MsgPack(); msgpack.ForcePathObject("Packet").AsString = "keyLogger"; msgpack.ForcePathObject("isON").AsString = "false"; ThreadPool.QueueUserWorkItem(C.Send, msgpack.Encode2Bytes()); }
/// <summary> /// 已检人数 /// </summary> /// <returns></returns> public int GetDetectionCount(int user_id) { sb?.Clear(); if (user_id > 0) { sb.AppendFormat(@"SELECT COUNT(*) FROM (SELECT user_identify,ROW_NUMBER() OVER(PARTITION BY user_identify ORDER BY ur_id DESC) AS rowNumber FROM Bane_UrinalysisRecord WHERE approve_status=1 AND LEFT(CONVERT(varchar(100),GETDATE(),23),7)=LEFT(CONVERT(varchar(100),ur_reality_date,23),7)) record INNER JOIN (SELECT user_id,user_identify FROM dbo.Bane_User) users ON users.user_identify = record.user_identify INNER JOIN (SELECT person_id FROM dbo.T_UserUnitPersonRelation WHERE user_id={0}) relation ON users.user_id=relation.person_id WHERE record.rowNumber=1;", user_id); } else { sb.Append(@"SELECT COUNT(*) FROM (SELECT ROW_NUMBER() OVER(PARTITION BY user_identify ORDER BY ur_id DESC) AS rowNumber,* FROM Bane_UrinalysisRecord WHERE approve_status=1 AND LEFT(CONVERT(varchar(100),GETDATE(),23),7)=LEFT(CONVERT(varchar(100),ur_reality_date,23),7)) record WHERE record.rowNumber=1;"); } return(HCQ2_Common.Helper.ToInt(HCQ2_Common.SQL.SqlHelper.ExecuteScalar(sb.ToString()))); }
private void Init(int fieldSize) { int side = fieldSize + 2; _sb?.Clear(); _sb ??= new StringBuilder(side * (side + 1)); for (int i = 0; i < side; ++i) { _sb.Append(' ', side); _sb.Append('\n'); } }
private void SendData(Intent intent) { try { if (intent != null) { switch (intent.Action) { case NfcAdapter.ActionNdefDiscovered: case NfcAdapter.ActionTagDiscovered: _data?.Clear(); MessagingCenter.Send <string>(true.ToString(), "reading"); try { IParcelable[] rawMessages = intent.GetParcelableArrayExtra(NfcAdapter.ExtraNdefMessages); if (rawMessages != null) { NdefMessage[] messages = new NdefMessage[rawMessages.Length]; for (int i = 0; i < rawMessages.Length; i++) { messages[i] = (NdefMessage)rawMessages[i]; } // Process the messages array.. foreach (var m in messages) { NdefRecord[] records = m.GetRecords(); foreach (var r in records) { ReadData(r.GetPayload()); } } if (_data.ToString().Length > 0) { MessagingCenter.Send <string>(_data.ToString(), "data"); } } } catch { } finally { MessagingCenter.Send <string>(false.ToString(), "reading"); } break; case NfcAdapter.ActionTechDiscovered: break; } } } catch { } }
/// <summary> /// 获取一栏数据 /// </summary> /// <param name="param"></param> /// <returns></returns> public List <T_UseWorkerModel> GetUseWorkListData(T_UseWorkerParam param) { sb?.Clear(); sb.Append(string.Format(@"SELECT TOP {0} use_id,com_id,use_title,addr,postNote,code.CodeItemName as 'work_type_value',work_type,trade_type,work_city,use_wage_start, use_wage_end,use_sex,use_age,use_edu,use_ageLimit,code1.ageLimit,use_major, work_start,CONVERT(varchar(100),issue_start,23) AS 'issue_start',use_status,use_note FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY use_id) AS RowNumber FROM dbo.T_UseWorker WHERE com_id={1} AND use_status=1 ", param.rows, param.com_id)); if (!string.IsNullOrEmpty(param.jobName)) { sb.Append(string.Format(@" AND trade_type LIKE '%@jobName%' ")); } if (param.jobStartMoney > 0 && param.jobEndMoney > 0) { sb.Append(string.Format(" AND use_wage_start>={0} AND use_wage_end<={1} ", param.jobStartMoney, param.jobEndMoney)); } else if (param.jobStartMoney > 0 && param.jobEndMoney <= 0) { sb.Append(string.Format(" AND use_wage_start>={0} ", param.jobStartMoney)); } else if (param.jobStartMoney <= 0 && param.jobEndMoney > 0) { sb.Append(string.Format(" AND use_wage_end<={0} ", param.jobEndMoney)); } sb.Append(string.Format(@") job INNER JOIN (SELECT item1.*,item2.* FROM (SELECT item_id,item_code FROM dbo.T_ItemCode WHERE item_code='JobPost') item1 INNER JOIN (SELECT code_name AS CodeItemName,code_value AS CodeItemValue,item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code ON job.work_type=code.CodeItemValue INNER JOIN (SELECT item1.*,item2.* FROM (SELECT item_id,item_code FROM dbo.T_ItemCode WHERE item_code='WorkExperience') item1 INNER JOIN (SELECT code_name AS ageLimit,code_value AS CodeItemValue,item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code1 ON job.use_ageLimit=code1.CodeItemValue WHERE job.RowNumber>{0} ", (param.page - 1) * param.rows)); if (!string.IsNullOrEmpty(param.jobName)) { sb.Append(string.Format(@" AND code.CodeItemName LIKE '%@jobName%';")); _param.Add("@jobName", param.jobName); } DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_UseWorkerModel>(dt)); }
internal unsafe int GetNameByOffset( IntPtr self, ulong offset, StringBuilder nameBuffer, uint nameBufferSize, uint *nameSize, ulong *displacement) { nameBuffer?.Clear(); Write(nameSize); Write(displacement); return(E_NOTIMPL); }
public List <WorkTypeCount> GetWorkType(OrgModel model) { sb?.Clear(); sb.Append(string.Format(@"SELECT ISNULL(code1.E0386,'其他') AS E0386,A.numCount FROM (SELECT ISNULL(E0386,'00') AS E0386,COUNT(ISNULL(E0386,'00')) AS numCount FROM dbo.A01 WHERE UnitID=@UnitID GROUP BY E0386) A LEFT JOIN (SELECT CodeItemID,CodeItemName AS E0386 FROM dbo.SM_CodeItems WHERE CodeID='JA') code1 ON A.E0386=code1.CodeItemID ")); _param?.Clear(); _param.Add("@UnitID", model.orgid); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <WorkTypeCount>(dt)); }
/// <summary> /// 获取已出工情况 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <string> GetWorkPersonList(WorkCount model) { sb?.Clear(); sb.Append(string.Format(@"SELECT A.A0101 FROM (SELECT A0177,A0101,UnitID FROM dbo.A01 WHERE UnitID=@UnitID AND ISNULL(retire_time,'')='') A INNER JOIN (SELECT DISTINCT A0177,UnitID FROM dbo.View_A02 WHERE UnitID=@UnitID AND CONVERT(varchar(100), A0201, 23)=@dateStart) B ON A.A0177 = B.A0177 WHERE A.UnitID=B.UnitID;")); _param?.Clear(); _param.Add("@UnitID", model.orgid); _param.Add("@dateStart", model.work_date); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); List <WorkParamModel> list = HCQ2_Common.Data.DataTableHelper.DataTableToIList <WorkParamModel>(dt); if (null == list) { return(null); } return(list.Select(s => s.A0101).ToList()); }
/// <summary> /// 获取戒毒人员一栏数据 /// </summary> /// <param name="param"></param> /// <returns></returns> public List <BaneListModel> GetBaneData(BaneListParams param) { sb?.Clear(); sb.Append(string.Format(@"SELECT TOP {0} * FROM (SELECT ROW_NUMBER() OVER(ORDER BY user_id ASC) rowNumber,user_name,user_sex,user_identify,user_type,user_phone,DATEDIFF(yy,CONVERT(varchar,user_birth,101),GETDATE())AS user_age,LEFT(user_name,1)+REPLICATE('*',LEN(user_name)-1) AS hiden_name, (CASE WHEN LEN(user_identify)=18 THEN LEFT(user_identify,6)+REPLICATE('*',8)+RIGHT(user_identify,4) WHEN LEN(user_identify)=15 THEN LEFT(user_identify,6)+REPLICATE('*',6)+RIGHT(user_identify,3) ELSE REPLICATE('*',LEN(user_identify)) END) AS hiden_identify FROM Bane_User WHERE 1=1 ", param.rows)); if (!string.IsNullOrEmpty(param.baneName)) { sb.Append(string.Format(" AND user_name LIKE '%{0}%' ", param.baneName)); } if (!string.IsNullOrEmpty(param.baneType)) { sb.Append(string.Format(" AND user_type='{0}' ", param.baneType)); } //判断是否为父节点 if (param.isParent) { sb.Append(string.Format(" AND org_id IN(SELECT folder_id FROM dbo.T_OrgFolder WHERE folder_path<>'{0}' AND folder_path LIKE '{0}%') AND user_id IN(SELECT person_id FROM dbo.T_UserUnitPersonRelation WHERE user_id={1})", param.folder_path, param.user_id)); } else { sb.Append(string.Format(" AND org_id={0} AND user_id IN(SELECT person_id FROM dbo.T_UserUnitPersonRelation WHERE user_id={1})", param.orgId, param.user_id)); } sb.Append(string.Format(@") users LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY user_identify ORDER BY start_date DESC) rank,CONVERT(varchar(100),start_date,23) AS start_date, CONVERT(varchar(100),end_date,23) AS end_date,end_reason,user_identify AS a0177 FROM Bane_RecoveryInfo WHERE 1=1 ")); if (!string.IsNullOrEmpty(param.baneEnd)) { sb.Append(string.Format(" AND end_reason='{0}' ", param.baneEnd)); } sb.Append(string.Format(@") info ON users.user_identify=info.a0177 WHERE info.rank=1 AND users.rowNumber>{0};", (param.page - 1) * param.rows)); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <BaneListModel>(dt)); }
private void Keylogger_FormClosed(object sender, FormClosedEventArgs e) { Sb?.Clear(); if (Client != null) { new Thread(() => { MsgPack msgpack = new MsgPack(); msgpack.ForcePathObject("Packet").AsString = "keyLogger"; msgpack.ForcePathObject("isON").AsString = "false"; ThreadPool.QueueUserWorkItem(Client.Send, msgpack.Encode2Bytes()); }).Start(); } }
protected void СonnectToDatabase() { index = -1; _sqlBuilder?.Clear(); if (m_dbConnection != null) { return; } m_dbConnection = new SQLiteConnection("Data Source=" + Directory.GetCurrentDirectory() + _dbPath + ";Version=3;"); m_dbConnection.Open(); }
/// <summary> /// 获取企业征信 /// </summary> /// <param name="com"></param> /// <returns></returns> public List <HCQ2_Model.APPModel.ResultApiModel.CreditModelResult> GetCompayProobjectList(CompanyModel com) { sb?.Clear(); sb.Append(string.Format(@"SELECT TOP {0} * FROM( SELECT cinfos.com_id,cinfos.UnitName,code1.UnitType,cinfos.TrustCode,cinfos.LegalPerson,del.ed_id,del.ent_name,code2.ent_type,del.update_time,ISNULL(del.update_name,'') AS update_name,del.solve_type,ROW_NUMBER() OVER(ORDER BY del.ent_type DESC) AS orderType FROM (SELECT com_id,dwmc AS UnitName,QXLB,tyshxydm AS TrustCode,Fddbrxm AS LegalPerson FROM dbo.T_CompProInfo ", com.size)); if (!string.IsNullOrEmpty(com.keyword)) { sb.Append(string.Format(" WHERE dwmc LIKE '%{0}%' ", com.keyword)); } sb.Append(string.Format(@" ) cinfos INNER JOIN (SELECT * FROM (SELECT ed_id,ent_id,ent_name='双龙航空港经济区政法与群众工作局',ent_type,CONVERT(varchar(100),update_time,23) AS update_time, update_name,solve_type=(CASE WHEN solve_type=0 THEN '未处理' ELSE '已处理' END),ROW_NUMBER() OVER(partition BY ent_id ORDER BY solve_type,ent_type DESC) AS order_index FROM T_EnterDetail WHERE is_success=0) oder WHERE oder.order_index=1) del ON cinfos.com_id=del.ent_id LEFT JOIN (SELECT item2.UnitType,item2.code_value FROM (SELECT item_id,item_code FROM dbo.T_ItemCode WHERE item_code='QYLSZBFB') item1 INNER JOIN (SELECT code_name AS UnitType,code_value,item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code1 ON cinfos.QXLB=code1.code_value LEFT JOIN (SELECT item2.ent_type,item2.code_value FROM (SELECT item_id,item_code FROM dbo.T_ItemCode WHERE item_code='ZXZT') item1 INNER JOIN (SELECT code_name AS ent_type,code_value,item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code2 ON del.ent_type=code2.code_value) delInfo WHERE delInfo.orderType>{0};", (com.page - 1) * com.size)); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString()); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.APPModel.ResultApiModel.CreditModelResult>(dt)); }
/// <summary> /// 获取导出数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public DataTable GetExportPersonData(string UnitID, string e0386, string in_type) { sb?.Clear(); sb.Append(string.Format(@"SELECT A0101,A0177,ISNULL(A0178,0) AS A0178,ISNULL(A0178,0) AS W0178,PersonID FROM dbo.A01 WHERE UnitID=@UnitID ")); if (!string.IsNullOrEmpty(e0386) && !e0386.Equals("00")) { sb.Append(string.Format(" AND E0386={0} ", e0386)); } if (!string.IsNullOrEmpty(in_type) && !in_type.Equals("00")) { sb.Append(string.Format(" AND in_team={0} ", in_type)); } _param?.Clear(); _param.Add("@UnitID", UnitID); return(SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param))); }
/// <summary> /// This event is fired when an error occurs. /// TODO: Hook up something so any external actors know we've errored. /// </summary> /// <param name="error">The string representation of the error reason.</param> /// <param name="hresult">The int representation of the hresult.</param> private void DictationRecognizer_DictationError(string error, int hresult) { dictationResult = error + "\nHRESULT: " + hresult.ToString(); textSoFar?.Clear(); dictationResult = string.Empty; if (debugOutput != null) { debugOutput.color = Color.red; debugOutput.text = error; } Debug.LogError(error); StartCoroutine(StopListeningInternal()); }
/// <summary> /// 根据code获取字典 /// </summary> /// <param name="code"></param> /// <returns></returns> public List <CodeItemsModel> GetOldSysCode(string code) { if (string.IsNullOrEmpty(code)) { return(null); } sb?.Clear(); sb.Append(string.Format(@"SELECT item.CodeItemID AS CodeValue,item.CodeItemName AS CodeText FROM (SELECT DISTINCT E0386 FROM dbo.A01 WHERE UnitID=@code AND ISNULL(E0386,'')<>'') a01 LEFT JOIN (SELECT CodeItemID,CodeItemName FROM dbo.SM_CodeItems WHERE CodeID='JA') item ON a01.E0386=item.CodeItemID;")); _param?.Clear(); _param.Add("@code", code); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <CodeItemsModel>(dt)); }