public System.IO.MemoryStream ShowImage(string partNo, decimal drwType, int issueNo)
{
PROD_DRAWING ddDrawing = null;
byte[] photosource = null;
System.IO.MemoryStream strm;
try
{
ddDrawing = (from c in DB.PROD_DRAWING
where c.PART_NO == partNo && c.DWG_TYPE == drwType && c.PAGE_NO == issueNo
select c).SingleOrDefault <PROD_DRAWING>();
if (ddDrawing.IsNotNullOrEmpty())
{
if (ddDrawing.PROD_DRW_IMAGE != null)
{
photosource = ddDrawing.PROD_DRW_IMAGE.ToArray();
strm = new System.IO.MemoryStream(photosource);
return(strm);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (System.Data.Linq.ChangeConflictException)
{
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
return(null);
}
catch (Exception ex)
{
ex.LogException();
DB.PROD_DRAWING.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddDrawing);
return(null);
}
}
public string ShowDrawing(string part_no)
{
PROD_DRAWING ddDrawing = null;
//PROD_DRAWING
//byte[] photosource = null;
//System.IO.MemoryStream strm=null;
try
{
ddDrawing = (from c in DB.PROD_DRAWING
where c.PART_NO == part_no
select c).FirstOrDefault <PROD_DRAWING>();
if (ddDrawing.IsNotNullOrEmpty())
{
if (ddDrawing.PRD_DWG != null)
{
return(ddDrawing.PRD_DWG.ToString());
}
else
{
return("");
}
}
else
{
return("");
}
//return "";
}
catch (System.Data.Linq.ChangeConflictException)
{
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
return("");
}
catch (Exception ex)
{
throw ex.LogException();
}
}
