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 = "XLXSBJDYZZI", Umid = 100860149, IsWorkFlow = false, IsAttach = false, UseWhr = false, QuerySelSql = " select XLXSBJDYZZI_JGBID, XLXSBJDYZZI_YZID,XLXSBJDYZZI_GYFLBM,XLXSBJDYZZI_DTLX,XLXSBJDYZZI_DYDJID,XLXSBJDYZZI_ZXJMSX,XLXSBJDYZZI_ZXJMXX, " + "\r\n" + " XLXSBJDYZZI_XHBHZF1,XLXSBJDYZZI_XHBHZF2,XLXSBJDYZZI_XHBBHZF, XLXSBJDYZZI_YZZ, XLXSBJDYZZI_WHR, XLXSBJDYZZI_WHRID, XLXSBJDYZZI_WHSJ " + "\r\n" + " from XLXSBJDYZZI " + "\r\n" + " where 1=1 ", EntitySelSql = " select XLXSBJDYZZI_JGBID, XLXSBJDYZZI_YZID, XLXSTZYZ_JJFS, " + " XLXSBJDYZZI_GYFLBM, XLXSBJDYZZI_ZXJMSX, XLXSBJDYZZI_ZXJMXX, XLXSBJDYZZI_DTLX, XLXSBJDYZZI_XHBHZF1,XLXSBJDYZZI_DYDJID,XLXSBJDYZZI_XHBHZF2, " + "XLXSBJDYZZI_XHBBHZF, XLXSBJDYZZI_YZZ, XLXSBJDYZZI_WHR, XLXSBJDYZZI_WHRID, XLXSBJDYZZI_WHSJ " + " from XLXSBJDYZZI left join XLXSTZYZ on XLXSTZYZ_YZID=XLXSBJDYZZI_YZID and XLXSTZYZ_MXBH='BJD' " + " where XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID and XLXSBJDYZZI_YZID =:XLXSBJDYZZI_YZID " + " and XLXSBJDYZZI_GYFLBM =:XLXSBJDYZZI_GYFLBM and XLXSBJDYZZI_DTLX =:XLXSBJDYZZI_DTLX and XLXSBJDYZZI_DYDJID =:XLXSBJDYZZI_DYDJID " + " and XLXSBJDYZZI_ZXJMSX=:XLXSBJDYZZI_ZXJMSX and XLXSBJDYZZI_ZXJMXX=:XLXSBJDYZZI_ZXJMXX " + " and XLXSBJDYZZI_XHBHZF1=:XLXSBJDYZZI_XHBHZF1 and XLXSBJDYZZI_XHBHZF2=:XLXSBJDYZZI_XHBHZF2 and XLXSBJDYZZI_XHBBHZF=:XLXSBJDYZZI_XHBBHZF", UpdateSql = " update XLXSBJDYZZI " + " set XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID , XLXSBJDYZZI_YZID =:XLXSBJDYZZI_YZID " + " , XLXSBJDYZZI_GYFLBM =:XLXSBJDYZZI_GYFLBM , XLXSBJDYZZI_DYDJID =:XLXSBJDYZZI_DYDJID , XLXSBJDYZZI_DTLX =:XLXSBJDYZZI_DTLX" + " , XLXSBJDYZZI_ZXJMSX=:XLXSBJDYZZI_ZXJMSX , XLXSBJDYZZI_ZXJMXX=:XLXSBJDYZZI_ZXJMXX " + " , XLXSBJDYZZI_XHBHZF1=:XLXSBJDYZZI_XHBHZF1 , XLXSBJDYZZI_XHBHZF2=:XLXSBJDYZZI_XHBHZF2 , XLXSBJDYZZI_XHBBHZF=:XLXSBJDYZZI_XHBBHZF,XLXSBJDYZZI_YZZ=:XLXSBJDYZZI_YZZ," + " XLXSBJDYZZI_WHR=:XLXSBJDYZZI_WHR,XLXSBJDYZZI_WHRID=:XLXSBJDYZZI_WHRID,XLXSBJDYZZI_WHSJ=:XLXSBJDYZZI_WHSJ " + " where XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID and XLXSBJDYZZI_YZID =:OLD_XLXSBJDYZZI_YZID " + " and XLXSBJDYZZI_GYFLBM =:OLD_XLXSBJDYZZI_GYFLBM and XLXSBJDYZZI_DTLX =:OLD_XLXSBJDYZZI_DTLX and XLXSBJDYZZI_DYDJID =:OLD_XLXSBJDYZZI_DYDJID " + " and XLXSBJDYZZI_ZXJMSX=:OLD_XLXSBJDYZZI_ZXJMSX and XLXSBJDYZZI_ZXJMXX=:OLD_XLXSBJDYZZI_ZXJMXX " + " and XLXSBJDYZZI_XHBHZF1=:OLD_XLXSBJDYZZI_XHBHZF1 and XLXSBJDYZZI_XHBHZF2=:OLD_XLXSBJDYZZI_XHBHZF2 and XLXSBJDYZZI_XHBBHZF=:OLD_XLXSBJDYZZI_XHBBHZF", InsertSql = " select XLXSBJDYZZI_JGBID from XLXSBJDYZZI where 1 <> 1 ", DeleteSql = " delete from XLXSBJDYZZI " + " where XLXSBJDYZZI_JGBID =:XLXSBJDYZZI_JGBID and XLXSBJDYZZI_YZID =:XLXSBJDYZZI_YZID " + " and XLXSBJDYZZI_GYFLBM =:XLXSBJDYZZI_GYFLBM and XLXSBJDYZZI_DTLX =:XLXSBJDYZZI_DTLX and XLXSBJDYZZI_DYDJID =:XLXSBJDYZZI_DYDJID" + " and XLXSBJDYZZI_ZXJMSX=:XLXSBJDYZZI_ZXJMSX and XLXSBJDYZZI_ZXJMXX=:XLXSBJDYZZI_ZXJMXX " + " and XLXSBJDYZZI_XHBHZF1=:XLXSBJDYZZI_XHBHZF1 and XLXSBJDYZZI_XHBHZF2=:XLXSBJDYZZI_XHBHZF2 and XLXSBJDYZZI_XHBBHZF=:XLXSBJDYZZI_XHBBHZF")] public class TZYZBJI : EntityManager { private string _XLXSBJDYZZI_JGBID; [ColumnMap(DbField = "XLXSBJDYZZI_JGBID", CtrlName = "txtJGBID", DbTitle = "调价表编号", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = false, IsKey = true, Length = 8)] public string XLXSBJDYZZI_JGBID { get { return _XLXSBJDYZZI_JGBID; } set { _XLXSBJDYZZI_JGBID = value; } } private string _XLXSBJDYZZI_GYFLBM; [ColumnMap(DbField = "XLXSBJDYZZI_GYFLBM", CtrlName = "cbxGYFLBM", DbTitle = "工艺分类编码", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = true, Length = 20)] public string XLXSBJDYZZI_GYFLBM { get { return _XLXSBJDYZZI_GYFLBM; } set { _XLXSBJDYZZI_GYFLBM = value; } } private string _OLD_XLXSBJDYZZI_GYFLBM; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_GYFLBM", CtrlName = "txtOLD_GYFLBM", DbTitle = "原工艺分类编码", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 20, PrintVisible = false)] public string OLD_XLXSBJDYZZI_GYFLBM { get { return _OLD_XLXSBJDYZZI_GYFLBM; } set { _OLD_XLXSBJDYZZI_GYFLBM = value; } } private string _XLXSBJDYZZI_DYDJID; [ColumnMap(DbField = "XLXSBJDYZZI_DYDJID", CtrlName = "cbxDYDJID", DbTitle = "电压等级", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = true, Length = 20)] public string XLXSBJDYZZI_DYDJID { get { return _XLXSBJDYZZI_DYDJID; } set { _XLXSBJDYZZI_DYDJID = value; } } private string _OLD_XLXSBJDYZZI_DYDJID; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_DYDJID", CtrlName = "txtOLD_DYDJID", DbTitle = "原电压等级ID", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 20, PrintVisible = false)] public string OLD_XLXSBJDYZZI_DYDJID { get { return _OLD_XLXSBJDYZZI_DYDJID; } set { _OLD_XLXSBJDYZZI_DYDJID = value; } } private string _XLXSBJDYZZI_DTLX; [ColumnMap(DbField = "XLXSBJDYZZI_DTLX", CtrlName = "cbxDTLX", DbTitle = "导体类型", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = true, Length = 10)] public string XLXSBJDYZZI_DTLX { get { return _XLXSBJDYZZI_DTLX; } set { _XLXSBJDYZZI_DTLX = value; } } private string _OLD_XLXSBJDYZZI_DTLX; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_DTLX", CtrlName = "txtOLD_DTLX", DbTitle = "原导体类型", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10, PrintVisible = false)] public string OLD_XLXSBJDYZZI_DTLX { get { return _OLD_XLXSBJDYZZI_DTLX; } set { _OLD_XLXSBJDYZZI_DTLX = value; } } private string _XLXSBJDYZZI_ZXJMSX; [ColumnMap(DbField = "XLXSBJDYZZI_ZXJMSX", CtrlName = "txtZXJMSX", DbTitle = "主芯截面上限", Type = FieldType.F, DefaultValue = "0", IsAllowNull = false, IsKey = true, Length = 0)] public string XLXSBJDYZZI_ZXJMSX { get { return _XLXSBJDYZZI_ZXJMSX; } set { _XLXSBJDYZZI_ZXJMSX = value; } } private string _OLD_XLXSBJDYZZI_ZXJMSX; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_ZXJMSX", CtrlName = "txtOLD_ZXJMSX", DbTitle = "原主芯截面上限", Type = FieldType.HiddenField, DefaultValue = "0", IsAllowNull = true, IsKey = false, Length = 0)] public string OLD_XLXSBJDYZZI_ZXJMSX { get { return _OLD_XLXSBJDYZZI_ZXJMSX; } set { _OLD_XLXSBJDYZZI_ZXJMSX = value; } } private string _XLXSBJDYZZI_ZXJMXX; [ColumnMap(DbField = "XLXSBJDYZZI_ZXJMXX", CtrlName = "txtZXJMXX", DbTitle = "主芯截面下限", Type = FieldType.F, DefaultValue = "0", IsAllowNull = false, IsKey = true, Length = 0)] public string XLXSBJDYZZI_ZXJMXX { get { return _XLXSBJDYZZI_ZXJMXX; } set { _XLXSBJDYZZI_ZXJMXX = value; } } private string _OLD_XLXSBJDYZZI_ZXJMXX; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_ZXJMXX", CtrlName = "txtOLD_ZXJMXX", DbTitle = "原主芯截面下限", Type = FieldType.HiddenField, DefaultValue = "0", IsAllowNull = true, IsKey = false, Length = 0)] public string OLD_XLXSBJDYZZI_ZXJMXX { get { return _OLD_XLXSBJDYZZI_ZXJMXX; } set { _OLD_XLXSBJDYZZI_ZXJMXX = value; } } private string _XLXSBJDYZZI_XHBHZF1; [ColumnMap(DbField = "XLXSBJDYZZI_XHBHZF1", CtrlName = "txtXHBHZF1", DbTitle = "型号包含", Type = FieldType.C, DefaultValue = "", IsAllowNull = true, IsKey = true, Length = 250)] public string XLXSBJDYZZI_XHBHZF1 { get { return _XLXSBJDYZZI_XHBHZF1; } set { _XLXSBJDYZZI_XHBHZF1 = value; } } private string _OLD_XLXSBJDYZZI_XHBHZF1; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_XHBHZF1", CtrlName = "txtOLD_XHBHZF1", DbTitle = "原型号包含", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 250)] public string OLD_XLXSBJDYZZI_XHBHZF1 { get { return _OLD_XLXSBJDYZZI_XHBHZF1; } set { _OLD_XLXSBJDYZZI_XHBHZF1 = value; } } private string _XLXSBJDYZZI_XHBHZF2; [ColumnMap(DbField = "XLXSBJDYZZI_XHBHZF2", CtrlName = "txtXHBHZF2", DbTitle = "型号包含", Type = FieldType.C, DefaultValue = "", IsAllowNull = true, IsKey = true, Length = 250)] public string XLXSBJDYZZI_XHBHZF2 { get { return _XLXSBJDYZZI_XHBHZF2; } set { _XLXSBJDYZZI_XHBHZF2 = value; } } private string _OLD_XLXSBJDYZZI_XHBHZF2; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_XHBHZF2", CtrlName = "txtOLD_XHBHZF2", DbTitle = "原型号包含", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 250)] public string OLD_XLXSBJDYZZI_XHBHZF2 { get { return _OLD_XLXSBJDYZZI_XHBHZF2; } set { _OLD_XLXSBJDYZZI_XHBHZF2 = value; } } private string _XLXSBJDYZZI_XHBBHZF; [ColumnMap(DbField = "XLXSBJDYZZI_XHBBHZF", CtrlName = "txtXHBBHZF", DbTitle = "型号不包含", Type = FieldType.C, DefaultValue = "", IsAllowNull = true, IsKey = true, Length = 250)] public string XLXSBJDYZZI_XHBBHZF { get { return _XLXSBJDYZZI_XHBBHZF; } set { _XLXSBJDYZZI_XHBBHZF = value; } } private string _OLD_XLXSBJDYZZI_XHBBHZF; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_XHBBHZF", CtrlName = "txtOLD_XHBBHZF", DbTitle = "原型号不包含", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 250)] public string OLD_XLXSBJDYZZI_XHBBHZF { get { return _OLD_XLXSBJDYZZI_XHBBHZF; } set { _OLD_XLXSBJDYZZI_XHBBHZF = value; } } private string _XLXSBJDYZZI_YZID; [ColumnMap(DbField = "XLXSBJDYZZI_YZID", CtrlName = "cbxYZID", DbTitle = "调价因子编码", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string XLXSBJDYZZI_YZID { get { return _XLXSBJDYZZI_YZID; } set { _XLXSBJDYZZI_YZID = value; } } private string _OLD_XLXSBJDYZZI_YZID; [ColumnMap(DbField = "OLD_XLXSBJDYZZI_YZID", CtrlName = "txtOLD_YZID", DbTitle = "原调价因子编码", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string OLD_XLXSBJDYZZI_YZID { get { return _OLD_XLXSBJDYZZI_YZID; } set { _OLD_XLXSBJDYZZI_YZID = value; } } private string _XLXSTZYZ_JJFS; [ColumnMap(DbField = "XLXSTZYZ_JJFS", CtrlName = "cbxJJFS", DbTitle = "调价方式", Type = FieldType.CBX, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 2)] public string XLXSTZYZ_JJFS { get { return _XLXSTZYZ_JJFS; } set { _XLXSTZYZ_JJFS = value; } } private string _XLXSBJDYZZI_YZZ; [ColumnMap(DbField = "XLXSBJDYZZI_YZZ", CtrlName = "txtYZZ", Type = FieldType.F, DbTitle = "因子值", DefaultValue = "0", IsAllowNull = true, IsKey = false, Length = 0)] public string XLXSBJDYZZI_YZZ { get { return _XLXSBJDYZZI_YZZ; } set { _XLXSBJDYZZI_YZZ = value; } } private string _XLXSBJDYZZI_WHR; [ColumnMap(DbField = "XLXSBJDYZZI_WHR", CtrlName = "txtWHR", DbTitle = "维护人", Type = FieldType.C, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 30)] public string XLXSBJDYZZI_WHR { get { return _XLXSBJDYZZI_WHR; } set { _XLXSBJDYZZI_WHR = value; } } private string _XLXSBJDYZZI_WHRID; [ColumnMap(DbField = "XLXSBJDYZZI_WHRID", CtrlName = "txtWHRID", DbTitle = "维护人工号", Type = FieldType.HiddenField, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string XLXSBJDYZZI_WHRID { get { return _XLXSBJDYZZI_WHRID; } set { _XLXSBJDYZZI_WHRID = value; } } private string _XLXSBJDYZZI_WHSJ; [ColumnMap(DbField = "XLXSBJDYZZI_WHSJ", CtrlName = "datWHSJ", DbTitle = "维护时间", Type = FieldType.DT, DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string XLXSBJDYZZI_WHSJ { get { return _XLXSBJDYZZI_WHSJ; } set { _XLXSBJDYZZI_WHSJ = value; } } } }