WorkFlow/WorkFlowApi/WorkFlowApi..../UserAccountB...

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WorkFlowApi.DB;
using WorkFlowApi.Entity;
using WorkFlowApi.IBusiness;
using WorkFlowApi.Utility;

namespace WorkFlowApi.Business
{
    public class UserAccountBusiness:BaseBusiness<T_Sys_UserAccount>,IUserAccountBusiness
    {
        public UserAccountBusiness()
        {
        }
        protected override string KeyField => "F_UserId";

        /// <summary>
        /// 根据账号获取用户
        /// </summary>
        /// <param name="userCode"></param>
        /// <returns></returns>
        public T_Sys_UserAccount GetEntityByUserCode(string userCode)
        {
            string fields = string.Join(",", Prop.Select(p => string.Format("[{0}]", p.Name)));
            string sql = string.Format("select top 1 {0} from T_Sys_UserAccount with(nolock) where [F_UserCode]=@F_UserCode;", fields, type.Name);
            SqlParameter[] ps = {
                    new SqlParameter(string.Format("@F_UserCode", KeyField), userCode)
            };

            DataTable dt = DbHelperSQL.Query(sql, ps).Tables[0];

            return dt.ConvertToList<T_Sys_UserAccount>().FirstOrDefault();
        }
    }
}