using LYFZ.Helper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LoginDal
{
    public class server_entry : BaseDataOperate
    {
        public server_entry()
        {
            this._tableFieldNameString = "";
        }
        #region 属性和字段

        string _tableName = "server_entry";
        /// <summary>
        /// 获取数据表名
        /// </summary>
        public override string TableName
        {
            get { return _tableName; }
            set { this._tableName = value; }
        }

        /// <summary>
        /// 获取当前新的数据表模型对象
        /// </summary>
        public override object ObjModel
        {
            get
            {
                return this.CurrentModel;
            }
        }
        /// <summary>
        /// 获取当前新的MOdel
        /// </summary>
        public LoginModel.server_entry CurrentModel
        {
            get { return new LoginModel.server_entry(); }
        }


        string _tableFieldNameString = "";
        /// <summary>
        /// 数据表字段名数组
        /// </summary>
        public override string TableFieldNameString
        {
            get { return this._tableFieldNameString; }

            set { this._tableFieldNameString = value; }
        }

        #endregion

        #region 检查记录
        //基类已经实现
        #endregion

        #region 增加数据

        /// <summary>
        /// 增加一条数据, 返回Id
        /// </summary>
        /// <param name="model">Model对象</param>
        /// <returns></returns>
        public int Add(LoginModel.server_entry model)
        {
            LYFZ.Helper.CommandInfo comdInfo = this.GetAddCommandInfo(model, "");
            object result = SQLHelper.GetSingle(comdInfo.CommandText, (SqlParameter[])comdInfo.Parameters);
            return Convert.ToInt32(result);
        }
        #endregion

        #region 删除数据
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Delete(LoginModel.server_entry model)
        {
            return base.Delete(model.id);
        }
        #endregion

        #region 更新数据
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(LoginModel.server_entry model)
        {
            return base.Update(model);
        }

        /// <summary>
        /// 根据筛选字段和SQL筛选运算符号更新数据
        /// </summary>
        /// <param name="model">Model对象</param>
        /// <param name="filterFieldName">筛选字段名称</param>
        /// <param name="operators">SQL筛选运算符号</param>
        /// <param name="overlookFieldList">忽略字段名列表 字段名之间用“,”号分隔</param>
        /// <returns></returns>
        public bool Update(LoginModel.server_entry model, string filterFieldName = "ID", string operators = "=", string overlookFieldList = "ID")
        {
            return base.Update(model, filterFieldName, operators, overlookFieldList);
        }
        #endregion

        #region 查询数据
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public LoginModel.server_entry GetModel(int ID)
        {
            return DataRowToModel(GetDataRow(ID));
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        /// <param name="row"></param>
        /// <returns></returns>
        public LoginModel.server_entry DataRowToModel(DataRow row)
        {
            return DataRowToModelObject(row) as LoginModel.server_entry;
        }
        #endregion

        #region 数据分页
        //基类已实现相关方法
        #endregion

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool DeleteEx(string server_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from server_entry ");
            strSql.Append(" where server_id=@server_id ");
            SqlParameter[] parameters = { new SqlParameter("@server_id", SqlDbType.VarChar, 32) };
            parameters[0].Value = server_id;
            int rows = SQLHelper.ExecuteSql(strSql.ToString(), parameters);
            return rows > 0 ? true : false;
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool UpdateEx(LoginModel.server_entry model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update server_entry set ");

            strSql.Append(" server_db_psw = @server_db_psw , ");
            strSql.Append(" server_note = @server_note , ");
            //strSql.Append(" server_gen_time = @server_gen_time , ");
            //strSql.Append(" server_id = @server_id , ");
            //strSql.Append(" server_ip = @server_ip , ");
            //strSql.Append(" server_name = @server_name , ");
            strSql.Append(" server_domain = @server_domain , ");
            strSql.Append(" server_http_port = @server_http_port , ");
            strSql.Append(" server_tcp_port = @server_tcp_port , ");
            strSql.Append(" server_db_port = @server_db_port , ");
            strSql.Append(" server_db_user = @server_db_user  ");
            strSql.Append(" where server_id=@server_id  ");

            SqlParameter[] parameters =
                {
                new SqlParameter("@server_db_psw", model.server_db_psw) ,
                new SqlParameter("@server_note", model.server_note) ,
                //new SqlParameter("@server_gen_time", model.server_gen_time) ,
                new SqlParameter("@server_id", model.server_id) ,
                //new SqlParameter("@server_ip", model.server_ip) ,
                //new SqlParameter("@server_name", model.server_name) ,
                new SqlParameter("@server_domain", model.server_domain) ,
                new SqlParameter("@server_http_port",model.server_http_port) ,
                new SqlParameter("@server_tcp_port", model.server_tcp_port) ,
                new SqlParameter("@server_db_port", model.server_db_port) ,
                new SqlParameter("@server_db_user", model.server_db_user)
            };

            int rows = SQLHelper.ExecuteSql(strSql.ToString(), parameters);

            return rows > 0 ? true : false;
        }
    }
}