Esempio n. 1
0
        public ActionResult BackMoney(string clubid, string str)
        {
            var result  = new ResultInfo(false);
            int clubid1 = int.Parse(clubid);

            try
            {
                using (var db = new ClusDBEntities())
                {
                    var q = db.t_f_activity.FirstOrDefault(m => m.ID == clubid1);
                    q.option3 = "审核完成,待汇报经费";
                    q.option5 = str;
                    if (db.SaveChanges() > 0)
                    {
                        result.IsSucceed = true;
                    }
                    else
                    {
                        result.IsSucceed = false;
                    }
                }
            }
            catch (Exception ex)
            {
                result.IsSucceed = false;
            }
            return(Json(result));
        }
Esempio n. 2
0
        public ActionResult AdminLiPage(string id)
        {
            ClusDBEntities db    = new ClusDBEntities();
            int            pid1  = int.Parse(id);
            var            dataa = (from a in db.t_f_activity
                                    join b in db.t_f_User on a.club_ID equals b.ID
                                    where a.ID == pid1
                                    select new Activity
            {
                acid = a.ID,            //活动ID
                actittle = a.tittle,    //活动主题
                acclub = b.Name,        //社团名称
                clubtime = a.option2,   //活动时间
                clubplace = a.place,    //活动地点
                lastmoney = b.option1,  // 社团剩余经费
                money = a.option1,      //活动经费
                sarttime = a.starttime, //申请时间
                option3 = a.option3,    //活动状态
                clubform = a.ac_form,   //活动内容
            }).First();

            ViewData["acid"]      = dataa.acid;
            ViewData["actittle"]  = dataa.actittle;
            ViewData["acclub"]    = dataa.acclub;
            ViewData["clubtime"]  = dataa.clubtime;
            ViewData["clubplace"] = dataa.clubplace;
            ViewData["lastmoney"] = dataa.lastmoney;
            ViewData["money"]     = dataa.money;
            ViewData["sarttime"]  = dataa.sarttime;
            ViewData["option3"]   = dataa.option3;
            ViewData["clubform"]  = dataa.clubform;
            return(View());
        }
Esempio n. 3
0
        public ActionResult DeleteNews(string id)
        {
            var     db     = new ClusDBEntities();
            decimal newsid = decimal.Parse(id);
            var     q      = db.t_f_news.FirstOrDefault(m => m.ID == newsid);

            q.isDel = true;
            db.SaveChanges();
            var data = from a in db.t_f_news
                       where a.isDel == false
                       orderby a.ID ascending
                       select new NewsCom
            {
                ID       = a.ID,
                EditTime = a.EditTime,
                Title    = a.Title,
                Content  = a.Content,
            };

            return(Json(new GridModel()
            {
                Data = data,
                Total = data.Count()
            }));
        }
Esempio n. 4
0
        public ActionResult NewsContent(string id)
        {
            ClusDBEntities db   = new ClusDBEntities();
            decimal        pid1 = decimal.Parse(id);
            t_f_news       dd   = db.t_f_news.Where(s => s.ID == pid1).First();

            ViewData["did"]     = dd.ID;       //编号
            ViewData["endtime"] = dd.EditTime; //时间
            ViewData["content"] = dd.Content;  //内容
            ViewData["TTitle"]  = dd.Title;    //标题
            return(View());
        }
Esempio n. 5
0
        public ActionResult EditNews(string id)
        {
            ClusDBEntities        db     = new ClusDBEntities();
            List <SelectListItem> recuit = new List <SelectListItem>();
            decimal  newsid = decimal.Parse(id);
            t_f_news dd     = db.t_f_news.Where(s => s.ID == newsid).First();

            ViewData["newsid"]  = dd.ID;       //编号ID
            ViewData["time"]    = dd.EditTime; //时间
            ViewData["title1"]  = dd.Title;    //标题
            ViewData["content"] = dd.Content;  //内容
            return(View());
        }
