e-mail SYSTEM account Integration

Source: Internet
Author: User
Tags administrator password mail account sql server management sql server management studio

. NET ERP System e-mail system account Integration

In order to ensure the accurate and fast transmission of the information flow in ERP system, a message box mechanism is needed for the system design. When business operations occur in the system, it is necessary to remind the operators of the next link to ensure the rapid and accurate transmission of the ERP information flow. such as production task orders (work orders, processing orders, orders) after the completion of the post, you need to inform the warehouse preparation materials for the workshop picking material production. The interface of the message box is as follows:

The message box contains business notifications (Messages) and workflow Approvals (Workflow). Business notifications such as when a purchase order PO is issued by a purchaser, the warehouse personnel need to be notified to prepare the receipt. Workflow approval is a document process control based on approval.

In the implementation of the message box process, encountered a customer needs to send the message to the e-mail system, so wrote this article to share the implementation process.

The purpose of the customer is simple, and the message is sent to the appropriate mail account as well:

Implement part 1 to build an email server

There are several options:

1 mail server with Outlook Exchange Server is a good mail server, but the configuration is slightly more complicated.

2 Magic winmail, Winwebmail Free Edition can publish 50-100 accounts, exceeding this limit requires purchase authorization.

3 hMailServer Open Source, free, unlimited. A COM interface is available for two development.

Finally choose hMailServer as the mail server of ERP system. The configuration process is skipped here.

After installing hMailServer, create the domain name enterprisesolution.com and enable it.

2 Synchronizing account messages

Open the Synchronizer, as shown in, and then connect to the mail server after you enter the administrator password. This is the program that I called the COM interface to complete.

In this program, the ERP user's mail can be synced to the hMailServer account table.

Click the Sync button, open the ERP account selection form, and then click Confirm, the account in the ERP is synced to the hMailServer mail system.

To view hMailServer's account:

Development section

Here is a detailed explanation of how the above synchronization program is implemented, it is a simple C # call C + + COM interface program. hMailServer officially given the address of the COM Help document here: Https://www.hmailserver.com/documentation/v5.6/?page=com_objects

1 Read mail SYSTEM account

Create a connection to the Hmailsever server first

Private Domain hmailserverconnection ()
   string hmaildomain = Txtdomain.text;
   String hmailusername = "Administrator";
   string hmailpassword = txtPassword.Text;
   var objglobal = new ApplicationClass ();
   Objglobal.authenticate (Hmailusername, Hmailpassword);
   Return ObjGlobal.Domains.get_ItemByName (Hmaildomain);

Most of the time we interact with the interface object domain.

Then read the Account table data bound in the interface grid control.

