///<summary>Create an entry per each docNum in the list. If setting isWaiting flag to true then create a row containing the given EhrLabNum and DocNum==-1. Otherwise omit such a row.</summary>
public static void InsertAllForLabNum(long ehrLabNum, bool isWaiting, List <long> docNums)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), ehrLabNum, isWaiting, docNums);
return;
}
//Delete existing rows for this EhrLabNum.
DeleteForLab(ehrLabNum);
//Create the waiting flag if necessary
if (isWaiting)
{
EhrLabImage labImage = new EhrLabImage();
labImage.EhrLabNum = ehrLabNum;
labImage.DocNum = -1;
Insert(labImage);
}
//Create the rest of the links
for (int i = 0; i < docNums.Count; i++)
{
EhrLabImage labImage = new EhrLabImage();
labImage.EhrLabNum = ehrLabNum;
labImage.DocNum = docNums[i];
Insert(labImage);
}
}
///<summary></summary>
public static long Insert(EhrLabImage ehrLabImage)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
ehrLabImage.EhrLabImageNum = Meth.GetLong(MethodBase.GetCurrentMethod(), ehrLabImage);
return(ehrLabImage.EhrLabImageNum);
}
return(Crud.EhrLabImageCrud.Insert(ehrLabImage));
}
///<summary>EhrLab first EhrLab which this docNum is attached to. Or returns null if docNum is not attached to any EhrLabs.</summary>
public static EhrLab GetFirstLabForDocNum(long docNum)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetObject <EhrLab>(MethodBase.GetCurrentMethod(), docNum));
}
//Get first EhrLabImage that has this docNum attached.
string command = "SELECT * FROM ehrlabimage WHERE DocNum = " + POut.Long(docNum) + " LIMIT 1";
EhrLabImage labImage = Crud.EhrLabImageCrud.SelectOne(command);
if (labImage == null) //Not found so return
{
return(null);
}
//Get the EhrLab which this labImage is attached to
command = "SELECT * FROM ehrlab WHERE EhrLabNum = " + POut.Long(labImage.EhrLabNum);
return(Crud.EhrLabCrud.SelectOne(labImage.EhrLabNum));
}
///<summary>Create an entry per each docNum in the list. If setting isWaiting flag to true then create a row containing the given EhrLabNum and DocNum==-1. Otherwise omit such a row.</summary>
public static void InsertAllForLabNum(long ehrLabNum,bool isWaiting,List<long> docNums) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),ehrLabNum,isWaiting,docNums);
return;
}
//Delete existing rows for this EhrLabNum.
DeleteForLab(ehrLabNum);
//Create the waiting flag if necessary
if(isWaiting) {
EhrLabImage labImage=new EhrLabImage();
labImage.EhrLabNum=ehrLabNum;
labImage.DocNum=-1;
Insert(labImage);
}
//Create the rest of the links
for(int i=0;i<docNums.Count;i++) {
EhrLabImage labImage=new EhrLabImage();
labImage.EhrLabNum=ehrLabNum;
labImage.DocNum=docNums[i];
Insert(labImage);
}
}
private void gridMain_CellClick(object sender,UI.ODGridClickEventArgs e) {
try {
PaintPreviewPicture();
if(e.Col!=0) {
return;
}
Document doc=GetSelectedDocument();
int existingIndex=-1;
for(int i=0;i<_listAttached.Count;i++) {
if(_listAttached[i].EhrLabNum==_ehrLabNum && _listAttached[i].DocNum==doc.DocNum) {
//found it, mark it for delete
existingIndex=i;
break;
}
}
if(existingIndex>=0) { //it exists so delete it
_listAttached.RemoveAt(existingIndex);
}
else { //it doesn't exist so add it
EhrLabImage labImage=new EhrLabImage();
labImage.EhrLabNum=_ehrLabNum;
labImage.DocNum=doc.DocNum;
_listAttached.Add(labImage);
}
FillGrid();
}
catch { }
}
///<summary></summary>
public static long Insert(EhrLabImage ehrLabImage) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
ehrLabImage.EhrLabImageNum=Meth.GetLong(MethodBase.GetCurrentMethod(),ehrLabImage);
return ehrLabImage.EhrLabImageNum;
}
return Crud.EhrLabImageCrud.Insert(ehrLabImage);
}
