private void GetStudentUpdate(string txtFrom, string txtTo)
{
DataTable queryDataTable = FullQuery(txtFrom, txtTo);
DataTable distinctTable = queryDataTable;// QueryByBanJi(ref queryDataTable);
if (distinctTable.Rows.Count > 0)
{
DataRow[] drs = distinctTable.Select("", "Author");
DataSet ds = new DataSet();
ds.Merge(drs);
_gvtable = ds.Tables[0].Copy();
}
else
{
_gvtable = distinctTable;
}
errlable.Text = "共有学生" + StudentCount.ToString() + "人，共更新 " + _gvtable.Rows.Count + " 条记录！";
}
public StudentCount GetStudentCount(int id)
{
{
var count = new StudentCount();
count.ClassId = id;
using (var cn = new SqlConnection(Config.GetConnectionString()))
{
var cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "StudentCount_GetByClassId";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ClassId", id);
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
count.Students = (int)dr["StudentCount"];
}
}
}
return(count);
}
}
