protected void Button1_Click(object sender, EventArgs e)
{
string pinglun = Request.Form["pingluntext"];//评论信息
if (pinglun.Equals(""))
{
Response.Write("<script>alert('内容不能为空！')</script>");
}
else
{
for (int i = 0; i < 61; i++)
{
//改变代码
pinglun = pinglun.Replace("a" + i + ".gif", "<img src=images/face/a" + i + ".gif/>");
}
string id = Request.Params["suc_dfdfddff"];
Datacon dc = new Datacon();
SqlConnection conn = dc.SQL_con();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
string str = "insert into [shine_sucai_pinglun] (sucai_id,pinglun_yonghu,touxiang,pinglun_neirong) values('" + id + "','" + Session["user"] + "','qq.png','" + pinglun + "')";
SqlCommand comm = new SqlCommand(str, conn);
if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0)
{
// 在此处放置用户代码以初始化页面
pingluns();
}
else
{
WebMessageBox.Show("评论出错！", "sucaiDetail_sub.aspx?suc_dfdfddff=" + id);
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Datacon dc = new Datacon();
SqlConnection conn = dc.SQL_con();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
string url = Request.Url.ToString();
string str = "insert into [shine_sucai_shoucang] (shoucang_id,shoucang_url) values('" + Session["user"] + "','" + url + "')";
SqlCommand comm = new SqlCommand(str, conn);
if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0)
{
// 在此处放置用户代码以初始化页面
string id = Request.Params["suc_dfdfddff"];
WebMessageBox.Show("恭喜,收藏成功！", "sucaiDetail_sub.aspx?suc_dfdfddff=" + id);
}
else
{
WebMessageBox.Show("未来收藏！", "Logon.aspx");
}
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.Params["id"];
if (id == null)
{
Response.Redirect("index1.aspx");
}
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from new where id='" + id + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "new");
DataList1.DataSource = ds;
DataList1.DataBind();
con.Close();
/* string sql = "select from new where id='" + id + "'";
* SqlCommand cmd = new SqlCommand(sql, con);
* SqlDataReader dr = cmd.ExecuteReader();
* while (dr.Read())
* {
* article.Text = dr["topic"].ToString();
* }
*
* string s = "select topic from new where id='" + id + "'";
* SqlDataAdapter da1 = new SqlDataAdapter(s, con);
* DataSet ds1 = new DataSet();
*
* Response.Write(ds1);
*
* Label1.Text = Convert.ToString(Session["i_tool"]);*/
}
public void online()
{
Datacon dc = new Datacon();
SqlConnection conn = dc.SQL_con();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
String online1 = HttpContext.Current.Request.UserHostAddress;
string strHostName = System.Net.Dns.GetHostName();
string clientIPAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
string str = "insert into [shine_online] (上线地点,ip地址,use_num) values('" + clientIPAddress + "','" + online1 + "','" + Session["user"].ToString() + "')";
SqlCommand comm = new SqlCommand(str, conn);
if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0)
{
}
else
{
}
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
protected void LinkButton2_Click1(object sender, EventArgs e)
{
string id = Request.Params["fdfdfdf"];
String str = "";
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_sucai] where id=" + id + "", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_message");
if (ds.Tables["shine_message"].Rows.Count == 0)
{
Response.Write("没有查询到数据，请重试");
}
else
{
Response.Write("<br>");
for (int i = 0; i < ds.Tables["shine_message"].Rows.Count; i++)
{
str = (ds.Tables["shine_message"].Rows[i]["file_zip_url"]).ToString();
}
Response.Redirect("file/zuopin/" + str);
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
//获取客户端的ip地址
string strHostName = System.Net.Dns.GetHostName();
string userip = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
//创建cookie对象：
if (Session["ipaddress"] == null)
{
Session["ipaddress"] = userip;
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
//更新语句
con.Open();
String str = "update shine_sucai_zan set dianzan_shu=dianzan_shu+1 where id='1' ";
SqlCommand comm = new SqlCommand(str, con);
int record = Convert.ToInt32(comm.ExecuteNonQuery());
if (record > 0)
{
bingdate();
}
con.Close();
}
}
protected void LoginButton_Click(object sender, EventArgs e)
{
if (lblCheckCode.Text.Trim() != txtCheckCode.Text.Trim()) //判断验证码
{
WebMessageBox.Show("验证码不正确，请重新输入！");
}
else
{
string name = UserName.Text.Trim();
string pass = Password.Text.Trim();
Datacon dc = new Datacon();
SqlConnection conn = dc.SQL_con();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
string str = "select * from userlogin where username='******' and pwd='" + pass + "' ";
SqlCommand comm = new SqlCommand(str, conn);
SqlDataReader dr = comm.ExecuteReader();
if (name == "" | pass == "")
{
Response.Write("<script>alert('不能为空！')</script>");
}
else if (dr.Read())
{
Session["user"] = name;
Response.Redirect("index1.aspx");
}
else
{
Response.Write("<script>alert('登录失败！请确保已注册且用户名密码不为空！')</script>");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
String title = TextBox1.Text; //获取标题
String validate = TextBox2.Text; //获取验证码
String contents = Request.Form["content1"]; //获取内容
if (contents.Equals("") && title.Equals("") && validate.Equals(""))
{
Response.Write("<script>alert('不能为空！')</script>");
}
else
{
if (String.Compare(Request.Cookies["yzmcode"].Value, this.TextBox2.Text, true) != 0)
{
Response.Write("<script>alert('验证码错误!')</script>");
TextBox2.Text = "";
}
else
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
string answerid = "";
int answer_id = 0;
//建立数据库连接
if (con.State == System.Data.ConnectionState.Closed)
{
//如果数据库连接处于关闭状态 则打开数据库
con.Open();
SqlCommand sqlcommand = new SqlCommand("select answerid from Question where id=(select max(id) from Question)", con);
answerid = sqlcommand.ExecuteScalar().ToString();
answer_id = int.Parse(answerid);
answer_id++;
}
//创建SQL语句
string sqlstr = "insert into Question(title,question,answerid) values('" + title + "','" + contents + "','" + answer_id + "')";
//创建SQLcommand对象
SqlCommand conmm = new SqlCommand(sqlstr, con);
//打开数据库连接
if (Convert.ToInt32(conmm.ExecuteNonQuery()) > 0)
{
content1.Text = "";
Response.Write("<script> alert('恭喜，发表成功');</script>");
// Response.Redirect("index_forum.aspx");
}
else
{
Response.Write("<script> alert('数据添加失败！');</script>");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT top 12 * FROM [shine_sucai]", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_sucai");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void LinkButton1_Click1(object sender, EventArgs e)
{
string id = Request.Params["fdfdfdf"];
String str = "";
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_sucai] where id=" + id + "", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_message");
if (ds.Tables["shine_message"].Rows.Count == 0)
{
Response.Write("没有查询到数据，请重试");
}
else
{
Response.Write("<br>");
for (int i = 0; i < ds.Tables["shine_message"].Rows.Count; i++)
{
str = (ds.Tables["shine_message"].Rows[i]["file_zip_url"]).ToString();
}
Datacon dcc = new Datacon();
SqlConnection conn = dc.SQL_con();
//更新语句
conn.Open();
String strs = "update shine_sucai set xiazailiang=xiazailiang+1 where id='" + id + "' ";
SqlCommand commd = new SqlCommand(strs, con);
int record = Convert.ToInt32(commd.ExecuteNonQuery());
if (record > 0)
{
//链接到下载界面
Response.Redirect("file/zuopin/" + str);
}
con.Close();
}
}
public void pingluns()
{
string id = Request.Params["suc_dfdfddff"];
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_sucai_pinglun] where sucai_id='" + id + "' order by time desc ", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_sucai_pinglun");
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [pinglun]", con);
DataSet ds = new DataSet();
da.Fill(ds, "pinglun");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_sucai] where use_num='" + Session["user"] + "' ", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_sucai");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select c1=count(id),c2=(select count(id) from shine_message where state='未读' and message_uer='" + Session["user"] + "' ),c3=(select count(id) from shine_message where message_uer='" + Session["user"] + "' ) from shine_message where state='已读' and message_uer='" + Session["user"] + "' ", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_message");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_message] where message_uer='" + Session["user"] + "' and state='未读' ", con);
DataSet ds = new DataSet();
da.Fill(ds, "pinglun");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void updata_datalist()
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Question]", con);
DataSet ds = new DataSet();
da.Fill(ds, "Question");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
public void xiaoxi()
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select count(id) as num from shine_message where message_uer='3' ", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_message");
con.Close();
DataListaa.DataSource = ds;
DataListaa.DataBind();
}
public void bingdate()
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_sucai_zan] ", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_sucai_zan");
con.Close();
DataList5.DataSource = ds;
DataList5.DataBind();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
String old_pass = TextBox1.Text;
String new_pass1 = TextBox2.Text;
String new_pass2 = TextBox3.Text;
//获取旧密码；
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
if (old_pass.Equals(""))
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] != null)
{
SqlConnection con = dc.SQL_con();
con.Open();
//string md5_name; //加密后数据
//md5_name = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile( Session["user"].ToString() , "MD5");
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [User_login] where use_num='" + Session["user"].ToString() + "' ", con);
DataSet ds = new DataSet();
da.Fill(ds, "User_login");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
else
{
Response.Write("<script>alert('登陆失效！请重新登陆')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//登陆响应事件
String name = TextBox1.Text;
//string md5_name; //加密后数据
//md5_name = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(name, "MD5");
String pass = TextBox2.Text;
string md5_pass; //加密后数据
md5_pass = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(pass, "MD5");
Datacon dc = new Datacon();
SqlConnection conn = dc.SQL_con();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
string str = "select * from [User_login] where use_num='" + name + "' and password='******' ";
SqlCommand comm = new SqlCommand(str, conn);
SqlDataReader dr = comm.ExecuteReader();
if (name == "" | pass == "")
{
Response.Write("<script>alert('不能为空！')</script>");
}
else if (dr.Read())
{
Session["user"] = name;
online();
WebMessageBox.Show("登陆成功！", "index1.aspx");
}
else
{
Response.Write("<script>alert('登陆失败，检查用户名密码！')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.Params["suc_dfdfddff"];
if (id == null)
{
Response.Redirect("sucaiDetail_sub1.aspx?suc_dfdfddff=2");
}
else
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_sucai] where id=" + id + "", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_message");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
pingluns();
}
bingdate();
}
protected void Page_Load(object sender, EventArgs e)
{
String str = "";
string type = Request.Params["tt"];
if (type == null || type.Equals("全部"))
{
str = "SELECT * FROM [shine_sucai]";
}
else
{
str = "SELECT * FROM [shine_sucai] where type='" + type + "'";
}
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter(str, con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_sucai");
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.Params["fdfdfdf"];
if (id == null)
{
Response.Redirect("sucaiDetail.aspx");
}
else
{
Datacon dc = new Datacon();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [shine_sucai] where id=" + id + "", con);
DataSet ds = new DataSet();
da.Fill(ds, "shine_message");
//if (ds.Tables["shine_message"].Rows.Count == 0)
//{
// Response.Write("没有查询到数据，请重试");
//}
//else
//{
// Response.Write("<br>");
// for (int i = 0; i < ds.Tables["shine_message"].Rows.Count; i++)
// {
// Response.Write(ds.Tables["shine_message"].Rows[i]["file_zip_url"] + "<br>");
// }
//}
con.Close();
DataList1.DataSource = ds;
DataList1.DataBind();
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
//注册用户：
if (TextBox1.Text == "")
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('账号不能为空!', 3000, 'rounded');</script>");
}
else if (TextBox5.Text == "")
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('昵称不能为空!', 3000, 'rounded');</script>");
}
else if (TextBox6.Text == "")
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('手机号不能为空!', 3000, 'rounded');</script>");
}
else if (TextBox7.Text == "")
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('验证码不能为空!', 3000, 'rounded');</script>");
}
else if (TextBox2.Text == "")
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('密码不能为空!', 3000, 'rounded');</script>");
}
else if (TextBox4.Text == "")
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('密码不能为空!', 3000, 'rounded');</script>");
}
else if (TextBox3.Text == "")
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('邮箱不能为空!', 3000, 'rounded');</script>");
}
else
{
Datacon dcc = new Datacon();
SqlConnection connn = dcc.SQL_con();
if (connn.State == System.Data.ConnectionState.Closed)
{
connn.Open();
}
string strs = "select * from [User_login] where use_num='" + TextBox5.Text + "' ";
SqlCommand commm = new SqlCommand(strs, connn);
SqlDataReader dr = commm.ExecuteReader();
if (dr.Read())
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('用户已存在!', 3000, 'rounded');</script>");
}
else
{
if (TextBox7.Text.Equals(Session["codes"]))
{
if (!(TextBox2.Text.Equals(TextBox4.Text)))
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('两次密码不一致!', 3000, 'rounded');</script>");
}
else
{
String name_num = TextBox1.Text;
//string md5_name_num; //加密后数据
//md5_name_num = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(name_num, "MD5");
String pass1 = TextBox2.Text;
string md5_pass1; //加密后数据
md5_pass1 = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(pass1, "MD5");
String email = TextBox3.Text;
String pass2 = TextBox4.Text;
String name = TextBox5.Text;
string jianjie = Request.Form["OrderNote"]; //个人简介
String sex = Request.Form["sex"]; //性别
String g1 = Request.Form["g1"]; //喜好
String g2 = Request.Form["g2"]; //喜好
String g3 = Request.Form["g3"]; //喜好
String g4 = Request.Form["g4"]; //喜好
String like = g1 + "," + g2 + "," + g3 + "," + g4 + "";
Datacon dc = new Datacon();
SqlConnection conn = dc.SQL_con();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
string str = "insert into [User_login] (use_num,use_name,password,email,sex,jianshu,like1) values('" + name_num + "','" + name + "','" + md5_pass1 + "','" + email + "','" + sex + "','" + jianjie + "','" + like + "')";
SqlCommand comm = new SqlCommand(str, conn);
if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0)
{
// 在此处放置用户代码以初始化页面
string namee = name_num;
string path = Server.MapPath("") + "\\file" + "\\" + namee;
if (Directory.Exists(path))
{
Response.Write("<script>alert('文件夹已存在了!');history.go(-1);</script>");
}
else
{
DirectoryInfo folder = Directory.CreateDirectory(path);
string time = Convert.ToString(Directory.GetCreationTime(path));
string foldername = name.Substring(name.LastIndexOf("\\") + 1);
// Response.Write("添加成功!");
//Response.Write("添加时间：" + time);
//Response.Write("文件夹名：" + foldername);
}
WebMessageBox.Show("注册成功，欢迎您加入我们！", "index1.aspx");
}
else
{
WebMessageBox.Show("注册失败请，检查输入信息！！", "register.aspx");
Response.Redirect("register.aspx");
}
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
}
else
{
Page.ClientScript.RegisterStartupScript(Page.ClientScript.GetType(), "myscript", "<script>Materialize.toast('验证码不一致!', 3000, 'rounded');</script>");
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
String file_yulan_url = "";
String file_zip_url = "";
bool fileIsValid = false;
//如果确认了上传文件，则判断文件类型是否符合要求
if (this.FileUpload1.HasFile)
{
//获取上传文件的后缀
String fileExtension = System.IO.Path.GetExtension(this.FileUpload1.FileName).ToLower();
String[] restrictExtension = { ".gif", ".jpg", ".bmp", ".png" };
//判断文件类型是否符合要求
for (int i = 0; i < restrictExtension.Length; i++)
{
if (fileExtension == restrictExtension[i])
{
fileIsValid = true;
}
}
//如果文件类型符合要求,调用SaveAs方法实现上传,并显示相关信息
if (fileIsValid == true)
{
try
{
this.Image1.ImageUrl = "~/file/" + Session["user"].ToString() + "/" + FileUpload1.FileName;
//预览文件地址
file_yulan_url = Session["user"] + "/" + FileUpload1.FileName;
this.FileUpload1.SaveAs(Server.MapPath("~/file/" + Session["user"].ToString() + "/") + FileUpload1.FileName);
this.Label1.Text = "预览文件上传成功";
this.Label1.Text += "<Br/>";
this.Label1.Text += "<li>" + "原文件路径：" + this.FileUpload1.PostedFile.FileName;
this.Label1.Text += "<Br/>";
this.Label1.Text += "" + "文件大小：" + this.FileUpload1.PostedFile.ContentLength + "字节";
this.Label1.Text += " ";
this.Label1.Text += "" + "文件类型：" + this.FileUpload1.PostedFile.ContentType;
}
catch (Exception ex)
{
this.Label1.Text = "无法上传文件" + ex.Message;
}
}
else
{
this.Label1.Text = "上传失败，只能够上传后缀为.gif,.jpg,.bmp,.png的文件";
}
}
//##########################################################################################################
//如果确认了上传文件，则判断文件类型是否符合要求
if (this.FileUpload2.HasFile)
{
//获取上传文件的后缀
String fileExtension = System.IO.Path.GetExtension(this.FileUpload2.FileName).ToLower();
String[] restrictExtension = { ".ISO", ".jar", ".rar", ".zip", ".ai", ".cdr", ".cdr" };
//判断文件类型是否符合要求
for (int i = 0; i < restrictExtension.Length; i++)
{
if (fileExtension == restrictExtension[i])
{
fileIsValid = true;
}
}
//如果文件类型符合要求,调用SaveAs方法实现上传,并显示相关信息
if (fileIsValid == true)
{
try
{
this.Image2.ImageUrl = "~/imag/bg2.png";
//源文件地址
file_zip_url = Session["user"] + "/" + FileUpload2.FileName;
this.FileUpload2.SaveAs(Server.MapPath("~/file/" + Session["user"].ToString() + "/") + FileUpload2.FileName);
this.Label2.Text = "源文件上传成功";
this.Label2.Text += "<Br/>";
this.Label2.Text += "<li>" + "原文件路径：" + this.FileUpload2.PostedFile.FileName;
this.Label2.Text += "<Br/>";
this.Label2.Text += "" + "文件大小：" + this.FileUpload2.PostedFile.ContentLength + "字节";
this.Label2.Text += " ";
this.Label2.Text += "" + "文件类型：" + this.FileUpload2.PostedFile.ContentType;
}
catch (Exception ex)
{
this.Label2.Text = "无法上传文件" + ex.Message;
}
}
else
{
this.Label2.Text = "上传失败，只能够上传后缀为.ai,.cdr.psd,.zip,.rar,.jar,.IOS的文件";
}
}
String use_number = Session["user"].ToString();
String file_zip = "源文件名";
String file_yulan = "预览文件名";
String jianjie = "素材简介";
String type = "素材文件";
Datacon dc = new Datacon();
SqlConnection conn = dc.SQL_con();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
string str = "insert into [shine_sucai] (use_num,file_zip,file_yulan,file_zip_url,file_yulan_url,jianjie,type) values('" + use_number + "','" + file_zip + "','" + file_yulan + "','" + file_yulan_url + "','" + file_yulan_url + "','" + jianjie + "','" + type + "')";
SqlCommand comm = new SqlCommand(str, conn);
if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0)
{
// 在此处放置用户代码以初始化页面
Response.Write("<script> alert('恭喜 ，上传成功！')</script>");
}
else
{
Response.Write("<script> alert('抱歉 ，上传失败！')</script>");
}
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
