/// <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, "删除失败，请检查各输入框是否正确！", ""));
}
}
