/// <summary>
/// 保存用户账号数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void 记住账号_CheckedChanged(object sender, EventArgs e)
{
var mi = (CheckBox)sender;
if (mi.Checked)
{
// 判断是否重复数据
var cous = sqlUserDtos.Where(m => m.Server == 数据库ID_Value.Text && m.DataBase == 数据库ID_Value.SelectedValue.ToString());
if (cous.Count() > 0)
{
MessageCommon.ShowInf("重复用户数据！");
return;
}
#region 添加新地址
SqlUserDto sqlUsers = new SqlUserDto();
sqlUsers.Server = 数据库ID_Value.Text;
sqlUsers.DataBase = 库_Value.Text;
sqlUsers.Uid = 用户名_Value.Text;
sqlUsers.Pwd = EncryptionCommon.Encryption(密码_Value.Text);
sqlUserDtos.Add(sqlUsers);
#endregion
JsonUtilities jsonUtilities = new JsonUtilities();
// 转换json
string json = jsonUtilities.JsonString <SqlUserDto>(sqlUserDtos);
jsonUtilities.WipeFileContent(@"../../SqlUser.json", json);
}
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="sql"></param>
/// <param name="sqlUser"></param>
public void BingData(string sql, SqlUserDto sqlUser)
{
int width = 0;
if (!string.IsNullOrWhiteSpace(sql))
{
SqlHelper sqlHelper = new SqlHelper(sqlUser.Server, sqlUser.Uid, sqlUser.Pwd, sqlUser.DataBase, sqlUser.DatabaseType);
this.查询结果集.DataBindings.Clear();
dt = sqlHelper.GetDataTable(sql);
this.查询结果集.DataSource = dt;
//对于DataGridView的每一个列都调整
for (int i = 0; i < this.查询结果集.Columns.Count; i++)
{
//将每一列都调整为自动适应模式
this.查询结果集.AutoResizeColumn(i, DataGridViewAutoSizeColumnMode.AllCells);
//记录整个DataGridView的宽度
width += this.查询结果集.Columns[i].Width;
}
//判断调整后的宽度与原来设定的宽度的关系，如果是调整后的宽度大于原来设定的宽度，
//则将DataGridView的列自动调整模式设置为显示的列即可，
//如果是小于原来设定的宽度，将模式改为填充。
if (width > this.查询结果集.Size.Width)
{
this.查询结果集.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
else
{
this.查询结果集.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
}
private void 查询_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(脚本语句_Value.Text))
{
MessageCommon.ShowErr("脚本语句不可为空！");
return;
}
#region 绑定数据
string sqls = string.Empty;
// 获取用户选择控件
foreach (Control c in 数据模式_数据类型.Controls)
{
if (c is RadioButton && ((RadioButton)c).Checked == true)
{
sqls = ((RadioButton)c).Name;
}
}
SqlUserDto sqlUsers = new SqlUserDto();
sqlUsers.Server = 数据库ID_Value.Text;
sqlUsers.DataBase = 库_Value.Text;
sqlUsers.Uid = 用户名_Value.Text;
sqlUsers.Pwd = 密码_Value.Text;
sqlUsers.DatabaseType = sqls;
#endregion
#region 判断窗体是否已打开
Form test = Application.OpenForms["SqlDataShow"]; //查找是否打开过about窗体
if ((test == null) || (test.IsDisposed)) //如果没有打开过
{
sqlData = new SqlDataShow();
sqlData.BingData(脚本语句_Value.Text, sqlUsers);
sqlData.Show(); //打开子窗体出来
}
else
{
sqlData.Activate(); //如果已经打开过就让其获得焦点
}
#endregion
}
