//更新材料信息 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)")); }