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