smartadmin.core.urf
1.0.0
SmartAdmin.core.urf는 도메인 구동 설계 원리 및 패턴을 기반으로 완전하고 모듈 식 및 계층 소프트웨어 아키텍처를 제공합니다. 또한 비즈니스 수요의 핵심에 중점을두고, 복제 코딩을 줄이며, 주니어 프로그래머가 전문적이고 아름다운 웹 애플리케이션을 개발할 수 있도록이 아키텍처를 구현하는 데 필요한 인프라를 제공합니다.
도메인 구동 설계 (DDD)는 소프트웨어 코드 (클래스 이름, 클래스 메소드, 클래스 변수)의 구조와 언어가 비즈니스 도메인과 일치해야한다는 개념입니다. 예를 들어, 소프트웨어가 대출 애플리케이션을 처리하는 경우 대출 및 고객과 같은 클래스와 수용자 및 철수와 같은 방법이있을 수 있습니다. DDD는 구현을 진화하는 모델에 연결합니다. 도메인 중심 디자인은 다음과 같은 목표를 전제로합니다.
- 핵심 도메인 및 도메인 로직에 프로젝트의 주요 초점을 두는 행위;
- 도메인 모델에 복잡한 설계를 기본으로합니다.
- 특정 도메인 문제를 해결하는 개념적 모델을 반복적으로 개선하기 위해 기술과 도메인 전문가 간의 창의적 협업을 시작합니다.
사용자 이름 : 데모 비밀번호 : 123456 데모 (https://admin.i247365.net/)
당신이 좋아한다면 별 을주세요. 모든 별은 계속 업데이트하도록 격려하는 동기입니다.
SmartAdmin.core.urf DDD 디자인 패턴을 따라 응용 프로그램의 4 층 모델을 구현하십시오.
도메인 계층
- 엔티티 : (SmartAdmin.entity.csproj)
- 기본 클래스 "엔티티"상속, 생성 시간, 마지막 수정 시간 등과 같은 필요한 감사 클래스를 추가하십시오.
- 기본 키가 있어야하며 바람직하게는 그루이드 (복합 기본 키가 권장되지 않음)이 있어야하지만이 프로젝트는 증분 int 유형을 사용합니다.
- 필드가 너무 중복되지 않아야합니다. 협회 관계를 정의 할 수 있습니다.
- 현장 속성 및 메소드에 가상 키워드를 최대한 사용하십시오. 일부 ORM 및 동적 프록시 도구가 필요합니다
응용 프로그램 계층
하부 구조
- Visual Studio .NET 2019
- .NET 5.0.1
- SQL Server (LocalDB)
- 포함 = "automapper"버전 = "10.1.1"
- 포함 = "automapper.extensions.microsoft.dependencyInjection"버전 = "8.1.1"
- 포함 = "dotnetcore.cap"버전 = "3.1.2"
- 포함 = "dotnetcore.cap.dashboard"버전 = "3.1.2"
- 포함 = "dotnetcore.cap.rabbitmq"버전 = "3.1.2"
- 포함 = "dotnetcore.cap.sqlserver"버전 = "3.1.2"
- 포함 = "dotnetcore.npoi"버전 = "1.2.3"
- 포함 = "mapster"버전 = "7.1.5"
- 포함 = "mediatr"버전 = "9.0.0"
- 포함 = "mediatr.extensions.microsoft.dependencyInjection"버전 = "9.0.0"
- 포함 = "microsoft.aspnetcore.authentication.jwtbearer"버전 = "5.0.3"
- 포함 = "microsoft.aspnetcore.diagnostics.entityFrameworkCore"버전 = "5.0.3"
- 포함 = "microsoft.aspnetcore.identity.entityFrameworkCore"버전 = "5.0.3"
- 포함 = "microsoft.aspnetcore.identity.ui"버전 = "5.0.3"
- 포함 = "microsoft.aspnetcore.mvc.razor.runtimecompilation"version = "5.0.3"
- 포함 = "microsoft.aspnetcore.mvc.viewfeatures"version = "2.2.0"
- 포함 = "microsoft.aspnetcore.signalr"버전 = "1.1.0"
- 포함 = "Microsoft.entityFrameworkCore.Design"버전 = "5.0.3"
- 포함 = "Microsoft.entityFrameworkCore.sqlServer"버전 = "5.0.3"
- 포함 = "Microsoft.entityFrameworkCore.Tools"버전 = "5.0.3">
- 포함 = "microsoft.visualstudio.web.codegeneration.design"version = "5.0.2"
- 포함 = "nlog"버전 = "4.7.8"
- 포함 = "nlog.extensions.logging"버전 = "1.7.1"
- 포함 = "nlog.web.aspnetCore"버전 = "4.11.0"
- 포함 = "swashbuckle.aspnetCore"버전 = "6.1.0"
- 포함 = "system.data.sqlclient"버전 = "4.8.2"
- 포함 = "system.linq.dynamic.core"버전 = "1.2.8"
간단한 요구 사항부터 시작하십시오
회사 객체와 함께 CRUD, 수입 및 수출 기능을 개발하십시오
SmartAdmin.entity.csproj> 모델 New Company.cs 클래스
//Note: define the best practices of entity objects, inherit the base class, use the virtual keyword, and define every attribute, name, type, length, verification rule, index, default value, etc. as much as possible
namespace SmartAdmin . Data . Models
{
public partial class Company : URF . Core . EF . Trackable . Entity
{
[ Display ( Name = "企业名称" , Description = "归属企业名称" ) ]
[ MaxLength ( 50 ) ]
[ Required ]
//[Index(IsUnique = true)]
public virtual string Name { get ; set ; }
[ Display ( Name = "组织代码" , Description = "组织代码" ) ]
[ MaxLength ( 12 ) ]
//[Index(IsUnique = true)]
[ Required ]
public virtual string Code { get ; set ; }
[ Display ( Name = "地址" , Description = "地址" ) ]
[ MaxLength ( 128 ) ]
[ DefaultValue ( "-" ) ]
public virtual string Address { get ; set ; }
[ Display ( Name = "联系人" , Description = "联系人" ) ]
[ MaxLength ( 12 ) ]
public virtual string Contact { get ; set ; }
[ Display ( Name = "联系电话" , Description = "联系电话" ) ]
[ MaxLength ( 20 ) ]
public virtual string PhoneNumber { get ; set ; }
[ Display ( Name = "注册日期" , Description = "注册日期" ) ]
[ DefaultValue ( "now" ) ]
public virtual DateTime RegisterDate { get ; set ; }
}
}
//在 SmartAdmin.Data.csproj 项目 SmartDbContext.cs 添加
public virtual DbSet < Company > Companies { get ; set ; }프로젝트 SmartAdmin.service.csproj 추가 icompanyservice.cs , compolyservice.cs 구현 비즈니스 요구 사항 및 사용 사례
//ICompany.cs
//Create methods based on actual business use cases, the default CRUD, additions, deletions, and changes do not need to be defined
namespace SmartAdmin . Service
{
// Example: extending IService<TEntity> and/or ITrackableRepository<TEntity>, scope: ICustomerService
public interface ICompanyService : IService < Company >
{
// Example: adding synchronous Single method, scope: ICustomerService
Company Single ( Expression < Func < Company , bool >> predicate ) ;
Task ImportDataTableAsync ( DataTable datatable ) ;
Task < Stream > ExportExcelAsync ( string filterRules = "" , string sort = "Id" , string order = "asc" ) ;
}
} // implementation of the interface method
namespace SmartAdmin . Service
{
public class CompanyService : Service < Company > , ICompanyService
{
private readonly IDataTableImportMappingService mappingservice ;
private readonly ILogger < CompanyService > logger ;
public CompanyService (
IDataTableImportMappingService mappingservice ,
ILogger < CompanyService > logger ,
ITrackableRepository < Company > repository ) : base ( repository )
{
this . mappingservice = mappingservice ;
this . logger = logger ;
}
public async Task < Stream > ExportExcelAsync ( string filterRules = "" , string sort = "Id" , string order = "asc" )
{
var filters = PredicateBuilder . FromFilter < Company > ( filterRules ) ;
var expcolopts = await this . mappingservice . Queryable ( )
. Where ( x => x . EntitySetName == "Company" )
. Select ( x => new ExpColumnOpts ( )
{
EntitySetName = x . EntitySetName ,
FieldName = x . FieldName ,
IgnoredColumn = x . IgnoredColumn ,
SourceFieldName = x . SourceFieldName
} ) . ToArrayAsync ( ) ;
var works = ( await this . Query ( filters ) . OrderBy ( n => n . OrderBy ( sort , order ) ) . SelectAsync ( ) ) . ToList ( ) ;
var datarows = works . Select ( n => new
{
Id = n . Id ,
Name = n . Name ,
Code = n . Code ,
Address = n . Address ,
Contect = n . Contect ,
PhoneNumber = n . PhoneNumber ,
RegisterDate = n . RegisterDate . ToString ( "yyyy-MM-dd HH:mm:ss" )
} ) . ToList ( ) ;
return await NPOIHelper . ExportExcelAsync ( "Company" , datarows , expcolopts ) ;
}
public async Task ImportDataTableAsync ( DataTable datatable )
{
var mapping = await this . mappingservice . Queryable ( )
. Where ( x => x . EntitySetName == "Company" &&
( x . IsEnabled == true || ( x . IsEnabled == false && x . DefaultValue != null ) )
) . ToListAsync ( ) ;
if ( mapping . Count == 0 )
{
throw new NullReferenceException ( "没有找到Work对象的Excel导入配置信息，请执行[系统管理/Excel导入配置]" ) ;
}
foreach ( DataRow row in datatable . Rows )
{
var requiredfield = mapping . Where ( x => x . IsRequired == true && x . IsEnabled == true && x . DefaultValue == null ) . FirstOrDefault ( ) ?. SourceFieldName ;
if ( requiredfield != null || ! row . IsNull ( requiredfield ) )
{
var item = new Company ( ) ;
foreach ( var field in mapping )
{
var defval = field . DefaultValue ;
var contain = datatable . Columns . Contains ( field . SourceFieldName ?? "" ) ;
if ( contain && ! row . IsNull ( field . SourceFieldName ) )
{
var worktype = item . GetType ( ) ;
var propertyInfo = worktype . GetProperty ( field . FieldName ) ;
var safetype = Nullable . GetUnderlyingType ( propertyInfo . PropertyType ) ?? propertyInfo . PropertyType ;
var safeValue = ( row [ field . SourceFieldName ] == null ) ? null : Convert . ChangeType ( row [ field . SourceFieldName ] , safetype ) ;
propertyInfo . SetValue ( item , safeValue , null ) ;
}
else if ( ! string . IsNullOrEmpty ( defval ) )
{
var worktype = item . GetType ( ) ;
var propertyInfo = worktype . GetProperty ( field . FieldName ) ;
if ( string . Equals ( defval , "now" , StringComparison . OrdinalIgnoreCase ) && ( propertyInfo . PropertyType == typeof ( DateTime ) || propertyInfo . PropertyType == typeof ( Nullable < DateTime > ) ) )
{
var safetype = Nullable . GetUnderlyingType ( propertyInfo . PropertyType ) ?? propertyInfo . PropertyType ;
var safeValue = Convert . ChangeType ( DateTime . Now , safetype ) ;
propertyInfo . SetValue ( item , safeValue , null ) ;
}
else if ( string . Equals ( defval , "guid" , StringComparison . OrdinalIgnoreCase ) )
{
propertyInfo . SetValue ( item , Guid . NewGuid ( ) . ToString ( ) , null ) ;
}
else if ( string . Equals ( defval , "user" , StringComparison . OrdinalIgnoreCase ) )
{
propertyInfo . SetValue ( item , "" , null ) ;
}
else
{
var safetype = Nullable . GetUnderlyingType ( propertyInfo . PropertyType ) ?? propertyInfo . PropertyType ;
var safeValue = Convert . ChangeType ( defval , safetype ) ;
propertyInfo . SetValue ( item , safeValue , null ) ;
}
}
}
this . Insert ( item ) ;
}
}
}
// Example, adding synchronous Single method
public Company Single ( Expression < Func < Company , bool >> predicate )
{
return this . Repository . Queryable ( ) . Single ( predicate ) ;
}
}
}MVC 컨트롤러
namespace SmartAdmin . WebUI . Controllers
{
public class CompaniesController : Controller
{
private readonly ICompanyService companyService ;
private readonly IUnitOfWork unitOfWork ;
private readonly ILogger < CompaniesController > _logger ;
private readonly IWebHostEnvironment _webHostEnvironment ;
public CompaniesController ( ICompanyService companyService ,
IUnitOfWork unitOfWork ,
IWebHostEnvironment webHostEnvironment ,
ILogger < CompaniesController > logger )
{
this . companyService = companyService ;
this . unitOfWork = unitOfWork ;
this . _logger = logger ;
this . _webHostEnvironment = webHostEnvironment ;
}
// GET: Companies
public IActionResult Index ( ) => View ( ) ;
//datagrid 数据源
public async Task < JsonResult > GetData ( int page = 1 , int rows = 10 , string sort = "Id" , string order = "asc" , string filterRules = "" )
{
try
{
var filters = PredicateBuilder . FromFilter < Company > ( filterRules ) ;
var total = await this . companyService
. Query ( filters )
. AsNoTracking ( )
. CountAsync ( )
;
var pagerows = ( await this . companyService
. Query ( filters )
. AsNoTracking ( )
. OrderBy ( n => n . OrderBy ( sort , order ) )
. Skip ( page - 1 ) . Take ( rows )
. SelectAsync ( ) )
. Select ( n => new
{
Id = n . Id ,
Name = n . Name ,
Code = n . Code ,
Address = n . Address ,
Contect = n . Contect ,
PhoneNumber = n . PhoneNumber ,
RegisterDate = n . RegisterDate . ToString ( "yyyy-MM-dd HH:mm:ss" )
} ) . ToList ( ) ;
var pagelist = new { total = total , rows = pagerows } ;
return Json ( pagelist ) ;
}
catch ( Exception e ) {
throw e ;
}
}
//编辑
[ HttpPost ]
[ ValidateAntiForgeryToken ]
public async Task < JsonResult > Edit ( Company company )
{
if ( ModelState . IsValid )
{
try
{
this . companyService . Update ( company ) ;
var result = await this . unitOfWork . SaveChangesAsync ( ) ;
return Json ( new { success = true , result = result } ) ;
}
catch ( Exception e )
{
return Json ( new { success = false , err = e . GetBaseException ( ) . Message } ) ;
}
}
else
{
var modelStateErrors = string . Join ( " , ", this.ModelState.Keys.SelectMany(key => this.ModelState[key].Errors.Select(n => n.ErrorMessage)));
return Json ( new { success = false , err = modelStateErrors } ) ;
//DisplayErrorMessage(modelStateErrors);
}
//return View(work);
}
//新建
[ HttpPost ]
[ ValidateAntiForgeryToken ]
public async Task < JsonResult > Create ( [ Bind ( "Name,Code,Address,Contect,PhoneNumber,RegisterDate" ) ] Company company )
{
if ( ModelState . IsValid )
{
try
{
this . companyService . Insert ( company ) ;
await this . unitOfWork . SaveChangesAsync ( ) ;
return Json ( new { success = true } ) ;
}
catch ( Exception e )
{
return Json ( new { success = false , err = e . GetBaseException ( ) . Message } ) ;
}
//DisplaySuccessMessage("Has update a Work record");
//return RedirectToAction("Index");
}
else
{
var modelStateErrors = string . Join ( " , ", this.ModelState.Keys.SelectMany(key => this.ModelState[key].Errors.Select(n => n.ErrorMessage)));
return Json ( new { success = false , err = modelStateErrors } ) ;
//DisplayErrorMessage(modelStateErrors);
}
//return View(work);
}
//删除当前记录
//GET: Companies/Delete/:id
[ HttpGet ]
public async Task < JsonResult > Delete ( int id )
{
try
{
await this . companyService . DeleteAsync ( id ) ;
await this . unitOfWork . SaveChangesAsync ( ) ;
return Json ( new { success = true } ) ;
}
catch ( Exception e )
{
return Json ( new { success = false , err = e . GetBaseException ( ) . Message } ) ;
}
}
//删除选中的记录
[ HttpPost ]
public async Task < JsonResult > DeleteChecked ( int [ ] id )
{
try
{
foreach ( var key in id )
{
await this . companyService . DeleteAsync ( key ) ;
}
await this . unitOfWork . SaveChangesAsync ( ) ;
return Json ( new { success = true } ) ;
}
catch ( Exception e )
{
return Json ( new { success = false , err = e . GetBaseException ( ) . Message } ) ;
}
}
//保存datagrid编辑的数据
[ HttpPost ]
public async Task < JsonResult > AcceptChanges ( Company [ ] companies )
{
if ( ModelState . IsValid )
{
try
{
foreach ( var item in companies )
{
this . companyService . ApplyChanges ( item ) ;
}
var result = await this . unitOfWork . SaveChangesAsync ( ) ;
return Json ( new { success = true , result } ) ;
}
catch ( Exception e )
{
return Json ( new { success = false , err = e . GetBaseException ( ) . Message } ) ;
}
}
else
{
var modelStateErrors = string . Join ( " , ", ModelState.Keys.SelectMany(key => ModelState[key].Errors.Select(n => n.ErrorMessage)));
return Json ( new { success = false , err = modelStateErrors } ) ;
}
}
//导出Excel
[ HttpPost ]
public async Task < IActionResult > ExportExcel ( string filterRules = "" , string sort = "Id" , string order = "asc" )
{
var fileName = "compnay" + DateTime . Now . ToString ( "yyyyMMddHHmmss" ) + ".xlsx" ;
var stream = await this . companyService . ExportExcelAsync ( filterRules , sort , order ) ;
return File ( stream , "application/vnd.ms-excel" , fileName ) ;
}
//导入excel
[ HttpPost ]
public async Task < IActionResult > ImportExcel ( )
{
try
{
var watch = new Stopwatch ( ) ;
watch . Start ( ) ;
var total = 0 ;
if ( Request . Form . Files . Count > 0 )
{
for ( var i = 0 ; i < this . Request . Form . Files . Count ; i ++ )
{
var model = Request . Form [ "model" ] . FirstOrDefault ( ) ?? "company" ;
var folder = Request . Form [ "folder" ] . FirstOrDefault ( ) ?? "company" ;
var autosave = Convert . ToBoolean ( Request . Form [ "autosave" ] . FirstOrDefault ( ) ) ;
var properties = ( Request . Form [ "properties" ] . FirstOrDefault ( ) ?. Split ( ',' ) ) ;
var file = Request . Form . Files [ i ] ;
var filename = file . FileName ;
var contenttype = file . ContentType ;
var size = file . Length ;
var ext = Path . GetExtension ( filename ) ;
var path = Path . Combine ( this . _webHostEnvironment . ContentRootPath , "UploadFiles" , folder ) ;
if ( ! Directory . Exists ( path ) )
{
Directory . CreateDirectory ( path ) ;
}
var datatable = await NPOIHelper . GetDataTableFromExcelAsync ( file . OpenReadStream ( ) , ext ) ;
await this . companyService . ImportDataTableAsync ( datatable ) ;
await this . unitOfWork . SaveChangesAsync ( ) ;
total = datatable . Rows . Count ;
if ( autosave )
{
var filepath = Path . Combine ( path , filename ) ;
file . OpenReadStream ( ) . Position = 0 ;
using ( var stream = System . IO . File . Create ( filepath ) )
{
await file . CopyToAsync ( stream ) ;
}
}
}
}
watch . Stop ( ) ;
return Json ( new { success = true , total = total , elapsedTime = watch . ElapsedMilliseconds } ) ;
}
catch ( Exception e ) {
this . _logger . LogError ( e , " Excel导入失败" ) ;
return this . Json ( new { success = false , err = e . GetBaseException ( ) . Message } ) ;
}
}
//下载模板
public async Task < IActionResult > Download ( string file ) {
this . Response . Cookies . Append ( " fileDownload " , " true " ) ;
var path = Path . Combine ( this . _webHostEnvironment . ContentRootPath , file ) ;
var downloadFile = new FileInfo ( path ) ;
if ( downloadFile . Exists )
{
var fileName = downloadFile . Name ;
var mimeType = MimeTypeConvert . FromExtension ( downloadFile . Extension ) ;
var fileContent = new byte [ Convert . ToInt32 ( downloadFile . Length ) ] ;
using ( var fs = downloadFile . Open ( FileMode . Open , FileAccess . Read , FileShare . Read ) )
{
await fs . ReadAsync ( fileContent , 0 , Convert . ToInt32 ( downloadFile . Length ) ) ;
}
return this . File ( fileContent , mimeType , fileName ) ;
}
else
{
throw new FileNotFoundException ( $ "文件 {file} 不存在!" ) ;
}
}
}
}MVC보기 Companies Index
@model SmartAdmin.Data.Models.Customer
@{
ViewData["Title"] = "客户信息";
ViewData["PageName"] = "customers_index";
ViewData["Heading"] = " < i class =' fal fa-window text-primary ' > </ i > 客户信息";
ViewData["Category1"] = "组织架构";
ViewData["PageDescription"] = "";
}
< div class =" row " >
< div class =" col-lg-12 col-xl-12 " >
< div id =" panel-1 " class =" panel " >
< div class =" panel-hdr " >
< h2 >
客户信息
</ h2 >
< div class =" panel-toolbar " >
< button class =" btn btn-panel bg-transparent fs-xl w-auto h-auto rounded-0 " data-action =" panel-collapse " data-toggle =" tooltip " data-offset =" 0,10 " data-original-title =" Collapse " > < i class =" fal fa-window-minimize " > </ i > </ button >
< button class =" btn btn-panel bg-transparent fs-xl w-auto h-auto rounded-0 " data-action =" panel-fullscreen " data-toggle =" tooltip " data-offset =" 0,10 " data-original-title =" Fullscreen " > < i class =" fal fa-expand " > </ i > </ button >
</ div >
</ div >
< div class =" panel-container show " >
< div class =" panel-content py-2 rounded-bottom border-faded border-left-0 border-right-0 text-muted bg-subtlelight-fade " >
< div class =" row no-gutters align-items-center " >
< div class =" col " >
<!-- 开启授权控制请参考 @@if (Html.IsAuthorize("Create") -->
< div class =" btn-group btn-group-sm " >
< button onclick =" appendItem() " class =" btn btn-default " >
< span class =" fal fa-plus mr-1 " > </ span > 新增
</ button >
</ div >
< div class =" btn-group btn-group-sm " >
< button name =" deletebutton " disabled onclick =" removeItem() " class =" btn btn-default " >
< span class =" fal fa-times mr-1 " > </ span > 删除
</ button >
</ div >
< div class =" btn-group btn-group-sm " >
< button name =" savebutton " disabled onclick =" acceptChanges() " class =" btn btn-default " >
< span class =" fal fa-save mr-1 " > </ span > 保存
</ button >
</ div >
< div class =" btn-group btn-group-sm " >
< button name =" cancelbutton " disabled onclick =" rejectChanges() " class =" btn btn-default " >
< span class =" fal fa-ban mr-1 " > </ span > 取消
</ button >
</ div >
< div class =" btn-group btn-group-sm " >
< button onclick =" reload() " class =" btn btn-default " > < span class =" fal fa-search mr-1 " > </ span > 查询 </ button >
< button type =" button " class =" btn btn-default dropdown-toggle dropdown-toggle-split " data-toggle =" dropdown " aria-haspopup =" true " aria-expanded =" false " >
< span class =" sr-only " > Toggle Dropdown </ span >
</ button >
< div class =" dropdown-menu dropdown-menu-animated " >
< a class =" dropdown-item js-waves-on " href =" javascript:void() " > 我的记录 </ a >
< div class =" dropdown-divider " > </ div >
< a class =" dropdown-item js-waves-on " href =" javascript:void() " > 自定义查询 </ a >
</ div >
</ div >
< div class =" btn-group btn-group-sm hidden-xs " >
< button type =" button " onclick =" importExcel.upload() " class =" btn btn-default " > < span class =" fal fa-cloud-upload mr-1 " > </ span > 导入 </ button >
< button type =" button " class =" btn btn-default dropdown-toggle dropdown-toggle-split waves-effect waves-themed " data-toggle =" dropdown " aria-haspopup =" true " aria-expanded =" false " >
< span class =" sr-only " > Toggle Dropdown </ span >
</ button >
< div class =" dropdown-menu dropdown-menu-animated " >
< a class =" dropdown-item js-waves-on " href =" javascript:importExcel.downloadtemplate() " >
< span class =" fal fa-download " > </ span > 下载模板
</ a >
</ div >
</ div >
< div class =" btn-group btn-group-sm hidden-xs " >
< button onclick =" exportExcel() " class =" btn btn-default " >
< span class =" fal fa-file-export mr-1 " > </ span > 导出
</ button >
</ div >
</ div >
</ div >
</ div >
< div class =" panel-content " >
< div class =" table-responsive " >
< table id =" companies_datagrid " >
</ table >
</ div >
</ div >
</ div >
</ div >
</ div >
</ div >
<!-- 弹出窗体form表单 -->
< div id =" customerdetailwindow " class =" easyui-window "
title ="明细数据"
data-options =" modal:true,
closed:true,
minimizable:false,
collapsible:false,
maximized:false,
iconCls:'fal fa-window',
onBeforeClose:function(){
var that = $(this);
if(customerhasmodified()){
$.messager.confirm('确认','你确定要放弃保存修改的记录?',function(r){
if (r){
var opts = that.panel('options');
var onBeforeClose = opts.onBeforeClose;
opts.onBeforeClose = function(){};
that.panel('close');
opts.onBeforeClose = onBeforeClose;
hook = false;
}
});
return false;
}
},
onOpen:function(){
$(this).window('vcenter');
$(this).window('hcenter');
},
onRestore:function(){
},
onMaximize:function(){
}
" style =" width:820px;height:420px;display:none " >
<!-- toolbar -->
< div class =" panel-content py-2 rounded-bottom border-faded border-left-0 border-right-0 text-muted bg-subtlelight-fade sticky-top " >
< div class =" d-flex flex-row-reverse pr-4 " >
< div class =" btn-group btn-group-sm mr-1 " >
< button name =" saveitembutton " onclick =" savecustomeritem() " class =" btn btn-default " >
< i class =" fal fa-save " > </ i > 保存
</ button >
</ div >
< div class =" btn-group btn-group-sm mr-1 " id =" deleteitem-btn-group " >
< button onclick =" deletecustomeritem() " class =" btn btn-danger " >
< i class =" fal fa-trash-alt " > </ i > 删除
</ button >
</ div >
</ div >
</ div >
< div class =" panel-container show " >
< div class =" container " >
< div class =" panel-content " >
< form id =" customer_form "
class =" easyui-form form-horizontal p-1 "
method =" post "
data-options =" novalidate:true,
onChange: function(target){
hook = true;
$('button[name*='saveitembutton']').prop('disabled', false);
},
onLoadSuccess:function(data){
hook = false;
$('button[name*='saveitembutton']').prop('disabled', true);
} " >
@Html.AntiForgeryToken()
<!--Primary Key-->
@Html.HiddenFor(model = > model.Id)
< fieldset class =" form-group " >
<!-- begin row -->
<!--名称-->
< div class =" row h-100 justify-content-center align-items-center " >
< label class =" col-md-2 pr-1 form-label text-right " > < span class =" text-danger " > * </ span > @Html.DisplayNameFor(model = > model.Name) </ label >
< div class =" col-md-4 mb-1 pl-1 " >
< input id =" @Html.IdFor(model => model.Name) "
name =" @Html.NameFor(model => model.Name) "
value =" @Html.ValueFor(model => model.Name) "
tabindex =" 0 " required
class =" easyui-textbox "
style =" width:100% "
type =" text "
data-options =" prompt:'@Html.DescriptionFor(model => model.Name)',
required:true,
validType: 'length[0,50]'
" />
</ div >
< label class =" col-md-2 pr-1 form-label text-right " > @Html.DisplayNameFor(model = > model.Contect) </ label >
< div class =" col-md-4 mb-1 pl-1 " >
< input id =" @Html.IdFor(model => model.Contect) "
name =" @Html.NameFor(model => model.Contect) "
value =" @Html.ValueFor(model => model.Contect) "
tabindex =" 1 " required
class =" easyui-textbox "
style =" width:100% "
type =" text "
data-options =" prompt:'@Html.DescriptionFor(model => model.Contect)',
required:true,validType: 'length[0,12]'
" />
</ div >
< label class =" col-md-2 pr-1 form-label text-right " > @Html.DisplayNameFor(model = > model.PhoneNumber) </ label >
< div class =" col-md-4 mb-1 pl-1 " >
< input id =" @Html.IdFor(model => model.PhoneNumber) "
name =" @Html.NameFor(model => model.PhoneNumber) "
value =" @Html.ValueFor(model => model.PhoneNumber) "
tabindex =" 2 "
class =" easyui-textbox "
style =" width:100% "
type =" text "
data-options =" prompt:'@Html.DescriptionFor(model => model.PhoneNumber)',
required:false,validType: 'length[0,20]'
" />
</ div >
< label class =" col-md-2 pr-1 form-label text-right " > @Html.DisplayNameFor(model = > model.Address) </ label >
< div class =" col-md-4 mb-1 pl-1 " >
< input id =" @Html.IdFor(model => model.Address) "
name =" @Html.NameFor(model => model.Address) "
value =" @Html.ValueFor(model => model.Address) "
tabindex =" 3 "
class =" easyui-textbox "
style =" width:100% "
type =" text "
data-options =" prompt:'@Html.DescriptionFor(model => model.Address)',
required:true, validType: 'length[0,50]'
" />
</ div >
</ div >
</ fieldset >
</ form >
</ div >
</ div >
</ div >
</ div >
@await Component.InvokeAsync("ImportExcel", new ImportExcelOptions
{
entity = "Customer",
folder = "Customers",
url = "/Customers/ImportExcel",
tpl = "/Customers/Download"
})
@section HeadBlock {
< link href =" ~/css/notifications/toastr/toastr.css " rel =" stylesheet " asp-append-version =" true " />
< link href =" ~/css/formplugins/bootstrap-daterangepicker/bootstrap-daterangepicker.css " rel =" stylesheet " asp-append-version =" true " />
< link href =" ~/js/easyui/themes/insdep/easyui.css " rel =" stylesheet " asp-append-version =" true " />
}
@section ScriptsBlock {
< script src =" ~/js/dependency/numeral/numeral.min.js " asp-append-version =" true " > </ script >
< script src =" ~/js/dependency/moment/moment.js " asp-append-version =" true " > </ script >
< script src =" ~/js/notifications/toastr/toastr.js " > </ script >
< script src =" ~/js/formplugins/bootstrap-daterangepicker/bootstrap-daterangepicker.js " asp-append-version =" true " > </ script >
< script src =" ~/js/easyui/jquery.easyui.min.js " asp-append-version =" true " > </ script >
< script src =" ~/js/easyui/plugins/datagrid-filter.js " asp-append-version =" true " > </ script >
< script src =" ~/js/easyui/plugins/columns-ext.js " asp-append-version =" true " > </ script >
< script src =" ~/js/easyui/plugins/columns-reset.js " asp-append-version =" true " > </ script >
< script src =" ~/js/easyui/locale/easyui-lang-zh_CN.js " asp-append-version =" true " > </ script >
< script src =" ~/js/easyui/jquery.easyui.component.js " asp-append-version =" true " > </ script >
< script src =" ~/js/plugin/filesaver/FileSaver.js " asp-append-version =" true " > </ script >
< script src =" ~/js/plugin/jquery.serializejson/jquery.serializejson.js " asp-append-version =" true " > </ script >
< script src =" ~/js/jquery.custom.extend.js " asp-append-version =" true " > </ script >
< script src =" ~/js/jquery.extend.formatter.js " asp-append-version =" true " > </ script >
< script >
var $dg = $ ( '#companies_datagrid' ) ;
var EDITINLINE = true ;
var customer = null ;
var editIndex = undefined ;
//下载Excel导入模板
//执行导出下载Excel
function exportExcel ( ) {
const filterRules = JSON . stringify ( $dg . datagrid ( 'options' ) . filterRules ) ;
console . log ( filterRules ) ;
$ . messager . progress ( { title : '请等待' , msg : '正在执行导出...' } ) ;
let formData = new FormData ( ) ;
formData . append ( 'filterRules' , filterRules ) ;
formData . append ( 'sort' , 'Id' ) ;
formData . append ( 'order' , 'asc' ) ;
$ . postDownload ( '/Customers/ExportExcel' , formData ) . then ( res => {
$ . messager . progress ( 'close' ) ;
toastr . success ( '导出成功!' ) ;
} ) . catch ( err => {
//console.log(err);
$ . messager . progress ( 'close' ) ;
$ . messager . alert ( '导出失败' , err . statusText , 'error' ) ;
} ) ;
}
//弹出明细信息
function showDetailsWindow ( id , index ) {
const customer = $dg . datagrid ( 'getRows' ) [ index ] ;
openCustomerDetailWindow ( customer , 'Modified' ) ;
}
function reload ( ) {
$dg . datagrid ( 'uncheckAll' ) ;
$dg . datagrid ( 'reload' ) ;
}
//新增记录
function appendItem ( ) {
customer = {
Address : '-' ,
RegisterDate : moment ( ) . format ( 'YYYY-MM-DD HH:mm:ss' ) ,
} ;
if ( ! EDITINLINE ) {
//弹出新增窗口
openCustomerDetailWindow ( customer , 'Added' ) ;
} else {
if ( endEditing ( ) ) {
//对必填字段进行默认值初始化
$dg . datagrid ( 'insertRow' ,
{
index : 0 ,
row : customer
} ) ;
editIndex = 0 ;
$dg . datagrid ( 'selectRow' , editIndex )
. datagrid ( 'beginEdit' , editIndex ) ;
hook = true ;
}
}
}
//删除编辑的行
function removeItem ( ) {
if ( this . $dg . datagrid ( 'getChecked' ) . length <= 0 && EDITINLINE ) {
if ( editIndex !== undefined ) {
const delindex = editIndex ;
$dg . datagrid ( 'cancelEdit' , delindex )
. datagrid ( 'deleteRow' , delindex ) ;
hook = true ;
$ ( "button[name*='savebutton']" ) . prop ( 'disabled' , false ) ;
$ ( "button[name*='cancelbutton']" ) . prop ( 'disabled' , false ) ;
} else {
const rows = $dg . datagrid ( 'getChecked' ) ;
rows . slice ( ) . reverse ( ) . forEach ( row => {
const rowindex = $dg . datagrid ( 'getRowIndex' , row ) ;
$dg . datagrid ( 'deleteRow' , rowindex ) ;
hook = true ;
} ) ;
}
} else {
deletechecked ( ) ;
}
}
//删除选中的行
function deleteChecked ( ) {
const checked = $dg . datagrid ( 'getChecked' ) . filter ( item => item . Id != null && item . Id > 0 ) . map ( item => {
return item . Id ;
} ) ; ;
if ( checked . length > 0 ) {
deleteRows ( checked ) ;
} else {
$ . messager . alert ( '提示' , '请先选择要删除的记录!' , 'question' ) ;
}
}
//执行删除
function deleteRows ( selected ) {
$ . messager . confirm ( '确认' , `你确定要删除这 <span class='badge badge-icon position-relative'> ${ selected . length } </span> 行记录?` , result => {
if ( result ) {
$ . post ( '/Customers/DeleteChecked' , { id : selected } )
. done ( response => {
if ( response . success ) {
toastr . error ( `成功删除 [ ${ selected . length } ] 行记录` ) ;
reload ( ) ;
} else {
$ . messager . alert ( '错误' , response . err , 'error' ) ;
}
} )
. fail ( ( jqXHR , textStatus , errorThrown ) => {
$ . messager . alert ( '异常' , ` ${ jqXHR . status } : ${ jqXHR . statusText } ` , 'error' ) ;
} ) ;
}
} ) ;
}
//开启编辑状态
function onClickCell ( index , field ) {
customer = $dg . datagrid ( 'getRows' ) [ index ] ;
const _actions = [ 'action' , 'ck' ] ;
if ( ! EDITINLINE || $ . inArray ( field , _actions ) >= 0 ) {
return ;
}
if ( editIndex !== index ) {
if ( endEditing ( ) ) {
$dg . datagrid ( 'selectRow' , index )
. datagrid ( 'beginEdit' , index ) ;
hook = true ;
editIndex = index ;
const ed = $dg . datagrid ( 'getEditor' , { index : index , field : field } ) ;
if ( ed ) {
( $ ( ed . target ) . data ( 'textbox' ) ? $ ( ed . target ) . textbox ( 'textbox' ) : $ ( ed . target ) ) . focus ( ) ;
}
} else {
$dg . datagrid ( 'selectRow' , editIndex ) ;
}
}
}
//关闭编辑状态
function endEditing ( ) {
if ( editIndex === undefined ) {
return true ;
}
if ( this . $dg . datagrid ( 'validateRow' , editIndex ) ) {
$dg . datagrid ( 'endEdit' , editIndex ) ;
return true ;
} else {
const invalidinput = $ ( 'input.validatebox-invalid' , $dg . datagrid ( 'getPanel' ) ) ;
const fieldnames = invalidinput . map ( ( index , item ) => {
return $ ( item ) . attr ( 'placeholder' ) || $ ( item ) . attr ( 'id' ) ;
} ) ;
$ . messager . alert ( '提示' , ` ${ Array . from ( fieldnames ) } 输入有误.` , 'error' ) ;
return false ;
}
}
//提交保存后台数据库
function acceptChanges ( ) {
if ( endEditing ( ) ) {
if ( $dg . datagrid ( 'getChanges' ) . length > 0 ) {
const inserted = $dg . datagrid ( 'getChanges' , 'inserted' ) . map ( item => {
item . TrackingState = 1 ;
return item ;
} ) ;
const updated = $dg . datagrid ( 'getChanges' , 'updated' ) . map ( item => {
item . TrackingState = 2
return item ;
} ) ;
const deleted = $dg . datagrid ( 'getChanges' , 'deleted' ) . map ( item => {
item . TrackingState = 3
return item ;
} ) ;
//过滤已删除的重复项
const changed = inserted . concat ( updated . filter ( item => {
return ! deleted . includes ( item ) ;
} ) ) . concat ( deleted ) ;
//$.messager.progress({ title: '请等待', msg: '正在保存数据...', interval: 200 });
$ . post ( '/Customers/AcceptChanges' , { customers : changed } )
. done ( response => {
//$.messager.progress('close');
//console.log(response);
if ( response . success ) {
toastr . success ( '保存成功' ) ;
$dg . datagrid ( 'acceptChanges' ) ;
reload ( ) ;
hook = false ;
} else {
$ . messager . alert ( '错误' , response . err , 'error' ) ;
}
} )
. fail ( ( jqXHR , textStatus , errorThrown ) => {
//$.messager.progress('close');
$ . messager . alert ( '异常' , ` ${ jqXHR . status } : ${ jqXHR . statusText } ` , 'error' ) ;
} ) ;
}
}
}
function rejectChanges ( ) {
$dg . datagrid ( 'rejectChanges' ) ;
editIndex = undefined ;
hook = false ;
}
$ ( document ) . ready ( function ( ) {
//定义datagrid结构
$dg . datagrid ( {
rownumbers : true ,
checkOnSelect : false ,
selectOnCheck : false ,
idField : 'Id' ,
sortName : 'Id' ,
sortOrder : 'desc' ,
remoteFilter : true ,
singleSelect : true ,
method : 'get' ,
onClickCell : onClickCell ,
clientPaging : false ,
pagination : true ,
striped : true ,
filterRules : [ ] ,
onHeaderContextMenu : function ( e , field ) {
e . preventDefault ( ) ;
$ ( this ) . datagrid ( 'columnMenu' ) . menu ( 'show' , {
left : e . pageX ,
top : e . pageY
} ) ;
} ,
onBeforeLoad : function ( ) {
const that = $ ( this ) ;
document . addEventListener ( 'panel.onfullscreen' , ( ) => {
setTimeout ( ( ) => {
that . datagrid ( 'resize' ) ;
} , 200 )
} )
} ,
onLoadSuccess : function ( data ) {
editIndex = undefined ;
$ ( "button[name*='deletebutton']" ) . prop ( 'disabled' , true ) ;
$ ( "button[name*='savebutton']" ) . prop ( 'disabled' , true ) ;
$ ( "button[name*='cancelbutton']" ) . prop ( 'disabled' , true ) ;
} ,
onCheck : function ( ) {
$ ( "button[name*='deletebutton']" ) . prop ( 'disabled' , false ) ;
} ,
onUncheck : function ( ) {
const checked = $ ( this ) . datagrid ( 'getChecked' ) . length > 0 ;
$ ( "button[name*='deletebutton']" ) . prop ( 'disabled' , ! checked ) ;
} ,
onSelect : function ( index , row ) {
customer = row ;
} ,
onBeginEdit : function ( index , row ) {
//const editors = $(this).datagrid('getEditors', index);
} ,
onEndEdit : function ( index , row ) {
editIndex = undefined ;
} ,
onBeforeEdit : function ( index , row ) {
editIndex = index ;
row . editing = true ;
$ ( "button[name*='deletebutton']" ) . prop ( 'disabled' , false ) ;
$ ( "button[name*='cancelbutton']" ) . prop ( 'disabled' , false ) ;
$ ( "button[name*='savebutton']" ) . prop ( 'disabled' , false ) ;
$ ( this ) . datagrid ( 'refreshRow' , index ) ;
} ,
onAfterEdit : function ( index , row ) {
row . editing = false ;
editIndex = undefined ;
$ ( this ) . datagrid ( 'refreshRow' , index ) ;
} ,
onCancelEdit : function ( index , row ) {
row . editing = false ;
editIndex = undefined ;
$ ( "button[name*='deletebutton']" ) . prop ( 'disabled' , true ) ;
$ ( "button[name*='savebutton']" ) . prop ( 'disabled' , true ) ;
$ ( "button[name*='cancelbutton']" ) . prop ( 'disabled' , true ) ;
$ ( this ) . datagrid ( 'refreshRow' , index ) ;
} ,
frozenColumns : [ [
/*开启CheckBox选择功能*/
{ field : 'ck' , checkbox : true } ,
{
field : 'action' ,
title : '操作' ,
width : 85 ,
sortable : false ,
resizable : true ,
formatter : function showdetailsformatter ( value , row , index ) {
if ( ! row . editing ) {
return `<div class="btn-group">
<button onclick="showDetailsWindow(' ${ row . Id } ', ${ index } )" class="btn btn-primary btn-sm btn-icon waves-effect waves-themed" title="查看明细" ><i class="fal fa-edit"></i> </button>
<button onclick="deleteRows([' ${ row . Id } '], ${ index } )" class="btn btn-primary btn-sm btn-icon waves-effect waves-themed" title="删除记录" ><i class="fal fa-times"></i> </button>
</div>` ;
} else {
return `<button class="btn btn-primary btn-sm btn-icon waves-effect waves-themed" disabled title="查看明细" ><i class="fal fa-edit"></i> </button>` ;
}
}
}
] ] ,
columns : [ [
{ /*名称*/
field : 'Name' ,
title : '@Html.DisplayNameFor(model => model.Name)' ,
width : 200 ,
hidden : false ,
editor : {
type : 'textbox' ,
options : { prompt : '@Html.DescriptionFor(model => model.Name)' , required : true , validType : 'length[0,128]' }
} ,
sortable : true ,
resizable : true
} ,
{ /*联系人*/
field : 'Contect' ,
title : '@Html.DisplayNameFor(model => model.Contect)' ,
width : 120 ,
hidden : false ,
editor : {
type : 'textbox' ,
options : { prompt : '@Html.DescriptionFor(model => model.Contect)' , required : true , validType : 'length[0,12]' }
} ,
sortable : true ,
resizable : true
} ,
{ /*电话*/
field : 'PhoneNumber' ,
title : '@Html.DisplayNameFor(model => model.PhoneNumber)' ,
width : 200 ,
hidden : false ,
editor : {
type : 'textbox' ,
options : { prompt : '@Html.DescriptionFor(model => model.PhoneNumber)' , required : false , validType : 'length[0,20]' }
} ,
sortable : true ,
resizable : true
} ,
{ /*地址*/
field : 'Address' ,
title : '@Html.DisplayNameFor(model => model.Address)' ,
width : 120 ,
hidden : false ,
editor : {
type : 'textbox' ,
options : { prompt : '@Html.DescriptionFor(model => model.Address)' , required : false , validType : 'length[0,50]' }
} ,
sortable : true ,
resizable : true ,
}
] ]
} ) . datagrid ( 'columnMoving' )
. datagrid ( 'resetColumns' )
. datagrid ( 'enableFilter' , [
] )
. datagrid ( 'load' , '/Customers/GetData' ) ;
}
) ;
</ script >
< script type =" text/javascript " >
//判断新增编辑状态
var MODELSTATE = 'Added' ;
var customerid = null ;
function openCustomerDetailWindow ( data , state ) {
MODELSTATE = state ;
initcustomerdetailview ( ) ;
customerid = ( data . Id || 0 ) ;
$ ( "#customerdetailwindow" ) . window ( "open" ) ;
$ ( '#customer_form' ) . form ( 'reset' ) ;
$ ( '#customer_form' ) . form ( 'load' , data ) ;
}
//删除当前记录
function deletecustomeritem ( ) {
$ . messager . confirm ( '确认' , '你确定要删除该记录?' , result => {
if ( result ) {
const url = `/Customers/Delete/ ${ customerid } ` ;
$ . get ( url ) . done ( res => {
if ( res . success ) {
toastr . success ( "删除成功" ) ;
$ ( "#customerdetailwindow" ) . window ( "close" ) ;
reload ( ) ;
} else {
$ . messager . alert ( "错误" , res . err , "error" ) ;
}
} ) ;
}
} ) ;
}
//async 保存数据
async function savecustomeritem ( ) {
const $customerform = $ ( '#customer_form' ) ;
if ( $customerform . form ( 'enableValidation' ) . form ( 'validate' ) ) {
let customer = $customerform . serializeJSON ( ) ;
let url = '/Customers/Edit' ;
//判断是新增或是修改方法
if ( MODELSTATE === 'Added' ) {
url = '/Customers/Create' ;
}
var token = $ ( 'input[name="__RequestVerificationToken"]' , $customerform ) . val ( ) ;
//$.messager.progress({ title: '请等待', msg: '正在保存数据...', interval: 200 });
$ . ajax ( {
type : "POST" ,
url : url ,
data : {
__RequestVerificationToken : token ,
customer : customer
} ,
dataType : 'json' ,
contentType : 'application/x-www-form-urlencoded; charset=utf-8'
} )
. done ( response => {
//$.messager.progress('close');
if ( response . success ) {
hook = false ;
$customerform . form ( 'disableValidation' ) ;
$dg . datagrid ( 'reload' ) ;
$ ( '#customerdetailwindow' ) . window ( "close" ) ;
toastr . success ( "保存成功" ) ;
} else {
$ . messager . alert ( "错误" , response . err , "error" ) ;
}
} )
. fail ( ( jqXHR , textStatus , errorThrown ) => {
//$.messager.progress('close');
$ . messager . alert ( '异常' , ` ${ jqXHR . status } : ${ jqXHR . statusText } ` , 'error' ) ;
} ) ;
}
}
//关闭窗口
function closecustomerdetailwindow ( ) {
$ ( '#customerdetailwindow' ) . window ( 'close' ) ;
}
//判断是否有没有保存的记录
function customerhasmodified ( ) {
return hook ;
}
function initcustomerdetailview ( ) {
//判断是否显示功能按钮
}
</ script >
}위의 뷰 계층의 코드는 매우 복잡하지만 모두 고정 형식이므로 스캐 폴드로 빠르게 생성 될 수 있습니다.
Open startup.cs. 공개 void configureservices (iservicececollection services) Register Services Services.addsCoped <irepositoryx, repositoryx> ();
services.addscoped <iCustomerService, customerservice> ();
EF 핵심 코드 우선 마이그레이션
Visual Studio.net에서
패키지 관리자 콘트로 런
PM> : add-migration create_company
PM> : 업데이트-사장
PM> : 마이그레이션
분산 트랜잭션의 솔루션 및 응용 시나리오를 제한하십시오
Nuget 설치
PM> install-package dotnetcore.cap
PM> install-package dotnetcore.cap.rabbitmq
PM> install-package dotnetcore.cap.sqlserver
public void ConfigureServices ( IServiceCollection services )
{
services . AddCap ( x =>
{
x . UseEntityFramework < SmartDbContext > ( ) ;
x . UseRabbitMQ ( "127.0.0.1" ) ;
x . UseDashboard ( ) ;
x . FailedRetryCount = 5 ;
x . FailedThresholdCallback = failed =>
{
var logger = failed . ServiceProvider . GetService < ILogger < Startup >> ( ) ;
logger . LogError ( $ @"A message of type {failed.MessageType} failed after executing {x.FailedRetryCount} several times,
requiring manual troubleshooting . Message name : { failed . Message . GetName ( ) } ");
} ;
} ) ;
}QQ 群!
