📄 package_upt.aspx
字号:
<!-- #include virtual="/include/PageDirective.inc" -->
<!-- #include virtual="/include/imports.inc" -->
<!-- #include virtual="/include/common_function.inc" -->
<html>
<head>
<link REL="StyleSheet" HREF="/css/standard.css" >
<script language="C#" runat="server">
/*************************************************
* 模块: package_upt.aspx
* 作者: miles
* 修改: 2/1/2001
* 目的: course table update
* 参数: none
* 数据: sel: course
* upt: course
* 批注:
***************************************************/
string strSQLPackageCourse="";
private void Page_Load(Object sender, EventArgs E) {
try {
if (IsPostBack){
strSQLPackageCourse="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
+ "' order by course_order";
return;
}
SqlConnection myConnection = new SqlConnection
(ConfigurationSettings.AppSettings["edu"]);
SqlCommand myCommand = new SqlCommand
("select * from course where course_id='"
+ Request["course_id"]+"'", myConnection);
SqlDataReader MyReader;
myConnection.Open();
MyReader=myCommand.ExecuteReader();
while (MyReader.Read()){
course_id.Text=MyReader["course_id"].ToString();
course_name.Text=MyReader["course_name"].ToString();
course_english_name.Text=MyReader["course_english_name"].ToString();
course_alias.Text=MyReader["course_alias"].ToString();
total_hour.Text=MyReader["total_hour"].ToString();
amount.Text=MyReader["amount"].ToString();
course_catalog_id.Text=MyReader["course_catalog_id"].ToString();
}
myConnection.Close();
myConnection.Open();
SqlDataAdapter myCommandcourse_catalog = new SqlDataAdapter
("select course_catalog_id,course_catalog_name from course_catalog",
myConnection);
DataSet ds1 = new DataSet();
myCommandcourse_catalog.Fill(ds1, "course_catalog");
course_catalog_list.DataSource=ds1.Tables["course_catalog"].DefaultView;
course_catalog_list.DataBind();
if (course_catalog_id.Text!=""){
int i =0;
foreach( DataRow course_catalog in ds1.Tables["course_catalog"].Rows)
{
if (course_catalog_id.Text==course_catalog["course_catalog_id"].ToString())
break;
i=i+1;
}
course_catalog_list.Items[i].Selected=true;
}
strSQLPackageCourse="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
+ "' order by course_order";
BindGrid();
}
catch (System.Exception e) {
ErrorHandler(e.ToString());
}
}
private void BackBtn_Click(Object Sender, EventArgs E) {
try {
Response.Redirect("package.aspx");
}
catch (System.Exception e) {
ErrorHandler(e.ToString());
}
}
private void SubmitBtn_Click(Object Sender, EventArgs E) {
try {
if (Page.IsValid) {
SqlConnection myConnection = new SqlConnection
(ConfigurationSettings.AppSettings["edu"]);;
String updateCmd = "update course set course_name= @course_name"
+", course_english_name=@course_english_name"
+", course_alias=@course_alias"
+", total_hour=@total_hour"
+", amount=@amount"
+", course_catalog_id=@course_catalog_id"
+" where course_id =@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("@course_name", SqlDbType.VarChar, 100));
myCommand.Parameters["@course_name"].Value = course_name.Text;
myCommand.Parameters.Add(new SqlParameter("@course_english_name", SqlDbType.VarChar, 100));
myCommand.Parameters["@course_english_name"].Value = course_english_name.Text;
myCommand.Parameters.Add(new SqlParameter("@course_alias", SqlDbType.VarChar, 50));
myCommand.Parameters["@course_alias"].Value = course_alias.Text;
myCommand.Parameters.Add(new SqlParameter("@total_hour", SqlDbType.Decimal, 5));
myCommand.Parameters["@total_hour"].Value = total_hour.Text;
myCommand.Parameters.Add(new SqlParameter("@amount", SqlDbType.Money, 8));
myCommand.Parameters["@amount"].Value = amount.Text;
myCommand.Parameters.Add(new SqlParameter("@course_catalog_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@course_catalog_id"].Value = course_catalog_list.SelectedItem.Value;
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLUptDone();
}
catch (System.Data.SqlClient.SqlException e) {
SQLErrorHandler(e);
}
myConnection.Close();
}
}
catch (System.Exception e) {
ErrorHandler(e.ToString());
}
}
private void FilterApply_Click(Object sender, EventArgs E) {
try {
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
SqlDataAdapter myCommand = new SqlDataAdapter("select course_id,name='['+course_id+']'+course_name from course where course_id like '"+course_id_filter.Value+"%' and course_name like '"+course_name_filter.Value+"%' and course_type='1' order by course_id", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "course");
course_list.DataSource=ds.Tables["course"].DefaultView;
course_list.DataBind();
}
catch (System.Exception e) {
ErrorHandler(e.ToString());
}
}
private void Add_Click(Object sender, EventArgs E) {
try {
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
String insertCmd = "insert into ref_course (course_id,ref_course_id) values('"+course_id.Text+"','" +course_list.SelectedItem.Value+"')";
SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLInsDone();
}
catch (System.Data.SqlClient.SqlException e) {
SQLErrorHandler(e);
}
myConnection.Close();
SqlDataAdapter myCommand2 = new SqlDataAdapter(strSQLPackageCourse, myConnection);
DataSet ds = new DataSet();
myCommand2.Fill(ds, "new_course");
MyDataGrid.DataSource=ds.Tables["new_course"].DefaultView;
MyDataGrid.DataBind();
}
catch (System.Exception e) {
ErrorHandler(e.ToString());
}
}
private void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs E) {
try {
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
String deleteCmd = "delete ref_course where course_id='"+course_id.Text+"' and ref_course_id='" +MyDataGrid.DataKeys[(int)E.Item.ItemIndex]+"'";
Message.InnerHtml = deleteCmd;
SqlCommand myCommand = new SqlCommand(deleteCmd, myConnection);
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLDelDone();
}
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());
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -