From
#region From
private 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
private 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