정훈's 프로그래밍

DataTable filteredDT = dt.Clone(); try { var queryGroupByPacking = ( from virtualTable in dt.AsEnumerable() group virtualTable by new { packing_no = virtualTable.Field("packing_no") } into newTable select new { packing_no = newTable.Key.packing_no }).Take(parcel_count); foreach (var packing in queryGroupByPacking) { foreach (var item in dt.Select(string.Format("{0} = '{1}'", "packing_no", packin..

confirmDelivery: async function () { var selectedPackingNo = []; var failure = []; const distinctPackingNo = Array.from(new Set(selectedPackingNo)); for (const value of distinctPackingNo) { if (await Page.confirmDeliverySync(value) == "Failure") { failure.push(value); } } if (failure.length > 0) { UIUtil.alert(String.format("There are some delivery confirm error error packing[{0}]", failure.toSt..

var my_Array = ["Mahesh","Jayesh","Ramesh","Jayesh","Suresh","Mahesh"]; var NewArray = my_Array.filter(function(element,index,self){ return index === self.indexOf(element); }); console.log(NewArray);

세로행 -> 가로행으로 변경 CREATE TABLE Sales ( Salesperson VARCHAR(50), Region VARCHAR(50), Sales INT ); INSERT INTO Sales (Salesperson, Region, Sales) VALUES ('John', 'North', 100), ('John', 'South', 150), ('John', 'East', 75), ('Mary', 'North', 200), ('Mary', 'South', 50), ('Mary', 'East', 125); SELECT Salesperson, [North], [South], [East] FROM ( SELECT Salesperson, Region, Sales FROM Sales ) AS SourceT..

let isChecked = $('#takenBefore').prop('checked'); console.log(isChecked); // true (if checked at the time) is() vs prop()? So, what's the difference between is() and prop() in this context? Both methods appear to work in much the same way from our perspective. So, what's the difference? is() has a bit more overhead processing and parsing than prop(). Even considering the fact that prop() doesn'..

SQL Server 데이터베이스 엔진 형식 .NET Framework 형식 bigint Int64 BigInt GetSqlInt64 Int64 GetInt64 binary Byte[] VarBinary GetSqlBinary Binary GetBytes bit Boolean Bit GetSqlBoolean Boolean GetBoolean char String Char[] Char GetSqlString AnsiStringFixedLength, String GetString GetChars date 1 (SQL Server 2008 and later) DateTime Date 1 GetSqlDateTime Date 1 GetDateTime datetime DateTime DateTime GetSqlDat..

"123".Substring(0, 60) // 총 문자열 길이가 3인데 0~60까지 문자열을 자르려고 하면 "Length" 오류가 발생한다. // 그래서 "PadRight" 함수를 이용해서 최소 길이를 60으로 설정해 주면 "Length" 오류를 회피할 수 있다. "123".PadRight(60).Substring(0, 60) PadRight https://learn.microsoft.com/ko-kr/dotnet/api/system.string.padright?view=net-6.0 Substring https://learn.microsoft.com/ko-kr/dotnet/api/system.string.substring?view=net-6.0

function SetOderType(orderType) { if ($.inArray(orderType, orderTypes) == -1) { orderTypes.push(orderType); } else { orderTypes = $.grep(orderTypes, function (value) { return value != orderType; }); } console.log(orderTypes); } 실행 결과 (2) ['ALL', 'DPC'] fulfillmentorderoperation.js?20221004121311:108 (3) ['ALL', 'DPC', 'PAT'] fulfillmentorderoperation.js?20221004121311:108 (4) ['ALL', 'DPC', 'PAT..

let text_break = '';let text_continue = '';for (let i = 0; i

Returns the number of characters of the specified string expression, excluding trailing spaces. 문자 수를 반환합니다. LEN ("string_expression")