private void HienThiPhongBanChiTiet() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select To_bophan from tblPHONGBAN where PhanTichTienDo is not null"); cbTheHienBoPhanChiTiet.DataSource = kn.laybang(sqlQuery); cbTheHienBoPhanChiTiet.DisplayMember = "To_bophan"; cbTheHienBoPhanChiTiet.ValueMember = "To_bophan"; kn.dongketnoi(); }
private void ShowReceiveMadeProduction() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select * from TrienKhaiKeHoachSanXuatGiaoNhanChiTiet where PointSave like '{0}'" , pointsave); grGiaoNhanHangHoaCacTo.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); gvGiaoNhanHangHoaCacTo.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
private void DanhMucSanPham() { ketnoi Connect = new ketnoi(); gridLookUpEditSanPham.Properties.DataSource = Connect.laybang(@"select Code,Masp,Tensp from tblSANPHAM"); gridLookUpEditSanPham.Properties.DisplayMember = "Masp"; gridLookUpEditSanPham.Properties.ValueMember = "Masp"; gridLookUpEditSanPham.Properties.NullText = null; Connect.dongketnoi(); }
private void TheHienGiaoHangTheoNgay() { ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select * from {0}('{1}','{2}')", functionPhanTich, dpTu.Value.ToString("MM-dd-yyyy"), dpDen.Value.ToString("MM-dd-yyyy")); grPhanTichTienDo.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); }
private void DocToanBoLichSanXuat() { string donHangID = UC_THEMDONHANG.donHangID; ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select * from viewCHITIET_BPSX where cast(NgayGhiKeHoach as date) between '{0}' and '{1}'", dptungay.Value.ToString("MM-dd-yyyy"), dpdenngay.Value.ToString("MM-dd-yyyy")); gridControl1.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); }
private void TheHienDanhSachSanPham() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select s.Masp,Tensp from tblSANPHAM s inner join tblSANPHAM_CT c on s.Code=c.SanPhamID"); cbMaSanPham.Properties.DataSource = kn.laybang(sqlQuery); cbMaSanPham.Properties.DisplayMember = "Masp"; cbMaSanPham.Properties.ValueMember = "Masp"; kn.dongketnoi(); }
private void TheHienDanhSachChiTietCungLoai() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select Mact MaLoai, Ten_ct TenLoai,Soluong_CT SoLuong, Chatlieu_chitiet DienGiai,DonVi from tblSANPHAM_CT where Masp like N'{0}'", cbMaSanPham.Text); grChildTreeList.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); }
private void TheHienCongDoanTuongTu() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select MaLoai,TenCong Ten_Nguonluc,DinhMucCongDoan Dinhmuc,ToThucHien, ''ThuTu,SoChiTiet,DienGiai,SoChiTiet,MaCong Ma_Nguonluc,''DonVi from tblSanPhamTreeList where MaSanPham like '{0}' and MaCong <>''" , cbMaSanPham.Text); grChildTreeList.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); gvChildTreeList.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
private void TheHienDanhSachTheoSanPhamID() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select Mact MaLoai, Ten_ct TenLoai,Soluong_CT SoLuong, Chatlieu_chitiet DienGiai,DonVi from tblSANPHAM_CT where SanPhamID like N'{0}'", txtIDSanPham.Text); grChildTreeList.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); gvChildTreeList.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
private void DocToGiaoDen() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select ToThucHien from TrienKhaiKeHoachSanXuat where IDChiTietDonHang like '{0}' and ToThucHien <>'' group by ToThucHien", idchitietdonhang, txtToThucHien.Text); cbToGiaoDen.DataSource = kn.laybang(sqlQuery); cbToGiaoDen.DisplayMember = "ToThucHien"; cbToGiaoDen.ValueMember = "ToThucHien"; kn.dongketnoi(); }
private void DocTatCaDonDatHang() { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"select V.Iden TrangThai,P.MaSP maDinhMucDonVi,C.* from tblDHCT C left outer join(select distinct(Iden) from tblvattu_dauvao) V on C.Iden=V.Iden left outer join (select distinct (MaSP) from DinhMucVatTu where Masp <>'') P on P.MaSP=C.MaSP order by Code Desc" ); kn.dongketnoi(); }
private void DocDonDatHangTheoNgay() { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"select V.Iden TrangThai,P.MaSP maDinhMucDonVi,C.* from tblDHCT C left outer join(select distinct(Iden) from tblvattu_dauvao) V on C.Iden=V.Iden left outer join (select distinct (MaSP) from DinhMucVatTu where Masp <>'') P on P.MaSP=C.MaSP where convert( datetime,thoigianthaydoi) between '" + dpDonHangTKTu.Value.ToString("yyyy/MM/dd") + "' and '" + dpDonHangTKDen.Value.ToString("yyyy/MM/dd") + "' order by Code Desc"); kn.dongketnoi(); }
private void DocNhatKyCongViec() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select * from tblNHATKYCD_test where HoTen like N'{0}' and NgayLam like '{1}' order by ID Desc" , lookHoTenNhanVien.Text, dpNgayLam.Value.ToString("yyyy-MM-dd")); grNhatKyCongViec.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); gvNhatKyCongViec.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
private void New_Category_Resource()//Tạo mới DanhSach Nguồn lực { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"select ResourceID,Ma_Nguonluc,Ten_Nguonluc, date01='',date02='',date03='',date04='',date05='',date06='',date07='',date08='' ,date09='',date10='',date11='',date12='',date13='',date14='',date15='',date16='', date17='',date18='',date19='',date20='',date21='' ,date22='',date23='',date24='',date25='',date26='', date27='',date28='',date29='',date30='',date31='' from tblResources"); kn.dongketnoi(); }
private void TraCuuXuatKho_Click(object sender, EventArgs e) { ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select * from tblchitietkehoach where ngay11 between '{0}' and '{1}' order by ngaytrienkhai desc,IDSP asc", dpTu.Value.ToString("MM-dd-yyyy"), dpDen.Value.ToString("MM-dd-yyyy")); grcBaoCaoSanLuong.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); }
private void DocDonHangHoanThanhSanLuong() { ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select * from tblchitietkehoach where ngaytrienkhai between '{0}' and '{1}' order by ngaytrienkhai desc,IDSP asc", dpTu.Value.ToString("MM-dd-yyyy"), dpDen.Value.ToString("MM-dd-yyyy")); grcBaoCaoSanLuong.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); }
private void DocNguyenCongTheoNgay() { ketnoi kn = new ketnoi(); gridControl4.DataSource = kn.laybang(@"select ChiTietSanPham, SoChiTietSanPham,Masp,Tensp,NguyenCong, Tencondoan,Dinhmuc,id, NguoiHC_CV,NgayHC_CV,TrungCongDoan from tblDMuc_LaoDong cast(NgayHC_CV as Date) between '" + dpnguyenCong_BD.Value.ToString("MM-dd-yyyy") + "' and '" + dpnguyenCong_KT.Value.ToString("MM-dd-yyyy") + "'"); kn.dongketnoi(); }
private void DocNguyenCong() { ketnoi kn = new ketnoi(); gridControl4.DataSource = kn.laybang(@"select ChiTietSanPham, SoChiTietSanPham,SoChiTiet,TrungCongDoan,NguyenCong, Masp,Tensp,NguyenCong,Tencondoan,Dinhmuc,id from tblDMuc_LaoDong where Masp ='" + txtMaSanPham.Text + "'"); kn.dongketnoi(); gridView4.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
private void DocDSSanPham() { ketnoi kn = new ketnoi(); gridControl2.DataSource = kn.laybang( @"select C.MaSP maDinhMuc,Code,P.Masp,Tensp from tblSANPHAM P left outer join (select distinct (MaSP) from DinhMucVatTu where Masp <>'')C on P.MaSP=C.MaSP order by Code DESC"); kn.dongketnoi(); }
private void CagoryMaterial() { ketnoi cn = new ketnoi(); gridControl5.DataSource = cn.laybang(@"select * from tblDM_VATLIEUPHU order by Ngaylap DESC,Tenvlphu ASC"); cn.dongketnoi(); gridView5.OptionsView.ShowAutoFilterRow = true; }
private void TheHienCongDoanMacDinh() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format( @"select '{0}'+'/CD00' MaLoai,Ten_Nguonluc,''DinhMuc,ToThucHien,ThuTu, '1' SoChiTiet,''DienGiai,Ma_Nguonluc,''DonVi from tblResources where ResourceID in (45,34,42,52,23,47) order by ThuTu ASC" , txtMaCha.Text); grChildTreeList.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); gvChildTreeList.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
private void DocKhoanLuongQuanLyChiTiet() { ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select T.*,C.madh MaDonHang, C.Soluong*T.SoChiTiet SoLuongCongDoan from KhoanLuongQuanLy_ChiTiet T left outer join tblDHCT C on T.IDDonHang=C.Iden"); gridControl1.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); }
private void CapNhatSoLuongTong()//tổng cộng số lượng chi tiết ghi vào sổ kế hoạch triển khai - TrienKhaiKeHoachSanXuat { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"update TrienKhaiKeHoachSanXuat set SoLuongGiao = g.SoGiao,NgayGiao=g.NgayGiao from (select IDTrienKhai,max(NgayGiao)NgayGiao,sum(SoGiao)SoGiao from TrienKhaiKeHoachSanXuatGiaoNhanChiTiet group by IDTrienKhai)g inner join TrienKhaiKeHoachSanXuat t on t.IDTrienKhai=g.IDTrienKhai where g.IDTrienKhai like '{0}'" , idtrienkhai); kn.dongketnoi(); }
private void DocDSSanPham() { ketnoi kn = new ketnoi(); gridControl1.DataSource = kn.laybang(@"select madh,MaPo,Tenquicach,MaSP,Mau_banve, Soluong,t.DaGiao,dvt,ngaygiao,ngoaiquang,ghichu,nguoithaydoi from tblDHCT c, (select IdPSX,max(BTPT11)DaGiao from PHANTICH_TIENDO11 where STATUS <>'HOAN THANH' group by IdPSX)t where c.Iden=t.IdPSX"); kn.dongketnoi(); }
private void DocDSKhungThoiGianLamViec() { ketnoi kn = new ketnoi(); grKhungThoiGianLamViec.DataSource = kn.laybang(@"select * from tblKhungThoiGianLamViec order by ID desc"); kn.dongketnoi(); this.gvKhungThoiGianLamViec.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; gvKhungThoiGianLamViec.OptionsSelection.CheckBoxSelectorColumnWidth = 20; this.gvKhungThoiGianLamViec.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None; }
private void DocDSBaoCaoNgayTheoNgay() { ketnoi kn = new ketnoi(); string sqlStr = string.Format( @"select * from BaoCaoSanXuatNgay where NgaySanXuat between '{0}' and '{1}'" , dpTu.Value.ToString("MM-dd-yyyy"), dpDen.Value.ToString("MM-dd-yyyy")); grcBaoCaoNgay.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); }
private void TheHienDanhSachCongDoanTheoSanPhamID() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format( @"select Macongdoan MaLoai,Tencondoan TenLoai,Dinhmuc, Tothuchien ToThucHien,''ThuTu,SoChiTiet, ''DienGiai,SoChiTiet,NguyenCong,''DonVi from tblDMuc_LaoDong where SanPhamID like N'{0}'", txtIDSanPham.Text); grChildTreeList.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); gvChildTreeList.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
//Thể hiện danh sách tổ thực hiện private void ShowDeparment() { repositoryItemCBDepartment.Items.Clear(); ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select ToThucHien from tblResources"); var data = kn.laybang(sqlQuery); for (int i = 0; i < data.Rows.Count; i++) { repositoryItemCBDepartment.Items.Add(data.Rows[i]["ToThucHien"]); } kn.dongketnoi(); }
private void TheHienDanhSachCongDoanMoi() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select top 0 '{0}'+'/CD00' MaLoai, Ten_Nguonluc TenLoai,''DinhMuc,ToThucHien,ThuTu, '1' SoChiTiet,''DienGiai,Ma_Nguonluc NguyenCong,N'Cái' DonVi from tblResources order by ThuTu ASC" , txtMaCha.Text); grChildTreeList.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); gvChildTreeList.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
void list_store_input_slip()//Danh sach nhập kho { ketnoi cn = new ketnoi(); gridControl2.DataSource = cn.laybang(@"select id,Manhap,Ngaynhap,Mavlphu,Tenvlphu, Donvi,Soluong,Dongia,Thanhtien, Nguoigiao,Diengiai,Nguoinhan,Noinhan, Nhaptam,XuatTT,LoaiNV, Nguoilap,DoiTuongCungCap,Ngayghi from tblNHAP_VATLIEUPHU where Manhap !='' and Ngaynhap between '" + dpStar_store_input.Value.ToString("MM/dd/yyyy") + "' and '" + dpEnd_store_input.Value.ToString("MM/dd/yyyy") + "' order by Ngaynhap ASC"); cn.dongketnoi(); }