public WebHosp WebGetHosp(int userid) { WebHosp ret = new WebHosp(); try { ServiceIF serv = new ServiceIF(); OrderTool_Serv.Class.HospMst hospData = null; ResultData inRet = serv.GetHosp_Serv(userid, out hospData); if (inRet.Result) { LogControl.WriteLog(LogType.ORE, "WebGetHosp", "【施設情報取得】 施設:" + hospData.CD + " 施設ID:" + hospData.HospID); 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, "WebGetHosp", e.Message); } return(ret); }
private static HospMst getHosp(AccDbConnection con, int id) { HospMst ret = new HospMst(); // コマンドオブジェクト生成 using (var cmd = con.CreateCommand()) { // SQL生成 // ---------------------------- // SELECT H.id, H.name, H.cd, H.seq // FROM M_Hosp As H // INNER JOIN HospUser HU // ON H.id = HU.hosp_id // WHERE user_id=id // ORDER BY H.seq ASC // ---------------------------- StringBuilder selSQL = new StringBuilder(); selSQL.Append("SELECT"); selSQL.Append(" H.id"); selSQL.Append(",H.name"); selSQL.Append(",H.cd"); selSQL.Append(",H.seq"); selSQL.Append(",H.visible"); selSQL.Append(" FROM"); selSQL.Append(" M_Hosp As H"); selSQL.Append(" INNER JOIN"); selSQL.Append(" HospUser HU"); selSQL.Append(" ON"); selSQL.Append(" H.id = HU.hosp_id"); selSQL.Append(" WHERE"); selSQL.Append(" user_id="); selSQL.Append(cmd.Add(id).ParameterName); selSQL.Append(" ORDER BY"); selSQL.Append(" H.seq"); selSQL.Append(" ASC"); cmd.CommandText = selSQL.ToString(); // SQL実行 using (var dr = cmd.ExecuteReader()) // 該当データがある場合、返却値を設定 if (dr.Read()) { ret.HospID = Convert.ToInt32(dr["id"]); ret.CD = dr["cd"].ToString(); if (dr["name"] != DBNull.Value) { ret.Name = dr["name"].ToString(); } ret.Seq = Convert.ToInt32(dr["seq"]); ret.Visible = Convert.ToInt32(dr["visible"]); } } return(ret); }
public static HospMst GetHosp(int id) { HospMst ret = new HospMst(); // DB接続 using (var con = new AccDbConnection(Conf._settings)) { ret = getHosp(con, id); } return(ret); }
private static HospMst[] getHospList(AccDbConnection con) { List <HospMst> ret = new List <HospMst>(); // コマンドオブジェクト生成 using (var cmd = con.CreateCommand()) { // SQL生成 // ---------------------------- // SELECT H.id, H.name, H.cd, H.seq // FROM M_Hosp As H // INNER JOIN HospUser HU // ON H.id = HU.hosp_id // WHERE user_id=id // ORDER BY H.seq ASC // ---------------------------- StringBuilder selSQL = new StringBuilder(); selSQL.Append("SELECT"); selSQL.Append(" H.id"); selSQL.Append(",H.name"); selSQL.Append(",H.cd"); selSQL.Append(",H.seq"); selSQL.Append(",H.visible"); selSQL.Append(" FROM"); selSQL.Append(" M_Hosp As H"); selSQL.Append(" ORDER BY"); selSQL.Append(" H.seq"); selSQL.Append(" ASC"); cmd.CommandText = selSQL.ToString(); // SQL実行 using (var dr = cmd.ExecuteReader()) // 該当データがある場合、返却値を設定 while (dr.Read()) { HospMst tmp = new HospMst(); tmp.HospID = Convert.ToInt32(dr["id"]); tmp.CD = dr["cd"].ToString(); if (dr["name"] != DBNull.Value) { tmp.Name = dr["name"].ToString(); } tmp.Seq = Convert.ToInt32(dr["seq"]); tmp.Visible = Convert.ToInt32(dr["visible"]); ret.Add(tmp); } } return(ret.ToArray()); }