Esempio n. 1
0
        //検査メモ履歴の取得
        public static void GetStudyMemoHistory(StudyKey key, out List <StudyMemoItem> items)
        {
            items = new List <StudyMemoItem>();

            using (var db = new TryDbConnection(settings))
            {
                using (var cmd = db.CreateCommand())
                {
                    cmd.CommandText = "SELECT MemoDate,Memo,UserName FROM T_StudyMemoHistory WHERE StudyInstanceUID=@0 ORDER BY MemoDate DESC";
                    cmd.Add(key.StudyInstanceUID);

                    using (var dr = cmd.ExecuteReader())
                    {
                        while (dr.Read())
                        {
                            var item = new StudyMemoItem();
                            item.Memo     = (string)dr["Memo"];
                            item.UserName = (string)dr["UserName"];
                            item.MemoDate = (DateTime)dr["MemoDate"];

                            items.Add(item);
                        }
                    }
                }
            }
        }
Esempio n. 2
0
 public static bool SetStudyMemo(StudyKey key, StudyMemoItem item)
 {
     if (AppUtil.DbType == AppUtil.DB_CLD)
     {
         return(LCL.SetStudyMemo(key, item));
     }
     else
     {
         throw new NotImplementedException();
     }
 }
Esempio n. 3
0
 public static void GetStudyMemo(StudyKey key, out StudyMemoItem item, out int count)
 {
     if (AppUtil.DbType == AppUtil.DB_CLD)
     {
         LCL.GetStudyMemo(key, out item, out count);
     }
     else
     {
         throw new NotImplementedException();
     }
 }
Esempio n. 4
0
        //検査メモの取得
        public static void GetStudyMemo(StudyKey key, out StudyMemoItem item, out int histCount)
        {
            item      = null;
            histCount = 0;

            using (var db = new TryDbConnection(settings))
            {
                using (var cmd = db.CreateCommand())
                {
                    cmd.CommandText = "SELECT MemoDate,Memo,UserName FROM T_StudyMemo WHERE StudyInstanceUID=@0";
                    cmd.Add(key.StudyInstanceUID);

                    using (var dr = cmd.ExecuteReader())
                    {
                        if (dr.Read())
                        {
                            item          = new StudyMemoItem();
                            item.Memo     = (string)dr["Memo"];
                            item.UserName = (string)dr["UserName"];
                            item.MemoDate = (DateTime)dr["MemoDate"];
                        }
                    }
                }

                using (var cmd = db.CreateCommand())
                {
                    cmd.CommandText = "SELECT COUNT(*) cnt FROM T_StudyMemoHistory WHERE StudyInstanceUID=@0";
                    cmd.Add(key.StudyInstanceUID);

                    using (var dr = cmd.ExecuteReader())
                    {
                        if (dr.Read())
                        {
                            histCount = Convert.ToInt32(dr["cnt"]);
                        }
                    }
                }
            }
        }
Esempio n. 5
0
        //検査メモの設定
        public static bool SetStudyMemo(StudyKey key, StudyMemoItem item)
        {
            for (int i = 0; i < AppUtil.RetryCount; i++)
            {
                string err = "";
                var    now = DateTime.Now;

                using (var db = new TryDbConnection(settings))
                {
                    db.BeginTransaction();
                    try
                    {
                        using (var cmd = db.CreateCommand())
                        {
                            cmd.CommandText = "DELETE FROM T_StudyMemo WHERE StudyInstanceUID=@0";
                            cmd.Add(key.StudyInstanceUID);

                            cmd.ExecuteNonQuery();
                        }

                        if (item.Memo.Trim() != "")
                        {
                            using (var cmd = db.CreateCommand())
                            {
                                cmd.CommandText = "INSERT INTO T_StudyMemo(StudyInstanceUID,MemoDate,Memo,UserName) VALUES(@0,@1,@2,@3)";
                                cmd.Add(key.StudyInstanceUID);
                                cmd.Add(now);
                                cmd.Add(item.Memo);
                                cmd.Add(item.UserName);

                                cmd.ExecuteNonQuery();
                            }
                        }

                        using (var cmd = db.CreateCommand())
                        {
                            cmd.CommandText = "INSERT INTO T_StudyMemoHistory(StudyInstanceUID,MemoDate,Memo,UserName) VALUES(@0,@1,@2,@3)";
                            cmd.Add(key.StudyInstanceUID);
                            cmd.Add(now);
                            cmd.Add(item.Memo);
                            cmd.Add(item.UserName);

                            cmd.ExecuteNonQuery();
                        }

                        db.Commit();
                        return(true);
                    }
                    catch (Exception ex)
                    {
                        db.Rollback();
                        err = ex.ToString();
                    }
                }

                //リトライ
                if (i < AppUtil.RetryCount - 1)
                {
                    System.Threading.Thread.Sleep(AppUtil.SleepTime);
                }
                else
                {
                    LogUtil.Error(err);
                }
            }

            return(false);
        }