public MainPage() { InitializeComponent(); Wb.Navigated += new EventHandler <System.Windows.Navigation.NavigationEventArgs>(Wb_Navigated); MouseLeftButtonDown += new MouseButtonEventHandler(MainPage_MouseLeftButtonDown); Wb.NavigateToString("<html><body><form action='http://google.com/'></form></body></html>"); }
public async Task <IActionResult> Edit(string id, [Bind("Seq,Id,Name,Kana,Ip,Status,Place,Back,StartDay,StartTime,EndDay,Ok,EndTime,Phone,Mail1,Mail2,Memo1,Memo2,Memo3,Memo4,Memo5,Message,UpdateDay,UpdateTime,FullName,Business,UpdateIp,InterPhone")] Wb wb) { if (id != wb.Seq) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(wb); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!WbExists(wb.Seq)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(wb)); }
public Map(string width, string height) { InitializeComponent(); string a = "https://www.google.com/maps/dir//" + width + "," + height + "/@" + width + "," + height + "z/data=!4m2!4m1!3e0"; Wb.Navigate(a); }
public int Run() { bool result = InitPara(); if (!result) { return(-999); } int failCount = 0; result = FailCount(ref failCount); if (!result) { Wb.Close(false, Type.Missing, Type.Missing); Excel.Quit(); return(-998); } Wb.Close(false, Type.Missing, Type.Missing); Excel.Quit(); if (failCount < 0) { failCount = failCount * -1; } return(0); }
public WatinWebBrowserExample() { InitializeComponent(); DataContext = new MainWindowViewModel(); Wb.Navigate("http://google.com"); Wb.LoadCompleted += ((sender, args) => { if (_docEvent != null) { _docEvent.oncontextmenu -= x => { WbShowContextMenu(); return(false); }; } if (Wb.Document != null) { _docEvent = (HTMLDocumentEvents2_Event)Wb.Document; _docEvent.oncontextmenu += x => { WbShowContextMenu(); return(false); }; } }); }
public async Task <IActionResult> PutWb(string id, Wb wb) { if (id != wb.Seq) { return(BadRequest()); } _context.Entry(wb).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!WbExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public Worldboss(Device device, Routine routine, Wb config, Smartrune smartune) { _device = device; _routine = routine; _config = config; _smartune = smartune; _alreadyDid = 0; }
public void GoForward() { if (Wb.CanGoForward) { Wb.GoForward(); NavigatedFromBrowser = true; } }
public void GoBack() { if (Wb.CanGoBack) { Wb.GoBack(); NavigatedFromBrowser = true; } }
protected override void Action() { base.Action(); Wb.Activate(); Ws.Select(); if (Range != null && (!Range.Equals(""))) { App.Range[Range].Select(); } }
public async Task <IActionResult> Create([Bind("Seq,Id,Name,Kana,Ip,Status,Place,Back,StartDay,StartTime,EndDay,Ok,EndTime,Phone,Mail1,Mail2,Memo1,Memo2,Memo3,Memo4,Memo5,Message,UpdateDay,UpdateTime,FullName,Business,UpdateIp,InterPhone")] Wb wb) { if (ModelState.IsValid) { _context.Add(wb); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(wb)); }
public void SetAddressBar(string path) { //if (System.IO.Directory.Exists(path)) //{ //var uri = new Uri(path); //if (Wb.WebBrowser.Source != uri) //{ Wb.Navigate(new Uri(path)); //} //} }
protected override void Action() { base.Action(); if (File.Exists(newWbPath)) { throw new ActionException($"文件({newWbPath})已经存在"); } Directory.CreateDirectory(Path.GetDirectoryName(newWbPath)); Wb.SaveAs(newWbPath, GetXlFileFormatByWbPath(newWbPath)); }
private void MfVaultView_Loaded(object sender, RoutedEventArgs e) { _viewModel = DataContext as MfVaultViewModel; if (_viewModel != null) { _viewModel.BrowserView = this; if (_viewModel.SourcePath != null) { Wb.Navigate(new Uri(_viewModel.SourcePath)); } } }
protected override void Action() { Wb = AttachWorkbook(WbPath); if (Wb != null) { AttachOrOpenApp(); bool Visible = App.Visible; Wb.Close(false); App.Visible = Visible; } Wb = OpenWorkbook(WbPath, readOnly, pwd, delimiter, writePwd); }
protected override void Action() { if (WbPath.CheckNoVoid()) { Wb = AttachWorkbook(WbPath); if (Wb != null) { Wb.Close(isSave); } } else { base.Action(); Wb.Close(isSave); } }
public MainWindow() { InitializeComponent(); Wb.Navigate("http://google.com"); Wb.LoadCompleted += delegate { if (_docEvent != null) { _docEvent.oncontextmenu -= _docEvent_oncontextmenu; } if (Wb.Document != null) { _docEvent = (HTMLDocumentEvents2_Event)Wb.Document; _docEvent.oncontextmenu += _docEvent_oncontextmenu; } }; }
public void DrawFullCarcass() { Wb.Clear(); ////Z - buffer //int[,] Z = new int[Wb.PixelWidth, Wb.PixelHeight]; //for (int i = 0; i < Wb.PixelWidth; i++) //{ // for (int j = 0; j < Wb.PixelHeight; j++) // { // Z[i, j] = Int32.MinValue; // } //} Point[] buffer = new Point[(BetaDo - BetaOt)]; for (int alfa = AlfaOt; alfa < AlfaDo; alfa += resolution) { for (int beta = BetaOt; beta < BetaDo; beta += resolution * 2) { var res = MainModel.Axonometry(MainModel.Func(R, alfa * Math.PI / 180, beta * Math.PI / 180), Alfa * Math.PI / 180, Beta * Math.PI / 180); if (!double.IsNegativeInfinity(pointHorizontal.X)) { MainModel.Line(wb, (int)pointHorizontal.X, (int)pointHorizontal.Y, (int)res.Item1 + Wb.PixelWidth / 2, (int)res.Item2 + Wb.PixelHeight / 2, color);// ,ref Z, (int)res.Item3); if (alfa > 0) { MainModel.Line(wb, (int)buffer[beta].X, (int)buffer[beta].Y, (int)res.Item1 + Wb.PixelWidth / 2, (int)res.Item2 + Wb.PixelHeight / 2, color); } } buffer[beta] = new Point(res.Item1 + Wb.PixelWidth / 2, res.Item2 + Wb.PixelHeight / 2); if (alfa < AlfaDo - resolution) { pointHorizontal = new Point(res.Item1 + Wb.PixelWidth / 2, res.Item2 + Wb.PixelHeight / 2); } else { pointHorizontal.X = double.NegativeInfinity; } } } }
public void DrawHorizontalCarcass(Func <Tuple <double, double, double>, int, Tuple <double, double, double> > scaling, Func <Tuple <double, double, double>, int, int, int, Tuple <double, double, double> > moving, Func <Tuple <double, double, double>, int, Tuple <double, double, double> > rX, Func <Tuple <double, double, double>, int, Tuple <double, double, double> > rY, Func <Tuple <double, double, double>, int, Tuple <double, double, double> > rZ) { Wb.Clear(); ////Z - buffer //int[,] Z = new int[Wb.PixelWidth, Wb.PixelHeight]; //for (int i = 0; i < Wb.PixelWidth; i++) //{ // for (int j = 0; j < Wb.PixelHeight; j++) // { // Z[i, j] = Int32.MinValue; // } //} for (int alfa = AlfaOt; alfa < AlfaDo; alfa += resolution) { for (int beta = BetaOt; beta < BetaDo; beta += resolution * 2) { var res = MainModel.Axonometry(rZ(rY(rX(moving(scaling(MainModel.Func(R, alfa * Math.PI / 180, beta * Math.PI / 180), K), Dx, Dy, Dz), AffineAngleX), AffineAngleY), AffineAngleZ), Alfa * Math.PI / 180, Beta * Math.PI / 180); if (!double.IsNegativeInfinity(pointHorizontal.X)) { MainModel.Line(wb, (int)pointHorizontal.X, (int)pointHorizontal.Y, (int)res.Item1 + Wb.PixelWidth / 2, (int)res.Item2 + Wb.PixelHeight / 2, color);//,ref Z, (int)res.Item3); } if (alfa < AlfaDo - resolution) { pointHorizontal = new Point(res.Item1 + Wb.PixelWidth / 2, res.Item2 + Wb.PixelHeight / 2); } else { pointHorizontal.X = double.NegativeInfinity; } } } }
public async Task <ActionResult <Wb> > PostWb(Wb wb) { _context.Wb.Add(wb); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (WbExists(wb.Seq)) { return(Conflict()); } else { throw; } } return(CreatedAtAction("GetWb", new { id = wb.Seq }, wb)); }
private bool SaveReport() { Console.WriteLine("Save Report..."); try { bool allPass = IsAllPass(); string resultStr = allPass ? "(Pass)" : "(Fail)"; string savePathFile = ExcelFileDirectory + @"\" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + resultStr + ".xlsx"; Wb.SaveAs(savePathFile); Wb.Close(false, Type.Missing, Type.Missing); Excel.Quit(); MoveReportToPreFolder(savePathFile); } catch (Exception ex) { Console.WriteLine("儲存檔案出錯,檔案可能正在使用" + Environment.NewLine + ex.Message); return(false); } return(true); }
protected override void Action() { base.Action(); //运行宏 if (FunctionName.CheckNoVoid()) { Wb.Activate(); try { RunVBA(); } //沒有信任存取VAB專案物件模型 catch (System.Runtime.InteropServices.COMException come) { //插入VBA代码 if (VBACode.CheckNoVoid()) { try { VBE vbe = App.VBE; VBComponent vbComponent; vbComponent = Wb.VBProject.VBComponents.Add(vbext_ComponentType.vbext_ct_StdModule); vbComponent.CodeModule.AddFromString(VBACode); } catch (Exception e) { throw new ActionException("添加vb函數失敗\n" + e.ToString()); } RunVBA(); } else { throw come; } } } }
public void DrawPolygons() { Wb.Clear(); Point[] bufferUp = new Point[(BetaDo - BetaOt)]; Point[] bufferDown = new Point[(BetaDo - BetaOt)]; for (int alfa = AlfaOt; alfa < AlfaDo; alfa += resolution) { for (int beta = BetaOt; beta < BetaDo; beta += resolution) { var res = MainModel.Axonometry(MainModel.Func(R, alfa * Math.PI / 180, beta * Math.PI / 180), Alfa * Math.PI / 180, Beta * Math.PI / 180); bufferDown[beta] = new Point(res.Item1 + Wb.PixelWidth / 2, res.Item2 + Wb.PixelHeight / 2); if (alfa > 1 && beta > 0) { MainModel.Polygon(wb, bufferUp[beta - 1], bufferUp[beta], bufferDown[beta - 1], bufferDown[beta], color); } if (alfa > 0 && beta > 0) { bufferUp[beta - 1] = bufferDown[beta - 1]; } } } }
private void Xuat_kehoachsx(System.Data.DataTable dt, string filename)//Xuất phiếu { if (dt.Rows.Count == 0) { return; } Excel.Application App = null; Excel.Workbook Wb; Excel.Worksheet Ws; int isExcelOpen = 0; try { App = (Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); } catch (System.Runtime.InteropServices.COMException) { App = new Excel.Application(); isExcelOpen = 1; } //oXL.Visible = true; Wb = (Excel.Workbook)(App.Workbooks.Add(Missing.Value)); Ws = (Excel.Worksheet)Wb.ActiveSheet; try { Ws = (Excel.Worksheet)App.Worksheets.Add(); // Xử lý tiêu đề cột int rowCount = dt.Rows.Count; int colCount = dt.Columns.Count; int c = 0; int r = 0; Excel.Range HeaderRow = Ws.get_Range("A1"); foreach (System.Data.DataColumn dc in dt.Columns) { HeaderRow.get_Offset(0, r).Value2 = dc.ColumnName; r++; } HeaderRow.EntireRow.Font.Bold = true; HeaderRow.EntireRow.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; // Xử lý data-> mảng 2 chiều object[,] rowData = new object[rowCount, colCount]; foreach (System.Data.DataRow row in dt.Rows) { for (int col = 0; col < colCount; col++) { if (IsNumeric(row[col].GetType().ToString())) { rowData[c, col] = System.Convert.ToDouble(row[col].ToString()); } else { rowData[c, col] = row[col].ToString(); } } c++; } // Paste mảng vào excel Ws.get_Range("A2").get_Resize(c, colCount).Value2 = rowData; Ws.get_Range("A1").get_Resize(1, colCount).EntireColumn.AutoFit(); // Lưu file string ExcelPath = AppDomain.CurrentDomain.BaseDirectory + string.Format("{0}.xlsx", filename); if (System.IO.File.Exists(ExcelPath)) { System.IO.File.Delete(ExcelPath); } Wb.SaveAs(ExcelPath, AccessMode: Excel.XlSaveAsAccessMode.xlShared); Wb.Close(); if (isExcelOpen == 1) { App.Quit(); } dt.Dispose(); } catch (Exception ex) { throw ex; } // Dọn rác System.Runtime.InteropServices.Marshal.ReleaseComObject(Ws); System.Runtime.InteropServices.Marshal.ReleaseComObject(Wb); System.Runtime.InteropServices.Marshal.ReleaseComObject(App); }
public static void DataTableToExcel(System.Data.DataTable dt, string filename) { string ExcelPathx = AppDomain.CurrentDomain.BaseDirectory + "\\FILE TRIEN KHAI.xlsm"; if (dt.Rows.Count == 0) { return; } Excel.Application App = null; Excel.Workbook Wb; Excel.Worksheet Ws; int isExcelOpen = 0; try { App = (Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); } catch (System.Runtime.InteropServices.COMException) { App = new Excel.Application(); isExcelOpen = 1; } //catch(Exception){} //finally //{ // App = new Excel.Application(); // isExcelOpen = 1; //} //oXL.Visible = true; Wb = (Excel.Workbook)(App.Workbooks.Open(ExcelPathx, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value)); //Wb = (Excel.Workbook)(App.Workbooks.Add(Missing.Value)); Ws = (Excel.Worksheet)Wb.Worksheets["Sheet"]; //Ws = (Excel.Worksheet)Wb.ActiveSheet; try { //Ws = (Excel.Worksheet)App.Worksheets.Add(); // Xử lý tiêu đề cột int rowCount = dt.Rows.Count; int colCount = dt.Columns.Count; int c = 0; //int r = 0; //Excel.Range HeaderRow = Ws.get_Range("A1"); //foreach (System.Data.DataColumn dc in dt.Columns) //{ // HeaderRow.get_Offset(0, r).Value2 = dc.ColumnName; // r++; //} //HeaderRow.EntireRow.Font.Bold = true; //HeaderRow.EntireRow.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; // Xử lý data-> mảng 2 chiều object[,] rowData = new object[rowCount, colCount]; foreach (System.Data.DataRow row in dt.Rows) { for (int col = 0; col < colCount; col++) { if (IsNumeric(row[col].GetType().ToString())) { rowData[c, col] = System.Convert.ToDouble(row[col].ToString()); } else { rowData[c, col] = row[col].ToString(); } } c++; } //xóa mảng trước khi pass //Ws.get_Range("A2:AZ600").get_Resize(rowCount, colCount).Value2 = rowData; Xóa mảng trùng với mảng copy lên excel Ws.get_Range("A2:AZ600").Cells.ClearContents(); // Paste mảng vào excel Ws.get_Range("A2").get_Resize(rowCount, colCount).Value2 = rowData; //Ws.get_Range("A1").get_Resize(1, colCount).EntireColumn.AutoFit(); // Giãn cột // Lưu file string ExcelPath = AppDomain.CurrentDomain.BaseDirectory + string.Format("{0}.xlsm", "FILE TRIEN KHAI"); if (System.IO.File.Exists(ExcelPath)) { System.IO.File.Delete(ExcelPath); } Wb.SaveAs(ExcelPath, AccessMode: Excel.XlSaveAsAccessMode.xlShared); Wb.Close(); //App.Quit(); if (isExcelOpen == 1) { App.Quit(); } dt.Dispose(); } catch { //throw ex; } // Dọn rác System.Runtime.InteropServices.Marshal.ReleaseComObject(Ws); System.Runtime.InteropServices.Marshal.ReleaseComObject(Wb); System.Runtime.InteropServices.Marshal.ReleaseComObject(App); System.Threading.Thread.Sleep(400); }
void Wb_Navigated(object sender, System.Windows.Navigation.NavigationEventArgs e) { Wb.InvokeScript("eval", "document.forms[0].submit();"); // Throws 80020101 }
private void buttonSaveExcel_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel.Application App; Microsoft.Office.Interop.Excel._Workbook Wb; Microsoft.Office.Interop.Excel._Worksheet oS; Microsoft.Office.Interop.Excel.Range oRan; object misvalue = System.Reflection.Missing.Value; int count; string count_str; try { count = save_time_str.Count(); count_str = count.ToString(); count_str = "A" + count_str; List <string> output = Clear(save_time_str); List <int> int_time_list = new List <int>(); List <string> output_temp = new List <string>(); int x = 0; foreach (string el in output) { Int32.TryParse(el, out x); int_time_list.Add(x); } int temp_val = int_time_list[5]; for (int j = 5; j < 17; j++) { if (int_time_list[j] > temp_val) { temp_val = int_time_list[j]; } } //eliminacja ujemnych i błędnych wartosci for (int i = 1; i < int_time_list.Count; i++) { if (int_time_list[i] < 0) { int_time_list.RemoveAt(i); int_time_list.RemoveAt(i - 1); } if (int_time_list[i] > 10 * temp_val) { int_time_list.RemoveAt(i); int_time_list.RemoveAt(i - 1); } } int_time_list.RemoveAt(int_time_list.Count - 1); foreach (int el in int_time_list) { output_temp.Add(el.ToString()); } string[,] output2 = new string[count, 1]; int it = 0; foreach (string el in output_temp) { output2[it, 0] = el; it++; } App = new Microsoft.Office.Interop.Excel.Application(); App.Visible = true; Wb = (Microsoft.Office.Interop.Excel._Workbook)(App.Workbooks.Add("")); oS = (Microsoft.Office.Interop.Excel._Worksheet)Wb.ActiveSheet; oS.Cells[1, 1] = "times"; oS.get_Range("A1", "B1").Font.Bold = true; oS.get_Range("A1", "B1").VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter; oS.get_Range("A2", count_str).Value2 = output2; oRan = oS.get_Range("A1", "B1"); oRan.EntireColumn.AutoFit(); App.Visible = false; App.UserControl = false; Wb.SaveAs("test505.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); textBox3.Visible = true; textBox3.Text = "saved in documents folder"; Wb.Close(); } catch (UnauthorizedAccessException) { } }
/// <summary> /// 播放线程执行方法 /// </summary> private unsafe void DeCoding() { try { Console.WriteLine("DeCoding run..."); //Bitmap oldBmp = null; // 更新图片显示 tstRtmp.ShowBitmap show = (width, height, stride, data) => { // // this.Invoke(new MethodInvoker(() => // // { // // this.pic.Image = bmp; // // if (oldBmp != null) // // { // // oldBmp.Dispose(); // // } // // oldBmp = bmp; // // })); WriteableBitmap Wb = null; Int32Rect rec = Int32Rect.Empty; this.Dispatcher.Invoke(new Action(delegate { //this.LiveImg.Source = bmp; //Solution 1: Official Way //IntPtr ptr = bmp.GetHbitmap(); //BitmapSource Bs = System.Windows.Interop.Imaging.CreateBitmapSourceFromHBitmap( // ptr, IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions()); ////release resource //DeleteObject(ptr); //this.LiveImg.Source = Bs; //Solution 2: Memory Way //BitmapImage Bi = BitmapToBitmapImage(bmp); //LiveLU.Source = Bi; //Solution 3: WriteableBitmap //Low Frame Rate if (Wb == null) { Wb = new WriteableBitmap(width, height, 96, 96, System.Windows.Media.PixelFormats.Bgr24, null); rec = new Int32Rect(0, 0, width, height); } Wb.Lock(); Wb.AddDirtyRect(rec); Wb.WritePixels(rec, data, width * height * 4, stride); //Debug.WriteLine(frameNumber); Wb.Unlock(); this.LiveImg.Source = Wb; })); }; rtmp.Start(show, "rtmp://127.0.0.1/live"); } catch (Exception ex) { Console.WriteLine(ex); } finally { Console.WriteLine("DeCoding exit"); rtmp.Stop(); thPlayer = null; //this.Invoke(new MethodInvoker(() => //{ // btnStart.Text = "开始播放"; // btnStart.Enabled = true; //})); } }
private void MainPage_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { Wb.InvokeScript("eval", "document.forms[0].submit();"); // Works }
public Map() { InitializeComponent(); Wb.Navigate("https://www.google.com/maps/dir//53.8913847,27.5592104/@53.8908151,27.5572328,17.79z/data=!4m2!4m1!3e0"); }