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_XLJC { [TableMap(DB = "DBERP", DbTableName = "BJCPXX", Umid = 101421013, IsWorkFlow = false, UseWhr = false, IsAttach = false, EntitySelSql = @" select BJCPXX_XLXHID,BJCPXX_XLGGID,BJCPXX_XLBZID,BJCPXX_DYDJID,BJCPXX_DTJGXX,BJCPXX_WJ, BJCPXX_ZXWQBS,BJCPXX_WHR,BJCPXX_WHRID,BJCPXX_WHSJ,rtrim(XLBZ_XLBZLXMC)||'|'||XLBZ_XLBZID as XLBZ, BJCPXX_XLXHID as OLD_XLXHID,BJCPXX_XLGGID as OLD_XLGGID,BJCPXX_XLBZID as OLD_XLBZID,BJCPXX_DYDJID as OLD_DYDJID from BJCPXX left join XLBZ on XLBZ_XLBZID=BJCPXX_XLBZID where BJCPXX_XLXHID=:OLD_XLXHID and BJCPXX_XLGGID=:OLD_XLGGID and BJCPXX_XLBZID=:OLD_XLBZID and BJCPXX_DYDJID=:OLD_DYDJID ", InsertSql = @"insert into BJCPXX (BJCPXX_XLXHID, BJCPXX_XLGGID, BJCPXX_XLBZID, BJCPXX_DYDJID, BJCPXX_DTJGXX, BJCPXX_WJ, BJCPXX_ZXWQBS, BJCPXX_WHR, BJCPXX_WHRID, BJCPXX_WHSJ) values (:BJCPXX_XLXHID, :BJCPXX_XLGGID, :BJCPXX_XLBZID, :BJCPXX_DYDJID, :BJCPXX_DTJGXX, :BJCPXX_WJ, :BJCPXX_ZXWQBS, :BJCPXX_WHR, :BJCPXX_WHRID, :BJCPXX_WHSJ)", UpdateSql = @"update BJCPXX set BJCPXX_XLXHID=:BJCPXX_XLXHID, BJCPXX_XLGGID=:BJCPXX_XLGGID, BJCPXX_XLBZID=:BJCPXX_XLBZID, BJCPXX_DYDJID=:BJCPXX_DYDJID, BJCPXX_DTJGXX=:BJCPXX_DTJGXX, BJCPXX_WJ=:BJCPXX_WJ, BJCPXX_ZXWQBS=:BJCPXX_ZXWQBS, BJCPXX_WHR=:BJCPXX_WHR, BJCPXX_WHRID=:BJCPXX_WHRID, BJCPXX_WHSJ=:BJCPXX_WHSJ where BJCPXX_XLXHID=:OLD_XLXHID and BJCPXX_XLGGID=:OLD_XLGGID and BJCPXX_XLBZID=:OLD_XLBZID and BJCPXX_DYDJID=:OLD_DYDJID ", DeleteSql = "DELETE FROM BJCPXX where BJCPXX_XLXHID=:OLD_XLXHID and BJCPXX_XLGGID=:OLD_XLGGID and BJCPXX_XLBZID=:OLD_XLBZID and BJCPXX_DYDJID=:OLD_DYDJID ")] public class BJCPWH : EntityManager { #region 字段级映射 private string _BJCPXX_XLXHID; [ColumnMap(DbField = "BJCPXX_XLXHID", CtrlName = "cbxXH", Type = FieldType.CBX, DbTitle = "型号", DefaultValue = "", IsAllowNull = false, IsKey = false, Length = 20)] public string BJCPXX_XLXHID { get { return _BJCPXX_XLXHID; } set { _BJCPXX_XLXHID = value; } } private string _BJCPXX_XLGGID; [ColumnMap(DbField = "BJCPXX_XLGGID", CtrlName = "txtGG", Type = FieldType.C, DbTitle = "规格", DefaultValue = "", IsAllowNull = false, IsKey = false, Length = 60)] public string BJCPXX_XLGGID { get { return _BJCPXX_XLGGID; } set { _BJCPXX_XLGGID = value; } } private string _BJCPXX_XLBZID; [ColumnMap(DbField = "BJCPXX_XLBZID", CtrlName = "cbxBZ", Type = FieldType.CBX, DbTitle = "标准", DefaultValue = "", IsAllowNull = false, IsKey = false, Length = 10)] public string BJCPXX_XLBZID { get { return _BJCPXX_XLBZID; } set { _BJCPXX_XLBZID = value; } } private string _BJCPXX_DYDJID; [ColumnMap(DbField = "BJCPXX_DYDJID", CtrlName = "cbxDYDJ", Type = FieldType.CBX, DbTitle = "电压等级", DefaultValue = "", IsAllowNull = false, IsKey = false, Length = 20)] public string BJCPXX_DYDJID { get { return _BJCPXX_DYDJID; } set { _BJCPXX_DYDJID = value; } } private string _OLD_XLXHID; [ColumnMap(DbField = "OLD_XLXHID", CtrlName = "txtOLDXH", Type = FieldType.HiddenField, PrintVisible = false, DbTitle = "原型号", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 20)] public string OLD_XLXHID { get { return _OLD_XLXHID; } set { _OLD_XLXHID = value; } } private string _OLD_XLGGID; [ColumnMap(DbField = "OLD_XLGGID", CtrlName = "txtOLDGG", Type = FieldType.HiddenField, PrintVisible = false, DbTitle = "原规格", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 60)] public string OLD_XLGGID { get { return _OLD_XLGGID; } set { _OLD_XLGGID = value; } } private string _OLD_XLBZID; [ColumnMap(DbField = "OLD_XLBZID", CtrlName = "txtOLDBZ", Type = FieldType.HiddenField, PrintVisible = false, DbTitle = "原标准", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string OLD_XLBZID { get { return _OLD_XLBZID; } set { _OLD_XLBZID = value; } } private string _OLD_DYDJID; [ColumnMap(DbField = "OLD_DYDJID", CtrlName = "txtOLDDYDJ", Type = FieldType.HiddenField, PrintVisible = false, DbTitle = "原电压等级", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 20)] public string OLD_DYDJID { get { return _OLD_DYDJID; } set { _OLD_DYDJID = value; } } private string _BJCPXX_WJ; [ColumnMap(DbField = "BJCPXX_WJ", CtrlName = "txtWJ", Type = FieldType.F, DbTitle = "外径", DefaultValue = "0", IsAllowNull = true, IsKey = false, Length = 0)] public string BJCPXX_WJ { get { return _BJCPXX_WJ; } set { _BJCPXX_WJ = value; } } private string _BJCPXX_ZXWQBS; [ColumnMap(DbField = "BJCPXX_ZXWQBS", CtrlName = "txtZXWQBS", Type = FieldType.F, DbTitle = "最小弯曲倍数", DefaultValue = "0", IsAllowNull = true, IsKey = false, Length = 0)] public string BJCPXX_ZXWQBS { get { return _BJCPXX_ZXWQBS; } set { _BJCPXX_ZXWQBS = value; } } //导体结构信息 private string _BJCPXX_DTJGXX; [ColumnMap(DbField = "BJCPXX_DTJGXX", CtrlName = "txtDTJGXX", Type = FieldType.C, DbTitle = "导体结构信息", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 250)] public string BJCPXX_DTJGXX { get { return _BJCPXX_DTJGXX; } set { _BJCPXX_DTJGXX = value; } } // 私有变量维护人 private string _BJCPXX_WHR; [ColumnMap(DbField = "BJCPXX_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 30)] public string BJCPXX_WHR { get { return _BJCPXX_WHR; } set { _BJCPXX_WHR = value; } } // 私有变量维护人编码 private string _BJCPXX_WHRID; [ColumnMap(DbField = "BJCPXX_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人工号", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 10)] public string BJCPXX_WHRID { get { return _BJCPXX_WHRID; } set { _BJCPXX_WHRID = value; } } // 私有变量维护时间 private string _BJCPXX_WHSJ; [ColumnMap(DbField = "BJCPXX_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "", IsAllowNull = true, IsKey = false, Length = 0)] public string BJCPXX_WHSJ { get { return _BJCPXX_WHSJ; } set { _BJCPXX_WHSJ = value; } } #endregion } }