ÈçºÎ°ÑÊý¾Ý¿â²éѯºóµÃµ½µÄ½á¹û¼¯Êä³öµ½XMLÖÐ
IList <ClassStockWarningInfo> stockWarningList = new List <ClassStockWarningInfo>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringInventoryDistributedTransaction, 600, CommandType.StoredProcedure, SQL_SELECT_STOCKWARNING_BY_FILIALECTLIST_AND_GOODSCLASS, parms))
{
while (rdr.Read())
{
ClassStockWarningInfo stockWarningInfo = new ClassStockWarningInfo(rdr.GetGuid(0), rdr.GetString(1), rdr[2] == DBNull.Value ? "" : rdr.GetString(2), rdr.GetDouble(3), rdr.GetInt32(4), rdr.GetDouble(5), rdr[6] == DBNull.Value ? 0 : rdr.GetDouble(6));
stockWarningList.Add(stockWarningInfo);
}
}
return stockWarningList;
ÎÒÏëÎʵÄÊÇ£¬²éѯµ½µÄ½á¹ûÊDz»ÊDZ£´æÔÚÁËstockWarningListÖÐÁË£¿Èç¹ûÊǵϰ£¬ÎÒÔõô°Ñ½á¹ûÊä³öµ½XMLÖУ¿
ÎÒ¿´²»Ì«¶®ÉÏÃæµÄ´úÂ룬ÄܸøÎÒ½âÊÍһϾÍ×îºÃÁË£¬Ð»Ð»£¡
×¢£º²éѯÊý¾Ý¿âÖ÷ÒªÊǵ÷Óô洢¹ý³ÌSQL_SELECT_STOCKW
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
<?xml version="1.0" encoding="gb2312" ?>
<sites>
<site>
<name>.Net¿ª·¢ÕßÔ°µØ</name>
<url>http://dotnet.aspx.cc</url>
<img&g ......
ÈçºÎ¶ÔxmlÄÚÈÝÊý¾Ý½øÐбȽÏ
ÀýÈ磺
<?xml version='1.0' encoding='utf-8'?>
<TestLIST>
<PID>40</PID>
<TestName>ÉîÛÚÊÐ</TestName>
......
ÒÑÖªÎļþ1.xmlºÍÊý¾ÝÎļþdb.xml£¬ÈçºÎÓÃjava±àд³ÌÐò£¬µÃ³ö2.xmlÎļþ£¿
1.ÒÑÖªxmlÎļþ 1.xml½á¹¹ÈçÏ£º
<cs>
<cs name="cs1" details="This is cs1" country="China&q ......
¡¶C#Èë޵䡷µÚÈý°æ£¨vs2005£©Ëµ±àдxmlºó¿ÉÒÔÓÒ»÷£¬Ñ¡view data grid£¬ÓÃÁбíÏÔʾÊý¾Ý¡££¨23.1.7½Ú£©
ÎÒÏÖÔÚÔÚÓÃvs2008£¬ÎÒÏàÐÅÕâ¸ö¹¦ÄÜÓ¦¸Ã»¹ÊÇÓе쬱»·Åµ½ÄĶùÈ¥ÁËÄØ£¿
ʵ¼ùһϾÍÖªµÀÀ²£¡
ÒýÓÃ
ʵ¼ùÒ»Ï ......