使用c＃进行ERP开发 - SQL Server [英] ERP Development using c# - SQL Server

问题描述

亲爱的会员，



我将为我的组织开发一个ERP系统。我的ERP涉及多个用户和4个模块。



我需要指导方针来开发这个系统。该系统将是WinForm基础应用程序。



数据库调用在所有表单和报告中应该是异步的。



数据库已经设计好并且要开发UI。



请提供满足我要求的任何帮助。





感谢所有。

解决方案

从这里开始：< a href =http://www.vkinfotek.com/erp/erp-software-development.html> ERP软件开发 [ ^ ]

ERP开发是一个广泛的主题，包括：

- 业务要求

- 技术要求

- ...



这是一个非常在像这样的论坛中回答难以回答的问题。下次尝试询问具体问题。

可以帮助你。



参考网站：http：//www.vkinfotek .com / develop-erp-asp-software-contents.html



章：1。简介。



.Net Framework 3.5

创建ASP.Net 3.5应用程序

ASP.Net 3.5中的代码模型

单文件页面模型

代码隐藏页面模型

哪个型号更好？

单个文件页面的优点

代码的优点-Behind Pages

ASP.NET页面语法

ASP.Net服务器控件概述

标准控件

数据控件

验证控件

导航控件

登录控件

HTML控件

ASP .NET AJAX扩展控件

WebParts

如何将页面中的多个控件连接到同一个事件处理程序

使用ListBoxes和DropDown列表

Cre多选列表框

在单选ListBox控件中获取所选项

在多选ListBox控件中获取所选项

ListBox控件的SelectedIndexChanged事件

创建ListItem对象并使用Add（）方法将它们添加到Control中

从特定位置删除项目

从多选ListBox控件中删除项目

使用CheckBoxes和RadioButtons

使用单选按钮单击事件获取RadioButton控件中的Selected Item

复选框控件

RadioButtonList和CheckBoxList控件

从CheckBoxList控件中获取所选项目

验证控件

RequiredField Validator

ErrorMessage属性

使用带有TextBox控件的RequiredFieldValidator的InitialValue属性

使用RequiredFieldValidator的InitialValue属性和DropDownList控件$

显示属性

启用属性

EnableClientScript属性

CompareValidator控件

执行数据类型检查

RangeValidator控件

正则表达式验证器控件

CustomValidator控件

客户端验证

ValidationSummary Control

使用验证组

如何使用单个按钮验证多个验证组

章：2 ASP.Net 3.5中的数据访问。

SqlDataSource控件

如何使用SqlDataSource控件连接到SQL Server数据库

创建一个SqlDataSource控件声明性地

在Web.config文件中存储连接字符串

使用SqlDataSource控件执行数据命令

将ListBox控件绑定到SqlDataSource控件

设置DataSouceMode属性

SqlDataSource控件事件

使用参数带有SqlDataSource控件的文件

ASP.Net参数对象的属性

SqlDataSource控件集合

如何在执行select命令之前设置SqlDataSource的参数

使用ASP.Net ControlParameter对象

GridView控件概述

GridView控件的属性

GridView事件

GridView方法

使用SqlDataSource控件在GridView控件中显示，编辑和删除数据

GridView控件中的程序化数据绑定

格式化GridView控件

使用CSS格式化GridView控件

使用带GridView控件的字段

使用BoundFields

如何使用DataFormatString属性格式化日期和货币列

使用命令字段

使用模板字段

如何使用Eval（）和Bind（）方法

使用EditItemTempl在GridView中编辑时显示DropDownList ate

如何使用FooterTemplate使用GridView控件将新数据插入数据库

如何限制使用GridView SelectedIndexChanging事件选择项目

DetailsView和FormView控件

使用DetailsView控件中的字段

在DetailsView控件中使用样式元素

创建DetailsView控件

使用DetailsView控件进行数据绑定

使用DataSourceID属性

使用DataSource属性

DetailsView属性

DetailsView活动

使用DetailsView中的命令按钮

在DetailsView控件中使用模板

如何使用GridView和DetailsView控件创建Master - Detail页面< br $>
FormView控件

FormView与DetailsView控件

如何使用FormView控件更新和插入数据

章： 3. ERP应用程序架构

多层Archit的好处结论

表达层的目的

业务层的目的

数据访问层的目的

数据层的用途

使用Visual Studio创建Web ERP应用程序框架

为数据访问层创建类库

为业务层创建类库

为表示层创建Web应用程序

用C语言开发数据访问层

创建DataServer类

构造函数DataServer类

DataServer类方法

母版页介绍

创建ERP Web应用程序的母版页

如何在主页面上放置菜单控件

章：4。开发财务模块

财务模块中的业务流程

表示层财务模块

创建账户

设计和编程AccountsDialog.aspx

管理ASP .Net使用Server.Transfer方法导航

使用Server.Transfer方法将参数发送到另一个页面

设计和编程AccountsForm.aspx

将DropDownList控件绑定到ObjectDataSource控件

使用ObjectDataSource的SelectMethod属性

ObjectDataSource的TypeName属性

ObjectDataSource的OnSelecting属性

导入业务层的命名空间

使用Request.QueryString在Page_Load（）事件中检索查询字符串值

使用选择事件设置ObjectDataSource的参数 - ObjectDataSource1_Selecting

保存帐户详细信息

创建业务对象 - Account.cs

检索组

与DataAccessLayer交互的步骤

保存帐户详细信息

将AccountForm连接到菜单

使用AccountsForm.aspx创建客户，供应商，银行和一般帐户

Char帐户

Accounts.aspx的设计和编程图表

在ChartofAccounts.aspx上放置TreeView控件

填充根级别节点Page_Load（）事件

填充给定节点的子节点

编程TreeNodePopulate事件

创建业务对象 - Group.cs
返回主要组别

仅返回特定组下的子组

为日记帐凭证交易设计JournalForm.aspx

设计JournalForm.aspx的步骤

创建和设置GridView控件的重要属性和方法

使用asp：TemplateField元素在GridView控件中创建模板列

ItemTemplate

EditItemTemplate

页脚模板

为JV中的AccountName列创建一个模板列

为JV中的Debit列创建一个Template列

为Cre创建一个Template列JV中的dit列

为插入按钮创建模板列

创建删除命令按钮和编辑命令按钮

创建EmptyDataTemplate以在数据源为空时接受第一行数据

如何在表单上放置ObjectDatasource控件，交易号，信用卡和借记卡列的日期和总计

如何在GridView控件中插入多个帐户

编写JournalForm.cs的步骤

为GridView构建DataTable结构

编程用于将DataTable绑定到GridView控件的Page_Load事件

编写添加新记录按钮以使用EmptyDataTemplate向GridView添加新行数据

访问放置在EmptyDataTemplate

编写插入按钮，使用FooterTemplate向GridView添加新行数据

检索控件（DropDownList和TextBox控件）的值h在页脚模板中

从Session对象中检索现有帐户并分配给DataTable

将DataTable保存到会话中

获取来自特定单元格的值，这是一个TemplateField

编程EditCommand事件的事件处理程序

protected void grdAccounts_RowEditing（object sender，GridViewEditEventArgs e）

编程取消按钮

protected void grdAccounts_RowCancelingEdit（Object sender，GridViewCancelEditEventArgs e）

编写DeleteCommand事件的事件处理程序

protected void grdAccounts_RowDeleting（object sender，GridViewDeleteEventArgs e）

从DataTable中删除一行

提交对此DataTable所做的所有更改

将DataTable指定为DataSource到GridView并绑定GridView

要清除行的选择，我们以编程方式将SelectedIndex属性设置为-1

编程更新但是n

protected void grdAccounts_RowUpdating（object sender，GridViewUpdateEventArgs e）

编写保存账户借方金额总计的函数

编程检查双进入规则的程序

编程保存按钮

设计和编程凭证/收据交易

现金券

现金收据

支票凭证

支票收据

创建业务对象 - Transaction.cs

退货现金和银行账户

根据菜单选择返回账户

保存交易详情并在交易更新成功时返回布尔值

章：5。开发销售和采购模块

销售模块中的业务流程

设计和编程OrderForm.aspx以创建销售订单和采购订单

