//更新材料信息
public int UpdateMaterial(Model.Material maters)
{
string sql = "Update [Material] set [State]=0";
if (!string.IsNullOrEmpty(maters.MaterialName))
{
sql += ",[MaterialName]='" + maters.MaterialName + "'";
}
if (!string.IsNullOrEmpty(maters.ImageURL))
{
sql += ",[ImageURl]='" + maters.ImageURL + "'";
}
if (maters.Materialnum > 0)
{
sql += ",[Materialunm]='" + maters.Materialnum + "'";
}
if (maters.MaterialPrice > 0)
{
sql += ",[MaterialPrice]='" + maters.MaterialPrice + "'";
}
if (maters.MaterialTypeID > 0)
{
sql += ",[MaterialTypeID]='" + maters.MaterialTypeID + "'";
}
if (!string.IsNullOrEmpty(maters.Origin))
{
sql += ",[Origin]='" + maters.Origin + "'";
}
if (!string.IsNullOrEmpty(maters.Brand))
{
sql += "'[Brand]=" + maters.Brand + "'";
}
if (!string.IsNullOrEmpty(maters.Model))
{
sql += "'[Model]=" + maters.Model + "'";
}
if (!string.IsNullOrEmpty(maters.specifications))
{
sql += "'[specifications]=" + maters.specifications + "'";
}
if (!string.IsNullOrEmpty(maters.Style))
{
sql += "'[Style]=" + maters.Style + "'";
}
if (maters.PartsTypeID > 0)
{
sql += "'[PartsTypeID]=" + maters.PartsTypeID + "'";
}
if (maters.State > 0)
{
sql += "'[State]=" + maters.State + "'";
}
sql += "where [MaterialID]='" + maters.MaterialID + "'";
return(SQLHelp.ExecQuery(sql));
}
//修改用户信息
public int UpdateMaterUser(Model.MaterUser mater)
{
string sql = "Update [MaterUser] set [Sate]=0";
if (!string.IsNullOrEmpty(mater.UserName))
{
sql += ",[UserName]='" + mater.UserName + "'";
}
if (!string.IsNullOrEmpty(mater.UserAccout))
{
sql += ",[UserAccout]='" + mater.UserAccout + "'";
}
if (!string.IsNullOrEmpty(mater.Password))
{
sql += "'[Password]='" + mater.Password + "'";
}
if (mater.UserBirthday.Year > 1)
{
sql += "'[UserBirthday]='" + mater.UserBirthday + "'";
}
if (!string.IsNullOrEmpty(mater.UserGender))
{
sql += "'[UserGender]='" + mater.UserGender + "'";
}
if (!string.IsNullOrEmpty(mater.Address))
{
sql += "'[Address]='" + mater.Address + "'";
}
if (!string.IsNullOrEmpty(mater.UserRemark))
{
sql += "'[UserRemark]='" + mater.UserRemark + "'";
}
if (mater.State > 0)
{
sql += "'[Sate]='" + mater.State + "'";
}
sql += " where [UserID]='" + mater.UserID + "'";
return(SQLHelp.ExecQuery(sql));
}
//添加电影信息
public int InsertMovies(Model.Movies movies)
{
return(SQLHelp.ExecQuery("insert into [Movies]([MoviesID],[MoviesName],[MoviesNameID],[ReleaseDate],MoviesType],[MoviesLanguage],[MoviesRegion],[MoviesYears],[MoviesDirector],[MoviesActors],[MoviesDesc]) " +
"values('" + movies.MoviesID + "','" + movies.MoviesName + "','" + movies.MoviesNameID + "','" + movies.ReleaseDate + "'+'" + movies.MoviesType + "','" + movies.MoviesLanguage + "','" + movies.MoviesRegion + "','" + movies.MoviesDirector + "','" + movies.MoviesActors + "'," + movies.MoviesDesc + "',0,0)"));
}
//添加材料的数量
public int InsertMaterial(Model.Material material)
{
return(SQLHelp.ExecQuery("insert into [MaterialName],[ImageURL],[Materialunm],[MaterialPrice],[MaterialTypeID],[Origin],[Brand],[Model],[specifications],[Style],[level],[PartsTypeID],[State]) values('"
+ material.MaterialID + "','" + material.MaterialName + "','" + material.ImageURL + "','" + material.Materialnum + "','" + material.MaterialPrice + "','" + material.MaterialTypeID + "','" + material.Origin + "','" + material.Brand +
"','" + material.Model + "','" + material.specifications + "','" + material.Style + "','" + material.level + "','" + material.PartsTypeID + "','" + material.State + "',0,0)"));
}
//删除材料信息
public int DeleteMaterial(string id)
{
return(SQLHelp.ExecQuery("update [Material] set[State]=1 where [MaterialID] in(" + id + ")"));
}
//添加购物车信息
public int InsertShoppCar(Model.ShoppCar shoppcar)
{
return(SQLHelp.ExecQuery("insert into [UserID],[MaterialID],[MaterialNumCar],[State]) values('" + shoppcar.UserID + "','" + shoppcar.MaterialID + "','" + shoppcar.MaterialNumCar + "','" + shoppcar.State + "',0)"));
}
//添加用户信息
public int InserMaterialUser(Model.MaterUser user)
{
return(SQLHelp.ExecQuery("insert into [MaterUser]([UserName],[UserAccout],[Password]) values('"
+ user.UserName + "','" + user.UserAccout + "','" + user.Password + "')"));
}
//添加细分类信息
public int InsertPartsType(Model.PartsType partsType)
{
return(SQLHelp.ExecQuery("insert into [PartsTypeName],[MaterialTypeID],[Sate]) values('" + partsType.PartsTypeName + "','" + partsType.MaterialTypeID + "','" + partsType.State + "',0)"));
}
//添加材料类型信息
public int InsertMaterialType(Model.MaterialType materType)
{
return(SQLHelp.ExecQuery("insert into [TypeName],[Desc],[Sate]) values('" + materType.TypeName + "','" + materType.Desc + "','" + materType.State + "',0)"));
}
public int InsertComments(Model.Comments Comm)
{
return(SQLHelp.ExecQuery("insert into [content],[MaterialID],[UserID],[CommentTime],[praise],[Step],[Sate]) values('" + Comm.content + "','" + Comm.MaterialID + "','" + Comm.UserID + "','" + Comm.CommentTime + "','" + Comm.praise + "','" + Comm.Step + "','" + Comm.State + "',0)"));
}
