using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using XImagingXhandler.XDAL;
|
using System.Data;
|
using XCoreBLL.Resource;
|
using System.Xml;
|
using XCommon;
|
using DataEntity.Share;
|
using DataRWDAL;
|
using DataEntity;
|
|
namespace XCore
|
{
|
/// <summary>
|
/// 文件移液业务逻辑类
|
/// </summary>
|
public class TransferFileBll
|
{
|
WellFileCalc wellFileCalc = new WellFileCalc();
|
|
#region 获取DataTable的表头名称数据集合
|
/// <summary>
|
/// 获取DataTable的表头名称数据集合
|
/// </summary>
|
/// <param name="dataTable"></param>
|
/// <returns></returns>
|
public List<TransferFileHeader> GetTransferFileHeaders(DataTable dataTable)
|
{
|
List<TransferFileHeader> transferFileHeaders = new List<TransferFileHeader>();
|
|
TransferFileHeader transferFileHeader = new TransferFileHeader();
|
transferFileHeader.header_id = "0";
|
transferFileHeader.header_name = "请选择";
|
transferFileHeaders.Add(transferFileHeader);
|
|
for (int i = 0; i < dataTable.Columns.Count; i++)
|
{
|
transferFileHeader = new TransferFileHeader();
|
transferFileHeader.header_id = dataTable.Columns[i].ColumnName;
|
transferFileHeader.header_name = dataTable.Columns[i].ColumnName;
|
transferFileHeaders.Add(transferFileHeader);
|
}
|
return transferFileHeaders;
|
}
|
#endregion
|
|
public MethodTransferFile GenerateMethodTransferFileDataByXmlNode(XmlNode xmlNode)
|
{
|
MethodTransferFile methodTransferFile = new MethodTransferFile();
|
|
methodTransferFile.isrun = xmlNode.SelectSingleNode("isrun").InnerText;
|
methodTransferFile.status = xmlNode.SelectSingleNode("status").InnerText;
|
methodTransferFile.name = xmlNode.SelectSingleNode("name").InnerText;
|
methodTransferFile.label = xmlNode.SelectSingleNode("label").InnerText;
|
methodTransferFile.strIndex = xmlNode.SelectSingleNode("strIndex").InnerText;
|
methodTransferFile.armText = xmlNode.SelectSingleNode("arm/text").InnerText;
|
methodTransferFile.armValue = xmlNode.SelectSingleNode("arm/value").InnerText;
|
methodTransferFile.headType = xmlNode.SelectSingleNode("headType").InnerText;
|
methodTransferFile.labwaretipText = xmlNode.SelectSingleNode("labwaretip/text").InnerText;
|
methodTransferFile.labwaretipValue = xmlNode.SelectSingleNode("labwaretip/value").InnerText;
|
|
string strchs = xmlNode.SelectSingleNode("channels").InnerText;
|
methodTransferFile.channels = ComUtility.GetChannelsFromXml(strchs);
|
|
methodTransferFile.filePath = xmlNode.SelectSingleNode("filePath").InnerText;
|
methodTransferFile.beginLine = Convert.ToInt32(xmlNode.SelectSingleNode("beginLine").InnerText);
|
methodTransferFile.transferDataTable = GenerateTransferFileDataTable(xmlNode);
|
methodTransferFile.sourceLabware = xmlNode.SelectSingleNode("sourceLabware").InnerText;
|
methodTransferFile.sourceWell = xmlNode.SelectSingleNode("sourceWell").InnerText;
|
methodTransferFile.destinationLabware = xmlNode.SelectSingleNode("destinationLabware").InnerText;
|
methodTransferFile.destinationWell = xmlNode.SelectSingleNode("destinationWell").InnerText;
|
methodTransferFile.destVolume = xmlNode.SelectSingleNode("destVolume").InnerText;
|
methodTransferFile.tipSet = xmlNode.SelectSingleNode("tipSet").InnerText;
|
methodTransferFile.changeTipsMode = Convert.ToInt32(xmlNode.SelectSingleNode("changeTipsMode").InnerText);
|
methodTransferFile.changeToTipText = xmlNode.SelectSingleNode("changeToTipText").InnerText;
|
methodTransferFile.changeToTipValue = Convert.ToInt32(xmlNode.SelectSingleNode("changeToTipValue").InnerText);
|
|
methodTransferFile.jump0Volume = xmlNode.SelectSingleNode("jump0Volume").InnerText.ToLower() == "true" ? true : false;
|
methodTransferFile.liquididText = xmlNode.SelectSingleNode("liquidid/text").InnerText;
|
methodTransferFile.liquididValue = xmlNode.SelectSingleNode("liquidid/value").InnerText;
|
methodTransferFile.liquidrangeidText = xmlNode.SelectSingleNode("liquidrangeid/text").InnerText;
|
methodTransferFile.liquidrangeidValue = xmlNode.SelectSingleNode("liquidrangeid/value").InnerText;
|
methodTransferFile.liquidpidText = xmlNode.SelectSingleNode("liquidpid/text").InnerText;
|
methodTransferFile.liquidpidValue = xmlNode.SelectSingleNode("liquidpid/value").InnerText;
|
methodTransferFile.bMix = xmlNode.SelectSingleNode("enableMix").InnerText.ToLower() == "true" ? true : false;
|
methodTransferFile.mixvolume = Convert.ToDouble(xmlNode.SelectSingleNode("mixvolume").InnerText);
|
methodTransferFile.mixcount = Convert.ToInt32(xmlNode.SelectSingleNode("mixcount").InnerText);
|
methodTransferFile.mixAspiratePositionText = xmlNode.SelectSingleNode("mixAspiratePosition/text").InnerText;
|
methodTransferFile.mixAspiratePositionValue = Convert.ToInt32(xmlNode.SelectSingleNode("mixAspiratePosition/value").InnerText);
|
methodTransferFile.mixAspirateDistance = Convert.ToDouble(xmlNode.SelectSingleNode("mixAspirateDistance").InnerText);
|
methodTransferFile.mixAspirateSpeed = Convert.ToDouble(xmlNode.SelectSingleNode("mixAspirateSpeed").InnerText);
|
methodTransferFile.mixDispensePositionText = xmlNode.SelectSingleNode("mixDispensePosition/text").InnerText;
|
methodTransferFile.mixDispensePositionValue = Convert.ToInt32(xmlNode.SelectSingleNode("mixDispensePosition/value").InnerText);
|
methodTransferFile.mixDispenseDistance = Convert.ToDouble(xmlNode.SelectSingleNode("mixDispenseDistance").InnerText);
|
methodTransferFile.mixDispenseSpeed = Convert.ToDouble(xmlNode.SelectSingleNode("mixDispenseSpeed").InnerText);
|
|
|
methodTransferFile.enableLiquidSensor = xmlNode.SelectSingleNode("enableLiquidSensor").InnerText.ToLower() == "true" ? true : false;
|
methodTransferFile.liquidSensorCount = Convert.ToInt32(xmlNode.SelectSingleNode("liquidSensorCount").InnerText);
|
methodTransferFile.liquidSensorDistance = Convert.ToDouble(xmlNode.SelectSingleNode("liquidSensorDistance").InnerText);
|
methodTransferFile.liquidSensorEndDistance = Convert.ToDouble(xmlNode.SelectSingleNode("liquidSensorEndDistance").InnerText);
|
methodTransferFile.liquidSensorSpeed = Convert.ToDouble(xmlNode.SelectSingleNode("liquidSensorSpeed").InnerText);
|
methodTransferFile.liquidSensorRadio = Convert.ToDouble(xmlNode.SelectSingleNode("liquidSensorRadio").InnerText);
|
methodTransferFile.liquidSensorDisIdText = xmlNode.SelectSingleNode("liquidSensorDisId/text").InnerText;
|
methodTransferFile.liquidSensorDisIdValue = Convert.ToDouble(xmlNode.SelectSingleNode("liquidSensorDisId/value").InnerText);
|
methodTransferFile.enableLiquidFollow = xmlNode.SelectSingleNode("enableLiquidFollow").InnerText.ToLower() == "true" ? true : false;
|
methodTransferFile.liquidFollowType = Convert.ToInt32(xmlNode.SelectSingleNode("liquidFollowType/value").InnerText);
|
methodTransferFile.liquidFollowTypeName = xmlNode.SelectSingleNode("liquidFollowType/text").InnerText;
|
methodTransferFile.liquidFollowSpeed = Convert.ToDouble(xmlNode.SelectSingleNode("liquidFollowSpeed").InnerText);
|
methodTransferFile.liquidFollowDistance = Convert.ToDouble(xmlNode.SelectSingleNode("liquidFollowDistance").InnerText);
|
methodTransferFile.liquidFollowArea = Convert.ToDouble(xmlNode.SelectSingleNode("liquidFollowArea").InnerText);
|
methodTransferFile.enableMixFollow = xmlNode.SelectSingleNode("enableMixFollow").InnerText.ToLower() == "true" ? true : false;
|
|
methodTransferFile.enableSensorBlock = xmlNode.SelectSingleNode("enableSensorBlock").InnerText.ToLower() == "true" ? true : false;
|
//methodTransferFile.liquidSensorBlockDistance = Convert.ToDouble(xmlNode.SelectSingleNode("liquidSensorBlockDistance").InnerText);
|
methodTransferFile.aspirateBlockDisIdText = xmlNode.SelectSingleNode("aspirateBlockDisId/text").InnerText;
|
methodTransferFile.aspirateBlockDisIdValue = Convert.ToInt32(xmlNode.SelectSingleNode("aspirateBlockDisId/value").InnerText);
|
methodTransferFile.dispenseBlockDisIdText = xmlNode.SelectSingleNode("dispenseBlockDisId/text").InnerText;
|
methodTransferFile.dispenseBlockDisIdValue = Convert.ToInt32(xmlNode.SelectSingleNode("dispenseBlockDisId/value").InnerText);
|
methodTransferFile.aspirateAirDisIdText = xmlNode.SelectSingleNode("aspirateAirDisId/text").InnerText;
|
methodTransferFile.aspirateAirDisIdValue = Convert.ToInt32(xmlNode.SelectSingleNode("aspirateAirDisId/value").InnerText);
|
return methodTransferFile;
|
}
|
|
public DataTable GenerateTransferFileDataTable(XmlNode xmlNode)
|
{
|
XmlNode xmlNode2 = xmlNode.SelectSingleNode("transferDataTable");
|
DataTable dataTable = new DataTable();
|
foreach (XmlNode childNode in xmlNode2.ChildNodes)
|
{
|
DataColumn dataColumn = new DataColumn();
|
dataColumn.ColumnName = childNode.Attributes["columnname"].Value.ToString();
|
dataTable.Columns.Add(dataColumn);
|
}
|
if (xmlNode2.ChildNodes[0] != null)
|
{
|
for (int i = 0; i < xmlNode2.ChildNodes[0].ChildNodes.Count; i++)
|
{
|
DataRow dataRow = dataTable.NewRow();
|
for (int j = 0; j < xmlNode2.ChildNodes.Count; j++)
|
{
|
dataRow[j] = xmlNode2.ChildNodes[j].ChildNodes[i].InnerText;
|
}
|
|
dataTable.Rows.Add(dataRow);
|
}
|
}
|
|
return dataTable;
|
}
|
|
|
#region 当前系统语言
|
string strCurrentCulture = "";
|
#endregion
|
|
#region 构造函数
|
public TransferFileBll()
|
{
|
strCurrentCulture = System.Threading.Thread.CurrentThread.CurrentCulture.Name;
|
}
|
#endregion
|
|
#region 检查所有属性设置是否满足要求
|
/// <summary>
|
/// 检查所有属性设置是否满足要求
|
/// </summary>
|
/// <param name="methodTransferFile">文件移液属性对象</param>
|
/// <returns>检查所有属性设置是否满足要求</returns>
|
public MethodPropertyInfo CheckProperty(MethodTransferFile methodTransferFile)
|
{
|
MethodPropertyInfo methodPropertyInfo = new MethodPropertyInfo();
|
|
if (strCurrentCulture == "zh-CN")
|
{
|
methodPropertyInfo.property_tips_info = TransferFileResourceCHS.tipsInfo.ToString();
|
|
if (methodTransferFile.armText == null || methodTransferFile.armText == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.armText.ToString();
|
}
|
//if (methodTransferFile.aspirateMixCount != null || methodTransferFile.aspirateMixCount != "")
|
//{
|
// if (methodTransferFile.aspirateMixVolume == null || methodTransferFile.aspirateMixVolume == "")
|
// {
|
// methodPropertyInfo.property_name_info = TransferFileResourceCHS.aspirateMixVolume.ToString();
|
// }
|
//}
|
//if (methodTransferFile.dispenseMixCount != null || methodTransferFile.dispenseMixCount != "")
|
//{
|
// if (methodTransferFile.dispenseMixVolume == null || methodTransferFile.dispenseMixVolume == "")
|
// {
|
// methodPropertyInfo.property_name_info = TransferFileResourceCHS.dispenseMixVolume.ToString();
|
// }
|
//}
|
|
//if (methodTransferFile.ChannelText == null || methodTransferFile.ChannelText == "")
|
//{
|
// methodPropertyInfo.property_name_info = TransferFileResourceCHS.ChannelText.ToString();
|
//}
|
if (methodTransferFile.destinationLabware == null || methodTransferFile.destinationLabware == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.destinationLabware.ToString();
|
}
|
if (methodTransferFile.destinationWell == null || methodTransferFile.destinationWell == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.destinationWell.ToString();
|
}
|
if (methodTransferFile.destVolume == null || methodTransferFile.destVolume == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.destVolume.ToString();
|
}
|
if (methodTransferFile.filePath == null || methodTransferFile.filePath == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.filePath.ToString();
|
}
|
if (methodTransferFile.labwaretipText == null || methodTransferFile.labwaretipText == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.labwaretipText.ToString();
|
}
|
if (methodTransferFile.liquididText == null || methodTransferFile.liquididText == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.liquididText.ToString();
|
}
|
if (methodTransferFile.sourceLabware == null || methodTransferFile.sourceLabware == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.sourceLabware.ToString();
|
}
|
if (methodTransferFile.sourceWell == null || methodTransferFile.sourceWell == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.sourceWell.ToString();
|
}
|
if (methodTransferFile.transferDataTable == null || methodTransferFile.transferDataTable.Rows.Count == 0)
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceCHS.transferDataTable.ToString();
|
}
|
}
|
else if (strCurrentCulture == "en-US")
|
{
|
methodPropertyInfo.property_tips_info = TransferFileResourceENU.tipsInfo.ToString();
|
|
if (methodTransferFile.armText == null || methodTransferFile.armText == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.armText.ToString();
|
}
|
//if (methodTransferFile.aspirateMixCount != null || methodTransferFile.aspirateMixCount != "")
|
//{
|
// if (methodTransferFile.aspirateMixVolume == null || methodTransferFile.aspirateMixVolume == "")
|
// {
|
// methodPropertyInfo.property_name_info = TransferFileResourceENU.aspirateMixVolume.ToString();
|
// }
|
//}
|
//if (methodTransferFile.dispenseMixCount != null || methodTransferFile.dispenseMixCount != "")
|
//{
|
// if (methodTransferFile.dispenseMixVolume == null || methodTransferFile.dispenseMixVolume == "")
|
// {
|
// methodPropertyInfo.property_name_info = TransferFileResourceENU.dispenseMixVolume.ToString();
|
// }
|
//}
|
|
//if (methodTransferFile.ChannelText == null || methodTransferFile.ChannelText == "")
|
//{
|
// methodPropertyInfo.property_name_info = TransferFileResourceENU.ChannelText.ToString();
|
//}
|
if (methodTransferFile.destinationLabware == null || methodTransferFile.destinationLabware == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.destinationLabware.ToString();
|
}
|
if (methodTransferFile.destinationWell == null || methodTransferFile.destinationWell == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.destinationWell.ToString();
|
}
|
if (methodTransferFile.destVolume == null || methodTransferFile.destVolume == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.destVolume.ToString();
|
}
|
if (methodTransferFile.filePath == null || methodTransferFile.filePath == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.filePath.ToString();
|
}
|
if (methodTransferFile.labwaretipText == null || methodTransferFile.labwaretipText == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.labwaretipText.ToString();
|
}
|
if (methodTransferFile.liquididText == null || methodTransferFile.liquididText == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.liquididText.ToString();
|
}
|
if (methodTransferFile.sourceLabware == null || methodTransferFile.sourceLabware == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.sourceLabware.ToString();
|
}
|
if (methodTransferFile.sourceWell == null || methodTransferFile.sourceWell == "")
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.sourceWell.ToString();
|
}
|
if (methodTransferFile.transferDataTable == null || methodTransferFile.transferDataTable.Rows.Count == 0)
|
{
|
methodPropertyInfo.property_name_info = TransferFileResourceENU.transferDataTable.ToString();
|
}
|
}
|
return methodPropertyInfo;
|
}
|
#endregion
|
|
#region 检查数据中的板子名称是否在台面存在
|
/// <summary>
|
/// 检查数据中的板子名称是否在台面存在
|
/// </summary>
|
/// <param name="methodTransferFile">文件方法属性对象</param>
|
/// <param name="xmlEnv">台面板位xmlNode</param>
|
/// <param name="labwareName">耗材名称</param>
|
/// <returns>true:存在;false:不存在</returns>
|
public bool CheckDataExist(MethodTransferFile methodTransferFile, XmlNode xmlEnv, out string labwareName)
|
{
|
bool bResult = true;
|
labwareName = "";
|
try
|
{
|
if (methodTransferFile.transferDataTable != null)
|
{
|
DataTable dt = methodTransferFile.transferDataTable;
|
string colSrcName = methodTransferFile.sourceLabware;//来源板列名
|
string colDesName = methodTransferFile.destinationLabware;//目标板列名
|
foreach (DataRow dr in dt.Rows)
|
{
|
XmlNodeList platformNode = xmlEnv.SelectNodes("platform");
|
bool isExistSource = false;//存在来源板
|
bool isExistDestination = false;//存在目标板
|
|
for (int i = 0; i < platformNode.Count; i++)
|
{
|
XmlNodeList labwareNodeList = platformNode[i].SelectNodes("labware");
|
|
var labwareSrcNode = labwareNodeList[0].SelectSingleNode("labware_sname[text()='" + dr[colSrcName].ToString() + "']");//='" + dr[colSrcName].ToString() + "'");
|
if (labwareSrcNode != null)
|
{
|
isExistSource = true;
|
break;
|
}
|
}
|
for (int i = 0; i < platformNode.Count; i++)
|
{
|
XmlNodeList labwareNodeList = platformNode[i].SelectNodes("labware");
|
var labwareDesNode = labwareNodeList[0].SelectSingleNode("labware_sname[text()='" + dr[colDesName].ToString() + "']");
|
if (labwareDesNode != null)
|
{
|
isExistDestination = true;
|
break;
|
}
|
}
|
|
if(!isExistSource)
|
{
|
bResult = false;
|
labwareName = dr[colSrcName].ToString();
|
return bResult;
|
}
|
|
if(!isExistDestination)
|
{
|
bResult = false;
|
labwareName = dr[colDesName].ToString();
|
return bResult;
|
}
|
|
}
|
}
|
}
|
catch
|
{
|
}
|
return bResult;
|
}
|
#endregion
|
|
#region 检查数据中的板子孔位是否完整(同一列，孔位指定的体积是否相同等）
|
/// <summary>
|
/// 检查数据中的板子孔位是否完整
|
/// </summary>
|
/// <param name="methodTransferFile">文件方法属性对象</param>
|
/// <param name="plateNode">台面板位xmlNode</param>
|
/// <param name="methodNode">文件方法属性xmlNode</param>
|
/// <param name="dt">移液文件数据表</param>
|
/// <param name="excludeWell">输出参数，数据中不包含的孔位集合</param>
|
/// <param name="bSameVolume">同一列体积是否相同</param>
|
/// <param name="bfullDecWell">目标孔是否是完整的列</param>
|
/// <param name="bfullChangeTips">更换Tip列是否完整</param>
|
/// <returns>true:数据完整；false：数据不完整</returns>
|
public bool CheckDataIsIntegrity(MethodTransferFile methodTransferFile, XmlNode plateNode, XmlNode methodNode, out DataTable dt, out List<DropdownName> excludeWells, out bool bSameVolume, out bool bfullDecWell, out bool bfullChangeTips)
|
{
|
bool bResult = true;
|
dt = new DataTable();
|
excludeWells = new List<DropdownName>();
|
bSameVolume = true;
|
bfullDecWell = true;//目标孔是否是完整的列
|
bfullChangeTips = true;//更换Tip列是否完整
|
|
try
|
{
|
if (methodTransferFile.transferDataTable != null)
|
{
|
|
//调用排序方法排序
|
dt = wellFileCalc.SortFileData(methodTransferFile.transferDataTable, plateNode, methodNode, out excludeWells, out bSameVolume, out bfullDecWell, out bfullChangeTips);
|
|
if (excludeWells.Count > 0)
|
{
|
bResult = false;
|
}
|
}
|
}
|
catch
|
{
|
}
|
return bResult;
|
}
|
#endregion
|
|
#region 获取移液表中的来源板和目标板的耗材对象实体
|
public List<LabwareRSLattice> GetLabwareEntities(MethodTransferFile methodTransferFile, XmlNode plateNode)
|
{
|
List<LabwareRSLattice> labwares = new List<LabwareRSLattice>();
|
try
|
{
|
if (methodTransferFile.transferDataTable != null)
|
{
|
DataTable dt = methodTransferFile.transferDataTable;
|
string colSrcName = methodTransferFile.sourceLabware;//来源板列名
|
string colDesName = methodTransferFile.destinationLabware;//目标板列名
|
foreach (DataRow dr in dt.Rows)
|
{
|
XmlNode srcPlatformNode = GetXmlNodeByBoardName(plateNode.SelectNodes("platform"), dr[colSrcName].ToString());//plateNode.SelectSingleNode("platform/labware[@id=max(../labware/@id)]");///labware_sname[text()='" + dr[colSrcName].ToString() + "']").ParentNode;
|
int num = srcPlatformNode.SelectNodes("labware").Count;
|
XmlNode srcLabwareNode = srcPlatformNode.SelectSingleNode("labware[@id='" + num.ToString()+ "']");
|
|
//var a = plateNode.SelectSingleNode("platform[labware_sname='" + dr[colSrcName] + "']");
|
if (srcLabwareNode != null)
|
{
|
LabwareRSLattice labwareRSLattice = new LabwareRSLattice();
|
Labware labware = LabwareDB.GetLabware(srcLabwareNode.SelectSingleNode("labware_id").InnerText);
|
labware.labware_sname = dr[colSrcName].ToString();
|
|
Lattice lattice = null;// ControlCom.GetLatticeId(srcPlatformNode.SelectSingleNode("lattice_id").InnerText,true);
|
TabletopTemplate tabletopTemplate = TabletopTemplateDB.GetCurrentAppTabletopTemplateCollectionFromdb(); //增加台面模板判断
|
if (tabletopTemplate == null)
|
{
|
string latticeNumber = "P" + srcPlatformNode.SelectSingleNode("lattice_id").InnerText;
|
lattice = LatticeDB.GetLatticeDataByIdFromdb(latticeNumber, Convert.ToInt32(Shared.DeviceArmList.SingleOrDefault(x => x.arm_type.Equals(1)).device_arm_id), Shared.SoftwareInformation.software_device_number);//arm1
|
}
|
else
|
{
|
string latticeNumber = "P" + srcPlatformNode.SelectSingleNode("lattice_id").InnerText;
|
lattice = LatticeDB.GetLatticeDataByLatticeNumAndTempIdFromdb(latticeNumber, Convert.ToInt32(Shared.DeviceArmList.SingleOrDefault(x=>x.arm_type.Equals(1)).device_arm_id), Shared.SoftwareInformation.software_device_number, tabletopTemplate.tabletopid);
|
}
|
|
labwareRSLattice.lattice = lattice;
|
labwareRSLattice.labware = labware;
|
if (labwares.FirstOrDefault(x => x.lattice.lattice_id.Equals(lattice.lattice_id)) == null)
|
{
|
labwares.Add(labwareRSLattice);
|
}
|
}
|
|
XmlNode desPlatformNode = GetXmlNodeByBoardName(plateNode.SelectNodes("platform"), dr[colDesName].ToString());//plateNode.SelectSingleNode("platform/labware[@id=max(../labware/@id)]");///labware_sname[text()='" + dr[colSrcName].ToString() + "']").ParentNode;
|
XmlNode desLabwareNode = srcPlatformNode.SelectSingleNode("labware[@id='" + desPlatformNode.SelectNodes("labware").Count + "']");
|
//var b = plateNode.SelectSingleNode("platform[labware_sname='" + dr[colDesName] + "']");
|
if (desLabwareNode != null)
|
{
|
LabwareRSLattice labwareRSLattice = new LabwareRSLattice();
|
Labware labware = LabwareDB.GetLabware(desLabwareNode.SelectSingleNode("labware_id").InnerText);
|
labware.labware_sname = dr[colDesName].ToString();
|
//Lattice lattice = LatticeDB.GetLatticeDataByIdFromdb(desPlatformNode.SelectSingleNode("lattice_id").InnerText);
|
Lattice lattice = null;// ControlCom.GetLatticeId(srcPlatformNode.SelectSingleNode("lattice_id").InnerText,true);
|
TabletopTemplate tabletopTemplate = TabletopTemplateDB.GetCurrentAppTabletopTemplateCollectionFromdb(); //增加台面模板判断
|
if (tabletopTemplate == null)
|
{
|
string latticeNumber = "P" + desPlatformNode.SelectSingleNode("lattice_id").InnerText;
|
lattice = LatticeDB.GetLatticeDataByIdFromdb(latticeNumber, Convert.ToInt32(Shared.DeviceArmList.SingleOrDefault(x => x.arm_type.Equals(1)).device_arm_id), Shared.SoftwareInformation.software_device_number);//arm1
|
}
|
else
|
{
|
string latticeNumber = "P" + desPlatformNode.SelectSingleNode("lattice_id").InnerText;
|
lattice = LatticeDB.GetLatticeDataByLatticeNumAndTempIdFromdb(latticeNumber, Convert.ToInt32(Shared.DeviceArmList.SingleOrDefault(x => x.arm_type.Equals(1)).device_arm_id), Shared.SoftwareInformation.software_device_number, tabletopTemplate.tabletopid);
|
}
|
labwareRSLattice.lattice = lattice;
|
labwareRSLattice.labware = labware;
|
if (labwares.FirstOrDefault(x => x.lattice.lattice_id.Equals(lattice.lattice_id)) == null)
|
{
|
labwares.Add(labwareRSLattice);
|
}
|
}
|
}
|
}
|
}
|
catch
|
{
|
}
|
return labwares;
|
}
|
#endregion
|
|
#region 根据板位别名和台面信息xml查找到对应唯一板位节点
|
/// <summary>
|
/// 根据板位别名和台面信息xml查找到对应唯一板位
|
/// </summary>
|
/// <param name="platformList"></param>
|
/// <param name="boardName"></param>
|
/// <returns></returns>
|
public XmlNode GetXmlNodeByBoardName(XmlNodeList platformList,string boardName)
|
{
|
XmlNode result = null;
|
|
for (int i = 0; i < platformList.Count; i++)
|
{
|
XmlNodeList labwareNodeList = platformList[i].SelectNodes("labware");
|
|
var labwareSrcNode = labwareNodeList[0].SelectSingleNode("labware_sname[text()='" + boardName + "']");
|
if (labwareSrcNode != null)
|
{
|
result = platformList[i];
|
break;
|
}
|
}
|
return result;
|
}
|
#endregion
|
|
#region 8个固定通道特有的方法
|
#region 检查固定8通道在某个板位耗材上，是否存在孔位数据不全的问题
|
/// <summary>
|
/// 检查固定8通道在某个板位耗材上，是否村存在孔位数据不全的问题
|
/// </summary>
|
/// <param name="methodTransferFile">移液表对象</param>
|
/// <param name="labwareRSLattice">板位与耗材实体对象</param>
|
/// <returns>true:存在孔位不全情况；false:不存在孔位不全情况</returns>
|
public bool IsEntire8ChannelsSolidWells(MethodTransferFile methodTransferFile, LabwareRSLattice labwareRSLattice)
|
{
|
bool bResult = false;
|
List<string> sortWellName = new List<string>();
|
Labware labware = labwareRSLattice.labware;
|
|
|
for (int j = 1; j <= labware.number_column; j++)
|
{
|
for (int i = 0; i < labware.number_row; i++)
|
{
|
string rowName = ComUtility.GetRowChar(i);
|
|
string rowWellName = rowName + j;
|
sortWellName.Add(rowWellName);
|
}
|
}
|
|
DataTable dt = methodTransferFile.transferDataTable;
|
string colSrcName = methodTransferFile.sourceLabware;//来源板列名
|
string colSrcWellName = methodTransferFile.sourceWell;//来源板孔位列名
|
string colDesName = methodTransferFile.destinationLabware;//目标板列名
|
string colDesWellName = methodTransferFile.destinationWell;//目标板孔位列名
|
if (dt != null)
|
{
|
//查询出所有该类板子的孔位数据
|
#region 来源板
|
DataRow[] dataRowSrc = dt.Select(colSrcName + @"='" + labware.labware_sname + @"'");
|
List<DataRow> dataRows1 = dataRowSrc.ToList();
|
for (int i = 0; i < sortWellName.Count; i++)
|
{
|
var d = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]));
|
if (d != null)
|
{
|
bool b = DeleteColWellByAWellName(dataRows1, colSrcWellName, sortWellName[i]);
|
if (b)
|
{
|
bResult = true;
|
return bResult;
|
}
|
}
|
else
|
{
|
i = i + 6;
|
}
|
}
|
#endregion
|
|
#region 目标板
|
DataRow[] dataRowDes = dt.Select(colDesName + @"='" + labware.labware_sname + @"'");
|
List<DataRow> dataRows2 = dataRowDes.ToList();
|
for (int i = 0; i < sortWellName.Count; i++)
|
{
|
var d = dataRows2.FirstOrDefault(x => x[colDesWellName].Equals(sortWellName[i]));
|
if (d != null)
|
{
|
bool b = DeleteColWellByAWellName(dataRows2, colDesWellName, sortWellName[i]);
|
if (b)
|
{
|
bResult = true;
|
return bResult;
|
}
|
}
|
else
|
{
|
i = i + 6;
|
}
|
}
|
#endregion
|
}
|
|
return bResult;
|
}
|
#endregion
|
|
#region 删除存在的同一列的孔位,如果该列孔位不全，则报告返回
|
/// <summary>
|
/// 删除存在的同一列的孔位（全部）,如果该列孔位列不全，则报告返回
|
/// </summary>
|
/// <param name="dataRows"></param>
|
/// <param name="colName"></param>
|
/// <param name="wellName"></param>
|
/// <returns>true:孔位不全；false:孔位全</returns>
|
public bool DeleteColWellByAWellName(List<DataRow> dataRows, string colName, string wellName)
|
{
|
bool bResult = false;
|
//string[] strWells = new string[Shared.ChannelCount];
|
string[] strWells = new string[8];
|
int suffix = Convert.ToInt32(wellName.Substring(1, wellName.Length - 1));
|
|
//for (int i = 0; i < strWells.Length; i++)
|
//{
|
// strWells[i] = ComUtility.GetRowChar(i) + suffix.ToString();
|
//}
|
strWells[0] = "A" + suffix.ToString();
|
strWells[1] = "B" + suffix.ToString();
|
strWells[2] = "C" + suffix.ToString();
|
strWells[3] = "D" + suffix.ToString();
|
strWells[4] = "E" + suffix.ToString();
|
strWells[5] = "F" + suffix.ToString();
|
strWells[6] = "G" + suffix.ToString();
|
strWells[7] = "H" + suffix.ToString();
|
|
var d = dataRows.FirstOrDefault(x => x[colName].Equals(wellName));
|
do
|
{
|
for (int i = 0; i < strWells.Length; i++)
|
{
|
d = dataRows.FirstOrDefault(x => x[colName].Equals(strWells[i]));
|
if (d != null)
|
{
|
dataRows.Remove(d);
|
}
|
}
|
|
d = dataRows.FirstOrDefault(x => x[colName].Equals(wellName));
|
}
|
while (d != null);
|
|
//再次检查看看有没有其他的孔位
|
for (int i = 0; i < strWells.Length; i++)
|
{
|
d = dataRows.FirstOrDefault(x => x[colName].Equals(strWells[i]));
|
if (d != null)
|
{
|
bResult = true;
|
}
|
}
|
|
return bResult;
|
}
|
#endregion
|
|
#region 给来源板孔位数据排序,找出来源板到目标板孔位不对应的数据，返回
|
/// <summary>
|
/// 给来源板孔位数据排序,找出来源板到目标板孔位不对应的数据，返回
|
/// </summary>
|
/// <param name="methodTransferFile"></param>
|
/// <param name="labwareRSLattice"></param>
|
/// <returns>null：移液数据错误；</returns>
|
public DataTable SortALabwareData(MethodTransferFile methodTransferFile, LabwareRSLattice labwareRSLattice)
|
{
|
DataTable bResult = null;
|
List<string> sortWellName = new List<string>();
|
Labware labware = labwareRSLattice.labware;
|
|
|
for (int j = 1; j <= labware.number_column; j++)
|
{
|
for (int i = 0; i < labware.number_row; i++)
|
{
|
string rowName = ComUtility.GetRowChar(i);
|
|
string rowWellName = rowName + j;
|
sortWellName.Add(rowWellName);
|
}
|
}
|
|
DataTable dt = methodTransferFile.transferDataTable;
|
string colSrcName = methodTransferFile.sourceLabware;//来源板列名
|
string colSrcWellName = methodTransferFile.sourceWell;//来源板孔位列名
|
string colDesName = methodTransferFile.destinationLabware;//目标板列名
|
string colDesWellName = methodTransferFile.destinationWell;//目标板孔位列名
|
if (dt != null)
|
{
|
bResult = dt.Clone();
|
DataRow[] dataRowSrc = dt.Select(colSrcName + @"='" + labware.labware_sname + @"'");
|
List<DataRow> dataRows1 = dataRowSrc.ToList();
|
|
while (dataRows1.Count > 0)
|
{
|
int firstIndex = 0;//保存为某一列的第一个通道
|
for (int i = 0; i < sortWellName.Count; i++)
|
{
|
var d1 = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]));
|
if (d1 != null)
|
{
|
//再加上目标板孔查询
|
var d2 = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]) && x[colDesName].Equals(d1[colDesName]) && x[colDesWellName].Equals(d1[colDesWellName]));
|
if (d2 != null)
|
{
|
int suffix = Convert.ToInt32(d2[colDesWellName].ToString().Substring(1, d2[colDesWellName].ToString().Length - 1));
|
//int sortSuffix= Convert.ToInt32(sortWellName[i].ToString().Substring(1, sortWellName[i].ToString().Length - 1));
|
//if (suffix == 1)//&& firstIndex)//&& suffix== sortSuffix)
|
//{
|
bResult.ImportRow(d2);
|
dataRows1.Remove(d2);
|
//}
|
//else
|
//{
|
// bResult = null;
|
// return bResult;
|
//}
|
}
|
else
|
{
|
bResult = null;
|
return bResult;
|
}
|
}
|
else
|
{
|
i = i + 7;
|
}
|
}
|
}
|
}
|
return bResult;
|
}
|
#endregion
|
#endregion
|
|
#region 6个固定通道特有的方法——武汉设备专用
|
#region 检查固定6通道在某个板位耗材上，是否存在孔位数据不全的问题
|
/// <summary>
|
/// 检查固定6通道在某个板位耗材上，是否存在孔位数据不全的问题
|
/// </summary>
|
/// <param name="methodTransferFile">移液表对象</param>
|
/// <param name="labwareRSLattice">板位与耗材实体对象</param>
|
/// <returns>true:存在孔位不全情况；false:不存在孔位不全情况</returns>
|
public bool IsEntire6ChannelsSolidWells(MethodTransferFile methodTransferFile, LabwareRSLattice labwareRSLattice)
|
{
|
bool bResult = false;
|
List<string> sortWellName = new List<string>();
|
Labware labware = labwareRSLattice.labware;
|
|
for (int j = 1; j <= labware.number_column; j++)
|
{
|
for (int i = 0; i < labware.number_row; i++)
|
{
|
string rowName = ComUtility.GetRowChar(i);
|
|
string rowWellName = rowName + j;
|
sortWellName.Add(rowWellName);
|
}
|
}
|
|
DataTable dt = methodTransferFile.transferDataTable;
|
string colSrcName = methodTransferFile.sourceLabware;//来源板列名
|
string colSrcWellName = methodTransferFile.sourceWell;//来源板孔位列名
|
string colDesName = methodTransferFile.destinationLabware;//目标板列名
|
string colDesWellName = methodTransferFile.destinationWell;//目标板孔位列名
|
|
if (dt != null)
|
{
|
//查询出所有该类板子的孔位数据
|
#region 来源板
|
DataRow[] dataRowSrc = dt.Select(colSrcName + @"='" + labware.labware_sname + @"'");
|
List<DataRow> dataRows1 = dataRowSrc.ToList();
|
for (int i = 0; i < sortWellName.Count; i++)
|
{
|
var d = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]));
|
if (d != null)
|
{
|
bool b = DeleteColWellByAWellName(dataRows1, colSrcWellName, sortWellName[i]);
|
if (b)
|
{
|
bResult = true;
|
return bResult;
|
}
|
}
|
else
|
{
|
i = i + 6;
|
}
|
}
|
#endregion
|
|
#region 目标板
|
DataRow[] dataRowDes = dt.Select(colDesName + @"='" + labware.labware_sname + @"'");
|
List<DataRow> dataRows2 = dataRowDes.ToList();
|
for (int i = 0; i < sortWellName.Count; i++)
|
{
|
var d = dataRows2.FirstOrDefault(x => x[colDesWellName].Equals(sortWellName[i]));
|
if (d != null)
|
{
|
bool b = DeleteColWellByAWellName(dataRows2, colDesWellName, sortWellName[i]);
|
if (b)
|
{
|
bResult = true;
|
return bResult;
|
}
|
}
|
else
|
{
|
i = i + 6;
|
}
|
}
|
#endregion
|
}
|
|
return bResult;
|
}
|
#endregion
|
|
#region 给来源板孔位数据排序,找出来源板到目标板孔位不对应的数据，返回---武汉专用
|
/// <summary>
|
/// 给来源板孔位数据排序,找出来源板到目标板孔位不对应的数据，返回--武汉专用
|
/// </summary>
|
/// <param name="methodTransferFile"></param>
|
/// <param name="labwareRSLattice"></param>
|
/// <returns>null：移液数据错误；</returns>
|
public DataTable SortALabwareDataForChoice(MethodTransferFile methodTransferFile, LabwareRSLattice labwareRSLattice)
|
{
|
DataTable bResult = null;
|
List<string> sortWellName = new List<string>();
|
Labware labware = labwareRSLattice.labware;
|
|
for (int i = 0; i < labware.number_row; i++)
|
{
|
string rowName = ComUtility.GetRowChar(i);
|
for (int j = 1; j <= labware.number_column; j++)
|
{
|
string rowWellName = rowName + j;
|
sortWellName.Add(rowWellName);
|
}
|
|
if (labware.number_column == 12)//重新排孔位为 A1,A3,A5,A7,A9,A11,A2,A4,A6,A8,A10,A12
|
{
|
List<string> oddSortWellNames = new List<string>();
|
List<string> evenSortWellNames = new List<string>();
|
bool isOdd = false;
|
int countOfsortWellName = sortWellName.Count;
|
for (int j = countOfsortWellName - 1; j >= countOfsortWellName - labware.number_column; j--)
|
{
|
if (isOdd)
|
{
|
oddSortWellNames.Add(sortWellName[j]);
|
isOdd = false;
|
}
|
else
|
{
|
evenSortWellNames.Add(sortWellName[j]);
|
isOdd = true;
|
|
}
|
|
sortWellName.RemoveAt(j);
|
}
|
|
for (int j = oddSortWellNames.Count - 1; j >= 0; j--)
|
{
|
sortWellName.Add(oddSortWellNames[j]);
|
}
|
|
for (int j = evenSortWellNames.Count - 1; j >= 0; j--)
|
{
|
sortWellName.Add(evenSortWellNames[j]);
|
}
|
|
}
|
}
|
|
DataTable dt = methodTransferFile.transferDataTable;
|
string colSrcName = methodTransferFile.sourceLabware;//来源板列名
|
string colSrcWellName = methodTransferFile.sourceWell;//来源板孔位列名
|
string colDesName = methodTransferFile.destinationLabware;//目标板列名
|
string colDesWellName = methodTransferFile.destinationWell;//目标板孔位列名
|
if (dt != null)
|
{
|
bResult = dt.Clone();
|
DataRow[] dataRowSrc = dt.Select(colSrcName + @"='" + labware.labware_sname + @"'");
|
List<DataRow> dataRows1 = dataRowSrc.ToList();
|
|
while (dataRows1.Count > 0)
|
{
|
int firstIndex = 0;//保存为某一列的第一个通道
|
for (int i = 0; i < sortWellName.Count; i++)
|
{
|
var d1 = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]));
|
if (d1 != null)
|
{
|
//再加上目标板孔查询
|
var d2 = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]) && x[colDesName].Equals(d1[colDesName]) && x[colDesWellName].Equals(d1[colDesWellName]));
|
if (d2 != null)
|
{
|
int suffix = Convert.ToInt32(d2[colDesWellName].ToString().Substring(1, d2[colDesWellName].ToString().Length - 1));
|
//int sortSuffix= Convert.ToInt32(sortWellName[i].ToString().Substring(1, sortWellName[i].ToString().Length - 1));
|
//if (suffix == 1)//&& firstIndex)//&& suffix== sortSuffix)
|
//{
|
bResult.ImportRow(d2);
|
dataRows1.Remove(d2);
|
//}
|
//else
|
//{
|
// bResult = null;
|
// return bResult;
|
//}
|
}
|
else
|
{
|
bResult = null;
|
return bResult;
|
}
|
}
|
else
|
{
|
//if (labware.number_column == 12)//重新排孔位为 A1,A3,A5,A7,A9,A11,A2,A4,A6,A8,A10,A12
|
//{
|
// i = i + 5;
|
//}
|
//else
|
//{
|
//i = i + 5;
|
//}
|
}
|
}
|
}
|
}
|
return bResult;
|
}
|
#endregion
|
#endregion
|
|
#region 给来源板孔位数据排序,找出来源板到目标板孔位不对应的数据，返回---多通道专用
|
/// <summary>
|
/// 给来源板孔位数据排序,找出来源板到目标板孔位不对应的数据，返回--多通道专用
|
/// </summary>
|
/// <param name="methodTransferFile"></param>
|
/// <param name="labwareRSLattice"></param>
|
/// <returns>null：移液数据错误；</returns>
|
public DataTable SortALabwareDataForChoiceSH(MethodTransferFile methodTransferFile, LabwareRSLattice labwareRSLattice)
|
{
|
DataTable bResult = null;
|
List<string> sortWellName = new List<string>();
|
Labware labware = labwareRSLattice.labware;
|
|
for (int j = 1; j <= labware.number_column; j++)
|
{
|
for (int i = 0; i < labware.number_row; i++)
|
{
|
string rowName = ComUtility.GetRowChar(i);
|
|
string rowWellName = rowName + j;
|
sortWellName.Add(rowWellName);
|
}
|
|
if (labware.number_row == 8)//重新排孔位为 A1,B1,C1,D1,E1,F1,G1,H1
|
{
|
}
|
}
|
|
DataTable dt = methodTransferFile.transferDataTable;
|
string colSrcName = methodTransferFile.sourceLabware;//来源板列名
|
string colSrcWellName = methodTransferFile.sourceWell;//来源板孔位列名
|
string colDesName = methodTransferFile.destinationLabware;//目标板列名
|
string colDesWellName = methodTransferFile.destinationWell;//目标板孔位列名
|
if (dt != null)
|
{
|
bResult = dt.Clone();
|
DataRow[] dataRowSrc = dt.Select(colSrcName + @"='" + labware.labware_sname + @"'");
|
List<DataRow> dataRows1 = dataRowSrc.ToList();
|
|
while (dataRows1.Count > 0)
|
{
|
for (int i = 0; i < sortWellName.Count; i++)
|
{
|
var d1 = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]));
|
if (d1 != null)
|
{
|
//再加上目标板孔查询
|
var d2 = dataRows1.FirstOrDefault(x => x[colSrcWellName].Equals(sortWellName[i]) && x[colDesName].Equals(d1[colDesName]) && x[colDesWellName].Equals(d1[colDesWellName]));
|
if (d2 != null)
|
{
|
int suffix = Convert.ToInt32(d2[colDesWellName].ToString().Substring(1, d2[colDesWellName].ToString().Length - 1));
|
bResult.ImportRow(d2);
|
dataRows1.Remove(d2);
|
}
|
else
|
{
|
bResult = null;
|
return bResult;
|
}
|
}
|
else
|
{
|
}
|
}
|
}
|
}
|
return bResult;
|
}
|
#endregion
|
}
|
}
|
