?? templatesave.aspx.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace OI.DocTemplate.Template
{
/// <summary>
/// TemplateSave 的摘要說明。
/// </summary>
public class TemplateSave : OI.PageBase
{
string mRecordID="";
// string mFileName="";
string mDescript="";
string mFileType="";
string mDocumentTypeID="";
string mUserName="";
private int departmentid;
private OI.DatabaseOper.DatabaseConnect oConn = new OI.DatabaseOper.DatabaseConnect();
private void Page_Load(object sender, System.EventArgs e) {
// 在此處放置用戶代碼以初始化頁面
if (Session["userid"]==null)
{
Response.Write ("<script>alert('超時,請重新登錄');top.location.href='../userpass.aspx';</script>");
return ;
}
try {
departmentid=Convert.ToUInt16(Request["departmentid"].ToString ());
}
catch{
departmentid=1;
}
SqlCommand nCommand;
string strUpdateCmd;
bool mResult=false;
mRecordID=Request.Form["RecordID"] ;
//mFileName=Request.Form["FileName"] ;
mDescript=Request.Form["Descript"] ;
mFileType=Request.Form["FileType"] ;
mDocumentTypeID =Request.Form["DocumentTypeID"];
mUserName=Request.Form["UserName"] ;
strUpdateCmd="Update Template Set DocumentTypeID=" +mDocumentTypeID+",UserName='"+mUserName+"',Descript = '"+ mDescript +"',departmentid="+departmentid+" Where RecordID='"+ mRecordID +"'";
nCommand = new SqlCommand(strUpdateCmd, oConn.GetConn());//更改
try {
nCommand.ExecuteNonQuery();
mResult=true;
}
catch(SqlException ex) {
Response.Write(ex.ToString());
mResult=false;
}
if (mResult) {
if( System.Convert.ToInt32(Session["manageid"])==1) {
try {
string str="update template set departmentid=0 where RecordID="+mRecordID;
oConn.ExecuteSQL (str);
}
catch {
}
Response.Redirect("TemplateList.aspx?manageid=1");
}
else {
Response.Redirect("TemplateList.aspx");
}
}
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -