public static bool SetPreOrder(PreOrder order)
{
bool ret = false;
// DB接続
using (var con = new AccDbConnection(Conf._settings))
{
if (order.OrderID == 0)
{
ret = setPreOrder(con, order);
}
else
{
ret = udtPreOrder(con, order);
}
}
return(ret);
}
private static bool udtPreOrder(AccDbConnection con, PreOrder order)
{
bool ret = false;
// コマンドオブジェクト生成
using (var cmd = con.CreateCommand())
{
StringBuilder udtSQL = new StringBuilder();
udtSQL.Append("UPDATE");
udtSQL.Append(" PreOrder");
udtSQL.Append(" SET");
udtSQL.Append(" hospid=" + cmd.Add(order.HospID).ParameterName);
udtSQL.Append(",patkey=" + cmd.Add(order.Key).ParameterName);
udtSQL.Append(",patage=" + cmd.Add(order.PatAge).ParameterName);
udtSQL.Append(",modality=" + cmd.Add(order.Modality).ParameterName);
udtSQL.Append(",studydate=" + cmd.Add(order.Date).ParameterName);
udtSQL.Append(",studytime=" + cmd.Add(order.Time).ParameterName);
udtSQL.Append(",bodypart=" + cmd.Add(order.BodyPart).ParameterName);
udtSQL.Append(",studytype=" + cmd.Add(order.Type).ParameterName);
udtSQL.Append(",imgcnt=" + cmd.Add(order.ImgCnt).ParameterName);
udtSQL.Append(",isemergency=" + cmd.Add(order.IsEmergency).ParameterName);
udtSQL.Append(",ismail=" + cmd.Add(order.IsMail).ParameterName);
udtSQL.Append(",comment=" + cmd.Add(order.Comment).ParameterName);
udtSQL.Append(",status=" + cmd.Add(order.Status).ParameterName);
udtSQL.Append(" WHERE");
udtSQL.Append(" id=");
udtSQL.Append(cmd.Add(order.OrderID).ParameterName);
cmd.CommandText = udtSQL.ToString();
var retcnt = cmd.ExecuteNonQuery();
if (retcnt > 0)
{
ret = true;
}
}
return(ret);
}
private static PreOrder[] getPreOrderList(AccDbConnection con, Search search)
{
List <PreOrder> ret = new List <PreOrder>();
// コマンドオブジェクト生成
using (var cmd = con.CreateCommand())
{
// SQL生成
// ----------------------------
// ----------------------------
StringBuilder selSQL = new StringBuilder();
selSQL.Append("SELECT");
selSQL.Append(" O.id");
selSQL.Append(",O.hospid");
selSQL.Append(",O.patkey");
selSQL.Append(",O.patage");
selSQL.Append(",O.modality");
selSQL.Append(",O.studydate");
selSQL.Append(",O.studytime");
selSQL.Append(",O.bodypart");
selSQL.Append(",O.studytype");
selSQL.Append(",O.imgcnt");
selSQL.Append(",O.isemergency");
selSQL.Append(",O.ismail");
selSQL.Append(",O.comment");
selSQL.Append(",O.status");
selSQL.Append(",P.key");
selSQL.Append(",P.patid");
selSQL.Append(",P.patname");
selSQL.Append(",P.patname_h");
selSQL.Append(",P.patname_r");
selSQL.Append(",P.patsex");
selSQL.Append(",P.patbirth");
selSQL.Append(" FROM");
selSQL.Append(" PreOrder As O");
selSQL.Append(" INNER JOIN");
selSQL.Append(" Patient As P");
selSQL.Append(" ON");
selSQL.Append(" O.patkey=P.Key");
string strWhere = " WHERE";
if (search.HospID > 0)
{
selSQL.Append(strWhere);
selSQL.Append(" O.hospid=");
selSQL.Append(cmd.Add(search.HospID).ParameterName);
strWhere = " AND";
}
if (search.OrderID > 0)
{
selSQL.Append(strWhere);
selSQL.Append(" O.id=");
selSQL.Append(cmd.Add(search.OrderID).ParameterName);
strWhere = " AND";
}
if (!string.IsNullOrEmpty(search.PatID))
{
selSQL.Append(strWhere);
selSQL.Append(" P.patid=");
selSQL.Append(cmd.Add(search.PatID).ParameterName);
strWhere = " AND";
}
if (search.Status != -1)
{
selSQL.Append(strWhere);
selSQL.Append(" O.status=");
selSQL.Append(cmd.Add(search.Status).ParameterName);
strWhere = " AND";
}
selSQL.Append(" ORDER BY");
selSQL.Append(" O.studydate");
selSQL.Append(" DESC");
selSQL.Append(",O.studytime");
selSQL.Append(" DESC");
cmd.CommandText = selSQL.ToString();
// SQL実行
using (var dr = cmd.ExecuteReader())
// 該当データがある場合、返却値を設定
while (dr.Read())
{
PreOrder tmpOrder = new PreOrder();
tmpOrder.OrderID = Convert.ToInt32(dr["id"]);
tmpOrder.HospID = Convert.ToInt32(dr["hospid"]);
tmpOrder.Key = Convert.ToInt32(dr["key"]);
tmpOrder.PatID = dr["patid"].ToString();
if (dr["patname"] != DBNull.Value)
{
tmpOrder.PatName = dr["patname"].ToString();
}
if (dr["patname_h"] != DBNull.Value)
{
tmpOrder.PatName_H = dr["patname_h"].ToString();
}
if (dr["patname_r"] != DBNull.Value)
{
tmpOrder.PatName_R = dr["patname_r"].ToString();
}
tmpOrder.Sex = Convert.ToInt32(dr["patsex"]);
if (dr["patbirth"] != DBNull.Value)
{
tmpOrder.BirthDay = dr["patbirth"].ToString();
}
if (dr["patage"] != DBNull.Value)
{
tmpOrder.PatAge = Convert.ToInt32(dr["patage"]);
}
tmpOrder.Modality = dr["modality"].ToString();
tmpOrder.Date = dr["studydate"].ToString();
if (dr["studytime"] != DBNull.Value)
{
tmpOrder.Time = dr["studytime"].ToString();
}
if (dr["bodypart"] != DBNull.Value)
{
tmpOrder.BodyPart = dr["bodypart"].ToString();
}
if (dr["studytype"] != DBNull.Value)
{
tmpOrder.Type = dr["studytype"].ToString();
}
if (dr["imgcnt"] != DBNull.Value)
{
tmpOrder.ImgCnt = Convert.ToInt32(dr["imgcnt"]);
}
tmpOrder.IsEmergency = Convert.ToInt32(dr["isemergency"]);
tmpOrder.IsMail = Convert.ToInt32(dr["ismail"]);
if (dr["comment"] != DBNull.Value)
{
tmpOrder.Comment = dr["comment"].ToString();
}
if (dr["status"] != DBNull.Value)
{
tmpOrder.Status = Convert.ToInt32(dr["status"]);
}
ret.Add(tmpOrder);
}
}
return(ret.ToArray());
}
private static bool setPreOrder(AccDbConnection con, PreOrder order)
{
bool ret = false;
// コマンドオブジェクト生成
using (var cmd = con.CreateCommand())
{
StringBuilder insSQL = new StringBuilder();
insSQL.Append("INSERT");
insSQL.Append(" INTO");
insSQL.Append(" PreOrder");
insSQL.Append(" (");
insSQL.Append(" hospid");
insSQL.Append(",patkey");
insSQL.Append(",patage");
insSQL.Append(",modality");
insSQL.Append(",studydate");
insSQL.Append(",studytime");
insSQL.Append(",bodypart");
insSQL.Append(",studytype");
insSQL.Append(",imgcnt");
insSQL.Append(",isemergency");
insSQL.Append(",ismail");
insSQL.Append(",comment");
insSQL.Append(",status");
insSQL.Append(" )");
insSQL.Append(" VALUES");
insSQL.Append(" (");
insSQL.Append(cmd.Add(order.HospID).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.Key).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.PatAge).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.Modality).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.Date).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.Time).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.BodyPart).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.Type).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.ImgCnt).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.IsEmergency).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.IsMail).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.Comment).ParameterName);
insSQL.Append(",");
insSQL.Append(cmd.Add(order.Status).ParameterName);
insSQL.Append(" )");
cmd.CommandText = insSQL.ToString();
var retcnt = cmd.ExecuteNonQuery();
if (retcnt > 0)
{
ret = true;
}
}
return(ret);
}