using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.Data; namespace 人事信息系统 { public class LogInUser { private string _UserID; private string _PassWord; public static string Group; public string UserID//ID属性 { get { _UserID = UserID; } set { _UserID = value; } } public string PassWord//PassWord属性 { get { _PassWord = PassWord; } set { _PassWord = value; } } public LogInUser(string UserID, string PassWord) { this.UserID = UserID; this.PassWord = PassWord; } public LogInUser() { } public int IsUser() { SqlConnection SqlCon = new SqlConnection(); SqlCommand LogInCommand = new SqlCommand(); SqlDataAdapter userAdapter = new SqlDataAdapter(); DataSet UserInfoSet = new DataSet(); try { SqlCon.ConnectionString = "Data Source=.;Initial Catalog=企业人事信息管理;Integrated Security=True"; SqlCon.Open(); LogInCommand.CommandText = "select * from LogInInfo where UserID='" + this.UserID.Trim() + "'"; userAdapter.SelectCommand = LogInCommand; userAdapter.Fill(UserInfoSet, "UserInfo"); if (UserInfoSet == null || UserInfoSet.Tables["UserInfo"].Rows.Count == 0)//数据库中无用户记录 { SqlCon.Close(); return 1; } else { if (!this.UserID.Trim().Equals(UserInfoSet.Tables["UserInfo"].Rows[0]["UserID"].ToString().Trim()))//数据库中无此ID { SqlCon.Close();//关闭连接 return 2;//返回2 } else { if (!this.PassWord.Trim().Equals(UserInfoSet.Tables["UserInfo"].Rows[0]["PassWord"].ToString().Trim())) //密码错误 { SqlCon.Close();//关闭连接 return 3;//返回3 } } } if (this.UserID.Trim().Equals(UserInfoSet.Tables["UserInfo"].Rows[0]["UserID"].ToString().Trim()) && this.PassWord.Trim().Equals(UserInfoSet.Tables["UserInfo"].Rows[0]["PassWord"].ToString().Trim()))//ID和密码都正确 { Group = UserInfoSet.Tables["UserInfo"].Rows[0]["GroupID"].ToString().Trim();//获得权限 SqlCon.Close();//关闭此次连接 return 0;//返回0 } else { SqlCon.Close(); return 4; }//其他不匹配的错误情况返回4 } /*catch(Exception ex) { throw new ApplicationException("SysTem Err"); }*/ finally { } } } } 错误 1 “人事信息系统.LogInUser.UserID.get”: 并非所有的代码路径都返回值 D:/My Documents/人事信息系统/人事信息系统/LogInUser.cs 16 13 人事信息系统