/// <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> /// <returns></returns> public int UpdateAnLi(JiaJiModels.Anli model, int teamid) { try { return(new JiaJiDAL.Anlidal().UpdateAnLi(model, teamid)); } catch (Exception ex) { return(0); } }
/// <summary> /// 成功案例添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Anliadd(JiaJiModels.Anli model, int teamid) { try { return(new JiaJiDAL.Anlidal().Anliadd(model, teamid)); } catch (Exception) { return(0); } }
/// <summary> /// 成功案例添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Anliadd(JiaJiModels.Anli model, int teamid) { try { string sql = "insert into successful(SuccessTitle,SuccessContent,SuccessDate) VALUES('" + model.SuccessTitle + "', '" + model.SuccessContent + "', '" + model.SuccessDate + "');select @@IDENTITY"; int successid = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0][0]); sql = "insert into successful_relation(SuccessID,StudentID) VALUES(" + successid + "," + model.StudentID + ");"; //sql += "insert into team_anli(TeamID,SuccessID) VALUES("+ teamid + "," + successid + ")"; int he = MySqlDB.nonquery(sql, CommandType.Text, null); return(he); } catch (Exception) { return(0); } }