protected void DLnotline_ItemDataBound(object sender, DataListItemEventArgs e)
{
Label hl = new Label();
hl = (Label)e.Item.FindControl("lbQname");
Label lb = new Label();
lb = (Label)e.Item.FindControl("LabelNnum");
string jsstr = "notsg('" + lb.Text + "', '" + DDLgrade.SelectedValue + "', '" + Server.UrlEncode(hl.Text) + "');";
hl.Attributes.Add("onclick", jsstr);
string pp = LearnSite.Common.Photo.ExistStuPhoto(lb.Text);
if (pp != "none")
{
lb.Attributes.Add("class", "tooltip");
lb.ToolTip = pp;
lb.BackColor = Color.Bisque;
}
LearnSite.BLL.NotSign bll = new LearnSite.BLL.NotSign();
string getnote = bll.GetNoteToday(lb.Text);
if (getnote.Trim() != "")
{
hl.ToolTip = getnote;
}
else
{
hl.ToolTip = "点击请给未签到备注";
}
}
protected void BtnExcelNoSign_Click(object sender, EventArgs e)
{
int sgrade = Int32.Parse(DDLgrade.SelectedValue);
int sclass = Int32.Parse(DDLclass.SelectedValue);
int sterm = Int32.Parse(LearnSite.Common.XmlHelp.GetTerm());
LearnSite.BLL.NotSign nbll = new LearnSite.BLL.NotSign();
nbll.NotSignExcel(sgrade, sclass, sterm);
}
private void showNotSign()
{
if (LearnSite.Common.CookieHelp.IsStudentLogin())
{
string mynum = cook.Snum;
LearnSite.BLL.NotSign nbll = new LearnSite.BLL.NotSign();
GVNoSign.DataSource = nbll.NotSignSnumdetail(mynum);
GVNoSign.DataBind();
}
}
private void showNotSign()
{
if (LearnSite.Common.CookieHelp.IsStudentLogin())
{
string mynum = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Snum"].ToString();
LearnSite.BLL.NotSign nbll = new LearnSite.BLL.NotSign();
GVNoSign.DataSource = nbll.NotSignSnumdetail(mynum);
GVNoSign.DataBind();
}
}
private void Showdone()
{
if (Request.QueryString["Nnum"] != null)
{
string Nnum = Request.QueryString["Nnum"].ToString();
LearnSite.BLL.NotSign bll = new LearnSite.BLL.NotSign();
string Nnote = bll.GetNoteToday(Nnum);
TextBox1.Text = Nnote;
if (Nnote.Trim() != "")
{
Btnnotsign.Text = "修改";
}
else
{
Btnnotsign.Text = "添加";
}
}
}
protected void GVNoSign_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int Qyear = Int32.Parse(Request.QueryString["Qyear"].ToString());
int Qmonth = Int32.Parse(Request.QueryString["Qmonth"].ToString());
int Qday = Int32.Parse(Request.QueryString["Qday"].ToString());
string Nnum = e.Row.Cells[1].Text;
LearnSite.BLL.NotSign bll = new LearnSite.BLL.NotSign();
string Nnote = bll.GetNoteThisday(Nnum, Qyear, Qmonth, Qday);
e.Row.Cells[10].Text = Nnote;
//当鼠标放上去的时候 先保存当前行的背景颜色 并给附一颜色
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#E1E8E1',this.style.fontWeight='';");
//当鼠标离开的时候 将背景颜色还原的以前的颜色
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");
//单击行改变行背景颜色
e.Row.Attributes.Add("onclick", "this.style.backgroundColor='#D8E0D8'; this.style.color='buttontext';this.style.cursor='default';");
}
}
protected void Btnnotsign_Click(object sender, EventArgs e)
{
if (Request.QueryString["Nnum"] != null && TextBox1.Text.Trim() != "")
{
string Nnum = Request.QueryString["Nnum"].ToString();
LearnSite.BLL.NotSign bll = new LearnSite.BLL.NotSign();
if (bll.ExistsToday(Nnum))
{
//存在则更新
bll.UpdateNote(Nnum, TextBox1.Text.Trim());
Labelmsg.Text = "修改缺席备注成功！";
System.Threading.Thread.Sleep(500);
}
else
{
//不存在则添加
LearnSite.Model.NotSign model = new LearnSite.Model.NotSign();
DateTime dt = DateTime.Now;
int Nday = dt.Day;
int Nmonth = dt.Month;
int Nyear = dt.Year;
model.Nnum = Nnum;
model.Ndate = dt;
model.Nday = Nday;
model.Nmonth = Nmonth;
model.Nweek = dt.DayOfWeek.ToString();
model.Nyear = Nyear;
model.Nnote = TextBox1.Text.Trim();
model.Ngrade = Int32.Parse(Request.QueryString["Ngrade"].ToString());
model.Nterm = Int32.Parse(LearnSite.Common.XmlHelp.GetTerm());
int results = bll.Add(model);
if (results > 0)
{
Labelmsg.Text = "添加缺席备注成功！";
}
System.Threading.Thread.Sleep(500);
}
}
}
