public bool SLogin() { bool flag = false; DbMySqlHelper mySqlHelper = new DbMySqlHelper(); string userString = userName.Text.Trim(); string pwdString = passWord.Text.Trim(); //创建sql try { string sql = string.Format("select * from ec_user where username = '******' and passwd = '{1}'", userString, pwdString); DataTable mysqlData = mySqlHelper.getMySqlRead(sql); if (mysqlData.Rows.Count >= 1) { flag = true; } } catch (Exception ex) { MessageBox.Show("发生异常 " + ex.Message); flag = false; } return(flag); }
public override object ExecuteScalar(IDbConnection connection, string cmdText, IList <IDbDataParameter> parameter) { return(DbMySqlHelper.ExecuteScalar((MySqlConnection)connection, CommandType.Text, cmdText, parameter == null ? null : parameter.Cast <MySqlParameter>().ToArray())); }
public override int ExecuteNonQuery(IDbTransaction trans, string cmdText, IList <IDbDataParameter> parameter) { return(DbMySqlHelper.ExecuteNonQuery(trans as MySqlTransaction, CommandType.Text, cmdText, parameter == null ? null : parameter.Cast <MySqlParameter>().ToArray()).ToInt()); }