using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Core.EFDbContext;
|
using WIDESEA_Core.FreeDB;
|
using WIDESEA_Entity.DomainModels;
|
using WIDESEA_WMS.IRepositories;
|
using WIDESEA_WMS.Repositories;
|
|
namespace WIDESEA_WMS.Common
|
{
|
public class QueryData
|
{
|
static FreeDB freeDB = new FreeDB();
|
/// <summary>
|
/// 根据图号查询车轮信息
|
/// </summary>
|
/// <param name="type"></param>
|
/// <returns></returns>
|
public static dt_geometry_data QueryMateriel(string type)
|
{
|
VOLContext Context = new VOLContext();
|
Idt_geometry_dataRepository dataRepository = new dt_geometry_dataRepository(Context);
|
var materielinfo = dataRepository.Find(x => x.Description == type).OrderBy(x => x.TypeId).FirstOrDefault();
|
//var materielinfo = freeDB.Select<dt_geometry_data>().Where(x => x.Description == type).First();
|
return materielinfo;
|
}
|
public static dt_geometry_data_detectionline QueryMateriel1(string type)
|
{
|
VOLContext Context = new VOLContext();
|
Idt_geometry_data_detectionlineRepository data_DetectionlineRepository = new dt_geometry_data_detectionlineRepository(Context);
|
//var materielinfo = freeDB.Select<dt_geometry_data_detectionline>().Where(x => x.Description == type).First();
|
var materielinfo = data_DetectionlineRepository.Find(x => x.Description == type).OrderBy(x => x.TypeId).FirstOrDefault();
|
return materielinfo;
|
}
|
/// <summary>
|
/// 根据主键查询车轮信息
|
/// </summary>
|
/// <param name="type"></param>
|
/// <returns></returns>
|
public static dt_geometry_data QueryMateriel(int type)
|
{
|
var materielinfo = freeDB.Select<dt_geometry_data>().Where(x => x.TypeId == type).First();
|
return materielinfo;
|
}
|
}
|
}
|
