codetypewritesql.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>
        CODE TYPE: Write SQL File
      </td>
    </table>

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

<%

	String action = "";
	if (request.getParameter("action") != null) {
		action = request.getParameter("action");
	}
	String codeTypeId = "";
	if (request.getParameter("codeTypeId") != null) {
		codeTypeId = request.getParameter("codeTypeId");
	}
	String codeTypeName = "";
	if (request.getParameter("codeTypeName") != null) {
		codeTypeName = request.getParameter("codeTypeName");
	} else {
		HashMap hashMap = new HashMap();
		hashMap.put("codeTypeId", codeTypeId);
		ModelEntity codeTypeME = delegator.getModelEntity("CodeType");
		GenericPK genericPk = new GenericPK(codeTypeME, hashMap);
		GenericValue codeTypeGV = delegator.findByPrimaryKey(genericPk);
		codeTypeName = codeTypeGV.getString("codeTypeName");
	}
	if (action.equals("showWriteSqlFile")) {
		String filePath = "c:\\ofbiz\\work\\ofbiz\\sfa\\sql\\code-" + codeTypeId + ".sql";

%>
      <form method="post" action="<ofbiz:url>/codeTypeWriteSql</ofbiz:url>" TARGET="headerFrame">
        <input type="hidden" name="codeTypeId" value="<%=codeTypeId%>">
        <input type="hidden" name="codeTypeName" value="<%=codeTypeName%>">
        <input type="hidden" value="writeSqlFile" name="action" >

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Code Type ID:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=codeTypeId%>
		 </TD>
        </TR>

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Code Type Name:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=codeTypeName%>
		 </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.writeCodeTypeFile (delegator, codeTypeId, filePath);
%>
        <TR>
		 <TD CLASS="freeFormSectionField" COLSPAN="2">
          <%=message%>
		 </TD>
        </TR>
<%
		return;
	}

%>

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