/*//常用JS代码参考*/ new BigDecimal(data[i][3]).stripTrailingZeros().toPlainString()//js去掉小数点后面多余的0用parseFloat如:var a=23.8000 alert(parseFloat(a)) //结果:23.8 //常用引入外部JSdocument.write('<script type="text/javascript" src="../../CustomJsLib/EFGPShareMethod.js"></script>');//for 开窗//全局变量定义var gtxtsqrq = document.getElementById("txtsqrq");//申请日期var gsqrid = document.getElementById("sqrid");//申请人代号var gsqr = document.getElementById("sqr");//申请人名称var gsqbmid = document.getElementById("sqbmid");//申请部门代号var gsqbm = document.getElementById("sqbm");//申请部门名称 · //数据库链接var databaseCfgId = "EFGP"; //系統管理員資料來源(DataAccessDefinition)代號var tDbConn = new DataSource("ccsqd","SQLEFGP");//表單名;SQL namefunction formCreate(){ DefalInfo();return true;}function formOpen(){ var tGrid1 = document.getElementById("Grid1").value; //取出儲存在隱藏欄位中的Grid資料 if(typeof(Grid1Obj) != "undefined"){ //判斷grid物件是否存在表單中 if(tGrid1.length >1 ){ //判斷Grid是否有資料 Grid1Obj.reload(eval(tGrid1)); //若Grid有資料則將存於隱藏中的值載入Grid中 } } return true;}function formSave(){ if(typeof(Grid1Obj) != "undefined"){ //判斷grid物件是否存在表單中 document.getElementById("Grid1").value = Grid1Obj.toArrayString(); //將Grid裡的資料儲存至隱藏欄位中 } return true;}function formClose(){return true;}//单选开窗function btnsqr_onclick(){ var FileName = "SingleOpenWin"; var sql = " select U.id,U.userName "+ " from Users U, Functions F "+ " left join OrganizationUnit OU on OU.OID = F.organizationUnitOID "+ " inner join Organization O on O.OID = OU.organizationOID "+ " where U.leaveDate is null and F.isMain = 1 and OU.organizationUnitType = 0 "; var SQLClaused = new Array(sql); var SQLLabel = new Array("申请人代号","申请人姓名","部门代号","部门名称");//客制开窗的Grid Label var QBEField = new Array("U.id","U.userName","OU.id","OU.organizationUnitName");//模糊查询,須和DB Table栏位名称相同 var QBELabel = new Array("申请人代号","申请人姓名","部门代号","部门名称");//模糊查询的Label var ReturnId = new Array("apa21","gen02","apa22","gem02");//表单上的栏位代号 singleOpenWin(FileName, databaseCfgId_EFGP, SQLClaused, SQLLabel, QBEField, QBELabel, ReturnId, 720, 430); }//开窗关闭后触发的事件function checkPointOnClose(pReturnId){ if (pReturnId == "apa21") //根据申请人ID获取送货厂商默认编号 { //获取申请人所在组织 var tSql = " select u.username,fl.levelvalue,ou.organizationunitname,og.organizationname,og.id from Users U "+ " inner Join Functions F on F.occupantOID=U.OID "+ " inner Join OrganizationUnit OU ON OU.OID=F.organizationUnitOID "+ " inner Join FunctionDefinition FD ON FD.OID=F.definitionOID "+ " inner join functionlevel Fl on fl.oid =F.Approvalleveloid "+ " inner join organization og on og.oid =ou.organizationoid "+ " where u.id = '"+gapa21.value+"'" ; // alert(tSql); var results = tDbConn_EFGP.query(tSql); if(results.length > 0){ ghidsqrzzid.value = results[0][4]; } } }//表单预设值function DefalInfo(){ gtxtsqrq.value = systemDateTime;//申请日期 document.getElementById("sqrid").value = userId;//申请人ID document.getElementById("sqr").value = userName;//申请人姓名 document.getElementById("sqbmid").value = mainOrgUnitIds;//申请部门ID document.getElementById("sqbm").value = mainOrgUnitNames;//申请部门}//Grid新增function btn_add_onclick(){ Grid1Obj.addRow(); //將Binding欄位的資料填入Grid中 Grid1Obj.clearBinding(); //新增後清除Binding欄位資料 document.getElementById("Grid1").value = Grid1Obj.toArrayString(); //將新的資料存入Grid隱藏欄位中 } //Grid修改function btn_edit_onclick(){ Grid1Obj.editRow(); //將修改後的欄位的資料填入Grid中 Grid1Obj.clearBinding(); //清除Binding欄位資料 document.getElementById("Grid1").value = Grid1Obj.toArrayString(); //將新的資料存入Grid隱藏欄位中 } //Grid删除function btn_delete_onclick(){ Grid1Obj.deleteRow(); //將Grid某筆資料刪除 Grid1Obj.clearBinding(); //清除Binding欄位資料 document.getElementById("Grid1").value = Grid1Obj.toArrayString(); //將新的資料存入Grid隱藏欄位中 } //判断不能为空------------判断不能为空方式一----------function formSave(){ return checkNull(); return true;}//检查发起时不能为空function checkNull(){ if(activityId == "ACT7"){ var tMsg = ""; var tErrMsg = "不能为空"; if(Textbox50.value == "" ){ tMsg = tMsg + "请支原因" + tErrMsg + " \r\n"; }if(Textbox52.value == ""){ tMsg = tMsg + "在途金额" + tErrMsg + " \r\n"; }if(tMsg == ""){ return true }else{ alert(tMsg); return false; } }else{ return true;//第一关以外的关卡 }}------------判断不能为空方式二,Grid不能为空----------//表单保存function formSave(){ //非空校验合格 if (checkNull()) { if(typeof(Grid1Obj) != "undefined") { //判斷grid物件是否存在表單中 document.getElementById("Grid1").value = Grid1Obj.toArrayString(); //將Grid裡的資料儲存至隱藏欄位中 } //判斷Grid是否有資料 if(document.getElementById("Grid1").value=="[]") { alert("单身不能为空,请按新增按钮将单头资料插入单身中!"); return false ; } return true; } return false;}//金额必须是数字function Textbox25_onblur(){ var str = document.getElementById("Textbox25").value ; if(!isNaN(str) || str == ".") { document.getElementById("Textbox27").value = DX(document.getElementById("Textbox25").value) ; return true; }else{ alert("金额必须是数字"); document.getElementById("Textbox25").focus(); }}//金额转大写function DX1(n){ if (!/^(0|[1-9]\d*)(\.\d+)?$/.test(n)) return ""; var unit = "千百拾亿千百拾万千百拾元角分", str = ""; n += "00"; var p = n.indexOf('.'); if (p >= 0) n = n.substring(0, p) + n.substr(p+1, 2); unit = unit.substr(unit.length - n.length); for (var i=0; i < n.length; i++) str += '零壹贰叁肆伍陆柒捌玖'.charAt(n.charAt(i)) + unit.charAt(i); return str.replace(/零(千|百|拾|角)/g, "零").replace(/(零)+/g, "零").replace(/零(万|亿|元)/g, "$1").replace(/(亿)万|壹(拾)/g, "$1$2").replace(/^元零?|零分/g, "").replace(/元$/g, "元整");}//单价*数量=总价function SubTotal(){ if(tTxtQuantity.value != "" && tTxtPrice.value != "") { tTxtSubTotal.value = parseFloat(tTxtQuantity.value) * parseFloat(tTxtPrice.value); } else { tTxtSubTotal.value = '0'; }}//Grid中的金额合计&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&7777777function GridTotal(){ var gridData = g1Obj.getData(); var tSellingPriceTemp = 0; if (gridData.length > 0){ for (i = 0; i < gridData.length; i++){ if(gridData[i]["grid列代号"] != ""){ tSellingPriceTemp = tSellingPriceTemp + eval(gridData[i][5]); } } tTxtTotalPrice.value = eval(tSellingPriceTemp ); } else{ tTxtTotalPrice.value = '0'; }}///******************************************************************88//根据申请人带出相应部门ID,可应用在根据申请人ID带出相应职务、直属主管等信息function iptUser_onchange(){ if (iptUser_txt.value.length > 0) { var tSql = " select U.id,U.userName,OU.id,OU.organizationUnitName"+ " from Users U left join Functions F on F.occupantOID = U.OID "+ " left join OrganizationUnit OU on OU.OID = F.organizationUnitOID "+ " inner join Organization O on O.OID = OU.organizationOID "+ " where U.leaveDate is null and F.isMain = 1 and OU.organizationUnitType = 0 and U.id = '"+iptUser_txt.value+"' "; var tResult = tDbConn.query(tSql); if (tResult.length > 0){ tTxtDeptId.value = tResult[0][2]; tTxtDeptName.value = tResult[0][3]; } else { alert("请购人不存在 !!");//出差人不存在 !! } } else { tTxtDeptId.value = ''; tTxtDeptName.value = ''; }}两位小数.toFixed(2)//下拉框的内外储值function Dd_sksjd_onclick(){ var obj=document.getElementById("Dd_sksjd") ;//获取select控件,Select1为控件Select的id var index=obj.selectedIndex;//选中的索引; var text=obj.options[index].text;//选中的文本,外显值 var Value=obj.options[index].value;//选中值,内储值 document.getElementById("hdnType1").value = text;}//checkbox判断或赋值,一个等号是赋值 两个等号是判断document.getElementById("Ckb_dqxq_0").checked == true;//栏位是否被选中document.getElementById("Ckb_sqzbly_0").checked = false;//栏位被清空document.getElementById("Textbox8").style.display = "none";//不显示对象document.getElementById("Textbox8").style.display = "";//显示对象(采用默认值)document.getElementById("Textbox8").style.backgroundColor = "eeeeee";//显示对象(采用默认值)document.getElementById("Tb_lzryid").readOnly = true;//栏位只读document.getElementById("btn_lzry").disabled = false; //栏位 可编辑document.getElementById("btn_lzry").disabled = true; //栏位不可编辑