private void btn_year_Click(object sender, EventArgs e) // nam { dataGridViewMain.Rows.Clear(); Thread thread = new Thread(delegate() { listItem = Helpers.Helper.DoanhThuTheoNam(DatabaseFactory.Instance, dateTimePicker1.Value); FillToGrid(listItem); Tuple <int, int> resultBuyMedicine = HelperforSeemore.GetAllCountAndMoneyMedicineInputInYear(DatabaseFactory.Instance, dateTimePicker1.Value.Year); int phimuathuoc = resultBuyMedicine.Item2; CalcuTotal(phimuathuoc, listItem, resultBuyMedicine.Item1); }); thread.Start(); HelperControl.Instance.ShowProgress(thread); thread.Join(); }
private Tuple <int, int> GetCountAndMoneySellMedcine(string strcmd) { int count = 0; int money = 0; using (DbDataReader reader = db.ExecuteReader(strcmd, null) as DbDataReader) { while (reader.Read()) { string medicine = reader[0].ToString(); if (medicine.Length != 0) { Tuple <int, int> itemResult = HelperforSeemore.ProcessStringGetCountAndMoneyAll(medicine); count += itemResult.Item1; money += itemResult.Item2; } } } return(new Tuple <int, int>(count, money)); }
private void btn_day_Click(object sender, EventArgs e) { DateTime current = dateTimePicker1.Value; // Thuoc da nhap trong ngay Tuple <int, int> resultInputDay = HelperforSeemore.GetCountAndMoneyMedicineInputInDay(db, current, this.IDMedicine); int countInput = resultInputDay.Item1; tbx_nhapthuoc.Text = countInput.ToString(); tbx_moneynhapthuoc.Text = resultInputDay.Item2.ToString(); // Medicine export Tuple <int, int> resultExportInDay = HelperforSeemore.GetCountAndMoneyMedicineExportInDay(db, current, this.NameMedicine); int countExport = resultExportInDay.Item1; tbx_xuatthuoc.Text = countExport.ToString(); tbx_moneyxuatthuoc.Text = resultExportInDay.Item2.ToString(); if (current.Date == DateTime.Now.Date) { // Thuoc ton kho int countInventory = db.GetCountFromMecidicByName(this.NameMedicine); tbx_cuoiki.Text = countInventory.ToString(); //Ton khi truoc ki int countFirst = countInventory + countExport - countInput; tbx_dauki.Text = countFirst.ToString(); } else { //Ton khi truoc ki int countFirst = HelperforSeemore.GetCountFirstDay(db, current, this.IDMedicine, this.NameMedicine); tbx_dauki.Text = countFirst.ToString(); // Thuoc ton kho int countInventory = countFirst + countInput - countExport; tbx_cuoiki.Text = countInventory.ToString(); } }