复制代码 代码如下:

//收看视频三个标准
//从页面传参数过来
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 style=\"width: 101px; text-align: center;\">
<asp:Label ID=\"Label2\" runat=\"server\" Text=\"收看视频（分钟）:\" Font-Size=\"9pt\" Width=\"132px\"></asp:Label>
</td>
<td style=\"text-align: left;\"colspan=\"2\">
<table>
<tr style=\"height:25px;\">
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox1\" runat=\"server\"></asp:TextBox></td>
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox4\" runat=\"server\"></asp:TextBox></td>
</tr>

<tr>
<td class=\"auto-style3\"><asp:TextBox id=\"TextBox2\" runat=\"server\"></asp:TextBox></td>
<td class=\"auto-style3\"><asp:TextBox id=\"TextBox5\" runat=\"server\"></asp:TextBox></td>
</tr>

<tr style=\"height:25px;\">
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox3\" runat=\"server\" OnTextChanged=\"TextBox3_TextChanged\"></asp:TextBox></td>
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox6\" runat=\"server\"></asp:TextBox></td>
</tr>

</table>

</td>
</tr>
<tr>
<td style=\"width: 101px; text-align: center;\">
<asp:Label ID=\"Labele\" runat=\"server\" Text=\"作业批阅数（篇）:\" Font-Size=\"9pt\" Width=\"132px\"></asp:Label>
</td>
<td style=\"text-align: left;\"colspan=\"2\">
<table>
<tr style=\"height:25px;\">
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox7\" runat=\"server\"></asp:TextBox></td>
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox10\" runat=\"server\"></asp:TextBox></td>
</tr>

<tr style=\"height:25px;\">
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox8\" runat=\"server\"></asp:TextBox></td>
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox11\" runat=\"server\"></asp:TextBox></td>
</tr>

<tr style=\"height:25px;\">
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox9\" runat=\"server\"></asp:TextBox></td>
<td style=\"width:180px;\"><asp:TextBox id=\"TextBox12\" 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 )