MyOAExx/OA.DAL/SysFunService.cs

（开头部分） 4KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

//============================================================
// Producnt name:		TenXiang.Code
// Coded by:			hotboart
// Auto generated at: 	2014/1/5 11:48:50
//============================================================



using System;						
using System.Collections.Generic;	
using System.Text;					
using System.Data;					
using System.Data.SqlClient;		
using OA.Models;

namespace OA.DAL
{								

	public static partial class SysFunService
	{	
		//Add Mothed Start
        public static readonly string InsertSql = "INSERT SysFun (NodeId,DisplayName, NodeURL, DisplayOrder, ParentNodeId)VALUES (@NodeId,@DisplayName, @NodeURL, @DisplayOrder, @ParentNodeId)";
		public static readonly string UpdateSql = "Update SysFun set DisplayName=@DisplayName, NodeURL=@NodeURL, DisplayOrder=@DisplayOrder, ParentNodeId=@ParentNodeId where NodeId=@NodeId";
		public static readonly string DeleteSql = "Delete FROM SysFun  where NodeId=@NodeId";
		public static readonly string SelectSql = "Select * FROM SysFun";
		public static readonly string SelectSqlById = "Select * FROM SysFun where NodeId =@NodeId";
	    public static int AddSysFun(SysFun sysFun)
	    {								
			string sql = InsertSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@DisplayName",sysFun.DisplayName),new SqlParameter("@NodeId",sysFun.NodeId), new SqlParameter("@NodeURL",sysFun.NodeURL), new SqlParameter("@DisplayOrder",sysFun.DisplayOrder), new SqlParameter("@ParentNodeId",sysFun.ParentNodeId)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int UpdateSysFun(SysFun sysFun)
	    {								
			string sql = UpdateSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@NodeId",sysFun.NodeId), new SqlParameter("@DisplayName",sysFun.DisplayName), new SqlParameter("@NodeURL",sysFun.NodeURL), new SqlParameter("@DisplayOrder",sysFun.DisplayOrder), new SqlParameter("@ParentNodeId",sysFun.ParentNodeId)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int DelSysFun(int NodeId)
	    {								
			string sql = DeleteSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@NodeId",NodeId)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}
		public static IList< SysFun > GetAllList()
		{								
			string sql = SelectSql;
    	    return GetListBySql(sql);
		}

        public static IList<SysFun> GetAllListByRoleId(string userid)
后面还有 49 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。