using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using MySql.Data.MySqlClient;

namespace FangYar.OracleDAL.ZHSQ
{
    public class FolderDAL : IDAL.ZHSQ.FolderIDAL
    {
        #region 私有方法
        /// <summary>
        /// DataRow转model实体类对象
        /// </summary>
        /// <param name="dr"></param>
        /// <returns></returns>
        private void DataRowToModel(Model.ZHSQ.ZHSQ_FOLDER_INFO_Model model, DataRow dr)
        {
            if (!DBNull.Value.Equals(dr["ID"]))
                model.ID = dr["ID"].ToString();
            if (!DBNull.Value.Equals(dr["F_CODE"]))
                model.F_CODE = int.Parse( dr["F_CODE"].ToString());
            if (!DBNull.Value.Equals(dr["F_NAME"]))
                model.F_NAME = dr["F_NAME"].ToString();
            if (!DBNull.Value.Equals(dr["F_FID"]))
                model.F_FID = dr["F_FID"].ToString();
            if (!DBNull.Value.Equals(dr["ORG_ID"]))
                model.ORG_ID = dr["ORG_ID"].ToString();
            if (!DBNull.Value.Equals(dr["F_DES"]))
                model.F_DES = dr["F_DES"].ToString();
            if (!DBNull.Value.Equals(dr["USER_CODE"]))
                model.USER_CODE = dr["USER_CODE"].ToString();
            if (!DBNull.Value.Equals(dr["F_TIME"]))
                model.F_TIME = dr["F_TIME"].ToString();
            if (!DBNull.Value.Equals(dr["F_ORDER"]))
                model.F_ORDER = int.Parse(dr["F_ORDER"].ToString());
        }
        /// <summary>
        /// 把DataRow行转成实体类对象
        /// </summary>
        private FangYar.Model.ZHSQ.ZHSQ_FOLDER_INFO_Model DataRowToModel(DataRow dr)
        {
            FangYar.Model.ZHSQ.ZHSQ_FOLDER_INFO_Model model = new Model.ZHSQ.ZHSQ_FOLDER_INFO_Model();
            if (!DBNull.Value.Equals(dr["ID"]))
                model.ID = dr["ID"].ToString();
            if (!DBNull.Value.Equals(dr["F_CODE"]))
                model.F_CODE = int.Parse(dr["F_CODE"].ToString());
            if (!DBNull.Value.Equals(dr["F_NAME"]))
                model.F_NAME = dr["F_NAME"].ToString();
            if (!DBNull.Value.Equals(dr["F_FID"]))
                model.F_FID = dr["F_FID"].ToString();
            if (!DBNull.Value.Equals(dr["ORG_ID"]))
                model.ORG_ID = dr["ORG_ID"].ToString();
            if (!DBNull.Value.Equals(dr["F_DES"]))
                model.F_DES = dr["F_DES"].ToString();
            if (!DBNull.Value.Equals(dr["USER_CODE"]))
                model.USER_CODE = dr["USER_CODE"].ToString();
            if (!DBNull.Value.Equals(dr["F_TIME"]))
                model.F_TIME = dr["F_TIME"].ToString();
            if (!DBNull.Value.Equals(dr["F_ORDER"]))
                model.F_ORDER = int.Parse(dr["F_ORDER"].ToString());
            return model;


        }
        /// <summary>
        /// 把DataRow行转成树节点实体类对象
        /// </summary>
        private FangYar.Model.TreeNodeModel DataRowToTreeNodeModel(DataRow dr)
        {
            FangYar.Model.TreeNodeModel model = new Model.TreeNodeModel();
            if (!DBNull.Value.Equals(dr["F_CODE"]))
                model.id = dr["F_CODE"].ToString();
            if (!DBNull.Value.Equals(dr["F_NAME"]))
                model.name = dr["F_NAME"].ToString();
            if (!DBNull.Value.Equals(dr["F_FID"]))
                model.pId = dr["F_FID"].ToString();
            
            return model;


        }
        /// <summary>
        /// 把DataTable行转成实体类List集合
        /// </summary>
        private List<FangYar.Model.TreeNodeModel> DataTableToTreeList(DataTable dt)
        {
            List<FangYar.Model.TreeNodeModel> modellist = new List<Model.TreeNodeModel>();
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow myRow in dt.Rows)
                {
                    modellist.Add(DataRowToTreeNodeModel(myRow));
                }
            }
            return modellist;

        }
        /// <summary>
        /// 把DataTable行转成实体类List集合
        /// </summary>
        private List<FangYar.Model.ZHSQ.ZHSQ_FOLDER_INFO_Model> DataTableToList(DataTable dt)
        {
            List<FangYar.Model.ZHSQ.ZHSQ_FOLDER_INFO_Model> modellist = new List<Model.ZHSQ.ZHSQ_FOLDER_INFO_Model>();
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow myRow in dt.Rows)
                {
                    modellist.Add(DataRowToModel(myRow));
                }
            }
            return modellist;

        }
        #endregion
        #region 基本方法

        /// <summary>
        /// 获取记录数
        /// </summary>
        public int Count(string strwhere)
        {
            string sql = "select count(1) from ZHSQ_FOLDER_INFO ";
            if (strwhere != null && strwhere != "")
            {
                sql += " where " + strwhere;
            }
            try
            {

                return FangYar.Common.MySqlHelper.GetCount(sql);

            }
            catch
            {
                return 0;
            }
        }

        /// <summary>
        /// 根据ID获取实体对象
        /// </summary>
        public Model.ZHSQ.ZHSQ_FOLDER_INFO_Model GetModelByID(string Id)
        {
            Model.ZHSQ.ZHSQ_FOLDER_INFO_Model model = null;
            string sql = "select * from ZHSQ_FOLDER_INFO where ID=@ID";
            MySqlParameter[] paras ={
                                    new MySqlParameter("@ID",MySqlDbType.VarChar,36)
                                    };
            paras[0].Value = Id;
            DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql, paras);
            if (dt.Rows.Count > 0)
            {
                model = new Model.ZHSQ.ZHSQ_FOLDER_INFO_Model();
                DataRowToModel(model, dt.Rows[0]);
                return model;

            }
            else
            {

                return null;
            }

        }

        /// <summary>
        /// 根据区域码获取实体类对象
        /// </summary>
        public Model.ZHSQ.ZHSQ_FOLDER_INFO_Model GetModelByCode(string Code)
        {
            Model.ZHSQ.ZHSQ_FOLDER_INFO_Model model = null;
            string sql = "select * from ZHSQ_FOLDER_INFO where AREA_CODE=@AREA_CODE";
            MySqlParameter[] paras ={
                                  new MySqlParameter("@AREA_CODE",MySqlDbType.VarChar,50)
                                  };
            paras[0].Value = Code;
            DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql, paras);
            if (dt.Rows.Count > 0)
            {
                model = new Model.ZHSQ.ZHSQ_FOLDER_INFO_Model();
                DataRowToModel(model, dt.Rows[0]);
                return model;
            }
            else
            {

                return null;
            }
        }
        /// <summary>
        /// 添加
        /// </summary>
        public bool Add(Model.ZHSQ.ZHSQ_FOLDER_INFO_Model model)
        {
            StringBuilder strsql = new StringBuilder();
            strsql.Append("insert into ZHSQ_FOLDER_INFO (F_CODE,F_NAME,F_FID,ORG_ID,F_DES,USER_CODE,F_TIME,F_ORDER)");
            strsql.Append("values");
            strsql.Append("(@F_CODE,@F_NAME,@F_FID,@ORG_ID,@F_DES,@USER_CODE,@F_TIME,@F_ORDER)");
            MySqlParameter[] paras ={
                                    new MySqlParameter("@F_CODE",MySqlDbType.Int32,8),
                                    new MySqlParameter("@F_NAME",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_FID",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@ORG_ID",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_DES",MySqlDbType.VarChar,500),
                                    new MySqlParameter("@USER_CODE",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_TIME",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_ORDER",MySqlDbType.Int32,8)
                                
                                 
                                    };
            paras[0].Value = model.F_CODE;
            paras[1].Value = model.F_NAME;
            paras[2].Value = model.F_FID;
            paras[3].Value = model.ORG_ID;
            paras[4].Value = model.F_DES;
            paras[5].Value = model.USER_CODE;
            paras[6].Value = model.F_TIME;
            paras[7].Value = model.F_ORDER;
            int i = FangYar.Common.MySqlHelper.ExecuteSql(strsql.ToString(), paras);
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }

        }
        /// <summary>
        ///修改
        /// </summary>
        public bool Edit(Model.ZHSQ.ZHSQ_FOLDER_INFO_Model model)
        {
            StringBuilder strsql = new StringBuilder();
            strsql.Append("update ZHSQ_FOLDER_INFO set ");
            strsql.Append("F_CODE=@F_CODE,");
            strsql.Append("F_NAME=@F_NAME,");
            strsql.Append("F_FID=@F_FID,");
            strsql.Append("ORG_ID=@ORG_ID,");
            strsql.Append("F_DES=@F_DES, ");
            strsql.Append("USER_CODE=@USER_CODE, ");
            strsql.Append("F_TIME=@F_TIME ");
            strsql.Append(" where ID=@ID");
            MySqlParameter[] paras ={
                                    new MySqlParameter("@F_CODE",MySqlDbType.Int32,8),
                                    new MySqlParameter("@F_NAME",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_FID",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@ORG_ID",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_DES",MySqlDbType.VarChar,500),
                                    new MySqlParameter("@USER_CODE",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_TIME",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@F_ORDER",MySqlDbType.Int32,8),
                                    new MySqlParameter("@ID",MySqlDbType.VarChar,50)
                                 
                                    };
            paras[0].Value = model.F_CODE;
            paras[1].Value = model.F_NAME;
            paras[2].Value = model.F_FID;
            paras[3].Value = model.ORG_ID;
            paras[4].Value = model.F_DES;
            paras[5].Value = model.USER_CODE;
            paras[6].Value = model.F_TIME;
            paras[7].Value = model.ID;
            paras[8].Value = model.F_ORDER;
            int i = FangYar.Common.MySqlHelper.ExecuteSql(strsql.ToString(), paras);
            if (i > 0) { return true; }
            else { return false; }

        }
        /// <summary>
        /// 删除
        /// </summary>
        public bool Delete(string IDList)
        {
            string sql = "delete from ZHSQ_FOLDER_INFO where ID in('" + IDList + "')";
            try
            {
                FangYar.Common.MySqlHelper.ExecuteSql(sql);
                return true;
            }
            catch
            {
                return false;
            }

        }

        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public DataTable GetModelList( string strwhere)
        {
            string sql = "select * from ZHSQ_FOLDER_INFO ";
            if (strwhere != null && strwhere != "")
            {
                sql += " where " + strwhere;
            }
            return FangYar.Common.MySqlHelper.QueryTable(sql);
        }
       
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public List<FangYar.Model.ZHSQ.ZHSQ_FOLDER_INFO_Model> GetModelToList(string strwhere)
        {
            return DataTableToList(GetModelList(strwhere));
        }
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public List<FangYar.Model.TreeNodeModel> GetListToTree(string strwhere)
        {
            return DataTableToTreeList(GetModelList(strwhere));
        }
        #endregion

        #region 分页

        /// <summary>
        /// 分页无排序
        /// </summary>
        /// <param name="PageIndex">页面索引</param>
        /// <param name="PageSize">页面大小</param>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public string QueryJsonList(int PageIndex, int PageSize, string strwhere)
        {
            return FangYar.Common.JsonHelper.ToJson(QueryPage(PageIndex, PageSize, strwhere));
        }
        
        /// <summary>
        /// 分页无排序
        /// </summary>
        /// <param name="PageIndex">页面索引</param>
        /// <param name="PageSize">页面大小</param>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public string QueryJsonList(int PageIndex, int PageSize, string strwhere, string order)
        {
            return FangYar.Common.JsonHelper.ToJson(QueryPage(PageIndex, PageSize, strwhere, order));
        }
        
        /// <summary>
        /// 分页无排序
        /// </summary>
        /// <param name="PageIndex">页面索引</param>
        /// <param name="PageSize">页面大小</param>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public List<FangYar.Model.ZHSQ.ZHSQ_FOLDER_INFO_Model> QueryList(int PageIndex, int PageSize, string strwhere)
        {
            return DataTableToList(QueryPage(PageIndex, PageSize, strwhere));
        }
        
        /// <summary>
        /// 分页无排序
        /// </summary>
        /// <param name="PageIndex">页面索引</param>
        /// <param name="PageSize">页面大小</param>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public List<FangYar.Model.ZHSQ.ZHSQ_FOLDER_INFO_Model> QueryList(int PageIndex, int PageSize, string strwhere, string order)
        {
            return DataTableToList(QueryPage(PageIndex, PageSize, strwhere, order));
        }
        
        /// <summary>
        /// 分页无排序
        /// </summary>
        /// <param name="PageIndex">页面索引</param>
        /// <param name="PageSize">页面大小</param>
        /// <param name="strwhere">查询条件</param>
        /// <returns></returns>
        public DataTable QueryPage(int PageIndex, int PageSize, string strwhere)
        {
            return FangYar.Common.MySqlHelper.QueryPage(PageIndex, PageSize, "ZHSQ_FOLDER_INFO", strwhere);
        }

        /// <summary>
        /// 分页无排序
        /// </summary>
        /// <param name="PageIndex">页面索引</param>
        /// <param name="PageSize">页面大小</param>
        /// <param name="strwhere">查询条件</param>
        /// <param name="strwhere">排序</param>
        /// <returns></returns>
        public DataTable QueryPage(int PageIndex, int PageSize, string strwhere, string order)
        {
            return FangYar.Common.MySqlHelper.QueryPage(PageIndex, PageSize, "ZHSQ_FOLDER_INFO", strwhere, order);
        }
        /// <summary>
        /// 存储过程分页
        /// </summary>
        /// <param name="PageIndex">页面索引</param>
        /// <param name="PageSize">页面大小</param>
        /// <param name="strwhere">查询条件</param>
        /// <param name="strwhere">排序</param>
        /// <returns></returns>
        public void QueryProc(int PageIndex, int PageSize, string strwhere, string order)
        {
            int totalcount = 0;
            FangYar.Common.SqlPagerHelperOra.Select(PageSize, PageIndex, out  totalcount, "ZHSQ_FOLDER_INFO", "*", null, null, null);
        }
        #endregion

        #region 扩展业务方法

        #endregion
    }
}