ÈçºÎ°ÑÊý¾Ý¿â²éѯºóµÃµ½µÄ½á¹û¼¯Êä³öµ½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ÖеÄÖµ×°µ½.txt¸ñʽµÄÎļþÖС£
ÎÒĿǰÏëµ½Á½ÖֱȽϱ¿µÄ·½·¨£º1.¿ÉÒÔͨ¹ýxmlspy±à¼¹¤¾ßʵÏÖ
2.ͨ¹ý°Ñxmlת³ÉJavabean£¬È»ºóתµ½excelÖУ¬ÔÙ´Óб£´æÖØÃüÃûΪ. ......
ÈçÌâ
ÇëÎÊÄܲ»ÄܸøµãÖ¸µã£¬¹ØÓÚÕâ¸ö¿ÎÌâÎÒ²»ÖªµÀ¸ÃÔõô׼±¸£¡
˵µÃÌ«¼ò½àÁË£¬²»Àí½â
Âò¼¸±¾xml»ù´¡µÄÊé¿´¿´
ÊǽâÎöxmlÂð£¿Èç¹ûÊÇ£¬½¨ÒéÏÈÓÃdom½âÎö£¬ÕÒµ½·½·¨ºó£¬¿ÉÒÔÖ±½ÓʹÓÃjquery½âÎö£¬½¨ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
ÎÒÏÖÔÚ×ö½Ó¿Úµ¼³ö£¬.NETƽ̨£¬¿ª·¢ÓïÑÔC#£¬Ïëµ¼³öXMLµÄÎı¾¸ñʽ¡£
ÏëµÃµ½ <?xml version="1.0" encoding="GBK"?>
µÄ±àÂë¸ñʽ£¡ÔõôÉèÖã¿Ð»Ð»£¡¼±£¡
¶¥
Ö»Òª±£´æÎªxml¸ñʽ£¬ ......