省厅报件7.0 读取mdb 生成xml 文件

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{

try
{
var address = @"C:\Users\Administrator\Downloads\JSYD (12).mdb";
String str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + address + "'";
var con = new OleDbConnection(str);
con.Open();
OleDbCommand cmd = con.CreateCommand();

//获得数据

OleDbDataAdapter dagroup = new OleDbDataAdapter("select * from T_ZD_TYPE ", con);
DataSet dsgroup = new DataSet();
dagroup.Fill(dsgroup, "ddgroup");
var dt = dsgroup.Tables[0];
var str1 = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
var type = dt.Rows[i]["TYPE"];
var mc = dt.Rows[i]["MC"];
var dm = dt.Rows[i]["DM"];
var typeBZ = dt.Rows[i]["TYPEBZ"];
str1 += string.Format("<dict name ='' key = '{0}' value = '{1}' type ='{2}' desc = '{3}' />\r\n", dm, mc, type, typeBZ);
}
WriteLogFile(str1);
con.Close();
con.Dispose();

}

catch (Exception ex)
{
//con.Close();
//con.Dispose();
throw ex;
}

}

/**/
/// <summary>
/// 写入日志文件
/// </summary>
/// <param name="input"></param>
public static void WriteLogFile(string input)
{
/**/
///指定日志文件的目录
string fname = Directory.GetCurrentDirectory() + "\\LogFile.txt";
/**/
///定义文件信息对象

FileInfo finfo = new FileInfo(fname);

if (!finfo.Exists)
{
FileStream fs;
fs = File.Create(fname);
fs.Close();
finfo = new FileInfo(fname);
}

/**/
///判断文件是否存在以及是否大于2K
if (finfo.Length > 1024 * 1024 * 10)
{
/**/
///文件超过10MB则重命名
File.Move(Directory.GetCurrentDirectory() + "\\LogFile.txt", Directory.GetCurrentDirectory() + DateTime.Now.TimeOfDay + "\\LogFile.txt");
/**/
///删除该文件
//finfo.Delete();
}
//finfo.AppendText();
/**/
///创建只写文件流

using (FileStream fs = finfo.OpenWrite())
{
/**/
///根据上面创建的文件流创建写数据流
StreamWriter w = new StreamWriter(fs);

/**/
///设置写数据流的起始位置为文件流的末尾
w.BaseStream.Seek(0, SeekOrigin.End);

/**/
///写入“Log Entry : ”
w.Write("\n\rLog Entry : ");

/**/
///写入当前系统时间并换行
w.Write("{0} {1} \n\r", DateTime.Now.ToLongTimeString(),
DateTime.Now.ToLongDateString());

/**/
///写入日志内容并换行
w.Write(input + "\n\r");

/**/
///写入------------------------------------“并换行
w.Write("------------------------------------\n\r");

/**/
///清空缓冲区内容，并把缓冲区内容写入基础流
w.Flush();

/**/
///关闭写数据流
w.Close();
}

}
}
}

巴特西

省厅报件7.0 读取mdb 生成xml 文件

最新文章

热门文章