public static int AddPd(Pd_info pd)
{
string sql = string.Format("insert into pd_info (pd_name) values('{0}')", pd.Pdname);
int ret = Dbhelper.ExecuteNonQuery(sql);
return(ret);
}
private void button1_Click(object sender, EventArgs e)
{
Pd_info pd = new Pd_info();
pd.Pdname = this.tex_pd.Text;
int ret = PdServices.AddPd(pd);
if (ret > 0)
{
MessageBox.Show("添加成功!");
this.dataGridView1.DataSource = PdServices.getallpd();
}
}
private void button5_Click(object sender, EventArgs e)
{
string str = MessageBox.Show("你确定要删除选中项目吗？", "警告", MessageBoxButtons.YesNo).ToString();
if (str == "Yes")
{
Pd_info pd = new Pd_info();
if (this.dataGridView1.SelectedRows.Count > 0)
{
for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
{
DataGridViewRow dr = dataGridView1.SelectedRows[i];
pd.Pdid = int.Parse(dr.Cells[1].Value.ToString());
int ret = PdServices.DlePd(pd);
if (ret > 0)
{
}
else
{
MessageBox.Show(string.Format("第{0}条删除失败！", i + 1));
}
}
}
else
{
DataGridViewCell dc = this.dataGridView1.SelectedCells[0];
// DataGridViewRow dr = dc.RowNumber;
// dc = dr.Cells[0];
DataGridViewRow dr = dc.OwningRow;
pd.Pdid = int.Parse(dr.Cells[1].Value.ToString());
// MessageBox.Show(pd.Pdid.ToString());
int ret = PdServices.DlePd(pd);
if (ret > 0)
{
}
else
{
MessageBox.Show("操作失败！");
}
}
MessageBox.Show("操作成功！");
this.dataGridView1.DataSource = PdServices.getallpd();
}
}
public static List <Pd_info> getallpd()
{
string sql = "select * from pd_info";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <Pd_info> list = new List <Pd_info>();
if (dr != null)
{
while (dr.Read())
{
Pd_info pd = new Pd_info();
pd.Pdname = dr[1].ToString();
pd.Pdid = int.Parse(dr[0].ToString());
list.Add(pd);
}
dr.Close();
}
return(list);
}
public static int DlePd(Pd_info pd)
{
string sql = string.Format("delete from pd_info where pd_id={0}", pd.Pdid);
return(Dbhelper.ExecuteNonQuery(sql));
}
public static int UpdatePd(Pd_info pd)
{
string sql = string.Format("update pd_info set pd_name='{0}' where pd_id={1}", pd.Pdname, pd.Pdid);
return(Dbhelper.ExecuteNonQuery(sql));
}
