예제 #1
0
        public List <Model.QueryRecoder> CheckQueryRecord(Model.QueryRecoder model)
        {
            BLL.QueryRecoder qr           = new BLL.QueryRecoder();
            QueryRecoder     queryRecoder = new QueryRecoder();
            //查询本地数据库有没有数据
            StringBuilder strWhere = new StringBuilder();

            if (!string.IsNullOrEmpty(model.Uname))
            {
                strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
            }
            if (!string.IsNullOrEmpty(model.Code))
            {
                strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
            }
            if (!string.IsNullOrEmpty(model.CodeType))
            {
                strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
            }
            if (!string.IsNullOrEmpty(model.QueryType))
            {
                strWhere.AppendFormat("QueryType = {0} and  ", "'" + model.QueryType + "'");
            }
            if (!model.IsDel)
            {
                strWhere.AppendFormat("IsDel = {0}", "'" + model.IsDel + "'");
            }
            //查询条件是,当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
            return(qr.GetModelList(strWhere.ToString()));
        }
예제 #2
0
        private void ChangeQueryRecordStatu(BLL.Request.Request cq, string msg)
        {
            Model.QueryRecoder queryRecoder = cq.QueryRecoderModel;
            int queryDateInterval           = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["QueryDateInterval"].Trim());

            if (queryRecoder != null)
            {
                try
                {
                    if ((DateTime.Now - queryRecoder.AddDate).Days > queryDateInterval)
                    {
                        //超时数据
                        queryRecoder.LastQueryDate = DateTime.Now;
                        queryRecoder.IsDel         = true;
                    }
                    else
                    {
                        //不超时数据
                        queryRecoder.LastQueryDate = DateTime.Now;
                    }
                    queryRecoder.QueryResult = ("&nbsp" + DateTime.Now.ToLocalTime() + " " + msg + queryRecoder.QueryResult);
                    BLL.QueryRecoder q = new BLL.QueryRecoder();
                    q.Update(queryRecoder);
                }
                catch (Exception ex)
                {
                    Common.LogHelper.WriteError(ex);
                }
            }
        }
예제 #3
0
 public List<Model.QueryRecoder> CheckQueryRecord(Model.QueryRecoder model)
 {
     BLL.QueryRecoder qr = new BLL.QueryRecoder();
     QueryRecoder queryRecoder = new QueryRecoder();
     //查询本地数据库有没有数据
     StringBuilder strWhere = new StringBuilder();
     if (!string.IsNullOrEmpty(model.Uname))
     {
         strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
     }
     if (!string.IsNullOrEmpty(model.Code))
     {
         strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
     }
     if (!string.IsNullOrEmpty(model.CodeType))
     {
         strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
     }
     if (!string.IsNullOrEmpty(model.QueryType))
     {
         strWhere.AppendFormat("QueryType = {0} and  ", "'" + model.QueryType + "'");
     }
     if (!model.IsDel)
     {
         strWhere.AppendFormat("IsDel = {0}", "'" + model.IsDel + "'");
     }
     //查询条件是,当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
     return qr.GetModelList(strWhere.ToString());
 }
