App_Code/DAO/HourseDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

using HourseRentSystem.Model;
using HourseRentSystem.DB;
using System.Text;

namespace HourseRentSystem.DAO
{
    /// <summary>
    ///HourseDAO 的摘要说明:关于房屋信息处理的数据处理层
    /// </summary>
    public class HourseDAO
    {
        public HourseDAO()
        {
        }
        /*向数据库中登记房屋信息*/
        public bool AddHourse(Hourse hourse)
        {
            /*建立数据访问对象*/
            DataBase db = new DataBase();
            /*构造sql语句*/ 
            string sql = ""; 
            sql += "insert into [hourse] (zujin,huxing,mianji,zhuangxiu,leixing,louceng,quyu,xiaoqu,dizhi,";
            sql += "chuangFlag,dianhuaFlag,dianshiFlag,kongtiaoFlag,bingxiangFlag,reshuiqiFlag,xiyijiFlag,kuandaiFlag,";
            sql += "zhuangtai,kssj) values(";
            sql += hourse.getZujin() + ",";
            sql += SqlString.GetQuotedString(hourse.getHuxing()) + ",";
            sql += hourse.getMianji() + ",";
            sql += SqlString.GetQuotedString(hourse.getZhuangxiu()) + ",";
            sql += SqlString.GetQuotedString(hourse.getLeixing()) + ",";
            sql += SqlString.GetQuotedString(hourse.getLouceng()) + ",";
            sql += SqlString.GetQuotedString(hourse.getQuyu()) + ",";
            sql += SqlString.GetQuotedString(hourse.getXiaoqu()) + ",";
            sql += SqlString.GetQuotedString(hourse.getDizhi()) + ",";
            sql += hourse.getChuangFlag() + ",";
            sql += hourse.getDianhuaFlag() + ",";
            sql += hourse.getDianshiFlag() + ",";
            sql += hourse.getKongtiaoFlag() + ",";
            sql += hourse.getBingxiangFlag() + ",";
            sql += hourse.getReshuiqiFlag() + ",";
            sql += hourse.getXiyijiFlag() + ",";
            sql += hourse.getKuandaiFlag() + ",'未租',";
            sql += SqlString.GetQuotedString(Convert.ToDateTime("1970-1-1").ToShortDateString());
            sql += ")";
            /*调用数据访问层执行房屋信息的添加*/
            return db.InsertOrUpdate(sql) > 0;  
        }

         /*更新房屋信息*/
        public bool UpdateHourse(Hourse hourse)
        {
            /*建立数据层访问对象*/
            DataBase db = new DataBase();
            /*构建sql语句*/
            StringBuilder sb = new StringBuilder();
            sb.Append("update [hourse] set zujin=").Append(hourse.getZujin());