public bool Login(Manager_User Manager_User) { str = "select * from E_User where manager_Account=@manager_Account and manager_Pw=@manager_Pw"; SqlParameter[] para = { new SqlParameter("@manager_Account", Manager_User.manager_Account), new SqlParameter("@manager_Pw", Manager_User.manager_Pw) }; if (sql.FillDt_para(str, para).Rows.Count > 0) { return(true); } else { return(false); } }
/// <summary> /// 用户登录 2017/5/13 左县委 /// </summary> /// <param name="username">用户帐号</param> /// <param name="pwd">用户密码</param> /// <returns>登录成功 true</returns> public bool Login(E_User users) { //bool istrue = false; //string strsql = "select user_Pw from E_User where user_Account=@username"; //SqlParameter[] para = { new SqlParameter("@username", users.user_Account) }; //SqlDataReader sr = sql.GetDataReader(strsql, para); ////string uuuu = sr.GetString(0).ToString(); ////SqlDataReader sr = db.GetDataReader(strsql,para); //while (sr.Read()) //{ // if (sr.GetString(0) == users.user_Pw) // { // sr.Close(); // istrue = true; // break; // } // else // { // sr.Close(); // istrue = false; // break; // } //} //sr.Close(); //return istrue; str = "select * from E_User where user_Account=@user_Account and user_Pw=@user_Pw"; SqlParameter[] para = { new SqlParameter("@user_Account", users.user_Account), new SqlParameter("@user_Pw", users.user_Pw) }; if (sql.FillDt_para(str, para).Rows.Count > 0) { return(true); } else { return(false); } }