indexservice.cs

客户关系管理系统 客户关系管理系统

using System;
using System.Collections.Generic;
using System.Text;
using MyCRM.DBUtility;
using MyCRM.IDAL;
using MyCRM.Models;
using System.Data;
using System.Data.SqlClient;
//该源码下载自www.51aspx.com(５１ａsｐｘ．ｃｏｍ)

namespace MyCRM.DAL
{
    /// <summary>
    /// 主页数据层
    /// </summary>
    public class IndexService:IIndex
    {
        /// <summary>
        /// 根据父节点Id得到所有文件信息
        /// </summary>
        /// <param name="parentId"></param>
        /// <returns></returns>

        public List<Sys_right> GetTreeByParentId(string parentId)
        {
            string sql = "select * from Sys_right where Right_parent_code='" + parentId + "'";
            return GetListBySql(sql);
        }
        /// <summary>
        /// 根据SQL语句查询
        /// </summary>
        /// <param name="safeSql"></param>
        /// <returns></returns>
        private List<Sys_right> GetListBySql(string safeSql)
        {
            List<Sys_right> list = new List<Sys_right>();

            try
            {
                DataTable table = DBHelper.GetDataSet(safeSql);

                foreach (DataRow row in table.Rows)
                {
                    Sys_right right = new Sys_right();

                    right.Right_code = (string)row["Right_code"];
                    right.Right_parent_code = (string)row["Right_parent_code"];
                    right.Right_text =(string)row["Right_text"];
                    right.Right_tip = (string)row["Right_tip"];
                    right.Right_type = (string)row["Right_type"];
                    right.Right_url= (string)row["Right_url"];

                    list.Add(right);
                }

                return list;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }

        }
    }
}