public static bool Display(SQLViewModel viewModel) { SQLEditor editor = new SQLEditor(viewModel); editor.Owner = Application.Current.MainWindow; return(editor.ShowDialog() ?? false); }
/// <summary> /// 联合查询 分页 /// </summary> /// <param name="viewModel"></param> /// <returns></returns> public static PagerViewModel <T> GetPageList <T>(SQLViewModel viewModel) where T : class, new() { using (var conn = SingleHepler <ConnectionFactory> .Instance.CreateConnection()) { return(conn.QueryAsync <T>(viewModel.SQLStr, viewModel.Params).ContinueWith((task) => { var returnData = task.Result; var totalCount = 0; var totalResult = conn.ExecuteReaderAsync(viewModel.CounSQLStr, viewModel.PageCount).Result; if (totalResult.Read()) { totalCount = Convert.ToInt32(totalResult["TotalCount"]); } var pager = new PagerViewModel <T>() { TotalCount = totalCount }; if (null != returnData) { pager.ItemList = returnData.ToList <T>(); } return pager; }).Result); } }
public void EditValue(Property property, object designer) { SQLViewModel viewModel = new SQLViewModel((ExecuteSQLDesigner)designer); if (SQLEditor.Display(viewModel)) { property.Value = viewModel.SQL; } }
public ActionResult RunSQL(SQLViewModel mv) { DBConnection db = new DBConnection(); if (ModelState.IsValid) { DBContext.ExecuteScalar(mv.Command, db); } return(View(new SQLViewModel() { Command = mv.Command })); }
private async void Wanted_Clicked(object sender, EventArgs e) { bool successful = false; SQLViewModel sqlview = new SQLViewModel(); successful = sqlview.SaveWantedGames(SHGD.Id.ToString()); if (successful) { await DisplayAlert("Alert", "Successfuly Added", "OK"); } else { await DisplayAlert("Alert", "Adding was unsccessful", "OK"); } }
private SQLEditor(SQLViewModel viewModel) : this() { base.DataContext = viewModel; }
public async Task <ActionResult> Index() { SQLViewModel model = new SQLViewModel(); return(View(model)); }
public App(String filename) { InitializeComponent(); SQLViewModel.Inicializador(filename); MainPage = new NotesView(); }