读取XML村放入list集合并放入实体中

 public CustomerBillingDetailResponse GetCustomerBillingDetailInfo(string customer_id, DateTime from_date, DateTime to_date, string language)
        {


            CustomerBillingDetailResponse req = new CustomerBillingDetailResponse(); 

            string URL = string.Format("http://113.105.65.104:22224/ctw/msdQueryCtwCusAccount?cuscode={0}&beginDate={1}&endDate={2}", customer_id, from_date.ToString("yyyy-MM-dd"), to_date.ToString("yyyy-MM-dd"));  //直接通过URL获取xml

            XDocument xdoc = XDocument.Load(URL);
            var qurey = from cusaccount in xdoc.Descendants("cusaccount")
                        select new CustomerBillingDetail
                        {
                            cuscodenew = cusaccount.Element("cuscodenew").Value,
                            accdate = string.IsNullOrEmpty(cusaccount.Element("accdate").Value.ToString()) ? "" : DataTypeHelper.GetDateTime(cusaccount.Element("accdate").Value).ToString("dd-MM-yyyy"),//格式化时间
                            billcode = cusaccount.Element("billcode").Value,
                            cno = cusaccount.Element("cno").Value,
                            description = cusaccount.Element("description").Value,
                            payin = DataTypeHelper.GetDecimal(cusaccount.Element("payin").Value,0).ToString("N"),
                            ccp = DataTypeHelper.GetDecimal(cusaccount.Element("ccp").Value,0).ToString("N"),
                            camount =DataTypeHelper.GetDecimal(cusaccount.Element("camount").Value,0).ToString("N"),
                            dif = DataTypeHelper.GetDecimal(cusaccount.Element("dif").Value,0).ToString("N"),
                            totalbalance = DataTypeHelper.GetDecimal(cusaccount.Element("totalbalance").Value,0).ToString("N")

                        };
            req.CustomerBillingDetails = qurey.ToList();//转换成list并放入实体集
            return req;
        }

 

posted @ 2014-03-26 12:49  飞翔.  阅读(234)  评论(0编辑  收藏  举报