herolistforms.cs

用vc#编写的小游戏

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
using System.Xml;

namespace Mine.UIL
{
    public partial class HeroListForms : Form
    {
        private Mine.ADL.Users _dalUser;
        private StringBuilder _strConnect;
        private string _serverName;
        private string _databaseName;
        private string _userName;
        private string _userPass;
        private string _connectType;

        public HeroListForms()
        {
            InitializeComponent();
            ReadToXml();
            BuildConnectString();
            _dalUser = new Mine.ADL.Users(_strConnect.ToString());
            GetDataFromDB();
        }

        private void labTitle_Click(object sender, EventArgs e)
        {

        }

        /// <summary>
        /// 从数据库读取数据
        /// </summary>
        private void GetDataFromDB()
        {
            DataTable dt = new DataTable();
            DataSet t=new DataSet();
            t=_dalUser.GetList();
            if (t != null)
            {

                dt = t.Tables[0];

                string[] strItem = new string[5];

                foreach (DataRow dr in dt.Rows)
                {
                    if ((dr["用户名"].ToString()).Trim() != "0")
                    {
                        strItem[0] = (dr["用户名"].ToString()).Trim();
                        strItem[1] = dr["游戏级别"].ToString();
                        strItem[2] = (dr["雷的数目"].ToString()).Trim();
                        strItem[3] = (dr["所用时间"].ToString()).Trim();
                        strItem[4] = (dr["日期时间"].ToString()).Trim();
                        ListViewItem item = new ListViewItem(strItem);
                        lstSort.Items.Add(item);
                    }
                }
            }
            else
            {
                MessageBox.Show("服务器连接错误，请检查是否正确设置服务器！","错误信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
            }
        }

        /// <summary>
        /// 构造连接字符串
        /// </summary>
        public void BuildConnectString()
        {
            _strConnect = new StringBuilder();
            if (_connectType == "windows")
            {
                _strConnect.Append("Data Source=");
                _strConnect.Append(_serverName + @";" + @"Initial Catalog=" + _databaseName);
                _strConnect.Append(@";Integrated Security=True");
            }
            else if (_connectType == "usernameandpassword")
            {
                _strConnect.Append("Data Source=");
                _strConnect.Append(_serverName + @";" + @"Initial Catalog=" + _databaseName);
                _strConnect.Append(@";User ID=" + _userName + @";Password=" + _userPass);

            }
        }

        /// <summary>
        /// 从配置文件中读取服务器配置信息
        /// </summary>
        /// <param name="fileName">文件名</param>
        private bool ReadToXml()
        {
            bool bo = false;

            if (File.Exists(@"Config.xml"))
            {

                XmlTextReader xmlReader = new XmlTextReader(@"Config.xml");
                try
                {
                    while (xmlReader.Read())
                    {
                        if (xmlReader.Name == "servername")
                        {
                            _serverName = (xmlReader.ReadElementString()).Trim();
                        }
                        else if (xmlReader.Name == "databasename")
                        {
                            _databaseName = (xmlReader.ReadElementString()).Trim();
                        }
                        else if (xmlReader.Name == "username")
                        {
                            _userName = (xmlReader.ReadElementString()).Trim();
                        }
                        else if (xmlReader.Name == "userpassword")
                        {
                            _userPass = (xmlReader.ReadElementString()).Trim();
                        }
                        else if (xmlReader.Name == "connecttype")
                        {
                            _connectType = (xmlReader.ReadElementString()).Trim();
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }

                bo = true;
            }
            else
            {
                bo = false;
                MessageBox.Show("尚未配置服务器，您将读取数据！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

            return bo;
        }

        private void butDelete_Click(object sender, EventArgs e)
        {
            if (lstSort.SelectedItems.Count == 0)
            {
                MessageBox.Show("您得先选中一条记录，再删除嘛！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                bool bo=false;
                foreach (ListViewItem item in lstSort.SelectedItems)
                {
                    bo = _dalUser.Delete((item.SubItems[0].Text).Trim(), (item.SubItems[1].Text).Trim(),( item.SubItems[3].Text).Trim(),( item.SubItems[4].Text).Trim(),Convert.ToInt32( item.SubItems[2].Text));

                }

                if (bo == true)
                {
                    foreach (ListViewItem item in lstSort.SelectedItems)
                    {
                        lstSort.Items.Remove(item);

                    }

                    MessageBox.Show("删除成功！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("删除失败！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
    }
}