123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859 |
- 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表 字段信息
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: datetime;
- /// 数据长度: 8;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 出生日期;
- /// </summary>
- public const string cBirthDate = "BirthDate";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 20;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 手机号码;
- /// </summary>
- public const string cCellPhone = "CellPhone";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: int;
- /// 数据长度: 4;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 学历类型;
- /// </summary>
- public const string cDegreeTypeID = "DegreeTypeID";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: datetime;
- /// 数据长度: 8;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 进单位时间;
- /// </summary>
- public const string cEnterCompanyDate = "EnterCompanyDate";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 10;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员1称谓;
- /// </summary>
- public const string cFamily1Appellation = "Family1Appellation";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 100;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员1单位;
- /// </summary>
- public const string cFamily1Company = "Family1Company";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 10;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员1名称;
- /// </summary>
- public const string cFamily1Name = "Family1Name";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 100;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员1户籍地;
- /// </summary>
- public const string cFamily1Residence = "Family1Residence";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 10;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员2称谓;
- /// </summary>
- public const string cFamily2Appellation = "Family2Appellation";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 100;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员2单位;
- /// </summary>
- public const string cFamily2Company = "Family2Company";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 10;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员2名称;
- /// </summary>
- public const string cFamily2Name = "Family2Name";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 100;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员2户籍地;
- /// </summary>
- public const string cFamily2Residence = "Family2Residence";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 10;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员3称谓;
- /// </summary>
- public const string cFamily3Appellation = "Family3Appellation";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 100;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员3单位;
- /// </summary>
- public const string cFamily3Company = "Family3Company";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 10;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员3名称;
- /// </summary>
- public const string cFamily3Name = "Family3Name";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 100;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭成员3户籍地;
- /// </summary>
- public const string cFamily3Residence = "Family3Residence";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: smallint;
- /// 数据长度: 2;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 性别;
- /// </summary>
- public const string cGender = "Gender";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 100;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 家庭住址;
- /// </summary>
- public const string cHomeAddress = "HomeAddress";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 20;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 身份证号;
- /// </summary>
- public const string cIdCard = "IdCard";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 20;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 分管工作;
- /// </summary>
- public const string cJob = "Job";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: char;
- /// 数据长度: 10;
- /// 是否允许为空: N;
- /// 默认值: ;
- /// 描述: 市场编号;
- /// </summary>
- public const string cMarketID = "MarketID";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 10;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 姓名;
- /// </summary>
- public const string cName = "Name";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 200;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 备注;
- /// </summary>
- public const string cNotes = "Notes";
- /// <summary>
- /// 为关键字段: Y --- PrimaryKey;
- /// 自动增长: Y;
- /// 数据类型: int;
- /// 数据长度: 4;
- /// 是否允许为空: N;
- /// 默认值: ;
- /// 描述: 编号;
- /// </summary>
- public const string cOperatorID = "OperatorID";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 20;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 政治面貌;
- /// </summary>
- public const string cPolitics = "Politics";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 2000;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 奖惩记录;
- /// </summary>
- public const string cResume = "Resume";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 30;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 电话;
- /// </summary>
- public const string cTel = "Tel";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 20;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 职务;
- /// </summary>
- public const string cTitle = "Title";
- /// <summary>
- /// 为关键字段: N ;
- /// 自动增长: N;
- /// 数据类型: varchar;
- /// 数据长度: 20;
- /// 是否允许为空: Y;
- /// 默认值: ;
- /// 描述: 用户名称;
- /// </summary>
- 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
- }
|