//查询用户信息
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);
}
