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