📄 publicparm.jsp
字号:
if (!oldNumDot.equals(numDot)) {//基本参数改变的情况下，改动数据库结构
updateSql = "update sysparam set para_value='"+numDot+"' where para_no='P72'";
updateSql = new String(updateSql.getBytes("gb2312"),"ISO8859_1");
rs = stmt.executeQuery(updateSql);
//采购计划单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".requireplanmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
//+ "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".requireplandetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY stockinfactnum DECIMAL(20,"+numDot+") default '0';");
//采购定单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".buyplanmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
//+ "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".buyplandetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+" MODIFY stockinfactnum DECIMAL(20,"+numDot+") default '0';");
//采购入库单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockinmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
//+ "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0'"
//+ ",MODIFY sendAmt DECIMAL(20,"+numDot+") default '0',MODIFY noFaxAmt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockindetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY stockinfactnum DECIMAL(20,"+numDot+") default '0',MODIFY freenum DECIMAL(20,"+numDot+") default '0',"
+"MODIFY allnum DECIMAL(20,"+numDot+") default '0';");
//销售计划单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".sellplanmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
//+ "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".sellplandetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY stockinfactnum DECIMAL(20,"+numDot+") default '0',MODIFY manunum DECIMAL(20,"+numDot+") default '0';");
//销售出库单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockoutmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
//+ "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0'"
//+ ",MODIFY sendAmt DECIMAL(20,"+numDot+") default '0',MODIFY noFaxAmt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockoutdetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY stockoutfactnum DECIMAL(20,"+numDot+") default '0',MODIFY freenum DECIMAL(20,"+numDot+") default '0',"
+"MODIFY allnum DECIMAL(20,"+numDot+") default '0';");
//销售送货单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".sendmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
//+ "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0'"
//+ ",MODIFY sendAmt DECIMAL(20,"+numDot+") default '0',MODIFY noFaxAmt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".senddetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY stockoutfactnum DECIMAL(20,"+numDot+") default '0',MODIFY freenum DECIMAL(20,"+numDot+") default '0',"
+"MODIFY allnum DECIMAL(20,"+numDot+") default '0';");
//库存总账
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".store MODIFY stocknum DECIMAL(20,"+numDot+") default '0',MODIFY freenum DECIMAL(20,"+numDot+") default '0',"
+"MODIFY allnum DECIMAL(20,"+numDot+") default '0';");
//库存明细帐
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".storedetail MODIFY stockinfactnum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY storefactnum DECIMAL(20,"+numDot+") default '0',MODIFY stockoutfactnum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY freenum DECIMAL(20,"+numDot+") default '0',MODIFY allnum DECIMAL(20,"+numDot+") default '0';");
//商品属性
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".product MODIFY storemin DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY storemax DECIMAL(20,"+numDot+") default '0';");
//商品明细帐
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".storeflowdetail MODIFY fromnum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY innum DECIMAL(20,"+numDot+") default '0',MODIFY outnum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY endnum DECIMAL(20,"+numDot+") default '0';");
//生产计划单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuplanmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
//+ "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0'"
//+",MODIFY noFaxAmt DECIMAL(20,"+numDot+") default '0',MODIFY sendAmt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuplandetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY stockoutfactnum DECIMAL(20,"+numDot+") default '0',MODIFY manunum DECIMAL(20,"+numDot+") default '0'"
+",MODIFY freenum DECIMAL(20,"+numDot+") default '0',MODIFY allnum DECIMAL(20,"+numDot+") default '0';");
//生产任务单
//rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuprodmain MODIFY amt DECIMAL(20,"+numDot+") default '0',"
// + "MODIFY payamt DECIMAL(20,"+numDot+") default '0',MODIFY factpayamt DECIMAL(20,"+numDot+") default '0'"
// +",MODIFY noFaxAmt DECIMAL(20,"+numDot+") default '0',MODIFY sendAmt DECIMAL(20,"+numDot+") default '0';");
rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuproddetail MODIFY plannum DECIMAL(20,"+numDot+") default '0',"
+ "MODIFY stockoutfactnum DECIMAL(20,"+numDot+") default '0'"
+",MODIFY freenum DECIMAL(20,"+numDot+") default '0',MODIFY allnum DECIMAL(20,"+numDot+") default '0';");
}
rs.close();
updateSql = "update sysparam set para_value='" + BuyTaxRate + "' where para_no='P67'";
updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
rs = stmt.executeQuery(updateSql);
rs.close();
updateSql = "update sysparam set para_value='" + SellTaxRate + "' where para_no='P68'";
updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
rs = stmt.executeQuery(updateSql);
rs.close();
updateSql = "update sysparam set para_value='" + dataTimeScope + "' where para_no='P66'";
updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
rs = stmt.executeQuery(updateSql);
updateSql = "update sysparam set para_value='" + ProductScope + "' where para_no='P70'";
updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
rs = stmt.executeQuery(updateSql);
updateSql = "update sysparam set para_value='" + StockScope + "' where para_no='P71'";
updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
rs = stmt.executeQuery(updateSql);
updateSql = "update sysparam set para_value='" + incost + "' where para_no='P90'";
updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
rs = stmt.executeQuery(updateSql);
updateSql = "update sysparam set para_value='" + outrate + "' where para_no='P91'";
updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
rs = stmt.executeQuery(updateSql);
}
catch (SQLException ex) {
System.err.println("executeQuery:" + ex.getMessage());
}
finally {
stmt.close();
conn.close();
}
}
else {
try {
conn = Messjdbc.connDbms();
stmt = conn.createStatement();
selectSql="select EA from TD_OA.VERSION";
rs=stmt.executeQuery(selectSql);
while(rs.next()){
EAVersion=rs.getString(1);
}
selectSql = "select para_value from sysparam where para_no = 'P01'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
UnitName = rs.getString(1);
UnitName = UnitName==null?"":UnitName;
}
selectSql = "select para_value from sysparam where para_no = 'P02'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
PageSize = rs.getString(1);
PageSize = PageSize==null?"":PageSize;
}
selectSql = "select para_value from sysparam where para_no = 'P17'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
StockIsNeg = rs.getString(1);
StockIsNeg = StockIsNeg==null?"":StockIsNeg;
}
selectSql = "select para_value from sysparam where para_no = 'P18'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
ExchRate = rs.getString(1);
ExchRate = ExchRate==null?"":ExchRate;
}
selectSql = "select para_value from sysparam where para_no='P65'";
rs = stmt.executeQuery(selectSql);
while(rs.next()){
amtDot = rs.getString(1);
amtDot = amtDot==null?"":amtDot;
}
selectSql = "select para_value from sysparam where para_no='P66'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
dataTimeScope = rs.getString(1);
dataTimeScope = dataTimeScope==null?"":dataTimeScope;
}
selectSql = "select para_value from sysparam where para_no='P67'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
BuyTaxRate = rs.getString(1);
BuyTaxRate = BuyTaxRate==null?"":BuyTaxRate;
}
selectSql = "select para_value from sysparam where para_no='P68'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
SellTaxRate = rs.getString(1);
SellTaxRate = SellTaxRate==null?"":SellTaxRate;
}
selectSql = "select para_value from sysparam where para_no='P70'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
ProductScope = rs.getString(1);
ProductScope = ProductScope==null?"":ProductScope;
}
selectSql = "select para_value from sysparam where para_no='P71'";
rs = stmt.executeQuery(selectSql);
while (rs.next()) {
StockScope = rs.getString(1);
StockScope = StockScope==null?"":StockScope;
}
selectSql = "select para_value from sysparam where para_no='P72'";
rs = stmt.executeQuery(selectSql);
while(rs.next()){
numDot = rs.getString(1);
numDot = numDot==null?"":numDot;
}
selectSql = "select para_value from sysparam where para_no='P90'";
rs = stmt.executeQuery(selectSql);
while(rs.next()){
incost = rs.getString(1);
incost = incost==null?"":incost;
}
selectSql = "select para_value from sysparam where para_no='P91'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -