C#三层架构-12.ATM开户.doc

ATM开户功能1 DAL-userInfoGetModel/ / 用身份证号查询得到一个对象实体/ public Model.userInfo GetModel(string PID) StringBuilder strSql = new StringBuilder(); strSql.Append(select top 1 ); strSql.Append( customerID,customerName,pID,telephone,address ); strSql.Append( from userInfo ); strSql.Append( where pID= + PID + ); Model.userInfo model = new Model.userInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(); if (ds.Tables0.Rows.Count 0) return DataRowToModel(ds.Tables0.Rows0); else return null; / / 得到一个对象实体/ public Model.userInfo DataRowToModel(DataRow row)Model.userInfo model=new Model.userInfo();if (row != null)if(rowcustomerID!=null & rowcustomerID.ToString()!=)model.customerID=int.Parse(rowcustomerID.ToString();if(rowcustomerName!=null)model.customerName=rowcustomerName.ToString();if(rowpID!=null)model.pID=rowpID.ToString();if(rowtelephone!=null)model.telephone=rowtelephone.ToString();if(rowaddress!=null)model.address=rowaddress.ToString();return model;2 DAL-userInfoAdd/ / 增加一条数据 / public int Add(Model.userInfo model)StringBuilder strSql=new StringBuilder();StringBuilder strSql1=new StringBuilder();StringBuilder strSql2=new StringBuilder();if (model.customerName != null)strSql1.Append(customerName,);strSql2.Append(+model.customerName+,);if (model.pID != null)strSql1.Append(pID,);strSql2.Append(+model.pID+,);if (model.telephone != null)strSql1.Append(telephone,);strSql2.Append(+model.telephone+,);if (model.address != null)strSql1.Append(address,);strSql2.Append(+model.address+,);strSql.Append(insert into userInfo();strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1);strSql.Append();strSql.Append( values ();strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1);strSql.Append();strSql.Append(;select IDENTITY);object obj = DbHelperSQL.GetSingle(strSql.ToString();if (obj = null)return 0;elsereturn Convert.ToInt32(obj);3 DAL- transInfoAdd （若此方法已经有了，就不要加了）/ / 增加一条数据/ public bool Add(Model.transInfo model)StringBuilder strSql=new StringBuilder();StringBuilder strSql1=new StringBuilder();StringBuilder strSql2=new StringBuilder();if (model.transDate != null)strSql1.Append(transDate,);strSql2.Append(+model.transDate+,);if (model.cardID != null)strSql1.Append(cardID,);strSql2.Append(+model.cardID+,);if (model.transType != null)strSql1.Append(transType,);strSql2.Append(+model.transType+,);if (model.transMoney != null)strSql1.Append(transMoney,);strSql2.Append(+model.transMoney+,);if (model.remark != null)strSql1.Append(remark,);strSql2.Append(+model.remark+,);strSql.Append(insert into transInfo();strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1);strSql.Append();strSql.Append( values ();strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1);strSql.Append();int rows=DbHelperSQL.ExecuteSql(strSql.ToString();if (rows 0)return true;elsereturn false;4 DAL- cardinfoAdd / / 获取最新开卡人的账号 / / public string getMaxCardID() string s = ; string sql = select top 1 cardID from cardinfo order by openDate desc; object obj= DbHelperSQL.GetSingle(sql); if (!Object.Equals(obj, null) s = obj.ToString(); return s; / / 增加一条数据 / public bool Add(Model.cardinfo model,out string cardID)StringBuilder strSql=new StringBuilder();StringBuilder strSql1=new StringBuilder();StringBuilder strSql2=new StringBuilder(); cardID = ; /62212611 。1-6表示银行 7-8省份。9-15位才是自己的账户号，最后一位仍然是校验码 。中间7位 /获取最新的银行卡号。新卡的账号。是卡号9-15位的数字+1.。最后一位是随机数 string ss= getMaxCardID(); if (ss = ) cardID = 622126110000001; /第一个开卡的人 else int xx = int.Parse(ss.Substring(8, 7) + 1; if (xx = 10000000) return false; /超额了 cardID = ss.Substring(0, 8) + xx.ToString(D7); Random r = new Random(); cardID = cardID + r.Next(0, 10); model.cardID= cardID; if (model.cardID != null)strSql1.Append(cardID,);strSql2.Append(+model.cardID+,); if (model.curType != null)strSql1.Append(curType,);strSql2.Append(+model.curType+,);if (model.savingType != null)strSql1.Append(savingType,);strSql2.Append(+model.savingType+,);if (model.openDate != null)strSql1.Append(openDate,);strSql2.Append(+model.openDate+,);if (model.openMoney != null)strSql1.Append(openMoney,);strSql2.Append(+model.openMoney+,);if (model.balance != null)strSql1.Append(balance,);strSql2.Append(+model.balance+,);if (model.pass != null)strSql1.Append(pass,);strSql2.Append(+model.pass+,);if (model.IsReportLoss != null)strSql1.Append(IsReportLoss,);strSql2.Append(+(model.IsReportLoss? 1 : 0) +,);if (model.customerID != null)strSql1.Append(customerID,);strSql2.Append(+model.customerID+,);strSql.Append(insert into cardinfo();strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1);strSql.Append();strSql.Append( values ();strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1);strSql.Append();int rows=DbHelperSQL.ExecuteSql(strSql.ToString();if (rows 0) /增加交易记录 Model.transInfo t = new Model.transInfo(); t.cardID = model.cardID; t.transDate = model.openDate; t.transMoney = model.openMoney; t.transType = 存入; t.remark = 开户存入; DAL.transInfo dalt = new DAL.transInfo(); dalt.Add(t);return true;elsereturn false;5 BLL- userinfoGetModel public Model.userInfo GetModel(string PID) return dal.GetModel(PID); 6 BLL- userinfoAdd/ / 增加一条数据/ public int Add(Model.userInfo model)return dal.Add(model);7 BLL- cardinfoAdd / / 增加一条数据 / public bool Add(Model.cardinfo model,out string CardID)return dal.Add(model,out CardID);8 WinF- NewCard窗体-增加字段private int CustomerID = 0;/用户ID public string CardID;/卡号9 WinF- NewCard窗体-查询身份证按钮private void button1_Click(object sender, EventArgs e) label8.Text =; textBox2.Text =; textBox3.Text = ; textBox4.Text = ; string pid = textBox1.Text; BLL.userInfo bll = new BLL.userInfo(); Model.userInfo model= bll.GetModel(pid); if (model != null) textBox2.Text = model.customerName; textBox3.Text = model.telephone; textBox4.Text = model.address; CustomerID = model.customerID; label8.Text =老客户，基本信息不用重填; else label8.Text= 新客户，请填基本信息; 10 WinF- NewCard窗体-开户按钮private void button2_Click(object sender, EventArgs e) label9.Text = ; string acctype=comboBox1.Text; decimal opennnum=numericUpDown1.Value; string pwd = textBox5.Text; Model.cardinfo model = new Model.cardinfo(); model.cardID =; model.curType = RMB; model.customerID = CustomerID; model.IsReportLoss = false; model.savingType = acctype; model.openDate = DateTime.Now; model.openMoney = opennnum; model.balance = opennnum; model.pass = pwd; bool openOK; if (CustomerID != 0)/身份证已注册 BLL.cardinfo bll = new BLL.cardinfo(); openOK= bll.Add(model,out CardID)