msetup.java

Java写的ERP系统

			sqlCmd = new StringBuffer ("INSERT INTO AD_Sequence ");
			sqlCmd.append("(AD_Sequence_ID,").append(m_stdColumns).append(",");
			sqlCmd.append("Name,IsAutoSequence,IncrementNo,StartNo,CurrentNext,");
			sqlCmd.append("CurrentNextSys,IsTableID) VALUES (");
			sqlCmd.append(AD_Sequence_ID).append(",").append(m_stdValues).append(",");
			sqlCmd.append("'").append(Name).append("','Y',1,").append(StartNo).append(",").append(StartNo).append(",");
			sqlCmd.append(StartNo/10).append(",'N')");
			int no = DB.executeUpdate(sqlCmd.toString());
			if (no != 1)
				Log.error("MSetup.createDocType - Sequence NOT created - " + Name);
		}

		//  Get Document Type
		int C_DocType_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_DocType");
		sqlCmd = new StringBuffer ("INSERT INTO	C_DocType ");
		sqlCmd.append("(C_DocType_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("Name,PrintName,DocBaseType,DocSubTypeSO,");
		sqlCmd.append("C_DocTypeShipment_ID,C_DocTypeInvoice_ID,");
		sqlCmd.append("IsDocNoControlled,DocNoSequence_ID,GL_Category_ID,");
		sqlCmd.append("IsPrinted,IsTransferred,DocumentCopies,IsSOTrx)");
		//
		sqlCmd.append(" VALUES (").append(C_DocType_ID).append(",").append(m_stdValues).append(",");
		//  Name,PrintName,DocBaseType,DocSubTypeSO,
		sqlCmd.append("'").append(Name).append("','").append(PrintName).append("','").append(DocBaseType).append("',");
		if (DocSubTypeSO == null || DocSubTypeSO.length() == 0)
			sqlCmd.append("NULL,");
		else
			sqlCmd.append("'").append(DocSubTypeSO).append("',");
		//  C_DocTypeShipment_ID,C_DocTypeInvoice_ID,
		if (C_DocTypeShipment_ID == 0)
			sqlCmd.append("NULL,");
		else
			sqlCmd.append(C_DocTypeShipment_ID).append(",");
		if (C_DocTypeInvoice_ID == 0)
			sqlCmd.append("NULL,");
		else
			sqlCmd.append(C_DocTypeInvoice_ID).append(",");
		//  IsDocNoControlled,DocNoSequence_ID,GL_Category_ID,
		if (AD_Sequence_ID == 0)
			sqlCmd.append("'N',NULL,");
		else
			sqlCmd.append("'Y',").append(AD_Sequence_ID).append(",");
		sqlCmd.append(GL_Category_ID).append(",");
		//  IsPrinted,IsTransferred,DocumentCopies,IsSOTrx)
		sqlCmd.append("'Y',");
		if (DocBaseType.equals("SOO"))
			sqlCmd.append("'N',");
		else
			sqlCmd.append("'Y',");
		sqlCmd.append("0,");
		if (DocBaseType.startsWith("AR") || DocBaseType.equals("MMS") || DocBaseType.equals("SOO"))
			sqlCmd.append("'Y'");
		else
			sqlCmd.append("'N'");
		sqlCmd.append(")");
		int no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createDocType - DocType NOT created - " + Name);
		//
		return C_DocType_ID;
	}   //  createDocType

	/*************************************************************************/

	/**
	 *  Create Default main entities.
	 *  - Dimensions & BPGroup, Prod Category)
	 *  - Location, Locator, Warehouse
	 *  - PriceList
	 *  - Cashbook, PaymentTerm
	 *  @param C_Country_ID country
	 *  @param City city
	 *  @param C_Region_ID region
	 *  @return true if created
	 */
	public boolean createEntities (int C_Country_ID, String City, int C_Region_ID)
	{
		Log.trace(Log.l3_Util, "MSetup.createEntries", "C_Country_ID=" + C_Country_ID + ", City=" + City + ", C_Region_ID=" + C_Region_ID);
		m_info.append("\n----\n");
		//
		String defaultName = Msg.translate(m_lang, "Standard");
		String defaultEntry = "'" + defaultName + "',";
		StringBuffer sqlCmd = null;
		int no = 0;

		//	Create Marketing Channel/Campaign
		int C_Channel_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_Channel");
		sqlCmd = new StringBuffer("INSERT INTO C_Channel ");
		sqlCmd.append("(C_Channel_ID,Name,");
		sqlCmd.append(m_stdColumns).append(") VALUES (");
		sqlCmd.append(C_Channel_ID).append(",").append(defaultEntry);
		sqlCmd.append(m_stdValues).append(")");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - Channel NOT inserted");
		int C_Campaign_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_Campaign");
		sqlCmd = new StringBuffer("INSERT INTO C_Campaign ");
		sqlCmd.append("(C_Campaign_ID,C_Channel_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,Name,Costs) VALUES (");
		sqlCmd.append(C_Campaign_ID).append(",").append(C_Channel_ID).append(",").append(m_stdValues).append(",");
		sqlCmd.append(defaultEntry).append(defaultEntry).append("0)");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "C_Campaign_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - Campaign NOT inserted");
		if (m_hasMCampaign)
		{
			//  Default
			sqlCmd = new StringBuffer ("UPDATE C_AcctSchema_Element SET ");
			sqlCmd.append("C_Campaign_ID=").append(C_Campaign_ID);
			sqlCmd.append(" WHERE C_AcctSchema_ID=").append(C_AcctSchema_ID);
			sqlCmd.append(" AND ElementType='MC'");
			no = DB.executeUpdate(sqlCmd.toString());
			if (no != 1)
				Log.error("MSetup.createEntities - AcctSchema ELement Campaign NOT updated");
		}

		//	Create Sales Region
		int C_SalesRegion_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_SalesRegion");
		sqlCmd = new StringBuffer ("INSERT INTO C_SalesRegion ");
		sqlCmd.append("(C_SalesRegion_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,Name,IsSummary) VALUES (");
		sqlCmd.append(C_SalesRegion_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(defaultEntry).append("'N')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "C_SalesRegion_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - SalesRegion NOT inserted");
		if (m_hasSRegion)
		{
			//  Default
			sqlCmd = new StringBuffer ("UPDATE C_AcctSchema_Element SET ");
			sqlCmd.append("C_SalesRegion_ID=").append(C_SalesRegion_ID);
			sqlCmd.append(" WHERE C_AcctSchema_ID=").append(C_AcctSchema_ID);
			sqlCmd.append(" AND ElementType='SR'");
			no = DB.executeUpdate(sqlCmd.toString());
			if (no != 1)
				Log.error("MSetup.createEntities - AcctSchema ELement SalesRegion NOT updated");
		}

		/**
		 *  Business Partner
		 */
		//  Create BP Group
		int C_BP_Group_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_BP_Group");
		sqlCmd = new StringBuffer ("INSERT INTO C_BP_Group ");
		sqlCmd.append("(C_BP_Group_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,Name,IsDefault) VALUES ( ");
		sqlCmd.append(C_BP_Group_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(defaultEntry).append("'Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "C_BP_Group_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - BP Group NOT inserted");

		//	Create BPartner
		int C_BPartner_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_BPartner");
		sqlCmd = new StringBuffer ("INSERT INTO C_BPartner ");
		sqlCmd.append("(C_BPartner_ID,").append(m_stdColumns).append(",");
		sqlCmd.append("Value,Name,C_BP_Group_ID,IsSummary) VALUES (");
		sqlCmd.append(C_BPartner_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(defaultEntry).append(C_BP_Group_ID).append(",'N')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "C_BPartner_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - BPartner NOT inserted");
		//  Default
		sqlCmd = new StringBuffer ("UPDATE C_AcctSchema_Element SET ");
		sqlCmd.append("C_BPartner_ID=").append(C_BPartner_ID);
		sqlCmd.append(" WHERE C_AcctSchema_ID=").append(C_AcctSchema_ID);
		sqlCmd.append(" AND ElementType='BP'");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - AcctSchema Element BPartner NOT updated");
		createPreference("C_BPartner_ID", String.valueOf(C_BPartner_ID), 143);

		/**
		 *  Product
		 */
		//  Create Product Category
		int M_Product_Category_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "M_Product_Category");
		sqlCmd = new StringBuffer ("INSERT INTO M_Product_Category ");
		sqlCmd.append("(M_Product_Category_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,Name,IsDefault,PlannedMargin) VALUES (");
		sqlCmd.append(M_Product_Category_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(defaultEntry).append("'Y',0)");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "M_Product_Category_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - Product Category NOT inserted");

		//  UOM (EA)
		int C_UOM_ID = 100;

		//  TaxCategory
		int C_TaxCategory_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_TaxCategory");
		sqlCmd = new StringBuffer ("INSERT INTO C_TaxCategory ");
		sqlCmd.append("(C_TaxCategory_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Name,IsDefault) VALUES (");
		sqlCmd.append(C_TaxCategory_ID).append(",").append(m_stdValues).append(", ");
		if (C_Country_ID == 100)    // US
			sqlCmd.append("'Sales Tax','Y')");
		else
			sqlCmd.append(defaultEntry).append("'Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - TaxCategory NOT inserted");

		//  Tax - Zero Rate
		int C_Tax_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_Tax");
		sqlCmd = new StringBuffer ("INSERT INTO C_Tax ");
		sqlCmd.append("(C_Tax_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Name,Rate,C_TaxCategory_ID,C_Country_ID,TO_Country_ID,ValidFrom,IsDefault) VALUES (");
		sqlCmd.append(C_Tax_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append("0,").append(C_TaxCategory_ID).append(",")
			.append(C_Country_ID).append(",").append(C_Country_ID)
			.append(",TO_DATE('01-JAN-1990'),'Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - Tax NOT inserted");

		//	Create Product
		int M_Product_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "M_Product");
		sqlCmd = new StringBuffer ("INSERT INTO M_Product ");
		sqlCmd.append("(M_Product_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,Name,C_UOM_ID,M_Product_Category_ID,C_TaxCategory_ID) VALUES (");
		sqlCmd.append(M_Product_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(defaultEntry);
		sqlCmd.append(C_UOM_ID).append(",").append(M_Product_Category_ID).append(",");
		sqlCmd.append(C_TaxCategory_ID).append(")");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no == 1)
			m_info.append(Msg.translate(m_lang, "M_Product_ID")).append("=").append(defaultName).append("\n");
		else
			Log.error("MSetup.createEntities - Product NOT inserted");
		//  Default
		sqlCmd = new StringBuffer ("UPDATE C_AcctSchema_Element SET ");
		sqlCmd.append("M_Product_ID=").append(M_Product_ID);
		sqlCmd.append(" WHERE C_AcctSchema_ID=").append(C_AcctSchema_ID);
		sqlCmd.append(" AND ElementType='PR'");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - AcctSchema Element Product NOT updated");

		/**
		 *  Warehouse
		 */
		//  Location (Company)
		int C_Location_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "C_Location");
		sqlCmd = new StringBuffer ("INSERT INTO C_Location ")
			.append("(C_Location_ID,").append(m_stdColumns).append(",")
			.append("City,C_Country_ID,C_Region_ID) VALUES (");
		sqlCmd.append(C_Location_ID).append(",").append(m_stdValues).append(",")
			.append("'").append(City).append("',").append(C_Country_ID).append(",");
		if (C_Region_ID != 0)
			sqlCmd.append(C_Region_ID).append(")");
		else
			sqlCmd.append("null)");
		DB.executeUpdate(sqlCmd.toString());
		sqlCmd = new StringBuffer ("UPDATE AD_OrgInfo SET C_Location_ID=");
		sqlCmd.append(C_Location_ID).append(" WHERE AD_Org_ID=").append(AD_Org_ID);
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - Location NOT inserted");
		createPreference("C_Country_ID", String.valueOf(C_Country_ID), 0);

		//  Default Warehouse
		int M_Warehouse_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "M_Warehouse");
		sqlCmd = new StringBuffer ("INSERT INTO M_Warehouse ");
		sqlCmd.append("(M_Warehouse_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,Name,C_Location_ID,Separator) VALUES (");
		sqlCmd.append(M_Warehouse_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(defaultEntry).append(C_Location_ID).append(",'-')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - Warehouse NOT inserted");

		//   Locator
		int M_Locator_ID = DB.getKeyNextNo(AD_Client_ID, CompiereSys, "M_Locator");
		sqlCmd = new StringBuffer ("INSERT INTO M_Locator ");
		sqlCmd.append("(M_Locator_ID,").append(m_stdColumns).append(",");
		sqlCmd.append(" Value,M_Warehouse_ID,X,Y,Z,PriorityNo,IsDefault) VALUES (");
		sqlCmd.append(M_Locator_ID).append(",").append(m_stdValues).append(", ");
		sqlCmd.append(defaultEntry).append(M_Warehouse_ID).append(",0,0,0,50,'Y')");
		no = DB.executeUpdate(sqlCmd.toString());
		if (no != 1)
			Log.error("MSetup.createEntities - Locator NOT inserted");

		//  Update ClientInfo
		sqlCmd = new StringBuffer ("UPDATE AD_ClientInfo SET ");
		sqlCmd.append("C_BPartnerCashTrx_ID=").append(C_BPartner_ID);
		sqlCmd.append(",M_ProductFreight_ID=").append(M_Product_ID);
//		sqlCmd.append("C_UOM_Volume_ID=");
//		sqlCmd.append(",C_UOM_Weight_ID=");