Esempio n. 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()));
        }
Esempio n. 2
0
        /// <summary>
        /// 查询完WebService之后更新记录表
        /// </summary>
        /// <param name="cq">记录表对象</param>
        /// <param name="msg">查询之后的消息</param>
        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);
                    QueryRecoder q = new QueryRecoder();
                    q.Update(queryRecoder);
                }
                catch (Exception ex)
                {
                    Common.LogHelper.WriteError(ex);
                }
            }
        }
Esempio n. 3
0
        private void QueryData(HttpContext context, bool p)
        {
            if (p)
            {
            }
            else
            {
                //查询数据
                //string Mzzybz = context.Request["Mzzybz"];//0 门诊 1住院
                string code     = context.Request.Params["code"];//住院号或门诊号
                string codeType = context.Request.Params["codeType"];
                string dateNow  = context.Request.Params["dateNow"];

                Model.QueryRecoder qqq = new Model.QueryRecoder();
                qqq.Code      = code;
                qqq.CodeType  = codeType;
                qqq.QueryType = "NormalLisReport";
                qqq.Uname     = Common.CookieHelper.GetCookieValue("username");
                qqq.AddDate   = DateTime.Parse(dateNow);
                qqq.IsDel     = false;

                BLL.Request.Request request = new BLL.Request.NormalLisReportRequest(qqq);

                BLL.NormalLisReport NData = new BLL.NormalLisReport();
                string result             = NData.GetData(qqq, true);
                context.Response.Write(result);
            }
        }
Esempio n. 4
0
        /// <summary>
        /// 字典转化为model
        /// </summary>
        /// <returns></returns>
        public Model.QueryRecoder DicToQueryRecoderModel(Dictionary <string, string> dic)
        {
            string str = JsonConvert.SerializeObject(dic);

            Model.QueryRecoder queryRecoder = JsonConvert.DeserializeObject <Model.QueryRecoder>(str);
            return(queryRecoder);
        }
Esempio n. 5
0
        //private Model.DTO.NormalLisItemsRequest request;
        public List <Model.NormalLisItems> GetData(Model.QueryRecoder model, bool queryBycode)
        {
            BLL.Request.NormalLisItemsRequest normalLisItemsRequest = new Request.NormalLisItemsRequest(model);
            normalLisItemsRequest.CreatRequest(queryBycode);
            Model.QueryRecoder queryRecoderModel = normalLisItemsRequest.QueryRecoderModel;
            this.RequestList = normalLisItemsRequest.RequestStr;//临时变量
            List <Model.NormalLisItems> normalLisItems = new List <Model.NormalLisItems>();

            //   保存记录(查询记录数据,更新或添加)  string.IsNullOrEmpty(cq.RequestStr)存在值 修改修!string.IsNullOrEmpty(cq.RequestStr) kaka
            if (normalLisItemsRequest.RequestStr != null && normalLisItemsRequest.RequestStr.Count > 0)
            {
                //   调用接口获取数据
                //  正常这里只会传入一个连接字符串
                foreach (var item in normalLisItemsRequest.RequestStr)
                {
                    string xmlStr = GetWebServiceData(item);
                    string Msg    = "";
                    List <Model.NormalLisItems> tem = new List <Model.NormalLisItems>();
                    //  将xml数据转换成list集合会查询本地数据库去除重复项
                    tem = this.GetList(xmlStr, out Msg);
                    if (string.IsNullOrEmpty(Msg))
                    {
                        normalLisItems.AddRange(tem);
                    }
                }
            }

            return(normalLisItems);
        }
Esempio n. 6
0
        public override void CreatRequest(bool quertByCode)
        {
            //此方法this.RequestStr 赋值

            //01.按照code查询数据
            if (quertByCode)
            {
                //检查数据是否有记录
                //根据code、username、type、isdel 查询数据记录
                Model.QueryRecoder        newModel     = this.QueryRecoderModel;
                BLL.QueryRecoder          queryRecoder = new QueryRecoder();
                List <Model.QueryRecoder> list         = queryRecoder.CheckQueryRecord(newModel);
                if (list != null && list.Count > 0)
                {
                    //本地数据库有数据
                    Model.QueryRecoder oldModel = list.OrderByDescending(a => a.LastQueryDate).FirstOrDefault();
                    //对比数据库数据,并更新数据库数据
                    this.QueryRecoderModel = ContrastQueryRecoderModel(newModel, oldModel);
                }
                else
                {
                    //本地数据库无数据
                    this.QueryRecoderModel = ContrastQueryRecoderModel(newModel, null);
                }
            }
            //02.datagrid 提交过来的数据
            else
            {
                //数据肯定有记录
                Model.QueryRecoder oldModel = this.QueryRecoderModel;
                this.QueryRecoderModel = ContrastQueryRecoderModel(null, oldModel);
                //更新数据库的记录--更新X内容
            }
        }
Esempio n. 7
0
 private Model.QueryRecoder CreatQueryRecoderModel()
 {
     Model.QueryRecoder model = new Model.QueryRecoder();
     model.Code      = this.Code;
     model.CodeType  = this.CodeType;
     model.QueryType = "NormalLisItems";
     model.Uname     = Common.CookieHelper.GetCookieValue("username");
     model.IsDel     = false;
     return(model);
 }
