정훈's 프로그래밍

여러건을 한번에 치환하기 Dictionary dic = new Dictionary() { {"", "rows chnaged to new value"} }; Console.WriteLine( dic.Aggregate ( "old change", (current, item) => current.Replace (item.Key, item.Value) ) );

List 객체에 특정 값이 존재하는지 Where을 사용하여 확인 하는 예제입니다. var isThereEmptyValueInSkuNo = warehouseOutScanningInfo.Where(valueCheck => string.IsNullOrWhiteSpace(valueCheck.sku_no)); if (isThereEmptyValueInSkuNo.Count() > 0) { // 메세지 }

#if (DEBUG && !MYTEST) Console.WriteLine("DEBUG is defined"); #elif (!DEBUG && MYTEST) Console.WriteLine("MYTEST is defined"); #elif (DEBUG && MYTEST) Console.WriteLine("DEBUG and MYTEST are defined"); #else Console.WriteLine("DEBUG and MYTEST are not defined"); #endif

create sequence dbo.seq_name as [int] start with 1 increment by 1 maxvalue 999999 declare @grn_sequence_no int = next value for dbo.seq_name select format(getdate(), 'yyyyMMdd') + '-' + format(@grn_sequence_no, 'd6') 참조 자료] 날짜 및 시간 스타일 https://docs.microsoft.com/ko-kr/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-2017 포멧(Format) https://docs.microsoft.com/ko-kr/sql/t-sql/func..

WebClient wc = new WebClient(); wc.Encoding = System.Text.Encoding.UTF8; string api_key = ""; string url = "https://"; var data = wc.DownloadString(url);

SELECT columName , ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS rownum FROM dbo.Transactions 참조 사이트 https://stackoverflow.com/questions/44105691/row-number-without-order-by

var test1 = this.Wordbook.WordbookListT(1); var test2 = this.Wordbook.WordbookListT(1); T IWordbook.List(long memberNo) { if(typeof(T) == typeof(List)) { return (T)Convert.ChangeType(this.DoctorslDCC.Wordbook_Select_List_AtWordView(memberNo).ToList(), typeof(T)); } else if (typeof(T) == typeof(List)) { return (T)Convert.ChangeType(this.DoctorslDCC.Wordbook_Select_List_My(memberNo).ToList(), type..

ViewPage.ViewBag 속성 정의 네임스페이스:System.Web.Mvc어셈블리:System.Web.Mvc.dll패키지:Microsoft.AspNet.Mvc v5.2.6 뷰 모음을 가져옵니다. C#복사 public dynamic ViewBag { get; }속성 값Object 뷰 모음입니다. ViewPage.ViewData 속성 정의 네임스페이스:System.Web.Mvc어셈블리:System.Web.Mvc.dll패키지:Microsoft.AspNet.Mvc v5.2.6 컨트롤러와 뷰 간에 전달할 데이터가 들어 있는 사전을 가져오거나 설정합니다. C#복사 public System.Web.Mvc.ViewDataDictionary ViewData { get; set; }속성 값ViewDataDiction..

public ObjectResult ChattingRoom_Select_ChattingRoomInfo(string chattingRoomId) { return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery( "dbo.[ChattingRoom_Select_ChattingRoomInfo] @ChattingRoomId", new object[] { new SqlParameter("@ChattingRoomId", chattingRoomId) } ) ?? (ObjectResult)Convert.ChangeType(new ChattingRoom_Select_ChattingRoomInfo_Result(), typeof(ObjectResult)); }

1. SignalR 설치 2. Startup.cs Class 생성 using Owin; using Microsoft.Owin; using Microsoft.AspNet.SignalR; [assembly: OwinStartup(typeof(DoctorSL.WebApp.Startup))] namespace DoctorSL.WebApp { public class Startup { public void Configuration(IAppBuilder app) { HubConfiguration hubConfiguration = new HubConfiguration() { EnableJSONP = true }; app.MapSignalR(hubConfiguration); } } } 3. SignalR Hub Clas..