public OrderEntryForm2(SetupTableData setupTableData, GetSqlServer getSqlServer, Hospital hospital) : base(setupTableData, getSqlServer, hospital) { Load += orderentry_Load; InitializeComponent(); groupTestToIndividualTest = new GroupTestToIndividualTest(getSqlServer); }
public StatOrderQueryForm(string query, string queryName, GetSqlServer getSqlServer) { // This call is required by the Windows Form Designer. InitializeComponent(); // Add any initialization after the InitializeComponent() call. this.QUERY = query; this.QUERYName = queryName; this.getSqlServer = getSqlServer; }
public SetupTableData(GetSqlServer getSqlServer, Hospital hospital) { wards = getSqlServer.FilledColumn("select Clinic_code from [CLINIC]"); DISpecimenTranslation = getSqlServer.FilledDictionary("SELECT [type], [translation] FROM [downtime].[dbo].[diTranslation]").ToReadOnly(); #if DEBUG var dr = new GetPathDirectory().Labels.GetLabelersListOfIPs_byGroup(string.Format("/{0}/Specimen Management", Enum.GetName(typeof(Hospital), hospital))); if (hospital == Hospital.Highland) { dr.Add("C42", "172.16.60.252"); } LabelersByIp = dr.ToReadOnly(); #else LabelersByIp = new GetPathDirectory().Labels.GetLabelersListOfIPs_byGroup(string.Format("/{0}/Specimen Management", Enum.GetName(typeof(Hospital), hospital))).ToReadOnly(); #endif }
public OrderBaseForm(SetupTableData setupTableData, GetSqlServer getSqlServer, Hospital hospital) : base() { InitializeComponent(); this.setupTableData = setupTableData; this.getSqlServer = getSqlServer; this.hospital = hospital; #if DEBUG this.DebugButtonFill.Visible = true; #endif this.TextBoxTechId.Text = GlobalMutableState.userName; ComboboxPrinter.Items.AddRange(setupTableData.LabelersByIp.Keys.ToArray()); comboBoxWard.Items.AddRange(setupTableData.wards); ComboboxPrinter.AutoCompleteMode = AutoCompleteMode.SuggestAppend; ComboboxPrinter.AutoCompleteSource = AutoCompleteSource.ListItems; comboBoxWard.AutoCompleteMode = AutoCompleteMode.SuggestAppend; comboBoxWard.AutoCompleteSource = AutoCompleteSource.ListItems; //use SchemaFilledTable to load the table layout testTable = getSqlServer.SchemaFilledTable("SELECT TOP 1 [Id], [Name], [Tube], [Location], [Extension], [DiTranslation] FROM [dbo].[TestsWithSpecimenExtension]"); this.dataGridTests.DataSource = testTable; }
public GroupTestToIndividualTest(GetSqlServer getSqlServer) { groupTestsTable = getSqlServer.FilledTable("SELECT * FROM grouptest"); ; }
public TrackCoagForm(GetSqlServer getSqlServer) : base(getSqlServer) { InitializeComponent(); }
public AliquotForm(SetupTableData setupTableData, GetSqlServer getSqlServer, Hospital hospital) : base(setupTableData, getSqlServer, hospital) { InitializeComponent(); }
public RecoveryForm(GetSqlServer getSqlServer) { InitializeComponent(); this.getSqlServer = getSqlServer; }
/// <summary> /// Required for VisualStudio designer /// </summary> public TrackingBase(GetSqlServer getSqlServer) : base() { InitializeComponent(); this.getSqlServer = getSqlServer; }
/// <summary> /// insert the order with the ordered tests and patient info /// </summary> public void InsertOrder(GetSqlServer getSqlServer) { var testRows = tests.Select(x => "SELECT '" + x.Key["Id"] + "', '" + ((x.Value) ? "1" : "0") + "', SCOPE_IDENTITY()") .mkString(" UNION ALL "); getSqlServer.ExecuteNonQuery(String.Format(@"INSERT INTO [ordered] ([ordernumber] ,[collectiontime], [receivetime], [ward], [priority], [mrn], [dob], [FIRSTNAME],[PROBLEM],[CALLS] ,[ORDERCOMMENT],[LASTNAME],[TRACKING],[TRACKINGCOMMENT],[TECHID],[BILLINGNUMBER],[collectdate]) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}', '{10}','{11}','{12}','{13}','{14}','{15}','{16}'); " + "Insert INTO [testOnOrder] (test,hl7Sent,ordernumberId) " + testRows, orderNumber, collectionTime, receiveTime, ward, priority, mrn, dob, firstName, problem, calls, comment, lastName, "", "", techId, billingNumber,collectDate)); }
public static Option<DataRow> orderLookup(string orderNumber, GetSqlServer getSqlServer) { return getSqlServer.FilledRowOption("select TOP 1 * FROM [ordered] where ordernumber like '" + orderNumber + "' ORDER BY ID DESC"); }
public TrackUrineHemForm(GetSqlServer getSqlServer) : base(getSqlServer) { InitializeComponent(); }
public RestartWheel(GetSqlServer getSqlServer) { InitializeComponent(); this.getSqlServer = getSqlServer; }
/// <summary> /// If the Date changes, wipe out the table of orderNumbers and restart ordering /// </summary> /// <remarks></remarks> public static void TruncateOrderNumbersOnDateChange(GetSqlServer getSqlServer) { if (DateTime.Now.Day != GlobalMutableState.StartupDate.Day) { var dtable = getSqlServer.FilledTable("select * FROM ordernumber"); if (dtable.Rows.Count != 1) { getSqlServer.ExecuteNonQuery("truncate TABLE ordernumber"); getSqlServer.ExecuteNonQuery("insert into ordernumber (OrderLast,Ordernumber) VALUES (1, 7500);"); } GlobalMutableState.StartupDate = System.DateTime.Now; } }
/// <summary> /// use the DB to generate a the next orderNumber /// </summary> /// <returns></returns> /// <remarks></remarks> public static string getNewOrderNumber(GetSqlServer getSqlServer) { TruncateOrderNumbersOnDateChange(getSqlServer); DataRow q = getSqlServer.FilledRowOption("insert into ordernumber (OrderLast,Ordernumber) select TOP 1 OrderLast+1, ordernumber+1 FROM ordernumber ORDER BY OrderLast DESC; select TOP 1 OrderLast, Ordernumber FROM ordernumber ORDER BY OrderLast DESC;").get; string neworernumber = q["Ordernumber"].ToString(); if (neworernumber.Length > 4) { string letters = Strings.Left(neworernumber, 2); string ordernums = Strings.Right(neworernumber, 3); neworernumber = Strings.Chr(int.Parse(letters)) + ordernums; } return date2ordernumber(System.DateTime.Now) + neworernumber.PadLeft(4, '0'); }
public MolisEntry(GetSqlServer getSqlServer) { InitializeComponent(); this.getSqlServer = getSqlServer; }