ajax实现增删改查的一个实例

//注悉：点击保存按钮时自动获取未发卡员工的Id无刷新异步保存卡号Id与卡号并且该员工资料被隐藏；已发卡表就显示该员工资料；如果想从第N位开始发卡，操作前必须把N-1以及其前的所有员工资料都客户端删除（此删除只是客户端隐藏display='none'，操作跟后台无关，当然数据库的数据不变）；才可以正常保存第N位员工发卡；（系统默认从未发卡员工表第一位员工开始发卡）；这个功能让哥很头疼；研究了整整两天才搞定；如果是选择CheckBox对应的发卡的话，哥一两个钟整个流程就可以搞定了；

<%@Page Language="C#" AutoEventWireup="true"CodeBehind="ME_MembersCardNo_Add.aspx.cs"Inherits="Front.Member.ME_MembersCardNo_Add" %>

<!DOCTYPE html PUBLIC "-//W3C//DTDXHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

//-----------------------------AJAX实现非执业注师无刷新发卡

// $(function () {

//$("input[isRemoveRow='true']").click(function () {

// var Id =$(this).attr("curId");

// if (confirm("真的要删除吗？")) {

//$.post("HandlerDel.ashx",{ "Id": Id },function(data,status) {

// if (status =="success") {

// alert("删除成功！");

// }

// });

// $("input[curId='"+ Id + "']").parent().parent().remove(); //AJAX删除input→td→tr,parent()指当前Id所在位置的父亲td，也就是要删除tr的话，就要删除当前Id所在input的父亲td的父亲tr；

// }

// });

//动态删除选中的行

@H_218_404@function delTableRowNo() {

@H_218_404@varinputs = document.getElementsByTagName(@H_403_59@"input");

@H_218_404@varlen = inputs.length;

@H_218_404@for(@H_218_404@vari = 0; i <len; i++) {

@H_218_404@ if (@H_403_59@"checkBox" == inputs[i].type) {

@H_218_404@if (inputs[i].checked) {

@H_218_404@if (inputs[i].id != @H_403_59@ "checkAll")

document.getElementById(inputs[i].title).style.display= @H_403_59@"none";//被选中的CheckBox客户端隐藏

//document.getElementById(inputs[i].title).style

}

@H_218_404@returnfalse;

}

//点击保存按钮是触发的javascript方法

@H_218_404@function AddTableRowNo() {

@H_218_404@varrowindex = 0;

@H_218_404@vari = 0;

@H_218_404@varCarId = document.getElementById(@H_403_59@"txtMembersCardId").value;

@H_218_404@varCarNo = document.getElementById(@H_403_59@"txtMembersCard").value;

@H_218_404@if(CarId == @H_403_59@""){

alert(@H_403_59@"@H_403_59@会员编号@H_403_59@Id@H_403_59@不能为空@H_403_59@");

@H_218_404@ return;

}

@H_218_404@if(CarNo == @H_403_59@""){

alert(@H_403_59@"@H_403_59@会员卡号不能为空@H_403_59@");

@H_218_404@ return;

}

// var IsCardTable =document.getElementById("IsCardTable");

@H_218_404@varinputs = document.getElementsByTagName(@H_403_59@"input");

@H_218_404@varinputLen = inputs.length;

　 //当遍历到checkBox的style.display不等于none时，取得该checkBox的Id就跳出for循环

@H_218_404@for(i = 0; i <inputLen; i++) {

@H_218_404@ if (@H_403_59@"checkBox" == inputs[i].type) {

@H_218_404@if (@H_403_59@"checkAll" != inputs[i].id) {

@H_218_404@if (document.getElementById(inputs[i].title).style.display!= @H_403_59@"none"){

rowindex = inputs[i].id;

@H_218_404@break;

}

//AJAX异步请求后台代码并且保存数据

@H_218_404@varnum = Front.Member.ME_MembersCardNo_Add.SaveIsCardMembersNO(rowindex,CarId,CarNo);

@H_218_404@if(rowindex != 0) {

document.getElementById(inputs[i].title).style.display = @H_403_59@"none";

　　 //AJAX异步请求查询已发卡的会员资料

@H_218_404@ var dt = Front.Member.ME_MembersCardNo_Add.ReturnIsCardTableNo()

@H_218_404@ var IsCardT = document.getElementById(@H_403_59@"IsCardTable");

// for (var j = 0; j< IsCardT.rows.length; j++) {

//document.getElementById("IsCardTable").removeChild();

// }

// for (var j = 0; j< inputLen; j++) {

// if("hidden" == inputs[j].type) {

// if("name" == inputs[j].name) {

// if ("No"!= document.getElementById("No")) {

// }

　　　//JQuery动态删除已发卡的员工表

$(@H_403_59@"#IsCardTable").remove();

　　 //JQuery动态添加已发卡的员工表（空表）

@H_218_404@ var table = $(@H_403_59@"<table id='IsCardTable' class='card_datalist'width='100%'><tr><td>@H_403_59@会员卡号@H_403_59@ID</td><td>@H_403_59@会员卡号@H_403_59@</td><td>@H_403_59@姓名@H_403_59@</td><td>@H_403_59@性别@H_403_59@</td><td>@H_403_59@身份证@H_403_59@</td><td>CPA@H_403_59@证号@H_403_59@</td></tr></table>");

$(@H_403_59@"#Addtable").append(table);

@H_218_404@ for (@H_218_404@var K = 0; K < dt.value.Rows.length; K++) {

@H_218_404@if (dt.value.Rows[K][@H_403_59@"MemberNo"] == @H_218_404@null) {

@H_218_404@var tr = $(@H_403_59@"<tr id='" + dt.value.Rows[K][@H_403_59@"Id"] + @H_403_59@"'><td>"+ dt.value.Rows[K][@H_403_59@"CarId"] + @H_403_59@"<input type='hidden' id='" + dt.value.Rows[K][@H_403_59@"Id"] + @H_403_59@"' name='name' />" + @H_403_59@ "</td><td>" + dt.value.Rows[K][@H_403_59@"CardNo"] + @H_403_59@"</td><td>" + dt.value.Rows[K][@H_403_59@"Mname"] + @H_403_59@"</td><td>" + dt.value.Rows[K][@H_403_59@"Sex"] + @H_403_59@"</td><td>" + dt.value.Rows[K][@H_403_59@"IdNo"] + @H_403_59@"</td><td>" + @H_403_59@" "+ @H_403_59@"</td></tr>")

}

@H_218_404@else {

}

$(@H_403_59@"#IsCardTable").append(tr);

}

@H_218_404@else{

alert(@H_403_59@"@H_403_59@没有发卡的会员@H_403_59@");

}

document.getElementById(@H_403_59@"txtMembersCardId").value = @H_403_59@"";

document.getElementById(@H_403_59@"txtMembersCard").value = @H_403_59@"";

}

　 </script>

</head>

<body>

<div class=@H_403_59@"Current">当前位置：<span><a href=@H_403_59@"ME_MembersCardNo_Mgr.aspx">非执业注师发卡</a></span>@H_403_59@ >>@H_403_59@ <a href=@H_403_59@"ME_MembersCardNo_Add.aspx">发卡</a><span style="color:#F00"><asp:Label

ID=@H_403_59@"lbl_title" runat=@H_403_59@"server"Text=@H_403_59@""></asp:Label></span></div>

</div>

所属事务所@H_403_59@  <asp:DropDownList ID=@H_403_59@"ddlOffice"runat=@H_403_59@"server">

<asp:ListItem Value=@H_403_59@"">--请选择--</asp:ListItem>

</asp:DropDownList>

CPA证号@H_403_59@  <asp:TextBox ID=@H_403_59@"txtCPANo"runat=@H_403_59@"server"></asp:TextBox>

姓名@H_403_59@  <asp:TextBox ID=@H_403_59@"txtName"runat=@H_403_59@"server"></asp:TextBox>

<asp:Button ID=@H_403_59@"BtnSearch"CssClass=@H_403_59@"Submit"runat=@H_403_59@"server"Text=@H_403_59@"@H_403_59@查询@H_403_59@" onclick=@H_403_59@"BtnSearch_Click"/></td></tr>

<asp:Button ID=@H_403_59@"LBtnDelMembersNoCard" CssClass=@H_403_59@"Submit"runat=@H_403_59@"server" OnClientClick=@H_403_59@"return delTableRowNo();" Text=@H_403_59@"@H_403_59@删除不需发卡注师@H_403_59@"/>

</td></tr></table>

</td></tr>

<tr>

</td>

<td>

会员卡号ID

</td>

<td>

会员卡号

</td>

<td>

姓名

</td>

<td>

性别

</td>

<td>

身份证

</td>

<td>

CPA证号

</td>

</tr>

<asp:Repeater ID=@H_403_59@"Repeater1"runat=@H_403_59@"server">

<%--<input id=@H_403_59@"checkBox1"type=@H_403_59@"checkBox" isEditRow=@H_403_59@"true" value=@H_403_59@'<%#Eval("Id")%>'/>--%>

<%--<asp:CheckBox ID=@H_403_59@"CheckBox1"runat=@H_403_59@"server"ToolTip=@H_403_59@'<%# Eval("Id") %>' isEditRow=@H_403_59@"true"></asp:CheckBox>--%>

<input type=@H_403_59@"checkBox" id=@H_403_59@'<%#Eval("Id")%>'title=@H_403_59@'<%#Eval("Id")%>'/>

<asp:HiddenFieldID=@H_403_59@"HiddenField1"runat=@H_403_59@"server"Value=@H_403_59@'<%#Eval("Id")%>' />

</td>

<td>

<%#Eval("CarId")%>

</td>

<td>

<%#Eval("CardNo")%>

</td>

<td>

<%#Eval("Mname")%>

</td>

<td>

<%#Eval("Sex")%>

</td>

<td>

<%#Eval("IdNo")%>

</td>

<td>

<%#Eval("MemberNo")%>

</td>

</tr>

</ItemTemplate>

</asp:Repeater>

</table>

</td>

</tr>

</table>

<tr>

<tr>

<%--<td>

</td>--%>

<td>

会员卡号ID

</td>

<td>

会员卡号

</td>

<td>

姓名

</td>

<td>

性别

</td>

<td>

身份证

</td>

<td>

CPA证号

</td>

</tr>

<asp:Repeater ID=@H_403_59@"Repeater2"runat=@H_403_59@"server">

<tr >

<%-- <td>

<asp:CheckBoxID=@H_403_59@"CheckBox1"runat=@H_403_59@"server"/>

</td>--%>

<td>

<%#Eval("CarId")%>

</td>

<td>

<%#Eval("CardNo")%>

</td>

<td>

<%#Eval("Mname")%>

</td>

<td>

<%#Eval("Sex")%>

</td>

<td>

<%#Eval("IdNo")%>

</td>

<td>

<%#Eval("MemberNo")%>

</td>

</tr>

</ItemTemplate>

</asp:Repeater>

</table>

</td>

</tr>

</table>

<h3><span style=" font-size:14px;">@H_403_59@   增加会员卡号</span></h3>

会员卡号Id@H_403_59@  <asp:TextBoxID=@H_403_59@"txtMembersCardId"runat=@H_403_59@"server" onkeyup=@H_403_59@"value=value.replace(/[^\w\.\/]/ig,'')"> </asp:TextBox>@H_403_59@                

会员卡号@H_403_59@  <asp:TextBox ID=@H_403_59@"txtMembersCard"runat=@H_403_59@"server"onkeyup=@H_403_59@"value=value.replace(/[^\w\.\/]/ig,'')"> </asp:TextBox>

</td></tr>

<%--<asp:Button ID=@H_403_59@"BtnSaveCard"class=@H_403_59@"form_buttom"runat=@H_403_59@"server"Text=@H_403_59@"@H_403_59@保存@H_403_59@" OnClientClick=@H_403_59@"return checkBtn();" onclick=@H_403_59@"BtnSaveCard_Click"/>--%>

<input type=@H_403_59@"button"class=@H_403_59@"form_buttom" id=@H_403_59@"button1" onclick=@H_403_59@"AddTableRowNo();" value=@H_403_59@"@H_403_59@保存@H_403_59@"/> @H_403_59@    

<asp:Button ID=@H_403_59@"Button1"class=@H_403_59@"form_buttom"runat=@H_403_59@"server"Text=@H_403_59@"@H_403_59@返回@H_403_59@" onclick=@H_403_59@"Button1_Click"/>

</td></tr></table>

</div></div>

</form>

</body>

</html>

ajax实现增删改查的一个实例

猜你在找的Ajax相关文章