'=================================================================
'ʱ䣺2009-04-19:
'汾v 4.4.0.421
1ͶƱʱѾͶƱˣѽͶƱĹܹرգֹû޷鿴ǷͶƱ
2ͶƱķصַǽʱҳ룬½ҳ룻
3޸ݳʼʱ򣬽ʦѧȻϢɾ⣬ֻɾصݣ
4޸עڹʹȻֹͣĴ
5ϵͳ̨ʱ˳󣬺̨ͲಿκʾֻʾʾʾϢ
'=================================================================
'ʱ䣺2009-02-16:
'汾v 4.3.0.216

1޸ѧű8λ⣻
2ԳɼʾɼС60ʹúɫʾóɼ
3ɼȵĸ߼ѯһԺϵ༶γ̵ĳɼĲ񣬼
4Żϵͳ̨˵ĹܰϵͳҳϢ޸ġġǡ
5γ̽з࣬۽ѧγ,ʵѵѧγ,Ŀѧγ̣γ̷ƿԶ壬
ͬķ۵ʱʹòָͬꣻ
6۵ݽṹеֶֶ֧κѡʾ 
ѡʹõѡбı3ݣ
7۵ָ飬ϸָͬķ飻
8޸ָ겻ɾĴ
9ӽʦ۽ѯʱܺݵܣ
10޸Ľʦ۱ѧͽʦıóΪ1000ģʽ
11޸ĿγӵʱѡʦʱǰĹܣ

 
ָûн

ݽṹ3
SkyEvaluationGroup
SkyEvaluation
SkyEvaluationDetail
SkyCourseType

SkyTeacherCorse2ֶDetailNameGroupDetailIDGroup
SkyCourseCourseTypeID

'=================================================================
alter table SkyCourse
add CourseTypeID varchar(50)

update SkyCourse Set courseTypeID= '1001'

alter table SkyTeacherCorse
add DetailNameGroup  memo,
DetailIDGroup  memo

'=================================================================
'ʱ䣺2009-01-07:
'汾v 4.2.0.103
1޸ѧɼܵʱɼݴ⣬ָ⣬Ҫ³ɼԶɾݣ
2޸ɼ㹤ڼɼʱСβ࣬Ŀǰȫ2λС
3޸ͬһ༶ɼڻܵʱͬγ̴⣻
4޸Ŀγ̲޸ĵĴ
5޸ŵGodaddyռ·Ĵ
6ɾûʹõļٿռռôС
7߱༭HTMLʽϢվڶţ
8ӱϲܣ԰ͬĵԪݺϲʾЧֱۣ

'=================================================================
'ʱ䣺2009-01-03:
'汾v 4.2
1޸ʦѧ޸ԼϢĴ
2޸ͬһſһڲͬϵͳ޷õ⣬ϵͳʾγ̵ıעϢ
3߿ԳѡĿʼʱͽʱ֧-- ʱ-- ʽʱƸȷ
4ְ֧γ̹ӰťĹܣ
5޸ͬʱͬʱʾע汾⣻
6ʼȫ֧MsSQLServer2000ݿ⣬ʽûʹñSQL汾ֹûɲܵ½Ĵ
7޸û滹лسܵ½Ĵ



'=================================================================
'ʱ䣺2008-11-23:
'汾2008 v 4.1
1SkyTermID⣬IDʹԶţû룬ֹݴ
2ɾԱ(ϵͳԱ)ӦȨ޲޸ıĴ
3޸˵УNp,Npadminֶθĳı԰ּĴ
4ӿγ̱еĿγʱƹܣԿ԰ȫѧڿ裬Ҳ԰յ˫ܣҲԹ̶ʱ俪Σ
ҪڱSkyCourseSkyCType,SkyCWeek,SkyCSDate,SkyCEDateֶΣ
5ӷϢʱӸĹܣ
6γøֵ֧˫/ָʱ÷

//ݿ======================================================
alter table SkyNews
add SkyNote varchar(200)

alter table SkyCourse
add SkyCType int,
SkyCWeek int,
SkyCSDate datetime,
SkyCEDate datetime

update SkyCourse 
Set SkyCType=0,SkyCWeek=0,
SkyCSDate='2008-1-1',SkyCEDate='2008-1-1'
//ݿ======================================================

