package com.sp2p.dao;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.apache.commons.lang.StringEscapeUtils;
import com.shove.data.DataException;
import com.shove.data.DataSet;
import com.shove.util.BeanMapUtils;
import com.sp2p.database.Dao;
import com.sp2p.database.Dao.Tables;
import com.sp2p.database.Dao.Views;
import com.sp2p.database.Dao.Tables.t_help_question;
import com.sp2p.database.Dao.Views.v_t_borrow_list;
/**
* 友情链接列表处理
* @author li.hou
*
*/
public class LinksDao {
/**
* 添加友情链接信息
* @param conn 数据库连接
* @param companyName 公司名称
* @param companyImg 公司图片
* @param companyURL 公司网址
* @param serialCount 序列号
* @param dateTime 时间
* @return
* @throws SQLException
*/
public Long addLinks(Connection conn,String companyName,String companyImg,String companyURL,
Long serialCount,String dateTime) throws SQLException{
Dao.Tables.t_links tlinks = new Dao().new Tables().new t_links();
if(companyName != null)
tlinks.companyName.setValue(companyName);
if(companyImg != null)
tlinks.companyImg.setValue(companyImg);
if(companyURL != null)
tlinks.companyURL.setValue(companyURL);
if(serialCount != null && serialCount > 0)
tlinks.serialCount.setValue(serialCount);
if(dateTime != null)
tlinks.publishTime.setValue(dateTime);
return tlinks.insert(conn);
}
/**
* 添加首页滚动图片
* @return
* @author Administrator
*/
public Long addIndexRollImg(Connection conn,String companyImg,
Long serialCount,String dateTime,Long ordershort,int cardStatus) throws SQLException{
Dao.Tables.t_links tlinks = new Dao().new Tables().new t_links();
if(companyImg != null)
tlinks.companyImg.setValue(companyImg);
if(serialCount != null && serialCount > 0)
tlinks.serialCount.setValue(serialCount);
if(dateTime != null)
tlinks.publishTime.setValue(dateTime);
if(ordershort != null)
tlinks.ordershort.setValue(ordershort);
tlinks.type.setValue(cardStatus);//3表示是首页滚动图片
return tlinks.insert(conn);
}
/**
* 删除友情链接信息
* @param conn
* @param ids
* @return
* @throws SQLException
*/
public Long deleteLinks(Connection conn,String ids) throws SQLException{
String idStr = StringEscapeUtils.escapeSql("'"+ids+"'");
String idSQL = "-2";
idStr = idStr.replaceAll("'", "");
String [] array = idStr.split(",");
for(int n=0;n<=array.length-1;n++){
idSQL += ","+array[n];
}
Dao.Tables.t_links t_links = new Dao().new Tables().new t_links();
return t_links.delete(conn, " serialCount in("+idSQL+")");
}
/**
* 根据友情链接id找友情链接信息
* @param conn
* @param id
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> queyLinksInfoById(Connection conn, long id) throws SQLException, DataException {
Dao.Tables.t_links t_links = new Dao().new Tables().new t_links();
DataSet dataSet = t_links.open(conn, "", " serialCount=" + id, "", -1, -1);
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 友情链接信息
* @param conn
* @param id
* @return
* @throws SQLException
* @throws DataException
*/
public List<Map<String, Object>> queyLinksInfoList(Connection conn) throws SQLException, DataException {
Dao.Tables.t_links t_links = new Dao().new Tables().new t_links();
DataSet dataSet = t_links.open(conn, "", "LIMIT 0,7 ", "", -1, -1);
dataSet.tables.get(0).rows.genRowsMap();
return dataSet.tables.get(0).rows.rowsMap;
}
/**
* 根据友情链接序列号更新对应序列号的友情链接信息
* @param conn
* @param companyName
* @param companyImg
* @param companyURL
* @param serialCount
* @param dateTime
* @return
* @throws SQLException
*/
public Long updateLinks(Connection conn,String companyName,String companyImg,String companyURL,
Long serialCount,String dateTime) throws SQLException{
Dao.Tables.t_links t_links = new Dao().new Tables().new t_links();
if(companyName!=null){
t_links.companyName.setValue(companyName);
}
if(companyImg!=null){
t_links.companyImg.setValue(companyImg);
}
if(companyURL!=null){
t_links.companyURL.setValue(companyURL);
}
if(serialCount!=null && serialCount > 0){
t_links.serialCount.setValue(serialCount);
}
if(dateTime!=null){
t_links.publishTime.setValue(dateTime);
}
/*if(publisher!=null){
questions.publisher.setValue(publisher);
}
if(publishTime!=null){
questions.publishTime.setValue(publishTime);
}*/
return t_links.update(conn, " serialCount="+serialCount);
}
/**
* 修改首页滚动图片
* @return
* @author Administrator
*/
public Long updateIndexRollImg(Connection conn,String companyImg,
Long serialCount,Long ordershort,String dateTime) throws SQLException{
Dao.Tables.t_links t_links = new Dao().new Tables().new t_links();
if(companyImg!=null){
t_links.companyImg.setValue(companyImg);
}
if(ordershort!=null){
t_links.ordershort.setValue(ordershort);
}
if(serialCount!=null && serialCount > 0){
t_links.serialCount.setValue(serialCount);
}
if(dateTime!=null){
t_links.publishTime.setValue(dateTime);
}
return t_links.update(conn, " serialCount="+serialCount+" AND type = 3 ");
}
public Map<String,String> getMaxSerial(Connection conn)throws SQLException, DataException{
Dao.Tables.t_links tLinks = new Dao().new Tables().new t_links();
DataSet dataSet = tLinks.open(conn, "max(serialCount)", " type = 1 ", "", -1, -1);
return BeanMapUtils.dataSetToMap(dataSet);
}
public Map<String,String> getMaxIndexRollImgSerial(Connection conn)throws SQLException, DataException{
Dao.Tables.t_links tLinks = new Dao().new Tables().new t_links();
DataSet dataSet = tLinks.open(conn, "max(serialCount)", "", "", -1, -1);
return BeanMapUtils.dataSetToMap(dataSet);
}
}