/// <summary> /// The test storage proc button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void TestStorageProcButtonClick(object sender, EventArgs e) { int cnt; var goodsDictionary = PiluleDal.ExecuteStorageProc(13, out cnt); if (goodsDictionary == null) { return; } this.MainDataGridView.DataSource = goodsDictionary; }
private static void Main(string[] args) { // Console.WriteLine($"test ADO.NET - {PiluleDal.CheckVersionAdoNet()}"); // Console.WriteLine($"test DapperORM - {PiluleDal.CheckVersionDaperOrm()}"); /*var debugValue = PiluleDal.GetDebugValue("GoodsDictionary"); * if (debugValue != null) * { * foreach (var items in debugValue) //foreach (ICollection<KeyValuePair<string, object>> items in debugValue) * { * foreach (var item in items) * { * Console.Write($"{item.Key}={item.Value} "); * } * Console.WriteLine(); * } * }*/ // var result = PiluleDal.ExecuteNonSelectCommand(); /*Console.WriteLine(PiluleDal.DropDataBase()); * Console.WriteLine(PiluleDal.ExecuteScript("CreateDB")); * Console.WriteLine(PiluleDal.ExecuteScript("CreateTable_Version")); * Console.WriteLine(PiluleDal.ExecuteScript("CreateTable_GoodsDictionary")); * Console.WriteLine(PiluleDal.ExecuteScript("CreateTable_StockBalance")); * Console.WriteLine(PiluleDal.InsertDataExecute("DupelData")); * * Console.WriteLine( * PiluleDal.InsertDataExecuteBulk( * new List<PiluleDal.GoodsDictionary> * { * new PiluleDal.GoodsDictionary { Name = "xxx", Price = 25, Comment = "nop" } * }));*/ int cnt; var goodsDictionary = PiluleDal.ExecuteStorageProc(out cnt); goodsDictionary?.ToList().ForEach(Console.WriteLine); Console.WriteLine(cnt); /*goodsDictionary = PiluleDal.GetGoodsDictionary(3); * goodsDictionary?.ToList().ForEach(Console.WriteLine);*/ //var goodsDictionary = PiluleDal.GetGoodsDictionary(new List<int> { 1, 3 }); //goodsDictionary?.ToList().ForEach(Console.WriteLine); //var tuple = PiluleDal.MultiSelect(); //tuple?.Item1?.ToList().ForEach(Console.WriteLine); //tuple?.Item2?.ToList().ForEach(Console.WriteLine); //var result = PiluleDal.MultiMapping(); //result?.ToList().ForEach(Console.WriteLine); /*var mmf = MemoryMappedFile.CreateNew("MyFileInFile", 1); * using (var writer = mmf.CreateViewAccessor(0, 1)) * { * byte msg = 25; * writer.Write(0, msg); * } * * var mmf1 = MemoryMappedFile.OpenExisting("MyFileInFile"); * using (var reader = mmf1.CreateViewAccessor(0, 1, MemoryMappedFileAccess.Read)) * { * var msg = reader.ReadByte(0); * Console.WriteLine(msg); * }*/ Console.ReadKey(); }