/// <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);
}
