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