?? editcard.aspx.cs
字號:
?using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class BackDesk_ManageUser_EditCard : System.Web.UI.Page
{
DataCon myCon = new DataCon();
DataOperate sqlBind = new DataOperate();
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Name"] == null)
{
Response.Redirect("../../FrontDesk/Login/Login.aspx");
}
else
{
labUserName.Text = Session["Name"].ToString() + "!";
if (!IsPostBack)
{
SqlConnection sqlconn = myCon.getCon();
sqlconn.Open();
string sqlstr = "select a.*,b.ModuleID,b.ModuleName from tb_Card as a "
+ "join tb_Module as b on a.ModuleID = b.ModuleID where a.CardID = '"
+ Request["CardID"].ToString() + "'";//接受CardInfo.aspx頁傳值
SqlDataAdapter myAdapter = new SqlDataAdapter(sqlstr, sqlconn);
DataSet myDSCard = new DataSet();
DataSet myDSModule = new DataSet();
myAdapter.Fill(myDSCard, "tb_Card");
myAdapter.Fill(myDSModule, "tb_Module");
DataRowView rowViewCard = myDSCard.Tables["tb_Card"].DefaultView[0];
DataRowView rowViewModule = myDSModule.Tables["tb_Module"].DefaultView[0];
txtCardContent.Text = Convert.ToString(rowViewCard["CardContent"]);
labCardTitle.Text = "帖子標題:"+Convert.ToString(rowViewCard["CardName"]);
labCardDate.Text = "發(fā)帖日期:"+Convert.ToString(rowViewCard["CardDate"]);
hpLinkCardMod.Text = "所屬模塊:"+Convert.ToString(rowViewModule["ModuleName"]);
sqlconn.Close();
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string sqlstr = "update tb_Card set CardContent='" + txtCardContent.Text
+ "' where CardID='" + Request["CardID"].ToString() + "'";
sqlBind.DataCom(sqlstr);
Response.Redirect("CardInfo.aspx");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
Response.Redirect("CardInfo.aspx");
}
protected void btnPride_Click(object sender, EventArgs e)
{
string sqlstr = "update tb_Card set CardIsPride='是' where CardID='" + Request["CardID"].ToString() + "'";
sqlBind.DataCom(sqlstr);
Response.Write("<script lanuage=javascript>alert('指定成功!');location='javascript:history.go(-1)'</script>");
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -