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