protected void btnProductAdd_Click(object sender, EventArgs e) { try { lblMsg.Text = ""; string imgNewFileName = Guid.NewGuid().ToString() + System.IO.Path.GetExtension(FileUpload_Img.FileName).ToLower(); if (FileUpload_Img.HasFile) { FileUpload_Img.SaveAs(Server.MapPath("product_img") + "/" + imgNewFileName); } SqlDataSource_Product.InsertParameters["產品編號"].DefaultValue = txtProductId.Text; SqlDataSource_Product.InsertParameters["類別編號"].DefaultValue = ddl_ProductClass.SelectedItem.Value; SqlDataSource_Product.InsertParameters["品名"].DefaultValue = txtProductName.Text; SqlDataSource_Product.InsertParameters["單價"].DefaultValue = txtPrice.Text; SqlDataSource_Product.InsertParameters["圖示"].DefaultValue = imgNewFileName; SqlDataSource_Product.Insert(); // 若目前檔案存在,則將檔案傳送到網站的product_img資料夾下 lblMsg.ForeColor = System.Drawing.Color.Blue; lblMsg.Text = "產品資料新增成功!"; txtProductId.Text = ""; txtProductName.Text = ""; txtPrice.Text = ""; } catch (Exception ex) { lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = ex.Message; } }
protected void btn_AccEdit_Click(object sender, EventArgs e) { conn.Open(); sqlcommand = new SqlCommand("select M_Name,M_Tel from [Member] WHERE M_num='" + Session["Login"].ToString() + "'", conn); dr = sqlcommand.ExecuteReader(); dr.Read(); string Name = dr["M_Name"].ToString(); string Phone = dr["M_Tel"].ToString(); dr.Close(); sqlcommand = new System.Data.SqlClient.SqlCommand("SELECT MAX(SHPR_num) FROM [SecondHandProductRequire]", conn);//查詢資料個數 dr = sqlcommand.ExecuteReader(); dr.Read(); string InsertID = ""; if (dr[0].ToString() == string.Empty) //當商品個數為0 則該筆商品的編號為1 { InsertID = 1.ToString(); } else { InsertID = (Convert.ToInt32(dr[0]) + 1).ToString();//不為0 該筆商品編號為會員個數+1 } dr.Close(); conn.Close(); conn.Open(); if (FileUpload_Img.HasFile) { string SaveImg = "SecondHandProductRequireImg/" + FileUpload_Img.FileName; FileUpload_Img.SaveAs(Server.MapPath(SaveImg)); SaveImg = @"SecondHandProductRequireImg\" + FileUpload_Img.FileName; sqlcommand = new SqlCommand("INSERT INTO [SecondHandProductRequire] VALUES('" + //把輸入資料的資料存入資料庫中 InsertID + "','" + txt_Name.Text + "','" + txt_Price.Text + "','" + txt_Info.Text + "','" + SaveImg + "','" + Name + "','" + Phone + "')", conn); sqlcommand.ExecuteNonQuery(); } else { sqlcommand = new SqlCommand("INSERT INTO [SecondHandProductRequire] VALUES('" + //把輸入資料的資料存入資料庫中 InsertID + "','" + txt_Name.Text + "','" + txt_Price.Text + "','" + txt_Info.Text + "'," + "NULL" + ",'" + Name + "','" + Phone + "')", conn); sqlcommand.ExecuteNonQuery(); } conn.Close(); Response.Write("<script>alert('已完成上架申請!');location.href='MyAccount_SHProductRequire.aspx'; </script>"); }
protected void btn_Submit_Click(object sender, EventArgs e) { if (txt_Name.Text != string.Empty || txt_Email.Text != string.Empty || txt_Content.Text != string.Empty) { string ID = DateTime.Now.ToString("yyyyMMddHHmmss");//以日期時間(年月日時分秒)作為ID儲存 conn.Open(); if (FileUpload_Img.HasFile) //若有包含圖片 { String fileExtension = System.IO.Path.GetExtension(FileUpload_Img.FileName).ToLower(); //得到檔的尾碼 String allowedExtensions = ".jpg"; //允許檔的尾碼 //看包含的檔是否是被允許的檔的尾碼 if (fileExtension == allowedExtensions)//若為允許的尾碼(.jpg),則上傳 { FileUpload_Img.SaveAs(Server.MapPath("ContactUsImg/" + ID + ".jpg")); sqlcommand = new SqlCommand("INSERT INTO [ContactUs] VALUES('" + ID + "','" + txt_Name.Text + "','" + txt_Email.Text + "','" + txt_Content.Text + "','" + "ContactUsImg/" + ID + ".jpg" + "')", conn); sqlcommand.ExecuteNonQuery(); } else//若為非允許的尾碼(.jpg),則拒絕上傳 { Response.Write("<script>alert('只能上傳jpg圖像檔喔!');</script>"); conn.Close(); return; } } else//若無包含圖片 { sqlcommand = new SqlCommand("INSERT INTO [ContactUs] VALUES('" + ID + "','" + txt_Name.Text + "','" + txt_Email.Text + "','" + txt_Content.Text + "',NULL)", conn); sqlcommand.ExecuteNonQuery(); } conn.Close(); //提醒用戶訊息以傳送成功,並導向回首頁 Response.Write("<script>alert('您的訊息以傳送成功囉!\\n我們將會盡快回復您。');location.href='index.aspx'; </script>"); } else { Response.Write("<script>alert('錯誤\\n下方姓名,Email,內容等皆須填寫不可空白喔!');</script>"); } }
protected void button_create_user_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"INSERT INTO Users (User_email, User_name, User_password, User_description, User_img) VALUES (@Email, @Name, @Password, @Description, @Img)"; cmd.Parameters.AddWithValue("@Email", TextBox_Email_Create.Text); cmd.Parameters.AddWithValue("@Name", TextBox_Username_Create.Text); cmd.Parameters.AddWithValue("@Password", TextBox_Password_Create1.Text); cmd.Parameters.AddWithValue("@Description", TextBox_Description.Text); string bill_sti = "intetbillede.jpg"; #region image1 if (FileUpload_Img.HasFile) { //NewGuid danner uniq navn for billeder bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img.FileName); // Opret String UploadeMappe = Server.MapPath("~/Images/ProfilePicture/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img.FileName; bill_sti = Filnavn; //Gem det orginale Billede FileUpload_Img.SaveAs(UploadeMappe + Filnavn); } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@Img", bill_sti); #endregion conn.Open(); object user_id = cmd.ExecuteScalar(); conn.Close(); Response.Redirect("Default.aspx"); }