/// <summary>
/// /新建或修改教师
/// </summary>
/// <param name="TeacherID"></param>
/// <param name="TeacherName"></param>
/// <param name="TeacherPwd"></param>
/// <param name="CreateORUpdate"></param>
/// <returns></returns>
public static bool InsertOrUpdateTeacher(int TeacherID, string TeacherName, string TeacherPwd, string CreateORUpdate)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertOrUpdateTeacher " + TeacherID + ",'" + TeacherName + "','" + TeacherPwd + "','" + CreateORUpdate + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 管理员删除教师
/// </summary>
/// <param name="AppointmentID"></param>
/// <returns></returns>
public static bool DeleteTeacherInfo(int TeacherID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteTeacherInfo " + TeacherID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 管理员审批预约
/// </summary>
/// <param name="AppointmentID"></param>
/// <param name="AdminAllow"></param>
/// <param name="AdminReason"></param>
/// <returns></returns>
public static bool AccraditationAppointment(int AppointmentID, int AdminAllow, string AdminReason)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_AccraditationAppointment " + AppointmentID + "," + AdminAllow + ",'" + AdminReason + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 管理员删除预约
/// </summary>
/// <param name="AppointmentID"></param>
/// <returns></returns>
public static bool DeleteLabAppointment(int AppointmentID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteLabAppointment " + AppointmentID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台 删除新闻公告
/// </summary>
/// <param name="NewsID"></param>
/// <returns></returns>
public static bool DeleteNoticeNewsInfo(int NewsID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteNoticeNewsInfo " + NewsID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台 修改新闻公告
/// </summary>
/// <param name="NewsID"></param>
/// <param name="NewsTitle"></param>
/// <param name="NewsContent"></param>
/// <returns></returns>
public static bool UpdateNewsInfo(int NewsID, string NewsTitle, string NewsContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdateNewsInfo " + NewsID + ",'" + NewsTitle + "','" + NewsContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台 新增新闻公告
/// </summary>
/// <param name="NewsTitle"></param>
/// <param name="NewsContent"></param>
/// <param name="Admin"></param>
/// <returns></returns>
public static bool InsertNoticeNews(string NewsTitle, string NewsContent, int Admin)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertNoticeNews '" + NewsTitle + "','" + NewsContent + "' ," + Admin + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 实验室预约
/// </summary>
/// <param name="LabID"></param>
/// <param name="TeacherID"></param>
/// <param name="TeacherLeaveMessage"></param>
/// <param name="AppointmentDate"></param>
/// <param name="DataSection"></param>
/// <returns></returns>
public static bool InsertLabAppointment(int LabID, int TeacherID, string TeacherLeaveMessage, string AppointmentDate, string DataSection)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertLabAppointment " + LabID + " ," + TeacherID + " ,'" + TeacherLeaveMessage + "','" + AppointmentDate + "','" + DataSection + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增环境安全
/// </summary>
/// <param name="LabSafetyTitle"></param>
/// <param name="LabSafetyContent"></param>
/// <returns></returns>
public static bool InsertLabSafetyInfo(string LabSafetyTitle, string LabSafetyContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertLabSafetyInfo '" + LabSafetyTitle + "' ,'" + LabSafetyContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除资源文件
/// </summary>
/// <param name="FileID"></param>
/// <returns></returns>
public static bool DeleteResourceFile(int FileID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteResourceFile " + FileID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 上传资源文件
/// </summary>
/// <param name="FileTitle"></param>
/// <param name="FileTypeName"></param>
/// <param name="FileName"></param>
/// <returns></returns>
public static bool InsertResourceFile(string FileTitle, string FileTypeName, string FileName)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertResourceFile '" + FileTitle + "','" + FileTypeName + "','" + FileName + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增实验室制度
/// </summary>
/// <param name="LabManageSystemTitle"></param>
/// <param name="LabManageSystemContent"></param>
/// <returns></returns>
public static bool InsertLabManageSystemTitle(string LabManageSystemTitle, string LabManageSystemContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertLabManageSystemTitle '" + LabManageSystemTitle + "' ,'" + LabManageSystemContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 临时方法
/// </summary>
/// <param name="CenterframeworkName"></param>
/// <param name="CenterframeworkContent"></param>
/// <returns></returns>
public static bool InsertCenterframeworkData(string CenterframeworkName, string CenterframeworkContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertCenterframeworkData '" + CenterframeworkName + "' ,'" + CenterframeworkContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台新增修改和删除实验室
/// </summary>
/// <param name="CUD"></param>
/// <param name="LabID"></param>
/// <param name="LabName"></param>
/// <param name="LabTypeID"></param>
/// <param name="MaxNO"></param>
/// <returns></returns>
public static bool BackCUDLabInfo(string CUD, int LabID, string LabName, int LabTypeID, int MaxNO)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_BackCUDLabInfo '" + CUD + "'," + LabID + " ,'" + LabName + "' ," + LabTypeID + " ," + MaxNO + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加、修改或删除实验室类型
/// </summary>
/// <param name="LabTypeID"></param>
/// <param name="LabTypeName"></param>
/// <param name="Command"></param>
/// <returns></returns>
public static bool BackOpearLabType(int LabTypeID, string LabTypeName, string Command)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_BackOpearLabType " + LabTypeID + ",'" + LabTypeName + "' ,'" + Command + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 后台删除留言
/// </summary>
/// <param name="LeaveMessageID"></param>
/// <returns></returns>
public static bool DeleteLeaveMessage(int LeaveMessageID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteLeaveMessage " + LeaveMessageID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 管理员回复留言
/// </summary>
/// <param name="LeaveMessageID"></param>
/// <param name="ReplyContent"></param>
/// <returns></returns>
public static bool UpdateLeaveMessage(int LeaveMessageID, string ReplyContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdateLeaveMessage " + LeaveMessageID + " ,'" + ReplyContent + "'") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="DrviceMaintenanceID"></param>
/// <returns></returns>
public static bool DeleteDrviceMaintenance(int DrviceMaintenanceID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteDrviceMaintenance " + DrviceMaintenanceID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool InsertDrviceMaintenance(string DrviceMaintenanceTitle, string DrviceMaintenancePath)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertDrviceMaintenance '" + DrviceMaintenanceTitle + "','" + DrviceMaintenancePath + "'") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增或修改制度或安全
/// </summary>
/// <param name="CreORUpd"></param>
/// <param name="command"></param>
/// <param name="MyID"></param>
/// <param name="Title"></param>
/// <param name="Content"></param>
/// <returns></returns>
public static bool UpdateSystemAndSafety(string CreORUpd, string command, int MyID, string Title, string Content)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdateSystemAndSafety '" + CreORUpd + "','" + command + "'," + MyID + ",'" + Title + "','" + Content + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除制度或安全
/// </summary>
/// <param name="command"></param>
/// <param name="MyID"></param>
/// <returns></returns>
public static bool DeleteSystemAndSafety(string command, int MyID)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_DeleteSystemAndSafety '" + command + "'," + MyID + " ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 给管理员留言
/// </summary>
/// <param name="LeaveManName"></param>
/// <param name="IsTeacher"></param>
/// <param name="LeaveMessageContent"></param>
/// <returns></returns>
public static bool InsertLeaveMessage(string LeaveManName, int IsTeacher, string LeaveMessageContent)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_InsertLeaveMessage '" + LeaveManName + "' ," + IsTeacher + " ,'" + LeaveMessageContent + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新公共信息
/// </summary>
/// <param name="command"></param>
/// <param name="Content"></param>
/// <returns></returns>
public static bool UpdatePublicInfo(string command, string Content)
{
if (ADOHelp.ExecuteSql_ReturnRow("exec proc_UpdatePublicInfo '" + command + "','" + Content + "' ") > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string lab = "";
string stage;
string time;
string order_Time = Request.Form["orderDate"];
string[] s = new string[36];
s[1] = TextBox1.Text;
s[2] = TextBox2.Text;
s[3] = TextBox3.Text;
s[4] = TextBox4.Text;
s[5] = TextBox5.Text;
s[6] = TextBox6.Text;
s[7] = TextBox7.Text;
s[8] = TextBox8.Text;
s[9] = TextBox9.Text;
s[10] = TextBox10.Text;
s[11] = TextBox11.Text;
s[12] = TextBox12.Text;
s[13] = TextBox13.Text;
s[14] = TextBox14.Text;
s[15] = TextBox15.Text;
s[16] = TextBox16.Text;
s[17] = TextBox17.Text;
s[18] = TextBox18.Text;
s[19] = TextBox19.Text;
s[20] = TextBox20.Text;
s[21] = TextBox21.Text;
s[22] = TextBox22.Text;
s[23] = TextBox23.Text;
s[24] = TextBox24.Text;
s[25] = TextBox25.Text;
s[26] = TextBox26.Text;
s[27] = TextBox27.Text;
s[28] = TextBox28.Text;
s[29] = TextBox29.Text;
s[30] = TextBox30.Text;
s[31] = TextBox31.Text;
s[32] = TextBox32.Text;
s[33] = TextBox33.Text;
s[34] = TextBox34.Text;
s[35] = TextBox35.Text;
string date = DateTime.Now.ToString();
/* for(int m = 1; m <= 35; m ++)
* {
*
* if (m<15)
* {
* stage = "上午";
* if(m % 2 == 0)
* {
* time = "三四节";
* int n = m / 2;
* switch (n)
* {
* case 1:
* lab = "第一机房";
* break;
* case 2:
* lab = "第二机房";
* break;
* case 3:
* lab = "第三机房";
* break;
* case 4:
* lab = "第四机房";
* break;
* case 5:
* lab = "第五机房";
* break;
* case 6:
* lab = "第六机房";
* break;
* case 7:
* lab = "第七机房";
* break;
*
* }
* }
* else
* {
* time = "一二节";
* int n = m / 2 + 1;
* switch (n)
* {
* case 1:
* lab = "第一机房";
* break;
* case 2:
* lab = "第二机房";
* break;
* case 3:
* lab = "第三机房";
* break;
* case 4:
* lab = "第四机房";
* break;
* case 5:
* lab = "第五机房";
* break;
* case 6:
* lab = "第六机房";
* break;
* case 7:
* lab = "第七机房";
* break;
*
* }
* }
* }
* else if(m > 14 && m < 29)
* {
* stage = "下午";
* if (m % 2 == 0)
* {
* time = "三四节";
* int n = m / 2 - 7;
* switch (n)
* {
* case 1:
* lab = "第一机房";
* break;
* case 2:
* lab = "第二机房";
* break;
* case 3:
* lab = "第三机房";
* break;
* case 4:
* lab = "第四机房";
* break;
* case 5:
* lab = "第五机房";
* break;
* case 6:
* lab = "第六机房";
* break;
* case 7:
* lab = "第七机房";
* break;
*
* }
* }
* else
* {
* time = "一二节";
* int n = m / 2 - 6;
* switch (n)
* {
* case 1:
* lab = "第一机房";
* break;
* case 2:
* lab = "第二机房";
* break;
* case 3:
* lab = "第三机房";
* break;
* case 4:
* lab = "第四机房";
* break;
* case 5:
* lab = "第五机房";
* break;
* case 6:
* lab = "第六机房";
* break;
* case 7:
* lab = "第七机房";
* break;
*
* }
* }
* }
* else
* {
* stage = "晚上";
* time = "晚上";
* int n = m - 28;
* switch (n)
* {
* case 1:
* lab = "第一机房";
* break;
* case 2:
* lab = "第二机房";
* break;
* case 3:
* lab = "第三机房";
* break;
* case 4:
* lab = "第四机房";
* break;
* case 5:
* lab = "第五机房";
* break;
* case 6:
* lab = "第六机房";
* break;
* case 7:
* lab = "第七机房";
* break;
*
* }
* }
*
* if (s[m] != "")
* {
* string sql = "insert into Newlab values('" + lab + "','" + stage + "','" + time + "','" + s[m] + "','" + Convert.ToDateTime
* (date) +" ','"+ Convert.ToDateTime(order_Time) +"')";
* int i = ADOHelp.ExecuteSql_ReturnRow(sql);
* }
* }*/
string sql = "insert into Newlab values('" + Convert.ToDateTime(order_Time) + "','第一机房','" + s[1] + "','" + s[2] + "','" + s[15] + " ','" + s[16] + "','" + s[29] + "')";
int i = ADOHelp.ExecuteSql_ReturnRow(sql);
sql = "insert into Newlab values('" + Convert.ToDateTime(order_Time) + "','第二机房','" + s[3] + "','" + s[4] + "','" + s[17] + " ','" + s[18] + "','" + s[30] + "')";
i = ADOHelp.ExecuteSql_ReturnRow(sql);
sql = "insert into Newlab values('" + Convert.ToDateTime(order_Time) + "','第三机房','" + s[5] + "','" + s[6] + "','" + s[19] + " ','" + s[20] + "','" + s[31] + "')";
i = ADOHelp.ExecuteSql_ReturnRow(sql);
sql = "insert into Newlab values('" + Convert.ToDateTime(order_Time) + "','第四机房','" + s[7] + "','" + s[8] + "','" + s[21] + " ','" + s[22] + "','" + s[32] + "')";
i = ADOHelp.ExecuteSql_ReturnRow(sql);
sql = "insert into Newlab values('" + Convert.ToDateTime(order_Time) + "','第五机房','" + s[9] + "','" + s[10] + "','" + s[23] + " ','" + s[24] + "','" + s[33] + "')";
i = ADOHelp.ExecuteSql_ReturnRow(sql);
sql = "insert into Newlab values('" + Convert.ToDateTime(order_Time) + "','第六机房','" + s[11] + "','" + s[12] + "','" + s[25] + " ','" + s[26] + "','" + s[34] + "')";
i = ADOHelp.ExecuteSql_ReturnRow(sql);
sql = "insert into Newlab values('" + Convert.ToDateTime(order_Time) + "','第七机房','" + s[13] + "','" + s[14] + "','" + s[27] + " ','" + s[28] + "','" + s[35] + "')";
i = ADOHelp.ExecuteSql_ReturnRow(sql);
}
//*/
protected void submitClick(object sender, EventArgs e)
{
if (FileUpload1.FileName == "")
{
this.loadLabel.Text = "上传文件不能为空";
return;
}
bool fileIsValid = false;
//如果确认了上传文件，则判断文件类型是否符合要求
if (this.FileUpload1.HasFile)
{
//获取文件的后缀
String fileExtension = System.IO.Path.GetExtension(this.FileUpload1.FileName).ToLower();
String[] restrictExtension = { ".gif", ".jpg", ".bmp", ".png" };
//判断文件类型是否符合要求
for (int i = 0; i < restrictExtension.Length; i++)
{
if (fileExtension == restrictExtension[i])
{
fileIsValid = true;
}
}
//如果文件类型符合要求，调用SaveAs方法实现上传，并显示相关信息
if (fileIsValid == true)
{
//上传文件是否大于10M
if (FileUpload1.PostedFile.ContentLength > (10 * 1024 * 1024))
{
this.loadLabel.Text = "上传文件过大";
return;
}
try
{
//this.loadImage.ImageUrl = "File/" + FileUpload1.FileName;
this.FileUpload1.SaveAs(Server.MapPath("File/") + FileUpload1.FileName);
this.loadLabel.Text = "图片上传成功！";
}
catch
{
this.loadLabel.Text = "图片上传失败";
}
finally
{
}
}
else
{
this.loadLabel.Text = "只能够上传后缀为.gif .jpg .bmp .png的文件";
}
}
string lostTime = Request.Form["dateInput"];
string name = Request.Form["lostName"];
string type = DropDownList2.SelectedItem.Text;
string room = roomSelect.SelectedItem.Text;
string description = this.des.Value;
string picName = FileUpload1.FileName;
if (lostTime == "" || name == "")
{
}
else
{
var tab = db.LostAndFound_Admin;
string sql = "insert into LostAndFound_Admin values('" + name + "','" + type + "','" + room + "','" + lostTime + "','" + System.DateTime.Now + "','" + description + "','" + picName + "');";
int i = ADOHelp.ExecuteSql_ReturnRow(sql);
Response.Redirect("LostAndFound_List.aspx");
}
}
