jquery easyui+ashx+三层框架实现增删改查
来源：互联网 发布：it consultis 编辑：程序博客网 时间：2024/06/06 06:50
先说一下背景， 最近在学校做一个比赛作品，是一个电子挂号系统。因为自己没有接触过医院方面的项目，没有到大医院看过病，也没有亲身体验过网上预约挂号系统的流程。现在对需求还是有很多不明白的地方。需要向大侠请教，如果有哪位园友做过类似的系统，还请加我qq1143314007（请备注 博客园 谢谢）和我交流。因为一些业务不是很清楚，所有数据库设计的还没有设计完整。由于时间紧迫，只能先做一些基础数据的更新了。在这个期间我们做了科室管理的增删改查。因为第一次使用jquery easyui也遇到了不少问题。
先看看这个项目的组织结构吧。
相信有些经验的人看到这个组织架构就知道，是一个基本的三层架构，然后在数据库访问层使用了一个抽象工厂模式来调用DAL。简单的介绍一个这个架构。
FrameWork：包括数据库访问接口，数据访问库，公共代码类，数据访问工厂等基础库
Register.Model：实体库
Register.DBUtility：通用数据库操作类
Register.IDAL：数据库增删改查接口
Register.DALFactory：数据库访问程序集访问工厂类
Register.DAL：数据库增删改查相关操作
Register.Command：公共访问类，比如密码加密解密，邮件发送等基础类
Register.BLL：实现相关业务逻辑库。
Reference：包括使用的第三方的库。
Solution Items：关于项目的说明文件，项目分工，项目进度等文档资料的说明
Test：项目单元测试的代码
WebApplication：系统项目及系统服务.
基本的项目结构就介绍这些，本文主要介绍jquery easyui和ashx以及三层架构的一个整合，下面来介绍主要代码（后面我会附上全部代码以及数据库）
ashx文件的代码：
相信有些经验的人看到这个组织架构就知道，是一个基本的三层架构，然后在数据库访问层使用了一个抽象工厂模式来调用DAL。简单的介绍一个这个架构。
FrameWork：包括数据库访问接口，数据访问库，公共代码类，数据访问工厂等基础库
Register.Model：实体库
Register.DBUtility：通用数据库操作类
Register.IDAL：数据库增删改查接口
Register.DALFactory：数据库访问程序集访问工厂类
Register.DAL：数据库增删改查相关操作
Register.Command：公共访问类，比如密码加密解密，邮件发送等基础类
Register.BLL：实现相关业务逻辑库。
Reference：包括使用的第三方的库。
Solution Items：关于项目的说明文件，项目分工，项目进度等文档资料的说明
Test：项目单元测试的代码
WebApplication：系统项目及系统服务.
基本的项目结构就介绍这些，本文主要介绍jquery easyui和ashx以及三层架构的一个整合，下面来介绍主要代码（后面我会附上全部代码以及数据库）
ashx文件的代码：
using System; using System.Collections.Generic; using System.Linq; using System.Web; using Register.BLL; using Register.Model; using System.Web.Script.Serialization; using RegisterWeb.Manager.SystemUserManager.ashx; using System.Text; namespace RegisterWeb.Manager.HospitalManager.ashx { /// <summary> /// DepartmentsManagerService 的摘要说明 /// </summary> public class DepartmentsManagerService : IHttpHandler { public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); String action = context.Request["action"]; //获取科室的全部列表 if (action.Equals("list")) { DepartmentListJSON departmentListJSON = new DepartmentListJSON(); departmentListJSON.rows = new List<DepartmentJSON>(); int row = int.Parse(context.Request["rows"].ToString()); int page = int.Parse(context.Request["page"].ToString()); List<DepartmentsInfo> list = DepartmentsBLL.GetPagedDepartmentsInfo(row, page, " Departments_State='1' "); departmentListJSON.total = DepartmentsBLL.GetDepartmentsCount(" Departments_State='1' "); foreach (DepartmentsInfo de in list) { string status; if (de.Departments_State.ToString().Equals("1")) { status = "有效"; } else status = "无效"; departmentListJSON.rows.Add(new DepartmentJSON(de.Departments_ID, (HospitalInfoBLL.GetHospitalInfoByID(de.Hospital_ID)).Hospital_Name, de.Departments_Name, de.Departments_Introduce, de.Departments_AddTime.ToString(), de.Departments_Recoder, status,de.Hospital_ID)); } JavaScriptSerializer jss = new JavaScriptSerializer(); context.Response.Write(jss.Serialize(departmentListJSON)); } //添加科室 else if (action.Equals("add")) { String DepartmentName = context.Request["textDepartmentName"]; String DepartmentDes = context.Request["textDepartmentDes"]; String selectHosptial = context.Request["selectHosptial"]; DepartmentsInfo info = new DepartmentsInfo(); info.Departments_ID = DataIDHelper.GetDataID("Departments_ID"); info.Departments_Introduce = DepartmentDes; info.Departments_Name = DepartmentName; info.Departments_LastAmendPerson = "admin"; info.Departments_Recoder = "admin"; info.Departments_LastAmendTime = DateTime.Now; info.Departments_AddTime = DateTime.Now; info.Hospital_ID = selectHosptial; info.Departments_State="1"; if (DepartmentsBLL.AddDepartments(info)) { message msg = new message(true,"该科室添加成功！"); JavaScriptSerializer jss = new JavaScriptSerializer(); context.Response.Write(jss.Serialize(msg)); } else { message msg = new message(false, "该科室添加失败！"); JavaScriptSerializer jss = new JavaScriptSerializer(); context.Response.Write(jss.Serialize(msg)); } } //删除科室 else if (action.Equals("delete")) { String id = context.Request["id"]; DepartmentsInfo info = new DepartmentsInfo(); info.Departments_ID=id; if (DepartmentsBLL.DeleteDepartments(info)) { context.Response.Write("ok"); } else { context.Response.Write("no"); } } //编辑科室 else if (action.Equals("edit")) { String DepartmentName = context.Request["textDepartmentName"]; String DepartmentDes = context.Request["textDepartmentDes"]; String selectHosptial = context.Request["selectHosptial"]; String id = context.Request["id"]; DepartmentsInfo info = new DepartmentsInfo(); info.Departments_ID = id; info.Departments_Name = DepartmentName; info.Departments_Introduce = DepartmentDes; info.Hospital_ID = selectHosptial; info.Departments_LastAmendPerson = "admin"; info.Departments_LastAmendTime = DateTime.Now; if (DepartmentsBLL.UpdateDepartments(info)) { message msg = new message(true, "该科室更新成功！"); JavaScriptSerializer jss = new JavaScriptSerializer(); context.Response.Write(jss.Serialize(msg)); } else { message msg = new message(false, "该科室更新失败！"); JavaScriptSerializer jss = new JavaScriptSerializer(); context.Response.Write(jss.Serialize(msg)); } } //查询科室 else if (action.Equals("search")) { string hospName = context.Request["hospName"]; string depName = context.Request["depName"]; DepartmentListJSON departmentListJSON = new DepartmentListJSON(); departmentListJSON.rows = new List<DepartmentJSON>(); int row = int.Parse(context.Request["rows"].ToString()); int page = int.Parse(context.Request["page"].ToString()); StringBuilder strBuilder = new StringBuilder(); strBuilder.Append(" Departments_State='1' "); if (!String.IsNullOrEmpty(depName)) { strBuilder.Append(" and Departments_Name=").Append(depName).Append(" "); } if (!String.IsNullOrEmpty(hospName)) { strBuilder.Append(" and Hospital_ID='").Append(hospName).Append("' "); } List<DepartmentsInfo> list = DepartmentsBLL.GetPagedDepartmentsInfo(row, page, strBuilder.ToString()); departmentListJSON.total = DepartmentsBLL.GetDepartmentsCount(strBuilder.ToString()); foreach (DepartmentsInfo de in list) { string status; if (de.Departments_State.ToString().Equals("1")) { status = "有效"; } else status = "无效"; departmentListJSON.rows.Add(new DepartmentJSON(de.Departments_ID, (HospitalInfoBLL.GetHospitalInfoByID(de.Hospital_ID)).Hospital_Name, de.Departments_Name, de.Departments_Introduce, de.Departments_AddTime.ToString(), de.Departments_Recoder, status, de.Hospital_ID)); } JavaScriptSerializer jss = new JavaScriptSerializer(); context.Response.Write(jss.Serialize(departmentListJSON)); } } public bool IsReusable { get { return false; } } } class DepartmentListJSON { public int total { get; set; } public List<DepartmentJSON> rows { get; set; } } class DepartmentJSON { public string ID { get; set; } public string Hospital { get; set; } public string Name { get; set; } public string Introduce { get; set; } public string AddTime { get; set; } public string Recoder { get; set; } public string State { get; set; } public string HosptialID { get; set; } public DepartmentJSON(string ID, string Hospital, string Name, string Introduce, string AddTime, string Recoder, string State, string HospitalID) { this.ID = ID; this.Hospital = Hospital; this.Name = Name; this.Introduce = Introduce; this.AddTime = AddTime; this.Recoder = Recoder; this.State = State; this.HosptialID = HospitalID; } } }在ashx文件中，不同的action对应一个前台的增删改查操作。然后执行相应的方法返回json串或者文本信息。
在看一下前台页面的核心jquery ui代码
<script type="text/javascript"> var url; //提交数据的路径 var formId; //当天要提交的Form的编号 var dialogId; //对话框的编号 var successCallback = function (result) { //result为请求处理后的返回值 var result = eval('(' + result + ')'); if (result.success) { $.messager.show({ title: 'Success', msg: result.msg }); $(dialogId).dialog('close'); $('#dg').datagrid('reload'); } else { $.messager.show({ title: 'Error', msg: result.msg }); } } $(function () { //预加载编辑框 $("#editDepartmentInfo").dialog({ "title": "编辑科室信息", width: 500, height: 450, href: 'EditDepartment.aspx' }); $("#editDepartmentInfo").dialog('open').dialog('close'); $('#dg').datagrid({ onDblClickRow: function (rowIndex, rowData) { $('#editDepartmentInfo').dialog('open'); $("#textDepartmentName").val(rowData.Name); $("#textDepartmentDes").val(rowData.Introduce); $("#hoistal").combobox('setValue', rowData.HosptialID); // $('#edit').form('clear'); url = 'ashx/DepartmentsManagerService.ashx?action=edit&id=' + rowData.ID; formId = "#edit"; dialogId = "#editDepartmentInfo"; } }); }); //编辑科室部分 function editDepartmentInfo() { var row = $('#dg').datagrid('getSelected'); if (row) { $('#editDepartmentInfo').dialog('open'); $("#textDepartmentName").val(row.Name); $("#textDepartmentDes").val(row.Introduce); $("#hoistal").combobox('setValue', row.HosptialID); // $('#edit').form('clear'); url = 'ashx/DepartmentsManagerService.ashx?action=edit&id=' + row.ID; formId = "#edit"; dialogId = "#editDepartmentInfo"; } else { $.messager.alert("提示", "您没有选中任何行！"); } } //添加科室部分 function addDepartmentInfo() { $("#addDepartmentInfo").dialog({ "title": "新建科室信息", width: 500, height: 450, href: 'AddDepartment.aspx' }); $('#addDepartmentInfo').dialog('open'); $('#add').form('clear'); url = 'ashx/DepartmentsManagerService.ashx?action=add'; formId = "#add"; dialogId = "#addDepartmentInfo"; } function saveInfo() { $(formId).form('submit', { url: url, onSubmit: function () { alert(formId); return $(this).form('validate'); }, success: successCallback }); } // 删除代码部分 function deleteAdminUser() { var row = $('#dg').datagrid('getSelected'); if (row) { $.messager.confirm('删除提示', '确定要删除' + row.Name + '吗', function (r) { if (r) { $.post('ashx/DepartmentsManagerService.ashx', { id: row.ID, action: 'delete' }, function (data, status) { if (data == "ok") { $('#dg').datagrid('reload'); } else { $.messager.show({ title: 'Error', msg: '删除该科室失败!' }); } }); } }); } } //多条件查询方法 function tsearch() { var hoistalName = $("#hoistalName").combobox("getValue"); var depName = $("#depName").val(); alert(depName); $('#dg').datagrid('options').pageNumber = 1; $('#dg').datagrid('getPager').pagination({pageNumber: 1}); $('#dg').datagrid('options').url = 'ashx/DepartmentsManagerService.ashx?action=search&hospName='+hoistalName+'&depName='+depName; $('#dg').datagrid("reload"); } </script> <div region="center" title="科室信息管理" > <div class="easyui-panel" title="查询条件" style="width:850px;height:80px" collapsible="true" > <div class="searchitem"> <label>医院名：</label> <select id="hoistalName" name="selectHosptial"> </select> <script type="text/javascript"> $("#hoistalName").combobox({ url: "ashx/HospitalInfoService.ashx?action=search", valueField: "HosptialItemID", textField: "HosptialItemName", panelHeight: "auto" }); </script> </div> <div class="searchitem"> <label>科室名：</label> <input type="text" id="depName" class="easyui-validatebox" /> </div> <div class="searchitem"> <a href="#" class="easyui-linkbutton" onclick="tsearch()" >查询</a> </div> </div> <table id="dg" title="科室信息管理" class="easyui-datagrid" style="width:850px;height:550px" url="ashx/DepartmentsManagerService.ashx?action=list" toolbar="#toolbar" pagination="true" rownumbers="true" fitColumns="true" singleSelect="true" idField='ID' pageSize="20" > <thead> <tr> <th field="Name" width="50">科室名</th> <th field="Hospital" width="50">所属单位</th> <th field="Introduce" width="50">科室介绍</th> <th field="AddTime" width="50">添加时间</th> <th field="Recoder" width="50">记录人</th> <th field="State" width="50">状态</th> </tr> </thead> </table> <div id="toolbar" style="padding:5px;height:auto"> <a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="true" onclick="addDepartmentInfo()">添加科室</a> <a href="#" class="easyui-linkbutton" iconCls="icon-edit" plain="true" onclick="editDepartmentInfo()">编辑科室</a> <a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true" onclick="deleteAdminUser()">删除科室</a> </div> <div id="addDepartmentInfo" class="easyui-dialog" closed="true" buttons="#addDepartmentInfo-buttons" style="padding:10px 20px"> </div> <div id="addDepartmentInfo-buttons"> <a href="#" class="easyui-linkbutton" iconCls="icon-ok" onclick="saveInfo()">保存</a> <a href="#" class="easyui-linkbutton" iconCls="icon-cancel" onclick="javascript:$('#addDepartmentInfo').dialog('close')">关闭</a> </div> <div id="editDepartmentInfo" class="easyui-dialog" closed="true" buttons="#editDepartmentInfo-buttons" style="padding:10px 20px"> </div> <div id="editDepartmentInfo-buttons"> <a href="#" class="easyui-linkbutton" iconCls="icon-ok" onclick="saveInfo()">保存</a> <a href="#" class="easyui-linkbutton" iconCls="icon-cancel" onclick="javascript:$('#editDepartmentInfo').dialog('close')">关闭</a> </div> </div>jquery easyui 的具体函数使用方法参考jquery easyui中文api
下面看一下最后的效果：
源代码下载 这是源码
注：同步于 http://www.cnblogs.com/JerryWang1991/archive/2012/06/29/2570492.html
- jquery easyui+ashx+三层框架实现增删改查
- jQuery EasyUI+Nutz实现增删改查
- Jquery EasyUI增删改查实现步骤
- ASP.NET使用EasyUI-DataGrid + ashx + JQuery Ajax：实现数据的增删查改，查询和分页！
- jquery-easyui实现页面布局和增删改查操作（SSH2框架支持）
- jquery-easyui实现页面布局和增删改查操作（SSH2框架支持）
- jquery-easyui 实现用户的增删改查！
- SSM框架搭建+easyui增删改查实现
- ssm框架搭建+easyui增删改查实现
- ssm框架搭建+easyui增删改查实现
- ssm框架搭建+easyui增删改查实现
- ssm框架搭建+easyui增删改查实现
- jQuery EasyUI treegrid 增删改查 - 1
- jQuery EasyUI treegrid 增删改查 - 2
- jQuery EasyUI treegrid 增删改查 - 3
- Jquery EasyUI增删改查代码
- 基于easyui框架的增删改查
- SSM框架搭建+easyui增删改查
- 8086段地址为什么是16的倍数？
- java常见面试题
- trap linux
- 使用Sourcery CodeBech Lite debug Arm/Linux应用程序
- Android通过http协议POST传输方式
- jquery easyui+ashx+三层框架实现增删改查
- java design pattern - singleton
- iphone开发书籍
- window消息机制
- oracle共享模式与专用模式
- Apache的rewrite规则详细介绍
- token 防止页面重复提交
- 自己实现一个spring aop事务管理
- Oracle Database 10g完全参考手册(中文)下载地址
