public DataTable BATCH_Find(string BATCH) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", " SELECT [CD_OF],[Batch] FROM [SYNC_NUTRICIEL].[dbo].[tbl_BATCH] Where [Batch] = '" + BATCH + "'", CommandType.Text); return(dt); }
public DataTable CTPT_List() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select ID , CTPT From [SYNC_NUTRICIEL].[dbo].tbl_ChiTieuPhanTich WHERE ID>1", CommandType.Text); return(dt); }
public int PKN_Template_Max_KQKNID() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT MAX([ID]) as ID FROM [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_TD]", CommandType.Text); return(int.Parse(dt.Rows[0]["ID"].ToString().Length == 0 ? "1" : dt.Rows[0]["ID"].ToString()) + 1); }
//SELECT CODE //SELECT ALL //INSERT //UPDATE //DELETE public DataTable SP_MAX_PRNO() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT MAX([SYNC_NUTRICIEL].dbo.tbl_PR.PRNO) + 1 as PRNO FROM [SYNC_NUTRICIEL].dbo.tbl_PR ", CommandType.Text); return(dt); }
public DataTable VENDOR_SELECT() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select * from [SYNC_NUTRICIEL].[dbo].[V_VENDOR] ", CommandType.Text); return(dt); }
public DataTable TDCOA_Search(string SoCOA) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[ID] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[SoCOA] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[COATemplateID]" + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[WO] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[ManfBy] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[SmpDate] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[ExpDate] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[AnlDate] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[ManfDate] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[LB_MAT] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[CreatedBy] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[CreatedDate] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[Locked] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[Note] " + ", [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Header].[IMGCOA] " + "FROM [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD] " + "INNER JOIN [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Header] " + "ON [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].[COATemplateID] = [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Header].[ID] " + "WHERE [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD].SoCOA ='" + SoCOA + "'", CommandType.Text); return(dt); }
public int COA_Template_Max_COAID() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", " SELECT MAX([SoCOA]) as SoCOA FROM [SYNC_NUTRICIEL].[dbo].[tbl_TDCOA]", CommandType.Text); return(int.Parse(dt.Rows[0]["SoCOA"].ToString().Length == 0 ? "1" : dt.Rows[0]["SoCOA"].ToString()) + 1); }
public DataTable RMUSED_Find(string CD_OF) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", " SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_RMUsed] Where [CD_OF] = '" + CD_OF + "'", CommandType.Text); return(dt); }
public int MAX_IdSort() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT MAX([IdSort]) as IdSort FROM [SYNC_NUTRICIEL].[dbo].[Resources]", CommandType.Text); return(int.Parse(dt.Rows[0]["IdSort"].ToString().Length == 0 ? "10" : dt.Rows[0]["IdSort"].ToString()) + 10); }
public int PRICELIST_INDENTITY_SELECT() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", " SELECT IDENT_CURRENT( 'tbl_PriceList_Details_LAB' ) + 1 as IDENT ", CommandType.Text); return(int.Parse(dt.Rows[0]["IDENT"].ToString())); }
public DataTable RMUSED_View() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_RMUsed] ORDER BY [Step] DESC", CommandType.Text); return(dt); }
public DataTable PRICELIST_History(int PLID) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", " SELECT [V_PriceList_History].[ID] " + " ,[V_PriceList_History].[CreatedDate] " + " ,[V_PriceList_History].[CreatedBy] " + " ,[V_PriceList_History].[Locked] " + " ,[V_PriceList_History].[PLID] " + " ,[V_PriceList_History].[CTXNID] " + " ,[tbl_ChiTieuXetNghiem_LAB].[CTXN] " + " ,[V_PriceList_History].[UoM] " + " ,[V_PriceList_History].[SoLuong] " + " ,[V_PriceList_History].[DonGia] " + " ,[V_PriceList_History].[Giam] " + " ,[V_PriceList_History].[UoMGiam] " + " ,[V_PriceList_History].[Note] " + " ,[V_PriceList_History].[VAT] " + " ,[V_PriceList_History].[DonGiaMuaNgoai] " + " ,[V_PriceList_History].[DVMuaNgoaiCode] " + " ,[V_PriceList_History].[DVMuaNgoaiName] " + " ,[V_PriceList_History].[MuaNgoai] " + " FROM[SYNC_NUTRICIEL].[dbo].[V_PriceList_History] " + " INNER JOIN tbl_ChiTieuXetNghiem_LAB " + " ON[V_PriceList_History].CTXNID = tbl_ChiTieuXetNghiem_LAB.ID " + " WHERE [PLID]=" + PLID + " Order by [V_PriceList_History].[CTXNID],[V_PriceList_History].[CreatedDate] DESC", CommandType.Text); return(dt); }
public int MYCOTOXIN_RESULT_Header_ID(string FilePath) { DataTable dt = Sql.ExecuteDataTable("SAP", "SELECT ID FROM [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Header_LAB] " + "WHERE FilePath='" + FilePath + "'", CommandType.Text); return(int.Parse(dt.Rows[0]["ID"].ToString())); }
public DataTable BATCH_View() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT [CD_OF],[Batch],[Start],[End],[ItemCode],[ItemDescription],[Formula],[Version],[PlannedQty],[ManufacturedQty],[Destination],[PrepareBatchNb],[TotalBatchNb] FROM [SYNC_NUTRICIEL].[dbo].[tbl_BATCH] ORDER BY [CD_OF] DESC", CommandType.Text); return(dt); }
public int Control_Visible(string control) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select * From [SYNC_NUTRICIEL].[dbo].tbl_Control where [Control]='" + control + "'", CommandType.Text); return(dt.Rows.Count); }
public DataTable PRICELISTDAO_List() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select ID , PL From [SYNC_NUTRICIEL].[dbo].tbl_PriceList_LAB", CommandType.Text); return(dt); }
public DataTable Control_List() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select ID as ControlID, Control as Control, ControlVN as ControlVN,Characteristic FROM [SYNC_NUTRICIEL].[dbo].tbl_Control ", CommandType.Text); return(dt); }
public DataTable KHMau_LABDAO_REPORT_STORAGE(string SoPXN) { //return Sql.ExecuteDataTable("SAP", " SELECT tbl_KHMau_LAB.ID, tbl_KHMau_LAB.SoPXN, tbl_KHMau_LAB.CreatedDate, tbl_KHMau_LAB.CreatedBy, tbl_KHMau_LAB.Locked, tbl_KHMau_LAB.Note, tbl_KHMau_LAB.KHMau,tbl_KHMau_LAB.KHMau_KhachHang, tbl_KHMau_LAB.SoLuongKHMau, " + // " tbl_KHMau_LAB.DonViKHMau, tbl_KHMau_LAB.PhuongPhapBaoQuan, tbl_KHMau_LAB.VitriLuuKHMau, tbl_KHMau_LAB.NgayLuuKHMau, tbl_KHMau_LAB.NhanVienLuuKHMau, tbl_KHMau_LAB.NgayHuyKHMau, " + // " tbl_KHMau_LAB.TaiLieuHuyKHMau, tbl_KHMau_LAB.NhanVienHuyKHMau, tbl_KHMau_LAB.TrangThaiKHMau, tbl_KHMau_LAB.SoLuongHuyKHMau, tbl_KHMau_LAB.KHMau_KhachHang, tbl_ChiTieuXetNghiem_LAB.CTXN, " + // " tbl_ChiTieuXetNghiem_LAB.CTXNDG, tbl_ChiTieuXetNghiem_LAB.CTXNDGTA, tbl_ChiTieuXetNghiem_LAB.MinValue, tbl_ChiTieuXetNghiem_LAB.MaxValue, tbl_ChiTieuXetNghiem_LAB.UnitValue, " + // " tbl_NhomChiTieuXetNghiem_LAB.NCTXN, tbl_NhomChiTieuXetNghiem_LAB.NCTXNDG, tbl_NhomChiTieuXetNghiem_LAB.NhomChung, tbl_PhuongPhapXetNghiem_LAB.PPXN, tbl_PhuongPhapXetNghiem_LAB.PPXNDG, " + // " tbl_KHMau_CTXN_LAB.KHMau AS Expr1, tbl_KHMau_CTXN_LAB.DonGia, tbl_KHMau_CTXN_LAB.ThanhTien, tbl_KHMau_CTXN_LAB.KetQua, tbl_KHMau_CTXN_LAB.SoLuongDat, tbl_KHMau_CTXN_LAB.VAT, tbl_KHMau_CTXN_LAB.SoLuongXN " + // " FROM tbl_KHMau_LAB LEFT JOIN " + // " tbl_KHMau_CTXN_LAB ON tbl_KHMau_LAB.KHMau = tbl_KHMau_CTXN_LAB.KHMau LEFT JOIN " + // " tbl_ChiTieuXetNghiem_LAB ON tbl_KHMau_CTXN_LAB.CTXNID = tbl_ChiTieuXetNghiem_LAB.ID LEFT JOIN " + // " tbl_NhomChiTieuXetNghiem_LAB ON tbl_ChiTieuXetNghiem_LAB.NCTXNID = tbl_NhomChiTieuXetNghiem_LAB.ID LEFT JOIN " + // " tbl_PhuongPhapXetNghiem_LAB ON tbl_ChiTieuXetNghiem_LAB.PPXNID = tbl_PhuongPhapXetNghiem_LAB.ID " + // " WHERE tbl_KHMau_LAB.SoPXN ='" + SoPXN + "' and TrangThaiKHMau = '0'" + // " GROUP BY tbl_KHMau_LAB.ID, tbl_KHMau_LAB.SoPXN, tbl_KHMau_LAB.CreatedDate, tbl_KHMau_LAB.CreatedBy, tbl_KHMau_LAB.Locked, tbl_KHMau_LAB.Note, tbl_KHMau_LAB.KHMau,tbl_KHMau_LAB.KHMau_KhachHang, tbl_KHMau_LAB.SoLuongKHMau, " + // " tbl_KHMau_LAB.DonViKHMau, tbl_KHMau_LAB.PhuongPhapBaoQuan, tbl_KHMau_LAB.VitriLuuKHMau, tbl_KHMau_LAB.NgayLuuKHMau, tbl_KHMau_LAB.NhanVienLuuKHMau, tbl_KHMau_LAB.NgayHuyKHMau, " + // " tbl_KHMau_LAB.TaiLieuHuyKHMau, tbl_KHMau_LAB.NhanVienHuyKHMau, tbl_KHMau_LAB.TrangThaiKHMau, tbl_KHMau_LAB.SoLuongHuyKHMau, tbl_ChiTieuXetNghiem_LAB.CTXN, " + // " tbl_ChiTieuXetNghiem_LAB.CTXNDG, tbl_ChiTieuXetNghiem_LAB.CTXNDGTA, tbl_ChiTieuXetNghiem_LAB.MinValue, tbl_ChiTieuXetNghiem_LAB.MaxValue, tbl_ChiTieuXetNghiem_LAB.UnitValue, " + // " tbl_NhomChiTieuXetNghiem_LAB.NCTXN, tbl_NhomChiTieuXetNghiem_LAB.NCTXNDG, tbl_NhomChiTieuXetNghiem_LAB.NhomChung, tbl_PhuongPhapXetNghiem_LAB.PPXN, tbl_PhuongPhapXetNghiem_LAB.PPXNDG, " + // " tbl_KHMau_CTXN_LAB.KHMau , tbl_KHMau_CTXN_LAB.DonGia, tbl_KHMau_CTXN_LAB.ThanhTien, tbl_KHMau_CTXN_LAB.KetQua, tbl_KHMau_CTXN_LAB.SoLuongDat, tbl_KHMau_CTXN_LAB.VAT ", CommandType.Text); return(Sql.ExecuteDataTable("SAP", " SELECT tbl_KHMau_LAB.ID, tbl_KHMau_LAB.SoPXN, tbl_KHMau_LAB.KHMau, tbl_KHMau_LAB.SoLuongKHMau, " + " tbl_KHMau_LAB.PhuongPhapBaoQuan, tbl_KHMau_LAB.VitriLuuKHMau, tbl_KHMau_LAB.NhanVienLuuKHMau, tbl_KHMau_LAB.NgayLuuKHMau,tbl_KHMau_LAB.LuuMau " + " FROM tbl_KHMau_LAB LEFT JOIN " + " tbl_KHMau_CTXN_LAB ON tbl_KHMau_LAB.KHMau = tbl_KHMau_CTXN_LAB.KHMau " + " WHERE tbl_KHMau_LAB.SoPXN ='" + SoPXN + "' and TrangThaiKHMau = '0' " + " GROUP BY tbl_KHMau_LAB.ID, tbl_KHMau_LAB.SoPXN, tbl_KHMau_LAB.KHMau, tbl_KHMau_LAB.SoLuongKHMau, " + " tbl_KHMau_LAB.PhuongPhapBaoQuan, tbl_KHMau_LAB.VitriLuuKHMau, tbl_KHMau_LAB.NhanVienLuuKHMau, tbl_KHMau_LAB.NgayLuuKHMau,tbl_KHMau_LAB.LuuMau ", CommandType.Text)); }
public DataTable COA_Template_View() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Details] ", CommandType.Text); return(dt); }
public DataTable BaoCao_HuyetThanhHoc_IBD(string year, int CTXNID) { return(Sql.ExecuteDataTable("SAP", " Select T1.ID as KHMau_CTXN_ID,T1.CTXNID,T1.SoLuongXN,T1.KHMau_GiaoMau,T1.ID,T1.SoPXN,T1.Month,T1.Year,S0.KHMau_GiaoMau,S0.CTXN_ID , " + " S0.Neg, S0.Pos, S0.Sus, T1.TenLoaiDV,T1.TenCoSoLayMau,T1.LOCCode,T1.ProvinceName,T1.TenCoSoGuiMau " + " From " + " (" + " Select tbl_IBD_RESULT_Header_LAB.KHMau_GiaoMau, tbl_IBD_RESULT_Header_LAB.CTXN_ID, " + " tbl_IBD_RESULT_Header_LAB.Neg, tbl_IBD_RESULT_Header_LAB.Pos, tbl_IBD_RESULT_Header_LAB.Sus " + " from tbl_IBD_RESULT_Header_LAB " + " Inner JOIN tbl_IBD_RESULT_Lines_LAB " + " ON tbl_IBD_RESULT_Header_LAB.ID = tbl_IBD_RESULT_Lines_LAB.IBD_RESULT_Header_LAB_ID " + " ) as S0 " + " INNER JOIN " + " (" + " Select tbl_KHMau_CTXN_LAB.ID as KHMau_CTXN_ID,tbl_KHMau_CTXN_LAB.CTXNID,tbl_KHMau_CTXN_LAB.SoLuongXN,T0.KHMau_GiaoMau,T0.ID,T0.SoPXN,T0.Month,T0.Year,T0.TenLoaiDV,T0.TenCoSoLayMau,T0.LOCCode,T0.ProvinceName,T0.TenCoSoGuiMau " + " From tbl_KHMau_CTXN_LAB " + " INNER JOIN " + " (" + " select tbl_CUSTOMER_LAB.LOCCode,tbl_CUSTOMER_LAB.ProvinceName,tbl_PXN_Header.TenCoSoLayMau,tbl_PXN_Header.TenCoSoGuiMau,tbl_LoaiDV_LAB.TenLoaiDV, tbl_KHMau_LAB.KHMau_GiaoMau, tbl_KHMau_LAB.ID, tbl_PXN_Header.SoPXN, MONTH(tbl_PXN_Header.NgayNhanMau) as Month, YEAR(tbl_PXN_Header.NgayNhanMau) as Year " + " from tbl_PXN_Header " + " inner join tbl_KHMau_LAB " + " On tbl_PXN_Header.SoPXN = tbl_KHMau_LAB.SoPXN " + " inner join tbl_LoaiDV_LAB " + " on tbl_KHMau_LAB.LoaiDVMauNuoc = tbl_LoaiDV_LAB.MaLoaiDV " + " inner join tbl_CUSTOMER_LAB " + " ON tbl_PXN_Header.MaCoSoLayMau = tbl_CUSTOMER_LAB.CUSTCODE " + " Where YEAR(tbl_PXN_Header.NgayNhanMau) = '" + year + "' " + " ) as T0 " + " ON tbl_KHMau_CTXN_LAB.KHMau_ID = T0.ID " + " Where tbl_KHMau_CTXN_LAB.CTXNID = " + CTXNID + " ) as T1 " + " ON S0.KHMau_GiaoMau = T1.KHMau_GiaoMau and S0.CTXN_ID = T1.CTXNID " + " GROUP BY T1.TenLoaiDV,T1.ID,T1.CTXNID,T1.SoLuongXN,T1.KHMau_GiaoMau,T1.ID,T1.SoPXN,T1.Month,T1.Year,S0.KHMau_GiaoMau,S0.CTXN_ID ,S0.Neg, S0.Pos, S0.Sus,T1.TenCoSoLayMau,T1.LOCCode,T1.ProvinceName,T1.TenCoSoGuiMau ", CommandType.Text)); }
public DataTable PPT_List() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select ID , PPT From [SYNC_NUTRICIEL].[dbo].tbl_PhuongPhapThu WHERE ID>1", CommandType.Text); return(dt); }
public DataTable QCDG_List() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select * From [SYNC_NUTRICIEL].[dbo].tbl_QuiCachDongGoi", CommandType.Text); return(dt); }
public DataTable SP_PR_Detail_parms(string PRNO) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].dbo.tbl_PR_Detail WHERE PRNO = '" + PRNO + "' ", CommandType.Text); return(dt); }
public DataTable PXN_ResultDAO_SELECT(string SoPXN) { return(Sql.ExecuteDataTable("SAP", "SELECT " + " tbl_PXN_Result.ID, " + " tbl_PXN_Result.SoPXN, " + " tbl_PXN_Result.CTXNID, " + " tbl_PXN_Result.ResultLine, " + " tbl_PXN_Result.ResultValue, " + " tbl_PXN_Result.Positive, " + " tbl_PXN_Result.ResultUoM, " + " tbl_PXN_Result.CreatedBy, " + " tbl_PXN_Result.Note, " + " tbl_PXN_Result.Locked, " + " tbl_PXN_Result.UnitTestCode, " + " tbl_ChiTieuXetNghiem_LAB.CTXN, " + " tbl_PhuongPhapXetNghiem_LAB.PPXN, " + " tbl_NhomChiTieuXetNghiem_LAB.NCTXN, " + //" tbl_PXN_Details.DonGia, " + //" tbl_PXN_Details.ThanhTien, " + //" tbl_PXN_Details.KetQua, " + //" tbl_PXN_Details.SLDat " + " FROM " + " tbl_PXN_Result " + " LEFT OUTER JOIN " + " tbl_ChiTieuXetNghiem_LAB " + " ON tbl_PXN_Result.CTXNID = tbl_ChiTieuXetNghiem_LAB.ID " + " LEFT OUTER JOIN " + " tbl_PhuongPhapXetNghiem_LAB " + " ON tbl_ChiTieuXetNghiem_LAB.PPXNID = tbl_PhuongPhapXetNghiem_LAB.ID " + " LEFT OUTER JOIN " + " tbl_NhomChiTieuXetNghiem_LAB " + " ON tbl_ChiTieuXetNghiem_LAB.NCTXNID = tbl_NhomChiTieuXetNghiem_LAB.ID " + " WHERE tbl_PXN_Result.[SoPXN]='" + SoPXN + "'", CommandType.Text)); }
//Report trả kết quả cho khách hàng public DataTable MYCOTOXIN_RESUTL_Lines_AnalysisReport(string SoPXN) { return(Sql.ExecuteDataTable("SAP", "SELECT T3.*,tbl_PhuongPhapXetNghiem_LAB.PPXN " + " FROM tbl_PhuongPhapXetNghiem_LAB " + " INNER JOIN " + " ( SELECT tbl_ChiTieuXetNghiem_LAB.CTXN,tbl_ChiTieuXetNghiem_LAB.MaCTXN,tbl_ChiTieuXetNghiem_LAB.Acronym,tbl_ChiTieuXetNghiem_LAB.UoM,tbl_ChiTieuXetNghiem_LAB.PPXNID,T2.* " + " FROM tbl_ChiTieuXetNghiem_LAB " + " INNER JOIN " + " ( " + " SELECT T1.*, tbl_KHMau_CTXN_RESULT_DETAILS_LAB.Custom1 " + " FROM tbl_KHMau_CTXN_RESULT_DETAILS_LAB " + " INNER JOIN " + " (" + " SELECT tbl_KHMau_CTXN_LAB.ID as KHMau_CTXN_LAB_ID, T.*, tbl_KHMau_CTXN_LAB.CTXNID " + " FROM tbl_KHMau_CTXN_LAB " + " INNER JOIN " + " ( " + " Select tbl_PXN_Header.SoPXN, tbl_KHMau_LAB.ID, tbl_KHMau_LAB.KHMau, tbl_KHMau_LAB.KHMau_KhachHang,tbl_PXN_Header.NgayNhanMau,tbl_PXN_Header.NgayTraKetQua " + " FROM tbl_PXN_Header " + " INNER JOIN " + " tbl_KHMau_LAB " + " ON tbl_PXN_Header.SoPXN = tbl_KHMau_LAB.SoPXN " + " WHERE tbl_PXN_Header.SoPXN = '" + SoPXN + "' " + " ) as T " + " ON tbl_KHMau_CTXN_LAB.KHMau = T.KHMau " + " ) as T1 " + " ON tbl_KHMau_CTXN_RESULT_DETAILS_LAB.KHMau_CTXN_ID = T1.KHMau_CTXN_LAB_ID " + " ) as T2 " + " ON tbl_ChiTieuXetNghiem_LAB.ID = T2.CTXNID " + " ) as T3 " + " ON tbl_PhuongPhapXetNghiem_LAB.ID = T3.PPXNID " + " ORDER BY T3.MaCTXN ASC ", CommandType.Text)); }
public DataTable CUSTOMER_LIST_SAPB1() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select CardName,CardCode,Address from [VIPHAVET].[dbo].[OCRD] ", CommandType.Text); return(dt); }
public DataTable PKN_Template_View() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_KQKN_Template_Header] ", CommandType.Text); return(dt); }
public DataTable Control_List_Characteristic(string Characteristic) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select ID as ControlID, Control as Control, ControlVN ans ControlVN FROM [SYNC_NUTRICIEL].[dbo].tbl_Control WHERE Characteristic='" + Characteristic + "' ", CommandType.Text); return(dt); }
public DataTable TC_List() { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "Select ID , TC From [SYNC_NUTRICIEL].[dbo].[tbl_TieuChuan] WHERE ID>1", CommandType.Text); return(dt); }
public DataTable BATCH_Details(string CD_OF) { DataTable dt = new DataTable(); dt = Sql.ExecuteDataTable("SAP", "select [ASIALAND].dbo.OWOR.DocNum as CD_OF,FG_STATUS = '1', CONVERT(varchar(10),[ASIALAND].dbo.OWOR.DueDate,103) as DT_PREV,CD_DEPOT='891',[ASIALAND].dbo.OWOR.ItemCode as CD_MAT,[ASIALAND].dbo.OITM.ItemName as LB_MAT,CAST([ASIALAND].dbo.OWOR.PlannedQty as numeric(18,0)) as QT_PREV, [ASIALAND].dbo.OITM.InvntryUom as CD_UNIT,NO_ORDRE='1000',T.CD_MAT1 AS CD_MAT1 ,CAST(T.QT_DOSE as numeric(18,0)) AS QT_DOSE,CD_VER ='89' from [ASIALAND].dbo.OWOR inner join [ASIALAND].dbo.OITM on [ASIALAND].dbo.OWOR.ItemCode = [ASIALAND].dbo.OITM.ItemCode inner join (select [ASIALAND].dbo.WOR1.DocEntry,[ASIALAND].dbo.WOR1.ItemCode as CD_MAT1,CAST([ASIALAND].dbo.WOR1.PlannedQty as numeric(18,0)) as QT_DOSE, [ASIALAND].dbo.WOR1.U_NBS_LossRow as LOSS_COMP from [ASIALAND].dbo.WOR1 inner join [ASIALAND].dbo.OITM on [ASIALAND].dbo.WOR1.ItemCode = [ASIALAND].dbo.OITM.ItemCode where OITM.InvntryUom ='KG' ) as T on [ASIALAND].dbo.OWOR.DocNum = T.DocEntry Where [ASIALAND].dbo.OWOR.DocNum = '" + CD_OF + "'", CommandType.Text); return(dt); }