private void button1_Click(object sender, EventArgs e) { string loai = null; if (LOAISC.SelectedItem.ToString() == "1.Sua Chua") { loai = "1"; } else { loai = "2"; } string maphieusc = MAPSC.SelectedItem.ToString(); spilit_space(ref maphieusc); string tenpt = LOAIPT.SelectedItem.ToString(); spilit_space(ref tenpt); string query = "SELECT MAPT FROM PHUTUNG WHERE TENPT='" + tenpt + "'"; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); string mapt = tb.Rows[0]["MAPT"].ToString(); spilit_space(ref mapt); ////////////////////////////// kiểm tra sự tồn tại khóa chính query = "SELECT *FROM THONGTINSUACHUA WHERE MAPT='" + mapt + "' AND MAPSC= '" + maphieusc + "'"; provider = new DATAPROVIDER(); DataTable result = provider.Executequery(query); if (result.Rows.Count == 1) { MessageBox.Show("Thông tin sửa chữa bị trùng !!!"); } else { ////////////////////////////////// query = "INSERT INTO dbo.THONGTINSUACHUA ( MAPT , MAPSC ,LOAISUACHUA ,MOTA ,SLPT_SUDUNG ,CHIPHI)VALUES ( '" + mapt + "','" + maphieusc + "', " + loai + " ,N'" + MOTA.Text.ToString() + "' ," + slptsd.Text.ToString() + "," + CHIPHI.Text.ToString() + ")"; tb = new DataTable(); tb = provider.Executequery(query); loadthongtinsuachua(maphieusc); } ///SHOW THÀNH TIỀN query = "SELECT SUM (CHIPHI) AS 'CHIPHI' FROM dbo.THONGTINSUACHUA WHERE MAPSC='" + maphieusc + "'"; provider = new DATAPROVIDER(); tb = new DataTable(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { THANHTIEN.Text = row["CHIPHI"].ToString(); THANHTIEN.Show(); } }
private void tenkhachhang_SelectedIndexChanged_1(object sender, EventArgs e) { get_kh.get_ten = makh.Text.ToString(); string query = "SELECT *FROM dbo.KHACHHANG WHERE MAKH= '" + makh.SelectedItem.ToString() + "'"; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { hoten.Text = row["HOTEN"].ToString(); hoten.Show(); cmnd.Text = row["CMND"].ToString(); cmnd.Show(); bienso.Text = row["BIENSO"].ToString(); bienso.Show(); loaixe.Text = row["LOAIXE"].ToString(); loaixe.Show(); } loadthongtinMapsccombobox(); addphieusuachua.Enabled = true; }
//kiểm tra sự tồn tại của khóa chính trong bảng thong tin sua chữa void loadthongtinsuachua(string mapsc) { string query = "SELECT *FROM THONGTINSUACHUA WHERE MAPSC= '" + mapsc + "'"; DATAPROVIDER provider = new DATAPROVIDER(); dataGridView1.DataSource = provider.Executequery(query); }
public void LoadListByKeyWord() { DATAPROVIDER kn = new DATAPROVIDER(); DataTable dt = new DataTable(); dt = kn.Executequery("select * from PHUTUNG where TENPHUTUNG like'%" + txtTimKiem.Text + "%' "); dataGridPhuTung.DataSource = dt; }
public void LayBangPT() { DATAPROVIDER kn = new DATAPROVIDER(); DataTable dt = new DataTable(); dt = kn.Executequery("select * from PHUTUNG"); dataGridPhuTung.DataSource = dt; }
public void LayBangNV() { DATAPROVIDER kn = new DATAPROVIDER(); DataTable dt = new DataTable(); dt = kn.Executequery("select * from NHANVIEN"); dataGridNhanVien.DataSource = dt; }
public void LoadListByKeyWord() { DATAPROVIDER kn = new DATAPROVIDER(); DataTable dt = new DataTable(); dt = kn.Executequery("select * from KHACHHANG where Name like'%" + txtTimKiem.Text + "%' "); dataGridKhachHang.DataSource = dt; }
public void LayBangKH() { DATAPROVIDER kn = new DATAPROVIDER(); DataTable dt = new DataTable(); dt = kn.Executequery("select * from KHACHHANG"); dataGridKhachHang.DataSource = dt; }
public void LoadListByKeyWord() { DATAPROVIDER kn = new DATAPROVIDER(); DataTable dt = new DataTable(); dt = kn.Executequery("select * from NHANVIEN where HOTEN like'%" + txtTimKiem.Text + "%' "); dataGridNhanVien.DataSource = dt; }
//public void loadaccountlist() //{ // //EXEC GETACCOUNTBYUSERNAME @USERNAME // string query = "SELECT *FROM dbo.TAIKHOAN "; // //string query = "INSERT INTO TAIKHOAN VALUES('TK06','NV6','123456','07/02/1788')"; // DATAPROVIDER provider = new DATAPROVIDER(); // dataGridView1.DataSource = provider.Executequery(query/*,new object[] { "NV2" }*/); public void loadaccountlist() { //EXEC GETACCOUNTBYUSERNAME @USERNAME string query = "SELECT *FROM dbo.TAIKHOAN "; // string query = "INSERT INTO TAIKHOAN VALUES('TK06','NV6','123456','07/02/1788')"; DATAPROVIDER provider = new DATAPROVIDER(); dataGridView1.DataSource = provider.Executequery(query /*new object[] { "NV2" }*/); }
public void loadthongtinkhintocombobox() { string query = "SELECT *FROM dbo.KHACHHANG "; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { string name = row["MAKH"].ToString(); makh.Items.Add(name); } makh.Show(); }
public void loadthongtinMapsccombobox() { string query = "SELECT MAPSC FROM dbo.PHIEUSUACHUA JOIN dbo.KHACHHANG ON KHACHHANG.MAKH = PHIEUSUACHUA.MAKH AND HOTEN='" + hoten.Text.ToString() + "'"; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { string name = row["MAPSC"].ToString(); MAPSC.Items.Add(name); } MAPSC.Show(); }
public void loadloaiphutungcombobox() { string query = "SELECT TENPT FROM dbo.PHUTUNG "; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { string name = row["TENPT"].ToString(); LOAIPT.Items.Add(name); } LOAIPT.Show(); }
void showmanv() { string query = "SELECT *FROM dbo.NHANVIEN "; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { string name = row["MANV"].ToString(); MANV.Items.Add(name); } MANV.Show(); }
void updatedata() { string query = "SELECT *FROM dbo.TAIKHOAN "; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); string MATK = tb.Rows[0]["MATK"].ToString(); spilit_space(ref MATK); //////////////////////////// //textBoxmatkhau.Text.ToString(); query = "UPDATE dbo.TAIKHOAN SET TENDN= '" + textboxtendangnhap.Text.ToString() + "' , MATKHAU= '" + textBoxmatkhau.Text.ToString() + "' WHERE MATK= '" + MATK + "'"; DATAPROVIDER pro = new DATAPROVIDER(); DataTable tbable = new DataTable(); tbable = pro.Executequery(query); }
private void MAPSC_SelectedIndexChanged(object sender, EventArgs e) { //load thông tin phiếu sửa chữa String idpsc = MAPSC.Text.ToString(); spilit_space(ref idpsc); loadthongtinsuachua(idpsc); /////load thông tin chi phí thu string query = "SELECT SUM (CHIPHI) AS 'CHIPHI' FROM dbo.THONGTINSUACHUA WHERE MAPSC='" + idpsc + "'"; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { THANHTIEN.Text = row["CHIPHI"].ToString(); THANHTIEN.Show(); } }
public void showdoanhthu() { string query = "SELECT PHUTUNG.MAPT AS N'Mã Phụ Tùng',TENPT AS N'Tên Phụ Tùng',SUM(SLPT_SUDUNG) AS N'Số Lượng Sử Dụng Trong Tháng',SOLUONG AS N'Số Lượng Còn Lại',SUM(THANHTIEN) AS'Tiền Thu' FROM dbo.THONGTINSUACHUA JOIN dbo.PHUTUNG ON PHUTUNG.MAPT = THONGTINSUACHUA.MAPT JOIN dbo.PHIEUSUACHUA ON PHIEUSUACHUA.MAPSC = THONGTINSUACHUA.MAPSC AND YEAR(NGAYSUACHUA)=YEAR(GETDATE()) AND MONTH(NGAYSUACHUA)=MONTH(GETDATE()) GROUP BY dbo.PHUTUNG.MAPT,dbo.PHUTUNG.TENPT,SOLUONG"; DATAPROVIDER provider = new DATAPROVIDER(); datagridbct.DataSource = provider.Executequery(query); query = "SELECT SUM(TIENTHU) as N'DOANHTHU' FROM dbo.PHIEUTHUTIEN WHERE YEAR(NGAYTHU)=YEAR(GETDATE()) AND MONTH(NGAYTHU)=MONTH(GETDATE())"; /////////////////////////// DataTable tb = new DataTable(); provider = new DATAPROVIDER(); tb = provider.Executequery(query); foreach (DataRow row in tb.Rows) { string DT = row["DOANHTHU"].ToString(); doanhthu.Text = DT; doanhthu.Show(); } }
private void INSERT_Click(object sender, EventArgs e) { if (MAPSC.Text == "" || MANV.Text == "") { MessageBox.Show("Mã phiếu sữa chữa hoặc mã nhân viên không được trống!!!"); } else { string idnv = MANV.SelectedItem.ToString(); spilit_space(ref idnv); string idkh = makh.Text.ToString(); spilit_space(ref idkh); string ngaysc = NGAYSUACHUA.Value.ToString(); string query = "INSERT INTO dbo.PHIEUSUACHUA( MAPSC,MANV,MAKH,NGAYSUACHUA)VALUES( '" + MAPSC.Text.ToString() + "','" + idnv + "','" + idkh + "','" + ngaysc + "')"; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); MessageBox.Show("Thêm phiếu sửa chữa thành công"); } }
void loadaccount() { string query = "SELECT *FROM dbo.TAIKHOAN"; DATAPROVIDER provider = new DATAPROVIDER(); DataTable tb = new DataTable(); tb = provider.Executequery(query); string str = tb.Rows[0]["TENDN"].ToString(); spilit_space(ref str); textboxtendangnhap.Text = str; textboxtendangnhap.Show(); str = tb.Rows[0]["MATKHAU"].ToString(); spilit_space(ref str); textBoxmatkhau.Text = str; textboxtendangnhap.Show(); str = tb.Rows[0]["NGAYTAO"].ToString(); spilit_space(ref str); textBoxngaytao.Text = str; textboxtendangnhap.Show(); }