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 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 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 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 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 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 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(); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { int dong = GridView1.SelectedIndex; ketnoi kn = new ketnoi(); DataTable dt = new DataTable(); dt = kn.laybang("SELECT * FROM TinTuc"); TextBox1.Text = dt.Rows[dong][0].ToString(); TextBox2.Text = dt.Rows[dong][1].ToString(); TextBox3.Text = dt.Rows[dong][2].ToString(); TextBox4.Text = dt.Rows[dong][3].ToString(); }
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 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 TaoMoiChiTiet() { 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}'", txtMaCha.Text); grChildTreeList.DataSource = kn.laybang(sqlQuery); kn.dongketnoi(); }
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 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 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 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 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 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 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; }
void LoadItemMaterial() { ketnoi kn = new ketnoi(); repositoryItem.DataSource = kn.laybang(@"select Mavlphu, Tenvlphu from tblDM_VATLIEUPHU order by Ngaylap desc"); repositoryItem.DisplayMember = "Tenvlphu"; repositoryItem.ValueMember = "Tenvlphu"; repositoryItem.NullText = @"CHỌN TÊN VẬT TƯ"; name_col.ColumnEdit = repositoryItem; }
private void ShowTreListProductionfollowProduction() { ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select * from tblSanPhamTreeList where IDSanPham like '{0}'", txtIDSanPham.Text); treeListProduction.DataSource = kn.laybang(sqlQuery); treeListProduction.ForceInitialize(); treeListProduction.ExpandAll(); //treeListProduction.BestFitColumns(); treeListProduction.OptionsSelection.MultiSelect = true; }
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(); }
private void DocToNhan() { int i = 0; ketnoi kn = new ketnoi(); string sqlQuery = string.Format(@"select ToThucHien from tblResources"); var dt = kn.laybang(sqlQuery); while (i < dt.Rows.Count) { repositoryItemCbBoPhanNhan.Items.Add(dt.Rows[i]["ToThucHien"]); i++; } }
private void DocMaNguyenCongChiTietSanPham() { repositoryItemMaCong2.Items.Clear(); repositoryItemMaCong2.NullText = @"Nguyên công"; ketnoi kn = new ketnoi(); var dt = kn.laybang(@"select Ten_Nguonluc,Ma_Nguonluc from tblResources"); for (int i = 0; i < dt.Rows.Count; i++) { repositoryItemMaCong2.Items.Add(dt.Rows[i]["Ma_Nguonluc"]); } kn.dongketnoi(); }
private void TaoCongDoanMoi() { ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select top 0 id,Tencondoan,Dinhmuc, Tothuchien,NguyenCong,ThuTuCongDoan, SoChiTiet from tblDMuc_LaoDong where Tencondoan <>'' and Dinhmuc <>''"); grcDinhMucCongDoan.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); grDinhMucCongDoan.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }
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; }
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; }
//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 DocToThucHienDinhMucCongChiTiet() { repositoryItemCBToThucHienDMCong.Items.Clear(); repositoryItemCBChiTietSanPham.NullText = @"Tổ thực hiện"; ketnoi kn = new ketnoi(); var dt = kn.laybang(@"select Tenpb from Admin where GiaoNhan = 1"); for (int i = 0; i < dt.Rows.Count; i++) { repositoryItemCBToThucHienDMCong.Items.Add(dt.Rows[i]["Tenpb"]); } kn.dongketnoi(); }
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 DocDSDinhMucCongDoanTheoMa() { ketnoi kn = new ketnoi(); string sqlStr = string.Format(@"select id,Tencondoan,Dinhmuc, Tothuchien,NguyenCong,ThuTuCongDoan, SoChiTiet from tblDMuc_LaoDong where Tencondoan <>'' and Dinhmuc <>'' and Masp like '{0}'", txtMaSanPham.Text); grcDinhMucCongDoan.DataSource = kn.laybang(sqlStr); kn.dongketnoi(); grDinhMucCongDoan.OptionsSelection.CheckBoxSelectorColumnWidth = 20; }