/// <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));
}
