Exemplo n.º 1
0
        /// <summary>
        /// 获取急救数据信息
        /// </summary>
        /// <returns></returns>
        public List <ALARM_EVENT_INFO> getNewEventInfo()
        {
            try
            {
                List <ALARM_EVENT_INFO> list = new List <ALARM_EVENT_INFO>();
                DataTable dt = DB120Help.GetRecord(GetDataSql.GetALARMDataStr());
                foreach (DataRow r in dt.Rows)
                {
                    try
                    {
                        ALARM_EVENT_INFO aci = new ALARM_EVENT_INFO();

                        aci.CALLCOUNT     = int.Parse(r["CALLCOUNT"].ToString());
                        aci.DEALCOUNT     = int.Parse(r["DEALCOUNT"].ToString());
                        aci.DISPATCHCOUNT = int.Parse(r["DISPATCHCOUNT"].ToString());
                        aci.PAIENTCOUNT   = int.Parse(r["PAIENTCOUNT"].ToString());
                        aci.LASTTIME      = DateTime.Now;
                        aci.DATATIME      = r["DATATIME"].ToString();
                        aci.READFLAG      = 1;
                        list.Add(aci);
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                }
                return(list);
            }
            catch (System.Exception ex)
            {
                throw ex;
            }
        }
        public static ParameterSql GetDataExchangeDataAccessSql(ALARM_EVENT_INFO Data)
        {
            ParameterSql sqlpar = new ParameterSql();

            //20151210 修改人:朱星汉 修改内容:添加系统人员密码
            sqlpar.StrSql = "insert into ALARM_EVENT_INFO(DATATIME,CALLCOUNT,DEALCOUNT,DISPATCHCOUNT,PAIENTCOUNT,LASTTIME,READFLAG)values(:DATATIME,:CALLCOUNT,:DEALCOUNT,:DISPATCHCOUNT,:PAIENTCOUNT,:LASTTIME,:READFLAG)";
            OracleParameter[] par = { new OracleParameter(":DATATIME",      GetString(Data.DATATIME)),
                                      new OracleParameter(":CALLCOUNT",     Data.CALLCOUNT),
                                      new OracleParameter(":DEALCOUNT",     Data.DEALCOUNT),
                                      new OracleParameter(":DISPATCHCOUNT", Data.DISPATCHCOUNT),
                                      new OracleParameter(":PAIENTCOUNT",   Data.PAIENTCOUNT),
                                      new OracleParameter(":LASTTIME",      GetDateTime(Data.LASTTIME.ToString())),
                                      new OracleParameter(":READFLAG",      Data.READFLAG), };
            sqlpar.OrclPar = par;
            return(sqlpar);
        }