/// <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, "删除失败!", "")); } }