短信模板.sql 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116
  1. USE [DYBBERPDB]
  2. GO
  3. SET IDENTITY_INSERT [dbo].[tb_SMSTemplates] ON
  4. GO
  5. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (61, 0, 1, 1, 101, N'1', N'相关客户', N'', N'XXX先生/女士,您在本店制作的所有产品已全部完成,请尽快到本店进行取件,记得带上您的单据前来。蒙娜丽莎祝您家庭幸福。电话2398865', 0, N'', CAST(0x0000A4F500DF056F AS DateTime), CAST(0x0000A4F500DF056F AS DateTime))
  6. GO
  7. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (4, 0, 1, 1, 100, N'1', N'相关客户', N'', N'XXX先生/女士您好,蒙娜丽莎婚纱摄影温馨提示您,您成功在本店预订套系。拍照前请与客服联系2398865我们将竭诚为您服务,祝您生活愉快!', 0, N'', CAST(0x0000A4F500E0C8AA AS DateTime), CAST(0x0000A4F500E0C8AA AS DateTime))
  8. GO
  9. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (5, 0, 1, 1, 103, N'1', N'相关客户', N'', N'XXX先生/女士,感谢您对蒙娜丽莎的支持,在您拍照期间,若有服务不周或待慢之处,恳请原谅!客服部敬上!电话2398865', 0, N'', CAST(0x0000A4F500E10BB8 AS DateTime), CAST(0x0000A4F500E10BB8 AS DateTime))
  10. GO
  11. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (6, 0, 1, 1, 102, N'1', N'相关客户', N'', N'XXX先生/女士,您在本店预约拍摄时间为XXT,请务必在此时间到店,以免耽误您的拍摄形成。温馨提示:睡前一小时勿喝水,以免眼袋臃肿;请保持充足的睡眠时间;贵重物品请妥善保管;请带上您的收据单到店。感谢您对蒙娜丽莎的支持。电话2398865', 0, N'', CAST(0x0000A4F500E2344F AS DateTime), CAST(0x0000A4F500E2344F AS DateTime))
  12. GO
  13. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (7, 0, 1, 1, 104, N'1', N'相关客户', N'', N'XXX先生/女士,您选的照片已进入数码部进行设计,我们会将您最靓丽的演出,最美丽的神韵,创作出您最满意的作品,祝贺您俩百年好合,永浴爱河!电话2398865', 0, N'', CAST(0x0000A4F500E26FB0 AS DateTime), CAST(0x0000A4F500E26FB0 AS DateTime))
  14. GO
  15. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (8, 0, 1, 1, 105, N'1', N'相关客户', N'', N'XXX先生/女士,您确定的作品已进入制作部进行制作,感谢您对蒙娜丽莎的支持!后续工作我们会全程把关,让您的照片更出色,也希望您能满意!电话2398865', 0, N'', CAST(0x0000A4F500E29C17 AS DateTime), CAST(0x0000A4F500E29C17 AS DateTime))
  16. GO
  17. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (9, 0, 1, 1, 114, N'1', N'相关客户', N'', N'XXX先生/女士,在您生日的来临之际,蒙娜丽莎全体员工祝您生日快乐,青春常驻,身体健康!感谢您对蒙娜丽莎的支持!电话2398865', 0, N'', CAST(0x0000A4F500E2CBEA AS DateTime), CAST(0x0000A4F500E2CBEA AS DateTime))
  18. GO
  19. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (10, 0, 1, 1, 315, N'0', N'相关客户', N'', N'XXX先生/女士,^o^在天愿做比翼鸟,在地愿结连理枝,不羡神仙逍遥游,只羡鸳鸯戏水在池中。今天是你们大喜的日子,蒙娜丽莎祝你们喜结连理,白头偕老!电话2398865', 0, N'', CAST(0x0000A4F500E30478 AS DateTime), CAST(0x0000A4F500E30478 AS DateTime))
  20. GO
  21. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (11, 0, 1, 1, 316, N'1', N'相关客户', N'', N'XXX先生/女士,明天就是您俩的结婚纪念日哦,您肯定不会忘记吧!^-^在此蒙娜丽莎全体员工祝您俩幸福永远,与之偕老,永远像新婚当天一样。电话2398865', 0, N'', CAST(0x0000A4F500E32AA6 AS DateTime), CAST(0x0000A4F500E32AA6 AS DateTime))
  22. GO
  23. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (12, 0, 1, 2, 100, N'1', N'相关客户', N'', N'XXX您好,今天很荣幸能为您服务!感谢您选择星光贝贝儿童摄影记录您宝贝成长的美好故事。我们全体员工一定会用心做到最好!再次感谢!同时请坚信我们星光贝贝是最棒的。电话2398865', 0, N'', CAST(0x0000A4F500E55C18 AS DateTime), CAST(0x0000A4F500E55C18 AS DateTime))
  24. GO
  25. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (13, 0, 1, 2, 101, N'1', N'相关客户', N'', N'XXX您好!您的产品已全部制作完毕,明天终于可以拿到宝贝的相册了,很期待吧!我们已经把照片都准备好了。记得带上票据准时来取哦,相信您回去之后所有的亲友都会用幸福的眼光看宝贝照片!电话2398865', 0, N'', CAST(0x0000A4F500E5CA01 AS DateTime), CAST(0x0000A4F500E5CA01 AS DateTime))
  26. GO
  27. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (14, 0, 1, 1, 114, N'0', N'相关客户', N'', N'XXX先生/女士,今天是您的生日,蒙娜丽莎全体员工祝您生日快乐,青春常驻,身体健康,家庭幸福!感谢您对蒙娜丽莎的支持!电话2398865', 0, N'', CAST(0x0000A4F500F42D3B AS DateTime), CAST(0x0000A4F500F42D3B AS DateTime))
  28. GO
  29. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (15, 0, 1, 2, 102, N'1', N'相关客户', N'', N'XXX您好,您预约拍摄时间为XXT期待的拍照日明天就要来了。您及宝贝要好好休息哦,记得给宝贝带好所需物品。相信我们会把宝贝最可爱的一面给您保留住,明天见!星光贝贝儿童摄影。电话2398865', 0, N'', CAST(0x0000A4F500F53ED4 AS DateTime), CAST(0x0000A4F500F53ED4 AS DateTime))
  30. GO
  31. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (17, 0, 1, 2, 104, N'1', N'相关客户', N'', N'XXX您好!宝贝拍出这么可爱的片子是值得恭喜的事,当然这还是的宝贝表现好的主要原因!宝贝的照片拍的自然又成功,后续所有的工作我们会全程关注,让宝贝的照片更出色,也希望一切您能满意。电话2398865', 0, N'', CAST(0x0000A4F500F5E29C AS DateTime), CAST(0x0000A4F500F5E29C AS DateTime))
  32. GO
  33. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (18, 0, 1, 2, 105, N'1', N'相关客户', N'', N'XXX您好,您确定的宝贝作品已进入制作部进行制作,感谢您对星光贝贝的支持!后续工作我们会全程把关,让您宝贝的照片更出色,也希望您能满意!电话2398865', 0, N'', CAST(0x0000A4F500F6294C AS DateTime), CAST(0x0000A4F500F6294C AS DateTime))
  34. GO
  35. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (19, 0, 1, 2, 106, N'1', N'相关客户', N'', N'XXX您好,您宝贝在我们影楼拍摄的所有作品已经取完,亲友们问起您宝贝的幸福照片时,记得跟我们推荐哦!谢谢您对星光贝贝的信任与支持!服务电话:2398865', 0, N'', CAST(0x0000A4F500F69E82 AS DateTime), CAST(0x0000A4F500F69E82 AS DateTime))
  36. GO
  37. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (21, 0, 1, 2, 217, N'0', N'相关客户', N'', N'XXX您好,星光贝贝全体员工祝您家宝贝生日快乐!我们为宝贝提供最专业,最贴心的拍照服务,让我们一同为宝贝留下一年一变的珍贵瞬间!服务电话2398865', 0, N'', CAST(0x0000A4F500F73110 AS DateTime), CAST(0x0000A4F500F73110 AS DateTime))
  38. GO
  39. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (22, 0, 1, 2, 103, N'1', N'相关客户', N'', N'XXX您好,感谢您对星光贝贝的支持,您宝贝的照片已拍摄完毕,选片时间我们另行通知。在您宝贝拍照期间,若有服务不周或待慢之处,恳请原谅!客服部敬上。电话2398865', 0, N'', CAST(0x0000A4F500F754DD AS DateTime), CAST(0x0000A4F500F754DD AS DateTime))
  40. GO
  41. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (23, 0, 1, 2, 218, N'7', N'相关客户', N'', N'XXX您好,星光贝贝温馨提示:宝宝出生一周了,您须注意宝宝的脐带护理,保持其清洁、干爽,以加快愈合的速度。服务电话2398865', 0, N'', CAST(0x0000A4F500F7CAE5 AS DateTime), CAST(0x0000A4F500F7CAE5 AS DateTime))
  42. GO
  43. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (24, 0, 1, 2, 218, N'14', N'相关客户', N'', N'XXX您好,星光贝贝温馨提示:宝宝出生二周了,天气比较干燥,记得给宝宝多喝温开水,母乳期间妈妈少吃巧克力,乳汁中的咖啡因会影响宝宝的睡眠和消化。服务电话2398865', 0, N'', CAST(0x0000A4F500F7F54E AS DateTime), CAST(0x0000A4F500F7F54E AS DateTime))
  44. GO
  45. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (25, 0, 1, 2, 218, N'21', N'相关客户', N'', N'XXX您好,星光贝贝温馨提示:宝宝出生三周了,妈妈可以下床适量的活动以加快身体的恢复,但一定要注意休息并补充营养!服务电话2398865', 0, N'', CAST(0x0000A4F500F8E089 AS DateTime), CAST(0x0000A4F500F8E089 AS DateTime))
  46. GO
  47. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (26, 0, 1, 2, 218, N'30', N'相关客户', N'', N'XXX您好,星光贝贝全体员工恭贺您宝贝满月了,祝您宝贝健康快乐的成长,全家幸福美满!爱心热线:2398865地址:演达大道丽园新村。 ', 0, N'', CAST(0x0000A4F500F95589 AS DateTime), CAST(0x0000A4F500F95589 AS DateTime))
  48. GO
  49. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (27, 0, 1, 2, 218, N'60', N'相关客户', N'', N'XXX您好,宝宝出生两个月,喂奶时切记勿给宝宝吸吮空奶瓶,大量的空气会引起腹胀等一系列不良症状。关爱宝贝的成长是星光贝贝最大的喜悦! 服务电话2398865', 0, N'', CAST(0x0000A4F500F9A38F AS DateTime), CAST(0x0000A4F500F9A38F AS DateTime))
  50. GO
  51. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (28, 0, 1, 2, 218, N'90', N'相关客户', N'', N'XXX您好,宝宝三个月了,可以添加鲜果汁和青菜汁等辅食营养,但需让宝宝有个适应的过程,不能急于求成。关爱宝贝的成长是星光贝贝最大的喜悦! 服务电话2398865', 0, N'', CAST(0x0000A4F500F9CF18 AS DateTime), CAST(0x0000A4F500F9CF18 AS DateTime))
  52. GO
  53. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (29, 0, 1, 2, 218, N'100', N'相关客户', N'', N'XXX您好,星光贝贝全体员工恭贺您宝贝百天了,祝您宝贝健康快乐成长,全家幸福美满,打电话来店,咱帮您安排宝宝百天照!爱心热线:2398865 地址:演达大道丽园新村 ', 0, N'', CAST(0x0000A4F500FA10A0 AS DateTime), CAST(0x0000A4F500FA10A0 AS DateTime))
  54. GO
  55. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (30, 0, 1, 2, 218, N'120', N'相关客户', N'', N'XXX您好,宝宝四个月了,给宝宝添加辅食过程中,如出现消化不良、腹泻、呕吐等情况,应暂停一段时间,再少量试喂或换另一种食物。关注宝贝成长尽在星光贝贝! 电话2398865', 0, N'', CAST(0x0000A4F500FA4508 AS DateTime), CAST(0x0000A4F500FA4508 AS DateTime))
  56. GO
  57. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (31, 0, 1, 2, 218, N'150', N'相关客户', N'', N'XXX您好,宝宝五个月,别在宝宝的食物中添加调味品,盐也要少放或不放,特别要避免蜂蜜,蜂蜜中的肉毒杆菌会让宝宝生病。关注宝贝成长尽在星光贝贝! 电话2398865', 0, N'', CAST(0x0000A4F500FA7688 AS DateTime), CAST(0x0000A4F500FA7688 AS DateTime))
  58. GO
  59. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (32, 0, 1, 2, 218, N'180', N'相关客户', N'', N'XXX您好,宝宝六个月,这个阶段能沉浮的浴室玩具、软积木、软球、能发声的填充娃娃、不倒翁等都将是宝宝很好的玩具。关注宝贝成长尽在星光贝贝!请打电话2398865,帮您安排宝宝半岁照。', 0, N'', CAST(0x0000A4F500FAA51D AS DateTime), CAST(0x0000A4F500FAA51D AS DateTime))
  60. GO
  61. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (33, 0, 1, 2, 218, N'210', N'相关客户', N'', N'XXX您好,宝宝七个月,调整宝宝正确的睡姿,趴睡会影响宝宝的上腭承受较大的压力,可能造成牙齿排列不整齐的问题。关注宝贝成长尽在星光贝贝! 电话2398865', 0, N'', CAST(0x0000A4F500FADF16 AS DateTime), CAST(0x0000A4F500FADF16 AS DateTime))
  62. GO
  63. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (34, 0, 1, 2, 218, N'240', N'相关客户', N'', N'XXX您好,宝宝八个月,记得让宝宝少看电视,而且要让宝宝离电视2米远的正面,时间不宜长,而播放儿歌可舒缓宝贝的情绪!关注宝贝成长尽在星光贝贝! 电话2398865', 0, N'', CAST(0x0000A4F500FB093D AS DateTime), CAST(0x0000A4F500FB093D AS DateTime))
  64. GO
  65. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (35, 0, 1, 2, 218, N'270', N'相关客户', N'', N'XXX 您好,九个月的宝宝会发脾气了,建议父母保持冷静,引开宝宝的注意力,处罚或屈服都是不适当的。关注宝贝成长尽在星光贝贝!请致电2398865,帮您宝宝安排9个月照相。 ', 0, N'', CAST(0x0000A4F500FB6976 AS DateTime), CAST(0x0000A4F500FB6976 AS DateTime))
  66. GO
  67. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (36, 0, 1, 2, 218, N'300', N'相关客户', N'', N'XXX您好,宝宝十个月,鼓励宝宝自己玩,有助于增强宝宝的独立能力,还能学到如何自娱,但一定要保证他的安全。关注宝贝成长尽在星光贝贝! 电话2398865', 0, N'', CAST(0x0000A4F500FB912A AS DateTime), CAST(0x0000A4F500FB912A AS DateTime))
  68. GO
  69. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (38, 0, 1, 2, 219, N'1', N'相关客户', N'', N'XXX您好,宝宝一岁,星光贝贝全体员工恭贺宝贝周岁了,祝宝贝生日快乐!关注宝贝成长尽在星光贝贝!爱心热线:2398865 地址:演达大道丽园新村 ', 0, N'', CAST(0x0000A4F500FC302D AS DateTime), CAST(0x0000A4F500FC302D AS DateTime))
  70. GO
  71. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (39, 0, 1, 1, 317, N'1', N'相关客户', N'', N'XXX您好,蒙娜丽莎温馨提示您,在XXSR是XXVN先生的生日,浪漫的日子用浪漫的方式表达,给他准备个神秘礼物吧吧。(>^ω^<)祝愿你们幸福长久。幸福热线2398865', 0, N'', CAST(0x0000A4F500FE8E9C AS DateTime), CAST(0x0000A4F500FE8E9C AS DateTime))
  72. GO
  73. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (40, 0, 1, 1, 318, N'1', N'相关客户', N'', N'XXX您好,蒙娜丽莎温馨提示您,在XXSR是XXVN女士的生日,浪漫的日子用浪漫的方式表达,给她准备个神秘礼物吧。(>^ω^<)祝愿你们幸福长久。幸福热线2398865', 0, N'', CAST(0x0000A4F500FEC034 AS DateTime), CAST(0x0000A4F500FEC034 AS DateTime))
  74. GO
  75. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (41, 0, 1, 3, 100, N'1', N'相关客户', N'', N'XXX您好,蒙娜丽莎婚纱摄影温馨提示您,您成功在本店预订套系。拍照前请与客服联系2398865我们将竭诚为您服务,祝您生活愉快!', 0, N'', CAST(0x0000A4F500FEF4F9 AS DateTime), CAST(0x0000A4F500FEF4F9 AS DateTime))
  76. GO
  77. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (42, 0, 1, 3, 101, N'1', N'相关客户', N'', N'XXX您好,您在本店制作的所有产品已全部完成,请尽快到本店进行取件,记得带上您的单据前来。蒙娜丽莎祝您家庭幸福。电话2398865', 0, N'', CAST(0x0000A4F500FF24CC AS DateTime), CAST(0x0000A4F500FF24CC AS DateTime))
  78. GO
  79. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (43, 0, 1, 3, 102, N'1', N'相关客户', N'', N'XXX您好,您在本店预约拍摄时间为XXT,请务必在此时间到店,以免耽误您的拍摄行程。温馨提示:睡前一小时勿喝水,以免眼袋臃肿;请保持充足的睡眠时间;贵重物品请妥善保管;请带上您的收据单到店。感谢您对蒙娜丽莎的支持。电话2398865', 0, N'', CAST(0x0000A4F500FF63A5 AS DateTime), CAST(0x0000A4F500FF63A5 AS DateTime))
  80. GO
  81. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (44, 0, 1, 3, 103, N'1', N'相关客户', N'', N'XXX您好,感谢您对蒙娜丽莎的支持,您的拍摄已全部完毕,选片时间另行通知。在您拍照期间,若有服务不周或待慢之处,恳请原谅!客服部敬上!电话2398865', 0, N'', CAST(0x0000A4F500FFA2FC AS DateTime), CAST(0x0000A4F500FFA2FC AS DateTime))
  82. GO
  83. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (45, 0, 1, 3, 104, N'1', N'相关客户', N'', N'XXX您好,您选的照片已进入数码部进行设计,我们会将您最靓丽的演出,最美丽的神韵,创作出您最满意的作品,祝您青春永驻!电话2398865', 0, N'', CAST(0x0000A4F500FFD04D AS DateTime), CAST(0x0000A4F500FFD04D AS DateTime))
  84. GO
  85. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (46, 0, 1, 3, 105, N'1', N'相关客户', N'', N'XXX您好,您确定的作品已进入制作部进行制作,感谢您对蒙娜丽莎的支持!后续工作我们会全程把关,让您的照片更出色,也希望您能满意!电话2398865', 0, N'', CAST(0x0000A4F500FFE8EC AS DateTime), CAST(0x0000A4F500FFE8EC AS DateTime))
  86. GO
  87. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (47, 0, 1, 3, 114, N'1', N'相关客户', N'', N'XXX您好,在您生日的来临之际,蒙娜丽莎全体员工祝您生日快乐,青春常驻,身体健康!感谢您对蒙娜丽莎的支持!电话2398865', 0, N'', CAST(0x0000A4F5010008F3 AS DateTime), CAST(0x0000A4F5010008F3 AS DateTime))
  88. GO
  89. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (48, 0, 1, 1, 106, N'1', N'相关客户', N'', N'XXX先生/女士您好,您在我们影楼拍摄的所有作品已经取完,亲友们问起您的幸福照片时,记得跟我们推荐哦!谢谢您对蒙娜丽莎的信任与支持!服务电话:2398865', 0, N'', CAST(0x0000A4F50100685D AS DateTime), CAST(0x0000A4F50100685D AS DateTime))
  90. GO
  91. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (49, 0, 1, 3, 106, N'1', N'相关客户', N'', N'XXX您好,您在我们影楼拍摄的所有作品已经取完,亲友们问起您的美丽照片时,记得跟我们推荐哦!谢谢您对蒙娜丽莎的信任与支持!服务电话:2398865', 0, N'', CAST(0x0000A4F50100855E AS DateTime), CAST(0x0000A4F50100855E AS DateTime))
  92. GO
  93. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (50, 0, 1, 0, 921, N'0', N'相关员工', N'', N'亲爱的XXX,公司的每一次进步,都离不开你的协作和努力,公司的每一次成长,都离不开你的辛勤和汗水,公司的每一次壮大,都离不开你的心血和付出。日月轮转永不断,情若真挚长相伴,不论你身在天涯海角,公司都送上对你最真挚的祝福。祝你生日快乐!', 0, N'', CAST(0x0000A4F50101D744 AS DateTime), CAST(0x0000A4F50101D744 AS DateTime))
  94. GO
  95. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (51, 0, 1, 0, 926, N'1', N'相关客户', N'', N'亲爱的XXX先生/女士,放心吧!我们一定用最好的服务和产品,为您创造出最美的作品!电话2398865', 0, N'', CAST(0x0000A4F501021BAE AS DateTime), CAST(0x0000A4F501021BAE AS DateTime))
  96. GO
  97. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (52, 0, 1, 0, 927, N'1', N'相关客户', N'', N'感谢您致电蒙娜丽莎婚纱摄影,我们将用最优蕙的的价格,最强的团队,为您打造一辈子的幸福回艺!电话2398865', 0, N'', CAST(0x0000A4F501023C93 AS DateTime), CAST(0x0000A4F501023C93 AS DateTime))
  98. GO
  99. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (53, 0, 1, 0, 928, N'1', N'相关员工', N'', N'亲爱的伙伴们,一丝不苟,积极向上,作好每一幅作品,服务好每一位客人,让每一对新人感激我们一辈子。就靠你了……', 0, N'', CAST(0x0000A4F50102525C AS DateTime), CAST(0x0000A4F50102525C AS DateTime))
  100. GO
  101. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (54, 0, 1, 0, 929, N'1', N'18607523124', N'', N'XXSR是XXX这位员工的生日,请做好祝贺准备', 0, N'', CAST(0x0000A4F50102A63E AS DateTime), CAST(0x0000A4F50102A63E AS DateTime))
  102. GO
  103. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (55, 0, 1, 0, 922, N'21:0', N'18607523124', N'', N'系统自动生成', 0, N'', CAST(0x0000A4F50102BD9F AS DateTime), CAST(0x0000A4F50102BD9F AS DateTime))
  104. GO
  105. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (56, 0, 1, 0, 913, N'1', N'相关客户', N'', N'XXX您好,您的XXN卡号,在XXT充值了XXCM元,现当前卡总金额为XXM元。感谢您对蒙娜丽莎的支持。电话2398865', 0, N'', CAST(0x0000A4F50103531E AS DateTime), CAST(0x0000A4F50103531E AS DateTime))
  106. GO
  107. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (57, 0, 1, 0, 912, N'1', N'相关客户', N'', N'XXX您好,您的XXN卡号,在XXT消费了XXQM元,现卡剩余金额为XXM元。感谢您对蒙娜丽莎的支持,电话2398865', 0, N'', CAST(0x0000A4F50103C185 AS DateTime), CAST(0x0000A4F50103C185 AS DateTime))
  108. GO
  109. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (58, 0, 1, 0, 910, N'1', N'相关客户', N'', N'XXX您好,感谢您成为本公司的荣誉贵宾,您的卡号为XXN,未来的日子里您可享受本公司所有的会员优蕙,同时希望您为我公司介绍更多的客户。电话2398865', 0, N'', CAST(0x0000A4F501040D66 AS DateTime), CAST(0x0000A4F501040D66 AS DateTime))
  110. GO
  111. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (59, 0, 1, 0, 909, N'1', N'相关客户', N'', N'XXX您好,您的朋友XXC在XXT成功在本店订单,给你积分XXF,达到一定积分可在本店兑换相应礼品哦。感谢您的介绍。2225955', 0, N'', CAST(0x0000A4F50104DBAC AS DateTime), CAST(0x0000A4F50104DBAC AS DateTime))
  112. GO
  113. INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (60, 0, 1, 2, 218, N'330', N'相关客户', N'', N'XXX您好,宝宝十一个月,带宝宝到户外呼吸新鲜空气,他的心情会变得愉快,也能够学着与人交往,促进孩子的身心发展。关注宝贝成长尽在星光贝贝! 电话2398865', 0, N'', CAST(0x0000A4F7009D05D8 AS DateTime), CAST(0x0000A4F7009D05D8 AS DateTime))
  114. GO
  115. SET IDENTITY_INSERT [dbo].[tb_SMSTemplates] OFF