/// <summary> /// 增删改 /// </summary> /// <param name="m">参见模型T_SYS_TREESPECIES_Model</param> /// <returns></returns> public static Message Manager(T_SYS_TREESPECIES_Model m) { if (m.opMethod == "Add") { Message msgTREESPECIES = BaseDT.T_SYS_TREESPECIES.Add(m); if (msgTREESPECIES.Success == false) { return(new Message(msgTREESPECIES.Success, msgTREESPECIES.Msg, "")); } return(new Message(msgTREESPECIES.Success, msgTREESPECIES.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { Message msgTREESPECIES = BaseDT.T_SYS_TREESPECIES.Mdy(m); if (msgTREESPECIES.Success == false) { return(new Message(msgTREESPECIES.Success, msgTREESPECIES.Msg, "")); } return(new Message(msgTREESPECIES.Success, msgTREESPECIES.Msg, m.returnUrl)); } if (m.opMethod == "Del") { Message msgTREESPECIES = BaseDT.T_SYS_TREESPECIES.Del(m); if (msgTREESPECIES.Success == false) { return(new Message(msgTREESPECIES.Success, msgTREESPECIES.Msg, "")); } return(new Message(msgTREESPECIES.Success, msgTREESPECIES.Msg, m.returnUrl)); } return(new Message(false, "无效操作", m.returnUrl)); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(T_SYS_TREESPECIES_Model m) { if (!isExists(new T_SYS_TREESPECIES_SW { TSPCODE = m.TSPCODE })) { return(new Message(false, "修改失败,该树种编码不存在!", m.returnUrl)); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE T_SYS_TREESPECIES"); sb.AppendFormat(" set "); sb.AppendFormat("TSPCODE='{0}'", ClsSql.EncodeSql(m.TSPCODE)); sb.AppendFormat(",TSPNAME='{0}'", ClsSql.EncodeSql(m.TSPNAME)); sb.AppendFormat(",LATINNAME='{0}'", ClsSql.EncodeSql(m.LATINNAME)); sb.AppendFormat(",ORDERBY={0}", ClsSql.EncodeSql(m.ORDERBY)); sb.AppendFormat(" where TSPCODE= '{0}'", ClsSql.EncodeSql(m.TSPCODE)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.returnUrl)); } else { return(new Message(false, "修改失败!", m.returnUrl)); } }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(T_SYS_TREESPECIES_Model m) { if (isExists(new T_SYS_TREESPECIES_SW { TSPCODE = m.TSPCODE, }) == true) { return(new Message(false, "添加失败,该树种编码已存在!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO T_SYS_TREESPECIES(TSPCODE, TSPNAME, LATINNAME, ORDERBY)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.TSPCODE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.TSPNAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LATINNAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORDERBY)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", m.returnUrl)); } else { return(new Message(false, "添加失败!", m.returnUrl)); } }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw">参见条件模型T_SYS_TREESPECIES_SW</param> /// <returns>参见模型T_SYS_TREESPECIES_Model</returns> public static IEnumerable <T_SYS_TREESPECIES_Model> getListModel(T_SYS_TREESPECIES_SW sw) { var result = new List <T_SYS_TREESPECIES_Model>(); DataTable dt = BaseDT.T_SYS_TREESPECIES.getDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_TREESPECIES_Model m = new T_SYS_TREESPECIES_Model(); m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString(); m.TSPNAME = dt.Rows[i]["TSPNAME"].ToString(); m.LATINNAME = dt.Rows[i]["LATINNAME"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw">参见条件模型T_SYS_TREESPECIES_SW</param> /// <returns>参见模型T_SYS_TREESPECIES_Model</returns> public static T_SYS_TREESPECIES_Model getModel(T_SYS_TREESPECIES_SW sw) { DataTable dt = BaseDT.T_SYS_TREESPECIES.getModel(sw); T_SYS_TREESPECIES_Model m = new T_SYS_TREESPECIES_Model(); if (dt.Rows.Count > 0) { int i = 0; //数据库表字段 m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString(); m.TSPNAME = dt.Rows[i]["TSPNAME"].ToString(); m.LATINNAME = dt.Rows[i]["LATINNAME"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); //扩充字段 } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 删除(包含所有的子目录) /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(T_SYS_TREESPECIES_Model m) { if (isExistsChild(new T_SYS_TREESPECIES_SW { TSPCODE = m.TSPCODE })) { return(new Message(false, "存在下属树种,暂无法删除!先删除下属树种,再删除当前树种!", m.returnUrl)); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete from T_SYS_TREESPECIES WHERE TSPCODE='{0}' ", ClsSql.EncodeSql(m.TSPCODE)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", m.returnUrl)); } else { return(new Message(false, "删除失败!", m.returnUrl)); } }