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