public StaffJSON Delete(string staffCode) { StaffJSON result = new StaffJSON(); //StringBuilder sbSQL = new StringBuilder(); try { StringBuilder sbSQL = new StringBuilder(); using (NpgDB npgDB = Connection.DBConnect()) { sbSQL.AppendLine("DELETE FROM mstaff"); sbSQL.AppendLine("WHERE staffcode = :p_staffcode"); npgDB.Command = sbSQL.ToString(); npgDB.SetParams("p_staffcode", staffCode); Debug.Write(staffCode); npgDB.ExecuteNonQuery(); result.success = true; //using (NpgsqlDataReader rec = npgDB.Query()) //{ // if (rec.Read()) // { // string deletedStaff = NpgDB.getString(rec, "staffCode"); // result.staff = new Staff // { // staffCode = deletedStaff // }; // result.success = true; // } //} } } catch (Exception ex) { } return(result); }
///////////////////////////////////////////////////////////////////////// /// <summary> ログ出力 </summary> /// <remarks> /// ログテーブルへログを出力 /// </remarks> /// <param name="sSts">ログ種別</param> /// <param name="sTtl">ログタイトル</param> /// <param name="sMsg">ログメッセージ</param> /// <param name="sMsgEx">ログ負荷情報</param> protected void LogWrite(string sSts, string sTtl, string sMsg, string sMsgEx) { StringBuilder sbSQL = new StringBuilder(); // // エラートラップ try { // 環境存在判定 if (m_config != null) { using (NpgDB npgDB = TTCommon.DBConnect(m_config)) { // SQLの作成 & 実行 sbSQL.AppendLine(" INSERT INTO " + m_sTbl); sbSQL.AppendLine(" " + "("); sbSQL.AppendLine(" " + "log_stamp" + ","); sbSQL.AppendLine(" " + "log_kbn" + ","); sbSQL.AppendLine(" " + "log_ttl" + ","); sbSQL.AppendLine(" " + "log_memo" + ","); sbSQL.AppendLine(" " + "log_ext" + ","); sbSQL.AppendLine(" " + "log_prg_nm" + ","); sbSQL.AppendLine(" " + "stf_cd" + ","); sbSQL.AppendLine(" " + "stf_j_nm" + " "); sbSQL.AppendLine(" " + ")" + " " + "VALUES" + " " + "("); sbSQL.AppendLine(" " + "CURRENT_TIMESTAMP" + ","); sbSQL.AppendLine(" " + ":log_kbn" + ","); sbSQL.AppendLine(" " + ":log_ttl" + ","); sbSQL.AppendLine(" " + ":log_memo" + ","); sbSQL.AppendLine(" " + ":log_ext" + ","); sbSQL.AppendLine(" " + ":log_prg_nm" + ","); sbSQL.AppendLine(" " + ":stf_cd" + ","); sbSQL.AppendLine(" " + ":stf_j_nm" + " "); sbSQL.AppendLine(" " + ")"); npgDB.Command = sbSQL.ToString(); npgDB.SetParams("log_kbn", sSts); npgDB.SetParams("log_ttl", sTtl); npgDB.SetParams("log_memo", sMsg); npgDB.SetParams("log_ext", sMsgEx); npgDB.SetParams("log_prg_nm", m_sPgNm); npgDB.SetParams("stf_cd", m_sStfCd); npgDB.SetParams("stf_j_nm", m_sStfNm); npgDB.ExecuteNonQuery(); } } else { LogfileWrite(sTtl, sMsg, sMsgEx); } } catch (Exception ex) { DebugWrite("ログ出力失敗:" + ex.Message); LogfileWrite(sTtl, sMsg, ex.Source); LogfileWrite(sTtl, sMsg, sMsgEx); } }