using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
namespace SysDataLibs.TableClass
{
    #region      MarketEvalGrade
    public class MarketEvalGrade_info : ITableInfo
    {
        #region      MarketEvalGrade表 字段信息
        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： EvalGradeID;
        /// </summary>
        public const string cEvalGradeID = "EvalGradeID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： EvaluationID;
        /// </summary>
        public const string cEvaluationID = "EvaluationID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： EvaluationItemID;
        /// </summary>
        public const string cEvaluationItemID = "EvaluationItemID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'N');
        /// 描述： IsSelf;
        /// </summary>
        public const string cIsSelf = "IsSelf";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 15;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： MarketID;
        /// </summary>
        public const string cMarketID = "MarketID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： tinyint;
        /// 数据长度： 1;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： Month;
        /// </summary>
        public const string cMonth = "Month";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smallint;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： ((0));
        /// 描述： Score;
        /// </summary>
        public const string cScore = "Score";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smalldatetime;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： ScoreDate;
        /// </summary>
        public const string cScoreDate = "ScoreDate";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 30;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： ScoreUser;
        /// </summary>
        public const string cScoreUser = "ScoreUser";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smalldatetime;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： TimeCreated;
        /// </summary>
        public const string cTimeCreated = "TimeCreated";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 30;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： UserID;
        /// </summary>
        public const string cUserID = "UserID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： tinyint;
        /// 数据长度： 1;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： Year;
        /// </summary>
        public const string cYear = "Year";

        #endregion
        public MarketEvalGrade_info() { }

        public MarketEvalGrade_info(DataRow poRow)
        {
            CreateTableInfo(poRow);
        }

        public void CreateTableInfo(DataRow poRow)
        {
            _EvalGradeID = UtilStr.StrFromObj(poRow[cEvalGradeID]);
            _EvaluationID = UtilStr.StrFromObj(poRow[cEvaluationID]);
            _EvaluationItemID = UtilStr.StrFromObj(poRow[cEvaluationItemID]);
            _IsSelf = UtilStr.StrFromObj(poRow[cIsSelf]);
            _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
            _Month = UtilStr.StrFromObj(poRow[cMonth]);
            _Score = UtilStr.StrFromObj(poRow[cScore]);
            _ScoreDate = UtilStr.StrFromObj(poRow[cScoreDate]);
            _ScoreUser = UtilStr.StrFromObj(poRow[cScoreUser]);
            _TimeCreated = UtilStr.StrFromObj(poRow[cTimeCreated]);
            _UserID = UtilStr.StrFromObj(poRow[cUserID]);
            _Year = UtilStr.StrFromObj(poRow[cYear]);
        }

