/// <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); }