/// <summary>
/// 创建一个员工费用中间表
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据库上下文</param>
/// <param name="entity">一个员工费用中间表</param>
/// <returns></returns>
public bool Create(ref ValidationErrors validationErrors, EmployeeMiddle entity)
{
try
{
repository.Create(entity);
return(true);
}
catch (Exception ex)
{
validationErrors.Add(ex.Message);
ExceptionsHander.WriteExceptions(ex);
}
return(false);
}
/// <summary>
/// 创建
/// </summary>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public Common.ClientResult.Result Post([FromBody] EmployeeMiddle entity)
{
Common.ClientResult.Result result = new Common.ClientResult.Result();
if (entity != null && ModelState.IsValid)
{
entity.State = Common.Status.启用.ToString();
entity.CreatePerson = LoginInfo.UserName;
entity.CreateTime = DateTime.Now;
string returnValue = string.Empty;
if (m_BLL.Create(ref validationErrors, entity))
{
LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + "，员工费用中间表的信息的Id为" + entity.Id, "员工费用中间表"
);//写入日志
result.Code = Common.ClientCode.Succeed;
result.Message = Suggestion.InsertSucceed;
return(result); //提示创建成功
}
else
{
if (validationErrors != null && validationErrors.Count > 0)
{
validationErrors.All(a =>
{
returnValue += a.ErrorMessage;
return(true);
});
}
LogClassModels.WriteServiceLog(Suggestion.InsertFail + "，员工费用中间表的信息，" + returnValue, "员工费用中间表"
);//写入日志
result.Code = Common.ClientCode.Fail;
result.Message = Suggestion.InsertFail + returnValue;
return(result); //提示插入失败
}
}
result.Code = Common.ClientCode.FindNull;
result.Message = Suggestion.InsertFail + "，请核对输入的数据的格式"; //提示输入的数据的格式不对
return(result);
}
// PUT api/<controller>/5
/// <summary>
/// 编辑
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public Common.ClientResult.Result Put([FromBody] EmployeeMiddle entity)
{
Common.ClientResult.Result result = new Common.ClientResult.Result();
if (entity != null && ModelState.IsValid)
{ //数据校验
EmployeeMiddle Model = m_BLL.GetById(entity.Id);
//Model.Id = entity.Id;
//Model.InsuranceKindId = entity.InsuranceKindId;
//Model.CompanyEmployeeRelationId = entity.CompanyEmployeeRelationId;
Model.PaymentBetween = entity.PaymentBetween;
Model.PaymentStyle = entity.PaymentStyle;
Model.CompanyBasePayment = entity.CompanyBasePayment;
Model.CompanyPayment = entity.CompanyPayment;
Model.EmployeeBasePayment = entity.EmployeeBasePayment;
Model.EmployeePayment = entity.EmployeePayment;
Model.PaymentMonth = entity.PaymentMonth;
Model.StartDate = entity.StartDate;
Model.EndedDate = entity.EndedDate;
Model.UseBetween = entity.UseBetween;
//Model.BillId = entity.BillId;
Model.Remark = entity.Remark;
//Model.State = entity.State;
//Model.CreateTime = entity.CreateTime;
//Model.CreatePerson = entity.CreatePerson;
Model.UpdateTime = entity.UpdateTime;
Model.UpdatePerson = entity.UpdatePerson;
//Model.CityId = entity.CityId;
Model.UpdateTime = DateTime.Now;
Model.UpdatePerson = LoginInfo.UserName;
string returnValue = string.Empty;
if (m_BLL.Edit(ref validationErrors, Model))
{
LogClassModels.WriteServiceLog(Suggestion.UpdateSucceed + "，员工费用中间表信息的Id为" + entity.Id, "员工费用中间表"
);//写入日志
result.Code = Common.ClientCode.Succeed;
result.Message = Suggestion.UpdateSucceed;
return(result); //提示更新成功
}
else
{
if (validationErrors != null && validationErrors.Count > 0)
{
validationErrors.All(a =>
{
returnValue += a.ErrorMessage;
return(true);
});
}
LogClassModels.WriteServiceLog(Suggestion.UpdateFail + "，员工费用中间表信息的Id为" + entity.Id + "," + returnValue, "员工费用中间表"
);//写入日志
result.Code = Common.ClientCode.Fail;
result.Message = Suggestion.UpdateFail + returnValue;
return(result); //提示更新失败
}
}
result.Code = Common.ClientCode.FindNull;
result.Message = Suggestion.UpdateFail + "请核对输入的数据的格式";
return(result); //提示输入的数据的格式不对
}
/// <summary>
/// 根据ID获取数据模型
/// </summary>
/// <param name="id">编号</param>
/// <returns></returns>
public EmployeeMiddle Get(int id)
{
EmployeeMiddle item = m_BLL.GetById(id);
return(item);
}
/// <summary>
/// 报增保险。不更新数据库
/// </summary>
/// <param name="db">实体类</param>
/// <param name="entity">初始值</param>
/// <returns></returns>
public bool CreateEmployee(SysEntities db, EmployeeMiddle entity)
{
repository.Create(db, entity);
return(true);
}
/// <summary>
/// 编辑一个员工费用中间表
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="entity">一个员工费用中间表</param>
/// <returns></returns>
public void Edit(SysEntities db, EmployeeMiddle entity)
{
repository.Edit(db, entity);
}
private List <EmployeeMiddle> CheckImportEmployeeMiddle(DataTable table, ref string message)
{
List <EmployeeMiddleExcelModel> employeeList = new List <EmployeeMiddleExcelModel>();
#region 数据转换
foreach (DataRow dr in table.Rows)
{
EmployeeMiddleExcelModel employee = new EmployeeMiddleExcelModel();
employee.CertificateNumber = dr["证件号码"].ToString().Trim();
employee.Name = dr["姓名"].ToString().Trim();
employee.City = dr["社保缴纳地"].ToString().Trim();
employee.CompanyPayment = dr["企业承担金额"].ToString().Trim();
employee.EmployeePayment = dr["个人承担金额"].ToString().Trim();
employee.Remark = dr["备注"].ToString().Trim();
employeeList.Add(employee);
}
#endregion
string search = string.Empty;
StringBuilder errMessageAll = new StringBuilder();
List <EmployeeMiddle> PostInfoList = new List <EmployeeMiddle>();
string DataForm = "证件号:{0},姓名:{1},的异常信息为:{2}\r\n";
foreach (EmployeeMiddleExcelModel item in employeeList)
{
StringBuilder errMessage = new StringBuilder();
EmployeeMiddle postinfos = new EmployeeMiddle();
CompanyEmployeeRelation cer = new CompanyEmployeeRelation();
#region 基础信息赋值
if (string.IsNullOrEmpty(item.CertificateNumber))
{
errMessage.Append("证件号码为空;\r\n");
}
else
{
cer.EmployeeId = getEmployeeIdByExcel(item, ref errMessage);
}
if (string.IsNullOrEmpty(item.Name))
{
errMessage.Append("姓名为空;\r\n");
}
if (string.IsNullOrEmpty(item.City))
{
errMessage.Append("社保缴纳地为空;\r\n");
}
else
{
cer.CityId = getCityIdByExcel(item, ref errMessage);
postinfos.CityId = cer.CityId;
}
if (cer.EmployeeId != null && !string.IsNullOrWhiteSpace(cer.CityId))
{
postinfos.CompanyEmployeeRelationId = CompanyEmployeeRelationId(cer.EmployeeId, cer.CityId, ref errMessage);
}
if (string.IsNullOrEmpty(item.CompanyPayment))
{
errMessage.Append("企业承担金额为空;\r\n");
}
else
{
decimal wage = 0;
if (decimal.TryParse(item.CompanyPayment, out wage))
{
if (wage <= 0)
{
errMessage.Append("企业承担金额不正确;\r\n");
}
if (!Business.IsNumber(item.CompanyPayment, 32, 2))
{
errMessage.Append("企业承担金额请保留两位小数;\r\n");
}
postinfos.CompanyPayment = wage;
}
else
{
errMessage.Append("企业承担金额不正确;\r\n");
}
}
if (string.IsNullOrEmpty(item.EmployeePayment))
{
errMessage.Append("个人承担金额为空;\r\n");
}
else
{
decimal wage = 0;
if (decimal.TryParse(item.EmployeePayment, out wage))
{
if (wage <= 0)
{
errMessage.Append("个人承担金额不正确;\r\n");
}
if (!Business.IsNumber(item.EmployeePayment, 32, 2))
{
errMessage.Append("个人承担金额请保留两位小数;\r\n");
}
postinfos.EmployeePayment = wage;
}
else
{
errMessage.Append("个人承担金额不正确;\r\n");
}
}
postinfos.Remark = item.Remark;
postinfos.PaymentStyle = (int)Common.EmployeeMiddle_PaymentStyle.正常;
DateTime now = DateTime.Now;
postinfos.PaymentBetween = now.ToString("yyyyMM") + "-" + now.ToString("yyyyMM");
postinfos.UseBetween = 0;
postinfos.StartDate = Convert.ToInt32(now.ToString("yyyyMM"));
postinfos.EndedDate = Convert.ToInt32(now.ToString("yyyyMM"));
postinfos.InsuranceKindId = (int)Common.EmployeeMiddle_InsuranceKind.其他社保费用;
postinfos.State = Common.Status.启用.ToString();
postinfos.CreatePerson = LoginInfo.RealName;
postinfos.CreateTime = DateTime.Now;
PostInfoList.Add(postinfos);
if (!string.IsNullOrWhiteSpace(errMessage.ToString()))
{
errMessageAll.Append(string.Format(DataForm, item.CertificateNumber, item.Name, errMessage.ToString()));
}
#endregion
}
message = errMessageAll.ToString();
return(PostInfoList);
}
