[c-sharp] view plain copy

  1. SqlConnection mycon = new SqlConnection(constr);  

  2. mycon.Open();  

  3. SqlCommand cmd = new SqlCommand();  

  4. SqlTransaction mytran = mycon.BeginTransaction();  

  5.   

  6. //绑定<a href="http://lib.csdn.net/base/14" class='replace_word' title="MySQL知识库" target='_blank' style='color:#df3434; font-weight:bold;'>数据库</a>连接和事务对象  

  7. cmd.Connection = mycon;  

  8. cmd.Transaction = mytran;  

  9. try  

  10. {  

  11.     cmd.CommandText = "use WDERPDATA_002";  

  12.     cmd.CommandText = "insert into TBASE_DEPT(BM_FZ_CODE,BM_DEPT_CODE,BM_DEPT_NAME,BM_STATUS) values('01','01','develop','1') ";  

  13.     cmd.ExecuteNonQuery();  

  14.     cmd.CommandText = "insert into TBASE_DEPT(BM_FZ_CODE,BM_DEPT_CODE1,BM_DEPT_NAME,BM_STATUS) values('01','02','develop1','1') ";  

  15.     cmd.ExecuteNonQuery();  

  16.     cmd.CommandText = "insert into TBASE_DEPT(BM_FZ_CODE,BM_DEPT_CODE,BM_DEPT_NAME,BM_STATUS) values('01','03','develop2','1') ";               

  17.     cmd.ExecuteNonQuery();  

  18.     //cmd.CommandText = "create database Hello";  

  19.     //cmd.ExecuteNonQuery();  

  20.     mytran.Commit();  

  21. }  

  22. catch (Exception ex)  

  23. {  

  24.     mytran.Rollback();  

  25.     Console.Write("事务操作出错，已回滚。系统信息：" + ex.Message);  

  26. }  

  27. finally  

  28. {  

  29.     mycon.Close();  

  30. }  


                                                

                                                     分布式事务处理

 

