992 lines
47 KiB
C#
992 lines
47 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Configuration;
|
|
using System.Web;
|
|
using System.Web.Security;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.WebControls.WebParts;
|
|
using System.Web.UI.HtmlControls;
|
|
using GThinking.N_MODEL.Page;
|
|
using System.Web.Script.Serialization;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_MISPRO.Utility;
|
|
|
|
namespace GThinking.N_XLXSBJ
|
|
{
|
|
[EntityType(Db = "DBERP", Table = "XLWBBJDML", IsWf = false, IsWhr = false, WhrPrefix = "XLWBBJDML", IsAttach = false)]
|
|
public class XLBJD_WBPICNR : EntityObject
|
|
{
|
|
#region 属性字段
|
|
|
|
private string _WBBJDID;
|
|
[ScriptIgnore]
|
|
public string WBBJDID
|
|
{
|
|
get { return _WBBJDID; }
|
|
set
|
|
{
|
|
_WBBJDID = value;
|
|
_MX.WBBJDID = value;
|
|
}
|
|
}
|
|
|
|
private string _BJDID;
|
|
[ScriptIgnore]
|
|
public string BJDID
|
|
{
|
|
get { return _BJDID; }
|
|
set
|
|
{
|
|
_BJDID = value;
|
|
_MX.BJDID = value;
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 控件
|
|
[DataMember(DbField = "XLWBBJDML_WBBJDID", DbTitle = "表号", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 10, IsNullable = false, DefValue = "", CtlName = "txtWBBJDID",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDML_WBBJDID
|
|
{
|
|
get { return GetField("XLWBBJDML_WBBJDID").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_WBBJDID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_BJDID", DbTitle = "报价单号", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 20, IsNullable = false, DefValue = "", CtlName = "txtBJDID",
|
|
CtlType = FieldType.HiddenField)]
|
|
public string XLWBBJDML_BJDID
|
|
{
|
|
get { return GetField("XLWBBJDML_BJDID").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_BJDID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_WBBJDMC", DbTitle = "表名", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 100, IsNullable = true, DefValue = "", CtlName = "txtWBBJDMC",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDML_WBBJDMC
|
|
{
|
|
get { return GetField("XLWBBJDML_WBBJDMC").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_WBBJDMC", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_DRSJ", DbTitle = "导入时间", IsKey = false, DbType = TGtdbType.DateTime,
|
|
Len = 0, IsNullable = true, DefValue = "", CtlName = "datDRSJ",
|
|
CtlType = FieldType.DT)]
|
|
public string XLWBBJDML_DRSJ
|
|
{
|
|
get { return GetField("XLWBBJDML_DRSJ").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_DRSJ", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_PICNAME", DbTitle = "图片", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = false, DefValue = "", CtlName = "txtPICNAME",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDML_PICNAME
|
|
{
|
|
get { return GetField("XLWBBJDML_PICNAME").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_PICNAME", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_LMHHS", DbTitle = "栏目行号始", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtLMHHS",
|
|
CtlType = FieldType.F)]
|
|
public string XLWBBJDML_LMHHS
|
|
{
|
|
get { return GetField("XLWBBJDML_LMHHS").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_LMHHS", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_LMHHZ", DbTitle = "栏目行号止", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtLMHHZ",
|
|
CtlType = FieldType.F)]
|
|
public string XLWBBJDML_LMHHZ
|
|
{
|
|
get { return GetField("XLWBBJDML_LMHHZ").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_LMHHZ", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_NRHHS", DbTitle = "内容行号始", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtNRHHS",
|
|
CtlType = FieldType.F)]
|
|
public string XLWBBJDML_NRHHS
|
|
{
|
|
get { return GetField("XLWBBJDML_NRHHS").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_NRHHS", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_NRHHZ", DbTitle = "内容行号止", IsKey = false, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = true, DefValue = "0", CtlName = "txtNRHHZ",
|
|
CtlType = FieldType.F)]
|
|
public string XLWBBJDML_NRHHZ
|
|
{
|
|
get { return GetField("XLWBBJDML_NRHHZ").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_NRHHZ", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_WHR", DbTitle = "维护人", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 30, IsNullable = true, DefValue = "", CtlName = "txtWHR",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDML_WHR
|
|
{
|
|
get { return GetField("XLWBBJDML_WHR").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_WHR", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_WHRID", DbTitle = "维护人工号", IsKey = false, DbType = TGtdbType.VarChar, PrintVisible = false,
|
|
Len = 10, IsNullable = true, DefValue = "", CtlName = "txtWHRID",
|
|
CtlType = FieldType.HiddenField)]
|
|
public string XLWBBJDML_WHRID
|
|
{
|
|
get { return GetField("XLWBBJDML_WHRID").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_WHRID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDML_WHSJ", DbTitle = "维护时间", IsKey = false, DbType = TGtdbType.DateTime,
|
|
Len = 8, IsNullable = true, DefValue = "", CtlName = "datWHSJ",
|
|
CtlType = FieldType.DT)]
|
|
public string XLWBBJDML_WHSJ
|
|
{
|
|
get { return GetField("XLWBBJDML_WHSJ").ToString().Trim(); }
|
|
set { SetField("XLWBBJDML_WHSJ", value); }
|
|
}
|
|
#endregion
|
|
|
|
#region 继承事件
|
|
|
|
public override TSQL SetDeleteSql()
|
|
{
|
|
TSQL SQL = base.SetDeleteSql();
|
|
SQL.Add("delete from XLWBBJDML where XLWBBJDML_WBBJDID=:XLWBBJDML_WBBJDID and XLWBBJDML_BJDID=:XLWBBJDML_BJDID");
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetInsertSql()
|
|
{
|
|
TSQL SQL = base.SetInsertSql();
|
|
SQL.Add("insert into XLWBBJDML( ");
|
|
SQL.Add("XLWBBJDML_BJDID,XLWBBJDML_WBBJDID,XLWBBJDML_WBBJDMC,XLWBBJDML_PICNAME,XLWBBJDML_LMHHS,XLWBBJDML_LMHHZ,XLWBBJDML_NRHHS,XLWBBJDML_NRHHZ,XLWBBJDML_DRSJ,XLWBBJDML_WHR,XLWBBJDML_WHRID,XLWBBJDML_WHSJ)");
|
|
SQL.Add(" values(");
|
|
SQL.Add(":XLWBBJDML_BJDID,:XLWBBJDML_WBBJDID,:XLWBBJDML_WBBJDMC,:XLWBBJDML_PICNAME,:XLWBBJDML_LMHHS,:XLWBBJDML_LMHHZ,:XLWBBJDML_NRHHS,:XLWBBJDML_NRHHZ,:XLWBBJDML_DRSJ,:XLWBBJDML_WHR,:XLWBBJDML_WHRID,:XLWBBJDML_WHSJ)");
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetUpdateSql()
|
|
{
|
|
TSQL SQL = base.SetUpdateSql();
|
|
SQL.Add("update XLWBBJDML set ");
|
|
SQL.Add(" XLWBBJDML_BJDID=:XLWBBJDML_BJDID,XLWBBJDML_WBBJDID=:XLWBBJDML_WBBJDID,");
|
|
SQL.Add(" XLWBBJDML_WBBJDMC=:XLWBBJDML_WBBJDMC,");
|
|
SQL.Add(" XLWBBJDML_PICNAME=:XLWBBJDML_PICNAME,");
|
|
SQL.Add(" XLWBBJDML_LMHHS=:XLWBBJDML_LMHHS,");
|
|
SQL.Add(" XLWBBJDML_LMHHZ=:XLWBBJDML_LMHHZ,");
|
|
SQL.Add(" XLWBBJDML_NRHHS=:XLWBBJDML_NRHHS,");
|
|
SQL.Add(" XLWBBJDML_NRHHZ=:XLWBBJDML_NRHHZ,");
|
|
SQL.Add(" XLWBBJDML_DRSJ=:XLWBBJDML_DRSJ,");
|
|
SQL.Add(" XLWBBJDML_WHR=:XLWBBJDML_WHR, ");
|
|
SQL.Add(" XLWBBJDML_WHRID=:XLWBBJDML_WHRID, ");
|
|
SQL.Add(" XLWBBJDML_WHSJ=:XLWBBJDML_WHSJ ");
|
|
SQL.Add(" where XLWBBJDML_BJDID=:XLWBBJDML_BJDID and XLWBBJDML_WBBJDID=:XLWBBJDML_WBBJDID");
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetQuerySql()
|
|
{
|
|
TSQL SQL = base.SetQuerySql();
|
|
SQL.Add(" select XLWBBJDML_BJDID,XLWBBJDML_WBBJDID,XLWBBJDML_WBBJDMC,XLWBBJDML_PICNAME,XLWBBJDML_LMHHS,XLWBBJDML_LMHHZ,XLWBBJDML_NRHHS,XLWBBJDML_NRHHZ, ");
|
|
SQL.Add(" XLWBBJDML_DRSJ,XLWBBJDML_WHR,XLWBBJDML_WHRID,XLWBBJDML_WHSJ ");
|
|
SQL.Add(" from XLWBBJDML ");
|
|
SQL.Add(" where 1 = 1 ");
|
|
//增加where条件以及参数的赋值
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetQuerySqlByKey()
|
|
{
|
|
TSQL SQL = base.SetQuerySqlByKey();
|
|
SQL.Add(" select XLWBBJDML_BJDID,XLWBBJDML_WBBJDID,XLWBBJDML_WBBJDMC,XLWBBJDML_PICNAME,XLWBBJDML_LMHHS,XLWBBJDML_LMHHZ,XLWBBJDML_NRHHS,XLWBBJDML_NRHHZ, ");
|
|
SQL.Add(" XLWBBJDML_DRSJ,XLWBBJDML_WHR,XLWBBJDML_WHRID,XLWBBJDML_WHSJ ");
|
|
SQL.Add(" from XLWBBJDML ");
|
|
SQL.Add(" where XLWBBJDML_BJDID=:XLWBBJDML_BJDID and XLWBBJDML_WBBJDID=:XLWBBJDML_WBBJDID");
|
|
SQL.AddParam("XLWBBJDML_BJDID", TGtdbType.VarChar, 20, _BJDID);
|
|
SQL.AddParam("XLWBBJDML_WBBJDID", TGtdbType.VarChar, 10, _WBBJDID);
|
|
return SQL;
|
|
}
|
|
|
|
public override bool Deleted(TSQL sql)
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
sql.Clear();
|
|
sql.Add("delete from XLWBBJDNR where XLWBBJDNR_BJDID=:XLWBBJDNR_BJDID and XLWBBJDNR_WBBJDID=:XLWBBJDNR_WBBJDID");
|
|
sql.ParamByName("XLWBBJDNR_BJDID").Value = GetField("XLWBBJDML_BJDID").ToString().Trim();
|
|
sql.ParamByName("XLWBBJDNR_WBBJDID").Value = GetField("XLWBBJDML_WBBJDID").ToString().Trim();
|
|
dberp.ExecSQL(sql);
|
|
sql.Clear();
|
|
sql.Add("delete from XLWBBJDLM where XLWBBJDLM_BJDID=:XLWBBJDLM_BJDID and XLWBBJDLM_WBBJDID=:XLWBBJDLM_WBBJDID");
|
|
sql.ParamByName("XLWBBJDLM_BJDID").Value = GetField("XLWBBJDML_BJDID").ToString().Trim();
|
|
sql.ParamByName("XLWBBJDLM_WBBJDID").Value = GetField("XLWBBJDML_WBBJDID").ToString().Trim();
|
|
dberp.ExecSQL(sql);
|
|
sql.Clear();
|
|
sql.Add("delete from XLWBBJDMX where XLWBBJDMX_BJDID=:XLWBBJDMX_BJDID and XLWBBJDMX_WBBJDID=:XLWBBJDMX_WBBJDID");
|
|
sql.ParamByName("XLWBBJDMX_BJDID").Value = GetField("XLWBBJDML_BJDID").ToString().Trim();
|
|
sql.ParamByName("XLWBBJDMX_WBBJDID").Value = GetField("XLWBBJDML_WBBJDID").ToString().Trim();
|
|
dberp.ExecSQL(sql);
|
|
return base.Deleted(sql);
|
|
}
|
|
|
|
public override bool Deleting(TSQL sql)
|
|
{
|
|
_MX.BJDID = GetField("XLWBBJDML_BJDID").ToString().Trim();
|
|
_MX.WBBJDID = GetField("XLWBBJDML_WBBJDID").ToString().Trim();
|
|
return base.Deleting(sql);
|
|
}
|
|
|
|
public override bool CanEdit()
|
|
{
|
|
if (CMISproDataBase.ExistsRecord("DBERP", string.Format("select top 1 XLWBBJDMX_DRHH from XLWBBJDMX where XLWBBJDMX_BJDID='{0}' and XLWBBJDMX_WBBJDID='{1}'",
|
|
GetField("XLWBBJDML_BJDID").ToString().Trim(), GetField("XLWBBJDML_WBBJDID").ToString().Trim())))
|
|
return false;
|
|
else
|
|
return base.CanEdit();
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 子实体
|
|
|
|
private MX _MX = new MX();
|
|
|
|
[Association(Name = "XLWBBJDNR", DeleteOnNull = false, Storage = "_MX", OtherKey = "XLWBBJDML_WBBJDID", ThisKey = "XLWBBJDNR_DRHH")]
|
|
public MX XLWBBJDNR
|
|
{
|
|
get { return _MX; }
|
|
set { _MX = value; }
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
[EntityType(Db = "DBERP", Table = "XLWBBJDNR", IsWf = false, IsWhr = false, WhrPrefix = "XLWBBJDNR", IsAttach = false)]
|
|
public class MX : EntityObject
|
|
{
|
|
#region 属性变量
|
|
|
|
private string _WBBJDID;
|
|
[ScriptIgnore]
|
|
public string WBBJDID
|
|
{
|
|
get { return _WBBJDID; }
|
|
set
|
|
{
|
|
_WBBJDID = value;
|
|
}
|
|
}
|
|
|
|
private string _BJDID;
|
|
[ScriptIgnore]
|
|
public string BJDID
|
|
{
|
|
get { return _BJDID; }
|
|
set
|
|
{
|
|
_BJDID = value;
|
|
}
|
|
}
|
|
|
|
private string _DRHH;
|
|
[ScriptIgnore]
|
|
public string DRHH
|
|
{
|
|
get { return _DRHH; }
|
|
set { _DRHH = value; }
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 字段属性
|
|
[DataMember(DbField = "XLWBBJDNR_BJDID", DbTitle = "报价单号", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 20, IsNullable = false, DefValue = "", CtlName = "txtXLWBBJDNR_BJDID",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_BJDID
|
|
{
|
|
get { return GetField("XLWBBJDNR_BJDID").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_BJDID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_WBBJDID", DbTitle = "表号", IsKey = true, DbType = TGtdbType.VarChar,
|
|
Len = 10, IsNullable = false, DefValue = "", CtlName = "txtXLWBBJDNR_WBBJDID",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_WBBJDID
|
|
{
|
|
get { return GetField("XLWBBJDNR_WBBJDID").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_WBBJDID", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_DRHH", DbTitle = "导入行号", IsKey = true, DbType = TGtdbType.Float,
|
|
Len = 0, IsNullable = false, DefValue = "0", CtlName = "txtXLWBBJDNR_DRHH",
|
|
CtlType = FieldType.F)]
|
|
public string XLWBBJDNR_DRHH
|
|
{
|
|
get { return GetField("XLWBBJDNR_DRHH").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_DRHH", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR01", DbTitle = "栏目01", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR01",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR01
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR01").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR01", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR02", DbTitle = "栏目02", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR02",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR02
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR02").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR02", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR03", DbTitle = "栏目03", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR03",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR03
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR03").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR03", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR04", DbTitle = "栏目04", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR04",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR04
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR04").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR04", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR05", DbTitle = "栏目05", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR05",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR05
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR05").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR05", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR06", DbTitle = "栏目06", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR06",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR06
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR06").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR06", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR07", DbTitle = "栏目07", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR07",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR07
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR07").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR07", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR08", DbTitle = "栏目08", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR08",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR08
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR08").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR08", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR09", DbTitle = "栏目09", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR09",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR09
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR09").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR09", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR10", DbTitle = "栏目10", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR10",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR10
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR10").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR10", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR11", DbTitle = "栏目11", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR11",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR11
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR11").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR11", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR12", DbTitle = "栏目12", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR12",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR12
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR12").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR12", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR13", DbTitle = "栏目13", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR13",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR13
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR13").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR13", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR14", DbTitle = "栏目14", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR14",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR14
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR14").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR14", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR15", DbTitle = "栏目15", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR15",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR15
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR15").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR15", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR16", DbTitle = "栏目16", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR16",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR16
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR16").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR16", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR17", DbTitle = "栏目17", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR17",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR17
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR17").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR17", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR18", DbTitle = "栏目18", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR18",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR18
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR18").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR18", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR19", DbTitle = "栏目19", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR19",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR19
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR19").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR19", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR20", DbTitle = "栏目20", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR20",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR20
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR20").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR20", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR21", DbTitle = "栏目21", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR21",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR21
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR21").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR21", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR22", DbTitle = "栏目22", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR22",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR22
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR22").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR22", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR23", DbTitle = "栏目23", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR23",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR23
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR23").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR23", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR24", DbTitle = "栏目24", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 250, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR24",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR24
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR24").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR24", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR25", DbTitle = "栏目25", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR25",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR25
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR25").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR25", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR26", DbTitle = "栏目26", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR26",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR26
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR26").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR26", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR27", DbTitle = "栏目27", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR27",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR27
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR27").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR27", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR28", DbTitle = "栏目28", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR28",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR28
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR28").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR28", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR29", DbTitle = "栏目29", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR29",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR29
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR29").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR29", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR30", DbTitle = "栏目30", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR30",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR30
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR30").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR30", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR31", DbTitle = "栏目31", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR31",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR31
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR31").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR31", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR32", DbTitle = "栏目32", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR32",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR32
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR32").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR32", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR33", DbTitle = "栏目33", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR33",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR33
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR33").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR33", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR34", DbTitle = "栏目34", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR34",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR34
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR34").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR34", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR35", DbTitle = "栏目35", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR35",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR35
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR35").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR35", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR36", DbTitle = "栏目36", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR36",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR36
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR36").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR36", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR37", DbTitle = "栏目37", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR37",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR37
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR37").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR37", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR38", DbTitle = "栏目38", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR38",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR38
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR38").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR38", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR39", DbTitle = "栏目39", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR39",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR39
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR39").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR39", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR40", DbTitle = "栏目40", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR40",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR40
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR40").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR40", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR41", DbTitle = "栏目41", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR41",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR41
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR41").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR41", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR42", DbTitle = "栏目42", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR42",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR42
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR42").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR42", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR43", DbTitle = "栏目43", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR43",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR43
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR43").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR43", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR44", DbTitle = "栏目44", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR44",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR44
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR44").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR44", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR45", DbTitle = "栏目45", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR45",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR45
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR45").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR45", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR46", DbTitle = "栏目46", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR46",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR46
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR46").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR46", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR47", DbTitle = "栏目47", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR47",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR47
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR47").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR47", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR48", DbTitle = "栏目48", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR48",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR48
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR48").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR48", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR49", DbTitle = "栏目49", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR49",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR49
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR49").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR49", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR50", DbTitle = "栏目50", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR50",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR50
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR50").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR50", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR51", DbTitle = "栏目51", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR51",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR51
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR51").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR51", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR52", DbTitle = "栏目52", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR52",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR52
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR52").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR52", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR53", DbTitle = "栏目53", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR53",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR53
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR53").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR53", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR54", DbTitle = "栏目54", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR54",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR54
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR54").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR54", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR55", DbTitle = "栏目55", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR55",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR55
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR55").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR55", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR56", DbTitle = "栏目56", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR56",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR56
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR56").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR56", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR57", DbTitle = "栏目57", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR57",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR57
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR57").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR57", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR58", DbTitle = "栏目58", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR58",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR58
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR58").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR58", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR59", DbTitle = "栏目59", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR59",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR59
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR59").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR59", value); }
|
|
}
|
|
|
|
[DataMember(DbField = "XLWBBJDNR_LMNR60", DbTitle = "栏目60", IsKey = false, DbType = TGtdbType.VarChar,
|
|
Len = 60, IsNullable = true, DefValue = "", CtlName = "txtXLWBBJDNR_LMNR60",
|
|
CtlType = FieldType.C)]
|
|
public string XLWBBJDNR_LMNR60
|
|
{
|
|
get { return GetField("XLWBBJDNR_LMNR60").ToString().Trim(); }
|
|
set { SetField("XLWBBJDNR_LMNR60", value); }
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region 重载新建，更新，删除,查询sql语句。
|
|
|
|
public override TSQL SetQuerySqlByKey()
|
|
{
|
|
TSQL SQL = base.SetQuerySqlByKey();
|
|
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetQuerySql()
|
|
{
|
|
TSQL SQL = base.SetQuerySql();
|
|
SQL.Add(" select XLWBBJDNR_BJDID,XLWBBJDNR_WBBJDID,XLWBBJDNR_DRHH,");
|
|
SQL.Add(" XLWBBJDNR_LMNR01,XLWBBJDNR_LMNR02,XLWBBJDNR_LMNR03,XLWBBJDNR_LMNR04,XLWBBJDNR_LMNR05,XLWBBJDNR_LMNR06,XLWBBJDNR_LMNR07,XLWBBJDNR_LMNR08,XLWBBJDNR_LMNR09,XLWBBJDNR_LMNR10,");
|
|
SQL.Add(" XLWBBJDNR_LMNR11,XLWBBJDNR_LMNR12,XLWBBJDNR_LMNR13,XLWBBJDNR_LMNR14,XLWBBJDNR_LMNR15,XLWBBJDNR_LMNR16,XLWBBJDNR_LMNR17,XLWBBJDNR_LMNR18,XLWBBJDNR_LMNR19,XLWBBJDNR_LMNR20,");
|
|
SQL.Add(" XLWBBJDNR_LMNR21,XLWBBJDNR_LMNR22,XLWBBJDNR_LMNR23,XLWBBJDNR_LMNR24,XLWBBJDNR_LMNR25,XLWBBJDNR_LMNR26,XLWBBJDNR_LMNR27,XLWBBJDNR_LMNR28,XLWBBJDNR_LMNR29,XLWBBJDNR_LMNR30,");
|
|
SQL.Add(" XLWBBJDNR_LMNR31,XLWBBJDNR_LMNR32,XLWBBJDNR_LMNR33,XLWBBJDNR_LMNR34,XLWBBJDNR_LMNR35,XLWBBJDNR_LMNR36,XLWBBJDNR_LMNR37,XLWBBJDNR_LMNR38,XLWBBJDNR_LMNR39,XLWBBJDNR_LMNR40,");
|
|
SQL.Add(" XLWBBJDNR_LMNR41,XLWBBJDNR_LMNR42,XLWBBJDNR_LMNR43,XLWBBJDNR_LMNR44,XLWBBJDNR_LMNR45,XLWBBJDNR_LMNR46,XLWBBJDNR_LMNR47,XLWBBJDNR_LMNR48,XLWBBJDNR_LMNR49,XLWBBJDNR_LMNR50,");
|
|
SQL.Add(" XLWBBJDNR_LMNR51,XLWBBJDNR_LMNR52,XLWBBJDNR_LMNR53,XLWBBJDNR_LMNR54,XLWBBJDNR_LMNR55,XLWBBJDNR_LMNR56,XLWBBJDNR_LMNR57,XLWBBJDNR_LMNR58,XLWBBJDNR_LMNR59,XLWBBJDNR_LMNR60 ");
|
|
SQL.Add(" from XLWBBJDNR");
|
|
SQL.Add(" where XLWBBJDNR_BJDID=:XLWBBJDNR_BJDID and XLWBBJDNR_WBBJDID=:XLWBBJDNR_WBBJDID ");
|
|
SQL.Add(" order by XLWBBJDNR_DRHH ");
|
|
SQL.AddParam("XLWBBJDNR_BJDID", TGtdbType.VarChar, 20, _BJDID);
|
|
SQL.AddParam("XLWBBJDNR_WBBJDID", TGtdbType.VarChar, 10, _WBBJDID);
|
|
//增加where条件以及参数的赋值
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetInsertSql()
|
|
{
|
|
TSQL SQL = base.SetInsertSql();
|
|
SQL.Add("insert into XLWBBJDNR(XLWBBJDNR_BJDID,XLWBBJDNR_WBBJDID,XLWBBJDNR_DRHH,");
|
|
SQL.Add(" XLWBBJDNR_LMNR01,XLWBBJDNR_LMNR02,XLWBBJDNR_LMNR03,XLWBBJDNR_LMNR04,XLWBBJDNR_LMNR05,XLWBBJDNR_LMNR06,XLWBBJDNR_LMNR07,XLWBBJDNR_LMNR08,XLWBBJDNR_LMNR09,XLWBBJDNR_LMNR10,");
|
|
SQL.Add(" XLWBBJDNR_LMNR11,XLWBBJDNR_LMNR12,XLWBBJDNR_LMNR13,XLWBBJDNR_LMNR14,XLWBBJDNR_LMNR15,XLWBBJDNR_LMNR16,XLWBBJDNR_LMNR17,XLWBBJDNR_LMNR18,XLWBBJDNR_LMNR19,XLWBBJDNR_LMNR20,");
|
|
SQL.Add(" XLWBBJDNR_LMNR21,XLWBBJDNR_LMNR22,XLWBBJDNR_LMNR23,XLWBBJDNR_LMNR24,XLWBBJDNR_LMNR25,XLWBBJDNR_LMNR26,XLWBBJDNR_LMNR27,XLWBBJDNR_LMNR28,XLWBBJDNR_LMNR29,XLWBBJDNR_LMNR30,");
|
|
SQL.Add(" XLWBBJDNR_LMNR31,XLWBBJDNR_LMNR32,XLWBBJDNR_LMNR33,XLWBBJDNR_LMNR34,XLWBBJDNR_LMNR35,XLWBBJDNR_LMNR36,XLWBBJDNR_LMNR37,XLWBBJDNR_LMNR38,XLWBBJDNR_LMNR39,XLWBBJDNR_LMNR40,");
|
|
SQL.Add(" XLWBBJDNR_LMNR41,XLWBBJDNR_LMNR42,XLWBBJDNR_LMNR43,XLWBBJDNR_LMNR44,XLWBBJDNR_LMNR45,XLWBBJDNR_LMNR46,XLWBBJDNR_LMNR47,XLWBBJDNR_LMNR48,XLWBBJDNR_LMNR49,XLWBBJDNR_LMNR50,");
|
|
SQL.Add(" XLWBBJDNR_LMNR51,XLWBBJDNR_LMNR52,XLWBBJDNR_LMNR53,XLWBBJDNR_LMNR54,XLWBBJDNR_LMNR55,XLWBBJDNR_LMNR56,XLWBBJDNR_LMNR57,XLWBBJDNR_LMNR58,XLWBBJDNR_LMNR59,XLWBBJDNR_LMNR60) ");
|
|
SQL.Add(" values(:XLWBBJDNR_BJDID,:XLWBBJDNR_WBBJDID,:XLWBBJDNR_DRHH,");
|
|
SQL.Add(" :XLWBBJDNR_LMNR01,:XLWBBJDNR_LMNR02,:XLWBBJDNR_LMNR03,:XLWBBJDNR_LMNR04,:XLWBBJDNR_LMNR05,:XLWBBJDNR_LMNR06,:XLWBBJDNR_LMNR07,:XLWBBJDNR_LMNR08,:XLWBBJDNR_LMNR09,:XLWBBJDNR_LMNR10,");
|
|
SQL.Add(" :XLWBBJDNR_LMNR11,:XLWBBJDNR_LMNR12,:XLWBBJDNR_LMNR13,:XLWBBJDNR_LMNR14,:XLWBBJDNR_LMNR15,:XLWBBJDNR_LMNR16,:XLWBBJDNR_LMNR17,:XLWBBJDNR_LMNR18,:XLWBBJDNR_LMNR19,:XLWBBJDNR_LMNR20,");
|
|
SQL.Add(" :XLWBBJDNR_LMNR21,:XLWBBJDNR_LMNR22,:XLWBBJDNR_LMNR23,:XLWBBJDNR_LMNR24,:XLWBBJDNR_LMNR25,:XLWBBJDNR_LMNR26,:XLWBBJDNR_LMNR27,:XLWBBJDNR_LMNR28,:XLWBBJDNR_LMNR29,:XLWBBJDNR_LMNR30,");
|
|
SQL.Add(" :XLWBBJDNR_LMNR31,:XLWBBJDNR_LMNR32,:XLWBBJDNR_LMNR33,:XLWBBJDNR_LMNR34,:XLWBBJDNR_LMNR35,:XLWBBJDNR_LMNR36,:XLWBBJDNR_LMNR37,:XLWBBJDNR_LMNR38,:XLWBBJDNR_LMNR39,:XLWBBJDNR_LMNR40,");
|
|
SQL.Add(" :XLWBBJDNR_LMNR41,:XLWBBJDNR_LMNR42,:XLWBBJDNR_LMNR43,:XLWBBJDNR_LMNR44,:XLWBBJDNR_LMNR45,:XLWBBJDNR_LMNR46,:XLWBBJDNR_LMNR47,:XLWBBJDNR_LMNR48,:XLWBBJDNR_LMNR49,:XLWBBJDNR_LMNR50,");
|
|
SQL.Add(" :XLWBBJDNR_LMNR51,:XLWBBJDNR_LMNR52,:XLWBBJDNR_LMNR53,:XLWBBJDNR_LMNR54,:XLWBBJDNR_LMNR55,:XLWBBJDNR_LMNR56,:XLWBBJDNR_LMNR57,:XLWBBJDNR_LMNR58,:XLWBBJDNR_LMNR59,:XLWBBJDNR_LMNR60) ");
|
|
return SQL;
|
|
}
|
|
|
|
public override bool Inserting(TSQL sql)
|
|
{
|
|
SetField("XLWBBJDNR_BJDID", _BJDID);
|
|
SetField("XLWBBJDNR_WBBJDID", _WBBJDID);
|
|
|
|
//if (GetField("U_TSJYMX_TSXH").ToString().Trim().Equals("") || GetField("U_TSJYMX_TSXH").ToString().Trim().Equals("0"))
|
|
//{
|
|
// WarningMsg = "图书序号为空，不允许保存！";
|
|
// return false;
|
|
//}
|
|
|
|
return base.Inserting(sql);
|
|
}
|
|
|
|
public override TSQL SetUpdateSql()
|
|
{
|
|
TSQL SQL = base.SetUpdateSql();
|
|
SQL.Add(" update XLWBBJDNR set ");
|
|
SQL.Add(" XLWBBJDNR_LMNR01=:XLWBBJDNR_LMNR01,XLWBBJDNR_LMNR02=:XLWBBJDNR_LMNR02,XLWBBJDNR_LMNR03=:XLWBBJDNR_LMNR03,XLWBBJDNR_LMNR04=:XLWBBJDNR_LMNR04,XLWBBJDNR_LMNR05=:XLWBBJDNR_LMNR05,XLWBBJDNR_LMNR06=:XLWBBJDNR_LMNR06,XLWBBJDNR_LMNR07=:XLWBBJDNR_LMNR07,XLWBBJDNR_LMNR08=:XLWBBJDNR_LMNR08,XLWBBJDNR_LMNR09=:XLWBBJDNR_LMNR09,XLWBBJDNR_LMNR10=:XLWBBJDNR_LMNR10,");
|
|
SQL.Add(" XLWBBJDNR_LMNR11=:XLWBBJDNR_LMNR11,XLWBBJDNR_LMNR12=:XLWBBJDNR_LMNR12,XLWBBJDNR_LMNR13=:XLWBBJDNR_LMNR13,XLWBBJDNR_LMNR14=:XLWBBJDNR_LMNR14,XLWBBJDNR_LMNR15=:XLWBBJDNR_LMNR15,XLWBBJDNR_LMNR16=:XLWBBJDNR_LMNR16,XLWBBJDNR_LMNR17=:XLWBBJDNR_LMNR17,XLWBBJDNR_LMNR18=:XLWBBJDNR_LMNR18,XLWBBJDNR_LMNR19=:XLWBBJDNR_LMNR19,XLWBBJDNR_LMNR20=:XLWBBJDNR_LMNR20,");
|
|
SQL.Add(" XLWBBJDNR_LMNR21=:XLWBBJDNR_LMNR21,XLWBBJDNR_LMNR22=:XLWBBJDNR_LMNR22,XLWBBJDNR_LMNR23=:XLWBBJDNR_LMNR23,XLWBBJDNR_LMNR24=:XLWBBJDNR_LMNR24,XLWBBJDNR_LMNR25=:XLWBBJDNR_LMNR25,XLWBBJDNR_LMNR26=:XLWBBJDNR_LMNR26,XLWBBJDNR_LMNR27=:XLWBBJDNR_LMNR27,XLWBBJDNR_LMNR28=:XLWBBJDNR_LMNR28,XLWBBJDNR_LMNR29=:XLWBBJDNR_LMNR29,XLWBBJDNR_LMNR30=:XLWBBJDNR_LMNR30,");
|
|
SQL.Add(" XLWBBJDNR_LMNR31=:XLWBBJDNR_LMNR31,XLWBBJDNR_LMNR32=:XLWBBJDNR_LMNR32,XLWBBJDNR_LMNR33=:XLWBBJDNR_LMNR33,XLWBBJDNR_LMNR34=:XLWBBJDNR_LMNR34,XLWBBJDNR_LMNR35=:XLWBBJDNR_LMNR35,XLWBBJDNR_LMNR36=:XLWBBJDNR_LMNR36,XLWBBJDNR_LMNR37=:XLWBBJDNR_LMNR37,XLWBBJDNR_LMNR38=:XLWBBJDNR_LMNR38,XLWBBJDNR_LMNR39=:XLWBBJDNR_LMNR39,XLWBBJDNR_LMNR40=:XLWBBJDNR_LMNR40,");
|
|
SQL.Add(" XLWBBJDNR_LMNR41=:XLWBBJDNR_LMNR41,XLWBBJDNR_LMNR42=:XLWBBJDNR_LMNR42,XLWBBJDNR_LMNR43=:XLWBBJDNR_LMNR43,XLWBBJDNR_LMNR44=:XLWBBJDNR_LMNR44,XLWBBJDNR_LMNR45=:XLWBBJDNR_LMNR45,XLWBBJDNR_LMNR46=:XLWBBJDNR_LMNR46,XLWBBJDNR_LMNR47=:XLWBBJDNR_LMNR47,XLWBBJDNR_LMNR48=:XLWBBJDNR_LMNR48,XLWBBJDNR_LMNR49=:XLWBBJDNR_LMNR49,XLWBBJDNR_LMNR50=:XLWBBJDNR_LMNR50,");
|
|
SQL.Add(" XLWBBJDNR_LMNR51=:XLWBBJDNR_LMNR51,XLWBBJDNR_LMNR52=:XLWBBJDNR_LMNR52,XLWBBJDNR_LMNR53=:XLWBBJDNR_LMNR53,XLWBBJDNR_LMNR54=:XLWBBJDNR_LMNR54,XLWBBJDNR_LMNR55=:XLWBBJDNR_LMNR55,XLWBBJDNR_LMNR56=:XLWBBJDNR_LMNR56,XLWBBJDNR_LMNR57=:XLWBBJDNR_LMNR57,XLWBBJDNR_LMNR58=:XLWBBJDNR_LMNR58,XLWBBJDNR_LMNR59=:XLWBBJDNR_LMNR59,XLWBBJDNR_LMNR60=:XLWBBJDNR_LMNR60 ");
|
|
SQL.Add(" where XLWBBJDNR_BJDID=:XLWBBJDNR_BJDID");
|
|
SQL.Add(" and XLWBBJDNR_WBBJDID=:XLWBBJDNR_WBBJDID");
|
|
SQL.Add(" and XLWBBJDNR_DRHH=:XLWBBJDNR_DRHH ");
|
|
SQL.AddParam("XLWBBJDNR_BJDID", TGtdbType.VarChar, 20, _BJDID);
|
|
SQL.AddParam("XLWBBJDNR_WBBJDID", TGtdbType.VarChar, 10, _WBBJDID);
|
|
return SQL;
|
|
}
|
|
|
|
public override TSQL SetDeleteSql()
|
|
{
|
|
TSQL SQL = base.SetDeleteSql();
|
|
SQL.Add("delete from XLWBBJDNR where XLWBBJDNR_BJDID=:XLWBBJDNR_BJDID and XLWBBJDNR_WBBJDID=:XLWBBJDNR_WBBJDID and XLWBBJDNR_DRHH=:XLWBBJDNR_DRHH");
|
|
SQL.AddParam("XLWBBJDNR_BJDID", TGtdbType.VarChar, 20, _BJDID);
|
|
SQL.AddParam("XLWBBJDNR_WBBJDID", TGtdbType.VarChar, 10, _WBBJDID);
|
|
return SQL;
|
|
}
|
|
|
|
public override bool Updating(TSQL sql)
|
|
{
|
|
SetField("XLWBBJDNR_BJDID", _BJDID);
|
|
SetField("XLWBBJDNR_WBBJDID", _WBBJDID);
|
|
|
|
//if (GetField("U_TSJYMX_TSXH").ToString().Trim().Equals("") || GetField("U_TSJYMX_TSXH").ToString().Trim().Equals("0"))
|
|
//{
|
|
// WarningMsg = "图书序号为空，不允许保存！";
|
|
// return false;
|
|
//}
|
|
|
|
return base.Updating(sql);
|
|
}
|
|
|
|
public override bool Deleted(TSQL sql)
|
|
{
|
|
|
|
|
|
return base.Deleted(sql);
|
|
}
|
|
|
|
#endregion
|
|
|
|
}
|
|
}
|