/// <summary>
/// 根据关键字段的值获取记录
/// </summary>
/// <param name="Id">关键字段的值</param>
/// <returns>符合查询条件的记录</returns>
//[WebMethod(Description = "按Id查找TmsDeviceToolsPos")]
public TmsDeviceToolsPos GetTmsDeviceToolsPosById(string Id)
{
using (ITmsDeviceToolsPosBLL TmsDeviceToolsPosBLL = BLLContainer.Resolve <ITmsDeviceToolsPosBLL>())
{
TmsDeviceToolsPos model = TmsDeviceToolsPosBLL.GetFirstOrDefault(Id);
return(model);
}
}
/// <summary>
/// 返回记录总数 配合分页查询用
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的记录数</returns>
//[WebMethod(Description = "返回TmsDeviceToolsPos行数")]
public int GetTmsDeviceToolsPosCount(string sWhere)
{
Expression <Func <TmsDeviceToolsPos, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <TmsDeviceToolsPos>(sWhere);
using (ITmsDeviceToolsPosBLL TmsDeviceToolsPosBLL = BLLContainer.Resolve <ITmsDeviceToolsPosBLL>())
{
return(TmsDeviceToolsPosBLL.GetCount(whereLamda));
}
}
/// <summary>
/// 根据查询条件获取记录
/// </summary>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的List</returns>
//[WebMethod(Description = "返回所有TmsDeviceToolsPos")]
public List <TmsDeviceToolsPos> GetTmsDeviceToolsPoss(string sWhere)
{
Expression <Func <TmsDeviceToolsPos, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <TmsDeviceToolsPos>(sWhere);
using (ITmsDeviceToolsPosBLL TmsDeviceToolsPosBLL = BLLContainer.Resolve <ITmsDeviceToolsPosBLL>())
{
List <TmsDeviceToolsPos> models = TmsDeviceToolsPosBLL.GetModels(whereLamda);
return(models);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="mTmsDeviceToolsPos">模型</param>
/// <returns>是否成功</returns>
//[WebMethod(Description = "新建TmsDeviceToolsPos")]
public bool AddTmsDeviceToolsPos(TmsDeviceToolsPos mTmsDeviceToolsPos)
{
if (mTmsDeviceToolsPos == null)
{
return(false);
}
using (ITmsDeviceToolsPosBLL TmsDeviceToolsPosBLL = BLLContainer.Resolve <ITmsDeviceToolsPosBLL>())
{
return(TmsDeviceToolsPosBLL.Add(mTmsDeviceToolsPos));
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Id">关键字段</param>
/// <returns>是否成功</returns>
//[WebMethod(Description = "删除TmsDeviceToolsPos")]
public bool DelTmsDeviceToolsPos(string Id)
{
using (ITmsDeviceToolsPosBLL TmsDeviceToolsPosBLL = BLLContainer.Resolve <ITmsDeviceToolsPosBLL>())
{
try
{
TmsDeviceToolsPos item = TmsDeviceToolsPosBLL.GetFirstOrDefault(Id);
return(TmsDeviceToolsPosBLL.Delete(item));
}
catch { return(false); }
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Ids">关键字段数组</param>
/// <returns>是否成功</returns>
//[WebMethod(Description = "删除（多个）TmsDeviceToolsPos")]
public bool DelTmsDeviceToolsPoss(string[] Ids)
{
using (ITmsDeviceToolsPosBLL TmsDeviceToolsPosBLL = BLLContainer.Resolve <ITmsDeviceToolsPosBLL>())
{
try
{
List <TmsDeviceToolsPos> entitys = new List <TmsDeviceToolsPos>();
foreach (string id in Ids)
{
TmsDeviceToolsPos item = TmsDeviceToolsPosBLL.GetFirstOrDefault(id);
entitys.Add(item);
}
return(TmsDeviceToolsPosBLL.Delete(entitys));
}
catch { return(false); }
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageSize">单页的记录数</param>
/// <param name="pageIndex">页码</param>
/// <param name="isAsc">是否正序排序</param>
/// <param name="orderField">排序字段 为空时默认为 CREATION_DATE </param>
/// <param name="sWhere">查询条件；多条件是目前只支持 and；表达式 System.Linq.Dynamic的形式</param>
/// <returns>符合查询条件的List结果</returns>
//[WebMethod(Description = "返回分页TmsDeviceToolsPos")]
public List <TmsDeviceToolsPos> GetTmsDeviceToolsPosByPage(int pageSize, int pageIndex, bool isAsc, string orderField, string sWhere)
{
string orderStr = "";
if (string.IsNullOrEmpty(orderField))
{
orderStr = "CREATION_DATE";
}
else
{
orderStr = orderField;
}
Expression <Func <TmsDeviceToolsPos, bool> > whereLamda = SerializerHelper.ConvertParamWhereToLinq <TmsDeviceToolsPos>(sWhere);
using (ITmsDeviceToolsPosBLL TmsDeviceToolsPosBLL = BLLContainer.Resolve <ITmsDeviceToolsPosBLL>())
{
List <TmsDeviceToolsPos> models = TmsDeviceToolsPosBLL.GetModelsByPage(pageSize, pageIndex, isAsc, orderStr, whereLamda);
return(models);
}
}
