/*
* 获取用户已经看过的案例,如第二日问题、账单计算问题等
*/
public static DataTable getCaseHasScaned(string userName, string courseName)
{
SqlTransaction trans = null;
DB db = null;
try
{
db = new DB();
trans = db.conn.BeginTransaction(IsolationLevel.ReadCommitted);
SqlParameter[] parms = {
new SqlParameter("@UserName", userName),
new SqlParameter("@CourseName", courseName)
};
DataTable dt = db.ExecuteDataTable(trans, "Command_GetCaseHasScaned", parms);
trans.Commit();
db.Close();
return dt;
}
catch
{
if (trans != null)
trans.Rollback();
if (db != null)
db.Close();
return null;
}
}
/*
* 获取包含某知识点的用户未看过的文件
*/
public static DataTable getUnreadFileByKID(int kID, string userName)
{
SqlTransaction trans = null;
DB db = null;
try
{
db = new DB();
trans = db.conn.BeginTransaction(IsolationLevel.ReadCommitted);
SqlParameter[] parms = {
new SqlParameter("@KID", kID),
new SqlParameter("@UserName", userName)
};
DataTable dt = db.ExecuteDataTable(trans, "Command_GetUnreadFileByKID", parms);
trans.Commit();
db.Close();
return dt;
}
catch
{
if (trans != null)
trans.Rollback();
if (db != null)
db.Close();
return null;
}
}
/*
* 获取与该文件关联的章知识点
*/
public static DataTable getSectionKnowledgeFromFile(int fID)
{
SqlTransaction trans = null;
DB db = null;
try
{
db = new DB();
trans = db.conn.BeginTransaction(IsolationLevel.ReadCommitted);
SqlParameter[] parms = {
new SqlParameter("@FID", fID)
};
DataTable dt = db.ExecuteDataTable(trans, "Command_GetSectionKnowledgeFromFile", parms);
trans.Commit();
db.Close();
return dt;
}
catch
{
if (trans != null)
trans.Rollback();
if (db != null)
db.Close();
return null;
}
}
