📄 package_upt.aspx

📁 本文件为ASP开发的在线播放系统,挺不错的,创建数据需按照说明进行创建,祝你成功!
💻 ASPX
📖 第 1 页 / 共 2 页
字号:
上一页 12
private void MyDataGrid_Edit(Object sender, DataGridCommandEventArgs E) {
   try {
        MyDataGrid.EditItemIndex = (int)E.Item.ItemIndex;
        //BindGrid();
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
        SqlDataAdapter myCommand2 = new SqlDataAdapter(strSQLPackageCourse, myConnection);
	DataSet ds = new DataSet();
	myCommand2.Fill(ds, "package_course");
        MyDataGrid.DataSource=ds.Tables["package_course"].DefaultView;
        MyDataGrid.DataBind();
   }                               
   catch (System.Exception e) {    
        ErrorHandler(e.ToString());
   }                               
}

private void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs E) {
   try {
        MyDataGrid.EditItemIndex = -1;
        BindGrid();
   }                               
   catch (System.Exception e) {    
        ErrorHandler(e.ToString());
   }                               
}

private void MyDataGrid_Update(Object sender, DataGridCommandEventArgs E) {
   try {
	if (Page.IsValid) {
	SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]); 
	String updateCmd = "update ref_course set   course_order = @course_order where course_id = @course_id and ref_course_id=@ref_course_id";
	SqlCommand myCommand = new SqlCommand(updateCmd, myConnection);
	myCommand.Parameters.Add(new SqlParameter("@course_id", SqlDbType.VarChar, 50));
	myCommand.Parameters["@course_id"].Value =course_id.Text;
	myCommand.Parameters.Add(new SqlParameter("@ref_course_id", SqlDbType.VarChar, 50));
	myCommand.Parameters["@ref_course_id"].Value = MyDataGrid.DataKeys[(int)E.Item.ItemIndex];        
	myCommand.Parameters.Add(new SqlParameter("@course_order", SqlDbType.TinyInt,1));
	myCommand.Parameters["@course_order"].Value = ((TextBox)E.Item.FindControl("edit_course_order")).Text;
	
	myConnection.Open();
	
	try {
	    myCommand.ExecuteNonQuery();
	    MessageSQLUptDone();
	    MyDataGrid.EditItemIndex = -1;
	}
	catch (System.Data.SqlClient.SqlException e) {
	   SQLErrorHandler(e);
	}
	
	myConnection.Close();

	SqlDataAdapter myCommand2 = new SqlDataAdapter(strSQLPackageCourse, myConnection);
	DataSet ds = new DataSet();
	myCommand2.Fill(ds, "package_course");
	MyDataGrid.DataSource=ds.Tables["package_course"].DefaultView;
	MyDataGrid.DataBind();
        }
   }                               
   catch (System.Exception e) {    
        ErrorHandler(e.ToString());
   }                               
}

private void BindGrid() {
   try {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]); 
	//SqlDataAdapter myCommand = new SqlDataAdapter("select ref_course_id,course_name=(select course_name from course where ref_course_id=course.course_id ),course_order from ref_course where course_id='"+course_id.Text+"'", myConnection);
	SqlDataAdapter myCommand = new SqlDataAdapter(strSQLPackageCourse, myConnection);
        DataSet ds = new DataSet();
	myCommand.Fill(ds, "package_course");
        MyDataGrid.DataSource=ds.Tables["package_course"].DefaultView;
        MyDataGrid.DataBind();

	myCommand.SelectCommand= new SqlCommand("select course_id,name='['+course_id+']'+course_name from course where course_type='1' order by course_id", myConnection);
	myCommand.Fill(ds, "course");
        course_list.DataSource=ds.Tables["course"].DefaultView;
        course_list.DataBind();
   }                               
   catch (System.Exception e) {    
        ErrorHandler(e.ToString());
   }                               
}

</script>
</head>
<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
<!-- #include virtual="/include/header.inc" -->

<table width=100% cellspacing=0 cellpadding=0>
<tr>
   <td align="center" class="CONTENTTITLE" width="100%" bgcolor="D3C9C7">                        
              全科基本数据 
   </td>
</tr>
<tr>
   <td>	
      <span id="Message" EnableViewState="false" class="MESSAGE" runat="server"/>
   </td>	
