package com.niuys.gdzc.dao.impl;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import com.niuys.gdzc.dao.IInOutAssetsDAO;
import com.niuys.gdzc.model.Comployee;
import com.niuys.gdzc.model.ZcInfo;
import com.niuys.gdzc.model.ZcInout;
public class InOutAssetsDAOImpl implements IInOutAssetsDAO {
private SessionFactory sessionFactory;
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
protected Session getSession() {
return sessionFactory.getCurrentSession();
}
//所有已借出的资产
public List showLendAssets(){
List list = null;
String hql = "from ZcInout";
Session session = this.getSession();
try {
Query query = session.createQuery(hql);
list = query.list();
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
//分页显示已借出资产
public List findPageLendAssets(int pageStartRow, int pageCount) {
List list = null;
String hql = "from ZcInout";
Session session = this.getSession();
try {
Query query = session.createQuery(hql);
query.setFirstResult(pageStartRow);
query.setMaxResults(pageCount);
list = query.list();
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
//查询借资产的员工信息
public Comployee getOneEmployee(String comployeeNo){
Comployee comployee=new Comployee();
Session session = this.getSession();
String sql = "from Comployee c where comployeeNo=:comployeeNo";
try {
Query query = session.createQuery(sql);
query.setString("comployeeNo", comployeeNo);
comployee= (Comployee) query.setMaxResults(1).uniqueResult();
} catch (Exception e) {
e.printStackTrace();
}
return comployee;
}
//查询借出资产的详细信息
public ZcInfo getOneZc(String zcId){
ZcInfo zcinfo=new ZcInfo();
Session session = this.getSession();
String sql = "from ZcInfo c where zcId=:zcId";
try {
Query query = session.createQuery(sql);
query.setString("zcId", zcId);
zcinfo= (ZcInfo) query.setMaxResults(1).uniqueResult();
} catch (Exception e) {
e.printStackTrace();
}
return zcinfo;
}
//归还已借出的资产
public boolean backZC(String inoutNo, String zcId) {
boolean flag=false;
SimpleDateFormat formatter = (SimpleDateFormat) SimpleDateFormat.getDateInstance();
formatter.applyPattern("yyyy-MM-dd");
Calendar cal = Calendar.getInstance();
String backTime = formatter.format(cal.getTime());
System.out.println(backTime);
String sql1="update ZcInout set backTime=:backTime where inoutNo=:inoutNo";
String sql2="update ZcInfo set zcStatus='正常' where zcId=:zcId";
Session session = this.getSession();
try {
Query query1 = session.createQuery(sql1);
query1.setString("inoutNo", inoutNo);
query1.setString("backTime", backTime);
query1.executeUpdate();
Query query2 = session.createQuery(sql2);
query2.setString("zcId", zcId);
query2.executeUpdate();
flag=true;
} catch (Exception e) {
e.printStackTrace();
}
return flag;
}
//查询资产的状态
public String zcStatus(String zcId){
String status="";
Session session = this.getSession();
String sql = "select zcStatus from ZcInfo c where zcId=:zcId";
try {
Query query = session.createQuery(sql);
query.setString("zcId", zcId);
status=(String) query.setMaxResults(1).uniqueResult();
} catch (Exception e) {
e.printStackTrace();
}
return status;
}
//借出资产
public boolean outZC(ZcInout inout,String zcId) {
boolean flag=false;
Session session = this.getSession();
String sql="update ZcInfo set zcStatus='借出' where zcId=:zcId";
try {
session.save(inout);
Query query = session.createQuery(sql);
query.setString("zcId", zcId);
query.executeUpdate();
flag=true;
} catch (Exception e) {
e.printStackTrace();
}
return flag;
}
public List ZCInOut(ZcInout inout){
List list=new ArrayList();
Session session = this.getSession();
String comployeeNo=inout.getComployeeNo();
String zcId=inout.getZcInfo().getZcId();
String sql = "from ZcInout where zcInfo.zcId=:zcId or comployeeNo=:comployeeNo";
try {
Query query = session.createQuery(sql);
query.setString("zcId", zcId);
query.setString("comployeeNo", comployeeNo);
list = query.list();
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
固定资产管理系统的设计与实现
共363个文件
class:75个
java:75个
jar:69个
需积分: 3 0 下载量 186 浏览量
2024-05-02
00:02:45
上传
评论
收藏 19.87MB ZIP 举报
温馨提示
随着计算机信息技术的发展以及对资产、设备的管理科学化、合理化的高要求,利用计算机实现设备及资产的信息化管理已经显得非常重要。 固定资产管理系统是一个单位不可缺少的部分。但一直以来人们使用传统的人工方式管理固定资产的信息,这种管理方式存在着许多缺点,这对于查找、更新和维护都带来了不小的困难。因此,开发一个界面友好,易操作的资产管理软件进行自动化管理变得十分重要。这正是本系统开发的目的和意义。本文所阐述的固定资产管理系统,以浏览器/服务器模式高效地实现了固定资产管理的各项功能,可进行资产的添加,删除、修改、查询、打印报表等功能;还可以对每位职工的添加、删除、修改、查询基本操作;本系统还对权限进行限制,操作员只可对资产和用户进行基本操作,管理员可以为每位员工赋权限。 使用本系统,不仅提升了效率,而且满足现代高校资产管理的需要。
资源推荐
资源详情
资源评论
收起资源包目录
固定资产管理系统的设计与实现 (363个子文件)
InOutAssetsDAOImpl.class 6KB
UserManaDAOImpl.class 5KB
AssetsDAOImpl.class 4KB
AssetPerDAOImpl.class 4KB
EmployeeDAOImpl.class 4KB
ZcInfo.class 4KB
AddAssetsAction.class 4KB
Comployee.class 3KB
SaveUpdateAssetsAction.class 3KB
FindPerAssetAction.class 3KB
SaveLendZCAction.class 3KB
RandomCode.class 3KB
AddPerAssetAction.class 3KB
LoginAction.class 3KB
AddEmployeeInfoAction.class 3KB
ZcWx.class 3KB
UpdateEmployeeAction.class 3KB
UpdatePerAssetAction.class 3KB
LendZCAction.class 3KB
AddUserAction.class 3KB
FindUserbyname.class 3KB
SelectZCForm.class 3KB
ZCForm.class 2KB
StoreInShowAllAction.class 2KB
EmployeeAction.class 2KB
FindPerAssetbyPro.class 2KB
ZCInOutAction.class 2KB
AssetPerAction.class 2KB
JHGLAction.class 2KB
UserManaAction.class 2KB
CheckZCAction.class 2KB
EditEmployeeAction.class 2KB
ZCGLAction.class 2KB
AssetManagerImpl.class 2KB
FindPerAssetForm.class 2KB
UpdatepwdAction.class 2KB
ZcInout.class 2KB
EmployeeInfoForm.class 2KB
EditEmployeeForm.class 2KB
CheckInOutAction.class 2KB
UpdateUserAction.class 2KB
InOutAssetManagerImpl.class 2KB
UserManaManagerImpl.class 2KB
BackZCAction.class 2KB
AddEmployeeAction.class 2KB
EmployeeManagerImpl.class 2KB
UserDAOImpl.class 2KB
AssetPerManagerImpl.class 2KB
UpdateAssetsAction.class 2KB
DeletePerassetAction.class 2KB
DeleteEmployeeAction.class 1KB
AuthorityInterceptor.class 1KB
CharacterEncodingFilter.class 1KB
DeleteUserAction.class 1KB
DeleteAssetsAction.class 1KB
BaseAction.class 1KB
UserInfo.class 1KB
PrintStoreInAction.class 1KB
AddUserForm.class 1KB
AddPerAssetForm.class 1KB
DataPageBean.class 1KB
UpdatepwdForm.class 1KB
Department.class 994B
LoginForm.class 986B
AssetManager.class 692B
IInOutAssetManager.class 647B
IInOutAssetsDAO.class 637B
IAssetsDAO.class 626B
IUserManaManager.class 555B
IUserManaDAO.class 543B
IAssetPerManager.class 522B
IEmployeeManager.class 511B
IAssetPerDAO.class 510B
IEmployeeDAO.class 499B
IUserDAO.class 174B
.classpath 6KB
org.eclipse.wst.common.component 471B
org.eclipse.wst.jsdt.ui.superType.container 49B
foot_style.css 11KB
header_style.css 11KB
style.css 8KB
style2.css 3KB
admin.css 2KB
toolbar_style.css 840B
css.css 648B
CSS.CSS 617B
top_bg.gif 16KB
earth2.gif 8KB
wdmap.gif 4KB
jzjl.gif 2KB
ddd.gif 2KB
1.gif 2KB
8959.gif 2KB
new.gif 2KB
556.gif 2KB
4.gif 2KB
7.gif 2KB
11.gif 2KB
9.gif 2KB
2.gif 1KB
共 363 条
- 1
- 2
- 3
- 4
资源评论
ShaZiJ
- 粉丝: 681
- 资源: 50
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功