| | |
| | | |
| | | |
| | | import com.yc.action.grid.Grid; |
| | | import com.yc.action.grid.PicEntity; |
| | | import com.yc.action.grid.SqlInfo; |
| | | import com.yc.app.v2.entity.GformEntity; |
| | | import com.yc.entity.TableColumnsDataTypeEntity; |
| | | import com.yc.utils.Page; |
| | | import com.yc.utils.ThreeJSON; |
| | | import org.json.JSONException; |
| | | import org.springframework.dao.DataAccessException; |
| | | import org.springframework.jdbc.core.JdbcTemplate; |
| | |
| | | * */ |
| | | public List getThreeTableInfo(int formid); |
| | | public List getGfiledByFormID9(int formID,int flag); |
| | | public List getGfiledByFormID9(int formID,int formType,int flag,String userCode); |
| | | /** |
| | | * 根据功能号ID查找gfiled功能字段信息 |
| | | * @param formID 功能号 |
| | |
| | | * @throws JSONException |
| | | * @throws UnsupportedEncodingException |
| | | * */ |
| | | public SqlInfo doExecute(DoExecuteParameter parameterObject,HttpServletRequest request,HttpServletResponse response,List<String> picList,Grid grid,String formid,String docPram,int cont) throws DataAccessException; |
| | | public SqlInfo doExecute(DoExecuteParameter parameterObject, HttpServletRequest request, HttpServletResponse response, List<PicEntity> picList, Grid grid, String formid, String docPram) throws DataAccessException; |
| | | /** |
| | | * 查找功能号所属的窗体类型 |
| | | * @param int formID 功能号 |
| | |
| | | * @param String fields 列名 |
| | | * @return SqlRowSet 参数值列表 |
| | | * */ |
| | | public List getDataByAjax(String tabName,String fields,String where)throws DataAccessException; |
| | | public List getDataByAjaxBy42(String tabName,String fields,String where)throws DataAccessException; |
| | | public List getDataByAjax(ThreeJSON json, String where)throws DataAccessException; |
| | | public List getDataByAjaxBy42(String tabName, String fields, String where, int limit, int page,String orderBy,int formid)throws DataAccessException; |
| | | /** |
| | | * 通过调用用户定义函数返回内容 |
| | | * @return Page --分页类 |
| | |
| | | * 取得自动编号 ---1类型 |
| | | * @param formid --------功能号 |
| | | * @param type ---------自动编号类型,取值=1 |
| | | * @param field --------哪个字段需要自动编号 |
| | | * @param length -------长度 |
| | | * @param perc -------前缀字符 |
| | | * **/ |
| | | public String getAutoCode(int formid,int type,String field,int length,String perc); |
| | | public String getAutoCode(int formid,int type,String field); |
| | | /** |
| | | * 根据表名取得表主键名 |
| | | * @param String tableName 表名 |
| | |
| | | * 根据功能号取得主从表名称 -----9801信息---增加新窗体类型都需要增加相应判断 |
| | | * **/ |
| | | public String getTableName(int formid,String winType); |
| | | public String getTableNameV2(SqlRowSet gform,String winType); |
| | | public String getExcludeTablesWhenSaving(int formid); |
| | | /** |
| | | * 取得功能号的过账类型号 |
| | | * **/ |
| | |
| | | |
| | | public List<TableColumnsDataTypeEntity> getTableColumnsDataTypes(int formid, int isDetailTable, String fieldids); |
| | | public List<String> getParm(String sql, List<String> temp, SqlRowSet row); |
| | | public String[] prossParm(SqlRowSet row, String temp, List<String> sq, int index, Map<String, String> map, Map<String, String> sessionClone, String tableName, int type); |
| | | public String[] prossParm(SqlRowSet row, String temp, List<String> sq, String index, Map<String, String> map, Map<String, String> sessionClone, String tableName, int type); |
| | | public String proccTbCols(Page page); |
| | | |
| | | String getTableNameByType(SqlRowSet gform, String winType); |
| | | String getTableNameByType(GformEntity gformEntity, String winType); |
| | | |
| | | /** |
| | | * 获取表字段的元数据(名称,数据类型,长度,是否为计算列) |
| | |
| | | * @return |
| | | */ |
| | | Map<String,TableMetaData> getTableMetaData(String tableName); |
| | | |
| | | void doNewTran(Integer formid, String docCode,String userCode,String userName); |
| | | public String getFunctionParm(String st, String parms, Map<String, String> env); |
| | | } |