using System;
using System.Data;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
using CommonFunc;
using System.Text;
using XGL.Models;
namespace XGL.Data
{
    public class basedata_nodesettingDb : IDisposable
    {
        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(true);
        }
        protected virtual void Dispose(bool disposing)
        {
            if (!disposing)
                return;
        }
        ///<summary>
        ///判断是否存在记录
        ///</summary>
        public bool Exists(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from role");
            strSql.Append(" where ");
            strSql.Append(" id = @id  ");
            MySqlParameter[] parameters = {
            new MySqlParameter("@id", MySqlDbType.Int32)
            };
            parameters[0].Value = id;
            return DbHelperSQLServer.Exists(strSql.ToString(), parameters);
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(basedata_nodesettingModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into basedata_nodesetting(");
            strSql.Append("NodeNo,NodeDesc,PlcId,PlcId2,PlcId3,PlcId4,PlcId5,NodeType,LineAreaId,IsStaticNumber,IsClearCar,OrderIndex,IsDeleted,CreateTime,CreateId,CreateBy,ModifyTime,ModifyId,ModifyBy)");
            strSql.Append(" values (");
            strSql.Append("@NodeNo,@NodeDesc,@PlcId,@PlcId2,@PlcId3,@PlcId4,@PlcId5,@NodeType,@LineAreaId,@IsStaticNumber,@IsClearCar,@OrderIndex,@IsDeleted,@CreateTime,@CreateId,@CreateBy,@ModifyTime,@ModifyId,@ModifyBy)");
            strSql.Append("; select @@IDENTITY");
            MySqlParameter[] parameters = {
             new MySqlParameter("@Id",model.Id),
             new MySqlParameter("@NodeNo",model.NodeNo),
             new MySqlParameter("@NodeDesc",model.NodeDesc),
             new MySqlParameter("@PlcId",model.PlcId),
             new MySqlParameter("@PlcId2",model.PlcId2),
             new MySqlParameter("@PlcId3",model.PlcId3),
             new MySqlParameter("@PlcId4",model.PlcId4),
             new MySqlParameter("@PlcId5",model.PlcId5),
             new MySqlParameter("@NodeType",model.NodeType),
             new MySqlParameter("@LineAreaId",model.LineAreaId),
             new MySqlParameter("@IsStaticNumber",model.IsStaticNumber),
             new MySqlParameter("@IsClearCar",model.IsClearCar),
             new MySqlParameter("@OrderIndex",model.OrderIndex),
             new MySqlParameter("@IsDeleted",model.IsDeleted),
             new MySqlParameter("@CreateTime",model.CreateTime),
             new MySqlParameter("@CreateId",model.CreateId),
             new MySqlParameter("@CreateBy",model.CreateBy),
             new MySqlParameter("@ModifyTime",model.ModifyTime),
             new MySqlParameter("@ModifyId",model.ModifyId),
             new MySqlParameter("@ModifyBy",model.ModifyBy),
             };
            object obj = DbHelperSQLServer.ExecuteScalar(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// </summary>
        /// 修改一条数据
        /// </summary>
        bool Update(basedata_nodesettingModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update  basedata_nodesetting set");
            strSql.Append(" NodeNo = @NodeNo , ");
            strSql.Append(" NodeDesc = @NodeDesc , ");
            strSql.Append(" PlcId = @PlcId , ");
            strSql.Append(" PlcId2 = @PlcId2 , ");
            strSql.Append(" PlcId3 = @PlcId3 , ");
            strSql.Append(" PlcId4 = @PlcId4 , ");
            strSql.Append(" PlcId5 = @PlcId5 , ");
            strSql.Append(" NodeType = @NodeType , ");
            strSql.Append(" LineAreaId = @LineAreaId , ");
            strSql.Append(" IsStaticNumber = @IsStaticNumber , ");
            strSql.Append(" IsClearCar = @IsClearCar , ");
            strSql.Append(" OrderIndex = @OrderIndex , ");
            strSql.Append(" IsDeleted = @IsDeleted , ");
            strSql.Append(" CreateTime = @CreateTime , ");
            strSql.Append(" CreateId = @CreateId , ");
            strSql.Append(" CreateBy = @CreateBy , ");
            strSql.Append(" ModifyTime = @ModifyTime , ");
            strSql.Append(" ModifyId = @ModifyId , ");
            strSql.Append(" ModifyBy = @ModifyBy");
            strSql.Append(" where  Id = @Id");
            MySqlParameter[] parameters = {
             new MySqlParameter("@Id", model.Id),
             new MySqlParameter("@NodeNo", model.NodeNo),
             new MySqlParameter("@NodeDesc", model.NodeDesc),
             new MySqlParameter("@PlcId", model.PlcId),
             new MySqlParameter("@PlcId2", model.PlcId2),
             new MySqlParameter("@PlcId3", model.PlcId3),
             new MySqlParameter("@PlcId4", model.PlcId4),
             new MySqlParameter("@PlcId5", model.PlcId5),
             new MySqlParameter("@NodeType", model.NodeType),
             new MySqlParameter("@LineAreaId", model.LineAreaId),
             new MySqlParameter("@IsStaticNumber", model.IsStaticNumber),
             new MySqlParameter("@IsClearCar", model.IsClearCar),
             new MySqlParameter("@OrderIndex", model.OrderIndex),
             new MySqlParameter("@IsDeleted", model.IsDeleted),
             new MySqlParameter("@CreateTime", model.CreateTime),
             new MySqlParameter("@CreateId", model.CreateId),
             new MySqlParameter("@CreateBy", model.CreateBy),
             new MySqlParameter("@ModifyTime", model.ModifyTime),
             new MySqlParameter("@ModifyId", model.ModifyId),
             new MySqlParameter("@ModifyBy", model.ModifyBy),
             };
            int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from role ");
            strSql.Append(" where id=@id");
            MySqlParameter[] parameters = {
             new MySqlParameter("@id", MySqlDbType.Int32)
          };
            parameters[0].Value = id;
            int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public basedata_nodesettingModel GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select");
            strSql.Append(" Id, NodeNo, NodeDesc, PlcId, PlcId2, PlcId3, PlcId4, PlcId5, NodeType, LineAreaId, IsStaticNumber, IsClearCar, OrderIndex, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
            strSql.Append("  from basedata_nodesetting");
            strSql.Append(" where id=@id");
            MySqlParameter[] parameters = {
               new MySqlParameter("@id", MySqlDbType.Int32)
          };
            parameters[0].Value = id;
            basedata_nodesettingModel model = new basedata_nodesettingModel();
            DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["Id"] != DBNull.Value)
                {
                    model.Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Id"]);
                }
                if (ds.Tables[0].Rows[0]["NodeNo"] != DBNull.Value)
                {
                    model.NodeNo = Convert.ToString(ds.Tables[0].Rows[0]["NodeNo"]);
                }
                if (ds.Tables[0].Rows[0]["NodeDesc"] != DBNull.Value)
                {
                    model.NodeDesc = Convert.ToString(ds.Tables[0].Rows[0]["NodeDesc"]);
                }
                if (ds.Tables[0].Rows[0]["PlcId"] != DBNull.Value)
                {
                    model.PlcId = Convert.ToInt32(ds.Tables[0].Rows[0]["PlcId"]);
                }
                if (ds.Tables[0].Rows[0]["PlcId2"] != DBNull.Value)
                {
                    model.PlcId2 = Convert.ToInt32(ds.Tables[0].Rows[0]["PlcId2"]);
                }
                if (ds.Tables[0].Rows[0]["PlcId3"] != DBNull.Value)
                {
                    model.PlcId3 = Convert.ToInt32(ds.Tables[0].Rows[0]["PlcId3"]);
                }
                if (ds.Tables[0].Rows[0]["PlcId4"] != DBNull.Value)
                {
                    model.PlcId4 = Convert.ToInt32(ds.Tables[0].Rows[0]["PlcId4"]);
                }
                if (ds.Tables[0].Rows[0]["PlcId5"] != DBNull.Value)
                {
                    model.PlcId5 = Convert.ToInt32(ds.Tables[0].Rows[0]["PlcId5"]);
                }
                if (ds.Tables[0].Rows[0]["NodeType"] != DBNull.Value)
                {
                    model.NodeType = Convert.ToInt32(ds.Tables[0].Rows[0]["NodeType"]);
                }
                if (ds.Tables[0].Rows[0]["LineAreaId"] != DBNull.Value)
                {
                    model.LineAreaId = Convert.ToInt32(ds.Tables[0].Rows[0]["LineAreaId"]);
                }
                if (ds.Tables[0].Rows[0]["IsStaticNumber"] != DBNull.Value)
                {
                    model.IsStaticNumber = Convert.ToInt32(ds.Tables[0].Rows[0]["IsStaticNumber"]);
                }
                if (ds.Tables[0].Rows[0]["IsClearCar"] != DBNull.Value)
                {
                    model.IsClearCar = Convert.ToInt32(ds.Tables[0].Rows[0]["IsClearCar"]);
                }
                if (ds.Tables[0].Rows[0]["OrderIndex"] != DBNull.Value)
                {
                    model.OrderIndex = Convert.ToInt32(ds.Tables[0].Rows[0]["OrderIndex"]);
                }
                if (ds.Tables[0].Rows[0]["IsDeleted"] != DBNull.Value)
                {
                    model.IsDeleted = ds.Tables[0].Rows[0]["IsDeleted"].ToString() == "False" ? false : true;
                }
                if (ds.Tables[0].Rows[0]["CreateTime"] != DBNull.Value)
                {
                    model.CreateTime = Convert.ToString(ds.Tables[0].Rows[0]["CreateTime"]);
                }
                if (ds.Tables[0].Rows[0]["CreateId"] != DBNull.Value)
                {
                    model.CreateId = Convert.ToInt32(ds.Tables[0].Rows[0]["CreateId"]);
                }
                if (ds.Tables[0].Rows[0]["CreateBy"] != DBNull.Value)
                {
                    model.CreateBy = Convert.ToString(ds.Tables[0].Rows[0]["CreateBy"]);
                }
                if (ds.Tables[0].Rows[0]["ModifyTime"] != DBNull.Value)
                {
                    model.ModifyTime = Convert.ToString(ds.Tables[0].Rows[0]["ModifyTime"]);
                }
                if (ds.Tables[0].Rows[0]["ModifyId"] != DBNull.Value)
                {
                    model.ModifyId = Convert.ToInt32(ds.Tables[0].Rows[0]["ModifyId"]);
                }
                if (ds.Tables[0].Rows[0]["ModifyBy"] != DBNull.Value)
                {
                    model.ModifyBy = Convert.ToString(ds.Tables[0].Rows[0]["ModifyBy"]);
                }
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 得到一个对象实体集合
        /// </summary>
        public List<basedata_nodesettingModel> GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select");
            strSql.Append(" Id, NodeNo, NodeDesc, PlcId, PlcId2, PlcId3, PlcId4, PlcId5, NodeType, LineAreaId, IsStaticNumber, IsClearCar, OrderIndex, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
            strSql.Append("  from basedata_nodesetting");
            if (!string.IsNullOrWhiteSpace(strWhere))
                strSql.Append(" where " + strWhere);
            List<basedata_nodesettingModel> Items = new List<basedata_nodesettingModel>();
            DataSet ds = DbHelperSQLServer.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    basedata_nodesettingModel model = new basedata_nodesettingModel();
                    if (row["Id"] != DBNull.Value)
                    {
                        model.Id = Convert.ToInt32(row["Id"]);
                    }
                    if (row["NodeNo"] != DBNull.Value)
                    {
                        model.NodeNo = Convert.ToString(row["NodeNo"]);
                    }
                    if (row["NodeDesc"] != DBNull.Value)
                    {
                        model.NodeDesc = Convert.ToString(row["NodeDesc"]);
                    }
                    if (row["PlcId"] != DBNull.Value)
                    {
                        model.PlcId = Convert.ToInt32(row["PlcId"]);
                    }
                    if (row["PlcId2"] != DBNull.Value)
                    {
                        model.PlcId2 = Convert.ToInt32(row["PlcId2"]);
                    }
                    if (row["PlcId3"] != DBNull.Value)
                    {
                        model.PlcId3 = Convert.ToInt32(row["PlcId3"]);
                    }
                    if (row["PlcId4"] != DBNull.Value)
                    {
                        model.PlcId4 = Convert.ToInt32(row["PlcId4"]);
                    }
                    if (row["PlcId5"] != DBNull.Value)
                    {
                        model.PlcId5 = Convert.ToInt32(row["PlcId5"]);
                    }
                    if (row["NodeType"] != DBNull.Value)
                    {
                        model.NodeType = Convert.ToInt32(row["NodeType"]);
                    }
                    if (row["LineAreaId"] != DBNull.Value)
                    {
                        model.LineAreaId = Convert.ToInt32(row["LineAreaId"]);
                    }
                    if (row["IsStaticNumber"] != DBNull.Value)
                    {
                        model.IsStaticNumber = Convert.ToInt32(row["IsStaticNumber"]);
                    }
                    if (row["IsClearCar"] != DBNull.Value)
                    {
                        model.IsClearCar = Convert.ToInt32(row["IsClearCar"]);
                    }
                    if (row["OrderIndex"] != DBNull.Value)
                    {
                        model.OrderIndex = Convert.ToInt32(row["OrderIndex"]);
                    }
                    if (row["IsDeleted"] != DBNull.Value)
                    {
                        model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
                    }
                    if (row["CreateTime"] != DBNull.Value)
                    {
                        model.CreateTime = Convert.ToString(row["CreateTime"]);
                    }
                    if (row["CreateId"] != DBNull.Value)
                    {
                        model.CreateId = Convert.ToInt32(row["CreateId"]);
                    }
                    if (row["CreateBy"] != DBNull.Value)
                    {
                        model.CreateBy = Convert.ToString(row["CreateBy"]);
                    }
                    if (row["ModifyTime"] != DBNull.Value)
                    {
                        model.ModifyTime = Convert.ToString(row["ModifyTime"]);
                    }
                    if (row["ModifyId"] != DBNull.Value)
                    {
                        model.ModifyId = Convert.ToInt32(row["ModifyId"]);
                    }
                    if (row["ModifyBy"] != DBNull.Value)
                    {
                        model.ModifyBy = Convert.ToString(row["ModifyBy"]);
                    }
                    Items.Add(model);
                }
            }
            return Items;
        }
        /// <summary>
        /// 得到一个对象实体集合
        /// </summary>
        public List<basedata_nodesettingModel> GetList(string strWhere, MySqlParameter[] parameters)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select");
            strSql.Append(" Id, NodeNo, NodeDesc, PlcId, PlcId2, PlcId3, PlcId4, PlcId5, NodeType, LineAreaId, IsStaticNumber, IsClearCar, OrderIndex, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s')  CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s')  ModifyTime, ModifyId, ModifyBy");
            strSql.Append("  from basedata_nodesetting");
            if (!string.IsNullOrWhiteSpace(strWhere))
                strSql.Append(" where " + strWhere);
            List<basedata_nodesettingModel> Items = new List<basedata_nodesettingModel>();
            DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    basedata_nodesettingModel model = new basedata_nodesettingModel();
                    if (row["Id"] != DBNull.Value)
                    {
                        model.Id = Convert.ToInt32(row["Id"]);
                    }
                    if (row["NodeNo"] != DBNull.Value)
                    {
                        model.NodeNo = Convert.ToString(row["NodeNo"]);
                    }
                    if (row["NodeDesc"] != DBNull.Value)
                    {
                        model.NodeDesc = Convert.ToString(row["NodeDesc"]);
                    }
                    if (row["PlcId"] != DBNull.Value)
                    {
                        model.PlcId = Convert.ToInt32(row["PlcId"]);
                    }
                    if (row["PlcId2"] != DBNull.Value)
                    {
                        model.PlcId2 = Convert.ToInt32(row["PlcId2"]);
                    }
                    if (row["PlcId3"] != DBNull.Value)
                    {
                        model.PlcId3 = Convert.ToInt32(row["PlcId3"]);
                    }
                    if (row["PlcId4"] != DBNull.Value)
                    {
                        model.PlcId4 = Convert.ToInt32(row["PlcId4"]);
                    }
                    if (row["PlcId5"] != DBNull.Value)
                    {
                        model.PlcId5 = Convert.ToInt32(row["PlcId5"]);
                    }
                    if (row["NodeType"] != DBNull.Value)
                    {
                        model.NodeType = Convert.ToInt32(row["NodeType"]);
                    }
                    if (row["LineAreaId"] != DBNull.Value)
                    {
                        model.LineAreaId = Convert.ToInt32(row["LineAreaId"]);
                    }
                    if (row["IsStaticNumber"] != DBNull.Value)
                    {
                        model.IsStaticNumber = Convert.ToInt32(row["IsStaticNumber"]);
                    }
                    if (row["IsClearCar"] != DBNull.Value)
                    {
                        model.IsClearCar = Convert.ToInt32(row["IsClearCar"]);
                    }
                    if (row["OrderIndex"] != DBNull.Value)
                    {
                        model.OrderIndex = Convert.ToInt32(row["OrderIndex"]);
                    }
                    if (row["IsDeleted"] != DBNull.Value)
                    {
                        model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
                    }
                    if (row["CreateTime"] != DBNull.Value)
                    {
                        model.CreateTime = Convert.ToString(row["CreateTime"]);
                    }
                    if (row["CreateId"] != DBNull.Value)
                    {
                        model.CreateId = Convert.ToInt32(row["CreateId"]);
                    }
                    if (row["CreateBy"] != DBNull.Value)
                    {
                        model.CreateBy = Convert.ToString(row["CreateBy"]);
                    }
                    if (row["ModifyTime"] != DBNull.Value)
                    {
                        model.ModifyTime = Convert.ToString(row["ModifyTime"]);
                    }
                    if (row["ModifyId"] != DBNull.Value)
                    {
                        model.ModifyId = Convert.ToInt32(row["ModifyId"]);
                    }
                    if (row["ModifyBy"] != DBNull.Value)
                    {
                        model.ModifyBy = Convert.ToString(row["ModifyBy"]);
                    }
                    Items.Add(model);
                }
            }
            return Items;
        }
    }
}