protected void btnOK_Click(object sender, EventArgs e)
{
int n = 0;
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = string.Format("insert into Subject values('{0}','{1}');", txtSubjectID.Text, txtSubject.Text);
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
conn.Open();
try
{
n = com.ExecuteNonQuery();
if (n == 1)
{
Response.Write(DialogMessage.CreateMessage("插入成功!"));
}
else
{
Response.Write(DialogMessage.CreateMessage("插入不成功!"));
}
}
catch (Exception ex)
{
lblResult.Text = ex.Message;
}
finally
{
com.Dispose();
conn.Close();
}
grdSubject.DataBind();
btnCancel_Click(null, null);
}
protected void btnOK_Click(object sender, EventArgs e)
{
int n = 0;
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = string.Format("insert into Schloarship values('{0}','{1}','{2}','{3}',{4},{5},{6});", txtScholarID.Text, txtScholarType.Text, txtStudentType.Text, txtSubjectType.Text, int.Parse(txtLivingExpense.Text), int.Parse(txtAccomExpense.Text), int.Parse(txtTuitionExpense.Text));
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
conn.Open();
try
{
n = com.ExecuteNonQuery();
if (n == 1)
{
Response.Write(DialogMessage.CreateMessage("插入成功!"));
}
else
{
Response.Write(DialogMessage.CreateMessage("插入不成功!"));
}
}
catch (Exception ex)
{
lblResult.Text = ex.Message;
}
finally
{
com.Dispose();
conn.Close();
}
grdScholarship.DataBind();
btnCancel_Click(null, null);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int LeaveID, n = 0;
Button btn = (Button)sender;
LeaveID = int.Parse(btn.CommandArgument);
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = string.Format("delete StudentLeaveInfo where StuLeaveID={0};", LeaveID);
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
conn.Open();
n = com.ExecuteNonQuery();
if (n != 0)
{
Response.Write(DialogMessage.CreateMessage("删除成功！"));
}
else
{
Response.Write(DialogMessage.CreateMessage("删除不成功！"));
}
com.Dispose();
conn.Close();
UpdateData();
}
protected void btnSave_Click(object sender, EventArgs e)
{
int n, m = 0;
int year, month, day;
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = "select max(StuLeaveID) from StudentLeaveInfo;";
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
conn.Open();
try
{
n = (int)com.ExecuteScalar();
}
catch
{
n = 0;
}
n++;
strSQL = "insert into StudentLeaveInfo(StuLeaveID,StudentID,ReasonLeaveType,ReasonLeaveContent,Destination,DateStart,DateEnd,DaysLeave,ProofFilePath,Year,Semester,AskLeaveApprovalStateID,IsPass) values(";
strSQL += string.Format("{0}", n);
strSQL += string.Format(",'{0}'", Session["UserName"].ToString());
strSQL += string.Format(",'{0}'", ddlLeaveType.SelectedValue.ToString());
strSQL += string.Format(",'{0}'", txtContent.Text);
strSQL += string.Format(",'{0}'", txtDestination.Text);
strSQL += string.Format(",'{0}'", txtStart.Text);
strSQL += string.Format(",'{0}'", txtEnd.Text);
year = int.Parse(txtStart.Text.Substring(0, 4));
month = int.Parse(txtStart.Text.Substring(5, 2));
day = int.Parse(txtStart.Text.Substring(8, 2));
DateTime dtstart = new DateTime(year, month, day);
year = int.Parse(txtEnd.Text.Substring(0, 4));
month = int.Parse(txtEnd.Text.Substring(5, 2));
day = int.Parse(txtEnd.Text.Substring(8, 2));
DateTime dtend = new DateTime(year, month, day);
m = (dtend - dtstart).Days;
strSQL += string.Format(",{0}", m);
strSQL += string.Format(",{0}", "null"); //proofFilePath
strSQL += string.Format(",{0}", year); //year
strSQL += string.Format(",{0}", "null"); //semester
strSQL += string.Format(",{0}", 1);
strSQL += string.Format(",{0}", 0); //0表示还没有审核意见，1表示同意，-1表示布同意。
strSQL += ");";
com.CommandText = strSQL;
n = com.ExecuteNonQuery();
if (n == 1)
{
Response.Write(DialogMessage.CreateMessage("请假条添加成功！"));
}
else
{
Response.Write(DialogMessage.CreateMessage("请假条添加失败！"));
}
com.Dispose();
conn.Close();
Response.Redirect(Request.Url.ToString());//防止二次提交保存
// UpdateData();
}
protected void txtEnd_TextChanged(object sender, EventArgs e)
{
int year, month, day;
int m = 0;
if (txtStart.Text != "" && txtEnd.Text != "")
{
year = int.Parse(txtStart.Text.Substring(0, 4));
month = int.Parse(txtStart.Text.Substring(5, 2));
day = int.Parse(txtStart.Text.Substring(8, 2));
DateTime dtstart = new DateTime(year, month, day);
if (dtstart < DateTime.Now)
{
Response.Write(DialogMessage.CreateMessage("请假时间不能早于今天！"));
txtStart.Text = "";
txtEnd.Text = "";
lblDaysLeave.Text = "";
return;
}
year = int.Parse(txtEnd.Text.Substring(0, 4));
month = int.Parse(txtEnd.Text.Substring(5, 2));
day = int.Parse(txtEnd.Text.Substring(8, 2));
DateTime dtend = new DateTime(year, month, day);
m = (dtend - dtstart).Days;
if (m < 0)
{
Response.Write(DialogMessage.CreateMessage("请假开始时间不能晚于请假结束时间！"));
txtStart.Text = "";
txtEnd.Text = "";
lblDaysLeave.Text = "";
return;
}
lblDaysLeave.Text = m.ToString();
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
int n = int.Parse(lblSemesterID.Text);
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = string.Format("insert into Semester values({0},'{1}','{2}','{3}',{4});", n, txtSemesterName.Text, Convert.ToDateTime(txtDateStart.Text), Convert.ToDateTime(txtDateEnd.Text), int.Parse(txtYear.Text));
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
conn.Open();
try
{
n = com.ExecuteNonQuery();
if (n == 1)
{
Response.Write(DialogMessage.CreateMessage("添加成功!"));
}
else
{
Response.Write(DialogMessage.CreateMessage("添加不成功!"));
}
}
catch (Exception ex)
{
lblResult.Text = ex.Message;
}
finally
{
com.Dispose();
conn.Close();
}
grdSemester.DataBind();
btnCancel_Click(null, null);
}
protected void grdAskLeave_SelectedIndexChanged(object sender, EventArgs e)
{
int AskID = int.Parse(grdAskLeave.SelectedRow.Cells[2].Text);
int n = 0;
string CheckID;
lblResult.Text = AskID.ToString();
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = string.Format("update StudentLeaveInfo set AskLeaveApprovalStateID=2 where StuLeaveID={0};", AskID);
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
SqlDataReader dr;
conn.Open();
n = com.ExecuteNonQuery();
if (n == 1)
{
strSQL = string.Format("select CheckTeacherID from AskLeaveCheckTurn where CheckTurn = 1;");
com.CommandText = strSQL;
dr = com.ExecuteReader();
if (dr.HasRows)
{
strSQL = "";
while (dr.Read())
{
CheckID = dr.GetValue(0).ToString();
strSQL += string.Format("insert into StudentLeaveCheckProcess(StuLeaveID,CheckTurn,CheckID) values({0},1,'{1}');", AskID, CheckID);
}
dr.Close();
com.CommandText = strSQL;
n = com.ExecuteNonQuery();
Response.Write(DialogMessage.CreateMessage("提交成功，请等待辅导员审核！"));
}
else
{
strSQL = string.Format("update StudentLeaveInfo set AskLeaveApprovalStateID=1 where StuLeaveID={0};", AskID);
com.CommandText = strSQL;
com.ExecuteNonQuery();
Response.Write(DialogMessage.CreateMessage("提交不成功，请联系管理员！"));
}
}
else
{
Response.Write(DialogMessage.CreateMessage("提交不成功，请联系系统管理员！"));
}
com.Dispose();
conn.Close();
UpdateData();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
int n = 0, turn, stateID = 0;
int LeaveID = int.Parse(lblLeaveID.Text);
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
//update StudentLeaveCheckProcess set IsPass='******' where StuLeaveId=7;
string strSQL = string.Format("update StudentLeaveCheckProcess set IsPass='******',ReasonForNoPass='******',CheckDate='{2}' where StuLeaveID={3} and CheckID='{4}';", "不同意", txtReason.Text, DateTime.Now, LeaveID, Session["UserName"].ToString());
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand com = new SqlCommand(strSQL, conn);
n = com.ExecuteNonQuery();
if (n > 0)
{
strSQL = string.Format("select CheckTurn from AskLeaveCheckTurn where CheckTeacherID = '{0}';", Session["UserName"].ToString());
com.CommandText = strSQL;
turn = (int)com.ExecuteScalar();
switch (turn)
{
case 1:
stateID = 4;
break;
case 2:
stateID = 6;
break;
case 3:
stateID = 8;
break;
case 4:
stateID = 10;
break;
}
strSQL = string.Format("Update StudentLeaveInfo set IsPass={0},AskLeaveApprovalStateID={1} where StuLeaveID={2};", -1, stateID, LeaveID);
com.CommandText = strSQL;
com.ExecuteNonQuery();
Response.Write(DialogMessage.CreateMessage("审核处理完成！"));
UpdateGridView();
}
com.Dispose();
conn.Close();
ReasonReject.Visible = false;
txtReason.Text = "";
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (filePath.FileName == "")
{
int n = 0, StuOutCampusID = int.Parse(lblRendID.Text);
string RentingContract = System.IO.Path.GetFileName(filePath.PostedFile.FileName);
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = string.Format("insert into StudentOutCampusInfo values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}');", StuOutCampusID, Session["UserName"].ToString(), txtAddress.Text, txtName.Text, txtPhone.Text, "null", DateStart.Text, DateEnd.Text);
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
conn.Open();
n = com.ExecuteNonQuery();
if (n > 0)
{
Response.Write(DialogMessage.CreateMessage("租房信息更新成功！"));
}
}
else
{
Response.Write(DialogMessage.CreateMessage("你还没有选择租房合同复印件！"));
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
int LeaveID, n = 0, turn, stateID = 0;
Button btn = (Button)sender;
LeaveID = int.Parse(btn.CommandArgument);
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
//update StudentLeaveCheckProcess set IsPass='******' where StuLeaveId=7;
string strSQL;
strSQL = string.Format("select CheckTurn from AskLeaveCheckTurn where CheckTeacherID = '{0}';", Session["UserName"].ToString());
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
SqlDataReader dr;
conn.Open();
turn = (int)com.ExecuteScalar();
strSQL = string.Format("select count(*) from StudentLeaveCheckProcess where StuLeaveID={0} and CheckTurn={1} and IsPass is not null;", LeaveID, turn);
com.CommandText = strSQL;
n = (int)com.ExecuteScalar();
strSQL = string.Format("update StudentLeaveCheckProcess set IsPass='******',Checkdate='{1}' where StuLeaveId={2} and CheckID='{3}';", "同意", DateTime.Now, LeaveID, Session["UserName"].ToString());
strSQL += string.Format("delete StudentLeaveCheckProcess where StuLeaveId={0} and CheckID!='{1}' and IsPass is null;", LeaveID, Session["UserName"].ToString());
com.CommandText = strSQL;
// Response.Write(DialogMessage.CreateMessage(strSQL));
n = com.ExecuteNonQuery();
if (n > 0)
{
// Response.Write(DialogMessage.CreateMessage(turn.ToString()));
switch (turn)
{
case 1:
stateID = 3;
break;
case 2:
stateID = 5;
break;
case 3:
stateID = 7;
break;
case 4:
stateID = 9;
break;
}
if (turn == 4)
{
strSQL = string.Format("update StudentLeaveInfo set AskLeaveApprovalStateID={0},IsPass={1} where StuLeaveID={2};", stateID, 1, LeaveID);
//请假条审批完成
com.CommandText = strSQL;
com.ExecuteNonQuery();
Response.Write(DialogMessage.CreateMessage("审批成功！"));
}
else
{
turn++;
// Response.Write(DialogMessage.CreateMessage(turn.ToString()));
strSQL = string.Format("select CheckTeacherID from AskLeaveCheckTurn where CheckTurn = {0};", turn);
com.CommandText = strSQL;
dr = com.ExecuteReader();
strSQL = "";
string chkID;
if (dr.HasRows)
{
while (dr.Read())
{
chkID = dr.GetValue(0).ToString();
strSQL += string.Format("insert into StudentLeaveCheckProcess(StuLeaveID,CheckTurn,CheckID) values({0},{1},'{2}');", LeaveID, turn, chkID);
}
}
else
{
// Response.Write(DialogMessage.CreateMessage(turn.ToString()));
}
dr.Close();
com.CommandText = strSQL;
n = com.ExecuteNonQuery();
// Response.Write(DialogMessage.CreateMessage("n=" + n.ToString()));
if (n > 0)
{
strSQL = string.Format("update StudentLeaveInfo set AskLeaveApprovalStateID={0} where StuLeaveID={1};", stateID, LeaveID);
com.CommandText = strSQL;
com.ExecuteNonQuery();
Response.Write(DialogMessage.CreateMessage("审批完成！"));
}
}
}
else
{
Response.Write(DialogMessage.CreateMessage("没有成功！"));
}
UpdateGridView();
com.Dispose();
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
string strConn = ConfigurationManager.ConnectionStrings["Conn1"].ToString();
string strSQL = string.Format("select Building,RoomNo,Floor,RoomType.RoomType,RoomPrice,StudentNumber,RoomSate.RoomState from StudentInCampusInfo,Rooms,RoomSate,RoomType where StudentInCampusInfo.RoomID=Rooms.RoomID and Rooms.State=RoomSate.RoomStateID and Rooms.RoomType = RoomType.RoomTypeID and StudentID='{0}';", Session["UserName"].ToString());
SqlConnection conn = new SqlConnection(strConn);
SqlCommand com = new SqlCommand(strSQL, conn);
conn.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
if (dr.GetValue(0) != null && dr.GetValue(1) != null)
{
lblBuilding.Text = dr.GetValue(0).ToString() + dr.GetValue(1).ToString();
}
if (dr.GetValue(2) != null)
{
lblFloor.Text = dr.GetValue(2).ToString();
}
if (dr.GetValue(3) != null)
{
lblRoomType.Text = dr.GetValue(3).ToString();
}
if (dr.GetValue(4) != null)
{
lblPrice.Text = dr.GetValue(4).ToString();
}
if (dr.GetValue(5) != null)
{
lblStudentNumber.Text = dr.GetValue(5).ToString();
}
if (dr.GetValue(6) != null)
{
lblRoomState.Text = dr.GetValue(6).ToString();
}
InCampus.Visible = true;
}
else
{
InCampus.Visible = false;
dr.Close();
strSQL = string.Format("select RentingHouseAddress,LandlordName,LandlordPhone,RentingContract,RentDateStart,RentDateEnd from StudentOutCampusInfo where StudentID='{0}' order by RentDateStart;", Session["UserName"].ToString());
com.CommandText = strSQL;
dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
if (dr.GetValue(0) != null)
{
lblAddress.Text = dr.GetValue(0).ToString();
}
if (dr.GetValue(1) != null)
{
lblName.Text = dr.GetValue(1).ToString();
}
if (dr.GetValue(2) != null)
{
lblPhone.Text = dr.GetValue(2).ToString();
}
if (dr.GetValue(3) != null)
{
linkContract.NavigateUrl = "File/RentContract/" + dr.GetValue(3).ToString();
}
if (dr.GetValue(4) != null)
{
lblDateStart.Text = dr.GetValue(4).ToString();
}
if (dr.GetValue(5) != null)
{
lblDateEnd.Text = dr.GetValue(5).ToString();
}
OutCampus.Visible = true;
dr.Close();
com.Dispose();
conn.Close();
}
else
{
OutCampus.Visible = false;
Response.Write(DialogMessage.CreateMessage("没有您的住宿信息和租房信息！"));
}
}
}
}