/// <summary>
///
/// </summary>
/// <param name="barCode"></param>
/// <returns></returns>
public List <OnProcessingInfo> GetOnProcessingList(string barCode)
{
List <OnProcessingInfo> list = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = @"SELECT T.PID,T.WORKINGSTARTTIME,T1.MATNAME,T2.ENAME,T3.PNAME AS PROCESSNAME,T4.PNAME AS PRODUCTNAME FROM T_FP_PRODUCETRACK T
LEFT OUTER JOIN T_WH_MAT T1 ON T1.ID = T.MATID
LEFT OUTER JOIN T_FP_EQUIPMENT T2 ON T2.PID = T.EQUID
LEFT OUTER JOIN T_FP_PROCESSINFO T3 ON T3.PID = T.WPID
LEFT OUTER JOIN T_FP_PRODUCTINFO T4 ON T4.PID = T.PRODUCTIONID
WHERE STATUS ='0'";
if (!string.IsNullOrEmpty(barCode))
{
sql += " AND T2.BARCODE =@BARCODE";
}
parameters.Add(new DataParameter("BARCODE", barCode));
list = session.GetList <OnProcessingInfo>(sql, parameters.ToArray()).ToList <OnProcessingInfo>();
}
if (list.Count > 0)
{
return(list);
}
else
{
return(null);
}
}
/// <summary>
/// 根据ID获取产品信息（要货信息）
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public SupplyInfo GetProducePlanInfoByID(string id)
{
List <SupplyInfo> list = null;
string sql = null;
sql = @"SELECT pp.BATCHNUMBER,fi.PNAME AS FactoryName,pi.PNAME AS ProduceName,pl.PLNAME AS PLName,pp.ProductionID
FROM T_FP_ProducePlan pp
LEFT OUTER JOIN T_FP_FACTORYINFO fi ON pp.FACTORYPID =fi.PID
LEFT OUTER JOIN T_FP_PRODUCTINFO pi ON pp.PRODUCTIONID = pi.PID
LEFT OUTER JOIN T_FP_PRODUCTLINE pl on pp.PRID = pl.PID
WHERE pp.PID = @PID";
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
parameters.Add(new DataParameter("PID", id));
list = session.GetList <SupplyInfo>(sql, parameters.ToArray()).ToList <SupplyInfo>();
}
if (list.Count > 0)
{
return(list[0]);
}
else
{
return(null);
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public ProduceTrack Get(ProduceTrack model)
{
List <ProduceTrack> list = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = @"SELECT T1.*,T2.PNAME,T3.BARCODE AS CBBARCODE,T3.ENAME AS CBNAME,T4.WSCODE,T5.PNAME AS GXNAME FROM T_FP_PRODUCETRACK T1
LEFT OUTER JOIN T_FP_PRODUCTINFO T2 ON T1.PRODUCTIONID = T2.PRID
LEFT OUTER JOIN T_FP_EQUIPMENT T3 ON T1.EQUID = T3.PID
LEFT OUTER JOIN T_FP_WORKSTATION T4 ON T1.WSID = T4.PID
LEFT OUTER JOIN T_FP_PROCESSINFO T5 ON T1.WPID = T5.PID
WHERE T1.PID =@PID";
parameters.Add(new DataParameter("PID", model.PID));
list = session.GetList <ProduceTrack>(sql, parameters.ToArray()).ToList <ProduceTrack>();
}
if (list.Count > 0)
{
return(list[0]);
}
else
{
return(null);
}
}
public GoodInfo GetGoodInfoByBatchNumber(string batchNumber)
{
List <GoodInfo> list = null;
string sql = null;
sql = @"SELECT t1.PID AS PLANID,t1.BATCHNUMBER,t1.FACTORYPID,t1.PRID,t1.ProductionID,t1.FactAmount,
t2.PCODE,t2.PNAME,t2.SPECIFICATION
FROM T_FP_ProducePlan t1 ,T_FP_PRODUCTINFO t2
WHERE t1.ProductionID = t2.PID AND t1.BatchNumber = @BatchNumber";
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
parameters.Add(new DataParameter("BatchNumber", batchNumber));
list = session.GetList <GoodInfo>(sql, parameters.ToArray()).ToList <GoodInfo>();
}
if (list.Count > 0)
{
return(list[0]);
}
else
{
return(null);
}
}
/// <summary>
/// 获取监测设备列表
/// </summary>
/// <param name="condition">条件</param>
/// <param name="page">数据页</param>
/// <returns>数据页</returns>
public List <InspectDeviceEntity> GetAllDeviceByOrgAndType(InspectDeviceEntity condition)
{
List <InspectDeviceEntity> itemInfo = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
sqlBuilder.Append(" SELECT Id,DeviceCode,DeviceName FROM deviceinfo A ");
//查询条件
if (!string.IsNullOrEmpty(condition.OrganID))
{
whereBuilder.Append(" AND A.OrganID = @OrganID");
parameters.Add(new DataParameter {
ParameterName = "OrganID", DataType = DbType.String, Value = condition.OrganID
});
}
//查询条件
if (string.IsNullOrEmpty(condition.DeviceType) == false)
{
whereBuilder.Append(" AND DeviceType = @DeviceType");
parameters.Add(new DataParameter {
ParameterName = "DeviceType", DataType = DbType.String, Value = condition.DeviceType
});
}
if (whereBuilder.Length > 0)
{
sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4));
}
sqlBuilder.Append(" ORDER BY A.DeviceCode ASC ");
sql = sqlBuilder.ToString();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
itemInfo = session.GetList <InspectDeviceEntity>(sql, parameters.ToArray()).ToList();
}
return(itemInfo);
}
catch (Exception ex)
{
throw ex;
}
}
public List <WorkGroupRef> GetPList(string id)
{
List <WorkGroupRef> list = null;
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = "SELECT * FROM T_FP_WORKGROUPREF WHERE WOID='" + id + "'";
list = session.GetList <WorkGroupRef>(sql, new List <DataParameter>().ToArray()).ToList <WorkGroupRef>();
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="condition">条件</param>
/// <returns>列表</returns>
public List <WorkGroup> GetList()
{
List <WorkGroup> list = null;
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = "SELECT PID,PNAME FROM T_FP_WORKGROUP ORDER BY PNAME";
list = session.GetList <WorkGroup>(sql, new List <DataParameter>().ToArray()).ToList <WorkGroup>();
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="condition">条件</param>
/// <returns>计量单位列表</returns>
public List <MatUnit> GetList(MatUnit condition)
{
List <MatUnit> list = null;
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = "SELECT ID,Description FROM T_WH_MatUnit order by Description";
list = session.GetList <MatUnit>(sql, new List <DataParameter>().ToArray()).ToList <MatUnit>();
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="condition">条件</param>
/// <returns>仓库列表</returns>
public List <ProductLine> GetList()
{
List <ProductLine> list = null;
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = "SELECT PID,PLCODE,PLNAME,FACTORYPID FROM T_FP_PRODUCTLINE ORDER BY PLCODE";
list = session.GetList <ProductLine>(sql, new List <DataParameter>().ToArray()).ToList <ProductLine>();
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="condition">条件</param>
/// <returns>仓库列表</returns>
public List <WHMat> GetList(WHMat condition)
{
List <WHMat> list = null;
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = "SELECT * FROM T_WH_Mat";
list = session.GetList <WHMat>(sql, new List <DataParameter>().ToArray()).ToList <WHMat>();
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="condition">条件</param>
/// <returns>仓库列表</returns>
public List <WorkStation> GetList()
{
List <WorkStation> list = null;
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = "SELECT PID,WSCODE,WSNAME FROM T_FP_WORKSTATION ORDER BY WSCODE";
list = session.GetList <WorkStation>(sql, new List <DataParameter>().ToArray()).ToList <WorkStation>();
}
return(list);
}
/// <summary>
/// 获取完成列表
/// </summary>
/// <param name="condition">条件</param>
/// <returns></returns>
public List <ProducePlan> GetCList()
{
List <ProducePlan> list = null;
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = "SELECT DISTINCT BATCHNUMBER FROM T_FP_PRODUCEPLAN WHERE Status='1' ORDER BY BATCHNUMBER";
list = session.GetList <ProducePlan>(sql, new List <DataParameter>().ToArray()).ToList <ProducePlan>();
}
return(list);
}
/// <summary>
/// 获取仓库权限
/// </summary>
/// <param name="userID">用户主键</param>
/// <returns>权限列表</returns>
public List <WarehousePower> GetWHPowers(string userID)
{
List <WarehousePower> list = new List <WarehousePower>();
List <DataParameter> parameters = new List <DataParameter>();
string sql = "select WarehouseID from T_WH_WHPower where UserID = @UserID";
parameters.Add(new DataParameter("UserID", userID));
using (IDataSession session = AppDataFactory.CreateMainSession())
{
list = session.GetList <WarehousePower>(sql, parameters.ToArray()).ToList();
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="condition">条件</param>
/// <returns>仓库列表</returns>
public List <WHMatSpec> GetList(WHMatSpec condition)
{
string sql = null;
List <WHMatSpec> list = null;
List <DataParameter> parameters = new List <DataParameter>();
sql = "SELECT * FROM T_WH_MatSpec where MatID = @MatID order by UnitName";
parameters.Add(new DataParameter("MatID", condition.MatID));
using (IDataSession session = AppDataFactory.CreateMainSession())
{
list = session.GetList <WHMatSpec>(sql, parameters.ToArray()).ToList();
}
return(list);
}
