📄 form3.cs
字号:
liu.WriteElementString("SCR", reader.GetString(5));
liu.WriteEndElement();
}//endwhile
}//endtry
catch(Exception excep)
{
}
liu.WriteEndElement();
liu.WriteEndDocument();
liu.Flush();
liu.Close();
}
else
{
if(bm=="水库编码")
{
System.Xml.XmlTextWriter liu = new System.Xml.XmlTextWriter(@FileName,System.Text.Encoding.UTF8);
liu.Formatting=System.Xml.Formatting.Indented;
liu.WriteStartDocument();
liu.WriteStartElement("BMSK_GB");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from BMSK_GB";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("BMSK_GB");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("SKMC", reader.GetString(1));
liu.WriteElementString("SZS", reader.GetString(2));
liu.WriteElementString("SZX", reader.GetString(3));
liu.WriteEndElement();
}//endwhile
}//endtry
catch(Exception excep)
{
}
liu.WriteEndElement();
liu.WriteEndDocument();
liu.Flush();
liu.Close();
}//endif
else
{
if(bm=="坝面竖向位移-考证表")
{
System.Xml.XmlTextWriter liu = new System.Xml.XmlTextWriter(@FileName,System.Text.Encoding.UTF8);
liu.Formatting=System.Xml.Formatting.Indented;
liu.WriteStartDocument();
liu.WriteStartElement("BMSXWY_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from BMSXWY_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("BMSXWY_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("BH_BMSXKZ", reader.GetString(1));
liu.WriteElementString("XS_BMSXKZ", reader.GetString(2));
liu.WriteElementString("MSRQ_BMSXKZ", reader.GetString(3));
liu.WriteElementString("MSZH_BMSXKZ", reader.GetString(4));
liu.WriteElementString("MSZJ_BMSXKZ", reader.GetString(5));
liu.WriteElementString("JCQK_BMSXKZ", reader.GetString(6));
liu.WriteElementString("CDRQ_BMSXKZ", reader.GetString(7));
liu.WriteElementString("GC_BMSXKZ", reader.GetString(8));
liu.WriteElementString("BZ_BMSXKZ", reader.GetString(9));
liu.WriteElementString("SZDXS_BMSXKZ", reader.GetString(10));
liu.WriteElementString("SZDBH_BMSXKZ", reader.GetString(11));
liu.WriteElementString("SZDGC_BMSXKZ", reader.GetString(12));
liu.WriteElementString("SZDWZ_BMSXKZ", reader.GetString(13));
liu.WriteElementString("JCJL_BMSXKZ", reader.GetString(14));
liu.WriteElementString("ZG_BMSXKZ", reader.GetString(15));
liu.WriteElementString("JHZ_BMSXKZ", reader.GetString(16));
liu.WriteElementString("GCZ_BMSXKZ", reader.GetString(17));
liu.WriteElementString("MSZ_BMSXKZ", reader.GetString(18));
liu.WriteElementString("TBR_BMSXKZ", reader.GetString(19));
liu.WriteElementString("TBRQ_BMSXKZ", reader.GetString(20));
liu.WriteEndElement();
}//endwhile
}//endtry
catch(Exception excep)
{
}
liu.WriteEndElement();
liu.WriteEndDocument();
liu.Flush();
liu.Close();
}//endif
else
{
if(bm=="坝面水平位移-考证表")
{
System.Xml.XmlTextWriter liu = new System.Xml.XmlTextWriter(@FileName,System.Text.Encoding.UTF8);
liu.Formatting=System.Xml.Formatting.Indented;
liu.WriteStartDocument();
liu.WriteStartElement("BMSPWY_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from BMSPWY_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("BMSPWY_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("CDBH_ZXWYKZ", reader.GetString(1));
liu.WriteElementString("YQXH_ZXWYKZ", reader.GetString(2));
liu.WriteElementString("LC_ZXWYKZ", reader.GetString(3));
liu.WriteElementString("YQCS_ZXWYKZ", reader.GetString(4));
liu.WriteElementString("YQBH_ZXWYKZ", reader.GetString(5));
liu.WriteElementString("MSZH_ZXWYKZ", reader.GetString(6));
liu.WriteElementString("MSBZJ_ZXWYKZ", reader.GetString(7));
liu.WriteElementString("MSGC_ZXWYKZ", reader.GetString(8));
liu.WriteElementString("MSFX_ZXWYKZ", reader.GetString(9));
liu.WriteElementString("MSQCL_ZXWYKZ", reader.GetString(10));
liu.WriteElementString("CSPL_ZXWYKZ", reader.GetString(11));
liu.WriteElementString("CSWY_ZXWYKZ", reader.GetString(12));
liu.WriteElementString("BJJ_ZXWYKZ", reader.GetString(13));
liu.WriteElementString("JXCD_ZXWYKZ", reader.GetString(14));
liu.WriteElementString("MSSYT_ZXWYKZ", reader.GetString(15));
liu.WriteElementString("MSSM_ZXWYKZ", reader.GetString(16));
liu.WriteElementString("MSSQ_ZXWYKZ", reader.GetString(17));
liu.WriteElementString("MSQZ_ZXWYKZ", reader.GetString(18));
liu.WriteElementString("ZG_ZXWYKZ", reader.GetString(14));
liu.WriteElementString("JHZ_ZXWYKZ_ZXWYKZ", reader.GetString(15));
liu.WriteElementString("MSZ_ZXWYKZ", reader.GetString(16));
liu.WriteElementString("GCZ_ZXWYKZ", reader.GetString(17));
liu.WriteElementString("MSQZ_ZXWYKZ", reader.GetString(18));
liu.WriteEndElement();
}//endwhile
}//endtry
catch(Exception excep)
{
}
liu.WriteEndElement();
liu.WriteEndDocument();
liu.Flush();
liu.Close();
}//endif
else
{
if(bm=="测压管考证表")
{
System.Xml.XmlTextWriter liu = new System.Xml.XmlTextWriter(@FileName,System.Text.Encoding.UTF8);
liu.Formatting=System.Xml.Formatting.Indented;
liu.WriteStartDocument();
liu.WriteStartElement("CYG_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from CYG_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("CYG_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("CDBH_CYGKZ", reader.GetString(1));
liu.WriteElementString("MSZH_CYGKZ", reader.GetString(2));
liu.WriteElementString("MSQY_CYGKZ", reader.GetString(3));
liu.WriteElementString("MSBZJ_CYGKZ", reader.GetString(4));
liu.WriteElementString("GKGC_CYGKZ", reader.GetString(5));
liu.WriteElementString("GNJ_CYGKZ", reader.GetString(6));
liu.WriteElementString("GDGC_CYGKZ", reader.GetString(7));
liu.WriteElementString("GC_CYGKZ", reader.GetString(8));
liu.WriteElementString("AZFF_CYGKZ", reader.GetString(9));
liu.WriteElementString("GCAI_CYGKZ", reader.GetString(10));
liu.WriteElementString("JCSD_CYGKZ", reader.GetString(11));
liu.WriteElementString("TSJG_CYGKZ", reader.GetString(12));
liu.WriteElementString("TSDDGC_CYGKZ", reader.GetString(13));
liu.WriteElementString("FCDDGC_CYGKZ", reader.GetString(14));
liu.WriteElementString("MSRQ_CYGKZ", reader.GetString(15));
liu.WriteElementString("GKJCRQ_CYGKZ", reader.GetString(16));
liu.WriteElementString("GKJCGC_CYGKZ", reader.GetString(17));
liu.WriteElementString("ZG_CYGKZ", reader.GetString(18));
liu.WriteElementString("JHZ_CYGKZ", reader.GetString(19));
liu.WriteElementString("MSR_CYGKZ", reader.GetString(20));
liu.WriteElementString("TBR_CYGKZ", reader.GetString(21));
liu.WriteElementString("TBRQ_CYGKZ", reader.GetString(22));
liu.WriteElementString("MSSYT_CYGKZ", reader.GetString(23));
liu.WriteElementString("MSSM_CYGKZ", reader.GetString(24));
liu.WriteEndElement();
}//endwhile
}//endtry
catch(Exception excep)
{
}
liu.WriteEndElement();
liu.WriteEndDocument();
liu.Flush();
liu.Close();
}//endif
else
{
if(bm=="电磁式、干簧管式沉降仪测管理埋设考证表")
{
System.Xml.XmlTextWriter liu = new System.Xml.XmlTextWriter(@FileName,System.Text.Encoding.UTF8);
liu.Formatting=System.Xml.Formatting.Indented;
liu.WriteStartDocument();
liu.WriteStartElement("DGCJMX_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from DGCJMX_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("DGCJMX_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("CJHBH_DGCJMX", reader.GetString(1));
liu.WriteElementString("CJGBH_DGCJKZ", reader.GetString(2));
liu.WriteElementString("MSGC_DGCJMX", reader.GetString(3));
liu.WriteElementString("TCHD_DGCJMX", reader.GetString(4));
liu.WriteElementString("TTGC_DGCJMX", reader.GetString(5));
liu.WriteElementString("TTMD_DGCJMX", reader.GetString(6));
liu.WriteElementString("BZ_DGCJMX", reader.GetString(7));
liu.WriteEndElement();
}//endwhile
}//endtry
catch(Exception excep)
{
}
liu.WriteEndElement();
liu.WriteEndDocument();
liu.Flush();
liu.Close();
}//endif
else
{
if(bm=="电磁式、干簧管式沉降仪测管理考证——主表")
{
System.Xml.XmlTextWriter liu = new System.Xml.XmlTextWriter(@FileName,System.Text.Encoding.UTF8);
liu.Formatting=System.Xml.Formatting.Indented;
liu.WriteStartDocument();
liu.WriteStartElement("DGCJ_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -