Example #1
0
		///<summary></summary>
		public static long Insert(Laboratory laboratory) {
			if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
				laboratory.LaboratoryNum=Meth.GetLong(MethodBase.GetCurrentMethod(),laboratory);
				return laboratory.LaboratoryNum;
			}
			return Crud.LaboratoryCrud.Insert(laboratory);
		}
Example #2
0
		///<summary></summary>
		public static void Update(Laboratory laboratory) {
			if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
				Meth.GetVoid(MethodBase.GetCurrentMethod(),laboratory);
				return;
			}
			Crud.LaboratoryCrud.Update(laboratory);
		}
		public static string LabCaseWithInvalidLaboratory(bool verbose,bool isCheck) {
			if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
				return Meth.GetString(MethodBase.GetCurrentMethod(),verbose,isCheck);
			}
			string log="";
			if(isCheck) {
				command="SELECT COUNT(*) FROM labcase WHERE laboratoryNum NOT IN(SELECT laboratoryNum FROM laboratory)";
				int numFound=PIn.Int(Db.GetCount(command));
				if(numFound>0 || verbose) {
					log+=Lans.g("FormDatabaseMaintenance","Lab cases found with invalid laboratories")+": "+numFound+"\r\n";
				}
			}
			else {
				command="SELECT COUNT(*) FROM labcase WHERE laboratoryNum NOT IN(SELECT laboratoryNum FROM laboratory)";
				long numberFixed=long.Parse(Db.GetCount(command));
				command="SELECT * FROM labcase WHERE laboratoryNum NOT IN(SELECT laboratoryNum FROM laboratory) GROUP BY LaboratoryNum";
				table=Db.GetTable(command);
				long labnum;
				for(int i=0;i<table.Rows.Count;i++) {
					Laboratory lab=new Laboratory();
					lab.LaboratoryNum=PIn.Long(table.Rows[i]["LaboratoryNum"].ToString());
					lab.Description="Laboratory "+table.Rows[i]["LaboratoryNum"].ToString();
					//laboratoryNum is not allowed to be zero
					labnum=Crud.LaboratoryCrud.Insert(lab);
					command="UPDATE labcase SET LaboratoryNum="+POut.Long(labnum)+" WHERE LaboratoryNum="+table.Rows[i]["LaboratoryNum"].ToString();
					Db.NonQ(command);
				}
				if(numberFixed>0 || verbose) {
					log+=Lans.g("FormDatabaseMaintenance","Lab cases fixed with invalid laboratories")+": "+numberFixed.ToString()+"\r\n";
				}
			}
			return log;
		}