//CONSTRUCTOR
public ExportViewModel()
{
//Initialize combo boxes
int MinYear = 2018, MaxYear = DateTime.Now.Year;
for (int i = 1; i <= 53; i++)
{
FromWeek.Add(i);
}
for (int i = MinYear; i <= MaxYear; i++)
{
FromYear.Add(i);
}
for (int i = 1; i <= 53; i++)
{
ToWeek.Add(i);
}
for (int i = MinYear; i <= MaxYear; i++)
{
ToYear.Add(i);
}
// Initalize default values now
// Instantiate a new calender based on the danish culture.
CultureInfo culInfo = new CultureInfo("da-DK");
Calendar cal = culInfo.Calendar;
// Get the current weeknumber based on the danish calender and current time.
int weekNumber = cal.GetWeekOfYear(DateTime.Now,
DateTimeFormatInfo.CurrentInfo.CalendarWeekRule,
DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek);
SelectedFromWeek = weekNumber;
SelectedToWeek = weekNumber;
SelectedFromYear = DateTime.Now.Year;
SelectedToYear = DateTime.Now.Year;
//Get outputlocation
FilePath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
//Find file name
UpdateFileName();
}
private void Lost_Year(object sender, RoutedEventArgs e)
{
//作成年月がNullだった場合今年の年を挿入
DateTime d作成年月From, d作成年月To;
string s作成年月From, s作成年月To;
if (string.IsNullOrEmpty(作成年月))
{
//作成日付が未入力の場合、当年を入力補助
string ToYear;
ToYear = DateTime.Today.ToString();
ToYear = ToYear.Substring(0, 4);
作成年月 = ToYear;
}
else if (作成年月 == "9999")
{
//作成年月 9999年入力時の日付を計算
s作成年月From = 作成年月 + "/" + "04" + "/" + "01";
s作成年月To = 作成年月 + "/" + "12" + "/" + "31";
d作成年月From = Convert.ToDateTime(s作成年月From);
d作成年月To = Convert.ToDateTime(s作成年月To);
//編集した値をBinding
集計期間From = d作成年月From;
集計期間To = d作成年月To;
return;
}
//集計期間 4月1日～3月31日の一年間
s作成年月From = 作成年月 + "/" + "04" + "/" + "01";
s作成年月To = 作成年月 + "/" + "03" + "/" + "31";
d作成年月From = Convert.ToDateTime(s作成年月From);
d作成年月To = Convert.ToDateTime(s作成年月To).AddYears(+1);
//編集した値をBinding
集計期間From = d作成年月From;
集計期間To = d作成年月To;
}
private void BindInitialValues()
{
ddPrjGroup.DataSource = ProjectGroup.GetProjectGroups();
ddPrjGroup.DataTextField = "Title";
ddPrjGroup.DataValueField = "ProjectGroupId";
ddPrjGroup.DataBind();
ddPrjGroup.Items.Insert(0, new ListItem(LocRM.GetString("AllFem"), "0"));
ddPrjGroup.Items.Add(new ListItem(LocRM.GetString("tCustom"), "-1"));
switch (ProjectListType)
{
case "All":
if (ddPrjGroup.Items.FindByValue("0") != null)
{
ddPrjGroup.SelectedValue = "0";
}
break;
case "Custom":
if (ddPrjGroup.Items.FindByValue("-1") != null)
{
ddPrjGroup.SelectedValue = "-1";
}
break;
case "Portfolio":
if (ddPrjGroup.Items.FindByValue(ProjectListData) != null)
{
ddPrjGroup.SelectedValue = ProjectListData;
}
break;
}
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("tTotalSum") });
ddFinanceType.DataSource = dt;
ddFinanceType.DataTextField = "Name";
ddFinanceType.DataValueField = "Id";
ddFinanceType.DataBind();
ddFinanceType.SelectedValue = FinanceType;
DataTable dt1 = new DataTable();
dt1.Columns.Add(new DataColumn("Id", typeof(int)));
dt1.Columns.Add(new DataColumn("Name", typeof(string)));
foreach (BasePlanSlot bps in BasePlanSlot.List())
{
DataRow dr = dt1.NewRow();
dr["Id"] = bps.BasePlanSlotId;
dr["Name"] = bps.Name;
dt1.Rows.Add(dr);
}
dt1.Rows.Add(new object[] { "-1", LocRM.GetString("tFact") });
dt1.Rows.Add(new object[] { "0", LocRM.GetString("tCurrent") });
DataView dv = dt1.DefaultView;
dv.Sort = "Id ASC";
ddBasePlan1.DataSource = dv;
ddBasePlan1.DataTextField = "Name";
ddBasePlan1.DataValueField = "Id";
ddBasePlan1.DataBind();
ddBasePlan1.SelectedValue = BasePlan1.ToString();
dt1.Rows.Add(new object[] { "-2", LocRM.GetString("tNotSelected") });
dv = dt1.DefaultView;
dv.Sort = "Id ASC";
ddBasePlan2.DataSource = dv;
ddBasePlan2.DataTextField = "Name";
ddBasePlan2.DataValueField = "Id";
ddBasePlan2.DataBind();
ddBasePlan2.SelectedValue = BasePlan2.ToString();
tbFromYear.Text = FromYear.ToString();
tbToYear.Text = ToYear.ToString();
ddGroupBy.Items.Clear();
ddGroupBy.Items.Add(new ListItem(LocRM.GetString("tByProject"), "false"));
ddGroupBy.Items.Add(new ListItem(LocRM.GetString("tByBusinessScore"), "true"));
ddGroupBy.SelectedValue = Reverse.ToString().ToLower();
}
