using DataRWDAL.Base;
|
using System.Collections.Generic;
|
using System.Collections.ObjectModel;
|
using System.Reflection;
|
using XImagingXhandler.XDAL;
|
|
namespace DataRWDAL
|
{
|
/// <summary>
|
/// 菌落库表操作类
|
/// </summary>
|
public class BacteriaDB: BaseDB
|
{
|
#region 根据菌落Id，获取菌落信息
|
/// <summary>
|
/// 根据菌落Id，获取菌落信息
|
/// </summary>
|
/// <param name="bacteriaid">菌落Id</param>
|
/// <returns>菌落对象</returns>
|
public static Bacteria GetABacteriaFromdb(string bacteriaid)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Queryable<Bacteria>().Single(it => it.bacteria_id.Equals(bacteriaid));
|
}
|
}
|
#endregion
|
|
#region 添加一条新的菌数据 by 菌落对象
|
/// <summary>
|
/// 添加一条新的菌落数据 by 菌落对象
|
/// </summary>
|
/// <param name="bacteria">菌落对象</param>
|
/// <returns>1:成功；0:失败</returns>
|
public static int AddBacteriaIntodb(Bacteria bacteria)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Insertable<Bacteria>(bacteria).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 查询菌落是否重名 by 菌落对象
|
/// <summary>
|
/// 查询菌落是否重名 by 菌落对象
|
/// </summary>
|
/// <param name="bacteria">菌落对象</param>
|
/// <returns>true:存在；false:不存在</returns>
|
public static bool GetIsDoubleBacteriaOndb(Bacteria bacteria)
|
{
|
bool isExistUser = false;
|
int count = 0;
|
using (var db = GetInstance())
|
{
|
if (bacteria.bacteria_id != "")
|
{
|
count= db.Queryable<Bacteria>().Where(it => it.bacteria_name.Equals(bacteria.bacteria_name)&&!it.bacteria_id.Equals(bacteria.bacteria_id)&&it.bacteria_status.Equals(1)).Count();
|
}
|
else
|
{
|
count = db.Queryable<Bacteria>().Where(it => it.bacteria_name.Equals(bacteria.bacteria_name) && it.bacteria_status.Equals(1)).Count();
|
}
|
|
if(count>0)
|
{
|
isExistUser = true;
|
}
|
else
|
{
|
isExistUser = false;
|
}
|
}
|
return isExistUser;
|
}
|
#endregion
|
|
#region 修改一条新的菌落数据 by 菌落对象
|
/// <summary>
|
/// 修改一条新的菌落数据 by 菌落对象
|
/// </summary>
|
/// <param name="bacteria">菌落对象</param>
|
/// <returns>1：成功；0：失败</returns>
|
public static int UpdateBacteriaIntodb(Bacteria bacteria)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<Bacteria>(bacteria).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 查询返回菌落数据集 by 默认类型
|
/// <summary>
|
/// 查询返回菌落数据集 by 默认类型
|
/// </summary>
|
/// <param name="isDefault">1:系统默认；0：非默认；2：全部</param>
|
/// <returns></returns>
|
public static ObservableCollection<Bacteria> GetBacteriaListFromdb(int isDefault)
|
{
|
using (var db = GetInstance())
|
{
|
if (isDefault == 2)
|
{
|
return new ObservableCollection<Bacteria>(db.Queryable<Bacteria>().Where(it => it.bacteria_status.Equals(1)).ToList());
|
}
|
else
|
{
|
return new ObservableCollection<Bacteria>(db.Queryable<Bacteria>().Where(it => it.bacteria_status.Equals(1)&&it.is_default_type.Equals(isDefault)).ToList());
|
}
|
}
|
|
}
|
#endregion
|
|
#region 构建返回挑菌位置数据集合信息
|
/// <summary>
|
/// 构建返回挑菌位置数据集合信息
|
/// </summary>
|
/// <returns>挑菌位置实体集合</returns>
|
public static ObservableCollection<DropdownName> GetBacteriaPositionListFromdb()
|
{
|
ObservableCollection<DropdownName> dropdowns = new ObservableCollection<DropdownName>();
|
|
DropdownName dropdown = new DropdownName();
|
|
dropdown.dropdown_id = "1";
|
dropdown.dropdown_name = "距离皿底距离";
|
dropdowns.Add(dropdown);
|
|
dropdown = new DropdownName();
|
|
dropdown.dropdown_id = "2";
|
dropdown.dropdown_name = "菌表面距离";
|
dropdowns.Add(dropdown);
|
|
return dropdowns;
|
}
|
#endregion
|
}
|
}
|
