Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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());
        }
Esempio n. 4
0
        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);
        }