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