public objAttachment Select_Obj(IDataReader idr) { objAttachment o = new objAttachment(); bool rtNull = true; if (idr != null) { while (idr.Read()) { rtNull = false; if (idr["attachmentId"] != DBNull.Value) { o.attachmentId = Convert.ToInt32(idr["attachmentId"]); } if (idr["attachmentOriginalFileName"] != DBNull.Value) { o.attachmentOriginalFileName = Convert.ToString(idr["attachmentOriginalFileName"]); } if (idr["attachmentMaskedFileName"] != DBNull.Value) { o.attachmentMaskedFileName = Convert.ToString(idr["attachmentMaskedFileName"]); } if (idr["transGroupID"] != DBNull.Value) { o.transGroupID = Convert.ToInt32(idr["transGroupID"]); } } } if (rtNull) { o = null; } return(o); }
public void Update(objAttachment i) { db.Update( i.attachmentId, i.attachmentOriginalFileName, i.attachmentMaskedFileName, i.transGroupID); }