/// <summary> /// 获得数据列表 /// </summary> public List <LearnSite.Model.NotSign> DataTableToList(DataTable dt) { List <LearnSite.Model.NotSign> modelList = new List <LearnSite.Model.NotSign>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { LearnSite.Model.NotSign model; for (int n = 0; n < rowsCount; n++) { model = new LearnSite.Model.NotSign(); if (dt.Rows[n]["Nid"].ToString() != "") { model.Nid = int.Parse(dt.Rows[n]["Nid"].ToString()); } model.Nnum = dt.Rows[n]["Nnum"].ToString(); if (dt.Rows[n]["Ndate"].ToString() != "") { model.Ndate = DateTime.Parse(dt.Rows[n]["Ndate"].ToString()); } if (dt.Rows[n]["Nyear"].ToString() != "") { model.Nyear = int.Parse(dt.Rows[n]["Nyear"].ToString()); } if (dt.Rows[n]["Nmonth"].ToString() != "") { model.Nmonth = int.Parse(dt.Rows[n]["Nmonth"].ToString()); } if (dt.Rows[n]["Nday"].ToString() != "") { model.Nday = int.Parse(dt.Rows[n]["Nday"].ToString()); } model.Nweek = dt.Rows[n]["Nweek"].ToString(); model.Nnote = dt.Rows[n]["Nnote"].ToString(); if (dt.Rows[n]["Ngrade"].ToString() != "") { model.Ngrade = int.Parse(dt.Rows[n]["Ngrade"].ToString()); } if (dt.Rows[n]["Nterm"].ToString() != "") { model.Nterm = int.Parse(dt.Rows[n]["Nterm"].ToString()); } modelList.Add(model); } } return(modelList); }
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); } } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(LearnSite.Model.NotSign model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LearnSite.Model.NotSign model) { return(dal.Add(model)); }