/// <summary>
/// 添加工资发放记录
/// </summary>
/// <param name="_sr"></param>
/// <returns></returns>
public bool AddPayRecord(SalaryRecord _sr)
{
testEntities t = new testEntities();
t.SalaryRecord.Add(_sr);
return(t.SaveChanges() > 0);
}
public void OutputResult(OperateResult or)
{
dynamic listLeaveWarning = or.data;
foreach (var item in listLeaveWarning)
{
SalaryRecord e = new SalaryRecord();
PropertyInfo[] pArray = item.GetType().GetProperties();
Type t = item.GetType();
long id = t.GetProperty("id").GetValue(item);
string name = t.GetProperty("name").GetValue(item);
string number = t.GetProperty("number").GetValue(item);
string departmentName = t.GetProperty("departmentName").GetValue(item);
string postName = t.GetProperty("postName").GetValue(item);
int age = t.GetProperty("age").GetValue(item);
int workAge = t.GetProperty("workAge").GetValue(item);
string resultScore = t.GetProperty("resultScore").GetValue(item);
var content =
$"id: {id}, name:{name}, number:{number}, departmentName:{departmentName}, postName:{postName}, age:{age}, workAge:{workAge}, resultScore:{resultScore}";
Trace.WriteLine("App Trace Case Result >>> " + content);
}
}
public bool AddIntoDB(SalaryRecord record)
{
try
{
OpenConnection();
string query = @"insert into SalaryRecord (idSalaryRecord, salaryRecordDate, total, idAccount) values(@idSalaryRecord, @salaryRecordDate, @total, @idAccount)";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@idSalaryRecord", record.IdSalaryRecord.ToString());
cmd.Parameters.AddWithValue("@salaryRecordDate", record.SalaryRecordDate);
cmd.Parameters.AddWithValue("@total", record.Total.ToString());
cmd.Parameters.AddWithValue("@idAccount", record.IdAccount.ToString());
if (cmd.ExecuteNonQuery() < 1)
{
return(false);
}
else
{
return(true);
}
}
catch
{
return(false);
}
finally
{
CloseConnection();
}
}
public OperateResult Update(SalaryRecord model)
{
using (SystemDB db = new SystemDB())
{
try
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public ActionResult RefreshSalary()
{
string data = Request.Params["requestData"];
if (data == null)
{
return(Json(
new OperateResult
{
content = "无数据",
},
JsonRequestBehavior.AllowGet
));
}
JavaScriptSerializer js = new JavaScriptSerializer();
SalaryRecord model = js.Deserialize <SalaryRecord>(data);
if (model == null)
{
return(Json(
new OperateResult
{
content = "无数据",
},
JsonRequestBehavior.AllowGet
));
}
OperateResult or = SalaryRecordManager.RefreshSalary(model);
return(Json(or, JsonRequestBehavior.AllowGet));
}
public SalaryRecord GetSalaryRecordById(string idSalaryRecord)
{
try
{
OpenConnection();
string queryString = "select * from SalaryRecord where idSalaryRecord = " + idSalaryRecord;
SqlCommand command = new SqlCommand(queryString, conn);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
SalaryRecord res = new SalaryRecord(int.Parse(idSalaryRecord), DateTime.Parse(dataTable.Rows[0].ItemArray[1].ToString()),
int.Parse(dataTable.Rows[0].ItemArray[2].ToString()), int.Parse(dataTable.Rows[0].ItemArray[3].ToString()));
return(res);
}
catch
{
return(new SalaryRecord());
}
finally
{
CloseConnection();
}
}
/// <summary>
/// 工资页面
/// </summary>
/// <returns></returns>
public ActionResult Paylist()
{
//查询所有员工
EmployeeDal edal = new EmployeeDal();
List <EmployeeInfo> emlist = edal.GetAllEmployeer();
ViewBag.allem = emlist;
//查询所有员工工资
List <Payroll> allPays = edal.GetPayrolls();
ViewBag.allPays = allPays;
//接收员工id
int id = Convert.ToInt32(Request["id"]);
if (id != 0)
{
List <SalaryRecord> srlist = dal.GetByID(id);
//循环遍历查询‘发放时间’有无与正在发送的时间相同
string ispay = "";
//查询该员工在这月有无发送工资
foreach (var item in srlist)
{
DateTime paytime = (DateTime)item.PayTime;
if (paytime.Year == DateTime.Now.Year && paytime.Month == DateTime.Now.Month)
{
ispay = "已支付";
return(Content("1"));
}
}
//添加工资发送记录
if (ispay == "")
{
//获取该员工的总工资
int salary = Convert.ToInt32(Request["salary"]);
bool isAdd = false;
//增加工资记录
if (id != 0)
{
SalaryRecord sr = new SalaryRecord();
sr.EmployeeId = id;
sr.TotalSalary = salary;
sr.PayTime = DateTime.Now;
//增加发放工资记录
isAdd = dal.AddPayRecord(sr);
if (isAdd)
{
return(Content("0"));
}
}
}
}
return(View());
}
public void UpdateR(SalaryRecord SR)
{
db1.SalaryRecords.Attach(SR);
var update = db1.Entry(SR);
update.Property(x => x.ID).IsModified = true;
update.Property(x => x.FirstName).IsModified = true;
update.Property(x => x.Date).IsModified = true;
update.Property(x => x.IsActive).IsModified = true;
update.Property(x => x.IsDelete).IsModified = true;
update.Property(x => x.LastName).IsModified = true;
update.Property(x => x.Salary).IsModified = true;
}
public ActionResult AddSalaryRecord(SalaryRecord Sr)
{
if (Convert.ToInt32(Request.QueryString["ID"]) != 0 && Request.QueryString["ID"] != null && Request.QueryString["ID"] != "")
{
Sr.ID = Convert.ToInt32(Request.QueryString["ID"]);
new TeachersModel().UpdateR(Sr);
TempData["AlertTask"] = "Record Successfully Update";
}
else
{
new TeachersModel().SaveSR(Sr);
TempData["AlertTask"] = "Record Successfully Saved";
}
return(RedirectToAction("Manage Monthly Salary"));
}
public ActionResult SaveSingle()
{
string month = Request.Params["month"];
if (month == null)
{
return(Json(
new OperateResult
{
content = "请输入考核月",
},
JsonRequestBehavior.AllowGet
));
}
string data = Request.Params["salaryRecord"];
if (data == null)
{
return(Json(
new OperateResult
{
content = "无数据",
},
JsonRequestBehavior.AllowGet
));
}
JavaScriptSerializer js = new JavaScriptSerializer();
SalaryRecord model = js.Deserialize <SalaryRecord>(data);
if (model == null)
{
return(Json(
new OperateResult
{
content = "无数据",
},
JsonRequestBehavior.AllowGet
));
}
SalaryRecordManager manager = new SalaryRecordManager();
OperateResult or = manager.Add(model);
return(Json(or, JsonRequestBehavior.AllowGet));
}
public ActionResult EditEntity()
{
string data = Request.Params["requestData"];
if (data == null)
{
return(Json(
new OperateResult
{
content = "无考核数据",
},
JsonRequestBehavior.AllowGet
));
}
JavaScriptSerializer js = new JavaScriptSerializer();
SalaryRecord model = js.Deserialize <SalaryRecord>(data);
if (model == null)
{
return(Json(
new OperateResult
{
content = "无考核数据",
},
JsonRequestBehavior.AllowGet
));
}
if (!ModelState.IsValid)
{
return(Json(
new OperateResult
{
content = Model.Utility.GetModelStateErrors(ModelState),
},
JsonRequestBehavior.AllowGet
));
}
OperateResult or = SalaryRecordManager.Update(model);
return(Json(or, JsonRequestBehavior.AllowGet));
}
public OperateResult Add(SalaryRecord model)
{
using (SystemDB db = new SystemDB())
{
try
{
var match = (from m in db.salaryRecordList.Include("assessmentInfo")
where m.assessmentInfoId == model.assessmentInfoId
select m
).FirstOrDefault();
if (match != null)
{
return(new OperateResult
{
content = "数据已经存在",
});
}
model.inputDate = DateTime.Now;
db.salaryRecordList.Add(model);
db.SaveChanges();
return(new OperateResult
{
status = OperateStatus.Success,
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
/// <summary>
/// 获取所有工资记录列表
/// </summary>
/// <returns>工资记录集合</returns>
public IList<SalaryRecord> GetAllSalaryRecord()
{
IList<SalaryRecord> list = new List<SalaryRecord>();
string sql = "select * from TB_SalaryRecord order by Date desc";
DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
SalaryRecord record = new SalaryRecord();
record.Id = (int)row["ID"];
record.EId = (int)row["EId"];
record.Date = (DateTime)row["Date"];
record.Salary = (double)row["Salary"];
list.Add(record);
}
}
return list;
}
public void SaveSR(SalaryRecord sr)
{
db1.SalaryRecords.Add(sr);
db1.SaveChanges();
}
/// <summary>
/// 获取工资记录对象
/// </summary>
/// <param name="eId">Id</param>
/// <returns>工资记录对象</returns>
public SalaryRecord GetSalaryRecord(int id)
{
SalaryRecord record = null;
string sql = "select * from TB_SalaryRecord where ID=" + id;
DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
record = new SalaryRecord();
record.Id = (int)row["ID"];
record.EId = (int)row["EId"];
record.Date = (DateTime)row["Date"];
record.Salary = (double)row["Salary"];
}
return record;
}
/// <summary>
/// 修改工资记录
/// </summary>
/// <param name="record">工资记录对象</param>
/// <returns>影响行数</returns>
public int Update(SalaryRecord record)
{
string sql = "update TB_SalaryRecord set EId=@EId,[Date]=@Date,Salary=@Salary where ID=@ID";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@EId",record.EId),
new OleDbParameter("@Date",record.Date),
new OleDbParameter("@Salary",record.Salary),
new OleDbParameter("@ID",record.Id)
};
int count = AccessHelper.ExecuteNonQuery(_connectionString, sql, param);
return count;
}
/// <summary>
/// 添加工资记录
/// </summary>
/// <param name="record">工资记录对象</param>
/// <returns>ID</returns>
public int Insert(SalaryRecord record)
{
string sql = "insert into TB_SalaryRecord(EId,[Date],Salary) ";
sql += "values(@EId,@Date,@Salary)";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@EId",record.EId),
new OleDbParameter("@Date",record.Date),
new OleDbParameter("@Salary",record.Salary)
};
AccessHelper.ExecuteNonQuery(_connectionString, sql, param);
object id = AccessHelper.ExecuteScalar(_connectionString, "select @@identity");
return Convert.ToInt32(id);
}
/// <summary>
/// 修改工资记录
/// </summary>
/// <param name="record">工资记录对象</param>
/// <returns>影响行数</returns>
public int Update(SalaryRecord record)
{
return _dal.Update(record);
}
/// <summary>
/// 添加工资记录
/// </summary>
/// <param name="record">工资记录对象</param>
/// <returns>ID</returns>
public int Insert(SalaryRecord record)
{
return _dal.Insert(record);
}
public bool EmployeeSalaryInputStub(string month)
{
Random random = new Random();
QueryParam queryParam = new QueryParam {
pager = new Pager
{
page = 1,
rows = EmployeeStubSize
}
};
FilterModel filter = new FilterModel
{
key = "month",
value = month
};
Dictionary <string, FilterModel> filterSet = new Dictionary <string, FilterModel>();
filterSet.Add(filter.key, filter);
queryParam.filters = filterSet;
var or = SalaryRecordManager.GetAssessmentAll(queryParam);
if (or.status == OperateStatus.Error)
{
return(false);
}
dynamic listAssessment = or.data;
foreach (var ass in listAssessment)
{
SalaryRecord e = new SalaryRecord();
PropertyInfo[] pArray = ass.GetType().GetProperties();
Type t = ass.GetType();
//e.billSerial = Convert.ToString();
//e.employeeId = Convert.ToInt64(t.GetProperty("employeeId").GetValue(ass));
e.billSerial = t.GetProperty("billSerial").GetValue(ass);
e.assessmentInfoId = t.GetProperty("assessmentInfoId").GetValue(ass);
e.levelSalary = t.GetProperty("levelSalary").GetValue(ass);
e.fullAttendanceRewards = t.GetProperty("fullAttendanceRewards").GetValue(ass);
e.performanceRewards = t.GetProperty("performanceRewards").GetValue(ass);
e.benefitRewards = t.GetProperty("benefitRewards").GetValue(ass);
e.seniorityRewards = t.GetProperty("seniorityRewards").GetValue(ass);
e.normalOvertimeRewards = t.GetProperty("normalOvertimeRewards").GetValue(ass);
e.holidayOvertimeRewards = t.GetProperty("holidayOvertimeRewards").GetValue(ass);
e.shouldTotal = t.GetProperty("shouldTotal").GetValue(ass);
e.actualTotal = t.GetProperty("actualTotal").GetValue(ass);
or = SalaryRecordManager.Add(e);
if (or.status == OperateStatus.Error)
{
StackTrace st = new StackTrace(new StackFrame(true));
string msg = $"App Trace >>> in file: {st.GetFrame(0).GetFileName()} " +
$"line {st.GetFrame(0).GetFileLineNumber()} message： {or.content}";
Trace.WriteLine(msg);
return(false);
}
}
return(true);
}
