//
public static bool AddUsage(UsageItem item)
{
string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=""E:\c++练习\MyMoneyAgent - 副本 (2) - 副本\MyMoneyAgent\MyMoney.mdf"";Integrated Security=True";
SqlConnection conn = new SqlConnection(connString);//创建链接对象
try
{
conn.Open();
//执行删除命令
string cmdTxt = string.Format("INSERT INTO [用途表] VALUES('{0}','{1}')",
item.Usage, item.Description);
SqlCommand comm = new SqlCommand(cmdTxt, conn);
comm.ExecuteNonQuery();
return(true);
}
catch (Exception)
{
return(false);
}
finally
{
//关闭连接
conn.Close();
}
}
private void btnDelUse_Click(object sender, EventArgs e)
{
//如果没有选中任何用途，则不删除，直接退出
if (this.lstUsage.SelectedItem == null)
{
return;
}
//获取选中的用途
UsageItem item = (UsageItem)this.lstUsage.SelectedItem;
//通过BankCardAccessor删除用途
if (BankCardSQL.DeleteUsage(item.Usage))
{
this.btnLoadUse_Click(null, null);
//删除成功提示成功
MessageBox.Show(this, "删除用途:" + item.Usage + ",成功！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
//删除失败，提示失败
MessageBox.Show(this, "删除用途:" + item.Usage + ",失败！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//
public static List <UsageItem> LoadUseageList()
{
string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=""E:\c++练习\MyMoneyAgent - 副本 (2) - 副本\MyMoneyAgent\MyMoney.mdf"";Integrated Security=True";
SqlConnection conn = new SqlConnection(connString);//创建链接对象
try
{
conn.Open();
//查询数据库中
string cmdTxt = "SELECT [用途], [说明] FROM [用途表] ";
SqlCommand comm = new SqlCommand(cmdTxt, conn);
SqlDataReader dr;
dr = comm.ExecuteReader();
List <UsageItem> usageLst = new List <UsageItem>();
while (dr.Read())
{
UsageItem item = new UsageItem();
item.Usage = dr.GetString(0);
item.Description = dr.GetString(1);
usageLst.Add(item);
}
return(usageLst);
}
catch (Exception)
{
return(null);
}
finally
{
//关闭连接
conn.Close();
}
}
private void lstUsage_SelectedIndexChanged(object sender, EventArgs e)
{
//如果有选中的用途，则更新
if (this.lstUsage.SelectedItem != null)
{
//获取选中的用途
UsageItem item = (UsageItem)this.lstUsage.SelectedItem;
//将用途的名称和说明显示到界面
this.tbUsage.Text = item.Usage;
this.tbUsageDes.Text = item.Description;
}
}
private void btnAddUse_Click(object sender, EventArgs e)
{
//检查用途名称的合法性
if (string.IsNullOrEmpty(this.tbUsage.Text))
{
MessageBox.Show(this, "请输入正确的用途名称，不能已经存在，也不能为空！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//检查用途说明的合法性
if (string.IsNullOrEmpty(this.tbUsageDes.Text))
{
MessageBox.Show(this, "请输入正确的用途说明，不能为空！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//创建用途对象
UsageItem item = new UsageItem();
//获取新用途数据
item.Usage = this.tbUsage.Text.Trim();
item.Description = this.tbUsageDes.Text.Trim();
//添加到数据库
if (BankCardSQL.AddUsage(item))
{
//重新加载用途列表
this.btnLoadUse_Click(null, null);
//删除成功提示成功
MessageBox.Show(this, "添加用途:" + item.Usage + ",成功！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
//删除成功提示成功
MessageBox.Show(this, "添加用途:" + item.Usage + ",失败！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
