protected void Page_Load(object sender, EventArgs e)
{
this.MetaDescription = "부품 상세보기 입니다.";
CommonClassMain ccm = new CommonClassMain();
if (!IsPostBack)
{
string s_productid = Request["productid"]; //Get
if (s_productid == null)
{
//s_productid = "202104062250123";
return;
}
// GET 받기 //
// String test2 = Request.QueryString["test2"] //Get
// POST 받기 //
// String test1 = Request.Form["test1"]; //Post
// GET & POST 구분 없이 받기 //
// String test2 = Request["test2"] //Get
try
{
StringBuilder sbQuery = new StringBuilder();
sbQuery.AppendLine("SELECT [PRODUCTID] ");
sbQuery.AppendLine(" ,[MANUFACTURER] ");
sbQuery.AppendLine(" ,[NAME] ");
sbQuery.AppendLine(" ,[YEAR] ");
sbQuery.AppendLine(" ,[VIN] ");
sbQuery.AppendLine(" ,[PARTNUM] ");
sbQuery.AppendLine(" ,[PRODUCTINFO] ");
sbQuery.AppendLine(" ,[MOREINFO] ");
sbQuery.AppendLine(" ,[RETURNINFO] ");
sbQuery.AppendLine(" ,[SHIPPINGINFO] ");
sbQuery.AppendLine(" ,[PUBLISHER] ");
sbQuery.AppendLine(" ,[POSTINGTIME] ");
sbQuery.AppendLine(" ,[LASTMODIFIER] ");
sbQuery.AppendLine(" ,[LASTMODIFIEDTIME] ");
sbQuery.AppendLine(" FROM [seowoncarasp].[SEOWON_PRODUCT] ");
sbQuery.AppendLine("WHERE [PRODUCTID] = '" + s_productid + "' ");
SqlCommand scCmd = new SqlCommand(sbQuery.ToString());
SqlDataReader reader = ccm.fnQuerySQL(scCmd, "SELECT");
while (reader.Read())
{
lblMANUFACTURER.Text = reader["MANUFACTURER"].ToString();
lblNAME.Text = reader["NAME"].ToString();
lblPARTNUM.Text = reader["PARTNUM"].ToString();
lblPRODUCTID.Text = reader["PRODUCTID"].ToString();
lblPRODUCTINFO.Text = reader["PRODUCTINFO"].ToString();
lblVIN.Text = reader["VIN"].ToString();
lblYEAR.Text = reader["YEAR"].ToString();
lblMOREINFO.Text = reader["MOREINFO"].ToString();
lblRETURNINFO.Text = reader["RETURNINFO"].ToString();
lblSHIPPINGINFO.Text = reader["SHIPPINGINFO"].ToString();
}
reader.Close();
this.MetaDescription = "부품 상세보기 - " + lblMANUFACTURER.Text + "-" + lblNAME.Text + "-" + lblYEAR.Text;
//이미지 넣기
//s_productid = "202104062250123";
string sPath = ccm.fnUploadPath(Request.Url.ToString());
string sYear = s_productid.Substring(0, 4);
string sMonth = s_productid.Substring(4, 2);
string sImageName = s_productid.Substring(6);
sPath = Path.Combine(sPath, sYear, sMonth);
DirectoryInfo diPathImage = new DirectoryInfo(sPath);
string sCondition = string.Format("{0}_*.*", sImageName);
FileInfo[] fiImageArray = diPathImage.GetFiles(sCondition, SearchOption.TopDirectoryOnly);
StringBuilder sbTagImage = new StringBuilder();
int iCount = 0;
foreach (FileInfo fi in fiImageArray)
{
if (iCount == 0)
{
iCount++;
continue;
}
sbTagImage.AppendLine(string.Format("<img src = \"board/upload/{0}/{1}/{2}_{3}" + fi.Extension + "\" class=\"img-fluid\" alt=\"\">", sYear, sMonth, sImageName, iCount));
iCount++;
}
imgParent.InnerHtml = sbTagImage.ToString();
lblMOREINFO.Text = sbTagImage.ToString() + lblMOREINFO.Text;
}
catch
{
//Response.Write( "Excaption-> " + e.Message + " -> " + e.Source + " -> " + e.StackTrace );
}
//다른방법으로 섬네일 만들기
//CommonClassMain ih = new CommonClassMain();
//ih.GetThumnailImage( "062250123_1.jpg", @"D:\work\SeowoncarASP\board\upload\2021\04");
}
else
{
}
}