Esempio n. 6
0
        public ActionResult Index(FormCollection fc)
        {
            //string content = Request.Form["editor"];
            //return View();
            ////var title = SaveTitle(json);

            string data    = Request.Form["title"];
            string content = fc["editor"];

            System.DateTime starttime = new System.DateTime();
            starttime = DateTime.Now;
            if (data == "")
            {
                ViewData["back_news"] = "标题为空,请重新输入";
                return(View());
            }
            else if (content == "")
            {
                ViewData["back_news"] = "内容为空,请重新输入";
                return(View());
            }
            else
            {
                try
                {
                    using (var db = new ClusDBEntities())
                    {
                        var news = new t_f_news()
                        {
                            Title    = data,
                            Content  = content,
                            EditTime = starttime,
                            isDel    = false
                        };
                        db.t_f_news.Add(news);
                        db.SaveChanges();
                        ViewData["back_news"] = "保存成功!";
                        return(View());
                    }
                }
                catch (Exception ex)
                {
                    ViewData["back_news"] = "保存失败";
                    return(View());
                }
            }
        }
Esempio n. 7
0
        public string SaveUMoney(string json)
        {
            var        result      = new ResultInfo(false);
            JsonObject obj         = new JsonObject(json);
            int        clubid      = int.Parse(obj["clubid"].Value.ToString());
            string     factmoney   = obj["factmoney"].Value.ToString();
            string     com_content = obj["com_content"].Value.ToString();

            System.DateTime com_starttime = new System.DateTime();
            com_starttime = DateTime.Now;
            try
            {
                using (var db = new ClusDBEntities())
                {
                    var finance = new t_f_finance()
                    {
                        price   = factmoney,     //消费金额
                        tittle  = com_content,   //文件位置
                        fi_time = com_starttime, //申请时间
                        fi_type = clubid         //活动id
                    };
                    db.t_f_finance.Add(finance);
                    if (db.SaveChanges() > 0)
                    {
                        var q = db.t_f_activity.FirstOrDefault(m => m.ID == clubid);
                        q.option3 = "待转账";
                        if (db.SaveChanges() > 0)
                        {
                            return("success");
                        }
                        else
                        {
                            return("existed");
                        }
                    }
                    else
                    {
                        return("existed");
                    }
                }
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
Esempio n. 8
0
        [HttpPost]//保存new user
        public string SaveActivity(string json)
        {
            JsonObject obj         = new JsonObject(json);
            string     clubtittle  = obj["clubtittle"].Value.ToString();
            string     clubtime    = obj["clubtime"].Value.ToString();
            string     clubplace   = obj["clubplace"].Value.ToString();
            string     cluboption1 = obj["cluboption1"].Value.ToString();
            string     clubform    = obj["clubform"].Value.ToString();

            System.DateTime com_starttime = new System.DateTime();
            com_starttime = DateTime.Now;
            try
            {
                using (var db = new ClusDBEntities())
                {
                    t_f_User user   = Session["user"] as t_f_User;
                    int      userid = user.ID;//社团ID
                    if (userid != null)
                    {
                        var activity = new t_f_activity()
                        {
                            club_ID   = userid,        //社团ID
                            tittle    = clubtittle,    //活动主题
                            option2   = clubtime,      //活动时间
                            place     = clubplace,     //活动地点
                            option1   = cluboption1,   //活动经费
                            ac_form   = clubform,      //活动内容
                            starttime = com_starttime, //申请时间
                            option3   = "审核中……"
                        };
                        db.t_f_activity.Add(activity);
                        db.SaveChanges();
                        return("success");
                    }
                    else
                    {
                        return("existed");
                    }
                }
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
Esempio n. 9
0
        public ActionResult AddMoneyList(string id)
        {
            ClusDBEntities db    = new ClusDBEntities();
            int            pid1  = int.Parse(id);
            var            dataa = (from a in db.t_f_activity
                                    where a.ID == pid1
                                    select new Activity
            {
                acid = a.ID,             //活动ID
                actittle = a.tittle,     //活动主题
                money = a.option1,       //活动经费
            }).First();

            ViewData["acid1"]     = dataa.acid;
            ViewData["actittle1"] = dataa.actittle;
            ViewData["money1"]    = dataa.money;
            return(View());
        }
Esempio n. 10
0
        ////案例
        public ActionResult File_Save(HttpPostedFileBase file_upload)
        {
            //获取文件的类型
            string filename = Path.GetFileName(file_upload.FileName);
            string filetype = System.IO.Path.GetExtension(filename);
            //string filetype = "." + file_upload.ContentType.Split('/')[1];
            //获取文件的路径
            string fileName = file_upload.FileName;

            //判断格式
            if (filetype == ".xlsx" || filetype == ".xlsm" || filetype == ".xltx" || filetype == ".xltm" || filetype == ".xlsb" || filetype == ".xlam")
            {
                //转换只取文件名,去掉路径。
                if (fileName.LastIndexOf("\\") > -1)
                {
                    fileName = fileName.Substring(fileName.LastIndexOf("\\") + 1);
                }
                //保存到相对路径下。
                bool abc = Directory.Exists(Server.MapPath("~/Upload"));
                if (abc == false)
                {
                    Directory.CreateDirectory(Server.MapPath("~/Upload"));
                }
                file_upload.SaveAs(Server.MapPath("~/Upload/" + fileName));
                //以下代码是将路径保存到数据库。
                string FilePath = "../../Upload/" + fileName;
                //插入到数据库
                try
                {
                    using (var db = new ClusDBEntities())
                    {
                        return(Content("1|" + FilePath + "|上传成功!|"));
                    }
                }
                catch (Exception ex)
                {
                    return(Content("0|网络繁忙,请稍后在试!"));
                }
            }
            else
            {
                return(Content("0|请选择Excel格式的文件!"));
            }
        }
Esempio n. 11
0
        public ActionResult EditNews(FormCollection fc)
        {
            //string content = Request.Form["editor"];
            //return View();
            ////var title = SaveTitle(json);
            decimal newsid  = Decimal.Parse(Request.Form["newsid"]);
            string  data    = Request.Form["title"];
            string  content = fc["editor"];

            System.DateTime starttime = new System.DateTime();
            starttime = DateTime.Now;
            if (data == "")
            {
                ViewData["back_news"] = "标题为空,请重新输入";
                return(View());
            }
            else if (content == "")
            {
                ViewData["back_news"] = "内容为空,请重新输入";
                return(View());
            }
            else
            {
                try
                {
                    using (var db = new ClusDBEntities())
                    {
                        var recruit = db.t_f_news.FirstOrDefault(s => s.ID == newsid);
                        recruit.Title    = data;
                        recruit.Content  = content;
                        recruit.EditTime = starttime;
                        db.SaveChanges();
                        ViewData["back_news"] = "保存成功!";
                        return(View());
                    }
                }
                catch (Exception ex)
                {
                    ViewData["back_news"] = "保存失败";
                    return(View());
                }
            }
        }
Esempio n. 12
0
        public string SaveUActivity(string json)
        {
            var        result      = new ResultInfo(false);
            JsonObject obj         = new JsonObject(json);
            int        acid        = int.Parse(obj["clubid"].Value.ToString());
            string     clubtittle  = obj["clubtittle"].Value.ToString();
            string     clubtime    = obj["clubtime"].Value.ToString();
            string     clubplace   = obj["clubplace"].Value.ToString();
            string     cluboption1 = obj["cluboption1"].Value.ToString();
            string     clubform    = obj["clubform"].Value.ToString();

            System.DateTime com_starttime = new System.DateTime();
            com_starttime = DateTime.Now;
            try
            {
                using (var db = new ClusDBEntities())
                {
                    var q = db.t_f_activity.FirstOrDefault(m => m.ID == acid);
                    q.tittle    = clubtittle;    //活动主题
                    q.option2   = clubtime;      //活动时间
                    q.place     = clubplace;     //活动地点
                    q.option1   = cluboption1;   //活动经费
                    q.ac_form   = clubform;      //活动内容
                    q.starttime = com_starttime; //申请时间
                    q.option3   = "审核中……";
                    if (db.SaveChanges() > 0)
                    {
                        return("success");
                    }
                    else
                    {
                        return("existed");
                    }
                }
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
Esempio n. 13
0
 public string LogOn(string handno, string pwd)
 {
     try
     {
         using (var db = new ClusDBEntities())
         {
             var user = db.t_f_User.Where(p => p.HandNo == handno && p.Password == pwd && p.IsDelete == false).FirstOrDefault();
             if (user != null)
             {
                 Session["user"] = user;
                 return("success");
             }
             else
             {
                 return("密码有误!");
             }
         }
     }
     catch (Exception ex)
     {
         return("用户名有误!" + ex.Message);
     }
 }