private void LoadMenu(string userid) { slAmidaConsole.Web.EQ_DomainContext db = new Web.EQ_DomainContext(); EntityQuery< vwUserMenuAllow> qry = from n in db.GetVwUserMenuAllowQuery() where n.UserID == userid && n.IsAllow select n; LoadOperation<vwUserMenuAllow> lo = db.Load<vwUserMenuAllow>(qry); lo.Completed += (s, a) => { if (lo.Error != null) { MessageBox.Show(lo.Error.Message); return; } MenuInfos = new System.Collections.ObjectModel.ObservableCollection<vwUserMenuAllow>(lo.Entities); var q = (from n in MenuInfos group n by new { n.GroupName, n.MenuOrder} into gn select new MenuInfo { MainMenu = gn.Key.GroupName, MenuOrder=gn.Key.MenuOrder, Menus = gn.ToList<vwUserMenuAllow>() }).OrderBy(x=>x.MenuOrder); this.accordin.ItemsSource = q.ToList<MenuInfo>(); // var MainMenus = (from n in MenuInfos select n.GroupName).Distinct<string>(); // foreach (string mainmenu in MainMenus) // { // AccordionItem item = new AccordionItem() { Header = mainmenu }; // var q = from n in MenuInfos where n.GroupName == mainmenu select n; // item.DataContext = q; // this.accordin.Items.Add (item); // } }; }
private void button1_Click(object sender, RoutedEventArgs e) { Uri uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=4"); InvokeOperation<slAmidaConsole.Web.RptSchema.rptCurrentWIPSchema[]> lo = null; slAmidaConsole.Web.EQ_DomainContext client = new EQ_DomainContext(); lo = client.GetCurrentWIP(); this.BusyIndicator1.IsBusy = true; lo.Completed += (s, a) => { this.BusyIndicator1.IsBusy = false; this.dataGrid1.ItemsSource = lo.Value; }; HtmlWindow html = HtmlPage.Window; if (chkDownload.IsChecked == true) html.Navigate(uri); }
private void button1_Click(object sender, RoutedEventArgs e) { EQ_DomainContext context = new EQ_DomainContext(); this.busyIndicator1.IsBusy = true; EntityQuery<tblUser> q = (from n in context.GetTblUserQuery() where n.UserID == txtUserID.Text && n.Password == txtPassword.Password select n); LoadOperation<tblUser> lo = context.Load<tblUser>(q); lo.Completed += (s, a) => { if (lo.Error != null) { MessageBox.Show(lo.Error.Message); this.busyIndicator1.IsBusy = false; return; } tblUser user = lo.Entities.FirstOrDefault<tblUser>(); if (user == null) { MessageBox.Show("帳號密碼錯誤 !"); this.busyIndicator1.IsBusy = false; return; }; // slDBManager.WebContext client = new WebContext(); WebService.WebServiceSoapClient client = new WebService.WebServiceSoapClient(); client.RegisterSessionCompleted += (ss, aa) => { if (aa.Error != null) { MessageBox.Show(aa.Error.Message); this.busyIndicator1.IsBusy = false; return; } this.busyIndicator1.IsBusy = true; this.NavigationService.Navigate(new Uri("/EqManager.xaml?userid="+user.UserID+"&username="+user.UserName,UriKind.Relative)); }; client.RegisterSessionAsync(user.UserID); }; }
private void button1_Click(object sender, RoutedEventArgs e) { string wherestr=""; slAmidaConsole.Web.EQ_DomainContext client =new EQ_DomainContext(); //var q = from n in client.GetTblVerifyNoteQuery() where n.StartTimes == new DateTime(2013, 1, 1) select n; ; //client.Load(q); if (txtPCMASK.Text.Trim() != "") wherestr += " it.PCID like '" + txtPCMASK.Text + "%' and"; if (txtPCShape.Text.Trim() != "") { int res; if (!int.TryParse(txtPCShape.Text,out res)) { MessageBox.Show("ProbeShape must be integer!"); return; } wherestr += " it.ProbeShape=" + txtPCShape.Text.Trim() + " and"; } int datecnt = 0; if (txtStartDate.Text.Trim() != "" && txtStopDate.Text.Trim() != "") { DateTime res; if (!DateTime.TryParse(txtStartDate.Text.Trim(), out res)) { MessageBox.Show("Start Date format error!"); return; } if (!DateTime.TryParse(this.txtStopDate.Text.Trim(), out res)) { MessageBox.Show("End Date format error!"); return; } datecnt = 2; wherestr += string.Format(" it.StartTimes >= @p0 and it.StartTimes <@p1 and it.stoptimes >=@p0 and it.stoptimes <@p1 and"); } else if (txtStartDate.Text.Trim() != "" && txtStopDate.Text.Trim() == "") { DateTime res; if (!DateTime.TryParse(txtStartDate.Text.Trim(), out res)) { MessageBox.Show("Start Date format error!"); return; } datecnt = 1; wherestr += string.Format(" it.StartTimes >= @p0 and"); } else if (txtStartDate.Text.Trim() == "" && txtStopDate.Text.Trim() != "") { DateTime res; if (!DateTime.TryParse(txtStartDate.Text.Trim(), out res)) { MessageBox.Show("Start Date format error!"); return; } datecnt = 1; wherestr += string.Format(" it.stoptimes < @p1 and"); } wherestr= wherestr.TrimEnd(new char[] { 'a', 'n', 'd' }); Uri uri; InvokeOperation<slAmidaConsole.Web.RptSchema.RptTouchDownSchema[]> lo=null; if (datecnt == 2) { lo = client.GetTouchDownTotalBySql(wherestr, DateTime.Parse(txtStartDate.Text), DateTime.Parse(txtStopDate.Text)); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=1&wherestr="+wherestr+"&starttimes=" + txtStartDate.Text.Trim() + "&stoptimes=" + txtStopDate.Text.Trim()); } else if (datecnt == 1) { if(txtStartDate.Text.Trim()=="") { lo = client.GetTouchDownTotalBySql(wherestr, DateTime.MinValue, DateTime.Parse(txtStopDate.Text)); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=1&wherestr=" + wherestr + "&starttimes=" + txtStartDate.Text.Trim() + "&stoptimes=" + DateTime.MaxValue.ToShortDateString()); } else { lo = client.GetTouchDownTotalBySql(wherestr, DateTime.Parse(txtStartDate.Text), DateTime.MaxValue); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=1&wherestr="+wherestr+"&starttimes=" + txtStartDate.Text.Trim() + "&stoptimes=" + DateTime.MaxValue.ToShortDateString()); } } else { lo = client.GetTouchDownTotalBySql(wherestr, DateTime.MinValue, DateTime.MaxValue); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=1&wherestr="+wherestr +"&starttimes=" + DateTime.MinValue.ToShortDateString() + "&stoptimes=" + DateTime.MaxValue.ToShortDateString()); } this.BusyIndicator1.IsBusy = true; lo.Completed += (s, a) => { this.BusyIndicator1.IsBusy = false ; this.dataGrid1.ItemsSource = lo.Value; if(IsShowChart) (this.chart1.Series[0] as ColumnSeries).ItemsSource = lo.Value; }; HtmlWindow html = HtmlPage.Window; if (chkDownload.IsChecked == true) { // MessageBox.Show(uri.ToString()); html.Navigate(uri); } // WebClient webclient = new WebClient(); // webclient.OpenReadAsync(uri); // Uri uri = App.Current.Host.Source.MakeRelativeUri("../../DownloadForm.aspx"); // webclient.OpenReadAsync(new Uri().); // var exp = PredicateBuilder.True<tblVerifyNote>().And<tblVerifyNote>(n=>n.StartTimes>=new DateTime(2013,4,16)); // exp = exp.And<tblVerifyNote>(n => n.StartTimes >= new DateTime(2013, 4, 16) && n.StartTimes <= new DateTime(2013, 4, 16)); //EntityQuery<slAmidaConsole.Web.> q // = client.GetTblVerifyNoteBySqlQuery("").Take(3600); // client.GetTblVerifyNoteQuery().Where<tblVerifyNote>(n=>n.PCID.StartsWith("AE385")); // LoadOperation<slAmidaConsole.Web.tblVerifyNote> lo // = client.Load<slAmidaConsole.Web.tblVerifyNote>(q); //// EntityQuery<tblVerifyNote> lo1 = client.GetTblVerifyNoteBySqlQuery("it.PCID like 'AE385%'"); // lo.Completed += (s, a) => // { // if (lo.HasError) // { // MessageBox.Show(lo.Error.Message); // return; // } // this.dataGrid1.ItemsSource = lo.Entities; // }; }
private void button1_Click(object sender, RoutedEventArgs e) { // string wherestr = ""; slAmidaConsole.Web.EQ_DomainContext client = new EQ_DomainContext(); if (this.txtWaferMask.Text.Trim() == "") { MessageBox.Show("WaferMask must not be empty!"); return; } int datecnt = 0; if (txtStartDate.Text.Trim() != "" && txtStopDate.Text.Trim() != "") { DateTime res; if (!DateTime.TryParse(txtStartDate.Text.Trim(), out res)) { MessageBox.Show("Start Date format error!"); return; } if (!DateTime.TryParse(this.txtStopDate.Text.Trim(), out res)) { MessageBox.Show("End Date format error!"); return; } datecnt = 2; } else if (txtStartDate.Text.Trim() != "" && txtStopDate.Text.Trim() == "") { DateTime res; if (!DateTime.TryParse(txtStartDate.Text.Trim(), out res)) { MessageBox.Show("Start Date format error!"); return; } datecnt = 1; } Uri uri; InvokeOperation<slAmidaConsole.Web.RptSchema.rptYieldVSRCPSchema[]> lo = null; if (datecnt == 2) { lo = client.GetYieldVSRCP(txtWaferMask.Text.Trim(),txtRCP.Text.Trim(), DateTime.Parse(txtStartDate.Text), DateTime.Parse(txtStopDate.Text)); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=6&maskid=" + txtWaferMask.Text.Trim() + "&starttimes=" + txtStartDate.Text.Trim() + "&stoptimes=" + txtStopDate.Text.Trim() + "&rcp=" + txtRCP.Text.Trim()); } else if (datecnt == 1) { lo = client.GetYieldVSRCP(txtWaferMask.Text.Trim(), txtRCP.Text, DateTime.Parse(txtStartDate.Text), DateTime.MaxValue); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=6&maskid=" + txtWaferMask.Text + "&starttimes=" + txtStartDate.Text.Trim() + "&stoptimes=" + DateTime.MaxValue.ToShortDateString() + "&rcp=" + txtRCP.Text.Trim()); } else { lo = client.GetYieldVSRCP(txtWaferMask.Text.Trim(), txtRCP.Text, new DateTime(1900, 1, 1), DateTime.Now.Date); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=6&maskid=" + txtWaferMask.Text.Trim() + "&starttimes=" + new DateTime(1900, 1, 1).ToShortDateString() + "&stoptimes=" + DateTime.MaxValue.ToShortDateString() + "&rcp=" + txtRCP.Text.Trim()); } this.BusyIndicator1.IsBusy = true; lo.Completed += (s, a) => { this.BusyIndicator1.IsBusy = false; this.dataGrid1.ItemsSource = lo.Value; if (IsShowChart) { (this.chart1.Series[0] as LineSeries).ItemsSource = lo.Value; (this.chart1.Series[1] as ColumnSeries).ItemsSource = lo.Value; (this.chart1.Series[2] as LineSeries).ItemsSource = lo.Value; } }; HtmlWindow html = HtmlPage.Window; if (chkDownload.IsChecked == true) { // MessageBox.Show(uri.ToString()); html.Navigate(uri); } }
private void button1_Click(object sender, RoutedEventArgs e) { string wherestr = ""; slAmidaConsole.Web.EQ_DomainContext client = new EQ_DomainContext(); //var q = from n in client.GetTblVerifyNoteQuery() where n.StartTimes == new DateTime(2013, 1, 1) select n; ; //client.Load(q); if (txtOperator.Text.Trim() != "") wherestr += " it.operator like '" + this.txtOperator.Text + "%' and"; //if (txtPCShape.Text.Trim() != "") //{ // int res; // if (!int.TryParse(txtPCShape.Text, out res)) // { // MessageBox.Show("ProbeShape must be integer!"); // return; // } // wherestr += " it.ProbeShape=" + txtPCShape.Text.Trim() + " and"; //} int datecnt = 0; if (txtStartDate.Text.Trim() != "" && txtStopDate.Text.Trim() != "") { DateTime res; if (!DateTime.TryParse(txtStartDate.Text.Trim(), out res)) { MessageBox.Show("Start Date format error!"); return; } if (!DateTime.TryParse(this.txtStopDate.Text.Trim(), out res)) { MessageBox.Show("End Date format error!"); return; } datecnt = 2; wherestr += string.Format(" it.Start_Time >= @p0 and it.Start_Time <@p1 and it.stop_time >=@p0 and it.stop_time <@p1 and"); } else if (txtStartDate.Text.Trim() != "" && txtStopDate.Text.Trim() == "") { DateTime res; if (!DateTime.TryParse(txtStartDate.Text.Trim(), out res)) { MessageBox.Show("Start Date format error!"); return; } datecnt = 1; wherestr += string.Format(" it.Start_Time >= @p0 and"); } wherestr = wherestr.TrimEnd(new char[] { 'a', 'n', 'd' }); Uri uri; InvokeOperation<slAmidaConsole.Web.RptSchema.rptPerformanceSchema[]> lo = null; if (datecnt == 2) { lo = client.GetPerformanceTotalBySql(wherestr, DateTime.Parse(txtStartDate.Text), DateTime.Parse(txtStopDate.Text)); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=2&wherestr=" + wherestr + "&starttimes=" + txtStartDate.Text.Trim() + "&stoptimes=" + txtStopDate.Text.Trim()); } else if (datecnt == 1) { lo = client.GetPerformanceTotalBySql(wherestr, DateTime.Parse(txtStartDate.Text), DateTime.MaxValue); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=2&wherestr=" + wherestr + "&starttimes=" + txtStartDate.Text.Trim() + "&stoptimes=" + DateTime.MaxValue.ToShortDateString()); } else { lo = client.GetPerformanceTotalBySql(wherestr, DateTime.MinValue, DateTime.MaxValue); uri = new Uri(App.Current.Host.Source + "/../../DownLoadForm.aspx?rptid=2&wherestr=" + wherestr + "&starttimes=" + DateTime.MinValue.ToShortDateString() + "&stoptimes=" + DateTime.MaxValue.ToShortDateString()); } this.BusyIndicator1.IsBusy = true; lo.Completed += (s, a) => { if (lo.Error != null) { MessageBox.Show(lo.Error.Message); return; } this.BusyIndicator1.IsBusy = false; this.dataGrid1.ItemsSource = lo.Value; if (IsShowChart) (this.chart1.Series[0] as ColumnSeries).ItemsSource = lo.Value; }; HtmlWindow html = HtmlPage.Window; if (chkDownload.IsChecked == true) html.Navigate(uri); }