'=================================================================
'ʱ䣺2008-11-12
'汾2008 v 4.0
1ֺ̨дǰ̨õʱвдҪԺ֪
2admin/xml/System.Xml ϵͳļϵͳһЩϢݿļڶˣ
3Ӳ鿴Cookies,Session,ApplicationϢĹܣں̨ЩϢֹи²ʱĴ
4Ծ鿴Ͳѯܣ
5label for ܣѡѡжϣԵ־Ϳѡˡ
6ԾӺ޸ĹܣӵʱԾ0ʱ⣬ܹѡҪˣ
7ܹʾԾϢʹJSļʱ䣬ʱԶύԾ
8Ծбʷع˹ܣԲ鿴ԾĿԳɼϵͳ۹ܣԲ鿴ÿȷ⡣
9Լ¼ķͰհ༶ͳɼĳɼݿ
10ûܣûܣսʦѧԱȫܣ
11¼һ޸˵ݣҵˣ
12º̨Ϊǳɫǰ̨ͺ̨ͳһ
13߿ ѧֱʾԾͳɼб(ûд𰸵ʹ&nbsp;ռλֹݳִ)
14ݿ棬ݿSky.Education.Data.dllļڣ
	ݿ֧MsSQLAccess汾ֻҪWeb.configļͿ޸ģĶļͿɣ
15޸middel.htmlļmiddel.aspxļܹرպʹർĴ
16EXCELҪװEXCELԴExcelеѧʦɼݣ
17ӱSkyCETNameӵEXCELݲӢĻܣ
18ӱӡܣṩݵ׼֤ӡܣ
'=================================================================
'ʱ䣺2008-10-28
'汾2008 v 3.4
1ҳĽģӺ̨ȫʾܣŻҳ͹ؼ֣ҳʾ£
2¹滮ļĿ¼ݣ
3SkyMenuݱNpΪַ,ֶImgOpen,ImgClose˵ͼ;
4º̨˵ݣС־ʹʾѺã
5ʦѧ޸ԼϢʱʹSessionжϲתָ޸ҳ;
6Ŀ¼ṹʹų̃́adminĿ¼
   config(ϵͳ),course(γ̱),email(վʼ),evluation(ʦ),
   exam(߿-),news(վ),score(ѧɼ)
   Ϣsystem,publicĿ¼ݿļĵĿ¼³uploadĿ¼Ϣ;
7ϵͳɵdllļΪSky.Education.Upload.dllSky.Education.Education.dll
   ʹϵͳʾ淶
8°༶ѧɼտγ̻ܵƽСλ⣬ϵͳ2λС
9ڱĿ¼ṹ½ϴ󣬽ʽûڸϵǺڽк̨
'=================================================================
'ʱ䣺2008-9-16
'汾2008 v 3.3
1޸ɹ¼̨ʱʾϢﲻͨ˳Ĵ
2ӱվӹܣ
3ɼѯɾѳɼӡܸΪɼѯܣ
4ӹԱ࣬ڱSkyMenuмNpAdminֶ(1ϢԱ 2ϵͳԱ 3Ա)ӱSkyAdminUserԱȨ޷޸admin_Login/adminLeftܣMd5빦ܣ
5Ӳ־ܣ¼ÿ־ӱSkyOprLogɴ˹ܣ
6˵ɫöǺɫ
7ļϴܣѧͼƬͨϴܽϴ֧ļнɾȹܣ
'=================================================================
'ʱ䣺2008-8-24
'汾2008 v 3.2
'Ϣ
1޸ĲעʾΪʾʹJSԻ򵯳ʾǳлQQ715287 ṩĽ飬ȫûĸܣ
2Ĭѧڵı༭ʽı䣬ֹĬѧڳֵĴ
3޸ĬѧڸºطApplicationʱµĴ
4 ʦ->ɼӡֱӼĳѧڵĳɼڵ鿴Ϊ˷ӡEXCELܣڱ༭ӡ棻
5 ʦ۹ܵѧͽʦռֱܷãͱ100֣Skyadminбã
6½ʦɼӡʾֶΪγ̱ γ ʦ ѧ ΰ༶  ѧ ʦ ܷ ѯѯ
7ý棬Ϣкķ࣬۷кǷ100жϣ
8ӽʦ۳ɼʾ״ͼʾֱ۸飻
9ӳɼʾɼĿƳɼɼʾ״ͼʾɫϵͳԶã
10ӽҹܣԱ༭ʦƣϢΪγѡ༶ṩ㣬Ϊ̨ԶſΣſԿ춨
11̨˵ϵͳڽϸڷ
12ϵͳ̨ĬʾΪվϵͳϢ
'=================================================================
'ʱ䣺2008-8-18
'汾2008 v 3.1
'Ϣ
1޸ַ֤ϢݵĴ⣻
'=================================================================
'ʱ䣺2008-8-5
'汾2008 v 2.2
'Ϣ
1ڲֹϼ֤ʾܣ
2˺̨ҳ޸ĹܡԸĺ̨ͼƬʾ˵Ϣ
3޸ǰ̨ʹ֣ʹͼƬӣٶȣ
'=================================================================
'ʱ䣺2008-8-1
'汾2008 v 2.1
'Ϣ
1ݿʼܣûʹõʱһ¾Ϳݿ⣬ȻԼ-[ά]
2Ӱ汾עṦܣϵͳļûȨ˱ϵͳǿάģûҪṩIPַ롣ṩȨûһȨֻһϣ
3Ų̨ҳĲָʽͻʽ汾Ҫԣ
'=================================================================
'ʱ䣺2008-7-24
'汾2008 v 2.0
'Ϣ
1޸ϵͳѧڿAPPLICATIONûмʱµĴ
2޸ҳûȷʹʽļɲҳ治ۣ
3޸̨ļŰʽ
4޸๦ܲ˵ָĬϵչģʽûʹø㣻
5CHMʽϵͳļûʹϵͳַhttp://www.0451sky.com/soft/
6˲ѵϵͳϢ
7޸˵½ҳİȨϢϵͳѺã
8ʹЧӳã
'=================================================================
'ʱ䣺2007-10-1
'汾1.1
汾ɣΪ0451skyʦѧϵͳ(Access+.Net1.1)԰
ϵͳṩȫܸûʹ
˰汾ǻ2005꿪ASP汾ĽʦϵͳԻӣ
ûʹõë.ϵͳǻAsp.Net½ʦѧϵͳ
кܴ
װԵûעⰲװ.Net 1.1 + IIS + Access
ûϵҽ
'=================================================================

1ã޸ģѧϢ磺2008ѧڣһĬѧΪǰѧڣ
2ã޸ģԺϵϢСѧѧ͸вԺϵֱĬΪ༶һԺϵġ
3ã޸ģӽʦϢҲӽʦϢӵĽʦǽʦţԽʦ¼̨Լ޸Ϣ
4ã޸ģӰ༶Ϣǰ༶ĳԺϵа༶ſѧͿγ̡
5ã޸ģѧϢҲѧϢӵѧѧţѧ¼̨Լ޸Ϣѧӵʱѡصİ༶
6ã޸ģӿγϢγ̵Ŀνʦοʱΰ༶Ϣ˹Ͽγ̱ɽʦͰ༶γ̱
7¼־Բ鿴ʦѧԱĵ¼
8άԱݿ⣬ҲֱӲSQL(ʹ)ݿԸױݣϵͳȫ
9ѧǰ̨ѯԼѧڵĿγ̵ĳɼϢ
10Զһ༶ѧɼϢ
11ṩɼĿ빦ܣɼṩɼļã
  磺ƽʱɼ*10%+ҵɼ*10%+гɼ*20%+ĩɼ*60%=ܷ) 
12ʦͨɼŲγ̵ѧɼĸߵ
13ṩɼܣԲ鿴ĳγ̳ɼķ
磺30 ʱ 2008-7-28 4:04:25 ܷ 2037  
ƽ 67.9  ߷ 85  ͷ 35  
 29   1  
14ûԿûֲ᣻
15ʦԲ鿴ѧڿĿγ̣ͨɼܽѧɼ¼빦ܣ
16ʦͨɼܣγ̵㣬ȱϢ
17ʦͨɼܹܣһ༶ȫγ̽ķȫγ̵ܷ֣εϢ
  Ҫͳļ
18ͨEXCELܵݵĻͨEXCELӡɼݣݱ㡣
'=================================================================
γ̱ 
1Բ鿴ĳʦĳѧڵĿγ̰༶ʱ䰲ŵĿγ̱
2Բ鿴ĳ༶ĳѧڵĿγ̰༶ʱ䰲ŵĿγ̱
3ͨرӡγ̱Ҳͨ˫ܡ 
'=================================================================
ʦ۹
1Աýʦۣѧ۵ݺصķ
2Աۺķʾȼ
3ʦѧԶԽʦĿγۣ̽ǲʽģʦÿγֻһΣѧֻܶԼѧĿγۣҲֻһΣɼ޸ġ
4ʦԲ鿴Լ۽ԿѧͽʦԼγ̵ϢҲԲ鿴ƽ,ʵʵÿ۷ǿ۵ԱϢΪǲͶƱ
'=================================================================



BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_SkyCourseType
	(
	ID int NOT NULL IDENTITY (1, 1),
	CourseTypeID nvarchar(50) NULL,
	CourseTypeName nvarchar(50) NULL,
	CourseTypeInfo ntext NULL,
	ShowID nvarchar(50) NULL,
	CreateDate smalldatetime NULL,
	IP nvarchar(50) NULL
	)  ON [PRIMARY]
	 TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_SkyCourseType ON
GO
IF EXISTS(SELECT * FROM dbo.SkyCourseType)
	 EXEC('INSERT INTO dbo.Tmp_SkyCourseType (ID, CourseTypeID, CourseTypeName, CourseTypeInfo, ShowID, CreateDate, IP)
		SELECT ID, CourseTypeID, CourseTypeName, CourseTypeInfo, ShowID, CreateDate, IP FROM dbo.SkyCourseType TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_SkyCourseType OFF
GO
DROP TABLE dbo.SkyCourseType
GO
EXECUTE sp_rename N'dbo.Tmp_SkyCourseType', N'SkyCourseType', 'OBJECT'
GO
ALTER TABLE dbo.SkyCourseType ADD CONSTRAINT
	PK_SkyCourseType PRIMARY KEY CLUSTERED 
	(
	ID
	) ON [PRIMARY]

GO
COMMIT


/*    200934 20:44:32    û      (local)    ݿ⣺ SkyEducation    Ӧó MS SQLEM - Data Tools */  BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_SkyEvaluationGroup
	(
	ID int NOT NULL IDENTITY (1, 1),
	EvaluationGroupID nvarchar(50) NULL,
	EvaluationGroupName nvarchar(50) NULL,
	ShowID int NULL,
	EInfo ntext NULL,
	CreateDate smalldatetime NULL,
	IP nvarchar(50) NULL
	)  ON [PRIMARY]
	 TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_SkyEvaluationGroup ON
GO
IF EXISTS(SELECT * FROM dbo.SkyEvaluationGroup)
	 EXEC('INSERT INTO dbo.Tmp_SkyEvaluationGroup (ID, EvaluationGroupID, EvaluationGroupName, ShowID, EInfo, CreateDate, IP)
		SELECT ID, EvaluationGroupID, EvaluationGroupName, ShowID, EInfo, CreateDate, IP FROM dbo.SkyEvaluationGroup TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_SkyEvaluationGroup OFF
GO
DROP TABLE dbo.SkyEvaluationGroup
GO
EXECUTE sp_rename N'dbo.Tmp_SkyEvaluationGroup', N'SkyEvaluationGroup', 'OBJECT'
GO
COMMIT 
  





ƼУϵͳҪܺнʦϵͳѧɼϵͳ༶
̱ϵͳ䡢߿ϵͳȹܡϵͳB/S ģʽʵ,Ա,ʦ,ѧͨʱϵͳܹѺõɽУۺϽϵͳ΢.Net ƽ̨ܹͬWindows ϵͳOffice ϵͳ޷ϣҲзӦ÷ʵҳͻ˫ṹȫı֤ڲȽĺͿű׼缼ϵͳĿֲԺͿչԡϵͳгΪٽѧУԴ͵Ŀѧ淶ϢԱЧѧƵ˳ʵṩ֧֡

ϵͳҪɫܣ

1ȵļףϵͳĿǰΪȽȶ.Net ܹϵ֧AccessMysqlSQLServer ȶݿⰲװ
2ά򵥣ԻͨIE ϵͳʵֿͻά
3ϵͳùǿֶָ֧ʽĹ䣬Ҫðãѧ
ãԺϵãʦãҹ༶ãѧãγõȹܿ
ȫû塣
4ѧɼϵͳǷʹʦѧɼͳư༶ѧɼֶ֧
ʽѧɼ㣬ṩļ㹤ߡѧͨIE ʲ鿴Լĳɼ
5ʦѧϵͳģҵЧϵͳԣԱԽָ꣬ѧ
ͽʦԶԽʦĿγۣ̽ԱԻȫʦĳɼ
6߿ϵͳԱ(գѡ񣬶ѡжϣʴ)ȻгԾ
ѧָʱڽпԡڿʱܼʱ֮ԶύԾֱʾԳɼ
7γ̱Զɹܣûϵͳ̨鿴ָѧںָʦͰ༶Ŀγ̱
8ݵ뵼ܣϵͳֺ֧Excel ݽܣǷ밲װExcelȨޡ
9ڲʼܣ֧û֮佻ʹá
10ǿϵͳ԰ģķʽҽӵϵͳ֤ѯϵͳ\ѧƻϵͳϱϵͳֱӰװϵͳڲ

ܺܶ࣬ϸ˾

Աû
û admin Ա  admin
û minfo ϢԱ  minfo
û msystem ϵͳԱ  msystem
ݹԱݣԻѧͽʦϢв 





