程序中 #region 程序中 private bool CheckDataExist() ...{ //检测数据库是否有重复数据 try ...{ PCServer pcserver = new PCServer(); DataSet dsQuery = new DataSet(); dsQuery = pcserver.MCUSTOMER_CheckExist(txtCustcd.Text.Trim()); if (RebuildDataSet.GetErrorFlg(dsQuery) == 0) ...{ if (RebuildDataSet.GetRecordCount(dsQuery) > 0) ...{ if (m_blnUpdateFlag) ...{ return false; } } } } catch (Exception ex) ...{ LogManager.WriteClientErrLog4Net(ex); return false; } return true; } #endregion WebService #region WebService [WebMethod(Description = "check 最終処理区分")] public DataSet MCUSTOMER_CheckExist(string user_no) ...{ try ...{ BC_Master bcUser = new BC_Master(); return bcUser.GetCustCdCheck(user_no); } catch (Exception ex) ...{ UtilityLog.WriteErrLogWithLog4Net(ex.Message + ex.StackTrace); return BuildDataSet.BuiledReErrDataSet("EU00015"); } } #endregion BC #region BC public DataSet GetCustCdCheck(string user_no) ...{ return dac_master.GetCustCdCheck(user_no); } #endregion IDAC #region IDAC DataSet GetCustcdSearch(string user_id); #endregion DAC #region DACpublic class DAC_Master : IDAC_Master ...{ 取引先マスタ#region 取引先マスタ public DataSet GetCustCdCheck(string user_no) ...{ DataSet dsQuery = new DataSet(); StringBuilder strSql = new StringBuilder(); SqlCommand cmd = new SqlCommand(); strSql.Append(DAC_Master_Sql.GetCheckSql()); string strWhere = string.Empty; if (user_no != string.Empty) ...{ SqlParameter parameters1 = new SqlParameter("@USER_NO", SqlDbType.VarChar); strWhere += " AND (CUSTCD=@USER_NO "; parameters1.Value = user_no; cmd.Parameters.Add(parameters1); } dsQuery = DbHelperSQL.Query(strSql.ToString() + strWhere + ")", cmd, "QDs"); return dsQuery; } } #endregion DAC_Master_Sql #region DAC_Master_Sql public static string GetCheckSql() ...{ //StringBuilder strSql = new StringBuilder(); string strSql = @" SELECT * FROM MCUSTOMER WHERE 1=1 "; return strSql; } #endregion