public bool IsEquals(BaiscInfo bi)
{
bool have = false;
con.Open();
string sql = String.Format("select TypeName from {0} where TypeName='{1}'", bi.Db, bi.Typename);
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader msrd;
msrd = cmd.ExecuteReader();
string result = null;
while (msrd.Read())
{
for (int ct = 0; ct < msrd.FieldCount; ct++)
{
result = msrd[ct].ToString();
}
}
if (result == null)
{
}
else
{
have = true;
}
con.Close();
return(have);
}
public int AddBI(BaiscInfo bi)
{
con.Open();
string sql = String.Format("INSERT INTO {0} VALUES ('{1}', '{2}')", bi.Db, null, bi.Typename);
Console.WriteLine("SQL:::::::::::" + sql);
MySqlCommand cmd = new MySqlCommand(sql, con);
int iRet = cmd.ExecuteNonQuery();//这里返回的是受影响的行数，为int值。可以根据返回的值进行判断是否插入成功。
con.Close();
return(iRet);
}
private void button1_Click(object sender, EventArgs e)
{
string which = App.value;
//MessageBox.Show(which);
bi = new BaiscInfo()
{
Db = which,
Typename = textBox1.Text
};
string messageStr = null;
if (bm.Add(bi, out messageStr))
{
MessageBox.Show("添加成功");
this.Hide();
}
else
{
MessageBox.Show(messageStr);
}
}
public bool Add(BaiscInfo bi, out string msg)
{
msg = null;
bool isSuccess = false;
if (bi.Db.Trim().Length != 0 || bi.Typename.Trim().Length != 0) //判断从传递来的username是否为空
{
if (!bd.IsEquals(bi)) //传给DALl操作判断数据库中是否有重复值
{
bd.AddBI(bi); //传给DAL操作增加一个新用户
isSuccess = true;
}
else
{
msg = "有相同的值";
}
}
else
{
msg = "不能为空";
}
return(isSuccess);//返回界面层是否添加成功
}
