private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (navigationPane1.SelectedPage == navigationPage1) { new AddMaker().Show(); ShowMaker(); } else if (navigationPane1.SelectedPage == navigationPage2) { new AddProduct().Show(); dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct"); } else if (navigationPane1.SelectedPage == navigationPage3) { new AddAssortment().Show(); dataGridView5.DataSource = DbConn.GetDataTable("ShowPrice"); } else if (navigationPane1.SelectedPage == navigationPage4) { } else if (navigationPane1.SelectedPage == navigationPage5) { } else if (navigationPane1.SelectedPage == navigationPage6) { } else if (navigationPane1.SelectedPage == navigationPage7) { } else if (navigationPane1.SelectedPage == navigationPage8) { } }
private void XtraForm2_Load(object sender, EventArgs e) { dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct"); dataGridView1.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel); dataGridView2.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel); dataGridView3.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel); dataGridView4.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel); dataGridView5.Font = new Font("Arial", 12.5F, GraphicsUnit.Pixel); dataGridView6.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel); dataGridView7.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel); dataGridView8.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel); dataGridView9.Font = new Font("Arial", 16.5F, GraphicsUnit.Pixel); dataGridView3.DataSource = DbConn.GetData($"SELECT * FROM Greasiness"); dataGridView4.DataSource = DbConn.GetData($"SELECT Packaging.Id, TypePackaging.Namee, VolumePackaging.Valuee " + " FROM Packaging JOIN TypePackaging ON TypePackaging.ID = Packaging.TypePackagingID " + "JOIN VolumePackaging ON VolumePackaging.ID = Packaging.VolumePackagingID "); dataGridView5.DataSource = DbConn.GetDataTable("ShowPrice"); ShowMaker(); ShowCheckProduct(); ShowCheckUnique(); RefreshSearchForm(); ShowAllSale(); CreateChartMakerProduct__Sum(); CreateChartTypePackaging__Sum(); CreateChartDataAffiliate__Sum(); navigationPane1.Font = new Font("Arial", 24, GraphicsUnit.Pixel); navigationPage1.Font = new Font("Arial", 24F, GraphicsUnit.Pixel); //navigationPage1.Appearance.FontSizeDelta = 4; //navigationPage2.Appearance.FontSizeDelta = 1; //navigationPage3.Appearance.FontSizeDelta = 12; //navigationPage4.Appearance.FontSizeDelta = -2; }
private void simpleButton11_Click(object sender, EventArgs e)//add new TypeProduct { Task task = new Task(InsertTypeProduct); task.Start(); task.Wait(); textBox7.Text = ""; dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct"); }
private void simpleButton9_Click(object sender, EventArgs e) { Task task = new Task(DeleteTypeProduct); task.Start(); task.Wait(); textBox1.Text = ""; dataGridView2.DataSource = DbConn.GetData($"SELECT * FROM TypeProduct"); }
public void ShowGroup() { try { string columns = ""; if (checkBox1.Checked) { columns += "TypeProduct.Namee, "; } if (checkBox2.Checked) { columns += "Maker.Namee, "; } if (checkBox3.Checked) { columns += "TypePackaging.Namee, "; } if (checkBox4.Checked) { columns += "VolumePackaging.valuee, "; } if (checkBox5.Checked) { columns += "Greasiness.Valuee, "; } if (!string.IsNullOrEmpty(columns) && !string.IsNullOrWhiteSpace(columns)) { int index = columns.LastIndexOf(","); columns = columns.Remove(index); } string from = "Maker JOIN PriceList ON Maker.Id=PriceList.MakerID JOIN TypeProduct ON TypeProduct.Id = PriceList.TypeProductID JOIN Packaging ON Packaging.Id = PriceList.PackagingID JOIN TypePackaging ON TypePackaging.Id = Packaging.TypePackagingID JOIN VolumePackaging ON VolumePackaging.Id = Packaging.VolumePackagingID JOIN Greasiness ON Greasiness.Id = PriceList.GreasinessID JOIN CheckProduct ON CheckProduct.PriceListID = PriceList.Id JOIN CheckUnique ON CheckUnique.Id = CheckProduct.CheckUniqueID JOIN Affiliate ON Affiliate.Id = CheckUnique.AffiliateID"; string query = $"SELECT {columns}, Sum(CheckProduct.Countt) as Count, SUM(PriceList.Price*CheckProduct.Countt) as Sum FROM {from} GROUP BY {columns}"; dataGridView9.DataSource = null; dataGridView9.DataSource = DbConn.GetData(query); } catch { } }
public void ShowMaker() { Thread.Sleep(1000); dataGridView1.DataSource = DbConn.GetData($"SELECT * FROM Maker"); }