/// <summary> /// お知らせ情報の追加 /// /// 使用画面:MstInfoMnt /// </summary> public int Insert() { ComDB db = new ComDB(_db_type, "COM"); StringBuilder strSQL = new StringBuilder(); int rtn = 0; // 最大のREC_NOを得る strSQL.Append("SELECT "); if (_db_type == "ORACLE") { strSQL.Append("NVL(MAX(REC_NO),0) "); } else { strSQL.Append("ISNULL(MAX(REC_NO),0) "); } strSQL.Append(" AS REC_NO"); strSQL.Append(" FROM INFO_MASTER "); //if (_db_type == "ORACLE") //{ // strSQL.Append(" WHERE COMPANY_CD = :COMPANY_CD"); // db.DbParametersClear(); // db.DbPsetString("COMPANY_CD", _company_cd); //} //else //{ // strSQL.Append(" WHERE COMPANY_CD = @COMPANY_CD"); // db.DbParametersClear(); // db.DbPsetString("@COMPANY_CD", _company_cd); //} rtn = db.DbExecuteReader(strSQL.ToString()); if (rtn == ComConst.FAILED) { _rec_no = 1; } else { try { _rec_no = int.Parse(db.Row("REC_NO")); } catch { _rec_no = 0; } _rec_no += 1; } db.DbCloseReader(); // Insert strSQL = new StringBuilder(); if (_db_type == "ORACLE") { strSQL.Append("INSERT INTO INFO_MASTER "); strSQL.Append("("); //strSQL.Append("COMPANY_CD, REC_NO, LANG, INFO_DATE, INFO_MSG,"); strSQL.Append("REC_NO, LANG, INFO_DATE, INFO_MSG,"); strSQL.Append("IMPORTANT_FLG, BEG_EFF_DATE, END_EFF_DATE,"); strSQL.Append("ENTRY_DATE, CHG_DATE, CHG_USER_ID, UPDATE_CNTR"); strSQL.Append(") VALUES ("); //strSQL.Append(":COMPANY_CD, :REC_NO, :LANG, :INFO_DATE, :INFO_MSG,"); strSQL.Append(":REC_NO, :LANG, :INFO_DATE, :INFO_MSG,"); strSQL.Append(":IMPORTANT_FLG, :BEG_EFF_DATE, :END_EFF_DATE,"); strSQL.Append(":ENTRY_DATE, :CHG_DATE, :CHG_USER_ID, :UPDATE_CNTR)"); db.DbParametersClear(); //db.DbPsetString("COMPANY_CD", _company_cd); db.DbPsetInt("REC_NO", _rec_no); db.DbPsetInt("LANG", _lang); db.DbPsetInt("INFO_DATE", _info_date); db.DbPsetString("INFO_MSG", _info_msg); db.DbPsetInt("IMPORTANT_FLG", _important_flg); db.DbPsetInt("BEG_EFF_DATE", _beg_eff_date); db.DbPsetInt("END_EFF_DATE", _end_eff_date); db.DbPsetDate("ENTRY_DATE", DateTime.Now); db.DbPsetDate("CHG_DATE", DateTime.Now); db.DbPsetString("CHG_USER_ID", _chg_user_id); db.DbPsetInt("UPDATE_CNTR", _update_cntr); } else { strSQL.Append("INSERT INTO INFO_MASTER "); strSQL.Append("("); //strSQL.Append("COMPANY_CD, REC_NO, LANG, INFO_DATE, INFO_MSG,"); strSQL.Append("REC_NO, LANG, INFO_DATE, INFO_MSG,"); strSQL.Append("IMPORTANT_FLG, BEG_EFF_DATE, END_EFF_DATE,"); strSQL.Append("ENTRY_DATE, CHG_DATE, CHG_USER_ID, UPDATE_CNTR"); strSQL.Append(") VALUES ("); //strSQL.Append("@COMPANY_CD, @REC_NO, @LANG, @INFO_DATE, @INFO_MSG,"); strSQL.Append("@REC_NO, @LANG, @INFO_DATE, @INFO_MSG,"); strSQL.Append("@IMPORTANT_FLG, @BEG_EFF_DATE, @END_EFF_DATE,"); strSQL.Append("@ENTRY_DATE, @CHG_DATE, @CHG_USER_ID, @UPDATE_CNTR)"); db.DbParametersClear(); //db.DbPsetString("@COMPANY_CD", _company_cd); db.DbPsetInt("@REC_NO", _rec_no); db.DbPsetInt("@LANG", _lang); db.DbPsetInt("@INFO_DATE", _info_date); db.DbPsetString("@INFO_MSG", _info_msg); db.DbPsetInt("@IMPORTANT_FLG", _important_flg); db.DbPsetInt("@BEG_EFF_DATE", _beg_eff_date); db.DbPsetInt("@END_EFF_DATE", _end_eff_date); db.DbPsetDate("@ENTRY_DATE", DateTime.Now); db.DbPsetDate("@CHG_DATE", DateTime.Now); db.DbPsetString("@CHG_USER_ID", _chg_user_id); db.DbPsetInt("@UPDATE_CNTR", _update_cntr); } db.DbBeginTrans(); rtn = db.DbExecute(strSQL.ToString()); if (rtn != ComConst.FAILED) { db.DbCommit(); } else { _dbmsg = db.expmsg; _strErr = db.strErr; db.DbRollback(); } return(rtn); }