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