摘要:“交” 条件查询 不同字段 精确 queryExpression = '(InventTable.ItemName == "座") && (InventTable.ItemGroupID == "10")'; qbds.addRange(fieldnum(InventTable, ItemId)).value(queryExpression); 模糊 queryExpression =...
阅读全文
摘要:public void dsRefresh() { itemId itemId ; itemId = inventtable.itemId; Inventtable_ds.research(); Inventtable_ds.findRecord(InventTable::find(itemId)); }
阅读全文
摘要:static void testCallForm(Args _args) { formrun FromNAme; Args parameters = new Args(); ; parameters.name(formstr("AAAItemIDTest")); parameters.parm("PurchTable"); //parameters....
阅读全文
摘要:static void TestSendMail(Args _args) { SysMailer mail; ; mail = new SysMailer(); mail.quickSend('lingdanglfw@126.com','lingdanglfw@163.com', 'hahahahahahaha',"Hello"); }
阅读全文
摘要:static void LoadInventTable(Args _args) { str sDSN = "MSDN"; LoginProperty Lp; OdbcConnection myConnection; statement myStatement; ResultSet ...
阅读全文
摘要:static void TestDirectSQLInXpp(Args _args) { str sqltxt = "select * from custtable where custtable.accountnum == '4001'"; source sqlcmd; XppCompiler compiler = new XppCompiler(); custt...
阅读全文
摘要:Class:(一定要配 Run On Server) resultSet TestDirectSQLTwo() { connection con=new connection(); statement stm=con.createStatement(); SqlStatementExecutePermission sq...
阅读全文
摘要:1.Windows 2003 server 2.AD(IIS) 3.SQL Server 2005 + SP2(Instance+Analysis+Reporting) 4..Net FrameWork3.5 5.Office SharePoint 2007 + SP1 6.Wndows 2008 SDK(Net FrameWork) 7.VS Shell 2008 Isolated Mode S...
阅读全文
摘要:Round Round(123.243,0.05) {123.20} Trunc(123.23) {123}
阅读全文
摘要:Lookup DataSource public void lookup(FormControl _formControl, str _filterStr) {//; //journalFormTable.designLookupJournalName(_formControl); Query query = new Query...
阅读全文