PS> Get-Content "C:\Users\rdsadmin\Documents\visual studio 2015\Projects\LazyLogConsoleAuto\LazyLogCon
soleAuto\bin\Debug\log\2018-11-11.log" -Wait -Tail 10
'보미아빠, 석이'에 해당되는 글 454건
- 2018.11.11 tail
- 2018.11.02 task
- 2018.09.12 delete
- 2018.09.11 helppage
- 2018.08.30 ncp c# apicall sample
- 2018.07.10 telegram bot
- 2018.07.10 Task await
- 2018.06.29 c# event
- 2018.05.29 function base n
- 2018.05.17 bmw ista+
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace winform
{
public partial class Form1 : Form
{
DataTable table;
public Form1()
{
InitializeComponent();
}
private async void button1_Click(object sender, EventArgs e)
{
await Task.Run(() => {
FillData();
dataGridView1.InvokeIfRequired(s => {
s.ColumnCount = 3;
s.Columns[0].Name = "Column1";
s.Columns[1].Name = "Column2";
s.Columns[2].Name = "Column3";
s.Columns[0].Width = 100;
s.Columns[1].Width = 100;
s.Columns[2].Width = 300;
s.RowHeadersVisible = false;
});
foreach (DataRow row in table.Rows)
{
dataGridView1.InvokeIfRequired(s => {
int n = s.Rows.Add();
s.Rows[n].Cells[0].Value = row["Column1"].ToString();
s.Rows[n].Cells[1].Value = row["Column2"].ToString();
s.Rows[n].Cells[2].Value = row["Column3"].ToString();
});
}
});
}
private void FillData()
{
table = new DataTable();
table.Columns.Add("Column1", typeof(string));
table.Columns.Add("Column2", typeof(string));
table.Columns.Add("Column3", typeof(string));
for (int i = 0; i < 1000000; i++)
{
table.Rows.Add(i.ToString(), "Indocin", "David");
}
}
}
public static class ControlHelpers
{
public static void InvokeIfRequired<T>(this T control, Action<T> action) where T : ISynchronizeInvoke
{
if (control.InvokeRequired)
{
control.Invoke(new Action(() => action(control)), null);
}
else
{
action(control);
}
}
}
}
set nocount on
declare @rowcount varchar(100) ;
while (1=1)
begin
delete top (1000) t from perfmon t where machinename is null
select @rowcount = @@rowcount
if @rowcount = 0 break;
RAISERROR(@rowcount, 0, 1) WITH NOWAIT
waitfor delay '00:00:00.200'
end
Install-Package Microsoft.AspNet.WebApi.HelpPage
Adding Help Documentation to a Web API REST Service
http://localhost:54212/Help
REST POST Build a REST Service in Visual Studio 2015 Part 1
ncp c# apicall sample
분류없음 / 2018.08.30 14:19
using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using System.Text;
using System.Net.Http;
using System.Threading;
using System.Diagnostics;
using System.Security.Cryptography;
namespace APITest
{
public class Config
{
private static readonly Lazy<Config> lazy =
new Lazy<Config>(() => new Config(), LazyThreadSafetyMode.ExecutionAndPublication);
public static Config Instance { get { return lazy.Value; } }
public string apiKey
{
get { return "apiGwKey"; }
}
public string accessKey
{
get { return "accessKey"; }
}
public string secureKey
{
get { return "secureKey"; }
}
public string ncpUrl
{
get { return @"https://ncloud.apigw.ntruss.com/clouddb/v1/"; }
}
}
class Program
{
static void Main(string[] args)
{
Config config = Config.Instance;
var postParams = new List<KeyValuePair<string, string>>();
postParams.Add(new KeyValuePair<string, string>("dbKindCode", "MSSQL"));
postParams.Add(new KeyValuePair<string, string>("responseFormatType", "json"));
AsyncCall asyncCall = new AsyncCall();
Task<string> t = asyncCall.NCloudApiCall("getCloudDBConfigGroupList", postParams, config.apiKey, config.accessKey, config.secureKey, config.ncpUrl);
t.Wait();
Console.WriteLine(t.Result);
}
}
class AsyncCall
{
public async Task<string> NCloudApiCall(string action, List<KeyValuePair<string, string>> postParams, string apiKey, string accessKey, string secureKey, string ncpUrl)
{
string responseString = string.Empty;
try
{
HttpClient client = Client.Instance.getClient();
string timestamp = string.Empty;
string sig = Auth.Instance.makePostSignature(action, ref timestamp, apiKey, accessKey, secureKey);
string url = ncpUrl + action;
var content = new FormUrlEncodedContent(postParams);
client.DefaultRequestHeaders.Add("x-ncp-apigw-timestamp", timestamp);
client.DefaultRequestHeaders.Add("x-ncp-apigw-api-key", apiKey);
client.DefaultRequestHeaders.Add("x-ncp-iam-access-key", accessKey);
client.DefaultRequestHeaders.Add("x-ncp-apigw-signature-v1", sig);
var response = await client.PostAsync(url, content);
responseString = await response.Content.ReadAsStringAsync();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return responseString;
}
}
class Auth
{
private static readonly Lazy<Auth> lazy =
new Lazy<Auth>(() => new Auth(), LazyThreadSafetyMode.ExecutionAndPublication);
public static Auth Instance { get { return lazy.Value; } }
public string makePostSignature(string action, ref string stringtimestamp, string apiKey, string accessKey, string secureKey)
{
if (string.IsNullOrEmpty(action))
return "parameter error";
long timestamp = (long)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalMilliseconds;
string space = " ";
string newLine = "\n";
string method = "POST";
string url = @"/clouddb/v1/" + action;
stringtimestamp = timestamp.ToString();
string message = new StringBuilder()
.Append(method)
.Append(space)
.Append(url)
.Append(newLine)
.Append(stringtimestamp)
.Append(newLine)
.Append(apiKey)
.Append(newLine)
.Append(accessKey)
.ToString();
Debug.WriteLine(message);
byte[] secretKey = Encoding.UTF8.GetBytes(secureKey);
HMACSHA256 hmac = new HMACSHA256(secretKey);
hmac.Initialize();
byte[] bytes = Encoding.UTF8.GetBytes(message);
byte[] rawHmac = hmac.ComputeHash(bytes);
Debug.WriteLine(Convert.ToBase64String(rawHmac));
return Convert.ToBase64String(rawHmac);
}
}
class Client
{
private static readonly Lazy<Client> lazy =
new Lazy<Client>(() => new Client(), LazyThreadSafetyMode.ExecutionAndPublication);
public static Client Instance { get { return lazy.Value; } }
private readonly HttpClient client = new HttpClient();
public HttpClient getClient()
{
return client;
}
}
}
telegram bot
분류없음 / 2018.07.10 18:54
[bot 만들기]
텔레그램 안에서 BotFather 친구 맺음
/start
/newbot
yourbotname
yourbotname_bot
Use this token to access the HTTP API:
0000000:VVVhJhOKsTl_2Vppzc93OKsOd0PpLVcVZlM
For a description of the Bot API, see this page: https://core.telegram.org/bots/api
/token
@yourbotname_bot
[그룹만들어 봇 초대하기]
인간 사용자가 그룹을 만들어
봇 사용자가 그룹을 찾아 들어감 Add to Group
[봇이 들어간 group 내 사용자 리스트 구하기]
https://api.telegram.org/bot00000000:fdsafdsafda_dsafdsafdas/getUpdates
id 양수는 개인
id 음수는 그룹
-- 이제 코딩
https://github.com/TelegramBots/Telegram.Bot.Examples/blob/master/Telegram.Bot.Examples.Echo/Program.cs
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Telegram.Bot;
using Telegram.Bot.Args;
using Telegram.Bot.Types.Enums;
using Telegram.Bot.Types.InlineQueryResults;
using Telegram.Bot.Types.ReplyMarkups;
namespace telegramtest2
{
class Program
{
private static readonly TelegramBotClient Bot = new Telegram.Bot.TelegramBotClient("botid");
//private static readonly TelegramBotClient Bot = new Telegram.Bot.TelegramBotClient("botid");
static void Main(string[] args)
{
Bot.OnMessage += Bot_OnMessage;
var me = Bot.GetMeAsync().Result;
Console.Title = me.Username;
//SendMsg(5646546464565, "메롱2");
/// Recv Start
Bot.StartReceiving();
Console.ReadLine();
/// Recv Stop
Bot.StopReceiving();
Console.ReadKey();
}
private static async void SendMsg(long chatId, string message)
{
await Bot.SendTextMessageAsync(chatId, message);
}
private static async void Bot_OnMessage(object sender, Telegram.Bot.Args.MessageEventArgs messageEventArgs)
{
var message = messageEventArgs.Message;
if (message.Text.StartsWith("/cmd"))
{
Console.WriteLine(message.Chat.Id);
Debug.WriteLine(message.Chat.Id);
await Bot.SendTextMessageAsync(message.Chat.Id, "나한테 일시키기 마라");
}
}
}
}
Task await
분류없음 / 2018.07.10 15:18
class Program
{
static void Main(string[] args)
{
List<Task<string>> lists = new List<Task<string>>();
Program p = new Program();
lists.Add(p.Run2());
lists.Add(p.Run());
foreach (var a in lists)
a.Wait(); // 모두 기다리고 출력
foreach (var a in lists)
Console.WriteLine(a.Result); // 5초 응답
}
async Task<string> Run()
{
var a = Task.Delay(1000);
var b = Task.Delay(1000);
var c = Task.Delay(1000);
var d = Task.Delay(1000);
var e = Task.Delay(1000);
await a;
await b;
await c;
await d;
await e;
Thread.Sleep(3000); // 전체 처리시간 4초
return DateTime.Now.ToString();
}
async Task<string> Run2()
{
await Task.Delay(1000);
await Task.Delay(1000);
await Task.Delay(1000);
await Task.Delay(1000);
await Task.Delay(1000); // 전체 처리시간 5초
return DateTime.Now.ToString();
}
}
//using System;
//using System.Collections.Generic;
//using System.Linq;
//using System.Text;
//using System.Threading.Tasks;
//using System.Configuration;
//using System.Threading;
//namespace ConsoleApp1
//{
// public class EvenNumberEventArgs : EventArgs
// {
// public EvenNumberEventArgs(int i)
// {
// this.I = i;
// }
// public int I { get; set; }
// }
// class Program
// {
// static void Main(string[] args)
// {
// new Program().Run();
// }
// void Run()
// {
// Config config = Config.Instance;
// EventProcess ep = new EventProcess();
// //Console.WriteLine(config.SampleApplication);
// for (int i = 0; i < 10; i++)
// {
// config.NumberCheck(i);
// }
// }
// }
// public sealed class Config
// {
// private static readonly Lazy<Config> lazy =
// new Lazy<Config>(() => new Config(), LazyThreadSafetyMode.ExecutionAndPublication);
// public static Config Instance { get { return lazy.Value; } }
// private Config()
// {
// //this.SampleApplication = ConfigurationManager.AppSettings["sampleApplication"];
// }
// //public string SampleApplication { get; } = string.Empty;
// public event EventHandler<EvenNumberEventArgs> MyEvent;
// public void NumberCheck(int i)
// {
// if (i % 2 == 0)
// MyEvent?.Invoke(this, new EvenNumberEventArgs(i));
// }
// }
// class EventProcess
// {
// public EventProcess()
// {
// Config.Instance.MyEvent += EvenNumber;
// }
// void EvenNumber(object o, EvenNumberEventArgs args)
// {
// Console.WriteLine(o.GetType());
// Console.WriteLine(string.Format("this is even Number : {0}", args.I));
// }
// }
//}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
namespace ConsoleApp1
{
class Program
{
static void Main(string[] args)
{
new Program().Run();
}
void Run()
{
Config config = Config.Instance;
new EventProcess();
//Console.WriteLine(config.SampleApplication);
for (int i = 0; i < 10; i++)
{
config.NumberCheck(i);
}
}
}
public sealed class Config
{
private static readonly Lazy<Config> lazy =
new Lazy<Config>(() => new Config(), LazyThreadSafetyMode.ExecutionAndPublication);
public static Config Instance { get { return lazy.Value; } }
private Config()
{
//this.SampleApplication = ConfigurationManager.AppSettings["sampleApplication"];
}
public Action<object, EvenNumberEventArgs> MyEvent;
public void NumberCheck(int i)
{
if (i % 2 == 0)
MyEvent?.Invoke(this, new EvenNumberEventArgs(i));
}
public class EvenNumberEventArgs : EventArgs
{
public EvenNumberEventArgs(int i)
{
this.I = i;
}
public int I { get; set; }
}
}
class EventProcess
{
public EventProcess()
{
Config.Instance.MyEvent += EvenNumber;
}
void EvenNumber(object o, Config.EvenNumberEventArgs args)
{
Console.WriteLine(o.GetType());
Console.WriteLine(string.Format("this is even Number : {0}", args.I));
}
}
}
function base n
분류없음 / 2018.05.29 18:07
/****** Object: UserDefinedFunction [dbo].[F_NUMERIC_TO_BASE_N] Script Date: 5/29/2018 6:07:05 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create function [dbo].[F_NUMERIC_TO_BASE_N]
(
@Number numeric(32,0),
@Base int
)
returns varchar(110)
as
/*
Function: F_NUMERIC_TO_BASE_N
Function F_NUMERIC_TO_BASE_N converts a numeric(32,0) value, @Number,
to a string of digits in number base @Base,
where @Base is between 2 and 36.
Output digits greater than 9 are represented by
uppercase letters A through Z, where A = 10 through Z = 35.
If input parameter @Number is negative, the output string
will have a minus sign in the leftmost position.
Any non-null numeric(32,0) value for parameter @Number is valid:
-99999999999999999999999999999999 through
99999999999999999999999999999999.
If input parameters @Number or @Base are null,
or @Base is not between 2 and 36,
then the function returns a null value.
*/
begin
declare @Work_Number numeric(38,0)
declare @Modulus int
declare @Digits varchar(36)
declare @Output_String varchar(110)
if @Number is null or @Base is null or @Base < 2 or @Base > 36
begin
return null
end
set @Digits = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'
set @Output_String = ''
set @Work_Number = @Number
while 1=1
begin
Set @Modulus = convert(int,abs(@Work_Number-(round(@Work_Number/@Base,0,1)*@Base)))
set @Output_String = substring(@Digits,@Modulus+1,1) + @Output_String
set @Work_Number = round(@Work_Number/@Base,0,1)
if @Work_Number = 0 break
end -- end while
if @Number < 0 set @Output_String = '-'+@Output_String
return @Output_String
end
GO
declare @times bigint = 1
declare @top_count bigint = 1000
select dbo.[F_NUMERIC_TO_BASE_N](@times * 100000000 + rn * 1000 , 32)
from
(
select top (@top_count) row_number() over (order by (select 1)) rn
from sysobjects a
cross join sysobjects b
cross join sysobjects c
) a
https://m.blog.naver.com/PostView.nhn?blogId=lauf1&logNo=220781453020&proxyReferer=https%3A%2F%2Fwww.google.co.kr%2F
ista-d torrent