return doc;
}
public static JSONObject getjdhbmess1(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 查询对应人员的工作清单,这边作为对比字段是人员ID。项目ID
,文件状态为2 的,就是已经班组长确认过的数据才能在站班这边选择到
Connection conn = context.getConnection("jeecg37bzb");
String par_fID = params.getString("fID");//人员ID
String par_fName = params.getString("fName");//人员名称
java.sql.Date par_currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
String fProjectID = params.getString("fProjectID");//项目ID
JSONObject doc=new JSONObject();
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
String state = "2";
// 查询
String sql1 = "SELECT * FROM pm_project_persondetail2 m where
m.fTeamID = '"+par_fID+"' and m.fProjectCode='"+fProjectID+"'and
m.fStateID='"+state+"'";
System.out.println("第一次查询的的sql "+sql1);
//
Table table3 = DataUtils.queryData(conn, sql1, null,null,
null,null);
Iterator<Row> iterator3 = table3.getRows().iterator();
while (iterator3.hasNext()) {
Row info = iterator3.next();
String new_uuid =
UUID.randomUUID().toString();//获取UUID并转化为String对象 ID
String fNo = info.getString("fNo");//1
String paibanfID = info.getString("fID");//1
String fProjectName = info.getString("fProjectName");//2
String fProjectCode = info.getString("fProjectCode");//3
String fzhuangqd = info.getString("fzhuangqd");//4
String fMsterID = info.getString("fMsterID");//5
String fPtBasicType = info.getString("fPtBasicType");//6
String fPtBasicName = info.getString("fPtBasicName");//7
String fPtfID = info.getString("fPtfID");//8
String fPtfMasterID = info.getString("fPtfMasterID");//9
String fPtfOnlyone = info.getString("fPtfOnlyone");//10
String fPaibanIDTTT = info.getString("fPaibanIDTTT");//11
String fTeamName = info.getString("fTeamName");//11
String fTeamID = info.getString("fTeamID");//11
String fequallyS = info.getString("fequallyS");//11
String fWorkState = info.getString("fWorkState");//11
Date fStartTime = info.getDate("fStartTime");//11
Date fEndTime = info.getDate("fEndTime");//11
String fWorkType = info.getString("fWorkType");//11
String fOnlyone = info.getString("fOnlyone");//11
int fToalSum = info.getInteger("fToalSum");//11
int fSingle = info.getInteger("fSingle");//11
int fPlanSum = info.getInteger("fPlanSum");//
String fStateName = info.getString("fStateName");//11
String fStateID = info.getString("fStateID");//11
String fStateImg = info.getString("fStateImg");//11
//插入语句
String insertsql5="INSERT INTO
pm_project_persondetail2_jingdu VALUES" +
"(" +
"'"+new_uuid+"'," +
"'"+fNo+"'," +
"'"+fProjectName+"'," +
"'"+fProjectCode+"'," +
"'"+fzhuangqd+"'," +
"'"+fMsterID+"'," +
"'"+fPtBasicType+"'," +
"'"+fPtBasicName+"'," +
"'"+fPtfID+"'," +
"'"+fPtfMasterID+"'," +
"'"+fPtfOnlyone+"'," +
"'"+fPaibanIDTTT+"'," +
"'"+fTeamName+"'," +
"'"+fTeamID+"'," +
"'"+fequallyS+"'," +
"'"+fWorkState+"'," +
"'"+fStartTime+"'," +
"'"+fEndTime+"'," +
"'"+fWorkType+"'," +
"'"+fOnlyone+"'," +
"'"+fToalSum+"'," +
"'"+0+"'," +
"'"+0+"'," +
"'"+fStateName+"'," +
"'"+fStateID+"'," +
"'"+fStateImg+"'," +
"'"+paibanfID+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'," +
"'"+par_fID+"'," +
"'"+par_fName+"'," +
"'"+par_currentDate+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'" +
")";
//插入工序成功
stmt.executeUpdate(insertsql5);
System.out.println("第一次插入工序成功 ");
}
doc.put("zt", "成功");
return doc;
}
public static JSONObject getxmbgxaction1(JSONObject params,
ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//项目立项,项目部岗位选择成立岗位设置,根据每个项目部的不同来新增
岗位
Connection conn = (Connection)
context.getConnection("jeecg37bzb");// 获取数据库连接
String pid = params.getString("pid");//获取项目ID
String xmbid = params.getString("xmbid");//获取项目部门ID
String sn = params.getString("sn");//获取项目类别
String weri = "";
JSONObject doc=new JSONObject();
//操作容器
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//查询所属项目下的岗位设置,带条件 id, 类别
String sql1parmasin1 = "SELECT * FROM
pm_project_project_informationtable_postsetb m WHERE
m.fMasterID='"+pid+"' and m.fPostXlb='"+sn+"'";
Table table2 = DataUtils.queryData((java.sql.Connection) conn,
sql1parmasin1, null, null, null, null);
//遍历
Iterator<Row> iterator2 = table2.getRows().iterator();
System.out.println("现在查询的项目人员这边的时候sql是:"+sql1parma
sin1);
while (iterator2.hasNext()) {
//遍历获取到的数据
String new_uuid = UUID.randomUUID().toString();
//获取UUID并转化为String对象 ID
Row info1 = iterator2.next();
String fID = info1.getString("fID");
String fNo = info1.getString("fNo");
String fPostName = info1.getString("fPostName");
String fPostWriteName = info1.getString("fPostWriteName");
String fPostWriteID = info1.getString("fPostWriteID");
String fPostCode = info1.getString("fPostCode");
String fPostID = info1.getString("fPostID");
String fPostState = info1.getString("fPostState");
String fPostType = info1.getString("fPostType");
String fMasterID = info1.getString("fMasterID");
String fProjectName = info1.getString("fProjectName");
String fProjectCode = info1.getString("fProjectCode");
String fRoleName = info1.getString("fRoleName");
String fRoleID = info1.getString("fRoleID");
String fMd51 = info1.getString("fMd5");
String fPostXlb = info1.getString("fPostXlb");
String fPostxmid = info1.getString("fPostxmid");
//插入数据,插入时候插入项目部主键为项目外键
System.out.println("返回的结果集是"+fID);
String sql1 ="insert into
pm_project_project_informationtable_postsetb" +
"(fID," +
"fNo," +
"fPostName," +
"fPostWriteName," +
"fPostWriteID," +
"fPostCode," +
"fPostID," +
"fPostState," +
"fPostType," +
"fMasterID," +
"fProjectName," +
"fProjectCode," +
"fRoleName," +
"fRoleID," +
"fPostxmid1," +
"fPostxmid2," +
"fMd5," +
"fPostXlb," +
"fPostxmid)" +
"values" +
"('"+new_uuid+"'," +
"'"+fNo+"'," +
"'"+fPostName+"'," +
"'"+weri+"'," +
"'"+fPostWriteID+"'," +
"'"+fPostCode+"'," +
"'"+fPostID+"'," +
"'"+fPostState+"'," +
"'"+fPostType+"'," +
"'"+fMasterID+"'," +
"'"+fProjectName+"'," +
"'"+fProjectCode+"'," +
"'"+fRoleName+"'," +
"'"+fRoleID+"'," +
"'"+new_uuid+"'," +
"'"+new_uuid+"'," +
"'"+fMd51+"'," +
"'"+fPostXlb+"'," +
"'"+xmbid+"')";
stmt.executeUpdate(sql1);
System.out.println("第一次插入岗位成功");
}
//返回数据集
doc.put("state","成功");
return doc;
}
public static JSONObject getloginselectProjectList1(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//登录查询项目
Connection conn = (Connection)
context.getConnection("jeecg37bzb");// 获取数据库连接
String sName = params.getString("sName");//获取桩号或者区段主键
String sID = params.getString("sID");//获取类别
String md5 = params.getString("md5");//
JSONObject doc=new JSONObject();
//操作容器
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//查询项目人员表中有几个当前人的ID
String sql1parmasin1 = "SELECT * FROM
pm_project_project_informationtable_postsetb_people m WHERE
m.fPostWriteID like'%"+sID+"%'";
System.out.println("第一次插入岗位成功"+sql1parmasin1);
// 查询
try {
//
Table a = DataUtils.queryData(conn, sql1parmasin1, null,
null, null, null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
}
Connection conn = (Connection)
context.getConnection("jeecg37bzb");// 获取数据库连接
String s_fID = params.getString("id");//获取项目主键
String s_fPrjoectName =
params.getString("fPrjoectName");//获取项目名称
String s_fProjectCode =
params.getString("fProjectCode");//获取项目编码
define(function(require){
var $ = require("jquery");
var justep = require("$UI/system/lib/justep");
var SqliteUtil =
require("$UI/ProjectSubcontracting_demo1/ProjectSub_20180102/prodata_0
01/project_class/pro_db/sqliteUtil");
var DemoDB =
require("$UI/ProjectSubcontracting_demo1/ProjectSub_20180102/prodata_0
01/project_class/pro_db/demoDB");
var Model = function(){
this.callParent();
this.demoDB = null;
};
Model.prototype.modelLoad = function(event){
//onload
/*var sData = this.comp("data1");
var storage=window.localStorage;
var LoginSGG =storage["Door_sLoginSLogoinGo"];//获取当前登录状态
//!==
if(!LoginSGG){
alert("登录状态为空,请确认登录状态");
} else{
if(LoginSGG=="是"){
if (!justep.Browser.isX5App) {
alert("本案例只支持在手机APP中运行");
return;
}
var self = this;
// 设备准备好后,才能通过插件打开数据库
document.addEventListener("deviceready", function() {
//
这里在DemoDB.js中实现了一个单例对象,为了能在多个功能
页中共用一个数据源,避免死锁
self.demoDB = DemoDB.getInstance();
// DemoDB.js中实现了自动判断并初始化数据库
self.demoDB.initData(function() {
// 初始化后刷新列表
self.comp("list1").refresh(true);
});
});
}else if(LoginSGG=="否"){
//!==
justep.Baas.sendRequest({
"url" :
"/pm_ProjectfenBao/pm_Project_Basic_TeamChange1",
"action" : "queryPm_project_basic_main_gongzuorenwu4",
"async" : false,
"params" : {
"limit" : event.limit,
"offset" : event.offset,
"filter" : sData.getFilter("filter")
// "orderBy" : "ADDTIME desc"
// "columns" :
baas.getDataColumns(thisObject.comp("todoData"))
},
"success" : function(data) {
sData.loadData(data, false);
}
});
}
}*/
};
Model.prototype.Submit1 = function(event){
/*//保存事件
var sdata = this.comp("data1");
var self = this;
var storage =window.localStorage;
var LoginSGG =storage["Door_sLoginSLogoinGo"];//获取当前登录状态
//!==
if(!LoginSGG){
alert("登录状态为空,请确认登录状态");
}else{
if(LoginSGG=="是"){
// 标记当前保存是异步执行的
event.async = true;
var db = this.demoDB.getDatabase();
var data = event.source;
SqliteUtil.saveData(db, data, "DEMO_Class1", null,
function(res) {
// 异步执行模式下,保存成功后必须执行doSaveAfter
data.doSaveAfter(true, event.options);
}, function(msg) {
data.doSaveAfter(false, event.options);
});
}else if(LoginSGG=="否"){
//在线保存
sdata.saveData();
alert("保存成功");
}
}*/
// 标记当前保存是异步执行的
event.async = true;
var db = this.demoDB.getDatabase();
var data = event.source;
SqliteUtil.saveData(db, data, "DEMO_Class1", null, function(res) {
// 异步执行模式下,保存成功后必须执行doSaveAfter
data.doSaveAfter(true, event.options);
}, function(msg) {
data.doSaveAfter(false, event.options);
});
};
Model.prototype.zbhClick = function(event){
//站班会
};
Model.prototype.data1CustomRefresh = function(event){
//接管刷新事件
var sdata = this.comp("data1");
var storage =window.localStorage;
var LoginSGG =storage["Door_sLoginSLogoinGo"];//获取当前登录状态
//!==
if(!LoginSGG){
alert("登录状态为空,请确认");
}else{
if(LoginSGG=="是"){
//离线登录#
// 标记当前刷新是异步执行的
event.async = true;
var db = this.demoDB.getDatabase();
var data = event.source;
var append = event.options && event.options.append; //
是否数据追加模式
var limit = event.limit; // 分页行数
var offset = event.offset; // 分页偏移
// 执行SQL查询
SqliteUtil.executeSql(db, "SELECT * FROM DEMO_Class1
LIMIT ? OFFSET ? ", [ limit, offset ], onSuccess,
onError);
function onSuccess(res) {
// 转换返回数据结果
var table = SqliteUtil.rowsToTable(res.rows);
if (offset == 0) {
//
如果偏移为零则表明加载第一页,需要在Table中提供总
行数,用于分页计算
SqliteUtil.executeSql(db, "SELECT COUNT(*) cnt
FROM DEMO_Class1 ", [], function(res) {
SqliteUtil.setTableTotal(table,
res.rows.item(0).cnt);
doRefreshData();
});
} else {
doRefreshData();
}
function doRefreshData() {
data.loadData(table, append);
//
异步执行模式下,加载数据后必须执行doRefreshAfter
data.doRefreshAfter(true, event.options);
}
}
function onError(msg) {
data.doRefreshAfter(false, event.options);
}
}else if(LoginSGG=="否"){
//!$$
justep.Baas.sendRequest({
"url" :
"/pm_ProjectfenBao/pm_Project_Basic_TeamChange1",
"action" : "queryPm_project_basic_main_gongzuorenwu4",
"async" : false,
"params" : {
"limit" : event.limit,
"offset" : event.offset,
"filter" : sdata.getFilter("filter")
// "orderBy" : "ADDTIME desc"
// "columns" :
baas.getDataColumns(thisObject.comp("todoData"))
},
"success" : function(data) {
sdata.loadData(data, false);
}
});
}
}
};
Model.prototype.button2Click = function(event){
//离线状态
var storage =window.localStorage;
storage["Door_sLoginSLogoinGo"]="是";
};
Model.prototype.button5Click = function(event){
var storage =window.localStorage;
storage["Door_sLoginSLogoinGo"]="否";
};
return Model;
});
//
require("$UI/system/lib/cordova/cordova");
require("css!$UI/demo/native/common/pub").load();
require("cordova!cordova-plugin-camera");
require("cordova!cordova-plugin-media-capture");
require("cordova!cordova-plugin-inappbrowser");
Model.prototype.newwork2 = function(event){
// 新增排版表数据 ,组塔
var data7 =this.comp("pro_main");
var data1 =this.comp("pro_zhuang_z");//桩号区段表
var data2 =this.comp("pro_work11");//排班表
var data3 =this.comp("pro_work22");//工序表
//获取参数
var s_sum= data1.getValue("fBasicsSubPlanSum");
var s_fid= data1.getValue("fID");
var s_date = new Date();
var pro_id= data7.getCurrentRowID();
var s_name= data1.getValue("fPostName");
//排班主表
var fWorkType = $(this.getElementByXid("spanzt1")).html();
data2.newData();
var dat2_id = data2.getCurrentRowID();
data2.setValue("fMasterID",s_fid);
data2.setValue("fWriteTime",s_date);
data2.setValue("fwanLiang",s_sum);
data2.setValue("fWorkType",fWorkType);
//排班从表
var span1 = $(this.getElementByXid("spanzt1")).html();
var span2= $(this.getElementByXid("spanzt2")).html();
//调用动作,去后台判断工序新增是要新增项目工序还是桩后面的工序
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getzhuangquduangxmesagge1",
"async" : false,
"params" : {
"id" : s_fid ,
"type1" : span1 ,
"type2" : span2 ,
"pro_id" : pro_id
},
"success" : function(emp) {
var mg_s =emp.gx.rows.length;
for(var i =0;i<mg_s;i++){
data3.newData();
data3.setValue("fMsterID",dat2_id);//外键,跟随桩号或
者区段
data3.setValue("fPaibanIDTTT",emp.gx.rows[i].fMasterID
.value);//外键,跟随桩号或者区段
data3.setValue("fzhuangqd",s_name);//外键,工序名称
data3.setValue("fPtBasicType",
emp.gx.rows[i].fBasicType.value);//工序类别
data3.setValue("fPtBasicName",
emp.gx.rows[i].fBasicName.value);//工序名称
data3.setValue("fPtfID",
emp.gx.rows[i].fBasicCode.value);//工序ID
data3.setValue("fPtfOnlyone",
emp.gx.rows[i].fOnlyone.value);//唯一工序
data3.setValue("fToalSum",
emp.gx.rows[i].fSum.value);//完成量
data3.setValue("fWorkState",
emp.gx.rows[i].fState.value);//完成状态
data3.setValue("fNo", emp.gx.rows[i].fNo.value);//编号
data3.setValue("fStateName","确定中");//文件状态
data3.setValue("fStateID","1");//文件状态ID
}
}
});
data2.saveData();
data3.saveData();
};
package pm_ProjectfenBao;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.UUID;
import javax.naming.NamingException;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.justep.baas.BaasException;
import com.justep.baas.action.ActionContext;
import com.justep.baas.data.DataUtils;
import com.justep.baas.data.Row;
import com.justep.baas.data.Table;
import com.justep.baas.data.Transform;
import com.justep.baas.data.sql.SQLException;
public class ProjectM {
public static JSONObject getTeamName(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
System.out.println("获得到的参数是:" + id);
// 查询
try {
String sql = "select
m.fWorkType,m.fProjectWrokType,m.fMasterID,m.fdoState,n.fBranc
hName,n.fequallyS,n.fWorkType,n.fID,n.fMsterID,n.fToalSum,n.fS
ingle,n.fWorkState from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fID=n.fMsterID and
n.fSteamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getlistjdhbRep(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 接受参数
// 声明要操作的数据库
// 接收参数
JSONArray userCode = (JSONArray) params.get("clis");
// 转换成要换成循环的格式
Object[] o = userCode.toArray();
// 遍历循环的数据
String Stateing = "已完成";
for (int i = 0; i < o.length; i++) {
System.out.println("数组中的数字是:" + o[i].toString());
// 接收每条循环出来的数据
String line = o[i].toString();
// 切割转成list
String[] linecut = line.split(",");
//
String xid = linecut[0];
String pid = linecut[1];
String todaysum = linecut[2];
//
// sql批量执行
Connection conn = context.getConnection("jeecg");
java.sql.Statement stmt = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
// 项目工序修改根据ID
stmt.addBatch("update pm_project_project_gongxu m set m.fSum
=m.fSum+'"
+ todaysum + "' where m.fID='" + xid + "'");
stmt.addBatch("update pm_project_project_gongxu m set
m.fState ='"
+ Stateing + "' where m.fID='" + xid + "' and
m.fSum>=100");
// 排班工序修改根据ID
stmt.addBatch("update pm_project_persondetail2 m set
m.fToalSum =m.fToalSum+'"
+ todaysum + "' where m.fID='" + pid + "'");
stmt.addBatch("update pm_project_persondetail2 m set
m.fWorkState ='"
+ Stateing
+ "' where m.fID='"
+ pid
+ "'and m.fToalSum>=100");
stmt.executeBatch();
conn.close();
}
return null;
}
public static JSONObject getJIngDuNewAction2Shenpi(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 接收参数 进度审批确定事件
//
JSONObject ab = new JSONObject();//json
//
String id = params.getString("id");//获取人员ID
String fProjectID = params.getString("fProjectID");//获取项目ID
String fMasterID = params.getString("fMasterID");//获取主表ID
用来鉴别 0 1
//临时变量
String State ="已完成";
String fBz="1";//判断是否修改,修改为 ,未修改为0 最后统一规0
String fBzNO="0";
String stateing="进行中";
String stateinged="已完成";
String jdweiwancheng="未完成";
String weikaishi="未开始";
String s1="基础";
String s2="组塔";
String s3="架线";
//sql 批量执行
Connection conn = context.getConnection("jeecg");//连接池
//
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);//类似容器什么的
//更新进度汇报表中的数据数量,
条件是:当班组ID,外键,临时变量符合参数时候,更新
String sql1update1="update pm_project_schedulmain2 m set
m.fWancSum = m.fWancSum+m.fJinRiWanCheng where m.fBanID='"+id+"'
and m.fBz='"+fBz+"' and m.fMasterID ='"+fMasterID+"'";//更新数量
System.out.println("第一次更新数据量汇报sql语句是:"+sql1update1);
//输出
//stmt.executeUpdate(sql1update1);
stmt.addBatch(sql1update1);//加入包执行
//更新进度汇报表中的数据状态,当
ID,外键,和临时参数都相等时,并且sum
=100,的时候更新此数据为已完成,来区别数据,用于统计和分析,并且判
断此数据是否在业务中显示
String sql1update2="update pm_project_schedulmain2 m set
m.fState = '"+State+"' where m.fBanID='"+id+"' and m.fWancSum
=100 and m.fBz='"+fBz+"' and m.fMasterID
='"+fMasterID+"'";//更新状态
System.out.println("第二次更新状态汇报的sql语句是:"+sql1update2);
// stmt.executeUpdate(sql1update2);
stmt.addBatch(sql1update2);
//查询改变的数据,通过数据去修改站班和项目的数据
String sql1update3 ="select
m.fxmGxID,m.fPbGXID,m.fJinRiWanCheng,m.fxmwJ from
pm_project_schedulmain2 m where m.fBanID='"+id+"' and
m.fBz='"+fBz+"'and m.fMasterID ='"+fMasterID+"'";
System.out.println("查询到的第三个要更改项目排班中的数据是"+sql1up
date3);
//Table
Table table = DataUtils.queryData(conn, sql1update3, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fxmGxID = info.getString("fxmGxID");//获取ID xid
String fPbGXID = info.getString("fPbGXID");//获取桩号 pid
String fxmwJ = info.getString("fxmwJ");//获取桩号 工序外键
int fJinRiWanCheng =
info.getInteger("fJinRiWanCheng");//获取数量
//
System.out.println("查询到的完成状态是:"+ fJinRiWanCheng);
//更新其他表,更改项目从表工序表的状态,
数量,以及其他信息,最重要
String sqlupOther1 ="update pm_project_project_gongxu m set
m.fSum =m.fSum+'"+ fJinRiWanCheng + "' where
m.fID='"+fxmGxID+"'";//项目
// stmt.executeUpdate(sqlupOther1);
System.out.println("查询到的完成状态是1111:"+ fJinRiWanCheng);
//更改排班表中的工序数据更新吧。
20171127修改项目部版本留,记得加注释
String sqlupOther2 ="update pm_project_persondetail2 m set
m.fToalSum =m.fToalSum+'"+ fJinRiWanCheng + "' where
m.fID='"+fPbGXID + "'";//排班
// stmt.executeUpdate(sqlupOther2);
//更新其他表,更改项目从表工序表的状态,
数量,以及其他信息,最重要状态
String sqlupOther3="update pm_project_project_gongxu m set
m.fState ='"+ State + "' where m.fID='" + fxmGxID + "' and
m.fSum>=100";//项目状态
// stmt.executeUpdate(sqlupOther3);
// 更新其他表,更改排班从表工序表的状态,
数量,以及其他信息,最重要 状态
String sqlupOther4="update pm_project_persondetail2 m set
m.fWorkState ='"+ State+ "' where m.fID='"+ fPbGXID+"'and
m.fToalSum>=100";//排班状态
//批处理
// stmt.executeUpdate(sqlupOther4);
//新加sql.来更新桩号后面所跟随的状态
基础组塔,架线,**********************************************
********
//更新项目桩号 基础已完成 当工序有一条为已完成 100的
时候去更新桩的状态1
String sqlupOther5="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateing+"' where m.fID='"+fxmwJ+"'
AND m.BasicsSubPageState ='"+weikaishi+"'AND m.fID =
n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum>0 and
n.fBasicType='"+s1+"'";//
System.out.println("修改基础分包商的sql进行中是"+sqlupOther5);
//更新项目桩号表中的组他完成状态,当有一条为已完成100
的时候去去更新桩 的状态1
String sqlupOther6="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.TowerSubPageState='"+stateing+"' where
m.fID='"+fxmwJ+"'AND m.TowerSubPageState ='"+weikaishi+"'
AND m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum>0
and n.fBasicType='"+s2+"'";//
//更新项目桩号表中的组塔完成状态,当有一条为已完成100
的时候去去更新桩 的状态1
String sqlupOther7="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.StringingSubPageState='"+stateing+"' where
m.fID='"+fxmwJ+"'AND m.StringingSubPageState
='"+weikaishi+"' AND m.fID = n.fMasterID and
n.fID='"+fxmGxID+"'and n.fSum>0 and n.fBasicType='"+s3+"'";//
//更新项目桩号表的已完成的 基础组塔架线,2
stmt.addBatch(sqlupOther1);
stmt.addBatch(sqlupOther2);
stmt.addBatch(sqlupOther3);
stmt.addBatch(sqlupOther4);
//
stmt.addBatch(sqlupOther5);
stmt.addBatch(sqlupOther6);
stmt.addBatch(sqlupOther7);
stmt.executeBatch();
//查询对应的项目工序是否全部是已完成
基础**********************************************************
************
String sqlselect52 ="select count(n.fState) as sum from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fState='"+jdweiwancheng+"' and
n.fBasicType='"+s1+"'";
System.out.println("查询B表中的未完成的基础工序数量是"+sqlsele
ct52);
//Table
Table tableQ1 = DataUtils.queryData(conn, sqlselect52, null,
null, null, null);
// 遍历
Iterator<Row> iteratorQ1 = tableQ1.getRows().iterator();
while (iteratorQ1.hasNext()) {
Row infoQ1 = iteratorQ1.next();
Object sSum = infoQ1.getValue("sum");
String sc = sSum.toString();
System.out.println("查询到B表中基础的数量是"+sSum);
if(sc.equals("0")){
//如果是全部是未完成即没有未完成的
String sqlupOther51="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and
n.fSum=100 and n.fState='"+stateinged+"' and
n.fBasicType='"+s1+"'";//
String sqlupOther51paiban="update
pm_project_proceduredetail
m,pm_project_persondetail2 n set
m.BasicsSubPageState='"+stateinged+"'where
m.fPtzhuangID='"+fxmwJ+"' AND m.fPtzhuangID =
n.fPtfMasterID and n.fToalSum=100 and
m.fProjectWrokType='"+s1+"'and
n.fWorkState='"+stateinged+"'and
n.fPtBasicType='"+s1+"'";
stmt.addBatch(sqlupOther51paiban);
stmt.addBatch(sqlupOther51);
stmt.executeBatch();
}
};
//查询对应的项目工序是否全部是已完成
组塔**********************************************************
************
String sqlselect62 ="select count(n.fState) as sum from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fState='"+jdweiwancheng+"' and
n.fBasicType='"+s2+"'";
System.out.println("查询B表中的组塔未完成的工序数量是"+sqlsele
ct62);
//Table
Table tableQ2 = DataUtils.queryData(conn, sqlselect62, null,
null, null, null);
// 遍历
Iterator<Row> iteratorQ2 = tableQ2.getRows().iterator();
while (iteratorQ2.hasNext()) {
Row infoQ2 = iteratorQ2.next();
Object sSum = infoQ2.getValue("sum");
String sc = sSum.toString();
System.out.println("查询到B表中组塔的数量是"+sSum);
if(sc.equals("0")){
//如果是全部是未完成即没有未完成的
String sqlupOther61="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and
n.fSum=100 and n.fState='"+stateinged+"' and
n.fBasicType='"+s2+"'";//
String sqlupOther61paiban="update
pm_project_proceduredetail
m,pm_project_persondetail2 n set
m.BasicsSubPageState='"+stateinged+"'where
m.fPtzhuangID='"+fxmwJ+"' AND m.fPtzhuangID =
n.fPtfMasterID and n.fToalSum=100 and
m.fProjectWrokType='"+s2+"'and
n.fWorkState='"+stateinged+"'and
n.fPtBasicType='"+s2+"'";
stmt.addBatch(sqlupOther61paiban);
stmt.addBatch(sqlupOther61);
stmt.executeBatch();
}
};
//查询对应的项目工序是否全部是已完成
架线**********************************************************
************
String sqlselect72 ="select count(n.fState) as sum from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fState='"+jdweiwancheng+"' and
n.fBasicType='"+s3+"'";
System.out.println("查询B表中的架线未完成的工序数量是"+sqlsele
ct72);
//Table
Table tableQ3 = DataUtils.queryData(conn, sqlselect72, null,
null, null, null);
// 遍历
Iterator<Row> iteratorQ3 = tableQ3.getRows().iterator();
while (iteratorQ3.hasNext()) {
Row infoQ2 = iteratorQ3.next();
Object sSum = infoQ2.getValue("sum");
String sc = sSum.toString();
System.out.println("查询到B表中架线的数量是"+sSum);
if(sc.equals("0")){
//如果是全部是未完成即没有未完成的
String sqlupOther71="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and
n.fSum=100 and n.fState='"+stateinged+"' and
n.fBasicType='"+s3+"'";//
String sqlupOther71paiban="update
pm_project_proceduredetail
m,pm_project_persondetail2 n set
m.BasicsSubPageState='"+stateinged+"'where
m.fPtzhuangID='"+fxmwJ+"' AND m.fPtzhuangID =
n.fPtfMasterID and n.fToalSum=100 and
m.fProjectWrokType='"+s3+"'and
n.fWorkState='"+stateinged+"'and
n.fPtBasicType='"+s3+"'";
stmt.addBatch(sqlupOther71paiban);
stmt.addBatch(sqlupOther71);
stmt.executeBatch();
}
};
/*// String sqlupOther51="update
pm_project_project_postinformationtab m set
m.BasicsSubPageState='"+stateinged+"' from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum=100
and n.fState='"+stateinged+"' and n.fBasicType='"+s1+"'";//
String sqlupOther51="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' having
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and n.fSum=100
and count(n.fState='"+jdweiwancheng+"')= 0 and
n.fBasicType='"+s1+"'";//
System.out.println("修改基础分包商的sql完成是"+sqlupOther51);
//更新项目桩号表中的组他完成状态,当有一条为已完成100
的时候去去更新桩 的状态2
// String sqlupOther61="update
pm_project_project_postinformationtab m set
m.TowerSubPageState='"+stateinged+"' from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum=100
and n.fState='"+stateinged+"'";//
String sqlupOther61="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.TowerSubPageState='"+stateinged+"' where m.fID='"+fxmwJ+"'
AND m.fID = n.fMasterID and n.fSum=100 and
n.fState<>'"+jdweiwancheng+"' and n.fBasicType='"+s2+"'";//
//更新项目桩号表中的组塔完成状态,当有一条为已完成100
的时候去去更新桩 的状态2
// String sqlupOther71="update
pm_project_project_postinformationtab m set
m.StringingSubPageState='"+stateinged+"' from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum=100
and n.fState='"+stateinged+"'";//
String sqlupOther71="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.StringingSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and n.fSum=100
and n.fState<>'"+jdweiwancheng+"' and
n.fBasicType='"+s3+"'";//
*/ //
// stmt.addBatch(sqlupOther51);
// stmt.addBatch(sqlupOther61);
// stmt.addBatch(sqlupOther71);
//
System.out.println("执行成功");
}
//
// String sql1update9="update pm_project_schedulmain2 m set
m.fBz='"+fBzNO+"' where m.fBanID='"+id+"' and m.fMasterID
='"+fMasterID+"'";//更新状态
//
// System.out.println("修改状态 1
改成0"+"修改的外键是:"+fMasterID);
// stmt.addBatch(sql1update9);
// //
// stmt.executeBatch();
conn.close();
return ab;
}
public static JSONObject getGxMes(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 接受参数
List<Object> list1 = new ArrayList<Object>();
JSONObject json = new JSONObject();
String st = "未完成";
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");
Connection conn = context.getConnection("jeecg");// 获取数据库连接
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环查询
String id = o[i].toString();
// 查询
String sql = "select
m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"
+ id + "' and m.fState='" + st + "'";
// 装入table
Table table = DataUtils
.queryData(conn, sql, null, null, null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
List<Map<String, Object>> list = new
ArrayList<Map<String, Object>>();
Row info = iterator.next();
String fBasicName = info.getString("fBasicName");
String fID = info.getString("fID");
String fMasterID = info.getString("fMasterID");
String fBasicType = info.getString("fBasicType");
String fOnlyone = info.getString("fOnlyone");
int fSum = info.getInteger("fSum");
String fState = info.getString("fState");
// 数据装入map
Map<String, Object> map = new HashMap<String, Object>();
map.put("fID", fID);
map.put("fMasterID", fMasterID);
map.put("fBasicName", fBasicName);
map.put("fBasicType", fBasicType);
map.put("fOnlyone", fOnlyone);
map.put("fSum", fSum);
map.put("fState", fState);
list.add(map);
list1.add(list);
}
}
json.put("ID", list1);
return json;
}
public static JSONObject getPianchaYuanyinAction(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
System.out.println("获得到的参数是:" + id);
// 查询
try {
String sql = "select
m.fNameCodeID,m.fName,n.fWrtietime,n.fWrtieName,n.fID,n.fZhuan
gNo,n.fZhuangCode from pm_project_weekreport_detail m
,pm_project_weekreport n where n.fID=m.fMasterID and
n.ffProjectID='"+ id + "'";
System.out.println("第一次查询到的sql是:"+ sql);
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
/* public static JSONObject getNewPaiBanCheckZGmess(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {//排班选择工序
//****************************************************************
***************************
// 接受参数
Connection conn = context.getConnection("jeecg");// 获取数据库连接
String st = "未完成";
Collection<String> list5 = new ArrayList<String>();//新5
装入桩号ID
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");//获取桩号ID
String MainID = params.getString("MainsID");//获取主表ID
String Type = params.getString("Type");//获取类型 基础组塔架线
String ty = "基础";
java.sql.Statement stmt1 = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
java.sql.Statement stmt2 = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
//****************************************************************
***************************
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环桩号插入表
String id = o[i].toString();
// 查询桩号
String sql = "select m.fID,m.fPostName,m.fState,m.fMsterID
from pm_project_project_postinformationtab m where m.fID =
'"+ id + "'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fID = info.getString("fID");//获取ID
String fPostName = info.getString("fPostName");//获取桩号
String fState = info.getString("fState");//获取状态
String fMsterID = info.getString("fMsterID");//获取外键
System.out.println("第一次查询到的桩号是:"+ fPostName);
//如果有,插入排班桩号数据
// java.sql.PreparedStatement pstmt = null;
// pstmt = conn.prepareStatement("insert
into pm_project_proceduredetail
s(s.version,s.fMasterID,s.fPtzhuangID,s.fPtzhuangN,s.fProj
ectWrokType,s.fPtzhuangState,s.fPtzhuangMasterID)values(0,
'"+MainID+"','"+fID+"','"+fPostName+"','"+ty+"','"+fState+
"','"+fMsterID+"')");
String sql1 ="insert into pm_project_proceduredetail
s(s.version,s.fMasterID,s.fPtzhuangID,s.fPtzhuangN,s.fProj
ectWrokType,s.fPtzhuangState,s.fPtzhuangMasterID)values(0,
'"+MainID+"','"+fID+"','"+fPostName+"','"+ty+"','"+fState+
"','"+fMsterID+"')";
stmt1.addBatch(sql1);
// pstmt.execute();//执行
// 数据装入map
list5.add(fID);
}
stmt1.executeBatch();
}
//循环桩号查询工序信息
Iterator<String> it = list5.iterator();
while(it.hasNext()){
String fID = (String)it.next();//获取ID
String sql = "select
m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"+ fID + "' and m.fState='" + st + "'";
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fBasicName = info.getString("fBasicName");
String fID1 = info.getString("fID");
String fMasterID = info.getString("fMasterID");
String fBasicType = info.getString("fBasicType");
String fOnlyone = info.getString("fOnlyone");
int fSum = info.getInteger("fSum");
String fState = info.getString("fState");
System.out.println("第二次查询到的工序是:"+ fBasicName);
//执行插入语句
java.sql.PreparedStatement pstmt1 = null;
// pstmt1 = conn.prepareStatement("insert
into pm_project_proceduredetail
b(b.version,b.fPtfID,b.fPtfMasterID,b.fPtBasicName,b.fPtBa
sicType,b.fPtzhuangState,b.fPtzhuangMasterID,b.fToalSum,b.
fWorkState,b.fMsterID)values(0,'"+fID1+"','"+fMasterID+"',
'"+fBasicName+"','"+fBasicType+"','"+fOnlyone+"','"+fSum+"
','"+fState+"','"+MainID+"')");
String sql2 = "insert into pm_project_proceduredetail
b(b.version,b.fPtfID,b.fPtfMasterID,b.fPtBasicName,b.fPtBa
sicType,b.fPtzhuangState,b.fPtzhuangMasterID,b.fToalSum,b.
fWorkState,b.fMsterID)values(0,'"+fID1+"','"+fMasterID+"',
'"+fBasicName+"','"+fBasicType+"','"+fOnlyone+"','"+fSum+"
','"+fState+"','"+MainID+"')";
stmt2.addBatch(sql2);
// pstmt1.execute();//执行
}
}
// stmt1.executeBatch();
stmt2.executeBatch();
conn.close();
return null;
}*/
/* public static JSONObject getNewPaiBanCheckZGmess(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//排班动作
JSONObject ad = new JSONObject();
JSONArray arr = (JSONArray) params.get("id");//获取桩号ID
String MainID = params.getString("MainsID");//获取主表ID
String Type = params.getString("Type");//获取类型 基础组塔架线
String ty = "测试基础";//临时数据
String State = "未完成";
String fNo = "3333333";
//
Date date = new Date();
DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
java.sql.Date currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
//
Connection conn = context.getConnection("jeecg");// 获取数据库连接
//SQL批量执行
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//
Object[] o = arr.toArray();
//
for (int i = 0; i < o.length; i++) { // 循环桩号插入表
String uuid1 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid1 = uuid1.replace("-", "");
System.out.println("第一次查询到UUID:"+ uuid1);
String id = o[i].toString();
System.out.println("获取到的id是:"+id);
// 查询桩号
20171211,添加功能,查询
基础实际量,组塔实际量,架线实际量,用来统计对比计划量 统计量
*
*
String sql = "select
m.fID,m.fPostName,m.fState,m.fMsterID,m.BasicsSubPageName,m.To
werSubPageName,m.StringingSubPageName,m.fBasicsSubPlanSum,m.fT
owerSubPlanSum,m.fStringingSubPlanSum from
pm_project_project_postinformationtab m where m.fID = '"+
id + "'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fID = info.getString("fID");//获取ID
String fPostName = info.getString("fPostName");//获取桩号
String fState = info.getString("fState");//获取状态
String fMsterID = info.getString("fMsterID");//获取外键
String BasicsSubPageName =
info.getString("BasicsSubPageName");//获取基础分包商
String TowerSubPageName =
info.getString("TowerSubPageName");//获取组塔分包商
String StringingSubPageName =
info.getString("StringingSubPageName");//获取架线分包商
int fBasicsSubPlanSum =
info.getInteger("fBasicsSubPlanSum");//获取基础实际量
int fTowerSubPlanSum =
info.getInteger("fTowerSubPlanSum");//获取组塔实际量
int fStringingSubPlanSum =
info.getInteger("fStringingSubPlanSum");//获取架线实际量
System.out.println("第一次查询到的桩号是:"+ fPostName);
//
//因为UUID本身为32位只是生成时多了“-”,所以将它们去点就可
VALUES
//如果有,插入排班桩号数据,遍历插入排班表中的数据
String sql1="insert into pm_project_proceduredetail
(fNo,fID,fCreateDateTime,fMasterID,fPtzhuangID,fPtzhuangN,
fProjectWrokType,fPtzhuangState,fPtzhuangMasterID,BasicsSu
bPageName,TowerSubPageName,StringingSubPageName,fBasicsSub
PlanSumS,fTowerSubPlanSumS,fStringingSubPlanSumS,fBasicsSu
bPlanSum,fTowerSubPlanSum,fStringingSubPlanSum)" +
" VALUES
('"+fNo+"','"+uuid1+"','"+currentDate+"','"+MainID
+"','"+fID+"','"+fPostName+"','"+Type+"','"+fState
+"','"+fMsterID+"','"+BasicsSubPageName+"','"+Towe
rSubPageName+"','"+StringingSubPageName+"','"+fBas
icsSubPlanSum+"','"+fTowerSubPlanSum+"','"+fString
ingSubPlanSum+"','"+fBasicsSubPlanSum+"','"+fTower
SubPlanSum+"','"+fStringingSubPlanSum+"')" ;
System.out.println("插入排班桩号输出的sql是:"+sql1);
//批处理
stmt.executeUpdate(sql1);
//
System.out.println("执行成功");
//pstmt.executeBatch();
// list5.add(fID);
}
//查询工序
System.out.println("要查询的主键是:"+id);
String sql2 = "select
m.fNo,m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"+ id + "' and m.fState='" + State + "'";
System.out.println("查询的第二个语句是:"+sql2);
//
Table table1 = DataUtils.queryData(conn, sql2, null, null,
null, null);
Iterator<Row> iterator1 = table1.getRows().iterator();
//遍历
while (iterator1.hasNext()) {
//生成主键
String uuid2 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid2 = uuid2.replace("-", "");
//
Row info1 = iterator1.next();
String fBasicName = info1.getString("fBasicName");
String fID1 = info1.getString("fID");
String fNo1 = info1.getString("fNo");
String fMasterID = info1.getString("fMasterID");
String fBasicType = info1.getString("fBasicType");
String fOnlyone = info1.getString("fOnlyone");
int fSum = info1.getInteger("fSum");
String fState = info1.getString("fState");
//if判断基础组塔架线
if(fBasicType.equals(Type)){
//执行插入语句pm_project_persondetail2
System.out.println("第二次查询到的工序是过滤后的工序:"
+fBasicName);//
String sqlinsert1 = "insert into
pm_project_persondetail2
(fNo,fID,fStartTime,fPtfID,fPtfMasterID,fPtBasicName,f
PtBasicType,fPtfOnlyone,fToalSum,fWorkState,fMsterID)
values
('"+fNo1+"','"+uuid2+"','"+currentDate+"','"+fID1+"','
"+fMasterID+"','"+fBasicName+"','"+fBasicType+"','"+fO
nlyone+"','"+fSum+"','"+fState+"','"+MainID+"')";
//批处理
stmt.executeUpdate(sqlinsert1);
System.out.println("出入工序成功"+fBasicName);
}
}
}
//
//批处理执行
conn.close();
return ad;
}*/
public static JSONObject getNewPaiBanCheckZGmess(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//排班动作
JSONObject ad = new JSONObject();
JSONArray arr = (JSONArray) params.get("id");//获取桩号ID
String MainID = params.getString("MainsID");//获取主表ID
String Type = params.getString("Type");//获取类型 基础组塔架线
String ty = "测试基础";//临时数据
String State = "未完成";
String fNo = "333";
//时间转换
java.sql.Date currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
//
Connection conn = context.getConnection("jeecg");// 获取数据库连接
//SQL批量执行
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//
Object[] o = arr.toArray();
//
for (int i = 0; i < o.length; i++) { // 循环桩号插入表
String uuid1 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid1 = uuid1.replace("-", "");
System.out.println("第一次查询到UUID:"+ uuid1);
String id = o[i].toString();
System.out.println("获取到的id是:"+id);
//20171211,添加功能,查询
基础实际量,组塔实际量,架线实际量,用来统计对比计划量
统计量查询桩号
String sql = "select
m.fID,m.fPostName,m.fState,m.fMsterID,m.BasicsSubPageName,m.To
werSubPageName,m.StringingSubPageName,m.fBasicsSubPlanSum,m.fT
owerSubPlanSum,m.fStringingSubPlanSum from
pm_project_project_postinformationtab m where m.fID = '"+
id + "'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fID = info.getString("fID");//获取ID
String fPostName = info.getString("fPostName");//获取桩号
String fState = info.getString("fState");//获取状态
String fMsterID = info.getString("fMsterID");//获取外键
String BasicsSubPageName =
info.getString("BasicsSubPageName");//获取基础分包商
String TowerSubPageName =
info.getString("TowerSubPageName");//获取组塔分包商
String StringingSubPageName =
info.getString("StringingSubPageName");//获取架线分包商
int fBasicsSubPlanSum =
info.getInteger("fBasicsSubPlanSum");//获取基础实际量
int fTowerSubPlanSum =
info.getInteger("fTowerSubPlanSum");//获取组塔实际量
int fStringingSubPlanSum =
info.getInteger("fStringingSubPlanSum");//获取架线实际量
System.out.println("第一次查询到的桩号是:"+ fPostName);
//因为UUID本身为32位只是生成时多了“-”,所以将它们去点就可
VALUES
//如果有,插入排班桩号数据,遍历插入排班表中的数据
String sql1="insert into pm_project_proceduredetail
(fNo,fID,fCreateDateTime,fMasterID,fPtzhuangID,fPtzhuangN,
fProjectWrokType,fPtzhuangState,fPtzhuangMasterID,BasicsSu
bPageName,TowerSubPageName,StringingSubPageName,fBasicsSub
PlanSumS,fTowerSubPlanSumS,fStringingSubPlanSumS,fBasicsSu
bPlanSum,fTowerSubPlanSum,fStringingSubPlanSum)" +"
VALUES
('"+fNo+"','"+uuid1+"','"+currentDate+"','"+MainID+"','"+f
ID+"','"+fPostName+"','"+Type+"','"+fState+"','"+fMsterID+
"','"+BasicsSubPageName+"','"+TowerSubPageName+"','"+Strin
gingSubPageName+"','"+fBasicsSubPlanSum+"','"+fTowerSubPla
nSum+"','"+fStringingSubPlanSum+"','"+fBasicsSubPlanSum+"'
,'"+fTowerSubPlanSum+"','"+fStringingSubPlanSum+"')" ;
System.out.println("插入排班桩号输出的sql是:"+sql1);
//批处理
stmt.executeUpdate(sql1);
System.out.println("执行成功");
//接着查询工序********************************************
************************************
System.out.println("要查询的主键是:"+id);
String sql2 = "select
m.fNo,m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from
pm_project_project_gongxu m where m.fMasterID = '"+ id
+ "' and m.fState='" + State + "'";
System.out.println("查询的第二个语句是:"+sql2);
Table table1 = DataUtils.queryData(conn, sql2, null,
null, null, null);
Iterator<Row> iterator1 = table1.getRows().iterator();
//遍历
while (iterator1.hasNext()) {
//生成主键
String uuid2 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid2 = uuid2.replace("-", "");
//
Row info1 = iterator1.next();
String fBasicName = info1.getString("fBasicName");
String fID1 = info1.getString("fID");
String fNo1 = info1.getString("fNo");
String fMasterID = info1.getString("fMasterID");
String fBasicType = info1.getString("fBasicType");
String fOnlyone = info1.getString("fOnlyone");
int fSum = info1.getInteger("fSum");
String fState1 = info1.getString("fState");
//if判断基础组塔架线
if(fBasicType.equals(Type)){
//执行插入语句pm_project_persondetail2
System.out.println("第二次查询到的工序是过滤后的工
序:"+fBasicName);//
String sqlinsert1 = "insert into
pm_project_persondetail2
(fPaibanIDTTT,fNo,fID,fStartTime,fPtfID,fPtfMaster
ID,fPtBasicName,fPtBasicType,fPtfOnlyone,fToalSum,
fWorkState,fMsterID) values
('"+uuid1+"','"+fNo1+"','"+uuid2+"','"+currentDate
+"','"+fID1+"','"+fMasterID+"','"+fBasicName+"','"
+fBasicType+"','"+fOnlyone+"','"+fSum+"','"+fState
1+"','"+MainID+"')";
//批处理
stmt.executeUpdate(sqlinsert1);
System.out.println("出入工序成功"+fBasicName);
}
}
}
}
//
//批处理执行
conn.close();
return ad;
}
public static JSONObject getJiaxianGxPBmess(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 接受参数
List<Object> list1 = new ArrayList<Object>();
JSONObject json = new JSONObject();
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");
Connection conn = context.getConnection("jeecg");// 获取数据库连接
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环查询
String id = o[i].toString();
// 查询
String sql = "select
m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"
+ id + "'";
// 装入table
Table table = DataUtils
.queryData(conn, sql, null, null, null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
List<Map<String, Object>> list = new
ArrayList<Map<String, Object>>();
Row info = iterator.next();
String fBasicName = info.getString("fBasicName");
String fID = info.getString("fID");
String fMasterID = info.getString("fMasterID");
String fBasicType = info.getString("fBasicType");
String fOnlyone = info.getString("fOnlyone");
int fSum = info.getInteger("fSum");
String fState = info.getString("fState");
// 数据装入map
Map<String, Object> map = new HashMap<String, Object>();
map.put("fID", fID);
map.put("fMasterID", fMasterID);
map.put("fBasicName", fBasicName);
map.put("fBasicType", fBasicType);
map.put("fOnlyone", fOnlyone);
map.put("fSum", fSum);
map.put("fState", fState);
list.add(map);
list1.add(list);
}
}
json.put("ID", list1);
return json;
}
public static JSONObject getJiaxian(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询项目下通过节点
Connection conn = context.getConnection("jeecg");
// 查询
try {
String sql = "select m.fPostName, m.fID from
pm_project_project_postinformationtab m where m.fPointCut
='是' ";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getGx1(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
String st = "未完成";
// 查询
try {
String sql = "select DISTINCT n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMaster
ID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPt
fOnlyone from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangID=
n.fPtfMasterID and n.fTeamID ='"+ id + "' and
n.fWorkState='"+st+"'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getGx3(JSONObject params, ActionContext
context)throws SQLException, NamingException, java.sql.SQLException {
// 查询对应班组的工序
// 接受参数
List<Object> list1 = new ArrayList<Object>();
JSONObject json = new JSONObject();
String st = "未完成";
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");//获取数组ID
String PersonID = params.getString("PersonID");//获取人员ID
Connection conn = context.getConnection("jeecg");// 获取数据库连接
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环查询
String id = o[i].toString();
System.out.println("获取到的ID 是:"+id);
// 查询
String sql = "select DISTINCT n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMaster
ID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPt
fOnlyone from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangID=
n.fPtfMasterID and n.fTeamID ='"+PersonID+ "'and
m.fMasterID= n.fMsterID='"+id+"'and n.fWorkState='"+st+"'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
List<Map<String, Object>> list = new
ArrayList<Map<String, Object>>();
Row info = iterator.next();
String congbiaoID = info.getString("congbiaoID");//1
String fPtfID = info.getString("fPtfID");//2
String fPtBasicName = info.getString("fPtBasicName");//3
String fPtBasicType = info.getString("fPtBasicType");//4
String fPtfMasterID = info.getString("fPtfMasterID");//5
String fMsterID = info.getString("fMsterID");//6
String fTeamName = info.getString("fTeamName");//7
String fTeamID = info.getString("fTeamID");//8
String fWorkState = info.getString("fWorkState");//9
int fToalSum = info.getInteger("fToalSum");//10
String fPtfOnlyone = info.getString("fPtfOnlyone");//11
// 数据装入map
Map<String, Object> map = new HashMap<String, Object>();
map.put("congbiaoID",congbiaoID);
map.put("fPtfID",fPtfID);
map.put("fPtBasicName",fPtBasicName);
map.put("fPtBasicType",fPtBasicType);
map.put("fPtfMasterID",fPtfMasterID);
map.put("fMsterID",fMsterID);
map.put("fTeamName",fTeamName);
map.put("fTeamID",fTeamID);
map.put("fWorkState",fWorkState);
map.put("fToalSum", fToalSum);
map.put("fPtfOnlyone", fPtfOnlyone);
//list装箱
list.add(map);
list1.add(list);
}
}
json.put("ID", list1);
return json;
}
public static JSONObject getJiaXianQuDuanGx(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMaster
ID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPt
fOnlyone from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangMasterID=
n.fPtfID and n.fTeamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getJDHBzhuang(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");// 获取人员ID
String projectID = params.getString("projectID");// 获取项目ID
System.out.println("获取到项目ID:" + projectID);
String Time = params.getString("time");// 获取当前时间
String stat = "未完成";
System.out.println("输出的" + Time);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
try {
String sql = "select DISTINCT
y.fID,y.fMasterID,y.fPtzhuangID,y.fPtzhuangN,y.fProjectWrokTyp
e,y.fPtzhuangState,y.fPtzhuangMasterID from
pm_project_proceduredetail y,pm_project_persondetail2 z
where y.fMasterID=z.fMsterID and y.fPtzhuangID=
z.fPtfMasterID and z.fTeamID = '"+ id+ "' and z.fTeamID is
not null and y.fPtzhuangMasterID='"+projectID+ "' and
z.fWorkState ='"+stat+"'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getJingDuNewAction1(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
JSONObject return1 = new JSONObject();
//获取参数
String personName = params.getString("personName");// 人员名称
String id = params.getString("id");// 获取人员ID
String MainID = params.getString("MainID");// 获取主表ID
String projectID = params.getString("projectID");// 获取项目ID
String Time = params.getString("time");// 获取当前时间
String fNo = "进度";
String st = "未完成";
//转换java转化sql时间
java.sql.Date currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
//SQL批量执行
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//查询排班中的所属桩号,查询张三班组在排班中所有的桩号和桩的类别
String sql = "select DISTINCT
y.fBasicsSubPlanSum,y.fTowerSubPlanSum,y.fStringingSubPlanSum,y.fI
D,y.fMasterID,y.fPtzhuangID,y.fPtzhuangN,y.fProjectWrokType,y.fPtz
huangState,y.fPtzhuangMasterID from
pm_project_proceduredetail y,pm_project_persondetail2 z where
y.fMasterID=z.fMsterID and y.fPtzhuangID= z.fPtfMasterID and
z.fTeamID LIKE '%"+ id+ "%' " +
" and z.fTeamID is not null and
y.fPtzhuangMasterID='"+projectID+ "' and z.fWorkState
='"+st+"'and y.fID = z.fPaibanIDTTT";
//
System.out.println("查询桩号是sql"+sql);
//
Table table = DataUtils.queryData(conn, sql, null, null, null,
null);
//遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
//
String uuid1 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid1 = uuid1.replace("-", ""); //生成主键
System.out.println("获取到的UUID是"+uuid1);
//
Row info = iterator.next();//20171212修改计划量和实际量
3方同步
int fBasicsSubPlanSum =
info.getInteger("fBasicsSubPlanSum");//基础实际量
int fTowerSubPlanSum =
info.getInteger("fTowerSubPlanSum");//组塔实际量
int fStringingSubPlanSum =
info.getInteger("fStringingSubPlanSum");//架线实际量
String fID = info.getString("fID");//排版桩ID
String fPtzhuangID =
info.getString("fPtzhuangID");//项目桩ID data1=data2
String fPtzhuangN = info.getString("fPtzhuangN");//桩号名称
String fType = info.getString("fProjectWrokType");//桩号类别
//插入进度桩号表
String sql1="insert into
pm_project_schedulmain1(fNo,fID,fTime,fBanCode,fMasterID,fZhua
ngID,fTongBuID,fZhuangName,fType,fBasicsSubPlanSum,fTowerSubPl
anSum,fStringingSubPlanSum) VALUES
('"+fNo+"','"+uuid1+"','"+currentDate+"','"+id+"','"+MainID+"'
,'"+fID+"','"+fPtzhuangID+"','"+fPtzhuangN+"','"+fType+"','"+f
BasicsSubPlanSum+"','"+fTowerSubPlanSum+"','"+fStringingSubPla
nSum+"')" ;
System.out.println("输出的sql是:"+sql1);
//批处理
stmt.executeUpdate(sql1);
//
System.out.println("桩号执行成功");
}
//通过人员ID 查询工序
String sql2 = "select DISTINCT n.fNo, n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMasterID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPtfOnl
yone from pm_project_proceduredetail m ,pm_project_persondetail2
n where m.fPtzhuangID= n.fPtfMasterID and n.fTeamID LIKE '%"+ id
+"%' and n.fWorkState='"+st+"'";
//
Table table1 = DataUtils.queryData(conn,sql2, null, null, null,
null);
Iterator<Row> iterator1 = table1.getRows().iterator();
//遍历插入
while (iterator1.hasNext()) {
Row info1 = iterator1.next();
//
String uuid2 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid2 = uuid2.replace("-", ""); //生成主键
System.out.println("获取到的UUID是"+uuid2);
//
String congbiaoID = info1.getString("congbiaoID");//1
String fPtfID = info1.getString("fPtfID");//2
String fPtBasicName = info1.getString("fPtBasicName");//3
String fPtBasicType = info1.getString("fPtBasicType");//4
String fPtfMasterID = info1.getString("fPtfMasterID");//5
String fMsterID = info1.getString("fMsterID");//6
String fTeamName = info1.getString("fTeamName");//7
String fTeamID = info1.getString("fTeamID");//8
String fWorkState = info1.getString("fWorkState");//9
int fToalSum = info1.getInteger("fToalSum");//10
String fPtfOnlyone = info1.getString("fPtfOnlyone");//11
String fNo1 = info1.getString("fNo");//11
//插入数据 工序表
String sqlinsert2="insert into pm_project_schedulmain2
(fNo,fID,fWritime,fBanID,fMasterID,fxmGxID,fxmwJ,fPbGXID,fPbwj
,fGongxu,fBanName,fState,fWancSum,fType,fOnlyOne,fJinRiWanChen
g)" +" VALUES
('"+fNo1+"','"+uuid2+"','"+currentDate+"','"+id+"','"+MainID+"
','"+fPtfID+"','"+fPtfMasterID+"','"+congbiaoID+"','"+fMsterID
+"','"+fPtBasicName+"','"+personName+"','"+fWorkState+"','"+fT
oalSum+"','"+fPtBasicType+"','"+fPtfOnlyone+"',0)" ;
System.out.println("输出的sql是:"+sqlinsert2);
//批处理
stmt.executeUpdate(sqlinsert2);
//
System.out.println("插入工序执行成功");
}
return return1;
}
public static JSONObject getJiaXianQuDuan(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select DISTINCT m.fPtzhuangID, m.fPtzhuangN,
m.fID,m.fProjectWrokType,m.fPtzhuangMasterID from
pm_project_proceduredetail m ,pm_project_persondetail2 n
where m.fPtzhuangMasterID= n.fPtfID and n.fTeamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getGx2(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select m.fID, m.fPtzhuangN,m.fPtzhuangID,
m.fProjectWrokType,m.fPtzhuangMasterID,n.fID as
congID,n.fPtfID,fPtBasicType,n.fPtBasicName,n.fPtBasicType,n.f
PtfOnlyone, n.fPtfMasterID,n.fTeamName,n.fTeamID,
n.fToalSum from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangMasterID=
n.fPtfID and n.fTeamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getXuJianBanTeamNameselect(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select m.fPostName,m.fPostWriteName,
m.fPostWriteID from
pm_project_project_informationtable_postsetb m where
m.fMasterID = '"
+ id + "' ";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject Getjiaxian(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询 对应项目下的节点形成的区段返回前台
List<Object> list1 = new ArrayList<Object>();// 声明list1
JSONObject json = new JSONObject();// 声明json对象
Connection conn = context.getConnection("jeecg");// 声明连接池
String id = params.getString("id");// 接收参数
String srt = "";// 申明srt来临时储存桩号
String ids = "";// 声明ids 来临时储存ID
String sumjia = "";// 声明sum来储存桩之间的档距
// Float srtsum = '
// 查询
// where m.fMsterID='"+id+"' 备用项目ID
String sql = " select m.fPointCut,m.fPostName,m.fID,m.fSpanSum
from pm_project_project_postinformationtab m where m.fMsterID='"
+ id + "'";
// Table装在值
Table a = DataUtils.queryData(conn, sql, null, null, null, null);
// 把查询的数据循环遍历
Iterator<Row> iterator = a.getRows().iterator();
// 遍历
while (iterator.hasNext()) {
List<Map<String, Object>> list = new ArrayList<Map<String,
Object>>();// 声明list
Map<String, Object> map = new HashMap<String, Object>();//
声明map
Row info = iterator.next();// 迭代下一行
String fPointCut = info.getString("fPointCut");// 获取节点
String fPostName = info.getString("fPostName");// 获取桩号名称
String fID = info.getString("fID");// 获取主键
Float fSpanSum = info.getFloat("fSpanSum");// 获取档距
// 判断 如果当前遍历的节点是否为空
if ("".equals(fPointCut) || fPointCut == null) {
// 判断节点是否为空,如果为空, 把空的桩号拼接起来用来使用
srt += fPostName + ",";// 拼接桩号
ids += fID + ",";// 拼接ID
// srtsum+=fSpanSum;//拼接档距
System.out.println("桩号的临时数组是:" + srt);
System.out.println("主键的临时数组是:" + ids);
} else {// 如果节点不为空,那就把这个节点存为当前节点
,然后开始节点是临时list的第一个值
String[] linecut = srt.split(",");// 切割桩号
String first = linecut[0];// 获取list中的第一个桩号
System.out.println("切割的数据第一个是:" + first);
String assemble = first + "---" + fPostName;// 拼接
String ids1 = ids;// ID
// Float dangju =srtsum;//拼接
System.out.println("拼接后的节点是:" + assemble);
map.put("cut", assemble);// map添加区段
map.put("ids", ids1);// map添加区段中的桩ID
// srt qingkong
// 归零,然后把临时桩list。和idsList归零
srt = fPostName + ",";// 桩listname清除
ids = fID + ",";// 桩ID清除
list.add(map);// 添加map
list1.add(list);// 添加list
// srtsum=null;
}
}
json.put("ID", list1);
return json;
}
public static JSONObject Getjiaxian1(JSONObject params,
ActionContext context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询 对应项目下的节点形成的区段返回前台
List<Object> list1 = new ArrayList<Object>();// 声明list1
JSONObject json = new JSONObject();// 声明json对象
Connection conn = context.getConnection("jeecg");// 声明连接池
String id = params.getString("id");// 接收参数
String srt = "";// 申明srt来临时储存桩号
String ids = "";// 声明ids 来临时储存ID
// int sumjia = 0;// 声明sum来储存桩之间的档距
float sumjia =0f;
// DecimalFormat df = new DecimalFormat(".00");
// System.out.println(df.format(d));
// Float srtsum = '
// 查询
// where m.fMsterID='"+id+"' 备用项目ID
String sql = " select m.fPointCut,m.fPostName,m.fID,m.fSpanSum
from pm_project_project_postinformationtab m where m.fMsterID='"
+ id + "'";
// Table装在值
Table a = DataUtils.queryData(conn, sql, null, null, null, null);
// 把查询的数据循环遍历
Iterator<Row> iterator = a.getRows().iterator();
// 遍历
while (iterator.hasNext()) {
List<Map<String, Object>> list = new ArrayList<Map<String,
Object>>();// 声明list
Map<String, Object> map = new HashMap<String, Object>();//
声明map
Row info = iterator.next();// 迭代下一行
String fPointCut = info.getString("fPointCut");// 获取节点
String fPostName = info.getString("fPostName");// 获取桩号名称
String fID = info.getString("fID");// 获取主键
float fSpanSum = info.getFloat("fSpanSum");// 获取档距1111111
// 判断 如果当前遍历的节点是否为空
if ("".equals(fPointCut) || fPointCut == null) {
// 判断节点是否为空,如果为空, 把空的桩号拼接起来用来使用
srt += fPostName + ",";// 拼接桩号
ids += fID + ",";// 拼接ID
// float quc= df.format(fSpanSum);
sumjia+=fSpanSum;//拼接区段长度
// srtsum+=fSpanSum;//拼接档距
System.out.println("桩号的临时数组是:" + srt);
System.out.println("主键的临时数组是:" + ids);
System.out.println("区段的临时总和是:" + sumjia);
} else {// 如果节点不为空,那就把这个节点存为当前节点
,然后开始节点是临时list的第一个值
String[] linecut = srt.split(",");// 切割桩号
String first = linecut[0];// 获取list中的第一个桩号
System.out.println("切割的数据第一个是:" + first);
String assemble = first + "---" + fPostName;// 拼接
String ids1 = ids;// ID
// Float dangju =srtsum;//拼接
System.out.println("拼接后的节点是:" + assemble);
map.put("cut", assemble);// map添加区段
map.put("ids", ids1);// map添加区段中的桩ID
map.put("sum", sumjia);// map添加区段中的桩ID
// srt qingkong
// 归零,然后把临时桩list。和idsList归零
srt = fPostName + ",";// 桩listname清除
ids = fID + ",";// 桩ID清除
sumjia=0f;//区段清理0
sumjia+=fSpanSum;//拼接区段长度
list.add(map);// 添加map
list1.add(list);// 添加list
// srtsum=null;
}
}
json.put("ID", list1);
return json;
}
}
pm_project_statreport
SELECT * FROM pm_project_project_informationtable WHERE
((pm_project_project_informationtable.fID LIKE
'%3b504952-2118-450b-a6fe-fcb622d64435,C7DDE5295740000122C7359F30C06450,C7
DDECA107E00001E4531EDD14D01679' ) )
SELECT * FROM pm_project_project_informationtable WHERE
((pm_project_project_informationtable.fID IN
'3b504952-2118-450b-a6fe-fcb622d64435,C7DDE5295740000122C7359F30C06450,C7D
DECA107E00001E4531EDD14D01679' ) )
arr_pkfPostWriteID
sql11111111111111111111111111111111111111111111111111111111111111111111111
11111111111111111111111111111111111111111111111111111111111111111111111
http://localhost:8080/x5/UI2/v_/chat/wex5/index.w#!main
// 架线
sql 分部语句
select * from pm_project_proceduredetail m where
DELETE FROM Person WHERE LastName = 'Wilson'
select * from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
DELETE from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
C7C97356D7B000015375FB781F501237
select * from pm_project_persondetail2 m where
m.fPtfMasterID='C7C97356D7B000015375FB781F501237'
DELETE from pm_project_persondetail2 where
fPtfMasterID='C7C97356D7B000015375FB781F501237'
DELETE from pm_project_proceduredetail where
fProjectWrokType='架线'
?、
120.27.11.218:8443
http://120.27.11.218:8095/x5/UI2/v_/chat/wex5/index.w#!main
//基础 40
//排班
进度、
pm_project_project_postinformationtab
pm_project_project_postinformationtab 桩号表
工序表 pm_project_project_gongxu
select *from pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
where n.
//
select m.fBasicName from pm_project_project_postinformationtab
n ,
pm_project_project_gongxu m
where n.fID= m.fMasterID
and n.fPostName=' N040 ' and m.fBasicType='基础'
//
update pm_project_project_postinformationtab
n,pm_project_project_gongxu m set
m.A ,set m.et, where n.fID= m.fMasterID
and n.fPostName=' N040 ' and m.fBasicType='基础'
//项目
//排班
pm_project_proceduredetail 桩号表
pm_project_persondetail2 工序表
update pm_project_project_postinformationtab n, m
set m.fSum=0, m.fState='未完成',n.BasicsSubPageState='进行中'
where n.fID= m.fMasterID
and n.fPostName=' N040 '
and m.fBasicType='基础'
pm_project_proceduredetail
select * from pm_project_persondetail2 m where
m.fPtBasicType='基础' and
m.fPtfMasterID ='
C7C690A041D0000124507400CD003690 '
//更新项目数据
select * from pm_project_project_postinformationtab n ,
pm_project_project_gongxu
m
where n.fID = m.fMasterID
and n.fPostName<' N040 '
where n.fID = m.fMasterID
and n.fPostName<' N030 '
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='未完成',m.fSum=0,m.fState='未完成'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='未完成',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName<' N030 '
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<' N030 ' and
//更新项目基础的数据整体完成的情况
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N044 '
and n.fPostName>=' N036 '
and m.fBasicType='基础'
//针对项目中桩号工序单个完成的情况
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName=' N030 '
and m.fBasicType='基础'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N164 '
and n.fPostName>=' N163 '
and m.fBasicType='基础'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N178 '
and m.fBasicType='基础'
基础
update pm_project_project_gongxu set
//针对单一工序没有完成的桩号更新
select * from pm_project_project_gongxu m where m.fMasterID
='
C7C690A0420000013D3A1A7419E83ED0 ' and m.fBasicName='前期准备' and
m.fBasicType='基础'
updat
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N178 '
and m.fBasicType='基础'
m.fBasicName='前期准备' and m.fBasicType='基础'
//前期准备
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='前期准备'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='基础开挖'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='基础浇筑'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='基坑回填'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='接埋地线'
前期准备'
基础开挖
基础浇筑
基坑回填
接埋地线
//下面是铁塔组立的代码 20171220 1800
b. 这是 大小范围的代码 全部完成
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N164 '
and n.fPostName>=' N163 '
and m.fBasicType='基础'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N001 '
and n.fPostName>=' N015 '
and m.fBasicType='组塔'
//铁塔单一工序
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.TowerSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='组塔'
and m.fBasicName='前期准备'
塔材运输
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.TowerSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N036 '
and m.fBasicType='组塔'
and m.fBasicName='塔材运输'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N188 '
and n.fPostName>=' N188 '
and m.fBasicType='组塔'
C7C690A04690000185E6AC01C1101587
DELETE FROM Person WHERE LastName = 'Wilson'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N001 '
and n.fPostName>=' N015 '
and m.fBasicType='组塔'
// 20171221 架线弯沉工序
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N028 --- N029 '
and m.fBasicType='架线'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N028 --- N029 '
and m.fBasicType='架线'
//查询架线
select m.fBasicType from pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
where n.fPostName=' N028 --- N029 '
and m.fBasicType='架线'
and n.fID = m.fMasterID
//
//排班
pm_project_proceduredetail pm_project_persondetail2
select * from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
pm_project_project_gongxu
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='未开始',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName=' N120 --- N123 '
and m.fBasicType='架线'
//20171226
//跟新完成状态
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A009'
and n.fPostName>='A007'
and m.fBasicType='基础'
//跟新不完成状态
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName<='A009'
and n.fPostName>='A007'
and m.fBasicType='基础'
//跟新一半数据
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A004'
and n.fPostName>='A004'
and m.fBasicType='基础'
and m.fBasicName<>'接埋地线'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A004'
and n.fPostName>='A004'
and m.fBasicType='基础'
and m.fBasicName<>'接埋地线'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A047'
and n.fPostName>='A047'
and m.fBasicType='基础'
and m.fBasicName='前期准备'
or and m.fBasicName='基础开挖'//
//排班桩号表 pm_project_proceduredetail // 排班工序表
pm_project_persondetail2
// sql桩号表
select * from pm_project_proceduredetail m where m.fPtzhuangN=' N017'
select * from pm_project_proceduredetail m where m.fPtzhuangN='
N017 'and m.fCreateDateTime>='2017-12-21'
c95effa915f245dfb5a369e585bb5b8b
//
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='c95effa915f245dfb5a369e585bb5b8b'
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='c95effa915f245dfb5a369e585bb5b8b'
d82f8ef4b8b343038a74c2516c3235c9 ee04fe37aed14ebd911aa127f8d2aec6
DELETE from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
DELETE from pm_project_proceduredetail ,pm_project_persondetail2
where pm_project_proceduredetail.fID
=pm_project_persondetail2.fPaibanIDTTT and
pm_project_proceduredetail.fPtzhuangN=' N034 '
ee04fe37aed14ebd911aa127f8d2aec6
17 1556df1e382b44a984c95b958d8a05ec
d82f8ef4b8b343038a74c2516c3235c9
//17组塔
c95effa915f245dfb5a369e585bb5b8b
//19组塔 f3d946ef6b8e464194d538b2f4d413d4
//
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='f3d946ef6b8e464194d538b2f4d413d4'
//68组塔 fbf0ded5000b4bc688292cc248babf70
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='fbf0ded5000b4bc688292cc248babf70'
//49组塔 4ba2ea4e59274100a641721191c8832a
//99组塔 bb30433831334056bee1f80f3ec5b031
//157组塔 9d27da64fcaf4375a27d7c42994c6d57
C7C690A045A0000150F3A20015501C50
select * from pm_project_persondetail2 m where
m.fPtfMasterID=' C7C690A045A0000150F3A20015501C50
' and m.fPaibanIDTTT<>'9d27da64fcaf4375a27d7c42994c6d57'
//163 组塔 ef0841ffee9e4ce593a7f87b49e63b10
N015 --- N028
//架线 9c04df56cf9c4eb2a6170b6bb30ce973
select * from pm_project_proceduredetail m where
m.fPtzhuangN=' N015 --- N028 '
//架线 28 29 630a709e62634bbd9db0066f9bc904a3
// 112 010 26f948ca84b74419bfcb16deb32f2d06
select * from pm_project_proceduredetail m where
m.fPtzhuangN=' N028 --- N029 '
//N55 74 f8c5b0486c49452b86a6f0739fc3d426
// 102 110 c1e3108cbd094e6c8c53e3b81736995a
C7CE09581EE00001B79217DB4E971E88
select * from pm_project_persondetail2 m where
m.fPtfMasterID=' C7CE09581EE00001B79217DB4E971E88
' and m.fPaibanIDTTT<>'c1e3108cbd094e6c8c53e3b81736995a'
C7CE09581EE00001B79217DB4E971E88
//120-123 架线 e16790d3d3314cd298a572a237bf6aaf
select * from pm_project_proceduredetail m where
m.fPtzhuangN=' N120 --- N123 '
//17 组塔 3888da90ab66427494f40d69f1d2dfc0 30
// jichu 17 update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='未完成',m.fSum=0,m.fState='未完成'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.TowerSubPageState='未开始', m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName=' N017 '
and m.fBasicType='组塔'
// 外键 C7C690A041000001BD101F63B8D016F8
feeb28b9f7704adb972b2b3f69072ab3
feeb28b9f7704adb972b2b3f69072ab3
//跟新分包商数据
update pm_project_project_gongxu m set m.fState ='未完成', m.fSum =
0//初始化工序表
update pm_project_project_postinformationtab m set
m.fBasicsSubPlanSum =0,m.fTowerSubPlanSum =0,m.fStringingSubPlanSum =0,
m.BasicsSubPageState='未开始',m.TowerSubPageState='未开始',m.StringingSub
PageState='未开始'
update pm_project_persondetail2 m set m.fTeamName='',m.fTeamID=''
where m.
pm_project_proceduredetail
//查询工作排班从表 桩号
SELECT * FROM pm_project_proceduredetail N WHERE
N.BasicsSubPageName='四川省津华电力分包商'
//更新班组
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='dddd' where m.BasicsSubPageName='四川省津华电力分包商'
and n.fPaibanIDTTT=m.fID
//
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='dddd',n.fTeamID ='dd' where
m.BasicsSubPageName='四川省津华电力分包商' and n.fPaibanIDTTT=m.fID
//基础 四川腾峰
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='郝守成',n.fTeamID ='C7CD4FC44110000196A113901DB416FC',
n.fPlanSum=100
where m.BasicsSubPageName='四川腾烽电力分包商' and
n.fPaibanIDTTT=m.fID
唐山博聚建筑分包商 四川省输变电分包商 四川省岳池送变电分包商
大元建业集团分包商
//四川省津华电力分包商
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='刘顺宽',n.fTeamID ='C7CD4FFDB1000001598744241C1460E0',
n.fPlanSum=100
where m.BasicsSubPageName='四川省津华电力分包商' and
n.fPaibanIDTTT=m.fID
//山东睿涵电力工程有限公司
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='睿涵苏必安',n.fTeamID
='C7CD50192EA000013E52AE0AFDE01F5D', n.fPlanSum=100
where m.BasicsSubPageName='山东睿涵电力分包商' and
n.fPaibanIDTTT=m.fID
//
//基础 唐山博聚建筑安装有限公司
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='博聚苏必安',n.fTeamID ='C7CD503A04F000013D4D86E07B801BA4',
n.fPlanSum=100
where m.BasicsSubPageName='唐山博聚建筑分包商' and
n.fPaibanIDTTT=m.fID
//四川省输变电分包商 基础
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='王伟',n.fTeamID ='C7CD504F08A00001CB1B1620EEFF7DA0',
n.fPlanSum=100
where m.BasicsSubPageName='四川省输变电分包商' and
n.fPaibanIDTTT=m.fID
//四川省岳池送变电分包商
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='岳池苏必安',n.fTeamID
='C7CD508D70B00001ACFBD5B3D2D01956', n.fPlanSum=100
where m.BasicsSubPageName='四川省岳池送变电分包商' and
n.fPaibanIDTTT=m.fID
//大元建业集团分包商
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='罗经理',n.fTeamID ='C7CD511C0D7000017A1B13C018E0B660',
n.fPlanSum=100
where m.BasicsSubPageName='大元建业集团分包商' and
n.fPaibanIDTTT=m.fID
//组塔四川省津华电力工程有限公司
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='马福彬',n.fTeamID ='C7CD5056AC70000147EF144517151B8B',
n.fPlanSum=100
where m.TowerSubPageName='四川省输变电分包商' and
n.fPaibanIDTTT=m.fID and m.fProjectWrokType ='组塔'
//四川精四川省津华电力工程有限公司 组
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='刘顺宽',n.fTeamID ='C7CD4FFDB1000001598744241C1460E0',
n.fPlanSum=100
where m.TowerSubPageName='四川省津华电力分包商' and
n.fPaibanIDTTT=m.fID and m.fProjectWrokType ='组塔'
//sql
20180108
select * from pm_project_proceduredetail m where m.fPtzhuangN='
N083 --- N100 '
2b98f18775f84c6abbcb71e8d61ab47f
2b98f18775f84c6abbcb71e8d61ab47f
pm_project_persondetail2
2b98f18775f84c6abbcb71e8d61ab47f
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N188 '
and n.fPostName>=' N188 '
and m.fBasicType='组塔'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N017 '
and n.fPostName>=' N017 '
and m.fBasicType='组塔'
// paiban
pm_project_proceduredetail
pm_project_persondetail2
select
//
select * from pm_project_proceduredetail m where m.fPtzhuangN='
N017 ' feeb28b9f7704adb972b2b3f69072ab3
pm_project_persondetail2
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='feeb28b9f7704adb972b2b3f69072ab3'
update pm_project_proceduredetail n , pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fSum=100,m.work ='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N188 '
and n.fPostName>=' N188 '
and m.fBasicType='组塔'
//
paiban update pm_project_proceduredetail n ,
pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fToalSum=100,m.fWorkState ='已完成'
where n.fID = m.fPaibanIDTTT
and n.fPtzhuangN=' N017 '
and m.fPtBasicType='组塔'
and n.fProjectWrokType='组塔'
//
feeb28b9f7704adb972b2b3f69072ab3
update pm_project_proceduredetail n , pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fToalSum=100,m.fWorkState ='已完成'
where n.fID = m.fPaibanIDTTT
and n.fPtzhuangN=' N166 '
and m.fPtBasicType='组塔'
and n.fProjectWrokType='组塔'
update pm_project_proceduredetail n , pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fToalSum=100,m.fWorkState ='已完成'
where n.fID = m.fPaibanIDTTT
and n.fPtzhuangN=' N017 '
and m.fPtBasicType='架线'
and n.fProjectWrokType='架线'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N120 --- N123 '
and m.fBasicType='架线'
*************************************************************************
*************************************************************************
************************
20180223 工作记录
王文安 管理员
陈启红
济南
李天宏 管理员
周启 施工经理
梁伦婷 施工经理
陈江利 施工班组
陈江李 施工班组
叶岳辉 施工班组
C7DEBA8A1EA00001EB8B1EB01620BFF0 圣辉四期项目部 项目部id
pm_project_project_informationtable_postsetb_xm_3gw
项目信息-岗位表
pm_project_project_informationtable_postsetb_people
项目信息-人员表
pm_project_project_informationtable_postsetb_xm
C7E2949FE1700001251CD3A6283CA870 十部
$row.val("fysxs1") =='2'
$row.val("fysxs1") =='1' || $row.val("fysxs1") =='2'
C7E29581A7C000013A10969379F71D56
Model.prototype.xmbonckick1 = function(event){
//项目部点击事件, 跳转详细
debugger
var data = this.comp("pro_projc_xmb");
var pro_g = this.comp("pro_projc_gang");
//参数列表
var N_fiter1="1";
var N_fiter2="2";
var id = data.getRowID(event.bindingContext.$object);
data.to(id);
pro_g.setFilter("Nb1",
"pm_project_project_informationtable_postsetb_xm_3gw.fysxs1='"+N_f
iter2+"'");
pro_g.refreshData();
this.comp("bdstm").to("douce7");
};
var data = this.comp('mainData');
data.setFilter('filter1',"SA_OPPerson.sName like '%李%'");
data.setFilter('filter2',"SA_OPPerson.sCode = :operatorCode() or
SA_OPPerson.sCode = :code");
//给变参code赋值
data.filters.setStringVar("code","code_abc");
//最终qureyAction的KSQL中where部分将增加 and ((SA_OPPerson.sName
like '%李%') and (SA_OPPerson.sCode = :operatorCode() or
SA_OPPerson.sCode = 'code_abc'))
//统计mainData中年龄fAge合计
var sum = this.comp('mainData').sum('fAge');
//统计mainData中fName姓“李”的年龄fAge合计
var sum = this.comp('mainData').sum('fAge',function(ev){
var v = ev.source.getValue('fName',ev.row);
return v.indexOf('李')==0;
});
fxmbName
$model.pro_zb.val("fReachSum") =='0/0'
$model.pro_zb.val("fReachSum") !='0/0'
Model.prototype.selectgzp1 = function(event){
//选择工作票
var data = this.comp("basgzpb");
var basgzpc = this.comp("basgzpc");
var s = this.comp("select1").val();
data.setFilter("t",
"pm_project_basic_main_gongzuorenwu2.fBz='"+s+"'");
data.refreshData();
basgzpc.refreshData();
};
C7D7629EC85000016FE61E2015805100
基础**********************************************************
************
C7D7629F6D70000120EC5C2714491474
组塔**********************************************************
************
C7E29FC0F2C000019CE71F2C29DE1910 架线
select * from pm_project_project_informationtable_postsetb_xm_3gw m
where m.fPostxmid='C7E29581A7C000013A10969379F71D56'
$UI/BZB01/common/img/u66.png
周牛宝 管理员
王留微
jishizao 英国保城集团
周 启 山东迪尔公司 管理员
******************************
山东迪尔公司
******************************
管理员 周 启
经理 曾诚革 zengchengge
林 匡 lingkuang
谢夏光 xiexiaguang
班长 欧金才 oujingcai
吴 本 wuben
刘边仁 liubanren
班组人员 郭幼丹 guoyoudan
梁叔侠 liangshuxia
***********************************************************
Model.prototype.Count3open = function(event){
//选择人员 跳转到5
debugger
var data = this.comp("jicu_peo");//人员表
data.refreshData();
var pro_projc_gang= this.comp("pro_projc_gang");
var rows = pro_projc_gang.getCurrentRow();
var N_tnd = pro_projc_gang.getValue("fPostWriteID",rows);
//数据回显
data.each(function(parmas){
var Na = data.getValue("fPostWriteID", parmas.row);
if(N_tnd.indexof(Na)==1){
data.setValue("sFamilyAddress", '1', parmas.row);
}
});
this.comp("bdstm").to("douce5");
//选择org人员
};
*************************************************************************
*************************************************************
*************************************************************************
*************************************************************
站班汇报
*************************************************************************
*************************************************************
*************************************************************************
*******
山东迪尔公司
******************************
管理员 周 启
经理 曾诚革 zengchengge
林 匡 lingkuang
谢夏光 xiexiaguang
班长 欧金才 oujingcai
吴 本 wuben
刘边仁 liubanren
班组人员 郭幼丹 guoyoudan是的发送的地方是的发送东 演示
梁叔侠 liangshuxia
************************************************************************
************************************************************************
*****************************************
//选择人员 跳转到5
var data = this.comp("jicu_peo");//人员表
data.refreshData();
var pro_projc_gang= this.comp("pro_projc_gang");
var rows = pro_projc_gang.getCurrentRow();
var N_tnd = pro_projc_gang.getValue("fPostWriteID",rows);
//数据回显
data.each(function(parmas){
var Na = data.getValue("sID", parmas.row);
if(N_tnd.indexOf(Na)==-1){
}else{
data.setValue("sFamilyAddress", '1', parmas.row);
}
});
this.comp("bdstm").to("douce5");
//选择org人员
******************************************************************
******************************************************************
*****************************************************
1.进度汇报 添加备注...
2.所有数据回显
3.站班汇报 地理位置...###############
4.进度汇报数据同步
5.站班汇报###############
6.进度汇报###############
7.排班 同步, 新增后顺序############### 同步解决, 剩下 数据回显
8.排序###############
9.单选###############
10.任务清单
11.
//参数列表
var storage =window.localStorage;
var pd_porN=storage["Door_login2018_now_prona"];//项目名称
//
project_report.setValue("fspName", st_arr,rows);
project_report.setValue("fspID", st_brr, rows);
c268c816-cd3c-4620-a757-100ae1955fb7
c0876663-4879-4191-816c-dd96843fe11b
52768d1d-0f39-4b4c-9906-b144882b662d
ba9eb5a1-c98b-4257-a348-be9d12069303
N_id
******************************************************************
**************************************
//桩号回显
debugger
var pro_zb = this.comp("pro_zb");
var pro_zh = this.comp("pro_zh");
//参数列表
var rows=pro_zb.getCurrentRow();
var N_Nam =pro_zb.getValue("fPlaceName",rows);
//黑盒
pro_zh.each(function(parmas){
var Na = pro_zh.getValue("fPostName", parmas.row);
if(N_Nam == undefined|| N_Nam == null||N_Nam ==''){
debugger
}else{
if(N_Nam.indexOf(Na)==-1){
}else{
pro_zh.setValue("fState", '1', parmas.row);
}
}
});
this.comp("contents1").to("content2");
ref("fPostState")
//
var st =pro2.getValue("fPostState", params.row);
var st_name =pro2.getValue("fPostWriteName", params.row);
var st_sID =pro2.getValue("fPostWriteID", params.row);
var st =pro2.getValue("fPostState", params.row);
var st_name =pro2.getValue("fPostWriteName", params.row);
var st_sID =pro2.getValue("fPostWriteID", params.row);
Model.prototype.newwork3 = function(event){
// 新增排版表数据 。这个动作是为了架线新增工序, 要做的判断是
排班表和 工序表 都要有类别
var data1 =this.comp("pro_quduan");
var data2 =this.comp("pro_work33");
var data3 =this.comp("pro_work44");
//获取参数
var storage =window.localStorage;
var pd_porN=storage["Door_login2018_now_prona"];//项目名称
var pd_porD=storage["Door_login2018_pn_proid"];//项目id
var pd_porC=storage["Door_login2018_pn_procode"];//项目编码
//
var user = localStorage.getItem("user");//人员ID, 组织ID
var sp_md5Str = JSON.parse(user).md5Str;//md5
var s_sum= data1.getValue("fBasicsSubPlanSum");
var s_fid= data1.getValue("fID");
var s_date = new Date();
var s_name= data1.getValue("fPostName");
//排班主表
var stitle =
$(this.getElementByXid("spanjx1")).html();//获取到类别
data2.newData();
var dat2_id = data2.getCurrentRowID();
data2.setValue("fMasterID",s_fid);
data2.setValue("fWriteTime",s_date);
data2.setValue("fwanLiang",s_sum);
data2.setValue("fWorkType",stitle);
//排班从表
var span1 = $(this.getElementByXid("spanjx1")).html();
var span2 = $(this.getElementByXid("spanjx2")).html();
//调用动作,去后台判断工序新增是要新增项目工序还是桩后面的工序
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getzhuangquduangxmesagge1",
"async" : false,
"params" : {
"id" : s_fid ,
"type1" : span1 ,
"type2" : span2 ,
"pro_id" : pd_porD
},
"success" : function(emp) {
var mg_s =emp.gx.rows.length;
for(var i =0;i<mg_s;i++){
data3.newData();
data3.setValue("fMsterID",dat2_id);//外键,跟随桩号或
者区段
data3.setValue("fPaibanIDTTT",emp.gx.rows[i].fMasterID
.value);//外键,跟随桩号或者区段
data3.setValue("fzhuangqd",s_name);//外键,工序名称
data3.setValue("fPtBasicType",
emp.gx.rows[i].fBasicType.value);//工序类别
data3.setValue("fPtBasicName",
emp.gx.rows[i].fBasicName.value);//工序名称
data3.setValue("fPtfID",
emp.gx.rows[i].fBasicCode.value);//工序ID
data3.setValue("fPtfOnlyone",
emp.gx.rows[i].fOnlyone.value);//唯一工序
data3.setValue("fToalSum",
emp.gx.rows[i].fSum.value);//完成量
data3.setValue("fWorkState",
emp.gx.rows[i].fState.value);//完成状态
data3.setValue("fNo", emp.gx.rows[i].fNo.value);//编号
data3.setValue("fStateName","确定中");//文件状态
data3.setValue("fStateID","1");//文件状态ID
data3.setValue("fProjectName",pd_porN);//项目名称
data3.setValue("fProjectCode",pd_porC);//项目编码
data3.setValue("fProjectID",pd_porD);//项目ID
data3.setValue("fMD5",sp_md5Str);//MD5
}
}
});
data2.saveData();
data3.saveData();
};
Model.prototype.tongbuzuta1 = function(event){
//同步 同步操作,
这边要做的是吧当前时间表的主键拿过来去查询从表符合的数据,当有数据
的时候保存,然后再次循环。
debugger
var pro_work1 = this.comp("pro_work11");
var pro_work2 = this.comp("pro_work22");
//参数列表
var w1_id = pro_work1.getCurrentRowID();
var arr =[];
var brr =[];
var crr =[];
pro_work2.each(function(parmas){
// var id = pro_work2.getValue("fPtBasicName");
var State = pro_work2.getValue("fMsterID",parmas.row);
if(State==w1_id){
var s_name = pro_work2.getValue("fTeamName",parmas.row);
var s_id = pro_work2.getValue("fTeamID", parmas.row);
var s_time = pro_work2.getValue("fEndTime", parmas.row);
if(s_id == undefined|| s_id == null||s_id ==''){
}else{
arr.push(s_name);
brr.push(s_id);
crr.push(s_time);
}
}
});
//同步数据
var tb_name = arr[0];//班组
var tb_id = brr[0];//班组id
var tb_s_time = crr[0];//时间
//
pro_work2.each(function(parmas){
// var id = pro_work2.getValue("fPtBasicName");
var State = pro_work2.getValue("fMsterID",parmas.row);
if(State==w1_id){
pro_work2.setValue("fTeamName",tb_name,parmas.row);
pro_work2.setValue("fTeamID",tb_id,parmas.row);
pro_work2.setValue("fEndTime",tb_s_time,parmas.row);
}
});
pro_work2.saveData();
};
bz_people.each(function(par){
debugger
var e_id = bz_people.getValue("fPostWriteID", par.row);
if(N_s==e_id){
debugger
bz_people.setValue("fPostState","1", par.row);
}
});
}
litiegao
var storage = window.localStorage;
storage["Door_jdhb5"] = id;//进度汇报页面
val("fxxsb") =='k'
data2.each(function(params){
var st =data2.getValue("fPostState", params.row);
var st_name =data2.getValue("fPostWriteName", params.row);
var st_sID =data2.getValue("fPostWriteID", params.row);
if(st==1){
arr.push(st_name);
brr.push(st_sID);
}
});
************************
作业过程预控措施及落实: 是
否
1、施工现场布置:严格按照《输变电工程安全文明施工实施方案》的要求设置安全
警戒线、警示牌、友情提示牌、现场设置混凝土配合比标牌等安全设施。
2、基础立模应牢固。
3、操作转动机械时严禁戴手套。传动部件应有防护罩。
4、施工用电设施的安装、维护必须严格按《安规》执行,严禁私拉乱接;开关负荷
侧的首端处必须安装漏电保
护装置,熔丝的规格应符合设备的要求,且不得用其它金属线代替。
5、机电设备使用前应进行全面检查,确认机电装置完整、绝缘良好、接地可靠,使
用时严格执行安规要求。搭
设浇筑平台的跳板材质和搭设符合要求,跳板捆绑牢固,支撑牢固可靠,有上料通道
;上料平台不得搭悬臂结构,中间应设支撑点并结构可靠,平台应设护栏;大坑口基
础浇制时,搭设的浇制平台要牢固可靠,平
台横梁应加撑杆,以防平台横梁垮塌伤。
6、基础施工前应配备漏电保安器,无漏电保安器的作业现场,禁止浇制施工,发电
机、搅拌机在使用前应将外 壳安装保护接地线,搅拌机电源线应架
7、坑下捣固人员必须正确佩戴安全帽,坑上监护人和坑下工作人员要互相联系配合
好,上、下坑应有攀登措施。 8、模板应用绳索和木杠滑入坑内。
9、模板的支撑应使用钢支撑架或方木,采用吊梁应有足够的强度,搁置应稳固。
10、模板支撑应牢固,并应对称布置;高出坑口的加高立柱模板应有防止倾覆的措施
。
12、拆除模板应自上而下进行;拆下的模板应集中堆放;木模板外露的铁钉应及时
拔掉或打弯。
13、人工搅拌混凝土的平台应搭设稳固、可靠。工作前必须检查基础模板和浇制平
台是否牢固可靠。施工
人员不得在支撑和独木上行走。 14、人工浇筑混凝土遵守下列规定: ①
浇筑混凝土或投放大石时,必须听从坑内捣固人员的指挥。 ②
坑口边缘0.8m以内不得堆放材料和工具。 ③
捣固人员不得在模板或撑木上走动。 ④
电动振捣器应采用绝缘良好的橡皮软线;振捣器运转过热或暂停工作时,应将电源切
断。
15、浇制用的电源,必须配备专用电源箱,且有触电保安器装置。机电设备使用前应
进行全面检查,确认
机电装置完整、绝缘良好、接地可靠。在林区施工时,油料堆放处应做好防护,施工
现场配备灭火器。
18、用手推车运送混凝土时,倒料平台口应设挡车措施;倒料时严禁撒把。
21、采用暖棚养护,应采取防止废气窒息、中毒措施,火源不得与易燃物靠近。
22、在光线不足及夜间工作的场所,应设足够的照明;主要通道上应装设路灯。
现场作业工艺要点: 1.
对原材料进行外观检查,水泥、砂、石粒径及含泥量应符合要求、应采取措施与地面
隔离。复核钢筋规格、数量,基础及地脚螺栓尺寸。 2.
严格按要求控制混凝土配合比、水灰比,每班日或每个基础腿应检查两次及以上坍落
度并做好记录。混凝土搅拌必须到位,机械搅拌不得少于2分钟。冬季施工当平均气
温低于5℃时,应对砂、石、水进行加热后
搅拌,优先加热水,但水泥不得加热。 3.
混凝土不宜长时间、长距离运送,以免出现离析现象。混凝土浇灌落差超过2m时应设
置溜筒。 4.
混凝土应分层浇筑,分层捣固,混凝土每层浇筑厚度应控制在插入式振捣棒有效作用
长度的1.25倍以内。使用插入式振捣器宜直上直下、快插慢拔,插点均匀。振捣器的
移动间距一般为300~400mm。每次振捣
都要插入混凝土下层30~50mm,每处振捣应以混凝土表面出现浮浆和不再出现气泡,
不再显著沉落为度;不得有漏振和过振现象。 5.
混凝土全部浇筑完成后,在混凝土快要初凝前及时对地脚螺栓进行复核调整,调整后
的地螺四周需再捣固一次。基础棱边分明,基面平整光滑,不积水。 6.
同一基础应一次性浇筑完成(设计有要求的除外),相隔时间不得超过2小时。
7.
及时做好试块件,试块应在现场从浇筑中的混凝土取样制作,其养护条件应与基础相
同。 8.
基础根开、对角线、地螺间距及外露高度应符合设计要求。 9.
根据气温做好养护,混凝土未达到一定强度时,应用喷壶浇水,不得用水直接冲击表
面,保持混凝土湿润。冬季当日平均气温低于5℃时,不得浇水养护,而应采取暧棚法
、覆盖法进行养护,保证养护温度不低
于5℃,并应保持混凝土湿润。 10.
及时做好原材料的跟踪记录;按要求拍摄数码照
作业分工:
作业前检查
是 否 施工人员着装是否规范、
精神状态是否良好 □ □
施工安全防护用品(包括个人)、 用具是否齐全和完好 □
□ 现场所使用的工器具是否完好且符合技术安全措施要
□ □
是否编制技术安全措施交底 □
□ 施工人员是否参加过本工程技术安全措施交底
□ □
施工人员对工作分工是否清楚 □
□ 各工作岗位人员对存在的风险点、 风险源是否明白
□ □
预控措施是否明白
//返回上一页
Model.prototype.backBtnClick = function(event){
justep.Shell.closePage();
setTimeout(function(){
justep.Shell.fireEvent("onRestoreContent", {});
},500);
};
//图片路径转换
Model.prototype.getImageUrl = function(url){
return require.toUrl(url);
};
□ □
//减数量
Model.prototype.reductionBtnClick = function(event){
/*
1、减少数量按钮绑定点击事件onClick()
2、点击按钮,当前记录的fNumber值减1
3、fNumber为1时不再相减
*/
var row = event.bindingContext.$object;
var n=row.val("fNumber");
if(n>1){
row.val("fNumber",n-1);
}
};
//加数量
Model.prototype.addBtnClick = function(event){
/*
1、增加数量按钮绑定点击事件onClick()
2、点击按钮,当前记录的fNumber值加1
*/
var row = event.bindingContext.$object;
var n=row.val("fNumber");
row.val("fNumber",n+1);
};
var data = this.comp("data");
var goodrows = data.find();
var goodsData = this.comp("goodsData");
var goodsRows = goodsData.find(["fChoose"],["1"]);
goodsData.deleteData(goodsRows);
shopData.each(function(obj){
var n =
goodsData.find(["fShopID"],[obj.row.val("id")]).length;
if(n == 0){
shopRows.push(obj.row);
}
});
Model.prototype.showBackBtn = function(isBack){
/*
1、根据参数修改calculateData
*/
this.isBack = isBack;
var v = isBack ? 1 : 0;
this.comp("calculateData").setValue("isBack",v);
};
一条语句,多个变量
您可以在一条语句中声明很多变量。该语句以 var
开头,并使用逗号分隔变量即可:
var lastname="Doe", age=30, job="carpenter";
声明也可横跨多行:
var lastname="Doe",
age=30,
job="carpenter";
重新声明 JavaScript 变量
如果重新声明 JavaScript 变量,该变量的值不会丢失:
在以下两条语句执行后,变量 carname 的值依然是 "Volvo":
var carname="Volvo";
var carname;
JavaScript 数据类型
字符串(String)、数字(Number)、布尔(Boolean)、数组(Array)、对象(Object)、空(Null)、未定义(Undefined)。
var answer1='It\'s alright';
var answer2="He is called \"Johnny\"";
var answer3='He is called "Johnny"';
JavaScript 对象
对象由花括号分隔。在括号内部,对象的属性以名称和值对的形式 (name : value) 来定义。属性由逗号分隔:
var person={firstname:"John", lastname:"Doe", id:5566};
上面例子中的对象 (person) 有三个属性:firstname、lastname 以及 id。
空格和折行无关紧要。声明可横跨多行:
var person={
firstname : "John",
lastname : "Doe",
id : 5566
};
对象属性有两种寻址方式:
实例
name=person.lastname;
name=person["lastname"];
当您声明新变量时,可以使用关键词 "new" 来声明其类型:
var carname=new String;
var x= new Number;
var y= new Boolean;
var cars= new Array;
var person= new Object;
var person = {firstName:"John", lastName:"Doe", age:50, eyeColor:"blue"};
var person = {
firstName:"John",
lastName:"Doe",
age:50,
eyeColor:"blue"
};
var person = {
firstName:"John",
lastName:"Doe",
age:50,
eyeColor:"blue"
};
****************************************
福田四川工程公司
lifutian 管理员
赵铁一 项目经理
赵铁二
赵铁三
张宁一
张宁二
$row.val("fPostType") =='项目部'
98ed9717-e342-45bf-b95f-4ede8d13dda6
Table table3 = DataUtils.queryData(conn, sqlzuzhigx2, null,null, null,null);
Iterator<Row> iterator3 = table3.getRows().iterator();
while(iterator3.hasNext()){
Row info2 = iterator3.next();
String new_uuid = UUID.randomUUID().toString(); //获取UUID并转化为String对象 ID
String vb_fID = info2.getString("fID");
String vb_fNo = info2.getString("fNo");
String vb_fBasicType = info2.getString("fBasicType");
String vb_fBasicName = info2.getString("fBasicName");
String vb_fBasicCode = info2.getString("fBasicCode");
String vb_fBz = info2.getString("fBz");
String vb_fMasterID= info2.getString("fMasterID");
Model.prototype.ztxf1 = function(event){
//指头下发 基础
debugger
var pro_work1 = this.comp("pro_work1");
var pro_work2 = this.comp("pro_work2");
var pro_z_j = this.comp("pro_zhuang_j");//桩id
//参数列表
debugger
var w1_id = pro_work1.getCurrentRowID();//排班时间表 id
var z1_id = pro_z_j.getCurrentRowID();//桩区段表id
var stitle = $(this.getElementByXid("spanjx1")).html();//获取到类别
pro_work2.each(function(parmas){
var State = pro_work2.getValue("fMsterID",parmas.row);
if(State==w1_id){
//如果当当前从表工序表的外键等于排班时间主表的主键的时候,就定位到这这些要下发的数据,然后进行数据处理
pro_work2.setValue("fStateName","待审批",parmas.row);
pro_work2.setValue("fStateID","1",parmas.row);
}
//调用动作,这边要做的处理是把当前数据作为有效数据,去数据库中修改之前的数据为失效,判断依据是当前时间主表的id.
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getxmpb_xiafaczsj17",
"async" : false,
"params" : {
"pt_id" :w1_id,
"f_zqid" :z1_id,
"f_leb" :stitle
},
"success" : function(emp) {
//加载data部分数据
debugger
}
});
});
pro_work1.setValue("fPtzhuangState","已排班");
pro_work2.saveData();
pro_work1.saveData();
justep.Util.hint("下发成功");
};
fPtfID
fPostxmid
select *from pm_project_project_informationtable_postsetb_xm_3gw m where m.fPostxmid='C7E3A96CE5A00001E6EB1447C9C0166E'
select *from pm_project_project_informationtable_postsetb_xm m where m.fxmbName='权威项目部'
C7E3AA944EF0000178E1135010651C9C
C7E3AB6CF80000015948DB2019A06600
Model.prototype.stmok1 = function(event){
//新增班组确定事件
var gang = this.comp("pro_projc_gang");
var main = this.comp("pro_projc_main");
var sCode = generateUUID();//获取主键
//参数列表
var isv = this.comp("input133").val();
var main_id = main.getCurrentRowID();
//容器
gang.newData();
gang.setValue("fPostName",isv);
gang.setValue("fysxs1","2");
gang.setValue("fNo","7");//判断人员单个状态
gang.setValue("fPostxmid1",sCode);
gang.setValue("fPostXlb","fbs");
gang.setValue("fPostType","项目部");
gang.saveData();
gang.refreshData();
//调用动作
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getteamname1pro",
"async" : false,
"params" : {
"id" :main_id//项目ID
},
"success" : function(emp){
//加载data部分数据
for(var i =0 ;i<emp.rows.length;i++){
gang.newData();
gang.setValue("fPostxmid2",sCode);
gang.setValue("fPostName",emp.rows[i].fPostName.value);
gang.setValue("fPostXlb",emp.rows[i].fPostXlb.value);
gang.setValue("fPostType","班组");
gang.setValue("fysxs1", "1");
gang.setValue("fNo", "8");
gang.saveData();
}
}
});
//
function generateUUID() {
var d = new Date().getTime();
var uuid = 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
var r = (d + Math.random()*16)%16 | 0;
d = Math.floor(d/16);
return (c=='x' ? r : (r&0x3|0x8)).toString(16);
});
return uuid;
}
//关闭弹出框
this.comp("messlist").hide();
};
}
public static JSONObject getjdhbmess1(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 查询对应人员的工作清单,这边作为对比字段是人员ID。项目ID
,文件状态为2 的,就是已经班组长确认过的数据才能在站班这边选择到
Connection conn = context.getConnection("jeecg37bzb");
String par_fID = params.getString("fID");//人员ID
String par_fName = params.getString("fName");//人员名称
java.sql.Date par_currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
String fProjectID = params.getString("fProjectID");//项目ID
JSONObject doc=new JSONObject();
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
String state = "2";
// 查询
String sql1 = "SELECT * FROM pm_project_persondetail2 m where
m.fTeamID = '"+par_fID+"' and m.fProjectCode='"+fProjectID+"'and
m.fStateID='"+state+"'";
System.out.println("第一次查询的的sql "+sql1);
//
Table table3 = DataUtils.queryData(conn, sql1, null,null,
null,null);
Iterator<Row> iterator3 = table3.getRows().iterator();
while (iterator3.hasNext()) {
Row info = iterator3.next();
String new_uuid =
UUID.randomUUID().toString();//获取UUID并转化为String对象 ID
String fNo = info.getString("fNo");//1
String paibanfID = info.getString("fID");//1
String fProjectName = info.getString("fProjectName");//2
String fProjectCode = info.getString("fProjectCode");//3
String fzhuangqd = info.getString("fzhuangqd");//4
String fMsterID = info.getString("fMsterID");//5
String fPtBasicType = info.getString("fPtBasicType");//6
String fPtBasicName = info.getString("fPtBasicName");//7
String fPtfID = info.getString("fPtfID");//8
String fPtfMasterID = info.getString("fPtfMasterID");//9
String fPtfOnlyone = info.getString("fPtfOnlyone");//10
String fPaibanIDTTT = info.getString("fPaibanIDTTT");//11
String fTeamName = info.getString("fTeamName");//11
String fTeamID = info.getString("fTeamID");//11
String fequallyS = info.getString("fequallyS");//11
String fWorkState = info.getString("fWorkState");//11
Date fStartTime = info.getDate("fStartTime");//11
Date fEndTime = info.getDate("fEndTime");//11
String fWorkType = info.getString("fWorkType");//11
String fOnlyone = info.getString("fOnlyone");//11
int fToalSum = info.getInteger("fToalSum");//11
int fSingle = info.getInteger("fSingle");//11
int fPlanSum = info.getInteger("fPlanSum");//
String fStateName = info.getString("fStateName");//11
String fStateID = info.getString("fStateID");//11
String fStateImg = info.getString("fStateImg");//11
//插入语句
String insertsql5="INSERT INTO
pm_project_persondetail2_jingdu VALUES" +
"(" +
"'"+new_uuid+"'," +
"'"+fNo+"'," +
"'"+fProjectName+"'," +
"'"+fProjectCode+"'," +
"'"+fzhuangqd+"'," +
"'"+fMsterID+"'," +
"'"+fPtBasicType+"'," +
"'"+fPtBasicName+"'," +
"'"+fPtfID+"'," +
"'"+fPtfMasterID+"'," +
"'"+fPtfOnlyone+"'," +
"'"+fPaibanIDTTT+"'," +
"'"+fTeamName+"'," +
"'"+fTeamID+"'," +
"'"+fequallyS+"'," +
"'"+fWorkState+"'," +
"'"+fStartTime+"'," +
"'"+fEndTime+"'," +
"'"+fWorkType+"'," +
"'"+fOnlyone+"'," +
"'"+fToalSum+"'," +
"'"+0+"'," +
"'"+0+"'," +
"'"+fStateName+"'," +
"'"+fStateID+"'," +
"'"+fStateImg+"'," +
"'"+paibanfID+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'," +
"'"+par_fID+"'," +
"'"+par_fName+"'," +
"'"+par_currentDate+"'," +
"'"+fOnlyone+"'," +
"'"+fOnlyone+"'" +
")";
//插入工序成功
stmt.executeUpdate(insertsql5);
System.out.println("第一次插入工序成功 ");
}
doc.put("zt", "成功");
return doc;
}
public static JSONObject getxmbgxaction1(JSONObject params,
ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//项目立项,项目部岗位选择成立岗位设置,根据每个项目部的不同来新增
岗位
Connection conn = (Connection)
context.getConnection("jeecg37bzb");// 获取数据库连接
String pid = params.getString("pid");//获取项目ID
String xmbid = params.getString("xmbid");//获取项目部门ID
String sn = params.getString("sn");//获取项目类别
String weri = "";
JSONObject doc=new JSONObject();
//操作容器
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//查询所属项目下的岗位设置,带条件 id, 类别
String sql1parmasin1 = "SELECT * FROM
pm_project_project_informationtable_postsetb m WHERE
m.fMasterID='"+pid+"' and m.fPostXlb='"+sn+"'";
Table table2 = DataUtils.queryData((java.sql.Connection) conn,
sql1parmasin1, null, null, null, null);
//遍历
Iterator<Row> iterator2 = table2.getRows().iterator();
System.out.println("现在查询的项目人员这边的时候sql是:"+sql1parma
sin1);
while (iterator2.hasNext()) {
//遍历获取到的数据
String new_uuid = UUID.randomUUID().toString();
//获取UUID并转化为String对象 ID
Row info1 = iterator2.next();
String fID = info1.getString("fID");
String fNo = info1.getString("fNo");
String fPostName = info1.getString("fPostName");
String fPostWriteName = info1.getString("fPostWriteName");
String fPostWriteID = info1.getString("fPostWriteID");
String fPostCode = info1.getString("fPostCode");
String fPostID = info1.getString("fPostID");
String fPostState = info1.getString("fPostState");
String fPostType = info1.getString("fPostType");
String fMasterID = info1.getString("fMasterID");
String fProjectName = info1.getString("fProjectName");
String fProjectCode = info1.getString("fProjectCode");
String fRoleName = info1.getString("fRoleName");
String fRoleID = info1.getString("fRoleID");
String fMd51 = info1.getString("fMd5");
String fPostXlb = info1.getString("fPostXlb");
String fPostxmid = info1.getString("fPostxmid");
//插入数据,插入时候插入项目部主键为项目外键
System.out.println("返回的结果集是"+fID);
String sql1 ="insert into
pm_project_project_informationtable_postsetb" +
"(fID," +
"fNo," +
"fPostName," +
"fPostWriteName," +
"fPostWriteID," +
"fPostCode," +
"fPostID," +
"fPostState," +
"fPostType," +
"fMasterID," +
"fProjectName," +
"fProjectCode," +
"fRoleName," +
"fRoleID," +
"fPostxmid1," +
"fPostxmid2," +
"fMd5," +
"fPostXlb," +
"fPostxmid)" +
"values" +
"('"+new_uuid+"'," +
"'"+fNo+"'," +
"'"+fPostName+"'," +
"'"+weri+"'," +
"'"+fPostWriteID+"'," +
"'"+fPostCode+"'," +
"'"+fPostID+"'," +
"'"+fPostState+"'," +
"'"+fPostType+"'," +
"'"+fMasterID+"'," +
"'"+fProjectName+"'," +
"'"+fProjectCode+"'," +
"'"+fRoleName+"'," +
"'"+fRoleID+"'," +
"'"+new_uuid+"'," +
"'"+new_uuid+"'," +
"'"+fMd51+"'," +
"'"+fPostXlb+"'," +
"'"+xmbid+"')";
stmt.executeUpdate(sql1);
System.out.println("第一次插入岗位成功");
}
//返回数据集
doc.put("state","成功");
return doc;
}
public static JSONObject getloginselectProjectList1(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//登录查询项目
Connection conn = (Connection)
context.getConnection("jeecg37bzb");// 获取数据库连接
String sName = params.getString("sName");//获取桩号或者区段主键
String sID = params.getString("sID");//获取类别
String md5 = params.getString("md5");//
JSONObject doc=new JSONObject();
//操作容器
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//查询项目人员表中有几个当前人的ID
String sql1parmasin1 = "SELECT * FROM
pm_project_project_informationtable_postsetb_people m WHERE
m.fPostWriteID like'%"+sID+"%'";
System.out.println("第一次插入岗位成功"+sql1parmasin1);
// 查询
try {
//
Table a = DataUtils.queryData(conn, sql1parmasin1, null,
null, null, null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
}
Connection conn = (Connection)
context.getConnection("jeecg37bzb");// 获取数据库连接
String s_fID = params.getString("id");//获取项目主键
String s_fPrjoectName =
params.getString("fPrjoectName");//获取项目名称
String s_fProjectCode =
params.getString("fProjectCode");//获取项目编码
define(function(require){
var $ = require("jquery");
var justep = require("$UI/system/lib/justep");
var SqliteUtil =
require("$UI/ProjectSubcontracting_demo1/ProjectSub_20180102/prodata_0
01/project_class/pro_db/sqliteUtil");
var DemoDB =
require("$UI/ProjectSubcontracting_demo1/ProjectSub_20180102/prodata_0
01/project_class/pro_db/demoDB");
var Model = function(){
this.callParent();
this.demoDB = null;
};
Model.prototype.modelLoad = function(event){
//onload
/*var sData = this.comp("data1");
var storage=window.localStorage;
var LoginSGG =storage["Door_sLoginSLogoinGo"];//获取当前登录状态
//!==
if(!LoginSGG){
alert("登录状态为空,请确认登录状态");
} else{
if(LoginSGG=="是"){
if (!justep.Browser.isX5App) {
alert("本案例只支持在手机APP中运行");
return;
}
var self = this;
// 设备准备好后,才能通过插件打开数据库
document.addEventListener("deviceready", function() {
//
这里在DemoDB.js中实现了一个单例对象,为了能在多个功能
页中共用一个数据源,避免死锁
self.demoDB = DemoDB.getInstance();
// DemoDB.js中实现了自动判断并初始化数据库
self.demoDB.initData(function() {
// 初始化后刷新列表
self.comp("list1").refresh(true);
});
});
}else if(LoginSGG=="否"){
//!==
justep.Baas.sendRequest({
"url" :
"/pm_ProjectfenBao/pm_Project_Basic_TeamChange1",
"action" : "queryPm_project_basic_main_gongzuorenwu4",
"async" : false,
"params" : {
"limit" : event.limit,
"offset" : event.offset,
"filter" : sData.getFilter("filter")
// "orderBy" : "ADDTIME desc"
// "columns" :
baas.getDataColumns(thisObject.comp("todoData"))
},
"success" : function(data) {
sData.loadData(data, false);
}
});
}
}*/
};
Model.prototype.Submit1 = function(event){
/*//保存事件
var sdata = this.comp("data1");
var self = this;
var storage =window.localStorage;
var LoginSGG =storage["Door_sLoginSLogoinGo"];//获取当前登录状态
//!==
if(!LoginSGG){
alert("登录状态为空,请确认登录状态");
}else{
if(LoginSGG=="是"){
// 标记当前保存是异步执行的
event.async = true;
var db = this.demoDB.getDatabase();
var data = event.source;
SqliteUtil.saveData(db, data, "DEMO_Class1", null,
function(res) {
// 异步执行模式下,保存成功后必须执行doSaveAfter
data.doSaveAfter(true, event.options);
}, function(msg) {
data.doSaveAfter(false, event.options);
});
}else if(LoginSGG=="否"){
//在线保存
sdata.saveData();
alert("保存成功");
}
}*/
// 标记当前保存是异步执行的
event.async = true;
var db = this.demoDB.getDatabase();
var data = event.source;
SqliteUtil.saveData(db, data, "DEMO_Class1", null, function(res) {
// 异步执行模式下,保存成功后必须执行doSaveAfter
data.doSaveAfter(true, event.options);
}, function(msg) {
data.doSaveAfter(false, event.options);
});
};
Model.prototype.zbhClick = function(event){
//站班会
};
Model.prototype.data1CustomRefresh = function(event){
//接管刷新事件
var sdata = this.comp("data1");
var storage =window.localStorage;
var LoginSGG =storage["Door_sLoginSLogoinGo"];//获取当前登录状态
//!==
if(!LoginSGG){
alert("登录状态为空,请确认");
}else{
if(LoginSGG=="是"){
//离线登录#
// 标记当前刷新是异步执行的
event.async = true;
var db = this.demoDB.getDatabase();
var data = event.source;
var append = event.options && event.options.append; //
是否数据追加模式
var limit = event.limit; // 分页行数
var offset = event.offset; // 分页偏移
// 执行SQL查询
SqliteUtil.executeSql(db, "SELECT * FROM DEMO_Class1
LIMIT ? OFFSET ? ", [ limit, offset ], onSuccess,
onError);
function onSuccess(res) {
// 转换返回数据结果
var table = SqliteUtil.rowsToTable(res.rows);
if (offset == 0) {
//
如果偏移为零则表明加载第一页,需要在Table中提供总
行数,用于分页计算
SqliteUtil.executeSql(db, "SELECT COUNT(*) cnt
FROM DEMO_Class1 ", [], function(res) {
SqliteUtil.setTableTotal(table,
res.rows.item(0).cnt);
doRefreshData();
});
} else {
doRefreshData();
}
function doRefreshData() {
data.loadData(table, append);
//
异步执行模式下,加载数据后必须执行doRefreshAfter
data.doRefreshAfter(true, event.options);
}
}
function onError(msg) {
data.doRefreshAfter(false, event.options);
}
}else if(LoginSGG=="否"){
//!$$
justep.Baas.sendRequest({
"url" :
"/pm_ProjectfenBao/pm_Project_Basic_TeamChange1",
"action" : "queryPm_project_basic_main_gongzuorenwu4",
"async" : false,
"params" : {
"limit" : event.limit,
"offset" : event.offset,
"filter" : sdata.getFilter("filter")
// "orderBy" : "ADDTIME desc"
// "columns" :
baas.getDataColumns(thisObject.comp("todoData"))
},
"success" : function(data) {
sdata.loadData(data, false);
}
});
}
}
};
Model.prototype.button2Click = function(event){
//离线状态
var storage =window.localStorage;
storage["Door_sLoginSLogoinGo"]="是";
};
Model.prototype.button5Click = function(event){
var storage =window.localStorage;
storage["Door_sLoginSLogoinGo"]="否";
};
return Model;
});
//
require("$UI/system/lib/cordova/cordova");
require("css!$UI/demo/native/common/pub").load();
require("cordova!cordova-plugin-camera");
require("cordova!cordova-plugin-media-capture");
require("cordova!cordova-plugin-inappbrowser");
Model.prototype.newwork2 = function(event){
// 新增排版表数据 ,组塔
var data7 =this.comp("pro_main");
var data1 =this.comp("pro_zhuang_z");//桩号区段表
var data2 =this.comp("pro_work11");//排班表
var data3 =this.comp("pro_work22");//工序表
//获取参数
var s_sum= data1.getValue("fBasicsSubPlanSum");
var s_fid= data1.getValue("fID");
var s_date = new Date();
var pro_id= data7.getCurrentRowID();
var s_name= data1.getValue("fPostName");
//排班主表
var fWorkType = $(this.getElementByXid("spanzt1")).html();
data2.newData();
var dat2_id = data2.getCurrentRowID();
data2.setValue("fMasterID",s_fid);
data2.setValue("fWriteTime",s_date);
data2.setValue("fwanLiang",s_sum);
data2.setValue("fWorkType",fWorkType);
//排班从表
var span1 = $(this.getElementByXid("spanzt1")).html();
var span2= $(this.getElementByXid("spanzt2")).html();
//调用动作,去后台判断工序新增是要新增项目工序还是桩后面的工序
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getzhuangquduangxmesagge1",
"async" : false,
"params" : {
"id" : s_fid ,
"type1" : span1 ,
"type2" : span2 ,
"pro_id" : pro_id
},
"success" : function(emp) {
var mg_s =emp.gx.rows.length;
for(var i =0;i<mg_s;i++){
data3.newData();
data3.setValue("fMsterID",dat2_id);//外键,跟随桩号或
者区段
data3.setValue("fPaibanIDTTT",emp.gx.rows[i].fMasterID
.value);//外键,跟随桩号或者区段
data3.setValue("fzhuangqd",s_name);//外键,工序名称
data3.setValue("fPtBasicType",
emp.gx.rows[i].fBasicType.value);//工序类别
data3.setValue("fPtBasicName",
emp.gx.rows[i].fBasicName.value);//工序名称
data3.setValue("fPtfID",
emp.gx.rows[i].fBasicCode.value);//工序ID
data3.setValue("fPtfOnlyone",
emp.gx.rows[i].fOnlyone.value);//唯一工序
data3.setValue("fToalSum",
emp.gx.rows[i].fSum.value);//完成量
data3.setValue("fWorkState",
emp.gx.rows[i].fState.value);//完成状态
data3.setValue("fNo", emp.gx.rows[i].fNo.value);//编号
data3.setValue("fStateName","确定中");//文件状态
data3.setValue("fStateID","1");//文件状态ID
}
}
});
data2.saveData();
data3.saveData();
};
package pm_ProjectfenBao;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.UUID;
import javax.naming.NamingException;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.justep.baas.BaasException;
import com.justep.baas.action.ActionContext;
import com.justep.baas.data.DataUtils;
import com.justep.baas.data.Row;
import com.justep.baas.data.Table;
import com.justep.baas.data.Transform;
import com.justep.baas.data.sql.SQLException;
public class ProjectM {
public static JSONObject getTeamName(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
System.out.println("获得到的参数是:" + id);
// 查询
try {
String sql = "select
m.fWorkType,m.fProjectWrokType,m.fMasterID,m.fdoState,n.fBranc
hName,n.fequallyS,n.fWorkType,n.fID,n.fMsterID,n.fToalSum,n.fS
ingle,n.fWorkState from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fID=n.fMsterID and
n.fSteamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getlistjdhbRep(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 接受参数
// 声明要操作的数据库
// 接收参数
JSONArray userCode = (JSONArray) params.get("clis");
// 转换成要换成循环的格式
Object[] o = userCode.toArray();
// 遍历循环的数据
String Stateing = "已完成";
for (int i = 0; i < o.length; i++) {
System.out.println("数组中的数字是:" + o[i].toString());
// 接收每条循环出来的数据
String line = o[i].toString();
// 切割转成list
String[] linecut = line.split(",");
//
String xid = linecut[0];
String pid = linecut[1];
String todaysum = linecut[2];
//
// sql批量执行
Connection conn = context.getConnection("jeecg");
java.sql.Statement stmt = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
// 项目工序修改根据ID
stmt.addBatch("update pm_project_project_gongxu m set m.fSum
=m.fSum+'"
+ todaysum + "' where m.fID='" + xid + "'");
stmt.addBatch("update pm_project_project_gongxu m set
m.fState ='"
+ Stateing + "' where m.fID='" + xid + "' and
m.fSum>=100");
// 排班工序修改根据ID
stmt.addBatch("update pm_project_persondetail2 m set
m.fToalSum =m.fToalSum+'"
+ todaysum + "' where m.fID='" + pid + "'");
stmt.addBatch("update pm_project_persondetail2 m set
m.fWorkState ='"
+ Stateing
+ "' where m.fID='"
+ pid
+ "'and m.fToalSum>=100");
stmt.executeBatch();
conn.close();
}
return null;
}
public static JSONObject getJIngDuNewAction2Shenpi(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 接收参数 进度审批确定事件
//
JSONObject ab = new JSONObject();//json
//
String id = params.getString("id");//获取人员ID
String fProjectID = params.getString("fProjectID");//获取项目ID
String fMasterID = params.getString("fMasterID");//获取主表ID
用来鉴别 0 1
//临时变量
String State ="已完成";
String fBz="1";//判断是否修改,修改为 ,未修改为0 最后统一规0
String fBzNO="0";
String stateing="进行中";
String stateinged="已完成";
String jdweiwancheng="未完成";
String weikaishi="未开始";
String s1="基础";
String s2="组塔";
String s3="架线";
//sql 批量执行
Connection conn = context.getConnection("jeecg");//连接池
//
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);//类似容器什么的
//更新进度汇报表中的数据数量,
条件是:当班组ID,外键,临时变量符合参数时候,更新
String sql1update1="update pm_project_schedulmain2 m set
m.fWancSum = m.fWancSum+m.fJinRiWanCheng where m.fBanID='"+id+"'
and m.fBz='"+fBz+"' and m.fMasterID ='"+fMasterID+"'";//更新数量
System.out.println("第一次更新数据量汇报sql语句是:"+sql1update1);
//输出
//stmt.executeUpdate(sql1update1);
stmt.addBatch(sql1update1);//加入包执行
//更新进度汇报表中的数据状态,当
ID,外键,和临时参数都相等时,并且sum
=100,的时候更新此数据为已完成,来区别数据,用于统计和分析,并且判
断此数据是否在业务中显示
String sql1update2="update pm_project_schedulmain2 m set
m.fState = '"+State+"' where m.fBanID='"+id+"' and m.fWancSum
=100 and m.fBz='"+fBz+"' and m.fMasterID
='"+fMasterID+"'";//更新状态
System.out.println("第二次更新状态汇报的sql语句是:"+sql1update2);
// stmt.executeUpdate(sql1update2);
stmt.addBatch(sql1update2);
//查询改变的数据,通过数据去修改站班和项目的数据
String sql1update3 ="select
m.fxmGxID,m.fPbGXID,m.fJinRiWanCheng,m.fxmwJ from
pm_project_schedulmain2 m where m.fBanID='"+id+"' and
m.fBz='"+fBz+"'and m.fMasterID ='"+fMasterID+"'";
System.out.println("查询到的第三个要更改项目排班中的数据是"+sql1up
date3);
//Table
Table table = DataUtils.queryData(conn, sql1update3, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fxmGxID = info.getString("fxmGxID");//获取ID xid
String fPbGXID = info.getString("fPbGXID");//获取桩号 pid
String fxmwJ = info.getString("fxmwJ");//获取桩号 工序外键
int fJinRiWanCheng =
info.getInteger("fJinRiWanCheng");//获取数量
//
System.out.println("查询到的完成状态是:"+ fJinRiWanCheng);
//更新其他表,更改项目从表工序表的状态,
数量,以及其他信息,最重要
String sqlupOther1 ="update pm_project_project_gongxu m set
m.fSum =m.fSum+'"+ fJinRiWanCheng + "' where
m.fID='"+fxmGxID+"'";//项目
// stmt.executeUpdate(sqlupOther1);
System.out.println("查询到的完成状态是1111:"+ fJinRiWanCheng);
//更改排班表中的工序数据更新吧。
20171127修改项目部版本留,记得加注释
String sqlupOther2 ="update pm_project_persondetail2 m set
m.fToalSum =m.fToalSum+'"+ fJinRiWanCheng + "' where
m.fID='"+fPbGXID + "'";//排班
// stmt.executeUpdate(sqlupOther2);
//更新其他表,更改项目从表工序表的状态,
数量,以及其他信息,最重要状态
String sqlupOther3="update pm_project_project_gongxu m set
m.fState ='"+ State + "' where m.fID='" + fxmGxID + "' and
m.fSum>=100";//项目状态
// stmt.executeUpdate(sqlupOther3);
// 更新其他表,更改排班从表工序表的状态,
数量,以及其他信息,最重要 状态
String sqlupOther4="update pm_project_persondetail2 m set
m.fWorkState ='"+ State+ "' where m.fID='"+ fPbGXID+"'and
m.fToalSum>=100";//排班状态
//批处理
// stmt.executeUpdate(sqlupOther4);
//新加sql.来更新桩号后面所跟随的状态
基础组塔,架线,**********************************************
********
//更新项目桩号 基础已完成 当工序有一条为已完成 100的
时候去更新桩的状态1
String sqlupOther5="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateing+"' where m.fID='"+fxmwJ+"'
AND m.BasicsSubPageState ='"+weikaishi+"'AND m.fID =
n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum>0 and
n.fBasicType='"+s1+"'";//
System.out.println("修改基础分包商的sql进行中是"+sqlupOther5);
//更新项目桩号表中的组他完成状态,当有一条为已完成100
的时候去去更新桩 的状态1
String sqlupOther6="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.TowerSubPageState='"+stateing+"' where
m.fID='"+fxmwJ+"'AND m.TowerSubPageState ='"+weikaishi+"'
AND m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum>0
and n.fBasicType='"+s2+"'";//
//更新项目桩号表中的组塔完成状态,当有一条为已完成100
的时候去去更新桩 的状态1
String sqlupOther7="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.StringingSubPageState='"+stateing+"' where
m.fID='"+fxmwJ+"'AND m.StringingSubPageState
='"+weikaishi+"' AND m.fID = n.fMasterID and
n.fID='"+fxmGxID+"'and n.fSum>0 and n.fBasicType='"+s3+"'";//
//更新项目桩号表的已完成的 基础组塔架线,2
stmt.addBatch(sqlupOther1);
stmt.addBatch(sqlupOther2);
stmt.addBatch(sqlupOther3);
stmt.addBatch(sqlupOther4);
//
stmt.addBatch(sqlupOther5);
stmt.addBatch(sqlupOther6);
stmt.addBatch(sqlupOther7);
stmt.executeBatch();
//查询对应的项目工序是否全部是已完成
基础**********************************************************
************
String sqlselect52 ="select count(n.fState) as sum from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fState='"+jdweiwancheng+"' and
n.fBasicType='"+s1+"'";
System.out.println("查询B表中的未完成的基础工序数量是"+sqlsele
ct52);
//Table
Table tableQ1 = DataUtils.queryData(conn, sqlselect52, null,
null, null, null);
// 遍历
Iterator<Row> iteratorQ1 = tableQ1.getRows().iterator();
while (iteratorQ1.hasNext()) {
Row infoQ1 = iteratorQ1.next();
Object sSum = infoQ1.getValue("sum");
String sc = sSum.toString();
System.out.println("查询到B表中基础的数量是"+sSum);
if(sc.equals("0")){
//如果是全部是未完成即没有未完成的
String sqlupOther51="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and
n.fSum=100 and n.fState='"+stateinged+"' and
n.fBasicType='"+s1+"'";//
String sqlupOther51paiban="update
pm_project_proceduredetail
m,pm_project_persondetail2 n set
m.BasicsSubPageState='"+stateinged+"'where
m.fPtzhuangID='"+fxmwJ+"' AND m.fPtzhuangID =
n.fPtfMasterID and n.fToalSum=100 and
m.fProjectWrokType='"+s1+"'and
n.fWorkState='"+stateinged+"'and
n.fPtBasicType='"+s1+"'";
stmt.addBatch(sqlupOther51paiban);
stmt.addBatch(sqlupOther51);
stmt.executeBatch();
}
};
//查询对应的项目工序是否全部是已完成
组塔**********************************************************
************
String sqlselect62 ="select count(n.fState) as sum from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fState='"+jdweiwancheng+"' and
n.fBasicType='"+s2+"'";
System.out.println("查询B表中的组塔未完成的工序数量是"+sqlsele
ct62);
//Table
Table tableQ2 = DataUtils.queryData(conn, sqlselect62, null,
null, null, null);
// 遍历
Iterator<Row> iteratorQ2 = tableQ2.getRows().iterator();
while (iteratorQ2.hasNext()) {
Row infoQ2 = iteratorQ2.next();
Object sSum = infoQ2.getValue("sum");
String sc = sSum.toString();
System.out.println("查询到B表中组塔的数量是"+sSum);
if(sc.equals("0")){
//如果是全部是未完成即没有未完成的
String sqlupOther61="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and
n.fSum=100 and n.fState='"+stateinged+"' and
n.fBasicType='"+s2+"'";//
String sqlupOther61paiban="update
pm_project_proceduredetail
m,pm_project_persondetail2 n set
m.BasicsSubPageState='"+stateinged+"'where
m.fPtzhuangID='"+fxmwJ+"' AND m.fPtzhuangID =
n.fPtfMasterID and n.fToalSum=100 and
m.fProjectWrokType='"+s2+"'and
n.fWorkState='"+stateinged+"'and
n.fPtBasicType='"+s2+"'";
stmt.addBatch(sqlupOther61paiban);
stmt.addBatch(sqlupOther61);
stmt.executeBatch();
}
};
//查询对应的项目工序是否全部是已完成
架线**********************************************************
************
String sqlselect72 ="select count(n.fState) as sum from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fState='"+jdweiwancheng+"' and
n.fBasicType='"+s3+"'";
System.out.println("查询B表中的架线未完成的工序数量是"+sqlsele
ct72);
//Table
Table tableQ3 = DataUtils.queryData(conn, sqlselect72, null,
null, null, null);
// 遍历
Iterator<Row> iteratorQ3 = tableQ3.getRows().iterator();
while (iteratorQ3.hasNext()) {
Row infoQ2 = iteratorQ3.next();
Object sSum = infoQ2.getValue("sum");
String sc = sSum.toString();
System.out.println("查询到B表中架线的数量是"+sSum);
if(sc.equals("0")){
//如果是全部是未完成即没有未完成的
String sqlupOther71="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and
n.fSum=100 and n.fState='"+stateinged+"' and
n.fBasicType='"+s3+"'";//
String sqlupOther71paiban="update
pm_project_proceduredetail
m,pm_project_persondetail2 n set
m.BasicsSubPageState='"+stateinged+"'where
m.fPtzhuangID='"+fxmwJ+"' AND m.fPtzhuangID =
n.fPtfMasterID and n.fToalSum=100 and
m.fProjectWrokType='"+s3+"'and
n.fWorkState='"+stateinged+"'and
n.fPtBasicType='"+s3+"'";
stmt.addBatch(sqlupOther71paiban);
stmt.addBatch(sqlupOther71);
stmt.executeBatch();
}
};
/*// String sqlupOther51="update
pm_project_project_postinformationtab m set
m.BasicsSubPageState='"+stateinged+"' from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum=100
and n.fState='"+stateinged+"' and n.fBasicType='"+s1+"'";//
String sqlupOther51="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.BasicsSubPageState='"+stateinged+"' having
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and n.fSum=100
and count(n.fState='"+jdweiwancheng+"')= 0 and
n.fBasicType='"+s1+"'";//
System.out.println("修改基础分包商的sql完成是"+sqlupOther51);
//更新项目桩号表中的组他完成状态,当有一条为已完成100
的时候去去更新桩 的状态2
// String sqlupOther61="update
pm_project_project_postinformationtab m set
m.TowerSubPageState='"+stateinged+"' from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum=100
and n.fState='"+stateinged+"'";//
String sqlupOther61="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.TowerSubPageState='"+stateinged+"' where m.fID='"+fxmwJ+"'
AND m.fID = n.fMasterID and n.fSum=100 and
n.fState<>'"+jdweiwancheng+"' and n.fBasicType='"+s2+"'";//
//更新项目桩号表中的组塔完成状态,当有一条为已完成100
的时候去去更新桩 的状态2
// String sqlupOther71="update
pm_project_project_postinformationtab m set
m.StringingSubPageState='"+stateinged+"' from
pm_project_project_postinformationtab
m,pm_project_project_gongxu n where m.fID='"+fxmwJ+"' AND
m.fID = n.fMasterID and n.fID='"+fxmGxID+"'and n.fSum=100
and n.fState='"+stateinged+"'";//
String sqlupOther71="update
pm_project_project_postinformationtab
m,pm_project_project_gongxu n set
m.StringingSubPageState='"+stateinged+"' where
m.fID='"+fxmwJ+"' AND m.fID = n.fMasterID and n.fSum=100
and n.fState<>'"+jdweiwancheng+"' and
n.fBasicType='"+s3+"'";//
*/ //
// stmt.addBatch(sqlupOther51);
// stmt.addBatch(sqlupOther61);
// stmt.addBatch(sqlupOther71);
//
System.out.println("执行成功");
}
//
// String sql1update9="update pm_project_schedulmain2 m set
m.fBz='"+fBzNO+"' where m.fBanID='"+id+"' and m.fMasterID
='"+fMasterID+"'";//更新状态
//
// System.out.println("修改状态 1
改成0"+"修改的外键是:"+fMasterID);
// stmt.addBatch(sql1update9);
// //
// stmt.executeBatch();
conn.close();
return ab;
}
public static JSONObject getGxMes(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 接受参数
List<Object> list1 = new ArrayList<Object>();
JSONObject json = new JSONObject();
String st = "未完成";
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");
Connection conn = context.getConnection("jeecg");// 获取数据库连接
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环查询
String id = o[i].toString();
// 查询
String sql = "select
m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"
+ id + "' and m.fState='" + st + "'";
// 装入table
Table table = DataUtils
.queryData(conn, sql, null, null, null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
List<Map<String, Object>> list = new
ArrayList<Map<String, Object>>();
Row info = iterator.next();
String fBasicName = info.getString("fBasicName");
String fID = info.getString("fID");
String fMasterID = info.getString("fMasterID");
String fBasicType = info.getString("fBasicType");
String fOnlyone = info.getString("fOnlyone");
int fSum = info.getInteger("fSum");
String fState = info.getString("fState");
// 数据装入map
Map<String, Object> map = new HashMap<String, Object>();
map.put("fID", fID);
map.put("fMasterID", fMasterID);
map.put("fBasicName", fBasicName);
map.put("fBasicType", fBasicType);
map.put("fOnlyone", fOnlyone);
map.put("fSum", fSum);
map.put("fState", fState);
list.add(map);
list1.add(list);
}
}
json.put("ID", list1);
return json;
}
public static JSONObject getPianchaYuanyinAction(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
System.out.println("获得到的参数是:" + id);
// 查询
try {
String sql = "select
m.fNameCodeID,m.fName,n.fWrtietime,n.fWrtieName,n.fID,n.fZhuan
gNo,n.fZhuangCode from pm_project_weekreport_detail m
,pm_project_weekreport n where n.fID=m.fMasterID and
n.ffProjectID='"+ id + "'";
System.out.println("第一次查询到的sql是:"+ sql);
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
/* public static JSONObject getNewPaiBanCheckZGmess(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {//排班选择工序
//****************************************************************
***************************
// 接受参数
Connection conn = context.getConnection("jeecg");// 获取数据库连接
String st = "未完成";
Collection<String> list5 = new ArrayList<String>();//新5
装入桩号ID
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");//获取桩号ID
String MainID = params.getString("MainsID");//获取主表ID
String Type = params.getString("Type");//获取类型 基础组塔架线
String ty = "基础";
java.sql.Statement stmt1 = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
java.sql.Statement stmt2 = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
//****************************************************************
***************************
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环桩号插入表
String id = o[i].toString();
// 查询桩号
String sql = "select m.fID,m.fPostName,m.fState,m.fMsterID
from pm_project_project_postinformationtab m where m.fID =
'"+ id + "'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fID = info.getString("fID");//获取ID
String fPostName = info.getString("fPostName");//获取桩号
String fState = info.getString("fState");//获取状态
String fMsterID = info.getString("fMsterID");//获取外键
System.out.println("第一次查询到的桩号是:"+ fPostName);
//如果有,插入排班桩号数据
// java.sql.PreparedStatement pstmt = null;
// pstmt = conn.prepareStatement("insert
into pm_project_proceduredetail
s(s.version,s.fMasterID,s.fPtzhuangID,s.fPtzhuangN,s.fProj
ectWrokType,s.fPtzhuangState,s.fPtzhuangMasterID)values(0,
'"+MainID+"','"+fID+"','"+fPostName+"','"+ty+"','"+fState+
"','"+fMsterID+"')");
String sql1 ="insert into pm_project_proceduredetail
s(s.version,s.fMasterID,s.fPtzhuangID,s.fPtzhuangN,s.fProj
ectWrokType,s.fPtzhuangState,s.fPtzhuangMasterID)values(0,
'"+MainID+"','"+fID+"','"+fPostName+"','"+ty+"','"+fState+
"','"+fMsterID+"')";
stmt1.addBatch(sql1);
// pstmt.execute();//执行
// 数据装入map
list5.add(fID);
}
stmt1.executeBatch();
}
//循环桩号查询工序信息
Iterator<String> it = list5.iterator();
while(it.hasNext()){
String fID = (String)it.next();//获取ID
String sql = "select
m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"+ fID + "' and m.fState='" + st + "'";
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fBasicName = info.getString("fBasicName");
String fID1 = info.getString("fID");
String fMasterID = info.getString("fMasterID");
String fBasicType = info.getString("fBasicType");
String fOnlyone = info.getString("fOnlyone");
int fSum = info.getInteger("fSum");
String fState = info.getString("fState");
System.out.println("第二次查询到的工序是:"+ fBasicName);
//执行插入语句
java.sql.PreparedStatement pstmt1 = null;
// pstmt1 = conn.prepareStatement("insert
into pm_project_proceduredetail
b(b.version,b.fPtfID,b.fPtfMasterID,b.fPtBasicName,b.fPtBa
sicType,b.fPtzhuangState,b.fPtzhuangMasterID,b.fToalSum,b.
fWorkState,b.fMsterID)values(0,'"+fID1+"','"+fMasterID+"',
'"+fBasicName+"','"+fBasicType+"','"+fOnlyone+"','"+fSum+"
','"+fState+"','"+MainID+"')");
String sql2 = "insert into pm_project_proceduredetail
b(b.version,b.fPtfID,b.fPtfMasterID,b.fPtBasicName,b.fPtBa
sicType,b.fPtzhuangState,b.fPtzhuangMasterID,b.fToalSum,b.
fWorkState,b.fMsterID)values(0,'"+fID1+"','"+fMasterID+"',
'"+fBasicName+"','"+fBasicType+"','"+fOnlyone+"','"+fSum+"
','"+fState+"','"+MainID+"')";
stmt2.addBatch(sql2);
// pstmt1.execute();//执行
}
}
// stmt1.executeBatch();
stmt2.executeBatch();
conn.close();
return null;
}*/
/* public static JSONObject getNewPaiBanCheckZGmess(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//排班动作
JSONObject ad = new JSONObject();
JSONArray arr = (JSONArray) params.get("id");//获取桩号ID
String MainID = params.getString("MainsID");//获取主表ID
String Type = params.getString("Type");//获取类型 基础组塔架线
String ty = "测试基础";//临时数据
String State = "未完成";
String fNo = "3333333";
//
Date date = new Date();
DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
java.sql.Date currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
//
Connection conn = context.getConnection("jeecg");// 获取数据库连接
//SQL批量执行
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//
Object[] o = arr.toArray();
//
for (int i = 0; i < o.length; i++) { // 循环桩号插入表
String uuid1 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid1 = uuid1.replace("-", "");
System.out.println("第一次查询到UUID:"+ uuid1);
String id = o[i].toString();
System.out.println("获取到的id是:"+id);
// 查询桩号
20171211,添加功能,查询
基础实际量,组塔实际量,架线实际量,用来统计对比计划量 统计量
*
*
String sql = "select
m.fID,m.fPostName,m.fState,m.fMsterID,m.BasicsSubPageName,m.To
werSubPageName,m.StringingSubPageName,m.fBasicsSubPlanSum,m.fT
owerSubPlanSum,m.fStringingSubPlanSum from
pm_project_project_postinformationtab m where m.fID = '"+
id + "'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fID = info.getString("fID");//获取ID
String fPostName = info.getString("fPostName");//获取桩号
String fState = info.getString("fState");//获取状态
String fMsterID = info.getString("fMsterID");//获取外键
String BasicsSubPageName =
info.getString("BasicsSubPageName");//获取基础分包商
String TowerSubPageName =
info.getString("TowerSubPageName");//获取组塔分包商
String StringingSubPageName =
info.getString("StringingSubPageName");//获取架线分包商
int fBasicsSubPlanSum =
info.getInteger("fBasicsSubPlanSum");//获取基础实际量
int fTowerSubPlanSum =
info.getInteger("fTowerSubPlanSum");//获取组塔实际量
int fStringingSubPlanSum =
info.getInteger("fStringingSubPlanSum");//获取架线实际量
System.out.println("第一次查询到的桩号是:"+ fPostName);
//
//因为UUID本身为32位只是生成时多了“-”,所以将它们去点就可
VALUES
//如果有,插入排班桩号数据,遍历插入排班表中的数据
String sql1="insert into pm_project_proceduredetail
(fNo,fID,fCreateDateTime,fMasterID,fPtzhuangID,fPtzhuangN,
fProjectWrokType,fPtzhuangState,fPtzhuangMasterID,BasicsSu
bPageName,TowerSubPageName,StringingSubPageName,fBasicsSub
PlanSumS,fTowerSubPlanSumS,fStringingSubPlanSumS,fBasicsSu
bPlanSum,fTowerSubPlanSum,fStringingSubPlanSum)" +
" VALUES
('"+fNo+"','"+uuid1+"','"+currentDate+"','"+MainID
+"','"+fID+"','"+fPostName+"','"+Type+"','"+fState
+"','"+fMsterID+"','"+BasicsSubPageName+"','"+Towe
rSubPageName+"','"+StringingSubPageName+"','"+fBas
icsSubPlanSum+"','"+fTowerSubPlanSum+"','"+fString
ingSubPlanSum+"','"+fBasicsSubPlanSum+"','"+fTower
SubPlanSum+"','"+fStringingSubPlanSum+"')" ;
System.out.println("插入排班桩号输出的sql是:"+sql1);
//批处理
stmt.executeUpdate(sql1);
//
System.out.println("执行成功");
//pstmt.executeBatch();
// list5.add(fID);
}
//查询工序
System.out.println("要查询的主键是:"+id);
String sql2 = "select
m.fNo,m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"+ id + "' and m.fState='" + State + "'";
System.out.println("查询的第二个语句是:"+sql2);
//
Table table1 = DataUtils.queryData(conn, sql2, null, null,
null, null);
Iterator<Row> iterator1 = table1.getRows().iterator();
//遍历
while (iterator1.hasNext()) {
//生成主键
String uuid2 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid2 = uuid2.replace("-", "");
//
Row info1 = iterator1.next();
String fBasicName = info1.getString("fBasicName");
String fID1 = info1.getString("fID");
String fNo1 = info1.getString("fNo");
String fMasterID = info1.getString("fMasterID");
String fBasicType = info1.getString("fBasicType");
String fOnlyone = info1.getString("fOnlyone");
int fSum = info1.getInteger("fSum");
String fState = info1.getString("fState");
//if判断基础组塔架线
if(fBasicType.equals(Type)){
//执行插入语句pm_project_persondetail2
System.out.println("第二次查询到的工序是过滤后的工序:"
+fBasicName);//
String sqlinsert1 = "insert into
pm_project_persondetail2
(fNo,fID,fStartTime,fPtfID,fPtfMasterID,fPtBasicName,f
PtBasicType,fPtfOnlyone,fToalSum,fWorkState,fMsterID)
values
('"+fNo1+"','"+uuid2+"','"+currentDate+"','"+fID1+"','
"+fMasterID+"','"+fBasicName+"','"+fBasicType+"','"+fO
nlyone+"','"+fSum+"','"+fState+"','"+MainID+"')";
//批处理
stmt.executeUpdate(sqlinsert1);
System.out.println("出入工序成功"+fBasicName);
}
}
}
//
//批处理执行
conn.close();
return ad;
}*/
public static JSONObject getNewPaiBanCheckZGmess(JSONObject
params, ActionContext context)throws SQLException, NamingException,
java.sql.SQLException {
//排班动作
JSONObject ad = new JSONObject();
JSONArray arr = (JSONArray) params.get("id");//获取桩号ID
String MainID = params.getString("MainsID");//获取主表ID
String Type = params.getString("Type");//获取类型 基础组塔架线
String ty = "测试基础";//临时数据
String State = "未完成";
String fNo = "333";
//时间转换
java.sql.Date currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
//
Connection conn = context.getConnection("jeecg");// 获取数据库连接
//SQL批量执行
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//
Object[] o = arr.toArray();
//
for (int i = 0; i < o.length; i++) { // 循环桩号插入表
String uuid1 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid1 = uuid1.replace("-", "");
System.out.println("第一次查询到UUID:"+ uuid1);
String id = o[i].toString();
System.out.println("获取到的id是:"+id);
//20171211,添加功能,查询
基础实际量,组塔实际量,架线实际量,用来统计对比计划量
统计量查询桩号
String sql = "select
m.fID,m.fPostName,m.fState,m.fMsterID,m.BasicsSubPageName,m.To
werSubPageName,m.StringingSubPageName,m.fBasicsSubPlanSum,m.fT
owerSubPlanSum,m.fStringingSubPlanSum from
pm_project_project_postinformationtab m where m.fID = '"+
id + "'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
Row info = iterator.next();
String fID = info.getString("fID");//获取ID
String fPostName = info.getString("fPostName");//获取桩号
String fState = info.getString("fState");//获取状态
String fMsterID = info.getString("fMsterID");//获取外键
String BasicsSubPageName =
info.getString("BasicsSubPageName");//获取基础分包商
String TowerSubPageName =
info.getString("TowerSubPageName");//获取组塔分包商
String StringingSubPageName =
info.getString("StringingSubPageName");//获取架线分包商
int fBasicsSubPlanSum =
info.getInteger("fBasicsSubPlanSum");//获取基础实际量
int fTowerSubPlanSum =
info.getInteger("fTowerSubPlanSum");//获取组塔实际量
int fStringingSubPlanSum =
info.getInteger("fStringingSubPlanSum");//获取架线实际量
System.out.println("第一次查询到的桩号是:"+ fPostName);
//因为UUID本身为32位只是生成时多了“-”,所以将它们去点就可
VALUES
//如果有,插入排班桩号数据,遍历插入排班表中的数据
String sql1="insert into pm_project_proceduredetail
(fNo,fID,fCreateDateTime,fMasterID,fPtzhuangID,fPtzhuangN,
fProjectWrokType,fPtzhuangState,fPtzhuangMasterID,BasicsSu
bPageName,TowerSubPageName,StringingSubPageName,fBasicsSub
PlanSumS,fTowerSubPlanSumS,fStringingSubPlanSumS,fBasicsSu
bPlanSum,fTowerSubPlanSum,fStringingSubPlanSum)" +"
VALUES
('"+fNo+"','"+uuid1+"','"+currentDate+"','"+MainID+"','"+f
ID+"','"+fPostName+"','"+Type+"','"+fState+"','"+fMsterID+
"','"+BasicsSubPageName+"','"+TowerSubPageName+"','"+Strin
gingSubPageName+"','"+fBasicsSubPlanSum+"','"+fTowerSubPla
nSum+"','"+fStringingSubPlanSum+"','"+fBasicsSubPlanSum+"'
,'"+fTowerSubPlanSum+"','"+fStringingSubPlanSum+"')" ;
System.out.println("插入排班桩号输出的sql是:"+sql1);
//批处理
stmt.executeUpdate(sql1);
System.out.println("执行成功");
//接着查询工序********************************************
************************************
System.out.println("要查询的主键是:"+id);
String sql2 = "select
m.fNo,m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from
pm_project_project_gongxu m where m.fMasterID = '"+ id
+ "' and m.fState='" + State + "'";
System.out.println("查询的第二个语句是:"+sql2);
Table table1 = DataUtils.queryData(conn, sql2, null,
null, null, null);
Iterator<Row> iterator1 = table1.getRows().iterator();
//遍历
while (iterator1.hasNext()) {
//生成主键
String uuid2 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid2 = uuid2.replace("-", "");
//
Row info1 = iterator1.next();
String fBasicName = info1.getString("fBasicName");
String fID1 = info1.getString("fID");
String fNo1 = info1.getString("fNo");
String fMasterID = info1.getString("fMasterID");
String fBasicType = info1.getString("fBasicType");
String fOnlyone = info1.getString("fOnlyone");
int fSum = info1.getInteger("fSum");
String fState1 = info1.getString("fState");
//if判断基础组塔架线
if(fBasicType.equals(Type)){
//执行插入语句pm_project_persondetail2
System.out.println("第二次查询到的工序是过滤后的工
序:"+fBasicName);//
String sqlinsert1 = "insert into
pm_project_persondetail2
(fPaibanIDTTT,fNo,fID,fStartTime,fPtfID,fPtfMaster
ID,fPtBasicName,fPtBasicType,fPtfOnlyone,fToalSum,
fWorkState,fMsterID) values
('"+uuid1+"','"+fNo1+"','"+uuid2+"','"+currentDate
+"','"+fID1+"','"+fMasterID+"','"+fBasicName+"','"
+fBasicType+"','"+fOnlyone+"','"+fSum+"','"+fState
1+"','"+MainID+"')";
//批处理
stmt.executeUpdate(sqlinsert1);
System.out.println("出入工序成功"+fBasicName);
}
}
}
}
//
//批处理执行
conn.close();
return ad;
}
public static JSONObject getJiaxianGxPBmess(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 接受参数
List<Object> list1 = new ArrayList<Object>();
JSONObject json = new JSONObject();
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");
Connection conn = context.getConnection("jeecg");// 获取数据库连接
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环查询
String id = o[i].toString();
// 查询
String sql = "select
m.fID,m.fMasterID,m.fBasicName,m.fBasicType,
m.fOnlyone,m.fSum,m.fState from pm_project_project_gongxu m
where m.fMasterID = '"
+ id + "'";
// 装入table
Table table = DataUtils
.queryData(conn, sql, null, null, null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
List<Map<String, Object>> list = new
ArrayList<Map<String, Object>>();
Row info = iterator.next();
String fBasicName = info.getString("fBasicName");
String fID = info.getString("fID");
String fMasterID = info.getString("fMasterID");
String fBasicType = info.getString("fBasicType");
String fOnlyone = info.getString("fOnlyone");
int fSum = info.getInteger("fSum");
String fState = info.getString("fState");
// 数据装入map
Map<String, Object> map = new HashMap<String, Object>();
map.put("fID", fID);
map.put("fMasterID", fMasterID);
map.put("fBasicName", fBasicName);
map.put("fBasicType", fBasicType);
map.put("fOnlyone", fOnlyone);
map.put("fSum", fSum);
map.put("fState", fState);
list.add(map);
list1.add(list);
}
}
json.put("ID", list1);
return json;
}
public static JSONObject getJiaxian(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询项目下通过节点
Connection conn = context.getConnection("jeecg");
// 查询
try {
String sql = "select m.fPostName, m.fID from
pm_project_project_postinformationtab m where m.fPointCut
='是' ";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getGx1(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
String st = "未完成";
// 查询
try {
String sql = "select DISTINCT n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMaster
ID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPt
fOnlyone from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangID=
n.fPtfMasterID and n.fTeamID ='"+ id + "' and
n.fWorkState='"+st+"'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getGx3(JSONObject params, ActionContext
context)throws SQLException, NamingException, java.sql.SQLException {
// 查询对应班组的工序
// 接受参数
List<Object> list1 = new ArrayList<Object>();
JSONObject json = new JSONObject();
String st = "未完成";
// 接收前台的数组
JSONArray arr = (JSONArray) params.get("id");//获取数组ID
String PersonID = params.getString("PersonID");//获取人员ID
Connection conn = context.getConnection("jeecg");// 获取数据库连接
Object[] o = arr.toArray();
for (int i = 0; i < o.length; i++) { // 循环查询
String id = o[i].toString();
System.out.println("获取到的ID 是:"+id);
// 查询
String sql = "select DISTINCT n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMaster
ID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPt
fOnlyone from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangID=
n.fPtfMasterID and n.fTeamID ='"+PersonID+ "'and
m.fMasterID= n.fMsterID='"+id+"'and n.fWorkState='"+st+"'";
// 装入table
Table table = DataUtils.queryData(conn, sql, null, null,
null, null);
// 遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
List<Map<String, Object>> list = new
ArrayList<Map<String, Object>>();
Row info = iterator.next();
String congbiaoID = info.getString("congbiaoID");//1
String fPtfID = info.getString("fPtfID");//2
String fPtBasicName = info.getString("fPtBasicName");//3
String fPtBasicType = info.getString("fPtBasicType");//4
String fPtfMasterID = info.getString("fPtfMasterID");//5
String fMsterID = info.getString("fMsterID");//6
String fTeamName = info.getString("fTeamName");//7
String fTeamID = info.getString("fTeamID");//8
String fWorkState = info.getString("fWorkState");//9
int fToalSum = info.getInteger("fToalSum");//10
String fPtfOnlyone = info.getString("fPtfOnlyone");//11
// 数据装入map
Map<String, Object> map = new HashMap<String, Object>();
map.put("congbiaoID",congbiaoID);
map.put("fPtfID",fPtfID);
map.put("fPtBasicName",fPtBasicName);
map.put("fPtBasicType",fPtBasicType);
map.put("fPtfMasterID",fPtfMasterID);
map.put("fMsterID",fMsterID);
map.put("fTeamName",fTeamName);
map.put("fTeamID",fTeamID);
map.put("fWorkState",fWorkState);
map.put("fToalSum", fToalSum);
map.put("fPtfOnlyone", fPtfOnlyone);
//list装箱
list.add(map);
list1.add(list);
}
}
json.put("ID", list1);
return json;
}
public static JSONObject getJiaXianQuDuanGx(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMaster
ID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPt
fOnlyone from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangMasterID=
n.fPtfID and n.fTeamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getJDHBzhuang(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");// 获取人员ID
String projectID = params.getString("projectID");// 获取项目ID
System.out.println("获取到项目ID:" + projectID);
String Time = params.getString("time");// 获取当前时间
String stat = "未完成";
System.out.println("输出的" + Time);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
try {
String sql = "select DISTINCT
y.fID,y.fMasterID,y.fPtzhuangID,y.fPtzhuangN,y.fProjectWrokTyp
e,y.fPtzhuangState,y.fPtzhuangMasterID from
pm_project_proceduredetail y,pm_project_persondetail2 z
where y.fMasterID=z.fMsterID and y.fPtzhuangID=
z.fPtfMasterID and z.fTeamID = '"+ id+ "' and z.fTeamID is
not null and y.fPtzhuangMasterID='"+projectID+ "' and
z.fWorkState ='"+stat+"'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getJingDuNewAction1(JSONObject
params,ActionContext context) throws SQLException,
NamingException,java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
JSONObject return1 = new JSONObject();
//获取参数
String personName = params.getString("personName");// 人员名称
String id = params.getString("id");// 获取人员ID
String MainID = params.getString("MainID");// 获取主表ID
String projectID = params.getString("projectID");// 获取项目ID
String Time = params.getString("time");// 获取当前时间
String fNo = "进度";
String st = "未完成";
//转换java转化sql时间
java.sql.Date currentDate = new
java.sql.Date(System.currentTimeMillis());//获取sql java呼唤时间
//SQL批量执行
java.sql.Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
ONCUR_UPDATABLE);
//查询排班中的所属桩号,查询张三班组在排班中所有的桩号和桩的类别
String sql = "select DISTINCT
y.fBasicsSubPlanSum,y.fTowerSubPlanSum,y.fStringingSubPlanSum,y.fI
D,y.fMasterID,y.fPtzhuangID,y.fPtzhuangN,y.fProjectWrokType,y.fPtz
huangState,y.fPtzhuangMasterID from
pm_project_proceduredetail y,pm_project_persondetail2 z where
y.fMasterID=z.fMsterID and y.fPtzhuangID= z.fPtfMasterID and
z.fTeamID LIKE '%"+ id+ "%' " +
" and z.fTeamID is not null and
y.fPtzhuangMasterID='"+projectID+ "' and z.fWorkState
='"+st+"'and y.fID = z.fPaibanIDTTT";
//
System.out.println("查询桩号是sql"+sql);
//
Table table = DataUtils.queryData(conn, sql, null, null, null,
null);
//遍历
Iterator<Row> iterator = table.getRows().iterator();
while (iterator.hasNext()) {
//
String uuid1 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid1 = uuid1.replace("-", ""); //生成主键
System.out.println("获取到的UUID是"+uuid1);
//
Row info = iterator.next();//20171212修改计划量和实际量
3方同步
int fBasicsSubPlanSum =
info.getInteger("fBasicsSubPlanSum");//基础实际量
int fTowerSubPlanSum =
info.getInteger("fTowerSubPlanSum");//组塔实际量
int fStringingSubPlanSum =
info.getInteger("fStringingSubPlanSum");//架线实际量
String fID = info.getString("fID");//排版桩ID
String fPtzhuangID =
info.getString("fPtzhuangID");//项目桩ID data1=data2
String fPtzhuangN = info.getString("fPtzhuangN");//桩号名称
String fType = info.getString("fProjectWrokType");//桩号类别
//插入进度桩号表
String sql1="insert into
pm_project_schedulmain1(fNo,fID,fTime,fBanCode,fMasterID,fZhua
ngID,fTongBuID,fZhuangName,fType,fBasicsSubPlanSum,fTowerSubPl
anSum,fStringingSubPlanSum) VALUES
('"+fNo+"','"+uuid1+"','"+currentDate+"','"+id+"','"+MainID+"'
,'"+fID+"','"+fPtzhuangID+"','"+fPtzhuangN+"','"+fType+"','"+f
BasicsSubPlanSum+"','"+fTowerSubPlanSum+"','"+fStringingSubPla
nSum+"')" ;
System.out.println("输出的sql是:"+sql1);
//批处理
stmt.executeUpdate(sql1);
//
System.out.println("桩号执行成功");
}
//通过人员ID 查询工序
String sql2 = "select DISTINCT n.fNo, n.fID as
congbiaoID,n.fPtfID,n.fPtBasicName,n.fPtBasicType,n.fPtfMasterID,
n.fMsterID,n.fTeamName,n.fTeamID,n.fWorkState,n.fToalSum,n.fPtfOnl
yone from pm_project_proceduredetail m ,pm_project_persondetail2
n where m.fPtzhuangID= n.fPtfMasterID and n.fTeamID LIKE '%"+ id
+"%' and n.fWorkState='"+st+"'";
//
Table table1 = DataUtils.queryData(conn,sql2, null, null, null,
null);
Iterator<Row> iterator1 = table1.getRows().iterator();
//遍历插入
while (iterator1.hasNext()) {
Row info1 = iterator1.next();
//
String uuid2 = UUID.randomUUID().toString();
//获取UUID并转化为String对象
uuid2 = uuid2.replace("-", ""); //生成主键
System.out.println("获取到的UUID是"+uuid2);
//
String congbiaoID = info1.getString("congbiaoID");//1
String fPtfID = info1.getString("fPtfID");//2
String fPtBasicName = info1.getString("fPtBasicName");//3
String fPtBasicType = info1.getString("fPtBasicType");//4
String fPtfMasterID = info1.getString("fPtfMasterID");//5
String fMsterID = info1.getString("fMsterID");//6
String fTeamName = info1.getString("fTeamName");//7
String fTeamID = info1.getString("fTeamID");//8
String fWorkState = info1.getString("fWorkState");//9
int fToalSum = info1.getInteger("fToalSum");//10
String fPtfOnlyone = info1.getString("fPtfOnlyone");//11
String fNo1 = info1.getString("fNo");//11
//插入数据 工序表
String sqlinsert2="insert into pm_project_schedulmain2
(fNo,fID,fWritime,fBanID,fMasterID,fxmGxID,fxmwJ,fPbGXID,fPbwj
,fGongxu,fBanName,fState,fWancSum,fType,fOnlyOne,fJinRiWanChen
g)" +" VALUES
('"+fNo1+"','"+uuid2+"','"+currentDate+"','"+id+"','"+MainID+"
','"+fPtfID+"','"+fPtfMasterID+"','"+congbiaoID+"','"+fMsterID
+"','"+fPtBasicName+"','"+personName+"','"+fWorkState+"','"+fT
oalSum+"','"+fPtBasicType+"','"+fPtfOnlyone+"',0)" ;
System.out.println("输出的sql是:"+sqlinsert2);
//批处理
stmt.executeUpdate(sqlinsert2);
//
System.out.println("插入工序执行成功");
}
return return1;
}
public static JSONObject getJiaXianQuDuan(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select DISTINCT m.fPtzhuangID, m.fPtzhuangN,
m.fID,m.fProjectWrokType,m.fPtzhuangMasterID from
pm_project_proceduredetail m ,pm_project_persondetail2 n
where m.fPtzhuangMasterID= n.fPtfID and n.fTeamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getGx2(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select m.fID, m.fPtzhuangN,m.fPtzhuangID,
m.fProjectWrokType,m.fPtzhuangMasterID,n.fID as
congID,n.fPtfID,fPtBasicType,n.fPtBasicName,n.fPtBasicType,n.f
PtfOnlyone, n.fPtfMasterID,n.fTeamName,n.fTeamID,
n.fToalSum from pm_project_proceduredetail m
,pm_project_persondetail2 n where m.fPtzhuangMasterID=
n.fPtfID and n.fTeamID = '"
+ id + "'";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject getXuJianBanTeamNameselect(JSONObject params,
ActionContext context) throws SQLException, NamingException,
java.sql.SQLException {
// 查询对应班组的工序
Connection conn = context.getConnection("jeecg");
String id = params.getString("id");
// 查询
try {
String sql = "select m.fPostName,m.fPostWriteName,
m.fPostWriteID from
pm_project_project_informationtable_postsetb m where
m.fMasterID = '"
+ id + "' ";
//
Table a = DataUtils.queryData(conn, sql, null, null, null,
null);
return Transform.tableToJson(a);
} finally {
conn.close();
}
}
public static JSONObject Getjiaxian(JSONObject params, ActionContext
context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询 对应项目下的节点形成的区段返回前台
List<Object> list1 = new ArrayList<Object>();// 声明list1
JSONObject json = new JSONObject();// 声明json对象
Connection conn = context.getConnection("jeecg");// 声明连接池
String id = params.getString("id");// 接收参数
String srt = "";// 申明srt来临时储存桩号
String ids = "";// 声明ids 来临时储存ID
String sumjia = "";// 声明sum来储存桩之间的档距
// Float srtsum = '
// 查询
// where m.fMsterID='"+id+"' 备用项目ID
String sql = " select m.fPointCut,m.fPostName,m.fID,m.fSpanSum
from pm_project_project_postinformationtab m where m.fMsterID='"
+ id + "'";
// Table装在值
Table a = DataUtils.queryData(conn, sql, null, null, null, null);
// 把查询的数据循环遍历
Iterator<Row> iterator = a.getRows().iterator();
// 遍历
while (iterator.hasNext()) {
List<Map<String, Object>> list = new ArrayList<Map<String,
Object>>();// 声明list
Map<String, Object> map = new HashMap<String, Object>();//
声明map
Row info = iterator.next();// 迭代下一行
String fPointCut = info.getString("fPointCut");// 获取节点
String fPostName = info.getString("fPostName");// 获取桩号名称
String fID = info.getString("fID");// 获取主键
Float fSpanSum = info.getFloat("fSpanSum");// 获取档距
// 判断 如果当前遍历的节点是否为空
if ("".equals(fPointCut) || fPointCut == null) {
// 判断节点是否为空,如果为空, 把空的桩号拼接起来用来使用
srt += fPostName + ",";// 拼接桩号
ids += fID + ",";// 拼接ID
// srtsum+=fSpanSum;//拼接档距
System.out.println("桩号的临时数组是:" + srt);
System.out.println("主键的临时数组是:" + ids);
} else {// 如果节点不为空,那就把这个节点存为当前节点
,然后开始节点是临时list的第一个值
String[] linecut = srt.split(",");// 切割桩号
String first = linecut[0];// 获取list中的第一个桩号
System.out.println("切割的数据第一个是:" + first);
String assemble = first + "---" + fPostName;// 拼接
String ids1 = ids;// ID
// Float dangju =srtsum;//拼接
System.out.println("拼接后的节点是:" + assemble);
map.put("cut", assemble);// map添加区段
map.put("ids", ids1);// map添加区段中的桩ID
// srt qingkong
// 归零,然后把临时桩list。和idsList归零
srt = fPostName + ",";// 桩listname清除
ids = fID + ",";// 桩ID清除
list.add(map);// 添加map
list1.add(list);// 添加list
// srtsum=null;
}
}
json.put("ID", list1);
return json;
}
public static JSONObject Getjiaxian1(JSONObject params,
ActionContext context)
throws SQLException, NamingException, java.sql.SQLException {
// 查询 对应项目下的节点形成的区段返回前台
List<Object> list1 = new ArrayList<Object>();// 声明list1
JSONObject json = new JSONObject();// 声明json对象
Connection conn = context.getConnection("jeecg");// 声明连接池
String id = params.getString("id");// 接收参数
String srt = "";// 申明srt来临时储存桩号
String ids = "";// 声明ids 来临时储存ID
// int sumjia = 0;// 声明sum来储存桩之间的档距
float sumjia =0f;
// DecimalFormat df = new DecimalFormat(".00");
// System.out.println(df.format(d));
// Float srtsum = '
// 查询
// where m.fMsterID='"+id+"' 备用项目ID
String sql = " select m.fPointCut,m.fPostName,m.fID,m.fSpanSum
from pm_project_project_postinformationtab m where m.fMsterID='"
+ id + "'";
// Table装在值
Table a = DataUtils.queryData(conn, sql, null, null, null, null);
// 把查询的数据循环遍历
Iterator<Row> iterator = a.getRows().iterator();
// 遍历
while (iterator.hasNext()) {
List<Map<String, Object>> list = new ArrayList<Map<String,
Object>>();// 声明list
Map<String, Object> map = new HashMap<String, Object>();//
声明map
Row info = iterator.next();// 迭代下一行
String fPointCut = info.getString("fPointCut");// 获取节点
String fPostName = info.getString("fPostName");// 获取桩号名称
String fID = info.getString("fID");// 获取主键
float fSpanSum = info.getFloat("fSpanSum");// 获取档距1111111
// 判断 如果当前遍历的节点是否为空
if ("".equals(fPointCut) || fPointCut == null) {
// 判断节点是否为空,如果为空, 把空的桩号拼接起来用来使用
srt += fPostName + ",";// 拼接桩号
ids += fID + ",";// 拼接ID
// float quc= df.format(fSpanSum);
sumjia+=fSpanSum;//拼接区段长度
// srtsum+=fSpanSum;//拼接档距
System.out.println("桩号的临时数组是:" + srt);
System.out.println("主键的临时数组是:" + ids);
System.out.println("区段的临时总和是:" + sumjia);
} else {// 如果节点不为空,那就把这个节点存为当前节点
,然后开始节点是临时list的第一个值
String[] linecut = srt.split(",");// 切割桩号
String first = linecut[0];// 获取list中的第一个桩号
System.out.println("切割的数据第一个是:" + first);
String assemble = first + "---" + fPostName;// 拼接
String ids1 = ids;// ID
// Float dangju =srtsum;//拼接
System.out.println("拼接后的节点是:" + assemble);
map.put("cut", assemble);// map添加区段
map.put("ids", ids1);// map添加区段中的桩ID
map.put("sum", sumjia);// map添加区段中的桩ID
// srt qingkong
// 归零,然后把临时桩list。和idsList归零
srt = fPostName + ",";// 桩listname清除
ids = fID + ",";// 桩ID清除
sumjia=0f;//区段清理0
sumjia+=fSpanSum;//拼接区段长度
list.add(map);// 添加map
list1.add(list);// 添加list
// srtsum=null;
}
}
json.put("ID", list1);
return json;
}
}
pm_project_statreport
SELECT * FROM pm_project_project_informationtable WHERE
((pm_project_project_informationtable.fID LIKE
'%3b504952-2118-450b-a6fe-fcb622d64435,C7DDE5295740000122C7359F30C06450,C7
DDECA107E00001E4531EDD14D01679' ) )
SELECT * FROM pm_project_project_informationtable WHERE
((pm_project_project_informationtable.fID IN
'3b504952-2118-450b-a6fe-fcb622d64435,C7DDE5295740000122C7359F30C06450,C7D
DECA107E00001E4531EDD14D01679' ) )
arr_pkfPostWriteID
sql11111111111111111111111111111111111111111111111111111111111111111111111
11111111111111111111111111111111111111111111111111111111111111111111111
http://localhost:8080/x5/UI2/v_/chat/wex5/index.w#!main
// 架线
sql 分部语句
select * from pm_project_proceduredetail m where
DELETE FROM Person WHERE LastName = 'Wilson'
select * from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
DELETE from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
C7C97356D7B000015375FB781F501237
select * from pm_project_persondetail2 m where
m.fPtfMasterID='C7C97356D7B000015375FB781F501237'
DELETE from pm_project_persondetail2 where
fPtfMasterID='C7C97356D7B000015375FB781F501237'
DELETE from pm_project_proceduredetail where
fProjectWrokType='架线'
?、
120.27.11.218:8443
http://120.27.11.218:8095/x5/UI2/v_/chat/wex5/index.w#!main
//基础 40
//排班
进度、
pm_project_project_postinformationtab
pm_project_project_postinformationtab 桩号表
工序表 pm_project_project_gongxu
select *from pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
where n.
//
select m.fBasicName from pm_project_project_postinformationtab
n ,
pm_project_project_gongxu m
where n.fID= m.fMasterID
and n.fPostName=' N040 ' and m.fBasicType='基础'
//
update pm_project_project_postinformationtab
n,pm_project_project_gongxu m set
m.A ,set m.et, where n.fID= m.fMasterID
and n.fPostName=' N040 ' and m.fBasicType='基础'
//项目
//排班
pm_project_proceduredetail 桩号表
pm_project_persondetail2 工序表
update pm_project_project_postinformationtab n, m
set m.fSum=0, m.fState='未完成',n.BasicsSubPageState='进行中'
where n.fID= m.fMasterID
and n.fPostName=' N040 '
and m.fBasicType='基础'
pm_project_proceduredetail
select * from pm_project_persondetail2 m where
m.fPtBasicType='基础' and
m.fPtfMasterID ='
C7C690A041D0000124507400CD003690 '
//更新项目数据
select * from pm_project_project_postinformationtab n ,
pm_project_project_gongxu
m
where n.fID = m.fMasterID
and n.fPostName<' N040 '
where n.fID = m.fMasterID
and n.fPostName<' N030 '
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='未完成',m.fSum=0,m.fState='未完成'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='未完成',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName<' N030 '
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<' N030 ' and
//更新项目基础的数据整体完成的情况
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N044 '
and n.fPostName>=' N036 '
and m.fBasicType='基础'
//针对项目中桩号工序单个完成的情况
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName=' N030 '
and m.fBasicType='基础'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N164 '
and n.fPostName>=' N163 '
and m.fBasicType='基础'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N178 '
and m.fBasicType='基础'
基础
update pm_project_project_gongxu set
//针对单一工序没有完成的桩号更新
select * from pm_project_project_gongxu m where m.fMasterID
='
C7C690A0420000013D3A1A7419E83ED0 ' and m.fBasicName='前期准备' and
m.fBasicType='基础'
updat
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N178 '
and m.fBasicType='基础'
m.fBasicName='前期准备' and m.fBasicType='基础'
//前期准备
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='前期准备'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='基础开挖'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='基础浇筑'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='基坑回填'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='基础'
and m.fBasicName='接埋地线'
前期准备'
基础开挖
基础浇筑
基坑回填
接埋地线
//下面是铁塔组立的代码 20171220 1800
b. 这是 大小范围的代码 全部完成
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N164 '
and n.fPostName>=' N163 '
and m.fBasicType='基础'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N001 '
and n.fPostName>=' N015 '
and m.fBasicType='组塔'
//铁塔单一工序
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.TowerSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N045 '
and m.fBasicType='组塔'
and m.fBasicName='前期准备'
塔材运输
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.TowerSubPageState='进行中',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N036 '
and m.fBasicType='组塔'
and m.fBasicName='塔材运输'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N188 '
and n.fPostName>=' N188 '
and m.fBasicType='组塔'
C7C690A04690000185E6AC01C1101587
DELETE FROM Person WHERE LastName = 'Wilson'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N001 '
and n.fPostName>=' N015 '
and m.fBasicType='组塔'
// 20171221 架线弯沉工序
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N028 --- N029 '
and m.fBasicType='架线'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N028 --- N029 '
and m.fBasicType='架线'
//查询架线
select m.fBasicType from pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
where n.fPostName=' N028 --- N029 '
and m.fBasicType='架线'
and n.fID = m.fMasterID
//
//排班
pm_project_proceduredetail pm_project_persondetail2
select * from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
pm_project_project_gongxu
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.StringingSubPageState='未开始',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName=' N120 --- N123 '
and m.fBasicType='架线'
//20171226
//跟新完成状态
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A009'
and n.fPostName>='A007'
and m.fBasicType='基础'
//跟新不完成状态
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName<='A009'
and n.fPostName>='A007'
and m.fBasicType='基础'
//跟新一半数据
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A004'
and n.fPostName>='A004'
and m.fBasicType='基础'
and m.fBasicName<>'接埋地线'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A004'
and n.fPostName>='A004'
and m.fBasicType='基础'
and m.fBasicName<>'接埋地线'
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.BasicsSubPageState='未开始',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<='A047'
and n.fPostName>='A047'
and m.fBasicType='基础'
and m.fBasicName='前期准备'
or and m.fBasicName='基础开挖'//
//排班桩号表 pm_project_proceduredetail // 排班工序表
pm_project_persondetail2
// sql桩号表
select * from pm_project_proceduredetail m where m.fPtzhuangN=' N017'
select * from pm_project_proceduredetail m where m.fPtzhuangN='
N017 'and m.fCreateDateTime>='2017-12-21'
c95effa915f245dfb5a369e585bb5b8b
//
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='c95effa915f245dfb5a369e585bb5b8b'
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='c95effa915f245dfb5a369e585bb5b8b'
d82f8ef4b8b343038a74c2516c3235c9 ee04fe37aed14ebd911aa127f8d2aec6
DELETE from pm_project_proceduredetail m where
m.fProjectWrokType='架线'
DELETE from pm_project_proceduredetail ,pm_project_persondetail2
where pm_project_proceduredetail.fID
=pm_project_persondetail2.fPaibanIDTTT and
pm_project_proceduredetail.fPtzhuangN=' N034 '
ee04fe37aed14ebd911aa127f8d2aec6
17 1556df1e382b44a984c95b958d8a05ec
d82f8ef4b8b343038a74c2516c3235c9
//17组塔
c95effa915f245dfb5a369e585bb5b8b
//19组塔 f3d946ef6b8e464194d538b2f4d413d4
//
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='f3d946ef6b8e464194d538b2f4d413d4'
//68组塔 fbf0ded5000b4bc688292cc248babf70
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='fbf0ded5000b4bc688292cc248babf70'
//49组塔 4ba2ea4e59274100a641721191c8832a
//99组塔 bb30433831334056bee1f80f3ec5b031
//157组塔 9d27da64fcaf4375a27d7c42994c6d57
C7C690A045A0000150F3A20015501C50
select * from pm_project_persondetail2 m where
m.fPtfMasterID=' C7C690A045A0000150F3A20015501C50
' and m.fPaibanIDTTT<>'9d27da64fcaf4375a27d7c42994c6d57'
//163 组塔 ef0841ffee9e4ce593a7f87b49e63b10
N015 --- N028
//架线 9c04df56cf9c4eb2a6170b6bb30ce973
select * from pm_project_proceduredetail m where
m.fPtzhuangN=' N015 --- N028 '
//架线 28 29 630a709e62634bbd9db0066f9bc904a3
// 112 010 26f948ca84b74419bfcb16deb32f2d06
select * from pm_project_proceduredetail m where
m.fPtzhuangN=' N028 --- N029 '
//N55 74 f8c5b0486c49452b86a6f0739fc3d426
// 102 110 c1e3108cbd094e6c8c53e3b81736995a
C7CE09581EE00001B79217DB4E971E88
select * from pm_project_persondetail2 m where
m.fPtfMasterID=' C7CE09581EE00001B79217DB4E971E88
' and m.fPaibanIDTTT<>'c1e3108cbd094e6c8c53e3b81736995a'
C7CE09581EE00001B79217DB4E971E88
//120-123 架线 e16790d3d3314cd298a572a237bf6aaf
select * from pm_project_proceduredetail m where
m.fPtzhuangN=' N120 --- N123 '
//17 组塔 3888da90ab66427494f40d69f1d2dfc0 30
// jichu 17 update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.BasicsSubPageState='未完成',m.fSum=0,m.fState='未完成'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m set
n.TowerSubPageState='未开始', m.fSum=0,m.fState='未完成'
where n.fID = m.fMasterID
and n.fPostName=' N017 '
and m.fBasicType='组塔'
// 外键 C7C690A041000001BD101F63B8D016F8
feeb28b9f7704adb972b2b3f69072ab3
feeb28b9f7704adb972b2b3f69072ab3
//跟新分包商数据
update pm_project_project_gongxu m set m.fState ='未完成', m.fSum =
0//初始化工序表
update pm_project_project_postinformationtab m set
m.fBasicsSubPlanSum =0,m.fTowerSubPlanSum =0,m.fStringingSubPlanSum =0,
m.BasicsSubPageState='未开始',m.TowerSubPageState='未开始',m.StringingSub
PageState='未开始'
update pm_project_persondetail2 m set m.fTeamName='',m.fTeamID=''
where m.
pm_project_proceduredetail
//查询工作排班从表 桩号
SELECT * FROM pm_project_proceduredetail N WHERE
N.BasicsSubPageName='四川省津华电力分包商'
//更新班组
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='dddd' where m.BasicsSubPageName='四川省津华电力分包商'
and n.fPaibanIDTTT=m.fID
//
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='dddd',n.fTeamID ='dd' where
m.BasicsSubPageName='四川省津华电力分包商' and n.fPaibanIDTTT=m.fID
//基础 四川腾峰
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='郝守成',n.fTeamID ='C7CD4FC44110000196A113901DB416FC',
n.fPlanSum=100
where m.BasicsSubPageName='四川腾烽电力分包商' and
n.fPaibanIDTTT=m.fID
唐山博聚建筑分包商 四川省输变电分包商 四川省岳池送变电分包商
大元建业集团分包商
//四川省津华电力分包商
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='刘顺宽',n.fTeamID ='C7CD4FFDB1000001598744241C1460E0',
n.fPlanSum=100
where m.BasicsSubPageName='四川省津华电力分包商' and
n.fPaibanIDTTT=m.fID
//山东睿涵电力工程有限公司
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='睿涵苏必安',n.fTeamID
='C7CD50192EA000013E52AE0AFDE01F5D', n.fPlanSum=100
where m.BasicsSubPageName='山东睿涵电力分包商' and
n.fPaibanIDTTT=m.fID
//
//基础 唐山博聚建筑安装有限公司
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='博聚苏必安',n.fTeamID ='C7CD503A04F000013D4D86E07B801BA4',
n.fPlanSum=100
where m.BasicsSubPageName='唐山博聚建筑分包商' and
n.fPaibanIDTTT=m.fID
//四川省输变电分包商 基础
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='王伟',n.fTeamID ='C7CD504F08A00001CB1B1620EEFF7DA0',
n.fPlanSum=100
where m.BasicsSubPageName='四川省输变电分包商' and
n.fPaibanIDTTT=m.fID
//四川省岳池送变电分包商
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='岳池苏必安',n.fTeamID
='C7CD508D70B00001ACFBD5B3D2D01956', n.fPlanSum=100
where m.BasicsSubPageName='四川省岳池送变电分包商' and
n.fPaibanIDTTT=m.fID
//大元建业集团分包商
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='罗经理',n.fTeamID ='C7CD511C0D7000017A1B13C018E0B660',
n.fPlanSum=100
where m.BasicsSubPageName='大元建业集团分包商' and
n.fPaibanIDTTT=m.fID
//组塔四川省津华电力工程有限公司
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='马福彬',n.fTeamID ='C7CD5056AC70000147EF144517151B8B',
n.fPlanSum=100
where m.TowerSubPageName='四川省输变电分包商' and
n.fPaibanIDTTT=m.fID and m.fProjectWrokType ='组塔'
//四川精四川省津华电力工程有限公司 组
update pm_project_proceduredetail m,pm_project_persondetail2 n set
n.fTeamName ='刘顺宽',n.fTeamID ='C7CD4FFDB1000001598744241C1460E0',
n.fPlanSum=100
where m.TowerSubPageName='四川省津华电力分包商' and
n.fPaibanIDTTT=m.fID and m.fProjectWrokType ='组塔'
//sql
20180108
select * from pm_project_proceduredetail m where m.fPtzhuangN='
N083 --- N100 '
2b98f18775f84c6abbcb71e8d61ab47f
2b98f18775f84c6abbcb71e8d61ab47f
pm_project_persondetail2
2b98f18775f84c6abbcb71e8d61ab47f
//
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N188 '
and n.fPostName>=' N188 '
and m.fBasicType='组塔'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N017 '
and n.fPostName>=' N017 '
and m.fBasicType='组塔'
// paiban
pm_project_proceduredetail
pm_project_persondetail2
select
//
select * from pm_project_proceduredetail m where m.fPtzhuangN='
N017 ' feeb28b9f7704adb972b2b3f69072ab3
pm_project_persondetail2
select * from pm_project_persondetail2 m where
m.fPaibanIDTTT='feeb28b9f7704adb972b2b3f69072ab3'
update pm_project_proceduredetail n , pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fSum=100,m.work ='已完成'
where n.fID = m.fMasterID
and n.fPostName<=' N188 '
and n.fPostName>=' N188 '
and m.fBasicType='组塔'
//
paiban update pm_project_proceduredetail n ,
pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fToalSum=100,m.fWorkState ='已完成'
where n.fID = m.fPaibanIDTTT
and n.fPtzhuangN=' N017 '
and m.fPtBasicType='组塔'
and n.fProjectWrokType='组塔'
//
feeb28b9f7704adb972b2b3f69072ab3
update pm_project_proceduredetail n , pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fToalSum=100,m.fWorkState ='已完成'
where n.fID = m.fPaibanIDTTT
and n.fPtzhuangN=' N166 '
and m.fPtBasicType='组塔'
and n.fProjectWrokType='组塔'
update pm_project_proceduredetail n , pm_project_persondetail2 m
set
n.TowerSubPageState='已完成',m.fToalSum=100,m.fWorkState ='已完成'
where n.fID = m.fPaibanIDTTT
and n.fPtzhuangN=' N017 '
and m.fPtBasicType='架线'
and n.fProjectWrokType='架线'
update pm_project_project_postinformationtab n ,
pm_project_project_gongxu m
set
n.TowerSubPageState='已完成',m.fSum=100,m.fState='已完成'
where n.fID = m.fMasterID
and n.fPostName=' N120 --- N123 '
and m.fBasicType='架线'
*************************************************************************
*************************************************************************
************************
20180223 工作记录
王文安 管理员
陈启红
济南
李天宏 管理员
周启 施工经理
梁伦婷 施工经理
陈江利 施工班组
陈江李 施工班组
叶岳辉 施工班组
C7DEBA8A1EA00001EB8B1EB01620BFF0 圣辉四期项目部 项目部id
pm_project_project_informationtable_postsetb_xm_3gw
项目信息-岗位表
pm_project_project_informationtable_postsetb_people
项目信息-人员表
pm_project_project_informationtable_postsetb_xm
C7E2949FE1700001251CD3A6283CA870 十部
$row.val("fysxs1") =='2'
$row.val("fysxs1") =='1' || $row.val("fysxs1") =='2'
C7E29581A7C000013A10969379F71D56
Model.prototype.xmbonckick1 = function(event){
//项目部点击事件, 跳转详细
debugger
var data = this.comp("pro_projc_xmb");
var pro_g = this.comp("pro_projc_gang");
//参数列表
var N_fiter1="1";
var N_fiter2="2";
var id = data.getRowID(event.bindingContext.$object);
data.to(id);
pro_g.setFilter("Nb1",
"pm_project_project_informationtable_postsetb_xm_3gw.fysxs1='"+N_f
iter2+"'");
pro_g.refreshData();
this.comp("bdstm").to("douce7");
};
var data = this.comp('mainData');
data.setFilter('filter1',"SA_OPPerson.sName like '%李%'");
data.setFilter('filter2',"SA_OPPerson.sCode = :operatorCode() or
SA_OPPerson.sCode = :code");
//给变参code赋值
data.filters.setStringVar("code","code_abc");
//最终qureyAction的KSQL中where部分将增加 and ((SA_OPPerson.sName
like '%李%') and (SA_OPPerson.sCode = :operatorCode() or
SA_OPPerson.sCode = 'code_abc'))
//统计mainData中年龄fAge合计
var sum = this.comp('mainData').sum('fAge');
//统计mainData中fName姓“李”的年龄fAge合计
var sum = this.comp('mainData').sum('fAge',function(ev){
var v = ev.source.getValue('fName',ev.row);
return v.indexOf('李')==0;
});
fxmbName
$model.pro_zb.val("fReachSum") =='0/0'
$model.pro_zb.val("fReachSum") !='0/0'
Model.prototype.selectgzp1 = function(event){
//选择工作票
var data = this.comp("basgzpb");
var basgzpc = this.comp("basgzpc");
var s = this.comp("select1").val();
data.setFilter("t",
"pm_project_basic_main_gongzuorenwu2.fBz='"+s+"'");
data.refreshData();
basgzpc.refreshData();
};
C7D7629EC85000016FE61E2015805100
基础**********************************************************
************
C7D7629F6D70000120EC5C2714491474
组塔**********************************************************
************
C7E29FC0F2C000019CE71F2C29DE1910 架线
select * from pm_project_project_informationtable_postsetb_xm_3gw m
where m.fPostxmid='C7E29581A7C000013A10969379F71D56'
$UI/BZB01/common/img/u66.png
周牛宝 管理员
王留微
jishizao 英国保城集团
周 启 山东迪尔公司 管理员
******************************
山东迪尔公司
******************************
管理员 周 启
经理 曾诚革 zengchengge
林 匡 lingkuang
谢夏光 xiexiaguang
班长 欧金才 oujingcai
吴 本 wuben
刘边仁 liubanren
班组人员 郭幼丹 guoyoudan
梁叔侠 liangshuxia
***********************************************************
Model.prototype.Count3open = function(event){
//选择人员 跳转到5
debugger
var data = this.comp("jicu_peo");//人员表
data.refreshData();
var pro_projc_gang= this.comp("pro_projc_gang");
var rows = pro_projc_gang.getCurrentRow();
var N_tnd = pro_projc_gang.getValue("fPostWriteID",rows);
//数据回显
data.each(function(parmas){
var Na = data.getValue("fPostWriteID", parmas.row);
if(N_tnd.indexof(Na)==1){
data.setValue("sFamilyAddress", '1', parmas.row);
}
});
this.comp("bdstm").to("douce5");
//选择org人员
};
*************************************************************************
*************************************************************
*************************************************************************
*************************************************************
站班汇报
*************************************************************************
*************************************************************
*************************************************************************
*******
山东迪尔公司
******************************
管理员 周 启
经理 曾诚革 zengchengge
林 匡 lingkuang
谢夏光 xiexiaguang
班长 欧金才 oujingcai
吴 本 wuben
刘边仁 liubanren
班组人员 郭幼丹 guoyoudan是的发送的地方是的发送东 演示
梁叔侠 liangshuxia
************************************************************************
************************************************************************
*****************************************
//选择人员 跳转到5
var data = this.comp("jicu_peo");//人员表
data.refreshData();
var pro_projc_gang= this.comp("pro_projc_gang");
var rows = pro_projc_gang.getCurrentRow();
var N_tnd = pro_projc_gang.getValue("fPostWriteID",rows);
//数据回显
data.each(function(parmas){
var Na = data.getValue("sID", parmas.row);
if(N_tnd.indexOf(Na)==-1){
}else{
data.setValue("sFamilyAddress", '1', parmas.row);
}
});
this.comp("bdstm").to("douce5");
//选择org人员
******************************************************************
******************************************************************
*****************************************************
1.进度汇报 添加备注...
2.所有数据回显
3.站班汇报 地理位置...###############
4.进度汇报数据同步
5.站班汇报###############
6.进度汇报###############
7.排班 同步, 新增后顺序############### 同步解决, 剩下 数据回显
8.排序###############
9.单选###############
10.任务清单
11.
//参数列表
var storage =window.localStorage;
var pd_porN=storage["Door_login2018_now_prona"];//项目名称
//
project_report.setValue("fspName", st_arr,rows);
project_report.setValue("fspID", st_brr, rows);
c268c816-cd3c-4620-a757-100ae1955fb7
c0876663-4879-4191-816c-dd96843fe11b
52768d1d-0f39-4b4c-9906-b144882b662d
ba9eb5a1-c98b-4257-a348-be9d12069303
N_id
******************************************************************
**************************************
//桩号回显
debugger
var pro_zb = this.comp("pro_zb");
var pro_zh = this.comp("pro_zh");
//参数列表
var rows=pro_zb.getCurrentRow();
var N_Nam =pro_zb.getValue("fPlaceName",rows);
//黑盒
pro_zh.each(function(parmas){
var Na = pro_zh.getValue("fPostName", parmas.row);
if(N_Nam == undefined|| N_Nam == null||N_Nam ==''){
debugger
}else{
if(N_Nam.indexOf(Na)==-1){
}else{
pro_zh.setValue("fState", '1', parmas.row);
}
}
});
this.comp("contents1").to("content2");
ref("fPostState")
//
var st =pro2.getValue("fPostState", params.row);
var st_name =pro2.getValue("fPostWriteName", params.row);
var st_sID =pro2.getValue("fPostWriteID", params.row);
var st =pro2.getValue("fPostState", params.row);
var st_name =pro2.getValue("fPostWriteName", params.row);
var st_sID =pro2.getValue("fPostWriteID", params.row);
Model.prototype.newwork3 = function(event){
// 新增排版表数据 。这个动作是为了架线新增工序, 要做的判断是
排班表和 工序表 都要有类别
var data1 =this.comp("pro_quduan");
var data2 =this.comp("pro_work33");
var data3 =this.comp("pro_work44");
//获取参数
var storage =window.localStorage;
var pd_porN=storage["Door_login2018_now_prona"];//项目名称
var pd_porD=storage["Door_login2018_pn_proid"];//项目id
var pd_porC=storage["Door_login2018_pn_procode"];//项目编码
//
var user = localStorage.getItem("user");//人员ID, 组织ID
var sp_md5Str = JSON.parse(user).md5Str;//md5
var s_sum= data1.getValue("fBasicsSubPlanSum");
var s_fid= data1.getValue("fID");
var s_date = new Date();
var s_name= data1.getValue("fPostName");
//排班主表
var stitle =
$(this.getElementByXid("spanjx1")).html();//获取到类别
data2.newData();
var dat2_id = data2.getCurrentRowID();
data2.setValue("fMasterID",s_fid);
data2.setValue("fWriteTime",s_date);
data2.setValue("fwanLiang",s_sum);
data2.setValue("fWorkType",stitle);
//排班从表
var span1 = $(this.getElementByXid("spanjx1")).html();
var span2 = $(this.getElementByXid("spanjx2")).html();
//调用动作,去后台判断工序新增是要新增项目工序还是桩后面的工序
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getzhuangquduangxmesagge1",
"async" : false,
"params" : {
"id" : s_fid ,
"type1" : span1 ,
"type2" : span2 ,
"pro_id" : pd_porD
},
"success" : function(emp) {
var mg_s =emp.gx.rows.length;
for(var i =0;i<mg_s;i++){
data3.newData();
data3.setValue("fMsterID",dat2_id);//外键,跟随桩号或
者区段
data3.setValue("fPaibanIDTTT",emp.gx.rows[i].fMasterID
.value);//外键,跟随桩号或者区段
data3.setValue("fzhuangqd",s_name);//外键,工序名称
data3.setValue("fPtBasicType",
emp.gx.rows[i].fBasicType.value);//工序类别
data3.setValue("fPtBasicName",
emp.gx.rows[i].fBasicName.value);//工序名称
data3.setValue("fPtfID",
emp.gx.rows[i].fBasicCode.value);//工序ID
data3.setValue("fPtfOnlyone",
emp.gx.rows[i].fOnlyone.value);//唯一工序
data3.setValue("fToalSum",
emp.gx.rows[i].fSum.value);//完成量
data3.setValue("fWorkState",
emp.gx.rows[i].fState.value);//完成状态
data3.setValue("fNo", emp.gx.rows[i].fNo.value);//编号
data3.setValue("fStateName","确定中");//文件状态
data3.setValue("fStateID","1");//文件状态ID
data3.setValue("fProjectName",pd_porN);//项目名称
data3.setValue("fProjectCode",pd_porC);//项目编码
data3.setValue("fProjectID",pd_porD);//项目ID
data3.setValue("fMD5",sp_md5Str);//MD5
}
}
});
data2.saveData();
data3.saveData();
};
Model.prototype.tongbuzuta1 = function(event){
//同步 同步操作,
这边要做的是吧当前时间表的主键拿过来去查询从表符合的数据,当有数据
的时候保存,然后再次循环。
debugger
var pro_work1 = this.comp("pro_work11");
var pro_work2 = this.comp("pro_work22");
//参数列表
var w1_id = pro_work1.getCurrentRowID();
var arr =[];
var brr =[];
var crr =[];
pro_work2.each(function(parmas){
// var id = pro_work2.getValue("fPtBasicName");
var State = pro_work2.getValue("fMsterID",parmas.row);
if(State==w1_id){
var s_name = pro_work2.getValue("fTeamName",parmas.row);
var s_id = pro_work2.getValue("fTeamID", parmas.row);
var s_time = pro_work2.getValue("fEndTime", parmas.row);
if(s_id == undefined|| s_id == null||s_id ==''){
}else{
arr.push(s_name);
brr.push(s_id);
crr.push(s_time);
}
}
});
//同步数据
var tb_name = arr[0];//班组
var tb_id = brr[0];//班组id
var tb_s_time = crr[0];//时间
//
pro_work2.each(function(parmas){
// var id = pro_work2.getValue("fPtBasicName");
var State = pro_work2.getValue("fMsterID",parmas.row);
if(State==w1_id){
pro_work2.setValue("fTeamName",tb_name,parmas.row);
pro_work2.setValue("fTeamID",tb_id,parmas.row);
pro_work2.setValue("fEndTime",tb_s_time,parmas.row);
}
});
pro_work2.saveData();
};
bz_people.each(function(par){
debugger
var e_id = bz_people.getValue("fPostWriteID", par.row);
if(N_s==e_id){
debugger
bz_people.setValue("fPostState","1", par.row);
}
});
}
litiegao
var storage = window.localStorage;
storage["Door_jdhb5"] = id;//进度汇报页面
val("fxxsb") =='k'
data2.each(function(params){
var st =data2.getValue("fPostState", params.row);
var st_name =data2.getValue("fPostWriteName", params.row);
var st_sID =data2.getValue("fPostWriteID", params.row);
if(st==1){
arr.push(st_name);
brr.push(st_sID);
}
});
************************
作业过程预控措施及落实: 是
否
1、施工现场布置:严格按照《输变电工程安全文明施工实施方案》的要求设置安全
警戒线、警示牌、友情提示牌、现场设置混凝土配合比标牌等安全设施。
2、基础立模应牢固。
3、操作转动机械时严禁戴手套。传动部件应有防护罩。
4、施工用电设施的安装、维护必须严格按《安规》执行,严禁私拉乱接;开关负荷
侧的首端处必须安装漏电保
护装置,熔丝的规格应符合设备的要求,且不得用其它金属线代替。
5、机电设备使用前应进行全面检查,确认机电装置完整、绝缘良好、接地可靠,使
用时严格执行安规要求。搭
设浇筑平台的跳板材质和搭设符合要求,跳板捆绑牢固,支撑牢固可靠,有上料通道
;上料平台不得搭悬臂结构,中间应设支撑点并结构可靠,平台应设护栏;大坑口基
础浇制时,搭设的浇制平台要牢固可靠,平
台横梁应加撑杆,以防平台横梁垮塌伤。
6、基础施工前应配备漏电保安器,无漏电保安器的作业现场,禁止浇制施工,发电
机、搅拌机在使用前应将外 壳安装保护接地线,搅拌机电源线应架
7、坑下捣固人员必须正确佩戴安全帽,坑上监护人和坑下工作人员要互相联系配合
好,上、下坑应有攀登措施。 8、模板应用绳索和木杠滑入坑内。
9、模板的支撑应使用钢支撑架或方木,采用吊梁应有足够的强度,搁置应稳固。
10、模板支撑应牢固,并应对称布置;高出坑口的加高立柱模板应有防止倾覆的措施
。
12、拆除模板应自上而下进行;拆下的模板应集中堆放;木模板外露的铁钉应及时
拔掉或打弯。
13、人工搅拌混凝土的平台应搭设稳固、可靠。工作前必须检查基础模板和浇制平
台是否牢固可靠。施工
人员不得在支撑和独木上行走。 14、人工浇筑混凝土遵守下列规定: ①
浇筑混凝土或投放大石时,必须听从坑内捣固人员的指挥。 ②
坑口边缘0.8m以内不得堆放材料和工具。 ③
捣固人员不得在模板或撑木上走动。 ④
电动振捣器应采用绝缘良好的橡皮软线;振捣器运转过热或暂停工作时,应将电源切
断。
15、浇制用的电源,必须配备专用电源箱,且有触电保安器装置。机电设备使用前应
进行全面检查,确认
机电装置完整、绝缘良好、接地可靠。在林区施工时,油料堆放处应做好防护,施工
现场配备灭火器。
18、用手推车运送混凝土时,倒料平台口应设挡车措施;倒料时严禁撒把。
21、采用暖棚养护,应采取防止废气窒息、中毒措施,火源不得与易燃物靠近。
22、在光线不足及夜间工作的场所,应设足够的照明;主要通道上应装设路灯。
现场作业工艺要点: 1.
对原材料进行外观检查,水泥、砂、石粒径及含泥量应符合要求、应采取措施与地面
隔离。复核钢筋规格、数量,基础及地脚螺栓尺寸。 2.
严格按要求控制混凝土配合比、水灰比,每班日或每个基础腿应检查两次及以上坍落
度并做好记录。混凝土搅拌必须到位,机械搅拌不得少于2分钟。冬季施工当平均气
温低于5℃时,应对砂、石、水进行加热后
搅拌,优先加热水,但水泥不得加热。 3.
混凝土不宜长时间、长距离运送,以免出现离析现象。混凝土浇灌落差超过2m时应设
置溜筒。 4.
混凝土应分层浇筑,分层捣固,混凝土每层浇筑厚度应控制在插入式振捣棒有效作用
长度的1.25倍以内。使用插入式振捣器宜直上直下、快插慢拔,插点均匀。振捣器的
移动间距一般为300~400mm。每次振捣
都要插入混凝土下层30~50mm,每处振捣应以混凝土表面出现浮浆和不再出现气泡,
不再显著沉落为度;不得有漏振和过振现象。 5.
混凝土全部浇筑完成后,在混凝土快要初凝前及时对地脚螺栓进行复核调整,调整后
的地螺四周需再捣固一次。基础棱边分明,基面平整光滑,不积水。 6.
同一基础应一次性浇筑完成(设计有要求的除外),相隔时间不得超过2小时。
7.
及时做好试块件,试块应在现场从浇筑中的混凝土取样制作,其养护条件应与基础相
同。 8.
基础根开、对角线、地螺间距及外露高度应符合设计要求。 9.
根据气温做好养护,混凝土未达到一定强度时,应用喷壶浇水,不得用水直接冲击表
面,保持混凝土湿润。冬季当日平均气温低于5℃时,不得浇水养护,而应采取暧棚法
、覆盖法进行养护,保证养护温度不低
于5℃,并应保持混凝土湿润。 10.
及时做好原材料的跟踪记录;按要求拍摄数码照
作业分工:
作业前检查
是 否 施工人员着装是否规范、
精神状态是否良好 □ □
施工安全防护用品(包括个人)、 用具是否齐全和完好 □
□ 现场所使用的工器具是否完好且符合技术安全措施要
□ □
是否编制技术安全措施交底 □
□ 施工人员是否参加过本工程技术安全措施交底
□ □
施工人员对工作分工是否清楚 □
□ 各工作岗位人员对存在的风险点、 风险源是否明白
□ □
预控措施是否明白
//返回上一页
Model.prototype.backBtnClick = function(event){
justep.Shell.closePage();
setTimeout(function(){
justep.Shell.fireEvent("onRestoreContent", {});
},500);
};
//图片路径转换
Model.prototype.getImageUrl = function(url){
return require.toUrl(url);
};
□ □
//减数量
Model.prototype.reductionBtnClick = function(event){
/*
1、减少数量按钮绑定点击事件onClick()
2、点击按钮,当前记录的fNumber值减1
3、fNumber为1时不再相减
*/
var row = event.bindingContext.$object;
var n=row.val("fNumber");
if(n>1){
row.val("fNumber",n-1);
}
};
//加数量
Model.prototype.addBtnClick = function(event){
/*
1、增加数量按钮绑定点击事件onClick()
2、点击按钮,当前记录的fNumber值加1
*/
var row = event.bindingContext.$object;
var n=row.val("fNumber");
row.val("fNumber",n+1);
};
var data = this.comp("data");
var goodrows = data.find();
var goodsData = this.comp("goodsData");
var goodsRows = goodsData.find(["fChoose"],["1"]);
goodsData.deleteData(goodsRows);
shopData.each(function(obj){
var n =
goodsData.find(["fShopID"],[obj.row.val("id")]).length;
if(n == 0){
shopRows.push(obj.row);
}
});
Model.prototype.showBackBtn = function(isBack){
/*
1、根据参数修改calculateData
*/
this.isBack = isBack;
var v = isBack ? 1 : 0;
this.comp("calculateData").setValue("isBack",v);
};
一条语句,多个变量
您可以在一条语句中声明很多变量。该语句以 var
开头,并使用逗号分隔变量即可:
var lastname="Doe", age=30, job="carpenter";
声明也可横跨多行:
var lastname="Doe",
age=30,
job="carpenter";
重新声明 JavaScript 变量
如果重新声明 JavaScript 变量,该变量的值不会丢失:
在以下两条语句执行后,变量 carname 的值依然是 "Volvo":
var carname="Volvo";
var carname;
JavaScript 数据类型
字符串(String)、数字(Number)、布尔(Boolean)、数组(Array)、对象(Object)、空(Null)、未定义(Undefined)。
var answer1='It\'s alright';
var answer2="He is called \"Johnny\"";
var answer3='He is called "Johnny"';
JavaScript 对象
对象由花括号分隔。在括号内部,对象的属性以名称和值对的形式 (name : value) 来定义。属性由逗号分隔:
var person={firstname:"John", lastname:"Doe", id:5566};
上面例子中的对象 (person) 有三个属性:firstname、lastname 以及 id。
空格和折行无关紧要。声明可横跨多行:
var person={
firstname : "John",
lastname : "Doe",
id : 5566
};
对象属性有两种寻址方式:
实例
name=person.lastname;
name=person["lastname"];
当您声明新变量时,可以使用关键词 "new" 来声明其类型:
var carname=new String;
var x= new Number;
var y= new Boolean;
var cars= new Array;
var person= new Object;
var person = {firstName:"John", lastName:"Doe", age:50, eyeColor:"blue"};
var person = {
firstName:"John",
lastName:"Doe",
age:50,
eyeColor:"blue"
};
var person = {
firstName:"John",
lastName:"Doe",
age:50,
eyeColor:"blue"
};
****************************************
福田四川工程公司
lifutian 管理员
赵铁一 项目经理
赵铁二
赵铁三
张宁一
张宁二
$row.val("fPostType") =='项目部'
98ed9717-e342-45bf-b95f-4ede8d13dda6
Table table3 = DataUtils.queryData(conn, sqlzuzhigx2, null,null, null,null);
Iterator<Row> iterator3 = table3.getRows().iterator();
while(iterator3.hasNext()){
Row info2 = iterator3.next();
String new_uuid = UUID.randomUUID().toString(); //获取UUID并转化为String对象 ID
String vb_fID = info2.getString("fID");
String vb_fNo = info2.getString("fNo");
String vb_fBasicType = info2.getString("fBasicType");
String vb_fBasicName = info2.getString("fBasicName");
String vb_fBasicCode = info2.getString("fBasicCode");
String vb_fBz = info2.getString("fBz");
String vb_fMasterID= info2.getString("fMasterID");
Model.prototype.ztxf1 = function(event){
//指头下发 基础
debugger
var pro_work1 = this.comp("pro_work1");
var pro_work2 = this.comp("pro_work2");
var pro_z_j = this.comp("pro_zhuang_j");//桩id
//参数列表
debugger
var w1_id = pro_work1.getCurrentRowID();//排班时间表 id
var z1_id = pro_z_j.getCurrentRowID();//桩区段表id
var stitle = $(this.getElementByXid("spanjx1")).html();//获取到类别
pro_work2.each(function(parmas){
var State = pro_work2.getValue("fMsterID",parmas.row);
if(State==w1_id){
//如果当当前从表工序表的外键等于排班时间主表的主键的时候,就定位到这这些要下发的数据,然后进行数据处理
pro_work2.setValue("fStateName","待审批",parmas.row);
pro_work2.setValue("fStateID","1",parmas.row);
}
//调用动作,这边要做的处理是把当前数据作为有效数据,去数据库中修改之前的数据为失效,判断依据是当前时间主表的id.
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getxmpb_xiafaczsj17",
"async" : false,
"params" : {
"pt_id" :w1_id,
"f_zqid" :z1_id,
"f_leb" :stitle
},
"success" : function(emp) {
//加载data部分数据
debugger
}
});
});
pro_work1.setValue("fPtzhuangState","已排班");
pro_work2.saveData();
pro_work1.saveData();
justep.Util.hint("下发成功");
};
fPtfID
fPostxmid
select *from pm_project_project_informationtable_postsetb_xm_3gw m where m.fPostxmid='C7E3A96CE5A00001E6EB1447C9C0166E'
select *from pm_project_project_informationtable_postsetb_xm m where m.fxmbName='权威项目部'
C7E3AA944EF0000178E1135010651C9C
C7E3AB6CF80000015948DB2019A06600
Model.prototype.stmok1 = function(event){
//新增班组确定事件
var gang = this.comp("pro_projc_gang");
var main = this.comp("pro_projc_main");
var sCode = generateUUID();//获取主键
//参数列表
var isv = this.comp("input133").val();
var main_id = main.getCurrentRowID();
//容器
gang.newData();
gang.setValue("fPostName",isv);
gang.setValue("fysxs1","2");
gang.setValue("fNo","7");//判断人员单个状态
gang.setValue("fPostxmid1",sCode);
gang.setValue("fPostXlb","fbs");
gang.setValue("fPostType","项目部");
gang.saveData();
gang.refreshData();
//调用动作
justep.Baas.sendRequest({
"url" : "/BZB02/pm_action_project_pro",
"action" :"getteamname1pro",
"async" : false,
"params" : {
"id" :main_id//项目ID
},
"success" : function(emp){
//加载data部分数据
for(var i =0 ;i<emp.rows.length;i++){
gang.newData();
gang.setValue("fPostxmid2",sCode);
gang.setValue("fPostName",emp.rows[i].fPostName.value);
gang.setValue("fPostXlb",emp.rows[i].fPostXlb.value);
gang.setValue("fPostType","班组");
gang.setValue("fysxs1", "1");
gang.setValue("fNo", "8");
gang.saveData();
}
}
});
//
function generateUUID() {
var d = new Date().getTime();
var uuid = 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
var r = (d + Math.random()*16)%16 | 0;
d = Math.floor(d/16);
return (c=='x' ? r : (r&0x3|0x8)).toString(16);
});
return uuid;
}
//关闭弹出框
this.comp("messlist").hide();
};