/// <summary> /// The debug button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void DebugButtonClick(object sender, RoutedEventArgs e) { if (this.CurrentGoodsId == -1) { this.baskeеt.Add(this.piluleDataProvider.GetGood(this.OnBaskeеtChanged)); } else { var goods = PiluleDal.GetGoodsDictionary(this.CurrentGoodsId); if (goods == null) { return; } var basketData = new BaskeеtData(this.OnBaskeеtChanged) { Id = goods.Id, Name = goods.Name, Amount = 1, Price = goods.Price }; this.baskeеt.Add(basketData); this.DocVid.Content = "Вид документа: продажа (открыт)"; this.PaymentButton.IsEnabled = true; this.PaymentButton.Background = new SolidColorBrush(Colors.DarkSeaGreen); } }
/// <summary> /// The insert data button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private async void InsertDataButtonClick(object sender, EventArgs e) { this.InsertDataButton.Enabled = false; this.ClearLog(); var assemblyFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location); if (string.IsNullOrEmpty(assemblyFolder)) { this.OutLog("ExecutingAssembly not found"); return; } var fileName = Path.Combine(assemblyFolder, "Docs", "ProductList.txt"); var lines = File.ReadAllLines(fileName); var goodsDictionaryList = new List <PiluleDal.GoodsDictionary>(); var stockBalanceList = new List <PiluleDal.StockBalance>(); var rnd = new Random(); foreach (var line in lines) { if (string.IsNullOrEmpty(line)) { continue; } var code = $"{goodsDictionaryList.Count + 1:000000}"; var price = Convert.ToDecimal(rnd.Next(10000, 50000)) / 100; var splitResult = line.Split(new[] { ". " }, StringSplitOptions.None); PiluleDal.GoodsDictionary item = null; if (splitResult.Length == 1) { item = new PiluleDal.GoodsDictionary { Name = splitResult[0], Code = code, Comment = string.Empty, Price = price }; } if (splitResult.Length == 2) { item = new PiluleDal.GoodsDictionary { Name = splitResult[0], Code = code, Comment = splitResult[1], Price = price }; } if (item == null) { continue; } goodsDictionaryList.Add(item); stockBalanceList.Add(new PiluleDal.StockBalance { GoodsId = stockBalanceList.Count + 1, Amount = rnd.Next(0, 100) }); } await PiluleDal.InsertGoodsDictionaryAsync(goodsDictionaryList, this.OutLog); await PiluleDal.InsertStockBalanceAsync(stockBalanceList, this.OutLog); }
/// <summary> /// The get multi mapping button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void GetMultiMappingButtonClick(object sender, EventArgs e) { var multiMapping = PiluleDal.MultiMapping(); if (multiMapping == null) { return; } this.MainDataGridView.DataSource = multiMapping; }
/// <summary> /// The get stock balance button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void GetStockBalanceButtonClick(object sender, EventArgs e) { var stockBalance = PiluleDal.GetStockBalance(); if (stockBalance == null) { return; } this.MainDataGridView.DataSource = stockBalance; }
/// <summary> /// The get goods dictionary button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void GetGoodsDictionaryButtonClick(object sender, EventArgs e) { var goodsDictionary = PiluleDal.GetGoodsDictionary(); if (goodsDictionary == null) { return; } this.MainDataGridView.DataSource = goodsDictionary; }
/// <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; }
/// <summary> /// The get debug value button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void GetDebugValueButtonClick(object sender, EventArgs e) { var debugValue = PiluleDal.GetDebugValue("GoodsDictionary"); if (debugValue == null) { this.OutLog("NULL Value"); return; } foreach (var items in debugValue) { foreach (var item in items) { this.OutLog($"{item.Key}={item.Value} "); } } }
private void GoodsFilterTextChanged(object sender, TextChangedEventArgs e) { this.AddBaskedButton.IsEnabled = false; this.AddBaskedButton.Background = new SolidColorBrush(Colors.Gainsboro); this.CurrentGoodsId = -1; if (this.GoodsFilter.Text.Length > 2) { var template = this.GoodsFilter.Text; var item = PiluleDal.GetFirstGoodsByTemplate(template); if (item == null) { return; } this.CurrentGoodsId = item.Id; this.NameLabel.Content = $"{item.Code} {item.Name} ({item.Comment})"; this.AddBaskedButton.IsEnabled = true; this.AddBaskedButton.Background = new SolidColorBrush(Colors.DarkSeaGreen); } }
/// <summary> /// The create db button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private async void CreateDbButtonClick(object sender, EventArgs e) { this.CreateDbButton.Enabled = false; this.ClearLog(); await PiluleDal.DropDataBaseAsync(this.OutLog); await PiluleDal.ExecuteScriptAsync("CreateDB", this.OutLog); await PiluleDal.ExecuteScriptAsync("CreateTable_Version", this.OutLog); await PiluleDal.ExecuteScriptAsync("CreateTable_GoodsDictionary", this.OutLog); await PiluleDal.ExecuteScriptAsync("CreateTable_StockBalance", this.OutLog); await PiluleDal.ExecuteScriptAsync("InsertVersion", this.OutLog); await PiluleDal.ExecuteScriptAsync("CreateTestStorageProc", this.OutLog); this.CreateDbButton.Enabled = true; }
/// <summary> /// The test button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void TestButtonClick(object sender, EventArgs e) { var x = PiluleDal.GetFirstGoodsByTemplate("Ай"); this.OutLog(x.Name); }
/// <summary> /// The get version button click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> private void GetVersionButtonClick(object sender, EventArgs e) { this.OutLog($"test ADO.NET - {PiluleDal.CheckVersionAdoNet(VersionMarker)}"); this.OutLog($"test DapperORM - {PiluleDal.CheckVersionDaperOrm(VersionMarker)}"); }
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(); }