更新线索收费管理
UPDATE [Menu]
SET uMenu_ParentId =
(SELECT uMenu_ID FROM Menu WHERE cMenu_Name = '收费管理'),
iMenu_OrderNumber = 792
WHERE cMenu_Name = '线索收费管理'
ALTER VIEW [dbo].[StudentView]
AS
SELECT c.uClu_ID AS uStu_ID, c.cClu_Num AS cStu_Num, c.cClu_CName AS cStu_CName, c.cClu_EName AS cStu_EName, c.iClu_Age AS cStu_Age,
cou.cCou_BJ AS cStu_Class, cou.cCou_JSH AS cStu_ClassNum, cou.cCou_JB AS cStu_ClassType, cou.cCou_XQ AS cStu_ClassTime, st.cSta_Name AS cStu_CE,
c.cClu_Phone AS sStu_Phone, c.cClu_QDEA AS EA, c.dClu_CreateTime AS dStu_CreateTime
FROM dbo.Clue AS c LEFT OUTER JOIN
dbo.Clue_Course AS cc ON c.uClu_ID = cc.uCluCou_CluId LEFT OUTER JOIN
dbo.Course AS cou ON cou.uCou_ID = cc.uCluCou_CouId LEFT OUTER JOIN
dbo.Staff AS st ON st.uSta_ID = cou.uCou_StaffId
SET uMenu_ParentId =
(SELECT uMenu_ID FROM Menu WHERE cMenu_Name = '收费管理'),
iMenu_OrderNumber = 792
WHERE cMenu_Name = '线索收费管理'
ALTER VIEW [dbo].[StudentView]
AS
SELECT c.uClu_ID AS uStu_ID, c.cClu_Num AS cStu_Num, c.cClu_CName AS cStu_CName, c.cClu_EName AS cStu_EName, c.iClu_Age AS cStu_Age,
cou.cCou_BJ AS cStu_Class, cou.cCou_JSH AS cStu_ClassNum, cou.cCou_JB AS cStu_ClassType, cou.cCou_XQ AS cStu_ClassTime, st.cSta_Name AS cStu_CE,
c.cClu_Phone AS sStu_Phone, c.cClu_QDEA AS EA, c.dClu_CreateTime AS dStu_CreateTime
FROM dbo.Clue AS c LEFT OUTER JOIN
dbo.Clue_Course AS cc ON c.uClu_ID = cc.uCluCou_CluId LEFT OUTER JOIN
dbo.Course AS cou ON cou.uCou_ID = cc.uCluCou_CouId LEFT OUTER JOIN
dbo.Staff AS st ON st.uSta_ID = cou.uCou_StaffId
相关栏目：
相关文章：
- 1ALTER VIEW [dbo].[FZJView]
- 2精益创业是软件公司开发产品的方法论
- 3行业趋势+开发管理+架构
- 4培训学校管理软件更新学习视频
- 5软件生命周期
- 6培训学校校长的营销真经
- 7新增招生线索添加历史修改记录
- 8欢迎使用浠水县教育局OA办公软件系统平台及教育局简介
- 9教培行业如何选择信息化管理软件?
- 10市场管理操作1
- 11培训学校管理系统的优点
- 12培训学校管理软件选班选课进行升级
- 13为什么培训学校管理系统越来越受重视?
- 14培训学校管理系统声明
- 15软件开发报价
- 16C#实现数据库备份和还原
- 17培训学校管理软件市场人员和课程顾问升级
- 18区教育局开展全区教育OA办公软件系统使用培训活动
- 192014年端午节放假通知
- 20谁来保护软件开发公司的权利
- 21更新教材入库
- 22自主创新——企业的制胜法宝
- 23交费信息查询
- 24添加视图TGRYYJView
- 25中小型培训机构信息化现状
- 26新增分配时间历史修改记录
- 27怎么看“济宁计算机软件开发专场招聘 招聘者求职者难＂对眼＂”
- 28培训学校管理软件优惠中单机单用户2880元特惠版
- 29市场活动
- 30更新前台人员登陆显示
下一篇：招生解决方案
相关系统
联系方式
成都公司：成都市成华区建设南路160号1层9号
重庆公司：重庆市江北区红旗河沟华创商务大厦18楼
