private void btnSubmit_Click(object sender, EventArgs e)
{
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
try
{
string sql = "INSERT well(井号,地点,负责人姓名,负责人电话,负责人地址,开井时间)" +
" VALUE('" + JingHao.Text + "','" + where.Text + "','" + name.Text + "','" + phone.Text + "','" + addres.Text + "','" + time.Value + "')";
Console.WriteLine(sql);
var res = mysqlDB.Edit(sql);
if (res)
{
MessageBox.Show("添加成功");
this.Close();
}
else
{
MessageBox.Show("添加失败");
}
}
catch (System.FormatException)
{
MessageBox.Show("输入格式错误");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
string type = null;
try
{
string sql = "insert into user(用户账号,用户昵称,用户密码,用户真实姓名,用户联系方式,用户地址,用户注册时间) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + DateTime.Now + "')";
Console.WriteLine(sql);
var res = mysqlDB.Edit(sql);
if (res)
{
MessageBox.Show("添加成功");
this.Close();
}
else
{
MessageBox.Show("添加失败");
}
}
catch (System.FormatException)
{
MessageBox.Show("输入格式错误");
}
}
public void zhanghao_Leave(object sender, EventArgs e)
{
var regex2 = new Regex(@"
(?=.*[0-9]) #必须包含数字
(?=.*[a-zA-Z]) #必须包含小写或大写字母
#必须包含特殊符号
.{6,20} #至少6个字符，最多20个字符
", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace);
//校验密码是否符合
bool pwdIsMatch2 = regex2.IsMatch(zhanghao.Text);
Console.WriteLine(pwdIsMatch2);
if (pwdIsMatch2 == true)
{
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
try
{
string sql = "select 管理员账号 from management";
Console.WriteLine(sql);
var res = mysqlDB.Get(sql);
List <string> list = new List <string>();
while (res.Read())
{
string str = res.GetString("管理员账号");
list.Add(str);
}
if (list.Contains(zhanghao.Text))
{
errorProvider1.SetError(zhanghao, "管理员账号已存在！");
Console.WriteLine("正确");
}
else if (string.IsNullOrEmpty(zhanghao.Text))
{
errorProvider1.SetError(zhanghao, "不能为空！");
}
else
{
errorProvider1.Clear();
}
//var res1 = mysqlDB.Edit(sql1);
}
catch (System.FormatException)
{
MessageBox.Show("输入格式错误");
}
}
else if (pwdIsMatch2 == false)
{
errorProvider1.SetError(zhanghao, "账号必须在8-30位之间，且需要包含数字和字母！");
}
//ErrorProvider errorProvider = new ErrorProvider();
}
public void showDate()
{
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
string sql = "select * from well";
var reader = mysqlDB.Get(sql);
while (reader.Read())
{
int index = this.dataGridView1.Rows.Add();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Rows[index].Cells[i].Value = reader[i];
}
}
}
private void lookup_Click(object sender, EventArgs e)
{
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
string sql = "select * from shuihua where 井号='" + num.Text + "'";
var reader = mysqlDB.Get(sql);
dataGridView1.Rows.Clear();
while (reader.Read())
{
int index = this.dataGridView1.Rows.Add();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Rows[index].Cells[i].Value = reader[i];
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (zhanghao.Text != "" & nicheng.Text != "" & mima.Text != "" & xingming.Text != "" & lianxi.Text != "" & dizhi.Text != "" & dateTimePicker1.Value != null)
{
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
try
{
//string sql1 = "insert into power values (" + "'" + zhanghao.Text + "'" + "," + "'" + xingming.Text + "'" + "," + "'" + "管理员" + "'" + "," + "'" +DateTime.Today+ "'" +","+ "'"+"修改人"+"'"+")";
string sql = "insert into management values (" + "'" + zhanghao.Text + "'" + "," + "'" + nicheng.Text + "'" + "," + "'" + mima.Text + "'" + "," + "'" + xingming.Text + "'" + "," + "'" + lianxi.Text + "'" + "," + "'" + dizhi.Text + "'" + "," + "'" + DateTime.Today + "'" + "," + "'" + dateTimePicker1.Value.ToString() + "'" + ")";
Console.WriteLine(sql);
//Console.WriteLine(sql1);
var res = mysqlDB.Edit(sql);
//var res1 = mysqlDB.Edit(sql1);
if (res)
{
MessageBox.Show("添加成功");
this.Close();
}
else
{
MessageBox.Show("添加失败");
}
/* if (res1)
* {
* MessageBox.Show("权限表更新成功");
* this.Close();
* }
* else
* {
* MessageBox.Show("权限表更新失败");
* }*/
}
catch (System.FormatException)
{
MessageBox.Show("输入格式错误");
}
}
else
{
MessageBox.Show("请将输入信息填写完整");
}
}
public void showDate()
{
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
string sql = "select * from 钻井液沿裂缝压力穿透效应及钻井液有效封堵性对井壁稳定性表";
var reader = mysqlDB.Get(sql);
while (reader.Read())
{
int index = this.dataGridView1.Rows.Add();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Rows[index].Cells[i].Value = reader[i];
}
}
//绑定数据集
num.DataSource = mysqlDB.getWellNum();
}
public void showDate()
{
dataGridView1.Columns[6].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm:ss";
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
string sql = "select * from 井眼轨迹表";
var reader = mysqlDB.Get(sql);
while (reader.Read())
{
int index = this.dataGridView1.Rows.Add();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Rows[index].Cells[i].Value = reader[i];
}
}
//绑定数据集
num.DataSource = mysqlDB.getWellNum();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
try
{
string sql = "INSERT 井眼轨迹表" +
"(井号,深度,井斜角,方位角,地层坍塌压力当量密度,时间)" +
" VALUE('" +
JingHao.Text + "'," +
(float)Convert.ToSingle(textHeight.Text) + "," +
(float)Convert.ToSingle(textJinxie.Text) + "," +
(float)Convert.ToSingle(textFangwei.Text) + "," +
(float)Convert.ToSingle(textMidu.Text) + ",'" +
DateTime.Now +
"')";
Console.WriteLine(sql);
var res = mysqlDB.Edit(sql);
if (res)
{
MessageBox.Show("添加成功");
this.Close();
f1.dataGridView1_refresh();
}
else
{
MessageBox.Show("添加失败");
}
}
catch (System.FormatException)
{
MessageBox.Show("输入格式错误");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
int i = 1;
try
{
string sql = "INSERT into shuihua(井号,深度,黏土矿物类型,含量分布,水化作用强度,时间)" +
" VALUE('" +
JingHao.Text + "'" + ',' +
"'" + textX.Text + "'" + "," +
"'" + textY.Text + "'" + ","
+ "'" + textZ.Text + "'" + ","
+ "'" + textH.Text + "'" + "," +
"'" + DateTime.Now + "'" +
")";
Console.WriteLine(sql);
var res = mysqlDB.Edit(sql);
if (res)
{
MessageBox.Show("添加成功");
this.Close();
}
else
{
MessageBox.Show("添加失败");
}
}
catch (System.FormatException)
{
MessageBox.Show("输入格式错误");
}
}
private void button1_Click(object sender, EventArgs e)
{
var regex3 = new Regex(@"
(?=.*^[0-9]*$) #必须包含数字
.{6,20} #至少8个字符，最多30个字符
", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace);
//校验密码是否符合
bool pwdIsMatch3 = regex3.IsMatch(textBox1.Text);
var regex1 = new Regex(@"
(?=.*[0-9]) #必须包含数字
(?=.*[a-zA-Z])
(?=([\x21-\x7e]+)[^a-zA-Z0-9]) #必须包含特殊符号#必须包含小写或大写字母
.{6,20} #至少8个字符，最多30个字符
", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace);
//校验密码是否符合
bool pwdIsMatch1 = regex1.IsMatch(textBox3.Text);
var regex2 = new Regex(@"
(?=.*[0-9]) #必须包含数字
(?=.*[a-zA-Z])
(?=([\x21-\x7e]+)[^a-zA-Z0-9]) #必须包含特殊符号#必须包含小写或大写字母
.{6,20} #至少8个字符，最多30个字符
", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace);
//校验密码是否符合
bool pwdIsMatch2 = regex2.IsMatch(textBox7.Text);
var regex4 = new Regex(@"
(?=.*^[0-9]*$) #必须包含数字
.{11,11} #至少8个字符，最多30个字符
", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace);
//校验密码是否符合
bool pwdIsMatch4 = regex4.IsMatch(textBox5.Text);
////////////////////////////////////////////////
if (pwdIsMatch3 == true)
{
if (pwdIsMatch1 == true && pwdIsMatch2 == true)
{
if (textBox3.Text.Trim().Equals(textBox7.Text.Trim()))
{
if (pwdIsMatch4 == true)
{
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
string type = null;
try
{
string sql = "insert into user(用户账号,用户昵称,用户密码,用户真实姓名,用户联系方式,用户地址,用户注册时间) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + DateTime.Now + "')";
Console.WriteLine(sql);
var res = mysqlDB.Edit(sql);
if (res)
{
MessageBox.Show("添加成功");
/*string po = "四级";
* string na = "管理员";
* string sql3 = "insert into power(账号,姓名,权限级别,修改时间，修改人) values('" + textBox1.Text + "','" + textBox4.Text + "','" + po + "','" + DateTime.Now + "'，'" + na + "')";
* Console.WriteLine(sql3);
* var res2 = mysqlDB.Edit(sql3);
* if (res2)
* { }
* else
* {
* MessageBox.Show("权限申请失败");
* }*/
this.Close();
}
else
{
MessageBox.Show("添加失败");
}
}
catch (System.FormatException)
{
MessageBox.Show("输入格式错误");
}
}
else
{
MessageBox.Show("必须电话号码是11位纯数字的号码");
}
}
else
{
MessageBox.Show("两次输入密码不一致,请重新输入");
}
}
else
{
MessageBox.Show("密码格式不对请输入字母加数字组合的6-20位");
}
}
else
{
MessageBox.Show("账号格式不对请输入纯数字6-20位");
}
}
private void FrmInsert_Load(object sender, EventArgs e)
{
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
JingHao.DataSource = mysqlDB.getWellNum();
}
//用户登录
private void button1_Click(object sender, EventArgs e)
{
//检查账户密码是否为空
if (textBox1.Text == "" || textBox2.Text == "" || (radioButton1.Checked == false && radioButton2.Checked == false))
{
MessageBox.Show("你的账号，密码为空，或者你没用选择身份按钮");
}
else
{
var regex1 = new Regex(@"
(?=.*[0-9]) #必须包含数字
#(?=.*[a-zA-Z])必须包含小写或大写字母
.{6,20} #至少8个字符，最多30个字符
", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace);
//校验密码是否符合
bool pwdIsMatch1 = regex1.IsMatch(textBox1.Text);
var regex2 = new Regex(@"
(?=.*[0-9]) #必须包含数字
(?=.*[a-zA-Z]) #必须包含小写或大写字母
(?=([\x21-\x7e]+)[^a-zA-Z0-9]) #必须包含特殊符号
.{6,20} #至少8个字符，最多30个字符
", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace);
//校验密码是否符合
bool pwdIsMatch2 = regex2.IsMatch(textBox2.Text);
if (pwdIsMatch2 == true && pwdIsMatch1 == true)
{
//登录数据库验证密码
MysqlDB mysqlDB;
mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456");
//string type = null;
string username = textBox1.Text.Trim();
string userpassword = textBox2.Text.Trim();
//sql语句（谨慎使用drop，delete!!!）
string sql = "SELECT 管理员账号,管理员密码 FROM management";
string sql1 = "SELECT 用户账号,用户密码 FROM user";
if (textBox1.Text.Equals("") & textBox2.Text.Equals(""))
{
MessageBox.Show("用户名或密码不能为空");
}
else
{
if (radioButton1.Checked)
{
var reader = mysqlDB.Get(sql);
Dictionary <string, string> qqDict = new Dictionary <string, string>();// 用户密码字典
if (reader != null)
{
while (reader.Read())
{
string name = reader.GetString("管理员账号");
string pwd = reader.GetString("管理员密码");
qqDict.Add(name, pwd);
}
if (textBox2.Text.Equals(""))
{
MessageBox.Show("密码不能为空");
}
else
{
String loginName = textBox1.Text;
//User.Name = textBox1.Text;//将登陆名的text创给类的静态字段
if (qqDict.ContainsKey(loginName))
{
if (textBox2.Text.Equals(qqDict[textBox1.Text]))
{
//MessageBox.Show("密码正确");
//if(radioButton1.Checked)
//管理员界面显示
kaiguan = true;
Form1 a = new Form1();
a.ShowDialog();
this.Hide();
}
else
{
MessageBox.Show("密码错误");
}
}
else
{
MessageBox.Show("无此用户名");
}
}
}
else
{
MessageBox.Show("出现网络连接问题");
}
}
else
{
var reader = mysqlDB.Get(sql1);
Dictionary <string, string> qqDict = new Dictionary <string, string>();// 用户密码字典
if (reader != null)
{
while (reader.Read())
{
string name = reader.GetString("用户账号");
string pwd = reader.GetString("用户密码");
qqDict.Add(name, pwd);
}
if (textBox2.Text.Equals(""))
{
MessageBox.Show("密码不能为空");
}
else
{
String loginName = textBox1.Text;
//User.Name = textBox1.Text;//将登陆名的text创给类的静态字段
if (qqDict.ContainsKey(loginName))
{
if (textBox2.Text.Equals(qqDict[textBox1.Text]))
{
//MessageBox.Show("密码正确");
//用户界面显示
Form1 form1 = new Form1();
form1.ShowDialog();
}
else
{
MessageBox.Show("密码错误");
}
}
else
{
MessageBox.Show("无此用户名");
}
}
}
else
{
MessageBox.Show("出现网络连接问题");
}
}
}
//Console.WriteLine("")
}
else
{
MessageBox.Show("请检验你输入的密码中是否含有特殊字符或空格，密码长度在6-20位，请重新输入");
}
}
//检验输入的密码
}
