private void btnquerycode_Click(object sender, EventArgs e)
{
try
{
string sql = string.Format("select * from Pinfo where P_CODE like '%{0}%'and P_info like '%{1}%'", cbCode.Text, txtinfo.Text);
SqlHelper.GetReader(sql);
List <Pinfo_class> info = new List <Pinfo_class>();
foreach (Pinfo_class item in SqlHelper.GetReader(sql))
{
Pinfo_class pclass = new Pinfo_class()
{
P_Code = item.P_Code,
P_Info = item.P_Info,
P_Answer = item.P_Answer
};
info.Add(pclass);
}
this.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True; //自动换行
this.dataGridView1.DataSource = info;
}
catch (Exception ex)
{
MessageBox.Show("异常抛出\n" + ex, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtcode.TextLength == 0)
{
MessageBox.Show("请输入错误代码！！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtcode.Focus();
return;
}
else if (txtinfo.TextLength == 0)
{
MessageBox.Show("请输入错误提示信息！！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtinfo.Focus();
return;
}
else if (txtanswer.TextLength == 0)
{
MessageBox.Show("请输入解决方法！！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtanswer.Focus();
return;
}
List <Pinfo_class> info = new List <Pinfo_class>();
Pinfo_class objinfo = new Pinfo_class()
{
P_Code = txtcode.Text.Trim(),
P_Info = txtinfo.Text.Trim(),
P_Answer = txtanswer.Text.Trim()
};
info.Add(objinfo);
string sql = "";
try
{
foreach (Pinfo_class item in info)
{
sql = string.Format("insert into Pinfo VALUES(newID(),'{0}','{1}','{2}')", item.P_Code, item.P_Info, item.P_Answer);
int result = SqlHelper.Update(sql);
}
this.dataGridView1.DataSource = info;
}
catch (Exception ex)
{
MessageBox.Show("未能完成该操作" + ex, "错误信息");
}
}