/// <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);
}
}