摘要： Select distinct case when BranchCourseId is null then Tb_Client.ThreePhaseKind else BranchCourseId end BranchCourseId, Tb_Client.* from Tb_Client inner join Tb_Class_Client on Tb_Client.id = Tb_Class_Client.clientIdinner join Tb_Class on tb_class_client.classid = tb_class.idinner join tb_course on t 阅读全文

摘要： /// <summary> /// 在页面中输出javascript脚本 /// </summary> /// <param name="script">要输出的javascript脚本</param> public static void ResponseScript(string script) { if (Anthem.Manager.IsCallBack) { Anthem.Manager.AddScriptForClientSideEval(script); } else { Page page = HttpCont 阅读全文

摘要： DECLARE myCURSOR INSENSITIVE CURSORFOR select id from Tb_Class_Client WHERE ClassID = 694 and ClassNumber = ''DECLARE @id varchar(50), @num intOPEN myCURSORFETCH NEXT FROM myCURSOR INTO @idWHILE @@FETCH_STATUS = 0BEGINdeclare @ClassNumber varchar(3)select @ClassNumber = '0'+ convert( 阅读全文