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