windows mobile 5编程体验2

最新推荐文章于 2025-05-23 10:38:48 发布

转载最新推荐文章于 2025-05-23 10:38:48 发布 · 134 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://blog.51cto.com/leelei/381289

文章标签：

#数据库 #操作系统

本文介绍了一款基于SQL Server Compact Edition的欠债还钱管理系统的设计与实现过程。该系统包括数据库设计、智能设备项目的创建及界面编程等内容，并提供了详细的代码示例。

今天没事干，就练练手，做一个简单的欠债还钱系统。首先我们在SQLServer 2008上设计好数据库。打开SQLServer 2008 Management studio。服务器类型选择SQL Server Compact Edition。

数据库文件选项选择新建数据库。ok我们新建一个名为Debt的数据库文件，我们再新建一个名为为DebtInfo的表。如下

好了，ok接下来就进入我们的编程环节。我们新建一个智能设备项目，名为DebtSystem。新建两个窗体。

为了编程我在次写了一个简单的公共类，用来执行sql。

using System;
using System.Linq;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlServerCe;
namespace DebtSystem
{
public class DBHelperSQL
{
private static string connectionString = "Data Source=\\Program Files\\Debt.sdf;Password=123asd";
public DBHelperSQL()
{
}
/// <summary>
/// 根据sql语句查询
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns></returns>
public static DataTable GetQueryResult(string sql)
{
using (SqlCeConnection sqlCeConnection = new SqlCeConnection(connectionString))
{
SqlCeDataAdapter sqlDataAdapter = new SqlCeDataAdapter(sql, sqlCeConnection);
DataSet ds = new DataSet();
sqlDataAdapter.Fill(ds);
return ds.Tables[0];
}
}
public static int ExecuteSql(string sql)
{
using (SqlCeConnection sqlCeConnection = new SqlCeConnection(connectionString))
{
SqlCeCommand sqlCeCommand = new SqlCeCommand(sql,sqlCeConnection);
sqlCeConnection.Open();
int rowAffect = sqlCeCommand.ExecuteNonQuery();
sqlCeConnection.Close();
return rowAffect;
}
}
}
}

好了，接下来设计界面。如下第一个界面是欠债信息查询，选项卡可以切换功能。还有就是增加功能

下面是代码，首先是DebtInfo.cs

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;
namespace DebtSystem
{
public partial class DebtInfo : Form
{
public DebtInfo()
{
InitializeComponent();
}
private void DebtInfo_Load(object sender, EventArgs e)
{
string sql = "select * from DebtInfo";
string sql1 = "select * from DebtInfo where repaytime>'"+DateTime.Now+"' and isrepayed=0";
DataTable dt = DBHelperSQL.GetQueryResult(sql);
this.SetHeaderText(dt);
DataTable dt1 = DBHelperSQL.GetQueryResult(sql1);
this.SetHeaderText(dt1);
this.dataGridDebtInfo.DataSource = dt.DefaultView;
this.dataGridDebtQueryInfo.DataSource = dt.DefaultView;
this.dataGridAlarm.DataSource = dt1.DefaultView;
dateTimePicker1.Value = DateTime.Now.AddYears(-1);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string sqlWhere = string.Empty;
string sql = "select * from DebtInfo";
if (!string.IsNullOrEmpty(txtName.Text))
{
sqlWhere = sqlWhere == string.Empty ? string.Empty:" where debtpersonid like '%" + txtName.Text + "%'" ;
}
if (dateTimePicker1.Value.CompareTo(dateTimePicker2.Value) > 0)
{
MessageBox.Show("起始日期不能大于结束日期", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
return;
}
else
{
sqlWhere = sqlWhere == string.Empty ? " where repaytime between '"
+ dateTimePicker1.Value.Year.ToString().Substring(0, 2)
+ dateTimePicker1.Value.ToShortDateString()
+ "' and '" + dateTimePicker2.Value.Year.ToString().Substring(0,2)
+dateTimePicker2.Value.ToShortDateString() + "'" : " and repaytime between '"
+ dateTimePicker1.Value.Year.ToString().Substring(0, 2)+dateTimePicker1.Value.ToShortDateString() + "' and '"
+ dateTimePicker2.Value.Year.ToString().Substring(0,2)+dateTimePicker2.Value.ToShortDateString() + "'";
}
DataTable dt = DBHelperSQL.GetQueryResult(sql+sqlWhere);
this.SetHeaderText(dt);
this.dataGridDebtQueryInfo.DataSource = dt;
}
catch
{
MessageBox.Show("查询出错", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
}
private void SetHeaderText(DataTable dt)
{
dt.Columns["debtpersonId"].ColumnName = "欠债人";
dt.Columns["amount"].ColumnName = "金额";
dt.Columns["borrowmoneytime"].ColumnName = "借钱日";
dt.Columns["repaytime"].ColumnName = "还钱日";
dt.Columns["isrepayed"].ColumnName = "是否已还款";
}
private void menuItem7_Click(object sender, EventArgs e)
{
Add add = new Add();
add.ShowDialog();
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
DebtInfo_Load(sender,e);
}
}
}

再看看Add.cs

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;
namespace DebtSystem
{
public partial class Add : Form
{
public Add()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtDebtPerson.Text == string.Empty)
{
ShowMessage("欠债人姓名不能为空");
return;
}
if (txtAmount.Text == string.Empty)
{
ShowMessage("金额不能为空");
return;
}
else
{
Regex reg = new Regex("^\\d+(\\.\\d+)?$");
if (!reg.IsMatch(txtAmount.Text))
{
ShowMessage("金额错误");
return;
}
}
if (dateTimePicker1.Value.CompareTo(dateTimePicker2.Value)>=0)
{
ShowMessage("借钱时间不能大于等于还钱时间");
return;
}
try
{
string id=Guid.NewGuid().ToString().Replace("-","");
string sql = "insert into debtInfo values('"
+ id + "','"
+ txtDebtPerson.Text + "',"
+ txtAmount.Text + ",'"
+ dateTimePicker1.Value.Year.ToString().Substring(0,2)+dateTimePicker1.Value + "','"
+ dateTimePicker2.Value.Year.ToString().Substring(0, 2) + dateTimePicker2.Value + "','"
+ (radioButton2.Text=="已还"? 1:0) + "','"
+ (txtRemark.Text == string.Empty ? "无" : txtRemark.Text)+"')";
int x = DBHelperSQL.ExecuteSql(sql);
if (x > 0)
{
ShowMessage("添加成功");
}
}
catch(Exception w)
{
ShowMessage(w.Message);
}
}
private void ShowMessage(string msg)
{
MessageBox.Show(msg, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
private void button2_Click(object sender, EventArgs e)
{
foreach (Control ctrl in this.Controls)
{
if (ctrl is TextBox)
{
(ctrl as TextBox).Text = string.Empty;
}
}
}
}
}