uientitywritesql.jsp

国外的一套开源CRM

<jsp:useBean id="uISQLFileWriter" class="com.sourcetap.sfa.ui.UISQLFileWriter" scope="application" />

<%@ include file="/includes/header.jsp" %>

    <table WIDTH="100%" CLASS="freeFormSectionTitleTable"><tr>
      <td>
        UI ENTITY: Write SQL File
      </td>
    </table>

    <table WIDTH="100%" HEIGHT="100%" CLASS="freeFormSectionDisplayTable">
<%

	String action = "";
	if (request.getParameter("action") != null) {
		action = request.getParameter("action");
	}
	String entityId = "";
	if (request.getParameter("entityId") != null) {
		entityId = request.getParameter("entityId");
	}
	String entityName = "";
	if (request.getParameter("entityName") != null) {
		entityName = request.getParameter("entityName");
	} else {
		HashMap hashMap = new HashMap();
		hashMap.put("entityId", entityId);
		ModelEntity uiEntityME = delegator.getModelEntity("UiEntity");
		GenericPK genericPk = new GenericPK(uiEntityME, hashMap);
		GenericValue uiEntityGV = delegator.findByPrimaryKey(genericPk);
		entityName = uiEntityGV.getString("entityName");
	}
	if (action.equals("showWriteSqlFile")) {
		String filePath = "c:\\ofbiz\\work\\ofbiz\\sfa\\sql\\ui-e-" + entityName.replace(' ', '_') + ".sql";

%>
      <form method="post" action="<ofbiz:url>/uiEntityWriteSql</ofbiz:url>" TARGET="headerFrame">
        <input type="hidden" name="entityId" value="<%=entityId%>">
        <input type="hidden" name="entityName" value="<%=entityName%>">
        <input type="hidden" value="writeSqlFile" name="action" >

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Entity ID:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=entityId%>
		 </TD>
        </TR>

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Entity Name:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=entityName%>
		 </TD>
        </TR>

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  File Path:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <input MAXLENGTH=100 SIZE=80 type="text" name="filePath" value="<%=filePath%>">
		 </TD>
        </TR>

        <TR>
		 <TD CLASS="freeFormSectionSaveButtonArea" COLSPAN="2">
          <input type="submit" value="Write File" >
		 </TD>
        </TR>

      </FORM>
     </TABLE>
<%

		return;
	}

	if (action.equals("writeSqlFile")) {
		String filePath = request.getParameter("filePath");
		String message = uISQLFileWriter.writeUiEntityFile (delegator, entityId, filePath);
%>
        <TR>
		 <TD CLASS="freeFormSectionField" COLSPAN="2">
          <%=message%>
		 </TD>
        </TR>
<%
		return;
	}


%>

<%@ include file="/includes/footer.jsp" %>