private void cmbDrink_SelectedIndexChanged(object sender, EventArgs e)
{
string nameDrink = cmbDrink.Text;
lbDrink.Text = nameDrink;
CategoriesD currentCate = (CategoriesD)cmbCategoriesD.SelectedItem;
int idCategory = currentCate.IdCategoriesD;
int nmCategory = 1;
int nmDrink = 0;
if (DataProvider.Instance.ExecuteScalar("NumberCategoriesOnAll @idCategoriesD , @getIn", new object[] { idCategory, dt.Value.Date }).ToString() == "")
{
lbPercentDrink.Text = (100 * nmDrink / nmCategory).ToString("0.0") + "%";
lbDrink.Text = nameDrink;
tkDrink.PercentItem = 360 * nmDrink / nmCategory;
tkDrink.Refresh();
return;
}
else
{
nmCategory = (int)DataProvider.Instance.ExecuteScalar("NumberCategoriesOnAll @idCategoriesD , @getIn", new object[] { idCategory, dt.Value.Date });
}
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT soLuong FROM DrinkPerTime WHERE nameDrink = N'" + nameDrink + "'");
foreach (DataRow item in data.Rows)
{
nmDrink += (int)item["soLuong"];
}
lbPercentDrink.Text = (100 * nmDrink / nmCategory).ToString("0.0") + "%";
lbDrink.Text = nameDrink;
tkDrink.PercentItem = 360 * nmDrink / nmCategory;
tkDrink.Refresh();
}
private void cmbCategoriesD_SelectedIndexChanged(object sender, EventArgs e)
{
//Hiện drink
lbTKDrink.Text = "Thống kê sản phẩm ngày : " + dt.Value.Date.ToString("dd-MM-yyyy");
CategoriesD currentCate = (CategoriesD)cmbCategoriesD.SelectedItem;
int idCategory = currentCate.IdCategoriesD;
cmbDrink.DataSource = DrinkDAO.Instance.GetListDrinkByIdCategory(idCategory);
cmbDrink.DisplayMember = "nameDrink";
//Thống kê
float percentItem = 0;
int nmCategory = 0;
int nmAll = 1;
if (true)
{
if (DataProvider.Instance.ExecuteScalar("NumberCategoriesOnAll @idCategoriesD , @getIn", new object[] { idCategory, dt.Value.Date }).ToString() == "")
{
tkCategories.PercentItem = percentItem;
tkCategories.Refresh();
lbCateName.Text = lbCate.Text = currentCate.NameCategories;
lbpercentCate.Text = (100 * nmCategory / nmAll).ToString("0.0") + "%";
return;
}
nmCategory = (int)DataProvider.Instance.ExecuteScalar("NumberCategoriesOnAll @idCategoriesD , @getIn", new object[] { idCategory, dt.Value.Date });
nmAll = (int)DataProvider.Instance.ExecuteScalar("AllProductsSale @getIn", new object[] { dt.Value.Date });
percentItem = 360 * nmCategory / nmAll;
}
tkCategories.PercentItem = percentItem;
tkCategories.Refresh();
lbCateName.Text = lbCate.Text = currentCate.NameCategories;
lbpercentCate.Text = (100 * nmCategory / nmAll).ToString("0.0") + "%";
}
public CategoriesD GetCategoryByName(string name)
{
CategoriesD ca = null;
string query = "SELECT * FROM CategoriesD WHERE nameCategories = N'" + name + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow row in data.Rows)
{
ca = new CategoriesD(row);
}
return(ca);
}
