public MainWindow()
{
if (File.Exists("Sql.json"))
{
SqlDataAccess sqlDataAccess = new SqlDataAccess();
if (sqlDataAccess.Connection() == false)
{
InitializeComponent();
SqlViewModel sqlViewModel = new SqlViewModel(this);
DataContext = sqlViewModel;
}
else
{
Welcome welcome = new Welcome();
welcome.Show();
this.Close();
}
}
else
{
InitializeComponent();
SqlViewModel sqlViewModel = new SqlViewModel(this);
DataContext = sqlViewModel;
}
}
public SqlViewModel DashBoard(SqlViewModel sqlView)
{
var conn = dataContext.Database.GetDbConnection().ConnectionString;
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sqlView.SqlCommand, connection);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataTable dt in ds.Tables)
{
foreach (DataColumn column in dt.Columns)
{
sqlView.ColumName.Add(column.ColumnName);
}
foreach (DataRow row in dt.Rows)
{
// получаем все ячейки строки
var cells = row.ItemArray;
sqlView.RowName.Add(cells);
}
}
connection.Close();
}
return(sqlView);
}
public static void ActualEntitiesView(this DbMigration migration, SqlViewModel queryModel)
{
var operartions = migration.Operations as IList <MigrationOperation>;
if (operartions != null)
{
operartions.Add(new ActualEntitiesViewMigrationOperation(queryModel));
}
}
protected void ActualView(MigrationActionType action, string tableName, string viewName, string[] properties, string[] keys, Func <SqlViewModel, SqlViewModel> sqlAction = null, bool isRegister = false, bool isSimple = false)
{
if (action == MigrationActionType.Up)
{
var viewModel = new SqlViewModel(viewName.GetViewName()).Init(tableName, properties, keys, isRegister, isSimple, true);
this.ActualEntitiesView(sqlAction != null ? sqlAction(viewModel) : viewModel);
}
else
{
this.DropView(tableName.GetViewName());
}
}
// GET: Member
public ActionResult Index(string param = null)
{
DataTable dt = new DataTable();
string constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["NorthwindConnectionString1"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = "SELECT [CustomerID],[CompanyName] FROM Customers";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
}
}
}
var result = new List <SqlViewModel>();
foreach (DataRow x in dt.Rows)
{
var item = new SqlViewModel();
item.CompanyName = x["CompanyName"].ToString();
item.CustomerID = x["CustomerID"].ToString();
result.Add(item);
}
return(View(result));
// var result = new MemberViewModel
// {
// Name = "機器人",
// Email = "*****@*****.**",
// Phone = "0912345678",
// Car = new List<string>
// {
// "toyota","benz","benzz"
// }
// };
// return View(result);
}
public IActionResult GetAdminDash(SqlViewModel select)
{
var result = adminRepository.DashBoard(select);
return(View(result));
}
public Ok(SqlViewModel sqlViewModel)
{
this.sqlViewModel = sqlViewModel;
}
public ActualEntitiesViewMigrationOperation(SqlViewModel queryModel)
: base(null)
{
_queryModel = queryModel;
}
