protected void BindBasePlans() { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Name", typeof(string))); dt.Columns.Add(new DataColumn("BasePlanSlotId", typeof(int))); Hashtable ht = ProjectSpreadSheet.GetFilledSlotHash(int.Parse(Request["ProjectId"])); if (ht.Keys.Count <= 0) { trBasePlanFilter.Visible = false; } foreach (BasePlanSlot bps in BasePlanSlot.List()) { DataRow row = dt.NewRow(); row["BasePlanSlotId"] = bps.BasePlanSlotId; DateTime d_time = DateTime.MinValue; if (ht.Contains(bps.BasePlanSlotId)) { foreach (BasePlan bp in BasePlan.List(int.Parse(Request["ProjectId"]))) { if (bp.BasePlanSlotId == bps.BasePlanSlotId) { d_time = bp.Created; break; } } } if (d_time != DateTime.MinValue) { row["Name"] = String.Format("{0} ({1}: {2})", bps.Name, LocRM.GetString("LastSaved"), d_time); } else { continue; } dt.Rows.Add(row); } ddlBasePlans.DataSource = dt; ddlBasePlans.DataTextField = "Name"; ddlBasePlans.DataValueField = "BasePlanSlotId"; ddlBasePlans.DataBind(); ddlBasePlans.Items.Insert(0, new ListItem(LocRM.GetString("NotSet"), "-1")); ddlBasePlans.SelectedValue = BasePlanSlotId.ToString(); }
void BindDropDown() { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Name", typeof(string))); dt.Columns.Add(new DataColumn("BasePlanSlotId", typeof(int))); Hashtable ht = ProjectSpreadSheet.GetFilledSlotHash(int.Parse(Request["ProjectId"])); int selvalue = -1; DateTime d_time = DateTime.Now; foreach (BasePlanSlot bps in BasePlanSlot.List()) { if (bps.IsDefault) { selvalue = bps.BasePlanSlotId; } DataRow row = dt.NewRow(); row["BasePlanSlotId"] = bps.BasePlanSlotId; if (ht.Contains(bps.BasePlanSlotId)) { foreach (BasePlan bp in BasePlan.List(int.Parse(Request["ProjectId"]))) { if (bp.BasePlanSlotId == bps.BasePlanSlotId) { d_time = bp.Created; break; } } row["Name"] = String.Format("{0} ({1}: {2})", bps.Name, LocRM.GetString("LastSaved"), d_time); //row["Created"] = ht[bps.BasePlanSlotId]; } else { row["Name"] = bps.Name; } dt.Rows.Add(row); } ddBasePlan.DataSource = dt; ddBasePlan.DataTextField = "Name"; ddBasePlan.DataValueField = "BasePlanSlotId"; ddBasePlan.DataBind(); ddBasePlan.SelectedValue = selvalue.ToString(); }
void BindDropDowns() { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Id", typeof(int))); dt.Columns.Add(new DataColumn("Name", typeof(string))); dt.Rows.Add(new object[] { 1, LocRM.GetString("tWeekYear") }); dt.Rows.Add(new object[] { 2, LocRM.GetString("tMonthQuarterYear") }); dt.Rows.Add(new object[] { 3, LocRM.GetString("tQuarterYear") }); dt.Rows.Add(new object[] { 4, LocRM.GetString("tYear") }); dt.Rows.Add(new object[] { 5, LocRM.GetString("tTotal") }); ArrayList list = new ArrayList(SpreadSheetTemplateInfo.List()); list.Sort(new SortComparer()); ddTemplate.DataSource = list; //SpreadSheetTemplateInfo.List(); ddTemplate.DataTextField = "Name"; ddTemplate.DataValueField = "FileName"; ddTemplate.DataBind(); ddDocType.DataSource = dt; ddDocType.DataTextField = "Name"; ddDocType.DataValueField = "Id"; ddDocType.DataBind(); ddDocType.SelectedValue = "2"; DataTable dt2 = new DataTable(); dt2.Columns.Add(new DataColumn("Id", typeof(int))); dt2.Columns.Add(new DataColumn("Name", typeof(string))); foreach (BasePlan bp in BasePlan.List(ProjectId)) { DataRow row = dt2.NewRow(); row["Id"] = bp.BasePlanSlotId; row["Name"] = String.Format("{0} ({1}: {2})", BasePlanSlot.Load(bp.BasePlanSlotId).Name, LocRM.GetString("LastSaved"), bp.Created); dt2.Rows.Add(row); } dt2.Rows.Add(new object[] { -1, LocRM.GetString("Fact") }); dt2.Rows.Add(new object[] { 0, LocRM.GetString("Current") }); DataView dv = dt2.DefaultView; dv.Sort = "Id ASC"; ddPrimarySheet.DataSource = dv; ddPrimarySheet.DataTextField = "Name"; ddPrimarySheet.DataValueField = "Id"; ddPrimarySheet.DataBind(); ddPrimarySheet.SelectedValue = "0"; dt2.Rows.Add(new object[] { -2, LocRM.GetString("NotSelected") }); ddSecondarySheet.DataSource = dv; ddSecondarySheet.DataTextField = "Name"; ddSecondarySheet.DataValueField = "Id"; ddSecondarySheet.DataBind(); ddSecondarySheet.SelectedValue = "-2"; tbFrom.Text = DateTime.Now.Year.ToString(); tbTo.Text = DateTime.Now.Year.ToString(); BindUserValues(); }