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