放置DropDownList控制并将其绑定到ObjectDataSource控件以显示cu stomer名称

如何在orderForm.aspx中插入多个项目

在订单中执行验证表格

保存销售订单/采购订单
更新订单详情

编程计算订单总额的功能

编程计算订单净额的功能

设计和编程订单Grid.aspx

挑选和包装销售订单

挑选运费订单

退货订单

待定采购订单

设计和编程InvForm.aspx

编程计算发票总额的函数

编写检查双重录入规则的程序

编程保存按钮

使用TextChanged事件验证放置在页脚中的TextBox控件

使用TextChanged事件验证放置在EmptyDataTemplate中的TextBox控件

编程采购发票

编程销售发票

程序现金销售

编程现金购买

编程购买退货

编程销售退货

商业对象 - 贸易

检索客户/供应商账户

从数据库中检索交易账户

检索折扣，运费和税务账户

保存交易详情

章：6。开发库存模块

库存模块中的业务流程

设计和编程ItemForm.aspx以创建不同的物品类型 - 原材料，消耗品，子装配或成品

设计和编程MaterialIssueForm.aspx以发布制造产品的组件

库存模块的业务层

业务对象 - Item.cs

从数据库中检索股票组

检索项目类型

保存项目详细信息

业务对象 - 问题

返回有关罪的信息gle工作单

保存问题详情

章：7。开发制造模块

制造模块中的业务流程

设计和编程BOMForm.aspx以创建物料清单

设计和编程WorkOrderForm.aspx用于创建工单

制造模块的业务层

Business Objects - BOM

返回所有商品的信息

返回产品列表

返回父品的组件

保存产品结构

使用BOMForm.aspx创建产品结构

使用BOMDisplay.aspx显示产品结构

Business Objects - WorkOrder
产品名称返回

返回制造一个父项目（产品）所需的组件及其数量的信息

保存工单详细信息

Dear Members,

I am going to develop an ERP system for my Org. There are several users and 4 modules involved in my ERP.

I need guidelines to develop this system. the system will be WinForm base app.

The database calls should be asynchronous in all the forms and reports.

The database is already designed and UI is to be developed.

please provide any help which fulfills my requirements.


Thanks to all.

解决方案

Start from here: ERP software development[^]

ERP development is a broad topic which encompasses :
- Business requirements
- Technical requirments
- ...

This is a very hard question to answer in a forum like this. Try asking specific questions next time.

May be it help you.

Ref Site: http://www.vkinfotek.com/develop-erp-asp-software-contents.html

Chapter : 1. Introduction.

