Example #1
0
 /// <summary>
 /// 修改tuandui信息
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public int UpdateTitle(JiaJiModels.Team model)
 {
     try
     {
         return(new JiaJiDAL.teamdal().UpdateTitle(model));
     }
     catch (Exception ex)
     {
         return(0);
     }
 }
Example #2
0
 /// <summary>
 /// 添加tuandui信息
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public int addTeam(JiaJiModels.Team model)
 {
     try
     {
         return(new JiaJiDAL.teamdal().addTeam(model));
     }
     catch (Exception ex)
     {
         return(0);
     }
 }
Example #3
0
        /// <summary>
        /// 修改tuandui信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdateTeam(JiaJiModels.Team model)
        {
            try
            {
                string sql    = "select TeamID from arearelation where AreaRelaID=" + model.AreaRelaID + "";
                int    teamid = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0]["TeamID"]);
                sql  = "update team set `Name`='" + model.Name + "',`Position`='" + model.Position + "',WorkDate='" + model.WorkDate + "',ShenQing='" + model.ShenQing + "',Image1='" + model.Image1 + "',Image2='" + model.Image2 + "',TeamProduce='" + model.TeamProduce + "',SuccessCount='" + model.SuccessCount + "',SuccessContent='" + model.SuccessContent + "',SuccessKeyWord='" + model.SuccessKeyWord + "',SuccessProfile='" + model.SuccessProfile + "' where TeamID=" + teamid + "; ";
                sql += "update arearelation set TeamID=" + teamid + ",AreaID=" + model.AreaID + " where arearelation.AreaRelaID=" + model.AreaRelaID + "";

                int he = MySqlDB.nonquery(sql, CommandType.Text, null);
                return(he);
            }
            catch (Exception ex)
            {
                return(0);
            }
        }
Example #4
0
        /// <summary>
        /// 添加团队信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int addTeam(JiaJiModels.Team model)
        {
            try
            {
                string sql = "INSERT INTO study_abroad.team (`Name`, `Position`,WorkDate,ShenQing,Image1,Image2,TeamProduce,SuccessCount,SuccessContent,SuccessKeyWord,SuccessProfile) VALUE ('" + model.Name + "','" + model.Position + "','" + model.WorkDate + "','" + model.ShenQing + "','" + model.Image1 + "','" + model.Image2 + "','" + model.TeamProduce + "','" + model.SuccessCount + "','" + model.SuccessContent + "','" + model.SuccessKeyWord + "','" + model.SuccessProfile + "');select @@IDENTITY;";

                int Teamid = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0][0]);

                sql = "insert into arearelation(TeamID, AreaID) values(" + Teamid + "," + model.AreaID + ")";

                int he = MySqlDB.nonquery(sql, CommandType.Text, null);
                return(he);
            }
            catch (Exception ex)
            {
                return(0);
            }
        }
 public JsonResult addTitle(JiaJiModels.Team infor)
 {
     try
     {
         var i = new JiaJiBLL.teambll().InsertTitle(infor);
         if (i > 0)
         {
             return(Json(new { Success = true, Message = "添加成功" }));
         }
         else
         {
             return(Json(new { Success = false, Message = "添加失败" }));
         }
     }
     catch
     {
         return(Json(new { Success = false, Message = "添加失败" }));
     }
 }
Example #6
0
        /// <summary>
        /// 修改团队标题
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdateTitle(JiaJiModels.Team model)
        {
            try
            {
                string sql       = "select * from term_relation where TermRealID=" + model.TermRealID + "";
                int    titleid   = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0][2]);
                int    contentid = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0][3]);

                sql  = "update team_content set Content='" + model.Content + "' where team_content.ContentID=" + contentid + ";";
                sql += " update team_title set TitleName='" + model.TitleName + "' where TeamTitleID=" + titleid + ";  ";
                sql += "update term_relation set term_relation.TeamID=" + model.TeamID + ",term_relation.TeamTitleID=" + titleid + ",term_relation.ContentID=" + contentid + " where term_relation.TermRealID=" + model.TermRealID + "";


                int he = MySqlDB.nonquery(sql, CommandType.Text, null);
                return(he);
            }
            catch (Exception ex)
            {
                return(0);
            }
        }
 public JsonResult addInsertTeam(JiaJiModels.Team infor)
 {
     try
     {
         infor.Image1 = "/image/" + infor.Image1;
         infor.Image2 = "/image/" + infor.Image2;
         var i = new JiaJiBLL.teambll().addTeam(infor);
         if (i > 0)
         {
             return(Json(new { Success = true, Message = "添加成功" }));
         }
         else
         {
             return(Json(new { Success = false, Message = "添加失败" }));
         }
     }
     catch
     {
         return(Json(new { Success = false, Message = "添加失败" }));
     }
 }
        public JsonResult editTitle(JiaJiModels.Team model)
        {
            try
            {
                int id = model.TermRealID;

                var i = new JiaJiBLL.teambll().UpdateTitle(model);
                if (i > 0)
                {
                    return(Json(new { Success = true, Message = "修改成功" }));
                }
                else
                {
                    return(Json(new { Success = false, Message = "修改失败" }));
                }
            }
            catch
            {
                return(Json(new { Success = false, Message = "修改失败" }));
            }
        }