📄 dailyarragement.java
字号:
package oa.bean;
import java.text.*;
import java.util.*;
import java.util.Date;
import java.lang.*;
import java.lang.Integer;
import java.io.*;
import java.sql.*;
import oa.main.*;
public class dailyArragement extends ParentBean
{
String strOrgNO = "-1";
String strPersonNO = "-1";
//构造函数
public dailyArragement()
{
}
//通过职工编号得到职工姓名
public String getPersonName(String strPersonNo)
{
return toName("ZZ_ZGB","ZGBH","XM",strPersonNo);
}
//设置是否提醒
public void setSFTX(String t)
{
}
//取得个人日程安排列表
public Vector getData(String personno)
{
Vector vect = new Vector();
String sql = "select * from ZZ_GRRCB where ZGBH='"+personno+"' order by SJ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
ResultSetMetaData rsmt = rs.getMetaData();//取得列数和列名
int cols = rsmt.getColumnCount();
while (rs.next())
{
Hashtable hash = new Hashtable();
for(int i=1;i<=cols;i++)
{
String field = ds.toString(rsmt.getColumnName(i));
String value = ds.toString(rs.getString(i));
if(field.equals("SFTX"))
{
if(value.equals("0")) value = "不提醒";
if(value.equals("1")) value = "提醒";
}
if(value==null) value = "";
hash.put(field,value);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("dailyArragement.getData(String)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("dailyArragement.getData(String)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("dailyArragement.getData(String)关闭声明时statement出错"+e);}
}
return vect;
}
//取得一个日程信息
public Hashtable getOneData(String personno,String xh)
{
Hashtable hash = new Hashtable();
String sql = "select * from ZZ_GRRCB where ZGBH='"+personno+"' and RCXH="+xh;
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
ResultSetMetaData rsmt = rs.getMetaData();//取得列数和列名
int cols = rsmt.getColumnCount();
while (rs.next())
{
for(int i=1;i<=cols;i++)
{
String field = ds.toString(rsmt.getColumnName(i));
String value = ds.toString(rs.getString(i));
if(field.equals("SFTX"))
{
if(value.equals("0")) value = "不提醒";
if(value.equals("1")) value = "提醒";
}
if(value==null) value = "";
hash.put(field,value);
}
}
}catch(Exception e){System.out.println("dailyArragement.getOneData(String,String)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("dailyArragement.getOneData(String,String)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("dailyArragement.getOneData(String,String)关闭声明时statement出错"+e);}
}
return hash;
}
//取得个人日程最大序号+1
public String getXH(String personno)
{
int xh=-1;
int maxxh=0;
String sql="select RCXH from ZZ_GRRCB where ZGBH='"+personno+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())
{
xh = Integer.parseInt(ds.toString(rs.getString("RCXH")));
if(xh > maxxh)
maxxh=xh;
}
}catch(Exception e){System.out.println("dailyArragement.getXH(String)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("dailyArragement.getXH(String)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("dailyArragement.getXH(String)关闭声明时statement出错"+e);}
}
return String.valueOf(maxxh+1);
}
//新增一条日程纪录
public int addRC(Hashtable hash)
{
String strZGBH = (String)hash.get("ZGBH");
String strXH = (String)hash.get("RCXH");
String strBT = (String)hash.get("BT");
String strNR = (String)hash.get("NR");
String strSJ = (String)hash.get("SJ");
String strTXSJ = (String)hash.get("TXSJ");
String strSFTX = (String)hash.get("SFTX");
Vector vect = new Vector();
vect.add("ZZ_GRRCB");
vect.add(addVector("ZGBH",strZGBH,"CHAR"));
vect.add(addVector("RCXH",strXH,"NUM"));
vect.add(addVector("BT",strBT,"CHAR"));
vect.add(addVector("NR",strNR,"CHAR"));
vect.add(addVector("SJ",strSJ,"CHAR"));
vect.add(addVector("TXSJ",strTXSJ,"CHAR"));
vect.add(addVector("SFTX",strSFTX,"NUM"));
//检验是否已经存在
String sql = "select * from ZZ_GRRCB where ZGBH='"+strZGBH+"' and RCXH="+strXH;
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(!rs.next())
return insertRecord(vect);
}catch(Exception e){System.out.println("dailyArragement.addRC(Hashtable)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("dailyArragement.addRC(Hashtable)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("dailyArragement.addRC(Hashtable)关闭声明时statement出错"+e);}
}
return 1;
}
//修改一条日程纪录
public int modRC(Hashtable hash)
{
String strZGBH = (String)hash.get("ZGBH");
String strXH = (String)hash.get("RCXH");
String strBT = (String)hash.get("BT");
String strNR = (String)hash.get("NR");
String strSJ = (String)hash.get("SJ");
String strTXSJ = (String)hash.get("TXSJ");
String strSFTX = (String)hash.get("SFTX");
Vector vect = new Vector();
vect.add("ZZ_GRRCB");
vect.add(addVector("BT",strBT,"CHAR"));
vect.add(addVector("NR",strNR,"CHAR"));
vect.add(addVector("SJ",strSJ,"CHAR"));
vect.add(addVector("TXSJ",strTXSJ,"CHAR"));
vect.add(addVector("SFTX",strSFTX,"NUM"));
vect.add("ZGBH='"+strZGBH+"' and RCXH= "+strXH);
return updateRecord(vect);
}
//删除一条日程纪录
public int delRC(String personno,String xh)
{
if(xh.equals(""))
return 0;
String sql = "delete from ZZ_GRRCB where ZGBH='"+personno+"' and RCXH in("+xh+")";
return deleteRecord(sql);
}
//某月的天数
public int getDaysInMonth(int m,int y)
{
int number=30;
switch(m)
{
case 1: case 3: case 5: case 7: case 8: case 10: case 12: number = 31;break;
case 4: case 6: case 9: case 11: number = 30;break;
case 2: {
if((y%4==0 && y%100!=0) || y%400==0)//润年与非润年
number = 29;
else
number = 28;
break;
}
}
return number;
}
//某月第一天的所在周次
public int getWeekdayMonthStartsOn(int m,int y)
{
Date da = new Date(y-1900,m-1,1);
return da.getDay();
}
//上一个月
public String subtractOneMonth(int y,int m,int d)
{
if(m == 1)
{ m = 12;
y = y - 1;
}
else
m = m - 1;
if(d > getDaysInMonth(m, y))
d = getDaysInMonth(m, y);
String stry = String.valueOf(y);
while(stry.length() < 4)
stry = "0" +stry;
String strm = String.valueOf(m);
while(strm.length() < 2)
strm = "0" +strm;
String strd = String.valueOf(d);
while(strd.length() <2)
strd = "0" +strd;
return stry+"-"+strm+"-"+strd;
}
//下一个月
public String addOneMonth(int y,int m,int d)
{
if(m == 12)
{
m = 1;
y = y + 1;
}
else
m = m + 1;
if(d > getDaysInMonth(m, y))
d = getDaysInMonth(m, y);
String stry = String.valueOf(y);
while(stry.length() < 4)
stry = "0" +stry;
String strm = String.valueOf(m);
while(strm.length() < 2)
strm = "0" +strm;
String strd = String.valueOf(d);
while(strd.length() <2)
strd = "0" +strd;
return stry+"-"+strm+"-"+strd;
}
//转化为汉字表示的月份
public String MonthName(int m)
{
String str="";
switch(m)
{
case 1: str="一月";break;
case 2: str="二月";break;
case 3: str="三月";break;
case 4: str="四月";break;
case 5: str="五月";break;
case 6: str="六月";break;
case 7: str="七月";break;
case 8: str="八月";break;
case 9: str="九月";break;
case 10: str="十月";break;
case 11: str="十一月";break;
case 12: str="十二月";break;
default: str="一月";break;
}
return str;
}
//判断设定的日期是否存在
public boolean IsDate(String date)
{
if(date.equals("")) return false;
if(date.length() != 10) return false;
if(!date.equals("") && date.length()==10)
{
String stry = date.substring(0,4);
stry = stry.trim();
String strm = date.substring(5,7);
strm = strm.trim();
if(strm.charAt(0)=='0') strm = strm.substring(1);
//字符串用equals(""),数字(int,long,float等)以及字符(char)用"=="
String strd = date.substring(8);
strd = strd.trim();
if(strd.charAt(0)=='0') strd = strd.substring(1);
int y = Integer.parseInt(stry);
int m = Integer.parseInt(strm);
int d = Integer.parseInt(strd);
if(m > 12) return false;
if(d > getDaysInMonth(m,y)) return false;
}
return true;
}
public int clearRecord(String personno){
return deleteRecord("delete from ZZ_GRRCB where ZGBH='"+personno+"'");
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -