public static string SampleNoToSampleBar(string sampleNo)
{
string times = "";
string strSampleNo = "";
string strTestTime = "";
if (sampleNo.Length >= 8)
{
DataSetHandle dsHandle = new DataSetHandle();
IniFile ConfigIni = new IniFile("SOLVESET.INI");
string orgId = ConfigIni.IniReadValue("EQUIPMENT", "Agencies");
string sql = @"to_char(申请时间,'yyyymmdd') as 核收时间,样本序号";
string where = @" 机构id='" + orgId + "' and 样本条码='" + sampleNo + "'";
DataSet ds = dsHandle.GetDataSet(sql, "检验记录", where);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
times = ds.Tables[0].Rows[0]["核收时间"].ToString();//20160202145321
strSampleNo = ds.Tables[0].Rows[0]["样本序号"].ToString();
try
{
strTestTime = times.Substring(0, 4) + "-" + times.Substring(4, 2) + "-" + times.Substring(6, 2);
}
catch (Exception e)
{
MessageBox.Show("Helper error strTestTime :+\r\n" + e.ToString());
}
return(strTestTime + "|" + strSampleNo);
}
}
return("");
}
public void Start()
{
strFolder.Add("HBcAb");
strFolder.Add("HBeAb");
strFolder.Add("HBeAg");
strFolder.Add("HBsAb");
strFolder.Add("HBsAg");
dsHandle = new DataSetHandle();
dsProject = dsHandle.GetDataSet("TEST_ITEM_ID,CHANNEL_NO", "TEST_INSTRUMENT_ITEM_CHANNEL", "INSTRUMENT_ID='" + strInstrumentID + "'");
foreach (System.Data.DataRow dr in dsProject.Tables[0].Rows)
{
if (dr["CHANNEL_NO"].ToString().ToUpper() == "HBCAB")
{
strHBcAbID = dr["TEST_ITEM_ID"].ToString();
}
else if (dr["CHANNEL_NO"].ToString().ToUpper() == "HBEAB")
{
strHBeAbID = dr["TEST_ITEM_ID"].ToString();
}
else if (dr["CHANNEL_NO"].ToString().ToUpper() == "HBEAG")
{
strHBeAgID = dr["TEST_ITEM_ID"].ToString();
}
else if (dr["CHANNEL_NO"].ToString().ToUpper() == "HBSAB")
{
strHBsAbID = dr["TEST_ITEM_ID"].ToString();
}
else if (dr["CHANNEL_NO"].ToString().ToUpper() == "HBSAG")
{
strHBsAgID = dr["TEST_ITEM_ID"].ToString();
}
}
;
//通过线程去提取数据
System.Threading.ParameterizedThreadStart ParStart = new System.Threading.ParameterizedThreadStart(GetResult);
System.Threading.Thread threadSocket = new System.Threading.Thread(ParStart);
object socketListen = "";
threadSocket.Start(socketListen);
//2010-05-11 22:16:49|22^^0||标本||aa31c32d-b539-4cfc-8dea-a0e6f85f33d7^3.9|
//SaveResult saveResult = new SaveResult();
//filePath = @"D:\新建文件夹\二院仪器数据\AnyTest\0Aux";
fileName = "*.*";
//fileName = "*.out";
//writelog.Write(filePath,"log");
}
/// <summary>
/// type 调用类型
/// 0 - 初始化
/// 1 - 连接
/// 9 - 断开
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public string CallDll(string para)
{
writeLog = new Write_Log();
dsHandle = new DataSetHandle();
ds = new DataSet();
string strInstrumentID = "";
string strMicroPlateID = "";
string strSampleNO = "";
string strSampleID = "";
string strCallSource = "";
string strInstrumentKind = "";
string strPara = "";
string strType = "";
string strReadBatch = "";
string strDeviceId = "";
strInstrumentID = "";
strType = "";
strMicroPlateID = "";
strSampleID = "";
strSampleNO = "";
strCallSource = "";
if (boolRun)
{
return(strError);
}
Dictionary <string, string> para_dic = new Dictionary <string, string>();
string[] para_value = para.Split(';');
foreach (string para_col in para_value)
{
if (string.IsNullOrEmpty(para_col))
{
break;
}
string[] tmp = para_col.Split('=');
para_dic.Add(tmp[0].ToUpper(), tmp[1]);
}
strPara = "";
//仪器ID
if (para.ToUpper().IndexOf("TEST_INSTRUMENT_ID=") >= 0)
{
strInstrumentID = para_dic["TEST_INSTRUMENT_ID"];
strPara = strPara + "TEST_INSTRUMENT_ID=" + strInstrumentID + ";";
}
//类型
if (para.ToUpper().IndexOf("TYPE=") >= 0)
{
strType = para_dic["TYPE"];
strPara = strPara + "TYPE=" + strType + ";";
}
//检验标本ID
if (para.ToUpper().IndexOf("TEST_SAMPLE_ID=") >= 0)
{
strSampleID = para_dic["TEST_SAMPLE_ID"];
strPara = strPara + "TEST_SAMPLE_ID=" + strSampleID + ";";
}
//标本ID
if (para.ToUpper().IndexOf("SAMPLE_NO=") >= 0)
{
strSampleNO = para_dic["SAMPLE_NO"];
if (!string.IsNullOrEmpty(strSampleNO))
{
strPara = strPara + "SAMPLE_NO=" + strSampleNO + ";";
}
}
//调用来源
if (para.ToUpper().IndexOf("CALL_SOURCE=") >= 0)
{
strCallSource = para_dic["CALL_SOURCE"];
strPara = strPara + "CALL_SOURCE=" + strCallSource + ";";
}
//单个读取
if (para.ToUpper().IndexOf("READ_BATCH=") >= 0)
{
strReadBatch = para_dic["READ_BATCH"];
strPara = strPara + "READ_BATCH=" + strReadBatch + ";";
}
if (ConnectDB.con.State != ConnectionState.Open)
{
ConnectDB init = new ConnectDB();
init.DBConnect();
}
//处理一台电脑解析多个数据
for (int j = 0; j < strInstrumentID.Split(',').Length; j++)
{
strDeviceId = strInstrumentID.Split(',')[j];
ds = dsHandle.GetDataSet("通讯类型,名称", "检验仪器", "ID = '" + strDeviceId + "'");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
strError = "未找到Id[" + strDeviceId + "]的仪器";
writeLog.Write(strError, "log");
break;
}
strCommType = ds.Tables[0].Rows[0]["通讯类型"].ToString();
strDeviceName = ds.Tables[0].Rows[0]["名称"].ToString();
//strCallSource = "1";
//BH调用exe
if (strCallSource == "1")
{
int WINDOW_HANDLER = FindWindow(null, @"解析程序");
if (WINDOW_HANDLER == 0)
//if (WINDOW_HANDLER.Equals(IntPtr.Zero))
{
strError = "解析程序未运行!";
MessageBox.Show(strError, "导入数据", MessageBoxButtons.OK, MessageBoxIcon.Information);
writeLog.Write(strDeviceName, strError, "log");
break;
}
else
{
byte[] sarr = System.Text.Encoding.Default.GetBytes(strPara);
int len = sarr.Length;
COPYDATASTRUCT cds;
cds.dwData = (IntPtr)1000;
cds.lpData = strPara;
cds.cbData = len + 1;
SendMessage(WINDOW_HANDLER, WM_COPYDATA, 0, ref cds);
}
}
else
{
if (strCommType == "1")
{
#region 时运行
if (strType != "9")
{
if (!dictionary_initDll_COM.ContainsKey(strDeviceName))
{
Init_COM initDll_COM = new Init_COM();
if (string.IsNullOrEmpty(initDll_COM.strSampleID) && !string.IsNullOrEmpty(strSampleID))
{
initDll_COM.strSampleID = strSampleID;
}
if (string.IsNullOrEmpty(initDll_COM.strInstrumentID) && !string.IsNullOrEmpty(strInstrumentID))
{
initDll_COM.strInstrumentID = strInstrumentID.Split(',')[j];
}
dictionary_initDll_COM.Add(strDeviceName, initDll_COM);
}
}
if (strType == "0")
{
//initDll_COM.Start(strDeviceId);
foreach (Init_COM item in dictionary_initDll_COM.Values)
{
if (string.IsNullOrEmpty(item.status))
{
item.Start(strDeviceId);
}
}
}
else if (strType == "9")
{
//initDll_COM.Stop();
foreach (Init_COM item in dictionary_initDll_COM.Values)
{
item.Stop();
strError = item.strError;
}
dictionary_initDll_COM.Clear();
}
#endregion
}
else if (strCommType == "2")
{
if (initDll_TCP == null)
{
initDll_TCP = new Init_TCP();
initDll_TCP.strInstrumentID = strInstrumentID.Split(',')[j];
}
if (strType == "0")
{
initDll_TCP.Init();
}
else if (strType == "9")
{
initDll_TCP.Stop();
}
strError = initDll_TCP.strError;
}
//xt 数据库类型支持多个同时应用
else if (strCommType == "3")
{
if (initDll_DB == null)
{
initDll_DB = new Init_DB();
initDll_DB.strInstrumentID = strInstrumentID.Split(',')[j];
initDll_DB.strTestNO = strSampleNO;
initDll_DB.Init();
#region 时运行
//if (strType != "9")
//{
// if (!dictionary_initDll_DB.ContainsKey(strDeviceName))
// {
// initDll_DB = new Init_DB();
// if (string.IsNullOrEmpty(initDll_DB.strTestNO) && !string.IsNullOrEmpty(strSampleID))
// {
// initDll_DB.strTestNO = strSampleID;
// }
// if (string.IsNullOrEmpty(initDll_DB.strInstrumentID) && !string.IsNullOrEmpty(strInstrumentID))
// {
// initDll_DB.strInstrumentID = strInstrumentID.Split(',')[j];
// }
// dictionary_initDll_DB.Add(strDeviceName, initDll_DB);
// }
//}
//if (strType == "0")
//{
// //initDll_COM.Start(strDeviceId);
// foreach (Init_DB item in dictionary_initDll_DB.Values)
// {
// if (string.IsNullOrEmpty(item.status))
// item.Init(strDeviceId);
// }
//}
//else if (strType == "9")
//{
// //initDll_COM.Stop();
// foreach (Init_DB item in dictionary_initDll_DB.Values)
// {
// item.Stop();
// strError = item.strError;
// }
// dictionary_initDll_DB.Clear();
//}
#endregion
}
strError = initDll_DB.strError;
}
else if (strCommType == "4")
{
if (initDll_TXT == null)
{
initDll_TXT = new Init_TXT();
}
initDll_TXT.strInstrumentID = strInstrumentID.Split(',')[j];
initDll_TXT.bnReadBatch = (strReadBatch == "1" ? true : false);
initDll_TXT.Start();
strError = initDll_TXT.strError;
}
else
{
strError = "未设置仪器的通讯类型!";
}
if (strType == "9")
{
if (ConnectDB.con.State == ConnectionState.Open)
{
ConnectDB init = new ConnectDB();
init.DisConnectDB(ConnectDB.con);
}
}
}
if (!String.IsNullOrEmpty(strError))
{
writeLog.Write(strDeviceName, strError, "log");
}
}
return(strError);
}
