private void GlEditDanhMucCP()//Danh muc ky chi phi { ketnoi Connect = new ketnoi(); glMasp.Properties.DataSource = Connect.laybang("select id_z,masp,tenloai,Macp from tblz_dmchiphi"); glMasp.Properties.DisplayMember = "id_z"; glMasp.Properties.ValueMember = "id_z"; glMasp.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; glMasp.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; glMasp.Properties.ImmediatePopup = true; Connect.dongketnoi(); }
private void GridLookupTonKho()//Danh mục hàng tồn trong kho { ketnoi Connect = new ketnoi(); gridLookUpEditVatTu.Properties.DataSource = Connect.laybang("select * from tblDM_VATLIEUPHU"); gridLookUpEditVatTu.Properties.DisplayMember = "Mavlphu"; gridLookUpEditVatTu.Properties.ValueMember = "Mavlphu"; gridLookUpEditVatTu.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; gridLookUpEditVatTu.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; gridLookUpEditVatTu.Properties.ImmediatePopup = true; Connect.dongketnoi(); }
private void List_TienDoTong() { ketnoi kn = new ketnoi(); gridControl2.DataSource = kn.laybang(@"select idsp,madh,mabv,sanpham,Ten_ct,soluongyc,tonkho,soluongsx, isnull(BTPT16,0)-isnull(soluongsx,0) as CONLAI,donvi,ngoaiquang,ngaytrienkhai,dayend, BTPT1,BTPT2,BTPT3,BTPT4,BTPT5,BTPT6,BTPT7,BTPT8,BTPT9,BTPT10, BTPT11,BTPT12,BTPT13,BTPT14,BTPT15,BTPT16,BTPT17,BTPT18,BTPT19,BTPT20,BTPT21 from tblchitietkehoach where ngaytrienkhai between '" + dptu_ngay.Value.ToString("yyyy/MM/dd") + "' and '" + dpden_ngay.Value.ToString("yyyy/MM/dd") + "'"); kn.dongketnoi(); }
private void gridlookupPSX()//gridlookup vật tư sử dụng { ketnoi Connect = new ketnoi(); gridLookMavattu.Properties.DataSource = Connect.laybang("select * from tblDM_VATTU order by Ngaylap desc"); gridLookMavattu.Properties.DisplayMember = "Ma_vl"; gridLookMavattu.Properties.ValueMember = "Ma_vl"; gridLookMavattu.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; gridLookMavattu.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; gridLookMavattu.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(); }
private void LOAD_PRINT_PHIEUGH() { DataTable dt = new DataTable(); ketnoi kn = new ketnoi(); dt = kn.laybang("select * from tbl01 where MaGH like N'" + txtMagiaohang.Text + "'"); XRPGH_NOIBO XtrGIAOHANG = new XRPGH_NOIBO(); XtrGIAOHANG.DataSource = dt; XtrGIAOHANG.DataMember = "Table"; XtrGIAOHANG.ShowPreviewDialog(); kn.dongketnoi(); }
private void BaoCaoChiPhiNhanVien() { ketnoi kn = new ketnoi(); gridControl5.DataSource = kn.laybang(@"SELECT NhanVienID,HoTen,Sothe,ChiPhiNhanVien,NoiDungViPham,SBB,SoNcr, KhongPhuHop,HinhThucXuLy FROM tblNCR R INNER JOIN NcrNhanVien N ON R.NcrID=N.NcrID where NgayLap between '" + dpChiPhiNhanVienTu.Value.ToString("MM/dd/yyyy") + "' and '" + dpChiPhiNhanVienDen.Value.ToString("MM/dd/yyyy") + "'"); kn.dongketnoi(); gridView6.ExpandAllGroups(); }
private void DocDanhSachDinhMuc() { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"select id,Masp,Tensp,Macongdoan, Tencondoan,Dinhmuc,Macv,HeSoDinhMuc, NguyenCong, Dongia_CongDoan, NguoiHC_CV, NgayHC_CV from tblDMuc_LaoDong"); kn.dongketnoi(); gridView1.Columns["Tensp"].GroupIndex = 0; gridView1.ExpandAllGroups(); }
private void DocNCRMoi() { ketnoi kn = new ketnoi(); gridControl2.DataSource = kn.laybang(@"select Top 0 cast(NgayLap as date)NgayLap,SoNcr='',SBB='', KhongPhuHop='',NguyenNhan='',KhacPhuc='',PhongNgua='', CaiTien='',KetQua='',GhiChu='',SoNcr='',NguoiLap='',HinhThucXuLy='', cast(NgayPhaiHoanThanh as date) NgayPhaiHoanThanh, cast(NgayGiamSat as date) NgayGiamSat,ThoaMan='', KhongThoaMan='',NcrMoi='' from tblNCR"); kn.dongketnoi(); }
private void DocChiPhiNhanVien() { ketnoi kn = new ketnoi(); gridControl4.DataSource = kn.laybang(@"select NcrNhanVienID, Sothe,HoTen,NcrID,NhanVienID ID, ChiPhiNhanVien,NoiDungViPham from NcrNhanVien where NcrID = " + txtNcrID.Text + ""); kn.dongketnoi(); this.gridView4.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; }
private void list_nhatky()//Danh sách z khởi tạo trọng tháng { ketnoi kn = new ketnoi(); gridControl2.DataSource = kn.laybang("select nk.*,dt.Maz,dt.z_tong,kb.tenz,dt.dm_vlchinh,dt.dm_vlphu,kb.masp,kh.tenkh, " + " dt.dm_nctt,dt.cp_sxchung,dt.cp_bhang,dt.cp_quanly,dt.cp_khuon,kygia " + " from tblz_nhatky nk left outer join " + " tblz_doitongtaphopchiphi dt on nk.idKygia=dt.id left outer join " + " tblz_khaibao kb on dt.Maz=kb.maz left outer join tblz_khachhang kh on nk.id_khach=kh.makh where convert(date,nk.ngaylap,101) between '" + dptu_ngay.Value.ToString("yyyy/MM/dd") + "' " + " and '" + dpden_ngay.Value.ToString("yyyy/MM/dd") + "'"); kn.dongketnoi(); }
private void GlEdiKhachHang()//Danh mục đối tượng tính z { ketnoi Connect = new ketnoi(); cbMakhachhang.Properties.DataSource = Connect.laybang("select * from tblz_khachhang"); cbMakhachhang.Properties.DisplayMember = "makh"; cbMakhachhang.Properties.ValueMember = "makh"; cbMakhachhang.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; cbMakhachhang.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; cbMakhachhang.Properties.ImmediatePopup = true; Connect.dongketnoi(); }
private void DocChiTietCungLoaiTam() { ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select ''DonVi,''MaLapGhep,MaChiTiet, TenChiTiet,SoLuongChiTiet, VatLieuChiTiet,MaSanPham from TempApMaChiTiet" , grlSanPham.Text); grcChiTiet.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); }
private void LOOUP_SANPHAM()//LooupEdit mã sản phẩm từ đặc điểm khuôn { DataTable Table = new DataTable(); ketnoi Connect = new ketnoi(); LookupCheck_Masp.Properties.DataSource = Connect.laybang("select Masp,Ma_khuon,Ten_khuon,Dacdiem_khuon from tblDM_KHUON where Dacdiem_khuon like N'" + txtDacdiem_khuon.Text + "'"); LookupCheck_Masp.Properties.DisplayMember = "Masp"; LookupCheck_Masp.Properties.ValueMember = "Masp"; LookupCheck_Masp.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; LookupCheck_Masp.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; LookupCheck_Masp.Properties.ImmediatePopup = true; }
private void TheHienToThucHien() { repositoryItemComboBox1.Items.Clear(); ketnoi kn = new ketnoi(); var dt = kn.laybang(@"select ToThucHien from tblResources"); for (int i = 0; i < dt.Rows.Count; i++) { repositoryItemComboBox1.Items.Add(dt.Rows[i]["ToThucHien"]); } kn.dongketnoi(); }
private void btnPrintBaoCaoTre_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); ketnoi kn = new ketnoi(); dt = kn.laybang(@"select * from viewDonHangTre where IDSP like '" + txtIDSP.Text + "'"); RpDonHangTre rpDonHangTre = new RpDonHangTre(); rpDonHangTre.DataSource = dt; rpDonHangTre.DataMember = "Table"; rpDonHangTre.ShowPreviewDialog(); }
private void BtnXuatPhieu_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); ketnoi kn = new ketnoi(); dt = kn.laybang("select * from ViewXuatKho_Gia where MaGH like N'" + txtMaphieu.Text + "' "); XRGIAXUAT XRXUATKHO_GIA = new XRGIAXUAT(); XRXUATKHO_GIA.DataSource = dt; XRXUATKHO_GIA.DataMember = "Table"; XRXUATKHO_GIA.ShowPreviewDialog(); }
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 btnDocDonHangTre_Click(object sender, EventArgs e) { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"SELECT IdPSX,IDSP,DanhGia,mabv,madh,SPLR,sanpham,soluongyc,BTPT11, KetThucTo11,AllProgress,STATUS,ngoaiquang FROM PHANTICH_CHUNG WHERE STATUS =N'Trễ' or STATUS =N'Đỏ'"); kn.dongketnoi(); this.gridView1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.RowSelect; this.gridView1.Appearance.Row.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; }
private void GlDMGianguyenlieu()//Danh mục định mức giá vật liệu sử dụng { ketnoi Connect = new ketnoi(); glMavatlieu.Properties.DataSource = Connect.laybang("select * from tblz_danhmucgiavatlieu"); glMavatlieu.Properties.DisplayMember = "Madongiavl"; glMavatlieu.Properties.ValueMember = "Madongiavl"; glMavatlieu.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; glMavatlieu.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; glMavatlieu.Properties.ImmediatePopup = true; Connect.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(); }
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(); }
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(); }
public void LoadDataVattu() { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang("SELECT CodeVatllieu,Iden,madh,Codedetail " + ", Tenquicachsp, Soluongsanpham, Donvi_sanpham, Ten_vattu " + ", SL_vattucan, KL_vattucan, SL_vattutonkho, KL_vattutonkho, SL_vattumua, KL_vattumua " + ", Donvi_vattu, NCC, NguoiGD, Dongia, Donviquydoi, Ngaydat_vattu, NgayDK_ve, Ngayve_TT, " + "SL_vattuve, KL_vattuve, SL_tinhgia, Dvt_gia, Ghichu_dathangmua, Ghichu_denghimua, " + "DK_TCmua, VAT, quyetdinh, nhanviendathang, nguoikiemkho, ngaykiemkho, nguoinhap, ngaynhap " + " FROM dbo.tblvattu_dauvao"); }
private void LOAD_TRE() { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"select PT.*,VT.Thucnhap,VT.Ngaynhap,Ten_vattu from (select madh+mabv Ma_PT,* from PHANTICH_TIENDO07) PT left outer join (select Madh+Masp Ma_VT,Thucnhap,Ngaynhap,Ten_vattu from PHANTICH_TIENDOVATTU) VT on PT.Ma_PT=VT.Ma_VT where Ma_PT is not null and Ma_VT is not null and PT.STATUS <> 'HOAN THANH'"); gridView1.ExpandAllGroups(); }
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 LookupGrid() { ketnoi kn = new ketnoi(); DataTable dt = new DataTable(); dt = kn.laybang("select Ma_Nguonluc,Ten_Nguonluc from tblResources"); List <tblDelivery_Dtl> details = new List <tblDelivery_Dtl>(); details = Utils.ConvertDataTable <tblDelivery_Dtl>(dt); gridControl2.DataSource = new BindingList <tblDelivery_Dtl>(details); gridControl2.DataSource = dt; kn.dongketnoi(); }
private void DocDSSanPham() { ketnoi kn = new ketnoi(); grcSanPham.DataSource = kn.laybang(@"select case when m.MaSanPham is not null then 'x' end DaApMa,Code,Masp,Tensp, Hotennv,Ngaylap from tblSANPHAM s left outer join (select MaSanPham from SanPhamKhuon group by MaSanPham)m on s.Masp=m.MaSanPham order by Ngaylap Desc" ); kn.dongketnoi(); }
private void LOAD_TIME() { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"select PT.*,VT.Thucnhap,VT.Ngaynhap,Ten_vattu from (select madh+mabv Ma_PT,* from PHANTICH_TIENDO07) PT left outer join (select Madh+Masp Ma_VT,Thucnhap,Ngaynhap,Ten_vattu from PHANTICH_TIENDOVATTU) VT on PT.Ma_PT=VT.Ma_VT where Ma_PT is not null and Ma_VT is not null and convert(Date,PT.ngaytrienkhai,103) between '" + dptu_ngay.Value.ToString("yyyy/MM/dd") + "' and '" + dpden_ngay.Value.ToString("yyyy/MM/dd") + "'"); kn.dongketnoi(); gridView1.ExpandAllGroups(); }
private void txtidentitysanpham_TextChanged(object sender, EventArgs e)//BẮT SỰ IỆN THAY ĐỔI SỐ TEXT IDEN SẢN PHẨM VIEW VẬT LIỆU CHI TIẾT { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang("SELECT Donviquydoi,CodeVatllieu,Iden,madh,Codedetail " + ", Tenquicachsp, Soluongsanpham, Donvi_sanpham, Ten_vattu " + ", SL_vattucan, KL_vattucan, SL_vattutonkho, KL_vattutonkho, SL_vattumua, KL_vattumua " + ", Donvi_vattu, NCC, NguoiGD, Dongia, Donviquydoi, Ngaydat_vattu, NgayDK_ve, Ngayve_TT, " + "SL_vattuve, KL_vattuve, SL_tinhgia, Dvt_gia, Ghichu_dathangmua, Ghichu_denghimua, " + "DK_TCmua, VAT, quyetdinh, nhanviendathang, nguoikiemkho, ngaykiemkho, nguoinhap, ngaynhap,fax,NVKD,Kiemkho " + " FROM dbo.tblvattu_dauvao where Iden like '" + txtIden.Text + "'"); kn.dongketnoi(); }