mp-main-v2/.vscode/db.code-snippets

{"查询广告位列表": {
"prefix": "ym-db-Advertisment-Find",
"body": [
"List<Advertisment> $1 = db.Advertisment.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (Advertisment $3 in $1)",
"{",
"}"
]
},
"查询广告位列表，并取值": {
"prefix": "ym-db-Advertisment-FindWithData",
"body": [
"List<Advertisment> $1 = db.Advertisment.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (Advertisment $3 in $1)",
"{",
"	string Title = $3.Title; //标题",
"	string ColId = $3.ColId; //分类",
"	string PicPath = $3.PicPath; //图片",
"	string Contents = $3.Contents; //内容",
"	string Url = $3.Url; //链接地址",
"}"
]
},
"查询广告位": {
"prefix": "ym-db-Advertisment-Exist",
"body": [
"bool $1 = db.Advertisment.Any(m => m.Id == $2);",
]
},
"查询某个广告位，并取值": {
"prefix": "ym-db-Advertisment-FindByPrimaryKey",
"body": [
"Advertisment $1 = db.Advertisment.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string Title = $1.Title; //标题",
"	string ColId = $1.ColId; //分类",
"	string PicPath = $1.PicPath; //图片",
"	string Contents = $1.Contents; //内容",
"	string Url = $1.Url; //链接地址",
"}"
]
},
"查询某个广告位，并赋值": {
"prefix": "ym-db-Advertisment-Update",
"body": [
"Advertisment $1 = db.Advertisment.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.Title = $2; //标题",
"	$1.ColId = $3; //分类",
"	$1.PicPath = $4; //图片",
"	$1.Contents = $5; //内容",
"	$1.Url = $6; //链接地址",
"}"
]
},
"获取广告位数量": {
"prefix": "ym-db-Advertisment-FindAndCount",
"body": [
"int $1 = db.Advertisment.Count(m => $2);",
]
},
"添加广告位": {
"prefix": "ym-db-Advertisment-Create",
"body": [
"db.Advertisment.Add(new Advertisment()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	Title = $1, //标题",
"	ColId = $2, //分类",
"	PicPath = $3, //图片",
"	Contents = $4, //内容",
"	Url = $5, //链接地址",
"});"
]
},"删除某个广告位": {
"prefix": "ym-db-Advertisment-Delete",
"body": [
"Advertisment $1 = db.Advertisment.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.Advertisment.Remove($1);",
"}"
]
},
"查询企业入驻审核记录列表": {
"prefix": "ym-db-BussinessAuditRecord-Find",
"body": [
"List<BussinessAuditRecord> $1 = db.BussinessAuditRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (BussinessAuditRecord $3 in $1)",
"{",
"}"
]
},
"查询企业入驻审核记录列表，并取值": {
"prefix": "ym-db-BussinessAuditRecord-FindWithData",
"body": [
"List<BussinessAuditRecord> $1 = db.BussinessAuditRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (BussinessAuditRecord $3 in $1)",
"{",
"	int UserId = $3.UserId; //会员",
"	int AuditId = $3.AuditId; //审核人",
"	string AuditNote = $3.AuditNote; //审核意见",
"	string UserRealName = $3.UserRealName; //会员姓名",
"	string UserCode = $3.UserCode; //会员编号",
"	string UserMobile = $3.UserMobile; //会员手机号",
"	string SysAdminName = $3.SysAdminName; //审核人名称",
"}"
]
},
"查询企业入驻审核记录": {
"prefix": "ym-db-BussinessAuditRecord-Exist",
"body": [
"bool $1 = db.BussinessAuditRecord.Any(m => m.Id == $2);",
]
},
"查询某个企业入驻审核记录，并取值": {
"prefix": "ym-db-BussinessAuditRecord-FindByPrimaryKey",
"body": [
"BussinessAuditRecord $1 = db.BussinessAuditRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	int UserId = $1.UserId; //会员",
"	int AuditId = $1.AuditId; //审核人",
"	string AuditNote = $1.AuditNote; //审核意见",
"	string UserRealName = $1.UserRealName; //会员姓名",
"	string UserCode = $1.UserCode; //会员编号",
"	string UserMobile = $1.UserMobile; //会员手机号",
"	string SysAdminName = $1.SysAdminName; //审核人名称",
"}"
]
},
"查询某个企业入驻审核记录，并赋值": {
"prefix": "ym-db-BussinessAuditRecord-Update",
"body": [
"BussinessAuditRecord $1 = db.BussinessAuditRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.UserId = $2; //会员",
"	$1.AuditId = $3; //审核人",
"	$1.AuditNote = $4; //审核意见",
"	$1.UserRealName = $5; //会员姓名",
"	$1.UserCode = $6; //会员编号",
"	$1.UserMobile = $7; //会员手机号",
"	$1.SysAdminName = $8; //审核人名称",
"}"
]
},
"获取企业入驻审核记录数量": {
"prefix": "ym-db-BussinessAuditRecord-FindAndCount",
"body": [
"int $1 = db.BussinessAuditRecord.Count(m => $2);",
]
},
"添加企业入驻审核记录": {
"prefix": "ym-db-BussinessAuditRecord-Create",
"body": [
"db.BussinessAuditRecord.Add(new BussinessAuditRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	UserId = $1, //会员",
"	AuditId = $2, //审核人",
"	AuditNote = $3, //审核意见",
"	UserRealName = $4, //会员姓名",
"	UserCode = $5, //会员编号",
"	UserMobile = $6, //会员手机号",
"	SysAdminName = $7, //审核人名称",
"});"
]
},"删除某个企业入驻审核记录": {
"prefix": "ym-db-BussinessAuditRecord-Delete",
"body": [
"BussinessAuditRecord $1 = db.BussinessAuditRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.BussinessAuditRecord.Remove($1);",
"}"
]
},
"查询分类设置列表": {
"prefix": "ym-db-Col-Find",
"body": [
"List<Col> $1 = db.Col.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (Col $3 in $1)",
"{",
"}"
]
},
"查询分类设置列表，并取值": {
"prefix": "ym-db-Col-FindWithData",
"body": [
"List<Col> $1 = db.Col.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (Col $3 in $1)",
"{",
"	string ColId = $3.ColId; //编号",
"	string ColName = $3.ColName; //名称",
"	string ColPicPath = $3.ColPicPath; //图标",
"	string ColDetail = $3.ColDetail; //简介",
"	ulong Recommend = $3.Recommend; //推荐",
"	string ColEnName = $3.ColEnName; //英文名",
"	string Contents = $3.Contents; //详细内容",
"	string Url = $3.Url; //第三方链接",
"}"
]
},
"查询分类设置": {
"prefix": "ym-db-Col-Exist",
"body": [
"bool $1 = db.Col.Any(m => m.Id == $2);",
]
},
"查询某个分类设置，并取值": {
"prefix": "ym-db-Col-FindByPrimaryKey",
"body": [
"Col $1 = db.Col.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string ColId = $1.ColId; //编号",
"	string ColName = $1.ColName; //名称",
"	string ColPicPath = $1.ColPicPath; //图标",
"	string ColDetail = $1.ColDetail; //简介",
"	ulong Recommend = $1.Recommend; //推荐",
"	string ColEnName = $1.ColEnName; //英文名",
"	string Contents = $1.Contents; //详细内容",
"	string Url = $1.Url; //第三方链接",
"}"
]
},
"查询某个分类设置，并赋值": {
"prefix": "ym-db-Col-Update",
"body": [
"Col $1 = db.Col.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.ColId = $2; //编号",
"	$1.ColName = $3; //名称",
"	$1.ColPicPath = $4; //图标",
"	$1.ColDetail = $5; //简介",
"	$1.Recommend = $6; //推荐",
"	$1.ColEnName = $7; //英文名",
"	$1.Contents = $8; //详细内容",
"	$1.Url = $9; //第三方链接",
"}"
]
},
"获取分类设置数量": {
"prefix": "ym-db-Col-FindAndCount",
"body": [
"int $1 = db.Col.Count(m => $2);",
]
},
"添加分类设置": {
"prefix": "ym-db-Col-Create",
"body": [
"db.Col.Add(new Col()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	ColId = $1, //编号",
"	ColName = $2, //名称",
"	ColPicPath = $3, //图标",
"	ColDetail = $4, //简介",
"	Recommend = $5, //推荐",
"	ColEnName = $6, //英文名",
"	Contents = $7, //详细内容",
"	Url = $8, //第三方链接",
"});"
]
},"删除某个分类设置": {
"prefix": "ym-db-Col-Delete",
"body": [
"Col $1 = db.Col.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.Col.Remove($1);",
"}"
]
},
"查询小程序版本库列表": {
"prefix": "ym-db-MiniProgramVersions-Find",
"body": [
"List<MiniProgramVersions> $1 = db.MiniProgramVersions.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MiniProgramVersions $3 in $1)",
"{",
"}"
]
},
"查询小程序版本库列表，并取值": {
"prefix": "ym-db-MiniProgramVersions-FindWithData",
"body": [
"List<MiniProgramVersions> $1 = db.MiniProgramVersions.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MiniProgramVersions $3 in $1)",
"{",
"	int UserId = $3.UserId; //会员",
"	int AuditId = $3.AuditId; //审核人",
"	string AuditNote = $3.AuditNote; //审核意见",
"	string UserRealName = $3.UserRealName; //会员姓名",
"	string UserCode = $3.UserCode; //会员编号",
"	string UserMobile = $3.UserMobile; //会员手机号",
"	string SysAdminName = $3.SysAdminName; //审核人名称",
"	int ProjectId = $3.ProjectId; //项目",
"	string ProjectName = $3.ProjectName; //项目名称",
"	string VerNum = $3.VerNum; //版本号",
"	int UpdateKind = $3.UpdateKind; //更新类型",
"	string UpdateNote = $3.UpdateNote; //更新备注",
"	int VerType = $3.VerType; //版本类型",
"	DateTime AuditDate = $3.AuditDate; //审核时间",
"	DateTime PublishDate = $3.PublishDate; //发布时间",
"	string SourceFilePath = $3.SourceFilePath; //资源文件路径",
"}"
]
},
"查询小程序版本库": {
"prefix": "ym-db-MiniProgramVersions-Exist",
"body": [
"bool $1 = db.MiniProgramVersions.Any(m => m.Id == $2);",
]
},
"查询某个小程序版本库，并取值": {
"prefix": "ym-db-MiniProgramVersions-FindByPrimaryKey",
"body": [
"MiniProgramVersions $1 = db.MiniProgramVersions.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	int UserId = $1.UserId; //会员",
"	int AuditId = $1.AuditId; //审核人",
"	string AuditNote = $1.AuditNote; //审核意见",
"	string UserRealName = $1.UserRealName; //会员姓名",
"	string UserCode = $1.UserCode; //会员编号",
"	string UserMobile = $1.UserMobile; //会员手机号",
"	string SysAdminName = $1.SysAdminName; //审核人名称",
"	int ProjectId = $1.ProjectId; //项目",
"	string ProjectName = $1.ProjectName; //项目名称",
"	string VerNum = $1.VerNum; //版本号",
"	int UpdateKind = $1.UpdateKind; //更新类型",
"	string UpdateNote = $1.UpdateNote; //更新备注",
"	int VerType = $1.VerType; //版本类型",
"	DateTime AuditDate = $1.AuditDate; //审核时间",
"	DateTime PublishDate = $1.PublishDate; //发布时间",
"	string SourceFilePath = $1.SourceFilePath; //资源文件路径",
"}"
]
},
"查询某个小程序版本库，并赋值": {
"prefix": "ym-db-MiniProgramVersions-Update",
"body": [
"MiniProgramVersions $1 = db.MiniProgramVersions.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.UserId = $2; //会员",
"	$1.AuditId = $3; //审核人",
"	$1.AuditNote = $4; //审核意见",
"	$1.UserRealName = $5; //会员姓名",
"	$1.UserCode = $6; //会员编号",
"	$1.UserMobile = $7; //会员手机号",
"	$1.SysAdminName = $8; //审核人名称",
"	$1.ProjectId = $9; //项目",
"	$1.ProjectName = $10; //项目名称",
"	$1.VerNum = $11; //版本号",
"	$1.UpdateKind = $12; //更新类型",
"	$1.UpdateNote = $13; //更新备注",
"	$1.VerType = $14; //版本类型",
"	$1.AuditDate = $15; //审核时间",
"	$1.PublishDate = $16; //发布时间",
"	$1.SourceFilePath = $17; //资源文件路径",
"}"
]
},
"获取小程序版本库数量": {
"prefix": "ym-db-MiniProgramVersions-FindAndCount",
"body": [
"int $1 = db.MiniProgramVersions.Count(m => $2);",
]
},
"添加小程序版本库": {
"prefix": "ym-db-MiniProgramVersions-Create",
"body": [
"db.MiniProgramVersions.Add(new MiniProgramVersions()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	UserId = $1, //会员",
"	AuditId = $2, //审核人",
"	AuditNote = $3, //审核意见",
"	UserRealName = $4, //会员姓名",
"	UserCode = $5, //会员编号",
"	UserMobile = $6, //会员手机号",
"	SysAdminName = $7, //审核人名称",
"	ProjectId = $8, //项目",
"	ProjectName = $9, //项目名称",
"	VerNum = $10, //版本号",
"	UpdateKind = $11, //更新类型",
"	UpdateNote = $12, //更新备注",
"	VerType = $13, //版本类型",
"	AuditDate = $14, //审核时间",
"	PublishDate = $15, //发布时间",
"	SourceFilePath = $16, //资源文件路径",
"});"
]
},"删除某个小程序版本库": {
"prefix": "ym-db-MiniProgramVersions-Delete",
"body": [
"MiniProgramVersions $1 = db.MiniProgramVersions.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MiniProgramVersions.Remove($1);",
"}"
]
},
"查询单页内容列表": {
"prefix": "ym-db-PageInfo-Find",
"body": [
"List<PageInfo> $1 = db.PageInfo.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (PageInfo $3 in $1)",
"{",
"}"
]
},
"查询单页内容列表，并取值": {
"prefix": "ym-db-PageInfo-FindWithData",
"body": [
"List<PageInfo> $1 = db.PageInfo.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (PageInfo $3 in $1)",
"{",
"	string Title = $3.Title; //标题",
"	string ColId = $3.ColId; //分类",
"	string Contents = $3.Contents; //内容",
"}"
]
},
"查询单页内容": {
"prefix": "ym-db-PageInfo-Exist",
"body": [
"bool $1 = db.PageInfo.Any(m => m.Id == $2);",
]
},
"查询某个单页内容，并取值": {
"prefix": "ym-db-PageInfo-FindByPrimaryKey",
"body": [
"PageInfo $1 = db.PageInfo.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string Title = $1.Title; //标题",
"	string ColId = $1.ColId; //分类",
"	string Contents = $1.Contents; //内容",
"}"
]
},
"查询某个单页内容，并赋值": {
"prefix": "ym-db-PageInfo-Update",
"body": [
"PageInfo $1 = db.PageInfo.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.Title = $2; //标题",
"	$1.ColId = $3; //分类",
"	$1.Contents = $4; //内容",
"}"
]
},
"获取单页内容数量": {
"prefix": "ym-db-PageInfo-FindAndCount",
"body": [
"int $1 = db.PageInfo.Count(m => $2);",
]
},
"添加单页内容": {
"prefix": "ym-db-PageInfo-Create",
"body": [
"db.PageInfo.Add(new PageInfo()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	Title = $1, //标题",
"	ColId = $2, //分类",
"	Contents = $3, //内容",
"});"
]
},"删除某个单页内容": {
"prefix": "ym-db-PageInfo-Delete",
"body": [
"PageInfo $1 = db.PageInfo.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.PageInfo.Remove($1);",
"}"
]
},
"查询项目审核记录列表": {
"prefix": "ym-db-ProjectAuditRecord-Find",
"body": [
"List<ProjectAuditRecord> $1 = db.ProjectAuditRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (ProjectAuditRecord $3 in $1)",
"{",
"}"
]
},
"查询项目审核记录列表，并取值": {
"prefix": "ym-db-ProjectAuditRecord-FindWithData",
"body": [
"List<ProjectAuditRecord> $1 = db.ProjectAuditRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (ProjectAuditRecord $3 in $1)",
"{",
"	int UserId = $3.UserId; //会员",
"	int AuditId = $3.AuditId; //审核人",
"	string AuditNote = $3.AuditNote; //审核意见",
"	string UserRealName = $3.UserRealName; //会员姓名",
"	string UserCode = $3.UserCode; //会员编号",
"	string UserMobile = $3.UserMobile; //会员手机号",
"	string SysAdminName = $3.SysAdminName; //审核人名称",
"	int ProjectId = $3.ProjectId; //项目",
"	string ProjectName = $3.ProjectName; //项目名称",
"}"
]
},
"查询项目审核记录": {
"prefix": "ym-db-ProjectAuditRecord-Exist",
"body": [
"bool $1 = db.ProjectAuditRecord.Any(m => m.Id == $2);",
]
},
"查询某个项目审核记录，并取值": {
"prefix": "ym-db-ProjectAuditRecord-FindByPrimaryKey",
"body": [
"ProjectAuditRecord $1 = db.ProjectAuditRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	int UserId = $1.UserId; //会员",
"	int AuditId = $1.AuditId; //审核人",
"	string AuditNote = $1.AuditNote; //审核意见",
"	string UserRealName = $1.UserRealName; //会员姓名",
"	string UserCode = $1.UserCode; //会员编号",
"	string UserMobile = $1.UserMobile; //会员手机号",
"	string SysAdminName = $1.SysAdminName; //审核人名称",
"	int ProjectId = $1.ProjectId; //项目",
"	string ProjectName = $1.ProjectName; //项目名称",
"}"
]
},
"查询某个项目审核记录，并赋值": {
"prefix": "ym-db-ProjectAuditRecord-Update",
"body": [
"ProjectAuditRecord $1 = db.ProjectAuditRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.UserId = $2; //会员",
"	$1.AuditId = $3; //审核人",
"	$1.AuditNote = $4; //审核意见",
"	$1.UserRealName = $5; //会员姓名",
"	$1.UserCode = $6; //会员编号",
"	$1.UserMobile = $7; //会员手机号",
"	$1.SysAdminName = $8; //审核人名称",
"	$1.ProjectId = $9; //项目",
"	$1.ProjectName = $10; //项目名称",
"}"
]
},
"获取项目审核记录数量": {
"prefix": "ym-db-ProjectAuditRecord-FindAndCount",
"body": [
"int $1 = db.ProjectAuditRecord.Count(m => $2);",
]
},
"添加项目审核记录": {
"prefix": "ym-db-ProjectAuditRecord-Create",
"body": [
"db.ProjectAuditRecord.Add(new ProjectAuditRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	UserId = $1, //会员",
"	AuditId = $2, //审核人",
"	AuditNote = $3, //审核意见",
"	UserRealName = $4, //会员姓名",
"	UserCode = $5, //会员编号",
"	UserMobile = $6, //会员手机号",
"	SysAdminName = $7, //审核人名称",
"	ProjectId = $8, //项目",
"	ProjectName = $9, //项目名称",
"});"
]
},"删除某个项目审核记录": {
"prefix": "ym-db-ProjectAuditRecord-Delete",
"body": [
"ProjectAuditRecord $1 = db.ProjectAuditRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.ProjectAuditRecord.Remove($1);",
"}"
]
},
"查询后台管理员列表": {
"prefix": "ym-db-SysAdmin-Find",
"body": [
"List<SysAdmin> $1 = db.SysAdmin.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (SysAdmin $3 in $1)",
"{",
"}"
]
},
"查询后台管理员列表，并取值": {
"prefix": "ym-db-SysAdmin-FindWithData",
"body": [
"List<SysAdmin> $1 = db.SysAdmin.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (SysAdmin $3 in $1)",
"{",
"	string AdminName = $3.AdminName; //用户名",
"	string Password = $3.Password; //密码",
"	string RealName = $3.RealName; //名称",
"	string Role = $3.Role; //角色",
"	DateTime LastLoginDate = $3.LastLoginDate; //最后登录时间",
"}"
]
},
"查询后台管理员": {
"prefix": "ym-db-SysAdmin-Exist",
"body": [
"bool $1 = db.SysAdmin.Any(m => m.Id == $2);",
]
},
"查询某个后台管理员，并取值": {
"prefix": "ym-db-SysAdmin-FindByPrimaryKey",
"body": [
"SysAdmin $1 = db.SysAdmin.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string AdminName = $1.AdminName; //用户名",
"	string Password = $1.Password; //密码",
"	string RealName = $1.RealName; //名称",
"	string Role = $1.Role; //角色",
"	DateTime LastLoginDate = $1.LastLoginDate; //最后登录时间",
"}"
]
},
"查询某个后台管理员，并赋值": {
"prefix": "ym-db-SysAdmin-Update",
"body": [
"SysAdmin $1 = db.SysAdmin.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.AdminName = $2; //用户名",
"	$1.Password = $3; //密码",
"	$1.RealName = $4; //名称",
"	$1.Role = $5; //角色",
"	$1.LastLoginDate = $6; //最后登录时间",
"}"
]
},
"获取后台管理员数量": {
"prefix": "ym-db-SysAdmin-FindAndCount",
"body": [
"int $1 = db.SysAdmin.Count(m => $2);",
]
},
"添加后台管理员": {
"prefix": "ym-db-SysAdmin-Create",
"body": [
"db.SysAdmin.Add(new SysAdmin()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AdminName = $1, //用户名",
"	Password = $2, //密码",
"	RealName = $3, //名称",
"	Role = $4, //角色",
"	LastLoginDate = $5, //最后登录时间",
"});"
]
},"删除某个后台管理员": {
"prefix": "ym-db-SysAdmin-Delete",
"body": [
"SysAdmin $1 = db.SysAdmin.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.SysAdmin.Remove($1);",
"}"
]
},
"查询后台管理员角色列表": {
"prefix": "ym-db-SysAdminRole-Find",
"body": [
"List<SysAdminRole> $1 = db.SysAdminRole.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (SysAdminRole $3 in $1)",
"{",
"}"
]
},
"查询后台管理员角色列表，并取值": {
"prefix": "ym-db-SysAdminRole-FindWithData",
"body": [
"List<SysAdminRole> $1 = db.SysAdminRole.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (SysAdminRole $3 in $1)",
"{",
"	string Name = $3.Name; //名称",
"	string Details = $3.Details; //描述",
"	string RightInfo = $3.RightInfo; //权限设置",
"}"
]
},
"查询后台管理员角色": {
"prefix": "ym-db-SysAdminRole-Exist",
"body": [
"bool $1 = db.SysAdminRole.Any(m => m.Id == $2);",
]
},
"查询某个后台管理员角色，并取值": {
"prefix": "ym-db-SysAdminRole-FindByPrimaryKey",
"body": [
"SysAdminRole $1 = db.SysAdminRole.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string Name = $1.Name; //名称",
"	string Details = $1.Details; //描述",
"	string RightInfo = $1.RightInfo; //权限设置",
"}"
]
},
"查询某个后台管理员角色，并赋值": {
"prefix": "ym-db-SysAdminRole-Update",
"body": [
"SysAdminRole $1 = db.SysAdminRole.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.Name = $2; //名称",
"	$1.Details = $3; //描述",
"	$1.RightInfo = $4; //权限设置",
"}"
]
},
"获取后台管理员角色数量": {
"prefix": "ym-db-SysAdminRole-FindAndCount",
"body": [
"int $1 = db.SysAdminRole.Count(m => $2);",
]
},
"添加后台管理员角色": {
"prefix": "ym-db-SysAdminRole-Create",
"body": [
"db.SysAdminRole.Add(new SysAdminRole()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	Name = $1, //名称",
"	Details = $2, //描述",
"	RightInfo = $3, //权限设置",
"});"
]
},"删除某个后台管理员角色": {
"prefix": "ym-db-SysAdminRole-Delete",
"body": [
"SysAdminRole $1 = db.SysAdminRole.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.SysAdminRole.Remove($1);",
"}"
]
},
"查询系统设置列表": {
"prefix": "ym-db-SystemSet-Find",
"body": [
"List<SystemSet> $1 = db.SystemSet.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (SystemSet $3 in $1)",
"{",
"}"
]
},
"查询系统设置列表，并取值": {
"prefix": "ym-db-SystemSet-FindWithData",
"body": [
"List<SystemSet> $1 = db.SystemSet.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (SystemSet $3 in $1)",
"{",
"	string WebUrl = $3.WebUrl; //网站地址",
"	string WebName = $3.WebName; //网站名称",
"	string IndexKeyword = $3.IndexKeyword; //首页关键词",
"	string IndexDescription = $3.IndexDescription; //首页简介",
"	string UploadExt = $3.UploadExt; //允许上传类型",
"	int UploadMaxSize = $3.UploadMaxSize; //允许最大上传",
"	ulong UploadAutoZoom = $3.UploadAutoZoom; //自动缩略图",
"	int UploadAutoZoomWidth = $3.UploadAutoZoomWidth; //自动缩略图宽",
"	int UploadAutoZoomHeight = $3.UploadAutoZoomHeight; //自动缩略图高",
"	ulong UploadAutoWater = $3.UploadAutoWater; //自动水印",
"	string UploadWaterPosition = $3.UploadWaterPosition; //水印位置",
"	string UploadWaterPath = $3.UploadWaterPath; //水印图片",
"	string RightInfo = $3.RightInfo; //版权信息",
"	string Address = $3.Address; //企业地址",
"	string Phone = $3.Phone; //联系电话",
"	string WebStatCode = $3.WebStatCode; //网站统计代码",
"	string Logo = $3.Logo; //Logo图片",
"}"
]
},
"查询系统设置": {
"prefix": "ym-db-SystemSet-Exist",
"body": [
"bool $1 = db.SystemSet.Any(m => m.Id == $2);",
]
},
"查询某个系统设置，并取值": {
"prefix": "ym-db-SystemSet-FindByPrimaryKey",
"body": [
"SystemSet $1 = db.SystemSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string WebUrl = $1.WebUrl; //网站地址",
"	string WebName = $1.WebName; //网站名称",
"	string IndexKeyword = $1.IndexKeyword; //首页关键词",
"	string IndexDescription = $1.IndexDescription; //首页简介",
"	string UploadExt = $1.UploadExt; //允许上传类型",
"	int UploadMaxSize = $1.UploadMaxSize; //允许最大上传",
"	ulong UploadAutoZoom = $1.UploadAutoZoom; //自动缩略图",
"	int UploadAutoZoomWidth = $1.UploadAutoZoomWidth; //自动缩略图宽",
"	int UploadAutoZoomHeight = $1.UploadAutoZoomHeight; //自动缩略图高",
"	ulong UploadAutoWater = $1.UploadAutoWater; //自动水印",
"	string UploadWaterPosition = $1.UploadWaterPosition; //水印位置",
"	string UploadWaterPath = $1.UploadWaterPath; //水印图片",
"	string RightInfo = $1.RightInfo; //版权信息",
"	string Address = $1.Address; //企业地址",
"	string Phone = $1.Phone; //联系电话",
"	string WebStatCode = $1.WebStatCode; //网站统计代码",
"	string Logo = $1.Logo; //Logo图片",
"}"
]
},
"查询某个系统设置，并赋值": {
"prefix": "ym-db-SystemSet-Update",
"body": [
"SystemSet $1 = db.SystemSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.WebUrl = $2; //网站地址",
"	$1.WebName = $3; //网站名称",
"	$1.IndexKeyword = $4; //首页关键词",
"	$1.IndexDescription = $5; //首页简介",
"	$1.UploadExt = $6; //允许上传类型",
"	$1.UploadMaxSize = $7; //允许最大上传",
"	$1.UploadAutoZoom = $8; //自动缩略图",
"	$1.UploadAutoZoomWidth = $9; //自动缩略图宽",
"	$1.UploadAutoZoomHeight = $10; //自动缩略图高",
"	$1.UploadAutoWater = $11; //自动水印",
"	$1.UploadWaterPosition = $12; //水印位置",
"	$1.UploadWaterPath = $13; //水印图片",
"	$1.RightInfo = $14; //版权信息",
"	$1.Address = $15; //企业地址",
"	$1.Phone = $16; //联系电话",
"	$1.WebStatCode = $17; //网站统计代码",
"	$1.Logo = $18; //Logo图片",
"}"
]
},
"获取系统设置数量": {
"prefix": "ym-db-SystemSet-FindAndCount",
"body": [
"int $1 = db.SystemSet.Count(m => $2);",
]
},
"添加系统设置": {
"prefix": "ym-db-SystemSet-Create",
"body": [
"db.SystemSet.Add(new SystemSet()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	WebUrl = $1, //网站地址",
"	WebName = $2, //网站名称",
"	IndexKeyword = $3, //首页关键词",
"	IndexDescription = $4, //首页简介",
"	UploadExt = $5, //允许上传类型",
"	UploadMaxSize = $6, //允许最大上传",
"	UploadAutoZoom = $7, //自动缩略图",
"	UploadAutoZoomWidth = $8, //自动缩略图宽",
"	UploadAutoZoomHeight = $9, //自动缩略图高",
"	UploadAutoWater = $10, //自动水印",
"	UploadWaterPosition = $11, //水印位置",
"	UploadWaterPath = $12, //水印图片",
"	RightInfo = $13, //版权信息",
"	Address = $14, //企业地址",
"	Phone = $15, //联系电话",
"	WebStatCode = $16, //网站统计代码",
"	Logo = $17, //Logo图片",
"});"
]
},"删除某个系统设置": {
"prefix": "ym-db-SystemSet-Delete",
"body": [
"SystemSet $1 = db.SystemSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.SystemSet.Remove($1);",
"}"
]
},
}