using System; using System.Collections.Generic; using System.Text; using System.Data; using SysBaseLibs; using System.Web.Script.Serialization; namespace SysDataLibs.TableClass { #region MarketOperators public class MarketOperators_info : ITableInfo { #region MarketOperators表 字段信息 /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: datetime; /// 数据长度: 8; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 出生日期; /// public const string cBirthDate = "BirthDate"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 20; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 手机号码; /// public const string cCellPhone = "CellPhone"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: int; /// 数据长度: 4; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 学历类型; /// public const string cDegreeTypeID = "DegreeTypeID"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: datetime; /// 数据长度: 8; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 进单位时间; /// public const string cEnterCompanyDate = "EnterCompanyDate"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 10; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员1称谓; /// public const string cFamily1Appellation = "Family1Appellation"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 100; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员1单位; /// public const string cFamily1Company = "Family1Company"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 10; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员1名称; /// public const string cFamily1Name = "Family1Name"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 100; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员1户籍地; /// public const string cFamily1Residence = "Family1Residence"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 10; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员2称谓; /// public const string cFamily2Appellation = "Family2Appellation"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 100; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员2单位; /// public const string cFamily2Company = "Family2Company"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 10; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员2名称; /// public const string cFamily2Name = "Family2Name"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 100; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员2户籍地; /// public const string cFamily2Residence = "Family2Residence"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 10; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员3称谓; /// public const string cFamily3Appellation = "Family3Appellation"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 100; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员3单位; /// public const string cFamily3Company = "Family3Company"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 10; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员3名称; /// public const string cFamily3Name = "Family3Name"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 100; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭成员3户籍地; /// public const string cFamily3Residence = "Family3Residence"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: smallint; /// 数据长度: 2; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 性别; /// public const string cGender = "Gender"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 100; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 家庭住址; /// public const string cHomeAddress = "HomeAddress"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 20; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 身份证号; /// public const string cIdCard = "IdCard"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 20; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 分管工作; /// public const string cJob = "Job"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: char; /// 数据长度: 10; /// 是否允许为空: N; /// 默认值: ; /// 描述: 市场编号; /// public const string cMarketID = "MarketID"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 10; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 姓名; /// public const string cName = "Name"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 200; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 备注; /// public const string cNotes = "Notes"; /// /// 为关键字段: Y --- PrimaryKey; /// 自动增长: Y; /// 数据类型: int; /// 数据长度: 4; /// 是否允许为空: N; /// 默认值: ; /// 描述: 编号; /// public const string cOperatorID = "OperatorID"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 20; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 政治面貌; /// public const string cPolitics = "Politics"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 2000; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 奖惩记录; /// public const string cResume = "Resume"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 30; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 电话; /// public const string cTel = "Tel"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 20; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 职务; /// public const string cTitle = "Title"; /// /// 为关键字段: N ; /// 自动增长: N; /// 数据类型: varchar; /// 数据长度: 20; /// 是否允许为空: Y; /// 默认值: ; /// 描述: 用户名称; /// public const string cUserName = "UserName"; #endregion public MarketOperators_info(){} public MarketOperators_info(DataRow poRow) { CreateTableInfo(poRow); } public void CreateTableInfo(DataRow poRow) { _BirthDate=UtilStr.StrFromObj(poRow[cBirthDate]); _CellPhone=UtilStr.StrFromObj(poRow[cCellPhone]); _DegreeTypeID=UtilStr.StrFromObj(poRow[cDegreeTypeID]); _EnterCompanyDate=UtilStr.StrFromObj(poRow[cEnterCompanyDate]); _Family1Appellation=UtilStr.StrFromObj(poRow[cFamily1Appellation]); _Family1Company=UtilStr.StrFromObj(poRow[cFamily1Company]); _Family1Name=UtilStr.StrFromObj(poRow[cFamily1Name]); _Family1Residence=UtilStr.StrFromObj(poRow[cFamily1Residence]); _Family2Appellation=UtilStr.StrFromObj(poRow[cFamily2Appellation]); _Family2Company=UtilStr.StrFromObj(poRow[cFamily2Company]); _Family2Name=UtilStr.StrFromObj(poRow[cFamily2Name]); _Family2Residence=UtilStr.StrFromObj(poRow[cFamily2Residence]); _Family3Appellation=UtilStr.StrFromObj(poRow[cFamily3Appellation]); _Family3Company=UtilStr.StrFromObj(poRow[cFamily3Company]); _Family3Name=UtilStr.StrFromObj(poRow[cFamily3Name]); _Family3Residence=UtilStr.StrFromObj(poRow[cFamily3Residence]); _Gender=UtilStr.StrFromObj(poRow[cGender]); _HomeAddress=UtilStr.StrFromObj(poRow[cHomeAddress]); _IdCard=UtilStr.StrFromObj(poRow[cIdCard]); _Job=UtilStr.StrFromObj(poRow[cJob]); _MarketID=UtilStr.StrFromObj(poRow[cMarketID]); _Name=UtilStr.StrFromObj(poRow[cName]); _Notes=UtilStr.StrFromObj(poRow[cNotes]); _OperatorID=UtilStr.StrFromObj(poRow[cOperatorID]); _Politics=UtilStr.StrFromObj(poRow[cPolitics]); _Resume=UtilStr.StrFromObj(poRow[cResume]); _Tel=UtilStr.StrFromObj(poRow[cTel]); _Title=UtilStr.StrFromObj(poRow[cTitle]); _UserName=UtilStr.StrFromObj(poRow[cUserName]); } public MarketOperators_info( string pcOperatorID, DBConnSql poDBConn) { if ( pcOperatorID.Trim().Length > 0 && poDBConn != null) { string lcSql = "select * from " + Tn.MarketOperators + " where OperatorID='"+pcOperatorID+"'"; rsQuery loQuery = poDBConn.OpenQuery(lcSql); if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1) { loQuery.MoveFirst(); CreateTableInfo(loQuery.CurrentRow); } } } private string _BirthDate=""; public string BirthDate { get { return _BirthDate; } set { _BirthDate = value; } } private string _CellPhone=""; public string CellPhone { get { return _CellPhone; } set { _CellPhone = value; } } private string _DegreeTypeID=""; public string DegreeTypeID { get { return _DegreeTypeID; } set { _DegreeTypeID = value; } } private string _EnterCompanyDate=""; public string EnterCompanyDate { get { return _EnterCompanyDate; } set { _EnterCompanyDate = value; } } private string _Family1Appellation=""; public string Family1Appellation { get { return _Family1Appellation; } set { _Family1Appellation = value; } } private string _Family1Company=""; public string Family1Company { get { return _Family1Company; } set { _Family1Company = value; } } private string _Family1Name=""; public string Family1Name { get { return _Family1Name; } set { _Family1Name = value; } } private string _Family1Residence=""; public string Family1Residence { get { return _Family1Residence; } set { _Family1Residence = value; } } private string _Family2Appellation=""; public string Family2Appellation { get { return _Family2Appellation; } set { _Family2Appellation = value; } } private string _Family2Company=""; public string Family2Company { get { return _Family2Company; } set { _Family2Company = value; } } private string _Family2Name=""; public string Family2Name { get { return _Family2Name; } set { _Family2Name = value; } } private string _Family2Residence=""; public string Family2Residence { get { return _Family2Residence; } set { _Family2Residence = value; } } private string _Family3Appellation=""; public string Family3Appellation { get { return _Family3Appellation; } set { _Family3Appellation = value; } } private string _Family3Company=""; public string Family3Company { get { return _Family3Company; } set { _Family3Company = value; } } private string _Family3Name=""; public string Family3Name { get { return _Family3Name; } set { _Family3Name = value; } } private string _Family3Residence=""; public string Family3Residence { get { return _Family3Residence; } set { _Family3Residence = value; } } private string _Gender=""; public string Gender { get { return _Gender; } set { _Gender = value; } } private string _HomeAddress=""; public string HomeAddress { get { return _HomeAddress; } set { _HomeAddress = value; } } private string _IdCard=""; public string IdCard { get { return _IdCard; } set { _IdCard = value; } } private string _Job=""; public string Job { get { return _Job; } set { _Job = value; } } private string _MarketID=""; public string MarketID { get { return _MarketID; } set { _MarketID = value; } } private string _Name=""; public string Name { get { return _Name; } set { _Name = value; } } private string _Notes=""; public string Notes { get { return _Notes; } set { _Notes = value; } } private string _OperatorID=""; public string OperatorID { get { return _OperatorID; } set { _OperatorID = value; } } private string _Politics=""; public string Politics { get { return _Politics; } set { _Politics = value; } } private string _Resume=""; public string Resume { get { return _Resume; } set { _Resume = value; } } private string _Tel=""; public string Tel { get { return _Tel; } set { _Tel = value; } } private string _Title=""; public string Title { get { return _Title; } set { _Title = value; } } private string _UserName=""; public string UserName { get { return _UserName; } set { _UserName = value; } } [ScriptIgnore] public rsXmlNode DataXMLNode { get { rsXmlNode loMainNode = new rsXmlNode("MarketOperatorsRecord", ""); rsXmlNode loNode =null; loNode = new rsXmlNode(cBirthDate, BirthDate); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cCellPhone, CellPhone); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cDegreeTypeID, DegreeTypeID); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cEnterCompanyDate, EnterCompanyDate); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily1Appellation, Family1Appellation); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily1Company, Family1Company); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily1Name, Family1Name); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily1Residence, Family1Residence); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily2Appellation, Family2Appellation); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily2Company, Family2Company); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily2Name, Family2Name); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily2Residence, Family2Residence); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily3Appellation, Family3Appellation); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily3Company, Family3Company); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily3Name, Family3Name); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cFamily3Residence, Family3Residence); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cGender, Gender); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cHomeAddress, HomeAddress); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cIdCard, IdCard); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cJob, Job); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cMarketID, MarketID); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cName, Name); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cNotes, Notes); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cOperatorID, OperatorID); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cPolitics, Politics); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cResume, Resume); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cTel, Tel); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cTitle, Title); loMainNode.AddChild(loNode); loNode = new rsXmlNode(cUserName, UserName); loMainNode.AddChild(loNode); return loMainNode ; } } public string InsertSql() { return " insert into "+Tn.MarketOperators+" "+ " ("+cBirthDate+","+cCellPhone+","+cDegreeTypeID+","+cEnterCompanyDate+","+cFamily1Appellation+","+cFamily1Company+","+cFamily1Name+","+cFamily1Residence+","+cFamily2Appellation+","+cFamily2Company+","+cFamily2Name+","+cFamily2Residence+","+cFamily3Appellation+","+cFamily3Company+","+cFamily3Name+","+cFamily3Residence+","+cGender+","+cHomeAddress+","+cIdCard+","+cJob+","+cMarketID+","+cName+","+cNotes+","+cPolitics+","+cResume+","+cTel+","+cTitle+","+cUserName+") "+ " values ('"+_BirthDate+"','"+_CellPhone+"',"+_DegreeTypeID+",'"+_EnterCompanyDate+"','"+_Family1Appellation+"','"+_Family1Company+"','"+_Family1Name+"','"+_Family1Residence+"','"+_Family2Appellation+"','"+_Family2Company+"','"+_Family2Name+"','"+_Family2Residence+"','"+_Family3Appellation+"','"+_Family3Company+"','"+_Family3Name+"','"+_Family3Residence+"','"+_Gender+"','"+_HomeAddress+"','"+_IdCard+"','"+_Job+"','"+_MarketID+"','"+_Name+"','"+_Notes+"','"+_Politics+"','"+_Resume+"','"+_Tel+"','"+_Title+"','"+_UserName+"') " ; } public string UpdateSql() { return " update "+Tn.MarketOperators+" "+ " set "+cBirthDate+"='"+_BirthDate+"',"+cCellPhone+"='"+_CellPhone+"',"+cDegreeTypeID+"="+_DegreeTypeID+","+cEnterCompanyDate+"='"+_EnterCompanyDate+"',"+cFamily1Appellation+"='"+_Family1Appellation+"',"+cFamily1Company+"='"+_Family1Company+"',"+cFamily1Name+"='"+_Family1Name+"',"+cFamily1Residence+"='"+_Family1Residence+"',"+cFamily2Appellation+"='"+_Family2Appellation+"',"+cFamily2Company+"='"+_Family2Company+"',"+cFamily2Name+"='"+_Family2Name+"',"+cFamily2Residence+"='"+_Family2Residence+"',"+cFamily3Appellation+"='"+_Family3Appellation+"',"+cFamily3Company+"='"+_Family3Company+"',"+cFamily3Name+"='"+_Family3Name+"',"+cFamily3Residence+"='"+_Family3Residence+"',"+cGender+"='"+_Gender+"',"+cHomeAddress+"='"+_HomeAddress+"',"+cIdCard+"='"+_IdCard+"',"+cJob+"='"+_Job+"',"+cMarketID+"='"+_MarketID+"',"+cName+"='"+_Name+"',"+cNotes+"='"+_Notes+"',"+cPolitics+"='"+_Politics+"',"+cResume+"='"+_Resume+"',"+cTel+"='"+_Tel+"',"+cTitle+"='"+_Title+"',"+cUserName+"='"+_UserName+"' "+ " where "+cOperatorID+"="+_OperatorID+"" ; } public string DeleteSql() { return "Delete "+Tn.MarketOperators+" where "+cOperatorID+"="+_OperatorID+"" ; } } #endregion #region public class MarketOperators_Qry : rsQuery { public DateTime BirthDate { get { return GetDateTime(MarketOperators_info.cBirthDate); } // set { SetField(MarketOperators_info.cBirthDate, value); } } public String CellPhone { get { return GetString(MarketOperators_info.cCellPhone); } // set { SetField(MarketOperators_info.cCellPhone, value); } } public Int64 DegreeTypeID { get { return GetInt(MarketOperators_info.cDegreeTypeID); } // set { SetField(MarketOperators_info.cDegreeTypeID, value); } } public DateTime EnterCompanyDate { get { return GetDateTime(MarketOperators_info.cEnterCompanyDate); } // set { SetField(MarketOperators_info.cEnterCompanyDate, value); } } public String Family1Appellation { get { return GetString(MarketOperators_info.cFamily1Appellation); } // set { SetField(MarketOperators_info.cFamily1Appellation, value); } } public String Family1Company { get { return GetString(MarketOperators_info.cFamily1Company); } // set { SetField(MarketOperators_info.cFamily1Company, value); } } public String Family1Name { get { return GetString(MarketOperators_info.cFamily1Name); } // set { SetField(MarketOperators_info.cFamily1Name, value); } } public String Family1Residence { get { return GetString(MarketOperators_info.cFamily1Residence); } // set { SetField(MarketOperators_info.cFamily1Residence, value); } } public String Family2Appellation { get { return GetString(MarketOperators_info.cFamily2Appellation); } // set { SetField(MarketOperators_info.cFamily2Appellation, value); } } public String Family2Company { get { return GetString(MarketOperators_info.cFamily2Company); } // set { SetField(MarketOperators_info.cFamily2Company, value); } } public String Family2Name { get { return GetString(MarketOperators_info.cFamily2Name); } // set { SetField(MarketOperators_info.cFamily2Name, value); } } public String Family2Residence { get { return GetString(MarketOperators_info.cFamily2Residence); } // set { SetField(MarketOperators_info.cFamily2Residence, value); } } public String Family3Appellation { get { return GetString(MarketOperators_info.cFamily3Appellation); } // set { SetField(MarketOperators_info.cFamily3Appellation, value); } } public String Family3Company { get { return GetString(MarketOperators_info.cFamily3Company); } // set { SetField(MarketOperators_info.cFamily3Company, value); } } public String Family3Name { get { return GetString(MarketOperators_info.cFamily3Name); } // set { SetField(MarketOperators_info.cFamily3Name, value); } } public String Family3Residence { get { return GetString(MarketOperators_info.cFamily3Residence); } // set { SetField(MarketOperators_info.cFamily3Residence, value); } } public Int64 Gender { get { return GetInt(MarketOperators_info.cGender); } // set { SetField(MarketOperators_info.cGender, value); } } public String HomeAddress { get { return GetString(MarketOperators_info.cHomeAddress); } // set { SetField(MarketOperators_info.cHomeAddress, value); } } public String IdCard { get { return GetString(MarketOperators_info.cIdCard); } // set { SetField(MarketOperators_info.cIdCard, value); } } public String Job { get { return GetString(MarketOperators_info.cJob); } // set { SetField(MarketOperators_info.cJob, value); } } public String MarketID { get { return GetString(MarketOperators_info.cMarketID); } // set { SetField(MarketOperators_info.cMarketID, value); } } public String Name { get { return GetString(MarketOperators_info.cName); } // set { SetField(MarketOperators_info.cName, value); } } public String Notes { get { return GetString(MarketOperators_info.cNotes); } // set { SetField(MarketOperators_info.cNotes, value); } } public Int64 OperatorID { get { return GetInt(MarketOperators_info.cOperatorID); } // set { SetField(MarketOperators_info.cOperatorID, value); } } public String Politics { get { return GetString(MarketOperators_info.cPolitics); } // set { SetField(MarketOperators_info.cPolitics, value); } } public String Resume { get { return GetString(MarketOperators_info.cResume); } // set { SetField(MarketOperators_info.cResume, value); } } public String Tel { get { return GetString(MarketOperators_info.cTel); } // set { SetField(MarketOperators_info.cTel, value); } } public String Title { get { return GetString(MarketOperators_info.cTitle); } // set { SetField(MarketOperators_info.cTitle, value); } } public String UserName { get { return GetString(MarketOperators_info.cUserName); } // set { SetField(MarketOperators_info.cUserName, value); } } } #endregion }