/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(T_SYS_BIOLOGICALTYPE_Model m)
{
if (isExists(new T_SYS_BIOLOGICALTYPE_SW {
BIOLOCODE = m.BIOLOCODE,
}) == true)
{
return(new Message(false, "添加失败，该分类编码已存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO T_SYS_BIOLOGICALTYPE(BIOLOCODE, BIOLONAME, BIOLOENNAME, ORDERBY)");
sb.AppendFormat("VALUES(");
sb.AppendFormat(" '{0}'", ClsSql.EncodeSql(m.BIOLOCODE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BIOLONAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BIOLOENNAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORDERBY));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
return(new Message(false, "添加失败,请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(T_SYS_BIOLOGICALTYPE_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE T_SYS_BIOLOGICALTYPE SET");
sb.AppendFormat(" BIOLONAME='{0}'", ClsSql.EncodeSql(m.BIOLONAME));
sb.AppendFormat(",BIOLOENNAME='{0}'", ClsSql.EncodeSql(m.BIOLOENNAME));
sb.AppendFormat(",ORDERBY='{0}'", ClsSql.EncodeSql(m.ORDERBY));
sb.AppendFormat(" WHERE BIOLOCODE= '{0}'", ClsSql.EncodeSql(m.BIOLOCODE));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", ""));
}
else
{
return(new Message(false, "修改失败,请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(T_SYS_BIOLOGICALTYPE_Model m)
{
if (isExistsChild(new T_SYS_BIOLOGICALTYPE_SW {
BIOLOCODE = m.BIOLOCODE
}))
{
return(new Message(false, "存在下级分类，暂无法删除!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("Delete T_SYS_BIOLOGICALTYPE");
sb.AppendFormat(" where BIOLOCODE= '{0}'", ClsSql.EncodeSql(m.BIOLOCODE));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功!", ""));
}
else
{
return(new Message(false, "删除失败!", ""));
}
}
