public List <LiveChatRoomMember> FindList(System.Linq.Expressions.Expression <Func <LiveChatRoomMember, bool> > where)
{
List <LiveChatRoomMember> rc = null;
try {
rc = db.Queryable <LiveChatRoomMember>().WhereIF(where != null, where).ToList();
}
catch (Exception ex) {
log.Error("FindList", ex);
}
return(rc);
}
public List <UserInfo> FindList(System.Linq.Expressions.Expression <Func <UserInfo, bool> > where)
{
List <UserInfo> rc = null;
try {
rc = db.Queryable <UserInfo>().WhereIF(where != null, where).ToList();
}
catch (Exception ex) {
log.Error("FindList", ex);
}
return(rc);
}
public GetMemberModelOutputDto GetMemberModel(GetMemberModelInputDto args)
{
var rlt = _db
.Queryable <Model.sys_member, Model.bif_company>((m, c) => new object[]
{ SqlSugar.JoinType.Left, m.coid == c.ID })
.Where((m, c) => m.ID == args.ID)
.Select((m, c) => new GetMemberModelOutputDto {
ID = m.ID, Name = m.name, CName = c.name, CAddress = c.address, CCode = c.code, CEmail = c.email, CRdt = c.rdt
})
.First();
return(rlt);
}
private void Reload()
{
var dt = client.Queryable <sdglsys.Entity.T_Dorm>().Where(x => x.Dorm_model_state).ToDataTable();
dataGridView1.AutoGenerateColumns = false;
dt.Columns.Add("sex", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["sex"] = dt.Rows[i][2].Equals(true) ? "男" : "女";
}
dataGridView1.DataSource = dt;
}
/// <summary>
///
/// </summary>
/// <param name="loginName"></param>
/// <param name="loginPwd"></param>
/// <returns></returns>
public async Task <string> GetUserRoleNameStr(string loginName, string loginPwd)
{
string roleName = "";
var user = (await Query(a => a.uLoginName == loginName && a.uLoginPWD == loginPwd)).FirstOrDefault();
var roleList = await _roleRepository.Query(a => a.IsDeleted == false);
if (user != null)
{
var userRoles = await _Db.Queryable <UserRole>().Where(u => u.Id == user.uID).ToListAsync();
if (userRoles.Count > 0)
{
var arr = userRoles.Select(ur => ur.RoleId.ObjToString()).ToList();
var roles = roleList.Where(d => arr.Contains(d.Id.ObjToString()));
roleName = string.Join(',', roles.Select(r => r.Name).ToArray());
}
}
return(roleName);
}
public List <Sys_Model> GetNavModelEntity()
{
return(db.Queryable <Sys_Model>().ToList());
}
public List <Sys_Email> GetUserEmails(int in_users)
{
return(db.Queryable <Sys_Email>().Where(x => x.PF_In_UserID == in_users.ToString()).OrderBy("PF_CreateTime desc").ToList());
}
private static int GetCount(SqlSugar.SqlSugarClient db)
{
return(db.Queryable <Order>().Count());
}
/// <summary>
/// 加载所有联系人
/// </summary>
public List <Sys_Custorm> GetCustorms(string name)
{
return(db.Queryable <Sys_Custorm>().WhereIF(!string.IsNullOrWhiteSpace(name), x => x.PF_NAME.Contains(name) || x.PF_COMPANY.Contains(name)).ToList());
}
public Sys_AccountInfo GetUserInfoEntity(Sys_AccountInfo item)
{
return(db.Queryable <Sys_AccountInfo>().First(x => x.PF_UName == item.PF_UName && x.PF_UPwd == item.PF_UPwd));
}
