wangwei/N_XLXSBJ----MX
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
N_XLXSBJ----MX/XLBJD.cs
T
wangwei f065129b20 2026821
2026-08-21 17:03:02 +08:00

256 lines
13 KiB
C#
Raw Permalink Blame History

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;
namespace GThinking.N_XLXSBJ
{
[TableMap(DB = "DBERP", DbTableName = "XLXSBJD", Umid = 100860000, IsWorkFlow = true, IsAttach = true,
DOCGRPIDFieldName = "XLXSBJD_DOCGRPID", DOCFJSFieldName = "XLXSBJD_FJS",
QuerySelSql = "",
DefaultFilter = " ",
EntitySelSql = "select XLXSBJD_BJDID, XLXSBJD_SYDWID, XLXSBJD_BJRQ, XLXSBJD_XSJLMC,\r\n"
+ " XLXSBJD_TXY, XLXSBJD_KH, XLXSBJD_XMMC, XLXSBJD_XXDZ, XLXSBJD_BZ,XLXSBJD_ZJE,XLXSBJD_LRL, XLXSBJD_FJS, XLXSBJD_DOCGRPID, XLXSBJD_WHR, XLXSBJD_WHRID, XLXSBJD_WHSJ, XLXSBJD_WFID, XLXSBJD_WFINST, XLXSBJD_WPID, XLXSBJD_WFAWAITER, XLXSBJD_WFHANDLER, XLXSBJD_ACTNAME \r\n"
+ " from XLXSBJD where XLXSBJD_WFID=:XLXSBJD_WFID and XLXSBJD_WFINST=:XLXSBJD_WFINST",
UpdateSql = "update XLXSBJD set \r\n"
+ " XLXSBJD_BJDID=:XLXSBJD_BJDID,\r\n"
+ "XLXSBJD_SYDWID=:XLXSBJD_SYDWID,\r\n"
+ "XLXSBJD_BJRQ=:XLXSBJD_BJRQ,\r\n"
+ "XLXSBJD_XSJLMC=:XLXSBJD_XSJLMC,\r\n"
+ "XLXSBJD_TXY=:XLXSBJD_TXY,\r\n"
+ "XLXSBJD_KH=:XLXSBJD_KH,\r\n"
+ "XLXSBJD_XMMC=:XLXSBJD_XMMC,\r\n"
+ "XLXSBJD_XXDZ=:XLXSBJD_XXDZ,\r\n"
+ "XLXSBJD_BZ=:XLXSBJD_BZ,\r\n"
+ "XLXSBJD_ZJE=:XLXSBJD_ZJE,\r\n"
+ "XLXSBJD_LRL=:XLXSBJD_LRL,\r\n"
+ "XLXSBJD_FJS=:XLXSBJD_FJS,\r\n"
+ "XLXSBJD_DOCGRPID=:XLXSBJD_DOCGRPID,\r\n"
+ "XLXSBJD_WHR=:XLXSBJD_WHR,\r\n"
+ "XLXSBJD_WHRID=:XLXSBJD_WHRID,\r\n"
+ "XLXSBJD_WHSJ=:XLXSBJD_WHSJ\r\n"
+ " where XLXSBJD_BJDID=:XLXSBJD_BJDID ",
InsertSql = "insert into XLXSBJD( XLXSBJD_BJDID, XLXSBJD_SYDWID, XLXSBJD_BJRQ, XLXSBJD_XSJLMC,\r\n"
+ " XLXSBJD_TXY, XLXSBJD_KH, XLXSBJD_XMMC, XLXSBJD_XXDZ, XLXSBJD_BZ,XLXSBJD_ZJE,XLXSBJD_LRL, XLXSBJD_FJS, XLXSBJD_DOCGRPID, XLXSBJD_WHR, XLXSBJD_WHRID, XLXSBJD_WHSJ)"
+ " values(:XLXSBJD_BJDID, :XLXSBJD_SYDWID, :XLXSBJD_BJRQ, :XLXSBJD_XSJLMC,\r\n"
+ " :XLXSBJD_TXY, :XLXSBJD_KH, :XLXSBJD_XMMC, :XLXSBJD_XXDZ, :XLXSBJD_BZ,:XLXSBJD_ZJE,:XLXSBJD_LRL, :XLXSBJD_FJS, :XLXSBJD_DOCGRPID, :XLXSBJD_WHR, :XLXSBJD_WHRID, :XLXSBJD_WHSJ)",
DeleteSql = "delete from XLXSBJD where XLXSBJD_BJDID=:XLXSBJD_BJDID ")]
public class XLBJD : EntityManager
{
}
[TableMap(DB = "DBERP", DbTableName = "XLXSBJDMX", Umid = 100860000, IsWorkFlow = false,
QuerySelSql = "select XLXSBJDMX_BJDID,XLXSBJDMX_XH, XLXSBJDMX_XLXHID, XLXSBJDMX_XLGGID, XLXSBJDMX_XLBZID,XLXSBJDMX_XLYSID,XLXSBJDMX_BJCP,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL,XLXSBJDMX_JGBBJ,"
+ " XLXSBJDMX_CPBJ,XLXSBJDMX_BJJE,XLXSBJDMX_CLCB,XLXSBJDMX_JGBBJJCL,XLXSBJDMX_JGBBJJCE,XLXSBJDMX_BZ ,XLXSBJDMX_WHRID, XLXSBJDMX_WHR ,XLXSBJDMX_WHSJ from XLXSBJDMX "
+ " where XLXSBJDMX_BJDID=:XLXSBJDMX_BJDID order by XLXSBJDMX_XH",
DefaultFilter = " ",
EntitySelSql = "select XLXSBJDMX_BJDID,XLXSBJDMX_XH, XLXSBJDMX_XLXHID, XLXSBJDMX_XLGGID, XLXSBJDMX_XLBZID,XLXSBJDMX_XLYSID,XLXSBJDMX_BJCP,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL,XLXSBJDMX_JGBBJ,"
+ " XLXSBJDMX_CPBJ,XLXSBJDMX_BJJE,XLXSBJDMX_CLCB,XLXSBJDMX_JGBBJJCL,XLXSBJDMX_JGBBJJCE,XLXSBJDMX_BZ ,XLXSBJDMX_WHRID, XLXSBJDMX_WHR ,XLXSBJDMX_WHSJ from XLXSBJDMX "
+ " where XLXSBJDMX_BJDID=:XLXSBJDMX_BJDID and XLXSBJDMX_XH=:XLXSBJDMX_XH",
UpdateSql = "update XLXSBJDMX set \r\n"
+ " XLXSBJDMX_BJDID =:XLXSBJDMX_BJDID,\r\n"
+ "XLXSBJDMX_XH =:XLXSBJDMX_XH,\r\n"
+ "XLXSBJDMX_XLXHID =:XLXSBJDMX_XLXHID,\r\n"
+ "XLXSBJDMX_XLGGID =:XLXSBJDMX_XLGGID,\r\n"
+ "XLXSBJDMX_XLBZID =:XLXSBJDMX_XLBZID,\r\n"
+ "XLXSBJDMX_XLYSID =:XLXSBJDMX_XLYSID,\r\n"
+ "XLXSBJDMX_BJCP =:XLXSBJDMX_BJCP,\r\n"
+ "XLXSBJDMX_JLDW =:XLXSBJDMX_JLDW,\r\n"
+ "XLXSBJDMX_BJSL =isnull(:XLXSBJDMX_BJSL,0),\r\n"
+ "XLXSBJDMX_JGBBJ =isnull(:XLXSBJDMX_JGBBJ,0),\r\n"
+ "XLXSBJDMX_CPBJ =isnull(:XLXSBJDMX_CPBJ,0),\r\n"
+ "XLXSBJDMX_BJJE =isnull(:XLXSBJDMX_BJJE,0),\r\n"
+ "XLXSBJDMX_CLCB =isnull(:XLXSBJDMX_CLCB,0),\r\n"
+ "XLXSBJDMX_JGBBJJCL =isnull(:XLXSBJDMX_JGBBJJCL,0),\r\n"
+ "XLXSBJDMX_JGBBJJCE =isnull(:XLXSBJDMX_JGBBJJCE,0),\r\n"
+ "XLXSBJDMX_BZ =:XLXSBJDMX_BZ,\r\n"
+ "XLXSBJDMX_WHRID =:XLXSBJDMX_WHRID,\r\n"
+ "XLXSBJDMX_WHR =:XLXSBJDMX_WHR,\r\n"
+ "XLXSBJDMX_WHSJ =:XLXSBJDMX_WHSJ \r\n"
+ " where XLXSBJDMX_BJDID=:XLXSBJDMX_BJDID and XLXSBJDMX_XH=:XLXSBJDMX_XH",
InsertSql = "insert into XLXSBJDMX("
+ " XLXSBJDMX_BJDID, XLXSBJDMX_XH, XLXSBJDMX_XLXHID, XLXSBJDMX_XLGGID, XLXSBJDMX_XLBZID,XLXSBJDMX_XLYSID,XLXSBJDMX_BJCP,XLXSBJDMX_JLDW,XLXSBJDMX_BJSL,XLXSBJDMX_JGBBJ,"
+ " XLXSBJDMX_CPBJ,XLXSBJDMX_BJJE,XLXSBJDMX_CLCB,XLXSBJDMX_JGBBJJCL,XLXSBJDMX_JGBBJJCE,XLXSBJDMX_BZ ,XLXSBJDMX_DZSC,XLXSBJDMX_WHRID, XLXSBJDMX_WHR ,XLXSBJDMX_WHSJ )"
+ " values(:XLXSBJDMX_BJDID, :XLXSBJDMX_XH, :XLXSBJDMX_XLXHID, :XLXSBJDMX_XLGGID, :XLXSBJDMX_XLBZID,:XLXSBJDMX_XLYSID,:XLXSBJDMX_BJCP,:XLXSBJDMX_JLDW,:XLXSBJDMX_BJSL,:XLXSBJDMX_JGBBJ,"
+ " :XLXSBJDMX_CPBJ,:XLXSBJDMX_BJJE,:XLXSBJDMX_CLCB,:XLXSBJDMX_JGBBJJCL,:XLXSBJDMX_JGBBJJCE,:XLXSBJDMX_BZ ,:XLXSBJDMX_DZSC,:XLXSBJDMX_WHRID, :XLXSBJDMX_WHR ,:XLXSBJDMX_WHSJ )",
DeleteSql = " delete from XLXSBJDMX where XLXSBJDMX_BJDID=:XLXSBJDMX_BJDID and XLXSBJDMX_XH=:XLXSBJDMX_XH")]
public class XLBJDMX : EntityManager
{
private string _XLXSBJDMX_XH;
[ColumnMap(DbField = "XLXSBJDMX_XH", CtrlName = "txtXLXSBJDMX_XH", DbTitle = "序号", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = false, IsKey = true, Length = 8)]
public string XLXSBJDMX_XH
{
get { return _XLXSBJDMX_XH; }
set { _XLXSBJDMX_XH = value; }
}
private string _XLXSBJDMX_XLXHID;
[ColumnMap(DbField = "XLXSBJDMX_XLXHID", CtrlName = "txtXLXSBJDMX_XLXHID", DbTitle = "型号", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 40)]
public string XLXSBJDMX_XLXHID
{
get { return _XLXSBJDMX_XLXHID; }
set { _XLXSBJDMX_XLXHID = value; }
}
private string _XLXSBJDMX_XLGGID;
[ColumnMap(DbField = "XLXSBJDMX_XLGGID", CtrlName = "txtXLXSBJDMX_XLGGID", DbTitle = "规格", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 60)]
public string XLXSBJDMX_XLGGID
{
get { return _XLXSBJDMX_XLGGID; }
set { _XLXSBJDMX_XLGGID = value; }
}
private string _XLXSBJDMX_XLBZID;
[ColumnMap(DbField = "XLXSBJDMX_XLBZID", CtrlName = "cbxXLXSBJDMX_XLBZID", DbTitle = "标准", Type = FieldType.CBX, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSBJDMX_XLBZID
{
get { return _XLXSBJDMX_XLBZID; }
set { _XLXSBJDMX_XLBZID = value; }
}
private string _XLXSBJDMX_XLYSID;
[ColumnMap(DbField = "XLXSBJDMX_XLYSID", CtrlName = "cbxXLXSBJDMX_XLYSID", DbTitle = "颜色", Type = FieldType.CBX, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSBJDMX_XLYSID
{
get { return _XLXSBJDMX_XLYSID; }
set { _XLXSBJDMX_XLYSID = value; }
}
private string _XLXSBJDMX_BJCP;
[ColumnMap(DbField = "XLXSBJDMX_BJCP", CtrlName = "txtXLXSBJDMX_BJCP", DbTitle = "报价产品", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 250)]
public string XLXSBJDMX_BJCP
{
get { return _XLXSBJDMX_BJCP; }
set { _XLXSBJDMX_BJCP = value; }
}
private string _XLXSBJDMX_JLDW;
[ColumnMap(DbField = "XLXSBJDMX_JLDW", CtrlName = "cbxXLXSBJDMX_JLDW", DbTitle = "计量单位", Type = FieldType.CBX, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_JLDW
{
get { return _XLXSBJDMX_JLDW; }
set { _XLXSBJDMX_JLDW = value; }
}
private string _XLXSBJDMX_BJSL;
[ColumnMap(DbField = "XLXSBJDMX_BJSL", CtrlName = "txtXLXSBJDMX_BJSL", DbTitle = "报价数量", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_BJSL
{
get { return _XLXSBJDMX_BJSL; }
set { _XLXSBJDMX_BJSL = value; }
}
//含税基准报价
private string _XLXSBJDMX_JGBBJ;
[ColumnMap(DbField = "XLXSBJDMX_JGBBJ", CtrlName = "txtXLXSBJDMX_JGBBJ", DbTitle = "价格表表价", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_JGBBJ
{
get { return _XLXSBJDMX_JGBBJ; }
set { _XLXSBJDMX_JGBBJ = value; }
}
//线缆产品报价
private string _XLXSBJDMX_CPBJ;
[ColumnMap(DbField = "XLXSBJDMX_CPBJ", CtrlName = "txtXLXSBJDMX_CPBJ", DbTitle = "报价", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_CPBJ
{
get { return _XLXSBJDMX_CPBJ; }
set { _XLXSBJDMX_CPBJ = value; }
}
private string _XLXSBJDMX_BJJE;
[ColumnMap(DbField = "XLXSBJDMX_BJJE", CtrlName = "txtXLXSBJDMX_BJJE", DbTitle = "报价金额", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_BJJE
{
get { return _XLXSBJDMX_BJJE; }
set { _XLXSBJDMX_BJJE = value; }
}
private string _XLXSBJDMX_CLCB;
[ColumnMap(DbField = "XLXSBJDMX_CLCB", CtrlName = "txtXLXSBJDMX_CLCB", DbTitle = "线缆材料成本", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_CLCB
{
get { return _XLXSBJDMX_CLCB; }
set { _XLXSBJDMX_CLCB = value; }
}
private string _XLXSBJDMX_JGBBJJCL;
[ColumnMap(DbField = "XLXSBJDMX_JGBBJJCL", CtrlName = "txtXLXSBJDMX_JGBBJJCL", DbTitle = "价格表表价价差率(%)", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_JGBBJJCL
{
get { return _XLXSBJDMX_JGBBJJCL; }
set { _XLXSBJDMX_JGBBJJCL = value; }
}
private string _XLXSBJDMX_JGBBJJCE;
[ColumnMap(DbField = "XLXSBJDMX_JGBBJJCE", CtrlName = "txtXLXSBJDMX_JGBBJJCE", DbTitle = "价格表表价价差额", Type = FieldType.F, DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_JGBBJJCE
{
get { return _XLXSBJDMX_JGBBJJCE; }
set { _XLXSBJDMX_JGBBJJCE = value; }
}
private string _XLXSBJDMX_BZ;
[ColumnMap(DbField = "XLXSBJDMX_BZ", CtrlName = "txtXLXSBJDMX_BZ", DbTitle = "备注", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 250)]
public string XLXSBJDMX_BZ
{
get { return _XLXSBJDMX_BZ; }
set { _XLXSBJDMX_BZ = value; }
}
private string _XLXSBJDMX_DZSC;
[ColumnMap(DbField = "XLXSBJDMX_DZSC", CtrlName = "txtXLXSBJDMX_DZSC", DbTitle = "定制生产", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 1)]
public string XLXSBJDMX_DZSC
{
get { return _XLXSBJDMX_DZSC; }
set { _XLXSBJDMX_DZSC = value; }
}
private string _XLXSBJDMX_WHR;
[ColumnMap(DbField = "XLXSBJDMX_WHR", CtrlName = "txtWHR", DbTitle = "维护人", Type = FieldType.C, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 30)]
public string XLXSBJDMX_WHR
{
get { return _XLXSBJDMX_WHR; }
set { _XLXSBJDMX_WHR = value; }
}
private string _XLXSBJDMX_WHRID;
[ColumnMap(DbField = "XLXSBJDMX_WHRID", CtrlName = "txtWHRID", DbTitle = "维护人工号", Type = FieldType.HiddenField, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSBJDMX_WHRID
{
get { return _XLXSBJDMX_WHRID; }
set { _XLXSBJDMX_WHRID = value; }
}
private string _XLXSBJDMX_WHSJ;
[ColumnMap(DbField = "XLXSBJDMX_WHSJ", CtrlName = "datWHSJ", DbTitle = "维护时间", Type = FieldType.DT, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 8)]
public string XLXSBJDMX_WHSJ
{
get { return _XLXSBJDMX_WHSJ; }
set { _XLXSBJDMX_WHSJ = value; }
}
private string _XLXSBJDMX_BJDID;
[ColumnMap(DbField = "XLXSBJDMX_BJDID", CtrlName = "txtBJDID", DbTitle = "报价单号", Type = FieldType.HiddenField, DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 20)]
public string XLXSBJDMX_BJDID
{
get { return _XLXSBJDMX_BJDID; }
set { _XLXSBJDMX_BJDID = value; }
}
}
}
Reference in New Issue View Git Blame Copy Permalink