发一个自己用的3层结构代码生成器(开源)

该版本只针对SQL2005, 用其他数据库的朋友可以改改代码(只需要能查询到所有表和表字段信息的SQL语句), 就可以对付其他数据库了

因为用了DEV控件,所以压缩包有点大

源码下载

使用版

不知道为什么图一直上传不了 , 图就不放了  放点生成后的代码吧

使用说明: 登入数据库(与一般生成器并无二致), 进入后, 左侧是表名列表,双击需要生成的表 , 打开生成页面, 点击按钮  --> OK END

实体:

using System;
namespace Entity
{
    public class ReserveRoom
    {
        public ReserveRoom()
        {}
        private int _id;
        public int ID
        {
            set{  _id= value;}
            get{return _id;}
        }
        private int _accountid;
        public int AccountID
        {
            set{  _accountid= value;}
            get{return _accountid;}
        }
        private string _roommark;
        public string RoomMark
        {
            set{  _roommark= value;}
            get{return _roommark;}
        }
        private string _roomprice;
        public string RoomPrice
        {
            set{  _roomprice= value;}
            get{return _roomprice;}
        }
        private string _guestname;
        public string GuestName
        {
            set{  _guestname= value;}
            get{return _guestname;}
        }
        private DateTime _starttime;
        public DateTime StartTime
        {
            set{  _starttime= value;}
            get{return _starttime;}
        }
        private DateTime _leavetime;
        public DateTime LeaveTime
        {
            set{  _leavetime= value;}
            get{return _leavetime;}
        }
        private string _memo;
        public string Memo
        {
            set{  _memo= value;}
            get{return _memo;}
        }
        private bool _isdel;
        public bool IsDel
        {
            set{  _isdel= value;}
            get{return _isdel;}
        }
    }
}

数据层:

 

using System.Data;
using System.Text;
using System.Data.SqlClient;
using Entity;
using System;
using System.Collections.Generic;
namespace DAL
{
    public class ReserveRoomDB
    {
        public ReserveRoomDB(){}

        public static int Create(ReserveRoom model)
        {
            StringBuilder strSql = new StringBuilder(); 
            strSql.Append("insert into reserveroom(");
            strSql.Append("accountid,roommark,roomprice,guestname,starttime,leavetime,memo,isdel");
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append("" + model.AccountID + ",");
            strSql.Append("'" + model.RoomMark + "',");
            strSql.Append("'" + model.RoomPrice + "',");
            strSql.Append("'" + model.GuestName + "',");
            strSql.Append("'" + model.StartTime + "',");
            strSql.Append("'" + model.LeaveTime + "',");
            strSql.Append("'" + model.Memo + "',");
            strSql.Append("'" + model.IsDel + "'");
            strSql.Append(");select @@IDENTITY");
            object obj = SQLHelper.ExecuteScalar(strSql.ToString());
            if (obj == null)
                return 0;
            else
                return Convert.ToInt32(obj);
        }

        public static void Delete(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete reserveroom ");
            strSql.Append(" where id=" + ID + " ");
            SQLHelper.ExecuteNonQuery(strSql.ToString());
        }

        public static void Update(ReserveRoom model)
        {
            StringBuilder strSql = new StringBuilder(); 
            strSql.Append("update reserveroom set ");
            strSql.Append("accountid=" + model.AccountID + ",");
            strSql.Append("roommark='" + model.RoomMark + "',");
            strSql.Append("roomprice='" + model.RoomPrice + "',");
            strSql.Append("guestname='" + model.GuestName + "',");
            strSql.Append("starttime='" + model.StartTime + "',");
            strSql.Append("leavetime='" + model.LeaveTime + "',");
            strSql.Append("memo='" + model.Memo + "',");
            strSql.Append("isdel='" + model.IsDel + "'");
            strSql.Append(" where id=" + model.ID + "");
            SQLHelper.ExecuteNonQuery(strSql.ToString());
        }

        public static ReserveRoom GetModel(int ID)
        {
            ReserveRoom model = new ReserveRoom();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" from reserveroom ");
            strSql.Append(" where id=" + ID + " ");
            using (SqlDataReader sr = SQLHelper.ExecuteReader(strSql.ToString()))
            {
                while (sr.Read())
                    return Get(sr);
            }
            return model;
        }

        public static List<ReserveRoom> GetList()
        {
            List<ReserveRoom> list = new List<ReserveRoom>();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" from reserveroom ");
            using (SqlDataReader sr = SQLHelper.ExecuteReader(strSql.ToString()))
            {
                while (sr.Read())
                    list.Add(Get(sr));
            }
            return list;
        }

        private static ReserveRoom Get(SqlDataReader sr)
        {
            ReserveRoom model = new ReserveRoom();
            model.ID = Convert.ToInt32(sr["ID"]);
            model.AccountID = Convert.ToInt32(sr["AccountID"]);
            model.RoomMark = sr["RoomMark"].ToString();
            model.RoomPrice = sr["RoomPrice"].ToString();
            model.GuestName = sr["GuestName"].ToString();
            model.StartTime = Convert.ToDateTime(sr["StartTime"]);
            model.LeaveTime = Convert.ToDateTime(sr["LeaveTime"]);
            model.Memo = sr["Memo"].ToString();
            model.IsDel = Convert.ToBoolean(sr["IsDel"]);
            return model;
        }
    }
}

逻辑层:

 

using System;
using System.Text;
using System.Collections.Generic;
using Entity;
using DAL;
namespace BLL
{
    public class ReserveRoomManager
    {

        public static int Create(ReserveRoom model,out string error)
        {
            error = string.Empty;
            //Check Todo
            if(error != string.Empty)
                return 0;

            try
            {
                return ReserveRoomDB.Create(model);
            }
            catch
            {
                error = "操作失败,发生未知错误 ";
                return 0;
            }
        }

        public static void Delete(int ID,out string error)
        {
            error = string.Empty;
            //Check Todo
            if(error != string.Empty)
                return;

            try
            {
                ReserveRoomDB.Delete(ID);
            }
            catch
            {
                error = "操作失败,发生未知错误 ";
                return;
            }
        }

        public static void Update(ReserveRoom model,out string error)
        {
            error = string.Empty;
            //Check Todo
            if(error != string.Empty)
                return;

            try
            {
                ReserveRoomDB.Update(model);
            }
            catch
            {
                error = "操作失败,发生未知错误 ";
                return;
            }
        }

        public static ReserveRoom GetModel(int ID)
        {
            return ReserveRoomDB.GetModel(ID);
        }

        public static List<ReserveRoom> GetList()
        {
            return ReserveRoomDB.GetList();
        }
    }
}