/// <summary> /// 更新JC_B /// </summary> /// <param name="alarmInfo"></param> private static void UpdateJC_BInfo(Jc_BInfo alarmInfo) { Dictionary <string, object> updateItems = new Dictionary <string, object>(); //updateItems.Add("State", alarmInfo.State); updateItems.Add("Etime", alarmInfo.Etime); //updateItems.Add("Zdz", alarmInfo.Zdz); //updateItems.Add("Pjz", alarmInfo.Pjz); //updateItems.Add("Zdzs", alarmInfo.Zdzs); //updateItems.Add("Kzk", alarmInfo.Kzk); //updateItems.Add("Isalarm", alarmInfo.Isalarm); //更新到缓存 AlarmCacheUpdatePropertiesRequest alarmCacheUpdatePropertiesRequest = new AlarmCacheUpdatePropertiesRequest(); alarmCacheUpdatePropertiesRequest.AlarmKey = alarmInfo.ID; alarmCacheUpdatePropertiesRequest.UpdateItems = updateItems; alarmCacheService.UpdateAlarmInfoProperties(alarmCacheUpdatePropertiesRequest); //更新到数据库 System.Data.DataColumn[] cols = new System.Data.DataColumn[updateItems.Count]; for (int i = 0; i < updateItems.Count; i++) { cols[i] = new System.Data.DataColumn(updateItems.Keys.ToList()[i]); } Jc_BModel alarmModel = ObjectConverter.Copy <Jc_BInfo, Jc_BModel>(alarmInfo); List <Jc_BModel> alarmModels = new List <Jc_BModel>(); alarmModels.Add(alarmModel); alarmRecordRepository.BulkUpdate("KJ_DataAlarm" + alarmInfo.Stime.ToString("yyyyMM"), alarmModels, cols, "ID"); }
/// <summary> /// 根据Id获取报警数据 /// </summary> /// <param name="tableName"></param> /// <param name="id"></param> /// <returns></returns> public Jc_BModel GetAlarmInfoById(string tableName, string id) { var jc_BModel = new Jc_BModel(); var datatable = base.QueryTable("global_RealModule_GetAlarmData_ById", tableName, id); if (datatable != null) { var row = datatable.Rows[0]; if (row != null) { jc_BModel.ID = row["ID"].ToString(); jc_BModel.PointID = row["PointID"].ToString(); jc_BModel.Fzh = short.Parse(row["fzh"].ToString()); jc_BModel.Kh = short.Parse(row["kh"].ToString()); jc_BModel.Dzh = short.Parse(row["dzh"].ToString()); jc_BModel.Devid = row["devid"].ToString(); jc_BModel.Wzid = row["devid"].ToString(); jc_BModel.Point = row["point"].ToString(); jc_BModel.Type = short.Parse(row["type"].ToString()); jc_BModel.State = short.Parse(row["state"].ToString()); jc_BModel.Stime = DateTime.Parse(row["stime"].ToString()); jc_BModel.Etime = DateTime.Parse(row["etime"].ToString()); jc_BModel.Zdz = double.Parse(row["zdz"].ToString()); jc_BModel.Pjz = double.Parse(row["pjz"].ToString()); jc_BModel.Zdzs = DateTime.Parse(row["zdzs"].ToString()); jc_BModel.Cs = row["cs"].ToString(); jc_BModel.Kzk = row["kzk"].ToString(); jc_BModel.Kdid = row["kdid"].ToString(); jc_BModel.Isalarm = short.Parse(row["isalarm"].ToString()); jc_BModel.Remark = row["remark"].ToString(); jc_BModel.Pjz = double.Parse(row["Pjz"].ToString()); jc_BModel.Bz1 = row["Bz1"].ToString(); jc_BModel.Bz2 = row["Bz2"].ToString(); jc_BModel.Bz3 = row["Bz3"].ToString(); jc_BModel.Bz4 = row["Bz4"].ToString(); jc_BModel.Bz5 = row["Bz5"].ToString(); jc_BModel.Upflag = row["upflag"].ToString(); } } return(jc_BModel); }