復制代碼 代碼如下:

//收看視頻三個標準
//從頁面傳參數過來
int V1_BiaoZhou = Convert.ToInt32(TextBox1.Text);
int V1_FeiZhi= Convert.ToInt32(TextBox4.Text);

int V2_BiaoZhou = Convert.ToInt32(TextBox2.Text);
int V2_FeiZhi= Convert.ToInt32(TextBox5.Text);

int V3_BiaoZhou = Convert.ToInt32(TextBox3.Text);
int V3_FeiZhi= Convert.ToInt32(TextBox6.Text);

//作業批閱數（篇）
int Z1_BiaoZhun=Convert .ToInt32 (TextBox7 .Text );
int Z1_FeiZhi=Convert .ToInt32 (TextBox10 .Text );

int Z2_BiaoZhun=Convert .ToInt32 (TextBox8 .Text );
int Z2_FeiZhi=Convert .ToInt32 (TextBox11 .Text );

int Z3_BiaoZhun=Convert .ToInt32 (TextBox9 .Text );
int Z3_FeiZhi=Convert .ToInt32 (TextBox12 .Text );

//實例化對象（learning庫對應的是EDBoperation）
edb=new EDBoperation();
//使用存儲過程
string procName="insert_Update_PROJECT_STANDARD";
//插入數據
SqlParameter[] spp=new SqlParameter[]{
new SqlParameter("@PROJECT_ID",projectID),
new SqlParameter("@V1_BIAOZHOU",V1_BiaoZhou),
new SqlParameter ("@V1_FENGZHI",V1_FeiZhi),
new SqlParameter ("@V2_BIAOZHOU",V2_BiaoZhou),
new SqlParameter ("@V2_FENGZHI",V2_FeiZhi),
new SqlParameter ("@V3_BIAOZHOU",V3_BiaoZhou),
new SqlParameter ("@V3_FENGZHI",V3_FeiZhi),
new SqlParameter ("@Z1_BIAOZHUN",Z1_BiaoZhun),
new SqlParameter ("@Z1_FENZHI",Z1_FeiZhi),
new SqlParameter ("@Z2_BIAOZHUN",Z2_BiaoZhun),
new SqlParameter ("@Z2_FENZHI",Z2_FeiZhi),
new SqlParameter ("@Z3_BIAOZHUN",Z3_BiaoZhun),
new SqlParameter ("@Z3_FENZHI",Z3_FeiZhi)

};

復制代碼 代碼如下:

<tr>
<td>
<asp:Label runat="server" Text="收看視頻（分鐘）:" Font-Size="9pt"></asp:Label>
</td>
<tdcolspan="2">
<table>
<tr>
<td><asp:TextBox runat="server"></asp:TextBox></td>
<td><asp:TextBox runat="server"></asp:TextBox></td>
</tr>

<tr>
<td><asp:TextBox runat="server"></asp:TextBox></td>
<td><asp:TextBox runat="server"></asp:TextBox></td>
</tr>

<tr>
<td><asp:TextBox runat="server" OnTextChanged="TextBox3_TextChanged"></asp:TextBox></td>
<td><asp:TextBox runat="server"></asp:TextBox></td>
</tr>

</table>

</td>
</tr>
<tr>
<td>
<asp:Label runat="server" Text="作業批閱數（篇）:" Font-Size="9pt"></asp:Label>
</td>
<tdcolspan="2">
<table>
<tr>
<td><asp:TextBox runat="server"></asp:TextBox></td>
<td><asp:TextBox runat="server"></asp:TextBox></td>
</tr>

<tr>
<td><asp:TextBox runat="server"></asp:TextBox></td>
<td><asp:TextBox runat="server"></asp:TextBox></td>
</tr>

<tr>
<td><asp:TextBox runat="server"></asp:TextBox></td>
<td><asp:TextBox runat="server"></asp:TextBox></td>
</tr>

復制代碼 代碼如下:

//創建存儲過程

create PROC insert_Update_PROJECT_STANDARD
@PROJECT_ID INT,
@V1_BIAOZHOU INT,
@V1_FENGZHI INT,
@V2_BIAOZHOU INT,
@V2_FENGZHI INT,
@V3_BIAOZHOU INT,
@V3_FENGZHI INT,
@Z1_BIAOZHUN INT,
@Z1_FENZHI INT,
@Z2_BIAOZHUN INT,
@Z2_FENZHI INT,
@Z3_BIAOZHUN INT,
@Z3_FENZHI INT
AS

//像存儲過程中對應著插入數據

INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid,KHBZ,FZ) values(@PROJECT_ID,@V1_BIAOZHOU,@V1_FENGZHI)

INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid,KHBZ,FZ) values(@PROJECT_ID,@V2_BIAOZHOU,@V2_FENGZHI)
INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid,KHBZ,FZ) values(@PROJECT_ID,@V3_BIAOZHOU,@V3_FENGZHI)

INSERT INTO T_LEARNING_PROJECT_STANDARD (Sid ,KHBZ ,FZ )VALUES(@PROJECT_ID ,@Z1_BIAOZHUN ,@Z1_FENZHI )
INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid ,KHBZ ,FZ )VALUES(@PROJECT_ID ,@Z2_BIAOZHUN ,@Z2_FENZHI )
INSERT INTO T_LEARNING_PROJECT_STANDARD (Sid ,KHBZ ,FZ )VALUES(@PROJECT_ID ,@Z3_BIAOZHUN ,@Z3_FENZHI )