예제 #4
0
        /// <summary>
        /// 检查数据是否存在,会检测添加日期 true存在
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool CheckRecord(Model.QueryRecoder model)
        {
            BLL.QueryRecoder qr           = new BLL.QueryRecoder();
            QueryRecoder     queryRecoder = new QueryRecoder();
            //查询本地数据库有没有数据
            StringBuilder strWhere = new StringBuilder();

            if (!string.IsNullOrEmpty(model.Uname))
            {
                strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
            }
            if (!string.IsNullOrEmpty(model.Code))
            {
                strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
            }
            if (!string.IsNullOrEmpty(model.CodeType))
            {
                strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
            }
            if (!string.IsNullOrEmpty(model.QueryType))
            {
                strWhere.AppendFormat("QueryType = {0} and  ", "'" + model.QueryType + "'");
            }
            if (!model.IsDel)
            {
                strWhere.AppendFormat("IsDel = {0} and ", "'" + model.IsDel + "'");
            }
            DateTime date = new DateTime();

            if (DateTime.TryParse(model.AddDate.ToString("yyyy-MM-dd"), out date))
            {
                // select * from dbo.QueryRecoder where REPLACE(CONVERT(Char(10),AddDate,111),'/','-')='2015-08-06'
                strWhere.AppendFormat("REPLACE(CONVERT(Char(10),AddDate,111),'/','-')={0}", "'" + model.AddDate.ToString("yyyy-MM-dd") + "'");
                //strWhere.AppendFormat("AddDate = {0}", "'" + model.AddDate + "'");
            }
            //查询条件是,当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
            List <Model.QueryRecoder> list = new List <Model.QueryRecoder>();

            list = qr.GetModelList(strWhere.ToString());
            if (list != null && list.Count > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #5
0
 /// <summary>
 /// 检查数据是否存在,会检测添加日期 true存在
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool CheckRecord(Model.QueryRecoder model)
 {
     BLL.QueryRecoder qr = new BLL.QueryRecoder();
     QueryRecoder queryRecoder = new QueryRecoder();
     //查询本地数据库有没有数据
     StringBuilder strWhere = new StringBuilder();
     if (!string.IsNullOrEmpty(model.Uname))
     {
         strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
     }
     if (!string.IsNullOrEmpty(model.Code))
     {
         strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
     }
     if (!string.IsNullOrEmpty(model.CodeType))
     {
         strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
     }
     if (!string.IsNullOrEmpty(model.QueryType))
     {
         strWhere.AppendFormat("QueryType = {0} and  ", "'" + model.QueryType + "'");
     }
     if (!model.IsDel)
     {
         strWhere.AppendFormat("IsDel = {0} and ", "'" + model.IsDel + "'");
     }
     DateTime date = new DateTime();
     if (DateTime.TryParse(model.AddDate.ToString("yyyy-MM-dd"), out date))
     {
         // select * from dbo.QueryRecoder where REPLACE(CONVERT(Char(10),AddDate,111),'/','-')='2015-08-06'
         strWhere.AppendFormat("REPLACE(CONVERT(Char(10),AddDate,111),'/','-')={0}", "'" + model.AddDate.ToString("yyyy-MM-dd") + "'");
         //strWhere.AppendFormat("AddDate = {0}", "'" + model.AddDate + "'");
     }
     //查询条件是,当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
     List<Model.QueryRecoder> list = new List<Model.QueryRecoder>();
     list = qr.GetModelList(strWhere.ToString());
     if (list != null && list.Count > 0)
     {
         return true;
     }
     else
     {
         return false;
     }
 }
예제 #6
0
파일: WebForm1.aspx.cs 프로젝트: aj-hc/SZY
 protected void Button1_Click(object sender, EventArgs e)
 {
     RuRo.Model.QueryRecoder model = new Model.QueryRecoder();
     DateTime dt = new DateTime();
     for (int i = 0; i < 100; i++)
     {
         model.Uname = "kaka" + i.ToString();
         dt = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
         model.AddDate = dt.AddDays(i);
         model.LastQueryDate = dt.AddDays(i);
         model.Code = "code" + i.ToString();
         model.CodeType = "CodeType" + i.ToString();
         model.QueryType = "QueryType" + i.ToString();
         model.QueryResult = "QueryResult" + i.ToString();
         model.IsDel = true;
         RuRo.BLL.QueryRecoder bll = new BLL.QueryRecoder();
         bll.Add(model);
     }
 }
예제 #7
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            RuRo.Model.QueryRecoder model = new Model.QueryRecoder();
            DateTime dt = new DateTime();

            for (int i = 0; i < 100; i++)
            {
                model.Uname         = "kaka" + i.ToString();
                dt                  = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
                model.AddDate       = dt.AddDays(i);
                model.LastQueryDate = dt.AddDays(i);
                model.Code          = "code" + i.ToString();
                model.CodeType      = "CodeType" + i.ToString();
                model.QueryType     = "QueryType" + i.ToString();
                model.QueryResult   = "QueryResult" + i.ToString();
                model.IsDel         = true;
                RuRo.BLL.QueryRecoder bll = new BLL.QueryRecoder();
                bll.Add(model);
            }
        }
예제 #8
0
 private void ChangeQueryRecordStatu(BLL.Request.Request cq, string msg)
 {
     Model.QueryRecoder queryRecoder = cq.QueryRecoderModel;
     int queryDateInterval = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["QueryDateInterval"].Trim());
     if (queryRecoder != null)
     {
         try
         {
             if ((DateTime.Now - queryRecoder.AddDate).Days > queryDateInterval)
             {
                 //超时数据
                 queryRecoder.LastQueryDate = DateTime.Now;
                 queryRecoder.IsDel = true;
             }
             else
             {
                 //不超时数据
                 queryRecoder.LastQueryDate = DateTime.Now;
             }
             queryRecoder.QueryResult = ("&nbsp" + DateTime.Now.ToLocalTime() + " " + msg + queryRecoder.QueryResult);
             BLL.QueryRecoder q = new BLL.QueryRecoder();
             q.Update(queryRecoder);
         }
         catch (Exception ex)
         {
             Common.LogHelper.WriteError(ex);
         }
     }
 }