private void LoadData()
{
DateTime today = DateTime.Now;
int year = today.Year;
int month = today.Month;
int day = today.Day;
string yearStr = year.ToString();
labTitle.Text = yearStr + " 年目标管理";
labAll.Label = UserInfo.Current.ChineseName + " " + yearStr + " 年总目标";
int userID = UserInfo.Current.ID;
Infobasis.Data.DataEntity.UserGoal userGoal = DB.UserGoals.Where(item => item.UserID == userID && item.Year == year).FirstOrDefault();
if (userGoal != null)
{
tbxInput1.Text = Change.ToString(userGoal.Month1);
tbxInput2.Text = Change.ToString(userGoal.Month2);
tbxInput3.Text = Change.ToString(userGoal.Month3);
tbxInput4.Text = Change.ToString(userGoal.Month4);
tbxInput5.Text = Change.ToString(userGoal.Month5);
tbxInput6.Text = Change.ToString(userGoal.Month6);
tbxInput7.Text = Change.ToString(userGoal.Month7);
tbxInput8.Text = Change.ToString(userGoal.Month8);
tbxInput9.Text = Change.ToString(userGoal.Month9);
tbxInput10.Text = Change.ToString(userGoal.Month10);
tbxInput11.Text = Change.ToString(userGoal.Month11);
tbxInput12.Text = Change.ToString(userGoal.Month12);
decimal group1 = userGoal.Month1.Value + userGoal.Month2.Value + userGoal.Month3.Value;
decimal group2 = userGoal.Month4.Value + userGoal.Month5.Value + userGoal.Month6.Value;
decimal group3 = userGoal.Month7.Value + userGoal.Month8.Value + userGoal.Month9.Value;
decimal group4 = userGoal.Month10.Value + userGoal.Month11.Value + userGoal.Month12.Value;
labGroup1.Text = Change.ToString(group1);
labGroup2.Text = Change.ToString(group2);
labGroup3.Text = Change.ToString(group3);
labGroup4.Text = Change.ToString(group4);
tbxRemark.Text = userGoal.Remark;
if (userGoal.LastUpdateDatetime.HasValue)
{
labLastUpdate.Text = userGoal.LastUpdateDatetime.Value.ToString("yyyy-MM-dd hh:mm:ss");
}
labAll.Text = Change.ToString(group1 + group2 + group3 + group4);
}
int groupVal = month / 3;
if (groupVal == 0)
{
GroupPanel1.CssClass = "activeGroupPanel";
}
if (groupVal == 1)
{
GroupPanel2.CssClass = "activeGroupPanel";
}
if (groupVal == 2)
{
GroupPanel3.CssClass = "activeGroupPanel";
}
if (groupVal == 3)
{
GroupPanel4.CssClass = "activeGroupPanel";
}
NumberBox inputControl = (NumberBox)GetControl(PanelMain, "tbxInput" + month.ToString());
if (inputControl != null)
{
inputControl.CssClass = "activeInputBox";
}
NumberBox[] numberBoxs = { tbxInput1, tbxInput2, tbxInput3, tbxInput4, tbxInput5, tbxInput6, tbxInput7, tbxInput8, tbxInput9, tbxInput10, tbxInput11, tbxInput12 };
int monthCount = 1;
foreach (NumberBox btn in numberBoxs)
{
btn.Label = yearStr + "-" + monthCount.ToString("00");
monthCount++;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int year = DateTime.Now.Year;
int userID = UserInfo.Current.ID;
Infobasis.Data.DataEntity.UserGoal goal;
Infobasis.Data.DataEntity.UserGoal oldGoal = DB.UserGoals.Where(item => item.UserID == userID && item.Year == year).FirstOrDefault();
if (oldGoal == null)
{
goal = new Infobasis.Data.DataEntity.UserGoal();
}
else
{
goal = oldGoal;
}
goal.UserID = userID;
goal.Year = year;
goal.Month1 = Change.ToDecimal(tbxInput1.Text, 0);
goal.Month2 = Change.ToDecimal(tbxInput2.Text, 0);
goal.Month3 = Change.ToDecimal(tbxInput3.Text, 0);
goal.Month4 = Change.ToDecimal(tbxInput4.Text, 0);
goal.Month5 = Change.ToDecimal(tbxInput5.Text, 0);
goal.Month6 = Change.ToDecimal(tbxInput6.Text, 0);
goal.Month7 = Change.ToDecimal(tbxInput7.Text, 0);
goal.Month8 = Change.ToDecimal(tbxInput8.Text, 0);
goal.Month9 = Change.ToDecimal(tbxInput9.Text, 0);
goal.Month10 = Change.ToDecimal(tbxInput10.Text, 0);
goal.Month11 = Change.ToDecimal(tbxInput11.Text, 0);
goal.Month12 = Change.ToDecimal(tbxInput12.Text, 0);
goal.Group1 = goal.Month1 + goal.Month2 + goal.Month3;
goal.Group2 = goal.Month4 + goal.Month5 + goal.Month6;
goal.Group3 = goal.Month7 + goal.Month8 + goal.Month9;
goal.Group4 = goal.Month10 + goal.Month11 + goal.Month12;
goal.Remark = tbxRemark.Text;
goal.Total = goal.Group1 + goal.Group2 + goal.Group3 + goal.Group4;
if (oldGoal == null)
{
DB.UserGoals.Add(goal);
goal.LastUpdateDatetime = DateTime.Now;
}
else
{
goal.LastUpdateByID = userID;
goal.LastUpdateDatetime = DateTime.Now;
}
if (SaveChanges())
{
ShowNotify("目标保存成功");
LoadData();
PageContext.RegisterStartupScript("initChart();");
}
else
{
ShowNotify("目标保存失败");
}
}
