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