private void Button_SearchTenSP_Click(object sender, RoutedEventArgs e)
{
string str = TextBox_SearchTenSP.Text;
try
{
//Cách 2
string cnString = Properties.Settings.Default.connString;
SqlConnection cn = new SqlConnection(cnString);
cn = CDatabase.Get_Database_Connection();
string sqlText = "SELECT TENHH as 'Tên hàng hóa', SLTON as 'Số lượng tồn' FROM HANG_HOA WHERE TENHH like '%" + str + "%' ";
DataTable tb = new DataTable();
tb = CDatabase.Get_Data_Table(sqlText);
CDatabase.Execute_SQL(sqlText);
MyDataGrid_SP.DataContext = tb.DefaultView;
CDatabase.Close_Database_Connection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void db_Read_Record_SP()
{
try
{
//Cách 2
string cnString = Properties.Settings.Default.connString;
SqlConnection cn = new SqlConnection(cnString);
cn = CDatabase.Get_Database_Connection();
string sqlText = "SELECT pp.TENHH as 'Tên hàng hóa', sum(p.SLBAN) 'Số lượng bán được' FROM CTHD p, HANG_HOA pp WHERE p.MAHH=pp.MAHH GROUP BY p.MAHH, pp.TENHH ORDER BY sum(p.SLBAN) DESC ";
DataTable tb = new DataTable();
tb = CDatabase.Get_Data_Table(sqlText);
CDatabase.Execute_SQL(sqlText);
MyDataGrid_LoaiSP.DataContext = tb.DefaultView;
CDatabase.Close_Database_Connection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}