監(jiān)理公司管理系統(tǒng) | 工程企業(yè)管理系統(tǒng) | OA系統(tǒng) | ERP系統(tǒng) | 造價(jià)咨詢(xún)管理系統(tǒng) | 工程設(shè)計(jì)管理系統(tǒng) | 甲方項(xiàng)目管理系統(tǒng) | 簽約案例 | 客戶(hù)案例 | 在線(xiàn)試用
X 關(guān)閉

更新線(xiàn)索收費(fèi)管理

申請(qǐng)免費(fèi)試用、咨詢(xún)電話(huà)：400-8352-114

    UPDATE [Menu]
SET uMenu_ParentId =
(SELECT uMenu_ID FROM Menu WHERE cMenu_Name = '收費(fèi)管理'),
iMenu_OrderNumber = 792
WHERE cMenu_Name = '線(xiàn)索收費(fèi)管理'
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
發(fā)布：2007-03-30 10:23    編輯：泛普軟件 · xiaona    [打印此頁(yè)]    [關(guān)閉]
相關(guān)文章：