/// <summary>
/// 接口执行方法
/// </summary>
protected override void ExecuteMethod()
{
EnterpriseStaff StaffModel = null;
///当前请求企业ID大于0的加入企业ID
if (this.Parameter.EnterpriseId > 0)
{
if (StaffModel == null)
{
StaffModel = new EnterpriseStaff();
}
StaffModel.EnterpriseId = this.Parameter.EnterpriseId != null ? (long)this.Parameter.EnterpriseId : 0;
}
//当前员工姓名不为空加入员工姓名为请求条件
if (!String.IsNullOrEmpty(this.Parameter.StaffName))
{
if (StaffModel == null)
{
StaffModel = new EnterpriseStaff();
}
StaffModel.StaffName = this.Parameter.StaffName;
}
if (!String.IsNullOrEmpty(this.Parameter.PayCenterCode))
{
if (StaffModel == null)
{
StaffModel = new EnterpriseStaff();
}
StaffModel.PayCenterCode = this.Parameter.PayCenterCode;
}
this.Result.Data = EpRep.QueryStaffList(Parameter.PageIndex, Parameter.PageSize, StaffModel);
}
protected override void ExecuteMethod()
{
EnterpriseStaff StaffModel = new EnterpriseStaff
{
ID = Parameter.ID,
StaffName = Parameter.StaffName,
IdentificationNumber = Parameter.IdentificationNumber,
DocumentType = Parameter.DocumentType,
PhoneNumber = Parameter.PhoneNumber,
SubsidiaryDepartment = Parameter.SubsidiaryDepartment,
JobPosition = Parameter.JobPosition,
IsJob = Parameter.IsJob
};
Result.Data = EpRep.UpdateStaff(StaffModel);
}
/// <summary>
/// 编辑更新员工
/// </summary>
/// <param name="model">修改员工对象</param>
/// <returns></returns>
public int UpdateStaff(EnterpriseStaff model)
{
using (var db = CgtTravelDB.GetInstance())
{
var StaffModel = db.Single <EnterpriseStaff>(model.ID);
StaffModel.StaffName = model.StaffName;
StaffModel.IdentificationNumber = model.IdentificationNumber;
StaffModel.DocumentType = model.DocumentType;
StaffModel.PhoneNumber = model.PhoneNumber;
StaffModel.SubsidiaryDepartment = model.SubsidiaryDepartment;
StaffModel.JobPosition = model.JobPosition;
StaffModel.IsJob = model.IsJob;
return(db.Update(StaffModel));
}
}
/// <summary>
/// 查询企业员工白名单列表
/// </summary>
/// <param name="PageIndex">当前页码</param>
/// <param name="PageSize">页面尺寸</param>
/// <param name="model">查询条件</param>
/// <returns></returns>
public Page <EnterpriseStaff> QueryStaffList(int PageIndex, int PageSize, EnterpriseStaff model = null)
{
string sqlwhere = "";
if (model != null && model.EnterpriseId > 0)
{
sqlwhere += " and EnterpriseId=@0";
}
if (model != null && !String.IsNullOrEmpty(model.StaffName))
{
sqlwhere += " and StaffName=@1";
}
if (model != null && !String.IsNullOrEmpty(model.PayCenterCode))
{
sqlwhere += " and PayCenterCode=@2";
}
using (var db = CgtTravelDB.GetInstance())
{
var page = db.Page <EnterpriseStaff>(PageIndex, PageSize, "select a.*,b.EnterpriseName,b.PayCenterCode from dbo.EnterpriseStaff a INNER JOIN dbo.EnterpriseWhiteList b ON a.EnterpriseId=b.EnterpriseWhiteListID where 1=1 " + sqlwhere + " ORDER BY ID DESC ", model?.EnterpriseId, model?.StaffName, model?.PayCenterCode);
return(page);
}
}
/// <summary>
/// 查询企业员工白名单列表
/// </summary>
/// <param name="model">查询条件</param>
/// <returns></returns>
public List <EnterpriseStaff> QueryStaffList(EnterpriseStaff model = null)
{
List <EnterpriseStaff> list = new List <EnterpriseStaff>();
string sqlwhere = "";
if (model != null && model.EnterpriseId > 0)
{
sqlwhere += " and EnterpriseId=@0";
}
if (model != null && !String.IsNullOrEmpty(model.StaffName))
{
sqlwhere += " and StaffName=@1";
}
if (model != null && !String.IsNullOrEmpty(model.PayCenterCode))
{
sqlwhere += " and PayCenterCode=@2";
}
using (var db = CgtTravelDB.GetInstance())
{
list = db.Fetch <EnterpriseStaff>("select a.*,b.EnterpriseName,b.PayCenterCode from dbo.EnterpriseStaff a INNER JOIN dbo.EnterpriseWhiteList b ON a.EnterpriseId=b.EnterpriseWhiteListID where 1=1 " + sqlwhere + " ORDER BY ID DESC ", model?.EnterpriseId, model?.StaffName, model?.PayCenterCode);
return(list);
}
}
/// <summary>
/// 执行方法
/// </summary>
protected override void ExecuteMethod()
{
//导出Excel数据
var table = Excel.ExcelImport(file.OpenReadStream());
//去除表头
table.rows.Remove(table.rows.FirstOrDefault());
//组织批量数据库实体
List <EnterpriseStaff> DataList = new List <EnterpriseStaff>();
foreach (var item in table.rows)
{
byte i = 1;
byte p = 0;
if (!string.IsNullOrWhiteSpace(item.columns.ElementAt(0).ColumnValue))
{
var EnterpriseStaffModel = new EnterpriseStaff
{
EnterpriseId = Parameter.EnterpriseId,
StaffName = Convert(item.columns.ElementAt(0).ColumnValue),
PhoneNumber = Convert(item.columns.ElementAt(1).ColumnValue),
IdentificationNumber = Convert(item.columns.ElementAt(2).ColumnValue),
IsJob = TranIsJob(item.columns.ElementAt(3).ColumnValue.Trim()),
SubsidiaryDepartment = Convert(item.columns.ElementAt(4).ColumnValue),
JobPosition = Convert(item.columns.ElementAt(5).ColumnValue),
DocumentType = 1,
CreateTime = DateTime.Now,
ModifyTime = DateTime.Now,
Modifier = Parameter.UserId
};
DataList.Add(EnterpriseStaffModel);
}
}
//数据库批量插入
this.Result.Data = EpRep.AddStaffList(DataList);
}
