static void Main(string[] args)
{
//连接数据库
SqlConnection conn = MyHelper.GetConnection();
DevExpress.Xpo.XpoDefault.DataLayer = CreateThreadSafeDataLayer(conn);
DevExpress.Xpo.Session.DefaultSession.Connection = conn;
Console.WriteLine("正在同步薪酬体系....");
SalaryPlan.SychSalaryPlan();
Console.WriteLine("正在同步薪等....");
SalaryGrade.SychSalaryGrade();
Console.WriteLine("正在同步薪级....");
SalaryStep.SychSalaryStep();
Console.WriteLine("正在同步员工基本信息....");
EmployeeInfo.SychEmployeeInfo();
Console.WriteLine("正在同步工资表....");
SalaryResult.SychSalaryResult();
Console.WriteLine("正在清理无效的月薪记录....");
MonthlySalary.ClearInvalidRecord();
Console.WriteLine("正在同步绩效考核结果....");
KpiItem.SychKpiItem();
Console.WriteLine("同步完毕！");
//Console.WriteLine("按任意键退出...");
//Console.ReadKey(true);
}
public ActionResult DeleteConfirmed(int id)
{
SalaryGrade salarygrade = db.SalaryGrades.Find(id);
db.SalaryGrades.Remove(salarygrade);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SalaryGradeID,Salary,Grade")] SalaryGrade salarygrade)
{
if (ModelState.IsValid)
{
db.Entry(salarygrade).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salarygrade));
}
public ActionResult Create([Bind(Include = "SalaryGradeID,Salary,Grade")] SalaryGrade salarygrade)
{
if (ModelState.IsValid)
{
db.SalaryGrades.Add(salarygrade);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salarygrade));
}
// GET: /Salary/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalaryGrade salarygrade = db.SalaryGrades.Find(id);
if (salarygrade == null)
{
return(HttpNotFound());
}
return(View(salarygrade));
}
private void btn同步员工信息_Click(object sender, EventArgs e)
{
if (MessageBox.Show("同步需要几分钟甚至更长，过程中请不可进行其他操作，确实要立即同步吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2, 0, false) == DialogResult.Yes)
{
CreateWaitDialog("正在同步薪酬体系....", "请稍等");
SalaryPlan.SychSalaryPlan();
CreateWaitDialog("正在同步薪等....", "请稍等");
SalaryGrade.SychSalaryGrade();
CreateWaitDialog("正在同步薪级....", "请稍等");
SalaryStep.SychSalaryStep();
CreateWaitDialog("正在同步员工基本信息....", "请耐心等待");
EmployeeInfo.SychEmployeeInfo();
CloseWaitDialog();
}
}
public SettingRegRespObj AddSalaryGrade(RegSalaryGradeObj regObj)
{
var response = new SettingRegRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage()
}
};
try
{
if (regObj.Equals(null))
{
response.Status.Message.FriendlyMessage = "Error Occurred! Unable to proceed with your request";
response.Status.Message.TechnicalMessage = "Registration Object is empty / invalid";
return(response);
}
if (!EntityValidatorHelper.Validate(regObj, out var valResults))
{
var errorDetail = new StringBuilder();
if (!valResults.IsNullOrEmpty())
{
errorDetail.AppendLine("Following error occurred:");
valResults.ForEachx(m => errorDetail.AppendLine(m.ErrorMessage));
}
else
{
errorDetail.AppendLine(
"Validation error occurred! Please check all supplied parameters and try again");
}
response.Status.Message.FriendlyMessage = errorDetail.ToString();
response.Status.Message.TechnicalMessage = errorDetail.ToString();
response.Status.IsSuccessful = false;
return(response);
}
//if (!HelperMethods.IsUserValid(regObj.AdminUserId, regObj.SysPathCode, HelperMethods.getSeniorAccountant(), ref response.Status.Message))
//{
// return response;
//}
if (IsSalaryGradeDuplicate(regObj.Name, 1, ref response))
{
return(response);
}
var salaryGrade = new SalaryGrade
{
Name = regObj.Name,
Status = (ItemStatus)regObj.Status
};
var added = _repository.Add(salaryGrade);
_uoWork.SaveChanges();
if (added.SalaryGradeId < 1)
{
response.Status.Message.FriendlyMessage =
"Error Occurred! Unable to complete your request. Please try again later";
response.Status.Message.TechnicalMessage = "Unable to save to database";
return(response);
}
resetCache();
response.Status.IsSuccessful = true;
response.SettingId = added.SalaryGradeId;
}
catch (DbEntityValidationException ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
return(response);
}
