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;
}
