public void Load(int iID)
{
CDbScheduleHour dbDt = new CDbScheduleHour();
string tmpDat;
tmpDat = dbDt.GetByID(iID);
Clear();
if (tmpDat.Length > 0)
{
LoadVals(tmpDat);
}
dbDt = null;
}
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);
}
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);
}
public static void MoveAllTimeByWeek(int deptID, int projID, int wkID, int wkMove)
{
CDbScheduleHour dbDt = new CDbScheduleHour();
dbDt.MoveAllTimeByWeek(deptID, projID, wkID, wkMove);
}
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);
}
public static COScheduleHour.GridHoursLevel GetEmployeeTimeLevel(int empID, int wkID, COScheduleHour.ScheduleHourType type)
{
CDbScheduleHour dbDt = new CDbScheduleHour();
return(dbDt.GetEmployeeTimeLevel(empID, wkID, type));
}
public static SqlDataReader GetListByRange(int deptID, DateTime sDate, DateTime eDate)
{
CDbScheduleHour dbDt = new CDbScheduleHour();
return(dbDt.GetListByRange(deptID, sDate, eDate));
}
public static SqlDataReader GetList()
{
CDbScheduleHour dbDt = new CDbScheduleHour();
return(dbDt.GetList());
}
public static void Delete(int cID)
{
CDbScheduleHour dbDt = new CDbScheduleHour();
dbDt.Delete(cID);
}