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