/// <summary>
/// 按条件获取Tag点
/// 监控开启时直接获取内存的值，否则提取数据库的值
/// </summary>
public static List <FmsAssetTagSetting> GetTagSettings(string sWhere)
{
#region 整理查询条件
if (string.IsNullOrEmpty(sWhere))
{
sWhere = "USE_FLAG = 1";
}
else
{
sWhere = "USE_FLAG = 1 AND " + sWhere;
}
#endregion
if ((!bMonitor) || (_tagSettings == null)) //没有开启监控 || 空
{
WcfClient <IFMSService> wsthis = new WcfClient <IFMSService>();
return(wsthis.UseService(s => s.GetFmsAssetTagSettings(sWhere))); //获取Tag配置点
}
Expression <Func <FmsAssetTagSetting, bool> > whereLamda =
SerializerHelper.ConvertParamWhereToLinq <FmsAssetTagSetting>(sWhere);
return(_tagSettings.Where(whereLamda.Compile()).ToList());
}
public int GetRsFactoryCount(string sWhere)
{
Expression<Func<RsFactory, bool>> whereLamda = SerializerHelper.ConvertParamWhereToLinq<RsFactory>(sWhere);
using (IRsFactoryBLL RsFactoryBLL = BLLContainer.Resolve<IRsFactoryBLL>())
{
return RsFactoryBLL.GetCount(whereLamda);
}
}
public int GetTmsToolsMasterCount(string sWhere)
{
Expression <Func <TmsToolsMaster, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <TmsToolsMaster>(sWhere);
using (ITmsToolsMasterBLL TmsToolsMasterBLL = BLLContainer.Resolve <ITmsToolsMasterBLL>())
{
return(TmsToolsMasterBLL.GetCount(whereLamda));
}
}
public int GetDAMachineRealTimeInfoCount(string sWhere)
{
Expression <Func <DAMachineRealTimeInfo, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <DAMachineRealTimeInfo>(sWhere);
using (IDAMachineRealTimeInfoBLL DAMachineRealTimeInfoBLL = BLLContainer.Resolve <IDAMachineRealTimeInfoBLL>())
{
return(DAMachineRealTimeInfoBLL.GetCount(whereLamda));
}
}
public int GetFDIPostSaleOrderDetailCount(string sWhere)
{
Expression <Func <FDIPostSaleOrderDetail, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <FDIPostSaleOrderDetail>(sWhere);
using (IFDIPostSaleOrderDetailBLL FDIPostSaleOrderDetailBLL = BLLContainer.Resolve <IFDIPostSaleOrderDetailBLL>())
{
return(FDIPostSaleOrderDetailBLL.GetCount(whereLamda));
}
}
/// <summary>
/// 返回记录总数 配合分页查询用
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的记录数</returns>
public int GetMesProductProcessCount(string sWhere)
{
Expression <Func <MesProductProcess, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <MesProductProcess>(sWhere);
using (IMesProductProcessBLL MesProductProcessBLL = BLLContainer.Resolve <IMesProductProcessBLL>())
{
return(MesProductProcessBLL.GetCount(whereLamda));
}
}
public List<RsFactory> GetRsFactorys([FromBody]string sWhere)
{
Expression<Func<RsFactory, bool>> whereLamda = SerializerHelper.ConvertParamWhereToLinq<RsFactory>(sWhere);
using (IRsFactoryBLL RsFactoryBLL = BLLContainer.Resolve<IRsFactoryBLL>())
{
List<RsFactory> models = RsFactoryBLL.GetModels(whereLamda);
return models;
}
}
public int GetFDIGetMaterialInfoCount(string sWhere)
{
Expression <Func <FDIGetMaterialInfo, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <FDIGetMaterialInfo>(sWhere);
using (IFDIGetMaterialInfoBLL FDIGetMaterialInfoBLL = BLLContainer.Resolve <IFDIGetMaterialInfoBLL>())
{
return(FDIGetMaterialInfoBLL.GetCount(whereLamda));
}
}
public int GetPmTaskLineCount(string sWhere)
{
Expression <Func <PmTaskLine, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <PmTaskLine>(sWhere);
using (IPmTaskLineBLL PmTaskLineBLL = BLLContainer.Resolve <IPmTaskLineBLL>())
{
return(PmTaskLineBLL.GetCount(whereLamda));
}
}
public int GetRmRepairRecordCount(string sWhere)
{
Expression <Func <RmRepairRecord, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <RmRepairRecord>(sWhere);
using (IRmRepairRecordBLL RmRepairRecordBLL = BLLContainer.Resolve <IRmRepairRecordBLL>())
{
return(RmRepairRecordBLL.GetCount(whereLamda));
}
}
public int GetRsMaintainStandardsRelateCount(string sWhere)
{
Expression <Func <RsMaintainStandardsRelate, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <RsMaintainStandardsRelate>(sWhere);
using (IRsMaintainStandardsRelateBLL RsMaintainStandardsRelateBLL = BLLContainer.Resolve <IRsMaintainStandardsRelateBLL>())
{
return(RsMaintainStandardsRelateBLL.GetCount(whereLamda));
}
}
public int GetDAProductRecordCount(string sWhere)
{
Expression <Func <DAProductRecord, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <DAProductRecord>(sWhere);
using (IDAProductRecordBLL DAProductRecordBLL = BLLContainer.Resolve <IDAProductRecordBLL>())
{
return(DAProductRecordBLL.GetCount(whereLamda));
}
}
/// <summary>
/// 返回记录总数 配合分页查询用
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的记录数</returns>
public int GetAmAssetMasterNCount(string sWhere)
{
Expression <Func <AmAssetMasterN, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <AmAssetMasterN>(sWhere);
using (IAmAssetMasterNBLL AmAssetMasterNBLL = BLLContainer.Resolve <IAmAssetMasterNBLL>())
{
return(AmAssetMasterNBLL.GetCount(whereLamda));
}
}
/// <summary>
/// 返回记录总数 配合分页查询用
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的记录数</returns>
public int GetTestEFCodeFirstCount(string sWhere)
{
Expression <Func <TestEFCodeFirst, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <TestEFCodeFirst>(sWhere);
using (ITestEFCodeFirstBLL TestEFCodeFirstBLL = BLLContainer.Resolve <ITestEFCodeFirstBLL>())
{
return(TestEFCodeFirstBLL.GetCount(whereLamda));
}
}
/// <summary>
/// 返回记录总数 配合分页查询用
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的记录数</returns>
public int GetSysUserMenuCount(string sWhere)
{
Expression <Func <SysUserMenu, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <SysUserMenu>(sWhere);
using (ISysUserMenuBLL SysUserMenuBLL = BLLContainer.Resolve <ISysUserMenuBLL>())
{
return(SysUserMenuBLL.GetCount(whereLamda));
}
}
public int GetFDIPostWOCloseBatchCount(string sWhere)
{
Expression <Func <FDIPostWOCloseBatch, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <FDIPostWOCloseBatch>(sWhere);
using (IFDIPostWOCloseBatchBLL FDIPostWOCloseBatchBLL = BLLContainer.Resolve <IFDIPostWOCloseBatchBLL>())
{
return(FDIPostWOCloseBatchBLL.GetCount(whereLamda));
}
}
public int GetFmsAssetCommParamCount(string sWhere)
{
Expression <Func <FmsAssetCommParam, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <FmsAssetCommParam>(sWhere);
using (IFmsAssetCommParamBLL FmsAssetCommParamBLL = BLLContainer.Resolve <IFmsAssetCommParamBLL>())
{
return(FmsAssetCommParamBLL.GetCount(whereLamda));
}
}
public int GetWmsInventoryCount(string sWhere)
{
Expression <Func <WmsInventory, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <WmsInventory>(sWhere);
using (IWmsInventoryBLL WmsInventoryBLL = BLLContainer.Resolve <IWmsInventoryBLL>())
{
return(WmsInventoryBLL.GetCount(whereLamda));
}
}
/// <summary>
/// 返回记录总数 配合分页查询用
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的记录数</returns>
public int GetQmsCheckParamCount(string sWhere)
{
Expression <Func <QmsCheckParam, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <QmsCheckParam>(sWhere);
using (IQmsCheckParamBLL QmsCheckParamBLL = BLLContainer.Resolve <IQmsCheckParamBLL>())
{
return(QmsCheckParamBLL.GetCount(whereLamda));
}
}
public int GetRsRoutingCheckCount(string sWhere)
{
Expression <Func <RsRoutingCheck, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <RsRoutingCheck>(sWhere);
using (IRsRoutingCheckBLL RsRoutingCheckBLL = BLLContainer.Resolve <IRsRoutingCheckBLL>())
{
return(RsRoutingCheckBLL.GetCount(whereLamda));
}
}
/// <summary>
/// 返回记录总数 配合分页查询用
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的记录数</returns>
public int GetFmsStateResultRecordCount(string sWhere)
{
Expression <Func <FmsStateResultRecord, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <FmsStateResultRecord>(sWhere);
using (IFmsStateResultRecordBLL FmsStateResultRecordBLL = BLLContainer.Resolve <IFmsStateResultRecordBLL>())
{
return(FmsStateResultRecordBLL.GetCount(whereLamda));
}
}
public List <RsRoutingCheck> GetRsRoutingChecks([FromBody] string sWhere)
{
Expression <Func <RsRoutingCheck, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <RsRoutingCheck>(sWhere);
using (IRsRoutingCheckBLL RsRoutingCheckBLL = BLLContainer.Resolve <IRsRoutingCheckBLL>())
{
List <RsRoutingCheck> models = RsRoutingCheckBLL.GetModels(whereLamda);
return(models);
}
}
/// <summary>
/// 根据查询条件获取记录
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的List</returns>
public List <TestEFCodeFirst> GetTestEFCodeFirsts(string sWhere)
{
Expression <Func <TestEFCodeFirst, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <TestEFCodeFirst>(sWhere);
using (ITestEFCodeFirstBLL TestEFCodeFirstBLL = BLLContainer.Resolve <ITestEFCodeFirstBLL>())
{
List <TestEFCodeFirst> models = TestEFCodeFirstBLL.GetModels(whereLamda);
return(models);
}
}
/// <summary>
/// 根据查询条件获取记录
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的List</returns>
public List <SysUserMenu> GetSysUserMenus(string sWhere)
{
Expression <Func <SysUserMenu, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <SysUserMenu>(sWhere);
using (ISysUserMenuBLL SysUserMenuBLL = BLLContainer.Resolve <ISysUserMenuBLL>())
{
List <SysUserMenu> models = SysUserMenuBLL.GetModels(whereLamda);
return(models);
}
}
public List <WmsInventory> GetWmsInventorys([FromBody] string sWhere)
{
Expression <Func <WmsInventory, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <WmsInventory>(sWhere);
using (IWmsInventoryBLL WmsInventoryBLL = BLLContainer.Resolve <IWmsInventoryBLL>())
{
List <WmsInventory> models = WmsInventoryBLL.GetModels(whereLamda);
return(models);
}
}
public List <SysUserPurview> GetSysUserPurviews([FromBody] string sWhere)
{
Expression <Func <SysUserPurview, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <SysUserPurview>(sWhere);
using (ISysUserPurviewBLL SysUserPurviewBLL = BLLContainer.Resolve <ISysUserPurviewBLL>())
{
List <SysUserPurview> models = SysUserPurviewBLL.GetModels(whereLamda);
return(models);
}
}
public List <FmsAssetCommParam> GetFmsAssetCommParams([FromBody] string sWhere)
{
Expression <Func <FmsAssetCommParam, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <FmsAssetCommParam>(sWhere);
using (IFmsAssetCommParamBLL FmsAssetCommParamBLL = BLLContainer.Resolve <IFmsAssetCommParamBLL>())
{
List <FmsAssetCommParam> models = FmsAssetCommParamBLL.GetModels(whereLamda);
return(models);
}
}
public List <DAProductRecord> GetDAProductRecords(string sWhere)
{
Expression <Func <DAProductRecord, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <DAProductRecord>(sWhere);
using (IDAProductRecordBLL DAProductRecordBLL = BLLContainer.Resolve <IDAProductRecordBLL>())
{
List <DAProductRecord> models = DAProductRecordBLL.GetModels(whereLamda);
return(models);
}
}
public List <FDIPostWOCloseBatch> GetFDIPostWOCloseBatchs(string sWhere)
{
Expression <Func <FDIPostWOCloseBatch, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <FDIPostWOCloseBatch>(sWhere);
using (IFDIPostWOCloseBatchBLL FDIPostWOCloseBatchBLL = BLLContainer.Resolve <IFDIPostWOCloseBatchBLL>())
{
List <FDIPostWOCloseBatch> models = FDIPostWOCloseBatchBLL.GetModels(whereLamda);
return(models);
}
}
/// <summary>
/// 根据查询条件获取记录
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的List</returns>
public List <AmAssetMasterN> GetAmAssetMasterNs(string sWhere)
{
Expression <Func <AmAssetMasterN, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <AmAssetMasterN>(sWhere);
using (IAmAssetMasterNBLL AmAssetMasterNBLL = BLLContainer.Resolve <IAmAssetMasterNBLL>())
{
List <AmAssetMasterN> models = AmAssetMasterNBLL.GetModels(whereLamda);
return(models);
}
}
