private void barAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
SysDataFiles sdf = new SysDataFiles();
sdf.FileDesc = "用于创建城市数据库的文件";
FrmSysDataFileAdd frm = new FrmSysDataFileAdd();
frm.file = sdf;
frm.Text = "添加数据文件";
if (frm.ShowDialog() == DialogResult.OK)
{
try
{
ServicesSys.BaseService.Create <SysDataFiles>(frm.file);
}
catch (Exception)
{
throw;
}
InitData();
}
}
private void barEdit_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.RowCount < 1)
{
return;
}
if (gridView1.FocusedRowHandle < 0)
{
return;
}
SysDataFiles ds = gridView1.GetRow(gridView1.FocusedRowHandle) as SysDataFiles;
FrmSysDataFileAdd frm = new FrmSysDataFileAdd();
frm.file = ds;
frm.Text = "编辑数据文件";
if (frm.ShowDialog() == DialogResult.OK)
{
ds = frm.file;
ServicesSys.BaseService.Update <SysDataFiles>(ds);
InitData();
}
}
//导出数据文件
private void barSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
SaveFileDialog frm = new SaveFileDialog();
frm.Filter = "sql文件(*.sql)|*.sql";
string filePath;
if (frm.ShowDialog() == DialogResult.OK)
{
filePath = frm.FileName;
SysDataFiles file = gridView1.GetRow(gridView1.FocusedRowHandle) as SysDataFiles;
try
{
getfile(file.Files, filePath);
MessageBox.Show("已成功导出数据文件！");
}
catch (Exception)
{
MessageBox.Show("导出数据文件失败！");
}
}
}
/// <summary>
/// 创建数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCreateData_Click(object sender, EventArgs e)
{
if (!CheckForm())
{
return;
}
string connstr1 = " Connection Timeout=2; Pooling=False ;server=" + txtServerAddress.Text.Trim() + ";database=Master;uid=" + txtServerUser.Text.Trim() + ";pwd=" + txtServerPwd.Text.Trim() + ";";
if (!CheckConn(connstr1))
{
SQLDMOHelper.MesShow("无法连接到服务器，请确认服务器信息!");
return;
}
SQLDMOHelper smh = new SQLDMOHelper(txtServerAddress.Text.Trim(), txtServerUser.Text.Trim(), txtServerPwd.Text.Trim());
ArrayList datalist = smh.GetDbList();
if (datalist.Contains(txtServerName.Text.Trim()))
{
SQLDMOHelper.MesShow("该服务器中已在名为 " + txtServerName.Text.Trim() + " 的数据库");
return;
}
FrmDirTree frmd = new FrmDirTree();
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
svr.Connect(txtServerAddress.Text.Trim(), txtServerUser.Text.Trim(), txtServerPwd.Text.Trim());
frmd.svr = svr;
frmd.Text = txtServerAddress.Text.Trim() + "选择路径";
string FilePath = "";
if (frmd.ShowDialog() == DialogResult.OK)
{
FilePath = frmd.SelectPaht;
}
else
{
return;
}
WaitDialogForm frm = new WaitDialogForm("正在创建数据库，请稍后...");
frm.Show();
if (smh.CreateDB(txtServerName.Text.Trim(), FilePath))
{
//读取配置数据表.sql文件
IList <SysDataFiles> sdflist = ServicesSys.BaseService.GetList <SysDataFiles>("SelectSysDataFilesList", "");
if (sdflist.Count == 0)
{
frm.Hide();
SQLDMOHelper.MesShow("服务器中创建数据库文件不存在，请管管员先添加该文件！ ");
return;
}
SysDataFiles file = sdflist[0];
string path = Application.StartupPath + "\\BlogData";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string filepath = path + "\\" + file.FileName;
if (File.Exists(filepath))
{
File.Delete(filepath);
}
getfile(file.Files, filepath);
ArrayList alist = smh.GetSqlFile(filepath, txtServerName.Text.Trim());
if (File.Exists(filepath))
{
File.Delete(filepath);
}
string connstr2 = "Pooling=False ; server=" + txtServerAddress.Text.Trim() + ";database=" + txtServerName.Text.Trim() + ";uid=" + txtServerUser.Text.Trim() + ";pwd=" + txtServerPwd.Text.Trim() + ";";
SqlConnection conn = new SqlConnection(connstr2);
frm.Caption = "正在创建数据表，请稍后...";
if (smh.ExecuteCommand(alist, conn))
{
frm.Caption = "正在初始化数据，请稍后...";
//添加数据
if (CopyData(smh))
{
frm.Hide();
SQLDMOHelper.MesShow("数据库 " + txtServerName.Text.Trim() + " 已成功创建");
}
else
{
frm.Hide();
SQLDMOHelper.MesShow("数据库 " + txtServerName.Text.Trim() + " 已成功创建,初始化数据败");
}
}
else
{
frm.Hide();
SQLDMOHelper.MesShow("创建数据库表失败，请检查服务器中创建数据库文件是否损坏");
}
}
frm.Hide();
}
