/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = DataTableHelper.CreateTable("名称,常量值,说明");
var lst = (gridView1.DataSource as List <ConstantInfo>);
for (int i = 0; i < lst.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = lst[i].Name;
row[1] = lst[i].ConstantValue;
row[2] = lst[i].Remark;
dt.Rows.Add(row);
}
string saveFile = FileDialogHelper.SaveExcel("用户常量.xls", "C:\\");
if (!string.IsNullOrEmpty(saveFile))
{
MyXlsHelper.Export(dt, saveFile, "用户常量", 1, 1);
if (MessageDxUtil.ShowYesNoAndTips("保存成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = DataTableHelper.CreateTable("类型名,名称,Oracle,Mysql,DB2,SqlServer,Sqlite,Access");
var lst = (gridView1.DataSource as List <DefaultTypeInfo>);
for (int i = 0; i < lst.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = lst[i].Name;
row[1] = lst[i].ChineseName;
row[2] = lst[i].Oracle;
row[3] = lst[i].Mysql;
row[4] = lst[i].DB2;
row[5] = lst[i].SqlServer;
row[6] = lst[i].Sqlite;
row[7] = lst[i].Access;
dt.Rows.Add(row);
}
string saveFile = FileDialogHelper.SaveExcel("标准数据类型.xls", "C:\\");
if (!string.IsNullOrEmpty(saveFile))
{
MyXlsHelper.Export(dt, saveFile, "标准数据类型", 1, 1);
if (MessageDxUtil.ShowYesNoAndTips("保存成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = DataTableHelper.CreateTable("字段名,字段名称,字段类型,字段条目,字段条目说明,备注");
var lst = (gridView1.DataSource as List <StdFieldInfo>);
for (int i = 0; i < lst.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = lst[i].Name;
row[1] = lst[i].ChineseName;
row[2] = lst[i].DataType;
row[3] = lst[i].DictNo;
row[4] = lst[i].DictNameLst;
row[5] = lst[i].Remark;
dt.Rows.Add(row);
}
string saveFile = FileDialogHelper.SaveExcel("标准字段.xls", "C:\\");
if (!string.IsNullOrEmpty(saveFile))
{
MyXlsHelper.Export(dt, saveFile, "标准字段", 1, 1);
if (MessageDxUtil.ShowYesNoAndTips("保存成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = DataTableHelper.CreateTable("错误号,错误提示信息,错误级别,说明");
var lst = (gridView1.DataSource as List <ErrornoInfo>);
for (int i = 0; i < lst.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = lst[i].Name;
row[1] = lst[i].ChineseName;
row[2] = Convert.ToInt16(IntToErrInfo(lst[i].LogLevel));
row[3] = lst[i].Remark;
dt.Rows.Add(row);
}
string saveFile = FileDialogHelper.SaveExcel("标准错误号.xls", "C:\\");
if (!string.IsNullOrEmpty(saveFile))
{
MyXlsHelper.Export(dt, saveFile, "标准错误号", 1, 1);
if (MessageDxUtil.ShowYesNoAndTips("保存成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
private void btnToolGen_Click(object sender, EventArgs e)
{
DataTable dt = DataTableHelper.CreateTable("姓名,年龄|int,Email邮箱,描述");
for (int i = 0; i < 50; i++)
{
DataRow row = dt.NewRow();
row[0] = RandomChinese.GetRandomChinese(3);
row[1] = new Random(DateTime.Now.Millisecond).Next(20, 50);
row[2] = "*****@*****.**";
row[3] = RandomChinese.GetRandomChinese2(50);
dt.Rows.Add(row);
Thread.Sleep(10);
}
string saveFile = FileDialogHelper.SaveExcel("wuhuacong.xls", "C:\\");
if (!string.IsNullOrEmpty(saveFile))
{
MyXlsHelper.Export(dt, saveFile);
if (MessageUtil.ShowYesNoAndTips("保存成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (cmbDBlist.SelectedItem == null)
{
return;
}
string dbName = cmbDBlist.SelectedItem.ToString();
button1.Enabled = false;
if (radioButton1.Checked)
{
}
else if (radioButton2.Checked)
{
DataTable table = BLLFactory.Instance.idb.GetTablesColumnsList("", dbName);
MyXlsHelper.LeadOutToExcel(table);
}
else if (radioButton3.Checked)
{
SaveFileDialog save = new SaveFileDialog();
save.Title = "保存";
save.Filter = "HTML(*.htm)|*.htm|所有文件(*.*)|*.*";
save.RestoreDirectory = true;
if (save.ShowDialog() == DialogResult.OK)
{
HtmlTable(save.FileName, dbName);
MessageBox.Show("导出成功！");
}
}
button1.Enabled = true;
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImport_Click(object sender, EventArgs e)
{
string importFile = FileDialogHelper.OpenExcel(false);
if (!string.IsNullOrEmpty(importFile))
{
// 判断文件是否被占用
if (FileUtil.FileIsUsing(importFile))
{
MessageDxUtil.ShowWarning(string.Format("文件[{0}]被占用，请先关闭文件后再重试!", importFile));
return;
}
DataTable dt = MyXlsHelper.Import(importFile, "标准数据类型", 2, 1);
// 如果没有结果集就不在继续
if (dt == null)
{
return;
}
Int32 addRows = 0;
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
// 判断是否存在不存在则添加
if (!lstName.Contains(dt.Rows[i][0].ToString()))
{
var datatypeInfo = new DefaultTypeInfo();
datatypeInfo.Gid = System.Guid.NewGuid().ToString();
datatypeInfo.Name = dt.Rows[i][0].ToString();
datatypeInfo.ChineseName = dt.Rows[i][1].ToString();
datatypeInfo.Oracle = dt.Rows[i][2].ToString();
datatypeInfo.Mysql = dt.Rows[i][3].ToString();
datatypeInfo.DB2 = dt.Rows[i][4].ToString();
datatypeInfo.SqlServer = dt.Rows[i][5].ToString();
datatypeInfo.Sqlite = dt.Rows[i][6].ToString();
datatypeInfo.Access = dt.Rows[i][7].ToString();
datatypeInfo.CShort = dt.Rows[i][8].ToString();
xmlhelper.InsertElement("datatype", "item", "gid", datatypeInfo.Gid, string.Format(xmlModel, dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), dt.Rows[i][3].ToString(), dt.Rows[i][4].ToString(), dt.Rows[i][5].ToString(), dt.Rows[i][6].ToString(), dt.Rows[i][7].ToString(), dt.Rows[i][8].ToString()));
(gridView1.DataSource as List <DefaultTypeInfo>).Insert((gridView1.DataSource as List <DefaultTypeInfo>).Count - 1, datatypeInfo);
addRows++;
lstName.Add(dt.Rows[i][0].ToString());
}
}
xmlhelper.Save(false);
gridView1.RefreshData();
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = DataTableHelper.CreateTable("显示名称,图标,排序,功能ID,可见,Winform窗体类型,Web界面Url地址,Web界面的菜单图标,系统编号,创建人ID,创建时间,编辑人ID,编辑时间,已删除");
if (treelstMenu.Nodes.Count != Const.Num_Zero)
{
for (Int32 i = 0; i < treelstMenu.Nodes.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = "" + treelstMenu.Nodes[i].GetValue("Name");
row[1] = treelstMenu.Nodes[i].GetValue("Icon");
row[2] = treelstMenu.Nodes[i].GetValue("Seq");
row[3] = treelstMenu.Nodes[i].GetValue("AuthGi");
row[4] = Convert.ToBoolean(treelstMenu.Nodes[i].GetValue("IsVisable")) ? "是" : "否";
row[5] = treelstMenu.Nodes[i].GetValue("WinformClass");
row[6] = treelstMenu.Nodes[i].GetValue("Url");
row[7] = treelstMenu.Nodes[i].GetValue("WebIcon");
row[8] = treelstMenu.Nodes[i].GetValue("SystemtypeId");
row[9] = treelstMenu.Nodes[i].GetValue("CreatorId");
row[10] = treelstMenu.Nodes[i].GetValue("CreateTime");
row[11] = treelstMenu.Nodes[i].GetValue("EditorId");
row[12] = treelstMenu.Nodes[i].GetValue("LastUpdateTime");
row[13] = Convert.ToBoolean(treelstMenu.Nodes[i].GetValue("IsDelete")) ? "是" : "否";
dt.Rows.Add(row);
//Console.WriteLine("" + treelstMenu.Nodes[i].GetValue("Name"));
if (treelstMenu.Nodes[i].HasChildren)
{
ErgodicNode(treelstMenu.Nodes[i], "﹂", dt);
}
}
}
string saveFile = FileDialogHelper.SaveExcel("系统菜单.xls", "C:\\");
if (!string.IsNullOrEmpty(saveFile))
{
MyXlsHelper.Export(dt, saveFile, "系统菜单", 1, 1);
if (MessageDxUtil.ShowYesNoAndTips("保存成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImport_Click(object sender, EventArgs e)
{
string importFile = FileDialogHelper.OpenExcel(false);
if (!string.IsNullOrEmpty(importFile))
{
// 判断文件是否被占用
if (FileUtil.FileIsUsing(importFile))
{
MessageDxUtil.ShowWarning(string.Format("文件[{0}]被占用，请先关闭文件后再重试!", importFile));
return;
}
DataTable dt = MyXlsHelper.Import(importFile, "标准错误号", 2, 1);
// 如果没有结果集就不在继续
if (dt == null)
{
return;
}
Int32 addRows = 0;
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
// 判断是否存在不存在则添加
if (!lstName.Contains(dt.Rows[i][0].ToString()))
{
var errornoInfo = new ErrornoInfo();
errornoInfo.Gid = System.Guid.NewGuid().ToString();
errornoInfo.Name = dt.Rows[i][0].ToString();
errornoInfo.ChineseName = dt.Rows[i][1].ToString();
errornoInfo.LogLevel = Convert.ToInt16(ErrInfoToInt(dt.Rows[i][2].ToString()));
errornoInfo.Remark = dt.Rows[i][3].ToString();
xmlhelper.InsertElement("datatype", "item", "gid", errornoInfo.Gid, string.Format(xmlModel, dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), dt.Rows[i][3].ToString()));
(gridView1.DataSource as List <ErrornoInfo>).Insert((gridView1.DataSource as List <ErrornoInfo>).Count - 1, errornoInfo);
addRows++;
lstName.Add(dt.Rows[i][0].ToString());
}
}
xmlhelper.Save(false);
gridView1.RefreshData();
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = DataTableHelper.CreateTable("显示名称,功能ID,系统编号,排序");
if (treelstFunction.Nodes.Count != Const.Num_Zero)
{
for (Int32 i = 0; i < treelstFunction.Nodes.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = "" + treelstFunction.Nodes[i].GetValue("Name");
row[1] = treelstFunction.Nodes[i].GetValue("FunctionGid");
row[2] = treelstFunction.Nodes[i].GetValue("SystemtypeId");
row[3] = treelstFunction.Nodes[i].GetValue("Seq");
dt.Rows.Add(row);
//Console.WriteLine("" + treelstMenu.Nodes[i].GetValue("Name"));
if (treelstFunction.Nodes[i].HasChildren)
{
ErgodicNode(treelstFunction.Nodes[i], "﹂", dt);
}
}
}
string saveFile = FileDialogHelper.SaveExcel("系统功能.xls", "C:\\");
if (!string.IsNullOrEmpty(saveFile))
{
MyXlsHelper.Export(dt, saveFile, "系统功能", 1, 1);
if (MessageDxUtil.ShowYesNoAndTips("保存成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImport_Click(object sender, EventArgs e)
{
if (treelstFunction.Nodes.Count != Const.Num_Zero)
{
if (MessageDxUtil.ShowYesNoAndTips("系统功能有原始数据，此次导入会清空原始数据，是否继续？") == System.Windows.Forms.DialogResult.No)
{
return;
}
}
string importFile = FileDialogHelper.OpenExcel(false);
if (!string.IsNullOrEmpty(importFile))
{
// 判断文件是否被占用
if (FileUtil.FileIsUsing(importFile))
{
MessageDxUtil.ShowWarning(string.Format("文件[{0}]被占用，请先关闭文件后再重试!", importFile));
return;
}
DataTable dt = MyXlsHelper.Import(importFile, "系统功能", 2, 1);
List <SysFunctionInfo> lstsysFunctionInfo = new List <SysFunctionInfo>();
// 如果没有结果集就不在继续
if (dt == null)
{
return;
}
Int32 addRows = 0;
List <String> pushFunction = new List <string>();
pushFunction.Add("-1");
// 先清除全部节点
Int32 rowCount = xmlhelper.Read("datatype").Count;
for (Int32 i = 0; i < rowCount; i++)
{
xmlhelper.DeleteByPathNode("datatype/item");
xmlhelper.Save(false);
}
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
var sysFunctionInfo = new SysFunctionInfo();
sysFunctionInfo.Gid = Guid.NewGuid().ToString();
sysFunctionInfo.Pgid = pushFunction.Last <string>();
sysFunctionInfo.Name = dt.Rows[i][0].ToString().TrimStart('﹂');
sysFunctionInfo.FunctionGid = dt.Rows[i][1].ToString();
sysFunctionInfo.SystemtypeId = dt.Rows[i][2].ToString();
sysFunctionInfo.Seq = dt.Rows[i][3].ToString();
sysFunctionInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
if ((i + 1) < dt.Rows.Count && dt.Rows[i][0].ToString().LastIndexOf("﹂") < dt.Rows[i + 1][0].ToString().LastIndexOf("﹂"))
{
pushFunction.Add(sysFunctionInfo.Gid);
}
// 返回到了某个父节点
if ((i + 1) < dt.Rows.Count && dt.Rows[i][0].ToString().LastIndexOf("﹂") > dt.Rows[i + 1][0].ToString().LastIndexOf("﹂"))
{
// 需要多次弹出操作
for (Int32 j = 0; j < (dt.Rows[i][0].ToString().LastIndexOf("﹂") - dt.Rows[i + 1][0].ToString().LastIndexOf("﹂")); j++)
{
pushFunction.RemoveAt(pushFunction.Count - 1);
}
}
addRows++;
lstsysFunctionInfo.Add(sysFunctionInfo);
xmlhelper.InsertElement("datatype", "item", string.Format(xmlModel, sysFunctionInfo.Gid, sysFunctionInfo.Pgid, sysFunctionInfo.Name, sysFunctionInfo.FunctionGid, sysFunctionInfo.SystemtypeId, sysFunctionInfo.Seq));
xmlhelper.Save(false);
}
treelstFunction.DataSource = lstsysFunctionInfo;
treelstFunction.Refresh();
ClearValidate();
treelstFunction.ForceInitialize();
treelstFunction.BestFitColumns();
MessageDxUtil.ShowTips(string.Format("成功导入功能数据{0}条数据", addRows));
}
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImport_Click(object sender, EventArgs e)
{
if (treelstMenu.Nodes.Count != Const.Zero)
{
if (MessageDxUtil.ShowYesNoAndTips("系统菜单有原始数据，此次导入会清空原始数据，是否继续？") == System.Windows.Forms.DialogResult.No)
{
return;
}
}
string importFile = FileDialogHelper.OpenExcel(false);
if (!string.IsNullOrEmpty(importFile))
{
// 判断文件是否被占用
if (FileUtil.FileIsUsing(importFile))
{
MessageDxUtil.ShowWarning(string.Format("文件[{0}]被占用，请先关闭文件后再重试!", importFile));
return;
}
DataTable dt = MyXlsHelper.Import(importFile, "系统菜单", 2, 1);
List <SysMenuInfo> lstsysMenuInfo = new List <SysMenuInfo>();
// 如果没有结果集就不在继续
if (dt == null)
{
return;
}
Int32 addRows = 0;
List <String> pushMenu = new List <string>();
pushMenu.Add("-1");
// 先清除全部节点
Int32 rowCount = xmlhelper.Read("datatype").Count;
for (Int32 i = 0; i < rowCount; i++)
{
xmlhelper.DeleteByPathNode("datatype/item");
xmlhelper.Save(false);
}
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
var sysMenuInfo = new SysMenuInfo();
sysMenuInfo.ID = Guid.NewGuid().ToString();
sysMenuInfo.PID = pushMenu.Last <string>();
sysMenuInfo.Name = dt.Rows[i][0].ToString().TrimStart('﹂');
sysMenuInfo.Icon = dt.Rows[i][1].ToString();
sysMenuInfo.Seq = dt.Rows[i][2].ToString();
sysMenuInfo.FunctionId = dt.Rows[i][3].ToString();
sysMenuInfo.Visible = dt.Rows[i][4].ToString() == "是" ? true : false;
sysMenuInfo.WinformType = dt.Rows[i][5].ToString();
sysMenuInfo.Url = dt.Rows[i][6].ToString();
sysMenuInfo.WebIcon = dt.Rows[i][7].ToString();
sysMenuInfo.SystemType_ID = dt.Rows[i][8].ToString();
sysMenuInfo.Creator_ID = dt.Rows[i][9].ToString();
sysMenuInfo.CreateTime = Convert.ToDateTime(dt.Rows[i][10]);
sysMenuInfo.Editor_ID = dt.Rows[i][11].ToString();
sysMenuInfo.EditTime = Convert.ToDateTime(dt.Rows[i][12]);
sysMenuInfo.Is_Deleted = dt.Rows[i][13].ToString() == "是" ? true : false;
sysMenuInfo.lstInfo = new Dictionary <string, DevExpress.XtraEditors.DXErrorProvider.ErrorInfo>();
if ((i + 1) < dt.Rows.Count && dt.Rows[i][0].ToString().LastIndexOf("﹂") < dt.Rows[i + 1][0].ToString().LastIndexOf("﹂"))
{
pushMenu.Add(sysMenuInfo.ID);
}
// 返回到了某个父节点
if ((i + 1) < dt.Rows.Count && dt.Rows[i][0].ToString().LastIndexOf("﹂") > dt.Rows[i + 1][0].ToString().LastIndexOf("﹂"))
{
// 需要多次弹出操作
for (Int32 j = 0; j < (dt.Rows[i][0].ToString().LastIndexOf("﹂") - dt.Rows[i + 1][0].ToString().LastIndexOf("﹂")); j++)
{
pushMenu.RemoveAt(pushMenu.Count - 1);
}
}
addRows++;
lstsysMenuInfo.Add(sysMenuInfo);
xmlhelper.InsertElement("datatype", "item", string.Format(xmlModel, sysMenuInfo.ID, sysMenuInfo.PID, sysMenuInfo.Name, sysMenuInfo.Icon, sysMenuInfo.Seq, sysMenuInfo.FunctionId, sysMenuInfo.Visible == true ? Const.One.ToString() : Const.Zero.ToString(), sysMenuInfo.WinformType, sysMenuInfo.Url, sysMenuInfo.WebIcon, sysMenuInfo.SystemType_ID, sysMenuInfo.Creator_ID, sysMenuInfo.CreateTime, sysMenuInfo.Editor_ID, sysMenuInfo.EditTime, sysMenuInfo.Is_Deleted == true ? Const.One.ToString() : Const.Zero.ToString()));
xmlhelper.Save(false);
}
treelstMenu.DataSource = lstsysMenuInfo;
treelstMenu.Refresh();
ClearValidate();
treelstMenu.ForceInitialize();
treelstMenu.BestFitColumns();
MessageDxUtil.ShowTips(string.Format("成功导入菜单数据{0}条数据", addRows));
}
}
