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;
}
private void TheHienToThucHien()
{
repositoryItemCBToThucHien.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++)
{
repositoryItemCBToThucHien.Items.Add(data.Rows[i]["ToThucHien"]);
}
kn.dongketnoi();
}
private void CongDoan()
{
ketnoi kn = new ketnoi();
gridControl5.DataSource = kn.laybang(@"select ChiTietSanPham,SoChiTietSanPham,case when TrungCongDoan='x'
then 0 else SoChiTiet*Dongia_CongDoan end DonGiaBoSanPham,
SoChiTiet,TrungCongDoan,NguyenCong,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 where SP.Masp <>'' order by id DESC " );
kn.dongketnoi();
gridView1.ExpandAllGroups();
}
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 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 DocTatCaDonDatHang()
{
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"select D.Masp TrangThai,madh,C.Masp,
Tenquicach,dvt,Soluong,ngaygiao,
Khachhang,Mau_banve,Tonkho,ghichu,
ngoaiquang,pheduyet,Diengiai,nguoithaydoi,Iden,TrangThai from tblDHCT C
left outer join(select distinct(Masp) from tblDMuc_LaoDong) D
on D.MaSP=C.MaSP
order by Code Desc" );
kn.dongketnoi();
}
private void btnBaoCaoChuaXuatHang_Click(object sender, EventArgs e)
{
ketnoi kn = new ketnoi();
string sqlStr = string.Format(@"select * from tblchitietkehoach where
soluongyc < BTPT11 or BTPT11 is null and 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 DocMaNguyenCong()
{
repositoryItemMaNguyenCong.Items.Clear();
repositoryItemMaNguyenCong.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++)
{
repositoryItemMaNguyenCong.Items.Add(dt.Rows[i]["Ma_Nguonluc"]);
}
kn.dongketnoi();
}
private void DSNguonLucTheoDonHangID()
{
ketnoi kn = new ketnoi();
gridControl3.DataSource = kn.laybang(@"select madh +'-'+C.MaSP+'-'+C.Tenquicach
ThonTin,C.madh,C.MaSP,
P.* from tblCalender_Product P
left outer join tblDHCT C
on P.DonHangID=C.Iden where
DonHangID=" + txtDonHangID.Text + " order by KetThuc ASC");
kn.dongketnoi();
gridView3.ExpandAllGroups();
}
private void UpdateSoLuongGiaoChiTietTrienKhaiKeHoach()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"update TrienKhaiKeHoachSanXuat
set SoLuongGiao=t.SoGiao,NgayGiao=t.NgayGiao
from(select IDTrienKhai,Sum(SoGiao) SoGiao,max(NgayGiao)NgayGiao
from TrienKhaiKeHoachSanXuatGiaoNhanChiTiet where SoNhan >0
group by IDTrienKhai)t
where TrienKhaiKeHoachSanXuat.ID=t.IDTrienKhai");
var dt = kn.xulydulieu(sqlQuery);
kn.dongketnoi();
}
private void DocDSNhanVien()//đọc danh sách nhân viên
{
ketnoi Connect = new ketnoi();
lookHoTenNhanVien.Properties.DataSource = Connect.laybang(@"select HoTen,Sothe,MaBP,
To_bophan from tblDSNHANVIEN NV
left outer join
tblPHONGBAN PB on NV.MaBP = PB.Ma_bophan where NV.HoTen <> ''");
lookHoTenNhanVien.Properties.DisplayMember = "HoTen";
lookHoTenNhanVien.Properties.ValueMember = "HoTen";
lookHoTenNhanVien.Properties.NullText = null;
Connect.dongketnoi();
}
private void TheHienDanhSachCongDoanTheoSanPhamID()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(
@"select Macongdoan MaLoai,Tencondoan Ten_Nguonluc,Dinhmuc,
Tothuchien ToThucHien,''ThuTu,SoChiTiet,
''DienGiai,SoChiTiet,NguyenCong Ma_Nguonluc,N'Cái'DonVi
from tblDMuc_LaoDong where SanPhamID like N'{0}'", txtIDSanPham.Text);
grChildTreeList.DataSource = kn.laybang(sqlQuery);
kn.dongketnoi();
gvChildTreeList.OptionsSelection.CheckBoxSelectorColumnWidth = 20;
}
private void DocDSChiTietSanPhamDinhMuc()
{
ketnoi kn = new ketnoi();
string sqlStr = string.Format(@"SELECT MaLapGhep,ToThucHien,ID,Masp,Tensp,
IDCongDoan,SanPhamID,
DinhMuc,Nguoilap,Ngaylap,ChiTietSanPham,
Tencondoan,NguyenCong,SoChiTiet,
SoChiTietSanPham,ThuTuCongDoan
FROM ChiTietSanPhamDinhMuc where Masp <> '' order by Ngayghi DESC,Masp ASC, ThuTuCongDoan ASC");
grcDinhMucChiTietSanPham.DataSource = kn.laybang(sqlStr);
kn.dongketnoi();
grDinhMucCongDoan.OptionsSelection.CheckBoxSelectorColumnWidth = 20;
}
private void TheHienDanhSachSanPham()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select case when t.IDSanPham
is not null then 'x' else '' end TreeList,
* from tblSANPHAM p left outer join
(select IDSanPham from tblSanPhamTreeList group by IDSanPham)t
on p.Code=t.IDSanPham" );
grSanPham.DataSource =
kn.laybang(sqlQuery);
kn.dongketnoi();
gvSanPham.OptionsSelection.CheckBoxSelectorColumnWidth = 20;
}
private void DocSoLuongNhanHangTheoIDTrienKhai()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@" SELECT ID,IDTrienKhai,
IDChiTietDonHang,ToGiao,NgayGiao,
SoGiao,ToNhan,NgayNhan,SoNhan,HangLoiHu,NguoiGiao,
NgayGhiGiao,NgayHieuChinhGiao,NguoiNhan,NgayGhiNhan,
NgayHieuChinhNhan,TrangThaiGiao,TrangThaiNhan
FROM TrienKhaiKeHoachSanXuatGiaoNhanChiTiet where
IDTrienKhai like '{0}'", txtIDTrienKhai.Text);
gcNhanHang.DataSource = kn.laybang(sqlQuery);
kn.dongketnoi();
}
private void UpdateSoLuongNhanChiTietTrienKhaiKeHoach()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"update TrienKhaiKeHoachSanXuat set SoNhan=t.SoNhan,
NgayNhan=t.NgayNhan,ToNhan=t.ToNhan,HuHongThatLac=HangLoiHu
from(select IDTrienKhai,Sum(SoNhan) SoNhan,max(NgayNhan)NgayNhan,
max(ToNhan)ToNhan,sum(HangLoiHu)HangLoiHu
from TrienKhaiKeHoachSanXuatGiaoNhanChiTiet where SoNhan >0
group by IDTrienKhai)t
where TrienKhaiKeHoachSanXuat.ID=t.IDTrienKhai");
var dt = kn.xulydulieu(sqlQuery);
kn.dongketnoi();
}
private void DocTatCaDSNhanVien()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select N'Công việc:'+TenCongDoan+N'; QC:'
+SanPham+'('+MaSanPham+')'+N'; Mã đơn:'+MaDonHang Tasked,* from tblNHATKYCD_test
where NgayLam between '{0}' and '{1}'
order by ID Desc" ,
dpTu.Value.ToString("yyyy-MM-dd"),
dpDen.Value.ToString("yyyy-MM-dd"));
grNhatKyCongViec.DataSource = kn.laybang(sqlQuery);
kn.dongketnoi();
gvNhatKyCongViec.OptionsSelection.CheckBoxSelectorColumnWidth = 20;
}
private void DocTatCongSuatChuyen()
{
ketnoi kn = new ketnoi();
grCongSuatChuyen.DataSource = kn.laybang(@"select max(id)id,Masp,
max(ThuTuCongDoan)ThuTuCongDoan,max(ChiTietSanPham)ChiTietSanPham,
max(CongSuatChuyen)CongSuatChuyen,NguyenCong
from ChiTietSanPhamDinhMuc where
SoChiTietSanPham >0
and ThuTuCongDoan >0 and NguyenCong<>''
group by NguyenCong,Masp order by ThuTuCongDoan ASC" );
kn.dongketnoi();
gvCongSuatChuyen.OptionsSelection.CheckBoxSelectorColumnWidth = 20;
}
private void ShowTreeListfollowIDProductionStages()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select case when DonGiaCongDoan>0 then 'x' end CoGia,* from tblSanPhamTreeList
where IDSanPham like '{0}' order by ThuTu ASC", txtIDSanPham.Text);
treeListProductionStages.DataSource =
kn.laybang(sqlQuery);
treeListProductionStages.ForceInitialize();
treeListProductionStages.ExpandAll();
//treeListProductionStages.BestFitColumns();
treeListProductionStages.OptionsSelection.MultiSelect = true;
kn.dongketnoi();
}
private void TheHienTraCuuCongDoanTreeListStages()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select case when DonGiaCongDoan>0 then 'x' end CoGia,* from tblSanPhamTreeList
order by IDSanPham Desc, ThuTu ASC" );
treeListProductionStages.DataSource =
kn.laybang(sqlQuery);
treeListProductionStages.ForceInitialize();
treeListProductionStages.ExpandAll();
//treeListProductionStages.BestFitColumns();
treeListProductionStages.OptionsSelection.MultiSelect = true;
kn.dongketnoi();
}
private void FrmCauHinh_Load(object sender, EventArgs e)
{
if (File.Exists(cls_Main.duongdanfileketnoi))
{
_ketnoi = new ketnoi();
db2 = new BLL_KetNoi(cls_Main.duongdanfileketnoi, _ketnoi);
txtserver.Text = _ketnoi.ServerName;
txtdatabase.Text = _ketnoi.DatabaseName;
txtuser.Text = _ketnoi.UserName;
txtpass.Text = _ketnoi.PassWord;
}
lbltrangthai.Visible = false;
btnketnoi.Enabled = false;
}
// GET: admin/ketnois/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ketnoi ketnoi = db.ketnois.Find(id);
if (ketnoi == null)
{
return(HttpNotFound());
}
return(View(ketnoi));
}
private void ShowTreListProduction()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select *
from tblSanPhamTreeList
order by ID desc,NgayLap DESC");
treeListProduction.DataSource = kn.laybang(sqlQuery);
treeListProduction.ForceInitialize();
treeListProduction.ExpandAll();
//treeListProduction.BestFitColumns();
treeListProduction.OptionsSelection.MultiSelect = true;
//treeList1.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CheckBoxRowSelect;
}
void object_supplier()
{
cbDoiTuongCungCap.Properties.Items.Clear();
ketnoi cn = new ketnoi();
var dt = cn.laybang(@"select distinct DoiTuongCungCap
from tblNHAP_VATLIEUPHU
where DoiTuongCungCap !=''");
cn.dongketnoi();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbDoiTuongCungCap.Properties.Items.Add(dt.Rows[i]["DoiTuongCungCap"]);
}
}
private void Category_Resource_By_Date()
{
ketnoi kn = new ketnoi();
gridControl1.DataSource = kn.laybang(@"SELECT RCID,ResourceID,
BoPhan Ten_Nguonluc,MaBP Ma_Nguonluc,Thang,Nam,
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,
NgayLap,NguoiLap
FROM dbo.Resource_Calender where Thang ='" + cbthang.Text + "' and Nam='" + dpNam.Text + "' order by Nam desc, Thang desc");
kn.dongketnoi();
gridView1.Columns["Thang"].GroupIndex = -1;
}
void Supplier()//Nhà cung cấp
{
repositoryItemComboBoxNhaCC.Items.Clear();
ketnoi cn = new ketnoi();
var dt = cn.laybang(@"
select Nguoigiao from
tblNHAP_VATLIEUPHU
where Nguoigiao !='' group by Nguoigiao");
cn.dongketnoi();
for (int i = 0; i < dt.Rows.Count; i++)
{
repositoryItemComboBoxNhaCC.Items.Add(dt.Rows[i]["Nguoigiao"]);
}
}
private void DocTatCaCongSuatSanXuat()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select c.MaPo,madh,Tenquicach,
p.* from LichSanXuatChiTiet_func('{0}','{1}','{2}','{3}') p
left outer join tblDHCT c on
p.DonHangID=c.Iden" ,
dpNam.Value.ToString("yyyy"),
cbthang.Text,
txtGioLamViec.Text,
"%");//('2019',06,12,'HOW-ST-1207')
gridControl2.DataSource = kn.laybang(sqlQuery);
kn.dongketnoi();
}
private void DocCongSuatChuyenTheoMaSanPham()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select max(id)id,Masp,
max(ThuTuCongDoan)ThuTuCongDoan,max(ChiTietSanPham)ChiTietSanPham,
max(CongSuatChuyen)CongSuatChuyen,NguyenCong
from ChiTietSanPhamDinhMuc where
SoChiTietSanPham >0
and ThuTuCongDoan >0 and NguyenCong<>'' and Masp like N'{0}'
group by NguyenCong,Masp order by ThuTuCongDoan ASC" , txtMaSanPham.Text);
grCongSuatChuyen.DataSource = kn.laybang(sqlQuery);
kn.dongketnoi();
gvCongSuatChuyen.OptionsSelection.CheckBoxSelectorColumnWidth = 20;
}
private void TheHienCongDoanSanPham()
{
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select s.Masp,
s.Tensp from tblSANPHAM s
inner join
(select Masp from
tblDMuc_LaoDong group by Masp) l
on s.Masp=l.Masp" );
cbMaSanPham.Properties.DataSource = kn.laybang(sqlQuery);
cbMaSanPham.Properties.DisplayMember = "Masp";
cbMaSanPham.Properties.ValueMember = "Masp";
kn.dongketnoi();
}
private void DocDSSanPham()
{
ketnoi kn = new ketnoi();
string sqlStr = string.Format(@"select Code SanPhamID,Masp,Tensp,
case when l.MaSanPham <>'' then 'x' end CoDinhMuc
from tblSANPHAM
left outer join
(select Masp MaSanPham from tblDMuc_LaoDong group by Masp) l on
l.MaSanPham=tblSANPHAM.Masp order by Code desc" );
grlSanPhamDS.Properties.DataSource = kn.laybang(sqlStr);
grlSanPhamDS.Properties.DisplayMember = "Masp";
grlSanPhamDS.Properties.ValueMember = "Masp";
kn.dongketnoi();
}
