protected void gvScore_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int daysid = Convert.ToInt32(gvScore.DataKeys[e.RowIndex].Value);
DayScoreInfo days = new DayScoreInfo(daysid);
TextBox txtToday = gvScore.Rows[e.RowIndex].FindControl("txtToday") as TextBox;
TextBox txtItem = gvScore.Rows[e.RowIndex].FindControl("txtItem") as TextBox;
TextBox txtFinishTime = gvScore.Rows[e.RowIndex].FindControl("txtFinishTime") as TextBox;
TextBox txtTimeSpan = gvScore.Rows[e.RowIndex].FindControl("txtTimeSpan") as TextBox;
TextBox txtMemo = gvScore.Rows[e.RowIndex].FindControl("txtMemo") as TextBox;
DropDownList ddlRole = gvScore.Rows[e.RowIndex].FindControl("ddlRole") as DropDownList;
try
{
days.Today = txtToday.Text.ToString();
days.Item = txtItem.Text.ToString();
days.FinishTime = txtFinishTime.Text.ToString();
days.TimeSpan = txtTimeSpan.Text.ToString();
days.Memo = txtMemo.Text.ToString();
days.DayRoleId = Convert.ToInt32(ddlRole.SelectedValue);
days.Save();
gvScore.EditIndex = -1;
gvDataBind();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('更新失败：" + ex.Message + "');", true);
}
}
protected void gvScore_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int dayscoreid = Convert.ToInt32(gvScore.DataKeys[e.RowIndex].Value);
DayScoreInfo.DelDayScore(dayscoreid);
gvDataBind();
}
protected void gvDataBind()
{
DataTable dt;
if (ddlEmployee.SelectedValue == "" || txtDate1.Text == "" || txtDate2.Text == "")
{
dt = DayScoreInfo.getWksOfTm();
}
else
{
int emid = Convert.ToInt32(ddlEmployee.SelectedValue);
dt = DayScoreInfo.getScoreByCondition(emid, txtDate1.Text, txtDate2.Text);
}
DataView view = dt.DefaultView;
string sort = (string)ViewState["SortExpression"] + " " + (string)ViewState["SortDir"];
view.Sort = sort;
if (dt.Rows.Count == 0)
{
dt.Rows.Add(dt.NewRow());
UI.BindCtrl(dt.DefaultView, gvScore, AspNetPager1);
gvScore.Rows[0].Visible = false;
}
else
{
UI.BindCtrl(dt.DefaultView, gvScore, AspNetPager1);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
WeekScoreInfo wk = new WeekScoreInfo(Convert.ToInt32(ViewState["wkid"]));
float sum = 0;
foreach (GridViewRow row in gvScore.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
int dayid = Convert.ToInt32(gvScore.DataKeys[row.RowIndex].Value);
DayScoreInfo days = new DayScoreInfo(dayid);
TextBox txtScore = gvScore.Rows[row.RowIndex].FindControl("txtScore") as TextBox;
days.Score = txtScore.Text.ToString();
days.Save();
if (txtScore.Text.ToString() != "")
{
sum = sum + float.Parse(txtScore.Text.ToString());
}
}
}
wk.TotalScore = sum.ToString();
wk.IsSubmit = 2;
wk.Save();
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('保存成功！');</script>");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
DayScoreInfo das = new DayScoreInfo();
das.WeekScoreId = Convert.ToInt32(ViewState["wksid"]);
das.DayRoleId = Convert.ToInt32("1");
das.Save();
gvDataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (ddlEmployee.SelectedValue == "" || txtDate1.Text == "" || txtDate2.Text == "")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('请选择姓名、时间！');</script>");
}
else
{
int emid = Convert.ToInt32(ddlEmployee.SelectedValue);
lblScore.Text = DayScoreInfo.getSumScore(emid, txtDate1.Text, txtDate2.Text);
gvDataBind();
}
}
protected void gvDataBind()
{
DataTable dt = DayScoreInfo.getAddDayScore(Convert.ToInt32(ViewState["wksid"]));
DataView view = dt.DefaultView;
string sort = (string)ViewState["SortExpression"] + " " + (string)ViewState["SortDir"];
view.Sort = sort;
if (dt.Rows.Count == 0)
{
dt.Rows.Add(dt.NewRow());
UI.BindCtrl(dt.DefaultView, gvScore, AspNetPager1);
gvScore.Rows[0].Visible = false;
}
else
{
UI.BindCtrl(dt.DefaultView, gvScore, AspNetPager1);
}
}
protected void gvScore_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//鼠标移动到每项时颜色交替效果
e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e");
//设置悬浮鼠标指针形状为"小手"
e.Row.Attributes["style"] = "Cursor:hand";
DropDownList ddlRole = e.Row.FindControl("ddlRole") as DropDownList;
if (ddlRole != null)
{
DataTable dt = DayScoreInfo.getDayRole();
ddlRole.DataSource = dt;
ddlRole.DataTextField = "DayRoleName";
ddlRole.DataValueField = "DayRoleId";
ddlRole.DataBind();
}
}
}
protected void Init()
{
WeekScoreInfo weekscore = new WeekScoreInfo();
weekscore.IsSubmit = 0;
int emid = Convert.ToInt32(Request["EmployeeId"]);
weekscore.EmployeeId = emid;
weekscore.Save();
WeekScoreInfo wk = new WeekScoreInfo(weekscore.WeekScoreId);
wk.WeekScoreNum = DateTime.Now.Date.ToString("yyyyMMdd") + weekscore.WeekScoreId.ToString();
wk.Save();
ViewState["wksid"] = weekscore.WeekScoreId;
for (int i = 0; i < 5; i++)
{
DayScoreInfo dayscore = new DayScoreInfo();
dayscore.WeekScoreId = (int)ViewState["wksid"];
dayscore.DayRoleId = Convert.ToInt32("1");
dayscore.Save();
}
}
