ÈçºÎ°ÑÊý¾Ý¿â²éѯºóµÃµ½µÄ½á¹û¼¯Êä³öµ½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ÄÚÈÝÊý¾Ý½øÐбȽÏ
ÀýÈ磺
<?xml version='1.0' encoding='utf-8'?>
<TestLIST>
<PID>40</PID>
<TestName>ÉîÛÚÊÐ</TestName>
......
ÈçÌâ
ÇëÎÊÄܲ»ÄܸøµãÖ¸µã£¬¹ØÓÚÕâ¸ö¿ÎÌâÎÒ²»ÖªµÀ¸ÃÔõô׼±¸£¡
˵µÃÌ«¼ò½àÁË£¬²»Àí½â
Âò¼¸±¾xml»ù´¡µÄÊé¿´¿´
ÊǽâÎöxmlÂð£¿Èç¹ûÊÇ£¬½¨ÒéÏÈÓÃdom½âÎö£¬ÕÒµ½·½·¨ºó£¬¿ÉÒÔÖ±½ÓʹÓÃjquery½âÎö£¬½¨ ......
<XML>
<FLAG>1</FLAG>
<REASON></REASON>
<ADVERT><ADID>64</ADID><ADNAME>Ó¢»ÊÓéÀÖËÄ</ADNAME><ADCONTENT>ÄÚÈÝÒ»</ADCONTENT><ADT ......
ÔÚactionÖÐÖÁÉÙÓÐ4¸ö·½·¨£¬Ã¿¸ö·½·¨½ÓÊÜÒ»ÖÖÇëÇó£¬ÀýÈçËĸö·½·¨×î¼òµ¥µÄ¾ÍÊÇÔöɾ¸Ä²é£¬Ã¿Ò»ÖÖ²Ù×÷£¬ÐèҪУÑéµÄactionÊôÐÔÊDz»Í¬µÄ£¬Ð£ÑéÊôÐԵĹæÔòÒ²ÊDz»Í¬µÄ£¬ÔõôÑù²ÅÄÜʹÓÃxmlµÄÊäÈëУÑ飿
Èç¹ûÊÇʹÓÃactionName ......