/*
* ///<summary>This query is run with full privileges.</summary>
* public static int NonQ(string[] commands) {
* DataConnection dcon=new DataConnection();
*
* int rowsChanged=dcon.NonQ(cmd);
* return rowsChanged;//I don't think this will be accurate
* }*/
///<summary>This is for multiple queries all concatenated together with ;</summary>
public static DataSet GetDataSet(string commands)
{
DataConnection dcon = new DataConnection();
//DataTable table=dcon.GetTable(command);
DataSet retVal = dcon.GetDs(commands);
//retVal.Tables.Add(table);
return(retVal);
}
public static DataSet Refresh()
{
string command = "SELECT * FROM covcat ORDER BY covorder;"
+ "SELECT * FROM covcat WHERE IsHidden = 0 ORDER BY CovOrder";
DataConnection dcon = new DataConnection();
DataSet retVal = dcon.GetDs(command);
FillLists(retVal);
return(retVal);
}
///<summary></summary>
public static DataSet Refresh(int patNum)
{
string command = "SELECT * FROM procedurelog WHERE PatNum=" + POut.PInt(patNum);
//if(!includeDeletedAndNotes){
command += " AND ProcStatus !=6"; //don't include deleted
//}
command += " ORDER BY ProcDate"; //,OldCode
//notes:
/* +";SELECT * FROM procnote WHERE PatNum="+POut.PInt(patNum)
+" ORDER BY EntryDateTime";*/
DataConnection dcon = new DataConnection();
DataSet ds = dcon.GetDs(command);
//add a note column to the proc table.
//ds.Tables[0].Columns.Add("UserNum");
//ds.Tables[0].Columns.Add("Note");//,,typeof(string));
//ds.Tables[0].Columns.Add("SigIsTopaz");//,typeof(string));
//ds.Tables[0].Columns.Add("Signature");//,typeof(string));
/*
* for(int i=0;i<ds.Tables[0].Rows.Count;i++){//loop through each proc
* for(int n=ds.Tables[1].Rows.Count-1;n>=0;n--){//loop through each note, backwards.
* if(ds.Tables[0].Rows[i]["ProcNum"].ToString() != ds.Tables[1].Rows[n]["ProcNum"].ToString()) {
* continue;
* }
* //userNum=PIn.PInt(ds.Tables[1].Rows[n]["UserNum"].ToString());
* ds.Tables[0].Rows[i]["UserNum"] =ds.Tables[1].Rows[n]["UserNum"].ToString();
* ds.Tables[0].Rows[i]["Note"] =ds.Tables[1].Rows[n]["Note"].ToString();
* ds.Tables[0].Rows[i]["SigIsTopaz"]=ds.Tables[1].Rows[n]["SigIsTopaz"].ToString();
* ds.Tables[0].Rows[i]["Signature"] =ds.Tables[1].Rows[n]["Signature"].ToString();
* break;//out of note loop.
* }
* }*/
//ds.Tables.RemoveAt(1);
return(ds);
}