worker.cs

资产数据库设计

using System;

namespace AdminGoods
{
	/// <summary>
	/// Worker 的摘要说明。
	/// </summary>
	public class Worker
	{
		public Worker()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

//CREATE TABLE [dbo].[worker] (
//	[ID] [bigint] IDENTITY (1, 1) NOT NULL ,
		public int ID;
//	[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
		public string username;
//	[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
		public string password;
//	[workcode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
		public string workcode;
//	[worktype] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
		public string worktype;
//	[realname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
		public string realname;
//	[address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
		public string address;
//	[workage] [bigint] NOT NULL 
		public int workage;
//) ON [PRIMARY]

	}
}