Easyui(增删改查)
前台代码：
<head runat="server"> <meta charset="UTF-8"> <title>His</title> <link href="../../jquery-easyui-1.4.2/themes/default/easyui.css" rel="stylesheet" /> <link rel="stylesheet" href="../../jquery-easyui-1.4.2/themes/icon.css" /> <link href="../../resources/easyui/easyui/themes/demo.css" rel="stylesheet" /> <script type="text/javascript" src="../../jquery-easyui-1.4.2/jquery.min.js"></script> <script type="text/javascript" src="../../jquery-easyui-1.4.2/jquery.easyui.min.js"></script> <script type="text/javascript" src="../../resources/js/ExcelCommon.js"></script> <script src="../../jquery-easyui-1.4.2/PromptJs.js"></script> <script src="../../jquery-easyui-1.4.2/locale/easyui-lang-zh_CN.js"></script> </head> <body> <table style="padding-top: 10px;"> <tr style="height: 25px;"> <td style="text-align: right;">产品编号:</td> <td style="width: 120px;"> <input class="easyui-textbox" name="CProductCode" id="CProductCode" style="width: 100px;" /> </td> <%-- <td style="text-align: right;">设备:</td> <td> <input class="easyui-combobox" id="SelectType" style="width: 120px;" name="SelectType" data-options="data:[{'value':'1', 'text':'PC端'}, {'value':'2','text':'移动端'}],method:'get',valueField:'value',textField:'text',panelHeight:'auto' " /> </td> <td style="text-align: right;"></td>--%> <td><a href="javascript:void(0)" class="easyui-linkbutton" onclick="reloadgrid()" data-options="iconCls:'icon-search'" style="width: 60px; height: 30px">查询</a> </td> </tr> </table> <table id="dg" title="His" class="easyui-datagrid" style="width: 100%; height: 700px" <%--url="HisProductData.aspx?action=search"--%> toolbar="#toolbar" pagination="true" rownumbers="true" fitcolumns="true" singleselect="true"> <thead> <tr> <th field="ProductCode" width="70">产品编号</th> <th field="ProductName" width="50">产品名称</th> <%--<th field="Manufacturer" width="50">生产公司</th>--%> <th field="Usage" width="50">用法</th> <th field="Dose" width="50">默认用量</th> <th field="Unit" width="50">用量单位</th> <th field="Frequency" width="50">频率</th> </tr> </thead> </table> <div id="toolbar"> <%--<a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-add" plain="true" onclick="newUser()">添加</a>--%> <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-edit" plain="true" onclick="editUser()">修改</a> <%--<a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-remove" plain="true" onclick="destroyUser()">删除</a>--%> </div> <div id="dlg" class="easyui-dialog" style="width: 400px" data-options="closed:true,modal:true,border:'thin',buttons:'#dlg-buttons'"> <form id="fm" method="post" novalidate style="margin: 0; padding: 20px 50px"> <div style="margin-bottom: 10px"> 产品编号: <input name="ProductCode" class="easyui-textbox" required="true" type="text" style="width: 100px"> </div> <div style="margin-bottom: 10px"> 用 法 : <input class="easyui-textbox" name="Usage" required="true" type="text" style="width:100px"> </div> <div style="margin-bottom: 10px"> 默认用量: <input name="Dose" class="easyui-textbox" required="true" type="text" style="width:100px"> </div> <div style="margin-bottom: 10px"> 用量单位: <input name="Unit" class="easyui-textbox" required="true" type="text" style="width:100px"> </div> <div style="margin-bottom: 10px"> 频 率 : <input name="Frequency" class="easyui-textbox" required="true" type="text" style="width:100px"> </div> <input type="hidden" name="ID" /> </form> </div> <div id="dlg-buttons"> <a href="javascript:void(0)" class="easyui-linkbutton c6" iconcls="icon-ok" onclick="saveUser()" style="width: 90px">Save</a> <a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-cancel" onclick="javascript:$('#dlg').dialog('close')" style="width: 90px">Cancel</a> </div> <script type="text/javascript"> var url; function newUser() {//添加 $('#dlg').dialog('open').dialog('center').dialog('setTitle', 'New User'); $('#fm').form('clear'); url = 'HisProductData.aspx?action=add'; } function editUser() {//修改 var row = $('#dg').datagrid('getSelected'); if (row) { $('#dlg').dialog('open').dialog('center').dialog('setTitle', 'Edit User'); $('#fm').form('load', row); url = 'HisProductData.aspx?action=update'; } } function saveUser() {//提交 $('#fm').form('submit', { url: url, onSubmit: function () { return $(this).form('validate'); }, success: function (result) { var result = eval('(' + result + ')'); if (result.errorMsg) { $.messager.show({ title: 'Error', msg: result.errorMsg }); } else { $('#dlg').dialog('close'); // close the dialog $('#dg').datagrid('reload'); // reload the user data } } }); } function destroyUser() {//删除 var row = $('#dg').datagrid('getSelected'); if (row) { $.messager.confirm('Confirm', 'Are you sure you want to destroy this user?', function (r) { if (r) { $.post('HisProductData.aspx?action=delete', { id: row.ID }, function (result) { if (result.success) { $('#dg').datagrid('reload'); // reload the user data } else { $.messager.show({ // show error message title: 'Error', msg: result.errorMsg }); } }, 'json'); } }); } } window.onload = function () { Load(); }; function reloadgrid() { Load() } function Load() { $('#dg').datagrid({ url: "HisProductData.aspx?action=search&CProductCode=" + $("#CProductCode").textbox("getValue"), }); } </script> </body>
后台代码：
public partial class HisProductData : PageBaseEasyui { Product_ExtensionBLL product_Extensionbll = new Product_ExtensionBLL(); ProductBLL productbll = new ProductBLL(); protected void Page_Load(object sender, EventArgs e) { switch (Action) { case "search": GetList(); break; case "add": Add(); break; case "update": Update(); break; case "delete": var id = Request["id"]; Delete(id); break; } } private void GetList() { StringBuilder filter = new StringBuilder(); filter.Append(" a.IsSuit=0"); if (!string.IsNullOrEmpty(Request["CProductCode"])) { filter.Append(" and a.ProductCode=" + Request["CProductCode"] + ""); } string where = filter.ToString(); int start = 1; int limit = 10; start = string.IsNullOrEmpty(Request.Params["page"]) ? 1 : int.Parse(Request.Params["page"]); limit = string.IsNullOrEmpty(Request.Params["rows"]) ? 10 : int.Parse(Request.Params["rows"]); string sql = String.Format(@"select a.ProductCode,a.ProductName,b.Usage,b.Dose,b.Unit,b.Frequency from MallPortal..Product as a left join MallPortal..Product_Extension as b on a.ProductCode=b.ProductCode where {2} ORDER BY a.LastModified asc OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY", (start - 1) * limit, limit, where); string sqlCount = String.Format(@"select count(*) as PCount from MallPortal..Product as a left join MallPortal..Product_Extension as b on a.ProductCode=b.ProductCode where {0}", where); //int count = productbll.GetCount(where); DataSet dsCount = DAL.Base.SqlHelper.ExecuteDataSet("MallCenter", CommandType.Text, sqlCount); List<ProductHelp> list = new List<ProductHelp>(); DataSet ds = DAL.Base.SqlHelper.ExecuteDataSet("MallCenter", CommandType.Text, sql); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ProductHelp ptModel = new ProductHelp(); ptModel.ProductCode = ds.Tables[0].Rows[i]["ProductCode"].ToString(); ptModel.ProductName = ds.Tables[0].Rows[i]["ProductName"].ToString(); ptModel.Usage = ds.Tables[0].Rows[i]["Usage"].ToString(); ptModel.Dose = ds.Tables[0].Rows[i]["Dose"].ToString(); ptModel.Unit = ds.Tables[0].Rows[i]["Unit"].ToString(); ptModel.Frequency = ds.Tables[0].Rows[i]["Frequency"].ToString(); list.Add(ptModel); } var str = new EasyuiHelper<ProductHelp>().SToJsonDataGrid(list,Convert.ToInt32( dsCount.Tables[0].Rows[0]["PCount"])); Response.Write(str); Response.End(); } public void Add() { string ProductCode = GetPam("ProductCode"); var ProductModel = productbll.GetModel(" ProductCode=" + ProductCode + ""); if (ProductModel != null) { Product_Extension Model = new Product_Extension(); Model.ProductCode = Convert.ToInt32(ProductCode); Model.ProductName = ProductModel.ProductName; Model.Manufacturer = ProductModel.Manufacturer; Model.Packing = ProductModel.Packing; Model.Manufacturer = ProductModel.Manufacturer; Model.Usage = GetPam("ProductUsage"); Model.Dose = GetPam("ProductDose"); Model.Unit = GetPam("ProductUnit"); Model.Frequency = GetPam("ProductFrequency"); Model.CreationDate = DateTime.Now; Model.LastModified = DateTime.Now; product_Extensionbll.Add(Model); } else { Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = "产品编号异常" })); Response.End(); } Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true, msg = "添加成功" })); Response.End(); } public void Update() { string ProductCode = GetPam("ProductCode"); var ProductModel = productbll.GetModel(" ProductCode=" + ProductCode + ""); if (ProductModel != null) { Product_Extension Model = new Product_Extension(); Model.ProductCode = Convert.ToInt32(ProductCode); Model.ProductName = ProductModel.ProductName; Model.Manufacturer = ProductModel.Manufacturer; Model.Packing = ProductModel.Packing; Model.Manufacturer = ProductModel.Manufacturer; Model.Usage = GetPam("Usage"); Model.Dose = GetPam("Dose"); Model.Unit = GetPam("Unit"); Model.Frequency = GetPam("Frequency"); Model.CreationDate = DateTime.Now; Model.LastModified = DateTime.Now; product_Extensionbll.Add(Model); } else { Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = "产品编号异常" })); Response.End(); } Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true, msg = "添加成功" })); Response.End(); } public void Delete(string id) { product_Extensionbll.Delete(Convert.ToInt32(id)); Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true, msg = "删除成功" })); Response.End(); } } public class ProductHelp { public string ProductCode { get; set; } public string ProductName { get; set; } public string Usage { get; set; } public string Dose { get; set; } public string Unit { get; set; } public string Frequency { get; set; } }
浙公网安备 33010602011771号