Esempio n. 8
0
        /// <summary>
        /// 上传数据
        /// </summary>
        /// <param name="code">条码</param>
        /// <param name="codeType">条码的类型:0 卡号,1 住院号</param>
        /// <param name="dataStr">传入数据</param>
        /// <returns></returns>
        public string PostData(string dataStr, string username)
        {
            List <Dictionary <string, string> > dicList = GetClinicalInfoDgDicList(dataStr);
            string mes = "";

            //读取code和codeType
            if (dicList != null && dicList.Count > 0)
            {
                for (int i = 0; i < dicList.Count; i++)
                {
                    Model.QueryRecoder model = new Model.QueryRecoder();
                    model = DicToQueryRecoderModel(dicList[i]);//转化为MODEL
                    //获取值
                    string code     = dicList[i]["Code"];
                    string codeType = dicList[i]["CodeType"];
                    //string date = dicList[i]["LastQueryDate"];
                    //判断传入类型
                    if (model.QueryType == "NormalLisReport")
                    {
                        // BLL.Request.NormalLisReportRequest nrr = new Request.NormalLisReportRequest(model);
                        BLL.NormalLisReport nr = new NormalLisReport();
                        //nrr.CreatRequest(false);
                        string result = nr.GetData(model, false);
                        Model.DTO.JsonModel jsonModel_N = JsonConvert.DeserializeObject <Model.DTO.JsonModel>(result);
                        if (jsonModel_N.Statu == "ok")
                        {
                            string strdata = JsonConvert.SerializeObject(jsonModel_N.Data);
                            mes = mes + nr.PostData(code, codeType, strdata, username, true);//导入到临床检验数据
                        }
                        else
                        {
                            mes = mes + "," + jsonModel_N.Msg;
                        }
                    }
                    else if (model.QueryType == "PatientDiagnose")
                    {
                        BLL.Request.PatientDiagnoseResuest nrr = new Request.PatientDiagnoseResuest(model);
                        BLL.PatientDiagnose nr = new PatientDiagnose();
                        nrr.CreatRequest(false);
                        string result = nr.GetData(model, false);
                        Model.DTO.JsonModel jsonModel_N = JsonConvert.DeserializeObject <Model.DTO.JsonModel>(result);
                        if (jsonModel_N.Statu == "ok")
                        {
                            string strdata = JsonConvert.SerializeObject(jsonModel_N.Data);
                            mes = mes + nr.PostData(strdata, code, codeType, username, true);//导入到患者信息
                        }
                        else
                        {
                            mes = mes + "," + jsonModel_N.Msg;
                        }
                    }
                }
            }
            return(mes);
        }
Esempio n. 9
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);
            }
        }
Esempio n. 10
0
        //private bool SaveQueryRecord(ref Model.DTO.NormalLisItemsRequest resquet, string Msg, string codeType)
        //{
        //    bool result = false;
        //    QueryRecoder queryRecoder = new QueryRecoder();
        //    //根据传入的查询字符串创建的当此查询的记录model
        //    Model.QueryRecoder model = new Model.QueryRecoder();

        //    //model.AddDate = DateTime.Now;
        //    model.Code = request.hospnum;
        //    model.CodeType = codeType;
        //    model.QueryType = "NormalLisItems";
        //    model.Uname = Common.CookieHelper.GetCookieValue("username");
        //    model.IsDel = false;

        //    List<Model.QueryRecoder> list = CheckQueryRecord(model);
        //    if (list != null && list.Count > 0)
        //    {
        //        //判断查询出来的数据是否满足要求(时间差距lastdate<dateNow-5)
        //        Model.QueryRecoder oldModel = list.OrderByDescending(a => a.LastQueryDate).FirstOrDefault();
        //        model.AddDate = oldModel.AddDate;
        //        model.Id = oldModel.Id;
        //        DateTime dtAdd = Convert.ToDateTime(oldModel.AddDate);
        //        DateTime dtLastQuery = Convert.ToDateTime(oldModel.LastQueryDate);
        //        DateTime dt = DateTime.Now;//当前时间
        //        int days = (dt - dtAdd).Days;//获取当前日期与添加日期时间差
        //        int getDays = 0;
        //        if (days > getDays)
        //        {
        //            model.IsDel = true;
        //            model.LastQueryDate = dtAdd.AddDays(5);
        //        }
        //        else
        //        {
        //            int chaday = (dtLastQuery - dtAdd).Days;//获取最后查询日期与添加日期时间差
        //            int nowday = (dt - dtLastQuery).Days;//当前时间与最后查询时间差
        //            int addnowDay = (dt - dtAdd).Days;//当前时间与添加时间差
        //            if (nowday == 0)
        //            {
        //                //resquet.jsrq00 = "";
        //                //resquet.ksrq00 = "";
        //                result = true;
        //                model.IsDel = false;
        //                model.QueryResult += "&nbsp" + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
        //            }
        //            if (nowday > 0)//当前时间与最后查询时间差大于0
        //            {
        //                if (addnowDay == 0)
        //                {
        //                    result = true;
        //                    model.IsDel = false;
        //                    model.QueryResult += "&nbsp" + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
        //                }
        //                if (chaday >= getDays)
        //                {
        //                    model.IsDel = true;
        //                }
        //                else
        //                {
        //                    resquet.ksrq00 = dtLastQuery.ToString("yyyy-MM-dd");
        //                    resquet.jsrq00 = dtLastQuery.AddDays(1).ToString("yyyy-MM-dd");
        //                    result = true;
        //                    //添加日期是距离添加日期是5天内的
        //                    model.IsDel = false;
        //                    model.QueryResult += "&nbsp" + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
        //                }
        //            }
        //        }
        //        //本地数据库有数据
        //        result = queryRecoder.Update(model);
        //    }
        //    else
        //    {
        //        model.QueryResult += "&nbsp" + DateTime.Now.ToLocalTime() + " " + Msg.Trim();
        //        model.AddDate = DateTime.Now;
        //        model.LastQueryDate = DateTime.Now;
        //        bool bo = queryRecoder.Add(model) > 0;
        //        model.QueryType = "PatientDiagnose";
        //        bool boo = queryRecoder.Add(model) > 0;
        //        if (bo && boo)
        //        {
        //            result = true;
        //        }
        //        else { result = false; }
        //    }
        //    return result;
        //}

        private List <Model.QueryRecoder> CheckQueryRecord(Model.QueryRecoder model)
        {
            QueryRecoder queryRecoder = new QueryRecoder();
            //查询本地数据库有没有数据
            StringBuilder strWhere = new StringBuilder();

            strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
            strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
            strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
            strWhere.AppendFormat("IsDel = {0} and ", "'" + model.IsDel + "'");
            strWhere.AppendFormat("QueryType = {0} and  ", "'" + model.QueryType + "'");
            strWhere.AppendFormat("IsDel = {0}", "'" + false + "'");

            //查询条件是,当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
            return(queryRecoder.GetModelList(strWhere.ToString()));
        }
