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

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

namespace FangYar.OracleDAL.TBL
{
   public class SysDicmodDAL : FangYar.IDAL.TBL.SysDicmodIDAL
    {

        #region 私有方法
        /// <summary>
        /// DataRow转model实体类对象
        /// </summary>
        /// <param name="dr"></param>
        /// <returns></returns>
       private void DataRowToModel(Model.TBL.TBL_SYS_DICMOD_Model model, DataRow dr)
        {
            if (!DBNull.Value.Equals(dr["MOD_CODE"]))
                model.MOD_CODE = dr["MOD_CODE"].ToString();
            if (!DBNull.Value.Equals(dr["MOD_NAME"]))
                model.MOD_NAME = dr["MOD_NAME"].ToString();
       
        }
       /// <summary>
       /// 把DataRow行转成实体类对象
       /// </summary>
       private FangYar.Model.TBL.TBL_SYS_DICMOD_Model DataRowToModel(DataRow dr)
       {
           FangYar.Model.TBL.TBL_SYS_DICMOD_Model model = new Model.TBL.TBL_SYS_DICMOD_Model();
           if (!DBNull.Value.Equals(dr["MOD_CODE"]))
               model.MOD_CODE = dr["MOD_CODE"].ToString();
           if (!DBNull.Value.Equals(dr["MOD_NAME"]))
               model.MOD_NAME = dr["MOD_NAME"].ToString();

           return model;


       }
       /// <summary>
       /// 把DataTable行转成实体类List集合
       /// </summary>
       private List<FangYar.Model.TBL.TBL_SYS_DICMOD_Model> DataTableToList(DataTable dt)
       {
           List<FangYar.Model.TBL.TBL_SYS_DICMOD_Model> modellist = new List<Model.TBL.TBL_SYS_DICMOD_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 TBL_SYS_DICMOD ";
           if (strwhere != null && strwhere != "")
           {
               sql += " where " + strwhere;
           }
           try
           {

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

           }
           catch
           {
               return 0;
           }
       }

       /// <summary>
        /// 根据MOD_CODE获取model
        /// </summary>
       public FangYar.Model.TBL.TBL_SYS_DICMOD_Model GetModelByID(string MOD_CODE)
       {
           Model.TBL.TBL_SYS_DICMOD_Model model = null;
           string sql = "select * from TBL_SYS_DICMOD where MOD_CODE=@MOD_CODE";
           MySqlParameter[] paras ={
                                    new MySqlParameter("@MOD_CODE",MySqlDbType.VarChar,36)
                                    };
           paras[0].Value = MOD_CODE;
           DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql, paras);
           if (dt.Rows.Count > 0)
           {
               model = new Model.TBL.TBL_SYS_DICMOD_Model();
               DataRowToModel(model, dt.Rows[0]);
               return model;
           }
           else
           {
               return null;
           }
       }
        /// <summary>
        /// 添加
        /// </summary>
       public bool Add(FangYar.Model.TBL.TBL_SYS_DICMOD_Model model)
       {

           StringBuilder strsql = new StringBuilder();
           strsql.Append("insert into TBL_SYS_DICMOD (MOD_CODE,MOD_NAME)");
           strsql.Append("values");
           strsql.Append("(@MOD_CODE,@MOD_NAME)");
           MySqlParameter[] paras ={
                                    new MySqlParameter("@MOD_CODE",MySqlDbType.VarChar,50),
                                    new MySqlParameter("@MOD_NAME",MySqlDbType.VarChar,50),                       
                                    };
           paras[0].Value = model.MOD_CODE;
           paras[1].Value = model.MOD_NAME;
           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 TBL_SYS_DICMOD where MOD_CODE in('" + IDList + "')";
           try
           {
               FangYar.Common.MySqlHelper.ExecuteSql(sql);
               return true;
           }
           catch
           {
               return false;
           }
       }
        /// <summary>
        /// 编辑
        /// </summary>
       public bool Edit(FangYar.Model.TBL.TBL_SYS_DICMOD_Model model)
       {
           StringBuilder strsql = new StringBuilder();
           strsql.Append("update TBL_SYS_DICMOD set ");
    
           strsql.Append("MOD_NAME=@MOD_NAME ");
           strsql.Append(" where MOD_CODE=@MOD_CODE");
           MySqlParameter[] paras ={
                                  
                                    new MySqlParameter("@MOD_NAME",model.MOD_NAME),
                                    new MySqlParameter("@MOD_CODE",model.MOD_CODE)
                                    };
           int i = FangYar.Common.MySqlHelper.ExecuteSql(strsql.ToString(), paras);
           if (i > 0) { return true; }
           else { return false; }
       }
       #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.TBL.TBL_SYS_DICMOD_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.TBL.TBL_SYS_DICMOD_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, "TBL_SYS_DICMOD", 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, "TBL_SYS_DICMOD", 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, "TBL_SYS_DICMOD", "*", null, null, null);


       }
       #endregion

        #region 扩展业务方法

        #endregion

    }
}