📄 student.aspx.cs
字号:
}
else
if (DropDownList2.SelectedValue == "<=")
{
if (Convert.ToInt32(read.Rows[0][0]) <= data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == ">")
{
if (Convert.ToInt32(read.Rows[0][0]) > data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == "~")
{
int de = -1;
try
{
de = Convert.ToInt32(TextBox2.Text);
}
catch
{
Response.Write("<script>alert('还没有输入匹配数据错误');</script>");
return;
}
if ((Convert.ToInt32(read.Rows[0][0]) >= data) && (Convert.ToInt32(read.Rows[0][0]) <= de))
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
}
else
{
reader.Rows[i].Delete();
}
i++;
}
}
else
if (DropDownList1.SelectedValue == "3")
{
i = 0;
int data = 0;
try
{
data = Convert.ToInt32(TextBox1.Text);
}
catch
{
Response.Write("<script>alert('还没有输入匹配数据错误');</script>");
return;
}
//if (data < 1) return;
while (i < reader.Rows.Count)
{
str = "select count(StuID) as cout from ScholarApp where StuID='" + reader.Rows[i]["StuID"].ToString() + "' AND IsChecked=1";
try
{
read = null;
read = grd_MIS.manager.GetData_SqlExec(str);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
if (read != null && (read.Rows.Count == 1))
{
if (DropDownList2.SelectedValue == ">")
{
if (Convert.ToInt32(read.Rows[0][0]) > data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == "=")
{
if (Convert.ToInt32(read.Rows[0][0]) == data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == "<")
{
if (Convert.ToInt32(read.Rows[0][0]) < data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == ">=")
{
if (Convert.ToInt32(read.Rows[0][0]) >= data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == "<=")
{
if (Convert.ToInt32(read.Rows[0][0]) <= data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == ">")
{
if (Convert.ToInt32(read.Rows[0][0]) > data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == "~")
{
int de = -1;
try
{
de = Convert.ToInt32(TextBox2.Text);
}
catch
{
Response.Write("<script>alert('还没有输入匹配数据错误');</script>");
return;
}
if ((Convert.ToInt32(read.Rows[0][0]) >= data) && (Convert.ToInt32(read.Rows[0][0]) <= de))
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
}
else
{
reader.Rows[i].Delete();
}
i++;
}
}
else
if (DropDownList1.SelectedValue == "5")
{
i = 0;
int data = 0;
try
{
data = Convert.ToInt32(TextBox1.Text);
}
catch
{
Response.Write("<script>alert('还没有输入匹配数据错误');</script>");
return;
}
//if (data < 1) return;
while (i < reader.Rows.Count)
{
str = "select count(StuID) as cout from StationApply where StuID='" + reader.Rows[i]["StuID"].ToString() + "' AND IsChecked=1";
try
{
read = null;
read = grd_MIS.manager.GetData_SqlExec(str);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
if (read != null && (read.Rows.Count == 1))
{
if (DropDownList2.SelectedValue == ">")
{
if (Convert.ToInt32(read.Rows[0][0]) > data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == "=")
{
if (Convert.ToInt32(read.Rows[0][0]) == data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == "<")
{
if (Convert.ToInt32(read.Rows[0][0]) < data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
}
else
if (DropDownList2.SelectedValue == ">=")
{
if (Convert.ToInt32(read.Rows[0][0]) >= data)
{
reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);
}
else
{
reader.Rows[i].Delete();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -