using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;

public?partial?class?AddAndChangeInfo?:?System.Web.UI.Page
{
????private?AdminDAO?db?=?new?AdminDAO（）;
????private?Boolean?ischange?=?false;
????private?string?admin_name;

????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????admin_name?=?Session[“Log_Name“].ToString（）;
????????

????????string[]?param?=?Request.Url.PathAndQuery.Split（‘=‘）;//分離URL的函數(shù)的參數(shù)，可以判斷是否為修改
????????if?（param.Length?>?1）//修改
????????{
????????????string?title?=?Request.QueryString[“title“];//獲取URL中的title屬性的值
????????????string?id?=?Request.QueryString[“id“];
????????????string?auther?=?Request.QueryString[“author“];
????????????if?（!IsPostBack）//是否為提交動(dòng)作，這里的ISPOSTBACK為FALSE因?yàn)槭切薷膭?dòng)作，用戶并沒(méi)單擊頁(yè)面中的提交按鈕
????????????{
????????????????title.Text?=?title;
????????????????Auther.Value?=?auther;
????????????????TextBox1.Text?=?executeP（id?“article“）;//獲取對(duì)應(yīng)文章的內(nèi)容
????????????????SelectColunm.Text?=?executeP（id?“type“）;//設(shè)置下拉列表為對(duì)應(yīng)的表名，方便修改時(shí)獲取數(shù)據(jù)
????????????}
????????????ischange?=?true;//設(shè)置是否修改的標(biāo)示為真，在最后判斷是INSERT還是UPDATA的時(shí)候有用
????????}
????????else
????????????Auther.Value?=?admin_name;
????}
????private?string?executeP（string?id?string?clounm）//執(zhí)行P_SelectClounm存儲(chǔ)過(guò)程，傳入表名，連接字符串，ID，列名，返回該列的值，用于賦值
????{
????????string?command?=?“execute?P_SelectClounm?‘“?+?clounm?+?“‘?‘“?+?Server.UrlDecode（id）?+?“‘“;
????????return?db.ReturnCM（command）;
????}
????protected?void?Submit_ServerClick（object?sender?EventArgs?e）
????{

????????if?（ischange?==?false）//進(jìn)行添加操作
????????{
????????????if?（TextBox1.Text?==?““?||?title.Text?==?““）//判斷內(nèi)容和標(biāo)題是否為空，為空則不插入，并提示錯(cuò)誤
????????????{
????????????????Response.Write（“ript?language=‘javascript‘>alert（‘編輯內(nèi)容不能為空‘）;location.href（‘AddInfo.aspx‘）;ript>“）;
????????????????return;
????????????}
????????????//?Upload（mystr）;
????????????string?command?=?“execute?P_AddArticle?‘“?+?title.Text.ToString（）?+?“‘?‘“?+?Auther.Value.ToString（）?+?“‘??‘“?+?TextBox1.Text.ToString（）?+?“‘?‘“?+?DateTime.Now?+?“‘‘“?+?SelectColunm.SelectedValue?+?“‘“;
????????????db.ReturnCM（command）;
????????????//Response.Write（“ript?language=‘javascript‘>alert（‘文章添加成功！‘）;location.href=‘~/AddAndChangeInfo.aspx‘;ript>“）;

????????????TextBox1.Text?=?““;
????????????title.Text?=?““;

????????}



????????else?//進(jìn)行更新操作
????????{
????????????if?（TextBox1.Text?==?““?||?title.Text?==?““）
????????????{
????????????????Response.Write（“ript?language=‘javascript‘>alert（‘編輯內(nèi)容不能為空‘）;ript>“）;
????????????????return;
????????????}

????????????string?title?=?Request.QueryString[“title“];//獲取URL中的title屬性的值????
????????????string?auther?=?Request.QueryString[“author“];
????????????string?id?=?Request.QueryString[“id“];//獲取傳過(guò)來(lái)的文章ID

????????????//??Upload2（mystr）;

????????????string?command?=?“execute?P_UpdataArticle?“?+?id?+
????????????????“?‘“?+?title.Text.ToString（）

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????2830??2011-06-01?03:55??OA\AddAndChangeInfo.aspx

?????文件???????2774??2011-06-01?03:42??OA\AddAndChangeInfo.aspx.2.exclude

?????文件???????3766??2011-06-01?03:55??OA\AddAndChangeInfo.aspx.cs

?????文件???????3644??2012-04-28?23:18??OA\AddAndChangeInfo.aspx.cs.2.exclude

?????文件???????3647??2012-06-01?01:52??OA\a_AddAndChangeInfo.aspx.cs.exclude

?????文件???????2636??2012-05-21?02:24??OA\a_AddAndChangeInfo.aspx.exclude

?????文件???????6907??2012-05-22?07:38??OA\a_AddUser.aspx

?????文件????????999??2012-05-22?07:27??OA\a_AddUser.aspx.cs

?????文件???????3556??2012-05-22?07:57??OA\a_ApprovalList.aspx

?????文件???????1887??2012-05-22?08:22??OA\a_ApprovalList.aspx.cs

?????文件???????2747??2012-05-21?01:57??OA\a_ManageInfo.aspx

?????文件???????1697??2012-04-29?13:37??OA\a_ManageInfo.aspx.cs

?????文件???????5059??2011-06-01?04:22??OA\a_MeetingSet.aspx

?????文件???????2281??2011-06-01?04:43??OA\a_MeetingSet.aspx.cs

?????文件???????4039??2012-05-21?23:35??OA\a_SetApproval.aspx

?????文件???????2612??2012-05-21?14:59??OA\a_SetApproval.aspx.cs

?????文件???????1453??2012-06-01?06:57??OA\a_UploadFile.aspx

?????文件???????2051??2012-06-01?06:55??OA\a_UploadFile.aspx.cs

?????文件??????77055??2012-05-19?20:59??OA\c_OfficePhone.aspx

?????文件?????????84??2012-05-10?19:54??OA\c_OfficePhone.aspx.vb

?????文件????????280??2012-05-21?02:19??OA\Default.aspx.cs

?????文件???????3133??2012-05-15?00:01??OA\Email_Get.aspx.cs.exclude

?????文件???????3717??2012-05-15?14:39??OA\Email_Get.aspx.exclude

?????文件??????21600??2012-05-25?17:16??OA\left1.html

?????文件??????20608??2011-06-01?02:51??OA\leftM.html

?????文件????????117??2012-05-21?02:11??OA\licenses.licx

?????文件???????3099??2012-06-01?02:36??OA\ManageInfo.aspx

?????文件???????1693??2012-06-01?02:36??OA\ManageInfo.aspx.cs

?????文件??????14863??2012-05-22?07:28??OA\MasterPage_Manager.master

?????文件????????357??2012-05-19?04:46??OA\MasterPage_Manager.master.cs

............此處省略1874個(gè)文件信息