/// <summary>
/// 更新指定物资申请记录
/// </summary>
/// <param name="materialapply">指定物资申请记录</param>
public void Update(Materialapply materialapply)
{
using (var context = new SchoolOAContext())
{
context.Materialapply.Update(materialapply);
context.SaveChanges();
}
}
/// <summary>
/// 更新指定工作计划
/// </summary>
/// <param name="plantable">工作计划对象</param>
public void Update(Entities.Plantable plantable)
{
using (var context = new SchoolOAContext())
{
context.Plantable.Update(plantable);
context.SaveChanges();
}
}
/// <summary>
/// 更新指定工资记录对象
/// </summary>
/// <param name="wage">工资记录对象</param>
public void Update(Wage wage)
{
using (var context = new SchoolOAContext())
{
context.Wage.Update(wage);
context.SaveChanges();
}
}
/// <summary>
/// 依据工资记录的ID删除工资
/// </summary>
/// <param name="id">工资记录的ID</param>
public void Delete(int id)
{
using (SchoolOAContext context = new SchoolOAContext())
{
var wage = context.Wage.FirstOrDefault(x => x.Id == id);
context.Wage.Remove(wage);
context.SaveChanges();
}
}
/// <summary>
/// 通过ID查询工作计划
/// </summary>
/// <param name="id">要查询的工作计划ID</param>
/// <returns></returns>
public Entities.Plantable Query(int id)
{
using (var context = new SchoolOAContext())
{
var plantable = context.Plantable.FirstOrDefault(x => x.Id == id);
context.SaveChanges();
return(plantable);
}
}
/// <summary>
/// 按ID删除工作计划
/// </summary>
/// <param name="id">工作计划ID</param>
public void Delete(int id)
{
using (SchoolOAContext context = new SchoolOAContext())
{
var plantable = context.Plantable.FirstOrDefault(x => x.Id == id);
context.Plantable.Remove(plantable);
context.SaveChanges();
}
}
/// <summary>
/// 通过物资申请记录ID查询指定物资申请记录
/// </summary>
/// <param name="id">物资申请记录ID</param>
/// <returns>指定物资申请记录对象</returns>
public Entities.Materialapply Query(int id)
{
using (var context = new SchoolOAContext())
{
var materialapply = context.Materialapply.FirstOrDefault(x => x.Id == id);
context.SaveChanges();
return(materialapply);
}
}
/// <summary>
/// 通过物资申请记录ID删除指定物资申请记录
/// </summary>
/// <param name="id">物资申请记录ID</param>
public void Delete(int id)
{
using (SchoolOAContext context = new SchoolOAContext())
{
var materialapply = context.Materialapply.FirstOrDefault(x => x.Id == id);
context.Materialapply.Remove(materialapply);
context.SaveChanges();
}
}
/// <summary>
/// 通过工资记录ID查询指定工资记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Wage QuerybyID(int id)
{
using (var context = new SchoolOAContext())
{
var wage = context.Wage.FirstOrDefault(x => x.Id == id);
context.SaveChanges();
//wage.Wagetime = wage.Wagetime.ToString("yyyy-MM");
return(wage);
}
}
/// <summary>
/// 获取所有物资申请
/// </summary>
/// <returns>所有物资申请</returns>
public List <Materialapply> QueryAllMaterialapply()
{
List <Materialapply> materialapplyList = new List <Materialapply>();
using (var context = new SchoolOAContext())
{
materialapplyList = (from u in context.Materialapply
select u
).ToList();
context.SaveChanges();
}
return(materialapplyList);
}
/// <summary>
/// 获取所有工作计划
/// </summary>
/// <returns>工作计划列表</returns>
public List <Plantable> QueryAllPlantable()
{
List <Plantable> plantableList = new List <Plantable>();
using (var context = new SchoolOAContext())
{
plantableList = (from u in context.Plantable
select u
).ToList();
context.SaveChanges();
}
return(plantableList);
}
/// <summary>
/// 通过部门ID查询物资申请记录列表
/// </summary>
/// <param name="departmentid">部门ID</param>
/// <returns>物资申请记录列表</returns>
public List <Materialapply> QueryMaterialapplybyDid(string departmentid)
{
List <Materialapply> materialapplyList = new List <Materialapply>();
using (var context = new SchoolOAContext())
{
materialapplyList = (from u in context.Materialapply
where u.Departmentid.Equals(departmentid)
select u
).ToList();
context.SaveChanges();
}
return(materialapplyList);
}
/// <summary>
/// 通过教师ID查询工作计划列表
/// </summary>
/// <param name="teacherid">教师ID</param>
/// <returns>工作计划列表</returns>
public List <Plantable> QueryPlantablebyTid(string teacherid)
{
List <Plantable> plantableList = new List <Plantable>();
using (var context = new SchoolOAContext())
{
plantableList = (from u in context.Plantable
where u.Teacherid.Equals(teacherid)
select u
).ToList();
context.SaveChanges();
}
return(plantableList);
}
/// <summary>
/// 通过物资申请状态查询物资申请记录列表
/// </summary>
/// <param name="state">物资申请状态</param>
/// <returns>物资申请记录列表</returns>
public List <Materialapply> QueryMaterialapplybyState(int state)
{
List <Materialapply> materialapplyList = new List <Materialapply>();
using (var context = new SchoolOAContext())
{
materialapplyList = (from u in context.Materialapply
where u.State == state
select u
).ToList();
context.SaveChanges();
}
return(materialapplyList);
}
/// <summary>
/// 获取所有未处理工作计划
/// </summary>
/// <returns>工作计划列表</returns>
public List <Plantable> QueryUnprocessedPlantable()
{
List <Plantable> plantableList = new List <Plantable>();
using (var context = new SchoolOAContext())
{
plantableList = (from u in context.Plantable
where u.State != 1
select u
).ToList();
context.SaveChanges();
}
return(plantableList);
}
/// <summary>
/// 通过工作计划状态值查询工作计划列表
/// </summary>
/// <param name="state">工作计划状态值</param>
/// <returns>工作计划列表</returns>
public List <Plantable> QueryPlantablebyTid(uint state)
{
List <Plantable> plantableList = new List <Plantable>();
using (var context = new SchoolOAContext())
{
plantableList = (from u in context.Plantable
where u.State == state
select u
).ToList();
context.SaveChanges();
}
return(plantableList);
}
/// <summary>
/// 查询教师ID的某月的工资记录
/// </summary>
/// <param name="teacherid">教师ID</param>
/// <param name="time">工资日期（月份输入举例 eg：2019-01-01表示查询2019年1月工资）</param>
/// <returns>指定工资记录</returns>
public Wage QuerybyTidMonth(string teacherid, string time)
{
Wage wage = new Wage();
DateTime dt = Convert.ToDateTime(time);
using (var context = new SchoolOAContext())
{
wage = (from u in context.Wage
where (0 == DateTime.Compare(u.Wagetime, dt)) && (u.Teacherid.Equals(teacherid))
select u
).FirstOrDefault();
context.SaveChanges();
}
return(wage);
}
/// <summary>
/// 用基本工资创建工资记录
/// </summary>
/// <param name="teacherid">教师ID</param>
/// <param name="wagetime">工资日期</param>
/// <param name="basicwage">基本工资</param>
public void Add(string teacherid, string wagetime, float basicwage)
{
using (SchoolOAContext context = new SchoolOAContext())
{
DateTime dt = Convert.ToDateTime(wagetime);
Wage wage = new Wage
{
Teacherid = teacherid,
Wagetime = dt,
Basicwage = basicwage,
Totalwage = basicwage
};
context.Wage.Add(wage);
context.SaveChanges();
}
}
///// <summary>
///// 按工资日期（某个月）查找工资记录
///// </summary>
///// <param name="wagetime">工资日期</param>
///// <returns>指定日期（某个月）的所有人的工资记录</returns>
//public List<Wage> QueryAllbyTime(string wagetime)
//{
// List<Wage> wageList = new List<Wage>();
// DateTime dt = Convert.ToDateTime(wagetime);
// using (var context = new SchoolOAContext())
// {
// wageList = (from u in context.Wage
// where 0==DateTime.Compare(u.Wagetime, dt)
// select u
// ).ToList();
// context.SaveChanges();
// }
// return wageList;
//}
///// <summary>
///// 查询某一年所有人的工资
///// </summary>
///// <param name="year">年份</param>
///// <returns>指定年份工资记录列表</returns>
//public List<Wage> QueryAllbyYear(string year)
//{
// List<Wage> wageList = new List<Wage>();
// string Jan = "-01-01";
// string Dec = "-12-01";
// string Begin = year + Jan;
// string End = year + Dec;
// DateTime BeginTime = Convert.ToDateTime(Begin);
// DateTime EndTime = Convert.ToDateTime(End);
// using (var context = new SchoolOAContext())
// {
// wageList = (from u in context.Wage
// where DateTime.Compare(u.Wagetime, BeginTime) >=0 && DateTime.Compare(u.Wagetime, EndTime) <= 0
// select u
// ).ToList();
// context.SaveChanges();
// }
// return wageList;
//}
/// <summary>
/// 查询某部门（ID）内的所有人某月工资
/// </summary>
/// <param name="departmentid">部门ID</param>
/// <param name="time">工资日期（月份输入举例 eg：2019-01-01表示查询2019年1月工资）</param>
/// <returns>工资记录列表</returns>
public List <Wage> QueryAllbyDidMonth(string departmentid, string time)
{
List <Wage> wageList = new List <Wage>();
DateTime Time = Convert.ToDateTime(time);
using (var context = new SchoolOAContext())
{
wageList = (from u in context.Wage
from v in context.Teacherinfomation
where u.Teacherid.Equals(v.Teacherid) && v.Departmentid.Equals(departmentid) && DateTime.Compare(u.Wagetime, Time) == 0
select u
).ToList();
context.SaveChanges();
}
return(wageList);
}
/// <summary>
/// 新建工作计划
/// </summary>
/// <param name="teacherid">教师ID</param>
/// <param name="filepath">文件目录</param>
/// <param name="filename">文件名称</param>
/// <param name="committime">提交时间</param>
/// <param name="state">计划状态</param>
/// <param name="issue">批复意见</param>
public void Add(string teacherid, string filepath, string filename, DateTime committime, uint state, string issue)
{
using (SchoolOAContext context = new SchoolOAContext()) {
Entities.Plantable plantable = new Entities.Plantable
{
Teacherid = teacherid,
Filepath = filepath,
Filename = filename,
Committime = committime,
State = state,
Issue = issue
};
context.Plantable.Add(plantable);
context.SaveChanges();
}
}
/// <summary>
/// 创建物资申请
/// </summary>
/// <param name="departmentid">部门ID</param>
/// <param name="teacherid">教师ID</param>
/// <param name="goodsname">物资名称</param>
/// <param name="goodsnum">物资数量</param>
/// <param name="goodsprice">物资价格</param>
/// <param name="remarks">申请原因</param>
public void Add(string departmentid, string teacherid, string goodsname, int goodsnum, float goodsprice, string remarks)
{
using (SchoolOAContext context = new SchoolOAContext())
{
Materialapply materialapply = new Materialapply
{
Departmentid = departmentid,
Tid = teacherid,
Goodsname = goodsname,
Goodsnum = goodsnum,
Goodsprice = goodsprice,
Remarks = remarks,
State = 0 //新建物资申请状态默认未处理；0-未处理1-同意2-拒绝
};
context.Materialapply.Add(materialapply);
context.SaveChanges();
}
}
/// <summary>
/// 新建工资记录
/// </summary>
/// <param name="teacherid">教师ID</param>
/// <param name="wagetime"> 工资日期，格式：“2019-08-01”代表2019-08的工资</param>
/// <param name="basicwage">基本工资</param>
/// <param name="overtimewage">加班工资</param>
/// <param name="welfare">福利工资</param>
/// <param name="bonus">全勤奖</param>
public void Add(string teacherid, string wagetime, float basicwage, float?overtimewage, float?welfare, float?bonus)
{
using (SchoolOAContext context = new SchoolOAContext())
{
DateTime dt = Convert.ToDateTime(wagetime);
Wage wage = new Wage
{
Teacherid = teacherid,
Wagetime = dt,
Basicwage = basicwage,
Overtimewage = overtimewage,
Welfare = welfare,
Bonus = bonus,
Totalwage = basicwage + overtimewage + welfare + bonus
};
context.Wage.Add(wage);
context.SaveChanges();
}
}
/// <summary>
/// 查询某教师某年所有工资记录
/// </summary>
/// <param name="teacherid">教师ID</param>
/// <param name="year">年份</param>
/// <returns>指定教师ID的某年的所有工资记录</returns>
public List <Wage> QueryAllbyTidYear(string teacherid, string year)
{
List <Wage> wageList = new List <Wage>();
List <Wagestringtime> wageListstring = new List <Wagestringtime>();
string Jan = "-01-01";
string Dec = "-12-01";
string Begin = year + Jan;
string End = year + Dec;
DateTime BeginTime = Convert.ToDateTime(Begin);
DateTime EndTime = Convert.ToDateTime(End);
using (var context = new SchoolOAContext())
{
wageList = (from u in context.Wage
where u.Teacherid.Equals(teacherid) && DateTime.Compare(u.Wagetime, BeginTime) >= 0 && DateTime.Compare(u.Wagetime, EndTime) <= 0
select u
).ToList();
context.SaveChanges();
}
return(wageList);
}
