예제 #1
0
파일: Database.cs 프로젝트: colinnaylor/CN
        internal static System.Data.DataSet GetWorkSummary(DateTime FromDate, DateTime ToDate, string Employee)
        {
            GetDbConn();
            string sql;

            if (Employee.Trim() == "")
            {
                sql = "EXEC GetWorkSummary '{0}','{1}', null".Args(FromDate.ToString("yyyyMMdd"), ToDate.ToString("yyyyMMdd"));
            }
            else
            {
                sql = "EXEC GetWorkSummary '{0}','{1}','{2}'".Args(FromDate.ToString("yyyyMMdd"), ToDate.ToString("yyyyMMdd"), Employee);
            }

            System.Data.DataSet ret = SQLServer.FetchDataSet(conn, sql);

            return(ret);
        }