// Employee/GetEmployeeList
public ActionResult GetEmployeeList(EmployeeInfo employeeInfo)
{
List <EmployeeInfo> list = new Manager.EmployeeManager().GetEmployees(employeeInfo);
JsonResult jsonResult = Json(list);
return(jsonResult);
}
// Company/GetCompany?id=
public ActionResult GetCompany(int id)
{
CompanyInfo company = new Manager.EmployeeManager().GetCompany(id);
JsonResult jsonResult = Json(company, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
// Company/GetCompanyList?query=
public ActionResult GetCompanyList(string query)
{
List <CompanyInfo> list = new Manager.EmployeeManager().GetCompanies(query);
JsonResult jsonResult = Json(list);
return(jsonResult);
}
public ActionResult exportSimple(EmployeeInfo employeeInfo)
{
IExcel excel = ExcelFactory.CreateDefault();
DataSet ds = new Manager.EmployeeManager().GetSimpleEmployees();
POIStream stream = new POIStream();
stream.AllowClose = false;
excel.Write(stream, ds, ExcelExtendType.XLSX);
stream.AllowClose = true;
byte[] buffer = new byte[stream.Length];
stream.Position = 0;
stream.Read(buffer, 0, buffer.Length);
stream.Close();
HttpResponse context = System.Web.HttpContext.Current.Response;
try
{
context.ContentType = "application/ms-excel";
context.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xlsx", HttpUtility.UrlEncode("人员清单", System.Text.Encoding.UTF8)));
context.BinaryWrite(buffer);
context.Flush();
context.End();
}
catch (Exception ex)
{
context.ContentType = "text/plain";
context.Write(ex.Message);
}
return(null);
}
public ActionResult GetRetireIsEndEmployeeList()
{
List <EmployeeInfo> list = new Manager.EmployeeManager().GetRetireBeEndingEmployees();
JsonResult jsonResult = Json(list);
jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(jsonResult);
}
// Company/QueryCompanyList?q=
public ActionResult QueryCompanyList(string q)
{
if (String.IsNullOrEmpty(q))
{
return(null);
}
List <CompanyInfo> list = new Manager.EmployeeManager().GetCompanies(q);
JsonResult jsonResult = Json(list);
return(jsonResult);
}
public ActionResult DeleteCompany(int id)
{
bool pass = new Manager.EmployeeManager().DeleteCompany(id);
Object result = new
{
success = pass,
data = pass?"删除成功": "删除失败，数据可能已经被引用。"
};
JsonResult jsonResult = Json(result, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public ActionResult SaveCompany(CompanyInfo companyInfo)
{
CompanyInfo ci = new Manager.EmployeeManager().SaveCompany(companyInfo);
Object result = new
{
success = ci == null?false:true,
data = ci == null?0:ci.CompanyId
};
JsonResult jsonResult = Json(result, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public ActionResult DeletePosition(CompanyPositionSetInfo positionSetInfo)
{
bool pass = new Manager.EmployeeManager().DeletePostion(positionSetInfo);
Object result = new
{
success = pass,
data = pass ? "成功" : "失败"
};
JsonResult jsonResult = Json(result, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public ActionResult GetEmployee(int personId)
{
EmployeeInfo employeeInfo = new EmployeeInfo();
if (personId > 0)
{
employeeInfo = new Manager.EmployeeManager().GetEmployee(personId);
}
JsonResult jsonResult = Json(employeeInfo, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public ActionResult DeleteEmployee(int personId)
{
bool pass = new Manager.EmployeeManager().DeleteEmployee(personId);
Object result = new
{
success = pass,
data = pass ? "删除成功" : "删除失败，系统限制不允许删除！"
};
JsonResult jsonResult = Json(result, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public ActionResult Export()
{
List <CompanyInfo> list = new Manager.EmployeeManager().GetCompanies(string.Empty);
IExcel excel = ExcelFactory.CreateDefault();
DataTable dataTable = Converts.ListToDataTable <CompanyInfo>(list);
dataTable.Columns["Name"].Caption = "单位名称";
dataTable.Columns["Code"].Caption = "组织机构代码";
dataTable.Columns["Representative"].Caption = "法人";
dataTable.Columns["AccountBalance"].Caption = "账户余额";
dataTable.Columns.Remove("CompanyId");
dataTable.Columns.Remove("AccountId");
dataTable.Columns.Remove("Positions");
dataTable.Columns.Remove("Remark");
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);
POIStream stream = new POIStream();
stream.AllowClose = false;
excel.Write(stream, dataSet, ExcelExtendType.XLSX);
stream.AllowClose = true;
byte[] buffer = new byte[stream.Length];
stream.Position = 0;
stream.Read(buffer, 0, buffer.Length);
stream.Dispose();
HttpResponse context = System.Web.HttpContext.Current.Response;
try
{
context.ContentType = "application/ms-excel";
context.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xlsx", HttpUtility.UrlEncode("单位信息", System.Text.Encoding.UTF8)));
context.BinaryWrite(buffer);
context.Flush();
context.End();
}
catch (Exception ex)
{
context.ContentType = "text/plain";
context.Write(ex.Message);
}
return(null);
}
public ActionResult SaveEmployee(EmployeeInfo employeeInfo)
{
Object result;
string message = string.Empty;
// 输入校验
bool validate = true;
#region 验证
DateTime dateTime;
if (!string.IsNullOrEmpty(employeeInfo.Birthday))
{
if (DateTime.TryParse(employeeInfo.Birthday, out dateTime))
{
employeeInfo.Birthday = dateTime.ToString("yyyy-MM-dd");
}
else
{
message += " 出生日期格式不正确.";
validate = false;
}
}
if (!string.IsNullOrEmpty(employeeInfo.JoinWorkTime))
{
if (DateTime.TryParse(employeeInfo.JoinWorkTime, out dateTime))
{
employeeInfo.JoinWorkTime = dateTime.ToString("yyyy-MM-dd");
}
else
{
message += " 参工日期格式不正确.";
validate = false;
}
}
if (!string.IsNullOrEmpty(employeeInfo.LeaveTime))
{
if (DateTime.TryParse(employeeInfo.LeaveTime, out dateTime))
{
employeeInfo.LeaveTime = dateTime.ToString("yyyy-MM-dd");
}
else
{
message += " 离职日期格式不正确.";
validate = false;
}
}
if (!string.IsNullOrEmpty(employeeInfo.ContractTime))
{
if (DateTime.TryParse(employeeInfo.ContractTime, out dateTime))
{
employeeInfo.ContractTime = dateTime.ToString("yyyy-MM-dd");
}
else
{
message += " 合同日期格式不正确.";
validate = false;
}
}
if (!string.IsNullOrEmpty(employeeInfo.RetireTime))
{
if (DateTime.TryParse(employeeInfo.RetireTime, out dateTime))
{
employeeInfo.RetireTime = dateTime.ToString("yyyy-MM-dd");
}
else
{
message += " 退休日期格式不正确.";
validate = false;
}
}
#endregion
// 如果停用，服务费强制改为0
if (employeeInfo.State == 1)
{
employeeInfo.ServiceFee = 0;
}
if (validate)
{
bool pass = new Manager.EmployeeManager().SaveEmployee(employeeInfo);
result = new
{
success = pass,
data = pass ? employeeInfo.PersonId : 0
};
}
else
{
result = new
{
success = false,
data = message
};
}
JsonResult jsonResult = Json(result, JsonRequestBehavior.AllowGet);
return(jsonResult);
}