private void but_form_alter(object sender, EventArgs e) { Button but = (Button)sender; switch (but.Name) { case "but_changeToRegis": changeToFormRegister(); break; case "but_sua": if (checkInput()) { c1 = label_id.Text; c2 = funcShare.Nvarchar(textbox_ten.Text); c3 = textbox_remain.Text; c4 = textbox_loai.Text; funcShare.update("mat_hang", "ten,remain,loai_hang_id", c2, c3, c4, funcShare.where ("id", c1)); changeToFormRegister(); LoadMatHang(); } break; case "but_xoa": string xoa = "DELETE FROM mat_hang WHERE id=" + label_id.Text; cmd = new SqlCommand(xoa); db.editDB(cmd); changeToFormRegister(); LoadMatHang(); break; } }
private void but_sua_xoa_Click(object sender, EventArgs e) { Button but = (Button)sender; switch (but.Name) { case "but_sua": if (kiemTraInput()) { c1 = funcShare.Nvarchar(textbox_ten.Text); c2 = funcShare.Nvarchar(textbox_sdt.Text); c3 = funcShare.Nvarchar(textbox_quan.Text); c4 = funcShare.Nvarchar(textbox_phuong.Text); c5 = funcShare.Nvarchar(textbox_city.Text); c6 = label_id.Text; funcShare.update("nha_cung_cap", "ten,sdt,quan,phuong,city", c1, c2, c3, c4, c5, funcShare.where ("id", c6)); funcShare.loadGridView("nha_cung_cap", gridView); changeToFormRegister(); } break; case "but_xoa": string delete = "DELETE FROM nha_cung_cap WHERE id =" + label_id.Text; comman = new SqlCommand(delete); database.editDB(comman); funcShare.loadGridView("nha_cung_cap", gridView); changeToFormRegister(); break; case "but_changeToRegis": changeToFormRegister(); break; } }
private void but_form_alter(object sender, EventArgs e) { Button but = (Button)sender; switch (but.Name) { case "but_changeToRegis": changeToFormRegister(); break; case "but_sua": if (checkInput()) { c1 = label_id.Text; c2 = textbox_ncc.Text; c3 = funcShare.date(textbox_ngay.Text, textbox_thang.Text, textbox_nam.Text); c4 = textbox_nv.Text; funcShare.update("phieu_nhap", "ncc_id,ngay_nhap,nhan_vien_id", c2, c3, c4, funcShare.where ("id", c1)); changeToFormRegister(); LoadPhieuNhap(); } break; case "but_xoa": string xoa = "DELETE FROM phieu_nhap WHERE id=" + label_id.Text; cmd = new SqlCommand(xoa); database.editDB(cmd); changeToFormRegister(); LoadPhieuNhap(); break; } }
private void but_form_alter(object sender, EventArgs e)//but sua chua lam { Button but = (Button)sender; switch (but.Name) { case "but_changeToRegis": changeToFormRegister(); break; case "but_sua": c1 = label_id.Text; c2 = textbox_ncc.Text; c3 = funcShare.date(textbox_ngay.Text, textbox_thang.Text, textbox_nam.Text); c4 = textbox_nv.Text; funcShare.update("phieu_nhap", "ncc_id,ngay_nhap,nhan_vien_id", c2, c3, c4, funcShare.where ("id", c1)); changeToFormRegister(); funcShare.loadGridView("phieu_nhap,nha_cung_cap,nhan_vien where ncc_id=nha_cung_cap.id and nhan_vien_id=nhan_vien.id" , "phieu_nhap.id,nha_cung_cap.ten,ngay_nhap,nhan_vien.ten", gridView); break; case "but_xoa": string xoa = "DELETE FROM phieu_nhap WHERE id=" + label_id.Text; cmd = new SqlCommand(xoa); database.editDB(cmd); changeToFormRegister(); funcShare.loadGridView("phieu_nhap,nha_cung_cap,nhan_vien where ncc_id=nha_cung_cap.id and nhan_vien_id=nhan_vien.id" , "phieu_nhap.id,nha_cung_cap.ten,ngay_nhap,nhan_vien.ten", gridView); break; } }
private void but_fix_Click(object sender, EventArgs e) { if (checkInput()) { funcShare.update("chi_tiet_phieu_nhap", "so_luong,don_gia,don_vi", textbox_soluong.Text, textbox_cost.Text, funcShare.Nvarchar(textbox_donvi.Text), funcShare.where ("phieu_nhap_id", phieu_nhap_id, "mat_hang_id", item_id)); this.Close(); } }