public WebHospConf WebGetHospConf(int hospid) { WebHospConf ret = new WebHospConf(); try { ServiceIF serv = new ServiceIF(); OrderTool_Serv.Class.HospitalConfig hospData = null; ResultData inRet = serv.GetHospConf_Serv(hospid, out hospData); if (inRet.Result) { LogControl.WriteLog(LogType.ORE, "WebGetHospConf", "【施設マスタ取得】 施設ID:" + hospData); ret.Items = hospData; } else { ret.Message = inRet.Message; } ret.Result = inRet.Result; } catch (Exception e) { ret.Result = false; ret.Message = "処理中に障害が発生いたしました。\nシステム管理者にお問い合わせください。"; LogControl.WriteLog(LogType.ERR, "WebGetHospConf", e.Message); } return(ret); }
public static HospitalConfig GetHospConfig(int id) { HospitalConfig ret = new HospitalConfig(); // DB接続 using (var con = new AccDbConnection(Conf._settings)) { ret = getHospConfig(con, id); if (ret.Conf.Length == 0) { ret = getHospConfig(con, 0); } } return(ret); }
private static HospitalConfig getHospConfig(AccDbConnection con, int id) { HospitalConfig ret = new HospitalConfig(); List <Config> confs = new List <Config>(); // コマンドオブジェクト生成 using (var cmd = con.CreateCommand()) { // SQL生成 // ---------------------------- // SELECT key,value // FROM HospConfig // WHERE hosp_id=id // ---------------------------- StringBuilder selSQL = new StringBuilder(); selSQL.Append("SELECT"); selSQL.Append(" key"); selSQL.Append(",value"); selSQL.Append(" FROM"); selSQL.Append(" HospConfig"); selSQL.Append(" WHERE"); selSQL.Append(" hosp_id="); selSQL.Append(cmd.Add(id).ParameterName); cmd.CommandText = selSQL.ToString(); // SQL実行 using (var dr = cmd.ExecuteReader()) // 該当データがある場合、返却値を設定 while (dr.Read()) { Config tmpConf = new Config(); tmpConf.Key = dr["key"].ToString(); if (dr["value"] != DBNull.Value) { tmpConf.Value = dr["value"].ToString(); } confs.Add(tmpConf); } } ret.Conf = confs.ToArray(); return(ret); }