예제 #1
0
        public void Load(int iID)
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();
            string          tmpDat;

            tmpDat = dbDt.GetByID(iID);

            Clear();
            if (tmpDat.Length > 0)
            {
                LoadVals(tmpDat);
            }

            dbDt = null;
        }
예제 #2
0
        public int Save(HourTypeEnum hrType)
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();
            int             retVal;

            switch (hrType)
            {
            case HourTypeEnum.enForecast:
                retVal = dbDt.SaveHoursForecast(base.DepartmentID, base.ProjectID, base.EmployeeID, base.WeekID, base.FHrs);
                break;

            case HourTypeEnum.enActual:
                retVal = dbDt.SaveHoursActual(base.DepartmentID, base.ProjectID, base.EmployeeID, base.WeekID, base.AHrs);
                break;

            default:
                retVal = dbDt.SaveHoursPlan(base.DepartmentID, base.ProjectID, base.EmployeeID, base.WeekID, base.PHrs);
                break;
            }

            return(retVal);
        }
예제 #3
0
        public int Save()
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();
            string          tmpDat;
            int             retVal;

            tmpDat = GetDataString();

            if (base.ID > 0)
            {
                dbDt.SavePrev(tmpDat);
                retVal = base.ID;
            }
            else
            {
                retVal  = dbDt.SaveNew(tmpDat);
                base.ID = retVal;
            }

            dbDt = null;

            return(retVal);
        }
예제 #4
0
        public static void MoveAllTimeByWeek(int deptID, int projID, int wkID, int wkMove)
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();

            dbDt.MoveAllTimeByWeek(deptID, projID, wkID, wkMove);
        }
예제 #5
0
        public void GetProjectTotalByDate(int deptID, int projID, int weekID, ref decimal PTot, ref decimal FTot, ref decimal ATot)
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();

            dbDt.GetProjectTotalByDate(deptID, projID, weekID, ref PTot, ref FTot, ref ATot);
        }
예제 #6
0
        public static COScheduleHour.GridHoursLevel GetEmployeeTimeLevel(int empID, int wkID, COScheduleHour.ScheduleHourType type)
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();

            return(dbDt.GetEmployeeTimeLevel(empID, wkID, type));
        }
예제 #7
0
        public static SqlDataReader GetListByRange(int deptID, DateTime sDate, DateTime eDate)
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();

            return(dbDt.GetListByRange(deptID, sDate, eDate));
        }
예제 #8
0
        public static SqlDataReader GetList()
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();

            return(dbDt.GetList());
        }
예제 #9
0
        public static void Delete(int cID)
        {
            CDbScheduleHour dbDt = new CDbScheduleHour();

            dbDt.Delete(cID);
        }