public static Mouse_2017101992.User_2017101992 GetUser(string name, string pwd) { Mouse_2017101992.User_2017101992 user = null; string sql = "select *from UserDetails where userName=\'" + name + "\' and userPwd=\'" + pwd + "\'"; SqlDataReader reader = DAL.DBOper.GetReader(sql); if (reader.Read()) { user = new Mouse_2017101992.User_2017101992(); user.Name = System.Convert.ToString(reader["userName"]); user.Pwd = System.Convert.ToString(reader["userPwd"]); } reader.Close(); return(user); }
public static bool AddUser(Mouse_2017101992.User_2017101992 user_2017101992) { string sql = "insert into UserDetails values(@name, @pwd,@role)"; //创建参数对象 SqlParameter p1 = new SqlParameter("@name", user_2017101992.Name); SqlParameter p2 = new SqlParameter("@pwd", user_2017101992.Pwd); SqlParameter p3 = new SqlParameter("@role", user_2017101992.Role); //如果添加成功,则返回True if (DAL.DBOper.ExecuteCommmand(sql, p1, p2, p3) == 1) { return(true); } else { return(false); } }