/// <summary>
/// 加载图片
/// </summary>
void LoadImage()
{
if (UCInputMainType == 1)//数据库交互模式
{
m_UCDataLstImage.Clear();
if (UCDBSmallPicFieldName != string.Empty)
{
m_UCDataLstSmallImage.Clear();
}
saveIDs.Clear();
saveImageIndex = -1;
picShow.Image = null;
string sql = string.Empty;
switch (UCInputDBSaveType)
{
case 1: //存储在同一张表内
sql = "SELECT ID," + UCDBPicFieldName;
if (UCDBSmallPicFieldName != string.Empty)
{
sql += "," + UCDBSmallPicFieldName;
}
if (UCDBRemarkFieldName != string.Empty)
{
sql += "," + UCDBRemarkFieldName;
}
sql += " FROM " + UCDBTableName + " WHERE ID=" + UCDataID;
break;
case 2: //存储在独立的数据表内
sql = "SELECT ID," + UCDBPicFieldName;
if (UCDBSmallPicFieldName != string.Empty)
{
sql += "," + UCDBSmallPicFieldName;
}
if (UCDBRemarkFieldName != string.Empty)
{
sql += "," + UCDBRemarkFieldName;
}
sql += " FROM " + UCDBTableName + " WHERE " + UCDBMainIDFieldName + "=" + UCDataID;
break;
}
if (sql != string.Empty)
{
DataTable dt = PicFill(sql);
foreach (DataRow dr in dt.Rows)
{
m_UCDataLstImage.Add(UCTemplatePic.ByteToImage(dr[UCDBPicFieldName] as byte[]));
if (UCDBSmallPicFieldName != string.Empty)
{
m_UCDataLstSmallImage.Add(UCTemplatePic.ByteToImage(dr[UCDBSmallPicFieldName] as byte[]));
}
saveIDs.Add(SysConvert.ToInt32(dr["ID"]));
}
if (dt.Rows.Count > 0)
{
saveImageIndex = 0;
picShow.Image = m_UCDataLstImage[saveImageIndex];
}
else
{
picShow.Image = null;
}
}
}
else if (UCInputMainType == 2)//仅是图片交互模式
{
picShow.Image = null;
//代码待补充
if (m_UCDataLstImage.Count > 0)
{
saveImageIndex = 0;
picShow.Image = m_UCDataLstImage[saveImageIndex];
}
}
SetButtonStatus();
}
