using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("frequentlyaskedquestionevaluation")]
    public class FrequentlyAskedQuestionEvaluation : BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public FrequentlyAskedQuestionEvaluation()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10, "Id", 1, 1, 100, 1, "a.Id", "", 1, 1)]
        [Key]
        [Identity]
        public int Id { get; set; }
        [ColDetail(20, "问题Id", 1, 1, 100, 1, "a.QuestionId", "", 1, 1)]
        public int QuestionId { get; set; }
        [ColDetail(30, "工号", 1, 1, 100, 1, "a.StaffCode", "", 1, 1)]
        public string StaffCode { get; set; }
        [ColDetail(40, "评价类别   1 有用  2 没用", 1, 1, 100, 1, "a.GradeCategory", "", 1, 1)]
        public Enums.EnumQuestionEvaluationCategory GradeCategory { get; set; }
        [ColDetail(50, "评价时间", 1, 1, 100, 1, "a.EvaluateTime", "", 1, 1)]
        public DateTime EvaluateTime { get; set; }
        [ColDetail(60, "FName", 1, 1, 100, 1, "b.RecName", "", 1, 1)]
        public string FName { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
            string sqlstr = "a.Id Id,a.QuestionId QuestionId,a.StaffCode StaffCode,a.GradeCategory GradeCategory,a.EvaluateTime EvaluateTime,b.RecName FName,0 EntityStatusID";
            return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr = " frequentlyaskedquestionevaluation a ";
            sqlstr += " left outer join staff b on a.staffcode =b.fcode";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}