private void DocChiPhiDonHang()
{
ketnoi kn = new ketnoi();
gridControl3.DataSource = kn.laybang(@"select NcrDatHangID,NcrID,
DonHangID Iden,ChiPhiDonHang,Thongtin,Kg,Cai from
NcrDatHang where NcrID=" + txtNcrID.Text + "");
kn.dongketnoi();
this.gridView3.OptionsSelection.MultiSelectMode
= DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
}
private void DocNguyenCong()
{
ketnoi kn = new ketnoi();
gridControl2.DataSource = kn.laybang(@"select Masp,Tensp,NguyenCong,Tothuchien,
Tencondoan,HeSoDinhMuc,Dongia_CongDoan,
Dinhmuc,id,NguoiHC_CV,NgayHC_CV
from tblDMuc_LaoDong");
kn.dongketnoi();
gridView2.ExpandAllGroups();
}
private void DocDSNguonLuc()//GridlookupEdit Repository chọn mã nguồn lực trong gridcontrol Áp mã nguồn lực
{
ketnoi Connect = new ketnoi();
repository.DataSource = Connect.laybang(@"SELECT Ma_Nguonluc,
Ten_Nguonluc,Nguoi,Ngay FROM tblResources");
repository.DisplayMember = "Ma_Nguonluc";
repository.ValueMember = "Ma_Nguonluc";
repository.NullText = null;
Connect.dongketnoi();
}
private void DanhSachSanPham()
{
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"select Code,SP.Masp,Tensp,Hotennv,
SP.Ngaylap,NC.MaSP NguyenCong from tblSANPHAM SP
left outer join (select MaSP from NguyenCong group by MaSP) NC
on SP.Masp=NC.MaSP
ORDER BY Code DESC" );
kn.dongketnoi();
}
private void DocTatCaDSSanPham()
{
ketnoi kn = new ketnoi();
grDanhMucSanPham.DataSource = kn.laybang(@"select check1,check2,Case when ISNUMERIC (right(Masp,4)) >0 then right(Masp,4)
end TT, Masp, Tensp, Kichthuoc, Vatlieu,
Dacdiem, Ngaylap, KH.MKH, KH.TenKH, sp.manv,
hotennv, Code from tblSANPHAM SP left outer join tblKHACHHANG KH
on SP.Makh = KH.MKH ORDER BY TT DESC");
kn.dongketnoi();
}
public void DocDSSanPhamTheoNgay()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select check1,check2,Masp,Tensp,Kichthuoc,Vatlieu,
Dacdiem, Ngaylap, KH.MKH, KH.TenKH, sp.manv, hotennv,Code
from tblSANPHAM SP left outer join tblKHACHHANG KH
on SP.Makh = KH.MKH");
grDanhMucSanPham.DataSource = kn.laybang(sqlQuery);
kn.dongketnoi();
}
private void btnTongSLXuatKho_Click(object sender, EventArgs e)
{
ketnoi kn = new ketnoi();
gridControl4.DataSource = kn.laybang(@"select T11.*,PT.KetThucTo11,PT.tyle from tbl11 T11 left outer join
PHANTICH_TIENDO11 PT on T11.IDSP=PT.IDSP where
ngaynhan between '" + dpTu.Value.ToString("yyyy/MM/dd") + "' and '" + dpDen.Value.ToString("yyyy/MM/dd") + "'");
kn.dongketnoi();
gridView5.Columns["MaGH"].GroupIndex = 0;
gridView5.ExpandAllGroups();
}
private void BanHangDanhMuc()
{
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"select BanHangID,DatHangID,
DonHangID,MaDH,SoLuongDonHang,Dongia,
ThanhTien,MaSP,TenGoiNhaMay,MaSPKhachHang,TenGoiKhachHang,
MaPO,NgayTao,NguoiTao,NguoiHC,NgayHC from BanHang where NgayTao between '" + dptu_ngay.Value.ToString("yyyy/MM/dd") + "' and '" + dpden_ngay.Value.ToString("yyyy/MM/dd") + "'");
kn.dongketnoi();
gridView1.Columns["DatHangID"].GroupIndex = -1;
}
private void UcKHUON_CATDAY_Load(object sender, EventArgs e)
{
ketnoi kn = new ketnoi();
txtuser.Text = Login.Username;
cbmanhom_khuon.DataSource = kn.laybang("select Manhom_khuon from tblDMNHOM_KHUON");
cbmanhom_khuon.DisplayMember = "Manhom_khuon";
cbmanhom_khuon.ValueMember = "Manhom_khuon";
kn.dongketnoi();
MaNV(); LayTenKhuon(); Autocomplete_Dacdiemkhuon();
}
void DSToThucHien()
{
ketnoi Connect = new ketnoi();
repositoryItemToThucHien.DataSource = Connect.laybang(@"
select BoPhan from tblPHONGBAN_TK");
repositoryItemToThucHien.DisplayMember = "BoPhan";
repositoryItemToThucHien.ValueMember = "BoPhan";
repositoryItemToThucHien.NullText = null;
Connect.dongketnoi();
}
private void btnTongHopDoanhSo_Click(object sender, EventArgs e)
{
ketnoi kn = new ketnoi();
gridControl2.DataSource = kn.laybang(@"select BanHangID,DatHangID,
DonHangID,MaDH,SoLuongDonHang,Dongia,
ThanhTien,MaSP,TenGoiNhaMay,MaSPKhachHang,TenGoiKhachHang,
MaPO,NgayTao,NguoiTao,NguoiHC,NgayHC from BanHang where NgayTao between '" + dptu_ngay.Value.ToString("yyyy/MM/dd") + "' and '" + dpden_ngay.Value.ToString("yyyy/MM/dd") + "'");
kn.dongketnoi();
gridView2.Columns["DatHangID"].GroupIndex = 0;
}
private void btnTaoMoi_Click(object sender, EventArgs e)
{
ketnoi kn = new ketnoi();
gridControl3.DataSource = kn.laybang(@"select top 1 DatHangID='',DonHangID='',madh='',
Soluong='',dongia='',thanhtien='',MaSP='',Tenquicach='',Masp_KH='',
Tenkhachhang='',MaPO='',thoigianthaydoi='',Thoigian_Thuc='' from tblDHCT");
kn.dongketnoi();
this.gridView3.OptionsView.NewItemRowPosition
= DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Top;
}
void DocDSCongDoan_TheoTen(string Masp)
{
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"
select NguyenCong,Dongia_CongDoan,NguyenCong,SoChiTiet,id,Masp,Tensp,Tencondoan,
Dongia_CongDoan*SoChiTiet Dongia,DonGiaThuongPhanBo,
BoPhanThucHien,TrungCongDoan from tblDMuc_LaoDong where
Masp='" + Masp + "'");
kn.dongketnoi();
}
private void ListQuyTrinhSanPham()//Load Quy trinh
{
ketnoi kn = new ketnoi();
gridControl3.DataSource = kn.laybang("select id,masoqt,ngaybanhanh,QT.masp,SP.Tensp,diengiai,tacnhan, "
+ "nguoilap,ngayghi,KH.TenKH from tblQUYTRINH_SANXUAT QT "
+ "left outer join tblSANPHAM SP on QT.masp=SP.Masp "
+ "left outer join tblKHACHHANG KH on SP.Makh=KH.MKH where ngaybanhanh "
+ " between '" + dptu_ngay.Value.ToString("yyyy/MM/dd") + "' and '" + dpden_ngay.Value.ToString("yyyy/MM/dd") + "' order by id ASC");
kn.dongketnoi();
}
private void ThongTinQADH()
{
ketnoi kn = new ketnoi();
gridControl3.DataSource = kn.laybang("select Ngaytrienkhai,QC,NoidungQC,NgayQC,QA,Donvisp,IDSP, "
+ " CT.IdPSX,CT.nvkd,CT.SPLR,CT.SLSPLR,ngaytrienkhai,CT.madh,CT.LoaiDH,mabv,sanpham,Maubv, "
+ " Mact, Ten_ct, So_CT, ChatlieuCT, soluongyc, tonkho, soluongsx, "
+ " ngoaiquang, donvi, daystar, dayend, MaKH, CT.khachhang, xeploai, Ghichu, CT.MaPo, "
+ " TrangThai, DH.Diengiai from tblchitietkehoach CT left join tblDONHANG DH on CT.madh = DH.madh where CT.madh like N'" + txtMadh.Text + "'");
kn.dongketnoi();
}
private void TaoMoiChiTiet()
{
ketnoi kn = new ketnoi();
string sqlStr = string.Format(@"select top 0 DonVi,MaLapGhep,MaChiTiet,
TenChiTiet,SoLuongChiTiet,
VatLieuChiTiet,MaSanPham
from TempApMaChiTiet" );
grcChiTiet.DataSource = kn.laybang(sqlStr);
kn.dongketnoi();
}
private void BanHangThem()
{
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"select BanHangID,DatHangID,
DonHangID,MaDH,SoLuongDonHang,Dongia,
ThanhTien,MaSP,TenGoiNhaMay,MaSPKhachHang,TenGoiKhachHang,
MaPO,NgayTao,NguoiTao,NguoiHC,NgayHC from BanHang where DatHangID like '" + txtDatHangID.Text + "'");
kn.dongketnoi();
gridView1.Columns["DatHangID"].GroupIndex = -1;
}
private void ntnNew_Click(object sender, EventArgs e)
{
gridView1.OptionsView.NewItemRowPosition =
DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom;
gridView1.OptionsSelection.CheckBoxSelectorColumnWidth = 20;
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"select top 0 ID,BoPhan,MaBoPhan,NguoiLap,
NgayGhi from tblPHONGBAN_TK");
kn.dongketnoi();
}
private void DocPhuKienVatTu()
{
ketnoi kn = new ketnoi();
string sqlStr = string.Format(@"select idPSX,IDSP,sanpham,soluongsx,
HanDen,ToGiaoTruoc,SoHoanThanh
from calenderdp_dauvaohanpat_func()
where Handen is not null and idPSX = '{0}'", this.donHangID);
gridControl1.DataSource = kn.laybang(sqlStr);
kn.dongketnoi();
}
private void DocTatCa()
{
ketnoi kn = new ketnoi();
gridControl2.DataSource = kn.laybang(@"SELECT ID,SanPham,TenKhuon,NgayYC
,ThietKeBD,ThietKeKT,PhoiBD,PhoiKT
,GiaCongBD,GiaCongKT,LapRapBD,LapRapKT,ThuKhuonBD
,ThuKhuonKT,ChinhKhuonBD,ChinhKhuonKT,NgayNghiemThu,KetQua
,GhiChu,NguoiGhi,NgayGhi,NguoiSua,NgaySua FROM dbo.tblCVKhuon
where NgayGhi between '" + dptu_ngay.Value.ToString("yyyy-MM-dd") + "' and '" + dpden_ngay.Value.ToString("yyyy-MM-dd") + "'");
kn.dongketnoi();
}
private void DocCVKhuon()
{
ketnoi kn = new ketnoi();
gridControl2.DataSource = kn.laybang(@"SELECT ID,SanPham,TenKhuon,NgayYC
,ThietKeBD,ThietKeKT,PhoiBD,PhoiKT
,GiaCongBD,GiaCongKT,LapRapBD,LapRapKT,ThuKhuonBD
,ThuKhuonKT,ChinhKhuonBD,ChinhKhuonKT,NgayNghiemThu,KetQua
,GhiChu,NguoiGhi,NgayGhi,NguoiSua,NgaySua FROM dbo.tblCVKhuon
where ketqua is null or KetQua=''");
kn.dongketnoi();
}
private void GridlookupEditSP()//Danh mục xuất nhập tồn kho sản phẩm
{
ketnoi Connect = new ketnoi();
gridLookSanPham.Properties.DataSource = Connect.laybang("select * from tblSanpham_tonkho order by idtpnk desc");
gridLookSanPham.Properties.DisplayMember = "Masp";
gridLookSanPham.Properties.ValueMember = "Masp";
gridLookSanPham.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
gridLookSanPham.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
gridLookSanPham.Properties.ImmediatePopup = true;
Connect.dongketnoi();
}
private void TheHienCauTrucSanPham()
{
ketnoi kn = new ketnoi();
grSanPham.DataSource = kn.laybang(@"select c.Masp,s.Tensp,MaCum,TenCum,
SoLuongCum,Mact,Ten_ct,Soluong_CT,''KichThuc,''GhiChu
from tblSANPHAM_CT c
inner join tblSANPHAM s
on c.SanPhamID=s.Code
where MaCum <>'' and TenCum <>''");
kn.dongketnoi();
}
void DanhSachSanPhamTheoTen(string maSanPham)
{
ketnoi kn = new ketnoi();
gridControl3.DataSource = kn.laybang(@"
select Code,S.Masp,Tensp,
DonGiaThuong,NguoiLapDGThuong,
NgayLapDGThuong,DonGiaThuong,L.Masp DinhMuc from tblSANPHAM S left outer join
(select Masp from tblDMuc_LaoDong group by Masp) L
on S.Masp=L.Masp where S.Masp='" + maSanPham + "' order by Code DESC");
kn.dongketnoi();
}
private void ListDMNCC() //Combobox lấy danh mục nhà cung cấp
{
ketnoi Connect = new ketnoi();
cbNCC.Properties.DataSource = Connect.laybang("select * from tblDM_NCC_VATTU order by Ngaycapnhat_NCC desc ");
cbNCC.Properties.DisplayMember = "Ten_NCC";
cbNCC.Properties.ValueMember = "Ten_NCC";
cbNCC.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
cbNCC.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
cbNCC.Properties.ImmediatePopup = true;
Connect.dongketnoi();
}
private void ListAllQA(object sender, EventArgs e)
{
ketnoi kn = new ketnoi();
gridControl3.DataSource = kn.laybang("select CT.madh+CT.mabv as IdGroup,Ngaytrienkhai,QC,NoidungQC,NgayQC,QA,Donvisp,IDSP,CT.IdPSX,CT.nvkd,CT.SPLR,CT.SLSPLR,ngaytrienkhai,CT.madh,CT.LoaiDH,mabv,sanpham,Maubv, "
+ " Mact, Ten_ct, So_CT, ChatlieuCT, soluongyc, tonkho, soluongsx, "
+ " ngoaiquang, donvi, daystar, dayend, MaKH, CT.khachhang, xeploai, Ghichu, CT.MaPo, "
+ " TrangThai, DH.Diengiai from tblchitietkehoach CT left join tblDONHANG DH on CT.madh = DH.madh where CT.ngaytrienkhai "
+ " between '" + dptu_ngay.Value.ToString("yyyy/MM/dd") + "' and '" + dpden_ngay.Value.ToString("yyyy/MM/dd") + "' order by CT.ngaytrienkhai DESC");
kn.dongketnoi();
gridView3.ExpandAllGroups();
}
void DocDSDonHangXuat_TheoNgay()
{
ketnoi kn = new ketnoi();
gridControl2.DataSource = kn.laybang(@"select T.*,P.DonGiaThuong DaCoGia from
(select min(MaGH)MaGH,cast(min(ngaynhan)as date)ngaynhan,madh,mabv,max(chitietsanpham)sanpham,
max(soluongsx)soluongsx,
sum(BTPT11)BTPT11,sum(BTPT11*DonGiaThuong)TienThuongXuatKho,max(DonGiaThuong)DonGiaThuong
from tbl11 where madh !='' and mabv <>'' group by madh,mabv)T
left outer join tblSANPHAM P on T.mabv=P.Masp where cast(ngaynhan as date) between '" + dptu_ngay.Value.ToString("MM/dd/yyyy") + "' and '" + dpden_ngay.Value.ToString("MM/dd/yyyy") + "'");
kn.dongketnoi();
}
private void BtnList_CongDoan_Click(object sender, EventArgs e)
{
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"select
id,Ngayghi,LD.Masp,LD.Tensp,Macongdoan,Tencondoan,Dinhmuc,
Dongia_CongDoan,Tothuchien,Nguoilap,LD.Ngaylap,Trangthai,LD.DonGia_ApDung,
LD.NgayApDung from tblDMuc_LaoDong LD left outer join tblSANPHAM SP
on LD.Masp=SP.Masp" );
kn.dongketnoi();
gridView1.ExpandAllGroups();
}
private void LOAD_PRINT_PHIEUGH()
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang("select * from tblHanBam where MaGH like N'" + txtMagiaohang.Text + "'");
XRPGH_NOIBO XtrGIAOHANG = new XRPGH_NOIBO();
XtrGIAOHANG.DataSource = dt;
XtrGIAOHANG.DataMember = "Table";
XtrGIAOHANG.ShowPreviewDialog(); kn.dongketnoi();
}
void DocTatCaDSDonHangXuat()
{
ketnoi kn = new ketnoi();
gridControl2.DataSource = kn.laybang(@"select T.*,P.DonGiaThuong DaCoGia from
(select min(MaGH)MaGH,cast(min(ngaynhan)as date)ngaynhan,madh,mabv,max(chitietsanpham)sanpham,
max(soluongsx)soluongsx,
sum(BTPT11)BTPT11,sum(BTPT11*DonGiaThuong)TienThuongXuatKho,max(DonGiaThuong)DonGiaThuong
from tbl11 where madh !='' and mabv <>'' group by madh,mabv)T
left outer join tblSANPHAM P on T.mabv=P.Masp" );
kn.dongketnoi();
}