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