Esempio n. 11
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);
     }
 }
Esempio n. 12
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);
            }
        }
Esempio n. 13
0
 private void QueryData(HttpContext context, bool p)
 {
     if (p)
     {
     }
     else
     {
         //查询数据
         //string Mzzybz = context.Request["Mzzybz"];//0 门诊 1住院
         string code = context.Request.Params["code"];//住院号或门诊号
         string codeType = context.Request.Params["codeType"];
         string dateNow = context.Request.Params["dateNow"];
         Model.QueryRecoder qqq = new Model.QueryRecoder();
         qqq.Code = code;
         qqq.CodeType = codeType;
         qqq.QueryType = "PatientDiagnose";
         qqq.Uname = Common.CookieHelper.GetCookieValue("username");
         qqq.AddDate = DateTime.Parse(dateNow);
         qqq.IsDel = false;
         BLL.Request.PatientDiagnoseResuest nnnnn = new BLL.Request.PatientDiagnoseResuest(qqq);
         BLL.PatientDiagnose NData = new BLL.PatientDiagnose();
         string result = NData.GetData(qqq, true);
         context.Response.Write(result);
         //NData.GetData(BLL.Request.Request r);
     }
 }
Esempio n. 14
0
 public PatientDiagnoseResuest(Model.QueryRecoder queryRecoder)
 {
     this.QueryRecoderModel = queryRecoder;
 }
Esempio n. 15
0
 /// <summary>
 /// 上传数据
 /// </summary>
 /// <param name="code">条码</param>
 /// <param name="codeType">条码的类型:0 卡号,1 住院号</param>
 /// <param name="dataStr">传入数据</param>
 /// <returns></returns>
 public string PostData(string dataStr, string username)
 {
     List<Dictionary<string, string>> dicList = GetClinicalInfoDgDicList(dataStr);
     string mes = "";
     //读取code和codeType
     if (dicList != null && dicList.Count > 0)
     {
         for (int i = 0; i < dicList.Count; i++)
         {
             Model.QueryRecoder model = new Model.QueryRecoder();
             model = DicToQueryRecoderModel(dicList[i]);//转化为MODEL
             //获取值
             string code = dicList[i]["Code"];
             string codeType = dicList[i]["CodeType"];
             //string date = dicList[i]["LastQueryDate"];
             //判断传入类型
             if (model.QueryType == "NormalLisReport")
             {
                 // BLL.Request.NormalLisReportRequest nrr = new Request.NormalLisReportRequest(model);
                 BLL.NormalLisReport nr = new NormalLisReport();
                 //nrr.CreatRequest(false);
                 string result = nr.GetData(model, false);
                 Model.DTO.JsonModel jsonModel_N = JsonConvert.DeserializeObject<Model.DTO.JsonModel>(result);
                 if (jsonModel_N.Statu == "ok")
                 {
                     string strdata = JsonConvert.SerializeObject(jsonModel_N.Data);
                     mes = mes + nr.PostData(code, codeType, strdata, username, true);//导入到临床检验数据
                 }
                 else
                 {
                     mes = mes + "," + jsonModel_N.Msg;
                 }
             }
             else if (model.QueryType == "PatientDiagnose")
             {
                 BLL.Request.PatientDiagnoseResuest nrr = new Request.PatientDiagnoseResuest(model);
                 BLL.PatientDiagnose nr = new PatientDiagnose();
                 nrr.CreatRequest(false);
                 string result = nr.GetData(model, false);
                 Model.DTO.JsonModel jsonModel_N = JsonConvert.DeserializeObject<Model.DTO.JsonModel>(result);
                 if (jsonModel_N.Statu == "ok")
                 {
                     string strdata = JsonConvert.SerializeObject(jsonModel_N.Data);
                     mes = mes + nr.PostData(strdata, code, codeType, username, true);//导入到患者信息
                 }
                 else
                 {
                     mes = mes + "," + jsonModel_N.Msg;
                 }
             }
         }
     }
     return mes;
 }
