protected void Save_Click(object sender, EventArgs e)
{
CourseModel Course_Model = new CourseModel();
Bap_Course Bap_Course = new Bap_Course();
Bap_Course.Id = Id_Edit.Text;
Bap_Course.Course_Name = Course_Name_Edit.Text;
Bap_Course.Staff_num = Staff_num_Edit.Text;
Bap_Course.Teacher_Name = Teacher_Name_Edit.Text;
Bap_Course.Department = Department_Edit.Text;
Bap_Course.Hours = Hours_Edit.Text;
Bap_Course.Class_Time = Class_Time_Edit.SelectedValue;
Bap_Course.Class_Week = Class_Week_Edit.SelectedValue;
Bap_Course.Total_Week = Total_Week_Edit1.Text + "-" + Total_Week_Edit2.Text + "周";
Bap_Course.Is_Week = Is_Week_Edit.SelectedValue;;
Bap_Course.Class_Addr = Class_Addr_Edit.Text;
Bap_Course.Classes = Classes_Edit.Text;
bool is_Success = Course_Model.SaveById(Bap_Course);
if (is_Success)
{
Response.Redirect("List.aspx");
}
else
{
SaveInfo.Text = "修改失败...";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request["Id"];
Id_Edit.Text = id;
CourseModel Course_Model = new CourseModel();
Bap_Course Bap_Course = Course_Model.getOne(id);
Course_Name.Text = Bap_Course.Course_Name;
Staff_num.Text = Bap_Course.Staff_num;
Teacher_Name.Text = Bap_Course.Teacher_Name;
Department.Text = Bap_Course.Department;
Hours.Text = Bap_Course.Hours;
Class_Time.Text = Bap_Course.Class_Time;
Class_Week.Text = Bap_Course.Class_Week;
Total_Week.Text = Bap_Course.Total_Week;
Is_Week.Text = Bap_Course.Is_Week;
Class_Addr.Text = Bap_Course.Class_Addr;
Classes.Text = Bap_Course.Classes;
}
protected void queding_Click(object sender, EventArgs e)
{
int iii = 0;
string filename = Session["filename"].ToString();
//获取Execle文件名 DateTime日期函数
// Label2.Text = filename;
//Server.MapPath 获得虚拟服务器相对路径
string savePath = Server.MapPath(("~\\DaoRu\\files\\") + filename);
//SaveAs 将上传的文件内容保存在服务器上
//调用自定义方法
DataSet ds = new ExcelDateSet().ExcelDs(savePath);
//定义一个DataRow数组
DataRow[] dr = ds.Tables[0].Select();
int rowsnum = ds.Tables[0].Rows.Count;
// Response.Write("<table width='1380px;' style=' border : yellow 2px solid;'>");
//存放拆分之后的所有课表
LinkedList <LinkedList <String> > lastlist = new LinkedList <LinkedList <String> >();
//LinkedList<Object> lastlist = new LinkedList<Object>();
//读取execl表中的每一行，放在一个list中
for (int i = 0; i < dr.Length; i++)
{
LinkedList <String> List = new LinkedList <String>();
List.AddFirst(dr[i][0].ToString());
List.AddLast(dr[i][1].ToString());
List.AddLast(dr[i][2].ToString());
List.AddLast(dr[i][3].ToString());
List.AddLast(dr[i][4].ToString());
List.AddLast(dr[i][5].ToString());
List.AddLast(dr[i][6].ToString());
List.AddLast(dr[i][7].ToString());
//调用自己写方法，将execl表中的数据划分好。返回的数据是一个list中包含的list成员的链表
LinkedList <LinkedList <String> > templist = new ExcelDateSet().ListCutter(List);
//将返回的list放在最后的集合中
foreach (LinkedList <String> obj in templist)
{
lastlist.AddLast(obj);
}
foreach (LinkedList <String> linklist in lastlist)
{
int j = 0;
String[] tempstr = new String[20];
foreach (String str in linklist)
{
tempstr[j++] = str;
}
Bap_Course classbean = new Bap_Course();
classbean.Course_Name = tempstr[0];
classbean.Staff_num = tempstr[1];
classbean.Teacher_Name = tempstr[2];
classbean.Department = tempstr[3];
classbean.Hours = tempstr[4];
classbean.Class_Addr = tempstr[5];
classbean.Classes = tempstr[6];
// classbean.Class_Time = tempstr[7];
classbean.Class_Time = tempstr[8];
classbean.Class_Week = tempstr[9];
// classbean.Startweek = tempstr[10];
classbean.Total_Week = tempstr[11];
classbean.Is_Week = tempstr[12];
//try中的操作是将课程安排写到数据库中，暂时没有完成。
try
{
// DataBase db = new DataBase();
String insertstr = @"insert into Bap_Course(Course_Name ,Staff_num,Teacher_Name,Department,Hours,Class_Addr,Classes,Class_Time,Class_Week,Total_Week,Is_Week)
values ('" + classbean.Course_Name + "','" + classbean.Staff_num + "','" + classbean.Teacher_Name + "','" + classbean.Department + "','" + classbean.Hours + "','" + classbean.Class_Addr + "','" + classbean.Classes + "','" + classbean.Class_Time + "','" + classbean.Class_Week + "','" + classbean.Total_Week + "','" + classbean.Is_Week + "' ) ";
//Boolean b = db.DateExecuteSQL(insertstr);
if (DbHelperSQL.ExecuteSql(insertstr) > 0)
{
iii++;
}
}
catch (Exception ex) //捕捉异常
{
Response.Write("<script>alert('导入内容:" + ex.Message + "')</script>");
}
}
Response.Write("<script>alert('" + iii + "条数据导入成功!');</script>");
trselet.Visible = true;
queding.Visible = false;
fanhui.Visible = false;
Session["filename"] = "";
//Response.Redirect("~/DaoRu/Default.aspx");
Response.Write("<script>document.location=document.location;</script>");
//数据的拆分，写入数据库工作完成。
}
}
