protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string what = GridView1.Rows[e.RowIndex].Cells[1].Text;
MiniBli.sqlUse delete = new MiniBli.sqlUse();
string table = "AspNetUsers";
string sql = $"delete from {table} where Id = '{what}' ";
int i = delete.doDelete(sql);
if (i != 0)
{
BindData();
}
Response.Write("<script>alert('删除成功！');</script>");
}
protected void SearchVideo_Click(object sender, EventArgs e)
{
MiniBli.sqlUse search = new MiniBli.sqlUse();
string table = "Video";
string key = "";
switch (DropDownList2.SelectedValue)
{
case "ID":
key = "Id";
break;
case "标题":
key = "Title";
break;
case "分类":
key = "Type";
break;
case "上传者":
key = "Upuser";
break;
default:
break;
}
string what = TextBox2.Text;
DataTable dt = new DataTable();
if (TextBox2.Text != "")
{
dt = search.doSearch(table, key, what, "", "Id,Title,type,upuser,theupdate,info");
}
else
{
dt = search.doSearch("select Id,Title,type,upuser,theupdate,info from Video");
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string what = GridView1.Rows[e.RowIndex].Cells[1].Text;
MiniBli.sqlUse delete = new MiniBli.sqlUse();
string table = "Video";
DataTable dt = delete.doSearch($"search location from {table} where Id = {what}");
string loc = dt.Rows[0]["location"].ToString();
string str = "del /s /f /q " + loc;
System.Diagnostics.Process p = new System.Diagnostics.Process();
p.StartInfo.FileName = "cmd.exe";
p.StartInfo.UseShellExecute = false; //是否使用操作系统shell启动
p.StartInfo.RedirectStandardInput = true; //接受来自调用程序的输入信息
p.StartInfo.RedirectStandardOutput = true; //由调用程序获取输出信息
p.StartInfo.RedirectStandardError = true; //重定向标准错误输出
p.StartInfo.CreateNoWindow = true; //不显示程序窗口
p.Start(); //启动程序
//向cmd窗口发送输入信息
p.StandardInput.WriteLine(str + "&exit");
p.StandardInput.AutoFlush = true;
string output = p.StandardOutput.ReadToEnd();
p.WaitForExit();//等待程序执行完退出进程
p.Close();
string sql = $"delete from {table} where Id = '{what}' ";
int i = delete.doDelete(sql);
if (i != 0)
{
BindData();
}
Console.WriteLine(output);
Response.Write("<script>alert('删除成功！');</script>");
}
protected void SearchUser_Click(object sender, EventArgs e)
{
MiniBli.sqlUse search = new MiniBli.sqlUse();
string table = "AspNetUsers";
string key = "";
switch (DropDownList1.SelectedValue)
{
case "ID":
key = "Id";
break;
case "用户名":
key = "UserName";
break;
case "昵称":
key = "NickName";
break;
default:
break;
}
string what = TextBox1.Text + "' and UserName != 'Admin";
DataTable dt = new DataTable();
if (TextBox1.Text != "")
{
dt = search.doSearch(table, key, what, "", "Id,UserName,NickName,Email,PhoneNumber");
}
else
{
dt = search.doSearch($"select Id,UserName,NickName,Email,PhoneNumber from {table} where UserName != 'Admin'");
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
GridView1.DataSource = ds;
GridView1.DataBind();
}
