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();
}
}
