函数newbutton_Click
private void newbutton_Click(object sender, System.EventArgs e)
{
emp em=new emp();
em.xm=this.xm.Text;
if(empOperate.insertOperate(em))
{
if(empOperate.findemp(em.xm,em.xb))
{
Response.Write("<script defer>alert('新建成功!')</script>");
}
else
{
Response.Write("<script defer>alert('该文件已存在!')</script>");
}
}
else
{
Response.Write("<script defer>alert('新建失败!')</script>");
}
}
函数findemp
public static bool findemp(string xm,string xb)
{
SqlConnection con=Db.createConnection();
con.Open();
SqlCommand cmd=new SqlCommand("select count(*) from employee where xm='"+xm+"' and xb='"+xb+"",con);
int count=Convert.ToInt32(cmd.ExecuteScalar());
if(count>0)
{
return true;
}
else
{
return false;
}
}
函数insertOperate
public static bool insertOperate(emp em)
{
try
{
SqlConnection con=Db.createConnection();
con.Open();
SqlCommand cmd=new SqlCommand("insert into employee (xm,xb) values(@xm,@xb)",con);
SqlParameter para=new SqlParameter("@xm",SqlDbType.Char,20);
para.Value=em.xm;
cmd.Parameters.Add(para);
para=new SqlParameter("@xb",SqlDbType.Char,2);
para.Value=em.xb;
cmd.Parameters.Add(para);
return true; }
catch (Exception e)
{
Console.Write(e.ToString());//调试的时候可以在IDE里看到错误信息
return false;
}
}
运行后总是显示该文件已存在
其实并没有存在啊
请教,这是怎么回事啊
谢谢!
private void newbutton_Click(object sender, System.EventArgs e)
{
emp em=new emp();
em.xm=this.xm.Text;
if(empOperate.insertOperate(em))
{
if(empOperate.findemp(em.xm,em.xb))
{
Response.Write("<script defer>alert('新建成功!')</script>");
}
else
{
Response.Write("<script defer>alert('该文件已存在!')</script>");
}
}
else
{
Response.Write("<script defer>alert('新建失败!')</script>");
}
}
函数findemp
public static bool findemp(string xm,string xb)
{
SqlConnection con=Db.createConnection();
con.Open();
SqlCommand cmd=new SqlCommand("select count(*) from employee where xm='"+xm+"' and xb='"+xb+"",con);
int count=Convert.ToInt32(cmd.ExecuteScalar());
if(count>0)
{
return true;
}
else
{
return false;
}
}
函数insertOperate
public static bool insertOperate(emp em)
{
try
{
SqlConnection con=Db.createConnection();
con.Open();
SqlCommand cmd=new SqlCommand("insert into employee (xm,xb) values(@xm,@xb)",con);
SqlParameter para=new SqlParameter("@xm",SqlDbType.Char,20);
para.Value=em.xm;
cmd.Parameters.Add(para);
para=new SqlParameter("@xb",SqlDbType.Char,2);
para.Value=em.xb;
cmd.Parameters.Add(para);
return true; }
catch (Exception e)
{
Console.Write(e.ToString());//调试的时候可以在IDE里看到错误信息
return false;
}
}
运行后总是显示该文件已存在
其实并没有存在啊
请教,这是怎么回事啊
谢谢!
{
SqlConnection con=Db.createConnection();
con.Open();
SqlCommand cmd=new SqlCommand("insert into employee (xm,xb) values(@xm,@xb)",con);
SqlParameter para=new SqlParameter("@xm",SqlDbType.Char,20);
para.Value=em.xm;
cmd.Parameters.Add(para);
para=new SqlParameter("@xb",SqlDbType.Char,2);
para.Value=em.xb;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();----是不是少了这个?
return true; }
catch (Exception e)
{
Console.Write(e.ToString());//调试的时候可以在IDE里看到错误信息
return false;
}