1，事务处理的升级-分布式事务处理(http://www.cnblogs.com/yinhaiming/articles/1551466.html)

msdn:

  System.Transactions 基础结构既提供了基于 Transaction 类的显式编程模型(CommittableTransaction)，也提供了使用 TransactionScope 类的隐式编程模型，在后一种模型中，事务由该基础结构自动管理.

(MSDN: 建议使用 TransactionScope 类创建隐式事务，以便自动为您管理环境事务上下文。对于需要跨多个函数调用或多个线程调用使用相同事务的应用程序，您还应该使用 TransactionScope 和 DependentTransaction 类。有关此模型的更多信息，请参见 使用事务范围实现隐式事务 主题。)

CommittableTransaction :

    CommittableTransaction 不会自动设置环境事务（环境事务是您的代码在其中执行的事务）。可以通过调用全局 Transaction 对象的静态 Current 属性获取或设置环境事务。有关环境事务的更多信息，请参见 使用事务范围实现隐式事务 主题的“Managing Transaction Flow using TransactionScopeOption”

TransactionScope:

   如果在事务范围中（即从初始化 TransactionScope 对象到调用其 Dispose 方法之间）未发生异常，则允许该范围所参与的事务继续。如果事务范围中的确发生了异常，它所参与的事务将回滚。

当应用程序完成它要在一个事务中执行的所有工作以后，您应当只调用 Complete 方法一次，以通知事务管理器可以接受提交事务。未能调用此方法将中止该事务。

对 Dispose 方法的调用标志着该事务范围的结束。在调用此方法之后发生的异常不会影响该事务。

如果在范围中修改 Current 的值，则会在调用 Dispose 时引发异常。但是，在该范围结束时，先前的值将被还原。此外，如果在创建事务的事务范围内对 Current 调用 Dispose，则该事务将在相应范围末尾处中止。

 

上面重点看点：使用 TransactionScopeOption 管理事务流

 

2，DependentTransaction 依赖事务处理

3，跨多个函数调用//多个线程调用 使用相同环境事务：

多个线程中调用环境事务中，必须使用DependentTransaction 依赖事务，将Transaction.Current 设置为依赖项

 

 

附录： 转自  http://www.cnblogs.com/yongfeng/archive/2010/08/15/1799905.html

C#远程访问linux(ubuntu)或windows的mysql数据库

 1、远程访问数据库大概模型

2、MySQL在win7、linux上如何设置：

　　2.1、分配权限（linux和win7）

　　　　进行mysql命令行，进行分配权限、执行

GRANT ALL PRIVILEGES ON *.* TO 'Lucy'@'192.168.1.102' IDENTIFIED BY '123' WITH GRANT OPTION;

 　　　　ALL PRIVILEGES分配所有的权限，如Select、Insert、Delete、Update、Drop、Create等等

　　　　*.*是 数据库.数据库中的表

　　　　'Lucy'是远程机子要访问本计算机的所需要的用户名（这个由mysql分配用户给远程机子，当然，还要通过一下步的3306端口）　　　　

　　　　'192.168.1.102'是远程机子的IP地址（这个由mysql指定远程机子哪个IP地址可以让访问）

　　　　'123'是远程机子知道了用户，需要访问的用户密码（这个也是由mysql分配密码给远程机子）

　　　　所以也可以归纳为：

GRANT ALL PRIVILEGES ON 数据库.数据库表 TO '远程机用户名'@'远程机IP' IDENTIFIED BY '远程机用户密码' WITH GRANT OPTION;

　　2.2、打开3306端口

　　　　2.2.1、为什么要打开3306端口？

　　　　　　因为防火墙问题，例如：

　　　　　　IIS配置ASP后，局域网的机子不能访问本机的网页（如果默认端口是80），而关掉防火墙就可以。是因为你的80端口没有打开。

　　　　　　而mysql的默认端口3306是默认没有打开的。

　　　　2.2.2、为什么我们远程访问SQL的时候，不用打开端口？

　　　　　　因为SQL的端口是默认打开的，而你远程访问SQL数据库的时候，只要知道它的用户名、密码、端口号1433就行了。

　　　　2.2.3、如何打开mysql的端口

　　　　　　2.2.4、在win7上，只要在‘入站规则’上建立一个3306端口即可。

　　　　　　　　控制面板=>管理工具=>高级安全的Windows防火墙=>入站规则

　　　　　　　　然后新建规则=>选择‘端口’=>在‘特定本地端口’上输入一个‘3306’=>选择‘允许连接’=>选择‘域’、‘专用’、‘公用’

　　　　　　　　=>给个名称，如：mysqlinput

　　　　　　2.2.5、在linux的ubuntu上，对mysql的配置文件进行配置均可。

　　　　　　　　按F3（打开命令行）=>输入"sudo vi /etc/mysql/my.cnf"(用vim打开)=> 

 # Instead of skip-networking the default is now to listen only on 

 # localhost which is more compatible and is not less secure. 

 bind-address = 127.0.0.1

　　　　　　　注释掉bind-address均可，即#bind-address = 127.0.0.1，表示允许通过远程端口3306访问。

　　　　　　　=>重启mysql，即在命令行输入"sudo /etc/init.d/mysql restart"

 

3、客户端（win7或ubuntu下载 MySQL ODBC 3.51 Driver，因为在ubuntu上有人用Mono搞C#，所以ubuntu也提进去)

　　可以到http://dev.mysql.com/downloads/connector/odbc/3.51.html下载，安装在此不多说了。

　　安装完后，在win7下怎么看你有了MySQL ODBC 3.51 Driver这个驱动程序呢?(Mono我就帮不了忙了，因为我没有使用过)

　　控制面板=>管理工具=>数据源(ODBC)=>驱动程序

 

4、C#方面

　　这里就简单写一个对方存在的数据库(information_schema是默认存在的)，这里用的是asp

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Data;
using System.Data.Odbc;

namespace Help
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string strconn = "Driver={MySQL ODBC 3.51 Driver};Server=192.168.1.102;Database=information_schema;User=Lucy; Password=123;Option=3;chartset=utf8";
            string sql = "select * from CHARACTER_SETS";
            OdbcConnection myConnection = new OdbcConnection(strconn);
            OdbcCommand myCommand = new OdbcCommand(sql, myConnection);
            myConnection.Open();

            //DropDownList1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
            //DropDownList1.DataTextField = "name";
            //DropDownList1.DataValueField = "id";
            //DropDownList1.DataBind();
            OdbcDataAdapter sda = new OdbcDataAdapter();
            sda.SelectCommand = myCommand;
            DataSet ds = new DataSet();
            sda.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            
            myConnection.Close();
        }
    }
}

 

5、远程访问后，运行效果：

 

6、总结

　　6.1、操作系统上大部分有一些共性，其操作思想是可以移植的。

　　6.2、如何看懂相应的配置文件说明是很重要的。

　　6.3、命令行多少也得学一些。至少打开‘服务’的时候，输入services.msc，就可以打开服务了。

　　6.4、抽象出自己可理解和实际相结合的模型是挺重要的。

