@Override
public void updateTemplate(CpGzTemplateVO templateVo) throws TplBusinessException {
BaseDAO dao = new BaseDAO();
try {
dao.updateVO(templateVo);
} catch (DAOException e) {
LfwLogger.error(e);
throw new TplBusinessException(e.getMessage(), e);
}
}
@Override
public void delete(String systemCode) {
PtBaseDAO dao = new PtBaseDAO();
try {
dao.deleteByClause(PtSsopropVO.class, " systemcode = '" + systemCode + "'");
} catch (DAOException e) {
LfwLogger.error(e.getMessage(), e);
}
PortalCacheManager.notify(
CacheKeys.PORTAL_SSO_PROVIDER_CACHE, CacheKeys.PORTAL_SSO_PROVIDER_MAP_CACHE);
}
@Override
public void update(PtSsopropVO ssoProp) {
PtBaseDAO dao = new PtBaseDAO();
try {
dao.updateVO(ssoProp);
} catch (DAOException e) {
LfwLogger.error(e.getMessage(), e);
}
PortalCacheManager.notify(
CacheKeys.PORTAL_SSO_PROVIDER_CACHE, CacheKeys.PORTAL_SSO_PROVIDER_MAP_CACHE);
}
@Override
public void deleteTemplate(String pk_template) throws TplBusinessException {
try {
BaseDAO dao = new BaseDAO();
dao.deleteByPK(CpGzTemplateVO.class, pk_template);
dao.deleteByClause(CpGzConditionVO.class, "pk_gz_template='" + pk_template + "'");
} catch (DAOException e) {
LfwLogger.error(e);
throw new TplBusinessException(e.getMessage(), e);
}
}
public MenuAdapterVO[] getAllMenuCategorys() throws CpbBusinessException {
PtBaseDAO dao = new PtBaseDAO();
String sql = "select a.pk_menucategory,a.id,a.title from cp_menucategory a";
List<MenuAdapterVO> list;
try {
list = (List<MenuAdapterVO>) dao.executeQuery(sql, new MenuCategoryAdapterVOProcessor());
} catch (DAOException e) {
LfwLogger.error(e.getMessage(), e);
throw new CpbBusinessException(e);
}
return list.toArray(new MenuAdapterVO[0]);
}
@Override
public void add(SSOProviderVO provider) {
PtBaseDAO dao = new PtBaseDAO();
PtSsopropVO vo = SSOUtil.provider2prop(provider);
try {
dao.insertVO(vo);
} catch (DAOException e) {
LfwLogger.error(e.getMessage(), e);
}
PortalCacheManager.notify(
CacheKeys.PORTAL_SSO_PROVIDER_CACHE, CacheKeys.PORTAL_SSO_PROVIDER_MAP_CACHE);
}
/**
* 覆写方法：初始化所有数据
*
* @return
* @throws LfwBusinessException
* @see nc.vo.ebscg.xydowmload.service.IDownloadService#getDown()
*/
public List<XyDowmloadVO> getDown() throws LfwBusinessException {
// TODO Auto-generated method stub
String sql = "select * from ebs_xy_down_file_sign isnull(dr, 0)=0";
try {
List<XyDowmloadVO> list =
(List<XyDowmloadVO>) baseDao.executeQuery(sql, new BeanListProcessor(XyDowmloadVO.class));
System.out.println(list);
return list;
} catch (DAOException e) {
// TODO Auto-generated catch block
Logger.error(e.getMessage(), e);
e.printStackTrace();
throw new LfwBusinessException("没有查询到数据", e);
}
}
@Override
public void initConditons(String pk_template, CpGzConditionVO[] conditions)
throws TplBusinessException {
try {
BaseDAO dao = new BaseDAO();
// List<CpQueryConditionVO> list = (List<CpQueryConditionVO>)
// dao.retrieveByClause(CpQueryConditionVO.class, "pkTemplet='" + pk_template + "'");
// Iterator<CpQueryConditionVO> it = list.iterator();
dao.deleteByClause(CpGzConditionVO.class, "pk_gz_template='" + pk_template + "'");
if (null != conditions) dao.insertVOArray(conditions);
} catch (DAOException e) {
LfwLogger.error(e);
throw new TplBusinessException(e.getMessage(), e);
}
}
public MenuAdapterVO[] getAllMenus() throws CpbBusinessException {
PtBaseDAO dao = new PtBaseDAO();
String sql1 = "select a.pk_menucategory,a.id,a.title from cp_menucategory as a";
String sql2 =
"select b.code,b.name,b.pk_menuitem,b.pk_parent,b.pk_menucategory from cp_menuitem as b";
List<MenuAdapterVO> list1;
List<MenuAdapterVO> list2;
try {
list1 = (List<MenuAdapterVO>) dao.executeQuery(sql1, new MenuCategoryAdapterVOProcessor());
list2 = (List<MenuAdapterVO>) dao.executeQuery(sql2, new MenuItemAdapterVOProcessor());
} catch (DAOException e) {
LfwLogger.error(e.getMessage(), e);
throw new CpbBusinessException(e);
}
list1.addAll(list2);
return list1.toArray(new MenuAdapterVO[0]);
}
/**
* 查询，是否已经在外网确认过送货数量和金额
*
* @author:zhenglq <br>
* @datetime:2009-12-24下午06:51:17
* @param mainVO
* @return
* @throws LfwRuntimeException
*/
@SuppressWarnings("unchecked")
public boolean permitComplete(String orderPk) throws LfwRuntimeException {
// 查询采购订单确认中是否存在订单发货数据
String sql = "select * from ebs_dd_order_item_cfm where pk_dd_order_main='" + orderPk + "'";
try {
List<OrderItemCfmVO> predVOList =
(List<OrderItemCfmVO>)
getBaseDao().executeQuery(sql, new BeanListProcessor(OrderItemCfmVO.class));
if (null != predVOList && predVOList.size() > 0) {
return true;
} else {
return false;
}
} catch (DAOException e) {
e.printStackTrace();
}
return false;
}
@SuppressWarnings("unchecked")
@Override
public CpResourceVO[] getResoureces(String pk_user) throws CpbBusinessException {
PtBaseDAO baseDAO = new PtBaseDAO();
String sql =
"select * from pt_resource p1 join pt_permission p2 on p1.pk_resource = p2.pk_resource where p2.pk_role in (select pk_role from pt_roleuser p3 where p3.pk_user = ?) ";
List<CpResourceVO> list = null;
SQLParameter param = new SQLParameter();
param.addParam(pk_user);
try {
list =
(List<CpResourceVO>)
baseDAO.executeQuery(sql, param, new BeanListProcessor(CpResourceVO.class));
if (list == null || list.size() < 1) return new CpResourceVO[] {};
return list.toArray(new CpResourceVO[list.size()]);
} catch (DAOException e) {
LfwLogger.error(e.getMessage(), e);
throw new CpbBusinessException(e);
}
}
@SuppressWarnings("unchecked")
public CpResourceVO[] getResourcesByRoles(String pkroles[]) throws CpbBusinessException {
String param = StringUtils.join(pkroles, "','");
StringBuffer wherePart =
new StringBuffer(
"select * from pt_resource p1 join pt_permission p2 on p1.pk_resource = p2.pk_resource where p2.pk_role in ('");
wherePart.append(param);
wherePart.append("') ");
List<CpResourceVO> list = null;
try {
list =
(List<CpResourceVO>)
new PtBaseDAO()
.executeQuery(wherePart.toString(), new BeanListProcessor(CpResourceVO.class));
if (list == null || list.size() < 1) return new CpResourceVO[] {};
return list.toArray(new CpResourceVO[list.size()]);
} catch (DAOException e) {
LfwLogger.error(e.getMessage(), e);
throw new CpbBusinessException(e);
}
}
/**
* 更新单据受理状态的方法
*
* @author liweiqiang
* @param key 主表的PK值
* @param btnNo 出发事件的按钮编号 2009-11-12
*/
public String setAcceptStatusValue(String key, String btnNo) throws LfwBusinessException {
BaseDAO dao = new BaseDAO();
try {
DzcgMainAuthority dma = new DzcgMainAuthority();
if (dma.existsCloseData(key, EbsOperaitonConst.CLOSEREQCODE)) {
return "此单据已经被关闭,无法进行此操作!";
}
} catch (Exception e) {
Logger.error(
(new StringBuilder("采购申请,点击收回按钮时没有申请单数据 Pk_xq_req_main == ")).append(key).toString());
return "操作失败,请重新操作!";
}
String result = null;
ReqMainVO reqMainVO = new ReqMainVO();
reqMainVO.setPk_xq_req_main(key);
reqMainVO.setStatus(1);
ReqMainVO reqMainDeptVO = null;
String fieldNames[] = {
"accept_status", "modifydate", "modifier", "pk_oper_person", "pk_dept_sug", "zdy1"
};
try {
reqMainDeptVO = (ReqMainVO) dao.retrieveByPK(ReqMainVO.class, key);
} catch (Exception e) {
Logger.error(
(new StringBuilder("采购申请,点击收回按钮时没有申请单数据 Pk_xq_req_main == ")).append(key).toString());
return "无法进行收回,没有找到申请单数据,请刷新后在进行操作!";
}
reqMainVO.setModifydate(new UFDate(System.currentTimeMillis()));
reqMainVO.setModifier(LfwRuntimeEnvironment.getUserVO().getPrimaryKey());
IReqService service = (IReqService) NCLocator.getInstance().lookup(IReqService.class);
if ("998".equals(btnNo)) {
Integer acceptstatus = reqMainDeptVO.getAccept_status();
Integer billstatus = reqMainDeptVO.getBillstatus();
if (acceptstatus == null || billstatus == null) {
Logger.error("采购申请,点击收回按钮时没有找到正确的单据状态 acceptstatus == null, billstatus == null");
return "请刷新界面数据,在重新操作!";
}
Logger.warn(
(new StringBuilder("采购申请,点击收回按钮时数据状态为 acceptstatus == "))
.append(acceptstatus)
.append(", billstatus == ")
.append(billstatus)
.toString());
switch (acceptstatus.intValue()) {
case 3: // '\003'
reqMainVO.setAccept_status(Integer.valueOf(1));
reqMainVO.setBillstatus(Integer.valueOf(8));
reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person());
reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug());
reqMainVO.setZdy1(reqMainDeptVO.getZdy1());
service.setReqVOValue(reqMainVO, fieldNames);
return "收回成功!";
}
return "只有在提交受理状态下才能收回单据";
}
if (btnNo.equals("1")) {
reqMainVO.setAccept_status(Integer.valueOf(2));
} else if (btnNo.equals("2")) {
boolean flagTmp = false;
// yanlei start 将建议采购经办人进行处理，对照转授权表。。有被授权人时，改为被授权人
try {
// 获取当前方案申请记录
ArrayList<ReqMainVO> reqMainVOTmp =
(ArrayList<ReqMainVO>)
dao.retrieveByClause(
ReqMainVO.class,
" pk_xq_req_main like '" + reqMainVO.getPk_xq_req_main() + "'");
// 获取原建议采购经办人主键
// String old_pk_oper_person =
// (String)((AggReqVO)ncobjects[i].getContainmentObject()).getParentVO().getAttributeValue("pk_oper_person");
String old_pk_oper_person = reqMainVOTmp.get(0).getPk_oper_person();
if (null != old_pk_oper_person && !"".equals(old_pk_oper_person)) {
// 查询出被授权人人员的编码
String sqlPsnTmp = " pk_psndoc like '" + old_pk_oper_person + "'";
ArrayList<PsndocVO> psnvoTmp =
(ArrayList<PsndocVO>) (dao.retrieveByClause(PsndocVO.class, sqlPsnTmp));
List<SmUserVO> asqvoTmp =
(List<SmUserVO>)
dao.executeQuery(
"SELECT * FROM sm_user bd , sm_userandclerk sm WHERE "
+ " sm.pk_psndoc='"
+ psnvoTmp.get(0).getPk_psnbasdoc()
+ "' AND sm.userid = bd.cuserid",
new BeanListProcessor(SmUserVO.class));
// String sqlAsTmp = " cuserid = (select userid from sm_userandclerk tttt where
// tttt.pk_psndoc='"+psnvoTmp.get(0).getPk_psnbasdoc()+"'";
// ArrayList<SmUserVO> asqvoTmp =
// (ArrayList<SmUserVO>)(dao.retrieveByClause(SmUserVO.class, sqlAsTmp));
String old_cuserid = asqvoTmp.get(0).getPrimaryKey();
String sqlWhere =
" isnull(dr,0) = 0 and operatorid like '" + old_cuserid.toString() + "'";
ArrayList<ZsqVO> zsqvo = (ArrayList<ZsqVO>) (dao.retrieveByClause(ZsqVO.class, sqlWhere));
if (null != zsqvo && 0 != zsqvo.size()) {
if ((null != zsqvo.get(0).getAuthorid())
&& !old_cuserid.equals(zsqvo.get(0).getAuthorid())) {
// 被授权人的人员id
String new_cuserid = zsqvo.get(0).getAuthorid();
Date date1 = new Date(System.currentTimeMillis());
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
String currDateStr = df.format(date1);
UFDate currDate = new UFDate(currDateStr);
UFDateTime uft = new UFDateTime(System.currentTimeMillis());
UFDateTime end_date = null;
if (null != zsqvo.get(0).getEnd_author()) {
end_date = zsqvo.get(0).getEnd_author();
}
boolean is_youxiao = false;
if (null != end_date) {
is_youxiao = uft.before(end_date);
}
boolean is_everl_author = false;
if (null != zsqvo.get(0).getIs_everl_author()) {
is_everl_author = zsqvo.get(0).getIs_everl_author().booleanValue();
}
if (null == new_cuserid) {
reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person());
reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug());
reqMainVO.setZdy1(reqMainDeptVO.getZdy1());
} else if (is_youxiao || is_everl_author) {
// 查询出被授权人人员的编码
// 当被授权人为操作人员时
// List<PsndocVO> psnvo = (List<PsndocVO>)dao.executeQuery( "SELECT
// bd.pk_psndoc FROM bd_psndoc bd , sm_userandclerk sm WHERE " +
// " sm.userid='"+new_cuserid+"' AND sm.pk_psndoc = bd.pk_psnbasdoc", new
// BeanListProcessor(PsndocVO.class));
String sqlPsn = " pk_psndoc like '" + new_cuserid + "'";
ArrayList<PsndocVO> psnvo =
(ArrayList<PsndocVO>) (dao.retrieveByClause(PsndocVO.class, sqlPsn));
// String sqlUser = "******"+new_cuserid+"'";
// ArrayList<SmUserVO> asqvo =
// (ArrayList<SmUserVO>)(dao.retrieveByClause(SmUserVO.class, sqlUser));
// String str_code = asqvo.get(0).getUser_code();
// String sqlPsn = " psncode like '"+str_code+"'";
// ArrayList<PsndocVO> psnvo =
// (ArrayList<PsndocVO>)(dao.retrieveByClause(PsndocVO.class, sqlPsn));
//
// ((AggReqVO)ncobjects[i].getContainmentObject()).getParentVO().setAttributeValue("pk_oper_person", psnvo.get(0).getPk_psndoc());
reqMainVO.setPk_oper_person(psnvo.get(0).getPk_psndoc());
reqMainVO.setPk_dept_sug(psnvo.get(0).getPk_deptdoc());
reqMainVO.setZdy1(psnvo.get(0).getPk_corp());
} else {
reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person());
reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug());
reqMainVO.setZdy1(reqMainDeptVO.getZdy1());
}
} else {
reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person());
reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug());
reqMainVO.setZdy1(reqMainDeptVO.getZdy1());
}
} else {
reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person());
reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug());
reqMainVO.setZdy1(reqMainDeptVO.getZdy1());
}
} else {
reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person());
reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug());
reqMainVO.setZdy1(reqMainDeptVO.getZdy1());
}
} catch (DAOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
// yanlei end
String sql =
" select * from ebs_xq_req_item_prod where pk_xq_req_main ='"
+ key
+ "' and isnull(dr,0) = 0";
// 查找合同表体数据
try {
List<ReqItemProdVO> list =
(List<ReqItemProdVO>) dao.executeQuery(sql, new BeanListProcessor(ReqItemProdVO.class));
if (list == null || list.size() <= 0) {
return "表体数据无数据!";
}
} catch (Exception e) {
}
reqMainVO.setAccept_status(Integer.valueOf(3));
if (flagTmp) reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person());
// 申请人
String pk_persom = reqMainDeptVO.getOperatorid();
// 申请处理人
// yanlei start 当未授权时，发件人为原处理人，有授权人时，发件人变为被授权人
String pk_oper_person = reqMainVO.getPk_oper_person();
String psnname = "";
String email = "";
String person = "";
String email_s = "";
String dianhua = "";
String deptName = "";
DzcgMainAuthority dma = new DzcgMainAuthority();
try {
// 获取人员管理档案信息
PsndocVO pvo = dma.getPsndocByPk(pk_oper_person);
PsndocVO pdvo = dma.getPsndocVO(pk_persom);
DeptdocVO dept = dma.getDeptInfo(reqMainDeptVO.getPk_dept());
if (pvo != null) {
// 处理人员
psnname = pvo.getPsnname();
PsnbasdocVO pbvo = null;
pbvo = dma.getPsnbasdocVOByPk(pvo.getPk_psnbasdoc());
if (pbvo != null) {
// 处理人邮箱
email = pbvo.getEmail();
}
}
if (dept != null) {
deptName = dept.getDeptname();
}
if (pdvo != null) {
// 申请人名称
person = pdvo.getPsnname();
PsnbasdocVO pcvo = null;
pcvo = dma.getPsnbasdocVOByPk(pdvo.getPk_psnbasdoc());
if (pcvo != null) {
// 申请人电话邮箱
email_s = pcvo.getEmail();
dianhua = pcvo.getMobile();
}
}
} catch (Exception e) {
Logger.error("采购申请提交受理,发送email时获取人员档案信息失败!");
Logger.error(e.getMessage());
}
// ---zhoqui--修改邮件发送内容---
String title = "新的采购项目等待您处理";
StringBuffer mail =
new StringBuffer(
psnname
+ "：<br> 电子采购系统（需求受理）中有新的采购项目等待您处理。<br> 项目名称【");
mail.append(reqMainDeptVO.getBill_name()).append("】【");
mail.append(reqMainDeptVO.getBill_code()).append("】<br><br>");
mail.append(deptName).append("<br>联系人：");
mail.append(person).append("(申请人)<br>电话：");
mail.append(dianhua).append("<br>邮箱：");
mail.append(email_s).append("<br>注：此邮件为系统自动发出，请勿直接回复。谢谢！");
dma.sendEmail(title, mail.toString(), email);
} else {
reqMainVO.setAccept_status(Integer.valueOf(4));
}
service.setReqVOValue(reqMainVO, fieldNames);
// 现在都是email的通信机制所以不发送代办事项
/*
try
{
IPredictQueryService queryService = (IPredictQueryService)NCLocator.getInstance().lookup(IPredictQueryService.class);
MessageinfoVO messageinfoVO = new MessageinfoVO();
messageinfoVO.setBillid(null);
messageinfoVO.setBillno("/manageui.jsp?ctrl=nc.ui.ebscg.xqreqaccept.ClientUIWebCtrl&model=nc.ui.ebscg.xqreqaccept.ReqAcceptPageModel&delegator=nc.ui.ebscg.xqreqaccept.ReqAcceptDelegator&pageId=E05405");
messageinfoVO.setContent((new StringBuilder("采购申请提交受理,请进入待处理查看！")).append(new UFDateTime(System.currentTimeMillis())).toString());
messageinfoVO.setPk_billtype("E04C");
messageinfoVO.setPk_corp(LfwRuntimeEnvironment.getPkCorp());
messageinfoVO.setPk_srcbilltype(messageinfoVO.getPk_billtype());
messageinfoVO.setSenddate(new UFDateTime(System.currentTimeMillis()));
messageinfoVO.setSenderman(LfwRuntimeEnvironment.getUserVO().getPrimaryKey());
messageinfoVO.setSendermanName(LfwRuntimeEnvironment.getUserVO().getUserName());
messageinfoVO.setPriority(new Integer(0));
List uaVOs = queryService.queryUserInfoByRolecode(reqMainDeptVO.getPk_dept_sug(), LfwRuntimeEnvironment.getCorp().getUnitcode(), "E05405");
messageinfoVO.setState(new Integer(0));
messageinfoVO.setType(new Integer(3));
if (uaVOs != null)
{
for (Iterator iterator = uaVOs.iterator(); iterator.hasNext(); dao.insertVO(messageinfoVO))
{
UserAndClerkVO uaVO = (UserAndClerkVO)iterator.next();
messageinfoVO.setCheckman(uaVO.getUserid());
}
}
}
catch (DAOException e1)
{
throw new LfwRuntimeException("向建议采购部门采购申请处理人发送待办失败！");
}
*/
result = "success";
return result;
}