/// <summary>
/// 获取队列ID
/// </summary>
/// <param name="SName">Q名称</param>
/// <returns></returns>
public static EnterID2Skill_Result GetEnterID(string SName)
{
using (var dc = DCHelper.GenesysErsContext())
{
var sql = "SELECT * FROM dbo.IRD_EnterID2Skill WHERE SName = {0}";
var r = dc.Database.SqlQuery <EnterID2Skill_Result>(sql, SName.Replace("'", ""));
return(r.FirstOrDefault());
}
}
/// <summary>
/// 获取对应的队列名
/// </summary>
/// <param name="enterID">chat的enterid</param>
/// <returns></returns>
public static List <EnterID2Skill_Result> EnterID2Skill(Nullable <int> enterID)
{
using (var dc = DCHelper.GenesysErsContext())
{
var sql = "SELECT * FROM dbo.IRD_EnterID2Skill WHERE ( {0} IS NULL OR EID = {0} ) AND SName IS NOT NULL";
var r = dc.Database.SqlQuery <EnterID2Skill_Result>(sql, enterID);
return(r.ToList());
}
}
