/// <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)); } }