///<summary>Gets a single sheet from the database. Then, gets all the fields and parameters for it. So it returns a fully functional sheet.</summary>
public static Sheet GetSheet(long sheetNum)
{
//No need to check RemotingRole; no call to db.
Sheet sheet = CreateObject(sheetNum);
SheetFields.GetFieldsAndParameters(sheet);
return(sheet);
}
///<summary>Gets a single sheet from the database. Then, gets all the fields and parameters for it. So it returns a fully functional sheet.
///Returns null if the sheet isn't found in the database.</summary>
public static Sheet GetSheet(long sheetNum)
{
//No need to check RemotingRole; no call to db.
Sheet sheet = GetOne(sheetNum);
if (sheet == null)
{
return(null); //Sheet was deleted.
}
SheetFields.GetFieldsAndParameters(sheet);
return(sheet);
}
///<summary>Gets sheets with PatNum=0 and IsDeleted=0. Sheets with no PatNums were most likely transferred from CEMT tool.
///Also sets the sheet's SheetFields.</summary>
public static List <Sheet> GetTransferSheets()
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetObject <List <Sheet> >(MethodBase.GetCurrentMethod()));
}
//Sheets with patnum=0 and the sheet has a sheetfield.
string command = "SELECT * FROM sheet "
+ "INNER JOIN sheetfield ON sheetfield.SheetNum=sheet.SheetNum "
+ "WHERE PatNum=0 AND IsDeleted=0 "
+ "AND sheetfield.FieldName='isTransfer' "
+ $"AND SheetType={POut.Int((int)SheetTypeEnum.PatientForm)}";
List <Sheet> retVal = Crud.SheetCrud.SelectMany(command);
//Get the Sheetfields and parameters for each of the CEMT sheets
foreach (Sheet sheet in retVal)
{
SheetFields.GetFieldsAndParameters(sheet);
}
return(retVal);
}