using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
namespace SysDataLibs.TableClass
{
    #region      FSOnlineComplaintsTransmit
    public class FSOnlineComplaintsTransmit_info : ITableInfo
    {
        #region      FSOnlineComplaintsTransmit表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 100;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 转交前部门;
        /// </summary>
        public const string cOldDept = "OldDept";

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 100;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 转交后部门;
        /// </summary>
        public const string cTransmitDept = "TransmitDept";

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

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

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

        #endregion
        public FSOnlineComplaintsTransmit_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _OldDept = UtilStr.StrFromObj(poRow[cOldDept]);
            _OnlineComplaintsID = UtilStr.StrFromObj(poRow[cOnlineComplaintsID]);
            _TransmitDept = UtilStr.StrFromObj(poRow[cTransmitDept]);
            _TransmitID = UtilStr.StrFromObj(poRow[cTransmitID]);
            _TransmitPeople = UtilStr.StrFromObj(poRow[cTransmitPeople]);
            _UpdateTime = UtilStr.StrFromObj(poRow[cUpdateTime]);
        }

        public FSOnlineComplaintsTransmit_info(string pcTransmitID, DBConnSql poDBConn)
        {
            if (pcTransmitID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.FSOnlineComplaintsTransmit + " where TransmitID='" + pcTransmitID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _OldDept = "";
        public string OldDept
        {
            get { return _OldDept; }
            set { _OldDept = value; }
        }

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

        private string _TransmitDept = "";
        public string TransmitDept
        {
            get { return _TransmitDept; }
            set { _TransmitDept = value; }
        }

        private string _TransmitID = "";
        public string TransmitID
        {
            get { return _TransmitID; }
            set { _TransmitID = value; }
        }

        private string _TransmitPeople = "";
        public string TransmitPeople
        {
            get { return _TransmitPeople; }
            set { _TransmitPeople = value; }
        }

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

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("FSOnlineComplaintsTransmitRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cOldDept, OldDept);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cOnlineComplaintsID, OnlineComplaintsID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTransmitDept, TransmitDept);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTransmitID, TransmitID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTransmitPeople, TransmitPeople);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUpdateTime, UpdateTime);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }

        public string InsertSql()
        {
            return " insert into " + Tn.FSOnlineComplaintsTransmit + " " +
                        " (" + cTransmitID + "," + cOnlineComplaintsID + "," + cTransmitPeople + "," + cTransmitDept + "," + cOldDept + "," + cUpdateTime + ") " +
                        " values ('" + _TransmitID + "','" + _OnlineComplaintsID + "','" + _TransmitPeople + "','" + _TransmitDept + "','" + _OldDept + "','" + _UpdateTime + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.FSOnlineComplaintsTransmit + " " +
                        " set " + cOnlineComplaintsID + "='" + _OnlineComplaintsID + "'," + cTransmitPeople + "='" + _TransmitPeople +
                        "', " + cTransmitDept + "='" + _TransmitDept + "', " + cOldDept + "='" + _OldDept +
                        " where  " + cTransmitID + "='" + _TransmitID + "'";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.FSOnlineComplaintsTransmit + " where " + cTransmitID + "='" + _TransmitID + "'";
        }
        
    }

    #endregion

    #region

    public class FSOnlineComplaintsTransmit_Qry : rsQuery
    {
        public String OldDept
        {
            get { return GetString(FSOnlineComplaintsTransmit_info.cOldDept); }
            //    set { SetField(FSOnlineComplaintsTransmit_info.cOldDept, value); } 
        }

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

        public String TransmitDept
        {
            get { return GetString(FSOnlineComplaintsTransmit_info.cTransmitDept); }
            //    set { SetField(FSOnlineComplaintsTransmit_info.cTransmitDept, value); } 
        }

        public String TransmitID
        {
            get { return GetString(FSOnlineComplaintsTransmit_info.cTransmitID); }
            //    set { SetField(FSOnlineComplaintsTransmit_info.cTransmitID, value); } 
        }

        public String TransmitPeople
        {
            get { return GetString(FSOnlineComplaintsTransmit_info.cTransmitPeople); }
            //    set { SetField(FSOnlineComplaintsTransmit_info.cTransmitPeople, value); } 
        }

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

}