        public MarketEvalGrade_info(string pcEvalGradeID, DBConnSql poDBConn)
        {
            if (pcEvalGradeID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.MarketEvalGrade + " where EvalGradeID='" + pcEvalGradeID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _EvalGradeID = "";
        public string EvalGradeID
        {
            get { return _EvalGradeID; }
            set { _EvalGradeID = value; }
        }

        private string _EvaluationID = "";
        public string EvaluationID
        {
            get { return _EvaluationID; }
            set { _EvaluationID = value; }
        }

        private string _EvaluationItemID = "";
        public string EvaluationItemID
        {
            get { return _EvaluationItemID; }
            set { _EvaluationItemID = value; }
        }

        private string _IsSelf = "";
        public string IsSelf
        {
            get { return _IsSelf; }
            set { _IsSelf = value; }
        }

        private string _MarketID = "";
        public string MarketID
        {
            get { return _MarketID; }
            set { _MarketID = value; }
        }

        private string _Month = "";
        public string Month
        {
            get { return _Month; }
            set { _Month = value; }
        }

        private string _Score = "";
        public string Score
        {
            get { return _Score; }
            set { _Score = value; }
        }

        private string _ScoreDate = "";
        public string ScoreDate
        {
            get { return _ScoreDate; }
            set { _ScoreDate = value; }
        }

        private string _ScoreUser = "";
        public string ScoreUser
        {
            get { return _ScoreUser; }
            set { _ScoreUser = value; }
        }

        private string _TimeCreated = "";
        public string TimeCreated
        {
            get { return _TimeCreated; }
            set { _TimeCreated = value; }
        }

        private string _UserID = "";
        public string UserID
        {
            get { return _UserID; }
            set { _UserID = value; }
        }

        private string _Year = "";
        public string Year
        {
            get { return _Year; }
            set { _Year = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("MarketEvalGradeRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cEvalGradeID, EvalGradeID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cEvaluationID, EvaluationID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cEvaluationItemID, EvaluationItemID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsSelf, IsSelf);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketID, MarketID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMonth, Month);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cScore, Score);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cScoreDate, ScoreDate);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cScoreUser, ScoreUser);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTimeCreated, TimeCreated);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserID, UserID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cYear, Year);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.MarketEvalGrade + " " +
                        " (" + cEvaluationID + "," + cEvaluationItemID + "," + cIsSelf + "," + cMarketID + "," + cMonth + "," + cScore + "," + cScoreDate + "," + cScoreUser + "," + cTimeCreated + "," + cUserID + "," + cYear + ") " +
                        " values (" + _EvaluationID + "," + _EvaluationItemID + ",'" + _IsSelf + "','" + _MarketID + "','" + _Month + "','" + _Score + "','" + _ScoreDate + "','" + _ScoreUser + "','" + _TimeCreated + "','" + _UserID + "','" + _Year + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.MarketEvalGrade + " " +
                        " set " + cEvaluationID + "=" + _EvaluationID + "," + cEvaluationItemID + "=" + _EvaluationItemID + "," + cIsSelf + "='" + _IsSelf + "'," + cMarketID + "='" + _MarketID + "'," + cMonth + "='" + _Month + "'," + cScore + "='" + _Score + "'," + cScoreDate + "='" + _ScoreDate + "'," + cScoreUser + "='" + _ScoreUser + "'," + cTimeCreated + "='" + _TimeCreated + "'," + cUserID + "='" + _UserID + "'," + cYear + "='" + _Year + "' " +
                        " where  " + cEvalGradeID + "=" + _EvalGradeID + "";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.MarketEvalGrade + " where " + cEvalGradeID + "=" + _EvalGradeID + "";
        }

        public static bool Delete(string pcMarketID, string pcYear, string pcMonth,DBConnSql poDBConn)
        {
            string lcSql = " delete  " + Tn.MarketEvalGrade + " where  " + MarketEvalGrade_info.cMarketID + "='" + pcMarketID + "' and " + MarketEvalGrade_info.cYear + "='" + pcYear + "' and " + MarketEvalGrade_info.cMonth + "='" + pcMonth + "' ";
            if (!poDBConn.ExcuteSqlTran(lcSql))
            {
                return false;
            }
            return true;
        }

        public static string GetRankByScore(int score)
        {
            if (score >= 90)
                return "优秀";
            else if (score >= 80)
                return "良好";
            else if (score >= 70)
                return "一般";
            else if (score >= 60)
                return "合格";
            else
                return "不合格";
        } 
    }
    #endregion

    #region

    public class MarketEvalGrade_Qry : rsQuery
    {
        public Int64 EvalGradeID
        {
            get { return GetInt(MarketEvalGrade_info.cEvalGradeID); }
            //    set { SetField(MarketEvalGrade_info.cEvalGradeID, value); } 
        }

        public Int64 EvaluationID
        {
            get { return GetInt(MarketEvalGrade_info.cEvaluationID); }
            //    set { SetField(MarketEvalGrade_info.cEvaluationID, value); } 
        }

        public Int64 EvaluationItemID
        {
            get { return GetInt(MarketEvalGrade_info.cEvaluationItemID); }
            //    set { SetField(MarketEvalGrade_info.cEvaluationItemID, value); } 
        }

        public Boolean IsSelf
        {
            get { return GetBool(MarketEvalGrade_info.cIsSelf); }
            //    set { SetField(MarketEvalGrade_info.cIsSelf, value); } 
        }

        public String MarketID
        {
            get { return GetString(MarketEvalGrade_info.cMarketID); }
            //    set { SetField(MarketEvalGrade_info.cMarketID, value); } 
        }

        public Int64 Month
        {
            get { return GetInt(MarketEvalGrade_info.cMonth); }
            //    set { SetField(MarketEvalGrade_info.cMonth, value); } 
        }

        public Int64 Score
        {
            get { return GetInt(MarketEvalGrade_info.cScore); }
            //    set { SetField(MarketEvalGrade_info.cScore, value); } 
        }

        public DateTime ScoreDate
        {
            get { return GetDateTime(MarketEvalGrade_info.cScoreDate); }
            //    set { SetField(MarketEvalGrade_info.cScoreDate, value); } 
        }

        public String ScoreUser
        {
            get { return GetString(MarketEvalGrade_info.cScoreUser); }
            //    set { SetField(MarketEvalGrade_info.cScoreUser, value); } 
        }

        public DateTime TimeCreated
        {
            get { return GetDateTime(MarketEvalGrade_info.cTimeCreated); }
            //    set { SetField(MarketEvalGrade_info.cTimeCreated, value); } 
        }

        public String UserID
        {
            get { return GetString(MarketEvalGrade_info.cUserID); }
            //    set { SetField(MarketEvalGrade_info.cUserID, value); } 
        }

        public Int64 Year
        {
            get { return GetInt(MarketEvalGrade_info.cYear); }
            //    set { SetField(MarketEvalGrade_info.cYear, value); } 
        }

    }
    #endregion

}