Esempio n. 16
0
 private List<Model.NormalLisItems> GetNormalLisItemsList(Model.QueryRecoder queryRecoder, bool queryByCode)
 {
     BLL.Request.NormalLisItemsRequest normalLisItemsRequest = new Request.NormalLisItemsRequest(queryRecoder);
     BLL.NormalLisItems normalLisItems = new NormalLisItems();
     //将前台页面传入的model和标识传入到NormalLisItems中产生request
     List<Model.NormalLisItems> list = normalLisItems.GetData(queryRecoder, queryByCode);
     //查询完毕之后的QueryRecoder 对象
     this.queryRecoderModel = normalLisItemsRequest.QueryRecoderModel;
     this.requestStrList = normalLisItems.RequestList;
     return list;
 }
Esempio n. 17
0
        //private Model.DTO.PatientDiagnoseResuest request = new Model.DTO.PatientDiagnoseResuest();
        //private Model.QueryRecoder queryRecoderModel = null;
        //private List<string> requestStrList = null;
        public string GetData(Model.QueryRecoder model, bool queryBycode)
        {
            BLL.Request.PatientDiagnoseResuest cq = new Request.PatientDiagnoseResuest(model);
            cq.CreatRequest(queryBycode);
            Model.QueryRecoder  queryRecoderModel = cq.QueryRecoderModel;
            Model.DTO.JsonModel jsonmodel         = new Model.DTO.JsonModel()
            {
                Statu = "err", Msg = "无数据", Data = ""
            };

            //保存记录(查询记录数据,更新或添加)  string.IsNullOrEmpty(cq.RequestStr)存在值 修改修!string.IsNullOrEmpty(cq.RequestStr) kaka
            if (cq.RequestStr != null && cq.RequestStr.Count > 0)
            {
                List <Model.PatientDiagnose> patientDiagnoseList = new List <Model.PatientDiagnose>();
                StringBuilder msg = new StringBuilder();
                //调用接口获取数据
                foreach (var item in cq.RequestStr)
                {
                    string xmlStr = GetWebServiceData(item);
                    string _Msg   = "";
                    //返回数据缺少结束标记
                    if (!xmlStr.Contains("</Response>"))
                    {
                        xmlStr += "</Response>";
                    }
                    Model.DTO.PatientDiagnoseResuest request = XmlStrToPatientDiagnoseResuest(item);
                    if (request != null)
                    {
                        Model.PatientDiagnose patientDiagnose = StrTObject(xmlStr, out _Msg, request);
                        if (patientDiagnose != null)
                        {
                            if (!patientDiagnoseList.Contains(patientDiagnose))
                            {
                                bool check = CheckData(patientDiagnose);
                                if (!check)
                                {
                                    patientDiagnoseList.Add(patientDiagnose);
                                }
                            }
                            if (!string.IsNullOrEmpty(_Msg))
                            {
                                msg.Replace(_Msg, "");
                                msg.Append(" &nbsp " + _Msg);
                            }
                        }
                    }
                    //nnn.Add(model.Code);

                    else
                    {
                        if (!string.IsNullOrEmpty(_Msg))
                        {
                            msg.Replace(_Msg, "");
                            msg.Append(" &nbsp " + _Msg);
                        }
                    }
                }
                if (patientDiagnoseList != null && patientDiagnoseList.Count > 0)
                {
                    //有数据
                    jsonmodel = CreatJsonMode("ok", msg.ToString(), patientDiagnoseList);
                    ChangeQueryRecordStatu(cq, msg.ToString());
                }
                else
                {
                    //无数据
                    jsonmodel = CreatJsonMode("err", msg.ToString(), patientDiagnoseList);
                    ChangeQueryRecordStatu(cq, msg.ToString());
                }
            }
            return(JsonConvert.SerializeObject(jsonmodel));
        }
Esempio n. 18
0
 /// <summary>
 /// datagrid查询数据
 /// </summary>
 public NormalLisItemsRequest(Model.QueryRecoder queryRecoder)
 {
     this.QueryRecoderModel = queryRecoder;
 }
