Text message module of OA (I)

Preface

I am too busy recently. I don't have time to write a blog, and I find that there is no topic to write. take out the current modules to earn click-through rates. I also responded with a piece of information written by my colleagues in the company, but refused to explain the principle to us. in fact, this is very simple ..

Purpose

1. It can be used in OA, instant messaging, and warning systems.

2. You can also write components for other modules to call, such as workflows.

Introduction to mobile phone technology development

1. SP service provider. currently, mobile, telecom, and China Unicom all have their own short message service agencies. You only need to buy services from them, and they will provide technical materials, gateways, and accounts. there are three methods available for development:

One is provided through APIS. You only need to apply the DLL files they provide to the project. call the sending method. I personally think it encapsulates the services accessed by the gateway.

Second, in the database mode, you only need to install the engine they provide, configure ODBC, and configure the upstream and downstream tables (send) in the database as required ). Text messages written to the following table are automatically sent.

Third, I forgot ............

2. The hardware SMS cat can go to some companies to buy the SMS cat. They will provide software and hardware, connect to the mobile phone, connect to the computer, and then send text messages.

3. Some website text message WebServices. Some websites provide some services to common developers. They are free of charge, just like Sina. You can check it online.

4. There is another kind of code that I can't remember. It seems to be complicated and I don't understand.

Technology

1. C # development language.

2. Asp.net developed Web

3. Ado.net, that is, writing a database

4. sms sp this article mainly targets SP writing database development.

Application Environment

It is mainly used by the company to clerks of each department, send internal or external mails to the department, and manage the address book of employees of the Department.

Module functions

1. The address book module is mainly the Organization module of the company. This module is not required if it is available.

2. The company organization module is used to select a department or job type during group sending.

3. The Personal Address Book module is used to manage non-company or personal contacts.

4. Address Book directory permission authorization

5. The SMS module can send and receive text messages,

6. Send Group SMS messages

7. timed sending, which must be written by yourself.

8. SMS management and fee statistics.

Database

I wanted to use the relational database diagram, but unfortunately it was not supported by 2000. Ah!
1. Organize a directory table, which is a tree table used to store the organizational structure

Create table [dbo]. [SmsGroup] (
[Id] [int] IDENTITY (1, 1) not null,
[Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS not null,
[ParentID] [int] NOT NULL
)

2. A user table that stores users should be used in a complete OA system.

Code
Create table [dbo]. [SmsUser] (
[Id] [varchar] (50) COLLATE Chinese_PRC_CI_AS not null,
[Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS not null,
[Job] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Position] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Fix] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Qq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Msn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[Status] [int] not null,

)

3. the downstream table used for engine scanning, that is, the text message table. One field indicates the status of the text message.

Code
Create table [dbo]. [SmsSend] (
[Uninstand] [uniqueidentifier] not null,
[Id] [decimal] (18, 0) IDENTITY (1, 1) not null,
[To] [varchar] (20) COLLATE Chinese_PRC_CI_AS not null,
[Content] [varchar] (160) COLLATE Chinese_PRC_CI_AS not null,
[Status] [int] NOT NULL
)

4. The text message management table is used to provide users with management of sent text messages and statistics of text messages. You can also click a resend. Haha!

Code
Create table [dbo]. [SmsList] (
[Uninstand] [uniqueidentifier] not null,
[To] [varchar] (2000) COLLATE Chinese_PRC_CI_AS not null,
[Date] [datetime] not null,
[UserID] [varchar] (20) COLLATE Chinese_PRC_CI_AS not null,
[Status] [int] NOT NULL
)

5. The organization and user table are used to build the organization directory tree. The number of users under a department is different.

Create table [dbo]. [SmsGroupUser] (
[GroupID] [int] not null,
[UserID] [varchar] (50) COLLATE Chinese_PRC_CI_AS not null,
[SysID] [int] IDENTITY (1, 1) NOT NULL
)

6. User-defined tables are used to store user-defined contacts.

Code
Create table [dbo]. [SmsMyUser] (
[UserID] [varchar] (20) COLLATE Chinese_PRC_CI_AS not null,
[Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[SysID] [int] IDENTITY (1, 1) not null,
[Remark] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
)

7. frequently-used phrase table, used to store users' frequently-used text message tables

Create table [dbo]. [SmsWords] (
[UserID] [varchar] (20) COLLATE Chinese_PRC_CI_AS not null,
[Content] [varchar] (2000) COLLATE Chinese_PRC_CI_AS not null,
[SysID] [int] IDENTITY (1, 1) NOT NULL
)

Another table is used to send text messages on a regular basis. Because the engine provided by sp does not have this function, I need to write it myself, which is very simple.
Conclusion
The night is quiet, sleepy, put off the lights, and embrace Zhou Gong.
Next, I will cut out the interface and show it to you. It's a simple module that makes everyone laugh.