private void SetGridByDateRange(DateTime sDate, DateTime eDate, bool selDept, bool selProj) { int numWeeks; int numWeekCols; mdsWeeks = CBWeekList.GetList(sDate, eDate); // initialize fgSchedule.Styles.Normal.WordWrap = true; //numWeeks = RSLib.COUtility.NumberWeeksInRange(sDate, eDate); numWeeks = mdsWeeks.Tables[0].Rows.Count; numWeekCols = numWeeks * 3; fgSchedule.Cols.Count = WEEKCOLSTART + numWeekCols + TOTALCOLS; fgSchedule.Rows.Fixed = 2; fgSchedule.AllowMerging = AllowMergingEnum.FixedOnly; // create row headers fgSchedule.Rows[0].AllowMerging = true; fgSchedule.Cols[1].Width = 100; fgSchedule.Cols[2].Width = 100; fgSchedule.Cols[3].Width = 100; CreateWeekHeaders(); fgSchedule.Cols[0].AllowMerging = true; fgSchedule.Styles.Fixed.TextAlign = TextAlignEnum.CenterCenter; fgSchedule.AutoSizeCols(6, fgSchedule.Cols.Count - 1, 15); LoadGridByRange(0, sDate, eDate, selDept, selProj); }
public void SetProject(int deptID, int projID, int weekID, decimal totPlan, decimal totFor, decimal totAct) { CBProject p = new CBProject(); CBWeekList w = new CBWeekList(); CBCustomer c = new CBCustomer(); CBProjectBudget pb = new CBProjectBudget(); CBDepartment d = new CBDepartment(); p.Load(projID); miProjID = projID; w.Load(weekID); c.Load(p.CustomerID); pb.Load(deptID, projID); d.Load(deptID); txtNumber.Text = p.Number; txtWeek.Text = w.StartOfWeek.ToShortDateString(); txtStartDate.Text = p.DateStart.ToShortDateString(); txtEndDate.Text = p.DateEnd.ToShortDateString(); txtDescription.Text = p.Description; txtCustomer.Text = c.Name; if (d.Name.Length > 5) { lblBudget.Text = d.Name.Substring(0, 5) + " Bugt.:"; } else { lblBudget.Text = d.Name + " Bugt.:"; } txtTotBudget.Text = pb.BudgetHrs.ToString(DISPFORMAT); txtTotPlanned.Text = totPlan.ToString(DISPFORMAT); txtTotForecast.Text = totFor.ToString(DISPFORMAT); txtTotActual.Text = totAct.ToString(DISPFORMAT); txtRemaining.Text = ((decimal)(totFor + totAct)).ToString(DISPFORMAT); }