protected Boolean NoticeViewBind() { string qryNoticeView = "Select staff_id,bnGroup,bnTitle,bnSubTitle,bnContent,viewCount,writeDT,modifyDT " + " FROM t_BoardNotice" + " WHERE bNotice_id=" + bnID; SqlDataReader drNotice; drNotice = dbUtil.MyExecuteReader(qryNoticeView); if (drNotice.Read()) { this.bNotice_id.Text = bnID; this.bnGroup.Text = drNotice["bnGroup"].ToString(); this.viewCount.Text = drNotice["viewCount"].ToString(); this.writeDT.Text = drNotice.GetDateTime(6).ToShortDateString(); if (drNotice["modifyDT"] != DBNull.Value) { this.modifyDT.Text += "최종수정일: " + drNotice.GetDateTime(7).ToShortDateString(); this.modifyDT.Visible = true; } this.bnTitle.Text = HTML.ReplaceTo(drNotice["bnTitle"].ToString(), "toHTML"); this.bnSubTitle.Text = HTML.ReplaceTo(drNotice["bnSubTitle"].ToString(), "toHTML"); if (this.bnSubTitle.Text == "") { this.bnSubTitle.Text = this.bnTitle.Text; } this.bnContent.Text = HTML.ReplaceTo(drNotice["bnContent"].ToString(), "toHTML"); drNotice.Close(); return(true); } else { return(false); } }
protected Boolean NewsViewBind() { string qryString = "Select bnsGroup,bnsTitle,bnsSubTitle,bnsContent,viewCount,staff_id,writeDT,modifyDT " + " FROM t_BoardNews" + " WHERE bNews_id=" + bnsID; SqlDataReader drNews; drNews = dbUtil.MyExecuteReader(qryString); if (drNews.Read()) { this.bNews_id.Text = bnsID; this.bnsGroup.Text = drNews["bnsGroup"].ToString(); this.viewCount.Text = drNews["viewCount"].ToString(); this.writeDT.Text = drNews.GetDateTime(6).ToShortDateString(); if (drNews["modifyDT"] != DBNull.Value) { this.modifyDT.Text += "최종수정일: " + drNews.GetDateTime(7).ToShortDateString(); this.modifyDT.Visible = true; } string tempTitle = drNews["bnsTitle"].ToString(); this.bnsTitle.Text = tempTitle; this.bnsTitle.ToolTip = tempTitle; this.bnsSubTitle.Text = HTML.ReplaceTo(drNews["bnsSubTitle"].ToString(), "toHTML"); if (this.bnsSubTitle.Text == "") { this.bnsSubTitle.Text = this.bnsTitle.Text; } this.bnsContent.Text = HTML.ReplaceTo(drNews["bnsContent"].ToString(), "toHTML"); drNews.Close(); return(true); } else { return(false); } }
private Boolean StaffFormBind() { string qryString = "Select staff_id,sLoginID,sLoginPW,position,staffNbr,sName,DeptName,sClass,subJobs,phone,cellularP,ExtNbr,sEmail,SSN,zipcode,address" + ",homepage,mark,sLevel,sBusinessPic,sAvataImage,sData,joinDT" + " FROM t_Staff" + " WHERE staff_id=" + _sfID; qryString += ";Select annGroup,itemFlag,annDate FROM t_Anniversary WHERE annGroup<100 AND item_id=" + _sfID; SqlDataReader drStaff; DBLib dbUtil = new DBLib(); drStaff = dbUtil.MyExecuteReader(qryString); if (drStaff.Read()) { string[] arrTemp; //this.staff_id.Text = sfID; this.sLoginID.Text = drStaff["sLoginID"].ToString(); this.sLoginPW.Text = drStaff["sLoginPW"].ToString(); position.Text = PtnBaseLib.Self.GetPartnerCompany(Convert.ToInt16(Cookie.Self["position"])); this.staffNbr.Text = drStaff["staffNbr"].ToString(); this.sName.Text = drStaff["sName"].ToString(); this.DeptName.SelectedValue = drStaff["DeptName"].ToString(); this.sClass.SelectedValue = TableConfig.GetKey("Class_root", drStaff["sClass"].ToString()); this.subJobs.Text = drStaff["subJobs"].ToString(); arrTemp = drStaff["phone"].ToString().Split('-'); if (arrTemp.Length > 0) { this.phone1.Text = arrTemp[0]; this.phone2.Text = arrTemp[1]; this.phone3.Text = arrTemp[2]; arrTemp = null; } arrTemp = drStaff["cellularP"].ToString().Split('-'); if (arrTemp.Length > 0) { this.cellularP1.Text = arrTemp[0]; this.cellularP2.Text = arrTemp[1]; this.cellularP3.Text = arrTemp[2]; arrTemp = null; } this.ExtNbr.Text = drStaff["ExtNbr"].ToString(); this.sEmail.Text = drStaff["sEmail"].ToString(); arrTemp = drStaff["SSN"].ToString().Split('-'); if (arrTemp.Length > 0) { this.SSN1.Text = arrTemp[0]; this.SSN2.Text = arrTemp[1]; arrTemp = null; } this.zipcode.Text = drStaff["zipcode"].ToString(); arrTemp = drStaff["address"].ToString().Split('|'); if (arrTemp.Length > 1) { this.address1.Text = arrTemp[0]; this.address2.Text = arrTemp[1]; arrTemp = null; } this.homepage.Text = drStaff["homepage"].ToString(); this.mark.Text = drStaff["mark"].ToString(); this.sLevel.Text = drStaff["sLevel"].ToString(); //뷰스테이트로 파일 경로 저장 (체크박스 툴팁이용) //PostState.Self["sBusinessPic"] = drStaff["sBusinessPic"].ToString(); //PostState.Self["sAvataImage"] = drStaff["sAvataImage"].ToString(); //PostState.Self["sData"] = drStaff["sData"].ToString(); this.sBusinessPic.ImageUrl = SystemConfig.GetValue("StaffUploadDir") + Text.SetDefaultValue(drStaff["sBusinessPic"].ToString(), "MyPic_default.gif"); this.sBusinessPic.Style["cursor"] = "hand"; this.sBusinessPic.Attributes["OnClick"] = "javascript:ZoomWindowOpen('" + this.sBusinessPic.ImageUrl + "','bizPic','');"; //이미지 리사이즈 JinsLibrary.IMAGE.ImageLib.Self.ImageResize(ref sBusinessPic, 150, 200); this.sAvataImage.ImageUrl = @"../../zUpload/stfData/" + Text.SetDefaultValue(drStaff["sAvataImage"].ToString(), "MyPic_default.gif"); this.joinDT.Text = drStaff["joinDT"].ToString(); //파일 보존 체크박스처리 if (drStaff["sBusinessPic"].ToString() != "") { cbKeepBP.Visible = true; cbKeepBP.Checked = true; cbKeepBP.ToolTip = drStaff["sBusinessPic"].ToString(); } if (drStaff["sAvataImage"].ToString() != "") { cbKeepAI.Visible = true; cbKeepAI.Checked = true; cbKeepAI.ToolTip = drStaff["sAvataImage"].ToString(); } if (drStaff["sData"].ToString() != "") { cbKeepData.Visible = true; cbKeepData.Checked = true; cbKeepData.ToolTip = drStaff["sData"].ToString(); } //기념일 셋팅 if (drStaff.NextResult()) { string annDate; while (drStaff.Read()) { if (drStaff["annDate"].ToString() != "") { annDate = Convert.ToDateTime(drStaff["annDate"]).ToShortDateString(); } else { annDate = ""; } //Response.Write("----> " + drStaff["annDate"].ToString()); switch (Convert.ToInt32(drStaff["annGroup"])) { case 10: //생일 Util.RBLFindByValue(ref rblSLBirth, drStaff["itemFlag"].ToString()); this.tbBirthDay.Text = annDate; //Convert.ToDateTime(drStaff["annDate"]).ToShortDateString(); break; case 20: //결혼기념일 Util.RBLFindByValue(ref rblMarried, drStaff["itemFlag"].ToString()); //this.rblMarried.SelectedValue = drStaff["itemFlag"].ToString(); //되냉 if (rblMarried.SelectedValue == "미") { ClientAction.WriteJavascript(this, "pnWA", "pnWA.style.display='none';"); } else if (drStaff["annDate"].ToString() != "") { this.tbWeddingDay.Text = annDate; //Convert.ToDateTime(drCard["annDate"]).ToShortDateString(); } break; } } } //기획/관리부가 아닐때 수정못하게... if (Convert.ToInt16(Cookie.Self["sLevel"]) < 30) { this.staffNbr.Enabled = false; this.sClass.Enabled = false; this.DeptName.Enabled = false; this.joinDT.Enabled = false; this.dSelectorJoinDay.Visible = false; } drStaff.Close(); //DB닫기 dbUtil.SqlConnection.Close(); return(true); } else { return(false); } }
private void MemberViewBind() { _dbUtil = new DBLib(); string qryString = "Select member_id,loginID,loginPW,MbrName,MbrEmail,phone,cellularP,zipcode,address,findingID,findingA,SSN,newsLetter" + " FROM t_Member WHERE member_id=" + _mbID; qryString += ";Select mLevel,howMuch,howMany,RFund,RFundAC,point,pointAC,unpaid,unpaidAC,rcmderID,joinDT,modifyDT,recentLogin,IPaddress,leaveDT" + " FROM t_MemberValue WHERE member_id=" + _mbID; qryString += ";Select homepage,messenger,hobbies,carInfo,children,avataImage,monthlyPay,mark" + " FROM t_MemberOption WHERE member_id=" + _mbID; qryString += ";Select company,jobType,officeP,zipcode,address" + " FROM t_MemberJob WHERE member_id=" + _mbID; qryString += ";Select annGroup,itemFlag,annDate FROM t_Anniversary WHERE (annGroup BETWEEN 200 AND 220) AND item_id=" + _mbID; SqlDataReader drMember; drMember = _dbUtil.MyExecuteReader(qryString); if (drMember.Read()) //기본정보 { this.member_id.Text = _mbID; ViewState["mbID"] = _mbID; if (Convert.ToInt32(_mbID) > 0) { litFakeMbr.Text = "정상회원입니다."; } else { litFakeMbr.Text = "가짜회원입니다."; } this.member_id.Text = drMember["member_id"].ToString(); this.loginID.Text = drMember["loginID"].ToString(); this.loginPW.Text = drMember["loginPW"].ToString(); this.MbrName.Text = drMember["MbrName"].ToString(); this.phone.Text = drMember["phone"].ToString(); this.cellularP.Text = drMember["cellularP"].ToString(); this.hlEmail.Text = drMember["MbrEmail"].ToString(); string strSendonemail = this.MbrName.Text + " <" + this.hlEmail.Text + ">;"; this.hlEmail.NavigateUrl = "../Mine/Mail/MailForm.aspx?s=" + strSendonemail; this.SSN.Text = drMember["SSN"].ToString(); this.mAddress.Text = "[" + drMember["zipcode"].ToString().Substring(0, 3) + "-" + drMember["zipcode"].ToString().Substring(3, 3) + "] "; this.mAddress.Text += drMember["address"].ToString().Replace("|", " "); if (Convert.ToBoolean(drMember["newsLetter"].ToString())) { this.newsLetter.Text = "신청"; } else { this.newsLetter.Text = "비신청"; } //Response.Write("newsLetter =" + drMember["newsLetter"].ToString()); //아이디/패스워드 잊어 버렸을 때 QnA. SortedList mySL = JinsLibrary.XML.XmlLib.Self.GetResxList("/App_Data/resx/FindingMbrInfo.resx"); if (mySL.ContainsKey(Convert.ToInt16(drMember["findingID"]))) { this.findingID.Text = mySL[Convert.ToInt16(drMember["findingID"])].ToString(); this.findingA.Text = drMember["findingA"].ToString(); //JinsLibrary.CONTROL.Util.DDLAddItem(ref ddl, mySL); } if (drMember.NextResult()) //평가치 { drMember.Read(); this.mLevel.Text = MbrBaseLib.Self.GetStatusText((byte)drMember["mLevel"]); this.howMuch.Text = MathLib.GetComma(drMember["howMuch"]); this.howMany.Text = MathLib.GetComma(drMember["howMany"]); this.RFund.Text = MathLib.GetComma(drMember["RFund"]); this.RFundAC.Text = MathLib.GetComma(drMember["RFundAC"]); this.point.Text = MathLib.GetComma(drMember["point"]); this.pointAC.Text = MathLib.GetComma(drMember["pointAC"]); this.unpaid.Text = MathLib.GetComma(drMember["unpaid"]); this.unpaidAC.Text = MathLib.GetComma(drMember["unpaidAC"]); this.rcmderID.Text = drMember["rcmderID"].ToString(); this.joinDT.Text = drMember["joinDT"].ToString(); this.modifyDT.Text = drMember["modifyDT"].ToString(); this.recentLogin.Text = drMember["recentLogin"].ToString(); this.IPaddress.Text = drMember["IPaddress"].ToString(); this.leaveDT.Text = drMember["leaveDT"].ToString(); if (this.leaveDT.Text != "") { this.mLevel.Text += " <b>[탈퇴회원]</b>"; } } if (drMember.NextResult()) //부가정보 { if (drMember.Read()) { if (drMember["avataImage"].ToString() != "") { this.avataImage.ImageUrl = SystemConfig.GetValue("MemberPicUploadDir") + Text.SetDefaultValue(drMember["avataImage"].ToString(), "MbrPic_default.gif"); this.avataImage.Style["cursor"] = "hand"; this.avataImage.Attributes["onClick"] = "javascript:ZoomWindowOpen('" + this.avataImage.ImageUrl + "','avaPic','');"; this.avataImage.ToolTip = "큰 이미지보기"; //이미지 리사이즈 JinsLibrary.IMAGE.ImageLib.Self.ImageResize(ref avataImage, 280, 300); } if (drMember["homepage"].ToString() != "") { this.hlHomepage.Text = "http://" + drMember["homepage"].ToString(); this.hlHomepage.NavigateUrl = "http://" + drMember["homepage"].ToString(); this.hlHomepage.Target = "_blank"; } if (drMember["messenger"].ToString() != "|") { this.messenger.Text = drMember["messenger"].ToString().Replace("|", " / "); } this.hobbies.Text = drMember["hobbies"].ToString().Replace(";", "; "); this.carInfo.Text = MbrBaseLib.Self.GetCarInfoText(drMember["carInfo"].ToString()); this.monthlyPay.Text = MbrBaseLib.Self.GetMonthlyPayText(drMember["monthlyPay"].ToString()); this.children.Text = drMember["children"].ToString(); this.mark.Text = HTML.ReplaceToHTML(drMember["mark"].ToString()); //부가정보보여주기 pnAdditionalInfo.Visible = true; } } if (drMember.NextResult()) //회사정보 { if (drMember.Read()) { this.company.Text = drMember["company"].ToString(); this.jobType.Text = drMember["jobType"].ToString(); if (drMember["officeP"].ToString().Trim() != "--") { this.officeP.Text = drMember["officeP"].ToString(); } if (drMember["address"].ToString() != "|") { this.oAddress.Text = "[" + drMember["zipcode"].ToString().Substring(0, 3) + "-" + drMember["zipcode"].ToString().Substring(3, 3) + "] "; this.oAddress.Text += drMember["address"].ToString().Replace("|", " "); } //부가정보보여주기 pnAdditionalInfo.Visible = true; } } if (drMember.NextResult()) //기념일 셋팅 { while (drMember.Read()) { switch (Convert.ToInt32(drMember["annGroup"])) { case 200: //생일 string anniversary = ""; if (drMember["annDate"].ToString() != "") { anniversary = Convert.ToDateTime(drMember["annDate"]).ToShortDateString() + " (" + drMember["itemFlag"].ToString() + ")"; } this.litBirthDay.Text = anniversary; break; case 210: //결혼기념일 if (drMember["itemFlag"].ToString() == "미") { this.litWeddingDay.Text = "미혼"; } else if (drMember["annDate"].ToString() != "") { this.litWeddingDay.Text = Convert.ToDateTime(drMember["annDate"]).ToShortDateString(); } break; } } } //DR,DB닫기 drMember.Close(); _dbUtil.SqlConnection.Close(); } else { ClientAction.ShowMsgBack("해당 데이터가 없습니다."); } }
private Boolean MemberFormBind() { _dbUtil = new DBLib(); string qryString = "Select member_id,loginID,loginPW,MbrName,MbrEmail,phone,cellularP,zipcode,address,findingID,findingA,SSN,newsLetter" + " FROM t_Member WHERE member_id=" + _mbID; qryString += ";Select mLevel,howMuch,howMany,RFund,RFundAC,point,pointAC,unpaid,unpaidAC,rcmderID,joinDT,recentLogin,IPaddress,leaveDT" + " FROM t_MemberValue WHERE member_id=" + _mbID; qryString += ";Select homepage,messenger,hobbies,carInfo,children,avataImage,monthlyPay,mark" + " FROM t_MemberOption WHERE member_id=" + _mbID; qryString += ";Select company,jobType,officeP,zipcode,address" + " FROM t_MemberJob WHERE member_id=" + _mbID; qryString += ";Select annGroup,itemFlag,annDate FROM t_Anniversary WHERE (annGroup BETWEEN 200 AND 220) AND item_id=" + _mbID; SqlDataReader drMember; drMember = _dbUtil.MyExecuteReader(qryString); if (drMember.Read()) //기본정보 { string[] arrTemp; this.member_id.Text = drMember["member_id"].ToString(); if (Convert.ToInt32(this.member_id.Text) > 0) { cbProMbr.Checked = false; } else { cbProMbr.Checked = true; } cbProMbr.Enabled = false;//수정안됨. this.loginID.Text = drMember["loginID"].ToString(); loginID.ReadOnly = true; loginID.BorderStyle = BorderStyle.None; bnLoginID.Visible = false; this.loginPW.Text = drMember["loginPW"].ToString(); this.MbrName.Text = drMember["MbrName"].ToString(); arrTemp = drMember["phone"].ToString().Split('-'); if (arrTemp.Length > 0) { this.phone1.Text = arrTemp[0]; this.phone2.Text = arrTemp[1]; this.phone3.Text = arrTemp[2]; arrTemp = null; } arrTemp = drMember["cellularP"].ToString().Split('-'); if (arrTemp.Length > 0) { Util.DDLFindByText(ref cellularP1, arrTemp[0]); this.cellularP2.Text = arrTemp[1]; this.cellularP3.Text = arrTemp[2]; if (arrTemp[0] != "") { cellularP1.Items.RemoveAt(0); } arrTemp = null; } this.MbrEmail.Text = drMember["MbrEmail"].ToString(); arrTemp = drMember["SSN"].ToString().Split('-'); if (arrTemp.Length > 0) { this.SSN1.Text = arrTemp[0]; this.SSN2.Text = arrTemp[1]; arrTemp = null; } this.zipcode.Text = drMember["zipcode"].ToString(); arrTemp = drMember["address"].ToString().Split('|'); if (arrTemp.Length > 1) { this.mAddress1.Text = arrTemp[0]; this.mAddress2.Text = arrTemp[1]; arrTemp = null; } if (Convert.ToBoolean(drMember["newsLetter"])) { this.newsLetter.Checked = true; } else { this.newsLetter.Checked = false; }; //아이디/패스워드 잊어 버렸을 때 QnA. Util.DDLFindByValue(ref findingID, drMember["findingID"].ToString()); if (drMember["findingID"].ToString() != "") { findingID.Items.RemoveAt(0); } this.findingA.Text = drMember["findingA"].ToString(); if (drMember.NextResult()) //평가치 { drMember.Read(); this.rcmderID.Text = drMember["rcmderID"].ToString(); rcmderID.ReadOnly = true; rcmderID.BorderStyle = BorderStyle.None; rcmderID.ToolTip = "수정할 수 없습니다."; bnRcmderID.Visible = false; Util.DDLFindByValue(ref ddlMLevel, drMember["mLevel"].ToString()); /* * this.howMuch.Text = MathLib.GetComma(drMember["howMuch"]); * this.howMany.Text = MathLib.GetComma(drMember["howMany"]); * this.RFund.Text = MathLib.GetComma(drMember["RFund"]); * this.RFundAC.Text = MathLib.GetComma(drMember["RFundAC"]); * this.point.Text = MathLib.GetComma(drMember["point"]); * this.pointAC.Text = MathLib.GetComma(drMember["pointAC"]); * this.unpaid.Text = MathLib.GetComma(drMember["unpaid"]); * this.unpaidAC.Text = MathLib.GetComma(drMember["unpaidAC"]); * this.joinDT.Text = drMember["joinDT"].ToString(); * this.recentLogin.Text = drMember["recentLogin"].ToString(); * this.IPaddress.Text = drMember["IPaddress"].ToString(); * this.leaveDT.Text = drMember["leaveDT"].ToString(); */ } if (drMember.NextResult()) //부가정보 { if (drMember.Read()) { //파일 보존 체크박스처리 if (drMember["avataImage"].ToString() != "") { cbDeleteAI.Visible = true; cbDeleteAI.ToolTip = drMember["avataImage"].ToString(); this.avataImage.ImageUrl = SystemConfig.GetValue("MemberPicUploadDir") + drMember["avataImage"].ToString(); this.avataImage.Style["cursor"] = "hand"; this.avataImage.Attributes["OnClick"] = "javascript:ZoomWindowOpen('" + this.avataImage.ImageUrl + "','avaPic','');"; //이미지 리사이즈 JinsLibrary.IMAGE.ImageLib.Self.ImageResize(ref avataImage, 260, 300); } this.homepage.Text = drMember["homepage"].ToString(); arrTemp = drMember["messenger"].ToString().Split('|'); if (arrTemp.Length > 1) { this.MsgName.Text = arrTemp[0]; this.MsgID.Text = arrTemp[1]; } Util.CBLFindByText(ref hobbies, drMember["hobbies"].ToString().Split(';')); Util.DDLFindByValue(ref monthlyPay, drMember["monthlyPay"].ToString()); if (drMember["monthlyPay"].ToString() != "") { monthlyPay.Items.RemoveAt(0); } Util.DDLFindByValue(ref carInfo, drMember["carInfo"].ToString()); if (drMember["carInfo"].ToString() != "") { carInfo.Items.RemoveAt(0); } this.children.Text = drMember["children"].ToString(); this.mark.Text = drMember["mark"].ToString(); } } if (drMember.NextResult()) //회사정보 { if (drMember.Read()) { this.company.Text = drMember["company"].ToString(); Util.DDLFindByText(ref jobType, drMember["jobType"].ToString()); if (drMember["jobType"].ToString() != "") { jobType.Items.RemoveAt(0); } arrTemp = drMember["officeP"].ToString().Split('-'); if (arrTemp.Length > 0) { //Util.DDLFindByText(ref cellularP1, arrTemp[0].ToString()); this.officeP1.Text = arrTemp[0]; this.officeP2.Text = arrTemp[1]; this.officeP3.Text = arrTemp[2]; arrTemp = null; } this.oZipcode.Text = drMember["zipcode"].ToString(); arrTemp = drMember["address"].ToString().Split('|'); if (arrTemp.Length > 1) { this.oAddress1.Text = arrTemp[0]; this.oAddress2.Text = arrTemp[1]; arrTemp = null; } } } if (drMember.NextResult()) //기념일 셋팅 { while (drMember.Read()) { //Response.Write( drMember["itemFlag"].ToString()); switch (Convert.ToInt32(drMember["annGroup"])) { case 200: //생일 Util.RBLFindByValue(ref rblSLBirth, drMember["itemFlag"].ToString()); if (drMember["annDate"].ToString() != "") { this.tbBirthDay.Text = Convert.ToDateTime(drMember["annDate"]).ToShortDateString(); } break; case 210: //결혼기념일(양력없음) -->기혼 미혼 셋팅 Util.RBLFindByValue(ref rblMarried, drMember["itemFlag"].ToString()); if (rblMarried.SelectedValue == "기") { if (drMember["annDate"].ToString() != "") { this.tbWeddingDay.Text = Convert.ToDateTime(drMember["annDate"]).ToShortDateString(); } } break; } } } //DR,DB닫기 drMember.Close(); _dbUtil.SqlConnection.Close(); return(true); } else { return(false); } }
private void CellViewBind() { _dbUtil = new DBLib(); string qryString = "Select gCode_id,gName,modelNbr,custPrice,newPrice,transPrice,joinPrice,USimmPrice,Mfger,keywords,specSummary,gOrder,status,fruitRate,postStart,postEnd,point,reserveFund,registerDT,updateDT,register,IPaddress" + " FROM t_GoodsCell WHERE gCode_id=" + GdsCellBaseLib.Self.gCode_id; qryString += ";Select fileName,fileDESC" + " FROM t_GdsCellFiles WHERE gCode_id=" + GdsCellBaseLib.Self.gCode_id + " AND fileName LIKE 'S2%'"; qryString += ";Select scOptions, currStock " + " FROM t_CellStockCurrent WHERE gCode_id=" + GdsCellBaseLib.Self.gCode_id + " AND StkEnable = 1" + " ORDER BY scOrder DESC"; SqlDataReader drGoods = _dbUtil.MyExecuteReader(qryString); if (drGoods.Read()) //기본정보 { //this.fvCell.Controls[gCode_id]// this.gCode_id.Text = drGoods["gCode_id"].ToString(); this.modelNbr.Text = drGoods["modelNbr"].ToString(); this.gName.Text = drGoods["gName"].ToString(); Title = String.Format("서비스정보 > 휴대폰정보 > {0}({1})", gName.Text, modelNbr.Text); this.keywords.Text = drGoods["keywords"].ToString(); this.custPrice.Text = MathLib.GetComma(drGoods["custPrice"]); this.newPrice.Text = MathLib.GetComma(drGoods["newPrice"]); this.transPrice.Text = MathLib.GetComma(drGoods["transPrice"]); this.joinPrice.Text = MathLib.GetComma(drGoods["joinPrice"]); this.USimmPrice.Text = MathLib.GetComma(drGoods["USimmPrice"]); this.Mfger.Text = drGoods["Mfger"].ToString(); //this.fruitRate.Text = MathLib.GetComma(drGoods["fruitRate"]); //this.gOrder.Text = MathLib.GetComma(drGoods["gOrder"]); this.point.Text = MathLib.GetComma(drGoods["point"]); this.reserveFund.Text = MathLib.GetComma(drGoods["reserveFund"]); //this.registerDT.Text = drGoods["registerDT"].ToString(); //this.updateDT.Text = drGoods["updateDT"].ToString(); //this.register.Text = drGoods["register"].ToString(); this.specSummary.Text = drGoods["specSummary"].ToString(); this.status.Text = GdsCellBaseLib.Self.GetStatusText(drGoods["status"]); if (drGoods["status"].ToString() == "10") { hlAskPrice.Visible = true; hlAskPrice.NavigateUrl = "/CustomerServices/QnA/QnA_Master.aspx?qgrp=quota&qgi=" + Server.UrlEncode(modelNbr.Text); } hlAskGoods.NavigateUrl = "/CustomerServices/QnA/QnA_Master.aspx?qnaCX=form&qgrp=gds&qgi=" + Server.UrlEncode(modelNbr.Text); //Response.Write(drGoods["status"].ToString()); //게시기간 string postEnd = drGoods["postEnd"].ToString(); //게시종료일 this.litDisplayTerm.Text = drGoods["postStart"].ToString() + " ~ "; if (postEnd != "") { this.litDisplayTerm.Text += postEnd; } else { this.litDisplayTerm.Text += "영구게시"; } //특정상품셋팅 if (GdsCellBaseLib.Self.IsPopularGoods(this.gCode_id.Text)) { this.GoodsClass.Text = "인기상품, "; imgPopular.ImageUrl = "/Shop/Images/popular.gif"; imgPopular.Visible = true; } SortedList slSG = GdsCellBaseLib.Self.GetSpecificGcID(this.gCode_id.Text); for (int i = 0; i < slSG.Count; i++) { //Response.Write(String.Format("\t{0}:\t{1}", slSG.GetKey(i), slSG.GetByIndex(i))); this.GoodsClass.Text += slSG.GetByIndex(i) + ", "; if (slSG.GetKey(i).ToString() == "1") { imgRecommand.Visible = true; } else if (slSG.GetKey(i).ToString() == "3") { imgBest.Visible = true; } else if (slSG.GetKey(i).ToString() == "5") { imgSpecial.Visible = true; } } if (GoodsClass.Text.Length > 2) { this.GoodsClass.Text = GoodsClass.Text.Substring(0, GoodsClass.Text.Length - 2); } //상품데이터 폴더 _GdsUploadDir = SystemConfig.GetValue("GdsUploadDir") + "GC" + this.gCode_id.Text + "/"; this.hlLargeImages.NavigateUrl = "javascript:GoLargeImageView('" + GdsCellBaseLib.Self.gCode_id + "');"; //htmlPage페이지확인 string htmlPage = ""; //if (drGoods["htmlPage"].ToString() != "") // htmlPage = drGoods["htmlPage"].ToString(); //else htmlPage = _GdsUploadDir + "Detail_" + gCode_id.Text + ".html"; //Detail.html확인 if (FileLib.Self.FileExist(htmlPage)) { pnDetailedHTML.Visible = true; //WebUtil.CurrentResponse.Write("htmlPage = " + htmlPage); this.litHTML.Text = FileLib.Self.LoadHtmlPage(Application["BaseHref"].ToString(), htmlPage); //this.litHTML.Text = GdsCellBaseLib.Self.LoadHtmlPage(Application["BaseHref"].ToString(), htmlPage); } //else if (drGoods["htmlPage"].ToString() != "") //{ // pnDetailedHTML.Visible = true; // this.litHTML.Text = "파일경로에러"; //} //string strSendonemail = this.MbrName.Text + " <" + this.hlEmail.Text +">;"; //this.hlEmail.NavigateUrl = "../Mine/Mail/MailForm.aspx?s=" + strSendonemail; if (drGoods.NextResult()) //이미지파일정보 { if (drGoods.HasRows) { this.hlLargeImages.Visible = true; this.dlGdsImages.DataSource = drGoods; this.dlGdsImages.DataBind(); //바인딩하기 전에 drGds.Read();하지 말것. } } if (drGoods.NextResult()) //스탁정보 { while (drGoods.Read()) { this.currStock.Text += drGoods["scOptions"].ToString() + " => " + drGoods["currStock"].ToString() + "<br> "; } if (this.currStock.Text == "") { this.currStock.Text = "재고관리대상아님"; } } //DR,DB닫기 drGoods.Close(); _dbUtil.SqlConnection.Close(); } else { CompanyItems_CIMasterPage_wide master = this.Master; //MainMasterPage master = (MainMasterPage)this.Master; master.FindControl("ucClientMessage").Visible = true; master.LitMsgText = "The Goods Don't Exist!!"; master.LitDetailsText = "요구하신 상품의 정보가 존재하지 않습니다."; master.HlBackVisible = true; tblCellView.Visible = false; } }