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