//查询用户信息 public List <Model.MaterUser> user(string whereStr = null, int start = 1, int end = 20) { List <Model.MaterUser> materuser = new List <Model.MaterUser>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from [MaterUser] where [State]=0 " + whereStr); if (dr != null) { Model.MaterUser user = null; while (dr.Read()) { user = new MaterUser(); user.Address = dr["Address"].ToString(); user.Password = dr["Password"].ToString(); user.State = (int)dr["State"]; user.UserAccout = dr["UserAccout"].ToString(); if (!string.IsNullOrEmpty(dr["UserBirthday"].ToString())) { user.UserBirthday = (DateTime)dr["UserBirthday"]; } user.UserGender = dr["UserGender"].ToString(); user.UserID = dr["UserID"] as string; user.UserName = dr["UserName"].ToString(); user.UserRemark = dr["UserRemark"].ToString(); materuser.Add(user); } dr.Close(); SQLHelp.CloseConnection(); } } return(materuser); }
//查询材料信息 public List <Model.Material> Getmaterial(string whereStr = null, int start = 1, int end = 20) { List <Model.Material> mater = new List <Model.Material>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from [Material] where [State]=0 " + whereStr); if (dr != null) { while (dr.Read()) { mater.Add(new Model.Material() { MaterialID = (int)dr["MaterialID"], MaterialName = dr["MaterialName"].ToString(), ImageURL = dr["ImageURL"].ToString(), Materialnum = (int)dr["Materialnum"], MaterialPrice = (decimal)dr["MaterialPrice"], MaterialTypeID = (int)dr["MaterialTypeID"], Origin = dr["Origin"].ToString(), Brand = dr["Brand"].ToString(), Model = dr["Model"].ToString(), specifications = dr["specifications"].ToString(), Style = dr["Style"].ToString(), level = dr["level"].ToString(), PartsTypeID = (int)dr["PartsTypeID"], State = (int)dr["State"], }); } SQLHelp.CloseConnection(); } } return(mater); }
public List <Model.ShoppCar> GetShoppCar(string where = null) { List <Model.ShoppCar> shoppCar = new List <ShoppCar>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select MaterialName,MaterialPrice from Material where Materialnum='50' order by MaterialPrice asc" + where); if (dr != null) { while (dr.Read()) { shoppCar.Add(new ShoppCar() { ID = (int)dr["ID"], UserID = (int)dr["UserID"], MaterialID = (int)dr["MaterialID"], MaterialNumCar = (int)dr["MaterialNumCar"], State = (int)dr["State"], }); dr.Close(); SQLHelp.CloseConnection(); } } } return(shoppCar); }
public List <Model.PartsType> GetPartsType(string where = null) { List <Model.PartsType> partsType = new List <PartsType>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from [PartsType] where [Sate]=0" + where); if (dr != null) { while (dr.Read()) { partsType.Add(new PartsType() { PartsTypeID = (int)dr["PartsTypeID"], PartsTypeName = dr["PartsTypeName"].ToString(), MaterialTypeID = (int)dr["MaterialTypeID"], State = (int)dr["State"], }); dr.Close(); SQLHelp.CloseConnection(); } } } return(partsType); }
//查询材料类型信息 public List <Model.MaterialType> GetMaterialType(string where = null) { List <Model.MaterialType> materialType = new List <MaterialType>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select mater.* from Material mater left join MaterialType t on mater.MaterialTypeID=t.MaterialTypeID" + where); if (dr != null) { while (dr.Read()) { materialType.Add(new MaterialType() { MaterialTypeID = (int)dr["MaterialTypeID"], TypeName = dr["TypeName"].ToString(), Desc = dr["Desc"].ToString(), State = (int)dr["Sate"], }); dr.Close(); SQLHelp.CloseConnection(); } } } return(materialType); }
public List <Model.Comments> GetComment(string where = null) { List <Model.Comments> comment = new List <Comments>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from [Comments] where [Sate]=0" + where); if (dr != null) { while (dr.Read()) { comment.Add(new Comments() { CommentsID = (int)dr["CommentsID"], content = dr["content"].ToString(), MaterialID = (int)dr["MaterialID"], UserID = (int)dr["UserID"], CommentTime = (DateTime)dr["CommentTime"], praise = (int)dr["praise"], Step = (int)dr["Step"], State = (int)dr["Sate"], }); } dr.Close(); SQLHelp.CloseConnection(); } } return(comment); }
/// <summary> /// 查询电影表 /// </summary> /// <param name="where"></param> /// <returns></returns> /// #region //public List<Model.Movies> GetMovies(string where = null) //{ // List<Model.Movies> movies = new List<Model.Movies>(); // if (SQLHelp.OpenConnection()) // { // SqlDataReader dr = SQLHelp.ExecReader("select * from [Movies] where [MoviesID]=0 " + where); // if (dr != null) // { // while (dr.Read()) // movies.Add(new Model.Movies((int)dr["MoviesID"], dr["MoviesName"] as string, // (int)dr["ReleaseDate"], (int)dr["MoviesType"], (int)dr["MoviesLanguage"], // (int)dr["MoviesRegion"], (int)dr["MoviesYears"], dr["MoviesDirector"] as string, // dr["MoviesActors"] as string, dr["MoviesDesc"] as string)); // } // dr.Close(); // SQLHelp.CloseConnection(); // } // return movies; //} #endregion public List <Model.Movies> GetMovies(string whereStr = null, int start = 1, int end = 20) { List <Model.Movies> movies = new List <Model.Movies>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from Movies"); if (dr != null) { while (dr.Read()) { movies.Add(new Model.Movies { MoviesID = (int)dr["MoviesID"], MoviesName = dr["MoviesName"] as string, MoviesNameID = dr["MoviesNameID"] as string, ReleaseDate = (int)dr["ReleaseDate"], MoviesType = (int)dr["MoviesType"], MoviesLanguage = (int)dr["MoviesLanguafe"], MoviesRegion = (int)dr["MoviesRegion"], MoviesYears = (int)dr["MoviesYears"], MoviesDirector = dr["MoviesDirector"] as string, MoviesActors = dr["MoviesActors"] as string, MoviesDesc = dr["MoviesDesc"] as string }); } } dr.Close(); SQLHelp.CloseConnection(); } return(movies); }
public List <Model.User> GetUser() { List <Model.User> user = new List <Model.User>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from User"); if (dr != null) { while (dr.Read()) { user.Add(new Model.User { UserID = (int)dr["UserID"], UserName = dr["UserName"] as string, UserNumber = dr["UserNumber"] as string, Password = dr["Password"] as string, Mailbox = dr["Mailbox"] as string, Gender = dr["Gender"] as string }); } } dr.Close(); SQLHelp.CloseConnection(); } return(user); }
/// <summary> /// 查询电影地区表 /// </summary> /// <param name="where"></param> /// <returns></returns> /// #region //public List<Model.MoviesRegion> GetMoviesRegion(string where = null) //{ // List<Model.MoviesRegion> moviesregion = new List<Model.MoviesRegion>(); // if (SQLHelp.OpenConnection()) // { // SqlDataReader dr = SQLHelp.ExecReader("select * from [MoviesRegion] where [MoviesRegionID]=0 " + where); // if (dr != null) // { // while (dr.Read()) // moviesregion.Add(new Model.MoviesRegion((int)dr["MoviesRegionID"], dr["MoviesRegionName"] as string)); // } // dr.Close(); // SQLHelp.CloseConnection(); // } // return moviesregion; //} #endregion public List <Model.MoviesRegion> GetMoviesRegion() { List <Model.MoviesRegion> moviesregion = new List <Model.MoviesRegion>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from MoviesRegion"); if (dr != null) { while (dr.Read()) { moviesregion.Add(new Model.MoviesRegion { MoviesRegionID = (int)dr["MoviesRegionID"], MoviesRegionName = dr["MoviesRegionName"] as string }); } } dr.Close(); SQLHelp.CloseConnection(); } return(moviesregion); }
public List <Model.MoviesYears> GetMoviesYears() { List <Model.MoviesYears> moviesyears = new List <Model.MoviesYears>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from MoviesYears"); if (dr != null) { while (dr.Read()) { moviesyears.Add(new Model.MoviesYears { MoviesYearsID = (int)dr["MoviesYearsID"], MoviesYearsName = dr["MoviesYearsName"] as string }); } } dr.Close(); SQLHelp.CloseConnection(); } return(moviesyears); }
/// <summary> /// 方法:查询电影年份 /// </summary> /// <param name="where"></param> /// <returns></returns> /// #region public List <Model.MoviesYears> GetMoviesYears(string where = null) { List <Model.MoviesYears> moviesyears = new List <Model.MoviesYears>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from [MoviesYears] where [MoviesYearsID]=0 " + where); if (dr != null) { while (dr.Read()) { moviesyears.Add(new Model.MoviesYears((int)dr["MoviesYearsID"], dr["MoviesYearsName"] as string)); } } dr.Close(); SQLHelp.CloseConnection(); } return(moviesyears); }
/// <summary> /// 查询音乐表 /// </summary> /// <param name="where"></param> /// <returns></returns> /// #region //public List<Model.Music> GetMusic(string where = null) //{ // List<Model.Music> music = new List<Model.Music>(); // if (SQLHelp.OpenConnection()) // { // SqlDataReader dr = SQLHelp.ExecReader("select * from [Music] where [Music]=0 " + where); // if (dr != null) // { // while (dr.Read()) // music.Add(new Model.Music((int)dr["MusicID"], dr["MusicName"] as string, dr["MusicSinger"] as string, (int)dr["MusicType"], (int)dr["FormatNames"])); // } // dr.Close(); // SQLHelp.CloseConnection(); // } // return music; //} #endregion public List <Model.Music> GetMusic() { List <Model.Music> music = new List <Model.Music>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from view_Music"); if (dr != null) { while (dr.Read()) { music.Add(new Model.Music { MusicID = (int)dr["MusicID"], MusicName = dr["MusicName"] as string, MusicSinger = dr["MusicSinger"] as string, MusicType = (int)dr["MusicType"], FormatNames = (int)dr["FormatName"] }); } } dr.Close(); SQLHelp.CloseConnection(); } return(music); }
/// <summary> /// 查询音乐格式 /// </summary> /// <param name="where"></param> /// <returns></returns> /// #region //public List<Model.FormatTable> GetFormatTable(string where = null) //{ // List<Model.FormatTable> formattable = new List<Model.FormatTable>(); // if (SQLHelp.OpenConnection()) // { // SqlDataReader dr = SQLHelp.ExecReader("select * from [FormatTableDAL] where [FormatID]=0" + where); // if (dr != null) // { // while (dr.Read()) // formattable.Add(new Model.FormatTable((int)dr["FormatID"],dr["FormatName"] as string)); // } // dr.Close(); // SQLHelp.CloseConnection(); // } // return formattable; //} #endregion public List <Model.FormatTable> GetFormatTable() { List <Model.FormatTable> formattable = new List <Model.FormatTable>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from FormatTable"); if (dr != null) { while (dr.Read()) { formattable.Add(new Model.FormatTable { FormatID = (int)dr["FormatID"], FormatName = dr["FormatName"] as string }); } } dr.Close(); SQLHelp.CloseConnection(); } return(formattable); }
/// <summary> /// 查询电影语言表 /// </summary> /// <param name="where"></param> /// <returns></returns> /// #region //public List<Model.MoviesLanguage> GetMoviesLanguage(string where = null) //{ // List<Model.MoviesLanguage> movieslanguage = new List<Model.MoviesLanguage>(); // if (SQLHelp.OpenConnection()) // { // SqlDataReader dr = SQLHelp.ExecReader("select * from [MoviesLanguage] where [MoviesLanguageID]=0 " + where); // if (dr != null) // { // while (dr.Read()) // movieslanguage.Add(new Model.MoviesLanguage((int)dr["MovieLanguageID"], dr["MoviesLanguageName"] as string)); // } // dr.Close(); // SQLHelp.CloseConnection(); // } // return movieslanguage; //} #endregion public List <Model.MoviesLanguage> GetMoviesLanguage() { List <Model.MoviesLanguage> list = new List <Model.MoviesLanguage>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from MoviesLanguage"); if (dr != null) { while (dr.Read()) { list.Add(new Model.MoviesLanguage { MoviesLanguageID = (int)dr["MoviesLanguageID"], MoviesLanguageName = dr["MoviesLanguageName"] as string }); } } dr.Close(); SQLHelp.CloseConnection(); } return(list); }
/// <summary> /// 音乐类型表 /// </summary> /// <param name="where"></param> /// <returns></returns> /// #region //public List<Model.MusicType> GetMusicType(string where = null) //{ // List<Model.MusicType> musictype = new List<Model.MusicType>(); // if (SQLHelp.OpenConnection()) // { // SqlDataReader dr = SQLHelp.ExecReader("select * from [MusicType] where [MusicTypeID]=0 " + where); // if (dr != null) // { // while (dr.Read()) // musictype.Add(new Model.MusicType((int)dr["MusicTypeID"], dr["MusicTypeName"] as string)); // } // dr.Close(); // SQLHelp.CloseConnection(); // } // return musictype; //} #endregion public List <Model.MusicType> GetMusicType() { List <Model.MusicType> musictype = new List <Model.MusicType>(); if (SQLHelp.OpenConnection()) { SqlDataReader dr = SQLHelp.ExecReader("select * from MusicType"); if (dr != null) { while (dr.Read()) { musictype.Add(new Model.MusicType { MusicTypeID = (int)dr["MusicTypeID"], MusicTypeName = dr["MusicTypeName"] as string }); } } dr.Close(); SQLHelp.CloseConnection(); } return(musictype); }