private void fnGenerateCategory()
{
StringBuilder sbQueryCate = new StringBuilder();
sbQueryCate.AppendLine("SELECT DISTINCT [CATEGORY] ");
sbQueryCate.AppendLine(" FROM [seowoncarasp].[SEOWON_PRODUCT] ");
SqlCommand scCmdCate = new SqlCommand(sbQueryCate.ToString());
SqlDataReader readerCate = CCM.fnQuerySQL(scCmdCate, "SELECT");
StringBuilder sbQuery = new StringBuilder();
sbQuery.AppendLine("SELECT [CATEGORY], [MANUFACTURER] ");
sbQuery.AppendLine(" FROM [seowoncarasp].[SEOWON_PRODUCT] ");
sbQuery.AppendLine("GROUP BY [CATEGORY], [MANUFACTURER] ");
SqlCommand scCmd = new SqlCommand(sbQuery.ToString());
SqlDataReader reader = CCM.fnQuerySQL(scCmd, "SELECT");
StringBuilder sbQuery2 = new StringBuilder();
sbQuery2.AppendLine(" SELECT [PRODUCTID] ");
sbQuery2.AppendLine(" ,[CATEGORY] ");
sbQuery2.AppendLine(" ,[MANUFACTURER] ");
sbQuery2.AppendLine(" ,[NAME] ");
sbQuery2.AppendLine(" ,[YEAR] ");
sbQuery2.AppendLine(" ,[VIN] ");
sbQuery2.AppendLine(" ,[PARTNUM] ");
sbQuery2.AppendLine(" ,[PRODUCTINFO] ");
sbQuery2.AppendLine(" ,[MOREINFO] ");
sbQuery2.AppendLine(" ,[RETURNINFO] ");
sbQuery2.AppendLine(" ,[SHIPPINGINFO] ");
sbQuery2.AppendLine(" ,[PUBLISHER] ");
sbQuery2.AppendLine(" ,[POSTINGTIME] ");
sbQuery2.AppendLine(" ,[LASTMODIFIER] ");
sbQuery2.AppendLine(" ,[LASTMODIFIEDTIME] ");
sbQuery2.AppendLine(" FROM [seowoncarasp].[SEOWON_PRODUCT] ");
sbQuery2.AppendLine(" ORDER BY [MANUFACTURER] ASC ");
SqlCommand scCmd2 = new SqlCommand(sbQuery2.ToString());
SqlDataReader reader2 = CCM.fnQuerySQL(scCmd2, "SELECT");
XmlDocument xDoc = new XmlDocument();
xDoc.LoadXml(divCategory.InnerText);
foreach (XmlNode xnTopDIV in xDoc.FirstChild.ChildNodes)
{
if (xnTopDIV.Attributes["class"].Value.Equals("row"))
{
XmlNode xn = xnTopDIV.FirstChild.FirstChild;
xn.RemoveAll();
XmlAttribute attUL = xDoc.CreateAttribute("id");
attUL.Value = "portfolio-flters";
xn.Attributes.Append(attUL);
XmlElement xeLI_ALL = xDoc.CreateElement("li");
XmlAttribute attLI_ALL = xDoc.CreateAttribute("data-filter");
attLI_ALL.Value = "*";
XmlAttribute attLI_Class = xDoc.CreateAttribute("class");
attLI_Class.Value = "filter-active";
XmlAttribute attIDx = xDoc.CreateAttribute("id");
attIDx.Value = "allCar";
xeLI_ALL.Attributes.Append(attLI_ALL);
xeLI_ALL.Attributes.Append(attLI_Class);
xeLI_ALL.Attributes.Append(attIDx);
xeLI_ALL.InnerText = "전체";
xn.AppendChild(xeLI_ALL);
//span 넣기
XmlElement xeSpan = xDoc.CreateElement("span");
xeSpan.InnerText = "|";
XmlAttribute xattrx = xDoc.CreateAttribute("style");
xattrx.Value = "font-size: xx-small;";
xeSpan.Attributes.Append(xattrx);
xn.AppendChild(xeSpan);
while (readerCate.Read())
{
string sCATEGORY = readerCate["CATEGORY"].ToString();
string sCateEng = sCATEGORY.Equals("국산차") ? "Domestic" : "Import";
XmlElement xeLI = xDoc.CreateElement("li");
XmlAttribute attLI = xDoc.CreateAttribute("data-filter");
attLI.Value = ".filter-" + sCATEGORY;
XmlAttribute attID = xDoc.CreateAttribute("id");
attID.Value = sCateEng;
xeLI.Attributes.Append(attLI);
xeLI.Attributes.Append(attID);
xeLI.InnerText = sCATEGORY;
xn.AppendChild(xeLI);
}
readerCate.Close();
//span 또 넣기
XmlElement xeSpan2 = xDoc.CreateElement("span");
xeSpan2.InnerText = "|";
XmlAttribute xattr2 = xDoc.CreateAttribute("style");
xattr2.Value = "font-size: xx-small;";
xeSpan2.Attributes.Append(xattr2);
xn.AppendChild(xeSpan2);
while (reader.Read())
{
string sMANUFACTURER = reader["MANUFACTURER"].ToString();
string sCATEGORY = reader["CATEGORY"].ToString();
string sCateEng = sCATEGORY.Equals("국산차") ? "Domestic" : "Import";
XmlElement xeLI = xDoc.CreateElement("li");
XmlAttribute attLI = xDoc.CreateAttribute("data-filter");
attLI.Value = string.Format(".filter-{0}", sMANUFACTURER);
XmlAttribute attClass = xDoc.CreateAttribute("class");
attClass.Value = sCateEng;
xeLI.Attributes.Append(attLI);
xeLI.Attributes.Append(attClass);
xeLI.InnerText = sMANUFACTURER;
xn.AppendChild(xeLI);
}
reader.Close();
}
else if (xnTopDIV.Attributes["class"].Value.Equals("row portfolio-container"))
{
XmlNode xn = xnTopDIV;
xn.RemoveAll();
//class="row portfolio-container" data-aos="fade-up" data-aos-easing="ease-in-out" data-aos-duration="500"
XmlAttribute attClass0 = xDoc.CreateAttribute("class");
attClass0.Value = "row portfolio-container";
XmlAttribute attdata_aos = xDoc.CreateAttribute("data-aos");
attdata_aos.Value = "fade-up";
XmlAttribute attdata_aos_easing = xDoc.CreateAttribute("data-aos-easing");
attdata_aos_easing.Value = "ease-in-out";
XmlAttribute attdata_aos_duration = xDoc.CreateAttribute("data-aos-duration");
attdata_aos_duration.Value = "500";
xn.Attributes.Append(attClass0);
xn.Attributes.Append(attdata_aos);
xn.Attributes.Append(attdata_aos_easing);
xn.Attributes.Append(attdata_aos_duration);
while (reader2.Read())
{
string sCATEGORY = reader2["CATEGORY"].ToString();
string sMANUFACTURER = reader2["MANUFACTURER"].ToString();
string sPRODUCTID = reader2["PRODUCTID"].ToString();
string sNAME = reader2["NAME"].ToString();
XmlElement xlDIV = xDoc.CreateElement("div");
XmlAttribute attClass = xDoc.CreateAttribute("class");
attClass.Value = string.Format("col-lg-4 col-md-6 filter-{0} filter-{1}", sMANUFACTURER, sCATEGORY);
xlDIV.Attributes.Append(attClass);
xn.AppendChild(xlDIV);
{
XmlElement xlDIV2 = xDoc.CreateElement("div");
XmlAttribute attClass2 = xDoc.CreateAttribute("class");
attClass2.Value = "portfolio-item";
xlDIV2.Attributes.Append(attClass2);
xlDIV.AppendChild(xlDIV2);
{
//이미지 넣기
//s_productid = "202104062250123";
string sPath = CCM.fnUploadPath(Request.Url.ToString());
string sImgFullPath = CCM.fnGetImgFullPath(sPath, sPRODUCTID)[0];
XmlElement xeAImg = xDoc.CreateElement("a");
XmlAttribute xaAImg = xDoc.CreateAttribute("href");
xaAImg.Value = "/portfolio-details.aspx?productid=" + sPRODUCTID;
xeAImg.Attributes.Append(xaAImg);
xlDIV2.AppendChild(xeAImg);
{
XmlElement xlimg = xDoc.CreateElement("img");
XmlAttribute attsrc = xDoc.CreateAttribute("src");
attsrc.Value = sImgFullPath;
XmlAttribute attClass4 = xDoc.CreateAttribute("class");
attClass4.Value = "img-fluid";
XmlAttribute attalt = xDoc.CreateAttribute("alt");
attalt.Value = "-";
xlimg.Attributes.Append(attsrc);
xlimg.Attributes.Append(attClass4);
xlimg.Attributes.Append(attalt);
xeAImg.AppendChild(xlimg);
}
XmlElement xlDIV3 = xDoc.CreateElement("div");
XmlAttribute attClass6 = xDoc.CreateAttribute("class");
attClass6.Value = "portfolio-info";
xlDIV3.Attributes.Append(attClass6);
xlDIV2.AppendChild(xlDIV3);
{
XmlElement xlH3 = xDoc.CreateElement("h3");
xlDIV3.AppendChild(xlH3);
{
XmlElement xlA = xDoc.CreateElement("a");
XmlAttribute attHref = xDoc.CreateAttribute("href");
//attHref.Value = sImgFullPath;
attHref.Value = "/portfolio-details.aspx?productid=" + sPRODUCTID;
XmlAttribute attdata_gall = xDoc.CreateAttribute("data-gall");
attdata_gall.Value = "portfolioGallery";
XmlAttribute attclass7 = xDoc.CreateAttribute("class");
attclass7.Value = "venobox";
XmlAttribute atttitle = xDoc.CreateAttribute("title");
atttitle.Value = sMANUFACTURER;
xlA.Attributes.Append(attHref);
//xlA.Attributes.Append(attdata_gall);
//xlA.Attributes.Append(attclass7);
xlA.Attributes.Append(atttitle);
xlA.InnerText = string.Format("{0} - {1}", sMANUFACTURER, sNAME);
xlH3.AppendChild(xlA);
}
//XmlElement xlDIV4 = xDoc.CreateElement("div");
//xlDIV3.AppendChild(xlDIV4);
//
//
//{
// XmlElement xlA2 = xDoc.CreateElement("a");
// XmlAttribute attHref2 = xDoc.CreateAttribute("href");
// attHref2.Value = sImgFullPath;
// XmlAttribute attdata_gall2 = xDoc.CreateAttribute("data-gall");
// attdata_gall2.Value = "portfolioGallery";
// XmlAttribute attclass72 = xDoc.CreateAttribute("class");
// attclass72.Value = "venobox";
// XmlAttribute atttitle2 = xDoc.CreateAttribute("title");
// atttitle2.Value = sMANUFACTURER;
//
// xlA2.Attributes.Append(attHref2);
// xlA2.Attributes.Append(attdata_gall2);
// xlA2.Attributes.Append(attclass72);
// xlA2.Attributes.Append(atttitle2);
//
// xlDIV4.AppendChild(xlA2);
//
// {
// XmlElement xlI = xDoc.CreateElement("i");
// XmlAttribute attClass8 = xDoc.CreateAttribute("class");
// attClass8.Value = "bx bx-plus";
// xlI.Attributes.Append(attClass8);
// xlI.InnerText = " ";
//
// xlA2.AppendChild(xlI);
// }
//
// XmlElement xlA23 = xDoc.CreateElement("a");
// XmlAttribute attHref23 = xDoc.CreateAttribute("href");
// attHref23.Value = "portfolio-details.aspx?productid=" + sPRODUCTID;
// XmlAttribute atttitle23 = xDoc.CreateAttribute("title");
// atttitle23.Value = "Portfolio Details";
//
// xlA23.Attributes.Append(attHref23);
// xlA23.Attributes.Append(atttitle23);
//
// xlDIV4.AppendChild(xlA23);
//
// {
// XmlElement xlI = xDoc.CreateElement("i");
// xlI.InnerText = " ";
// XmlAttribute attClass8 = xDoc.CreateAttribute("class");
// attClass8.Value = "bx bx-link";
// xlI.Attributes.Append(attClass8);
//
// xlA23.AppendChild(xlI);
// }
//
//}
}
}
}
}//while
reader2.Close();
}
}
divCategory.InnerHtml = xDoc.OuterXml;
// portfolio_flters.InnerText = sbInnerText.ToString();
}
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
{
}
}
