일일 업무일지 체크 Sql Query 시간범위 체크 SELECT COUNT(*) as 'Count', [DailyReportID] FROM [DailyReport] WHERE [ProjectID]=4 AND [DATE] BETWEEN '2020-12-01 00:00:00' AND '2020-12-01 23:59:59' GROUP BY [DailyReportID] C# asp.net public void DailyReportDateCheck(string projectID, string date,out bool isExist, out string reportID) { string[] day = date.Split('-'); DateTime startDate = new DateTime(int.Parse(day[0]), int.Parse(day[1]), int.Parse(day[2]), 0, 0, 0); DateTime endDate = new DateTime(int.Parse(day[0]), int.Parse(day[1]), int.Parse(day[2]), 23, 59, 59); string query = "SELECT COUNT(*) AS 'Count' , [DailyReportID] FROM [DailyReport] WHERE [ProjectID]="+ projectID + " AND [DATE] BETWEEN '"; query += String.Format("{0:yyyy-MM-dd HH:mm:ss}", startDate...
이 블로그의 인기 게시물
키스콘 건설업체 정보 서비스 (javascript, php)
html / javascript / php <!-- 건설업체 검색 모달 시작 --> < div class = "modal fade" id = "searchModal" > < div class = "modal-dialog" > < div class = "modal-content" > <!-- Modal Header --> < div class = "modal-header" > < h4 class = "modal-title" > 건설업 조회 서비스 </ h4 > < button type = "button" class = "close btn-sm" data-dismiss = "modal" > × </ button > </ div > <!-- Modal body --> < div class = "modal-body" > < div class = "row border-1 border-bottom pb-2" > < div class = "col-2 small" > 기간설정 </ div > < div class = "col-10" > ...
댓글
댓글 쓰기