/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(WILD_ANIMALDISTRIBUTE_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE WILD_ANIMALDISTRIBUTE"); sb.AppendFormat(" set "); sb.AppendFormat("BIOLOGICALTYPECODE={0}", ClsSql.saveNullField(m.BIOLOGICALTYPECODE)); sb.AppendFormat(",POPULATIONTYPE={0}", ClsSql.saveNullField(m.POPULATIONTYPE)); sb.AppendFormat(",MARK={0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",JWDLIST ={0}", ClsSql.saveNullField(m.JWDLIST)); sb.AppendFormat(",ANIMALCOUNT ={0}", ClsSql.saveNullField(m.ANIMALCOUNT)); sb.AppendFormat(" where WILD_ANIMALDISTRIBUTEID= '{0}'", ClsSql.EncodeSql(m.WILD_ANIMALDISTRIBUTEID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.WILD_ANIMALDISTRIBUTEID)); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(WILD_ANIMALDISTRIBUTE_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO WILD_ANIMALDISTRIBUTE( BIOLOGICALTYPECODE, POPULATIONTYPE, JD, WD, JWDLIST, ANIMALCOUNT, MARK) output inserted.WILD_ANIMALDISTRIBUTEID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.BIOLOGICALTYPECODE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.POPULATIONTYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JWDLIST)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ANIMALCOUNT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(")"); try { string strid = DataBaseClass.ReturnSqlField(sb.ToString()); if (string.IsNullOrEmpty(strid) == false) { return(new Message(true, "添加成功!", strid)); } else { return(new Message(false, "添加失败!请检查输入框是否正确", strid)); } } catch (Exception) { throw; } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(WILD_ANIMALDISTRIBUTE_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete WILD_ANIMALDISTRIBUTE"); sb.AppendFormat(" where WILD_ANIMALDISTRIBUTEID= '{0}'", ClsSql.EncodeSql(m.WILD_ANIMALDISTRIBUTEID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }