Пример #1
0
        public ActionResult Edit([Bind(Include = "Id,Title,Imag,Introduction")] PopSciinManger popSciinManger)
        {
            string             result   = "";
            string             getimage = popSciinManger.Imag;//将读出来的图片url先传给getimage
            HttpPostedFileBase files    = Request.Files["filename"];
            //docManger.File = Request.Files["filename"];

            string fileName = files.FileName;

            //Console.WriteLine(fileName);
            if (fileName == "")
            {
                popSciinManger.Imag = getimage;//如果getimage值是空的,就将原来的值还给Imag
            }
            else
            {
                string fileFormat  = fileName.Split('.')[fileName.Split('.').Length - 1]; // 以“.”截取,获取“.”后面的文件后缀
                Regex  imageFormat = new Regex(@"^(bmp)|(png)|(gif)|(jpg)|(jpeg)");       // 验证文件后缀的表达式(这段可以限制上传文件类型)
                Console.WriteLine(Server.MapPath("~/"));

                if (string.IsNullOrEmpty(fileName) || !imageFormat.IsMatch(fileFormat)) // 验证后缀,判断文件是否是所要上传的格式
                {
                    result = "error";
                }
                else
                {
                    string timeStamp     = DateTime.Now.Ticks.ToString();                       // 获取当前时间的string类型
                    string firstFileName = timeStamp.Substring(0, timeStamp.Length - 4);        // 通过截取获得文件名
                    string imageStr      = "pic/";                                              // 获取保存附件的项目文件夹
                    string uploadPath    = Server.MapPath("~/" + imageStr);                     // 将项目路径与文件夹合并
                    string pictureFormat = fileName.Split('.')[fileName.Split('.').Length - 1]; // 设置文件格式
                    string fileNames     = firstFileName + "." + fileFormat;                    // 设置完整(文件名+文件格式) 
                    string saveFile      = uploadPath + fileNames;                              //文件路径
                    files.SaveAs(saveFile);                                                     // 保存文件
                                                                                                // 如果单单是上传,不用保存路径的话,下面这行代码就不需要写了!
                    result = "http://58.192.132.31:9011/" + imageStr + fileNames;               // 设置数据库保存的路径

                    popSciinManger.Imag = result;                                               //将新的图片地址传给Imag
                }
            }
            if (ModelState.IsValid)
            {
                MySqlConnection mysql        = getMySqlConnection();
                MySqlCommand    mySqlCommand = getSqlCommand("UPDATE popsciinfortitle set title=" +
                                                             "'" + popSciinManger.Title + "'" + ",introduction=" + "'" + popSciinManger.Introduction + "'" +
                                                             ",Imag=" + "'" + popSciinManger.Imag + "'" + "where id=" + popSciinManger.Id, mysql);
                mysql.Open();
                MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand);
                mySqlCommand.ExecuteNonQuery();
                mysql.Close();
                return(RedirectToAction("Index"));
            }
            return(View(popSciinManger));
        }
Пример #2
0
        public ActionResult DeleteConfirmed(int id)
        {
            PopSciinManger  popSciinManger = new PopSciinManger();
            MySqlConnection mysql          = getMySqlConnection();
            MySqlCommand    mySqlCommand   = getSqlCommand("DELETE FROM popsciinfortitle where id=" + id, mysql);

            mysql.Open();
            MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand);

            mySqlCommand.ExecuteNonQuery();
            mysql.Close();
            return(RedirectToAction("Index"));
        }
Пример #3
0
        // GET: PopSciinMangers/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            PopSciinManger  popSciinManger = new PopSciinManger();
            MySqlConnection mysql          = getMySqlConnection();
            MySqlCommand    mySqlCommand   = getSqlCommand("SELECT * FROM  popsciinfortitle  WHERE id=" + id, mysql);

            mysql.Open();
            MySqlDataReader reader = mySqlCommand.ExecuteReader();

            try
            {
                while (reader.Read())
                {
                    if (reader.HasRows)
                    {
                        popSciinManger.Id = reader.GetInt32("id");

                        popSciinManger.Title = reader.GetString("title");

                        popSciinManger.Imag = reader.GetString("imag");
                        string a = reader.GetString("introduction");
                        popSciinManger.Introduction = "<p>" + a.Replace("\r\n", "</p><p>") + "</p>";
                        // popSciinManger.Introduction = reader.GetString("introduction");
                    }
                }
            }
            catch
            {
                return(HttpNotFound());
            }
            finally
            {
                mysql.Close();
            }

            return(View(popSciinManger));
        }
Пример #4
0
        // GET: PopSciinMangers
        public ActionResult Index(int page = 1)
        {
            List <PopSciinManger> listpopSciinMangers = new List <PopSciinManger>();
            MySqlConnection       mysql        = getMySqlConnection();
            MySqlCommand          mySqlCommand = getSqlCommand("select * from popsciinfortitle ", mysql);

            mysql.Open();
            MySqlDataReader reader = mySqlCommand.ExecuteReader();

            try
            {
                while (reader.Read())
                {
                    if (reader.HasRows)
                    {
                        PopSciinManger popSciinManger = new PopSciinManger();
                        popSciinManger.Id = reader.GetInt32("id");
                        string a;
                        a = reader.GetString("title");
                        popSciinManger.Title = getstring(a, 30);
                        popSciinManger.Imag  = reader.GetString("imag");
                        listpopSciinMangers.Add(popSciinManger);
                    }
                }
            }
            catch
            {
                return(HttpNotFound());
            }
            finally
            {
                mysql.Close();
            }
            const int pagesize = 8;
            var       data     = listpopSciinMangers
                                 .OrderBy(p => p.Id).ToPagedList(page, pagesize);

            return(View(data));
            //return View(db.DocMangers.ToList());
        }