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(); } }