62,268
社区成员
发帖
与我相关
我的任务
分享<nameid id='aa'>
<v1>000</v1>
<w2>
<t1 >1234567890</t1>
</w2>
</nameid><ok id='b1'>
<h>kkk1</h>
</ok>
<ok id='b2'>
<h>kkk2</h>
</ok>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Xml;
using System.Xml.XPath;
public partial class NewReports_CZWSINOUT_Report_CGKSaveData : System.Web.UI.Page
{
protected string[,] data;
protected string[] data1;
protected string[] data2;
protected string[] data0;
protected int item;
protected string connstr;
protected int version = 0;
protected void Page_Load(object sender, EventArgs e)
{
connstr = System.Configuration.ConfigurationSettings.AppSettings["sql2005"];
if (!IsPostBack)
{
GetXMLInfo();
}
}
/// <summary>
/// 得到传来的XML信息
/// </summary>
private void GetXMLInfo()
{
//取得XML文件
Response.Expires = -1000;
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(Request.InputStream);
//xmlDoc.Save(Server.MapPath(".\\DataSaved6.xml"));
//xmlDoc.Load(Server.MapPath(".\\DataSaved6.xml"));
//解析返回的XML文件
XmlNodeList xmlList = xmlDoc.SelectSingleNode("bqTree").ChildNodes;
int max = (new SqlDataAccess(connstr)).GetMaxValue("SELECT version FROM tRun_FactoryCheckInfo_CGK ORDER BY version DESC") + 1;
DateTime nowtime = System.DateTime.Now;
//先拿到相关的信息
//for (int i = 0; i < xmlList.Count - 2; i++)
//{
// data0 = xmlList.Item(i).InnerText.Split(new char[1] { '|' });
// for (int j = 0; j < 27; j++)
// {
// data[i, j] = data0[j];
// }
//}
data1 = xmlList.Item(xmlList.Count - 2).InnerText.Split(new char[1] { '|' });
data2 = xmlList.Item(xmlList.Count - 1).InnerText.Split(new char[1] { '|' });
string FACT_ID = "";
string FACT_NAME_j = "";
string strqrt0 = "insert into tRun_FactoryCheckInfo_CGKJL (version, DATE, InTime)values('" + max + "','" + GetDateTime(data1[1].Trim()) + "','" + nowtime + "')";
(new SqlDataAccess(connstr)).DataCom(strqrt0);
for (int i = 0; i < xmlList.Count - 2; i++)
{
data0 = xmlList.Item(i).InnerText.Split(new char[1] { '|' });
DataTable dt = (new SqlDataAccess(connstr)).RunSqlDT("SELECT OBJECTID, FACT_ID, FACT_NAME, FACT_NAME_j, In_Date, In_Dist FROM TDRAI_SEWAGEFACT WHERE (FACT_NAME = '" + data0[1].Trim() + "')");
if (dt.Rows.Count == 1)
{
FACT_ID = dt.Rows[0][1].ToString();
FACT_NAME_j = dt.Rows[0][3].ToString();
}
string strqrt1 = "insert into tRun_FactoryCheckInfo_CGK (version, ID, UNIT, DATE, IsUse, VersionId)values('" + max + "','" + Convert.ToInt32(i + 1) + "','" + FACT_NAME_j.Trim() + "','" + GetDateTime(data1[1].Trim()) + "','1','1')";
string strqrt2 = "insert into tRun_FactoryCheckSawege_CGK (version, JCBSDM, FACT_ID,DATE, FACT_BOD_IN, FACT_BOD_OUT, FACT_SS_IN, FACT_SS_OUT, FACT_COD_IN, FACT_COD_OUT, FACT_NH3N_IN, FACT_NH3N_OUT, FACT_TP_IN, FACT_TP_OUT, FACT_PH_IN, FACT_PH_OUT, FACT_CODHL_IN, FACT_CODHL_OUT, FACT_ANDAN_IN, FACT_ANDAN_OUT, FACT_ZP_IN, FACT_ZP_OUT, FACT_ZD_IN, FACT_ZD_OUT, FACT_SDU_IN, FACT_SDU_OUT, TSWNHSL, PWL, NYANG, CYDATE, IsUse, VersionId)values('" + max + "','" + Convert.ToInt32(i + 1) + "','" + FACT_ID.Trim() + "','" + GetDateTime(data1[1].Trim()) + "','" + GetDecimal(data0[2].Trim()) + "','" + GetDecimal(data0[3].Trim()) + "','" + GetDecimal(data0[4].Trim()) + "','" + GetDecimal(data0[5].Trim()) + "','" + GetDecimal(data0[6].Trim()) + "','" + GetDecimal(data0[7].Trim()) + "','" + GetDecimal(data0[8].Trim()) + "','" + GetDecimal(data0[9].Trim()) + "','" + GetDecimal(data0[10].Trim()) + "','" + GetDecimal(data0[11].Trim()) + "','" + GetDecimal(data0[12].Trim()) + "','" + GetDecimal(data0[13].Trim()) + "','" + GetDecimal(data0[14].Trim()) + "','" + GetDecimal(data0[15].Trim()) + "','" + GetDecimal(data0[16].Trim()) + "','" + GetDecimal(data0[17].Trim()) + "','" + GetDecimal(data0[18].Trim()) + "','" + GetDecimal(data0[19].Trim()) + "','" + GetDecimal(data0[20].Trim()) + "','" + GetDecimal(data0[21].Trim()) + "','" + GetDecimal(data0[22].Trim()) + "','" + GetDecimal(data0[23].Trim()) + "','" + GetDecimal(data0[24].Trim()) + "','" + GetDecimal(data0[25].Trim()) + "','" + data0[26].Trim() + "','" + GetDateTime(data0[27].Trim()) + "','1','1')";
(new SqlDataAccess(connstr)).DataCom(strqrt1);
(new SqlDataAccess(connstr)).DataCom(strqrt2);
}
}
/// <summary>
/// 判断是否为空和类型转换
/// </summary>
/// <param name="a">参数值</param>
/// <returns>得到泥质检测名称字符串</returns>
private DateTime GetDateTime(string a)
{
DateTime b = Convert.ToDateTime("1900-1-1");
if (a.Equals("") || a == null)
{
b = Convert.ToDateTime("1900-1-1");
}
else
{
try
{
b = Convert.ToDateTime(a);
}
catch
{
b = Convert.ToDateTime("1900-1-1");
}
}
return b;
}
/// <summary>
/// 判断是否为空和类型转换
/// </summary>
/// <param name="a">参数值</param>
/// <returns>得到泥质检测名称字符串</returns>
private decimal GetDecimal(string a)
{
decimal b = 0;
if (a.Equals("") || a == null)
{
b = 0;
}
else
{
try
{
b = Convert.ToDecimal(a);
}
catch
{
b = 0;
}
}
return b;
}
/// <summary>
/// 判断是否为空和类型转换
/// </summary>
/// <param name="a">参数值</param>
/// <returns>得到泥质检测名称字符串</returns>
private decimal GetInt(string a)
{
int b = 0;
if (a.Equals("") || a == null)
{
b = 0;
}
else
{
try
{
b = Convert.ToInt32(a);
}
catch
{
b = 0;
}
}
return b;
}
}
using System.Xml;
protected void Page_Load(object sender, EventArgs e)
{
XmlDocument dom = new XmlDocument ();
dom.Load ( Request.InputStream );
XmlNode node = doc.DocumentElement;
XmlNode t1Node = node.SelectSingleNode ( "//w2/t1" );
String result = t1Node.InnerXml;//1234567890你要的结果
String strXML = "<?xml version='1.0' encoding='GB2312'?><ok id='b1'><h>kkk1</h></ok><ok id='b2'><h>kkk2</h></ok>";
Response.ContentType = "text/xml";
Response.CharSet = "gb2312";
Response.Write(strXML);
Response.End();
}