From #region Fromprivate void CombBoxSectionInitial() ...{ //在ComBox中填充名 PCServer pcServer = new PCServer(); DataSet dsQuery = new DataSet(); BE_Bank beuser = new BE_Bank(); DataTable dtDetailTemp = new DataTable(); try ...{ dsQuery = pcServer.Bank_GetBank(beuser); if (RebuildDataSet.GetErrorFlg(dsQuery) == 0) ...{ int intCboCount = RebuildDataSet.GetRecordCount(dsQuery); m_strBANKCd = new string[intCboCount]; if (intCboCount > 0) ...{ dtDetailTemp = RebuildDataSet.GetQueryTable(dsQuery); for (int i = 0; i < intCboCount; i++) ...{ cboBank.Items.Add(dtDetailTemp.Rows[i]["BANKNM"]);//CmBox中加入名 m_strBANKCd[i] = dtDetailTemp.Rows[i]["BANKCD"].ToString();//把CD与名同步保存到数组中 } } } } catch(Exception ex) ...{ MessageBox.Show(" message", m_messageboxName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); LogManager.WriteClientErrLog4Net(ex); }#endregion pcserver #region pcserver [WebMethod(Description = " ")] public DataSet Bank_GetBank(BE_Bank beuser) ...{ try ...{ BC_Bank bcUser = new BC_Bank(); return bcUser.GetBank(beuser); } catch (Exception ex) ...{ UtilityLog.WriteErrLogWithLog4Net(ex.Message + ex.StackTrace); return BuildDataSet.BuiledReErrDataSet("EU00015"); } }#endregion BC #region BC private readonly IDAC_Bank dac_Bank = FDAC_Factory.CreateBank(); public DataSet GetBank(BE_Bank beuser) ...{ return dac_Bank.GetBank(""); }#endregion IDAC #region IDAC public interface IDAC_Bank ...{ DataSet GetBank(string Bankcd); }#endregion DAC #region DAC public DataSet GetBank(string Bankcd) ...{ DataSet dsQuery = new DataSet(); StringBuilder strSql = new StringBuilder(); SqlCommand cmd = new SqlCommand(); strSql.Append(DAC_Bank_Sql.GetBankSql()); string userID = Bankcd.Trim(); if (userID != string.Empty) ...{ SqlParameter[] parameters_2 = ...{ new SqlParameter("@BANKCD", SqlDbType.VarChar) }; parameters_2[0].Value = userID; strSql.Append(" AND USER_ID LIKE '%'+@USER_ID+'%' "); dsQuery = DbHelperSQL.Query(strSql.ToString(), parameters_2); } else ...{ dsQuery = DbHelperSQL.Query(strSql.ToString(), cmd); } return dsQuery; }#endregion DAC_Sql #region DAC_Sql class DAC_Bank_Sql ...{ public static string GetBankSql() ...{ string GetBankSql_1 = @" SELECT BANKCD ,BANKNM FROM MBANK "; return GetBankSql_1; } }#endregion