/// <summary>
/// 获取全部员工实体列表
/// </summary>
/// <returns></returns>
public List <PersonnelInfo> QueryEmployees()
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.strConn))
{
var result = from item in oContext.PersonnelInfo
orderby item.id descending
select item;
return(result.ToList());
}
}
/// <summary>
/// 判断工资是否已审核
/// </summary>
/// <param name="gatherID"></param>
/// <returns></returns>
public bool IsAssess(long gatherID)
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.oSqlHelper.SqlConn))
{
var result = (from item in oContext.PayOffGather2
where item.pogid == gatherID && item.assessor != null
select item);
return(result.Count() > 0);
}
}
/// <summary>
/// 查询指定模板名称的模板
/// </summary>
/// <param name="strName">模板名称</param>
/// <returns></returns>
public SalaryItemTemplet Query(string strName)
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.strConn))
{
var result = (from item in oContext.SalaryItemTemplet
where item.name == strName
select item).FirstOrDefault();
return(result);
}
}
public PersonnelInfo QueryEmployeeByID(long id)
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.strConn))
{
var result = from item in oContext.PersonnelInfo
where item.id == id
select item;
return(result.FirstOrDefault());
}
}
/// <summary>
/// 查询全部生产班组信息
/// </summary>
/// <returns></returns>
public List <ProduceTeam> QueryYieldGroups()
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.strConn))
{
var options = new System.Data.Linq.DataLoadOptions();
options.LoadWith <ProduceTeam>(p => p.Department);
options.LoadWith <ProduceTeam>(p => p.EquipmentInformation);
oContext.LoadOptions = options;
var result = from item in oContext.ProduceTeam
select item;
return(result.ToList());
}
}
public static decimal?QueryBase(int iHumanID)
{
using (SqlHelper oHelper = new SqlHelper())
{
using (HumanResourceDataContext oHumanContext = new HumanResourceDataContext(oHelper.SqlConn))
{
oHumanContext.ObjectTrackingEnabled = false;
var result = from item in oHumanContext.PersonnelInfo
where item.id == iHumanID
select item.basicSalary;
return(result.FirstOrDefault());
}
}
}
/// <summary>
/// 更新员工
/// </summary>
/// <param name="entity"></param>
public void Update(PersonnelInfo entity)
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.strConn))
{
PersonnelInfo ori = (from p in oContext.PersonnelInfo
where p.id == entity.id
select p).First();
ori.no = entity.no;
ori.name = entity.name;
ori.address = entity.address;
ori.basicSalary = entity.basicSalary;
ori.birthday = entity.birthday;
ori.competencyCertificate = entity.competencyCertificate;
ori.contactMethod = entity.contactMethod;
ori.contractNo = entity.contractNo;
ori.dId = entity.dId;
ori.dimissionDate = entity.dimissionDate;
ori.dimissionReason = entity.dimissionReason;
ori.function = entity.function;
ori.functionAssessDate = entity.functionAssessDate;
ori.hortationCastigate = entity.hortationCastigate;
ori.IDCard = entity.IDCard;
ori.judgeMarry = entity.judgeMarry;
ori.kind = entity.kind;
ori.mark = entity.mark;
ori.nationality = entity.nationality;
ori.nativePlace = entity.nativePlace;
ori.pId = entity.pId;
ori.politicalVisage = entity.politicalVisage;
ori.ptId = entity.ptId;
ori.remark = entity.remark;
ori.resume = entity.resume;
ori.salaryMethod = entity.salaryMethod;
ori.sex = entity.sex;
ori.specialty = entity.specialty;
ori.startWorkDate = entity.startWorkDate;
ori.tiptopDegree = entity.tiptopDegree;
ori.workDate = entity.workDate;
try
{
oContext.SubmitChanges();
}
catch (System.Data.Linq.ChangeConflictException)
{
throw;
}
}
}
/// <summary>
/// 删除职位信息
/// </summary>
/// <param name="id"></param>
public void DeletePosition(int[] id)
{
HumanResourceDataContext oHumanContext = new HumanResourceDataContext(this.strConn);
var deleting =
from item in oHumanContext.Position
where id.Contains((int)item.id)
select item;
foreach (var item in deleting)
{
oHumanContext.Position.DeleteOnSubmit(item);
}
oHumanContext.SubmitChanges();
}
/*
* 方法名称：QueryTaxBase
* 方法功能描述：获取扣税基数
*
* 创建人：杨林
* 创建时间：2009-03-12
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
/// <summary>
/// 获取扣税基数
/// </summary>
/// <returns></returns>
public static decimal QueryTaxBase()
{
HumanResourceDataContext oHumanContext = new HumanResourceDataContext(new SqlHelper().SqlConn);
try
{
return(decimal.Parse(
(from taxBas in oHumanContext.SalaryParameter
select taxBas.taxBase).First().ToString()
));
}
catch (System.Data.SqlClient.SqlException)
{
throw;
}
}
/// <summary>
/// 判断指定员工名称是否存在
/// </summary>
/// <param name="strName"></param>
/// <returns></returns>
public bool IsExistByName(string strName)
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.strConn))
{
var result = (from item in oContext.PersonnelInfo
where item.name.Trim() == strName.Trim()
select item.id).Count();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public string[] QueryPayrollItemName()
{
HumanResourceDataContext oHumanContext = new HumanResourceDataContext(this.oSqlHelper.SqlConn);
oHumanContext.ObjectTrackingEnabled = false;
var result = from item in oHumanContext.PayrollAdd
select item.name;
try
{
return(result.ToArray <string>());
}
catch (System.Data.SqlClient.SqlException)
{
return(null);
}
}
/// <summary>
/// 判断指定部门编号是否存在
/// </summary>
/// <param name="strNo"></param>
/// <returns></returns>
public bool IsExistByNo(string strNo)
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.strConn))
{
var result = (from item in oContext.Department
where item.no.Trim() == strNo.Trim()
select item.id).Count();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/*
* 方法名称：QueryAllPersonnel
* 方法功能描述：获取全部员工实体数组
*
* 创建人：杨林
* 创建时间：2009-03-12
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
/// <summary>
/// 获取全部员工实体数组
/// </summary>
/// <returns></returns>
public static PersonnelInfo[] QueryAllPersonnel()
{
HumanResourceDataContext oHumanContext = new HumanResourceDataContext(new SqlHelper().SqlConn);
oHumanContext.ObjectTrackingEnabled = false;
var result = from item in oHumanContext.PersonnelInfo
select item;
try
{
return(result.ToArray <PersonnelInfo>());
}
catch (System.Data.SqlClient.SqlException)
{
return(new PersonnelInfo[] { new PersonnelInfo {
name = "读取数据库出错!"
} });
}
}
/// <summary>
/// 审核工资
/// </summary>
/// <param name="gatherID"></param>
public void Assess(long gatherID, bool bPass, string strHumanName)
{
using (HumanResourceDataContext oContext = new HumanResourceDataContext(this.oSqlHelper.SqlConn))
{
PayOffGather2 result;
bool bExist = false;
result = (from item in oContext.PayOffGather2
where item.pogid == gatherID
select item).FirstOrDefault();
if (result == null)
{
result = new PayOffGather2();
result.pogid = gatherID;
}
else
{
bExist = true;
}
if (bPass)
{
result.inputman = strHumanName;
result.assessor = strHumanName;
result.assessordate = DateTime.Now;
result.checkupdate = null;
result.checkupman = null;
}
else
{
result.assessor = null;
result.assessordate = null;
result.checkupdate = null;
result.checkupman = null;
}
if (bExist == false)
{
oContext.PayOffGather2.InsertOnSubmit(result);
}
oContext.SubmitChanges();
}
}
