protected void WaitDrawDataGridView()
{
var server = new SQLiteService();
var list = server.Find <TestInfo>("1=1 limit 100");
tDataGridViewPager1.DataSource = list;
}
private void Query()
{
var server = new SQLiteService();
var list = server.Find <TestInfo>("1=1 limit 100");
var tQuery = new TQuery <TestInfo>();
tQuery.Init(qqTextBox1, list, new { Name = 0, Value = 0 });
tQuery.SelectedEvent += TQuery_SelectedEvent;
}
private void Button1_Click(object sender, EventArgs e)
{
var server = new SQLiteService();
var list = server.Find <TestInfo>("1=1 limit 100");
gridview3.DataSource = list;
gridview3.ExpandAll();
gridview2.DataSource = list;
gridview1.DataSource = list;
}
private void BtnTest_Click(object sender, EventArgs e)
{
try
{
//new SQLiteService().Insert(new UserInfo());
var list = new SQLiteService().Find <UserInfo>();
//new SqlService().Test();
}
catch (Exception ex)
{
ex.Show();
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
base.AddItem();
base.AddUpdate();
base.AddDelete();
base.HaveQuery();
gridview1.TPadding = new Padding(0);
gridview1.PageSize = 5;
gridview1.Edit.AddSpanHeader(typeof(TestInfo), nameof(TestInfo.Name), 2, "操作", true, StringAlignment.Near);
gridview1.Edit.ColumnHeadersHeight = 77;
if (DesignMode)
{
return;
}
//gridview1.IGroup = false;
//this.UserTree(true);
var server = new SQLiteService();
base.find = "Id<=917551";
var list = server.Find <TestInfo>("1=1 limit 1000");
base.InitData(list, server);
}
private void ToolBar1_ItemClick(ToolItem arg1, EventArgs arg2)
{
switch (arg1.Text)
{
case "控件":
MControl.ReLoad(panel1, typeof(TestControl));
break;
case "控件2":
MControl.ReLoad(panel1, typeof(Control1));
break;
case "数据":
var server = new SQLiteService();
ITestInfo obj = new TestInfo();
//obj.Id = 1;
//obj.Image = BitmapHelper.GetBitmapFormFile(@"D:\Tinn\DotNet\House\bin\Debug\Code\110031622_45259-02360-00.png");
//server.Insert(obj);
ITestInfo info = server.FindById <TestInfo>(1);
info.FindInfo = new FindInfo()
{
Id = 100
};
info.List.Add(new FindInfo());
info.List2 = new List <FindInfo>();
server.Update(info);
TestBase b = new TestBase();
var b1 = (TestBase)info;
b1.Clone(b);
b.Id = 3;
b.Clone(b1);
var id = info.GetValue(nameof(TestInfo.FindInfo));
var obj3 = info.Clone(true);
obj3.FindInfo.Id = 102;
obj3.List.Clear();
obj3.List2.Add(new FindInfo());
ITestInfo obj4 = new TestInfo();
info.Clone(obj4, true);
obj4.FindInfo.Id = 103;
obj4.List.Clear();
obj4.List2.Add(new FindInfo());
Stopwatch sw = new Stopwatch();
sw.Restart();
var list = server.Find <TestInfo>("1=1 limit 10000");
Debug.WriteLine("FindList=>" + sw.ElapsedMilliseconds);
sw.Restart();
//var dt3 = list.ToDataTable();
Debug.WriteLine("ToDataTable=>" + sw.ElapsedMilliseconds);
var type = typeof(TestInfo);
sw.Restart();
for (int i = 0; i < 10; i++)
{
var dt4 = list.ToDataTable();
}
Debug.WriteLine("ToDataTable=>" + sw.ElapsedMilliseconds);
sw.Restart();
for (int i = 0; i < 10; i++)
{
//var list4 = dt3.ToList<TestInfo>();
}
Debug.WriteLine("ToDataTable2=>" + sw.ElapsedMilliseconds);
sw.Restart();
for (int i = 0; i < 10 * 10; i++)
{
var ix = list.Find(c => c.Id == 1014509);
}
Debug.WriteLine("Find=>" + sw.ElapsedMilliseconds);
var dict = list.Cast <TestInfo>().ToDictionary(o => o.Id, o => o);
sw.Restart();
for (int i = 0; i < 10 * 10; i++)
{
if (dict.ContainsKey(1014509))
{
var ix = dict[1014509];
}
}
Debug.WriteLine("Key=>" + sw.ElapsedMilliseconds);
var map = new Hashtable();
map.Add(1, list[0]);
map.Add("1", list[1]);
var b2 = map[1];
var list3 = list.Clone(true);
sw.Restart();
for (int i = 0; i < 100; i++)
{
list.Clone(list3);
}
Debug.WriteLine("Clone=>" + sw.ElapsedMilliseconds);
sw.Restart();
for (int i = 0; i < 100; i++)
{
//var list3 = list.Clone2(true);
list.Clone(list3);
}
Debug.WriteLine("Clone2=>" + sw.ElapsedMilliseconds);
var dt2 = server.FindTable <ITestInfo>("1=1 limit 20");
var list2 = dt2.ToList <TestInfo>();
var list21 = dt2.ToList(type);
sw.Restart();
list.Sort(nameof(TestInfo.UserType));
Debug.WriteLine("OrderBy2=>" + sw.ElapsedMilliseconds);
sw.Restart();
var temp = list.AsParallel().OrderBy(c => c.Name);
Debug.WriteLine("OrderBy1=>" + sw.ElapsedMilliseconds);
sw.Restart();
var temp2 = list.AsParallel().OrderBy(c => c.Name).ToList();
Debug.WriteLine("ToList.Time=>" + sw.ElapsedMilliseconds);
sw.Restart();
foreach (var item in temp)
{
}
Debug.WriteLine("ToList.Time=>" + sw.ElapsedMilliseconds);
//gridview1.DataSource = list;
break;
}
}
