kxs_fee_server/.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-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-MsgBlackList-Find",
"body": [
"List<MsgBlackList> $1 = db.MsgBlackList.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgBlackList $3 in $1)",
"{",
"}"
]
},
"查询消息黑名单列表，并取值": {
"prefix": "ym-db-MsgBlackList-FindWithData",
"body": [
"List<MsgBlackList> $1 = db.MsgBlackList.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgBlackList $3 in $1)",
"{",
"	string ColId = $3.ColId; //分类",
"	int TemplateId = $3.TemplateId; //模板",
"	string Mobile = $3.Mobile; //手机号",
"	string Ip = $3.Ip; //IP地址",
"	string Reason = $3.Reason; //加入黑名单原因",
"	string Remark = $3.Remark; //注释",
"	string Extend = $3.Extend; //扩展字段",
"}"
]
},
"查询消息黑名单": {
"prefix": "ym-db-MsgBlackList-Exist",
"body": [
"bool $1 = db.MsgBlackList.Any(m => m.Id == $2);",
]
},
"查询某个消息黑名单，并取值": {
"prefix": "ym-db-MsgBlackList-FindByPrimaryKey",
"body": [
"MsgBlackList $1 = db.MsgBlackList.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string ColId = $1.ColId; //分类",
"	int TemplateId = $1.TemplateId; //模板",
"	string Mobile = $1.Mobile; //手机号",
"	string Ip = $1.Ip; //IP地址",
"	string Reason = $1.Reason; //加入黑名单原因",
"	string Remark = $1.Remark; //注释",
"	string Extend = $1.Extend; //扩展字段",
"}"
]
},
"查询某个消息黑名单，并赋值": {
"prefix": "ym-db-MsgBlackList-Update",
"body": [
"MsgBlackList $1 = db.MsgBlackList.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.ColId = $2; //分类",
"	$1.TemplateId = $3; //模板",
"	$1.Mobile = $4; //手机号",
"	$1.Ip = $5; //IP地址",
"	$1.Reason = $6; //加入黑名单原因",
"	$1.Remark = $7; //注释",
"	$1.Extend = $8; //扩展字段",
"}"
]
},
"获取消息黑名单数量": {
"prefix": "ym-db-MsgBlackList-FindAndCount",
"body": [
"int $1 = db.MsgBlackList.Count(m => $2);",
]
},
"添加消息黑名单": {
"prefix": "ym-db-MsgBlackList-Create",
"body": [
"db.MsgBlackList.Add(new MsgBlackList()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	ColId = $1, //分类",
"	TemplateId = $2, //模板",
"	Mobile = $3, //手机号",
"	Ip = $4, //IP地址",
"	Reason = $5, //加入黑名单原因",
"	Remark = $6, //注释",
"	Extend = $7, //扩展字段",
"});"
]
},"删除某个消息黑名单": {
"prefix": "ym-db-MsgBlackList-Delete",
"body": [
"MsgBlackList $1 = db.MsgBlackList.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgBlackList.Remove($1);",
"}"
]
},
"查询个人消息列表": {
"prefix": "ym-db-MsgPersonal-Find",
"body": [
"List<MsgPersonal> $1 = db.MsgPersonal.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPersonal $3 in $1)",
"{",
"}"
]
},
"查询个人消息列表，并取值": {
"prefix": "ym-db-MsgPersonal-FindWithData",
"body": [
"List<MsgPersonal> $1 = db.MsgPersonal.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPersonal $3 in $1)",
"{",
"	int TemplateId = $3.TemplateId; //模板",
"	int UserId = $3.UserId; //创客",
"	int MsgType = $3.MsgType; //消息类型",
"	string BgPic = $3.BgPic; //背景图片",
"	string Title = $3.Title; //标题",
"	string Content = $3.Content; //内容",
"	string Url = $3.Url; //跳转Url",
"	string Summary = $3.Summary; //简介",
"	int PushFlag = $3.PushFlag; //推送标记",
"	ulong ReadFlag = $3.ReadFlag; //已读标记",
"	string PushParam = $3.PushParam; //推送参数",
"	string ExtendColumn = $3.ExtendColumn; //扩展字段",
"	string Remark = $3.Remark; //备注",
"}"
]
},
"查询个人消息": {
"prefix": "ym-db-MsgPersonal-Exist",
"body": [
"bool $1 = db.MsgPersonal.Any(m => m.Id == $2);",
]
},
"查询某个个人消息，并取值": {
"prefix": "ym-db-MsgPersonal-FindByPrimaryKey",
"body": [
"MsgPersonal $1 = db.MsgPersonal.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	int TemplateId = $1.TemplateId; //模板",
"	int UserId = $1.UserId; //创客",
"	int MsgType = $1.MsgType; //消息类型",
"	string BgPic = $1.BgPic; //背景图片",
"	string Title = $1.Title; //标题",
"	string Content = $1.Content; //内容",
"	string Url = $1.Url; //跳转Url",
"	string Summary = $1.Summary; //简介",
"	int PushFlag = $1.PushFlag; //推送标记",
"	ulong ReadFlag = $1.ReadFlag; //已读标记",
"	string PushParam = $1.PushParam; //推送参数",
"	string ExtendColumn = $1.ExtendColumn; //扩展字段",
"	string Remark = $1.Remark; //备注",
"}"
]
},
"查询某个个人消息，并赋值": {
"prefix": "ym-db-MsgPersonal-Update",
"body": [
"MsgPersonal $1 = db.MsgPersonal.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.TemplateId = $2; //模板",
"	$1.UserId = $3; //创客",
"	$1.MsgType = $4; //消息类型",
"	$1.BgPic = $5; //背景图片",
"	$1.Title = $6; //标题",
"	$1.Content = $7; //内容",
"	$1.Url = $8; //跳转Url",
"	$1.Summary = $9; //简介",
"	$1.PushFlag = $10; //推送标记",
"	$1.ReadFlag = $11; //已读标记",
"	$1.PushParam = $12; //推送参数",
"	$1.ExtendColumn = $13; //扩展字段",
"	$1.Remark = $14; //备注",
"}"
]
},
"获取个人消息数量": {
"prefix": "ym-db-MsgPersonal-FindAndCount",
"body": [
"int $1 = db.MsgPersonal.Count(m => $2);",
]
},
"添加个人消息": {
"prefix": "ym-db-MsgPersonal-Create",
"body": [
"db.MsgPersonal.Add(new MsgPersonal()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TemplateId = $1, //模板",
"	UserId = $2, //创客",
"	MsgType = $3, //消息类型",
"	BgPic = $4, //背景图片",
"	Title = $5, //标题",
"	Content = $6, //内容",
"	Url = $7, //跳转Url",
"	Summary = $8, //简介",
"	PushFlag = $9, //推送标记",
"	ReadFlag = $10, //已读标记",
"	PushParam = $11, //推送参数",
"	ExtendColumn = $12, //扩展字段",
"	Remark = $13, //备注",
"});"
]
},"删除某个个人消息": {
"prefix": "ym-db-MsgPersonal-Delete",
"body": [
"MsgPersonal $1 = db.MsgPersonal.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgPersonal.Remove($1);",
"}"
]
},
"查询公告消息列表": {
"prefix": "ym-db-MsgPlacard-Find",
"body": [
"List<MsgPlacard> $1 = db.MsgPlacard.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPlacard $3 in $1)",
"{",
"}"
]
},
"查询公告消息列表，并取值": {
"prefix": "ym-db-MsgPlacard-FindWithData",
"body": [
"List<MsgPlacard> $1 = db.MsgPlacard.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPlacard $3 in $1)",
"{",
"	int MsgType = $3.MsgType; //消息类型",
"	string Title = $3.Title; //标题",
"	string Summary = $3.Summary; //简介",
"	string Content = $3.Content; //内容",
"	ulong IsTop = $3.IsTop; //置顶",
"	int ShowType = $3.ShowType; //展示类型",
"	DateTime EffectStartDate = $3.EffectStartDate; //有效开始时间",
"	DateTime EffectEndDate = $3.EffectEndDate; //有效结束时间",
"	string BgPic = $3.BgPic; //背景图片",
"	int PushType = $3.PushType; //推送类型",
"	int PushFlag = $3.PushFlag; //推送标记",
"	string PushParam = $3.PushParam; //推送参数",
"	DateTime PushTime = $3.PushTime; //推送时间",
"	string ExtendColumn = $3.ExtendColumn; //扩展字段",
"	string Remark = $3.Remark; //备注",
"	string Url = $3.Url; //跳转Url",
"}"
]
},
"查询公告消息": {
"prefix": "ym-db-MsgPlacard-Exist",
"body": [
"bool $1 = db.MsgPlacard.Any(m => m.Id == $2);",
]
},
"查询某个公告消息，并取值": {
"prefix": "ym-db-MsgPlacard-FindByPrimaryKey",
"body": [
"MsgPlacard $1 = db.MsgPlacard.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	int MsgType = $1.MsgType; //消息类型",
"	string Title = $1.Title; //标题",
"	string Summary = $1.Summary; //简介",
"	string Content = $1.Content; //内容",
"	ulong IsTop = $1.IsTop; //置顶",
"	int ShowType = $1.ShowType; //展示类型",
"	DateTime EffectStartDate = $1.EffectStartDate; //有效开始时间",
"	DateTime EffectEndDate = $1.EffectEndDate; //有效结束时间",
"	string BgPic = $1.BgPic; //背景图片",
"	int PushType = $1.PushType; //推送类型",
"	int PushFlag = $1.PushFlag; //推送标记",
"	string PushParam = $1.PushParam; //推送参数",
"	DateTime PushTime = $1.PushTime; //推送时间",
"	string ExtendColumn = $1.ExtendColumn; //扩展字段",
"	string Remark = $1.Remark; //备注",
"	string Url = $1.Url; //跳转Url",
"}"
]
},
"查询某个公告消息，并赋值": {
"prefix": "ym-db-MsgPlacard-Update",
"body": [
"MsgPlacard $1 = db.MsgPlacard.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.MsgType = $2; //消息类型",
"	$1.Title = $3; //标题",
"	$1.Summary = $4; //简介",
"	$1.Content = $5; //内容",
"	$1.IsTop = $6; //置顶",
"	$1.ShowType = $7; //展示类型",
"	$1.EffectStartDate = $8; //有效开始时间",
"	$1.EffectEndDate = $9; //有效结束时间",
"	$1.BgPic = $10; //背景图片",
"	$1.PushType = $11; //推送类型",
"	$1.PushFlag = $12; //推送标记",
"	$1.PushParam = $13; //推送参数",
"	$1.PushTime = $14; //推送时间",
"	$1.ExtendColumn = $15; //扩展字段",
"	$1.Remark = $16; //备注",
"	$1.Url = $17; //跳转Url",
"}"
]
},
"获取公告消息数量": {
"prefix": "ym-db-MsgPlacard-FindAndCount",
"body": [
"int $1 = db.MsgPlacard.Count(m => $2);",
]
},
"添加公告消息": {
"prefix": "ym-db-MsgPlacard-Create",
"body": [
"db.MsgPlacard.Add(new MsgPlacard()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	MsgType = $1, //消息类型",
"	Title = $2, //标题",
"	Summary = $3, //简介",
"	Content = $4, //内容",
"	IsTop = $5, //置顶",
"	ShowType = $6, //展示类型",
"	EffectStartDate = $7, //有效开始时间",
"	EffectEndDate = $8, //有效结束时间",
"	BgPic = $9, //背景图片",
"	PushType = $10, //推送类型",
"	PushFlag = $11, //推送标记",
"	PushParam = $12, //推送参数",
"	PushTime = $13, //推送时间",
"	ExtendColumn = $14, //扩展字段",
"	Remark = $15, //备注",
"	Url = $16, //跳转Url",
"});"
]
},"删除某个公告消息": {
"prefix": "ym-db-MsgPlacard-Delete",
"body": [
"MsgPlacard $1 = db.MsgPlacard.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgPlacard.Remove($1);",
"}"
]
},
"查询公告消息已读记录列表": {
"prefix": "ym-db-MsgPlacardRead-Find",
"body": [
"List<MsgPlacardRead> $1 = db.MsgPlacardRead.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPlacardRead $3 in $1)",
"{",
"}"
]
},
"查询公告消息已读记录列表，并取值": {
"prefix": "ym-db-MsgPlacardRead-FindWithData",
"body": [
"List<MsgPlacardRead> $1 = db.MsgPlacardRead.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPlacardRead $3 in $1)",
"{",
"	int PlacardId = $3.PlacardId; //公告",
"	string UserId = $3.UserId; //用户ID",
"	ulong ReadFlag = $3.ReadFlag; //已读标记",
"	string Remark = $3.Remark; //备注",
"}"
]
},
"查询公告消息已读记录": {
"prefix": "ym-db-MsgPlacardRead-Exist",
"body": [
"bool $1 = db.MsgPlacardRead.Any(m => m.Id == $2);",
]
},
"查询某个公告消息已读记录，并取值": {
"prefix": "ym-db-MsgPlacardRead-FindByPrimaryKey",
"body": [
"MsgPlacardRead $1 = db.MsgPlacardRead.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	int PlacardId = $1.PlacardId; //公告",
"	string UserId = $1.UserId; //用户ID",
"	ulong ReadFlag = $1.ReadFlag; //已读标记",
"	string Remark = $1.Remark; //备注",
"}"
]
},
"查询某个公告消息已读记录，并赋值": {
"prefix": "ym-db-MsgPlacardRead-Update",
"body": [
"MsgPlacardRead $1 = db.MsgPlacardRead.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.PlacardId = $2; //公告",
"	$1.UserId = $3; //用户ID",
"	$1.ReadFlag = $4; //已读标记",
"	$1.Remark = $5; //备注",
"}"
]
},
"获取公告消息已读记录数量": {
"prefix": "ym-db-MsgPlacardRead-FindAndCount",
"body": [
"int $1 = db.MsgPlacardRead.Count(m => $2);",
]
},
"添加公告消息已读记录": {
"prefix": "ym-db-MsgPlacardRead-Create",
"body": [
"db.MsgPlacardRead.Add(new MsgPlacardRead()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	PlacardId = $1, //公告",
"	UserId = $2, //用户ID",
"	ReadFlag = $3, //已读标记",
"	Remark = $4, //备注",
"});"
]
},"删除某个公告消息已读记录": {
"prefix": "ym-db-MsgPlacardRead-Delete",
"body": [
"MsgPlacardRead $1 = db.MsgPlacardRead.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgPlacardRead.Remove($1);",
"}"
]
},
"查询推送消息记录列表": {
"prefix": "ym-db-MsgPush-Find",
"body": [
"List<MsgPush> $1 = db.MsgPush.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPush $3 in $1)",
"{",
"}"
]
},
"查询推送消息记录列表，并取值": {
"prefix": "ym-db-MsgPush-FindWithData",
"body": [
"List<MsgPush> $1 = db.MsgPush.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgPush $3 in $1)",
"{",
"	string ClientType = $3.ClientType; //客户端类型",
"	string Url = $3.Url; //链接地址",
"	string Title = $3.Title; //推送标题",
"	string Details = $3.Details; //推送内容",
"	ulong IsSilent = $3.IsSilent; //静音推送",
"	string Devices = $3.Devices; //设备号",
"	int TemplateId = $3.TemplateId; //模板",
"	DateTime AutoPushDate = $3.AutoPushDate; //定时推送时间",
"	string MessageId = $3.MessageId; //推送返回码",
"	string Mobiles = $3.Mobiles; //手机号",
"}"
]
},
"查询推送消息记录": {
"prefix": "ym-db-MsgPush-Exist",
"body": [
"bool $1 = db.MsgPush.Any(m => m.Id == $2);",
]
},
"查询某个推送消息记录，并取值": {
"prefix": "ym-db-MsgPush-FindByPrimaryKey",
"body": [
"MsgPush $1 = db.MsgPush.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string ClientType = $1.ClientType; //客户端类型",
"	string Url = $1.Url; //链接地址",
"	string Title = $1.Title; //推送标题",
"	string Details = $1.Details; //推送内容",
"	ulong IsSilent = $1.IsSilent; //静音推送",
"	string Devices = $1.Devices; //设备号",
"	int TemplateId = $1.TemplateId; //模板",
"	DateTime AutoPushDate = $1.AutoPushDate; //定时推送时间",
"	string MessageId = $1.MessageId; //推送返回码",
"	string Mobiles = $1.Mobiles; //手机号",
"}"
]
},
"查询某个推送消息记录，并赋值": {
"prefix": "ym-db-MsgPush-Update",
"body": [
"MsgPush $1 = db.MsgPush.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.ClientType = $2; //客户端类型",
"	$1.Url = $3; //链接地址",
"	$1.Title = $4; //推送标题",
"	$1.Details = $5; //推送内容",
"	$1.IsSilent = $6; //静音推送",
"	$1.Devices = $7; //设备号",
"	$1.TemplateId = $8; //模板",
"	$1.AutoPushDate = $9; //定时推送时间",
"	$1.MessageId = $10; //推送返回码",
"	$1.Mobiles = $11; //手机号",
"}"
]
},
"获取推送消息记录数量": {
"prefix": "ym-db-MsgPush-FindAndCount",
"body": [
"int $1 = db.MsgPush.Count(m => $2);",
]
},
"添加推送消息记录": {
"prefix": "ym-db-MsgPush-Create",
"body": [
"db.MsgPush.Add(new MsgPush()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	ClientType = $1, //客户端类型",
"	Url = $2, //链接地址",
"	Title = $3, //推送标题",
"	Details = $4, //推送内容",
"	IsSilent = $5, //静音推送",
"	Devices = $6, //设备号",
"	TemplateId = $7, //模板",
"	AutoPushDate = $8, //定时推送时间",
"	MessageId = $9, //推送返回码",
"	Mobiles = $10, //手机号",
"});"
]
},"删除某个推送消息记录": {
"prefix": "ym-db-MsgPush-Delete",
"body": [
"MsgPush $1 = db.MsgPush.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgPush.Remove($1);",
"}"
]
},
"查询发送短信记录列表": {
"prefix": "ym-db-MsgSms-Find",
"body": [
"List<MsgSms> $1 = db.MsgSms.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgSms $3 in $1)",
"{",
"}"
]
},
"查询发送短信记录列表，并取值": {
"prefix": "ym-db-MsgSms-FindWithData",
"body": [
"List<MsgSms> $1 = db.MsgSms.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgSms $3 in $1)",
"{",
"	string ColId = $3.ColId; //分类",
"	int TemplateId = $3.TemplateId; //模板",
"	string Mobile = $3.Mobile; //手机号",
"	string Ip = $3.Ip; //IP地址",
"	int SendType = $3.SendType; //发送类别",
"	int SmsType = $3.SmsType; //短信内容类型",
"	string Content = $3.Content; //内容",
"	string SignName = $3.SignName; //签名",
"	DateTime SendTime = $3.SendTime; //发送时间",
"	string RespContent = $3.RespContent; //返回报文",
"	string RespCode = $3.RespCode; //返回码",
"	string VerifyCode = $3.VerifyCode; //验证码",
"	int ErrorNum = $3.ErrorNum; //错误次数",
"	int VerifyStatus = $3.VerifyStatus; //校验状态",
"}"
]
},
"查询发送短信记录": {
"prefix": "ym-db-MsgSms-Exist",
"body": [
"bool $1 = db.MsgSms.Any(m => m.Id == $2);",
]
},
"查询某个发送短信记录，并取值": {
"prefix": "ym-db-MsgSms-FindByPrimaryKey",
"body": [
"MsgSms $1 = db.MsgSms.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string ColId = $1.ColId; //分类",
"	int TemplateId = $1.TemplateId; //模板",
"	string Mobile = $1.Mobile; //手机号",
"	string Ip = $1.Ip; //IP地址",
"	int SendType = $1.SendType; //发送类别",
"	int SmsType = $1.SmsType; //短信内容类型",
"	string Content = $1.Content; //内容",
"	string SignName = $1.SignName; //签名",
"	DateTime SendTime = $1.SendTime; //发送时间",
"	string RespContent = $1.RespContent; //返回报文",
"	string RespCode = $1.RespCode; //返回码",
"	string VerifyCode = $1.VerifyCode; //验证码",
"	int ErrorNum = $1.ErrorNum; //错误次数",
"	int VerifyStatus = $1.VerifyStatus; //校验状态",
"}"
]
},
"查询某个发送短信记录，并赋值": {
"prefix": "ym-db-MsgSms-Update",
"body": [
"MsgSms $1 = db.MsgSms.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.ColId = $2; //分类",
"	$1.TemplateId = $3; //模板",
"	$1.Mobile = $4; //手机号",
"	$1.Ip = $5; //IP地址",
"	$1.SendType = $6; //发送类别",
"	$1.SmsType = $7; //短信内容类型",
"	$1.Content = $8; //内容",
"	$1.SignName = $9; //签名",
"	$1.SendTime = $10; //发送时间",
"	$1.RespContent = $11; //返回报文",
"	$1.RespCode = $12; //返回码",
"	$1.VerifyCode = $13; //验证码",
"	$1.ErrorNum = $14; //错误次数",
"	$1.VerifyStatus = $15; //校验状态",
"}"
]
},
"获取发送短信记录数量": {
"prefix": "ym-db-MsgSms-FindAndCount",
"body": [
"int $1 = db.MsgSms.Count(m => $2);",
]
},
"添加发送短信记录": {
"prefix": "ym-db-MsgSms-Create",
"body": [
"db.MsgSms.Add(new MsgSms()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	ColId = $1, //分类",
"	TemplateId = $2, //模板",
"	Mobile = $3, //手机号",
"	Ip = $4, //IP地址",
"	SendType = $5, //发送类别",
"	SmsType = $6, //短信内容类型",
"	Content = $7, //内容",
"	SignName = $8, //签名",
"	SendTime = $9, //发送时间",
"	RespContent = $10, //返回报文",
"	RespCode = $11, //返回码",
"	VerifyCode = $12, //验证码",
"	ErrorNum = $13, //错误次数",
"	VerifyStatus = $14, //校验状态",
"});"
]
},"删除某个发送短信记录": {
"prefix": "ym-db-MsgSms-Delete",
"body": [
"MsgSms $1 = db.MsgSms.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgSms.Remove($1);",
"}"
]
},
"查询发送短信配置列表": {
"prefix": "ym-db-MsgSmsSet-Find",
"body": [
"List<MsgSmsSet> $1 = db.MsgSmsSet.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgSmsSet $3 in $1)",
"{",
"}"
]
},
"查询发送短信配置列表，并取值": {
"prefix": "ym-db-MsgSmsSet-FindWithData",
"body": [
"List<MsgSmsSet> $1 = db.MsgSmsSet.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgSmsSet $3 in $1)",
"{",
"	string Name = $3.Name; //渠道名称",
"	string UserName = $3.UserName; //账号",
"	string AuthPwd = $3.AuthPwd; //密码",
"	int SmsType = $3.SmsType; //类别",
"	string ReqUrl = $3.ReqUrl; //请求地址",
"	string Params = $3.Params; //请求参数",
"}"
]
},
"查询发送短信配置": {
"prefix": "ym-db-MsgSmsSet-Exist",
"body": [
"bool $1 = db.MsgSmsSet.Any(m => m.Id == $2);",
]
},
"查询某个发送短信配置，并取值": {
"prefix": "ym-db-MsgSmsSet-FindByPrimaryKey",
"body": [
"MsgSmsSet $1 = db.MsgSmsSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string Name = $1.Name; //渠道名称",
"	string UserName = $1.UserName; //账号",
"	string AuthPwd = $1.AuthPwd; //密码",
"	int SmsType = $1.SmsType; //类别",
"	string ReqUrl = $1.ReqUrl; //请求地址",
"	string Params = $1.Params; //请求参数",
"}"
]
},
"查询某个发送短信配置，并赋值": {
"prefix": "ym-db-MsgSmsSet-Update",
"body": [
"MsgSmsSet $1 = db.MsgSmsSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.Name = $2; //渠道名称",
"	$1.UserName = $3; //账号",
"	$1.AuthPwd = $4; //密码",
"	$1.SmsType = $5; //类别",
"	$1.ReqUrl = $6; //请求地址",
"	$1.Params = $7; //请求参数",
"}"
]
},
"获取发送短信配置数量": {
"prefix": "ym-db-MsgSmsSet-FindAndCount",
"body": [
"int $1 = db.MsgSmsSet.Count(m => $2);",
]
},
"添加发送短信配置": {
"prefix": "ym-db-MsgSmsSet-Create",
"body": [
"db.MsgSmsSet.Add(new MsgSmsSet()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	Name = $1, //渠道名称",
"	UserName = $2, //账号",
"	AuthPwd = $3, //密码",
"	SmsType = $4, //类别",
"	ReqUrl = $5, //请求地址",
"	Params = $6, //请求参数",
"});"
]
},"删除某个发送短信配置": {
"prefix": "ym-db-MsgSmsSet-Delete",
"body": [
"MsgSmsSet $1 = db.MsgSmsSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgSmsSet.Remove($1);",
"}"
]
},
"查询消息模板列表": {
"prefix": "ym-db-MsgTemplate-Find",
"body": [
"List<MsgTemplate> $1 = db.MsgTemplate.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgTemplate $3 in $1)",
"{",
"}"
]
},
"查询消息模板列表，并取值": {
"prefix": "ym-db-MsgTemplate-FindWithData",
"body": [
"List<MsgTemplate> $1 = db.MsgTemplate.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MsgTemplate $3 in $1)",
"{",
"	string Title = $3.Title; //标题",
"	string Content = $3.Content; //内容",
"	string ColId = $3.ColId; //分类",
"	int TemplateType = $3.TemplateType; //类型",
"	int MsgType = $3.MsgType; //消息类型",
"	string Remark = $3.Remark; //注释",
"	string Extend = $3.Extend; //扩展字段",
"}"
]
},
"查询消息模板": {
"prefix": "ym-db-MsgTemplate-Exist",
"body": [
"bool $1 = db.MsgTemplate.Any(m => m.Id == $2);",
]
},
"查询某个消息模板，并取值": {
"prefix": "ym-db-MsgTemplate-FindByPrimaryKey",
"body": [
"MsgTemplate $1 = db.MsgTemplate.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string Title = $1.Title; //标题",
"	string Content = $1.Content; //内容",
"	string ColId = $1.ColId; //分类",
"	int TemplateType = $1.TemplateType; //类型",
"	int MsgType = $1.MsgType; //消息类型",
"	string Remark = $1.Remark; //注释",
"	string Extend = $1.Extend; //扩展字段",
"}"
]
},
"查询某个消息模板，并赋值": {
"prefix": "ym-db-MsgTemplate-Update",
"body": [
"MsgTemplate $1 = db.MsgTemplate.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.Title = $2; //标题",
"	$1.Content = $3; //内容",
"	$1.ColId = $4; //分类",
"	$1.TemplateType = $5; //类型",
"	$1.MsgType = $6; //消息类型",
"	$1.Remark = $7; //注释",
"	$1.Extend = $8; //扩展字段",
"}"
]
},
"获取消息模板数量": {
"prefix": "ym-db-MsgTemplate-FindAndCount",
"body": [
"int $1 = db.MsgTemplate.Count(m => $2);",
]
},
"添加消息模板": {
"prefix": "ym-db-MsgTemplate-Create",
"body": [
"db.MsgTemplate.Add(new MsgTemplate()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	Title = $1, //标题",
"	Content = $2, //内容",
"	ColId = $3, //分类",
"	TemplateType = $4, //类型",
"	MsgType = $5, //消息类型",
"	Remark = $6, //注释",
"	Extend = $7, //扩展字段",
"});"
]
},"删除某个消息模板": {
"prefix": "ym-db-MsgTemplate-Delete",
"body": [
"MsgTemplate $1 = db.MsgTemplate.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.MsgTemplate.Remove($1);",
"}"
]
},
"查询操作日志列表": {
"prefix": "ym-db-OperateLog-Find",
"body": [
"List<OperateLog> $1 = db.OperateLog.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (OperateLog $3 in $1)",
"{",
"}"
]
},
"查询操作日志列表，并取值": {
"prefix": "ym-db-OperateLog-FindWithData",
"body": [
"List<OperateLog> $1 = db.OperateLog.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (OperateLog $3 in $1)",
"{",
"	string TableEnName = $3.TableEnName; //表",
"	string OperateMan = $3.OperateMan; //操作员",
"	string BeforeOperate = $3.BeforeOperate; //操作前的数据",
"	string AfterOperate = $3.AfterOperate; //操作后的数据",
"	string OpMode = $3.OpMode; //操作方式",
"}"
]
},
"查询操作日志": {
"prefix": "ym-db-OperateLog-Exist",
"body": [
"bool $1 = db.OperateLog.Any(m => m.Id == $2);",
]
},
"查询某个操作日志，并取值": {
"prefix": "ym-db-OperateLog-FindByPrimaryKey",
"body": [
"OperateLog $1 = db.OperateLog.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string TableEnName = $1.TableEnName; //表",
"	string OperateMan = $1.OperateMan; //操作员",
"	string BeforeOperate = $1.BeforeOperate; //操作前的数据",
"	string AfterOperate = $1.AfterOperate; //操作后的数据",
"	string OpMode = $1.OpMode; //操作方式",
"}"
]
},
"查询某个操作日志，并赋值": {
"prefix": "ym-db-OperateLog-Update",
"body": [
"OperateLog $1 = db.OperateLog.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.TableEnName = $2; //表",
"	$1.OperateMan = $3; //操作员",
"	$1.BeforeOperate = $4; //操作前的数据",
"	$1.AfterOperate = $5; //操作后的数据",
"	$1.OpMode = $6; //操作方式",
"}"
]
},
"获取操作日志数量": {
"prefix": "ym-db-OperateLog-FindAndCount",
"body": [
"int $1 = db.OperateLog.Count(m => $2);",
]
},
"添加操作日志": {
"prefix": "ym-db-OperateLog-Create",
"body": [
"db.OperateLog.Add(new OperateLog()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TableEnName = $1, //表",
"	OperateMan = $2, //操作员",
"	BeforeOperate = $3, //操作前的数据",
"	AfterOperate = $4, //操作后的数据",
"	OpMode = $5, //操作方式",
"});"
]
},"删除某个操作日志": {
"prefix": "ym-db-OperateLog-Delete",
"body": [
"OperateLog $1 = db.OperateLog.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.OperateLog.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-PublicAccountSet-Find",
"body": [
"List<PublicAccountSet> $1 = db.PublicAccountSet.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (PublicAccountSet $3 in $1)",
"{",
"}"
]
},
"查询第三方平台设置列表，并取值": {
"prefix": "ym-db-PublicAccountSet-FindWithData",
"body": [
"List<PublicAccountSet> $1 = db.PublicAccountSet.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (PublicAccountSet $3 in $1)",
"{",
"	int Id = $3.Id; //Id",
"	string AlipayAppId = $3.AlipayAppId; //支付宝AppId",
"	string AlipayPartnerId = $3.AlipayPartnerId; //支付宝合作者Id",
"	string AlipayPrivateKey = $3.AlipayPrivateKey; //支付宝私钥",
"	string AlipayPublicKey = $3.AlipayPublicKey; //支付宝公钥",
"	string WeChatAppId = $3.WeChatAppId; //微信公众号AppId",
"	string WeChatAppSecret = $3.WeChatAppSecret; //微信公众号AppSecret",
"	string WeChatMchId = $3.WeChatMchId; //微信商户号",
"	string WeChatPayKey = $3.WeChatPayKey; //微信支付密钥",
"	string WeChatOpenAppId = $3.WeChatOpenAppId; //微信开放平台AppId",
"	string WeChatOpenAppSecret = $3.WeChatOpenAppSecret; //微信开放平台AppSecret",
"	string ServerIp = $3.ServerIp; //服务器IP",
"	string WeChatMiniAppId = $3.WeChatMiniAppId; //微信小程序AppId",
"	string WeChatMiniAppSecret = $3.WeChatMiniAppSecret; //微信小程序AppSecret",
"	string QqAndroidAppId = $3.QqAndroidAppId; //QQ安卓AppId",
"	string QqAndroidAppKey = $3.QqAndroidAppKey; //QQ安卓AppKey",
"	string QqIosAppId = $3.QqIosAppId; //QQIOSAppId",
"	string QqIosAppKey = $3.QqIosAppKey; //QQIOSAppKey",
"	string AliyunAccessKeyId = $3.AliyunAccessKeyId; //阿里云AccessKeyID",
"	string AliyunAccessKeySecret = $3.AliyunAccessKeySecret; //阿里云AccessKeySecret",
"	string AliyunPushAndroidAppId = $3.AliyunPushAndroidAppId; //阿里云推送安卓AppId",
"	string AliyunPushAndroidAppSecret = $3.AliyunPushAndroidAppSecret; //阿里云推送安卓AppSecret",
"	string AliyunPushIosAppId = $3.AliyunPushIosAppId; //阿里云推送IOSAppId",
"	string AliyunPushIosAppSecret = $3.AliyunPushIosAppSecret; //阿里云推送IOSAppSecret",
"	string MobAppKey = $3.MobAppKey; //MobAppKey",
"	string MobAppSecret = $3.MobAppSecret; //MobAppSecret",
"	string MeiQiaAppKey = $3.MeiQiaAppKey; //美洽AppKey",
"	string ErpApiUrl = $3.ErpApiUrl; //请求地址",
"	string ErpAppCode = $3.ErpAppCode; //AppCode",
"	string SmsApiPwd = $3.SmsApiPwd; //密码",
"	string SmsApiSign = $3.SmsApiSign; //签名",
"	string SmsApiUserId = $3.SmsApiUserId; //账号",
"	string SmsApiDefaultTemplate = $3.SmsApiDefaultTemplate; //默认验证码模板",
"	string AliyunRegionId = $3.AliyunRegionId; //阿里云服务器别名",
"	string AliyunAndroidNotifyTitle = $3.AliyunAndroidNotifyTitle; //阿里云安卓弹窗标题",
"	string AliyunAndroidActivity = $3.AliyunAndroidActivity; //阿里云点击通知后跳转的Activity",
"}"
]
},
"查询第三方平台设置": {
"prefix": "ym-db-PublicAccountSet-Exist",
"body": [
"bool $1 = db.PublicAccountSet.Any(m => m.Id == $2);",
]
},
"查询某个第三方平台设置，并取值": {
"prefix": "ym-db-PublicAccountSet-FindByPrimaryKey",
"body": [
"PublicAccountSet $1 = db.PublicAccountSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	int Id = $1.Id; //Id",
"	string AlipayAppId = $1.AlipayAppId; //支付宝AppId",
"	string AlipayPartnerId = $1.AlipayPartnerId; //支付宝合作者Id",
"	string AlipayPrivateKey = $1.AlipayPrivateKey; //支付宝私钥",
"	string AlipayPublicKey = $1.AlipayPublicKey; //支付宝公钥",
"	string WeChatAppId = $1.WeChatAppId; //微信公众号AppId",
"	string WeChatAppSecret = $1.WeChatAppSecret; //微信公众号AppSecret",
"	string WeChatMchId = $1.WeChatMchId; //微信商户号",
"	string WeChatPayKey = $1.WeChatPayKey; //微信支付密钥",
"	string WeChatOpenAppId = $1.WeChatOpenAppId; //微信开放平台AppId",
"	string WeChatOpenAppSecret = $1.WeChatOpenAppSecret; //微信开放平台AppSecret",
"	string ServerIp = $1.ServerIp; //服务器IP",
"	string WeChatMiniAppId = $1.WeChatMiniAppId; //微信小程序AppId",
"	string WeChatMiniAppSecret = $1.WeChatMiniAppSecret; //微信小程序AppSecret",
"	string QqAndroidAppId = $1.QqAndroidAppId; //QQ安卓AppId",
"	string QqAndroidAppKey = $1.QqAndroidAppKey; //QQ安卓AppKey",
"	string QqIosAppId = $1.QqIosAppId; //QQIOSAppId",
"	string QqIosAppKey = $1.QqIosAppKey; //QQIOSAppKey",
"	string AliyunAccessKeyId = $1.AliyunAccessKeyId; //阿里云AccessKeyID",
"	string AliyunAccessKeySecret = $1.AliyunAccessKeySecret; //阿里云AccessKeySecret",
"	string AliyunPushAndroidAppId = $1.AliyunPushAndroidAppId; //阿里云推送安卓AppId",
"	string AliyunPushAndroidAppSecret = $1.AliyunPushAndroidAppSecret; //阿里云推送安卓AppSecret",
"	string AliyunPushIosAppId = $1.AliyunPushIosAppId; //阿里云推送IOSAppId",
"	string AliyunPushIosAppSecret = $1.AliyunPushIosAppSecret; //阿里云推送IOSAppSecret",
"	string MobAppKey = $1.MobAppKey; //MobAppKey",
"	string MobAppSecret = $1.MobAppSecret; //MobAppSecret",
"	string MeiQiaAppKey = $1.MeiQiaAppKey; //美洽AppKey",
"	string ErpApiUrl = $1.ErpApiUrl; //请求地址",
"	string ErpAppCode = $1.ErpAppCode; //AppCode",
"	string SmsApiPwd = $1.SmsApiPwd; //密码",
"	string SmsApiSign = $1.SmsApiSign; //签名",
"	string SmsApiUserId = $1.SmsApiUserId; //账号",
"	string SmsApiDefaultTemplate = $1.SmsApiDefaultTemplate; //默认验证码模板",
"	string AliyunRegionId = $1.AliyunRegionId; //阿里云服务器别名",
"	string AliyunAndroidNotifyTitle = $1.AliyunAndroidNotifyTitle; //阿里云安卓弹窗标题",
"	string AliyunAndroidActivity = $1.AliyunAndroidActivity; //阿里云点击通知后跳转的Activity",
"}"
]
},
"查询某个第三方平台设置，并赋值": {
"prefix": "ym-db-PublicAccountSet-Update",
"body": [
"PublicAccountSet $1 = db.PublicAccountSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.Id = $2; //Id",
"	$1.AlipayAppId = $3; //支付宝AppId",
"	$1.AlipayPartnerId = $4; //支付宝合作者Id",
"	$1.AlipayPrivateKey = $5; //支付宝私钥",
"	$1.AlipayPublicKey = $6; //支付宝公钥",
"	$1.WeChatAppId = $7; //微信公众号AppId",
"	$1.WeChatAppSecret = $8; //微信公众号AppSecret",
"	$1.WeChatMchId = $9; //微信商户号",
"	$1.WeChatPayKey = $10; //微信支付密钥",
"	$1.WeChatOpenAppId = $11; //微信开放平台AppId",
"	$1.WeChatOpenAppSecret = $12; //微信开放平台AppSecret",
"	$1.ServerIp = $13; //服务器IP",
"	$1.WeChatMiniAppId = $14; //微信小程序AppId",
"	$1.WeChatMiniAppSecret = $15; //微信小程序AppSecret",
"	$1.QqAndroidAppId = $16; //QQ安卓AppId",
"	$1.QqAndroidAppKey = $17; //QQ安卓AppKey",
"	$1.QqIosAppId = $18; //QQIOSAppId",
"	$1.QqIosAppKey = $19; //QQIOSAppKey",
"	$1.AliyunAccessKeyId = $20; //阿里云AccessKeyID",
"	$1.AliyunAccessKeySecret = $21; //阿里云AccessKeySecret",
"	$1.AliyunPushAndroidAppId = $22; //阿里云推送安卓AppId",
"	$1.AliyunPushAndroidAppSecret = $23; //阿里云推送安卓AppSecret",
"	$1.AliyunPushIosAppId = $24; //阿里云推送IOSAppId",
"	$1.AliyunPushIosAppSecret = $25; //阿里云推送IOSAppSecret",
"	$1.MobAppKey = $26; //MobAppKey",
"	$1.MobAppSecret = $27; //MobAppSecret",
"	$1.MeiQiaAppKey = $28; //美洽AppKey",
"	$1.ErpApiUrl = $29; //请求地址",
"	$1.ErpAppCode = $30; //AppCode",
"	$1.SmsApiPwd = $31; //密码",
"	$1.SmsApiSign = $32; //签名",
"	$1.SmsApiUserId = $33; //账号",
"	$1.SmsApiDefaultTemplate = $34; //默认验证码模板",
"	$1.AliyunRegionId = $35; //阿里云服务器别名",
"	$1.AliyunAndroidNotifyTitle = $36; //阿里云安卓弹窗标题",
"	$1.AliyunAndroidActivity = $37; //阿里云点击通知后跳转的Activity",
"}"
]
},
"获取第三方平台设置数量": {
"prefix": "ym-db-PublicAccountSet-FindAndCount",
"body": [
"int $1 = db.PublicAccountSet.Count(m => $2);",
]
},
"添加第三方平台设置": {
"prefix": "ym-db-PublicAccountSet-Create",
"body": [
"db.PublicAccountSet.Add(new PublicAccountSet()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	Id = $1, //Id",
"	AlipayAppId = $2, //支付宝AppId",
"	AlipayPartnerId = $3, //支付宝合作者Id",
"	AlipayPrivateKey = $4, //支付宝私钥",
"	AlipayPublicKey = $5, //支付宝公钥",
"	WeChatAppId = $6, //微信公众号AppId",
"	WeChatAppSecret = $7, //微信公众号AppSecret",
"	WeChatMchId = $8, //微信商户号",
"	WeChatPayKey = $9, //微信支付密钥",
"	WeChatOpenAppId = $10, //微信开放平台AppId",
"	WeChatOpenAppSecret = $11, //微信开放平台AppSecret",
"	ServerIp = $12, //服务器IP",
"	WeChatMiniAppId = $13, //微信小程序AppId",
"	WeChatMiniAppSecret = $14, //微信小程序AppSecret",
"	QqAndroidAppId = $15, //QQ安卓AppId",
"	QqAndroidAppKey = $16, //QQ安卓AppKey",
"	QqIosAppId = $17, //QQIOSAppId",
"	QqIosAppKey = $18, //QQIOSAppKey",
"	AliyunAccessKeyId = $19, //阿里云AccessKeyID",
"	AliyunAccessKeySecret = $20, //阿里云AccessKeySecret",
"	AliyunPushAndroidAppId = $21, //阿里云推送安卓AppId",
"	AliyunPushAndroidAppSecret = $22, //阿里云推送安卓AppSecret",
"	AliyunPushIosAppId = $23, //阿里云推送IOSAppId",
"	AliyunPushIosAppSecret = $24, //阿里云推送IOSAppSecret",
"	MobAppKey = $25, //MobAppKey",
"	MobAppSecret = $26, //MobAppSecret",
"	MeiQiaAppKey = $27, //美洽AppKey",
"	ErpApiUrl = $28, //请求地址",
"	ErpAppCode = $29, //AppCode",
"	SmsApiPwd = $30, //密码",
"	SmsApiSign = $31, //签名",
"	SmsApiUserId = $32, //账号",
"	SmsApiDefaultTemplate = $33, //默认验证码模板",
"	AliyunRegionId = $34, //阿里云服务器别名",
"	AliyunAndroidNotifyTitle = $35, //阿里云安卓弹窗标题",
"	AliyunAndroidActivity = $36, //阿里云点击通知后跳转的Activity",
"});"
]
},"删除某个第三方平台设置": {
"prefix": "ym-db-PublicAccountSet-Delete",
"body": [
"PublicAccountSet $1 = db.PublicAccountSet.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.PublicAccountSet.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);",
"}"
]
},
"查询上传配置项列表": {
"prefix": "ym-db-UploadParams-Find",
"body": [
"List<UploadParams> $1 = db.UploadParams.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (UploadParams $3 in $1)",
"{",
"}"
]
},
"查询上传配置项列表，并取值": {
"prefix": "ym-db-UploadParams-FindWithData",
"body": [
"List<UploadParams> $1 = db.UploadParams.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (UploadParams $3 in $1)",
"{",
"	string TableName = $3.TableName; //表名",
"	string ColumnName = $3.ColumnName; //字段名",
"	string ColumnEnName = $3.ColumnEnName; //字段英文明",
"	string ParamString = $3.ParamString; //参数",
"	string TableEnName = $3.TableEnName; //表英文名",
"}"
]
},
"查询上传配置项": {
"prefix": "ym-db-UploadParams-Exist",
"body": [
"bool $1 = db.UploadParams.Any(m => m.Id == $2);",
]
},
"查询某个上传配置项，并取值": {
"prefix": "ym-db-UploadParams-FindByPrimaryKey",
"body": [
"UploadParams $1 = db.UploadParams.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string TableName = $1.TableName; //表名",
"	string ColumnName = $1.ColumnName; //字段名",
"	string ColumnEnName = $1.ColumnEnName; //字段英文明",
"	string ParamString = $1.ParamString; //参数",
"	string TableEnName = $1.TableEnName; //表英文名",
"}"
]
},
"查询某个上传配置项，并赋值": {
"prefix": "ym-db-UploadParams-Update",
"body": [
"UploadParams $1 = db.UploadParams.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.TableName = $2; //表名",
"	$1.ColumnName = $3; //字段名",
"	$1.ColumnEnName = $4; //字段英文明",
"	$1.ParamString = $5; //参数",
"	$1.TableEnName = $6; //表英文名",
"}"
]
},
"获取上传配置项数量": {
"prefix": "ym-db-UploadParams-FindAndCount",
"body": [
"int $1 = db.UploadParams.Count(m => $2);",
]
},
"添加上传配置项": {
"prefix": "ym-db-UploadParams-Create",
"body": [
"db.UploadParams.Add(new UploadParams()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TableName = $1, //表名",
"	ColumnName = $2, //字段名",
"	ColumnEnName = $3, //字段英文明",
"	ParamString = $4, //参数",
"	TableEnName = $5, //表英文名",
"});"
]
},"删除某个上传配置项": {
"prefix": "ym-db-UploadParams-Delete",
"body": [
"UploadParams $1 = db.UploadParams.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.UploadParams.Remove($1);",
"}"
]
},
}