/// <summary> /// 添加团队 /// </summary> /// <param name="t"></param> /// <returns></returns> public bool InsertTeam(Team t) { try { string sql = "insert into team (Name,Position,WorkDate,ShenQing,Image1,Image2,TeamProduce) values(?name,?position,?workdate,?shenqing,?image1,?image2,?TeamProduce)"; MySqlParameter[] pars = { new MySqlParameter("?name", t.Name), new MySqlParameter("?position", t.Position), new MySqlParameter("?workdate", t.WorkDate), new MySqlParameter("?shenqing", t.ShenQing), new MySqlParameter("?image1", t.Image1), new MySqlParameter("?image2", t.Image2), new MySqlParameter("?TeamProduce", t.TeamProduce) }; MySqlDB.nonquery(sql, CommandType.Text, pars); string sql2 = "select TeamID from team ORDER BY TeamID desc LIMIT 1"; int teamid = MySqlDB.scalar(sql2, CommandType.Text, null); string sql3 = "insert into arearelation (TeamID,AreaID) values(?teamid,?areaid)"; MySqlParameter[] pars3 = { new MySqlParameter("?teamid", teamid), new MySqlParameter("?areaid", t.AreaID) }; MySqlDB.nonquery(sql3, CommandType.Text, pars3); return(true); } catch (Exception ex) { return(false); } }
/// <summary> /// 删除团队信息 /// </summary> /// <param name="did"></param> /// <returns></returns> public bool DelTeamInfo(string ids) { try { string sql = "select TeamID from arearelation where AreaRelaID in (" + ids + ") "; //string sql = "select * from team where TeamID in (" + TeamID + "); "; string teamids = ""; var dt = MySqlDB.GetDataTable(sql, CommandType.Text, null); for (int i = 0; i < dt.Rows.Count; i++) { teamids += dt.Rows[i][0].ToString() + ","; } teamids = teamids.TrimEnd(','); sql = "delete from term_relation where TeamID in (" + teamids + ");"; sql += "delete from team where TeamID in (" + teamids + ");"; sql += "DELETE from arearelation where AreaRelaID in (" + teamids + ");"; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 添加学生信息和学生团队关系表 /// </summary> /// <returns></returns> public int stuadd(JiaJiModels.student stu) { try { string sql = "insert into student(StudentName,Score,Image,JiuDuXueyuan,EducationID) VALUES(?studentname,?score,?image,?jiuduxueyuan,?educationid)"; MySqlParameter[] pars = { new MySqlParameter("?studentname", stu.StudentName), new MySqlParameter("?score", stu.Score), new MySqlParameter("?image", stu.Image), new MySqlParameter("?jiuduxueyuan", stu.JiuDuXueyuan), new MySqlParameter("?educationid", stu.EducationID) }; MySqlDB.nonquery(sql, CommandType.Text, pars); string stusql = "select StudentID from student ORDER BY StudentID DESC limit 1"; DataTable dt = MySqlDB.GetDataTable(stusql, CommandType.Text, null); int stid = Convert.ToInt32(dt.Rows[0]["StudentID"]); string slq = "insert into teamrelation(TeamID,StudentID) VALUES(?teamid,?studentid)"; MySqlParameter[] parss = { new MySqlParameter("?teamid", stu.teamid), new MySqlParameter("?studentid", stid) }; MySqlDB.nonquery(slq, CommandType.Text, parss); return(1); } catch (Exception ex) { return(0); } }
/// <summary> /// 删除课程 /// </summary> /// <param name="did"></param> /// <returns></returns> public bool DelCourse(string did) { try { //首先在关系中查出该选中关系的编号 string sql = "select* from languagerelation where LRelationID in (" + did + ") "; //获取选中关系编号对应的课程编号 string courseids = ""; var dt = MySqlDB.GetDataTable(sql, CommandType.Text, null); for (int i = 0; i < dt.Rows.Count; i++) { courseids += dt.Rows[i][2].ToString() + ","; } courseids = courseids.TrimEnd(','); //删除选中的关系编号 sql = "delete from languagerelation where LRelationID in (" + did + ");"; //删除课程表中相对应的课程 sql += "delete from course where CourseID in (" + courseids + ")"; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 根据根节点删除所有子节点 /// </summary> /// <param name="RootID"></param> /// <returns></returns> public bool DeleteByRootID(int RootID) { bool res = false; try { string Navid = RootID.ToString() + ","; List <NavInfo> list = GetAllChild(RootID); for (int i = 0; i < list.Count; i++) { Navid += list[i].NavID + ","; } Navid = Navid.Substring(0, Navid.Length - 1); string sql = "delete from navinfo where NavID in (" + Navid + ")"; int n = MySqlDB.nonquery(sql, CommandType.Text, null); if (n > 0) { res = true; } } catch (Exception ex) { throw ex; } return(res); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool EditByModelContent(NavInfo model) { bool res = false; try { string sql = "update NavInfo set NavTitleOne=@NavTitleOne,NavCreateBy=@NavCreateBy,NavTitleTwo=@NavTitleTwo,NavContentTwo=@NavContentTwo,GuoJia=@GuoJia,BuWei=@BuWei,PaiXu=@PaiXu,depth=@depth,LinkFor=@LinkFor,KeyWord=@KeyWord where NavID=@NavID"; MySqlParameter[] para = { new MySqlParameter("@NavID", model.NavID), new MySqlParameter("@NavTitleOne", model.NavTitleOne), new MySqlParameter("@NavCreateBy", model.NavCreateBy), new MySqlParameter("@NavTitleTwo", model.NavTitleTwo), new MySqlParameter("@NavContentTwo", model.NavContentTwo), new MySqlParameter("@GuoJia", model.GuoJia), new MySqlParameter("@BuWei", model.BuWei), new MySqlParameter("@PaiXu", model.PaiXu), new MySqlParameter("@depth", model.depth), new MySqlParameter("@LinkFor", model.LinkFor), new MySqlParameter("@KeyWord", model.KeyWord) }; int n = MySqlDB.nonquery(sql, CommandType.Text, para); if (n > 0) { res = true; } } catch (Exception ex) { throw ex; } return(res); }
/// <summary> /// 修改成功案例 /// </summary> /// <returns></returns> public int UpdateAnLi(JiaJiModels.Anli model, int teamid) { try { //查出关系表中的内容 string sql = "select * from successful_relation where SRelationID=" + model.SRelationID + ""; int successid = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0][1]); string teamidsql = "select count(1) from team_anli where SuccessID=" + successid + " "; int countteam = MySqlDB.scalar(teamidsql, CommandType.Text, null); sql = "update successful set SuccessTitle='" + model.SuccessTitle + "',SuccessContent='" + model.SuccessContent + "',SuccessDate='" + model.SuccessDate + "' where SuccessID=" + successid + "; "; if (countteam > 0) { sql += "update team_anli set team_anli.TeamID=" + teamid + " where SuccessID=" + successid + ";"; } else { sql += "insert into team_anli(TeamID,SuccessID) VALUES(" + teamid + "," + successid + ");"; } sql += "update successful_relation set StudentID=" + model.StudentID + " where SuccessID=" + successid + " "; int he = MySqlDB.nonquery(sql, CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 留学规划类别 /// </summary> /// <param name="type"></param> /// <returns></returns> public int ProgramType(JiaJiModels.ApplyModel.StudentProgramType type) { string sql = "insert into StudentProgramType(TypeName)values(@Name)"; MySqlParameter[] para = { new MySqlParameter("@Name", type.TypeName) }; return(MySqlDB.nonquery(sql, System.Data.CommandType.Text, para)); }
/// <summary> /// 留学材料 /// </summary> /// <param name="Con"></param> /// <returns></returns> public int ArrangeCondition(JiaJiModels.ApplyModel.ApplyCondition Con) { string sql = "insert into applycondition(ApplyTitle,ApplyContent)values(@Title,@Content)"; MySqlParameter[] para = { new MySqlParameter("@Title", Con.ApplyTitle), new MySqlParameter("@Content", Con.ApplyContent) }; return(MySqlDB.nonquery(sql, System.Data.CommandType.Text, para)); }
/// <summary> /// 解决方案修改 /// </summary> /// <param name="sol"></param> /// <returns></returns> public int UpdSolu(JiaJiModels.solution sol) { try { string sql = "update solution set SolutionTitle='" + sol.SolutionTitle + "' where SolutionID=" + sol.SolutionID + ""; return(MySqlDB.nonquery(sql, CommandType.Text, null)); } catch (Exception ex) { return(0); } }
/// <summary> /// 添加学员分享 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddShare(JiaJiModels.ShareModel model) { try { string sql = "insert into shares(ShareTitle,ShareContent,LearnerID,ShareDate,Pro_ID,ShareImg,ShareKeyword,ShareProfile,ShareReadCount) values('" + model.ShareTitle + "','" + model.ShareContent + "'," + model.LearnerID + ",'" + model.ShareDate + "'," + model.Pro_ID + ",'" + model.ShareImg + "','" + model.ShareKeyword + "','" + model.ShareProfile + "',0)"; return(MySqlDB.nonquery(sql, System.Data.CommandType.Text, null)); } catch (Exception ex) { return(0); } }
/// <summary> /// 修改学员分享 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateShare(JiaJiModels.ShareModel model) { try { string sql = "Update shares set ShareTitle='" + model.ShareTitle + "',ShareContent='" + model.ShareContent + "',LearnerID=" + model.LearnerID + ",ShareDate='" + model.ShareDate + "',Pro_ID=" + model.Pro_ID + ",ShareImg='" + model.ShareImg + "',ShareKeyword='" + model.ShareKeyword + "',ShareProfile='" + model.ShareProfile + "' where ShareID=" + model.ShareID + ""; return(MySqlDB.nonquery(sql, System.Data.CommandType.Text, null)); } catch (Exception ex) { return(0); } }
/// <summary> /// 语言添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public int LanguageAdd(JiaJiModels.LearnerModel model) { string sql = "insert into languages(LanguageName,LanguageTitle,LanguageContent)value(@Name,@Title,@Content)"; MySqlParameter[] para = { new MySqlParameter("@Name", model.LanguageName), new MySqlParameter("@TItle", model.LanguageTitle), new MySqlParameter("@Content", model.LanguageContent) }; return(MySqlDB.nonquery(sql, System.Data.CommandType.Text, para)); }
/// <summary> /// 解决方案添加 /// </summary> /// <param name="sol"></param> /// <returns></returns> public int soladd(JiaJiModels.solution sol) { try { string sql = "insert into solution(SolutionTitle) VALUES('" + sol.SolutionTitle + "')"; return(MySqlDB.nonquery(sql, CommandType.Text, null)); } catch (Exception ex) { return(0); } }
/// <summary> /// 删除策略信息 /// </summary> /// <param name="did"></param> /// <returns></returns> public bool DelStrategy(string StrategyID) { try { string sql = "delete from strategy where StrategyID in (" + StrategyID + ")"; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 添加语言培训 /// </summary> /// <param name="model"></param> /// <returns></returns> public int addLanguagePeiXun(JiaJiModels.Language_PeiXun model) { try { string sql = "insert into language_peixun(Language_Name,Language_Content) values('" + model.Language_Name + "','" + model.Language_Content + "')"; int he = MySqlDB.nonquery(sql, CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 删除语言培训 /// </summary> /// <param name="did"></param> /// <returns></returns> public bool DelLanguagePeiXun(string did) { try { string sql = "delete from language_peixun where LanguagePx_ID in (" + did + "); "; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 修改活动 /// </summary> /// <returns></returns> public int ActiveUpd(JiaJiModels.Active model) { try { string sql = "update active set ActiveTitle = '" + model.ActiveTitle + "', ActiveDate = '" + model.ActiveDate + "', Site =" + model.Site + ", Datails = '" + model.Datails + "', ActivePhone = '" + model.ActivePhone + "', CountryID=" + model.CountryID + ",ActiveKeyWord='" + model.ActiveKeyWord + "',ActiveProfile='" + model.ActiveProfile + "' where ActiveID =" + model.ActiveID + " "; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h); } catch (Exception ex) { return(0); } }
/// <summary> /// 删除活动信息 /// </summary> /// <param name="did"></param> /// <returns></returns> public bool actionDel(string ids) { try { string sql = "DELETE from active where ActiveID in (" + ids + ")"; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 修改课程 /// </summary> /// <returns></returns> public int UpdateDominant(JiaJiModels.DominantModel model) { try { string sql = "update dominant set DominantName='" + model.DominantName + "',CountryID=" + model.CountryID + " where DominantID=" + model.DominantID + ""; int he = MySqlDB.nonquery(sql, CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 修改学员列表 /// </summary> /// <returns></returns> public int UpdateLearner(JiaJiModels.LearnerModel model) { try { string sql = "Update study_abroad.learner set LearnName = '" + model.LearnName + "', Phone = '" + model.Phone + "', GoTime = '" + model.GoTime + "', `LearnImage`= '" + model.LearnImage + "', CountryID = " + model.CountryID + " where LearnerID =" + model.LearnerID + " "; int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 添加学员列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public int addLearner(JiaJiModels.LearnerModel model) { try { string sql = "INSERT INTO study_abroad.learner (LearnName,Phone, GoTime, LearnImage,CountryID)VALUES ('" + model.LearnName + "','" + model.Phone + "','" + model.GoTime + "','" + model.LearnImage + "'," + model.CountryID + ")"; int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 修改高分学员列表 /// </summary> /// <returns></returns> public int UpdateMaxScoStu(JiaJiModels.LearnerModel model) { try { string sql = "Update study_abroad.learnsorce set LearnerID = " + model.LearnerID + ", LanguageID = " + model.LanguageID + ", Sorce = '" + model.Sorce + "', `LearnerGonsis`= '" + model.LearnerGonsis + "',LearnerContent='" + model.LearnerContent + "' where LearnSorceID =" + model.LearnSorceID + " "; int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 删除高分学员列表 /// </summary> /// <param name="did"></param> /// <returns></returns> public bool DelMaxScoStu(string did) { try { string sql = "delete from learnsorce where LearnSorceID in (" + did + ")"; int h = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 添加高分学员列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public int addMaxScoStu(JiaJiModels.LearnerModel model) { try { string sql = "insert into learnsorce(LearnerID,LanguageID,Sorce,LearnerGonsis,LearnerContent,HeatHot) VALUES(" + model.LearnerID + "," + model.LanguageID + ",'" + model.Sorce + "','" + model.LearnerGonsis + "','" + model.LearnerContent + "',0)"; int he = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 删除学员分享 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool DeleteShare(string shareids) { try { string sql = "delete form shares where ShareID=" + shareids + ""; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 修改攻略信息 /// </summary> /// <param name="stat"></param> /// <returns></returns> public int Updatestrategy(JiaJiModels.strategy stat) { try { string sql = "update strategy set strategyTitle = '" + stat.StrategyTitle + "',strategyContent = '" + stat.StrategyContent + "',strategyDate = '" + stat.StrategyDate + "',CountryID =" + stat.CountryID + ",Img = '" + stat.Img + "',StrategyProfile='" + stat.StrategyProfile + "',StrategyKeyWord='" + stat.StrategyKeyWord + "',StrategyAuthor='" + stat.StrategyAuthor + "' where StrategyID =" + stat.StrategyID + " "; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h); } catch (Exception ex) { return(0); } }
/// <summary> /// 添加优势 /// </summary> /// <param name="model"></param> /// <returns></returns> public int addDominant(JiaJiModels.DominantModel model) { try { string sql = "insert into dominant(DominantName,CountryID) VALUE('" + model.DominantName + "'," + model.CountryID + ") "; int he = MySqlDB.nonquery(sql, CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 删除嘉际观点 /// </summary> /// <param name="did"></param> /// <returns></returns> public bool DelOptions(string optionid) { try { string sql = "delete from optioninfo where OptionID in (" + optionid + ")"; int h = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null); return(h > 0); } catch (Exception ex) { return(false); } }
/// <summary> /// 修改语言培训 /// </summary> /// <returns></returns> public int UpdateLanguagePeiXun(JiaJiModels.Language_PeiXun model) { try { string sql = "UPDATE language_peixun set Language_Name='" + model.Language_Name + "',Language_Content='" + model.Language_Content + "' where LanguagePx_ID=" + model.LanguagePx_ID + ""; int he = MySqlDB.nonquery(sql, CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }