public SYS_MENU GetMenuByCode(string code) { string sql = "select *from sys_menu where Menu_code=@code and Menu_unit is not null"; SqlDataReader reader = SqlHelper_cory.ExecuteReader(sql, CommandType.Text, new SqlParameter("@code", code)); SYS_MENU model = new SYS_MENU(); if (reader.HasRows) { if (reader.Read()) { model.MENU_CODE = reader.GetString(reader.GetOrdinal("MENU_CODE")); model.MENU_NAME = reader.GetString(reader.GetOrdinal("MENU_NAME")); model.MENU_UNIT = reader.GetString(reader.GetOrdinal("MENU_UNIT")); model.PARENT_MENU_CODE = reader.GetString(reader.GetOrdinal("PARENT_MENU_CODE")); } } return(model); }
/// <summary> /// 根据ID返回实体 /// </summary> /// <param name="uid"></param> /// <returns></returns> public SYS_USER CheckUid(string uid) { string sql = "select * from SYS_USER where USER_CODE=@uid"; using (SqlDataReader reader = SqlHelper_cory.ExecuteReader(sql, CommandType.Text, new SqlParameter("@uid", uid))) { SYS_USER model = new SYS_USER(); if (reader.HasRows) { if (reader.Read()) { model.USER_CODE = reader.GetString(reader.GetOrdinal("USER_CODE")); model.PASSWORD = reader.GetString(reader.GetOrdinal("PASSWORD")); model.USER_NAME = reader.GetString(reader.GetOrdinal("USER_NAME")); model.STOCK_CODE = reader.GetString(reader.GetOrdinal("STOCK_CODE")); model.STOCK_NAME = reader.GetString(reader.GetOrdinal("STOCK_NAME")); model.PPRICE_SHOW = reader.GetBoolean(reader.GetOrdinal("PPRICE_SHOW")); model.DEPARTMENT_CODE = reader.GetString(reader.GetOrdinal("DEPARTMENT_CODE")); model.DEPARTMENT_NAME = reader.GetString(reader.GetOrdinal("DEPARTMENT_NAME")); } } return(model); } }