/// <summary>
/// 添加图形记录
/// </summary>
/// <param name="SQLlist"></param>
private void InsertLisPicture(SortedList SQLlist, DataTable dt, DataRow dr)
{
SQLlist.Add(new Hashtable()
{
{ "DELETE", "DeleteDALisPictureByRequestcode" }
}, dr["RequestCode"]);
if (dt == null)
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow drpicture = dt.Rows[i];
DALispicture _lispicture = new DALispicture();
_lispicture.Requestcode = dr["RequestCode"].ToString();
if (dt.Columns.Contains("HospSampleID") && dr["HospSampleID"] != DBNull.Value)
{
_lispicture.Hospsampleid = dr["HospSampleID"].ToString();
}
if (dt.Columns.Contains("HospSampleNumber") && dr["HospSampleNumber"] != DBNull.Value)
{
_lispicture.Hospsamplenumber = dr["HospSampleNumber"].ToString();
}
if (dt.Columns.Contains("displayorder") && drpicture["displayorder"] != DBNull.Value)
{
_lispicture.Indexno = Convert.ToDecimal(drpicture["displayorder"]);
}
if (dt.Columns.Contains("description") && drpicture["description"] != DBNull.Value)
{
_lispicture.Description = drpicture["description"].ToString();
}
if (dt.Columns.Contains("IMAGEDATA") && drpicture["IMAGEDATA"] != DBNull.Value && drpicture["IMAGEDATA"].ToString() != string.Empty)
{
_lispicture.Imagedata = Convert.FromBase64String(drpicture["IMAGEDATA"].ToString());
}
SQLlist.Add(new Hashtable()
{
{ "INSERT", "InsertDALisPicture" }
}, _lispicture);
}
}
/// <summary>
/// 修改图形记录
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int UpdateDALispictureInfo(DALispicture config)
{
return(service.update("UpdateDALisPicture", config));
}
/// <summary>
/// 添加图形记录
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public object InsertDALispictureInfo(DALispicture config)
{
return(service.insert("InsertDALisPicture", config));
}
