/// <summary>
/// Проверка наличия значения в базе
/// </summary>
/// <param name="whereString"></param>
/// <param name="addParams"></param>
/// <returns></returns>
internal protected bool FieldExists(string whereString, AddParams addParams)
{
return(GetIntField("SELECT TOP 1 " + idField +
" FROM " + tableName + " WITH (NOLOCK)\n" +
whereString, idField,
addParams) > 0);
}
public override int GetHashCode()
{
int hash = 1;
hash ^= Headers.GetHashCode();
hash ^= SetHeaders.GetHashCode();
hash ^= deleteHeaders_.GetHashCode();
if (Body.Length != 0)
{
hash ^= Body.GetHashCode();
}
if (Url.Length != 0)
{
hash ^= Url.GetHashCode();
}
hash ^= Params.GetHashCode();
hash ^= AddParams.GetHashCode();
hash ^= ExtendedParams.GetHashCode();
hash ^= deleteParams_.GetHashCode();
if (returnOverrides_ != null)
{
hash ^= ReturnOverrides.GetHashCode();
}
return(hash);
}
internal protected DataSet GetTreeData(string query, AddParams addParams, CancellationToken ct)
{
using (var sda = new SqlDataAdapter())
using (var conn = new SqlConnection(connectionString))
using (sda.SelectCommand = new SqlCommand(query, conn))
{
if (ct != CancellationToken.None)
{
ct.Register(() => sda.SelectCommand.Cancel());
}
if (addParams != null)
{
addParams(sda.SelectCommand);
}
if (ct != CancellationToken.None && ct.IsCancellationRequested)
{
ct.ThrowIfCancellationRequested();
}
DataSet ds = CMD_FillDS(sda);
if (ds != null)
{
AddParentRelation(ds, ct);
}
if (ct != CancellationToken.None && ct.IsCancellationRequested)
{
ct.ThrowIfCancellationRequested();
}
return(ds);
}
}
public static async Task AddAsync()
{
Console.WriteLine("**** AddAsync() ****");
Console.WriteLine("Id of AddAsync() : {0}", Thread.CurrentThread.ManagedThreadId);
AddParams add = new AddParams(10, 10);
await Sum(add);
}
/// <summary>
/// The execut add params.
/// </summary>
/// <param name="addParams">
/// The add params.
/// </param>
/// <returns>
/// The <see cref="int"/>.
/// </returns>
private static int ExecutAddParams(AddParams addParams)
{
var user = new UserData {
User = addParams.User, Secret = addParams.Secret
};
userService.AddUser(user);
return(ExitCodes.Ok);
}
internal protected DataTable GetDataTable(string query, AddParams addParams, out SqlCommand command)
{
using (var conn = new SqlConnection(connectionString))
using (var cmd = new SqlCommand(query, conn))
{
command = cmd;
addParams?.Invoke(cmd);
return(CMD_FillDT(cmd));
}
}
public static CalculationResult Calc(AddParams pars)
{
return(new CalculationResult
{
Addition = pars.First + pars.Second,
Divide = pars.First / pars.Second,
Multiply = pars.First * pars.Second,
Subtraction = pars.First - pars.Second,
});
}
private static void Add2(object data)
{
if (data is AddParams)
{
System.Console.WriteLine("ID of thread in Add(): {0}", Thread.CurrentThread.ManagedThreadId);
AddParams ap = (AddParams)data;
System.Console.WriteLine("{0} + {1} is {2}", ap.a, ap.b, ap.a + ap.b);
}
}
public MainWindow()
{
InitializeComponent();
var connectionString = new SQLiteConnectionStringBuilder {
DataSource = dataSource_
}.ToString();
var dataTable = new DataTable();
var sql =
Select(SHOHIN_ID, SHOHIN_MEI, HANBAI_TANKA)
.From(T_SHOHIN)
.Where(GreaterThan(HANBAI_TANKA,
Select(Avg(HANBAI_TANKA))
.From(T_SHOHIN)
.EndWithBrackets()))
.End();
try
{
using (var connection = new SQLiteConnection(connectionString))
using (var command = new SQLiteCommand(sql, connection))
using (var adapter = new SQLiteDataAdapter(command))
{
connection.Open();
AddParams(command,
("@id", DbType.String, "0008"),
("@name", DbType.String, "ボールペン"),
("@bunrui", DbType.String, "キッチン用品"),
("@htanka", DbType.Int32, 1000),
("@stanka", DbType.Int32, 500),
("@torokubi", DbType.Date, null)
);
adapter.Fill(dataTable);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
data_grid.ItemsSource = dataTable.DefaultView;
text_block.Text = sql;
}
internal static void Add(Object data)
{
if (data is AddParams)
{
Console.WriteLine($"ID of thread in Add(): {Thread.CurrentThread.ManagedThreadId}");
AddParams ap = (AddParams)data;
Thread.Sleep(5000);
Console.WriteLine($"{ap.a} + {ap.b} = {ap.a + ap.b}");
waitHandle.Set();
}
}
static void AddForThree(object data)
{
if (data is AddParams)
{
Console.WriteLine("ID of thread in Add(): {0}", Thread.CurrentThread.ManagedThreadId);
AddParams ap = (AddParams)data;
Console.WriteLine("{0} + {1} is {2}", ap.a, ap.b, ap.a + ap.b);
waitHandle.Set();
}
}
private static async Task AddAsync()
{
Console.WriteLine("***** Adding with Thread objects *****");
Console.WriteLine("ID of thread in Main(): {0}", Thread.CurrentThread.ManagedThreadId);
AddParams ap = new AddParams(10, 29);
await Sum(ap);
Console.WriteLine("Other thread is done!");
}
internal static void AddWiththreads()
{
Console.WriteLine($"ID of thread in Main(): {Thread.CurrentThread.ManagedThreadId}");
AddParams ap = new AddParams(10, 15);
Thread t = new Thread(new ParameterizedThreadStart(Add));
t.Start(ap);
waitHandle.WaitOne();
Console.WriteLine("Other thread is done!");
}
internal protected DataTable GetDataTable(string query, AddParams addParams)
{
using (var conn = new SqlConnection(connectionString))
using (var cmd = new SqlCommand(query, conn))
{
if (addParams != null)
{
addParams(cmd);
}
return(CMD_FillDT(cmd));
}
}
public static void Add(object data)
{
if (data is AddParams)
{
Console.WriteLine();
Console.WriteLine("Id of Add() : {0}", Thread.CurrentThread.ManagedThreadId);
AddParams ap = (AddParams)data;
Console.WriteLine("{0} + {1} is {2}", ap.a, ap.b, ap.a + ap.b);
}
}
public bool Equals(MiniRequestObject other)
{
if (ReferenceEquals(other, null))
{
return(false);
}
if (ReferenceEquals(other, this))
{
return(true);
}
if (!Headers.Equals(other.Headers))
{
return(false);
}
if (!SetHeaders.Equals(other.SetHeaders))
{
return(false);
}
if (!deleteHeaders_.Equals(other.deleteHeaders_))
{
return(false);
}
if (Body != other.Body)
{
return(false);
}
if (Url != other.Url)
{
return(false);
}
if (!Params.Equals(other.Params))
{
return(false);
}
if (!AddParams.Equals(other.AddParams))
{
return(false);
}
if (!ExtendedParams.Equals(other.ExtendedParams))
{
return(false);
}
if (!deleteParams_.Equals(other.deleteParams_))
{
return(false);
}
if (!object.Equals(ReturnOverrides, other.ReturnOverrides))
{
return(false);
}
return(true);
}
private static void UseParameterizedThreadStartDelegate()
{
Console.WriteLine("*** UseParameterizedThreadStartDelegate ***");
Console.WriteLine("ID of thread in Main(): {0}",
Thread.CurrentThread.ManagedThreadId);
AddParams parameters = new AddParams(10, 10);
Thread thread = new Thread(new ParameterizedThreadStart(Add));
thread.Start(parameters);
waitHandle.WaitOne();
Console.WriteLine("Other thread is done!");
}
static async Task Sum(object data)
{
Console.WriteLine("Id of Sum : {0}", Thread.CurrentThread.ManagedThreadId);
await Task.Run(() => {
if (data is AddParams)
{
Console.WriteLine("Id of Sum => TaskRun() : {0}", Thread.CurrentThread.ManagedThreadId);
AddParams add = (AddParams)data;
Console.WriteLine("{0} + {1} = {2}", add.a, add.b, add.a + add.b);
}
});
}
internal protected DataSet GetData(string query, AddParams addParams)
{
using (var sda = new SqlDataAdapter())
using (var conn = new SqlConnection(connectionString))
using (sda.SelectCommand = new SqlCommand(query, conn))
{
if (addParams != null)
{
addParams(sda.SelectCommand);
}
return(CMD_FillDS(sda));
}
}
internal protected List <T> GetRecords <T>(string query, AddParams addParams, GetResult getResult)
{
var result = new List <T>();
using (var conn = new SqlConnection(connectionString))
using (var cmd = new SqlCommand(query, conn))
{
if (addParams != null)
{
addParams(cmd);
}
cmd.CommandTimeout = cmdTimeout;
bool?repeat = null;
while (!repeat.HasValue || repeat.Value)
{
try
{
cmd.Connection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (getResult != null)
{
result.Add((T)getResult(dr));
}
else
{
if (dr[0] != DBNull.Value)
{
result.Add((T)dr[0]);
}
}
}
dr.Close();
}
repeat = false;
}
catch (SqlException sqlEx)
{
if ((sqlEx.Number != 6005 && sqlEx.Number != 10054) || (repeat.HasValue && repeat.Value))
{
repeat = false;
ProcessSqlEx(sqlEx, cmd);
}
else
{
repeat = true;
}
}
}
static async Task Sum(object data)
{
await Task.Run(() =>
{
if (data is AddParams)
{
Console.WriteLine("ID of thread in Add(): {0}",
Thread.CurrentThread.ManagedThreadId);
AddParams ap = (AddParams)data;
Console.WriteLine("{0} + {1} is {2}",
ap.number1, ap.number2, ap.number1 + ap.number2);
}
});
}
static void Add(object data)
{
if (data is AddParams)
{
Console.WriteLine("ID of thread in Add(): {0}",
Thread.CurrentThread.ManagedThreadId);
AddParams ap = (AddParams)data; // get params
Console.WriteLine("{0} + {1} is {2}",
ap.a, ap.b, ap.a + ap.b);
Thread.Sleep(5);
Console.WriteLine("Secondary thread finished.");
}
}
private static void WorkWithParameterizedThreadStart()
{
System.Console.WriteLine("***** Adding with Thread object *****");
System.Console.WriteLine("ID of thread in Main(): {0}", Thread.CurrentThread.ManagedThreadId);
// make an AddParams obj to pass to the secondary thread
AddParams ap = new AddParams(10, 10);
Thread t = new Thread(new ParamArrayAttribute(Add2));
t.Start(ap);
Thread.Sleep(5);
Console.ReadLine();
}
private static void Add(object data)
{
if (data is AddParams)
{
Console.WriteLine("ID of thread in Add(): {0}",
Thread.CurrentThread.ManagedThreadId);
AddParams parameters = (AddParams)data;
Console.WriteLine("{0} + {1} is {2}",
parameters.a,
parameters.b,
parameters.a + parameters.b);
waitHandle.Set();
}
}
static void Add(object data)
{
if (data is AddParams)
{
Console.WriteLine("ID of thread in Add(): {0}",
Thread.CurrentThread.ManagedThreadId);
AddParams ap = (AddParams)data; // get params
Console.WriteLine("{0} + {1} is {2}",
ap.a, ap.b, ap.a + ap.b);
// Tell other thread we are done.
waitHandle.Set(); //[true]
}
}
private static void WorkWithAutoResetEventClass()
{
System.Console.WriteLine("***** Adding with Thread objects *****");
System.Console.WriteLine("ID of thread in Main(): {0}", Thread.CurrentThread.ManagedThreadId);
AddParams ap = new AddParams(10, 10);
Thread t = new Thread(new ParameterizedThreadStart(Add3));
t.Start(ap);
WaitHandle.WaitOne();
System.Console.WriteLine("Other thread is done!");
System.Console.WriteLine();
}
static void Main(string[] args)
{
Console.WriteLine("***** Adding with Thread objects *****");
Console.WriteLine("ID of thread in Main(): {0}",
Thread.CurrentThread.ManagedThreadId);
// Make an AddParams object to pass to the secondary thread.
AddParams ap = new AddParams(10, 10);
Thread t = new Thread(new ParameterizedThreadStart(Add));
t.Start(ap);
// Force a wait to let other thread finish.
Console.WriteLine("Begin: Main thread sleep for 5 ms.");
Thread.Sleep(5);
Console.WriteLine("Finish: Main thread sleep for 5 ms.");
Console.ReadLine();
}
internal protected DataTable GetDataTable(string query, AddParams addParams, CancellationToken ct)
{
using (var conn = new SqlConnection(connectionString))
using (var cmd = new SqlCommand(query, conn))
{
if (ct != CancellationToken.None)
{
ct.Register(() => cmd.Cancel());
}
if (addParams != null)
{
addParams(cmd);
}
DataTable td = CMD_FillDT(cmd);
return(td);
}
}
static void Main(string[] args)
{
Console.WriteLine("***** Adding with Thread objects *****");
Console.WriteLine("ID of thread in Main(): {0}",
Thread.CurrentThread.ManagedThreadId);
// Make an AddParams object to pass to the secondary thread.
AddParams ap = new AddParams(10, 10);
Thread t = new Thread(new ParameterizedThreadStart(Add));
t.Start(ap);
// Force a wait to let other thread finish.
Console.WriteLine("Begin: Main thread sleep for 5 ms.");
Thread.Sleep(5);
Console.WriteLine("Finish: Main thread sleep for 5 ms.");
Console.ReadLine();
}
static void Main(string[] args)
{
Console.WriteLine("***** Adding with Thread objects *****");
Console.WriteLine("ID of thread in Main(): {0}",
Thread.CurrentThread.ManagedThreadId);
AddParams ap = new AddParams(10, 10);
Thread t = new Thread(new ParameterizedThreadStart(Add));
t.Start(ap);
//inform the primary thread to wait until the secondary thread has completed
// Wait here until you are notified!
Console.WriteLine("Main thread begin to wait.");
waitHandle.WaitOne(); // wait until waitHandle set true
// after waitone is called, AutoResetEvent be set false again.
Console.WriteLine("Other thread is done!");
Console.ReadLine();
}
public static void ThreadDemoThree()
{
Console.WriteLine("***** Adding with Thread objects *****");
Console.WriteLine("ID of thread in Main(): {0}", Thread.CurrentThread.ManagedThreadId);
AddParams ap = new AddParams(10, 10);
Thread t = new Thread(new ParameterizedThreadStart(AddForThree));
t.Start(ap);
//后台线程设置，不设置则都是前台线程
t.IsBackground = true;
//等待，直到接收到通知
waitHandle.WaitOne();
Console.WriteLine("Other thread is done!");
Thread.Sleep(5);
Console.ReadLine();
}
static void Main(string[] args)
{
Console.WriteLine("***** Adding with Thread objects *****");
Console.WriteLine("ID of thread in Main(): {0}",
Thread.CurrentThread.ManagedThreadId);
AddParams ap = new AddParams(10, 10);
Thread t = new Thread(new ParameterizedThreadStart(Add));
t.Start(ap);
//inform the primary thread to wait until the secondary thread has completed
// Wait here until you are notified!
Console.WriteLine("Main thread begin to wait.");
waitHandle.WaitOne(); // wait until waitHandle set true
// after waitone is called, AutoResetEvent be set false again.
Console.WriteLine("Other thread is done!");
Console.ReadLine();
}