谢谢版主的耐心解答及电话指导!
我的获取数据库数据并生成XML文件的关键代码如下(附件有生成的XML文件):
Spread_RecdCertif.Open(p_certif.GetRecdTempFile(b_templet.tpId, true));
public string GetRecdTempFile(int pTpId, bool Delete)
{
string RecdPath = AppEnvironment.Config.CertifTemplatePath + pTpId.ToString() + ".xml";
if (File.Exists(RecdPath))
{
if (Delete == true)
System.IO.File.Delete(RecdPath);
else
return RecdPath;
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = AppEnvironment.conDatabase;
cmd.CommandText = "SELECT tpContent FROM b_templet where tpId=" + pTpId.ToString();
cmd.CommandType = CommandType.Text;
try
{
if (AppEnvironment.conDatabase.State == ConnectionState.Closed)
{
AppEnvironment.conDatabase.Open();
}
object obj = cmd.ExecuteScalar();
byte[] bin = (byte[])obj;
using (FileStream fs = new FileStream(RecdPath, FileMode.Create, FileAccess.Write))
{
fs.Write(bin, 0, bin.Length);
fs.Dispose();
fs.Close();
cmd.Connection.Close();
return RecdPath;
}
}
catch (Exception err)
{
MessageBox.Show("获取到的模板文件有错误,请检查编号为:" + pTpId + "的模板文件!" + err.Message);
return "";
}
}
|
|