private void selectTappedout_Click(object sender, EventArgs e)
{
DraftSite = SelectedSite.Tappedout;
Close();
}
private void selectCCGDecks_Click(object sender, EventArgs e)
{
DraftSite = SelectedSite.CCGDecks;
Close();
}
void LoadConfigs()
{
string sitename = SelectedSite.Substring(0, 7);
GetConfigs(sitename);
}
void Download()
{
_isDownloading = true;
worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.WorkerSupportsCancellation = true;
DownloadProgress = 0;
worker.ProgressChanged += delegate(object sender, ProgressChangedEventArgs e)
{
DownloadProgress = e.ProgressPercentage;
};
worker.DoWork += delegate(object sender, DoWorkEventArgs args)
{
PIDownloader pi = new PIDownloader(DataSourceType.WindART_SQL);
DownloadProgressText = "Initializing Connection....";
foreach (string config in _configs.selectedItems)
{
List <Tag> SelectedTags = new List <Tag>();
DownloadProgress = 0;
int tagdownloadcount = 0;
string sitename = SelectedSite.Substring(0, 7);
SelectedTags = SelectTags(sitename);
TagManager tmReference = null;
tmReference = new TagManager(SelectedTags, sitename);
TagManagers.Add(tmReference);
foreach (Tag tag in SelectedTags)
{
if (tag == null)
{
continue;
}
string tagname = tag.TagName;
if (_downloadCancelled)
{
tmReference = null;
worker.ReportProgress(0);
worker.CancelAsync();
_downloadCancelled = false;
break;
}
SortedDictionary <DateTime, double> TagData = new SortedDictionary <DateTime, double>();
StringBuilder sql = new StringBuilder();
sql.Append(@"select time, value from piserver.piarchive..picomp where tag='");
sql.Append(tagname);
sql.Append("' and time between '");
sql.Append(tag.StartDate.ToShortDateString());
sql.Append(" 00:00:00");
sql.Append("' and '");
sql.Append(tag.EndDate.ToShortDateString());
sql.Append(" 00:00:00");
sql.Append("' and value is not null");
//System.Diagnostics.Debug.Print(sql.ToString ());
DataTable pidata = data.GetData(sql.ToString());
foreach (DataRow row in pidata.Rows)
{
DateTime thisDate = (DateTime)row["time"];
if (!TagData.ContainsKey(thisDate))
{
// Console.WriteLine(row["time"].ToString() + " " + row["value"].ToString());
TagData.Add(thisDate, Double.Parse(row["value"].ToString()));
}
else
{
// Console.WriteLine(row["time"].ToString() + " not found in " + tag.TagName);
TagData[thisDate] = -9999.0;
}
}
tmReference[tag.TagName].Data = TagData;
tagdownloadcount++;
int progress = (int)(double.Parse(tagdownloadcount.ToString()) / double.Parse(SelectedTags.Count().ToString()) * 100);
worker.ReportProgress(progress);
}
//add the downloaded data to a datatable
DownloadedData.Add(CreateDateTimeDataTable(tmReference));
}
};
worker.RunWorkerAsync();
_isDownloading = false;
}
private void showdata(string searchdata)
{
try
{
SelectedSite selectedData = (SelectedSite)DDSite.SelectedItem;
List <int> selectedSite = selectedData.SiteSelect;
using (InhCheckupDataContext cdc = new InhCheckupDataContext())
{
string txtSearch = searchdata.Trim().ToLower();
DateTime dateNow = Program.GetServerDateTime();
var datanewx = cdc.vw_pat_status.Where(x => selectedSite.Contains(x.mhs_id) &&
x.tpr_arrive_date.Value.Date == dateNow.Date &&
(searchdata.Length == 0 ? true :
(x.tpr_queue_no.ToLower().Contains(searchdata) ||
x.name.ToLower().Contains(searchdata) ||
x.tpt_hn_no.ToLower().Contains(searchdata) ||
x.mhs_ename.ToLower().Contains(searchdata) ||
x.tpt_hn_no.ToLower().Replace("-", "").Contains(searchdata))))
.OrderBy(x => x.tpt_hn_no)
.ToList()
.Select((x, inx) => new footerclass
{
no = inx + 1,
tprID = x.tpr_id,
mhs_id = x.mhs_id,
Dept = x.mhs_ename,
queue_no = x.tpr_queue_no,
hn_no = x.tpt_hn_no,
name = x.name,
RG = GetImage(x.RG),
BM = GetImage(x.BM),
SC = GetImage(x.SC),
CB = GetImage(x.CB),
PE = GetImage(x.PE),
CD = GetImage(x.CD),
XR = GetImage(x.XR),
US1 = GetImage(x.UU),
US2 = GetImage(x.UL),
US3 = GetImage(x.UB),
US4 = GetImage(x.UW),
DM = GetImage(x.DM),
BD = GetImage(x.BD),
EN = GetImage(x.EN),
EM = GetImage(x.EM),
HS = GetImage(x.HS),
EK = GetImage(x.EK),
AB = GetImage(x.AB),
ES = GetImage(x.ES),
PT = GetImage(x.PT),
TX = GetImage(x.TX),
TE = GetImage(x.TE),
UG = GetImage(x.UG),
PF = GetImage(x.PF),
CC = GetImage(x.CC),
DC = GetImage(x.DC),
PH = GetImage(x.PH),
BK = GetImage(x.BK),
FN = GetImage(x.FN)
})
.ToList();
dataGridView1.DataSource = datanewx;
dataGridView1.Columns["ColsiteID"].Visible = false;
lbdataPatientHPCSITE.Text = string.Format("{0} (Total {1} คน)", selectedData.Description, datanewx.Count());
}
}
catch (Exception ex)
{
Program.MessageError(this.Name, "showdata(string searchdata)", ex, false);
}
//DateTime serverdate = Program.GetServerDateTime();
//DateTime dnow = new DateTime(serverdate.Year, serverdate.Month, serverdate.Day, 0, 0, 0);
//using (InhCheckupDataContext cdc = new InhCheckupDataContext())
//{
// int? mhs_id = null;
// if (DDSite.SelectedValue != null && DDSite.SelectedValue.ToString() != "0")
// {
// mhs_id = Convert.ToInt32(DDSite.SelectedValue);
// }
// var datanewx = cdc.vw_pat_status.Where(x => (mhs_id == null ? true : x.mhs_id == mhs_id) &&
// x.tpr_arrive_date.Value.Date == dnow.Date &&
// //x.RG != null &&
// (searchdata.Length == 0 ? true :
// (x.tpr_queue_no.ToLower().Contains(searchdata) ||
// x.name.ToLower().Contains(searchdata) ||
// x.tpt_hn_no.ToLower().Contains(searchdata) ||
// x.mhs_ename.ToLower().Contains(searchdata) ||
// x.tpt_hn_no.ToLower().Replace("-", "").Contains(searchdata))))
// .Select(x => new footerclass16
// {
// tprID = x.tpr_id,
// mhs_id = x.mhs_id,
// Dept = x.mhs_ename,
// queue_no = x.tpr_queue_no,
// hn_no = x.tpt_hn_no,
// name = x.name,
// RG = GetImage(x.RG),
// BM = GetImage(x.BM),
// SC = GetImage(x.SC),
// CB = GetImage(x.CB),
// PE = GetImage(x.PE),
// CD = GetImage(x.CD),
// XR = GetImage(x.XR),
// US1 = GetImage(x.UU),
// US2 = GetImage(x.UL),
// US3 = GetImage(x.UB),
// US4 = GetImage(x.UW),
// DM = GetImage(x.DM),
// BD = GetImage(x.BD),
// EN = GetImage(x.EN),
// EM = GetImage(x.EM),
// HS = GetImage(x.HS),
// EK = GetImage(x.EK),
// AB = GetImage(x.AB),
// ES = GetImage(x.ES),
// PT = GetImage(x.PT),
// TX = GetImage(x.TX),
// TE = GetImage(x.TE),
// UG = GetImage(x.UG),
// PF = GetImage(x.PF),
// CC = GetImage(x.CC),
// DC = GetImage(x.DC),
// PH = GetImage(x.PH),
// BK = GetImage(x.BK),
// FN = GetImage(x.FN)
// }).OrderBy(x => x.hn_no)
// .ToList();
// dataGridView1.DataSource = datanewx;
// dataGridView1.Columns["ColsiteID"].Visible = false;
// lbdataPatientHPCSITE.Text = string.Format("{0} (Total {1} คน)", _title, datanewx.Count());
//}
//InhCheckupDataContext dbc = new InhCheckupDataContext();
////var objmrmlist = (from t1 in dbc.vw_pat_status where t1.tpr_arrive_date.Value.Date == serverdate.Date && t1.RG != null select t1);
//var objmrmlist = (from t1 in dbc.vw_pat_status where t1.tpr_arrive_date.Value.Date == serverdate.Date select t1);
//if (DDSite.SelectedValue != null && DDSite.SelectedValue.ToString() != "0")
//{
// objmrmlist = objmrmlist.Where(x => x.mhs_id == Convert.ToInt32(DDSite.SelectedValue));
//}
//var datanewx = from t1 in objmrmlist
// select new footerclass16
// {
// tprID = t1.tpr_id,
// mhs_id = t1.mhs_id,
// Dept = t1.mhs_ename,
// queue_no = t1.tpr_queue_no,
// hn_no = t1.tpt_hn_no,
// name = t1.name,
// RG = GetImage(t1.RG),
// BM = GetImage(t1.BM),
// SC = GetImage(t1.SC),
// CB = GetImage(t1.CB),
// PE = GetImage(t1.PE),
// CD = GetImage(t1.CD),
// XR = GetImage(t1.XR),
// US1 = GetImage(t1.UU),
// US2 = GetImage(t1.UL),
// US3 = GetImage(t1.UB),
// US4 = GetImage(t1.UW),
// DM = GetImage(t1.DM),
// BD = GetImage(t1.BD),
// EN = GetImage(t1.EN),
// EM = GetImage(t1.EM),
// HS = GetImage(t1.HS),
// EK = GetImage(t1.EK),
// AB = GetImage(t1.AB),
// ES = GetImage(t1.ES),
// PT = GetImage(t1.PT),
// TX = GetImage(t1.TX),
// TE = GetImage(t1.TE),
// UG = GetImage(t1.UG),
// PF = GetImage(t1.PF),
// CC = GetImage(t1.CC),
// DC = GetImage(t1.DC),
// PH = GetImage(t1.PH),
// BK = GetImage(t1.BK),
// FN = GetImage(t1.FN)
// };
//if (searchdata != "")
//{//footerclass16
// searchdata = searchdata.ToLower();
// dataGridView1.DataSource = datanewx.Where(x => x.queue_no.ToLower().Contains(searchdata) ||
// x.name.ToLower().Contains(searchdata) ||
// x.hn_no.ToLower().Contains(searchdata) ||
// x.Dept.ToLower().Contains(searchdata) ||
// x.hn_no.ToLower().Replace("-", "").Contains(searchdata)).OrderBy(y => y.hn_no);
//}
//else
//{
// //var objdata = new SortableBindingList<footerclass16>(datanewx.OrderBy(y => y.hn_no).ToList());
// dataGridView1.DataSource = datanewx.OrderBy(y => y.hn_no);
//}
//dataGridView1.Columns["ColsiteID"].Visible = false;
//lbdataPatientHPCSITE.Text = string.Format("{0} (Total {1} คน)", _title, datanewx.Count());
}
