private void DataGridzjz_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
try
{
DataGridzjz.EditItemIndex=e.Item.ItemIndex;
Buttoncx_Click(null,null);
string dw =e.Item.Cells[0].Text;
string pz =e.Item.Cells[2].Text;
pzzj.Open();
OracleCommand dwCmd=new OracleCommand("select FACTORYID from bm_dwbmb where FACTORYname='"+dw+"'",pzzj.MyConn);
OracleDataReader dr1=dwCmd.ExecuteReader();
while(dr1.Read())
{
dw=dr1["FACTORYID"].ToString();
}
OracleCommand Cmd=new OracleCommand("select VarietyID from bm_pzbm2 where Variety='"+pz+"'",pzzj.MyConn);
OracleDataReader dr=Cmd.ExecuteReader();
while(dr.Read())
{
pz=dr["VarietyID"].ToString();
}
//Response.Write("delete from jc_scdwpzgxb where FactoryID='"+dw+"' and VarietyID='"+pz+"'");
OracleCommand ryzjCmd = new OracleCommand("delete from jc_scdwpzgxb where FactoryID='"+dw+"' and VarietyID='"+pz+"'", pzzj.MyConn);
ryzjCmd.CommandType = CommandType.Text;
ryzjCmd.ExecuteNonQuery();
DataGridzjz.EditItemIndex=-1;
Buttoncx_Click(null,null);
Response.Write("<Script Language=\"javascript\">\n");
Response.Write("alert(\"操作完成!!\")\n");
Response.Write("</Script>");
}
catch
{
Session.Abandon();
Response.Write("<script>top.location.href=\"500error.aspx\";</script>");
}
finally
{
pzzj.Close();
}
Button1_Click(null,null);
}
CENTER><IMG SRC='http://www.cz88.net/ip/pic_1.aspx' BORDER='0'></IMG></CENTER>