The .Net Framework 3.5
Create an ASP.Net 3.5 application
Code models in ASP.Net 3.5
Single-File Page Model
Code behind Page model
Which model is better?
Advantages of Single-File Pages
Advantages of Code-Behind Pages
ASP.NET Page Syntax
Overview of ASP.Net server controls
Standard Controls
Data Controls
Validation Controls
Navigation Controls
Login Controls
HTML Controls
ASP.NET AJAX Extensions Controls
WebParts
How to wire multiple controls in a page to the same event handler
Using ListBoxes and DropDown Lists
Creating Multiple-Selection List boxes
Get the selected Item in the single-selection ListBox control
Get the selected Items in the multiple-selection ListBox control
SelectedIndexChanged event of ListBox control
Creating ListItem objects and adding them to a Control using the Add() method
Removing Items from a specific location
Removing Items from a multiple-selection ListBox control
Using CheckBoxes and RadioButtons
Get the Selected Item in a RadioButton Control using Radio button click event
Check Box control
RadioButtonList and CheckBoxList controls
Get selected items from the CheckBoxList control
Validation Controls
RequiredField Validator
ErrorMessage Property
Using InitialValue property of RequiredFieldValidator with TextBox control
Using InitialValue property of RequiredFieldValidator with DropDownList control
Display Property
Enabled Property
EnableClientScript Property
The CompareValidator Control
Performing a Data type Check
RangeValidator Control
Regular Expression Validator Control
CustomValidator Control
Client-Side Validation
ValidationSummary Control
Using Validation Groups
How to use a single button to validate multiple validation groups
Chapter : 2. Data Access in ASP.Net 3.5.
The SqlDataSource control
How to Connect to a SQL Server Database Using the SqlDataSource Control
Creating a SqlDataSource control declaratively
Storing Connection String in Web.config file
Executing Data Commands with the SqlDataSource Control
Binding a ListBox Control to the SqlDataSource control
Setting DataSouceMode property
SqlDataSource control Events
Using parameters with SqlDataSource control
Properties of ASP.Net parameter objects
SqlDataSource control Collections
How to set SqlDataSource's parameters before the select command is executed
Using the ASP.Net ControlParameter Object
Overview of GridView control
Properties of GridView control
GridView Events
GridView Methods
Display, edit and delete data in the GridView control using SqlDataSource control
Programmatic DataBinding in a GridView Control
Formatting GridView control
Formatting GridView control with CSS
Using fields with the GridView control
Using BoundFields
How to Format date and currency column using DataFormatString property
Using Command Fields
Using Template Fields
How to use Eval() and Bind() method
Display a DropDownList when Editing in the GridView using EditItemTemplate
How to insert new data into the database with GridView control using FooterTemplate
How to restrict an item from being selected using GridView SelectedIndexChanging Event
DetailsView and FormView control
Using Fields in a DetailsView control
Using style elements in a DetailsView control
Creating a DetailsView control
Data Binding with the DetailsView Control
Using DataSourceID property
Using DataSource property
DetailsView Properties
DetailsView Events
Using Command buttons in DetailsView
Using Templates in a DetailsView control
How to create Master - Detail page by using GridView and DetailsView control
FormView control
FormView vs. DetailsView control
How to use FormView control to update and insert data
Chapter : 3. ERP Application Architecture
Benefits of Multi-tier Architecture
Purpose of Presentation Layer
Purpose of Business Layer
Purpose of Data Access Layer
Purpose of Data Layer
Creating Web ERP Application Framework using Visual Studio
Creating a Class Library for the Data Access Layer
Creating a Class Library for the Business Layer
Creating a Web Application for the Presentation Layer
Developing Data Access Layer in C#
Creating DataServer Class
Constructor of the DataServer class
DataServer Class Methods
Introduction to Master pages
Creating a Master page for the ERP Web Application
How to place a Menu control on a Master page
Chapter : 4. Developing Finance Module
Business processes in Finance Module
Presentation Layer of Finance Module
Creation of Accounts
Designing and Programming the AccountsDialog.aspx
Managing ASP.Net Navigation using Server.Transfer method
Send a parameter to another page using Server.Transfer method
Designing and Programming the AccountsForm.aspx
Bind the DropDownList control to a ObjectDataSource control
Using SelectMethod property of ObjectDataSource
TypeName property of ObjectDataSource
OnSelecting property of ObjectDataSource
Import the namespace of Business Layer
Retrieve Query String Values in Page_Load() event using Request.QueryString
Set ObjectDataSource's parameters using Selecting event - ObjectDataSource1_Selecting
Save the Account Details
Creating Business Object - Account.cs
Retrieve Groups
Steps to interact with the DataAccessLayer
Save the Account details
Connecting AccountForm to the menu
Creating Customer, Supplier, Bank and General Account using the AccountsForm.aspx
Chart of Accounts
Designing and Programming Chart of Accounts.aspx
Placing a TreeView control on a ChartofAccounts.aspx
Populate the root level nodes in Page_Load() event
Populate the child nodes of a given node
Program the TreeNodePopulate event
Creating Business Object - Group.cs
Return main groups
Return only sub-groups under a particular group
Designing the JournalForm.aspx for the Journal Voucher Transaction
Steps to design the JournalForm.aspx
Create and set important properties and methods of the GridView control
Create Template columns in the GridView control using asp:TemplateField element
ItemTemplate
EditItemTemplate
Footer Template
Create a Template column for the AccountName column in the JV
Create a Template column for the Debit column in the JV
Create a Template column for the Credit column in the JV
Create a Template column for 'Insert' Button
Create a 'Delete' Command button and 'Edit' Command button
Create EmptyDataTemplate to accept first row of data when datasource is empty
How to place the ObjectDatasource control, Transaction number, Date and totals of Credit and Debit column amounts on the form
How to insert multiple accounts in the GridView control
Steps to program the JournalForm.cs
Building the DataTable Structure for the GridView
Program the Page_Load event to bind the DataTable to the GridView control
Program the Add New Record button to add a new row of data to the GridView using EmptyDataTemplate
Access the controls placed in the EmptyDataTemplate
Program the Insert button to add a new row of data to the GridView using FooterTemplate
Retrieve the values of controls (DropDownList and TextBox controls) which are in the Footer Template
Retrieve existing accounts from the Session object and assign to DataTable
Save the DataTable into a session
To get the value from a particular cell, which is a TemplateField
Program the Event handler for the EditCommand event
protected void grdAccounts_RowEditing(object sender, GridViewEditEventArgs e)
Program the Cancel button
protected void grdAccounts_RowCancelingEdit(Object sender, GridViewCancelEditEventArgs e)
Program the Event handler for the DeleteCommand event
protected void grdAccounts_RowDeleting(object sender, GridViewDeleteEventArgs e)
Delete a row from the DataTable
Commit all the changes made to this DataTable
Assign DataTable as DataSource to the GridView and bind the GridView
To clear the selection of a row, we set the SelectedIndex property programmatically to -1
Program the Update button
protected void grdAccounts_RowUpdating(object sender,GridViewUpdateEventArgs e)
Program the function which keeps a running total of the debit amounts of the accounts
Program the procedure for checking Double Entry rule
Program the Save button
Designing and Programming Voucher/ Receipts Transactions
Cash Voucher
Cash Receipt
Check Voucher
Check Receipt
Creating Business Object - Transaction.cs
Return Cash and Bank Accounts
Return Accounts based on menu selection
Save transaction details and return boolean value if transaction updation is successful
Chapter : 5. Developing Sales and Purchase Module
Business processes in Sales Module
Design and Program the OrderForm.aspx for creating Sales orders and purchase orders
Place the DropDownList control and bind it to the ObjectDataSource control to display customer names
How to insert multiple items in the orderForm.aspx
Perform Validations in order Form
Save Sales order /Purchase orders
Update Order details
Program the function which calculates the order total
Program the function for calculating order net amount
Designing and Programming ordersGrid.aspx
Pick and Pack Sales orders
Pick Shipping orders
Back orders
Pending Purchase orders
Designing and Programming InvForm.aspx
Program the function which calculates the invoice total
Program the procedure for checking Double Entry rule
Program the Save button
Validate the TextBox control placed in the Footer using TextChanged event
Validate the TextBox control placed in the EmptyDataTemplate using TextChanged event
Programming Purchase Invoice
Programming Sale Invoice
Programming the Cash Sales
Programming the Cash Purchase
Programming Purchase Returns
Programming Sale Returns
Business Object - Trade
Retrieve Customer/Vendor Accounts
Retrieve Trade Accounts from the database
Retrieve Discount, Freight and Tax Accounts
Saving the Transaction details
Chapter : 6. Developing Inventory Module
Business processes in Inventory Module
Designing and programming the ItemForm.aspx for creating different types of items - Raw Material, Consumable, Sub Assembly or a Finished Product
Designing and programming the MaterialIssueForm.aspx to issue components to manufacture products
Business Layer of Inventory Module
Business Object - Item.cs
Retrieve Stock Groups from database
Retrieve Item types
Save the Item details
Business Object - Issue
Return information about single Work order
Saving Issue details
Chapter : 7. Developing the Manufacturing Module
Business processes in Manufacturing Module
Designing and Programming BOMForm.aspx for Creating Bill of Materials
Designing and Programming WorkOrderForm.aspx for creating work orders
Business Layer of Manufacturing Module
Business Objects - BOM
Return information about all Items
Return list of Poducts
Return Components for a parent Item
Save Product Structure
Create product structures using BOMForm.aspx
Display product structures using BOMDisplay.aspx
Business Objects - WorkOrder
Return names of Products
Return Information about Components and their Quantities which are required to manufacture one parent item (product)
Save Work Order details

这篇关于使用c＃进行ERP开发 - SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！