資源簡介
CRM客戶關系管理系統,采用JavaEE技術開發,包含營銷管理、客戶管理、服務管理、統計報表、基礎數據和權限管理等,包含數據庫(oracle)

代碼片段和文件信息
package?org.java.dao;
import?java.util.List;
import?javax.security.auth.message.callback.PrivateKeyCallback.Request;
import?org.hibernate.Criteria;
import?org.hibernate.Query;
import?org.hibernate.Session;
import?org.hibernate.Transaction;
import?org.hibernate.criterion.Example;
import?org.hibernate.criterion.MatchMode;
import?org.hibernate.criterion.Order;
import?org.hibernate.criterion.Projections;
import?org.hibernate.criterion.Restrictions;
import?org.java.entity.CstActivity;
import?org.java.entity.CstCustomer;
import?org.java.entity.Cstlinkman;
import?org.java.entity.CstLost;
import?org.java.entity.Orders;
import?org.java.entity.OrdersLine;
import?org.java.entity.Product;
import?org.java.entity.SysUser;
import?org.java.util.HibernateSessionFactory;
import?org.java.util.Pagination;
public?class?CustDao_fkp?{
/**************************************************************/
public?void?addOrders(Orders?orders){
Session?ses?=?HibernateSessionFactory.getSession();
Transaction?tran??=?ses.beginTransaction();
ses.save(orders);
tran.commit();
ses.close();
}
public?void?addOrdersLine(OrdersLine?line){
Session?ses?=?HibernateSessionFactory.getSession();
Transaction?tran??=?ses.beginTransaction();
ses.save(line);
tran.commit();
ses.close();
}
//獲取產品集合
public?List?findProducts(){
Session?ses?=?HibernateSessionFactory.getSession();
String?hql?=?“from?Product?order?by?prodId“;
Query?query?=?ses.createQuery(hql);
List?list?=?query.list();
ses.close();
return?list;
}
//獲得產品對象
public?Product?findProdByPid(Long?pid){
Session?ses?=?HibernateSessionFactory.getSession();
Product?prod?=?(Product)?ses.get(Product.class?pid);
ses.close();
return?prod;
}
/******************************************************/
public?List?findAll(CstCustomer?custPagination?p){
Session?ses?=?HibernateSessionFactory.getSession();
Criteria?cri?=?ses.createCriteria(CstCustomer.class);
cri.addOrder(Order.desc(“custLevel“));
cust?=?cust==null?new?CstCustomer():cust;
/*************?實例查詢?**********/
Example?exa?=?Example.create(cust);
exa.excludeProperty(“custName“);
if(cust.getCustNo()!=null){
cri.add(Restrictions.idEq(cust.getCustNo()));
}
if(cust.getCustName()!=null){?
cri.add(Restrictions.ilike(“custName“?cust.getCustName()MatchMode.ANYWHERE));
}
if?(cust.getSysUser()!=null)?{
if(cust.getSysUser().getUserId()!=null){
cri.add(Restrictions.eq(“sysUser.userId“?cust.getSysUser().getUserId()));
}
}
//正常用戶
cust.setCustStatus(1L);
/*************?分頁?**********/
Integer?start?=?(p.getIndex()-1)*p.getSize();
cri.setFirstResult(start);
cri.setMaxResults(p.getSize());
cri.add(exa);
List?list?=?cri.list();
ses.close();
return?list;
}
public?Integer?getCount(CstC
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1753??2017-08-14?08:40??CRM\.classpath
?????文件????????132??2017-08-08?08:58??CRM\.git\config
?????文件?????????23??2017-08-08?09:01??CRM\.git\HEAD
?????文件??????22584??2017-08-08?09:01??CRM\.git\index
?????文件???????2672??2017-08-08?09:01??CRM\.git\logs\HEAD
?????文件????????156??2017-08-03?19:43??CRM\.git\logs\refs\heads\master
?????文件????????168??2017-08-08?08:58??CRM\.git\logs\refs\heads\wu
?????文件?????????21??2017-08-03?19:43??CRM\.git\ob
?????文件????????499??2017-08-03?19:43??CRM\.git\ob
?????文件?????????87??2017-08-03?19:43??CRM\.git\ob
?????文件???????1072??2017-08-03?19:43??CRM\.git\ob
?????文件????????828??2017-08-03?19:43??CRM\.git\ob
?????文件???????2956??2017-08-03?19:43??CRM\.git\ob
?????文件????????830??2017-08-03?19:43??CRM\.git\ob
?????文件????????157??2017-08-03?19:43??CRM\.git\ob
?????文件?????????85??2017-08-03?19:43??CRM\.git\ob
?????文件????????626??2017-08-03?19:43??CRM\.git\ob
?????文件????????394??2017-08-03?19:43??CRM\.git\ob
?????文件????????578??2017-08-03?19:43??CRM\.git\ob
?????文件????????481??2017-08-03?19:43??CRM\.git\ob
?????文件????????479??2017-08-03?19:43??CRM\.git\ob
?????文件????????421??2017-08-03?19:43??CRM\.git\ob
?????文件??????10216??2017-08-03?19:43??CRM\.git\ob
?????文件???????2326??2017-08-03?19:43??CRM\.git\ob
?????文件???????1055??2017-08-03?19:43??CRM\.git\ob
?????文件???????1277??2017-08-03?19:43??CRM\.git\ob
?????文件????????699??2017-08-03?19:43??CRM\.git\ob
?????文件????????933??2017-08-03?19:43??CRM\.git\ob
?????文件????????153??2017-08-03?19:43??CRM\.git\ob
?????文件???????1133??2017-08-03?19:43??CRM\.git\ob
............此處省略1748個文件信息
評論
共有 條評論