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("操作成功！");
}
