1 动态读取组织人员 根据选择人员 动态生成对应类别
mainActivity.model1Load = function(event){
//找对应下的人
var xjry = "";
var xjryh = "";
//登录人找下级人员号
justep.Request.sendBizRequest2({
action:"findxiajiryAction",
dataType: "json",
callback: function(result){
if(result.state){
xjryh =result.response;
}
}
});
// alert(xjry);
//下级人员号找员工姓名
var qactionParam = new justep.Request.ActionParam();
qactionParam.setString("xjryh",xjryh);
justep.Request.sendBizRequest2({
action:"xjyghFindygxmAction",
dataType: "json",
parameters :qactionParam,
callback: function(result){
if(result.state){
xjry =result.response;
}
}
});
var xjrys = xjry.split(",");
var xjryhs = xjryh.split(",");
var html2 = '<input name="a" type="radio" value="全部" οnclick="onRadioBoxClick()"/><label for="a">全部</label>';
$("#div1").append(html2);
for ( var i = 0; i< xjrys.length; i++){
var v =xjrys[i];
var v2 =xjryhs[i];
// alert(v+"==="+ xjrys.length);
// var checked = ""; d.getCount() d.getValue('fZZXM',rowid);
// if(value.indexOf(v) > -1){
// checked = "checked";
// }
var html = '<input name="a" type="radio" value="'+v2+'" οnclick="onRadioBoxClick()"/><label for="a">'+v+'</label>';
$("#div1").append(html);
}
justep.xbl('trigger10').setDisabled(true);
};
function onRadioBoxClick(){
justep.xbl('trigger10').setDisabled(false);
var x=document.getElementsByName("a");
var value='';
for (var i=0;i<x.length;i++){
// value = value + x[i].value + ",";
if(x[i].checked){
value = x[i].value ;
// alert(value);
ryradiovalue =value;
}
}
staticygh= value;
var rylx ="";
var actionParam = new justep.Request.ActionParam();
actionParam.setString("ygh",value);
justep.Request.sendBizRequest2({
action:"findlxbyYghAction",
dataType: "json",
parameters :actionParam,
callback: function(result){
if(result.state){
rylx =result.response;
}
}
});
//先清空div内容
document.getElementById("div2").innerHTML="";
var rylxs = rylx.split(",");
for ( var i = 0; i< rylxs.length; i++){
var v =rylxs[i];
// alert(v+"==="+ xjrys.length);
// var checked = ""; d.getCount() d.getValue('fZZXM',rowid);
// if(value.indexOf(v) > -1){
// checked = "checked";
// }
var html = '<input name="b" type="radio" value="'+v+'" οnclick="onRadioBoxClick2()"/><label for="b">'+v+'</label>';
$("#div2").append(html);
}
//根据员工姓名过滤数据 如果选中的是全部 删除掉过滤条件
if("全部"==ryradiovalue){
//alert(ryradiovalue);
justep.xbl('bizData3').filters.deleteFilter('xmFilter');
justep.xbl('bizData3').refreshData();
justep.xbl('trigger10').setDisabled(true);
}else{
var data = justep.xbl('bizData3');
data.filters.setFilter("xmFilter","fJHYGH = '"+staticygh+"'");
data.refreshData();
}
//justep.xbl('dataMain').setValue("fRYQK", value); //设置字段值
}
function onRadioBoxClick2(){
var x=document.getElementsByName("b");
var value='';
for (var i=0;i<x.length;i++){
// value = value + x[i].value + ",";
if(x[i].checked){
value = x[i].value ;
// alert(value);
}
staticyglx = value;
}
}
这个需要在 页面加一个view 然后找到view后 在中间加 <div id="div1" ></div> <div id="div2" ></div>
<xui:view auto-load="true" id="view1" class="xui-container">
<layout type="absolute" style="position:relative;" id="layout1">
<div id="div1" padding-left="1000"></div>
</layout></xui:view>
2 根据数据有无延期情况 有延期的 时间会显示成红色
mainActivity.bizData3AfterRefresh = function(event){
//如果计划有延误 日期 标注为红色
var querydata = justep.xbl('bizData3');
//var grid = justep.xbl('grid3');
for (var i = 0; i < querydata.getCount(); i++){
//有实际日期 获取数据的ID
var rowid = querydata.getID(i);
//获得对应数据ID的 对应字段
var ywgb = querydata.getValue('fJHYWGB',rowid);
//alert(rowid);
if("是"==ywgb){
//grid.grid.setCellTextStyle(rowid,3,"background-color: red");
justep.xbl('grid3').grid.setCellTextStyle(rowid,4,"background-color: red");
}
}
};
3 点击新增 自动带出部分数据
mainActivity.trigger10Click = function(event){
var data = justep.xbl('bizData3');
data.setValue("fJHLX", staticyglx);
// data.setValue("fJHYGXM", staticygxm);
data.setValue("fJHYGH", staticygh);
//根据员工号插入员工姓名
var actionParam = new justep.Request.ActionParam();
actionParam.setString("ygh",staticygh);
justep.Request.sendBizRequest2({
action:"findYghAction",
dataType: "json",
parameters :actionParam,
callback: function(result){
if(result.state){
data.setValue("fJHYGXM", result.response);
}
}
});
//插入权重
// alert(staticyglx);
var actionParam2 = new justep.Request.ActionParam();
actionParam2.setString("jhlx",staticyglx);
justep.Request.sendBizRequest2({
action:"findjhqzAction",
dataType: "json",
parameters :actionParam2,
callback: function(result){
if(result.state){
data.setValue("fJHQZ",result.response);
}
}
});
// 插入日期
var zhouqujians="";
justep.Request.sendBizRequest2({
action:"finweekdayAction",
dataType: "json",
callback: function(result){
if(result.state){
zhouqujians = result.response;
}
}
});
var weekdate = zhouqujians.split(",");
data.setValue("fJHKSSJ",weekdate[0]);
data.setValue("fJHJSSJ",weekdate[1]);
//插入所属团队
var actionParam6 = new justep.Request.ActionParam();
actionParam6.setString("ygh",staticygh);
justep.Request.sendBizRequest2({
action:"findSstdAction",
dataType: "json",
parameters :actionParam6,
callback: function(result){
if(result.state){
//alert(result.response);
data.setValue("fJHSSTD",result.response);
}
}
});
JAVA部分
import java.math.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;
import javax.naming.NamingException;
import org.dom4j.*;
import com.justep.model.Model;
import com.justep.model.ModelUtils;
import com.justep.system.data.*;
import com.justep.system.util.BizUtils;
import com.justep.util.Utils;
public class YT_TDKB {
static String dataModel = "/YT_TDKBXT/YT_TDKB/data";
public static String yghfindygxm(String zzygh) {
//之前是映射出错 尽量用复制 本来是fZBID 我写成了 FZBID
String[] ygh = zzygh.split(",");
String ygxm = "";
int f = 0;
int b = 0;
for(int a=0;a<ygh.length;a++){
String ksql = "select a.sName from SA_OPPerson a where a.sLoginName = '" + ygh[a] + "'";
Table table = KSQL.select(ksql, null, dataModel, null);
Iterator<Row> rows = table.iterator();
Row rs = null;
if (rows.hasNext()){
rs = rows.next();
//return (String) rs.getValue("sName");
ygxm +=(String) rs.getValue("sName")+",";
b++;
f++;
}else{
f++;
}
}
if(f!=b){
return "员工号错误";
}else{
return ygxm=ygxm.substring(0,ygxm.length()-1);
}
//
}
//获取员工登录号
public static String getsLoginName() {
String ksql = "select a.sLoginName from SA_OPPerson a where a = :currentPersonID()";
Table table = KSQL.select(ksql, null, dataModel, null);
Iterator<Row> rows = table.iterator();
Row rs = null;
if (rows.hasNext()) {
rs = rows.next();
}
//String loginname = com.justep.system.opm.api.Person.getLoginName();
return (String) rs.getValue("sLoginName");
}
//根据登录人找到对应的员工号 再用员工号找到对应的下级人员
public static String findxiajiry() throws Exception, Exception {
String loginname = getsLoginName();
String xjry = "";
String ksql2 = "select a.fZZYGH as ZZYGH from YT_TDKB_RYZZ a where ((a.fSJZZYGH = '" + loginname + "') or (a.fZZYGH = '" + loginname + "')) order by nlssort(fZZXM,'NLS_SORT=SCHINESE_PINYIN_M') ";
Connection connection = ModelUtils.getConnection(dataModel);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(ksql2);
Table table2 = BizUtils.resultSet2Table(resultSet, (Model) null);
Iterator<Row> rows2 = table2.iterator();
Row rs2 = null;
//找到上级的自己 现在可能只有找到自己一种情况 将来如果出现多个 下面再写个SQL 查出来上级的人员 然后拼接员工号
String name2 ="";
while (rows2.hasNext()) {
rs2 = rows2.next();
String name = (String) rs2.getValue("ZZYGH");
//name2 = (String) rs2.getValue("SJZZYGH");
xjry += name + ",";
}
String ksql3 = "select distinct a.fSJZZYGH as SJZZYGH from YT_TDKB_RYZZ a where a.fSJZZYGH = '" + loginname + "' order by nlssort(SJZZYGH,'NLS_SORT=SCHINESE_PINYIN_M') ";
Connection connection2 = ModelUtils.getConnection(dataModel);
Statement statement2 = connection2.createStatement();
ResultSet resultSet2 = statement2.executeQuery(ksql3);
Table table3 = BizUtils.resultSet2Table(resultSet2, (Model) null);
Iterator<Row> rows3 = table3.iterator();
Row rs3 = null;
while (rows3.hasNext()) {
rs3 = rows3.next();
String name3 = (String) rs3.getValue("SJZZYGH");
//name2 = (String) rs2.getValue("SJZZYGH");
if(xjry.indexOf(name3)==-1){
xjry+=name3+",";
}
}
//拼接一个的
xjry = xjry.substring(0, xjry.length() - 1);
System.out.println(xjry);
return xjry;
}
//根据员工号找类别
public static String findlxbyYgh(String ygh) {
String rylx = "";
//distinct 出去重复
String ksql2 = "select distinct a.fLBMC as LBMC ,a.fSFGY from YT_TDKB_LBSJ a ,YT_TDKB_LBRYB b where a.fid = b.fLBSJID and (b.fDYLBYGH = '" + ygh + "') or (a.fSFGY='是') order by a.fSFGY desc ";
System.out.println(ksql2+"员工号找类别");
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), ksql2);
Table table2 = SQL.select(sqlMap, null, dataModel);
//Table table2 = KSQL.select(ksql2, null, dataModel, null);
Iterator<Row> rows2 = table2.iterator();
Row rs2 = null;
while (rows2.hasNext()) {
rs2 = rows2.next();
String name = (String) rs2.getValue("LBMC");
rylx += name + ",";
}
rylx = rylx.substring(0, rylx.length() - 1);
System.out.println(rylx);
return rylx;
}
//根据员工号找人员姓名
public static String findYgh(String ygh) {
//之前是映射出错 尽量用复制 本来是fZBID 我写成了 FZBID
String ksql = "select a.sName from SA_OPPerson a where a.sLoginName = '" + ygh + "'";
Table table = KSQL.select(ksql, null, dataModel, null);
Iterator<Row> rows = table.iterator();
Row rs = null;
if (rows.hasNext()) {
rs = rows.next();
return (String) rs.getValue("sName");
}
return "无该人员姓名";
}
//根据类别找权重数据
public static String findjhqz(String jhlx) {
//之前是映射出错 尽量用复制 本来是fZBID 我写成了 FZBID
String ksql = "select a.fLBQZ from YT_TDKB_LBSJ a where a.fLBMC = '" + jhlx + "'";
Table table = KSQL.select(ksql, null, dataModel, null);
Iterator<Row> rows = table.iterator();
Row rs = null;
if (rows.hasNext()) {
rs = rows.next();
return (String) rs.getValue("fLBQZ");
}
return "";
}
//获取本5天周时间
public static String finweekday() {
Calendar c = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//-2的时候 日期增加
int weekday = c.get(7) - 2;
c.add(5, -weekday);
String beginday = sdf.format(c.getTime());
//5,5 5,6日期日期增加
c.add(5, 4);
String endday = sdf.format(c.getTime());
System.out.println(beginday + "本周开始时间：" + endday);
String zhouqujian = beginday + "," + endday;
return zhouqujian;
}
//获取本7天周时间
public static String finweek7day() {
Calendar c = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//-2的时候 日期增加
int weekday = c.get(7) - 2;
c.add(5, -weekday);
String beginday = sdf.format(c.getTime());
//5,5 5,6日期日期增加
c.add(5, 6);
String endday = sdf.format(c.getTime());
System.out.println(beginday + "本周开始时间：" + endday);
String zhouqujian = beginday + "," + endday;
return zhouqujian;
}
//根据查询计划表数据插入信息表数据的数据
public static Table findjhxx(String ygh) {
String zhouqujians = finweek7day();
String[] zhouqujian = zhouqujians.split(",");
//System.out.println(zhouqujian[0]+"===="+zhouqujian[1]);
//and a.fJHJSSJ >= stringToDate('" + zhouqujian[0] + "') and a.fJHJSSJ <= stringToDate('" + zhouqujian[1] + "')
String sql = "select a.fID as IDS, a.fJHJSSJ as JHJSSJ, a.fJHNR as JHNR,a.fJHYGH as JHYGH,a.fJHYGXM as JHYGXM,a.fJHLX as JHLX ,a.fJHQZ as JHQZ,a.fJHSSTD as JHSSTD ,a.fJHSFWC as JHSFWC from yt_tdkb_jhb a where a.fJHYGH = '"
+ ygh + "' and fJHSFWC = '否' ";
sql += "and a.fJHJSSJ >= to_date('" + zhouqujian[0] + "','yyyy-mm-dd') and a.fJHJSSJ <= to_date('" + zhouqujian[1] + "','yyyy-mm-dd') ";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
Table table = SQL.select(sqlMap, null, dataModel);
//Iterator<Row> rows2 = table.iterator();
System.out.println(sql + "我的数是多少");
// rs2.setInt("xxsum", xxsum);
// System.out.println(findjhxxSum(ygxm)+"我的数是多少");
return table;
}
//根据计划表插入信息表数据的条数
public static int findjhxxSum(String ygh) {
String zhouqujians = finweek7day();
String[] zhouqujian = zhouqujians.split(",");
String sql = "select a.fJHYGXM as JHYGXM from yt_tdkb_jhb a where a.fJHYGH = '" + ygh + "' and fJHSFWC = '否' ";
sql += "and a.fJHJSSJ >= to_date('" + zhouqujian[0] + "','yyyy-mm-dd') and a.fJHJSSJ <= to_date('" + zhouqujian[1] + "','yyyy-mm-dd') ";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
Table table = SQL.select(sqlMap, null, dataModel);
return table.size();
}
//根据修改计划日期 插入延误信息日志
public static void DbrqSaveXx(String orderID,String jhrq,String jhid) {
String sql = "select a.fXXJHRQ as XXJHRQ ,a.fXXXS as XXXS,a.fXXNR as XXNR ,a.fXXLB as XXLB,a.fXXSJSJ as XXSJSJ ,a.fSFWC as SFWC ,a.fXXYGH as XXYGH ,a.fXXYGXM as XXYGXM,a.fXXBZ as XXBZ ,a.fXXJHSJID as XXJHSJID,a.fXXSSTD as XXSSTD from yt_tdkb_xxlr a where a.fID = '"
+ orderID + "'";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
Table table = SQL.select(sqlMap, null, dataModel);
Iterator<Row> rows = table.iterator();
Row rs = null;
String xxnr = "";
String xxlb = "";
//Date s = null;
//Date d = null;
String s = null;
String d = null;
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String sfwc = "";
String ygh = "";
String ygxm = "";
String bz = "";
String xxxs = "";
String xxjhsjid = "";
String xxsstd = "";
if (rows.hasNext()) {
rs = rows.next();
s = rs.getValue("XXSJSJ").toString();
d = rs.getValue("XXJHRQ").toString();
xxlb = rs.getString("XXLB");//类别
xxnr = rs.getString("XXNR");//内容
sfwc = rs.getString("SFWC");//是否完工
ygh = rs.getString("XXYGH"); //员工号
ygxm = rs.getString("XXYGXM"); //员工姓名
bz = rs.getString("XXBZ"); //备注
xxxs = rs.getString("XXXS");
xxjhsjid= rs.getString("XXJHSJID");
xxsstd = rs.getString("XXSSTD");
}
System.out.println(xxjhsjid+"我是计划的数据ID");
if ("".equals(bz) || null == bz) {
bz = "";
}
if ("".equals(xxxs) || null == xxxs) {
xxxs = "";
}
if ("".equals(sfwc) || null == sfwc) {
sfwc = "";
}
String oldjhrq = "";
String sjsj = "";
if (null != s || null != d) {
//oldjhrq = sdf.format(d); //老的计划时间
//sjsj = sdf.format(s); //实际日期
oldjhrq=d;
sjsj=s;
}
Date now = new Date();
SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String nowdate = sdf2.format(now);
System.out.print(jhrq + "我是两个日期" + oldjhrq);
if (!oldjhrq.equals(jhrq) && null != s) {
//System.out.print("不等于");
KSQL.executeUpdate(
"insert into YT_TDKB_YWXX bb(bb,bb.version,bb.fYWNR,bb.fYWLX,bb.fSJRQ,bb.fJHXRQ,bb.fYWSFWC,bb.fYWYGH,bb.fYWYGXM,bb.fYWBZ,bb.fTDKBXXID,bb.fXS,bb.fYWCZSJ,bb.fTDKBJHID,bb.fYWSSTD) values "
+ "(:guid(),0,'"
+ xxnr
+ "','"
+ xxlb
+ "',stringToDate('"+sjsj+"'),stringToDate('"+oldjhrq+"'),'"
+ sfwc
+ "','"
+ ygh
+ "','"
+ ygxm
+ "','"
+ bz
+ "','"
+ orderID + "','" + xxxs + "','" + nowdate + "','" + xxjhsjid + "','"+xxsstd+"')", null, dataModel, null);
String ksql="update YT_TDKB_JHB a set a.fJHYWGB = '是' where a = '" + jhid + "' ";
//System.out.println(ksql+"更新时间语句");
KSQL.executeUpdate(ksql, null, dataModel, null);
}
}
//团队看板报表数据查询
public static Table queryTdkbReport(String sdate,String edate,String ygh,String ygxm,String sstd) {
String zhouqujians = finweek7day();
String[] zhouqujian = zhouqujians.split(",");
String sql = "select a.fXXJHRQ as XXJHRQ ,a.fXXXS as XXXS,a.fXXNR as XXNR ,a.fXXLB as XXLB,a.fXXSJSJ as XXSJSJ ,a.fSFWC as SFWC ,a.fXXYGH as XXYGH ,a.fXXYGXM as XXYGXM,a.fXXBZ as XXBZ,a.fXXQZ as XXQZ from yt_tdkb_xxlr a where 1=1 ";
if (Utils.isNotEmptyString(ygh)) {
sql += " and a.fXXYGH like '%" + ygh + "%' ";
}
if (Utils.isNotEmptyString(ygxm)) {
sql += " and a.fXXYGXM like '%" + ygxm + "%' ";
}
if (Utils.isNotEmptyString(sstd)) {
sql += " and a.fXXSSTD like '%" + sstd + "%' ";
}
//sql += "and a.fXXJHRQ >= to_date('" + zhouqujian[0] + "','yyyy-mm-dd') and a.fXXJHRQ <= to_date('" + zhouqujian[1] + "','yyyy-mm-dd') and a.fSFWC='是'";
sql += "and a.fXXJHRQ >= to_date('" + zhouqujian[0] + "','yyyy-mm-dd') and a.fXXJHRQ <= to_date('" + zhouqujian[1] + "','yyyy-mm-dd') ";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
Table table = SQL.select(sqlMap, null, dataModel);
System.out.println(sql + "我的报表SQL");
return table;
}
//根据下级的员工号集合 找到对应的姓名集合
public static String xjyghFindygxm(String xjryh) {
String[] fid = xjryh.split(",");
String xjry ="";
for (int a = 0; a < fid.length; a++){
//之前是映射出错 尽量用复制 本来是fZBID 我写成了 FZBID
String ksql = "select a.sName from SA_OPPerson a where a.sLoginName = '" + fid[a] + "' ";
Table table = KSQL.select(ksql, null, dataModel, null);
Iterator<Row> rows = table.iterator();
Row rs = null;
while (rows.hasNext()){
rs = rows.next();
xjry+= rs.getString("sName")+",";
}
}
xjry =xjry.substring(0,xjry.length()-1);
System.out.print(xjry+"我是人员号");
return xjry;
}
//如果信息为完工状态 记录日志 必须是有延误信息的情况下
public static void sfwcSaveXx(String orderID,String jhrq,String xxnr,String xxlb,String sjsj,String xxxs,String sfwc,String xxygh,String xxygxm,String xxbz,String xxjhid,String sstd){
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String nowdate = sdf.format(now);
KSQL.executeUpdate(
"insert into YT_TDKB_YWXX bb(bb,bb.version,bb.fYWNR,bb.fYWLX,bb.fSJRQ,bb.fJHXRQ,bb.fYWSFWC,bb.fYWYGH,bb.fYWYGXM,bb.fYWBZ,bb.fTDKBXXID,bb.fXS,bb.fYWCZSJ,bb.fTDKBJHID,bb.fYWSSTD) values "
+ "(:guid(),0,'"
+ xxnr
+ "','"
+ xxlb
+ "',stringToDate('"+sjsj+"'),stringToDate('"+jhrq+"'),'"
+ sfwc
+ "','"
+ xxygh
+ "','"
+ xxygxm
+ "','"
+ xxbz
+ "','"
+ orderID + "','" + xxxs + "','" + nowdate + "','" + xxjhid + "','" + sstd + "')", null, dataModel, null);
}
//求有多少条延误信息
public static int findYwxxSum(String orderID){
String ksql = "select a.fYWNR from YT_TDKB_YWXX a where a.fTDKBXXID = '" + orderID + "' ";
System.out.println(ksql);
Table table = KSQL.select(ksql, null, dataModel, null);
Iterator<Row> rows = table.iterator();
Row rs = null;
int sum =0;
if (rows.hasNext()){
sum =1;
}
return sum;
}
//根据员工号找所属团队
public static String findSstd(String ygh) {
//现在暂时以第一个输入的团队为主 将来有问题需要些成活的循环后 判断值一样不 团队不一样返回 错误信息 都一样就过
String[] yghs = ygh.split(",");
//for(int a =0;a<yghs.length;a++){
String ksql = "select a.fSSTD from YT_TDKB_RYZZ a where (a.fZZYGH = '" + yghs[0] + "') or (a.fSJZZYGH = '" + yghs[0] + "') ";
System.out.println(ksql);
Table table = KSQL.select(ksql, null, dataModel, null);
Iterator<Row> rows = table.iterator();
Row rs = null;
if (rows.hasNext()){
rs=rows.next();
return rs.getString("fSSTD");
}
return "";
}
//根据信息完工状态更新计划数据完工状态
public static void updateJhxx(String jhid){
String sql="update YT_TDKB_JHB a set a.fJHSFWC ='是' where a = '" + jhid + "' ";
KSQL.executeUpdate(sql, null, dataModel, null);
}
//修改任务信息的计划日期 计划表的结束时间变更
public static void updateJhrq(String jhid,String jhrq){
String sql = "select a.fJHJSSJ as JHJSSJ from YT_TDKB_JHB a where a.fID = '"+ jhid + "'";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
Table table = SQL.select(sqlMap, null, dataModel);
Iterator<Row> rows = table.iterator();
//Date jssj1 = null;
Row rs = null;
String jssj1="";
if (rows.hasNext()) {
rs = rows.next();
//if(null!=rs.getDateTime("JHJSSJ")){
// jssj1= rs.getDateTime("JHJSSJ");
jssj1= rs.getValue("JHJSSJ").toString();
//}
}
System.out.println(jssj1+"我是打印后台时间toString");
String jssj = "";
if("".equals(jssj1)){
// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
jssj = jssj1;
}
//!jssj.equals(jhrq)||
if(!"".equals(jssj)){
System.out.println(jssj+"==要修改的2个时间=="+jhrq);
String ksql="update YT_TDKB_JHB a set a.fJHJSSJ = stringToDate('"+jhrq+"') where a = '" + jhid + "' ";
System.out.println(ksql+"更新时间语句");
KSQL.executeUpdate(ksql, null, dataModel, null);
}
}
public static void insertlbygh(String ygh,String orderID){
String ksql="delete from YT_TDKB_LBRYB a where a.fLBSJID ='" + orderID + "' ";
KSQL.executeUpdate(ksql, null, dataModel, null);
String[] yghs = ygh.split(",");
for(int a =0;a<yghs.length;a++){
KSQL.executeUpdate(
"insert into YT_TDKB_LBRYB bb(bb,bb.version,bb.fLBSJID,bb.fDYLBYGH) values "
+ "(:guid(),0,'"
+ orderID + "','" + yghs[a] + "')", null, dataModel, null);
}
}
}
扫一扫
1338
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
