protected void SaveBtn_Click(object sender, EventArgs e) { String username, FileTitle1; username = Accept_User.Text; FileTitle1 = FileTitle.Text; String Send_user1 = Send_User.Text; //String TitleStr = Send_user1 + "To" + username; String TimeNow = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString(); MyUpload MyUpload = new MyUpload(); MyUpload.Sizes = 2048; string Pic1 = "File/"; //Cnn = new SqlConnection(ConfigurationSettings.AppSettings["connection"]); //Cnn.Open(); MyUpload.Path = "File"; MyUpload.Sizes = 2048; MyUpload.FileType = "jpg|gif|bmp|JPG|GIF|BMP|doc|DOC|xls|XLS|FLV|flv|SWF|swf"; MyUpload.PostedFile = FileUpload1.PostedFile; String Pic2 = MyUpload.Upload(); if (Pic2 == null) { Page.RegisterStartupScript("", "<script>alert('上传失败!')</script>"); Response.AddHeader("Refresh", "0.0001"); } else { Pic2 = Pic1 + Pic2; String Sql = "insert into SendFile(Accept_UserName,Send_UserName,Send_File,Send_Time,Send_FileName) values('" + username + "','" + Send_user1 + "','" + Pic2 + "','" + TimeNow + "','" + FileTitle1 + "')"; if (db.insert(Sql)) { Page.RegisterStartupScript("", "<script>alert('上传成功!')</script>"); } Accept_User.Text = ""; Send_User.Text = ""; } }
public void Upload(object sender, EventArgs e) { try { if (tbxtypes.Text != "" && tbxaddtitle.Text != "") { MyUpload myUpload = new MyUpload(); myUpload.FileLength = 5000; myUpload.PostedFile = upFile.PostedFile; myUpload.Extension = strFileTypes; strFileName = myUpload.PostedFile.FileName; int intP = strFileName.LastIndexOf("\\") + 1; strFileTypes = strFileName.Substring(intP++); myUpload.SavePath = Server.MapPath("files/"); if (strFileTypes.LastIndexOf("exe") != -1) { myUpload.Extension = "exe"; } else if (strFileTypes.LastIndexOf("rar") != -1) { myUpload.Extension = "rar"; } else if (strFileTypes.LastIndexOf("zip") != -1) { myUpload.Extension = "zip"; } else { Response.Write("<script>alert('只能是exe,zip,rar三种格式 ')<"); Response.Write("/"); Response.Write("script>"); } string strfile = myUpload.PostedFile.ContentLength.ToString(); strFileSize = strfile.Substring(0, strfile.Length - 3); FileMsg.Text = myUpload.Upload(); } else { Response.Write("<script>alert('请把各项填写好')<"); Response.Write("/"); Response.Write("script>"); } if (FileMsg.Text.IndexOf("Successfully") != -1) { string strCon = Application["db_app"].ToString(); OleDbConnection objCon = new OleDbConnection(strCon); string strSQL = "INSERT INTO db_down(FileTitle,Types,FileUrl,FileSize,FileReadMe,Score) VALUES(?,?,?,?,?,?)"; OleDbCommand objCmd = new OleDbCommand(strSQL, objCon); objCmd.Parameters.Add("FileTitle", OleDbType.VarChar, 100, "FileTitle"); objCmd.Parameters.Add("FileSize", OleDbType.VarChar, 50, "FileSize"); objCmd.Parameters.Add("Types", OleDbType.VarChar, 220, "Types"); objCmd.Parameters.Add("FileUrl", OleDbType.VarChar, 254, "FileUrl"); objCmd.Parameters.Add("FileReadMe", OleDbType.VarChar, 224, "FileReadMe"); objCmd.Parameters.Add("Score", OleDbType.VarChar, 30, "Score"); if (tbxreadme.Text == "") { tbxreadme.Text = tbxaddtitle.Text; } string strScore = ""; if (ddlstep.Items[0].Selected) { strScore = "★★★"; } else if (ddlstep.Items[1].Selected) { strScore = "★★★★"; } else if (ddlstep.Items[2].Selected) { strScore = "★★★★★"; } objCmd.Parameters["FileTitle"].Value = tbxaddtitle.Text; objCmd.Parameters["FileSize"].Value = tbxtypes.Text; objCmd.Parameters["Types"].Value = "files/" + strFileTypes; objCmd.Parameters["FileUrl"].Value = strFileSize + "KB"; objCmd.Parameters["FileReadMe"].Value = tbxreadme.Text; objCmd.Parameters["Score"].Value = strScore; objCon.Open(); objCmd.ExecuteNonQuery(); Response.Write("<script>alert('Sussess')<"); Response.Write("/"); Response.Write("script>"); Sus_Clear(); } } catch (Exception ex) { FileMsg.Text = ex.Message; } }