using DataEntity;
|
using DataRWDAL;
|
using DataRWDAL.Base;
|
using HxEnum;
|
using MySql.Data.MySqlClient;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Collections.ObjectModel;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using XCommon.Log;
|
using XCommon.MySql;
|
|
namespace XImagingXhandler.XDAL
|
{
|
/// <summary>
|
/// 台面模板内板位关联操作类
|
/// </summary>
|
public class TabletopRelLatticeDB:BaseDB
|
{
|
#region 删除某台面模板内的所有板位数据
|
/// <summary>
|
/// 删除某台面模板内的所有板位数据
|
/// </summary>
|
/// <param name="tabletopid">台面模板Id</param>
|
/// <returns>1：成功；0：失败；</returns>
|
public static int DeleteTabletopRelLatticeIntodb(string tabletopid)
|
{
|
using (var db = GetInstance())
|
{
|
int sum = 0;//执行的总数
|
var query = db.Queryable<TabletopRelLattice>().Where(it => it.tabletopid.Equals(tabletopid)).ToList();
|
if(query!=null&&query.Count()>0)
|
{
|
foreach(var item in query)
|
{
|
Lattice lattice = LatticeDB.GetLatticeDataByIdFromdb(item.lattice_id.ToString());
|
lattice.lattice_state = 0;
|
int ret=DeleteLatticeFromdb(lattice);
|
if (ret == 1)
|
{
|
sum++;
|
}
|
}
|
|
if (sum == query.Count)
|
{
|
return 1;
|
}
|
}
|
|
return 0;
|
}
|
}
|
#endregion
|
|
#region 删除指定的台面模板内的板位数据
|
/// <summary>
|
/// 删除指定的台面模板内的板位数据
|
/// </summary>
|
/// <param name="lattice">板位</param>
|
/// <returns>1：成功；0:失败；</returns>
|
public static int DeleteLatticeFromdb(Lattice lattice)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<Lattice>(lattice).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 更新指定的台面模板内的板位数据
|
/// <summary>
|
/// 更新指定的台面模板内的板位数据
|
/// </summary>
|
/// <param name="lattice">板位</param>
|
/// <returns>1：成功；0:失败；</returns>
|
public static int UpdateLatticeFromdb(Lattice lattice)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<Lattice>(lattice).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 更新指定的台面模板与板位关系数据
|
/// <summary>
|
/// 更新指定的台面模板与板位关系数据
|
/// </summary>
|
/// <param name="tabletopRelLattice">台面与板位关系对象</param>
|
/// <returns>1：成功；0:失败；</returns>
|
public static int UpdateTabletopRelLatticeFromdb(TabletopRelLattice tabletopRelLattice)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<TabletopRelLattice>(tabletopRelLattice).Where(it=>it.tabletopid.Equals(tabletopRelLattice.tabletopid)
|
&&it.lattice_id.Equals(tabletopRelLattice.lattice_id)).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 获取当前最大的台面板位Id
|
/// <summary>
|
/// 获取当前最大的台面板位Id
|
/// </summary>
|
/// <returns>最大板位Id</returns>
|
public static int GetMaxLattceId()
|
{
|
using (var db = GetInstance())
|
{
|
return db.Queryable<Lattice>().ToList().Count;
|
}
|
}
|
#endregion
|
|
#region 获取台面板位关系数据 通过台面Id和板位Id
|
/// <summary>
|
/// 获取台面板位关系数据 通过台面Id和板位Id
|
/// </summary>
|
/// <param name="latticeId">板位Id</param>
|
/// <param name="tabletopId">台面Id</param>
|
/// <returns>台面板位关系数据</returns>
|
public static TabletopRelLattice GetTabletopRelLatticeByTabletopIdAndLatticeId(string tabletopId,int latticeId)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Queryable<TabletopRelLattice>().Single(it => it.tabletopid.Equals(tabletopId) && it.lattice_id.Equals(latticeId));
|
}
|
}
|
#endregion
|
|
#region 批量添加板位数据
|
/// <summary>
|
/// 批量添加板位数据
|
/// </summary>
|
/// <param name="lattice">板位对象</param>
|
/// <param name="startLatticeid">开始板位Id</param>
|
/// <param name="tabletopId">台面模板Id</param>
|
/// <returns></returns>
|
public static int AddLatticeIntodb(Lattice lattice,int startLatticeid,string tabletopId)
|
{
|
using (var db = GetInstance())
|
{
|
int sum = 0;//执行的总数
|
//for (int i = 0; i < lattices.Count; i++)
|
//{
|
|
lattice.lattice_id = (startLatticeid).ToString();
|
db.Insertable<Lattice>(lattice).ExecuteCommand();
|
|
int ret=db.Insertable<TabletopRelLattice>(new TabletopRelLattice() { lattice_id = (startLatticeid), tabletopid = tabletopId,
|
lattice_pixel_x = lattice.lattice_pixel_x,
|
lattice_pixel_y = lattice.lattice_pixel_y,
|
labware_id= lattice.labware_id,
|
isbaselattice = 1
|
}).ExecuteCommand();
|
sum++;
|
//}
|
|
//if(sum==lattices.Count)
|
//{
|
if(ret>0)
|
{
|
return ret;
|
}
|
//}
|
|
return 0;
|
}
|
}
|
#endregion
|
}
|
}
|
