퐁낭그늘

  <script type="text/javascript">         $(document).ready(function () {             $(".divCreate").hide();         });         function CreateShow(div) {             $(".divCreate").hide();             $('#div' + div).show('slow');             switch (div) {                 case "Today":                     selectDataBind('ddlConBlock', 'Block');                     break;                 case "Tommorow":                     selectDataBind('ddlTomConBlock', 'Block');                     break;             }         }         function CreateHide(div) {             $('#div' + div).hide('slow');         }         //select DataBind         function selectDataBind(input, data) {             var selObj = document.getElementById(input);             var p_id = document.getElementById('<%=textProjectID.ClientID %>').value;             var myData = JSON.stringi

일일 업무일지 체크 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) + "' AND '";             query += String.Format("{0:yyyy-MM-dd HH:mm:ss}",