DataTable table = new DataTable ("Table");
Table. Columns.Add ("Address", typeof (String));
Table. Columns.Add ("Password", typeof (String));
Table. Columns.Add ("Personfirstname", typeof (String));
Table. Columns.Add ("Personlastname", typeof (String));
_domain = Hmailserverconnection ();
Accounts Accounts = _domain. Accounts;
for (int i = 0; i < accounts. Count; i++)
      Account account = Accounts[i];
      DataRow datarow = table. NewRow ();
      datarow["Address" = account. Address;
      datarow["Password"] = account. Password;
      datarow["Personfirstname"] = account. Personfirstname;
      datarow["Personlastname"] = account. Personlastname;
      Table. Rows.Add (DataRow);
Gridaccount.autogeneratecolumns = false;
Gridaccount.datasource = table;

2 Adding mail accounts

Refer to the following code call

Domain domain = hmailserverconnection ();
Accounts Accounts = domain. Accounts;
Account mailbox = accounts. ADD ();
Mailbox. Address = email;
Mailbox. Password = Password;
Mailbox. Save ();

3 Clearing mail accounts

Refer to the following code

Accounts Accounts = _domain. Accounts;
int count = accounts. Count;
while (Count > 0)
      _domain. Accounts.delete (0);
_domain. Accounts.refresh ();

The COM interface provided by Hmailsever is x86 architecture, so I can only set the x86 compiler platform for this project.

4 Multi-lingual

This project also involves multi-language implementations, and I'm using a common method of translating the controls on the interface, referring to the following code.

public static void Translateform (Form form)
    String labelText = String. Empty;
    DataRow datarow = null;
    string translation = String. Empty;
    Switch (Application.CurrentCulture.LCID)
         Case 2052:
             Translation = "CHS";
         Case 1028:
         Case 3076:
         Case 5124:
                 Translation = "CHT";
foreach (Var label in getallcontrolsrecusrvive<label> (form))
    LabelText = label. Text.trim (). TrimEnd (': ');
    DataRow = Shared.TranslationTable.Rows.Find (LabelText);
    if (DataRow! = null)
        Label. Text = convert.tostring (Datarow[translation]);

I just need to call the method above in the form-loading event of each interface to complete the multilanguage feature.

protected override void OnLoad (EventArgs e)
    Base. OnLoad (e);
    Shared.translateform (this);

The interface translation is derived from the XML resource file embedded in the project.

Project source code file: Http://files.cnblogs.com/files/JamesLi2015/Synchronization.zip

Essay classification-ERP design and implementation is mainly devoted to the implementation, optimization and two development of ERP system of small and medium-sized enterprises discrete manufacturing. Has a wealth of ERP development and implementation experience, main products enterprise solution including invoicing, engineering, production, financial modules, can effectively help enterprises to carry out operational planning, reduce costs, timely delivery and improve product quality. Parsing large. NET ERP SYSTEM Account Integration Summary: To ensure the accurate and fast transmission of the information flow of ERP system, a message box mechanism is needed for the system design. When business operations occur in the system, it is necessary to remind the operators of the next link to ensure the rapid and accurate transmission of the ERP information flow. such as production task orders (work orders, processing orders, orders) after the completion of the post, you need to inform the warehouse preparation materials for the workshop picking material production. The message box interface looks like this: The message box contains business notifications (Messages) and workflow Approvals (Workflow). Business notifications such as purchase order PO issued by purchasing personnel, need ... Read the full text posted @ 2016-05-24 21:49 james Li Read (418) |  Comments (0)   Edit   Finance Module Function Summary: When the ERP financial module and production, When the supply chain module is integrated, these modules generate accounting vouchers when they are posted. If you can preview the voucher before generating the accounting voucher, it is a friendly design for the user. As shown in the credit notification slip before the account, you can preview the voucher to know the accounting documents that will be generated. Click the Preview voucher button to see the upcoming accounting vouchers: For this purpose, share the changes to the system. The first is the Business Document rewrite button event, protected override void O ... Read the full text posted @ 2016-05-10 23:02 james Li Read |  Comments (0)   edit   syntax tagging system in Workflow system Summary: Based on Microsoft's WF, In order to achieve the approval of the ERP and notification purposes, refer to the existing system technology, here to share the skills. Let's look at the final result, the workflow host in. In the above workflow definition, in addition to the workflow host (rehost) technology, the parsing challenges of the rule expression need to be resolved. The rule editor provided by. NET WF is code-based, but for a code-free development environment, you need to find an expression design, parsing specification. For example, at run time, we need to parse out the above according to the current running parameters ... Read the full posted @ 2016-05-09 23:30 jameS Li Reading (| ) Comments (0)   editing   General attachment Management Improvements Summary: In the BOM function, it is often necessary to use external image interpretation to get a deeper understanding of the BOM. For example, when we introduce the bill of materials, we use the following chart to help explain it: it's easy to understand. And this kind of picture and ERP in the BOM itself is not much, so the explanatory function of these images are put in the attachment. In the newly released ERP system, there are the following attachment management features to improve the 1 added DWG format Attachment browsing feature. Attachments in Auto CAD format can be viewed online. In some industries, the bill of materials comes ... Read the full text posted @ 2016-05-08 23:03 james Li Read |  Comments (0)   Edit  enterprise Solution Virtual Test Environment Summary: Without networking, a physical computer installs a database service, VMware creates multiple virtual machines, and multiple clients in the virtual machine connect to the physical host concurrently. can share the same physical host database, can also test multiuser concurrency and other issues. 1 Install the Microsoft Virtual network card. In the Control Panel, open Device Manager, select the network adapter, click the Action menu item in the menu bar, and select Add Obsolete Hardware menu. The menu item in the English environment is action-> ADD legacy hardware. Select the network adapter from the category and select ... Read the full text posted @ 2015-08-26 08:05 james Li Read (155) |  Comments (0)   edit   parse large. NET ERP system Lookup and Drillthrough Summary: The lookup lookup form is A container, you can also think of Textbox,button as a container, you can add a button to the container. Refer to the following implementation code to add a Find button to the textbox. var btn = new Button (); Btn. size = new Size (txtOutputPath.ClientSize.Height + 2); Btn. Location = new Point (t ... Read the full text posted @ 2015-08-25 08:46 james Li Reading (234) |  Comments (0)   editing   parsing of large. NET ERP System version Control Summary: Database versioning 1) Develop version control. Control multi-person simultaneous repairDatabase conflicts, use the SQL Source Control tool to do version management. SQL Server Management Studio supports version control tools like VSS and TFS as database scripts. For SQL Source Control, refer to the following address http:/... Read the full text posted @ 2015-08-24 08:03 james Li Read (1438) |  Comments (0)   Edit   Parse a large. NET ERP System Automatic Update summary: C/ S-schema applications require support for automatic updates, and when a new version of the program is released, the running client can detect the new version of the program and notify the user whether to download the update. Since the work has been involved in several Automatic Update module design and maintenance, the author summarizes the automatic Update module design and implementation. Auto Update component main content 1 version comparison. How the old version detects the new version, the version information is the assembly self-description, or a separate file to protect ... Read the full text posted @ 2015-08-22 08:01 james Li Read (1668) |  Comments (0)   Edit   parse the design and implementation of a large. NET ERP system Rights module Summary: The privilege module is one of the core modules of ERP system, and the perfect privilege control mechanism adds a lot to the system. Summarize the permissions modules I have contacted to enjoy the reader. 1 Concise definition of permissions ERP Authority management in a simple sentence: Who can do those things. The meaning of the sentence indicates who department + job responsibilities can not be tied to departmental posts, omit role definitions. Can (True) No (False) use 0 or 1,tr ... Read the full text posted @ 2015-08-21 08:04 james Li Read (2406) |  Comments (5)   edit   parse large. NET ERP System document encoding feature implementation summary: Document coding is an essential function of ERP system, which is used to generate serial numbers of various documents, often using the date and time characters to generate a unique document number. From the software point of view, it is to generate the primary key value of the data table (reference number), from the user's point of view, is to create coding specifications for business documents. Then do see the name, such as the sales order number is SO201508190001, the purchase order number is PO201 ... Read the full text posted @ 2015-08-19 09:47 james Li Read (1779) |  Comments (5)   Edit  Analysis of large. NET ERP System Document standards (add, modify, delete, copy, print) function Design Summary: The document of ERP system has standard function, here the document can be translated to bill,document,entry, have similar tool bar operation interface. By designing reusable base classes, subclasses only need to inherit the base class form to complete the design of the document function. First look at the standard Sales contract document interface: This article through the Sales Contract document function, in turn, explain programming points for reference. 1 new Insert form has two kinds ... Read the full text posted @ 2015-08-18 07:54 james Li Read (2709) |  Comments (5)   Edit  windows 10 Deployment of enterprise solution 5.5 Summary: After the release of Windows 10, the new operating system has brought many changes. Now the newly purchased PC installed system should be Windows 10. The first thing to do when the user is not accustomed to Windows 7 to buy a new computer is to reload XP, and it is estimated that the current Windows 10 new user also has this impulse (install Windows 7). Changes in the interface need some time ... Read the full text posted @ 2015-08-18 07:53 james Li Read (349) |  Comments (1)   edit   parse large. NET ERP system Design exception handling module Summary: Exception handling module is a large system must be a component, well-designed exception handling module can improve the robustness of the system. Let's talk about all aspects of exception handling from the perspective I understand. My design is only limited to Windows Forms for reference. 1 Defining the exception type the. NET framework defines a number of exception types, and in the ERP system we add some custom exception types based on actual needs. Database Access Exception ... Read the full text posted @ 2015-08-14 07:58 james Li Read (430) |  Comments (1)   edit   parse large. NET ERP system business logic Design and implementation summary: According to the experience of manufacturing software development in recent years, the author gives a brief description of how the function (Feature) is designed and implemented in view of the understanding of the developer, for reference. Depending on the architecture, the technical implementation will vary, and my experience is limited to the Windows Form program. The overall feature 1 system supports multiple users. Create a single-instance (Singleton) Session Manager SessioNmanager ... Read the full text posted @ 2015-08-13 08:24 james Li Read (1865) |  Comments (2)   edit   parse large. NET ERP System Multi-language Implementation summary: There are many implementations of implementing multi-languages, no more than a string substitution technique, which replaces the text label of the interface control with the text of the corresponding language.. NET Windows Forms implements multiple languages in the following ways: 1. NET scheme, using resource files to do three language resource files, such as string.resx,string.zh-cn.resx,string ... Read the full text posted @ 2015-08-12 07:52 james Li Read (2338) |  Comments (7)   Edit  enterprise Solution Managing the Software development Framework process Summary: 1 define the module and function execution system function (SAUTSF) to add the function Samfem,employee master to the system Master File SAMF module. Assign permissions to the user groups that have permissions, including new, delete, modify, print, and post permissions, which are functional permissions for the SAMFEM. If you need to increase the field permissions, such as can edit ... Read the full text posted @ 2015-08-11 07:54 james Li Read (1097) |  Comments (0)   edit   parse large. NET ERP system data Audit features Summary: Data audit, English expression is audit, it is the process of tracking data change, recording the value before and after the data change, for reference analysis. By setting up, ERP can track changes in all fields of a table, or only the value of a specified field can be recorded. European and American companies each year have an independent audit department, from the general manager to the lower section of the staff, a review of the past economic business of the book data and the actual consistency. The audit function in ERP, usually ... Read the full text posted @ 2015-08-10 07:56 james Li Read |  Comments (0)   edit   parse large. NET ERP System 13 Interface Design Patterns Summary: The interface of the mature ERP system should be copied from the template, and the interface of all kinds of functions can be followed regularly. Software interface Design modelling or artistic creation, I recognize the former, modeled interface customers easy extrapolate, reducing the learning threshold. In addition to some small part of the functional interface design special, most of the ERP functions of the interface are similar. In my contact and design of ERP system, summed up the common interface design patterns for readers ... Read the full text posted @ 2015-08-08 07:55 james Li Read (2658) |  Comments (5)   Edit   Enterprise resource planning software Business Knowledge Point compilation Summary: 1. Change recording function: The change mode of "audit" is adopted for Po,so,jo,bom, which can record the change history of the operator. 2. The system has a simple file management system. All basic information, documents, can be uploaded to download the corresponding documents. 3. Define 10 Alternate fields: Built-in 20 alternative fields, you can define its name according to the actual management needs of the enterprise, such as defining an alternate field 1: material; Alternate fields ... Read the full text posted @ 2015-08-07 17:34 james Li Read (268) |  Comments (0)   edit   parse large. NET ERP system interface and Logical separation summary: Windows The key to the interface and logic separation of the forms program is the data binding technology, which is the same as the principle of the Microsoft-launched ASP, which separates the business code from the interface layer and improves the maintainability of the system. The main content of data binding data binding technology: Data source, control ... Read the full text posted @ 2015-08-07 08:04 james Li Read (2667) |  Comments (3)   edit   parse design and implementation of distributed application pattern for large. NET ERP System Summary: C/ S-architecture applications, transferring some of the complex computational logic from the client to the server side can improve performance while also for other controls. The. NET remoting performance is pretty good in LAN calls. The ERP system builds an application server (application Server) based on. NET Remoting and WCF. Distributed Application design goal: 1 customers ... Read the full text posted @ 2015-08-06 07:54 james Li Read (1868) |  Comments (6)   edit   parse large. NET ERP system Design general Microsoft Excel import feature Summary: Do business ManagementSoftware is hard to avoid working with Microsoft Excel, often software is done, and customers are asking for an Excel import feature. The ability to import Excel data is less difficult, from the values of Excel column data fields, to validating values, and then importing into database tables. However, has been doing repetitive work, wrote countless Excel import programs, each time just satisfied with the problem solved, and finally ... Read the full text posted @ 2015-08-04 07:57 james Li Read (2200) |  Comments (5)   edit   parse large. NET ERP System General Attachment management features Summary: Large systems have a common attachment management function, and it is best to use an attachment picture or an attachment document to represent a field that cannot be clearly expressed in a document. For example, the BOM attached a CAD drawing, the Sales order review function to add the customer's various forms, the general attachment function to the system to play a finishing touch. A schematic thousand words, first look at the interface design pattern, looks and the general data input function is same. The first is the design of accessories ... Read the full text posted @ 2015-08-03 07:55 james Li Read (2412) |  Comments (7)   edit   parse large. NET ERP System Flexible and complex interface controls Infragistics WinForms Summary: Infragistics is an excellent control provider for the. NET Platform, encompassing winforms,asp.net,silverlight,wpf,windows Phone, and all the interface controls on Microsoft. NET technology. These complex controls provide flexible operational capabilities for the ERP interface. This article does not discuss the control development, only detailed explains how the ERP system makes ... Read the full text posted @ 2015-07-31 07:57 james Li Read (2561) |  Comments (6)   edit   parse large. NET ERP system data Access Object Relational mapping framework Llbl Gen Pro Summary: Llbl Gen Pro is an object-relational mapping (ORM) framework designed for. NET developers that, like frameworks such as the nhibernate,entity framework, enables relational database persistence through mapping of entities to data tables. 1 Llbl Gen Pro Getting started Llbl Gen Pro Basic Open Llbl Gen Pro ... Read the full posted @ 2015-07-29 18:14 james Li Read (993) |  Comments (0)   Edit   Parse the bad taste of large. NET ERP System Code Summary: 1 Too many conventions and assumptions about user input configuration file in App. config, there is a configuration section that sets the report path: There is a sales report file Salesreport.rpt in the program, and calling this report in code may be written as: string salesreport= Reportpath + "Salesreport.rpt", because the end of the path is not reversed ... Read the full text posted @ 2015-07-29 07:53 james Li Read (2987) |  reviews   Edit   parse large. NET ERP System Core Components Query Designer Report Designer Form Designer Workflow Designer Task Scheduler Designer Summary: Enterprise management Software contains a number of common components that must be taken into account in each new project initiation phase. The core of the stability of the function, convenient system development and maintenance, but also for the system two times the development of a lot of convenience. For example, the general rights management system, general purpose attachment management, general query and other components, if the project is prepared before the development of these components, to ensure that the project on schedule delivery. Query Designer ... Read the full text posted @ 2015-07-27 08:01 james Li Read (3584) |  Comments (8)   edit   parse large. NET ERP systems for high quality. NET code Design pattern Summary: 1 cache caching system in a large number of use in the cache design mode, the system log in after the unchanged data cache, not directly read from the database. Consumes some memory, which is much more cost effective than reading the data again from SQL Server. The basic design pattern of the cache is referenced in the following code: private static Concurrentdictionary _cachedlooku ... Read the full text posted @ 2015-07-25 07:56 james Li Read (2617) |  Comments (7)   edit   parse large. NET ERP System 20 Database design Specifications Summary: Database design specification is a relatively low technical content of the topic, only need to adhere to the standards and norms can be achieved. When the system is more and more large, strictly control the database designers, and there is a specification book for the implementation of reference. In the framework of the program, there is also a mandatory agreement when not complying with the specification of the Times error. The following 20 clauses are the design conventions that I extracted from a large ERP system with more than 1000 database tables for reference. 1 ... Read the full text posted @ 2015-07-23 07:59 james Li Read (12209) |  Comments ($)   edit   parse large. NET ERP System Enterprise Informatization Executive Toolbox Summary: 1 First implementation meeting when the contract is signed, the software company and the customer agreed the meeting time, the two sides held the first implementation of the meeting, to determine the implementation of the team list, project implementation cycle, training schedule, implementation master plan, System preparation master file data preparation, software company technical support contact. 2 Project implementation Master planning system installation and testing: Business Research, demand matching analysis, discussion, and determine the main file data encoding scheme (material coding, B ... Read the full text posted @ 2015-07-22 11:32 james Li Read (766) |  Comments (0)   edit   parse large. NET ERP system Architecture Design framework+ Application Design Pattern Summary: My understanding of large-scale systems, from the number above, the source code more than millions of lines above, the system has more than 300 functions, from the quality of the system should have good scalability and maintainability, the function of the system is closely related. Apart from the complexity of the business, how to design such a well-coordinated system, build a developer base platform, has been my research direction. Soucecounter (Version 3.3.91 .... Read the full text posted @ 2015-07-20 07:48 james Li Read (4686) |  Comments (4)   edit   parse large. NET ERP systems forms, queries, reports two development summaries: The process steps of enterprise solution Two development are introduced in detail, including data input form (Entry form), query (Query/enquiry), report three important two development projects. Data entry Form Development Entry form when it comes to adding or adding a database table to a field, there are several main steps to developing a new functional interface ... Read full posted @ 2015-07-10 11:00 james Li Read (356) |  Comments (0)   edit   large. NET business software Code protection technologyCombining technique and practice to protect hard-to-create labor results Abstract: The code protection technology used to enumerate the various types of software encountered since the work, only the principle does not involve the implementation of technical details, in order to avoid the emergence of legal problems. Some friends say that the code directly on GitHub open source download, open source can promote technical exchanges and progress, but the valuable code is piled up in the hard disk, even if the bad code is sold a lot of money, won a lot of customers and the market. Cherish the love of their own written code, they are valuable wealth. ... Read the full text posted @ 2015-07-07 07:32 james Li Reading (6596) |  Comments (1)   editing   small and medium-sized ERP system development and implementation: Can reflect the various aspects of enterprise management and solve the actual problems of enterprises, not limited to the general problem of the solution, but in-depth business process 2. Behind this software there is a real management idea (not broadly speaking) and the essence of management understanding and induction, there is a whole more detailed planning and design ideas, can speak clearly 3. Medical batch tracking, validity period (near-effect tracking alarm) tracking, medicine warehouse location management, the national price policy ... Read the full text posted @ 2015-06-27 14:58 james Li Read (+) |  Comments (0)   Edit

E-mail system account integration

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.