/// <summary> /// update /// </summary> /// <param name="AllInOne_AlarmInfo"></param> /// <returns></returns> public void Update(AllInOne_AlarmInfo model) { var str = GetUpdateStr(model); var dict = GetParameters(model); SqlHelper.Instance.ExcuteNon(str, dict); }
/// <summary> /// add /// </summary> /// <param name="AllInOne_AlarmInfo"></param> /// <returns></returns> public int Add(AllInOne_AlarmInfo model) { var str = GetInsertStr(model) + " select @@identity"; var dict = GetParameters(model); return(Convert.ToInt32(SqlHelper.Instance.ExecuteScalar(str, dict))); }
/// <summary> /// 插入 /// </summary> /// <param name="allinone_alarminfo"></param> /// <returns>是否成功</returns> public string GetInsertStr(AllInOne_AlarmInfo allinone_alarminfo) { StringBuilder part1 = new StringBuilder(); StringBuilder part2 = new StringBuilder(); if (allinone_alarminfo.siteNo != null) { part1.Append("siteNo,"); part2.Append("@siteNo,"); } if (allinone_alarminfo.RtuNo != null) { part1.Append("RtuNo,"); part2.Append("@RtuNo,"); } if (allinone_alarminfo.Devid != null) { part1.Append("Devid,"); part2.Append("@Devid,"); } if (allinone_alarminfo.DevType != null) { part1.Append("DevType,"); part2.Append("@DevType,"); } if (allinone_alarminfo.DevTypeName != null) { part1.Append("DevTypeName,"); part2.Append("@DevTypeName,"); } if (allinone_alarminfo.AlarmContent != null) { part1.Append("AlarmContent,"); part2.Append("@AlarmContent,"); } if (allinone_alarminfo.AlarmTime != null) { part1.Append("AlarmTime,"); part2.Append("@AlarmTime,"); } if (allinone_alarminfo.DealFlag != null) { part1.Append("DealFlag,"); part2.Append("@DealFlag,"); } if (allinone_alarminfo.DealTime != null) { part1.Append("DealTime,"); part2.Append("@DealTime,"); } if (allinone_alarminfo.DealOperator != null) { part1.Append("DealOperator,"); part2.Append("@DealOperator,"); } if (allinone_alarminfo.SmsTimes != null) { part1.Append("SmsTimes,"); part2.Append("@SmsTimes,"); } if (allinone_alarminfo.SmsSendTimes != null) { part1.Append("SmsSendTimes,"); part2.Append("@SmsSendTimes,"); } if (allinone_alarminfo.SmsInvTime != null) { part1.Append("SmsInvTime,"); part2.Append("@SmsInvTime,"); } if (allinone_alarminfo.Linkman != null) { part1.Append("Linkman,"); part2.Append("@Linkman,"); } if (allinone_alarminfo.MobileNo != null) { part1.Append("MobileNo,"); part2.Append("@MobileNo,"); } StringBuilder sql = new StringBuilder(); sql.Append("insert into allinone_alarminfo(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")"); return(sql.ToString()); }
/// <summary> /// 更新 /// </summary> /// <param name="allinone_alarminfo"></param> /// <returns>是否成功</returns> public string GetUpdateStr(AllInOne_AlarmInfo allinone_alarminfo) { StringBuilder part1 = new StringBuilder(); part1.Append("update allinone_alarminfo set "); if (allinone_alarminfo.siteNo != null) { part1.Append("siteNo = @siteNo,"); } if (allinone_alarminfo.RtuNo != null) { part1.Append("RtuNo = @RtuNo,"); } if (allinone_alarminfo.Devid != null) { part1.Append("Devid = @Devid,"); } if (allinone_alarminfo.DevType != null) { part1.Append("DevType = @DevType,"); } if (allinone_alarminfo.DevTypeName != null) { part1.Append("DevTypeName = @DevTypeName,"); } if (allinone_alarminfo.AlarmContent != null) { part1.Append("AlarmContent = @AlarmContent,"); } if (allinone_alarminfo.AlarmTime != null) { part1.Append("AlarmTime = @AlarmTime,"); } if (allinone_alarminfo.DealFlag != null) { part1.Append("DealFlag = @DealFlag,"); } if (allinone_alarminfo.DealTime != null) { part1.Append("DealTime = @DealTime,"); } if (allinone_alarminfo.DealOperator != null) { part1.Append("DealOperator = @DealOperator,"); } if (allinone_alarminfo.SmsTimes != null) { part1.Append("SmsTimes = @SmsTimes,"); } if (allinone_alarminfo.SmsSendTimes != null) { part1.Append("SmsSendTimes = @SmsSendTimes,"); } if (allinone_alarminfo.SmsInvTime != null) { part1.Append("SmsInvTime = @SmsInvTime,"); } if (allinone_alarminfo.Linkman != null) { part1.Append("Linkman = @Linkman,"); } if (allinone_alarminfo.MobileNo != null) { part1.Append("MobileNo = @MobileNo,"); } int n = part1.ToString().LastIndexOf(","); part1.Remove(n, 1); part1.Append(" where Id= @Id "); return(part1.ToString()); }
/// <summary> /// 获取参数 /// </summary> /// <param name="allinone_alarminfo"></param> /// <returns></returns> public Dictionary <string, string> GetParameters(AllInOne_AlarmInfo allinone_alarminfo) { Dictionary <string, string> dict = new Dictionary <string, string>(); if (allinone_alarminfo.Id != null) { dict.Add("@Id", allinone_alarminfo.Id.ToString()); } if (allinone_alarminfo.siteNo != null) { dict.Add("@siteNo", allinone_alarminfo.siteNo.ToString()); } if (allinone_alarminfo.RtuNo != null) { dict.Add("@RtuNo", allinone_alarminfo.RtuNo.ToString()); } if (allinone_alarminfo.Devid != null) { dict.Add("@Devid", allinone_alarminfo.Devid.ToString()); } if (allinone_alarminfo.DevType != null) { dict.Add("@DevType", allinone_alarminfo.DevType.ToString()); } if (allinone_alarminfo.DevTypeName != null) { dict.Add("@DevTypeName", allinone_alarminfo.DevTypeName.ToString()); } if (allinone_alarminfo.AlarmContent != null) { dict.Add("@AlarmContent", allinone_alarminfo.AlarmContent.ToString()); } if (allinone_alarminfo.AlarmTime != null) { dict.Add("@AlarmTime", allinone_alarminfo.AlarmTime.ToString()); } if (allinone_alarminfo.DealFlag != null) { dict.Add("@DealFlag", allinone_alarminfo.DealFlag.ToString()); } if (allinone_alarminfo.DealTime != null) { dict.Add("@DealTime", allinone_alarminfo.DealTime.ToString()); } if (allinone_alarminfo.DealOperator != null) { dict.Add("@DealOperator", allinone_alarminfo.DealOperator.ToString()); } if (allinone_alarminfo.SmsTimes != null) { dict.Add("@SmsTimes", allinone_alarminfo.SmsTimes.ToString()); } if (allinone_alarminfo.SmsSendTimes != null) { dict.Add("@SmsSendTimes", allinone_alarminfo.SmsSendTimes.ToString()); } if (allinone_alarminfo.SmsInvTime != null) { dict.Add("@SmsInvTime", allinone_alarminfo.SmsInvTime.ToString()); } if (allinone_alarminfo.Linkman != null) { dict.Add("@Linkman", allinone_alarminfo.Linkman.ToString()); } if (allinone_alarminfo.MobileNo != null) { dict.Add("@MobileNo", allinone_alarminfo.MobileNo.ToString()); } return(dict); }