/// <summary>
/// ²éѯÊÇ·ñ´æÔÚÖ¸¶¨µÄÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="imodel"></param>
/// <returns></returns>
public override bool Exists(IModel imodel)
{
MReqScanImage model = (MReqScanImage)imodel;
strSql = "select * from " + TableName + " where EXAM_NO=" + model.EXAM_ACCESSION_NUM + "and IMAGE_INDEX=" + model.IMAGE_INDEX;
return(recordIsExist(strSql));
}
/// <summary>
/// ÅúÁ¿²åÈëÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MReqScanImage scanImage = new MReqScanImage();
Hashtable ht = new Hashtable();
int j = 0;
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
scanImage = (MReqScanImage)ht2[i];
ht.Add("EXAM_NO", scanImage.EXAM_ACCESSION_NUM);
ht.Add("IMAGE_INDEX", scanImage.IMAGE_INDEX);
ht.Add("IMAGE_FILE", scanImage.IMAGE_FILE);
ht.Add("OPERATOR", scanImage.OPERATOR);
j += ExecuteSql(StringConstructor.InsertSql(TableName, ht), ht);
}
return(j);
}
else
{
return(0);
}
}
/// <summary>
/// ²åÈëÒ»ÌõÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="imodel"></param>
/// <returns></returns>
public override int Add(IModel imodel)
{
MReqScanImage model = (MReqScanImage)imodel;
Hashtable ht = new Hashtable();
ht.Add("EXAM_NO", model.EXAM_ACCESSION_NUM);
ht.Add("IMAGE_INDEX", model.IMAGE_INDEX);
ht.Add("IMAGE_FILE", model.IMAGE_FILE);
ht.Add("OPERATOR", model.OPERATOR);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// ¸üÐÂÖ¸¶¨µÄÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="iimage"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iimage, string where)
{
MReqScanImage image = (MReqScanImage)iimage;
Hashtable ht = new Hashtable();
ht.Add("EXAM_NO", image.EXAM_ACCESSION_NUM);
ht.Add("IMAGE_INDEX", image.IMAGE_INDEX);
ht.Add("IMAGE_FILE", image.IMAGE_FILE);
ht.Add("OPERATOR", image.OPERATOR);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// »ñÈ¡Ö¸¶¨¼ì²éÉêÇëµ¥ºÅ¡¢Í¼ÏñË÷ÒýµÄÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="EXAM_ACCESSION_NUM"></param>
/// <param name="IMAGE_INDEX"></param>
/// <returns></returns>
public override IModel GetModel(string EXAM_ACCESSION_NUM, string IMAGE_INDEX)
{
strSql = "select * from " + TableName + " where EXAM_NO=" + EXAM_ACCESSION_NUM + "and IMAGE_INDEX=" + IMAGE_INDEX;
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MReqScanImage Model = new MReqScanImage();
Model.EXAM_ACCESSION_NUM = dt.Rows[0]["EXAM_NO"].ToString();
Model.IMAGE_INDEX = int.Parse(IMAGE_INDEX);
Model.IMAGE_FILE = (byte[])dt.Rows[0]["IMAGE_FILE"];
Model.OPERATOR = dt.Rows[0]["OPERATOR"].ToString();
return(Model);
}
