private void delete()
{
DOUONG_PUBLIC douong_public = new DOUONG_PUBLIC();
douong_public.IDDOUONG = int.Parse(txtma.Text);
douong_bul.delete_douong(douong_public);
}
private void insert()
{
DOUONG_PUBLIC douong_public = new DOUONG_PUBLIC();
douong_public.IDDM = int.Parse(cbiddm.Text);
douong_public.TENDOUONG = txttendouong.Text;
douong_public.DONGIA = float.Parse(txtdongia.Text);
douong_bul.insert_douong(douong_public);
}
public DataTable TIM_DOUONG(DOUONG_PUBLIC douong_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@TEN";
values[0] = douong_public.TEN;
string sql = "TIM_TENDOUONG";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}
public DataTable load_douongvoi_where(DOUONG_PUBLIC douong_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@MADM";
values[0] = douong_public.IDDM;
string sql = "LOAD_DOUONG_WITH_WHERE";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}
public int delete_douong(DOUONG_PUBLIC douong_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDDOUONG";
values[0] = douong_public.IDDOUONG;
string sql = "DELETE_DOUONG";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
private void bttim_Click(object sender, EventArgs e)
{
if (txttim.TextLength == 0)
{
lbtrangthai.ForeColor = Color.DarkRed;
lbtrangthai.Text = "Chưa điền tên cần tìm.";
}
else
{
DOUONG_PUBLIC douong_public = new DOUONG_PUBLIC();
douong_public.TEN = txttim.Text;
dg_monan.DataSource = douong_bul.TIM_DOUONG(douong_public);
}
}
public int insert_douong(DOUONG_PUBLIC douong_public)
{
int parameter = 3;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDDM";
name[1] = "@TENDOUONG";
name[2] = "@DONGIA";
values[0] = douong_public.IDDM;
values[1] = douong_public.TENDOUONG;
values[2] = douong_public.DONGIA;
string sql = "INSERT_DOUONG";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
private void cbten_Click_1(object sender, EventArgs e)
{
try
{
DOUONG_PUBLIC douong_public = new DOUONG_PUBLIC();
douong_public.IDDM = int.Parse(cbiddm.Text);
DataTable dt = new DataTable();
dt = DOUONG_BUL.load_douongvoi_where(douong_public);
cbten.DataSource = dt;
cbten.DisplayMember = "TENDOUONG";
cbgia.DataSource = dt;
cbgia.DisplayMember = "DONGIA";
cbiddouong.DataSource = dt;
cbiddouong.DisplayMember = "IDDOUONG";
}
catch
{
MessageBox.Show("Danh mục trống.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public DataTable load_douongvoi_where(DOUONG_PUBLIC douong_public)
{
return(douong_dal.load_douongvoi_where(douong_public));
}
public DataTable TIM_DOUONG(DOUONG_PUBLIC douong_public)
{
return(douong_dal.TIM_DOUONG(douong_public));
}
public int delete_douong(DOUONG_PUBLIC douong_public)
{
return(douong_dal.delete_douong(douong_public));
}
public int update_douong(DOUONG_PUBLIC douong_public)
{
return(douong_dal.update_douong(douong_public));
}
public int insert_douong(DOUONG_PUBLIC douong_public)
{
return(douong_dal.insert_douong(douong_public));
}
