經(jīng)過(guò)調(diào)試，發(fā)現(xiàn)其它情況（如數(shù)據(jù)庫(kù)連接）正常，只是在執(zhí)行一條多表連接查詢時(shí)一定超時(shí)（數(shù)據(jù)庫(kù)數(shù)據(jù)只有十多條）。由于采用分層開發(fā)，但將所有操作放在一起后，卻不見超時(shí)問(wèn)題。程序簡(jiǎn)單分為3層，數(shù)據(jù)層select直接調(diào)用連接，insert和update使用邏輯層的事務(wù)參數(shù)。以下為部分代碼:using (SqlConnection con = Helper.GetSqlConnection()){con.Open();using (SqlTransaction trans = con.BeginTransaction()){try{//刪除原來(lái)的權(quán)限、用戶組關(guān)系HAuthGroup.DeleteAuth_groupByAuthID(auth.Auth_id, con, trans);//更新權(quán)限HAuthority.UpdateAuthority(auth, con, trans);//如果新類別關(guān)聯(lián)了用戶組，添加新的權(quán)限、用戶組關(guān)系A(chǔ)uthType type = HAuthType.GetAuthTypeByID(auth.Type_id);///測(cè)試，添加幾個(gè)讀數(shù)據(jù)庫(kù)方法HGroup.GetGroupsByAuthType(new AuthType());///該處會(huì)導(dǎo)致超時(shí)List<Group> groups = HGroup.GetGroupsByAuthType(type);if (groups.Count > 0){foreach (Group group in groups){HAuthGroup.AddAuth_group(group.Group_id, auth.Auth_id, con, trans);}}trans.Commit();}catch{trans.Rollback();}}}public static List<Group> GetGroupsByAuthType(AuthType type){string strCmd = "select * from [sb_group] where [group_id] in(select [group_id] from [sb_auth_group] where [auth_id] in(select [auth_id] from [sb_authority] where [type_id]=" + type.Type_id + "))";return GetGroups(strCmd);}private static List<Group> GetGroups(string strCmd){List<Group> groups = new List<Group>();using (SqlConnection con = Helper.GetSqlConnection()){try{con.Open();SqlCommand cmd = new SqlCommand(strCmd, con);cmd.CommandTimeout = 5;using (SqlDataReader reader = cmd.ExecuteReader())// cmd.ExecuteReader()超時(shí) !1 將所有方法全部集成到一個(gè)方法里，多層嵌套的子查詢可以執(zhí)行，且不會(huì)超時(shí)。2 在邏輯層單獨(dú)調(diào)用GetGroupsByAuthType(AuthType type) 方法，沒有異常。3 注釋掉 HAuthority.UpdateAuthority(auth, con, trans)，沒有異常。