原文链接：

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2000.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2001.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2002.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2003.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2004.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2005.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2006.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2007.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2008.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2009.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2010.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2011.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2012.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2013.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2014.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2015.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2016.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2017.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2018.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2019.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2020.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2021.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2022.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2023.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2024.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2025.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2026.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2027.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2028.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2029.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2030.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2031.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2032.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2033.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2034.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2035.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2036.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2037.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2038.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2039.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2040.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2041.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2042.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2043.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2044.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2045.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2046.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2047.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2048.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2049.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2050.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2051.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2052.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2053.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2054.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2055.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2056.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2057.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2058.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2059.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2060.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2061.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2062.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2063.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2064.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2065.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2066.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2067.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2068.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2069.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2070.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2071.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2072.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2073.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2074.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2075.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2076.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2077.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2078.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2079.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2080.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2081.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2082.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2083.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2084.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2085.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2086.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2087.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2088.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2089.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2090.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2091.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2092.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2093.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2094.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2095.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2096.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2097.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2098.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2099.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2100.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2101.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2102.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2103.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2104.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2105.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2106.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2107.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2108.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2109.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2110.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2111.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2112.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2113.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2114.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2115.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2116.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2117.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2118.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2119.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2120.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2121.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2122.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2123.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2124.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2125.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2126.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2127.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2128.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2129.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2130.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2131.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2132.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2133.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2134.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2135.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2136.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2137.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2138.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2139.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2140.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2141.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2142.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2143.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2144.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2145.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2146.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2147.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2148.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2149.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2150.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2151.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2152.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2153.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2154.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2155.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2156.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2157.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2158.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2159.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2160.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2161.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2162.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2163.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2164.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2165.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2166.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2167.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2168.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2169.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2170.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2171.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2172.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2173.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2174.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2175.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2176.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2177.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2178.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2179.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2180.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2181.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2182.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2183.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2184.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2185.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2186.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2187.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2188.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2189.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2190.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2191.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2192.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2193.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2194.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2195.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2196.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2197.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2198.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2199.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2200.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2201.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2202.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2203.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2204.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2205.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2206.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2207.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2208.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2209.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2210.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2211.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2212.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2213.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2214.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2215.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2216.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2217.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2218.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2219.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2220.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2221.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2222.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2223.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2224.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2225.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2226.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2227.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2228.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2229.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2230.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2231.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2232.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2233.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2234.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2235.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2236.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2237.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2238.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2239.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2240.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2241.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2242.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2243.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2244.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2245.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2246.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2247.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2248.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2249.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2250.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2251.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2252.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2253.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2254.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2255.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2256.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2257.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2258.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2259.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2260.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2261.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2262.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2263.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2264.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2265.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2266.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2267.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2268.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2269.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2270.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2271.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2272.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2273.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2274.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2275.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2276.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2277.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2278.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2279.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2280.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2281.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2282.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2283.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2284.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2285.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2286.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2287.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2288.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2289.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2290.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2291.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2292.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2293.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2294.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2295.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2296.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2297.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2298.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2299.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2300.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2301.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2302.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2303.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2304.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2305.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2306.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2307.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2308.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2309.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2310.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2311.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2312.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2313.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2314.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2315.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2316.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2317.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2318.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2319.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2320.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2321.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2322.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2323.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2324.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2325.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2326.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2327.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2328.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2329.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2330.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2331.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2332.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2333.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2334.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2335.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2336.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2337.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2338.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2339.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2340.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2341.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2342.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2343.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2344.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2345.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2346.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2347.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2348.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2349.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2350.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2351.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2352.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2353.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2354.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2355.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2356.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2357.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2358.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2359.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2360.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2361.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2362.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2363.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2364.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2365.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2366.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2367.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2368.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2369.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2370.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2371.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2372.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2373.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2374.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2375.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2376.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2377.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2378.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2379.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2380.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2381.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2382.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2383.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2384.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2385.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2386.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2387.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2388.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2389.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2390.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2391.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2392.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2393.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2394.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2395.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2396.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2397.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2398.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2399.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2400.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2401.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2402.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2403.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2404.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2405.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2406.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2407.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2408.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2409.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2410.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2411.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2412.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2413.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2414.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2415.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2416.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2417.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2418.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2419.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2420.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2421.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2422.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2423.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2424.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2425.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2426.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2427.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2428.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2429.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2430.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2431.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2432.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2433.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2434.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2435.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2436.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2437.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2438.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2439.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2440.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2441.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2442.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2443.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2444.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2445.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2446.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2447.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2448.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2449.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2450.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2451.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2452.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2453.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2454.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2455.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2456.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2457.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2458.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2459.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2460.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2461.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2462.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2463.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2464.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2465.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2466.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2467.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2468.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2469.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2470.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2471.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2472.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2473.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2474.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2475.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2476.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2477.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2478.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2479.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2480.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2481.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2482.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2483.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2484.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2485.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2486.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2487.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2488.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2489.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2490.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2491.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2492.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2493.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2494.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2495.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2496.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2497.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2498.html

http://www.nanhaitoday.com/html/2016/kxizuo_0508/2499.html

http://www.nanhaitoday.com/sitemap.txt