/// <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); }