//按条件查询课程
public object ShowCourse(string check)
{
List <TimeTable> list1 = new List <TimeTable>();
string sql = @" select CourseName,[Date],MemberJoint,[Status] from TimeTable
where CourseName like '%" + check + @"%'
or convert(varchar(1024),[Date],120) like '%" + check + @"%'";
try
{
DataView dv = new DataView(dbs.SelectDataBase(sql).Tables[0]);
DataTable dt = dv.Table;
for (int i = 0; i < dt.Rows.Count; i++)
{
list1.Add(new TimeTable
{
CourseName = Convert.ToString(dt.Rows[i]["CourseName"]),
Date = Convert.ToString(dt.Rows[i]["Date"]),
MemberJoint = Convert.ToString(dt.Rows[i]["MemberJoint"]),
Status = Convert.ToString(dt.Rows[i]["Status"]),
});
}
}
catch (Exception e)
{
return("false");
}
return(list1);
}
public string GetUserID()
{
string UserID;
string sql = " select UserID from Users where FirstName='Sam'";
DataView dv = new DataView(dbs.SelectDataBase(sql).Tables[0]);
DataTable dt = dv.Table;
UserID = Convert.ToString(dt.Rows[0]["UserID"]);
return(UserID);
}
