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