using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
namespace SysDataLibs.TableClass
{
    #region      FSOnlineComplaintsDelay
    public class FSOnlineComplaintsDelay_info : ITableInfo
    {
        #region      FSOnlineComplaintsDelay表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 100;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 申请人;
        /// </summary>
        public const string cApplyPeople = "ApplyPeople";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： text;
        /// 数据长度： 16;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 申请理由;
        /// </summary>
        public const string cApplyReason = "ApplyReason";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： text;
        /// 数据长度： 16;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 回复内容;
        /// </summary>
        public const string cBackContent = "BackContent";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 100;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 回复人;
        /// </summary>
        public const string cBackPeople = "BackPeople";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 需要延期天数;
        /// </summary>
        public const string cDelayCount = "DelayCount";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： datetime;
        /// 数据长度： 8;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 需要延期时间;
        /// </summary>
        public const string cDelayDate = "DelayDate";

        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 50;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 编号;
        /// </summary>
        public const string cDelayID = "DelayID";

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 50;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 主投诉编号;
        /// </summary>
        public const string cOnlineComplaintsID = "OnlineComplaintsID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： datetime;
        /// 数据长度： 8;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 更新时间;
        /// </summary>
        public const string cUpdateTime = "UpdateTime";

        #endregion
        public FSOnlineComplaintsDelay_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _ApplyPeople = UtilStr.StrFromObj(poRow[cApplyPeople]);
            _ApplyReason = UtilStr.StrFromObj(poRow[cApplyReason]);
            _BackContent = UtilStr.StrFromObj(poRow[cBackContent]);
            _BackPeople = UtilStr.StrFromObj(poRow[cBackPeople]);
            _DelayCount = UtilStr.StrFromObj(poRow[cDelayCount]);
            _DelayDate = UtilStr.StrFromObj(poRow[cDelayDate]);
            _DelayID = UtilStr.StrFromObj(poRow[cDelayID]);
            _IsAgree = UtilStr.StrFromObj(poRow[cIsAgree]);
            _OnlineComplaintsID = UtilStr.StrFromObj(poRow[cOnlineComplaintsID]);
            _UpdateTime = UtilStr.StrFromObj(poRow[cUpdateTime]);
        }

        public FSOnlineComplaintsDelay_info(string pcDelayID, DBConnSql poDBConn)
        {
            if (pcDelayID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.FSOnlineComplaintsDelay + " where DelayID='" + pcDelayID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _ApplyPeople = "";
        public string ApplyPeople
        {
            get { return _ApplyPeople; }
            set { _ApplyPeople = value; }
        }

        private string _ApplyReason = "";
        public string ApplyReason
        {
            get { return _ApplyReason; }
            set { _ApplyReason = value; }
        }

        private string _BackContent = "";
        public string BackContent
        {
            get { return _BackContent; }
            set { _BackContent = value; }
        }

        private string _BackPeople = "";
        public string BackPeople
        {
            get { return _BackPeople; }
            set { _BackPeople = value; }
        }

        private string _DelayCount = "";
        public string DelayCount
        {
            get { return _DelayCount; }
            set { _DelayCount = value; }
        }

        private string _DelayDate = "";
        public string DelayDate
        {
            get { return _DelayDate; }
            set { _DelayDate = value; }
        }

        private string _DelayID = "";
        public string DelayID
        {
            get { return _DelayID; }
            set { _DelayID = value; }
        }

        private string _IsAgree = "";
        public string IsAgree
        {
            get { return _IsAgree; }
            set { _IsAgree = value; }
        }

        private string _OnlineComplaintsID = "";
        public string OnlineComplaintsID
        {
            get { return _OnlineComplaintsID; }
            set { _OnlineComplaintsID = value; }
        }

        private string _UpdateTime = "";
        public string UpdateTime
        {
            get { return _UpdateTime; }
            set { _UpdateTime = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("FSOnlineComplaintsDelayRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cApplyPeople, ApplyPeople);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cApplyReason, ApplyReason);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cBackContent, BackContent);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cBackPeople, BackPeople);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cDelayCount, DelayCount);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cDelayDate, DelayDate);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cDelayID, DelayID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsAgree, IsAgree);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cOnlineComplaintsID, OnlineComplaintsID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUpdateTime, UpdateTime);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }

        public string InsertSql()
        {
            return " insert into " + Tn.FSOnlineComplaintsDelay + " " +
                        " (" + cDelayID + "," + cOnlineComplaintsID + "," + cApplyPeople + "," + cApplyReason + 
                        "," + cDelayCount + "," + cDelayDate + "," + cBackContent + "," + cBackPeople + "," + cIsAgree + "," + cUpdateTime + ") " +
                        " values ('" + _DelayID + "','" + _OnlineComplaintsID + "','" + _ApplyPeople + "','" + _ApplyReason + "'," + _DelayCount +
                        ",'" + _DelayDate + "','" + _BackContent + "','" + _BackPeople + "'," + _IsAgree + ",'" + _UpdateTime + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.FSOnlineComplaintsDelay + " " +
                         " set " + cIsAgree + "=" + _IsAgree + "," + cBackPeople + "='" + _BackPeople +
                         "', " + cBackContent + "='" + _BackContent + "', " + cUpdateTime + "='" + _UpdateTime + "' " +
                         " where  " + cDelayID + "='" + _DelayID + "'";
        }        

        public string DeleteSql()
        {
            return "Delete " + Tn.FSOnlineComplaintsDelay + " where " + cDelayID + "='" + _DelayID + "'";
        }      
        
    }

    #endregion

    #region

    public class FSOnlineComplaintsDelay_Qry : rsQuery
    {
        public String ApplyPeople
        {
            get { return GetString(FSOnlineComplaintsDelay_info.cApplyPeople); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cApplyPeople, value); } 
        }

        public String ApplyReason
        {
            get { return GetString(FSOnlineComplaintsDelay_info.cApplyReason); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cApplyReason, value); } 
        }

        public String BackContent
        {
            get { return GetString(FSOnlineComplaintsDelay_info.cBackContent); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cBackContent, value); } 
        }

        public String BackPeople
        {
            get { return GetString(FSOnlineComplaintsDelay_info.cBackPeople); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cBackPeople, value); } 
        }

        public Int64 DelayCount
        {
            get { return GetInt(FSOnlineComplaintsDelay_info.cDelayCount); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cDelayCount, value); } 
        }

        public DateTime DelayDate
        {
            get { return GetDateTime(FSOnlineComplaintsDelay_info.cDelayDate); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cDelayDate, value); } 
        }

        public String DelayID
        {
            get { return GetString(FSOnlineComplaintsDelay_info.cDelayID); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cDelayID, value); } 
        }

        public Int64 IsAgree
        {
            get { return GetInt(FSOnlineComplaintsDelay_info.cIsAgree); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cIsAgree, value); } 
        }

        public String OnlineComplaintsID
        {
            get { return GetString(FSOnlineComplaintsDelay_info.cOnlineComplaintsID); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cOnlineComplaintsID, value); } 
        }

        public DateTime UpdateTime
        {
            get { return GetDateTime(FSOnlineComplaintsDelay_info.cUpdateTime); }
            //    set { SetField(FSOnlineComplaintsDelay_info.cUpdateTime, value); } 
        }

    } 
    #endregion

}