mp-main/.vscode/spdb.code-snippets

{"查询激活记录列表": {
"prefix": "ym-db-ActivateRecord-Find",
"body": [
"List<ActivateRecord> $1 = db.ActivateRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (ActivateRecord $3 in $1)",
"{",
"}"
]
},
"查询激活记录列表，并取值": {
"prefix": "ym-db-ActivateRecord-FindWithData",
"body": [
"List<ActivateRecord> $1 = db.ActivateRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (ActivateRecord $3 in $1)",
"{",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string SnNo = $3.SnNo; //终端机身号",
"	DateTime MerRegDate = $3.MerRegDate; //注册日期",
"	string AssessMonth = $3.AssessMonth; //考核月",
"	string AssessMonthCount = $3.AssessMonthCount; //考核第几月",
"	string ActivateStatus = $3.ActivateStatus; //激活状态",
"	DateTime ActivateDate = $3.ActivateDate; //激活日期",
"	string MerRealName = $3.MerRealName; //商户真实姓名",
"	string MerIdcardNo = $3.MerIdcardNo; //商户身份证号",
"	string BizEnterNo = $3.BizEnterNo; //业务员编号",
"	string BizEnterName = $3.BizEnterName; //业务员名称",
"	string Remark = $3.Remark; //备注",
"	string AgentNo = $3.AgentNo; //代理商编号",
"	string ProductType = $3.ProductType; //产品类型",
"	string ChannelSerial = $3.ChannelSerial; //渠道流水号",
"}"
]
},
"查询激活记录": {
"prefix": "ym-db-ActivateRecord-Exist",
"body": [
"bool $1 = db.ActivateRecord.Any(m => m.MerNo == $2);",
]
},
"查询某个激活记录，并取值": {
"prefix": "ym-db-ActivateRecord-FindByPrimaryKey",
"body": [
"ActivateRecord $1 = db.ActivateRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string SnNo = $1.SnNo; //终端机身号",
"	DateTime MerRegDate = $1.MerRegDate; //注册日期",
"	string AssessMonth = $1.AssessMonth; //考核月",
"	string AssessMonthCount = $1.AssessMonthCount; //考核第几月",
"	string ActivateStatus = $1.ActivateStatus; //激活状态",
"	DateTime ActivateDate = $1.ActivateDate; //激活日期",
"	string MerRealName = $1.MerRealName; //商户真实姓名",
"	string MerIdcardNo = $1.MerIdcardNo; //商户身份证号",
"	string BizEnterNo = $1.BizEnterNo; //业务员编号",
"	string BizEnterName = $1.BizEnterName; //业务员名称",
"	string Remark = $1.Remark; //备注",
"	string AgentNo = $1.AgentNo; //代理商编号",
"	string ProductType = $1.ProductType; //产品类型",
"	string ChannelSerial = $1.ChannelSerial; //渠道流水号",
"}"
]
},
"查询某个激活记录，并赋值": {
"prefix": "ym-db-ActivateRecord-Update",
"body": [
"ActivateRecord $1 = db.ActivateRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.MerNo = $2; //商户编号",
"	$1.MerName = $3; //商户名称",
"	$1.MerMobile = $4; //商户手机号",
"	$1.SnNo = $5; //终端机身号",
"	$1.MerRegDate = $6; //注册日期",
"	$1.AssessMonth = $7; //考核月",
"	$1.AssessMonthCount = $8; //考核第几月",
"	$1.ActivateStatus = $9; //激活状态",
"	$1.ActivateDate = $10; //激活日期",
"	$1.MerRealName = $11; //商户真实姓名",
"	$1.MerIdcardNo = $12; //商户身份证号",
"	$1.BizEnterNo = $13; //业务员编号",
"	$1.BizEnterName = $14; //业务员名称",
"	$1.Remark = $15; //备注",
"	$1.AgentNo = $16; //代理商编号",
"	$1.ProductType = $17; //产品类型",
"	$1.ChannelSerial = $18; //渠道流水号",
"}"
]
},
"获取激活记录数量": {
"prefix": "ym-db-ActivateRecord-FindAndCount",
"body": [
"int $1 = db.ActivateRecord.Count(m => $2);",
]
},
"添加激活记录": {
"prefix": "ym-db-ActivateRecord-Create",
"body": [
"db.ActivateRecord.Add(new ActivateRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	MerNo = $1, //商户编号",
"	MerName = $2, //商户名称",
"	MerMobile = $3, //商户手机号",
"	SnNo = $4, //终端机身号",
"	MerRegDate = $5, //注册日期",
"	AssessMonth = $6, //考核月",
"	AssessMonthCount = $7, //考核第几月",
"	ActivateStatus = $8, //激活状态",
"	ActivateDate = $9, //激活日期",
"	MerRealName = $10, //商户真实姓名",
"	MerIdcardNo = $11, //商户身份证号",
"	BizEnterNo = $12, //业务员编号",
"	BizEnterName = $13, //业务员名称",
"	Remark = $14, //备注",
"	AgentNo = $15, //代理商编号",
"	ProductType = $16, //产品类型",
"	ChannelSerial = $17, //渠道流水号",
"});"
]
},"删除某个激活记录": {
"prefix": "ym-db-ActivateRecord-Delete",
"body": [
"ActivateRecord $1 = db.ActivateRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.ActivateRecord.Remove($1);",
"}"
]
},
"查询绑定记录列表": {
"prefix": "ym-db-BindRecord-Find",
"body": [
"List<BindRecord> $1 = db.BindRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (BindRecord $3 in $1)",
"{",
"}"
]
},
"查询绑定记录列表，并取值": {
"prefix": "ym-db-BindRecord-FindWithData",
"body": [
"List<BindRecord> $1 = db.BindRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (BindRecord $3 in $1)",
"{",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	DateTime MerOperateDate = $3.MerOperateDate; //操作时间",
"	string MerOperateType = $3.MerOperateType; //操作类型",
"	string MerStatus = $3.MerStatus; //商户状态",
"	string ProductType = $3.ProductType; //产品类型",
"	string MerNewSnNo = $3.MerNewSnNo; //新终端机身号",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"	string ChannelSerial = $3.ChannelSerial; //渠道流水号",
"}"
]
},
"查询绑定记录": {
"prefix": "ym-db-BindRecord-Exist",
"body": [
"bool $1 = db.BindRecord.Any(m => m.MerNo == $2);",
]
},
"查询某个绑定记录，并取值": {
"prefix": "ym-db-BindRecord-FindByPrimaryKey",
"body": [
"BindRecord $1 = db.BindRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	DateTime MerOperateDate = $1.MerOperateDate; //操作时间",
"	string MerOperateType = $1.MerOperateType; //操作类型",
"	string MerStatus = $1.MerStatus; //商户状态",
"	string ProductType = $1.ProductType; //产品类型",
"	string MerNewSnNo = $1.MerNewSnNo; //新终端机身号",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"	string ChannelSerial = $1.ChannelSerial; //渠道流水号",
"}"
]
},
"查询某个绑定记录，并赋值": {
"prefix": "ym-db-BindRecord-Update",
"body": [
"BindRecord $1 = db.BindRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.AgentName = $2; //机构名称",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.MerSnNo = $5; //终端机身号",
"	$1.MerOperateDate = $6; //操作时间",
"	$1.MerOperateType = $7; //操作类型",
"	$1.MerStatus = $8; //商户状态",
"	$1.ProductType = $9; //产品类型",
"	$1.MerNewSnNo = $10; //新终端机身号",
"	$1.Remark = $11; //注释",
"	$1.CreateTime = $12; //创建时间",
"	$1.UpdateTime = $13; //更新时间",
"	$1.ChannelSerial = $14; //渠道流水号",
"}"
]
},
"获取绑定记录数量": {
"prefix": "ym-db-BindRecord-FindAndCount",
"body": [
"int $1 = db.BindRecord.Count(m => $2);",
]
},
"添加绑定记录": {
"prefix": "ym-db-BindRecord-Create",
"body": [
"db.BindRecord.Add(new BindRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AgentName = $1, //机构名称",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	MerSnNo = $4, //终端机身号",
"	MerOperateDate = $5, //操作时间",
"	MerOperateType = $6, //操作类型",
"	MerStatus = $7, //商户状态",
"	ProductType = $8, //产品类型",
"	MerNewSnNo = $9, //新终端机身号",
"	Remark = $10, //注释",
"	CreateTime = $11, //创建时间",
"	UpdateTime = $12, //更新时间",
"	ChannelSerial = $13, //渠道流水号",
"});"
]
},"删除某个绑定记录": {
"prefix": "ym-db-BindRecord-Delete",
"body": [
"BindRecord $1 = db.BindRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.BindRecord.Remove($1);",
"}"
]
},
"查询自建表创建记录列表": {
"prefix": "ym-db-CustomerTableRecord-Find",
"body": [
"List<CustomerTableRecord> $1 = db.CustomerTableRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (CustomerTableRecord $3 in $1)",
"{",
"}"
]
},
"查询自建表创建记录列表，并取值": {
"prefix": "ym-db-CustomerTableRecord-FindWithData",
"body": [
"List<CustomerTableRecord> $1 = db.CustomerTableRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (CustomerTableRecord $3 in $1)",
"{",
"	string TableEnName = $3.TableEnName; //表名",
"	DateTime CreateDate = $3.CreateDate; //创建时间",
"	DateTime AddTableDate = $3.AddTableDate; //分表时间",
"}"
]
},
"查询自建表创建记录": {
"prefix": "ym-db-CustomerTableRecord-Exist",
"body": [
"bool $1 = db.CustomerTableRecord.Any(m => m.TableEnName == $2);",
]
},
"查询某个自建表创建记录，并取值": {
"prefix": "ym-db-CustomerTableRecord-FindByPrimaryKey",
"body": [
"CustomerTableRecord $1 = db.CustomerTableRecord.FirstOrDefault(m => m.TableEnName == $2);",
"if ($1 != null)",
"{",
"	string TableEnName = $1.TableEnName; //表名",
"	DateTime CreateDate = $1.CreateDate; //创建时间",
"	DateTime AddTableDate = $1.AddTableDate; //分表时间",
"}"
]
},
"查询某个自建表创建记录，并赋值": {
"prefix": "ym-db-CustomerTableRecord-Update",
"body": [
"CustomerTableRecord $1 = db.CustomerTableRecord.FirstOrDefault(m => m.TableEnName == $2);",
"if ($1 != null)",
"{",
"	$1.TableEnName = $2; //表名",
"	$1.CreateDate = $3; //创建时间",
"	$1.AddTableDate = $4; //分表时间",
"}"
]
},
"获取自建表创建记录数量": {
"prefix": "ym-db-CustomerTableRecord-FindAndCount",
"body": [
"int $1 = db.CustomerTableRecord.Count(m => $2);",
]
},
"添加自建表创建记录": {
"prefix": "ym-db-CustomerTableRecord-Create",
"body": [
"db.CustomerTableRecord.Add(new CustomerTableRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TableEnName = $1, //表名",
"	CreateDate = $2, //创建时间",
"	AddTableDate = $3, //分表时间",
"});"
]
},"删除某个自建表创建记录": {
"prefix": "ym-db-CustomerTableRecord-Delete",
"body": [
"CustomerTableRecord $1 = db.CustomerTableRecord.FirstOrDefault(m => m.TableEnName == $2);",
"if ($1 != null)",
"{",
"	db.CustomerTableRecord.Remove($1);",
"}"
]
},
"查询快钱MPOS激活抓取列表": {
"prefix": "ym-db-KqActivate-Find",
"body": [
"List<KqActivate> $1 = db.KqActivate.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqActivate $3 in $1)",
"{",
"}"
]
},
"查询快钱MPOS激活抓取列表，并取值": {
"prefix": "ym-db-KqActivate-FindWithData",
"body": [
"List<KqActivate> $1 = db.KqActivate.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqActivate $3 in $1)",
"{",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string ProductType = $3.ProductType; //产品类型",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	DateTime MerRegDate = $3.MerRegDate; //注册日期",
"	string AssessMonth = $3.AssessMonth; //考核月",
"	string AssessMonthCount = $3.AssessMonthCount; //考核第几月",
"	string ActivateStatus = $3.ActivateStatus; //激活状态",
"	DateTime ActivateDate = $3.ActivateDate; //激活日期",
"	string MerRealName = $3.MerRealName; //商户真实姓名",
"	string MerIdcardNo = $3.MerIdcardNo; //商户身份证号",
"	string BizEnterNo = $3.BizEnterNo; //业务员编号",
"	string BizEnterName = $3.BizEnterName; //业务员名称",
"	string ActVerifyFlag = $3.ActVerifyFlag; //激活验证标识",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"	string SourceType = $3.SourceType; //来源类型",
"	string ActNo = $3.ActNo; //押金活动ID",
"	string ActName = $3.ActName; //押金活动名称",
"}"
]
},
"查询快钱MPOS激活抓取": {
"prefix": "ym-db-KqActivate-Exist",
"body": [
"bool $1 = db.KqActivate.Any(m => m.MerNo == $2);",
]
},
"查询某个快钱MPOS激活抓取，并取值": {
"prefix": "ym-db-KqActivate-FindByPrimaryKey",
"body": [
"KqActivate $1 = db.KqActivate.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string ProductType = $1.ProductType; //产品类型",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	DateTime MerRegDate = $1.MerRegDate; //注册日期",
"	string AssessMonth = $1.AssessMonth; //考核月",
"	string AssessMonthCount = $1.AssessMonthCount; //考核第几月",
"	string ActivateStatus = $1.ActivateStatus; //激活状态",
"	DateTime ActivateDate = $1.ActivateDate; //激活日期",
"	string MerRealName = $1.MerRealName; //商户真实姓名",
"	string MerIdcardNo = $1.MerIdcardNo; //商户身份证号",
"	string BizEnterNo = $1.BizEnterNo; //业务员编号",
"	string BizEnterName = $1.BizEnterName; //业务员名称",
"	string ActVerifyFlag = $1.ActVerifyFlag; //激活验证标识",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"	string SourceType = $1.SourceType; //来源类型",
"	string ActNo = $1.ActNo; //押金活动ID",
"	string ActName = $1.ActName; //押金活动名称",
"}"
]
},
"查询某个快钱MPOS激活抓取，并赋值": {
"prefix": "ym-db-KqActivate-Update",
"body": [
"KqActivate $1 = db.KqActivate.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.MerNo = $2; //商户编号",
"	$1.MerName = $3; //商户名称",
"	$1.MerMobile = $4; //商户手机号",
"	$1.ProductType = $5; //产品类型",
"	$1.MerSnNo = $6; //终端机身号",
"	$1.MerRegDate = $7; //注册日期",
"	$1.AssessMonth = $8; //考核月",
"	$1.AssessMonthCount = $9; //考核第几月",
"	$1.ActivateStatus = $10; //激活状态",
"	$1.ActivateDate = $11; //激活日期",
"	$1.MerRealName = $12; //商户真实姓名",
"	$1.MerIdcardNo = $13; //商户身份证号",
"	$1.BizEnterNo = $14; //业务员编号",
"	$1.BizEnterName = $15; //业务员名称",
"	$1.ActVerifyFlag = $16; //激活验证标识",
"	$1.Remark = $17; //注释",
"	$1.CreateTime = $18; //创建时间",
"	$1.UpdateTime = $19; //更新时间",
"	$1.SourceType = $20; //来源类型",
"	$1.ActNo = $21; //押金活动ID",
"	$1.ActName = $22; //押金活动名称",
"}"
]
},
"获取快钱MPOS激活抓取数量": {
"prefix": "ym-db-KqActivate-FindAndCount",
"body": [
"int $1 = db.KqActivate.Count(m => $2);",
]
},
"添加快钱MPOS激活抓取": {
"prefix": "ym-db-KqActivate-Create",
"body": [
"db.KqActivate.Add(new KqActivate()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	MerNo = $1, //商户编号",
"	MerName = $2, //商户名称",
"	MerMobile = $3, //商户手机号",
"	ProductType = $4, //产品类型",
"	MerSnNo = $5, //终端机身号",
"	MerRegDate = $6, //注册日期",
"	AssessMonth = $7, //考核月",
"	AssessMonthCount = $8, //考核第几月",
"	ActivateStatus = $9, //激活状态",
"	ActivateDate = $10, //激活日期",
"	MerRealName = $11, //商户真实姓名",
"	MerIdcardNo = $12, //商户身份证号",
"	BizEnterNo = $13, //业务员编号",
"	BizEnterName = $14, //业务员名称",
"	ActVerifyFlag = $15, //激活验证标识",
"	Remark = $16, //注释",
"	CreateTime = $17, //创建时间",
"	UpdateTime = $18, //更新时间",
"	SourceType = $19, //来源类型",
"	ActNo = $20, //押金活动ID",
"	ActName = $21, //押金活动名称",
"});"
]
},"删除某个快钱MPOS激活抓取": {
"prefix": "ym-db-KqActivate-Delete",
"body": [
"KqActivate $1 = db.KqActivate.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KqActivate.Remove($1);",
"}"
]
},
"查询快钱MPOS激活推送列表": {
"prefix": "ym-db-KqActivateCallBack-Find",
"body": [
"List<KqActivateCallBack> $1 = db.KqActivateCallBack.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqActivateCallBack $3 in $1)",
"{",
"}"
]
},
"查询快钱MPOS激活推送列表，并取值": {
"prefix": "ym-db-KqActivateCallBack-FindWithData",
"body": [
"List<KqActivateCallBack> $1 = db.KqActivateCallBack.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqActivateCallBack $3 in $1)",
"{",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string ProductType = $3.ProductType; //产品类型",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	DateTime MerRegDate = $3.MerRegDate; //注册日期",
"	string AssessMonth = $3.AssessMonth; //考核月",
"	string AssessMonthCount = $3.AssessMonthCount; //考核第几月",
"	string ActivateStatus = $3.ActivateStatus; //激活状态",
"	DateTime ActivateDate = $3.ActivateDate; //激活日期",
"	string MerRealName = $3.MerRealName; //商户真实姓名",
"	string MerIdcardNo = $3.MerIdcardNo; //商户身份证号",
"	string BizEnterNo = $3.BizEnterNo; //业务员编号",
"	string BizEnterName = $3.BizEnterName; //业务员名称",
"	string ActVerifyFlag = $3.ActVerifyFlag; //激活验证标识",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快钱MPOS激活推送": {
"prefix": "ym-db-KqActivateCallBack-Exist",
"body": [
"bool $1 = db.KqActivateCallBack.Any(m => m.MerNo == $2);",
]
},
"查询某个快钱MPOS激活推送，并取值": {
"prefix": "ym-db-KqActivateCallBack-FindByPrimaryKey",
"body": [
"KqActivateCallBack $1 = db.KqActivateCallBack.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string ProductType = $1.ProductType; //产品类型",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	DateTime MerRegDate = $1.MerRegDate; //注册日期",
"	string AssessMonth = $1.AssessMonth; //考核月",
"	string AssessMonthCount = $1.AssessMonthCount; //考核第几月",
"	string ActivateStatus = $1.ActivateStatus; //激活状态",
"	DateTime ActivateDate = $1.ActivateDate; //激活日期",
"	string MerRealName = $1.MerRealName; //商户真实姓名",
"	string MerIdcardNo = $1.MerIdcardNo; //商户身份证号",
"	string BizEnterNo = $1.BizEnterNo; //业务员编号",
"	string BizEnterName = $1.BizEnterName; //业务员名称",
"	string ActVerifyFlag = $1.ActVerifyFlag; //激活验证标识",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快钱MPOS激活推送，并赋值": {
"prefix": "ym-db-KqActivateCallBack-Update",
"body": [
"KqActivateCallBack $1 = db.KqActivateCallBack.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.MerNo = $2; //商户编号",
"	$1.MerName = $3; //商户名称",
"	$1.MerMobile = $4; //商户手机号",
"	$1.ProductType = $5; //产品类型",
"	$1.MerSnNo = $6; //终端机身号",
"	$1.MerRegDate = $7; //注册日期",
"	$1.AssessMonth = $8; //考核月",
"	$1.AssessMonthCount = $9; //考核第几月",
"	$1.ActivateStatus = $10; //激活状态",
"	$1.ActivateDate = $11; //激活日期",
"	$1.MerRealName = $12; //商户真实姓名",
"	$1.MerIdcardNo = $13; //商户身份证号",
"	$1.BizEnterNo = $14; //业务员编号",
"	$1.BizEnterName = $15; //业务员名称",
"	$1.ActVerifyFlag = $16; //激活验证标识",
"	$1.Remark = $17; //注释",
"	$1.CreateTime = $18; //创建时间",
"	$1.UpdateTime = $19; //更新时间",
"}"
]
},
"获取快钱MPOS激活推送数量": {
"prefix": "ym-db-KqActivateCallBack-FindAndCount",
"body": [
"int $1 = db.KqActivateCallBack.Count(m => $2);",
]
},
"添加快钱MPOS激活推送": {
"prefix": "ym-db-KqActivateCallBack-Create",
"body": [
"db.KqActivateCallBack.Add(new KqActivateCallBack()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	MerNo = $1, //商户编号",
"	MerName = $2, //商户名称",
"	MerMobile = $3, //商户手机号",
"	ProductType = $4, //产品类型",
"	MerSnNo = $5, //终端机身号",
"	MerRegDate = $6, //注册日期",
"	AssessMonth = $7, //考核月",
"	AssessMonthCount = $8, //考核第几月",
"	ActivateStatus = $9, //激活状态",
"	ActivateDate = $10, //激活日期",
"	MerRealName = $11, //商户真实姓名",
"	MerIdcardNo = $12, //商户身份证号",
"	BizEnterNo = $13, //业务员编号",
"	BizEnterName = $14, //业务员名称",
"	ActVerifyFlag = $15, //激活验证标识",
"	Remark = $16, //注释",
"	CreateTime = $17, //创建时间",
"	UpdateTime = $18, //更新时间",
"});"
]
},"删除某个快钱MPOS激活推送": {
"prefix": "ym-db-KqActivateCallBack-Delete",
"body": [
"KqActivateCallBack $1 = db.KqActivateCallBack.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KqActivateCallBack.Remove($1);",
"}"
]
},
"查询快钱Mpos商户列表": {
"prefix": "ym-db-KqMerchant-Find",
"body": [
"List<KqMerchant> $1 = db.KqMerchant.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqMerchant $3 in $1)",
"{",
"}"
]
},
"查询快钱Mpos商户列表，并取值": {
"prefix": "ym-db-KqMerchant-FindWithData",
"body": [
"List<KqMerchant> $1 = db.KqMerchant.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqMerchant $3 in $1)",
"{",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string ProductType = $3.ProductType; //产品类型",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	DateTime MerRegDate = $3.MerRegDate; //注册日期",
"	DateTime MerBindDate = $3.MerBindDate; //商户绑定时间",
"	string MerIdcardNo = $3.MerIdcardNo; //商户身份证号",
"	string MerRealName = $3.MerRealName; //商户真实姓名",
"	string BizEnterNo = $3.BizEnterNo; //业务员编号",
"	string BizEnterName = $3.BizEnterName; //业务员名称",
"	string SourceType = $3.SourceType; //来源类型",
"	string Province = $3.Province; //省份",
"	string City = $3.City; //城市",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快钱Mpos商户": {
"prefix": "ym-db-KqMerchant-Exist",
"body": [
"bool $1 = db.KqMerchant.Any(m => m.MerNo == $2);",
]
},
"查询某个快钱Mpos商户，并取值": {
"prefix": "ym-db-KqMerchant-FindByPrimaryKey",
"body": [
"KqMerchant $1 = db.KqMerchant.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string ProductType = $1.ProductType; //产品类型",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	DateTime MerRegDate = $1.MerRegDate; //注册日期",
"	DateTime MerBindDate = $1.MerBindDate; //商户绑定时间",
"	string MerIdcardNo = $1.MerIdcardNo; //商户身份证号",
"	string MerRealName = $1.MerRealName; //商户真实姓名",
"	string BizEnterNo = $1.BizEnterNo; //业务员编号",
"	string BizEnterName = $1.BizEnterName; //业务员名称",
"	string SourceType = $1.SourceType; //来源类型",
"	string Province = $1.Province; //省份",
"	string City = $1.City; //城市",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快钱Mpos商户，并赋值": {
"prefix": "ym-db-KqMerchant-Update",
"body": [
"KqMerchant $1 = db.KqMerchant.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.MerNo = $2; //商户编号",
"	$1.MerName = $3; //商户名称",
"	$1.MerMobile = $4; //商户手机号",
"	$1.ProductType = $5; //产品类型",
"	$1.MerSnNo = $6; //终端机身号",
"	$1.MerRegDate = $7; //注册日期",
"	$1.MerBindDate = $8; //商户绑定时间",
"	$1.MerIdcardNo = $9; //商户身份证号",
"	$1.MerRealName = $10; //商户真实姓名",
"	$1.BizEnterNo = $11; //业务员编号",
"	$1.BizEnterName = $12; //业务员名称",
"	$1.SourceType = $13; //来源类型",
"	$1.Province = $14; //省份",
"	$1.City = $15; //城市",
"	$1.Remark = $16; //注释",
"	$1.CreateTime = $17; //创建时间",
"	$1.UpdateTime = $18; //更新时间",
"}"
]
},
"获取快钱Mpos商户数量": {
"prefix": "ym-db-KqMerchant-FindAndCount",
"body": [
"int $1 = db.KqMerchant.Count(m => $2);",
]
},
"添加快钱Mpos商户": {
"prefix": "ym-db-KqMerchant-Create",
"body": [
"db.KqMerchant.Add(new KqMerchant()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	MerNo = $1, //商户编号",
"	MerName = $2, //商户名称",
"	MerMobile = $3, //商户手机号",
"	ProductType = $4, //产品类型",
"	MerSnNo = $5, //终端机身号",
"	MerRegDate = $6, //注册日期",
"	MerBindDate = $7, //商户绑定时间",
"	MerIdcardNo = $8, //商户身份证号",
"	MerRealName = $9, //商户真实姓名",
"	BizEnterNo = $10, //业务员编号",
"	BizEnterName = $11, //业务员名称",
"	SourceType = $12, //来源类型",
"	Province = $13, //省份",
"	City = $14, //城市",
"	Remark = $15, //注释",
"	CreateTime = $16, //创建时间",
"	UpdateTime = $17, //更新时间",
"});"
]
},"删除某个快钱Mpos商户": {
"prefix": "ym-db-KqMerchant-Delete",
"body": [
"KqMerchant $1 = db.KqMerchant.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KqMerchant.Remove($1);",
"}"
]
},
"查询快钱Mpos交易抓取列表": {
"prefix": "ym-db-KqTrade-Find",
"body": [
"List<KqTrade> $1 = db.KqTrade.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqTrade $3 in $1)",
"{",
"}"
]
},
"查询快钱Mpos交易抓取列表，并取值": {
"prefix": "ym-db-KqTrade-FindWithData",
"body": [
"List<KqTrade> $1 = db.KqTrade.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqTrade $3 in $1)",
"{",
"	string TradeSerialNo = $3.TradeSerialNo; //交易单号",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	decimal TradeAmount = $3.TradeAmount; //交易金额",
"	string ProductType = $3.ProductType; //产品类型",
"	string TradeStatus = $3.TradeStatus; //交易状态",
"	string TradeDate = $3.TradeDate; //交易日期",
"	string TradeTime = $3.TradeTime; //交易时间",
"	string BankCardType = $3.BankCardType; //银行卡类型",
"	string TradeSnNo = $3.TradeSnNo; //交易SN号",
"	string DigAmtFlag = $3.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $3.DigAmt; //挖款金额",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"	string BankCardNo = $3.BankCardNo; //交易卡号",
"	decimal FeeAmount = $3.FeeAmount; //手续费",
"	string SettleMethod = $3.SettleMethod; //出款方式",
"	decimal SettleFee = $3.SettleFee; //出款手续费",
"	string SmallDouble = $3.SmallDouble; //小额双免",
"	string BizEnterNo = $3.BizEnterNo; //业务员编号",
"	string BizEnterName = $3.BizEnterName; //业务员名称",
"	string SourceType = $3.SourceType; //来源类型",
"	decimal SettleTotalFee = $3.SettleTotalFee; //总手续费",
"	string BillType = $3.BillType; //计费类型",
"	decimal SettleFeeCostAmt = $3.SettleFeeCostAmt; //手续费成本金额",
"	decimal SettleFeeRebateAmt = $3.SettleFeeRebateAmt; //手续费返佣金额",
"	decimal SettleCostAmt = $3.SettleCostAmt; //出款成本金额",
"	decimal SettleRebateAmt = $3.SettleRebateAmt; //出款返佣金额",
"	decimal TotalCostAmt = $3.TotalCostAmt; //总成本",
"	decimal TotalRebateAmt = $3.TotalRebateAmt; //总返佣额",
"	string S0SettleStatus = $3.S0SettleStatus; //S0出款状态",
"	string DigStatus = $3.DigStatus; //挖款状态",
"	string KqTradeSeq = $3.KqTradeSeq; //快钱交易流水号",
"	string InputModel = $3.InputModel; //输入模式",
"}"
]
},
"查询快钱Mpos交易抓取": {
"prefix": "ym-db-KqTrade-Exist",
"body": [
"bool $1 = db.KqTrade.Any(m => m.MerNo == $2);",
]
},
"查询某个快钱Mpos交易抓取，并取值": {
"prefix": "ym-db-KqTrade-FindByPrimaryKey",
"body": [
"KqTrade $1 = db.KqTrade.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string TradeSerialNo = $1.TradeSerialNo; //交易单号",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	decimal TradeAmount = $1.TradeAmount; //交易金额",
"	string ProductType = $1.ProductType; //产品类型",
"	string TradeStatus = $1.TradeStatus; //交易状态",
"	string TradeDate = $1.TradeDate; //交易日期",
"	string TradeTime = $1.TradeTime; //交易时间",
"	string BankCardType = $1.BankCardType; //银行卡类型",
"	string TradeSnNo = $1.TradeSnNo; //交易SN号",
"	string DigAmtFlag = $1.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $1.DigAmt; //挖款金额",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"	string BankCardNo = $1.BankCardNo; //交易卡号",
"	decimal FeeAmount = $1.FeeAmount; //手续费",
"	string SettleMethod = $1.SettleMethod; //出款方式",
"	decimal SettleFee = $1.SettleFee; //出款手续费",
"	string SmallDouble = $1.SmallDouble; //小额双免",
"	string BizEnterNo = $1.BizEnterNo; //业务员编号",
"	string BizEnterName = $1.BizEnterName; //业务员名称",
"	string SourceType = $1.SourceType; //来源类型",
"	decimal SettleTotalFee = $1.SettleTotalFee; //总手续费",
"	string BillType = $1.BillType; //计费类型",
"	decimal SettleFeeCostAmt = $1.SettleFeeCostAmt; //手续费成本金额",
"	decimal SettleFeeRebateAmt = $1.SettleFeeRebateAmt; //手续费返佣金额",
"	decimal SettleCostAmt = $1.SettleCostAmt; //出款成本金额",
"	decimal SettleRebateAmt = $1.SettleRebateAmt; //出款返佣金额",
"	decimal TotalCostAmt = $1.TotalCostAmt; //总成本",
"	decimal TotalRebateAmt = $1.TotalRebateAmt; //总返佣额",
"	string S0SettleStatus = $1.S0SettleStatus; //S0出款状态",
"	string DigStatus = $1.DigStatus; //挖款状态",
"	string KqTradeSeq = $1.KqTradeSeq; //快钱交易流水号",
"	string InputModel = $1.InputModel; //输入模式",
"}"
]
},
"查询某个快钱Mpos交易抓取，并赋值": {
"prefix": "ym-db-KqTrade-Update",
"body": [
"KqTrade $1 = db.KqTrade.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.TradeSerialNo = $2; //交易单号",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.TradeAmount = $5; //交易金额",
"	$1.ProductType = $6; //产品类型",
"	$1.TradeStatus = $7; //交易状态",
"	$1.TradeDate = $8; //交易日期",
"	$1.TradeTime = $9; //交易时间",
"	$1.BankCardType = $10; //银行卡类型",
"	$1.TradeSnNo = $11; //交易SN号",
"	$1.DigAmtFlag = $12; //挖款标识",
"	$1.DigAmt = $13; //挖款金额",
"	$1.Remark = $14; //注释",
"	$1.CreateTime = $15; //创建时间",
"	$1.UpdateTime = $16; //更新时间",
"	$1.BankCardNo = $17; //交易卡号",
"	$1.FeeAmount = $18; //手续费",
"	$1.SettleMethod = $19; //出款方式",
"	$1.SettleFee = $20; //出款手续费",
"	$1.SmallDouble = $21; //小额双免",
"	$1.BizEnterNo = $22; //业务员编号",
"	$1.BizEnterName = $23; //业务员名称",
"	$1.SourceType = $24; //来源类型",
"	$1.SettleTotalFee = $25; //总手续费",
"	$1.BillType = $26; //计费类型",
"	$1.SettleFeeCostAmt = $27; //手续费成本金额",
"	$1.SettleFeeRebateAmt = $28; //手续费返佣金额",
"	$1.SettleCostAmt = $29; //出款成本金额",
"	$1.SettleRebateAmt = $30; //出款返佣金额",
"	$1.TotalCostAmt = $31; //总成本",
"	$1.TotalRebateAmt = $32; //总返佣额",
"	$1.S0SettleStatus = $33; //S0出款状态",
"	$1.DigStatus = $34; //挖款状态",
"	$1.KqTradeSeq = $35; //快钱交易流水号",
"	$1.InputModel = $36; //输入模式",
"}"
]
},
"获取快钱Mpos交易抓取数量": {
"prefix": "ym-db-KqTrade-FindAndCount",
"body": [
"int $1 = db.KqTrade.Count(m => $2);",
]
},
"添加快钱Mpos交易抓取": {
"prefix": "ym-db-KqTrade-Create",
"body": [
"db.KqTrade.Add(new KqTrade()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TradeSerialNo = $1, //交易单号",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	TradeAmount = $4, //交易金额",
"	ProductType = $5, //产品类型",
"	TradeStatus = $6, //交易状态",
"	TradeDate = $7, //交易日期",
"	TradeTime = $8, //交易时间",
"	BankCardType = $9, //银行卡类型",
"	TradeSnNo = $10, //交易SN号",
"	DigAmtFlag = $11, //挖款标识",
"	DigAmt = $12, //挖款金额",
"	Remark = $13, //注释",
"	CreateTime = $14, //创建时间",
"	UpdateTime = $15, //更新时间",
"	BankCardNo = $16, //交易卡号",
"	FeeAmount = $17, //手续费",
"	SettleMethod = $18, //出款方式",
"	SettleFee = $19, //出款手续费",
"	SmallDouble = $20, //小额双免",
"	BizEnterNo = $21, //业务员编号",
"	BizEnterName = $22, //业务员名称",
"	SourceType = $23, //来源类型",
"	SettleTotalFee = $24, //总手续费",
"	BillType = $25, //计费类型",
"	SettleFeeCostAmt = $26, //手续费成本金额",
"	SettleFeeRebateAmt = $27, //手续费返佣金额",
"	SettleCostAmt = $28, //出款成本金额",
"	SettleRebateAmt = $29, //出款返佣金额",
"	TotalCostAmt = $30, //总成本",
"	TotalRebateAmt = $31, //总返佣额",
"	S0SettleStatus = $32, //S0出款状态",
"	DigStatus = $33, //挖款状态",
"	KqTradeSeq = $34, //快钱交易流水号",
"	InputModel = $35, //输入模式",
"});"
]
},"删除某个快钱Mpos交易抓取": {
"prefix": "ym-db-KqTrade-Delete",
"body": [
"KqTrade $1 = db.KqTrade.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KqTrade.Remove($1);",
"}"
]
},
"查询快钱Mpos交易推送列表": {
"prefix": "ym-db-KqTradeCallBack-Find",
"body": [
"List<KqTradeCallBack> $1 = db.KqTradeCallBack.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqTradeCallBack $3 in $1)",
"{",
"}"
]
},
"查询快钱Mpos交易推送列表，并取值": {
"prefix": "ym-db-KqTradeCallBack-FindWithData",
"body": [
"List<KqTradeCallBack> $1 = db.KqTradeCallBack.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqTradeCallBack $3 in $1)",
"{",
"	string TradeSerialNo = $3.TradeSerialNo; //交易单号",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	decimal TradeAmount = $3.TradeAmount; //交易金额",
"	string TradeReferNo = $3.TradeReferNo; //交易参考号",
"	string BankAuthCode = $3.BankAuthCode; //银行授权码",
"	string DiscountRateFlag = $3.DiscountRateFlag; //优惠费率标识",
"	string ProductType = $3.ProductType; //产品类型",
"	string Trade_status = $3.Trade_status; //交易状态",
"	string ErrorCode = $3.ErrorCode; //错误码",
"	string ErrorMsg = $3.ErrorMsg; //错误信息",
"	string TradeDate = $3.TradeDate; //交易日期",
"	string TradeTime = $3.TradeTime; //交易时间",
"	string TradeType = $3.TradeType; //交易类型",
"	string SerEntryMode = $3.SerEntryMode; //输入模式",
"	string BankCardType = $3.BankCardType; //银行卡类型",
"	string TradeSnNo = $3.TradeSnNo; //交易SN号",
"	string DeviceType = $3.DeviceType; //设备类型",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string DigAmtFlag = $3.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $3.DigAmt; //挖款金额",
"	string IsStoreCashier = $3.IsStoreCashier; //店面收银交易标识",
"	string ReceiptType = $3.ReceiptType; //设备类型",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快钱Mpos交易推送": {
"prefix": "ym-db-KqTradeCallBack-Exist",
"body": [
"bool $1 = db.KqTradeCallBack.Any(m => m.MerNo == $2);",
]
},
"查询某个快钱Mpos交易推送，并取值": {
"prefix": "ym-db-KqTradeCallBack-FindByPrimaryKey",
"body": [
"KqTradeCallBack $1 = db.KqTradeCallBack.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string TradeSerialNo = $1.TradeSerialNo; //交易单号",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	decimal TradeAmount = $1.TradeAmount; //交易金额",
"	string TradeReferNo = $1.TradeReferNo; //交易参考号",
"	string BankAuthCode = $1.BankAuthCode; //银行授权码",
"	string DiscountRateFlag = $1.DiscountRateFlag; //优惠费率标识",
"	string ProductType = $1.ProductType; //产品类型",
"	string Trade_status = $1.Trade_status; //交易状态",
"	string ErrorCode = $1.ErrorCode; //错误码",
"	string ErrorMsg = $1.ErrorMsg; //错误信息",
"	string TradeDate = $1.TradeDate; //交易日期",
"	string TradeTime = $1.TradeTime; //交易时间",
"	string TradeType = $1.TradeType; //交易类型",
"	string SerEntryMode = $1.SerEntryMode; //输入模式",
"	string BankCardType = $1.BankCardType; //银行卡类型",
"	string TradeSnNo = $1.TradeSnNo; //交易SN号",
"	string DeviceType = $1.DeviceType; //设备类型",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string DigAmtFlag = $1.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $1.DigAmt; //挖款金额",
"	string IsStoreCashier = $1.IsStoreCashier; //店面收银交易标识",
"	string ReceiptType = $1.ReceiptType; //设备类型",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快钱Mpos交易推送，并赋值": {
"prefix": "ym-db-KqTradeCallBack-Update",
"body": [
"KqTradeCallBack $1 = db.KqTradeCallBack.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.TradeSerialNo = $2; //交易单号",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.TradeAmount = $5; //交易金额",
"	$1.TradeReferNo = $6; //交易参考号",
"	$1.BankAuthCode = $7; //银行授权码",
"	$1.DiscountRateFlag = $8; //优惠费率标识",
"	$1.ProductType = $9; //产品类型",
"	$1.Trade_status = $10; //交易状态",
"	$1.ErrorCode = $11; //错误码",
"	$1.ErrorMsg = $12; //错误信息",
"	$1.TradeDate = $13; //交易日期",
"	$1.TradeTime = $14; //交易时间",
"	$1.TradeType = $15; //交易类型",
"	$1.SerEntryMode = $16; //输入模式",
"	$1.BankCardType = $17; //银行卡类型",
"	$1.TradeSnNo = $18; //交易SN号",
"	$1.DeviceType = $19; //设备类型",
"	$1.MerMobile = $20; //商户手机号",
"	$1.DigAmtFlag = $21; //挖款标识",
"	$1.DigAmt = $22; //挖款金额",
"	$1.IsStoreCashier = $23; //店面收银交易标识",
"	$1.ReceiptType = $24; //设备类型",
"	$1.Remark = $25; //注释",
"	$1.CreateTime = $26; //创建时间",
"	$1.UpdateTime = $27; //更新时间",
"}"
]
},
"获取快钱Mpos交易推送数量": {
"prefix": "ym-db-KqTradeCallBack-FindAndCount",
"body": [
"int $1 = db.KqTradeCallBack.Count(m => $2);",
]
},
"添加快钱Mpos交易推送": {
"prefix": "ym-db-KqTradeCallBack-Create",
"body": [
"db.KqTradeCallBack.Add(new KqTradeCallBack()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TradeSerialNo = $1, //交易单号",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	TradeAmount = $4, //交易金额",
"	TradeReferNo = $5, //交易参考号",
"	BankAuthCode = $6, //银行授权码",
"	DiscountRateFlag = $7, //优惠费率标识",
"	ProductType = $8, //产品类型",
"	Trade_status = $9, //交易状态",
"	ErrorCode = $10, //错误码",
"	ErrorMsg = $11, //错误信息",
"	TradeDate = $12, //交易日期",
"	TradeTime = $13, //交易时间",
"	TradeType = $14, //交易类型",
"	SerEntryMode = $15, //输入模式",
"	BankCardType = $16, //银行卡类型",
"	TradeSnNo = $17, //交易SN号",
"	DeviceType = $18, //设备类型",
"	MerMobile = $19, //商户手机号",
"	DigAmtFlag = $20, //挖款标识",
"	DigAmt = $21, //挖款金额",
"	IsStoreCashier = $22, //店面收银交易标识",
"	ReceiptType = $23, //设备类型",
"	Remark = $24, //注释",
"	CreateTime = $25, //创建时间",
"	UpdateTime = $26, //更新时间",
"});"
]
},"删除某个快钱Mpos交易推送": {
"prefix": "ym-db-KqTradeCallBack-Delete",
"body": [
"KqTradeCallBack $1 = db.KqTradeCallBack.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KqTradeCallBack.Remove($1);",
"}"
]
},
"查询快钱流量卡分佣交易列表": {
"prefix": "ym-db-KqTradeFlux-Find",
"body": [
"List<KqTradeFlux> $1 = db.KqTradeFlux.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqTradeFlux $3 in $1)",
"{",
"}"
]
},
"查询快钱流量卡分佣交易列表，并取值": {
"prefix": "ym-db-KqTradeFlux-FindWithData",
"body": [
"List<KqTradeFlux> $1 = db.KqTradeFlux.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KqTradeFlux $3 in $1)",
"{",
"	string TradeSerialNo = $3.TradeSerialNo; //交易单号",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	decimal TradeAmount = $3.TradeAmount; //交易金额",
"	string ProductType = $3.ProductType; //产品类型",
"	string TradeStatus = $3.TradeStatus; //交易状态",
"	string TradeDate = $3.TradeDate; //交易日期",
"	string TradeTime = $3.TradeTime; //交易时间",
"	string BankCardType = $3.BankCardType; //银行卡类型",
"	string TradeSnNo = $3.TradeSnNo; //交易SN号",
"	string DigAmtFlag = $3.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $3.DigAmt; //挖款金额",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"	string BankCardNo = $3.BankCardNo; //交易卡号",
"	decimal FeeAmount = $3.FeeAmount; //手续费",
"	string SettleMethod = $3.SettleMethod; //出款方式",
"	decimal SettleFee = $3.SettleFee; //出款手续费",
"	string SmallDouble = $3.SmallDouble; //小额双免",
"	string BizEnterNo = $3.BizEnterNo; //业务员编号",
"	string BizEnterName = $3.BizEnterName; //业务员名称",
"	string SourceType = $3.SourceType; //来源类型",
"	string BillType = $3.BillType; //计费类型",
"	string KqTradeSeq = $3.KqTradeSeq; //快钱交易流水号",
"	string InputModel = $3.InputModel; //输入模式",
"	string TerminalNo = $3.TerminalNo; //终端号",
"	string DeviceNetwork = $3.DeviceNetwork; //设备网络",
"}"
]
},
"查询快钱流量卡分佣交易": {
"prefix": "ym-db-KqTradeFlux-Exist",
"body": [
"bool $1 = db.KqTradeFlux.Any(m => m.MerNo == $2);",
]
},
"查询某个快钱流量卡分佣交易，并取值": {
"prefix": "ym-db-KqTradeFlux-FindByPrimaryKey",
"body": [
"KqTradeFlux $1 = db.KqTradeFlux.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string TradeSerialNo = $1.TradeSerialNo; //交易单号",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	decimal TradeAmount = $1.TradeAmount; //交易金额",
"	string ProductType = $1.ProductType; //产品类型",
"	string TradeStatus = $1.TradeStatus; //交易状态",
"	string TradeDate = $1.TradeDate; //交易日期",
"	string TradeTime = $1.TradeTime; //交易时间",
"	string BankCardType = $1.BankCardType; //银行卡类型",
"	string TradeSnNo = $1.TradeSnNo; //交易SN号",
"	string DigAmtFlag = $1.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $1.DigAmt; //挖款金额",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"	string BankCardNo = $1.BankCardNo; //交易卡号",
"	decimal FeeAmount = $1.FeeAmount; //手续费",
"	string SettleMethod = $1.SettleMethod; //出款方式",
"	decimal SettleFee = $1.SettleFee; //出款手续费",
"	string SmallDouble = $1.SmallDouble; //小额双免",
"	string BizEnterNo = $1.BizEnterNo; //业务员编号",
"	string BizEnterName = $1.BizEnterName; //业务员名称",
"	string SourceType = $1.SourceType; //来源类型",
"	string BillType = $1.BillType; //计费类型",
"	string KqTradeSeq = $1.KqTradeSeq; //快钱交易流水号",
"	string InputModel = $1.InputModel; //输入模式",
"	string TerminalNo = $1.TerminalNo; //终端号",
"	string DeviceNetwork = $1.DeviceNetwork; //设备网络",
"}"
]
},
"查询某个快钱流量卡分佣交易，并赋值": {
"prefix": "ym-db-KqTradeFlux-Update",
"body": [
"KqTradeFlux $1 = db.KqTradeFlux.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.TradeSerialNo = $2; //交易单号",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.TradeAmount = $5; //交易金额",
"	$1.ProductType = $6; //产品类型",
"	$1.TradeStatus = $7; //交易状态",
"	$1.TradeDate = $8; //交易日期",
"	$1.TradeTime = $9; //交易时间",
"	$1.BankCardType = $10; //银行卡类型",
"	$1.TradeSnNo = $11; //交易SN号",
"	$1.DigAmtFlag = $12; //挖款标识",
"	$1.DigAmt = $13; //挖款金额",
"	$1.Remark = $14; //注释",
"	$1.CreateTime = $15; //创建时间",
"	$1.UpdateTime = $16; //更新时间",
"	$1.BankCardNo = $17; //交易卡号",
"	$1.FeeAmount = $18; //手续费",
"	$1.SettleMethod = $19; //出款方式",
"	$1.SettleFee = $20; //出款手续费",
"	$1.SmallDouble = $21; //小额双免",
"	$1.BizEnterNo = $22; //业务员编号",
"	$1.BizEnterName = $23; //业务员名称",
"	$1.SourceType = $24; //来源类型",
"	$1.BillType = $25; //计费类型",
"	$1.KqTradeSeq = $26; //快钱交易流水号",
"	$1.InputModel = $27; //输入模式",
"	$1.TerminalNo = $28; //终端号",
"	$1.DeviceNetwork = $29; //设备网络",
"}"
]
},
"获取快钱流量卡分佣交易数量": {
"prefix": "ym-db-KqTradeFlux-FindAndCount",
"body": [
"int $1 = db.KqTradeFlux.Count(m => $2);",
]
},
"添加快钱流量卡分佣交易": {
"prefix": "ym-db-KqTradeFlux-Create",
"body": [
"db.KqTradeFlux.Add(new KqTradeFlux()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TradeSerialNo = $1, //交易单号",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	TradeAmount = $4, //交易金额",
"	ProductType = $5, //产品类型",
"	TradeStatus = $6, //交易状态",
"	TradeDate = $7, //交易日期",
"	TradeTime = $8, //交易时间",
"	BankCardType = $9, //银行卡类型",
"	TradeSnNo = $10, //交易SN号",
"	DigAmtFlag = $11, //挖款标识",
"	DigAmt = $12, //挖款金额",
"	Remark = $13, //注释",
"	CreateTime = $14, //创建时间",
"	UpdateTime = $15, //更新时间",
"	BankCardNo = $16, //交易卡号",
"	FeeAmount = $17, //手续费",
"	SettleMethod = $18, //出款方式",
"	SettleFee = $19, //出款手续费",
"	SmallDouble = $20, //小额双免",
"	BizEnterNo = $21, //业务员编号",
"	BizEnterName = $22, //业务员名称",
"	SourceType = $23, //来源类型",
"	BillType = $24, //计费类型",
"	KqTradeSeq = $25, //快钱交易流水号",
"	InputModel = $26, //输入模式",
"	TerminalNo = $27, //终端号",
"	DeviceNetwork = $28, //设备网络",
"});"
]
},"删除某个快钱流量卡分佣交易": {
"prefix": "ym-db-KqTradeFlux-Delete",
"body": [
"KqTradeFlux $1 = db.KqTradeFlux.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KqTradeFlux.Remove($1);",
"}"
]
},
"查询快闪刷商户绑定列表": {
"prefix": "ym-db-KssBind-Find",
"body": [
"List<KssBind> $1 = db.KssBind.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssBind $3 in $1)",
"{",
"}"
]
},
"查询快闪刷商户绑定列表，并取值": {
"prefix": "ym-db-KssBind-FindWithData",
"body": [
"List<KssBind> $1 = db.KssBind.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssBind $3 in $1)",
"{",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	DateTime MerOperateDate = $3.MerOperateDate; //操作时间",
"	string MerOperateType = $3.MerOperateType; //操作类型",
"	string MerStatus = $3.MerStatus; //商户状态",
"	string ProductType = $3.ProductType; //产品类型",
"	string MerNewSnNo = $3.MerNewSnNo; //新终端机身号",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快闪刷商户绑定": {
"prefix": "ym-db-KssBind-Exist",
"body": [
"bool $1 = db.KssBind.Any(m => m.MerNo == $2);",
]
},
"查询某个快闪刷商户绑定，并取值": {
"prefix": "ym-db-KssBind-FindByPrimaryKey",
"body": [
"KssBind $1 = db.KssBind.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	DateTime MerOperateDate = $1.MerOperateDate; //操作时间",
"	string MerOperateType = $1.MerOperateType; //操作类型",
"	string MerStatus = $1.MerStatus; //商户状态",
"	string ProductType = $1.ProductType; //产品类型",
"	string MerNewSnNo = $1.MerNewSnNo; //新终端机身号",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快闪刷商户绑定，并赋值": {
"prefix": "ym-db-KssBind-Update",
"body": [
"KssBind $1 = db.KssBind.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.AgentName = $2; //机构名称",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.MerSnNo = $5; //终端机身号",
"	$1.MerOperateDate = $6; //操作时间",
"	$1.MerOperateType = $7; //操作类型",
"	$1.MerStatus = $8; //商户状态",
"	$1.ProductType = $9; //产品类型",
"	$1.MerNewSnNo = $10; //新终端机身号",
"	$1.Remark = $11; //注释",
"	$1.CreateTime = $12; //创建时间",
"	$1.UpdateTime = $13; //更新时间",
"}"
]
},
"获取快闪刷商户绑定数量": {
"prefix": "ym-db-KssBind-FindAndCount",
"body": [
"int $1 = db.KssBind.Count(m => $2);",
]
},
"添加快闪刷商户绑定": {
"prefix": "ym-db-KssBind-Create",
"body": [
"db.KssBind.Add(new KssBind()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AgentName = $1, //机构名称",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	MerSnNo = $4, //终端机身号",
"	MerOperateDate = $5, //操作时间",
"	MerOperateType = $6, //操作类型",
"	MerStatus = $7, //商户状态",
"	ProductType = $8, //产品类型",
"	MerNewSnNo = $9, //新终端机身号",
"	Remark = $10, //注释",
"	CreateTime = $11, //创建时间",
"	UpdateTime = $12, //更新时间",
"});"
]
},"删除某个快闪刷商户绑定": {
"prefix": "ym-db-KssBind-Delete",
"body": [
"KssBind $1 = db.KssBind.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KssBind.Remove($1);",
"}"
]
},
"查询快闪刷商户免押金列表": {
"prefix": "ym-db-KssFreeDeposit-Find",
"body": [
"List<KssFreeDeposit> $1 = db.KssFreeDeposit.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssFreeDeposit $3 in $1)",
"{",
"}"
]
},
"查询快闪刷商户免押金列表，并取值": {
"prefix": "ym-db-KssFreeDeposit-FindWithData",
"body": [
"List<KssFreeDeposit> $1 = db.KssFreeDeposit.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssFreeDeposit $3 in $1)",
"{",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string ProductType = $3.ProductType; //产品类型",
"	DateTime MerBindDate = $3.MerBindDate; //绑定日期",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	string ActNo = $3.ActNo; //押金活动ID",
"	string ActName = $3.ActName; //押金活动名称",
"	string NewFlag = $3.NewFlag; //是否新增",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快闪刷商户免押金": {
"prefix": "ym-db-KssFreeDeposit-Exist",
"body": [
"bool $1 = db.KssFreeDeposit.Any(m => m.MerNo == $2);",
]
},
"查询某个快闪刷商户免押金，并取值": {
"prefix": "ym-db-KssFreeDeposit-FindByPrimaryKey",
"body": [
"KssFreeDeposit $1 = db.KssFreeDeposit.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string ProductType = $1.ProductType; //产品类型",
"	DateTime MerBindDate = $1.MerBindDate; //绑定日期",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	string ActNo = $1.ActNo; //押金活动ID",
"	string ActName = $1.ActName; //押金活动名称",
"	string NewFlag = $1.NewFlag; //是否新增",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快闪刷商户免押金，并赋值": {
"prefix": "ym-db-KssFreeDeposit-Update",
"body": [
"KssFreeDeposit $1 = db.KssFreeDeposit.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.AgentName = $2; //机构名称",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.ProductType = $5; //产品类型",
"	$1.MerBindDate = $6; //绑定日期",
"	$1.MerSnNo = $7; //终端机身号",
"	$1.ActNo = $8; //押金活动ID",
"	$1.ActName = $9; //押金活动名称",
"	$1.NewFlag = $10; //是否新增",
"	$1.Remark = $11; //注释",
"	$1.CreateTime = $12; //创建时间",
"	$1.UpdateTime = $13; //更新时间",
"}"
]
},
"获取快闪刷商户免押金数量": {
"prefix": "ym-db-KssFreeDeposit-FindAndCount",
"body": [
"int $1 = db.KssFreeDeposit.Count(m => $2);",
]
},
"添加快闪刷商户免押金": {
"prefix": "ym-db-KssFreeDeposit-Create",
"body": [
"db.KssFreeDeposit.Add(new KssFreeDeposit()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AgentName = $1, //机构名称",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	ProductType = $4, //产品类型",
"	MerBindDate = $5, //绑定日期",
"	MerSnNo = $6, //终端机身号",
"	ActNo = $7, //押金活动ID",
"	ActName = $8, //押金活动名称",
"	NewFlag = $9, //是否新增",
"	Remark = $10, //注释",
"	CreateTime = $11, //创建时间",
"	UpdateTime = $12, //更新时间",
"});"
]
},"删除某个快闪刷商户免押金": {
"prefix": "ym-db-KssFreeDeposit-Delete",
"body": [
"KssFreeDeposit $1 = db.KssFreeDeposit.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KssFreeDeposit.Remove($1);",
"}"
]
},
"查询快闪刷商户列表": {
"prefix": "ym-db-KssMerchant-Find",
"body": [
"List<KssMerchant> $1 = db.KssMerchant.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssMerchant $3 in $1)",
"{",
"}"
]
},
"查询快闪刷商户列表，并取值": {
"prefix": "ym-db-KssMerchant-FindWithData",
"body": [
"List<KssMerchant> $1 = db.KssMerchant.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssMerchant $3 in $1)",
"{",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerRealName = $3.MerRealName; //商户真实姓名",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string MerIdcardNo = $3.MerIdcardNo; //商户身份证号",
"	DateTime MerRegDate = $3.MerRegDate; //注册日期",
"	DateTime MerAuditDate = $3.MerAuditDate; //审核日期",
"	string MerStatus = $3.MerStatus; //商户状态",
"	string ProductType = $3.ProductType; //产品类型",
"	string Province = $3.Province; //商户注册省份",
"	string City = $3.City; //商户注册城市",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快闪刷商户": {
"prefix": "ym-db-KssMerchant-Exist",
"body": [
"bool $1 = db.KssMerchant.Any(m => m.MerNo == $2);",
]
},
"查询某个快闪刷商户，并取值": {
"prefix": "ym-db-KssMerchant-FindByPrimaryKey",
"body": [
"KssMerchant $1 = db.KssMerchant.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerRealName = $1.MerRealName; //商户真实姓名",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string MerIdcardNo = $1.MerIdcardNo; //商户身份证号",
"	DateTime MerRegDate = $1.MerRegDate; //注册日期",
"	DateTime MerAuditDate = $1.MerAuditDate; //审核日期",
"	string MerStatus = $1.MerStatus; //商户状态",
"	string ProductType = $1.ProductType; //产品类型",
"	string Province = $1.Province; //商户注册省份",
"	string City = $1.City; //商户注册城市",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快闪刷商户，并赋值": {
"prefix": "ym-db-KssMerchant-Update",
"body": [
"KssMerchant $1 = db.KssMerchant.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.MerNo = $2; //商户编号",
"	$1.MerName = $3; //商户名称",
"	$1.AgentName = $4; //机构名称",
"	$1.MerRealName = $5; //商户真实姓名",
"	$1.MerMobile = $6; //商户手机号",
"	$1.MerIdcardNo = $7; //商户身份证号",
"	$1.MerRegDate = $8; //注册日期",
"	$1.MerAuditDate = $9; //审核日期",
"	$1.MerStatus = $10; //商户状态",
"	$1.ProductType = $11; //产品类型",
"	$1.Province = $12; //商户注册省份",
"	$1.City = $13; //商户注册城市",
"	$1.Remark = $14; //注释",
"	$1.CreateTime = $15; //创建时间",
"	$1.UpdateTime = $16; //更新时间",
"}"
]
},
"获取快闪刷商户数量": {
"prefix": "ym-db-KssMerchant-FindAndCount",
"body": [
"int $1 = db.KssMerchant.Count(m => $2);",
]
},
"添加快闪刷商户": {
"prefix": "ym-db-KssMerchant-Create",
"body": [
"db.KssMerchant.Add(new KssMerchant()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	MerNo = $1, //商户编号",
"	MerName = $2, //商户名称",
"	AgentName = $3, //机构名称",
"	MerRealName = $4, //商户真实姓名",
"	MerMobile = $5, //商户手机号",
"	MerIdcardNo = $6, //商户身份证号",
"	MerRegDate = $7, //注册日期",
"	MerAuditDate = $8, //审核日期",
"	MerStatus = $9, //商户状态",
"	ProductType = $10, //产品类型",
"	Province = $11, //商户注册省份",
"	City = $12, //商户注册城市",
"	Remark = $13, //注释",
"	CreateTime = $14, //创建时间",
"	UpdateTime = $15, //更新时间",
"});"
]
},"删除某个快闪刷商户": {
"prefix": "ym-db-KssMerchant-Delete",
"body": [
"KssMerchant $1 = db.KssMerchant.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KssMerchant.Remove($1);",
"}"
]
},
"查询快闪刷商户返押列表": {
"prefix": "ym-db-KssReturnDeposit-Find",
"body": [
"List<KssReturnDeposit> $1 = db.KssReturnDeposit.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssReturnDeposit $3 in $1)",
"{",
"}"
]
},
"查询快闪刷商户返押列表，并取值": {
"prefix": "ym-db-KssReturnDeposit-FindWithData",
"body": [
"List<KssReturnDeposit> $1 = db.KssReturnDeposit.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssReturnDeposit $3 in $1)",
"{",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string ActNo = $3.ActNo; //押金活动ID",
"	string ActName = $3.ActName; //押金活动名称",
"	DateTime MerDisposeDate = $3.MerDisposeDate; //押金日期",
"	DateTime MerStdDate = $3.MerStdDate; //达标日期",
"	int IntervalDay = $3.IntervalDay; //间隔天数",
"	string ProductType = $3.ProductType; //产品类型",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	decimal RetAmount = $3.RetAmount; //返押金额",
"	string RetFlag = $3.RetFlag; //是否返还",
"	string RetOrderNo = $3.RetOrderNo; //返押订单ID",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快闪刷商户返押": {
"prefix": "ym-db-KssReturnDeposit-Exist",
"body": [
"bool $1 = db.KssReturnDeposit.Any(m => m.MerNo == $2);",
]
},
"查询某个快闪刷商户返押，并取值": {
"prefix": "ym-db-KssReturnDeposit-FindByPrimaryKey",
"body": [
"KssReturnDeposit $1 = db.KssReturnDeposit.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string ActNo = $1.ActNo; //押金活动ID",
"	string ActName = $1.ActName; //押金活动名称",
"	DateTime MerDisposeDate = $1.MerDisposeDate; //押金日期",
"	DateTime MerStdDate = $1.MerStdDate; //达标日期",
"	int IntervalDay = $1.IntervalDay; //间隔天数",
"	string ProductType = $1.ProductType; //产品类型",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	decimal RetAmount = $1.RetAmount; //返押金额",
"	string RetFlag = $1.RetFlag; //是否返还",
"	string RetOrderNo = $1.RetOrderNo; //返押订单ID",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快闪刷商户返押，并赋值": {
"prefix": "ym-db-KssReturnDeposit-Update",
"body": [
"KssReturnDeposit $1 = db.KssReturnDeposit.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.AgentName = $2; //机构名称",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.ActNo = $5; //押金活动ID",
"	$1.ActName = $6; //押金活动名称",
"	$1.MerDisposeDate = $7; //押金日期",
"	$1.MerStdDate = $8; //达标日期",
"	$1.IntervalDay = $9; //间隔天数",
"	$1.ProductType = $10; //产品类型",
"	$1.MerSnNo = $11; //终端机身号",
"	$1.RetAmount = $12; //返押金额",
"	$1.RetFlag = $13; //是否返还",
"	$1.RetOrderNo = $14; //返押订单ID",
"	$1.Remark = $15; //注释",
"	$1.CreateTime = $16; //创建时间",
"	$1.UpdateTime = $17; //更新时间",
"}"
]
},
"获取快闪刷商户返押数量": {
"prefix": "ym-db-KssReturnDeposit-FindAndCount",
"body": [
"int $1 = db.KssReturnDeposit.Count(m => $2);",
]
},
"添加快闪刷商户返押": {
"prefix": "ym-db-KssReturnDeposit-Create",
"body": [
"db.KssReturnDeposit.Add(new KssReturnDeposit()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AgentName = $1, //机构名称",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	ActNo = $4, //押金活动ID",
"	ActName = $5, //押金活动名称",
"	MerDisposeDate = $6, //押金日期",
"	MerStdDate = $7, //达标日期",
"	IntervalDay = $8, //间隔天数",
"	ProductType = $9, //产品类型",
"	MerSnNo = $10, //终端机身号",
"	RetAmount = $11, //返押金额",
"	RetFlag = $12, //是否返还",
"	RetOrderNo = $13, //返押订单ID",
"	Remark = $14, //注释",
"	CreateTime = $15, //创建时间",
"	UpdateTime = $16, //更新时间",
"});"
]
},"删除某个快闪刷商户返押": {
"prefix": "ym-db-KssReturnDeposit-Delete",
"body": [
"KssReturnDeposit $1 = db.KssReturnDeposit.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KssReturnDeposit.Remove($1);",
"}"
]
},
"查询快闪刷商户在网达标列表": {
"prefix": "ym-db-KssStageRwd-Find",
"body": [
"List<KssStageRwd> $1 = db.KssStageRwd.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssStageRwd $3 in $1)",
"{",
"}"
]
},
"查询快闪刷商户在网达标列表，并取值": {
"prefix": "ym-db-KssStageRwd-FindWithData",
"body": [
"List<KssStageRwd> $1 = db.KssStageRwd.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssStageRwd $3 in $1)",
"{",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string ProductType = $3.ProductType; //产品类型",
"	DateTime MerBindDate = $3.MerBindDate; //绑定日期",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	string ActNo = $3.ActNo; //押金活动ID",
"	string ActName = $3.ActName; //押金活动名称",
"	string MerStdStage = $3.MerStdStage; //达标阶段",
"	DateTime MerStdDate = $3.MerStdDate; //达标日期",
"	string MerStdStatus = $3.MerStdStatus; //达标状态",
"	string NewFlag = $3.NewFlag; //是否新增",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快闪刷商户在网达标": {
"prefix": "ym-db-KssStageRwd-Exist",
"body": [
"bool $1 = db.KssStageRwd.Any(m => m.MerNo == $2);",
]
},
"查询某个快闪刷商户在网达标，并取值": {
"prefix": "ym-db-KssStageRwd-FindByPrimaryKey",
"body": [
"KssStageRwd $1 = db.KssStageRwd.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string ProductType = $1.ProductType; //产品类型",
"	DateTime MerBindDate = $1.MerBindDate; //绑定日期",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	string ActNo = $1.ActNo; //押金活动ID",
"	string ActName = $1.ActName; //押金活动名称",
"	string MerStdStage = $1.MerStdStage; //达标阶段",
"	DateTime MerStdDate = $1.MerStdDate; //达标日期",
"	string MerStdStatus = $1.MerStdStatus; //达标状态",
"	string NewFlag = $1.NewFlag; //是否新增",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快闪刷商户在网达标，并赋值": {
"prefix": "ym-db-KssStageRwd-Update",
"body": [
"KssStageRwd $1 = db.KssStageRwd.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.AgentName = $2; //机构名称",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.ProductType = $5; //产品类型",
"	$1.MerBindDate = $6; //绑定日期",
"	$1.MerSnNo = $7; //终端机身号",
"	$1.ActNo = $8; //押金活动ID",
"	$1.ActName = $9; //押金活动名称",
"	$1.MerStdStage = $10; //达标阶段",
"	$1.MerStdDate = $11; //达标日期",
"	$1.MerStdStatus = $12; //达标状态",
"	$1.NewFlag = $13; //是否新增",
"	$1.Remark = $14; //注释",
"	$1.CreateTime = $15; //创建时间",
"	$1.UpdateTime = $16; //更新时间",
"}"
]
},
"获取快闪刷商户在网达标数量": {
"prefix": "ym-db-KssStageRwd-FindAndCount",
"body": [
"int $1 = db.KssStageRwd.Count(m => $2);",
]
},
"添加快闪刷商户在网达标": {
"prefix": "ym-db-KssStageRwd-Create",
"body": [
"db.KssStageRwd.Add(new KssStageRwd()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AgentName = $1, //机构名称",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	ProductType = $4, //产品类型",
"	MerBindDate = $5, //绑定日期",
"	MerSnNo = $6, //终端机身号",
"	ActNo = $7, //押金活动ID",
"	ActName = $8, //押金活动名称",
"	MerStdStage = $9, //达标阶段",
"	MerStdDate = $10, //达标日期",
"	MerStdStatus = $11, //达标状态",
"	NewFlag = $12, //是否新增",
"	Remark = $13, //注释",
"	CreateTime = $14, //创建时间",
"	UpdateTime = $15, //更新时间",
"});"
]
},"删除某个快闪刷商户在网达标": {
"prefix": "ym-db-KssStageRwd-Delete",
"body": [
"KssStageRwd $1 = db.KssStageRwd.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KssStageRwd.Remove($1);",
"}"
]
},
"查询快闪刷商户首刷列表": {
"prefix": "ym-db-KssTradeFirst-Find",
"body": [
"List<KssTradeFirst> $1 = db.KssTradeFirst.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssTradeFirst $3 in $1)",
"{",
"}"
]
},
"查询快闪刷商户首刷列表，并取值": {
"prefix": "ym-db-KssTradeFirst-FindWithData",
"body": [
"List<KssTradeFirst> $1 = db.KssTradeFirst.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (KssTradeFirst $3 in $1)",
"{",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string ProductType = $3.ProductType; //产品类型",
"	DateTime MerBindDate = $3.MerBindDate; //绑定日期",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	string ActNo = $3.ActNo; //押金活动ID",
"	string ActName = $3.ActName; //押金活动名称",
"	DateTime MerStdDate = $3.MerStdDate; //达标日期",
"	string MerStdStatus = $3.MerStdStatus; //达标状态",
"	string NewFlag = $3.NewFlag; //是否新增",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"}"
]
},
"查询快闪刷商户首刷": {
"prefix": "ym-db-KssTradeFirst-Exist",
"body": [
"bool $1 = db.KssTradeFirst.Any(m => m.MerNo == $2);",
]
},
"查询某个快闪刷商户首刷，并取值": {
"prefix": "ym-db-KssTradeFirst-FindByPrimaryKey",
"body": [
"KssTradeFirst $1 = db.KssTradeFirst.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string ProductType = $1.ProductType; //产品类型",
"	DateTime MerBindDate = $1.MerBindDate; //绑定日期",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	string ActNo = $1.ActNo; //押金活动ID",
"	string ActName = $1.ActName; //押金活动名称",
"	DateTime MerStdDate = $1.MerStdDate; //达标日期",
"	string MerStdStatus = $1.MerStdStatus; //达标状态",
"	string NewFlag = $1.NewFlag; //是否新增",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"}"
]
},
"查询某个快闪刷商户首刷，并赋值": {
"prefix": "ym-db-KssTradeFirst-Update",
"body": [
"KssTradeFirst $1 = db.KssTradeFirst.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.AgentName = $2; //机构名称",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.ProductType = $5; //产品类型",
"	$1.MerBindDate = $6; //绑定日期",
"	$1.MerSnNo = $7; //终端机身号",
"	$1.ActNo = $8; //押金活动ID",
"	$1.ActName = $9; //押金活动名称",
"	$1.MerStdDate = $10; //达标日期",
"	$1.MerStdStatus = $11; //达标状态",
"	$1.NewFlag = $12; //是否新增",
"	$1.Remark = $13; //注释",
"	$1.CreateTime = $14; //创建时间",
"	$1.UpdateTime = $15; //更新时间",
"}"
]
},
"获取快闪刷商户首刷数量": {
"prefix": "ym-db-KssTradeFirst-FindAndCount",
"body": [
"int $1 = db.KssTradeFirst.Count(m => $2);",
]
},
"添加快闪刷商户首刷": {
"prefix": "ym-db-KssTradeFirst-Create",
"body": [
"db.KssTradeFirst.Add(new KssTradeFirst()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AgentName = $1, //机构名称",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	ProductType = $4, //产品类型",
"	MerBindDate = $5, //绑定日期",
"	MerSnNo = $6, //终端机身号",
"	ActNo = $7, //押金活动ID",
"	ActName = $8, //押金活动名称",
"	MerStdDate = $9, //达标日期",
"	MerStdStatus = $10, //达标状态",
"	NewFlag = $11, //是否新增",
"	Remark = $12, //注释",
"	CreateTime = $13, //创建时间",
"	UpdateTime = $14, //更新时间",
"});"
]
},"删除某个快闪刷商户首刷": {
"prefix": "ym-db-KssTradeFirst-Delete",
"body": [
"KssTradeFirst $1 = db.KssTradeFirst.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.KssTradeFirst.Remove($1);",
"}"
]
},
"查询商户列表": {
"prefix": "ym-db-Merchants-Find",
"body": [
"List<Merchants> $1 = db.Merchants.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (Merchants $3 in $1)",
"{",
"}"
]
},
"查询商户列表，并取值": {
"prefix": "ym-db-Merchants-FindWithData",
"body": [
"List<Merchants> $1 = db.Merchants.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (Merchants $3 in $1)",
"{",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerRealName = $3.MerRealName; //商户真实姓名",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string MerIdcardNo = $3.MerIdcardNo; //商户身份证号",
"	DateTime MerRegDate = $3.MerRegDate; //注册日期",
"	DateTime MerAuditDate = $3.MerAuditDate; //审核日期",
"	string MerStatus = $3.MerStatus; //商户状态",
"	string ProductType = $3.ProductType; //产品类型",
"	string Province = $3.Province; //商户注册省份",
"	string City = $3.City; //商户注册城市",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"	string SnNo = $3.SnNo; //SN号",
"	string AgentNo = $3.AgentNo; //代理商编号",
"}"
]
},
"查询商户": {
"prefix": "ym-db-Merchants-Exist",
"body": [
"bool $1 = db.Merchants.Any(m => m.MerNo == $2);",
]
},
"查询某个商户，并取值": {
"prefix": "ym-db-Merchants-FindByPrimaryKey",
"body": [
"Merchants $1 = db.Merchants.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerRealName = $1.MerRealName; //商户真实姓名",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string MerIdcardNo = $1.MerIdcardNo; //商户身份证号",
"	DateTime MerRegDate = $1.MerRegDate; //注册日期",
"	DateTime MerAuditDate = $1.MerAuditDate; //审核日期",
"	string MerStatus = $1.MerStatus; //商户状态",
"	string ProductType = $1.ProductType; //产品类型",
"	string Province = $1.Province; //商户注册省份",
"	string City = $1.City; //商户注册城市",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"	string SnNo = $1.SnNo; //SN号",
"	string AgentNo = $1.AgentNo; //代理商编号",
"}"
]
},
"查询某个商户，并赋值": {
"prefix": "ym-db-Merchants-Update",
"body": [
"Merchants $1 = db.Merchants.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.MerNo = $2; //商户编号",
"	$1.MerName = $3; //商户名称",
"	$1.AgentName = $4; //机构名称",
"	$1.MerRealName = $5; //商户真实姓名",
"	$1.MerMobile = $6; //商户手机号",
"	$1.MerIdcardNo = $7; //商户身份证号",
"	$1.MerRegDate = $8; //注册日期",
"	$1.MerAuditDate = $9; //审核日期",
"	$1.MerStatus = $10; //商户状态",
"	$1.ProductType = $11; //产品类型",
"	$1.Province = $12; //商户注册省份",
"	$1.City = $13; //商户注册城市",
"	$1.Remark = $14; //注释",
"	$1.CreateTime = $15; //创建时间",
"	$1.UpdateTime = $16; //更新时间",
"	$1.SnNo = $17; //SN号",
"	$1.AgentNo = $18; //代理商编号",
"}"
]
},
"获取商户数量": {
"prefix": "ym-db-Merchants-FindAndCount",
"body": [
"int $1 = db.Merchants.Count(m => $2);",
]
},
"添加商户": {
"prefix": "ym-db-Merchants-Create",
"body": [
"db.Merchants.Add(new Merchants()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	MerNo = $1, //商户编号",
"	MerName = $2, //商户名称",
"	AgentName = $3, //机构名称",
"	MerRealName = $4, //商户真实姓名",
"	MerMobile = $5, //商户手机号",
"	MerIdcardNo = $6, //商户身份证号",
"	MerRegDate = $7, //注册日期",
"	MerAuditDate = $8, //审核日期",
"	MerStatus = $9, //商户状态",
"	ProductType = $10, //产品类型",
"	Province = $11, //商户注册省份",
"	City = $12, //商户注册城市",
"	Remark = $13, //注释",
"	CreateTime = $14, //创建时间",
"	UpdateTime = $15, //更新时间",
"	SnNo = $16, //SN号",
"	AgentNo = $17, //代理商编号",
"});"
]
},"删除某个商户": {
"prefix": "ym-db-Merchants-Delete",
"body": [
"Merchants $1 = db.Merchants.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.Merchants.Remove($1);",
"}"
]
},
"查询商户在网达标列表": {
"prefix": "ym-db-MerchantStageRwd-Find",
"body": [
"List<MerchantStageRwd> $1 = db.MerchantStageRwd.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MerchantStageRwd $3 in $1)",
"{",
"}"
]
},
"查询商户在网达标列表，并取值": {
"prefix": "ym-db-MerchantStageRwd-FindWithData",
"body": [
"List<MerchantStageRwd> $1 = db.MerchantStageRwd.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (MerchantStageRwd $3 in $1)",
"{",
"	string AgentName = $3.AgentName; //机构名称",
"	string MerName = $3.MerName; //商户名称",
"	string ProductType = $3.ProductType; //产品类型",
"	DateTime MerBindDate = $3.MerBindDate; //绑定日期",
"	string MerSnNo = $3.MerSnNo; //终端机身号",
"	string ActNo = $3.ActNo; //押金活动ID",
"	string ActName = $3.ActName; //押金活动名称",
"	string MerStdStage = $3.MerStdStage; //达标阶段",
"	DateTime MerStdDate = $3.MerStdDate; //达标日期",
"	string MerStdStatus = $3.MerStdStatus; //达标状态",
"	string NewFlag = $3.NewFlag; //是否新增",
"	string Remark = $3.Remark; //注释",
"	DateTime CreateTime = $3.CreateTime; //创建时间",
"	DateTime UpdateTime = $3.UpdateTime; //更新时间",
"	string MerNo = $3.MerNo; //商户编号",
"}"
]
},
"查询商户在网达标": {
"prefix": "ym-db-MerchantStageRwd-Exist",
"body": [
"bool $1 = db.MerchantStageRwd.Any(m => m.MerNo == $2);",
]
},
"查询某个商户在网达标，并取值": {
"prefix": "ym-db-MerchantStageRwd-FindByPrimaryKey",
"body": [
"MerchantStageRwd $1 = db.MerchantStageRwd.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string AgentName = $1.AgentName; //机构名称",
"	string MerName = $1.MerName; //商户名称",
"	string ProductType = $1.ProductType; //产品类型",
"	DateTime MerBindDate = $1.MerBindDate; //绑定日期",
"	string MerSnNo = $1.MerSnNo; //终端机身号",
"	string ActNo = $1.ActNo; //押金活动ID",
"	string ActName = $1.ActName; //押金活动名称",
"	string MerStdStage = $1.MerStdStage; //达标阶段",
"	DateTime MerStdDate = $1.MerStdDate; //达标日期",
"	string MerStdStatus = $1.MerStdStatus; //达标状态",
"	string NewFlag = $1.NewFlag; //是否新增",
"	string Remark = $1.Remark; //注释",
"	DateTime CreateTime = $1.CreateTime; //创建时间",
"	DateTime UpdateTime = $1.UpdateTime; //更新时间",
"	string MerNo = $1.MerNo; //商户编号",
"}"
]
},
"查询某个商户在网达标，并赋值": {
"prefix": "ym-db-MerchantStageRwd-Update",
"body": [
"MerchantStageRwd $1 = db.MerchantStageRwd.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.AgentName = $2; //机构名称",
"	$1.MerName = $3; //商户名称",
"	$1.ProductType = $4; //产品类型",
"	$1.MerBindDate = $5; //绑定日期",
"	$1.MerSnNo = $6; //终端机身号",
"	$1.ActNo = $7; //押金活动ID",
"	$1.ActName = $8; //押金活动名称",
"	$1.MerStdStage = $9; //达标阶段",
"	$1.MerStdDate = $10; //达标日期",
"	$1.MerStdStatus = $11; //达标状态",
"	$1.NewFlag = $12; //是否新增",
"	$1.Remark = $13; //注释",
"	$1.CreateTime = $14; //创建时间",
"	$1.UpdateTime = $15; //更新时间",
"	$1.MerNo = $16; //商户编号",
"}"
]
},
"获取商户在网达标数量": {
"prefix": "ym-db-MerchantStageRwd-FindAndCount",
"body": [
"int $1 = db.MerchantStageRwd.Count(m => $2);",
]
},
"添加商户在网达标": {
"prefix": "ym-db-MerchantStageRwd-Create",
"body": [
"db.MerchantStageRwd.Add(new MerchantStageRwd()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	AgentName = $1, //机构名称",
"	MerName = $2, //商户名称",
"	ProductType = $3, //产品类型",
"	MerBindDate = $4, //绑定日期",
"	MerSnNo = $5, //终端机身号",
"	ActNo = $6, //押金活动ID",
"	ActName = $7, //押金活动名称",
"	MerStdStage = $8, //达标阶段",
"	MerStdDate = $9, //达标日期",
"	MerStdStatus = $10, //达标状态",
"	NewFlag = $11, //是否新增",
"	Remark = $12, //注释",
"	CreateTime = $13, //创建时间",
"	UpdateTime = $14, //更新时间",
"	MerNo = $15, //商户编号",
"});"
]
},"删除某个商户在网达标": {
"prefix": "ym-db-MerchantStageRwd-Delete",
"body": [
"MerchantStageRwd $1 = db.MerchantStageRwd.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.MerchantStageRwd.Remove($1);",
"}"
]
},
"查询分润记录列表": {
"prefix": "ym-db-ProfitRecord-Find",
"body": [
"List<ProfitRecord> $1 = db.ProfitRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (ProfitRecord $3 in $1)",
"{",
"}"
]
},
"查询分润记录列表，并取值": {
"prefix": "ym-db-ProfitRecord-FindWithData",
"body": [
"List<ProfitRecord> $1 = db.ProfitRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (ProfitRecord $3 in $1)",
"{",
"	string requestId = $3.requestId; //请求号",
"	string organizationNumber = $3.organizationNumber; //直属代理编号",
"	string organizationName = $3.organizationName; //直属代理名称",
"	string amount = $3.amount; //分润基础数据金额",
"	string orderNo = $3.orderNo; //原交易/结算流水单号",
"	string valueType = $3.valueType; //费率类型",
"	string balanceDirection = $3.balanceDirection; //支出方向",
"	string originalRate = $3.originalRate; //商户费率",
"	string originalFee = $3.originalFee; //原手续费",
"	string profitCost = $3.profitCost; //成本值",
"	string couponAmt = $3.couponAmt; //优惠券金额",
"	string actualCouponAmt = $3.actualCouponAmt; //分润使用优惠券金额",
"	string profitRate = $3.profitRate; //分润税点",
"	string rateFee = $3.rateFee; //分润税费",
"	string incomeScale = $3.incomeScale; //入账比例",
"	string actualIncomeAmt = $3.actualIncomeAmt; //实际结账户金额",
"	string applyDay = $3.applyDay; //分润日期",
"	string createTime = $3.createTime; //创建时间",
"	string topOrgNo = $3.topOrgNo; //一级服务商编号",
"}"
]
},
"查询分润记录": {
"prefix": "ym-db-ProfitRecord-Exist",
"body": [
"bool $1 = db.ProfitRecord.Any(m => m.Id == $2);",
]
},
"查询某个分润记录，并取值": {
"prefix": "ym-db-ProfitRecord-FindByPrimaryKey",
"body": [
"ProfitRecord $1 = db.ProfitRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string requestId = $1.requestId; //请求号",
"	string organizationNumber = $1.organizationNumber; //直属代理编号",
"	string organizationName = $1.organizationName; //直属代理名称",
"	string amount = $1.amount; //分润基础数据金额",
"	string orderNo = $1.orderNo; //原交易/结算流水单号",
"	string valueType = $1.valueType; //费率类型",
"	string balanceDirection = $1.balanceDirection; //支出方向",
"	string originalRate = $1.originalRate; //商户费率",
"	string originalFee = $1.originalFee; //原手续费",
"	string profitCost = $1.profitCost; //成本值",
"	string couponAmt = $1.couponAmt; //优惠券金额",
"	string actualCouponAmt = $1.actualCouponAmt; //分润使用优惠券金额",
"	string profitRate = $1.profitRate; //分润税点",
"	string rateFee = $1.rateFee; //分润税费",
"	string incomeScale = $1.incomeScale; //入账比例",
"	string actualIncomeAmt = $1.actualIncomeAmt; //实际结账户金额",
"	string applyDay = $1.applyDay; //分润日期",
"	string createTime = $1.createTime; //创建时间",
"	string topOrgNo = $1.topOrgNo; //一级服务商编号",
"}"
]
},
"查询某个分润记录，并赋值": {
"prefix": "ym-db-ProfitRecord-Update",
"body": [
"ProfitRecord $1 = db.ProfitRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.requestId = $2; //请求号",
"	$1.organizationNumber = $3; //直属代理编号",
"	$1.organizationName = $4; //直属代理名称",
"	$1.amount = $5; //分润基础数据金额",
"	$1.orderNo = $6; //原交易/结算流水单号",
"	$1.valueType = $7; //费率类型",
"	$1.balanceDirection = $8; //支出方向",
"	$1.originalRate = $9; //商户费率",
"	$1.originalFee = $10; //原手续费",
"	$1.profitCost = $11; //成本值",
"	$1.couponAmt = $12; //优惠券金额",
"	$1.actualCouponAmt = $13; //分润使用优惠券金额",
"	$1.profitRate = $14; //分润税点",
"	$1.rateFee = $15; //分润税费",
"	$1.incomeScale = $16; //入账比例",
"	$1.actualIncomeAmt = $17; //实际结账户金额",
"	$1.applyDay = $18; //分润日期",
"	$1.createTime = $19; //创建时间",
"	$1.topOrgNo = $20; //一级服务商编号",
"}"
]
},
"获取分润记录数量": {
"prefix": "ym-db-ProfitRecord-FindAndCount",
"body": [
"int $1 = db.ProfitRecord.Count(m => $2);",
]
},
"添加分润记录": {
"prefix": "ym-db-ProfitRecord-Create",
"body": [
"db.ProfitRecord.Add(new ProfitRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	requestId = $1, //请求号",
"	organizationNumber = $2, //直属代理编号",
"	organizationName = $3, //直属代理名称",
"	amount = $4, //分润基础数据金额",
"	orderNo = $5, //原交易/结算流水单号",
"	valueType = $6, //费率类型",
"	balanceDirection = $7, //支出方向",
"	originalRate = $8, //商户费率",
"	originalFee = $9, //原手续费",
"	profitCost = $10, //成本值",
"	couponAmt = $11, //优惠券金额",
"	actualCouponAmt = $12, //分润使用优惠券金额",
"	profitRate = $13, //分润税点",
"	rateFee = $14, //分润税费",
"	incomeScale = $15, //入账比例",
"	actualIncomeAmt = $16, //实际结账户金额",
"	applyDay = $17, //分润日期",
"	createTime = $18, //创建时间",
"	topOrgNo = $19, //一级服务商编号",
"});"
]
},"删除某个分润记录": {
"prefix": "ym-db-ProfitRecord-Delete",
"body": [
"ProfitRecord $1 = db.ProfitRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.ProfitRecord.Remove($1);",
"}"
]
},
"查询流量卡分佣交易列表": {
"prefix": "ym-db-TradeFluxRecord-Find",
"body": [
"List<TradeFluxRecord> $1 = db.TradeFluxRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (TradeFluxRecord $3 in $1)",
"{",
"}"
]
},
"查询流量卡分佣交易列表，并取值": {
"prefix": "ym-db-TradeFluxRecord-FindWithData",
"body": [
"List<TradeFluxRecord> $1 = db.TradeFluxRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (TradeFluxRecord $3 in $1)",
"{",
"	string TradeSerialNo = $3.TradeSerialNo; //交易单号",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	decimal TradeAmount = $3.TradeAmount; //交易金额",
"	string TradeStatus = $3.TradeStatus; //交易状态",
"	string TradeDate = $3.TradeDate; //交易日期",
"	string TradeTime = $3.TradeTime; //交易时间",
"	string BankCardType = $3.BankCardType; //银行卡类型",
"	string TradeSnNo = $3.TradeSnNo; //交易SN号",
"	string DigAmtFlag = $3.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $3.DigAmt; //挖款金额",
"	string BankCardNo = $3.BankCardNo; //交易卡号",
"	decimal FeeAmount = $3.FeeAmount; //手续费",
"	string SettleMethod = $3.SettleMethod; //出款方式",
"	decimal SettleFee = $3.SettleFee; //出款手续费",
"	string SmallDouble = $3.SmallDouble; //小额双免",
"	string BizEnterNo = $3.BizEnterNo; //业务员编号",
"	string BizEnterName = $3.BizEnterName; //业务员名称",
"	string SourceType = $3.SourceType; //来源类型",
"	string BillType = $3.BillType; //计费类型",
"	string KqTradeSeq = $3.KqTradeSeq; //快钱交易流水号",
"	string InputModel = $3.InputModel; //输入模式",
"	string TerminalNo = $3.TerminalNo; //终端号",
"	string DeviceNetwork = $3.DeviceNetwork; //设备网络",
"	string ProductType = $3.ProductType; //产品类型",
"	string AgentNo = $3.AgentNo; //代理商编号",
"}"
]
},
"查询流量卡分佣交易": {
"prefix": "ym-db-TradeFluxRecord-Exist",
"body": [
"bool $1 = db.TradeFluxRecord.Any(m => m.MerNo == $2);",
]
},
"查询某个流量卡分佣交易，并取值": {
"prefix": "ym-db-TradeFluxRecord-FindByPrimaryKey",
"body": [
"TradeFluxRecord $1 = db.TradeFluxRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	string TradeSerialNo = $1.TradeSerialNo; //交易单号",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	decimal TradeAmount = $1.TradeAmount; //交易金额",
"	string TradeStatus = $1.TradeStatus; //交易状态",
"	string TradeDate = $1.TradeDate; //交易日期",
"	string TradeTime = $1.TradeTime; //交易时间",
"	string BankCardType = $1.BankCardType; //银行卡类型",
"	string TradeSnNo = $1.TradeSnNo; //交易SN号",
"	string DigAmtFlag = $1.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $1.DigAmt; //挖款金额",
"	string BankCardNo = $1.BankCardNo; //交易卡号",
"	decimal FeeAmount = $1.FeeAmount; //手续费",
"	string SettleMethod = $1.SettleMethod; //出款方式",
"	decimal SettleFee = $1.SettleFee; //出款手续费",
"	string SmallDouble = $1.SmallDouble; //小额双免",
"	string BizEnterNo = $1.BizEnterNo; //业务员编号",
"	string BizEnterName = $1.BizEnterName; //业务员名称",
"	string SourceType = $1.SourceType; //来源类型",
"	string BillType = $1.BillType; //计费类型",
"	string KqTradeSeq = $1.KqTradeSeq; //快钱交易流水号",
"	string InputModel = $1.InputModel; //输入模式",
"	string TerminalNo = $1.TerminalNo; //终端号",
"	string DeviceNetwork = $1.DeviceNetwork; //设备网络",
"	string ProductType = $1.ProductType; //产品类型",
"	string AgentNo = $1.AgentNo; //代理商编号",
"}"
]
},
"查询某个流量卡分佣交易，并赋值": {
"prefix": "ym-db-TradeFluxRecord-Update",
"body": [
"TradeFluxRecord $1 = db.TradeFluxRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	$1.TradeSerialNo = $2; //交易单号",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.TradeAmount = $5; //交易金额",
"	$1.TradeStatus = $6; //交易状态",
"	$1.TradeDate = $7; //交易日期",
"	$1.TradeTime = $8; //交易时间",
"	$1.BankCardType = $9; //银行卡类型",
"	$1.TradeSnNo = $10; //交易SN号",
"	$1.DigAmtFlag = $11; //挖款标识",
"	$1.DigAmt = $12; //挖款金额",
"	$1.BankCardNo = $13; //交易卡号",
"	$1.FeeAmount = $14; //手续费",
"	$1.SettleMethod = $15; //出款方式",
"	$1.SettleFee = $16; //出款手续费",
"	$1.SmallDouble = $17; //小额双免",
"	$1.BizEnterNo = $18; //业务员编号",
"	$1.BizEnterName = $19; //业务员名称",
"	$1.SourceType = $20; //来源类型",
"	$1.BillType = $21; //计费类型",
"	$1.KqTradeSeq = $22; //快钱交易流水号",
"	$1.InputModel = $23; //输入模式",
"	$1.TerminalNo = $24; //终端号",
"	$1.DeviceNetwork = $25; //设备网络",
"	$1.ProductType = $26; //产品类型",
"	$1.AgentNo = $27; //代理商编号",
"}"
]
},
"获取流量卡分佣交易数量": {
"prefix": "ym-db-TradeFluxRecord-FindAndCount",
"body": [
"int $1 = db.TradeFluxRecord.Count(m => $2);",
]
},
"添加流量卡分佣交易": {
"prefix": "ym-db-TradeFluxRecord-Create",
"body": [
"db.TradeFluxRecord.Add(new TradeFluxRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TradeSerialNo = $1, //交易单号",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	TradeAmount = $4, //交易金额",
"	TradeStatus = $5, //交易状态",
"	TradeDate = $6, //交易日期",
"	TradeTime = $7, //交易时间",
"	BankCardType = $8, //银行卡类型",
"	TradeSnNo = $9, //交易SN号",
"	DigAmtFlag = $10, //挖款标识",
"	DigAmt = $11, //挖款金额",
"	BankCardNo = $12, //交易卡号",
"	FeeAmount = $13, //手续费",
"	SettleMethod = $14, //出款方式",
"	SettleFee = $15, //出款手续费",
"	SmallDouble = $16, //小额双免",
"	BizEnterNo = $17, //业务员编号",
"	BizEnterName = $18, //业务员名称",
"	SourceType = $19, //来源类型",
"	BillType = $20, //计费类型",
"	KqTradeSeq = $21, //快钱交易流水号",
"	InputModel = $22, //输入模式",
"	TerminalNo = $23, //终端号",
"	DeviceNetwork = $24, //设备网络",
"	ProductType = $25, //产品类型",
"	AgentNo = $26, //代理商编号",
"});"
]
},"删除某个流量卡分佣交易": {
"prefix": "ym-db-TradeFluxRecord-Delete",
"body": [
"TradeFluxRecord $1 = db.TradeFluxRecord.FirstOrDefault(m => m.MerNo == $2);",
"if ($1 != null)",
"{",
"	db.TradeFluxRecord.Remove($1);",
"}"
]
},
"查询交易记录列表": {
"prefix": "ym-db-TradeRecord-Find",
"body": [
"List<TradeRecord> $1 = db.TradeRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (TradeRecord $3 in $1)",
"{",
"}"
]
},
"查询交易记录列表，并取值": {
"prefix": "ym-db-TradeRecord-FindWithData",
"body": [
"List<TradeRecord> $1 = db.TradeRecord.Where(m => $2).OrderByDescending(m => m.Id).ToList();",
"foreach (TradeRecord $3 in $1)",
"{",
"	string TradeSerialNo = $3.TradeSerialNo; //交易单号",
"	string MerNo = $3.MerNo; //商户编号",
"	string MerName = $3.MerName; //商户名称",
"	decimal TradeAmount = $3.TradeAmount; //交易金额",
"	string TradeReferNo = $3.TradeReferNo; //交易参考号",
"	string BankAuthCode = $3.BankAuthCode; //银行授权码",
"	string DiscountRateFlag = $3.DiscountRateFlag; //优惠费率标识",
"	string TradeStatus = $3.TradeStatus; //交易状态",
"	string ErrorCode = $3.ErrorCode; //错误码",
"	string ErrorMsg = $3.ErrorMsg; //错误信息",
"	string TradeDate = $3.TradeDate; //交易日期",
"	string TradeTime = $3.TradeTime; //交易时间",
"	string TradeType = $3.TradeType; //交易类型",
"	string SerEntryMode = $3.SerEntryMode; //输入模式",
"	string BankCardType = $3.BankCardType; //银行卡类型",
"	string TradeSnNo = $3.TradeSnNo; //交易SN号",
"	string DeviceType = $3.DeviceType; //设备类型",
"	string MerMobile = $3.MerMobile; //商户手机号",
"	string DigAmtFlag = $3.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $3.DigAmt; //挖款金额",
"	string IsStoreCashier = $3.IsStoreCashier; //店面收银交易标识",
"	string ReceiptType = $3.ReceiptType; //设备类型",
"	string BankCardNo = $3.BankCardNo; //交易卡号",
"	decimal SettleFee = $3.SettleFee; //出款手续费",
"	string SettleMethod = $3.SettleMethod; //出款方式",
"	string Remark = $3.Remark; //备注",
"	string ProductType = $3.ProductType; //产品类型",
"	string AgentNo = $3.AgentNo; //代理商编号",
"	string ChannelSerial = $3.ChannelSerial; //渠道流水号",
"}"
]
},
"查询交易记录": {
"prefix": "ym-db-TradeRecord-Exist",
"body": [
"bool $1 = db.TradeRecord.Any(m => m.Id == $2);",
]
},
"查询某个交易记录，并取值": {
"prefix": "ym-db-TradeRecord-FindByPrimaryKey",
"body": [
"TradeRecord $1 = db.TradeRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	string TradeSerialNo = $1.TradeSerialNo; //交易单号",
"	string MerNo = $1.MerNo; //商户编号",
"	string MerName = $1.MerName; //商户名称",
"	decimal TradeAmount = $1.TradeAmount; //交易金额",
"	string TradeReferNo = $1.TradeReferNo; //交易参考号",
"	string BankAuthCode = $1.BankAuthCode; //银行授权码",
"	string DiscountRateFlag = $1.DiscountRateFlag; //优惠费率标识",
"	string TradeStatus = $1.TradeStatus; //交易状态",
"	string ErrorCode = $1.ErrorCode; //错误码",
"	string ErrorMsg = $1.ErrorMsg; //错误信息",
"	string TradeDate = $1.TradeDate; //交易日期",
"	string TradeTime = $1.TradeTime; //交易时间",
"	string TradeType = $1.TradeType; //交易类型",
"	string SerEntryMode = $1.SerEntryMode; //输入模式",
"	string BankCardType = $1.BankCardType; //银行卡类型",
"	string TradeSnNo = $1.TradeSnNo; //交易SN号",
"	string DeviceType = $1.DeviceType; //设备类型",
"	string MerMobile = $1.MerMobile; //商户手机号",
"	string DigAmtFlag = $1.DigAmtFlag; //挖款标识",
"	decimal DigAmt = $1.DigAmt; //挖款金额",
"	string IsStoreCashier = $1.IsStoreCashier; //店面收银交易标识",
"	string ReceiptType = $1.ReceiptType; //设备类型",
"	string BankCardNo = $1.BankCardNo; //交易卡号",
"	decimal SettleFee = $1.SettleFee; //出款手续费",
"	string SettleMethod = $1.SettleMethod; //出款方式",
"	string Remark = $1.Remark; //备注",
"	string ProductType = $1.ProductType; //产品类型",
"	string AgentNo = $1.AgentNo; //代理商编号",
"	string ChannelSerial = $1.ChannelSerial; //渠道流水号",
"}"
]
},
"查询某个交易记录，并赋值": {
"prefix": "ym-db-TradeRecord-Update",
"body": [
"TradeRecord $1 = db.TradeRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	$1.TradeSerialNo = $2; //交易单号",
"	$1.MerNo = $3; //商户编号",
"	$1.MerName = $4; //商户名称",
"	$1.TradeAmount = $5; //交易金额",
"	$1.TradeReferNo = $6; //交易参考号",
"	$1.BankAuthCode = $7; //银行授权码",
"	$1.DiscountRateFlag = $8; //优惠费率标识",
"	$1.TradeStatus = $9; //交易状态",
"	$1.ErrorCode = $10; //错误码",
"	$1.ErrorMsg = $11; //错误信息",
"	$1.TradeDate = $12; //交易日期",
"	$1.TradeTime = $13; //交易时间",
"	$1.TradeType = $14; //交易类型",
"	$1.SerEntryMode = $15; //输入模式",
"	$1.BankCardType = $16; //银行卡类型",
"	$1.TradeSnNo = $17; //交易SN号",
"	$1.DeviceType = $18; //设备类型",
"	$1.MerMobile = $19; //商户手机号",
"	$1.DigAmtFlag = $20; //挖款标识",
"	$1.DigAmt = $21; //挖款金额",
"	$1.IsStoreCashier = $22; //店面收银交易标识",
"	$1.ReceiptType = $23; //设备类型",
"	$1.BankCardNo = $24; //交易卡号",
"	$1.SettleFee = $25; //出款手续费",
"	$1.SettleMethod = $26; //出款方式",
"	$1.Remark = $27; //备注",
"	$1.ProductType = $28; //产品类型",
"	$1.AgentNo = $29; //代理商编号",
"	$1.ChannelSerial = $30; //渠道流水号",
"}"
]
},
"获取交易记录数量": {
"prefix": "ym-db-TradeRecord-FindAndCount",
"body": [
"int $1 = db.TradeRecord.Count(m => $2);",
]
},
"添加交易记录": {
"prefix": "ym-db-TradeRecord-Create",
"body": [
"db.TradeRecord.Add(new TradeRecord()",
"{",
"	CreateDate = DateTime.Now,",
"	UpdateDate = DateTime.Now,",
"	TradeSerialNo = $1, //交易单号",
"	MerNo = $2, //商户编号",
"	MerName = $3, //商户名称",
"	TradeAmount = $4, //交易金额",
"	TradeReferNo = $5, //交易参考号",
"	BankAuthCode = $6, //银行授权码",
"	DiscountRateFlag = $7, //优惠费率标识",
"	TradeStatus = $8, //交易状态",
"	ErrorCode = $9, //错误码",
"	ErrorMsg = $10, //错误信息",
"	TradeDate = $11, //交易日期",
"	TradeTime = $12, //交易时间",
"	TradeType = $13, //交易类型",
"	SerEntryMode = $14, //输入模式",
"	BankCardType = $15, //银行卡类型",
"	TradeSnNo = $16, //交易SN号",
"	DeviceType = $17, //设备类型",
"	MerMobile = $18, //商户手机号",
"	DigAmtFlag = $19, //挖款标识",
"	DigAmt = $20, //挖款金额",
"	IsStoreCashier = $21, //店面收银交易标识",
"	ReceiptType = $22, //设备类型",
"	BankCardNo = $23, //交易卡号",
"	SettleFee = $24, //出款手续费",
"	SettleMethod = $25, //出款方式",
"	Remark = $26, //备注",
"	ProductType = $27, //产品类型",
"	AgentNo = $28, //代理商编号",
"	ChannelSerial = $29, //渠道流水号",
"});"
]
},"删除某个交易记录": {
"prefix": "ym-db-TradeRecord-Delete",
"body": [
"TradeRecord $1 = db.TradeRecord.FirstOrDefault(m => m.Id == $2);",
"if ($1 != null)",
"{",
"	db.TradeRecord.Remove($1);",
"}"
]
},
}