From d3bf3cea8c5a35a8a6ecd5c7d2652f869bac6c44 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期四, 15 八月 2024 12:47:42 +0800 Subject: [PATCH] 表 --- cylsg/cylsg.Model/UserModel/User.cs | 18 cylsg/cylsg.Model/OrderModel/Order.cs | 138 +++++++++++++ cylsg/cylsg.Model/OrderModel/OrderBidding.cs | 57 +++++ cylsg/cylsg.Model/UserModel/UserWorker.cs | 82 ++++++++ cylsg/cylsg.Model/OrderModel/OrderBiddingDetail.cs | 99 +++++++++ cylsg/cylsg.Model/OrderModel/OrderBiddingDetailCheck.cs | 47 ++++ cylsg/cylsg.Core/BaseModelBase.cs | 4 cylsg/cylsg.Model/UserModel/UserCompany.cs | 100 ++++++++++ 8 files changed, 534 insertions(+), 11 deletions(-) diff --git a/cylsg/cylsg.Core/BaseModelBase.cs b/cylsg/cylsg.Core/BaseModelBase.cs index e722934..c267d1d 100644 --- a/cylsg/cylsg.Core/BaseModelBase.cs +++ b/cylsg/cylsg.Core/BaseModelBase.cs @@ -23,7 +23,7 @@ /// 鍒涘缓浜� /// </summary> [Display(Name = "鍒涘缓浜� ")] - [SugarColumn(ColumnDescription = "鍒涘缓浜� ", Length = 100)] + [SugarColumn(ColumnDescription = "鍒涘缓浜� ", ColumnDataType = "nvarchar(100)")] public string CreateBy { get; set; } /// <summary> /// 淇敼鏃堕棿 @@ -35,7 +35,7 @@ /// 淇敼浜� /// </summary> [Display(Name = "淇敼浜� ")] - [SugarColumn(ColumnDescription = "淇敼浜� ", Length = 100)] + [SugarColumn(ColumnDescription = "淇敼浜� ", ColumnDataType = "nvarchar(100)")] public string UpDataBy { get; set; } diff --git a/cylsg/cylsg.Model/OrderModel/Order.cs b/cylsg/cylsg.Model/OrderModel/Order.cs new file mode 100644 index 0000000..b76a4e7 --- /dev/null +++ b/cylsg/cylsg.Model/OrderModel/Order.cs @@ -0,0 +1,138 @@ +锘縰sing cylsg.Core; +using cylsg.Core.Attributes; +using SqlSugar; +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.ComponentModel.DataAnnotations; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace cylsg.Model.OrderModel +{ + /// <summary> + /// 鎷涘伐璁㈠崟 + /// </summary> + [Description("鎷涘伐璁㈠崟")] + [CoderFirst] + public class Order : BaseModel + { + /// <summary> + /// 鎷涘伐Id + /// </summary> + [SugarColumn(ColumnDescription = "鎷涘伐Id", IsPrimaryKey = true, IsIdentity = true)] + public int Id { get; set; } + + /// <summary> + /// 鎷涘伐鐢ㄦ埛id + /// </summary> + [SugarColumn(ColumnDescription = "鎷涘伐鐢ㄦ埛id")] + public int OrderUserId { get; set; } + + /// <summary> + /// 鎷涘伐鍚嶇О + /// </summary> + [SugarColumn(ColumnDescription = "鎷涘伐鍚嶇О", ColumnDataType = "nvarchar(100)")] + public string OrderName { get; set; } + + /// <summary> + /// 宸ヤ綔寮�濮嬫椂闂� + /// </summary> + [Display(Name = "宸ヤ綔寮�濮嬫椂闂�")] + [SugarColumn(ColumnDescription = "宸ヤ綔寮�濮嬫椂闂�", IsNullable = true)] + public DateTime? WordStartTime { get; set; } + + /// <summary> + /// 宸ヤ綔缁撴潫鏃堕棿 + /// </summary> + [Display(Name = "宸ヤ綔缁撴潫鏃堕棿")] + [SugarColumn(ColumnDescription = "宸ヤ綔缁撴潫鏃堕棿", IsNullable = true)] + public DateTime? WordEndTime { get; set; } + + /// <summary> + /// 闇�姹� + /// </summary> + [SugarColumn(ColumnDescription = "闇�姹�", ColumnDataType = "nvarchar(2000)", IsNullable = true)] + public string Demand { get; set; } + + /// <summary> + /// 鎷涘伐浜烘暟 + /// </summary> + [SugarColumn(ColumnDescription = "鎷涘伐浜烘暟", IsNullable = true)] + public int? WorderCount { get; set; } + + /// <summary> + /// 宸ヤ綔鍦扮偣 + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ綔鍦扮偣", ColumnDataType = "nvarchar(500)", IsNullable = true)] + public string WorderAddress { get; set; } + + + /// <summary> + /// 鑱旂郴鐢佃瘽 + /// </summary> + [SugarColumn(ColumnDescription = "鑱旂郴鐢佃瘽", ColumnDataType = "nvarchar(30)", IsNullable = true)] + public string ContactPhone { get; set; } + + + /// <summary> + /// 宸ヤ綔鏂瑰紡 + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ綔鏂瑰紡", IsNullable = true)] + public WorkerTypes? WorkerType { get; set; } + + + /// <summary> + /// 宸ヤ环 + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ环", Length = 18, DecimalDigits = 2, IsNullable = true)] + public decimal? WorkPrice { get; set; } + + + /// <summary> + /// 鎷涘伐鐘舵�� + /// </summary> + [SugarColumn(ColumnDescription = "鎷涘伐鐘舵��", IsNullable = true)] + public OrderStatuses? OrderStatus { get; set; } + } + + + + + + /// <summary> + /// 宸ヤ綔鏂瑰紡 + /// </summary> + public enum WorkerTypes + { + /// <summary> + ///璁℃椂 + /// </summary> + time = 0, + /// <summary> + ///璁′欢 + /// </summary> + count = 1 + } + + /// <summary> + /// 鎷涘伐鐘舵�� + /// </summary> + public enum OrderStatuses + { + /// <summary> + ///鍙戝竷 + /// </summary> + fabu = 0, + /// <summary> + ///鎷涘伐瀹屾瘯 + /// </summary> + zhaogongwanbi = 1, + + /// <summary> + ///缁撶畻瀹屾瘯 + /// </summary> + jiesuanwanbi = 2 + } +} diff --git a/cylsg/cylsg.Model/OrderModel/OrderBidding.cs b/cylsg/cylsg.Model/OrderModel/OrderBidding.cs new file mode 100644 index 0000000..13602e6 --- /dev/null +++ b/cylsg/cylsg.Model/OrderModel/OrderBidding.cs @@ -0,0 +1,57 @@ +锘縰sing cylsg.Core; +using cylsg.Core.Attributes; +using SqlSugar; +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace cylsg.Model.OrderModel +{ + /// <summary> + /// 宸ヤ汉鎶曢�� + /// </summary> + [Description("宸ヤ汉鎶曢��")] + [CoderFirst] + public class OrderBidding : BaseModel + { + /// <summary> + /// 宸ヤ汉鎶曢�扞d + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ汉鎶曢�扞d", IsPrimaryKey = true, IsIdentity = true)] + public int Id { get; set; } + + /// <summary> + /// 鐢ㄦ埛id + /// </summary> + [SugarColumn(ColumnDescription = "鐢ㄦ埛id")] + public int WorkerUserId { get; set; } + + + /// <summary> + /// 鏄惁閫変腑 + /// </summary> + [SugarColumn(ColumnDescription = "鏄惁閫変腑", IsNullable = true)] + public bool? IsSelected { get; set; } + + /// <summary> + /// 閫変腑鏃堕棿 + /// </summary> + [SugarColumn(ColumnDescription = "閫変腑鏃堕棿", IsNullable = true)] + public DateTime? Selectedtime { get; set; } + + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnDescription = "澶囨敞", ColumnDataType = "nvarchar(250)", IsNullable = true)] + public string Remark { get; set; } + + /// <summary> + /// 宸ヨ祫鎬婚 + /// </summary> + [SugarColumn(ColumnDescription = "宸ヨ祫鎬婚", Length = 18, DecimalDigits = 2, IsNullable = true)] + public decimal? Salary { get; set; } + } +} diff --git a/cylsg/cylsg.Model/OrderModel/OrderBiddingDetail.cs b/cylsg/cylsg.Model/OrderModel/OrderBiddingDetail.cs new file mode 100644 index 0000000..28d48b4 --- /dev/null +++ b/cylsg/cylsg.Model/OrderModel/OrderBiddingDetail.cs @@ -0,0 +1,99 @@ +锘縰sing cylsg.Core; +using cylsg.Core.Attributes; +using SqlSugar; +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace cylsg.Model.OrderModel +{ + /// <summary> + /// 宸ヤ汉宸ヤ綔鏄庣粏琛� + /// </summary> + [Description("宸ヤ汉宸ヤ綔鏄庣粏琛�")] + [CoderFirst] + public class OrderBiddingDetail : BaseModel + { + /// <summary> + /// 宸ヤ汉宸ヤ綔鏄庣粏琛↖d + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ汉宸ヤ綔鏄庣粏琛↖d", IsPrimaryKey = true, IsIdentity = true)] + public int Id { get; set; } + + /// <summary> + /// 宸ヤ汉鎶曢�抜d + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ汉鎶曢�抜d")] + public int OrderBiddingId { get; set; } + + /// <summary> + /// 宸ヤ綔鏃ユ湡 + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ綔鏃ユ湡", IsNullable = true)] + public DateTime? WorkDate { get; set; } + + /// <summary> + /// 宸ヤ綔鏃堕暱 + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ綔鏃堕暱", Length = 18, DecimalDigits = 2, IsNullable = true)] + public decimal? WorkTime { get; set; } + + /// <summary> + /// 璁′欢鏁伴噺 + /// </summary> + [SugarColumn(ColumnDescription = "璁′欢鏁伴噺", Length = 18, DecimalDigits = 2, IsNullable = true)] + public decimal? WorkCount { get; set; } + + /// <summary> + /// 褰撴棩宸ヨ祫 + /// </summary> + [SugarColumn(ColumnDescription = "褰撴棩宸ヨ祫", Length = 18, DecimalDigits = 2, IsNullable = true)] + public decimal? TodaySalary { get; set; } + + /// <summary> + /// 瀹℃壒鐘舵�� + /// </summary> + [SugarColumn(ColumnDescription = "瀹℃壒鐘舵��", IsNullable = true)] + public IsShenPis? IsShenPi { get; set; } + + /// <summary> + /// 瀹℃壒鏃堕棿 + /// </summary> + [SugarColumn(ColumnDescription = "瀹℃壒鏃堕棿", IsNullable = true)] + public DateTime? ShenPitime { get; set; } + + + /// <summary> + /// 鏄惁鎻愮幇 + /// </summary> + [SugarColumn(ColumnDescription = "鏄惁鎻愮幇", IsNullable = true)] + public bool? IsTiXian { get; set; } + + /// <summary> + /// 鎻愮幇鏃堕棿 + /// </summary> + [SugarColumn(ColumnDescription = "鎻愮幇鏃堕棿", IsNullable = true)] + public DateTime? TiXiantime { get; set; } + } + + + + /// <summary> + /// 瀹℃壒鐘舵�� + /// </summary> + public enum IsShenPis + { + /// <summary> + ///璁℃椂 + /// </summary> + weishenpi = 0, + /// <summary> + ///璁′欢 + /// </summary> + yishenpi = 1 + + } +} diff --git a/cylsg/cylsg.Model/OrderModel/OrderBiddingDetailCheck.cs b/cylsg/cylsg.Model/OrderModel/OrderBiddingDetailCheck.cs new file mode 100644 index 0000000..f0bf0d1 --- /dev/null +++ b/cylsg/cylsg.Model/OrderModel/OrderBiddingDetailCheck.cs @@ -0,0 +1,47 @@ +锘縰sing cylsg.Core; +using cylsg.Core.Attributes; +using SqlSugar; +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace cylsg.Model.OrderModel +{ + /// <summary> + /// 鎵撳崱璁板綍琛� + /// </summary> + [Description("鎵撳崱璁板綍琛�")] + [CoderFirst] + public class OrderBiddingDetailCheck : BaseModel + { + /// <summary> + /// 鎵撳崱璁板綍琛↖d + /// </summary> + [SugarColumn(ColumnDescription = "鎵撳崱璁板綍琛↖d", IsPrimaryKey = true, IsIdentity = true)] + public int Id { get; set; } + + /// <summary> + /// 宸ヤ汉宸ヤ綔鏄庣粏琛↖d + /// </summary> + [SugarColumn(ColumnDescription = "宸ヤ汉宸ヤ綔鏄庣粏琛↖d")] + public int OrderBiddingDetailId { get; set; } + + + /// <summary> + /// 鎵撳崱鐓х墖 + /// </summary> + [SugarColumn(ColumnDescription = "鎵撳崱鐓х墖", ColumnDataType = "nvarchar(500)", IsNullable = true)] + public string CheckPhoto { get; set; } + + + /// <summary> + /// 鎵撳崱鏃堕棿 + /// </summary> + [SugarColumn(ColumnDescription = "鎵撳崱鏃堕棿", IsNullable = true)] + public DateTime? Checktime { get; set; } + + } +} diff --git a/cylsg/cylsg.Model/UserModel/User.cs b/cylsg/cylsg.Model/UserModel/User.cs index e6215eb..bc6a074 100644 --- a/cylsg/cylsg.Model/UserModel/User.cs +++ b/cylsg/cylsg.Model/UserModel/User.cs @@ -26,37 +26,37 @@ /// <summary> /// 鐢佃瘽 /// </summary> - [SugarColumn(ColumnDescription = "鐢佃瘽")] + [SugarColumn(ColumnDescription = "鐢佃瘽", ColumnDataType = "nvarchar(30)")] public string Phone { get; set; } /// <summary> /// 鍚嶇О /// </summary> - [SugarColumn(ColumnDescription = "鍚嶇О",Length =100)] + [SugarColumn(ColumnDescription = "鍚嶇О", ColumnDataType = "nvarchar(100)")] public string name { get; set; } /// <summary> /// 鐢佃瘽鍙风爜 /// </summary> - [SugarColumn(ColumnDescription = "鐢佃瘽鍙风爜", Length = 30)] + [SugarColumn(ColumnDescription = "鐢佃瘽鍙风爜", ColumnDataType = "nvarchar(30)")] public string ItCode { get; set; } /// <summary> /// 鏄电О /// </summary> - [SugarColumn(ColumnDescription = "鐢ㄦ埛ID", Length = 100)] - public int Nickname { get; set; } + [SugarColumn(ColumnDescription = "鐢ㄦ埛ID", ColumnDataType = "nvarchar(100)")] + public string Nickname { get; set; } /// <summary> /// 瀵嗙爜 /// </summary> - [SugarColumn(ColumnDescription = "瀵嗙爜", Length = 100)] - public int PassWord { get; set; } + [SugarColumn(ColumnDescription = "瀵嗙爜", ColumnDataType = "nvarchar(100)")] + public string PassWord { get; set; } /// <summary> /// 澶村儚鍦板潃 /// </summary> - [SugarColumn(ColumnDescription = "澶村儚鍦板潃")] - public int Avatar { get; set; } + [SugarColumn(ColumnDescription = "澶村儚鍦板潃", ColumnDataType = "nvarchar(500)")] + public string Avatar { get; set; } } } diff --git a/cylsg/cylsg.Model/UserModel/UserCompany.cs b/cylsg/cylsg.Model/UserModel/UserCompany.cs new file mode 100644 index 0000000..bc4b662 --- /dev/null +++ b/cylsg/cylsg.Model/UserModel/UserCompany.cs @@ -0,0 +1,100 @@ +锘縰sing cylsg.Core; +using cylsg.Core.Attributes; +using Microsoft.AspNetCore.Routing.Constraints; +using SqlSugar; +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace cylsg.Model.UserModel +{ + /// <summary> + /// 鐢ㄦ埛鍏徃 + /// </summary> + [Description("鐢ㄦ埛鍏徃")] + [CoderFirst] + public class UserCompany : BaseModel + { + /// <summary> + /// 鐢ㄦ埛鍏徃Id + /// </summary> + [SugarColumn(ColumnDescription = "鐢ㄦ埛鍏徃ID", IsPrimaryKey = true, IsIdentity = true)] + public int Id { get; set; } + + /// <summary> + /// 鐢ㄦ埛id + /// </summary> + [SugarColumn(ColumnDescription = "鐢ㄦ埛id")] + public int UserId { get; set; } + + /// <summary> + /// 钀ヤ笟鎵х収璺緞 + /// </summary> + [SugarColumn(ColumnDescription = "钀ヤ笟鎵х収璺緞", ColumnDataType = "nvarchar(500)")] + public string BusinessLicense { get; set; } + + + + /// <summary> + /// 浼佷笟鍚嶇О + /// </summary> + [SugarColumn(ColumnDescription = "浼佷笟鍚嶇О", ColumnDataType = "nvarchar(100)", IsNullable = true)] + public string Suppliername { get; set; } + + /// <summary> + /// 娉ㄥ唽鏃堕棿 + /// </summary> + [SugarColumn(ColumnDescription = "娉ㄥ唽鏃堕棿", IsNullable = true)] + public DateTime? Regtime { get; set; } + + /// <summary> + /// 鑱旂郴鍦板潃 + /// </summary> + [SugarColumn(ColumnDescription = "鑱旂郴鍦板潃", ColumnDataType = "nvarchar(500)", IsNullable = true)] + public string Address { get; set; } + + /// <summary> + /// 浼佷笟娉ㄥ唽鍙� + /// </summary> + [SugarColumn(ColumnDescription = "浼佷笟娉ㄥ唽鍙�", ColumnDataType = "nvarchar(30)", IsNullable = true)] + public string Suppliercode { get; set; } + + + /// <summary> + /// 鑱旂郴浜� + /// </summary> + [SugarColumn(ColumnDescription = "鑱旂郴浜�", ColumnDataType = "nvarchar(50)", IsNullable = true)] + public string Contact { get; set; } + + + /// <summary> + /// 鑱旂郴鐢佃瘽 + /// </summary> + [SugarColumn(ColumnDescription = "鑱旂郴鐢佃瘽", ColumnDataType = "nvarchar(50)", IsNullable = true)] + public string Phone { get; set; } + + + + /// <summary> + /// 鍏徃绠�浠� + /// </summary> + [SugarColumn(ColumnDescription = "鍏徃绠�浠�", ColumnDataType = "nvarchar(2000)", IsNullable = true)] + public string Resume { get; set; } + + + /// <summary> + /// 鍏呭�间綑棰� + /// </summary> + [SugarColumn(ColumnDescription = "鍏呭�间綑棰�", Length = 18,DecimalDigits =2 , IsNullable = true)] + public decimal? ChongZhiYue { get; set; } + + /// <summary> + /// 鏄惁鍙互鍏呭�硷紝宸ヤ汉鎻愮幇 + /// </summary> + [SugarColumn(ColumnDescription = "鏄惁鍙互鍏呭�硷紝宸ヤ汉鎻愮幇", IsNullable = true)] + public bool? IsTiXian { get; set; } + } +} diff --git a/cylsg/cylsg.Model/UserModel/UserWorker.cs b/cylsg/cylsg.Model/UserModel/UserWorker.cs new file mode 100644 index 0000000..4a3235d --- /dev/null +++ b/cylsg/cylsg.Model/UserModel/UserWorker.cs @@ -0,0 +1,82 @@ +锘縰sing cylsg.Core; +using cylsg.Core.Attributes; +using SqlSugar; +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.ComponentModel.DataAnnotations; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace cylsg.Model.UserModel +{ + /// <summary> + /// 鐢ㄦ埛宸ヤ汉 + /// </summary> + [Description("鐢ㄦ埛宸ヤ汉")] + [CoderFirst] + public class UserWorker : BaseModel + { + /// <summary> + /// 鐢ㄦ埛宸ヤ汉Id + /// </summary> + [SugarColumn(ColumnDescription = "鐢ㄦ埛宸ヤ汉ID", IsPrimaryKey = true, IsIdentity = true)] + public int Id { get; set; } + + /// <summary> + /// 鐢ㄦ埛id + /// </summary> + [SugarColumn(ColumnDescription = "鐢ㄦ埛id")] + public int UserId { get; set; } + + /// <summary> + /// 韬唤璇佹闈㈣矾寰� + /// </summary> + [SugarColumn(ColumnDescription = "韬唤璇佹闈㈣矾寰�", ColumnDataType = "nvarchar(500)")] + public string IdCardFace { get; set; } + + /// <summary> + /// 韬唤璇佸弽闈㈣矾寰� + /// </summary> + [SugarColumn(ColumnDescription = "韬唤璇佸弽闈㈣矾寰�", ColumnDataType = "nvarchar(500)")] + public string IdCardBack { get; set; } + + /// <summary> + /// 濮撳悕 + /// </summary> + [SugarColumn(ColumnDescription = "濮撳悕", ColumnDataType = "nvarchar(100)", IsNullable = true)] + public string name { get; set; } + + /// <summary> + /// 鐢佃瘽鍙风爜 + /// </summary> + [SugarColumn(ColumnDescription = "鐢佃瘽鍙风爜", ColumnDataType = "nvarchar(30)", IsNullable = true)] + public string Phone { get; set; } + + /// <summary> + /// 韬唤璇佸彿 + /// </summary> + [SugarColumn(ColumnDescription = "韬唤璇佸彿", ColumnDataType = "nvarchar(30)", IsNullable = true)] + public string IdCode { get; set; } + + /// <summary> + /// 鑱旂郴鍦板潃 + /// </summary> + [SugarColumn(ColumnDescription = "鑱旂郴鍦板潃", ColumnDataType = "nvarchar(500)", IsNullable = true)] + public string Address{ get; set; } + + /// <summary> + /// 绠�鍘嗘弿杩� + /// </summary> + [SugarColumn(ColumnDescription = "绠�鍘嗘弿杩�", ColumnDataType = "nvarchar(2000)", IsNullable = true)] + public string Resume { get; set; } + + /// <summary> + /// 鎻愮幇浣欓 + /// </summary> + [SugarColumn(ColumnDescription = "鎻愮幇浣欓", Length = 18, DecimalDigits = 2, IsNullable = true)] + public decimal? TiXianYue { get; set; } + + } +} -- Gitblit v1.9.1