📄 form3.cs
字号:
cmd="select * from DGCJ_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("DGCJ_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("CJGBH_DGCJKZ", reader.GetString(1));
liu.WriteElementString("KKGC_DGCJKZ", reader.GetString(2));
liu.WriteElementString("KDGC_DGCJKZ", reader.GetString(3));
liu.WriteElementString("YQXH_DGCJKZ", reader.GetString(4));
liu.WriteElementString("SCDW_DGCJKZ", reader.GetString(5));
liu.WriteElementString("LC_DGCJKZ", reader.GetString(6));
liu.WriteElementString("MSZH_DGCJKZ", reader.GetString(7));
liu.WriteElementString("MSBZJ_DGCJKZ", reader.GetString(8));
liu.WriteElementString("MSQYCL_DGCJKZ", reader.GetString(9));
liu.WriteElementString("YQCS_DGCJKZ", reader.GetString(10));
liu.WriteElementString("CJHS_DGCJKZ", reader.GetString(11));
liu.WriteElementString("MSFF_DGCJKZ", reader.GetString(12));
liu.WriteElementString("JGGS_DGCJKZ", reader.GetString(13));
liu.WriteElementString("GC_DGCJKZ", reader.GetString(14));
liu.WriteElementString("NJ_DGCJKZ", reader.GetString(15));
liu.WriteElementString("WJ_DGCJKZ", reader.GetString(16));
liu.WriteElementString("MSQK_DGCJKZ", reader.GetString(17));
liu.WriteElementString("MSQQ_DGCJKZ", reader.GetString(18));
liu.WriteElementString("MSQZ_DGCJKZ", reader.GetString(19));
liu.WriteElementString("MSZG_DGCJKZ", reader.GetString(20));
liu.WriteElementString("GCZ_DGCJKZ", reader.GetString(21));
liu.WriteElementString("JHZ_DGCJKZ", reader.GetString(22));
liu.WriteElementString("MSZ_DGCJKZ", reader.GetString(23));
liu.WriteElementString("TBR_DGCJKZ", reader.GetString(24));
liu.WriteElementString("TBRQ_DGCJKZ", reader.GetString(25));
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("DWWY_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from DWWY_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("DWWY_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("CDBH_DWWYKZ", reader.GetString(1));
liu.WriteElementString("YQXH_YZWYKZ", reader.GetString(2));
liu.WriteElementString("LC_DWWYKZ", reader.GetString(3));
liu.WriteElementString("YQBH_DWWYKZ", reader.GetString(4));
liu.WriteElementString("SCDW_DWWYKZ", reader.GetString(5));
liu.WriteElementString("YQC1_DWWYKZ", reader.GetString(6));
liu.WriteElementString("YQC2_DWWYKZ", reader.GetString(7));
liu.WriteElementString("MSZH_DWWYKZ", reader.GetString(8));
liu.WriteElementString("MSBZJ_DWWYKZ", reader.GetString(9));
liu.WriteElementString("MSGC_DWWYKZ", reader.GetString(10));
liu.WriteElementString("MSFX_DWWYKZ", reader.GetString(11));
liu.WriteElementString("MSQCL_DWWYKZ", reader.GetString(12));
liu.WriteElementString("BJJ_DWWYKZ", reader.GetString(13));
liu.WriteElementString("JXCD_DWWYKZ", reader.GetString(14));
liu.WriteElementString("JXGS_DWWYKZ", reader.GetString(15));
liu.WriteElementString("GZDY_DWWYKZ", reader.GetString(16));
liu.WriteElementString("SCDS_DWWYKZ", reader.GetString(17));
liu.WriteElementString("CSWY_DWWYKZ", reader.GetString(18));
liu.WriteElementString("MSSYT_DWWYKZ", reader.GetString(19));
liu.WriteElementString("MSSM_DWWYKZ", reader.GetString(20));
liu.WriteElementString("MSQQ_DWWYKZ", reader.GetString(21));
liu.WriteElementString("MSSQZ_DWWYKZ", reader.GetString(22));
liu.WriteElementString("ZG_DWWYKZ", reader.GetString(23));
liu.WriteElementString("JHZ_DWWYKZ", reader.GetString(24));
liu.WriteElementString("GCZ_DWWYKZ", reader.GetString(25));
liu.WriteElementString("MSZ_DWWYKZ", reader.GetString(26));
liu.WriteElementString("TBR_DWWYKZ", reader.GetString(27));
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("LSY_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from LSY_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("LSY_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("YH_LSYKZ", reader.GetString(1));
liu.WriteElementString("ASDD_LSYKZ", reader.GetString(2));
liu.WriteElementString("ZH_LSYKZ", reader.GetString(3));
liu.WriteElementString("BZJ_LSYKZ", reader.GetString(4));
liu.WriteElementString("YX_LSYKZ", reader.GetString(5));
liu.WriteElementString("YKGC_LSYKZ", reader.GetString(6));
liu.WriteElementString("YKKD_LSYKZ", reader.GetString(7));
liu.WriteElementString("CDJL_LSYKZ", reader.GetString(8));
liu.WriteElementString("YCCC_LSYKZ", reader.GetString(9));
liu.WriteElementString("SCXS_LSYKZ", reader.GetString(10));
liu.WriteElementString("SCWZ_LSYKZ", reader.GetString(11));
liu.WriteElementString("LDGC_LSYKZ", reader.GetString(12));
liu.WriteElementString("LLGS_LSYKZ", reader.GetString(13));
liu.WriteElementString("ASRQ_LSYKZ", reader.GetString(14));
liu.WriteElementString("YKJCRQ_LSYKZ", reader.GetString(15));
liu.WriteElementString("YKJCGC_LSYKZ", reader.GetString(16));
liu.WriteElementString("SCJCRQ_LSYKZ", reader.GetString(17));
liu.WriteElementString("SCJCGC_LSYKZ", reader.GetString(18));
liu.WriteElementString("MSSYT_LSYKZ", reader.GetString(19));
liu.WriteElementString("MSSM_LSYKZ", reader.GetString(20));
liu.WriteElementString("ZG_LSYKZ", reader.GetString(21));
liu.WriteElementString("JHZ_LSYKZ", reader.GetString(22));
liu.WriteElementString("AZR_LSYKZ", reader.GetString(23));
liu.WriteElementString("TBR_LSYKZ", reader.GetString(24));
liu.WriteElementString("TBRQ_LSYKZ", reader.GetString(25));
liu.WriteElementString("JDBM_MKGL", reader.GetString(26));
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("SGCJ_KZ");
string cmd=null;
try
{
SqlConnection conncj=GetConnection();
conncj.Open();
cmd="select * from SGCJ_KZ";
SqlDataReader reader = GetDataReader(cmd,conncj);
while( reader.Read())
{
liu.WriteStartElement("SGCJ_KZ");
liu.WriteAttributeString("SKBM", reader.GetString(0));
liu.WriteElementString("CDBH_SGCJKZ", reader.GetString(1));
liu.WriteElementString("YQXH_SGCJKZ", reader.GetString(2));
liu.WriteElementString("YQBH_SGCJKZ", reader.GetString(3));
liu.WriteElementString("SCDW_SGCJKZ", reader.GetString(4));
liu.WriteElementString("LC_SGCJKZ", reader.GetString(5));
liu.WriteElementString("CDZH_SGCJKZ", reader.GetString(6));
liu.WriteElementString("CDBZJ_SGCJKZ", reader.GetString(7));
liu.WriteElementString("CDGC_SGCJKZ", reader.GetString(8));
liu.WriteElementString("GXCD_SGCJKZ", reader.GetString(9));
liu.WriteElementString("GXPD_SGCJKZ", reader.GetString(10));
liu.WriteElementString("MSQY_SGCJKZ", reader.GetString(11));
liu.WriteElementString("TZGD_SGCJKZ", reader.GetString(12));
liu.WriteElementString("JZGC_SGCJKZ", reader.GetString(13));
liu.WriteElementString("LGDS_SGCJKZ", reader.GetString(14));
liu.WriteElementString("MSSYT_SGCJKZ", reader.GetString(15));
liu.WriteElementString("SM_SGCJKZ", reader.GetString(16));
liu.WriteElementString("MSQQ_SGCJKZ", reader.GetString(17));
liu.WriteElementString("MSQZ_SGCJKZ", reader.GetString(18));
liu.WriteElementString("ZG_SGCJKZ", reader.GetString(19));
liu.WriteElementString("JHZ_SGCJKZ", reader.GetString(20));
liu.WriteElementString("GCZ_SGCJKZ", reader.GetString(21));
liu.WriteElementString("MCZ_SGCJKZ", reader.GetString(22));
liu.WriteElementString("TBR_SGCJKZ", reader.GetString(23));
liu.WriteElementString("TBRQ_SGCJKZ", reader.GetString(24));
liu.WriteElementString("CZBH_SGCJKZ", reader.GetString(25));
liu.WriteEndElement();
}//endwhile
}//endtry
catch(Exception excep)
{
}
liu.WriteEndElement();
liu.WriteEndDocument();
liu.Flush();
liu.Close();
}//endif
}//endelse
}//endelse
} //endelse
}//endelse
}//endelse
}//endelse
}//endelse
}//endelse
}//endelse
this.Visible = false;
Form4 f4=new Form4(FileName);
f4.Show();
}
private void Form3_Load(object sender, System.EventArgs e)
{
textBox1.Text="";
if(textBox1.Text=="")
button2.Enabled=false;
}
private void button3_Click(object sender, System.EventArgs e)
{
saveFileDialog1.ShowDialog();
FileName=saveFileDialog1.FileName;
textBox1.Text=FileName;
}
private void textBox1_TextChanged(object sender, System.EventArgs e)
{
if(textBox1.Text=="")
{button2.Enabled=false;}
else
{button2.Enabled=true;}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -