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