using DataRWDAL.Base;
|
using System;
|
using System.Collections.Generic;
|
using System.Collections.ObjectModel;
|
using System.Reflection;
|
using XImagingXhandler.XDAL;
|
|
namespace DataRWDAL
|
{
|
/// <summary>
|
/// 获取液体类型库表操作类
|
/// </summary>
|
public class LiquidTypeDB:BaseDB
|
{
|
#region 查询返回液体类型数据集 by 查询请求类型
|
/// <summary>
|
/// 查询返回液体类型数据集 by 查询请求类型
|
/// </summary>
|
/// <param name="lType">1:默认类型；0：非默认；2：全部类型</param>
|
/// <returns>液体类型数据集</returns>
|
public static ObservableCollection<LiquidType> GetLiquidTypeFromdb(int lType)
|
{
|
using (var db = GetInstance())
|
{
|
if (lType == 1 || lType == 0)
|
{
|
return new ObservableCollection<LiquidType>(db.Queryable<LiquidType>().Where(it => it.is_default_type.Equals(lType)
|
&& it.liquid_type_status.Equals(1)).OrderBy(it => it.timestamp, SqlSugar.OrderByType.Asc).ToList());
|
}
|
else if (lType == 2)
|
{
|
return new ObservableCollection<LiquidType>(db.Queryable<LiquidType>().Where(it => it.liquid_type_status.Equals(1)).OrderBy(it => it.timestamp, SqlSugar.OrderByType.Asc).ToList());
|
}
|
else
|
{
|
return null;
|
}
|
}
|
}
|
#endregion
|
|
#region 添加一条新的液体类型数据 by 液体类型数据
|
/// <summary>
|
/// 添加一条新的液体类型数据 by 液体类型数据
|
/// </summary>
|
/// <param name="liquidType">液体类型对象</param>
|
/// <returns>1:成功；0:失败</returns>
|
public static int AddLiquidTypeIntodb(LiquidType liquidType)
|
{
|
using (var db = GetInstance())
|
{
|
var result = 0;
|
db.BeginTran(); // 开启事务
|
try
|
{
|
result = db.Insertable<LiquidType>(liquidType).ExecuteCommand();
|
db.CommitTran(); // 提交事务
|
}
|
catch (Exception ex)
|
{
|
db.RollbackTran(); // 事务回滚
|
// 处理异常
|
result = 0;
|
}
|
return result;
|
}
|
}
|
#endregion
|
}
|
}
|
