/// <summary>
/// 根据申诉记录ID获取V_COMPLAINRECORD类型数据
/// </summary>
/// <param name="CompainRecordID">申诉记录ID</param>
/// <returns></returns>
public V_COMPLAINRECORD GetVcomplainRecordByID(string CompainRecordID)
{
var ents = from a in dal.GetObjects <T_HR_KPIRECORD>()
join b in dal.GetObjects <T_HR_EMPLOYEE>() on a.APPRAISEEID equals b.EMPLOYEEID
join k in dal.GetObjects <T_HR_KPIRECORDCOMPLAIN>() on a.KPIRECORDID equals k.T_HR_KPIRECORD.KPIRECORDID
join d in dal.GetObjects <T_HR_KPIPOINT>() on a.T_HR_KPIPOINT.KPIPOINTID equals d.KPIPOINTID into TEMPKPI
from e in TEMPKPI.DefaultIfEmpty()
where k.COMPLAINID == CompainRecordID
select new V_COMPLAINRECORD
{
T_HR_KPIRECORDCOMPLAIN = k,
T_HR_KPIRECORD = a,
FLOWID = e.FLOWID,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
CREATEUSERID = a.CREATEUSERID,
OWNERID = a.OWNERID,
OWNERPOSTID = a.OWNERPOSTID,
OWNERDEPARTMENTID = a.OWNERDEPARTMENTID,
OWNERCOMPANYID = a.OWNERCOMPANYID
};
return(ents.Count() > 0 ? ents.FirstOrDefault() : null);
}
/////..............................................................
#region YJH create time 2010-10-19
/// <summary>
/// 根据参数获取KPI明细记录的申诉记录
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="sort"></param>
/// <param name="filterString"></param>
/// <param name="paras"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public IQueryable <V_COMPLAINRECORD> GetComplainRecordPaging(int pageIndex, int pageSize, string sort, string filterString, string[] paras, ref int pageCount, int sType, string sValue, string userID, string startDate, string endDate, string strCheckState)
{
List <object> queryParas = new List <object>();
queryParas.AddRange(paras);
if (strCheckState != Convert.ToInt32(CheckStates.WaittingApproval).ToString())
{
SetOrganizationFilter(ref filterString, ref queryParas, userID, "T_HR_KPIRECORDCOMPLAIN");
if (!string.IsNullOrEmpty(strCheckState))
{
if (!string.IsNullOrEmpty(filterString))
{
filterString += " and ";
}
filterString += "T_HR_KPIRECORDCOMPLAIN.CHECKSTATE == @" + queryParas.Count();
queryParas.Add(strCheckState);
}
}
else
{
SetFilterWithflow("COMPLAINID", "T_HR_KPIRECORDCOMPLAIN", userID, ref strCheckState, ref filterString, ref queryParas);
if (queryParas.Count() == paras.Count())
{
return(null);
}
}
var ents = from a in dal.GetObjects <T_HR_KPIRECORD>()
join b in dal.GetObjects <T_HR_EMPLOYEE>() on a.APPRAISEEID equals b.EMPLOYEEID
join k in dal.GetObjects <T_HR_KPIRECORDCOMPLAIN>() on a.KPIRECORDID equals k.T_HR_KPIRECORD.KPIRECORDID
join d in dal.GetObjects <T_HR_KPIPOINT>() on a.T_HR_KPIPOINT.KPIPOINTID equals d.KPIPOINTID into TEMPKPI
from e in TEMPKPI.DefaultIfEmpty()
select new V_COMPLAINRECORD
{
T_HR_KPIRECORDCOMPLAIN = k,
T_HR_KPIRECORD = a,
FLOWID = e.FLOWID,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
CREATEUSERID = a.CREATEUSERID,
OWNERID = a.OWNERID,
OWNERPOSTID = a.OWNERPOSTID,
OWNERDEPARTMENTID = a.OWNERDEPARTMENTID,
OWNERCOMPANYID = a.OWNERCOMPANYID
};
switch (sType)
{
case 0:
ents = from k in dal.GetObjects <T_HR_KPIRECORDCOMPLAIN>()
join o in dal.GetObjects <T_HR_KPIRECORD>().Include("T_HR_KPIPOINT") on k.T_HR_KPIRECORD.KPIRECORDID equals o.KPIRECORDID
join b in dal.GetObjects <T_HR_EMPLOYEE>() on o.APPRAISEEID equals b.EMPLOYEEID
join ep in dal.GetObjects <T_HR_EMPLOYEEPOST>() on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
join p in dal.GetObjects <T_HR_POST>() on ep.T_HR_POST.POSTID equals p.POSTID
join d in dal.GetObjects <T_HR_DEPARTMENT>() on p.T_HR_DEPARTMENT.DEPARTMENTID equals d.DEPARTMENTID
join c in dal.GetObjects <T_HR_COMPANY>() on d.T_HR_COMPANY.COMPANYID equals c.COMPANYID
//join f in dal.GetObjects<T_HR_KPIPOINT>() on o.T_HR_KPIPOINT.KPIPOINTID equals f.KPIPOINTID into TEMPKPI
//from e in TEMPKPI.DefaultIfEmpty()
where c.COMPANYID == sValue
select new V_COMPLAINRECORD
{
T_HR_KPIRECORDCOMPLAIN = k,
T_HR_KPIRECORD = o,
FLOWID = o.T_HR_KPIPOINT.FLOWID,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
CREATEUSERID = o.CREATEUSERID,
OWNERID = o.OWNERID,
OWNERPOSTID = o.OWNERPOSTID,
OWNERDEPARTMENTID = o.OWNERDEPARTMENTID,
OWNERCOMPANYID = o.OWNERCOMPANYID
};
break;
case 1:
ents = from k in dal.GetObjects <T_HR_KPIRECORDCOMPLAIN>()
join o in dal.GetObjects <T_HR_KPIRECORD>().Include("T_HR_KPIPOINT") on k.T_HR_KPIRECORD.KPIRECORDID equals o.KPIRECORDID
join b in dal.GetObjects <T_HR_EMPLOYEE>() on o.APPRAISEEID equals b.EMPLOYEEID
join ep in dal.GetObjects <T_HR_EMPLOYEEPOST>() on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
join p in dal.GetObjects <T_HR_POST>() on ep.T_HR_POST.POSTID equals p.POSTID
join d in dal.GetObjects <T_HR_DEPARTMENT>() on p.T_HR_DEPARTMENT.DEPARTMENTID equals d.DEPARTMENTID
//join f in dal.GetObjects<T_HR_KPIPOINT>() on o.T_HR_KPIPOINT.KPIPOINTID equals f.KPIPOINTID into TEMPKPI
//from e in TEMPKPI.DefaultIfEmpty()
where d.DEPARTMENTID == sValue
select new V_COMPLAINRECORD
{
T_HR_KPIRECORDCOMPLAIN = k,
T_HR_KPIRECORD = o,
FLOWID = o.T_HR_KPIPOINT.FLOWID,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
CREATEUSERID = o.CREATEUSERID,
OWNERID = o.OWNERID,
OWNERPOSTID = o.OWNERPOSTID,
OWNERDEPARTMENTID = o.OWNERDEPARTMENTID,
OWNERCOMPANYID = o.OWNERCOMPANYID
};
break;
case 2:
ents = from k in dal.GetObjects <T_HR_KPIRECORDCOMPLAIN>()
join o in dal.GetObjects <T_HR_KPIRECORD>().Include("T_HR_KPIPOINT") on k.T_HR_KPIRECORD.KPIRECORDID equals o.KPIRECORDID
join b in dal.GetObjects <T_HR_EMPLOYEE>() on o.APPRAISEEID equals b.EMPLOYEEID
join ep in dal.GetObjects <T_HR_EMPLOYEEPOST>() on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
join p in dal.GetObjects <T_HR_POST>() on ep.T_HR_POST.POSTID equals p.POSTID
//join f in dal.GetObjects<T_HR_KPIPOINT>() on o.T_HR_KPIPOINT.KPIPOINTID equals f.KPIPOINTID into TEMPKPI
//from e in TEMPKPI.DefaultIfEmpty()
where p.POSTID == sValue
select new V_COMPLAINRECORD
{
T_HR_KPIRECORDCOMPLAIN = k,
T_HR_KPIRECORD = o,
FLOWID = o.T_HR_KPIPOINT.FLOWID,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
CREATEUSERID = o.CREATEUSERID,
OWNERID = o.OWNERID,
OWNERPOSTID = o.OWNERPOSTID,
OWNERDEPARTMENTID = o.OWNERDEPARTMENTID,
OWNERCOMPANYID = o.OWNERCOMPANYID
};
break;
}
if (!string.IsNullOrEmpty(startDate))
{
DateTime sTime = Convert.ToDateTime(startDate);
ents = ents.Where(s => s.T_HR_KPIRECORD.UPDATEDATE >= sTime);
}
if (!string.IsNullOrEmpty(endDate))
{
DateTime eTime = Convert.ToDateTime(endDate).AddDays(1);
ents = ents.Where(s => s.T_HR_KPIRECORD.UPDATEDATE <= eTime);
}
//if (!string.IsNullOrEmpty(strCheckState))
//{
// if (!string.IsNullOrEmpty(filterString))
// {
// filterString += " AND";
// }
// filterString += " T_HR_KPIRECORDCOMPLAIN.CHECKSTATE == @" + queryParas.Count();
// queryParas.Add(strCheckState);
//}
if (!string.IsNullOrEmpty(filterString))
{
ents = ents.Where(filterString, queryParas.ToArray());
}
ents = ents.OrderBy(sort);
ents = Utility.Pager <V_COMPLAINRECORD>(ents, pageIndex, pageSize, ref pageCount);
return(ents);
}
// 1e
// 1s
//public IQueryable<T_HR_KPIRECORD> GetKPIRecordPaging(int pageIndex, int pageSize, string sort, string filterString, string[] paras, ref int pageCount, string sType, string sValue, string userID)
//{
// List<object> queryParas = new List<object>();
// queryParas.AddRange(paras);
// //SetOrganizationFilter(ref filterString, ref queryParas, userID, "T_HR_KPIRECORD");
// //员工入职审核通过再显示。
// ///TOADD:员工编辑状态为生效 EDITSTATE==Convert.ToInt32(EditStates.Actived).ToString();
// ///
// IQueryable<T_HR_KPIRECORD> ents = DataContext.T_HR_KPIRECORD.Include("T_HR_KPIPOINT");
// switch (sType)
// {
// case "Company":
// ents = from o in DataContext.T_HR_KPIRECORD.Include("T_HR_KPIPOINT")
// join ep in DataContext.T_HR_EMPLOYEEPOST on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
// join p in DataContext.T_HR_POST on ep.T_HR_POST.POSTID equals p.POSTID
// join d in DataContext.T_HR_DEPARTMENT on p.T_HR_DEPARTMENT.DEPARTMENTID equals d.DEPARTMENTID
// join c in DataContext.T_HR_COMPANY on d.T_HR_COMPANY.COMPANYID equals c.COMPANYID
// where c.COMPANYID == sValue
// select o;
// break;
// case "Department":
// ents = from o in DataContext.T_HR_KPIRECORD.Include("T_HR_KPIPOINT")
// join ep in DataContext.T_HR_EMPLOYEEPOST on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
// join p in DataContext.T_HR_POST on ep.T_HR_POST.POSTID equals p.POSTID
// join d in DataContext.T_HR_DEPARTMENT on p.T_HR_DEPARTMENT.DEPARTMENTID equals d.DEPARTMENTID
// where d.DEPARTMENTID == sValue
// select o;
// break;
// case "Post":
// ents = from o in DataContext.T_HR_KPIRECORD.Include("T_HR_KPIPOINT")
// join ep in DataContext.T_HR_EMPLOYEEPOST on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
// join p in DataContext.T_HR_POST on ep.T_HR_POST.POSTID equals p.POSTID
// where p.POSTID == sValue
// select o;
// break;
// }
// if (!string.IsNullOrEmpty(filterString))
// {
// ents = ents.Where(filterString, queryParas.ToArray());
// }
// ents = ents.OrderBy(sort);
// ents = Utility.Pager<T_HR_KPIRECORD>(ents, pageIndex, pageSize, ref pageCount);
// return ents;
//}
/// <summary>
/// 根据参数获取KPI明细记录
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="sort"></param>
/// <param name="filterString"></param>
/// <param name="paras"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public IQueryable <V_KPIRECORD> GetKPIRecordPaging(int pageIndex, int pageSize, string sort, string filterString, string[] paras, ref int pageCount, string sType, string sValue, string userID, string startDate, string endDate, string strCheckState)
{
List <object> queryParas = new List <object>();
queryParas.AddRange(paras);
SetOrganizationFilter(ref filterString, ref queryParas, userID, "T_HR_KPIRECORD");
//员工入职审核通过再显示。
///TOADD:员工编辑状态为生效 EDITSTATE==Convert.ToInt32(EditStates.Actived).ToString();
///
var ents = from a in dal.GetObjects <T_HR_KPIRECORD>()
join b in dal.GetObjects <T_HR_EMPLOYEE>() on a.APPRAISEEID equals b.EMPLOYEEID
join d in dal.GetObjects <T_HR_KPIPOINT>() on a.T_HR_KPIPOINT.KPIPOINTID equals d.KPIPOINTID into TEMPKPI
from e in TEMPKPI.DefaultIfEmpty()
select new V_KPIRECORD
{
T_HR_KPIRECORD = a,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
KPIPOINTREMARK = a.KPIDESCRIPTION,
FLOWID = a.FLOWDESCRIPTION,
CREATEUSERID = a.CREATEUSERID,
OWNERID = a.OWNERID,
OWNERPOSTID = a.OWNERPOSTID,
OWNERDEPARTMENTID = a.OWNERDEPARTMENTID,
OWNERCOMPANYID = a.OWNERCOMPANYID
};
switch (sType)
{
case "Company":
ents = from o in dal.GetObjects <T_HR_KPIRECORD>()
join b in dal.GetObjects <T_HR_EMPLOYEE>() on o.APPRAISEEID equals b.EMPLOYEEID
join ep in dal.GetObjects <T_HR_EMPLOYEEPOST>() on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
join p in dal.GetObjects <T_HR_POST>() on ep.T_HR_POST.POSTID equals p.POSTID
join d in dal.GetObjects <T_HR_DEPARTMENT>() on p.T_HR_DEPARTMENT.DEPARTMENTID equals d.DEPARTMENTID
join c in dal.GetObjects <T_HR_COMPANY>() on d.T_HR_COMPANY.COMPANYID equals c.COMPANYID
join f in dal.GetObjects <T_HR_KPIPOINT>() on o.T_HR_KPIPOINT.KPIPOINTID equals f.KPIPOINTID into TEMPKPI
from e in TEMPKPI.DefaultIfEmpty()
where c.COMPANYID == sValue && ep.ISAGENCY == "0" && ep.EDITSTATE == "1"
select new V_KPIRECORD
{
T_HR_KPIRECORD = o,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
KPIPOINTREMARK = o.KPIDESCRIPTION,
FLOWID = o.FLOWDESCRIPTION,
CREATEUSERID = o.CREATEUSERID,
OWNERID = o.OWNERID,
OWNERPOSTID = o.OWNERPOSTID,
OWNERDEPARTMENTID = o.OWNERDEPARTMENTID,
OWNERCOMPANYID = o.OWNERCOMPANYID
};
break;
case "Department":
ents = from o in dal.GetObjects <T_HR_KPIRECORD>().Include("T_HR_KPIPOINT")
join b in dal.GetObjects <T_HR_EMPLOYEE>() on o.APPRAISEEID equals b.EMPLOYEEID
join ep in dal.GetObjects <T_HR_EMPLOYEEPOST>() on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
join p in dal.GetObjects <T_HR_POST>() on ep.T_HR_POST.POSTID equals p.POSTID
join d in dal.GetObjects <T_HR_DEPARTMENT>() on p.T_HR_DEPARTMENT.DEPARTMENTID equals d.DEPARTMENTID
join f in dal.GetObjects <T_HR_KPIPOINT>() on o.T_HR_KPIPOINT.KPIPOINTID equals f.KPIPOINTID into TEMPKPI
from e in TEMPKPI.DefaultIfEmpty()
where d.DEPARTMENTID == sValue && ep.ISAGENCY == "0" && ep.EDITSTATE == "1"
select new V_KPIRECORD
{
T_HR_KPIRECORD = o,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
KPIPOINTREMARK = o.KPIDESCRIPTION,
FLOWID = o.FLOWDESCRIPTION,
CREATEUSERID = o.CREATEUSERID,
OWNERID = o.OWNERID,
OWNERPOSTID = o.OWNERPOSTID,
OWNERDEPARTMENTID = o.OWNERDEPARTMENTID,
OWNERCOMPANYID = o.OWNERCOMPANYID
};
break;
case "Post":
ents = from o in dal.GetObjects <T_HR_KPIRECORD>().Include("T_HR_KPIPOINT")
join b in dal.GetObjects <T_HR_EMPLOYEE>() on o.APPRAISEEID equals b.EMPLOYEEID
join ep in dal.GetObjects <T_HR_EMPLOYEEPOST>() on o.APPRAISEEID equals ep.T_HR_EMPLOYEE.EMPLOYEEID
join p in dal.GetObjects <T_HR_POST>() on ep.T_HR_POST.POSTID equals p.POSTID
join f in dal.GetObjects <T_HR_KPIPOINT>() on o.T_HR_KPIPOINT.KPIPOINTID equals f.KPIPOINTID into TEMPKPI
from e in TEMPKPI.DefaultIfEmpty()
where p.POSTID == sValue && ep.ISAGENCY == "0" && ep.EDITSTATE == "1"
select new V_KPIRECORD
{
T_HR_KPIRECORD = o,
EMPLOYEECODE = b.EMPLOYEECODE,
EMPLOYEECNAME = b.EMPLOYEECNAME,
KPIPOINTREMARK = o.KPIDESCRIPTION,
FLOWID = o.FLOWDESCRIPTION,
CREATEUSERID = o.CREATEUSERID,
OWNERID = o.OWNERID,
OWNERPOSTID = o.OWNERPOSTID,
OWNERDEPARTMENTID = o.OWNERDEPARTMENTID,
OWNERCOMPANYID = o.OWNERCOMPANYID
};
break;
}
if (!string.IsNullOrEmpty(startDate))
{
DateTime sTime = Convert.ToDateTime(startDate);
ents = ents.Where(s => s.T_HR_KPIRECORD.UPDATEDATE >= sTime);
}
if (!string.IsNullOrEmpty(endDate))
{
DateTime eTime = Convert.ToDateTime(endDate).AddDays(1);
ents = ents.Where(s => s.T_HR_KPIRECORD.UPDATEDATE <= eTime);
}
if (!string.IsNullOrEmpty(strCheckState))
{
if (!string.IsNullOrEmpty(filterString))
{
filterString += " AND";
}
filterString += " T_HR_KPIRECORD.COMPLAINSTATUS == @" + queryParas.Count();
queryParas.Add(strCheckState);
}
if (!string.IsNullOrEmpty(filterString))
{
ents = ents.Where(filterString, queryParas.ToArray());
}
ents = ents.OrderBy(sort);
ents = Utility.Pager <V_KPIRECORD>(ents, pageIndex, pageSize, ref pageCount);
return(ents);
}
