public void Install(SqlConfig config, User user) { Runtime.SqlConfig = config; DataOperator dop = new DataOperator(Runtime.SqlConfig); //创建数据库 string db_path = Runtime.SqlConfig.DataBasePath.Replace("~", AppDomain.CurrentDomain.BaseDirectory); if (!Installer.HasInstall && File.Exists(db_path)) File.Delete(db_path); dop.DataDriver.CreateDataBase(db_path, Runtime.SqlConfig.PassWord); //创建表:User dop.CreateTable<User>(); dop.Insert(user); //创建表:Article dop.CreateTable<Article>(); //创建表:Category dop.CreateTable<Category>(); //保存数据库配置 string sql_config_path = AppDomain.CurrentDomain.BaseDirectory + SystemCoreStrings.FILE_CORE_SQLCONFIG; Runtime.SqlConfig.Save(sql_config_path); //创建安装安全锁 File.Create(AppDomain.CurrentDomain.BaseDirectory + SystemCoreStrings.FILE_CORE_INSTALL_LOCK); }
private void btnCreate_Click(object sender, EventArgs e) { SqlConfig config = new SqlConfig(DataDriverType.Sqlite, this.txtDataPre.Text, "", this.txtDBPath.Text); DataOperator dop = new DataOperator(config); Compile.CSharpCodeCompiler compiler = new Compile.CSharpCodeCompiler(); foreach(var item in this.lbxModels.Items) { try { var assembly = compiler.Compile(File.ReadAllText(item.ToString())); foreach (var type in assembly.GetTypes()) { dop.CreateTable(type); } MessageBox.Show("操作成功!"); } catch(Exception ex) { MessageBox.Show(ex.Message); } } }
private void btnDataInit_Click(object sender, EventArgs e) { if (File.Exists(UccRuntime.SqlConfig.DataBasePath.Replace("~", AppDomain.CurrentDomain.BaseDirectory))) { for (int i = 0; i < 5; i++) { if (MessageBox.Show("数据库已经存在,确定删除重新建立?", "数据库已经存在,确定删除重新建立?,这是一个不可以恢复的操作,操作完成后以前的数据将会丢失!", MessageBoxButtons.YesNo) == DialogResult.No) return; } } File.Delete(UccRuntime.SqlConfig.DataBasePath.Replace("~", AppDomain.CurrentDomain.BaseDirectory)); DataOperator dop = new DataOperator(UccRuntime.SqlConfig); dop.CreateTable<User>(); dop.CreateTable<YiFu>(); dop.CreateTable<ShouYi>(); dop.CreateTable<MoneyHistory>(); }
private void btnCreate_Click(object sender, EventArgs e) { string path = UccRuntime.SqlConfig.DataBasePath.Replace("~", AppDomain.CurrentDomain.BaseDirectory); if (File.Exists(path)) File.Delete(path); DataOperator dop = new DataOperator(UccRuntime.SqlConfig); dop.CreateTable<User>(); dop.CreateTable<YiFu>(); dop.CreateTable<ShouYi>(); dop.CreateTable<MoneyHistory>(); dop.CreateTable<XiaCi>(); dop.CreateTable<YanSe>(); dop.CreateTable<PinPai>(); dop.CreateTable<YiFuPriceType>(); dop.CreateTable<ChongZhiType>(); dop.Commit(); //xiace var table= SimpleDataController.Get(AppDomain.CurrentDomain.BaseDirectory + "/data/clothes_error.txt"); for(int i=0;i<table.Rows.Count;i++) { XiaCi item = new XiaCi(); item.XiaCiID = dop.Count<XiaCi>().ToString(); item.XiaCiContent = table.Rows[i][1].ToString(); dop.Insert(item); dop.Commit(); } table = SimpleDataController.Get(AppDomain.CurrentDomain.BaseDirectory + "/data/clothes_color.txt"); for(int i=0;i<table.Rows.Count;i++) { YanSe item = new YanSe(); item.YanSeID = dop.Count<YanSe>().ToString(); item.YanSeName = table.Rows[i][1].ToString(); dop.Insert(item); dop.Commit(); } table = SimpleDataController.Get(AppDomain.CurrentDomain.BaseDirectory + "/data/clothes_pinpai.txt"); for(int i=0;i<table.Rows.Count;i++) { PinPai item = new PinPai(); item.PinPaiID = dop.Count<PinPai>().ToString(); item.PinPaiName = table.Rows[i][0].ToString(); dop.Insert(item); dop.Commit(); } table = SimpleDataController.Get(AppDomain.CurrentDomain.BaseDirectory + "/data/clothes.txt"); for (int i = 0; i < table.Rows.Count; i++) { YiFuPriceType item = new YiFuPriceType(); item.YiFuPriceID = dop.Count<YiFuPriceType>().ToString(); item.YiFuName = table.Rows[i][1].ToString(); item.DanWei = table.Rows[i][2].ToString(); item.Price = table.Rows[i][3].ToString(); dop.Insert(item); dop.Commit(); } table = SimpleDataController.Get(AppDomain.CurrentDomain.BaseDirectory + "/data/register_money.txt"); for (int i = 0; i < table.Rows.Count; i++) { ChongZhiType item = new ChongZhiType(); item.ChonZhiMoney = double.Parse(table.Rows[i][0].ToString()); item.ZengSongMoney = double.Parse(table.Rows[i][1].ToString()); dop.Insert(item); dop.Commit(); } dop.Commit(); MessageBox.Show("操作成功!"); }