/// <summary>
/// 显示所有日期
///
/// </summary>
private void displayadd()
{
string sql;
sql = "select enable ,week,day , classtime,class_name from appointment where week='{0}'and day='{1}' and enable='可用'";//管理员模式全部显示
sql = string.Format(sql, weeknum.ToString(), daynum.ToString());
//创建数据库操作类的对象
Function fun = new Function();
//执行对数据库表的查询操作
DataSet ds = fun.Query(sql);
DataTable dt = ds.Tables[0];
Dgv_PA.DataSource = dt;
Dgv_PA.Refresh();
}
/// <summary>
/// 显示datagridview
/// </summary>
private void displayadd()
{
string sql;
//if (GmSelection.order_flag == 1)
//{
// sql = "select enable, week,day , classtime,class_name from appointment where week='{0}'and day='{1}'";//管理员模式全部显示
//}
//else
//{
sql = "select enable, week,day , classtime from appointment where enable='可用'and week='{0}'and day='{1}'"; //非管理员模式只显示可用项
//}
sql = string.Format(sql, weeknum.ToString(), daynum.ToString());
//创建数据库操作类的对象
Function fun = new Function();
//执行对数据库表的查询操作
DataSet ds = fun.Query(sql);
DataTable dt = ds.Tables[0];
Dgv_PA.DataSource = dt;
Dgv_PA.Refresh();
}
