1.对着Model项目名点右键,选择,添加类。
2.新建类-userinfo
3.编写userinfo类的代码
根据数据库字段设计类,每个数据库字段对应一个类的字段。然后,为每一个字段编写一个公有属性。注意类要设置为public的。
using System;
namespace Model
{
/// <summary>
/// userInfo:实体类(用户信息)
/// </summary>
[Serializable]
public class userInfo
{
public userInfo()
{}
#region Model
private int _customerid;
private string _customername;
private string _pid;
private string _telephone;
private string _address;
/// <summary>
/// 客户编号
/// </summary>
public int customerID
{
set{ _customerid=value;}
get{return _customerid;}
}
/// <summary>
/// 客户姓名
/// </summary>
public string customerName
{
set{ _customername=value;}
get{return _customername;}
}
/// <summary>
/// 身份证号
/// </summary>
public string pID
{
set{ _pid=value;}
get{return _pid;}
}
/// <summary>
/// 电话
/// </summary>
public string telephone
{
set{ _telephone=value;}
get{return _telephone;}
}
/// <summary>
/// 地址
/// </summary>
public string address
{
set{ _address=value;}
get{return _address;}
}
#endregion Model
}
}
4.创建并编写cardinfo类
using System;
namespace Model
{
/// <summary>
/// cardinfo:实体类(银行卡信息)
/// </summary>
[Serializable]
public class cardinfo
{
public cardinfo()
{}
#region Model
private string _cardid;
private string _curtype="RMB";
private string _savingtype;
private DateTime _opendate= DateTime.Now;
private decimal _openmoney=0M;
private decimal _balance=0M;
private string _pass= "888888";
private bool _isreportloss= false;
private int _customerid;
/// <summary>
/// 银行卡号
/// </summary>
public string cardID
{
set{ _cardid=value;}
get{return _cardid;}
}
/// <summary>
/// 货币类型
/// </summary>
public string curType
{
set{ _curtype=value;}
get{return _curtype;}
}
/// <summary>
/// 存款类型 活期/定活两便/定期
/// </summary>
public string savingType
{
set{ _savingtype=value;}
get{return _savingtype;}
}
/// <summary>
/// 开户日期
/// </summary>
public DateTime openDate
{
set{ _opendate=value;}
get{return _opendate;}
}
/// <summary>
/// 开户金额
/// </summary>
public decimal openMoney
{
set{ _openmoney=value;}
get{return _openmoney;}
}
/// <summary>
/// 账户余额
/// </summary>
public decimal balance
{
set{ _balance=value;}
get{return _balance;}
}
/// <summary>
/// 密码
/// </summary>
public string pass
{
set{ _pass=value;}
get{return _pass;}
}
/// <summary>
/// 是否已挂失
/// </summary>
public bool IsReportLoss
{
set{ _isreportloss=value;}
get{return _isreportloss;}
}
/// <summary>
/// 客户编号
/// </summary>
public int customerID
{
set{ _customerid=value;}
get{return _customerid;}
}
#endregion Model
}
}
5.创建并编写transinfo类
using System;
namespace Model
{
/// <summary>
/// transInfo:实体类(交易信息)
/// </summary>
[Serializable]
public class transInfo
{
public transInfo()
{}
#region Model
private DateTime _transdate= DateTime.Now;
private string _cardid;
private string _transtype;
private decimal _transmoney;
private string _remark;
/// <summary>
/// 交易日期
/// </summary>
public DateTime transDate
{
set{ _transdate=value;}
get{return _transdate;}
}
/// <summary>
/// 银行卡号
/// </summary>
public string cardID
{
set{ _cardid=value;}
get{return _cardid;}
}
/// <summary>
/// 交易类型 存入/支取
/// </summary>
public string transType
{
set{ _transtype=value;}
get{return _transtype;}
}
/// <summary>
/// 交易金额
/// </summary>
public decimal transMoney
{
set{ _transmoney=value;}
get{return _transmoney;}
}
/// <summary>
/// 备注
/// </summary>
public string remark
{
set{ _remark=value;}
get{return _remark;}
}
#endregion Model
}
}