public void freshen()
{
string sql = "select * from Storage order by S_ID";
dtInfo = DBHLper.GetTable(sql);
dataGridView1.DataSource = dtInfo;
InitDataSet();
this.label3.Text = "第" + pageCurrent + "页" + "共" + pageCount + "页" + "共" + nMax + "条";
dataGridView1.AllowUserToAddRows = false;
}
//修改
//private void button2_Click(object sender, EventArgs e)
//{
// string PhysicalPath = this.textBox1.Text;
// string StorageName = this.textBox2.Text;
// string sqlstr = string.Format("update Storage set PhysicalPath='{0}' " +
// ",StorageName='{1}' where S_ID={2}", PhysicalPath, StorageName,dgid);
// int num= DBHLper.GetExecuteNonQuery(sqlstr);
// if (num>0)
// {
// MessageBox.Show("修改成功！");
// }
// textBox1.Text = string.Empty;
// textBox2.Text = string.Empty;
// freshen();
//}
//查询
private void bn_c_Click(object sender, EventArgs e)
{
string url = this.tb_url.Text;
string strsql = string.Format("select * from Storage where PhysicalPath like '%{0}%' order by S_ID", url);
dtInfo = DBHLper.GetTable(strsql);
//dtInfo.Compute("PhysicalPath", url);
dataGridView1.DataSource = dtInfo;
InitDataSet();
this.label3.Text = "第" + pageCurrent + "页" + "共" + pageCount + "页" + "共" + nMax + "条";
dataGridView1.AllowUserToAddRows = false;
}
//添加
private void button1_Click(object sender, EventArgs e)
{
string PhysicalPath = this.textBox1.Text;
string StorageName = this.textBox2.Text;
int numsum;
if (tb_num.Text == string.Empty || tb_num == null)
{
numsum = 0;
}
else
{
numsum = Convert.ToInt32(tb_num.Text);
}
if (PhysicalPath == string.Empty || PhysicalPath == "")
{
MessageBox.Show("物理路径不能为空！");
return;
}
if (this.button1.Text == "添加")
{
string sqlstr = string.Format("insert into Storage(PhysicalPath,DeviceID,Num)" +
"values('{0}','{1}',{2})", PhysicalPath, StorageName, numsum);
int num = DBHLper.GetExecuteNonQuery(sqlstr);
if (num > 0)
{
MessageBox.Show("添加成功!");
}
else
{
MessageBox.Show("不能添加相同的数据!");
}
}
//修改
else
{
string sqlstr = string.Format("update Storage set PhysicalPath='{0}' " +
",DeviceID='{1}',num={2} where S_ID={3}", PhysicalPath, StorageName, numsum, dgid);
int num = DBHLper.GetExecuteNonQuery(sqlstr);
if (num > 0)
{
MessageBox.Show("修改成功！");
this.button1.Text = "添加";
}
}
textBox1.Text = string.Empty;
textBox2.Text = string.Empty;
tb_num.Text = string.Empty;
freshen();
}
private void ToolStripMenuItem_Click(object sender, EventArgs e)
{
//dgid = Convert.ToInt32(dataGridView1.Rows[Countid].Cells["S_ID"].Value.ToString());
foreach (DataGridViewRow item in dataGridView1.SelectedRows)
{
ids += dataGridView1.Rows[item.Index].Cells["S_ID"].Value.ToString() + ",";
}
string[] idlist = ids.Split(',');
//if (dgid <= 0)
//{
// MessageBox.Show("未选中任何行！");
// return;
//}
int num = 0;
if (MessageBox.Show("是否删除？", "提示!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
foreach (var item in idlist)
{
string sqlstr = string.Format("Delete From Storage where S_ID ={0}", item);
num = DBHLper.GetExecuteNonQuery(sqlstr);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
MessageBox.Show("删除成功！");
freshen();
}
else
{
return;
//MessageBox.Show("n");
}
}