Esempio n. 19
0
 private Model.QueryRecoder CreatQueryRecoderModel()
 {
     Model.QueryRecoder model = new Model.QueryRecoder();
     model.Code = this.Code;
     model.CodeType = this.CodeType;
     model.QueryType = "PatientDiagnose";
     model.Uname = Common.CookieHelper.GetCookieValue("username");
     model.IsDel = false;
     return model;
 }
Esempio n. 20
0
        private Model.QueryRecoder ContrastQueryRecoderModel(Model.QueryRecoder newModel, Model.QueryRecoder oldModel)
        {
            this.RequestStr = new List <string>();
            Model.QueryRecoder resultModel  = new Model.QueryRecoder();
            BLL.QueryRecoder   queryRecoder = new QueryRecoder();
            //对比创建的model和数据库中的model。
            //对比方面:addDate、lastQueryDate、QueryResult
            int queryDateInterval = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["QueryDateInterval"].Trim());

            if (newModel == null)
            {
                //datagrid里面的数据

                #region datagrid里面的数据

                if ((DateTime.Now - oldModel.AddDate).Days > queryDateInterval)
                {
                    //最后一次查询时间
                    string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    //更新最后一次查询时间
                    oldModel.LastQueryDate = DateTime.Now;
                    resultModel            = oldModel;
                    try
                    {
                        bool updateResult = queryRecoder.Update(resultModel);
                        if (updateResult)
                        {
                            //更新数据成功
                            // this.RequestStr = 最后一次查询时间到adddate+5
                            this.RequestStr.Add(CreatRequestStr(lastQueryDateStr, oldModel.AddDate.AddDays(queryDateInterval).ToString("yyyy-MM-dd")));
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                }
                else
                {
                    //5天范围内添加的数据
                    string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    if (oldModel.AddDate == oldModel.LastQueryDate && oldModel.AddDate == DateTime.Now)
                    {
                        //当天的数据
                    }
                    else if (oldModel.AddDate == oldModel.LastQueryDate && oldModel.AddDate < DateTime.Now)
                    {
                        oldModel.LastQueryDate = DateTime.Now;
                        resultModel            = oldModel;
                        try
                        {
                            bool updateResult = queryRecoder.Update(resultModel);
                            if (updateResult)
                            {
                                //更新数据成功
                                // this.RequestStr = 最后一次查询时间到adddate+5
                                this.RequestStr.Add(CreatRequestStr(lastQueryDateStr, oldModel.AddDate.AddDays(queryDateInterval).ToString("yyyy-MM-dd")));
                            }
                        }
                        catch (Exception ex)
                        {
                            Common.LogHelper.WriteError(ex);
                        }
                    }
                }

                #endregion datagrid里面的数据
            }
            else if (oldModel == null)
            {
                //本地数据库没数据,并且是用code添加信息

                #region 本地数据库没数据,并且是用code添加信息

                //超时的老数据第一次添加
                if ((DateTime.Now - newModel.AddDate).Days > queryDateInterval)
                {
                    newModel.LastQueryDate = DateTime.Now;
                    try
                    {
                        int res = queryRecoder.Add(newModel);
                        if (res > 0)
                        {
                            resultModel = queryRecoder.CheckQueryRecord(newModel).OrderByDescending(a => a.AddDate).FirstOrDefault();
                            string k = newModel.AddDate.AddDays(-queryDateInterval).ToString("yyyy-MM-dd");
                            string j = newModel.AddDate.AddDays(queryDateInterval).ToString("yyyy-MM-dd");
                            this.RequestStr.Add(CreatRequestStr(k, j));
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                }
                else
                {
                    //新添加的数据并且是在范围内
                    newModel.LastQueryDate = DateTime.Now;
                    try
                    {
                        int res = queryRecoder.Add(newModel);
                        if (res > 0)
                        {
                            resultModel = queryRecoder.CheckQueryRecord(newModel).OrderByDescending(a => a.AddDate).FirstOrDefault();
                            string k = newModel.AddDate.AddDays(-queryDateInterval).ToString("yyyy-MM-dd");
                            string j = DateTime.Now.ToString("yyyy-MM-dd");
                            //查询字符串的范围是当前日期的前几天,到当前日期
                            this.RequestStr.Add(CreatRequestStr(k, j));
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                }

                #endregion 本地数据库没数据,并且是用code添加信息
            }
            else if (newModel != null && oldModel != null)
            {
                //当前时间和最后的查询时间的查值
                int dateDifWithOldLastDateAndDateNow = (DateTime.Now - Convert.ToDateTime(oldModel.LastQueryDate)).Days;
                int dateDifWithOldAddDateAndDateNow  = (DateTime.Now - oldModel.AddDate).Days;
                int dateDifWithLastAndAddDate        = (Convert.ToDateTime(oldModel.LastQueryDate) - oldModel.AddDate).Days;
                //本地数据库有数据,并且是用code添加信息
                //01.判断lastquery 和当前日期
                if (oldModel.LastQueryDate == newModel.LastQueryDate && oldModel.LastQueryDate == DateTime.Now)
                {
                    //重复查询数据
                }
                else if (dateDifWithOldAddDateAndDateNow >= 2 * queryDateInterval)
                {
                    string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    //超时 并且是2倍时间间隔之前的数据——新建一条数据
                    Model.QueryRecoder newRecord = new Model.QueryRecoder()
                    {
                        AddDate       = DateTime.Now.AddDays(-queryDateInterval),
                        Code          = newModel.Code,
                        CodeType      = newModel.CodeType,
                        IsDel         = false,
                        LastQueryDate = DateTime.Now.AddDays(-queryDateInterval),
                        QueryType     = newModel.QueryType,
                        Uname         = newModel.Uname
                    };
                    oldModel.LastQueryDate = oldModel.AddDate.AddDays(queryDateInterval);
                    try
                    {
                        bool q = queryRecoder.CheckRecord(newRecord);
                        if (!q)
                        {
                            //不存在
                            int add = queryRecoder.Add(newRecord);
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                    resultModel = oldModel;
                    //最后查询时间到老model的添加时间加上时间间隔
                    if (dateDifWithLastAndAddDate >= queryDateInterval)
                    {
                        this.RequestStr.Add(CreatRequestStr(oldModel.AddDate.ToString("yyyy-MM-dd"), oldModel.AddDate.AddDays(queryDateInterval).ToString("yyyy-MM-dd")));
                    }
                    else
                    {
                        this.RequestStr.Add(CreatRequestStr(lastQueryDateStr, oldModel.AddDate.AddDays(queryDateInterval).ToString("yyyy-MM-dd")));
                    }
                }
                else if (dateDifWithOldAddDateAndDateNow >= queryDateInterval && dateDifWithOldAddDateAndDateNow < 2 * queryDateInterval)
                {
                    //查询时间有重合
                    string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    this.RequestStr.Add(CreatRequestStr(lastQueryDateStr, oldModel.AddDate.AddDays(queryDateInterval).ToString("yyyy-MM-dd")));
                    //超时 并且是2倍时间间隔之前的数据——新建一条数据
                    Model.QueryRecoder newRecord = new Model.QueryRecoder()
                    {
                        AddDate       = oldModel.AddDate.AddDays(queryDateInterval),
                        Code          = newModel.Code,
                        CodeType      = newModel.CodeType,
                        IsDel         = false,
                        LastQueryDate = oldModel.AddDate.AddDays(queryDateInterval),
                        QueryType     = newModel.QueryType,
                        Uname         = newModel.Uname
                    };
                    try
                    {
                        bool q = queryRecoder.CheckRecord(newRecord);
                        if (!q)
                        {
                            //不存在
                            int add = queryRecoder.Add(newRecord);
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                        throw;
                    }
                    oldModel.LastQueryDate = oldModel.AddDate.AddDays(queryDateInterval);
                    resultModel            = oldModel;
                }
                else
                {
                    string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    //没超时,还在时间范围内的
                    oldModel.LastQueryDate = DateTime.Now;
                    this.RequestStr.Add(CreatRequestStr(lastQueryDateStr, DateTime.Now.ToString("yyyy-MM-dd")));
                    resultModel = oldModel;
                }
            }
            List <string> temResquestStrList = new List <string>();
            if (this.RequestStr != null && this.RequestStr.Count > 0)
            {
                foreach (string item in this.RequestStr)
                {
                    if (!temResquestStrList.Contains(item))
                    {
                        temResquestStrList.Add(item);
                    }
                }
            }
            this.RequestStr = temResquestStrList;
            return(resultModel);
        }
Esempio n. 21
0
        private Model.QueryRecoder ContrastQueryRecoderModel(Model.QueryRecoder newModel, Model.QueryRecoder oldModel)
        {
            this.RequestStr = new List<string>();
            Model.QueryRecoder resultModel = new Model.QueryRecoder();
            BLL.QueryRecoder queryRecoder = new QueryRecoder();
            //对比创建的model和数据库中的model。
            //对比方面:addDate、lastQueryDate、QueryResult
            int queryDateInterval = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["QueryDateInterval"].Trim());
            if (newModel == null)
            {
                //datagrid里面的数据

                #region datagrid里面的数据

                int nowAndAddDate = (DateTime.Now - oldModel.AddDate).Days;
                if (nowAndAddDate > queryDateInterval)
                {
                    //最后一次查询时间
                    string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    DateTime lastDate = new DateTime();
                    try
                    {
                        lastDate = Convert.ToDateTime(lastQueryDateStr);
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                    int lastDateAndAddDate = (lastDate - oldModel.AddDate).Days;
                    //更新最后一次查询时间
                    oldModel.LastQueryDate = DateTime.Now;
                    try
                    {
                        bool updateResult = queryRecoder.Update(resultModel);
                        if (updateResult && lastDate != null)
                        {
                            if (lastDateAndAddDate >= 0)
                            {
                                //正常情况
                                for (int i = 0; i < (queryDateInterval - lastDateAndAddDate); i++)
                                {
                                    string temStr = this.CreatRequestStr(oldModel.Code, lastDate.AddDays(i));
                                    this.RequestStr.Add(temStr);
                                }
                            }
                            else
                            {
                                //没有最后查询时间
                                for (int i = 0; i < (queryDateInterval - 0); i++)
                                {
                                    string temStr = this.CreatRequestStr(oldModel.Code, oldModel.AddDate.AddDays(i));
                                    this.RequestStr.Add(temStr);
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                    resultModel = oldModel;
                }
                else
                {
                    //5天范围内添加的数据
                    string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    DateTime lastDate = new DateTime();
                    try
                    {
                        lastDate = Convert.ToDateTime(lastQueryDateStr);
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }

                    if ((oldModel.AddDate == oldModel.LastQueryDate && oldModel.AddDate == DateTime.Now) || (oldModel.LastQueryDate < oldModel.AddDate && oldModel.AddDate == DateTime.Now))
                    {
                        //当天的数据
                    }
                    else if ((oldModel.AddDate == oldModel.LastQueryDate && oldModel.AddDate < DateTime.Now) || (oldModel.LastQueryDate < oldModel.AddDate && oldModel.AddDate < DateTime.Now))
                    {
                        oldModel.LastQueryDate = DateTime.Now;
                        try
                        {
                            bool updateResult = queryRecoder.Update(resultModel);
                            if (updateResult)
                            {
                                //更新数据成功
                                // this.RequestStr = 最后一次查询时间到adddate+5
                                for (int i = 0; i < nowAndAddDate; i++)
                                {
                                    string temStr = CreatRequestStr(oldModel.Code, oldModel.AddDate.AddDays(i));
                                    this.RequestStr.Add(temStr);
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            Common.LogHelper.WriteError(ex);
                        }

                        resultModel = oldModel;
                    }
                }

                #endregion datagrid里面的数据
            }
            else if (oldModel == null)
            {
                //本地数据库没数据,并且是用code添加信息

                #region 本地数据库没数据,并且是用code添加信息

                //超时的老数据第一次添加
                if ((DateTime.Now - newModel.AddDate).Days > queryDateInterval)
                {
                    newModel.LastQueryDate = DateTime.Now;
                    try
                    {
                        int res = queryRecoder.Add(newModel);
                        if (res > 0)
                        {
                            resultModel = queryRecoder.CheckQueryRecord(newModel).OrderByDescending(a => a.AddDate).FirstOrDefault();
                            for (int i = 0; i < queryDateInterval; i++)
                            {
                                string temStr1 = this.CreatRequestStr(newModel.Code, newModel.AddDate.AddDays(-i).AddDays(-1));
                                string temStr2 = this.CreatRequestStr(newModel.Code, newModel.AddDate.AddDays(i));
                                this.RequestStr.Add(temStr1);
                                this.RequestStr.Add(temStr2);
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                }
                else
                {
                    //新添加的数据并且是在范围内
                    newModel.LastQueryDate = DateTime.Now;
                    try
                    {
                        int res = queryRecoder.Add(newModel);
                        if (res > 0)
                        {
                            resultModel = queryRecoder.CheckQueryRecord(newModel).OrderByDescending(a => a.AddDate).FirstOrDefault();
                            string k = newModel.Code;
                            string j = DateTime.Now.ToString("yyyy-MM-dd");
                            for (int i = 0; i < queryDateInterval; i++)
                            {
                                string temStr = this.CreatRequestStr(newModel.Code, newModel.AddDate.AddDays(-i).AddDays(-1));
                                this.RequestStr.Add(temStr);
                            }
                            for (int i = 0; i < (DateTime.Now - newModel.AddDate).Days; i++)
                            {
                                string temStr = this.CreatRequestStr(newModel.Code, newModel.AddDate.AddDays(i));
                                this.RequestStr.Add(temStr);
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                }

                #endregion 本地数据库没数据,并且是用code添加信息
            }
            else if (newModel != null && oldModel != null)
            {
                //当前时间和最后的查询时间的查值
                int dateDifWithOldLastDateAndDateNow = (DateTime.Now - Convert.ToDateTime(oldModel.LastQueryDate)).Days;
                int dateDifWithOldAddDateAndDateNow = (DateTime.Now - oldModel.AddDate).Days;
                //本地数据库有数据,并且是用code添加信息
                //01.判断lastquery 和当前日期
                if (oldModel.LastQueryDate == newModel.LastQueryDate && oldModel.LastQueryDate == DateTime.Now)
                {
                    //重复查询数据
                }
                else if (dateDifWithOldAddDateAndDateNow >= 2 * queryDateInterval)
                {
                    string Code = oldModel.Code;
                    //超时 并且是2倍时间间隔之前的数据——新建一条数据
                    Model.QueryRecoder newRecord = new Model.QueryRecoder()
                    {
                        AddDate = DateTime.Now.AddDays(-queryDateInterval),
                        Code = newModel.Code,
                        CodeType = newModel.CodeType,
                        IsDel = false,
                        LastQueryDate = DateTime.Now.AddDays(-queryDateInterval),
                        QueryType = newModel.QueryType,
                        Uname = newModel.Uname
                    };
                    DateTime lastDate = new DateTime();
                    try
                    {
                        lastDate = Convert.ToDateTime(oldModel.LastQueryDate);
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                    int lastDateAndAddDate = (lastDate - oldModel.AddDate).Days;
                    oldModel.LastQueryDate = oldModel.AddDate.AddDays(queryDateInterval);
                    try
                    {
                        bool q = queryRecoder.CheckRecord(newRecord);
                        if (!q)
                        {
                            //不存在
                            int add = queryRecoder.Add(newRecord);
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                    resultModel = oldModel;
                    //最后查询时间到老model的添加时间加上时间间隔
                    if (lastDateAndAddDate >= 0)
                    {
                        //正常情况
                        for (int i = 0; i < (queryDateInterval - lastDateAndAddDate); i++)
                        {
                            string temStr = this.CreatRequestStr(oldModel.Code, lastDate.AddDays(i));
                            this.RequestStr.Add(temStr);
                        }
                    }
                    else
                    {
                        //没有最后查询时间
                        for (int i = 0; i < (queryDateInterval - 0); i++)
                        {
                            string temStr = this.CreatRequestStr(oldModel.Code, oldModel.AddDate.AddDays(i));
                            this.RequestStr.Add(temStr);
                        }
                    }
                }
                else if (dateDifWithOldAddDateAndDateNow >= queryDateInterval && dateDifWithOldAddDateAndDateNow < 2 * queryDateInterval)
                {
                    //查询时间有重合
                    // string lastQueryDateStr = Convert.ToDateTime(oldModel.LastQueryDate).ToString("yyyy-MM-dd");
                    DateTime lastDate = new DateTime();
                    try
                    {
                        lastDate = Convert.ToDateTime(oldModel.LastQueryDate);
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                    int lastDateAndAddDate = (lastDate - oldModel.AddDate).Days;
                    //最后查询时间到老model的添加时间加上时间间隔
                    if (lastDateAndAddDate >= 0)
                    {
                        //正常情况
                        for (int i = 0; i < (queryDateInterval - lastDateAndAddDate); i++)
                        {
                            string temStr = this.CreatRequestStr(oldModel.Code, lastDate.AddDays(i));
                            this.RequestStr.Add(temStr);
                        }
                    }
                    else
                    {
                        //没有最后查询时间
                        for (int i = 0; i < (queryDateInterval - 0); i++)
                        {
                            string temStr = this.CreatRequestStr(oldModel.Code, oldModel.AddDate.AddDays(i));
                            this.RequestStr.Add(temStr);
                        }
                    }
                    // this.RequestStr.Add(CreatRequestStr(lastQueryDateStr, oldModel.AddDate.AddDays(queryDateInterval).ToString("yyyy-MM-dd")));
                    //超时 并且是时间间隔之前的数据——新建一条数据
                    Model.QueryRecoder newRecord = new Model.QueryRecoder()
                    {
                        AddDate = oldModel.AddDate.AddDays(queryDateInterval),
                        Code = newModel.Code,
                        CodeType = newModel.CodeType,
                        IsDel = false,
                        LastQueryDate = oldModel.AddDate.AddDays(queryDateInterval),
                        QueryType = newModel.QueryType,
                        Uname = newModel.Uname
                    };
                    try
                    {
                        bool q = queryRecoder.CheckRecord(newRecord);
                        if (!q)
                        {
                            //不存在
                            int add = queryRecoder.Add(newRecord);
                        }
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                        throw;
                    }
                    oldModel.LastQueryDate = oldModel.AddDate.AddDays(queryDateInterval);
                    resultModel = oldModel;
                }
                else
                {
                    string strCode = oldModel.Code;
                    //没超时,还在时间范围内的
                    DateTime lastDate = new DateTime();
                    try
                    {
                        lastDate = Convert.ToDateTime(oldModel.LastQueryDate);
                    }
                    catch (Exception ex)
                    {
                        Common.LogHelper.WriteError(ex);
                    }
                    //最后查询时间和当天时间对比
                    int nowAndLastDate = (DateTime.Now - lastDate).Days;
                    //最后查询时间到老model的添加时间加上时间间隔
                    if (nowAndLastDate <= queryDateInterval)
                    {
                        //正常情况
                        for (int i = 0; i < (nowAndLastDate); i++)
                        {
                            string temStr = this.CreatRequestStr(oldModel.Code, lastDate.AddDays(i));
                            this.RequestStr.Add(temStr);
                        }
                    }

                    // this.RequestStr.Add(CreatRequestStr(strCode, DateTime.Now.ToString("yyyy-MM-dd")));
                    oldModel.LastQueryDate = DateTime.Now;
                    resultModel = oldModel;
                }
            }
            List<string> temResquestStrList = new List<string>();
            if (this.RequestStr != null && this.RequestStr.Count > 0)
            {
                foreach (string item in this.RequestStr)
                {
                    if (!temResquestStrList.Contains(item))
                    {
                        temResquestStrList.Add(item);
                    }
                }
            }

            this.RequestStr = temResquestStrList;
            return resultModel;
        }