📄 usersaveforms.cs
字号:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Xml;
namespace Mine.UIL
{
public partial class UserSaveForms : Form
{
private Mine.Model.user _user;
private string _serverName;
private string _databaseName;
private string _userName;
private string _userPass;
private string _connectType;
private StringBuilder _strConnect;
public UserSaveForms()
{
InitializeComponent();
}
/// <summary>
/// 重载构造涵数
/// </summary>
/// <param name="user"></param>
public UserSaveForms(Mine.Model.user user)
{
InitializeComponent();
_user = user;
ReadToXml();
BuildConnectString();
}
/// <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);
}
}
private void butOK_Click(object sender, EventArgs e)
{
if (this.txtName.Text != null)
{
_user.UsersName = this.txtName.Text;
Mine.ADL.Users _dalUser = new Mine.ADL.Users(_strConnect.ToString()) ;
if (_dalUser.Add(_user))
{
MessageBox.Show("信息保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("信息保存失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("请输入你的姓名!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
/// <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;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -