public static Data.FileItem[] SelectTicketFiles(int DeptID, int SchedTicketId) { DataTable _dt = SelectRecords("sp_SelectSchedTicketFiles", new SqlParameter[] { new SqlParameter("@DId", DeptID), new SqlParameter("@SchedTicketId", SchedTicketId) }); Data.FileItem[] _arr = new Data.FileItem[_dt.Rows.Count]; for (int i = 0; i < _dt.Rows.Count; i++) { _arr[i] = new Data.FileItem((int)_dt.Rows[i]["Id"], _dt.Rows[i]["FileName"].ToString(), (int)_dt.Rows[i]["FileSize"], (DateTime)_dt.Rows[i]["dtUpdated"], (byte[])_dt.Rows[i]["FileData"]); } return(_arr); }
public static Data.FileItem[] SelectFilesToArray(int DeptID, int TicketId) { DataTable _dt = SelectFiles(DeptID, TicketId); Data.FileItem[] _arr = new Data.FileItem[_dt.Rows.Count]; for (int i = 0; i < _dt.Rows.Count; i++) _arr[i] = new Data.FileItem((int)_dt.Rows[i]["Id"], _dt.Rows[i]["FileName"].ToString(), (int)_dt.Rows[i]["FileSize"], (DateTime)_dt.Rows[i]["dtUpdated"], !_dt.Rows[i].IsNull("FileData") ? (byte[])_dt.Rows[i]["FileData"] : null); return _arr; }
public static Data.FileItem[] SelectTicketFiles(int DeptID, int SchedTicketId) { DataTable _dt = SelectRecords("sp_SelectSchedTicketFiles", new SqlParameter[] { new SqlParameter("@DId", DeptID), new SqlParameter("@SchedTicketId", SchedTicketId) }); Data.FileItem[] _arr = new Data.FileItem[_dt.Rows.Count]; for (int i = 0; i < _dt.Rows.Count; i++) _arr[i] = new Data.FileItem((int)_dt.Rows[i]["Id"], _dt.Rows[i]["FileName"].ToString(), (int)_dt.Rows[i]["FileSize"], (DateTime)_dt.Rows[i]["dtUpdated"], (byte[])_dt.Rows[i]["FileData"]); return _arr; }