정훈's 프로그래밍

if (attachFile != null && attachFile.ContentLength > 0) { string fileExtension = Path.GetExtension(attachFile.FileName); if(string.Compare(fileExtension, ".pdf", true) == 0 || string.Compare(fileExtension, ".doc", true) == 0 || string.Compare(fileExtension, ".docx", true) == 0 || string.Compare(fileExtension, ".hwp", true) == 0 || string.Compare(fileExtension, ".txt", true) == 0) { string filePa..

System.Net.HttpWebRequest wReq; System.Net.HttpWebResponse wRes; Uri uri = new Uri("https://www.allthegate.com/payment/mobilev2/transaction/ansim.jsp?storeID=" + StoreId + "&trackingID=" + tracking_id + "&type=approve"); wReq = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(uri); wReq.Method = "GET"; wReq.ServicePoint.Expect100Continue = false; using (wRes = (HttpWebResponse)wReq.GetRes..

select *from (select row_number() over(order by a.regDate desc) as rowNumber, a.*, b.OrderNo as OrderNumber, c.GoodsTitlefrom @DefaultData as aleft join t_order as b with(nolock)on a.OrderUid = b.Uidleft join t_order_info as c with(nolock)on b.Uid = c.OrderUidwhere convert(varchar(8), a.regDate, 112) between convert(varchar(8), @startDate, 112) and convert(varchar(8), @endDate, 112)) as tempTabl..

IList IDiscountMall.DiscountCategoryList(string area) { Dictionary param = new Dictionary(); param.Add("area", area); List discountCategory = new List(); IList discountCategoryList = this.totooutdoor.QueryForList("up_st_tto_t_goods_recom_discountCategoryList_select", param); foreach (DiscountCategoryEntityL item in discountCategoryList) { int categoryIndex = discountCategory.FindIndex( delegate(..

IEnumerable productionEntityL = from goods in this.shoppingCart.ProductionListOfShoppingCart("14156780851026495405", "100") where goods.CartUid == cartUid select goods;ProductionEntityL productionEntity = productionEntityL.First();

declare @CmCode varchar(20)set @CmCode = '05' select top 20row_number() over(order by a.RegDate asc) as No, a.Uid, b.CodeName, a.Subject, a.Content, a.IsTop9, a.ReadCnt, a.RegDatefrom t_faq as a with(nolock)left join t_common_code as b with(nolock)on a.Consult = b.CmCodewhere ((@CmCode = '' and 1=1)or (@CmCode = '05' and b.CmCode = @CmCode))and b.CmClass = 'CONSULT'order by a.RegDate desc 이 쿼리문의..

$(function() { $("#popularBrandList li:last").addClass("main_brand_end"); });

ASP.NET 인경우 혹은 ASP.NET MVC[ValidateInput(false)] public ActionResult EmailForm(EmailFormEntityU emailFormEntityU) {return View() }

한글만 $("#name").on("input propertychange", function(event) { var kor_check = /[^(가-힣ㄱ-ㅎㅏ-ㅣ)]/gi; if (kor_check.test($(this).val())) { $(this).val($(this).val().replace(kor_check, "")); } }); 영문 + 숫자만$(this).val($(this).val().replace(/[^a-zA-Z0-9]/g, ''));.css({ "ime-mode": "disabled" }); 숫자만$(".onlyPhonNumber").on("keydown", function(event) { if (event.keyCode == 8 || event.keyCode == 9 || event...

@cartUid = '42254,42255,' declare @convertCartUid table (cartUid bigint) while charindex(',', @cartUid) 0begininsert into @convertCartUid values(substring(@cartUid, 1, charindex(',', @cartUid)-1))set @cartUid = substring(@cartUid, charindex(',', @cartUid)+1, len(@cartUid)) end