private void btnImportFolder_Click(object sender, EventArgs e)
{
FolderBrowserDialog dlg = new FolderBrowserDialog();
if (dlg.ShowDialog() == DialogResult.OK)
{
if (MessageForm.ShowYesNo("您正在导入数据到数据库，如果有相同的主键，将会替换数据库数据，是否确认？"))
{
foreach (string fileName in System.IO.Directory.GetFiles(dlg.SelectedPath))
{
ADUtils.ImportFromXmlFile(fileName);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
//context.Response.Write("Done!");
string fileName = HttpContext.Current.Server.MapPath("UploadData\\") + context.Request.QueryString["fileName"];
Stream raw = context.Request.InputStream;
if (!string.IsNullOrEmpty(fileName) && raw.Length > 0)
{
byte[] b = new byte[raw.Length];
raw.Read(b, 0, b.Length);
using (FileStream fs = new FileStream(fileName, FileMode.Create))
{
fs.Write(b, 0, b.Length);
}
string tempDir = HttpContext.Current.Server.MapPath("UploadData\\Temp\\");
if (!System.IO.Directory.Exists(tempDir))
{
System.IO.Directory.CreateDirectory(tempDir);
}
foreach (string s in System.IO.Directory.GetFiles(tempDir))
{
System.IO.File.Delete(s);
}
Feng.Utils.CompressionHelper.UnzipToFolder(fileName, tempDir);
ADUtils.DisableFKConstraint();
foreach (string s in System.IO.Directory.GetFiles(tempDir))
{
ADUtils.ImportFromXmlFile(s);
System.IO.File.Delete(s);
}
ADUtils.EnableFKConstraint();
context.Response.ContentType = "text/plain";
context.Response.Write("Done!");
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error!");
}
}
private void btnImportYwsj_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.RestoreDirectory = true;
dlg.Filter = "Excel Xml(*.xml)|*.xml";
//saveFileDialog1.Title = "保存";
if (dlg.ShowDialog() == DialogResult.OK)
{
if (MessageBox.Show("您正在导入数据到数据库，如果有相同的主键，将会替换数据库数据，是否确认？", "确认", MessageBoxButtons.YesNo)
== DialogResult.Yes)
{
ADUtils.DisableFKConstraint();
ADUtils.ImportFromXmlFile(dlg.FileName);
ADUtils.EnableFKConstraint();
}
}
}
private void btnImport_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.RestoreDirectory = true;
dlg.Filter = "Excel Xml(*.xml)|*.xml";
dlg.Multiselect = true;
//saveFileDialog1.Title = "保存";
if (dlg.ShowDialog() == DialogResult.OK)
{
if (MessageForm.ShowYesNo("您正在导入数据到数据库，如果有相同的主键，将会替换数据库数据，是否确认？"))
{
foreach (string fileName in dlg.FileNames)
{
ADUtils.ImportFromXmlFile(fileName, true);
ADUtils.ImportFromXmlFile(fileName);
}
}
}
}
/// <summary>
/// 安装Module
/// </summary>
/// <param name="moduleName"></param>
public static void InstallModule(string moduleName)
{
CreateNecessaryDirectories(moduleName);
string dir = System.IO.Directory.GetCurrentDirectory() + "\\" + moduleName;
//// CheckModuleDependency
//IList<ModuleDependencyInfo> moduleDependencyInfos = ADInfoBll.Instance.GetInfos<ModuleDependencyInfo>(
// "from ModuleDependencyInfo where Module.Name = :moduleName", new Dictionary<string, object> { { "moduleName", moduleName } });
//foreach (ModuleDependencyInfo dependency in moduleDependencyInfos)
//{
// if (dependency.DependentModule
//}
//// No use now
////ModuleByClientInfo moduleByClientInfo = null;
////ModuleByOrgInfo moduleByOrgInfo = null;
IList <ModuleInfo> moduleInfos = ADInfoBll.Instance.GetInfos <ModuleInfo>("from Feng.ModuleInfo where Id = '" + moduleName + "'");
if (moduleInfos.Count == 0)
{
throw new ArgumentException("There is no module named " + moduleName);
}
CompressionHelper.DecompressToFolder(moduleInfos[0].ModuleData, System.IO.Directory.GetCurrentDirectory());
// ReferenceData
foreach (string file in System.IO.Directory.GetFiles(dir + "\\referencedata\\standard\\"))
{
ADUtils.ImportFromXmlFile(file);
}
// ApplicationDictionaryData
foreach (string file in System.IO.Directory.GetFiles(dir + "\\src-db\\database\\sourcedata\\"))
{
string s = System.IO.Path.GetFileNameWithoutExtension(file);
if (s.StartsWith("AD_Module"))
{
continue;
}
ADUtils.ImportFromXmlFile(file);
}
//// DbTable
//foreach (string file in System.IO.Directory.GetFiles(dir + "src-db\\database\\model\\tables\\"))
//{
//}
// DbView
foreach (string file in System.IO.Directory.GetFiles(dir + "\\src-db\\database\\model\\views\\"))
{
using (System.IO.StreamReader sr = new System.IO.StreamReader(file))
{
string script = sr.ReadToEnd();
DbHelper.Instance.ExecuteNonQuery(script);
}
}
// DbFunction
foreach (string file in System.IO.Directory.GetFiles(dir + "\\src-db\\database\\model\\functions\\"))
{
using (System.IO.StreamReader sr = new System.IO.StreamReader(file))
{
string script = sr.ReadToEnd();
DbHelper.Instance.ExecuteNonQuery(script);
}
}
// DbTrigger
foreach (string file in System.IO.Directory.GetFiles(dir + "\\src-db\\database\\model\\triggers\\"))
{
using (System.IO.StreamReader sr = new System.IO.StreamReader(file))
{
string script = sr.ReadToEnd();
DbHelper.Instance.ExecuteNonQuery(script);
}
}
// DbProcedure
foreach (string file in System.IO.Directory.GetFiles(dir + "\\src-db\\database\\model\\procedures\\"))
{
using (System.IO.StreamReader sr = new System.IO.StreamReader(file))
{
string script = sr.ReadToEnd();
DbHelper.Instance.ExecuteNonQuery(script);
}
}
//// SourceModel
//foreach (string file in System.IO.Directory.GetFiles(dir + "\\src\\model\\"))
//{
//}
//// SourceScript
//foreach (string file in System.IO.Directory.GetFiles(dir + "\\src\\script\\"))
//{
//}
//// SourceReport
//foreach (string file in System.IO.Directory.GetFiles(dir + "\\src\\report\\"))
//{
//}
}
