Files
2026-08-21 17:03:02 +08:00

332 lines
15 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 GThinking.N_MISPRO.Data;
namespace GThinking.N_XLXSBJ
{
[TableMap(DB = "DBERP", DbTableName = "XLXSBJDQYFB", Umid = 100860071, IsWorkFlow = false, UseWhr = true,
QuerySelSql = " select XLXSBJDQYFB_XZQHID,XLXSBJDQYFB_YFJZQH,XLXSBJDQYFB_YFDJ,XLXSBJDQYFB_YSFL, "
+ " XLXSBJDQYFB_WHR,XLXSBJDQYFB_WHRID,XLXSBJDQYFB_WHSJ "
+ " from XLXSBJDQYFB where 1=1",
EntitySelSql = " select XLXSBJDQYFB_XZQHID,XLXSBJDQYFB_YFJZQH,XLXSBJDQYFB_YSFL, "
+ " XLXSBJDQYFB_WHR,XLXSBJDQYFB_WHRID,XLXSBJDQYFB_WHSJ "
+ " from XLXSBJDQYFB where XLXSBJDQYFB_XZQHID=:OLDXZQHID and XLXSBJDQYFB_YFJZQH=' '",
UpdateSql = " update XLXSBJDQYFB set XLXSBJDQYFB_XZQHID=:XLXSBJDQYFB_XZQHID,XLXSBJDQYFB_YFJZQH=' ', "
+ " XLXSBJDQYFB_WHR=:XLXSBJDQYFB_WHR,XLXSBJDQYFB_WHRID=:XLXSBJDQYFB_WHRID,XLXSBJDQYFB_WHSJ=:XLXSBJDQYFB_WHSJ "
+ " where XLXSBJDQYFB_XZQHID=:OLDXZQHID and XLXSBJDQYFB_YFJZQH=' ' ",
InsertSql = " insert into XLXSBJDQYFB(XLXSBJDQYFB_XZQHID,XLXSBJDQYFB_YFJZQH, "
+ " XLXSBJDQYFB_WHR,XLXSBJDQYFB_WHRID,XLXSBJDQYFB_WHSJ) " + "\r\n"
+ " values(:XLXSBJDQYFB_XZQHID,' ',"
+ " :XLXSBJDQYFB_WHR,:XLXSBJDQYFB_WHRID,:XLXSBJDQYFB_WHSJ)",
DeleteSql = " delete from XLXSBJDQYFB where XLXSBJDQYFB_XZQHID=:XLXSBJDQYFB_XZQHID and XLXSBJDQYFB_YFJZQH=' ' ")]
public class BJYF : EntityManager
{
private string _XLXSBJDQYFB_XZQHID;
[ColumnMap(DbField = "XLXSBJDQYFB_XZQHID", CtrlName = "txtXZQHID", Type = FieldType.HiddenField, DbTitle = "地区", DefaultValue = "",
IsAllowNull = false, IsKey = true, Length = 10)]
public string XLXSBJDQYFB_XZQHID
{
get { return _XLXSBJDQYFB_XZQHID; }
set { _XLXSBJDQYFB_XZQHID = value; }
}
private string _OLDXZQHID;
[ColumnMap(DbField = "OLDXZQHID", CtrlName = "txtOLDXZQHID", Type = FieldType.HiddenField, DbTitle = "原地区", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)]
public string OLDXZQHID
{
get { return _OLDXZQHID; }
set { _OLDXZQHID = value; }
}
// 私有变量维护人
private string _XLXSBJDQYFB_WHR;
[ColumnMap(DbField = "XLXSBJDQYFB_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 30)]
public string XLXSBJDQYFB_WHR
{
get { return _XLXSBJDQYFB_WHR; }
set { _XLXSBJDQYFB_WHR = value; }
}
// 私有变量维护人工号
private string _XLXSBJDQYFB_WHRID;
[ColumnMap(DbField = "XLXSBJDQYFB_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人ID", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSBJDQYFB_WHRID
{
get { return _XLXSBJDQYFB_WHRID; }
set { _XLXSBJDQYFB_WHRID = value; }
}
// 私有变量维护时间
private string _XLXSBJDQYFB_WHSJ;
[ColumnMap(DbField = "XLXSBJDQYFB_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
IsAllowNull = false, IsKey = true, Length = 18)]
public string XLXSBJDQYFB_WHSJ
{
get { return _XLXSBJDQYFB_WHSJ; }
set { _XLXSBJDQYFB_WHSJ = value; }
}
}
[EntityType(Db = "DBERP", Table = "XLXSBJYFJZQJ", IsWf = false, IsWhr = false, WhrPrefix = "", IsAttach = false)]
public class BJYF_YJYZ : EntityObject
{
public string sXZQHID = "";
public override TSQL SetQuerySql()
{
TSQL SQL = base.SetQuerySql();
SQL.Add("select XLXSBJYFJZQJ_YFJZQH,XLXSBJYFJZQJ_YFJZQJMC,isnull(XLXSBJDQYFB_YFDJ,0) as YFDJ,isnull(XLXSBJDQYFB_YSFL,0) as YL ");
SQL.Add(" from XLXSBJYFJZQJ");
SQL.Add(" left join (select XLXSBJDQYFB_YFJZQH,XLXSBJDQYFB_YFDJ,XLXSBJDQYFB_YSFL from XLXSBJDQYFB where XLXSBJDQYFB_XZQHID=:pXZQHID and XLXSBJDQYFB_YFJZQH<>' ') a");
SQL.Add(" on a.XLXSBJDQYFB_YFJZQH=XLXSBJYFJZQJ_YFJZQH");
SQL.Add(" where 1=1 ");
SQL.Add("order by XLXSBJYFJZQJ_YFJZQH");
SQL.ParamByName("pXZQHID").Value = sXZQHID;
return SQL;
}
}
[EntityType(Db = "DBERP", Table = "XLXSBJDQYFB4", IsWf = false, IsWhr = false, WhrPrefix = "", IsAttach = false)]
public class BJYF_YJYJ : EntityObject
{
public string sXZQHID = "";
public override TSQL SetQuerySql()
{
TSQL SQL = base.SetQuerySql();
SQL.Add("select XLXSBJYFJJQJ_YFJJQH,XLXSBJYFJJQJ_YFJJQJMC,isnull(XLXSBJDQYFB4_YSFL,0) as YSFL ");
SQL.Add(" from XLXSBJYFJJQJ");
SQL.Add(" left join (select XLXSBJDQYFB4_YFJJQH,XLXSBJDQYFB4_YSFL from XLXSBJDQYFB4 where XLXSBJDQYFB4_XZQHID=:pXZQHID and XLXSBJDQYFB4_YFJJQH<>' ') a");
SQL.Add(" on a.XLXSBJDQYFB4_YFJJQH=XLXSBJYFJJQJ_YFJJQH");
SQL.Add(" where 1=1 ");
SQL.Add("order by XLXSBJYFJJQJ_YFJJQH");
SQL.ParamByName("pXZQHID").Value = sXZQHID;
return SQL;
}
}
[TableMap(DB = "DBERP", DbTableName = "XLXSBJDQYFZB", Umid = 100860071, IsWorkFlow = false, UseWhr = true,
QuerySelSql = " select XLXSBJDQYFZB_XZQHID, XLXSBJDQYFZB_YFJSFS,XLXSBJDQYFZB_TCPBL,XLXSBJDQYFZB_LCPBL,XLXSBJDQYFZB_YSJL, "
+ " XLXSBJDQYFZB_WHR,XLXSBJDQYFZB_WHRID,XLXSBJDQYFZB_WHSJ,XLXSBJDQYFZB_DQYFXX "
+ " from XLXSBJDQYFZB where 1=1",
EntitySelSql = " select XLXSBJDQYFZB_XZQHID,XLXSBJDQYFZB_YFJSFS,XLXSBJDQYFZB_TCPBL,XLXSBJDQYFZB_LCPBL,XLXSBJDQYFZB_YSJL, "
+ " XLXSBJDQYFZB_WHR,XLXSBJDQYFZB_WHRID,XLXSBJDQYFZB_WHSJ,XLXSBJDQYFZB_DQYFXX "
+ " from XLXSBJDQYFZB where XLXSBJDQYFZB_XZQHID=:OLDXZQHID ",
UpdateSql = " update XLXSBJDQYFZB set XLXSBJDQYFZB_XZQHID=:XLXSBJDQYFZB_XZQHID,XLXSBJDQYFZB_YFJSFS=:XLXSBJDQYFZB_YFJSFS,"
+" XLXSBJDQYFZB_TCPBL = :XLXSBJDQYFZB_TCPBL,XLXSBJDQYFZB_LCPBL = :XLXSBJDQYFZB_LCPBL, "
+ " XLXSBJDQYFZB_WHR=:XLXSBJDQYFZB_WHR,XLXSBJDQYFZB_WHRID=:XLXSBJDQYFZB_WHRID,XLXSBJDQYFZB_WHSJ=:XLXSBJDQYFZB_WHSJ,XLXSBJDQYFZB_DQYFXX=:XLXSBJDQYFZB_DQYFXX "
+ " where XLXSBJDQYFZB_XZQHID=:OLDXZQHID ",
InsertSql = " insert into XLXSBJDQYFZB(XLXSBJDQYFZB_XZQHID,XLXSBJDQYFZB_YFJSFS,XLXSBJDQYFZB_TCPBL,XLXSBJDQYFZB_LCPBL, "
+ " XLXSBJDQYFZB_WHR,XLXSBJDQYFZB_WHRID,XLXSBJDQYFZB_WHSJ,XLXSBJDQYFZB_DQYFXX) " + "\r\n"
+ " values(:XLXSBJDQYFZB_XZQHID,:XLXSBJDQYFZB_YFJSFS,:XLXSBJDQYFZB_TCPBL,:XLXSBJDQYFZB_LCPBL,"
+ " :XLXSBJDQYFZB_WHR,:XLXSBJDQYFZB_WHRID,:XLXSBJDQYFZB_WHSJ,:XLXSBJDQYFZB_DQYFXX)",
DeleteSql = " delete from XLXSBJDQYFZB where XLXSBJDQYFZB_XZQHID=:XLXSBJDQYFZB_XZQHID and XLXSBJDQYFZB_YFJSFS = :XLXSBJDQYFZB_YFJSFS")]
public class BJYFZB : EntityManager
{
private string _XLXSBJDQYFZB_XZQHID;
[ColumnMap(DbField = "XLXSBJDQYFZB_XZQHID", CtrlName = "txtXZQHID", Type = FieldType.HiddenField, DbTitle = "地区", DefaultValue = "",
IsAllowNull = false, IsKey = true, Length = 10)]
public string XLXSBJDQYFZB_XZQHID
{
get { return _XLXSBJDQYFZB_XZQHID; }
set { _XLXSBJDQYFZB_XZQHID = value; }
}
private string _OLDXZQHID;
[ColumnMap(DbField = "OLDXZQHID", CtrlName = "txtOLDXZQHID", Type = FieldType.HiddenField, DbTitle = "原地区", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10, PrintVisible=false)]
public string OLDXZQHID
{
get { return _OLDXZQHID; }
set { _OLDXZQHID = value; }
}
private string _XLXSBJDQYFZB_YFJSFS;
[ColumnMap(DbField = "XLXSBJDQYFZB_YFJSFS", CtrlName = "cbxYFJSFS", Type = FieldType.CL, DbTitle = "运费计算方式", DefaultValue = "",
IsAllowNull = false, IsKey = false, Length = 1)]
public string XLXSBJDQYFZB_YFJSFS
{
get { return _XLXSBJDQYFZB_YFJSFS; }
set { _XLXSBJDQYFZB_YFJSFS = value; }
}
private string _XLXSBJDQYFZB_DQYFXX;
[ColumnMap(DbField = "XLXSBJDQYFZB_DQYFXX", CtrlName = "txtDQYFXX", Type = FieldType.F, DbTitle = "地区运费下限", DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSBJDQYFZB_DQYFXX
{
get { return _XLXSBJDQYFZB_DQYFXX; }
set { _XLXSBJDQYFZB_DQYFXX = value; }
}
//private string _XLXSBJDQYFZB_YSJL;
//[ColumnMap(DbField = "XLXSBJDQYFZB_YSJL", CtrlName = "txtYL", Type = FieldType.F, DbTitle = "运输距离", DefaultValue = "0",
// IsAllowNull = true, IsKey = false, Length = 0)]
//public string XLXSBJDQYFZB_YSJL
//{
// get { return _XLXSBJDQYFZB_YSJL; }
// set { _XLXSBJDQYFZB_YSJL = value; }
//}
private string _XLXSBJDQYFZB_TCPBL;
[ColumnMap(DbField = "XLXSBJDQYFZB_TCPBL", CtrlName = "txtTCPBL", Type = FieldType.F, DbTitle = "铜产品(%)", DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSBJDQYFZB_TCPBL
{
get { return _XLXSBJDQYFZB_TCPBL; }
set { _XLXSBJDQYFZB_TCPBL = value; }
}
private string _XLXSBJDQYFZB_LCPBL;
[ColumnMap(DbField = "XLXSBJDQYFZB_LCPBL", CtrlName = "txtLCPBL", Type = FieldType.F, DbTitle = "铝产品(%)", DefaultValue = "0",
IsAllowNull = true, IsKey = false, Length = 0)]
public string XLXSBJDQYFZB_LCPBL
{
get { return _XLXSBJDQYFZB_LCPBL; }
set { _XLXSBJDQYFZB_LCPBL = value; }
}
// 私有变量维护人
private string _XLXSBJDQYFZB_WHR;
[ColumnMap(DbField = "XLXSBJDQYFZB_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 30)]
public string XLXSBJDQYFZB_WHR
{
get { return _XLXSBJDQYFZB_WHR; }
set { _XLXSBJDQYFZB_WHR = value; }
}
// 私有变量维护人工号
private string _XLXSBJDQYFZB_WHRID;
[ColumnMap(DbField = "XLXSBJDQYFZB_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人ID", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSBJDQYFZB_WHRID
{
get { return _XLXSBJDQYFZB_WHRID; }
set { _XLXSBJDQYFZB_WHRID = value; }
}
// 私有变量维护时间
private string _XLXSBJDQYFZB_WHSJ;
[ColumnMap(DbField = "XLXSBJDQYFZB_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
IsAllowNull = false, IsKey = true, Length = 18)]
public string XLXSBJDQYFZB_WHSJ
{
get { return _XLXSBJDQYFZB_WHSJ; }
set { _XLXSBJDQYFZB_WHSJ = value; }
}
}
[TableMap(DB = "DBERP", DbTableName = "XLXSBJDQYFB4SY1", Umid = 100860071, IsWorkFlow = false, UseWhr = true,
QuerySelSql = " select XLXSBJDQYFB4SY1_CPMLID, XLXSBJDQYFB4SY1_BZ, "
+ " XLXSBJDQYFB4SY1_WHR,XLXSBJDQYFB4SY1_WHRID,XLXSBJDQYFB4SY1_WHSJ "
+ " from XLXSBJDQYFB4SY1 where 1=1",
EntitySelSql = " select XLXSBJDQYFB4SY1_CPMLID,XLXSBJDQYFB4SY1_CPMLID as OLDCPMLID, XLXSBJDQYFB4SY1_BZ, "
+ " XLXSBJDQYFB4SY1_WHR,XLXSBJDQYFB4SY1_WHRID,XLXSBJDQYFB4SY1_WHSJ "
+ " from XLXSBJDQYFB4SY1 where XLXSBJDQYFB4SY1_CPMLID=:OLDCPMLID ",
UpdateSql = " update XLXSBJDQYFB4SY1 set XLXSBJDQYFB4SY1_CPMLID=:XLXSBJDQYFB4SY1_CPMLID,XLXSBJDQYFB4SY1_BZ=:XLXSBJDQYFB4SY1_BZ, "
+ " XLXSBJDQYFB4SY1_WHR=:XLXSBJDQYFB4SY1_WHR,XLXSBJDQYFB4SY1_WHRID=:XLXSBJDQYFB4SY1_WHRID,XLXSBJDQYFB4SY1_WHSJ=:XLXSBJDQYFB4SY1_WHSJ "
+ " where XLXSBJDQYFB4SY1_CPMLID=:OLDCPMLID ",
InsertSql = " insert into XLXSBJDQYFB4SY1(XLXSBJDQYFB4SY1_CPMLID,XLXSBJDQYFB4SY1_BZ, "
+ " XLXSBJDQYFB4SY1_WHR,XLXSBJDQYFB4SY1_WHRID,XLXSBJDQYFB4SY1_WHSJ) " + "\r\n"
+ " values(:XLXSBJDQYFB4SY1_CPMLID,:XLXSBJDQYFB4SY1_BZ,"
+ " :XLXSBJDQYFB4SY1_WHR,:XLXSBJDQYFB4SY1_WHRID,:XLXSBJDQYFB4SY1_WHSJ)",
DeleteSql = " delete from XLXSBJDQYFB4SY1 where XLXSBJDQYFB4SY1_CPMLID=:XLXSBJDQYFB4SY1_CPMLID ")]
public class BJYFSYCPML : EntityManager
{
private string _XLXSBJDQYFB4SY1_CPMLID;
[ColumnMap(DbField = "XLXSBJDQYFB4SY1_CPMLID", CtrlName = "cbxCPMLID", Type = FieldType.CBX, DbTitle = "产品目录ID", DefaultValue = "",
IsAllowNull = false, IsKey = true, Length = 2)]
public string XLXSBJDQYFB4SY1_CPMLID
{
get { return _XLXSBJDQYFB4SY1_CPMLID; }
set { _XLXSBJDQYFB4SY1_CPMLID = value; }
}
private string _OLDCPMLID;
[ColumnMap(DbField = "OLDCPMLID", CtrlName = "txtOLD_CPMLID", Type = FieldType.HiddenField, DbTitle = "原产品目录ID", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 2, PrintVisible = false)]
public string OLDCPMLID
{
get { return _OLDCPMLID; }
set { _OLDCPMLID = value; }
}
private string _XLXSBJDQYFB4SY1_BZ;
[ColumnMap(DbField = "XLXSBJDQYFB4SY1_BZ", CtrlName = "txtBZ", Type = FieldType.C, DbTitle = "备注", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 250)]
public string XLXSBJDQYFB4SY1_BZ
{
get { return _XLXSBJDQYFB4SY1_BZ; }
set { _XLXSBJDQYFB4SY1_BZ = value; }
}
// 私有变量维护人
private string _XLXSBJDQYFB4SY1_WHR;
[ColumnMap(DbField = "XLXSBJDQYFB4SY1_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 30)]
public string XLXSBJDQYFB4SY1_WHR
{
get { return _XLXSBJDQYFB4SY1_WHR; }
set { _XLXSBJDQYFB4SY1_WHR = value; }
}
// 私有变量维护人工号
private string _XLXSBJDQYFB4SY1_WHRID;
[ColumnMap(DbField = "XLXSBJDQYFB4SY1_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人ID", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 10)]
public string XLXSBJDQYFB4SY1_WHRID
{
get { return _XLXSBJDQYFB4SY1_WHRID; }
set { _XLXSBJDQYFB4SY1_WHRID = value; }
}
// 私有变量维护时间
private string _XLXSBJDQYFB4SY1_WHSJ;
[ColumnMap(DbField = "XLXSBJDQYFB4SY1_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
IsAllowNull = true, IsKey = false, Length = 18)]
public string XLXSBJDQYFB4SY1_WHSJ
{
get { return _XLXSBJDQYFB4SY1_WHSJ; }
set { _XLXSBJDQYFB4SY1_WHSJ = value; }
}
}
}