/// <summary>
/// 图片服务器表
/// </summary>
/// <returns></returns>
public static IDictionary <int, OcrDBPmsServer> GetOcrDBPmsServer()
{
using (DataSet ds = NpgSqlHelper.ExecuteDataSet2(SQL_OcrDBPmsServer))
{
if (ds.Tables[0].Rows.Count > 0)
{
IDictionary <int, OcrDBPmsServer> dic = new Dictionary <int, OcrDBPmsServer>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
OcrDBPmsServer data = new OcrDBPmsServer();
data.Id = Convert.ToInt32(ds.Tables[0].Rows[0]["i_id"]);
data.Name = ds.Tables[0].Rows[0]["c_name"].ToString();
data.IndexCode = ds.Tables[0].Rows[0]["c_index_code"].ToString();
data.Ip = ds.Tables[0].Rows[0]["i_ip"].ToString();
data.Port = ds.Tables[0].Rows[0]["i_port"].ToString();
dic.Add(data.Id, data);
}
return(dic);
}
}
return(null);
}
/// <summary>
/// 图片服务器表
/// </summary>
/// <returns></returns>
public static IDictionary <int, OcrDBPmsServer> GetOcrDBPmsServer()
{
//using (DataSet ds = NpgSqlHelper.ExecuteDataSet2(SQL_OcrDBPmsServer))
HttpHelper httpHelper = new HttpHelper();
string host = ConnectionHelper.GetOracleConnectionString("SCT_API_HOST");
string url = string.Format("{0}/api/OCRPmsServer/GetPMSServer", host);
using (DataTable dt = JsonConvert.DeserializeObject <DataTable>(httpHelper.HttpGet(url)))
{
if (dt.Rows.Count > 0)
{
IDictionary <int, OcrDBPmsServer> dic = new Dictionary <int, OcrDBPmsServer>();
foreach (DataRow dr in dt.Rows)
{
OcrDBPmsServer data = new OcrDBPmsServer();
data.Id = Convert.ToInt32(dr["i_id"]);
data.Name = dr["c_name"].ToString();
data.IndexCode = dr["c_index_code"].ToString();
data.Ip = dr["i_ip"].ToString();
data.Port = dr["i_port"].ToString();
dic.Add(data.Id, data);
}
return(dic);
}
}
return(null);
}
//加载图片
private void LoadPhotos()
{
using (OcrPhoto.T_OCR_PHOTODataTable ds = bll.GetPhoto(row.DOCK_ID))
{
string url1 = string.Empty;
string url2 = string.Empty;
string url3 = string.Empty;
string url4 = string.Empty;
string url5 = string.Empty;
string url6 = string.Empty;
string url7 = string.Empty;
string url8 = string.Empty;
OcrDBPmsServer pms = OcrDBPmsServerList[Convert.ToInt32(row.PMS_ID)];
if (pms == null)
{
throw new Exception("图片服务器设置异常");
}
string path = string.Format(@"http://{0}:{1}", pms.Ip, pms.Port);
foreach (OcrPhoto.T_OCR_PHOTORow dr in ds)
{
//int photo_pos = Convert.ToInt32(dr["PHOTO_POS"]);
string url = string.Format(@"{0}{1}", path, dr.PHOTO_URL);
switch (Convert.ToInt32(dr.PHOTO_POS))
{
case 1:
url1 = url;
break;
case 2:
url2 = url;
break;
case 3:
url3 = url;
break;
case 4:
url4 = url;
break;
case 5:
url5 = url;
break;
case 6:
url6 = url;
break;
case 7:
url7 = url;
break;
case 8:
url8 = url;
break;
}
}
tableLayoutPanel1.RowStyles[2] = new RowStyle(SizeType.Absolute, 1F);
tableLayoutPanel1.RowStyles[3] = new RowStyle(SizeType.Absolute, 1F);
tableLayoutPanel1.RowStyles[0] = new RowStyle(SizeType.Percent, 50F);
tableLayoutPanel1.RowStyles[1] = new RowStyle(SizeType.Percent, 50F);
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb1, url1));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb2, url2));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb3, url3));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb4, url4));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb5, url5));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb6, url6));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb7, url7));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb8, url8));
}
}
//¼ÓÔØͼƬ
private void LoadPhotos()
{
using (OcrPhoto.T_OCR_PHOTODataTable ds = SearchBLL.GetPhoto(dock_id))
{
string url1 = string.Empty;
string url2 = string.Empty;
string url3 = string.Empty;
string url4 = string.Empty;
string url5 = string.Empty;
string url6 = string.Empty;
string url7 = string.Empty;
string url8 = string.Empty;
OcrDBPmsServer pms = OcrDBPmsServerList[Convert.ToInt32(pms_id)];
if (pms == null)
{
throw new Exception("ͼƬ·þÎñÆ÷ÉèÖÃÒì³£");
}
string path = string.Format(@"http://{0}:{1}", pms.Ip, pms.Port);
foreach (OcrPhoto.T_OCR_PHOTORow dr in ds)
{
//int photo_pos = Convert.ToInt32(dr["PHOTO_POS"]);
string url = string.Format(@"{0}{1}", path, dr.PHOTO_URL);
switch (Convert.ToInt32(dr.PHOTO_POS))
{
case 1:
url1 = url;
break;
case 2:
url2 = url;
break;
case 3:
url3 = url;
break;
case 4:
url4 = url;
break;
case 5:
url5 = url;
break;
case 6:
url6 = url;
break;
case 7:
url7 = url;
break;
case 8:
url8 = url;
break;
}
}
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb1, url1));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb2, url2));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb3, url4));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb4, url3));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb5, url5));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb6, url6));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb7, url7));
ThreadPool.QueueUserWorkItem(new WaitCallback(LoadPhotoAsy), new LoadPhotoState(pb8, url8));
}
}
