private void Them(string SoXe, string Ten, string TinhTrang) { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); string ThemVT = string.Format("insert into VatTu(So_Xe,ThietBiVatTu,TinhTrang) values (@SoXe,@TBVT,@TinhTrang)"); DataTable user = new DataTable(); SqlCommand Com = new SqlCommand(ThemVT, Con); Com.Parameters.Add(new SqlParameter("@SoXe", SoXe)); Com.Parameters.Add(new SqlParameter("@TBVT", Ten)); Com.Parameters.Add(new SqlParameter("@TinhTrang", TinhTrang)); SqlDataAdapter adapt = new SqlDataAdapter(Com); adapt.Fill(user); Con.Close(); MetroFramework.MetroMessageBox.Show(this, string.Format("Okey Đã Thêm {0}!", Ten)); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void ThemDanhGia() { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); string DG = string.Format("update DanhGiaNhanVien set DanhGia= @DanhGia where MaNhanVien=@MaNhanVien"); DataTable user = new DataTable(); SqlCommand Com = new SqlCommand(DG, Con); Com.Parameters.Add(new SqlParameter("@DanhGia", txtDanhGia.Text)); Com.Parameters.Add(new SqlParameter("@MaNhanVien", MaNhanVien_FormMain)); SqlDataAdapter adapt = new SqlDataAdapter(Com); adapt.Fill(user); Con.Close(); MetroFramework.MetroMessageBox.Show(this, string.Format("OKey"), "Compelete", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void Loading() { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); String Soure = String.Format("select dg.DanhGia from DanhGiaNhanVien dg where dg.MaNhanVien=@MaNV"); SqlCommand Com = new SqlCommand(Soure, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNhanVien_FormMain)); if (Com.ExecuteScalar() == null) { lblDanhGia.Text = "........................."; } else { lblDanhGia.Text = Com.ExecuteScalar().ToString(); } Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void Loading() { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); //LayTenChiPhi string TenChiPhi = string.Format("select cp.TenChiPhi from ChiPhi cp where cp.STT=@STT"); //Gọi Proc SqlCommand Com = new SqlCommand(TenChiPhi, Con); Com.Parameters.Add(new SqlParameter("@STT", STT_FormMain)); lblTen.Text = Com.ExecuteScalar().ToString(); //LấyChiTiet string ChiTiet = string.Format("select cp.ChiTietChiPhi from ChiPhi cp where cp.STT=@STT"); //Gọi Proc Com = new SqlCommand(ChiTiet, Con); Com.Parameters.Add(new SqlParameter("@STT", STT_FormMain)); lblChiTiet.Text = Com.ExecuteScalar().ToString(); //LấyTien string Tien = string.Format("select cp.TongPhi from ChiPhi cp where cp.STT=@STT"); //Gọi Proc Com = new SqlCommand(Tien, Con); Com.Parameters.Add(new SqlParameter("@STT", STT_FormMain)); lbltien.Text = Com.ExecuteScalar().ToString(); Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void Them(string Ten, string ChiTiet, int Tong) { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); string ThemCP = string.Format("insert into ChiPhi(TenChiPhi,ChiTietChiPhi,TongPhi) values (@Ten,@ChiTiet,@Tien)"); DataTable user = new DataTable(); SqlCommand Com = new SqlCommand(ThemCP, Con); Com.Parameters.Add(new SqlParameter("@Ten", Ten)); Com.Parameters.Add(new SqlParameter("@ChiTiet", ChiTiet)); Com.Parameters.Add(new SqlParameter("@Tien", Tong)); SqlDataAdapter adapt = new SqlDataAdapter(Com); adapt.Fill(user); Con.Close(); MetroFramework.MetroMessageBox.Show(this, string.Format("Okey Đã Thêm {0}!", Ten)); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void Begin() { if (LoaiNhanVien == "1" || LoaiNhanVien == "2") { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); String Soure = String.Format("select p.LoTrinh from PhanCongViec p where p.MaCongViec=@MaCV"); SqlCommand Com = new SqlCommand(Soure, Con); Com.Parameters.Add(new SqlParameter("@MaCV", MaNhanVien_FormMain)); if (Com.ExecuteScalar() == null) { lblLoTrinh.Text = ""; } else { lblLoTrinh.Text = Com.ExecuteScalar().ToString(); } Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } } else { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); String Soure = String.Format("select p.CaTruc from PhanCongViec p where p.MaCongViec=@MaCV"); SqlCommand Com = new SqlCommand(Soure, Con); Com.Parameters.Add(new SqlParameter("@MaCV", MaNhanVien_FormMain)); if (Com.ExecuteScalar() == null) { comboBox1.Text = ""; } else { comboBox1.Text = Com.ExecuteScalar().ToString(); } Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } } }
private void GetInfoVe() { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); SqlCommand Com; int index = lblLoTrinh.Text.LastIndexOf("-"); if (index == -1) { lblNgayDi.Text = ""; lblMaChuyen.Text = ""; lblLoTrinh.Text = ""; } else { string DiemDen = lblLoTrinh.Text.Substring(index + 2); string DiemDi = lblLoTrinh.Text.Substring(0, index - 1); //LayNgayDi string NgayDi = string.Format("exec GetInfoVe_NgayDi @DiemXuatPhat , @DiemDich"); //Gọi Proc Com = new SqlCommand(NgayDi, Con); Com.Parameters.Add(new SqlParameter("@DiemXuatPhat", DiemDi)); Com.Parameters.Add(new SqlParameter("@DiemDich", DiemDen)); lblNgayDi.Text = Com.ExecuteScalar().ToString(); //LấyIdVe string IdVe = string.Format("exec GetInfoVe_ID"); //Gọi Proc Com = new SqlCommand(IdVe, Con); lblMaChuyen.Text = Com.ExecuteScalar().ToString() + " - "; string IDChuyen = string.Format("exec GetInfoVe_IdChuyen @DiemXuatPhat , @DiemDich"); //Gọi Proc Com = new SqlCommand(IDChuyen, Con); Com.Parameters.Add(new SqlParameter("@DiemXuatPhat", DiemDi)); Com.Parameters.Add(new SqlParameter("@DiemDich", DiemDen)); lblMaChuyen.Text += Com.ExecuteScalar().ToString(); } } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void SoXe() { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); String Soure = String.Format("select cx.So_Xe from ChuyenXe cx"); DataTable user = new DataTable(); SqlCommand cmd = new SqlCommand(Soure, Con); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataSet ChuyenDi = new DataSet(); adapt.Fill(ChuyenDi); cbSoXe.DataSource = ChuyenDi.Tables[0]; //Đổ dữ liệu vào Combobox cbSoXe.DisplayMember = "So_Xe"; cbSoXe.ValueMember = "So_Xe"; Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private string TenLoaiNV(string LoaiNV) { string temp = ""; try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); //Lấy Tên string Ten = string.Format("select lnv.TenLoaiNV from LoaiNhanVien lnv where lnv.IdLoaiNV=@LoaiNV"); //Gọi Proc SqlCommand Com = new SqlCommand(Ten, Con); Com.Parameters.Add(new SqlParameter("@LoaiNV", LoaiNV)); temp = Com.ExecuteScalar().ToString(); Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } return(temp); }
private void ShowInfoKhachHang() { string IdHangHoa = IdHangHoa_FormMain; string IdChuyen = IdChuyen_FormMain; try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); //Lấy Tên Người Gửi string TenNG = string.Format("exec InfoNhanHang_TenNG @IdHangHoa , @IdChuyen"); //Gọi Proc SqlCommand Com = new SqlCommand(TenNG, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtTenNguoiGui.Text = Com.ExecuteScalar().ToString(); //Lấy Tên Người Nhận string TenNN = string.Format("exec InfoNhanHang_TenNN @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(TenNN, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtTenNguoiNhan.Text = Com.ExecuteScalar().ToString(); //LayCMNDNguoiGui string CMNDNG = string.Format("exec InfoNhanHang_CMNDNG @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(CMNDNG, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); ntxtCMNDNguoiGui.Text = Com.ExecuteScalar().ToString(); //LayCMNDNguoiNhan string CMNDNN = string.Format("exec InfoNhanHang_CMNDNN @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(CMNDNN, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); ntxtCMNDNguoiNhan.Text = Com.ExecuteScalar().ToString(); //LaySDTNguoiGui string SDTNG = string.Format("exec InfoNhanHang_SDTNG @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(SDTNG, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); ntxtSDTNguoiGui.Text = Com.ExecuteScalar().ToString(); //LaySDTNguoiNhan string SDTNN = string.Format("exec InfoNhanHang_SDTNN @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(SDTNN, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); ntxtSDTNguoiNhan.Text = Com.ExecuteScalar().ToString(); //LayTenHang string TenHang = string.Format("exec InfoNhanHang_TenHang @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(TenHang, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtTenHang.Text = Com.ExecuteScalar().ToString(); //LayTrongLuong string trongluong = string.Format("exec InfoNhanHang_TrongLuong @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(trongluong, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); ntxtTrongLuong.Text = Com.ExecuteScalar().ToString(); //LayKichThuoc string KichThuoc = string.Format("exec InfoNhanHang_KichThuoc @IdHangHoa , @IdChuyen"); //Gọi Proc Com = new SqlCommand(KichThuoc, Con); Com.Parameters.Add(new SqlParameter("@IdHangHoa", IdHangHoa)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtKichThuoc.Text = Com.ExecuteScalar().ToString(); //LayLoTrinh string LoTrinh = string.Format("exec InfoNhanHang_LoTrinh @IdChuyen"); //Gọi Proc Com = new SqlCommand(LoTrinh, Con); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); CBChuyenTu_Den.Text = Com.ExecuteScalar().ToString(); //LayDiemGui string DiemGui = string.Format("exec InfoNhanHang_DiemGui @IdChuyen"); //Gọi Proc Com = new SqlCommand(DiemGui, Con); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtChoGui.Text = Com.ExecuteScalar().ToString(); //LayDiemNhan string DiemNhan = string.Format("exec InfoNhanHang_DiemNhan @IdChuyen"); //Gọi Proc Com = new SqlCommand(DiemNhan, Con); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtChoNhan.Text = Com.ExecuteScalar().ToString(); //LayNgayChay string NgayChay = string.Format("exec InfoNhanHang_NgayChay @IdChuyen"); //Gọi Proc Com = new SqlCommand(NgayChay, Con); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtNgayDi.Text = Com.ExecuteScalar().ToString(); //LayGioDi string GioDi = string.Format("exec InfoNhanHang_Gio @IdChuyen "); //Gọi Proc Com = new SqlCommand(GioDi, Con); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtGioDi.Text = Com.ExecuteScalar().ToString(); Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void ShowInfoKhachHang() { string IdVe = IdVe_FormMain; string IdChuyen = IdChuyen_FormMain; try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); //Lấy Tên string Ten = string.Format("exec ShowInfoKhachHang_Ten @IdChuyen, @IdVe"); //Gọi Proc SqlCommand Com = new SqlCommand(Ten, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtTen.Text = Com.ExecuteScalar().ToString(); //LayCMND string CMND = string.Format("exec ShowInfoKhachHang_CMND @IdChuyen,@IdVe"); //Gọi Proc Com = new SqlCommand(CMND, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); ntxtCMND.Text = Com.ExecuteScalar().ToString(); //QueQuan string Que = string.Format("exec ShowInfoKhachHang_Que @IdChuyen,@IdVe"); //Gọi Proc Com = new SqlCommand(Que, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); DynamicCBOXQueQuan.Text = Com.ExecuteScalar().ToString(); //LaySDT string SDT = string.Format("exec ShowInfoKhachHang_SDT @IdChuyen, @IdVe"); //Gọi Proc Com = new SqlCommand(SDT, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); ntxtSDT.Text = Com.ExecuteScalar().ToString(); //LayNgaySinh string NgaySinh = string.Format("exec ShowInfoKhachHang_NgaySinh @IdChuyen ,@IdVe"); //Gọi Proc Com = new SqlCommand(NgaySinh, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); dateTimePicker1.Text = Com.ExecuteScalar().ToString(); //LayGiaTien string Tien = string.Format("exec ShowInfoKhachHang_Tien @IdChuyen, @IdVe"); //Gọi Proc Com = new SqlCommand(Tien, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); TextBoxGiaTien.Text = Com.ExecuteScalar().ToString(); //LayNgay string Ngay = string.Format("exec ShowInfoKhachHang_NgayDi @IdChuyen, @IdVe"); //Gọi Proc Com = new SqlCommand(Ngay, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtNgayDi.Text = Com.ExecuteScalar().ToString(); //LayGio string Gio = string.Format("exec ShowInfoKhachHang_GioDi @IdChuyen , @IdVe"); //Gọi Proc Com = new SqlCommand(Gio, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); txtGioDi.Text = Com.ExecuteScalar().ToString(); //LayLoTrinh string LoTrinh = string.Format("exec ShowInfoKhachHang_LoTrinh @IdChuyen,@IdVe"); //Gọi Proc Com = new SqlCommand(LoTrinh, Con); Com.Parameters.Add(new SqlParameter("@IdVe", IdVe)); Com.Parameters.Add(new SqlParameter("@IdChuyen", IdChuyen)); CBChuyenTu_Den.Text = Com.ExecuteScalar().ToString(); Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }
private void LayThongTin(string MaNV) { try { SqlConnection Con = KetNoiCSDL.KetNoiSQL(); Con.Open(); //Lấy Tên string Ten = string.Format("select nv.TenNhanVien from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc SqlCommand Com = new SqlCommand(Ten, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); txtTen.Text = Com.ExecuteScalar().ToString(); //LayKinhNghiem string KinhNghiem = string.Format("select nv.KinhNghiem from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc Com = new SqlCommand(KinhNghiem, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); txtKinhNghiem.Text = Com.ExecuteScalar().ToString(); //LayNgaySinh string NgaySinh = string.Format("select nv.NgaySinh from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc Com = new SqlCommand(NgaySinh, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); txtNgaySinh.Value = Convert.ToDateTime(Com.ExecuteScalar()); //LayGioiTinh string sex = string.Format("select nv.GioiTinh from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc Com = new SqlCommand(sex, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); if (Com.ExecuteScalar().ToString() == "Nam") { rdNam.Checked = true; } else { rdNu.Checked = true; } //LaySDT string SDT = string.Format("select nv.SDT from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc Com = new SqlCommand(SDT, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); txtSDT.Text = Com.ExecuteScalar().ToString(); //LayDiaChi string DiaChi = string.Format("select nv.DiaChi from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc Com = new SqlCommand(DiaChi, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); txtDiaChi.Text = Com.ExecuteScalar().ToString(); //LayhrsChay string h_Chay = string.Format("select nv.SoGioDaChay from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc Com = new SqlCommand(h_Chay, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); txtSohChay.Text = Com.ExecuteScalar().ToString(); //LayLoaiNV string LoaiNV = string.Format("select nv.LoaiNV from NhanVien nv where nv.MaNhanVien=@MaNV"); //Gọi Proc Com = new SqlCommand(LoaiNV, Con); Com.Parameters.Add(new SqlParameter("@MaNV", MaNV)); LoaiNhanVien = Com.ExecuteScalar().ToString(); txtLoaiNV.Text = TenLoaiNV(Com.ExecuteScalar().ToString()); Con.Close(); } catch (Exception EX) { MetroFramework.MetroMessageBox.Show(this, EX.Message); } }