ZLPMS/PMS.BusinessModels/Problem/ProblemBusinessModel.cs

using QWPlatform.DataIntface.Database;
using QWPlatform.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PMS.BusinessModels.Problem
{







    [Table("问题记录")]
    public class ProblemBusinessModel : DataModelBase
    {
        //默认不带数据工厂构造
        public ProblemBusinessModel()
        {

        }

        //带有数据工厂的实例化,可以直接操作数据
        public ProblemBusinessModel(DataFactory factory)
            : base(factory)
        {

        }

        ///<summary>
        ///ID[必填项目],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("ID", "", "", true, false, "", 36, 0, "VARCHAR2")]
        public string ID { get; set; }

        ///<summary>
        ///编号[可为空],最大长度为:18,数据库类型:NUMBER
        ///</summary>
        [FieldBase("编号", "", "", false, false, "", 18, 0, "NUMBER")]
        public long? BH { get; set; }

        ///<summary>
        ///渠道ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("渠道ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string QDID { get; set; }

        ///<summary>
        ///项目ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("项目ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string XMID { get; set; }

        ///<summary>
        ///产品ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("产品ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string CPID { get; set; }

        ///<summary>
        ///模块ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("模块ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string MKID { get; set; }

        ///<summary>
        ///版本号[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("版本号", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string BBH { get; set; }

        ///<summary>
        ///来源代码[可为空],最大长度为:2,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("来源代码", "", "", false, false, "", 2, 0, "VARCHAR2")]
        public string LYDM { get; set; }

        ///<summary>
        ///登记人[可为空],最大长度为:50,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("登记人", "", "", false, false, "", 50, 0, "VARCHAR2")]
        public string DJR { get; set; }

        ///<summary>
        ///登记人ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("登记人ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string DJRID { get; set; }

        ///<summary>
        ///登记日期[可为空],最大长度为:7,数据库类型:DATE
        ///</summary>
        [FieldBase("登记日期", "", "", false, false, "", 7, 0, "DATE")]
        public DateTime? DJRJ { get; set; }

        ///<summary>
        ///紧急代码[可为空],最大长度为:2,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("紧急代码", "", "", false, false, "", 2, 0, "VARCHAR2")]
        public string JJDM { get; set; }

        ///<summary>
        ///要求时间[可为空],最大长度为:7,数据库类型:DATE
        ///</summary>
        [FieldBase("要求时间", "", "", false, false, "", 7, 0, "DATE")]
        public DateTime? YQSJ { get; set; }

        ///<summary>
        ///紧急描述[可为空],最大长度为:500,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("紧急描述", "", "", false, false, "", 500, 0, "VARCHAR2")]
        public string JJMS { get; set; }

        ///<summary>
        ///问题标题[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("问题标题", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string WTBT { get; set; }

        ///<summary>
        ///问题描述[可为空],最大长度为:4000,数据库类型:CLOB
        ///</summary>
        [FieldBase("问题描述", "", "", false, false, "", 4000, 0, "CLOB")]
        public string WTMS { get; set; }

        ///<summary>
        ///反馈人[可为空],最大长度为:50,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("反馈人", "", "", false, false, "", 50, 0, "VARCHAR2")]
        public string FKR { get; set; }

        ///<summary>
        ///问题性质[可为空],最大长度为:1,数据库类型:NUMBER(对应问题类型编码：1:Bug2:任务3:需求4:优化)
        ///</summary>
        [FieldBase("问题性质", "(对应问题类型编码：1:Bug2:任务3:需求4:优化)", "", false, false, "", 1, 0, "NUMBER")]
        public string WTXZ { get; set; }

        ///<summary>
        ///是否终止[可为空],最大长度为:1,数据库类型:NUMBER(0:正常，1：终止)
        ///</summary>
        [FieldBase("是否终止", "(0:正常，1：终止)", "", false, false, "", 1, 0, "NUMBER")]
        public int? SFZZ { get; set; }

        ///<summary>
        ///终止说明[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("终止说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string ZZSM { get; set; }

        ///<summary>
        ///终止日期[可为空],最大长度为:7,数据库类型:DATE
        ///</summary>
        [FieldBase("终止日期", "", "", false, false, "", 7, 0, "DATE")]
        public DateTime? ZZRJ { get; set; }

        ///<summary>
        ///是否回退[可为空],最大长度为:1,数据库类型:NUMBER(0:正常，1：回退)
        ///</summary>
        [FieldBase("是否回退", "(0:正常，1：回退)", "", false, false, "", 1, 0, "NUMBER")]
        public int? SFHT { get; set; }

        ///<summary>
        ///回退说明[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("回退说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string HTSM { get; set; }

        ///<summary>
        ///是否解决[可为空],最大长度为:1,数据库类型:NUMBER(0:未解决，1：解决)
        ///</summary>
        [FieldBase("是否解决", "(0:未解决，1：解决)", "", false, false, "", 1, 0, "NUMBER")]
        public int? SFJJ { get; set; }

        ///<summary>
        ///解决方案[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("解决方案", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string JJFA { get; set; }

        ///<summary>
        ///解决版本[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("解决版本", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string JJBB { get; set; }

        ///<summary>
        ///BH版本[可为空],最大长度为:50,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("BH版本", "", "", false, false, "", 50, 0, "VARCHAR2")]
        public string BHBB { get; set; }

        ///<summary>
        ///BH编号[可为空],最大长度为:50,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("BH编号", "", "", false, false, "", 50, 0, "VARCHAR2")]
        public string BHBH { get; set; }

        ///<summary>
        ///关键字[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("关键字", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string GJZ { get; set; }

        ///<summary>
        ///常见问题[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("常见问题", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string CJWT { get; set; }

        ///<summary>
        ///修改说明[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("修改说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string XGSM { get; set; }

        ///<summary>
        ///测试说明[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("测试说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string CSSM { get; set; }

        ///<summary>
        ///升级说明[可为空],最大长度为:200,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("升级说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
        public string SJSM { get; set; }

        ///<summary>
        ///是否发布[可为空],最大长度为:1,数据库类型:NUMBER(0:未发布，1：已发布)
        ///</summary>
        [FieldBase("是否发布", "(0:未发布，1：已发布)", "", false, false, "", 1, 0, "NUMBER")]
        public int? SFFB { get; set; }

        ///<summary>
        ///需要培训[可为空],最大长度为:1,数据库类型:NUMBER(0:不需要，1：需要)
        ///</summary>
        [FieldBase("需要培训", "(0:不需要，1：需要)", "", false, false, "", 1, 0, "NUMBER")]
        public int? XYPX { get; set; }

        ///<summary>
        ///项目处理[可为空],最大长度为:1,数据库类型:NUMBER(0:否，1：是)
        ///</summary>
        [FieldBase("项目处理", "(0:否，1：是)", "", false, false, "", 1, 0, "NUMBER")]
        public int? XMCL { get; set; }

        ///<summary>
        ///技术支持[可为空],最大长度为:1,数据库类型:NUMBER(0:否，1：是)
        ///</summary>
        [FieldBase("技术支持", "(0:否，1：是)", "", false, false, "", 1, 0, "NUMBER")]
        public int? JSZC { get; set; }

        ///<summary>
        ///研发协助[可为空],最大长度为:1,数据库类型:NUMBER(0:否，1：是)
        ///</summary>
        [FieldBase("研发协助", "(0:否，1：是)", "", false, false, "", 1, 0, "NUMBER")]
        public int? YFXZ { get; set; }

        ///<summary>
        ///问题类型[可为空],最大长度为:1,数据库类型:NUMBER(1:项目问题，2：产品问题)
        ///</summary>
        [FieldBase("问题类型", "(1:项目问题，2：产品问题)", "", false, false, "", 1, 0, "NUMBER")]
        public int? WTLX { get; set; }

        ///<summary>
        ///流程ID[可为空],最大长度为:10,数据库类型:NUMBER(关联问题工作流程表)
        ///</summary>
        [FieldBase("流程ID", "(关联问题工作流程表)", "", false, false, "", 10, 0, "NUMBER")]
        public int? LCID { get; set; }

        ///<summary>
        ///是否受理[可为空],最大长度为:1,数据库类型:NUMBER(0:否，1：是)
        ///</summary>
        [FieldBase("是否受理", "(0:否，1：是)", "", false, false, "", 1, 0, "NUMBER")]
        public int? SFSL { get; set; }

        ///<summary>
        ///受理人[可为空],最大长度为:50,数据库类型:VARCHAR2(受理处理该问题的人员姓名)
        ///</summary>
        [FieldBase("受理人", "(受理处理该问题的人员姓名)", "", false, false, "", 50, 0, "VARCHAR2")]
        public string SLR { get; set; }

        ///<summary>
        ///受理人ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("受理人ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string SLRID { get; set; }

        ///<summary>
        ///受理时间[可为空],最大长度为:7,数据库类型:DATE
        ///</summary>
        [FieldBase("受理时间", "", "", false, false, "", 7, 0, "DATE")]
        public DateTime? SLSJ { get; set; }

        ///<summary>
        ///指派人[可为空],最大长度为:50,数据库类型:VARCHAR2(指派具体的处理人员姓名)
        ///</summary>
        [FieldBase("指派人", "(指派具体的处理人员姓名)", "", false, false, "", 50, 0, "VARCHAR2")]
        public string ZPR { get; set; }

        ///<summary>
        ///指派人ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("指派人ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string ZPRID { get; set; }

        ///<summary>
        ///指派时间[可为空],最大长度为:7,数据库类型:DATE
        ///</summary>
        [FieldBase("指派时间", "", "", false, false, "", 7, 0, "DATE")]
        public DateTime? ZPSJ { get; set; }

        ///<summary>
        ///机构ID[可为空],最大长度为:36,数据库类型:VARCHAR2
        ///</summary>
        [FieldBase("机构ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
        public string JGID { get; set; }

        ///<summary>
        ///环节ID[可为空],最大长度为:10,数据库类型:NUMBER(关联问题流程环节表的ID)
        ///</summary>
        [FieldBase("环节ID", "(关联问题流程环节表的ID)", "", false, false, "", 10, 0, "NUMBER")]
        public int? HJID { get; set; }

        public int? Type { get; set; }

        public int? RegisterType { get; set; }

        /// <summary>
        /// 分值ID
        /// </summary>
        public string TYID { get; set; }
        
        /// <summary>
        /// 协助人ID
        /// </summary>
        public string XZRID { set; get; }
        /// <summary>
        /// 是否为内部问题
        /// </summary>
        public int? NBWT { get; set; }
        /// <summary>
        /// 重复问题ID
        /// </summary>
        public string CFWTID { get; set; }

        /// <summary>
        /// 关联ID
        /// </summary>
        public string GLID { get; set; }

        /// <summary>
        /// 迭代ID
        /// </summary>
        public string DDID { get; set; }


        /// <summary>
        /// 研发处理人ID
        /// </summary>
        public string YFCLRID
        {
            get;
            set;
        }
        /// <summary>
        /// 研发处理人
        /// </summary>
        public string YFCLR
        {
            get;
            set;
        }
        /// <summary>
        /// 测试处理人ID
        /// </summary>
        public string CSCLRID
        {
            get;
            set;
        }
        /// <summary>
        /// 测试处理人
        /// </summary>
        public string CSCLR
        {
            get;
            set;
        }

        /// <summary>
        /// 解决版本状态
        /// </summary>
        public string JJBBZT
        {
            get;
            set;
        }

    }
}