private void btnDelOutRec_Click(object sender, EventArgs e)
{
//判断是否有选中的记录
if (this.dgvOutRec.SelectedRows.Count == 0)
{
MessageBox.Show(this, "没有选中任何记录！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//获取选中记录的数据
OutRecord rec;
rec = (OutRecord)this.dgvOutRec.SelectedRows[0].Tag;
//再次确认删除操作
if (MessageBox.Show(this, "真的要删除支出记录----" + rec.ID.ToString() + "？", "提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//删除记录
if (OutSQL.DeleteOutRec(this.curUser.Name, rec.ID))
{
//删除成功，从表格移除
this.dgvOutRec.Rows.Remove(this.dgvOutRec.SelectedRows[0]);
}
else
{
//删除失败，则提示
MessageBox.Show(this, "删除支出记录----" + rec.ID.ToString() + ",失败！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void LoadOutRecList()
{
//清除原界面上的数据
this.dgvOutRec.Rows.Clear();
List <OutRecord> recLst;
//从数据库加载支出记录列表
recLst = OutSQL.LoadOutRcdList(this.curUser.Name);
//加载失败，可能是数据库连接不成功，提示
if (recLst == null)
{
MessageBox.Show(this, "加载已有支出记录失败，请确认数据库连接！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//依次显示所有的收入记录到界面
foreach (OutRecord rec in recLst)
{
//添加一行到界面
int newRowIndex = this.dgvOutRec.Rows.Add();
this.dgvOutRec.Rows[newRowIndex].Tag = rec;
//显示信息到新添加的行
this.dgvOutRec.Rows[newRowIndex].Cells["colOutID"].Value = rec.ID;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutTime"].Value = rec.OutTime;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutType"].Value = rec.OutType;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutUsage"].Value = rec.OutUsage;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutRecTime"].Value = rec.RecordTime;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutDes"].Value = rec.Description;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutBank"].Value = rec.BankCard;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutAmount"].Value = rec.Amount;
}
}
private void button1_Click(object sender, EventArgs e)
{
//清除原界面上的数据
this.dgvOutRec.Rows.Clear();
List <OutRecord> recList;
//从数据库加载支出记录列表
/* SqlDataAdapter da = new SqlDataAdapter();
* DataSet ds = new DataSet("MyMoney");
* string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=""E:\c++练习\MyMoneyAgent - 副本 (2) - 副本\MyMoneyAgent\MyMoney.mdf"";Integrated Security=True";
* SqlConnection conn = new SqlConnection(connString);//创建链接对象
*
* conn.Open();
* //查询数据库中
* string cmdTxt = "SELECT [支出编号], [姓名], [支出时间], [记录时间], [支出方式], " +
* "[支出类型], [金额], [银行卡号], [支出说明] FROM [支出记录] ";
* SqlCommand comm = new SqlCommand(cmdTxt, conn);
* da.SelectCommand = comm;
* SqlCommandBuilder builder = new SqlCommandBuilder(da);
* da.Fill(ds, "支出记录");
* dgvOutRec.DataSource = ds.Tables["支出记录"];
* //关闭连接
* conn.Close();*/
recList = OutSQL.LoadOutRcdListSearch(this.curUser.Name, date1.Value.ToString(), date2.Value.ToString());
//加载失败，可能是数据库连接不成功，提示
if (recList == null)
{
MessageBox.Show(this, "加载已有支出记录失败，请确认数据库连接！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//依次显示所有的支出记录到界面
foreach (OutRecord rec in recList)
{
//添加一行到界面
int newRowIndex = this.dgvOutRec.Rows.Add();
this.dgvOutRec.Rows[newRowIndex].Tag = rec;
//显示信息到新添加的行
this.dgvOutRec.Rows[newRowIndex].Cells["colOutID"].Value = rec.ID;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutTime"].Value = rec.OutTime;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutType"].Value = rec.OutType;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutUsage"].Value = rec.OutUsage;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutRecTime"].Value = rec.RecordTime;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutDes"].Value = rec.Description;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutBank"].Value = rec.BankCard;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutAmount"].Value = rec.Amount;
}
}
private void btnAddNewOutRec_Click(object sender, EventArgs e)
{
//创建用来保存新记录的对象
int newId = OutSQL.GetUsableOutID(this.curUser.Name);
if (newId == 0)
{
MessageBox.Show(this, "无法获取可用的支出记录编号，请确保数据库连接正确！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
OutRecord rec = new OutRecord();
rec.ID = newId;
rec.OutTime = DateTime.Now;
rec.RecordTime = DateTime.Now;
//创建支出记录编辑对话框
OutReForm dlg = new OutReForm(this.curUser.Name, rec, false);
if (dlg.ShowDialog(this) == DialogResult.OK)
{
//添加记录成功，则添加到界面
if (OutSQL.AddOutRec(this.curUser.Name, rec))
{
//添加一行到界面
int newRowIndex = this.dgvOutRec.Rows.Add();
this.dgvOutRec.Rows[newRowIndex].Tag = rec;
//显示信息到新添加的行
this.dgvOutRec.Rows[newRowIndex].Cells["colOutID"].Value = rec.ID;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutTime"].Value = rec.OutTime;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutType"].Value = rec.OutType;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutUsage"].Value = rec.OutUsage;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutRecTime"].Value = rec.RecordTime;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutDes"].Value = rec.Description;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutBank"].Value = rec.BankCard;
this.dgvOutRec.Rows[newRowIndex].Cells["colOutAmount"].Value = rec.Amount;
}
else
{
MessageBox.Show(this, "添加记录失败！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void btnModifyOutRec_Click(object sender, EventArgs e)
{
//判断是否有选中的记录
if (this.dgvOutRec.SelectedRows.Count == 0)
{
MessageBox.Show(this, "没有选中任何记录！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//获取支出记录的数据
OutRecord rec;
rec = (OutRecord)this.dgvOutRec.SelectedRows[0].Tag;
//创建可修改对话框
OutReForm orf = new OutReForm(this.curUser.Name, rec, false);
//显示对话框，进行编辑操作
if (orf.ShowDialog(this) == DialogResult.OK)
{
//修改记录成功，则更新指定记录
if (OutSQL.ModifyOutRec(this.curUser.Name, rec))
{
this.dgvOutRec.SelectedRows[0].Cells["colOutID"].Value = rec.ID;
this.dgvOutRec.SelectedRows[0].Cells["colOutTime"].Value = rec.OutTime;
this.dgvOutRec.SelectedRows[0].Cells["colOutType"].Value = rec.OutType;
this.dgvOutRec.SelectedRows[0].Cells["colOutUsage"].Value = rec.OutUsage;
this.dgvOutRec.SelectedRows[0].Cells["colOutRecTime"].Value = rec.RecordTime;
this.dgvOutRec.SelectedRows[0].Cells["colOutDes"].Value = rec.Description;
this.dgvOutRec.SelectedRows[0].Cells["colOutBank"].Value = rec.BankCard;
this.dgvOutRec.SelectedRows[0].Cells["colOutAmount"].Value = rec.Amount;
}
else
{
MessageBox.Show(this, "修改记录失败！", "提示",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}