</tr>
</table>
 <form runat="server" ACTION="package_upt.aspx" NAME="course_upt" METHOD="post">     
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0>
	<TR>
         <p>

 	  <div style="padding:15,15,15,15;font-size:10pt;font-family:Verdana">
         <TD VALIGN="top" ALIGN="left"><span class="REQUIREDFIELD">全科代码:</span>
	 <TD VALIGN="top" ALIGN="left">
		<asp:label id="course_id" runat="server"/></b>
	<TR style="background-color:#E7E7E7;">
          <TD VALIGN="center" ALIGN="left"><span class="REQUIREDFIELD">全科名称: </span><TD VALIGN="top" ALIGN="left"></b><asp:textbox type="text" id="course_name" Width="400px"  runat="server"/>
	 <asp:RequiredFieldValidator ControlToValidate="course_name" Display="Dynamic" ErrorMessage="*:不可空白" runat=server/>
	<TR >
          <TD VALIGN="center" ALIGN="left"><span class="FIELD">全科英文名称: </span><TD VALIGN="top" ALIGN="left"></b><asp:textbox type="text" id="course_english_name" Width="400px"  runat="server"/>
	<TR style="background-color:#E7E7E7;">
          <TD VALIGN="center" ALIGN="left"><span class="FIELD">全科简称: </span><TD VALIGN="top" ALIGN="left"></b><asp:textbox type="text" id="course_alias" Width="400px"  runat="server"/>
	<TR >
          <TD VALIGN="center" ALIGN="left"><span class="REQUIREDFIELD">总时数: </span><TD VALIGN="top" ALIGN="left"></b><asp:textbox type="text" id="total_hour" Width="100px"  runat="server"/>
	  <asp:RangeValidator id="rangeVal_total_hour" Type="Integer" ControlToValidate="total_hour" MinimumValue="0" MaximumValue="1000000000"   ErrorMessage="输入格式不符" runat="server"/>
	  <asp:RequiredFieldValidator ControlToValidate="total_hour" Display="Dynamic" ErrorMessage="*:不可空白" runat=server/>
	<TR style="background-color:#E7E7E7;">
          <TD VALIGN="center" ALIGN="left"><span class="REQUIREDFIELD">定价: </span><TD VALIGN="top" ALIGN="left"></b><asp:textbox type="text" id="amount" Width="100px"  runat="server"/>
  	  <asp:RangeValidator id="rangeVal" Type="Currency" ControlToValidate="amount" MinimumValue="0" MaximumValue="1000000000"   ErrorMessage="输入格式不符" runat="server"/>
	  <asp:RequiredFieldValidator ControlToValidate="amount" Display="Dynamic" ErrorMessage="*:不可空白" runat=server/>
	<TR >
          <TD VALIGN="center" ALIGN="left"><span class="REQUIREDFIELD">科目分类: </span><TD VALIGN="top" ALIGN="left"></b>
	  <asp:textbox type="text" id="course_catalog_id"  Visible="False" Width="100px"  runat="server"/>
 	  <asp:DropDownList id="course_catalog_list" runat="server" DataTextField="course_catalog_name" DataValueField="course_catalog_id"  />



	<TR>
	 <TD VALIGN="center" ALIGN="left"> <asp:Button OnClick="SubmitBtn_Click" Text="储存修改" Runat="server"/>
	 <TD VALIGN="center" ALIGN="left"> <asp:LinkButton OnClick="BackBtn_Click" Text="回全科基本数据维护" Runat="server"/>
        </div>  
</TABLE>
   

<hr>
<table style="font: 8pt verdana">
            <tr>
              <td colspan="5" bgcolor="#aaaadd" style="font:10pt verdana">新增全科科目:&nbsp;&nbsp;
		科目代码:<input type="text" id="course_id_filter"  runat="server">	    
		科目名称:<input type="text" id="course_name_filter"  runat="server">	    
		<input type="submit" OnServerClick="FilterApply_Click" value="套用" runat="server">
           </td>
           </tr>
            <tr>
              <td colspan="5" style="font:10pt verdana">将		
	   <asp:DropDownList id="course_list" runat="server" DataTextField="name" DataValueField="course_id" AutoPostBack="False"  />
	   </td>
           </tr>
	  <tr>	<TD VALIGN="top" ALIGN="left"><FONT FACE="Verdana,Helvetica,Arial" SIZE=1>
		加入下列全科科目中&nbsp; <input type="submit" OnServerClick="Add_Click" value="新增" runat="server"></FONT></TD>				              

	  </tr>	
	  
  </table>
<table style="font: 8pt verdana" width=100% >
            <tr>
              <td colspan="5" bgcolor="#aaaadd" style="font:10pt verdana">全科科目一览/删除:</td>
           </tr>
  </table>
    <ASP:DataGrid id="MyDataGrid" runat="server"
      BackColor="#F4FFF4" 
      BorderColor="black"
      ShowFooter="false" 
      CellPadding=3 
      CellSpacing="0"
      Font-Name="Verdana"
      Font-Size="8pt"
      HeaderStyle-BackColor="lightblue"
      OnEditCommand="MyDataGrid_Edit"	
      OnDeleteCommand="MyDataGrid_Delete"
      OnCancelCommand="MyDataGrid_Cancel"
      OnUpdateCommand="MyDataGrid_Update"
      DataKeyField="ref_course_id"
      AutoGenerateColumns="false"
    >

      <Columns>
        <asp:EditCommandColumn EditText="修改" CancelText="取消" UpdateText="储存"  ItemStyle-Wrap="false"  ButtonType=" PushButton" />
        <asp:ButtonColumn Text="删除" CommandName="Delete"  ButtonType="PushButton" />
     	<asp:BoundColumn HeaderText="科目代码" SortExpression="course_id" ReadOnly="True" DataField="ref_course_id" ItemStyle-Wrap="false" />
	<asp:BoundColumn HeaderText="科目名称" SortExpression="course_name" ReadOnly="True" DataField="course_name" ItemStyle-Wrap="false"/>
        <asp:TemplateColumn HeaderText="排课顺序" >
          <ItemTemplate>
            <asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "course_order") %>'/>
          </ItemTemplate>
          <EditItemTemplate>
            <nobr>
            <asp:TextBox runat="server" id="edit_course_order" Text='<%# DataBinder.Eval(Container.DataItem, "course_order") %>'/>
            <asp:RequiredFieldValidator id="course_order_ReqVal"
                ControlToValidate="edit_course_order"
                Display="Dynamic"
                Font-Name="Verdana" Font-Size="12"
                runat=server>
                    &nbsp;*
            </asp:RequiredFieldValidator>
          </EditItemTemplate>
        </asp:TemplateColumn>

      </Columns>

    </ASP:DataGrid>

</form>
<!-- #include virtual="/include/footer.inc" -->
</body>
</html>
上一页 12
💿 文件大小 936 K
👤 上传用户 philipsx
📂 所属分类书籍源码
🏷️ 相关标签

#ASP #播放系统 #数据
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -