C#程序设计家庭账单管理系统.docx
- 文档编号:27020739
- 上传时间:2023-06-25
- 格式:DOCX
- 页数:22
- 大小:66.71KB
C#程序设计家庭账单管理系统.docx
《C#程序设计家庭账单管理系统.docx》由会员分享,可在线阅读,更多相关《C#程序设计家庭账单管理系统.docx(22页珍藏版)》请在冰豆网上搜索。
C#程序设计家庭账单管理系统
C#程序设计作业
——家庭账本管理系统
系别
计算机与通信工程学院
专业
计算机科学有技术
班级
4110415
姓名
张振
一、程序说明
课题为:
家庭账单系统;
使用工具:
visualstudio2013系统用户名:
zhangzhen密码:
12345
经上网查找资料,最终确定该系统应有以下几个功能:
1)登陆,注册功能
2)成员管理功能,包括修改资料,添加成员等
3)最核心的消费记录管理功能,包括添加纪录,查看今天记录,本周记录等
程序有四个主要的界面:
1)登陆、注册界面
2)用户管理界面
主要功能包括修改资料、添加成员等,当然从此界面可以查看消费记录,退出系统等
3)消费记录界面
主要功能包括添加纪录、查看各个时间段消费记录的功能,当然可以进入成员管理界面和退出系统
4)消费记录管理界面
主要是添加消费记录的功能。
二、核心代码
1)成员管理界面
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespacehome
{
publicpartialclassForm2:
Form
{
publicintcount,pagecount,pagesize,page;
datadataconn=newdata();
publicForm2()
{
InitializeComponent();
stringcname=Fame;
this.label1.Text="用户:
"+cname+"-天天好心情哦!
~";
page=1;
pagesize=12;
getpagecount();
DataSetds=dataconn.getlist("selecttop"+pagesize+"username,password,cname,birthday,idfromcuserorderbyidasc");
this.dataGridView1.DataSource=ds.Tables[0].DefaultView;
this.dataGridView1.Columns[0].HeaderText="用户名";
this.dataGridView1.Columns[1].HeaderText="密码";
this.dataGridView1.Columns[2].HeaderText="姓名";
this.dataGridView1.Columns[3].HeaderText="生日";
this.dataGridView1.Columns[4].Visible=false;
DataGridViewButtonColumnbtn1=newDataGridViewButtonColumn();
btn1.HeaderText="";
btn1.Text="修改";
btn1.Name="edit";
btn1.Width=60;
btn1.UseColumnTextForButtonValue=true;
this.dataGridView1.Columns.Add(btn1);
DataGridViewButtonColumnbtn=newDataGridViewButtonColumn();
btn.HeaderText="";
btn.Text="删除";
btn.Name="del";
btn.Width=60;
btn.UseColumnTextForButtonValue=true;
this.dataGridView1.Columns.Add(btn);
this.dataGridView1.RowPostPaint+=newDataGridViewRowPostPaintEventHandler(DrawRowIndex);
this.dataGridView1.CellFormatting+=newDataGridViewCellFormattingEventHandler(dataGridView1_CellFormatting);
this.button1.Enabled=false;
this.button2.Enabled=false;
if(pagecount>page)
{
this.button1.Enabled=true;
}
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
kk
(1);
}
publicvoidgetpagecount()
{
DataSetdw=dataconn.getlist("select*fromcuser");
count=dw.Tables[0].Rows.Count;
if(count%pagesize==0)
{
pagecount=count/pagesize;
}
else
{
pagecount=count/pagesize+1;
}
this.label2.Text="共"+pagecount.ToString()+"页当前第"+page.ToString()+"页";
}
publicvoidkk(intss)
{
if(ss==0)
{
page-=1;
}
else
{
page+=1;
}
getpagecount();
stringsql="";
if(page<=1)
{
page=1;
sql="selecttop"+pagesize+"username,password,cname,birthday,idfromcuserorderbyidasc";
this.button2.Enabled=false;
if(pagecount>page)
{
this.button1.Enabled=true;
}
}
elseif(page>=pagecount)
{
sql="selecttop"+pagesize+"username,password,cname,birthday,idfromcuserwhereid>(selectmax(id)from(selecttop"+pagesize*(page-1)+"idfromcuserorderbyidasc)astem)";
if(pagecount>1)
{
this.button2.Enabled=true;
}
this.button1.Enabled=false;
}
else
{
sql="selecttop"+pagesize+"username,password,cname,birthday,idfromcuserwhereid>(selectmax(id)from(selecttop"+pagesize*(page-1)+"idfromcuserorderbyidasc)astem)";
this.button2.Enabled=true;
this.button1.Enabled=true;
}
DataSetds=dataconn.getlist(sql);
this.dataGridView1.DataSource=ds.Tables[0].DefaultView;
}
privatevoidbutton2_Click(objectsender,EventArgse)
{
kk(0);
}
privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse)
{
if(dataGridView1.Columns[e.ColumnIndex].Name=="del")
{
intid=Convert.ToInt16(dataGridView1.Rows[e.RowIndex].Cells[6].Value);
if(id==1)
{
MessageBox.Show("怎么能够删除创始人呢!
","友情提示");
return;
}
else
{
dataconn.update("deletefromcuserwhereid="+id);
MessageBox.Show("成功删除一个成员!
","友情提示");
page=2;
getpagecount();
kk(0);
}
}
if(dataGridView1.Columns[e.ColumnIndex].Name=="edit")
{
useruserfrm=newuser(this.dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString(),this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(),this.dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(),this.dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString(),this.dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString(),this);
userfrm.ShowDialog();
}
}
privatevoidForm2_FormClosing(objectsender,FormClosingEventArgse)
{
Application.Exit();
}
privatevoidbutton3_Click(objectsender,EventArgse)
{
useruserfrm=newuser("0","","","",DateTime.Now.Date.ToString(),this);
userfrm.ShowDialog();
}
privatevoidbutton4_Click(objectsender,EventArgse)
{
Form3frm3=newForm3();
frm3.Show();
this.Hide();
}
privatevoidbutton5_Click(objectsender,EventArgse)
{
intuid=Form1.uid;
SqlDataReaderdr=dataconn.read("select*fromcuserwhereid="+uid);
while(dr.Read())
{
useruserfrm=newuser(uid.ToString(),dr["username"].ToString(),dr["password"].ToString(),dr["cname"].ToString(),dr["birthday"].ToString(),this);
userfrm.ShowDialog();
}
dr.Close();
}
privatevoidbutton6_Click(objectsender,EventArgse)
{
Application.Exit();
}
privatevoidDrawRowIndex(objectsender,DataGridViewRowPostPaintEventArgse)
{
Rectanglerectangle=newRectangle(e.RowBounds.Location.X,
e.RowBounds.Location.Y,
this.dataGridView1.RowHeadersWidth-4,
e.RowBounds.Height);
TextRenderer.DrawText(e.Graphics,(e.RowIndex+1).ToString(),
this.dataGridView1.RowHeadersDefaultCellStyle.Font,
rectangle,
this.dataGridView1.RowHeadersDefaultCellStyle.ForeColor,
TextFormatFlags.VerticalCenter|TextFormatFlags.Right);
}
privatevoiddataGridView1_CellFormatting(objectsender,DataGridViewCellFormattingEventArgse)
{
if(e.ColumnIndex==3)
{
if(e.Value!
=null&&e.Value.ToString().Length>0)
{
e.Value=newstring('$',e.Value.ToString().Length);
}
}
}
}
}
2)消费记录管理界面
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Drawing.Imaging;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
usingSystem.Collections;
namespacehome
{
publicpartialclassForm3:
Form
{
datadataconn=newdata();
publicintpagesize,count,pagecount,page;
publicstringkey="";
publicstringjlsql="";
publicstringpsql="";
publicForm3()
{
InitializeComponent();
pagesize=22;
page=1;
getpagecount();
DataSetds=dataconn.getlist("selecttop"+pagesize+"*fromcordsorderbyiddesc");
this.dataGridView1.DataSource=ds.Tables[0].DefaultView;
this.dataGridView1.Columns[0].Visible=false;
this.dataGridView1.Columns[1].HeaderText="产品名称";
this.dataGridView1.Columns[2].HeaderText="类型";
this.dataGridView1.Columns[3].HeaderText="单价";
this.dataGridView1.Columns[4].HeaderText="费用";
this.dataGridView1.Columns[5].HeaderText="日期";
this.dataGridView1.Columns[6].HeaderText="星期";
this.dataGridView1.Columns[7].HeaderText="消费者";
this.dataGridView1.Columns[8].HeaderText="备注";
DataGridViewButtonColumnbtn1=newDataGridViewButtonColumn();
btn1.HeaderText="";
btn1.Text="修改";
btn1.Name="edit";
btn1.Width=60;
btn1.UseColumnTextForButtonValue=true;
this.dataGridView1.Columns.Add(btn1);
DataGridViewButtonColumnbtn=newDataGridViewButtonColumn();
btn.HeaderText="";
btn.Text="删除";
btn.Name="del";
btn.SortMode=DataGridViewColumnSortMode.NotSortable;
btn.Width=60;
btn.UseColumnTextForButtonValue=true;
this.dataGridView1.Columns.Add(btn);
this.dataGridView1.RowPostPaint+=newDataGridViewRowPostPaintEventHandler(DrawRowIndex);
this.button1.Enabled=false;
this.button2.Enabled=false;
if(pagecount>page)
{
this.button1.Enabled=true;
}
getcords();
SqlDataReaderdr1=dataconn.read("select*fromptype");
ArrayListlist=newArrayList();
list.Add(newDictionaryEntry("所有类型",""));
if(dr1.HasRows)
{
while(dr1.Read())
{
list.Add(newDictionaryEntry(dr1["ptype"].ToString(),dr1["ptype"].ToString()));
}
this.ptype.DataSource=list;
this.ptype.DisplayMember="key";
this.ptype.ValueMember="value";
}
dr1.Close();
}
publicvoidkk(intss)
{
if(ss==0)
{
page-=1;
}
else
{
page+=1;
}
getpagecount();
stringkeysql="";
keysql="andproductlike'%"+key+"%'";
stringsql="";
if(page<=1)
{
page=1;
sql="selecttop"+pagesize+"*fromcordswhereidisnotnull"+keysql+jlsql+psql+"orderbyctimedesc";
this.button2.Enabled=false;
if(pagecount>page)
{
this.button1.Enabled=true;
}
}
elseif(page>=pagecount)
{
sql="selecttop"+pagesize+"*fromcordswherectime<(selectmin(ctime)from(selecttop"+(page-1)*pagesize+"ctimefromcordsorderbyctimedesc)astemp)orderbyctimedesc";
if(pagecount>1)
{
this.button2.Enabled=true;
}
this.button1.Enabled=false;
}
else
{
sql="selecttop"+pagesize+"*fromcordswherectime<(selectmin(ctime)from(selecttop"+(page-1)*pagesize+"ctimefromcordsorderbyctimedesc)astemp)orderbyctimedesc";
this.button2.Enabled=true;
this.button1.Enabled=true;
}
DataSetds=dataconn.getlist(sql);
this.dataGridView1.DataSource=ds.Tables[0].DefaultView;
getcords();
SqlDataReaderdr1=dataconn.read("select*fromptype");
ArrayListlist=newArrayList();
list.Add(newDictionaryEntry("所有类型",""));
if(dr1.HasRows)
{
while(dr1.Read())
{
li
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- C# 程序设计 家庭 账单 管理 系统