Example #1
0
        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);
        }