cWeb是基于微软的.Net Framework 4框架,数据库是sql server 2008 r2。
cWeb开发框架下载,点击这里去下载。
cWeb开发框架借鉴三层架构理论分为三层,分别是:cData、cBN和cWeb。cData是数据层,cBN是业务处理层,cWeb是业务展示层。解决方案如图示:
一、cData数据层
cData数据层,数据库字段的映射类。在其他开发框架中常见于datatable和dataview,也就是将数据库表映射成datatable,dataview继承datatable,并将其他如视图等的字段映射在dataview中。在类似于petshop等开发框架中分层可谓详细,虽然现在硬件的发展可以不用考虑继承、映射、调用等等的运行时间,但是对于大数据量下即使很小的优化都会起到极大的作用,所以直接的就是高效率的,简化后数据层都融合在了一起。
data层数据示例:
using System; namespace AA.cData { /// <summary> /// t_info 的摘要说明。 /// </summary> [Serializable] public class t_infoDV { /// <summary> /// t_infoDV /// </summary> public t_infoDV() { } //============================数据库字段=================================// private long _ID = -1; /// <summary> /// ID /// </summary> public long ID { get { return _ID; } set { _ID = value; } } private string _t_info_title = null ; /// <summary> /// t_info_title /// </summary> public string t_info_title { get { return _t_info_title; } set { _t_info_title = value; } } private DateTime _t_info_createtime = System.DateTime.MinValue; /// <summary> /// t_info_createtime /// </summary> public DateTime t_info_createtime { get { return _t_info_createtime; } set { _t_info_createtime = value; } } //============================扩展字段==================================// private string _t_info_title_like = null ; /// <summary> /// t_info_title [模糊查询] /// </summary> public string t_info_title_like { get { return _t_info_title_like; } set { _t_info_title_like = value; } } } } |
二、cBN业务处理层
cBN业务处理层,也可以叫业务逻辑层。是数据层之上用来处理业务逻辑的方法,将除了web之外的所有业务处理都可以放在这个层里,比如添加、修改、删除、各种查询等方法,在web层仅仅调用一下就可以实现功能,也体现了业务逻辑通用原则,这样同样的业务处理就可以重复调用,提高了开发效率,减少了代码的冗长重复。
BN层示例:
using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using cDB; using AA.cData; namespace AA.cBN { /// <summary> /// t_info 的摘要说明。 /// </summary> public class t_infoBN { DataInfo cDI; /// <summary> /// t_infoBN /// </summary> public t_infoBN() { cDI = new DataInfo(); } #region [添加|修改|删除] /// <summary> /// [添加] /// </summary> /// <param name="tDV"></param> /// <param name="msg"></param> /// <returns></returns> public int Add(t_infoDV tDV, out string msg) { try { mCommand oCommand = new mCommand(); oCommand.SqlTxt = "Insert into t_info(t_info_title,t_info_createtime)" + " values(@t_info_title,@t_info_createtime)" ; SqlParameter[] SqlItems = new SqlParameter[2]; SqlItems[0] = new SqlParameter( "@t_info_title" , SqlDbType.NVarChar); SqlItems[0].Value = tDV.t_info_title; SqlItems[1] = new SqlParameter( "@t_info_createtime" , SqlDbType.DateTime); SqlItems[1].Value = tDV.t_info_createtime; oCommand.AddParameter(SqlItems); int iResult = cDI.iCommandSql(oCommand); if (iResult > -1) { msg = "添加成功!" ; } else { msg = "添加失败!" ; } return iResult; } catch //(Exception ex) { //msg = ex.Message; msg = "添加失败(异常)!" ; return -11; //-11表示异常 } } /// <summary> /// [修改] /// </summary> /// <param name="tDV"></param> /// <param name="msg"></param> /// <returns></returns> public int Edit(t_infoDV tDV, out string msg) { try { mCommand oCommand = new mCommand(); oCommand.SqlTxt = "update t_info set " + "t_info_title=@t_info_title," + "t_info_createtime=@t_info_createtime " + "where ID=@ID" ; SqlParameter[] SqlItems = new SqlParameter[3]; SqlItems[0] = new SqlParameter( "@t_info_title" , SqlDbType.NVarChar); SqlItems[0].Value = tDV.t_info_title; SqlItems[1] = new SqlParameter( "@t_info_createtime" , SqlDbType.DateTime); SqlItems[1].Value = tDV.t_info_createtime; SqlItems[2] = new SqlParameter( "@ID" , SqlDbType.BigInt); SqlItems[2].Value = tDV.ID; oCommand.AddParameter(SqlItems); int iResult = cDI.iCommandSql(oCommand); if (iResult > -1) { msg = "修改成功!" ; } else { msg = "修改失败!" ; } return iResult; } catch //(Exception ex) { //msg = ex.Message; msg = "添加失败(异常)!" ; return -11; //-11表示异常 } } /// <summary> /// [删除] /// </summary> /// <param name="tDV"></param> /// <param name="msg"></param> /// <returns></returns> public int Del(t_infoDV tDV, out string msg) { try { mCommand oCommand = new mCommand(); oCommand.SqlTxt = "delete t_info where ID=@ID" ; SqlParameter[] SqlItems = new SqlParameter[1]; SqlItems[0] = new SqlParameter( "@ID" , SqlDbType.BigInt); SqlItems[0].Value = tDV.ID; oCommand.AddParameter(SqlItems); int iResult = cDI.iCommandSql(oCommand); if (iResult > -1) { msg = "删除成功!" ; } else { msg = "删除失败!" ; } return iResult; } catch //(Exception ex) { //msg = ex.Message; msg = "删除失败(异常)!" ; return -11; //-11表示异常 } } #endregion #region [查询] /// <summary> /// [返回数据分页] /// </summary> /// <param name="tDV"></param> /// <param name="sqlWhere">where语句</param> /// <returns></returns> public DataTable GetDataList(t_infoDV tDV, string sqlWhere) { DataTable DTe = new DataTable(); mCommand oCommand = new mCommand(); StringBuilder SqlTxtPrefiex = new StringBuilder( " select ISNULL(count(ID),0) as Counts from View_t_info where 1 = 1 " + sqlWhere + " " ); SqlParameter tSqlItem = null ; if (tDV.t_info_title != null ) { SqlTxtPrefiex.Append( " and t_info_title = @t_info_title" ); tSqlItem = new SqlParameter( "@t_info_title" , SqlDbType.NVarChar); tSqlItem.Value = tDV.t_info_title; oCommand.SqlParameters.Add(tSqlItem); } if (tDV.t_info_title_like != null ) { SqlTxtPrefiex.Append( " and t_info_title like @t_info_title_like" ); tSqlItem = new SqlParameter( "@t_info_title_like" , SqlDbType.NVarChar); tSqlItem.Value = "%" + tDV.t_info_title_like + "%" ; oCommand.SqlParameters.Add(tSqlItem); } oCommand.SqlTxt = SqlTxtPrefiex.ToString(); DTe = cDI.GetTable(oCommand); return DTe; } /// <summary> /// [返回数据] /// </summary> /// <param name="tDV"></param> /// <param name="column">显示的列,默认为【*】全部</param> /// <param name="sqlWhere">where语句</param> /// <param name="beginIndex">开始记录</param> /// <param name="endIndex">结束记录</param> /// <param name="Order">排序,如【order by ID desc】</param> /// <returns></returns> public DataTable GetDataList(t_infoDV tDV, string column, string sqlWhere, long beginIndex, long endIndex, string Order) { if ( string .IsNullOrEmpty(column)) column = " * " ; mCommand oCommand = new mCommand(); StringBuilder cSqlTxtPrefiex = new StringBuilder( "select * from NoPagedTable WHERE rowIndex>=@beginIndex and rowIndex<=@endIndex" ); SqlParameter[] SqlItems = new SqlParameter[2]; SqlItems[0] = new SqlParameter( "@beginIndex" , SqlDbType.BigInt); SqlItems[0].Value = beginIndex; SqlItems[1] = new SqlParameter( "@endIndex" , SqlDbType.BigInt); SqlItems[1].Value = endIndex; oCommand.SqlParameters.AddRange(SqlItems); if (Order == string .Empty) { Order = " order by ID DESC " ; } StringBuilder SqlTxtPrefiex = new StringBuilder( "WITH NoPagedTable AS " + "(" + "SELECT ROW_NUMBER() OVER (" + Order + ") AS rowIndex," + column + " FROM View_t_info where 1 = 1 " + sqlWhere + " " ); SqlParameter tSqlItem = null ; if (tDV.t_info_title != null ) { SqlTxtPrefiex.Append( " and t_info_title = @t_info_title" ); tSqlItem = new SqlParameter( "@t_info_title" , SqlDbType.NVarChar); tSqlItem.Value = tDV.t_info_title; oCommand.SqlParameters.Add(tSqlItem); } if (tDV.t_info_title_like != null ) { SqlTxtPrefiex.Append( " and t_info_title like @t_info_title_like" ); tSqlItem = new SqlParameter( "@t_info_title_like" , SqlDbType.NVarChar); tSqlItem.Value = "%" + tDV.t_info_title_like + "%" ; oCommand.SqlParameters.Add(tSqlItem); } SqlTxtPrefiex.Append( ")" ); oCommand.SqlTxt = SqlTxtPrefiex.ToString() + cSqlTxtPrefiex.ToString(); return cDI.GetTable(oCommand); } /// <summary> /// [返回DataTable] /// </summary> /// <param name="tDV"></param> /// <param name="topNum">返回行数,默认【0】全部</param> /// <param name="column">显示的列,默认为【*】全部</param> /// <param name="sqlWhere">where语句</param> /// <param name="order">排序,如【order by ID desc】</param> /// <returns></returns> public DataTable GetDataTable(t_infoDV tDV, int topNum, string column, string sqlWhere, string order) { if ( string .IsNullOrEmpty(column)) column = " * " ; string topNumSql = "" ; if (topNum > 0) topNumSql = " top " + topNum.ToString(); DataTable DT = new DataTable(); mCommand oCommand = new mCommand(); StringBuilder SqlTxtPrefiex = new StringBuilder( " select " + topNumSql + " " + column + " from View_t_info where 1 = 1 " + sqlWhere + " " ); SqlParameter tSqlItem = null ; if (tDV.ID != -1) { SqlTxtPrefiex.Append( " and ID=@ID" ); tSqlItem = new SqlParameter( "@ID" , SqlDbType.BigInt); tSqlItem.Value = tDV.ID; oCommand.SqlParameters.Add(tSqlItem); } if (tDV.t_info_title != null ) { SqlTxtPrefiex.Append( " and t_info_title = @t_info_title" ); tSqlItem = new SqlParameter( "@t_info_title" , SqlDbType.NVarChar); tSqlItem.Value = tDV.t_info_title; oCommand.SqlParameters.Add(tSqlItem); } if (tDV.t_info_title_like != null ) { SqlTxtPrefiex.Append( " and t_info_title like @t_info_title_like" ); tSqlItem = new SqlParameter( "@t_info_title_like" , SqlDbType.NVarChar); tSqlItem.Value = "%" + tDV.t_info_title_like + "%" ; oCommand.SqlParameters.Add(tSqlItem); } if ( string .IsNullOrEmpty(order)) order = " order by ID desc " ; SqlTxtPrefiex.Append( " " + order + " " ); oCommand.SqlTxt = SqlTxtPrefiex.ToString(); DT = cDI.GetTable(oCommand); return DT; } #endregion } } |
三、cWeb业务展示层
cWeb业务展示层,用于业务逻辑展示的层,调用BN层的函数直接显示在web页面中。
web层示例:
infolist.aspx.cs代码如下:
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using AA.cData; using AA.cBN; using cPage; namespace AA.cWeb.manage.info { public partial class infolist : System.Web.UI.Page { cUser cu = new cUser(); public int p = 1; //页码 protected void Page_Load( object sender, EventArgs e) { #region [判断是否登录] if (!cu.isLogin()) { cGlobal.frameGoUrl( this , "../../default.aspx" ); return ; } #endregion #region 分页获得页码 string _p = Request.QueryString[ "p" ]; if ( string .IsNullOrEmpty(_p)) _p = "1" ; if (cGlobal.IsIntType(_p)) { p = Convert.ToInt32(_p); } else { cGlobal.showBoxBack( this , "页码不正确!" ); return ; } #endregion #region [判断是具有访问权限] if (!cDataCommon.userPagePower(cu.userID, "0202" )) { cGlobal.showBoxBack( this , "您没有权限访问!" ); return ; } #endregion #region [获得在【系统设置=》角色管理=》权限设置】中点击某一菜单后,“菜单功能权限设置”设置的功能] string userPageFunctionPower = cDataCommon.userPageFunctionPower(cu.userID, "0202" ); //判断是否具有“添加”功能 if (userPageFunctionPower.IndexOf( "|add|" ) > -1) btnAdd.Visible = true ; else btnAdd.Visible = false ; #endregion if (!Page.IsPostBack) { dataBind(); } } protected void dataBind() { string _url = "infolist.aspx?p=[#p#]" ; int _pageNum = 10; // 中间页码数量 int _pageSize = 10; //每页记录数 int _beginIndex = 0; int _endIndex = 0; t_infoBN tBN = new t_infoBN(); t_infoDV tDV = new t_infoDV(); DataTable rcDT = tBN.GetDataList(tDV, "" ); lblpage.Text = mPage.getPage(Convert.ToInt32(rcDT.Rows[0][0].ToString()), _pageSize, _pageNum, p, out _beginIndex, out _endIndex, _url); DataTable DT = tBN.GetDataList(tDV, "" , "" , _beginIndex, _endIndex, "" ); rlist.DataSource = DT; rlist.DataBind(); } protected void rlist_ItemDataBound( object sender, RepeaterItemEventArgs e) { if (e.Item.ItemIndex > -1) { ((LinkButton)e.Item.FindControl( "lnkbtnDel" )).Attributes[ "onclick" ] = "return confirm('确认要删除吗?');" ; } } protected void rlist_ItemCommand( object source, RepeaterCommandEventArgs e) { if (e.CommandName == "del" ) { try { long _ID = Convert.ToInt64(((HiddenField)(e.Item.FindControl( "hfID" ))).Value); t_sys_logBN tBN = new t_sys_logBN(); t_sys_logDV tDV = new t_sys_logDV(); tDV.ID = _ID; string msg = "" ; int iResult = -2; iResult = tBN.Del(tDV, out msg); if (iResult >= 0) //0,执行完成,>1,执行完成影响的记录数 { cGlobal.showBoxGo( this , "删除成功!" , Request.Url.ToString()); } else { cGlobal.showBoxBack( this , "删除失败!" ); } } catch { cGlobal.showBoxBack( this , "数据格式不正确(异常)" ); } } } } } |
更详细的介绍和cWeb源代码,去这里下载。
原帖地址:cWeb开发框架,基于asp.net的cWeb应用开发平台介绍(二)
bubufx提供,禁止转载。
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步