/// <summary> /// 空间库火险等级更新 根据QH_CODE更新 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message UpdateAceHuoXianDengJiByQHCODE(YJ_DANGERCLASS_Model m) { List <string> sqllist = new List <string>(); var arrBYORGNO = m.BYORGNO.Split(','); var arrDANGERCLASS = m.DANGERCLASS.Split(','); Message ms = null; StringBuilder sb1 = new StringBuilder(); for (int i = 0; i < arrBYORGNO.Length - 1; i++) { if (ClsSql.EncodeSql(arrDANGERCLASS[i]) != "") { string QHCODE = arrBYORGNO[i] + "000"; sb1.AppendFormat(" Update HUOXIANDENGJI set DValue={0}", ClsSql.EncodeSql(arrDANGERCLASS[i])); sb1.AppendFormat(" Where QH_CODE='{0}'", ClsSql.EncodeSql(QHCODE)); sqllist.Add(sb1.ToString()); sb1.Remove(0, sb1.Length); } } var j = SDEDataBaseClass.ExecuteSqlTran(sqllist); if (j >= 0) { ms = new Message(true, "保存成功!", ""); } else { ms = new Message(false, "保存失败,事物回滚!", ""); } return(ms); }
/// <summary> /// 更新三维库危害等级 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message UpdateAceHarmClass(PEST_HARMCLASS_Model m) { List <string> sqllist = new List <string>(); var arrBYORGNO = m.BYORGNO.Split(','); var arrHARMCLASS = m.HARMCLASS.Split(','); var arrDCDATE = m.DCDATE.Split(','); for (int i = 0; i < arrBYORGNO.Length - 1; i++) { if (ClsSql.EncodeSql(arrHARMCLASS[i]) != "") { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" UPDATE PESTHARMCLASS SET "); sb.AppendFormat(" HARMCLASS='{0}'", ClsSql.EncodeSql(arrHARMCLASS[i])); sb.AppendFormat(",DCDATE={0}", ClsSql.saveNullField(arrDCDATE[i])); sb.AppendFormat(" WHERE BYORGNO='{0}'", ClsSql.EncodeSql(arrBYORGNO[i])); sqllist.Add(sb.ToString()); } } var j = SDEDataBaseClass.ExecuteSqlTran(sqllist); if (j >= 0) { return(new Message(true, "保存成功!", "")); } else { return(new Message(false, "保存失败,事物回滚!", "")); } }
/// <summary> /// 更新三维库危害等级 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message UpdateAceHarmClass_XZ(PEST_HARMCLASS_Model m) { Message ms = null; StringBuilder sb1 = new StringBuilder(); sb1.AppendFormat(" Update PESTHARMCLASS_XZ Set DValue={0}", ClsSql.EncodeSql(m.DValue)); sb1.AppendFormat(" Where NAME='{0}'", ClsSql.EncodeSql(m.Name)); List <string> sqllist = new List <string>(); sqllist.Add(sb1.ToString()); var i = SDEDataBaseClass.ExecuteSqlTran(sqllist); if (i > 0) { ms = new Message(true, "更新成功!", ""); } else { ms = new Message(false, "更新失败,事物回滚机制!", ""); } return(ms); }
/// <summary> /// 空间火险等级更新 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message UpdateAceHuoXianDengJi(YJ_DANGERCLASS_Model m) { Message ms = null; StringBuilder sb1 = new StringBuilder(); sb1.AppendFormat(" Update HUOXIANDENGJI set DValue={0}", ClsSql.EncodeSql(m.DValue)); sb1.AppendFormat(" Where NAME='{0}'", ClsSql.EncodeSql(m.Name)); List <string> sqllist = new List <string>(); sqllist.Add(sb1.ToString()); var i = SDEDataBaseClass.ExecuteSqlTran(sqllist); if (i > 0) { ms = new Message(true, "处理成功!", ""); } else { ms = new Message(false, "处理失败,事物回滚机制!", ""); } return(ms); }