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(); }