using DataRWDAL.Base;
|
using SqlSugar;
|
using System.Collections.Generic;
|
using System.Collections.ObjectModel;
|
using System.Reflection;
|
using XImagingXhandler.XDAL;
|
|
namespace DataRWDAL
|
{
|
/// <summary>
|
/// 液体参数库表操作类
|
/// </summary>
|
public class LiquidDB:BaseDB
|
{
|
#region 查询返回一条液体参数数据 by 液体参数Id
|
/// <summary>
|
/// 查询返回一条液体参数数据 by 液体参数Id
|
/// </summary>
|
/// <param name="liquidid">液体参数Id</param>
|
/// <returns>1：成功；0：失败</returns>
|
public static Liquid GetALiquidFromdb(string liquidid)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Queryable<Liquid>().Where(it=>it.liquid_id.Equals(liquidid)&&it.liquid_status.Equals(1)).First();
|
}
|
}
|
#endregion
|
|
#region 添加一条新的液体参数数据 by 液体参数数据
|
/// <summary>
|
/// 添加一条新的液体参数数据 by 液体参数数据
|
/// </summary>
|
/// <param name="liquid">液体参数数据</param>
|
/// <returns>1:成功；0：失败</returns>
|
public static int AddLiquidIntodb(Liquid liquid)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Insertable<Liquid>(liquid).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 修改一条新的液体参数数据 by 液体参数数据
|
/// <summary>
|
/// 修改一条新的液体参数数据 by 液体参数数据
|
/// </summary>
|
/// <param name="liquid">液体参数数据</param>
|
/// <returns>1:成功；0：失败</returns>
|
public static int UpdateLiquidIntodb(Liquid liquid)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<Liquid>(liquid).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 查找返回是否存在一条相同名称的液体参数 by 液体范围数据对象、液体类型名称
|
/// <summary>
|
/// 查找返回是否存在一条相同名称的液体参数 by 液体范围数据对象、液体类型名称
|
/// </summary>
|
/// <param name="liquidTypeRSRange">液体范围数据对象</param>
|
/// <param name="liquidName">液体类型名称</param>
|
/// <returns>-1:不存在；其它值：存在</returns>
|
public static string IsExistSameNameLiquidTypeRSRangeIntodb(LiquidTypeRSRange liquidTypeRSRange, string liquidName)
|
{
|
string iResult = "-1";
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable("LiquidTypeRSRange", "t").AddJoinInfo("Liquid", "l", "t.liquid_id=l.liquid_id and t.liquid_type_id='"
|
+ liquidTypeRSRange.liquid_type_id + "'"
|
+ " and t.liquid_range_id='" + liquidTypeRSRange.liquid_range_id + "'"
|
+ " and t.device_arm_id=" + liquidTypeRSRange.device_arm_id
|
+ " and l.liquid_name='" + liquidName + "'"
|
+ " and l.liquid_status=1", JoinType.Inner)
|
.Select("l.*");
|
|
//var query= db.Queryable<Liquid, LiquidTypeRSRange>((st, sc) => st.liquid_id == sc.liquid_id).Where(st=>st.liquid_name.Equals(liquidName)
|
// && st.liquid_type_id.Equals(liquidTypeRSRange.liquid_type_id)
|
// && st.liquid_range_id.Equals(liquidTypeRSRange.liquid_range_id)
|
// && st.device_arm_id.Equals(liquidTypeRSRange.device_arm_id.ToString())
|
// && st.liquid_status.Equals(1)).ToList();
|
iResult = query.ToList().Count.ToString();
|
}
|
return iResult;
|
}
|
#endregion
|
|
#region 查询返回是否存在一条同名的液体参数数据 by 液体类型
|
/// <summary>
|
/// 查询返回是否存在一条同名的液体参数数据 by 液体类型
|
/// </summary>
|
/// <param name="liquidType">液体类型</param>
|
/// <returns>-1:不存在；其它值：存在</returns>
|
public static string IsExistLiquidTypeIntodb(string liquidType)
|
{
|
string iResult = "-1";
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<LiquidType>().Where(it=>it.liquid_type_name.Equals(liquidType)).ToList();
|
iResult = query.Count.ToString();
|
}
|
return iResult;
|
}
|
#endregion
|
|
#region 删除一条新的液体参数数据 by 液体参数数据对象
|
/// <summary>
|
/// 删除一条新的液体参数数据 by 液体参数数据对象
|
/// </summary>
|
/// <param name="liquid">液体参数数据对象</param>
|
/// <returns>1:成功；0：失败</returns>
|
public static int DeleteLiquidIntodb(Liquid liquid)
|
{
|
using (var db = GetInstance())
|
{
|
liquid.liquid_status= 0;
|
return db.Updateable<Liquid>(liquid).ExecuteCommand();
|
}
|
}
|
#endregion
|
}
|
}
|
