public Employee GetByLoginname(string loginname, PcsEmployeeSO search)
{
Employee result = null;
try
{
bool valid = true;
valid = valid && IsNotNullOrEmpty(loginname);
if (valid)
{
using (var ctx = new Base.AppContext())
{
var query = ctx.Employees.AsQueryable().Where(p => p.Loginname == loginname);
if (search.listEmployeeExpression != null && search.listEmployeeExpression.Count > 0)
{
foreach (var item in search.listEmployeeExpression)
{
query = query.Where(item);
}
}
result = query.SingleOrDefault();
}
}
}
catch (Exception ex)
{
Logging(LogUtil.TraceData("loginname", loginname) + LogUtil.TraceData("search", search), LogType.Error);
LogSystem.Error(ex);
result = null;
}
return(result);
}
public Project GetById(long id, PcsProjectSO search)
{
Project result = null;
try
{
bool valid = true;
valid = valid && IsGreaterThanZero(id);
if (valid)
{
using (var ctx = new Base.AppContext())
{
var query = ctx.Projects.AsQueryable().Where(p => p.Id == id);
if (search.listProjectExpression != null && search.listProjectExpression.Count > 0)
{
foreach (var item in search.listProjectExpression)
{
query = query.Where(item);
}
}
result = query.SingleOrDefault();
}
}
}
catch (Exception ex)
{
Logging(LogUtil.TraceData("id", id) + LogUtil.TraceData("search", search), LogType.Error);
LogSystem.Error(ex);
result = null;
}
return(result);
}
public Project GetByCode(string code, PcsProjectSO search)
{
Project result = null;
try
{
bool valid = true;
valid = valid && IsNotNullOrEmpty(code);
if (valid)
{
using (var ctx = new Base.AppContext())
{
var query = ctx.Projects.AsQueryable().Where(p => p.ProjectCode == code);
if (search.listProjectExpression != null && search.listProjectExpression.Count > 0)
{
foreach (var item in search.listProjectExpression)
{
query = query.Where(item);
}
}
result = query.SingleOrDefault();
}
}
}
catch (Exception ex)
{
Logging(LogUtil.TraceData("code", code) + LogUtil.TraceData("search", search), LogType.Error);
LogSystem.Error(ex);
result = null;
}
return(result);
}
public List <Project> Get(PcsProjectSO search, CommonParam param)
{
List <Project> list = new List <Project>();
try
{
bool valid = true;
valid = valid && IsNotNull(param);
if (valid)
{
using (var ctx = new Base.AppContext())
{
var query = ctx.Projects.AsQueryable();
if (search.listProjectExpression != null && search.listProjectExpression.Count > 0)
{
foreach (var item in search.listProjectExpression)
{
query = query.Where(item);
}
}
if (!string.IsNullOrWhiteSpace(search.OrderField) && !string.IsNullOrWhiteSpace(search.OrderDirection))
{
if (!param.Start.HasValue || !param.Limit.HasValue)
{
list = query.OrderByProperty(search.OrderField, search.OrderDirection).ToList();
}
else
{
param.Count = (from r in query select r).Count(); query = query.OrderByProperty(search.OrderField, search.OrderDirection);
if (param.Count <= param.Limit.Value && param.Start.Value == 0)
{
list = query.ToList();
}
else
{
list = query.Skip(param.Start.Value).Take(param.Limit.Value).ToList();
}
}
}
else
{
list = query.ToList();
}
}
}
}
catch (Exception ex)
{
Logging(LogUtil.TraceData("search", search) + LogUtil.TraceData("param", param), LogType.Error);
LogSystem.Error(ex);
list.Clear();
}
return(list);
}
public bool ExistsCode(string code, long?id)
{
bool result = false;
try
{
code = (code == null ? "" : code);
id = id.HasValue ? id.Value : -1;
long count = 0;
using (var ctx = new Base.AppContext())
{
count = ctx.Roles.AsQueryable().Where(p => p.RoleCode.Equals(code) && p.Id != id).Count();
}
result = (count > 0);
}
catch (Exception)
{
Logging(LogUtil.TraceData("code", code) + LogUtil.TraceData("id", id), LogType.Error);
throw;
}
return(result);
}
public List <RAW> GetSql <RAW>(string sql, params object[] parameters)
{
List <RAW> result = null;
try
{
if (!String.IsNullOrEmpty(sql))
{
using (var ctx = new Base.AppContext())
{
result = ctx.Database.SqlQuery <RAW>(sql, parameters).ToList();
}
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
LogSystem.Error("sql: " + sql + LogUtil.TraceData("parameters:", parameters));
result = null;
}
return(result);
}
public bool Execute(List <string> sqls)
{
bool result = false;
string sql = "";
try
{
if (sqls != null && sqls.Count > 0)
{
StringBuilder sqlBuilder = new StringBuilder();
foreach (string s in sqls)
{
if (!string.IsNullOrWhiteSpace(s))
{
sqlBuilder.Append(string.Format("{0};", s));
}
}
string tmp = sqlBuilder.ToString();
if (!string.IsNullOrWhiteSpace(tmp))
{
sql = string.Format("BEGIN {0} END;", tmp);
using (var ctx = new Base.AppContext())
{
ctx.Database.ExecuteSqlCommand(sql);
result = true;
}
}
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
LogSystem.Error("sql: " + sql);
result = false;
}
return(result);
}
public RAW GetSqlSingle <RAW>(string sql, params object[] parameters)
{
RAW result = default(RAW);
try
{
if (!String.IsNullOrEmpty(sql))
{
using (var ctx = new Base.AppContext())
{
result = ctx.Database.SqlQuery <RAW>(sql, parameters).FirstOrDefault();
}
}
}
catch (Exception ex)
{
LogSystem.Error("sql: " + sql + LogUtil.TraceData("parameters:", parameters));
LogSystem.Error(ex);
result = default(RAW);
}
return(result);
}
public bool Execute(string sql, params object[] parameters)
{
bool result = false;
try
{
if (!String.IsNullOrEmpty(sql))
{
using (var ctx = new Base.AppContext())
{
ctx.Database.ExecuteSqlCommand(sql, parameters);
result = true;
}
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
LogSystem.Error("sql: " + sql + LogUtil.TraceData("parameters:", parameters));
result = false;
}
return(result);
}
