63 lines
2.4 KiB
C#
63 lines
2.4 KiB
C#
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
|
|
namespace BLL
|
|
{
|
|
public static class APIWelderService
|
|
{
|
|
/// <summary>
|
|
/// 获取用户登录信息
|
|
/// </summary>
|
|
/// <param name="userInfo"></param>
|
|
/// <returns></returns>
|
|
public static Model.UserItem WelderLogOn(Model.UserItem userInfo)
|
|
{
|
|
var getUser = from x in Funs.DB.Welder_Welder
|
|
where x.WelderName == userInfo.Account
|
|
&& ( x.IdentityCard != null && x.IdentityCard.Substring(x.IdentityCard.Length - 4) == userInfo.Password)
|
|
&& x.ProjectId ==userInfo.LoginProjectId
|
|
select new Model.UserItem
|
|
{
|
|
UserId = x.WelderId,
|
|
UserCode = x.WelderCode,
|
|
UserName = x.WelderName,
|
|
UnitId = x.UnitId,
|
|
LoginProjectId = x.ProjectId,
|
|
IdentityCard = x.IdentityCard,
|
|
UserType = "3",
|
|
};
|
|
|
|
return getUser.FirstOrDefault();
|
|
}
|
|
|
|
#region 根据项目ID和施工单位获取项目焊工列表信息
|
|
/// <summary>
|
|
/// 根据项目ID和施工单位获取项目焊工列表信息
|
|
/// </summary>
|
|
/// <param name="projectId">项目ID</param>
|
|
/// <param name="unitId">施工单位ID</param>
|
|
/// <returns></returns>
|
|
public static List<Model.BaseInfoItem> getWelderList(string projectId,string unitId)
|
|
{
|
|
using (Model.HJGLDB db = new Model.HJGLDB(Funs.ConnString))
|
|
{
|
|
var getDataLists = (from x in db.Welder_ProjectWelder
|
|
join y in db.Welder_Welder on x.WelderId equals y.WelderId
|
|
where x.ProjectId == projectId && x.UnitId == unitId
|
|
select new Model.BaseInfoItem
|
|
{
|
|
BaseInfoId = x.WelderId,
|
|
BaseInfoCode = y.WelderCode,
|
|
BaseInfoName = y.WelderName
|
|
}).Distinct().ToList();
|
|
|
|
return getDataLists;
|
|
}
|
|
}
|
|
#endregion
|
|
}
|
|
}
|
|
|