/// <summary> /// /// </summary> /// <param name="GUID"> </param> /// <returns></returns> public static Entity.User GetUser(string GUID) { Entity.User entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [User] where GUID='" + GUID + "'", null); while (dataReader.Read()) { entity = new Entity.User(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.UserName = dataReader["UserName"].ToString(); entity.PassWord = dataReader["PassWord"].ToString(); entity.GUID = dataReader["GUID"].ToString(); entity.Department = dataReader["Department"].ToString(); entity.RealName = dataReader["RealName"].ToString(); entity.PwdChgDate = DataHelper.ParseToDate(dataReader["PwdChgDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); entity.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
public IList <Entity.User> select(Entity.User user) { //throw new NotImplementedException(); IList <Entity.User> Luser; string sql; //条件:实体没有传过来参数 if (user.UserID == null) { SqlParameter[] sqlparams = //new SqlParameter ("@userID",user.UserID ), { new SqlParameter("@lever", "管理员"), new SqlParameter("@lever2", "操作员") }; sql = "select * from user_info where level=@lever or level=@lever2 "; DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text, sqlparams); Luser = DAL.CovertHelper <Entity.User> .ConvertToModel(table); } //条件:实体传递过来参数的时候 else { SqlParameter[] sqlparamsB = { new SqlParameter("@userID", user.UserID), new SqlParameter("@lever", "管理员"), new SqlParameter("@lever2", "操作员") }; sql = "select * from user_info where userID=@userID"; DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text, sqlparamsB); Luser = DAL.CovertHelper <Entity.User> .ConvertToModel(table); } //DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text, sqlparams); //IList<Entity.User> Luser = DAL.CovertHelper<Entity.User>.ConvertToModel(table); return(Luser); }
public bool IdelUser(Entity.User user) { //throw new NotImplementedException(); SqlParameter[] para = { new SqlParameter("@userid", user.UserID) }; string sql = "delete from user_info where userID =@userid"; return(sqlhelper.ExecuteNonquery(sql, CommandType.Text, para)); }
public bool IaddUser(Entity.User user) { //throw new NotImplementedException(); SqlParameter[] para = { new SqlParameter("@userid", user.UserID), new SqlParameter("@username", user.UserName), new SqlParameter("@password", user.PassWord), new SqlParameter("@level", user.Level), new SqlParameter("@head", user.Head) }; string sql = "insert into user_info values(@userid,@username,@password,@level,@head)"; return(sqlhelper.ExecuteNonquery(sql, CommandType.Text, para)); }
public IList <Entity.User> SelectUser(Entity.User UserInfo) { SqlParameter[] sqlParams = { new SqlParameter("@userID", UserInfo.UserID), new SqlParameter("@pwd", UserInfo.PassWord) }; //SqlParameter[] sqlParams = { new SqlParameter("@userID", UserInfo.UserID) }; string sql = "select * from User_info where UserID=@userID and PassWord=@pwd"; //string sql = @"select * from User_info where UserID=@userID"; DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text, sqlParams); IList <Entity.User> user = DAL.CovertHelper <Entity.User> .ConvertToModel(table); return(user); //return table; }
/// <summary> /// /// </summary> /// <returns></returns> public static List <Entity.User> GetAllUser() { List <Entity.User> list = new List <Entity.User>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_User_GetAll", prams); while (dataReader.Read()) { Entity.User entity = new Entity.User(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.UserName = dataReader["UserName"].ToString(); entity.PassWord = dataReader["PassWord"].ToString(); entity.GUID = dataReader["GUID"].ToString(); //entity.AreaCode = dataReader["AreaCode"].ToString(); //entity.AreaInCharge = dataReader["AreaInCharge"].ToString(); entity.RealName = dataReader["RealName"].ToString(); entity.PwdChgDate = DataHelper.ParseToDate(dataReader["PwdChgDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); entity.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }