///<summary>Gets one OrthoPlanLink by OrthoCaseNum and OrthoPlanLinkType. Each OrthoCase should have no more than one of each ///OrthoPlanLinkType associated to it.</summary> public static OrthoPlanLink GetOneForOrthoCaseByType(long orthoCaseNum, OrthoPlanLinkType linkType) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <OrthoPlanLink>(MethodBase.GetCurrentMethod(), orthoCaseNum, linkType)); } string command = $@"SELECT * FROM orthoplanlink WHERE orthoplanlink.OrthoCaseNum={POut.Long(orthoCaseNum)} AND orthoplanlink.LinkType={POut.Int((int)linkType)}" ; return(Crud.OrthoPlanLinkCrud.SelectOne(command)); }
///<summary>Gets a list of all OrthoPlanLinks by OrthoPlanLinkType for a list of OrthoCaseNums.</summary> public static List <OrthoPlanLink> GetAllForOrthoCasesByType(List <long> listOrthoCaseNums, OrthoPlanLinkType linkType) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <List <OrthoPlanLink> >(MethodBase.GetCurrentMethod(), listOrthoCaseNums, linkType)); } if (listOrthoCaseNums.Count <= 0) { return(new List <OrthoPlanLink>()); } string command = $@"SELECT * FROM orthoplanlink WHERE orthoplanlink.LinkType={POut.Int((int)linkType)} AND orthoplanlink.OrthoCaseNum IN({string.Join(",",listOrthoCaseNums)})" ; return(Crud.OrthoPlanLinkCrud.SelectMany(command)); }