private void insertDate()
{
//圖片上傳
//取得副檔名
string extension = NewsPhotoUpload.FileName.Split('.')[NewsPhotoUpload.FileName.Split('.').Length - 1];
//新檔案名稱
string fileName = DateTime.Now.ToString("yyyyMMddhhmmsss") + "." + extension; //也可寫作：String.Format("{0:}.{1}", DateTime.Now, extension)
//設定檔案路徑
string savePath = Server.MapPath("NewsImg/");
//設定完整存檔路徑
string savedName = Path.Combine(savePath, fileName);
//判斷資料夾是否存在，若無則建立資料夾，using System.IO;
if (!Directory.Exists("NewsImg/"))
{
Directory.CreateDirectory(Server.MapPath("NewsImg"));
}
//判斷檔案否存在
if (NewsPhotoUpload.HasFile)
{
//判斷是否為圖片類型檔案
if (NewsPhotoUpload.PostedFile.ContentType.IndexOf("image", System.StringComparison.Ordinal) == -1)
{
lblMessage.Visible = true;
lblMessage.Text = "請使用圖片類型檔案！";
}
else
{
//存檔
NewsPhotoUpload.SaveAs(savedName);
CsImg.GenerateThumbnailImageWidth(161, fileName, NewsPhotoUpload.PostedFile.InputStream, savePath, "mini");
string ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//連接資料庫
SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();
//Cmd命令
SqlCommand Cmd = new SqlCommand("INSERT INTO News (NewsDate, NewsTitle, NewsContent, Sticky,PrePhotoName,Introduction) VALUES (@NewsDate,@NewsTitle,@NewsContent,@Sticky,@PrePhotoName,@Introduction)", Conn);
Cmd.Parameters.AddWithValue("@NewsDate", DateTime.Now.ToString("yyyy/MM/dd HH:mm"));
Cmd.Parameters.AddWithValue("@NewsTitle", txbNewsTitle.Text);
Cmd.Parameters.AddWithValue("@NewsContent", HttpUtility.HtmlEncode(txbNewsContent.Text));
Cmd.Parameters.AddWithValue("@Sticky", rdolstSticky.SelectedValue);
Cmd.Parameters.AddWithValue("@PrePhotoName", fileName);
Cmd.Parameters.AddWithValue("@Introduction", txbIntroduction.Text);
//執行命令
Cmd.ExecuteNonQuery();
Cmd.Cancel();
Conn.Close();
Conn.Dispose();
Response.Redirect("NewsMgmt.aspx");//頁面跳轉更新
}
}
else
{
lblMessage.Visible = true;
lblMessage.Text = "請選擇檔案上傳！";
}
}
private void updateDate()
{
//圖片上傳
//取得副檔名
string extension = ContactPhotoUpload.FileName.Split('.')[ContactPhotoUpload.FileName.Split('.').Length - 1];
//新檔案名稱
string fileName = DateTime.Now.ToString("yyyyMMddhhmmsss") + "." + extension; //也可寫作：String.Format("{0:}.{1}", DateTime.Now, extension)
//設定檔案路徑
string savePath = Server.MapPath("DealersImg/");
//設定完整存檔路徑
string savedName = Path.Combine(savePath, fileName);
//判斷資料夾是否存在，若無則建立資料夾，using System.IO;
if (!Directory.Exists("DealersImg/"))
{
Directory.CreateDirectory(Server.MapPath("DealersImg"));
}
//判斷檔案否存在
if (ContactPhotoUpload.HasFile)
{
//判斷是否為圖片類型檔案
if (ContactPhotoUpload.PostedFile.ContentType.IndexOf("image", System.StringComparison.Ordinal) == -1)
{
lblMessage.Visible = true;
lblMessage.Text = "請使用圖片類型檔案！";
}
else
{
//判斷檔案大小是否超過4MB
if (ContactPhotoUpload.PostedFile.ContentLength > 4194304)
{
lblMessage.Visible = true;
lblMessage.Text = "檔案大小不可超過4MB！";
}
else
{
//存檔
ContactPhotoUpload.SaveAs(savedName);
CsImg.GenerateThumbnailImageWidth(209, fileName, ContactPhotoUpload.PostedFile.InputStream, savePath, "mini");
string ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//連接資料庫
SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();
//Cmd命令
SqlCommand Cmd = new SqlCommand("UPDATE DealersDetails SET DealersInfo =@DealersInfo, Region =@Region, Title =@Title, ContactPhoto =@ContactPhoto WHERE id = @id", Conn);
Cmd.Parameters.AddWithValue("@DealersInfo", ckeDealersInfo.Text);
Cmd.Parameters.AddWithValue("@Region", txbRegion.Text);
Cmd.Parameters.AddWithValue("@Title", txbTitle.Text);
Cmd.Parameters.AddWithValue("@ContactPhoto", fileName);
//Request.QueryString["id"].ToString()是傳DealersDetails的id值
Cmd.Parameters.AddWithValue("@id", Request.QueryString["id"].ToString());
//執行命令
Cmd.ExecuteNonQuery();
Cmd.Cancel();
Conn.Close();
Conn.Dispose();
BackToPreviousPage();
}
}
}
else
{
string ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//連接資料庫
SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();
//Cmd命令
SqlCommand Cmd = new SqlCommand("UPDATE DealersDetails SET DealersInfo =@DealersInfo, Region =@Region, Title =@Title WHERE id = @id", Conn);
Cmd.Parameters.AddWithValue("@DealersInfo", ckeDealersInfo.Text);
Cmd.Parameters.AddWithValue("@Region", txbRegion.Text);
Cmd.Parameters.AddWithValue("@Title", txbTitle.Text);
//Request.QueryString["id"].ToString()是傳DealersDetails的id值
Cmd.Parameters.AddWithValue("@id", Request.QueryString["id"].ToString());
//執行命令
Cmd.ExecuteNonQuery();
Cmd.Cancel();
Conn.Close();
Conn.Dispose();
BackToPreviousPage();
}
}
private void uploadImg(FileUpload myFileUpload)
{
//判斷資料夾是否存在，若無則建立資料夾，using System.IO;
if (!Directory.Exists("YachtsImg/"))
{
Directory.CreateDirectory(Server.MapPath("YachtsImg"));
}
//判斷檔案否存在
if (myFileUpload.HasFile)
{
//判斷是否為圖片類型檔案
if (myFileUpload.PostedFile.ContentType.IndexOf("image", System.StringComparison.Ordinal) == -1)
{
lblMessage.Visible = true;
lblMessage.Text = "請使用圖片類型檔案！";
}
else
{
//判斷檔案大小是否超過4MB
if (myFileUpload.PostedFile.ContentLength > 4194304)
{
lblMessage.Visible = true;
lblMessage.Text = "檔案大小不可超過4MB！";
}
else
{
string extension = myFileUpload.FileName.Split('.')[myFileUpload.FileName.Split('.').Length - 1];
//新檔案名稱
string fileName = DateTime.Now.ToString("yyyyMMddhhmmsss") + "." + extension; //也可寫作：String.Format("{0:}.{1}", DateTime.Now, extension)
//設定檔案路徑
string savePath = Server.MapPath("YachtsImg/");
//設定完整存檔路徑
string savedName = Path.Combine(savePath, fileName);
//存檔
myFileUpload.SaveAs(savedName);
CsImg.GenerateThumbnailImage(fileName, myFileUpload.PostedFile.InputStream, savePath, "mini", 58);
string ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//連接資料庫
SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();
//Cmd命令
SqlCommand Cmd = new SqlCommand("INSERT INTO YachtsPhoto (YachtsID,FileName, UploadDate,Introduction) VALUES (@YachtsID,@FileName,@UploadDate,@Introduction)", Conn);
int id = Convert.ToInt32(Request.QueryString["id"]);
Cmd.Parameters.AddWithValue("@YachtsID", id);//遊艇船型的id值
Cmd.Parameters.AddWithValue("@FileName", fileName);
Cmd.Parameters.AddWithValue("@UploadDate", DateTime.Now.ToString("yyyy/MM/dd HH:mm"));
Cmd.Parameters.AddWithValue("@Introduction", txbIntroduction.Text);
//執行命令
Cmd.ExecuteNonQuery();
Cmd.Cancel();
Conn.Close();
Conn.Dispose();
Response.Redirect(this.Request.Url.ToString());
}
}
}
else
{
lblMessage.Text = "請選擇檔案上傳！";
}
}
