温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:热线球队财务管理系统源码
当前文件:
SmallFinance/member.aspx[10K,2009-6-12 11:54:22],打开代码结构图
SmallFinance/member.aspx[10K,2009-6-12 11:54:22],打开代码结构图1<%@ Page language="c#" ContentType="text/html" ResponseEncoding="gb2312" %> 2
<!--#include file="config.inc.aspx"--> 3
<script runat="server"> 4
public int intTotalCount = 0; 5
6
private void Page_Load(object sender, EventArgs e) 7
{ 8
CheckSession(); 9
10
Response.Write("<xml id=\"xmlDetail\">\n"); 11
BindGrid(); 12
Response.Write("\n</xml>"); 13
} 14
15
void BindGrid() 16
{ 17
string strsql_count = "Select Count(*) From TeamUser"; 18
intTotalCount = (int)RetrieveCountWithSqlScalar(strsql_count); 19
if(intTotalCount==0) 20
return; 21
22
23
Response.Write("<data>"); 24
25
string strsql_query = "Select m.fchrCodeID, m.fchrCode, m.fchrCodeName, m.fchrSex, b.flotAmount, m.fbitIsLeave, Convert(bit, isNull(u.fbitIsUsed,0)) From TeamUser m Left Join TeamBalance b On b.fchrUserID=m.fchrCodeID Left Join UniteCode u On u.fchrCodeID=m.fchrCodeID Order By m.fchrCode"; 26
SqlDataReader rdUser = RetrieveRowsWithDataReader(strsql_query); 27
while(rdUser.Read()) 28
{ 29
Response.Write("<Person id=\""+ rdUser.GetString(0) +"\" code=\""+ rdUser.GetString(1) +"\" name=\""+ rdUser.GetString(2) +"\" sex=\""+ rdUser.GetString(3) +"\" money=\""+ rdUser.GetDecimal(4).ToString("n2") +"\" leave=\""+ rdUser.GetBoolean(5) +"\" used=\""+ rdUser.GetBoolean(6) +"\" />"); 30
} 31
rdUser.Close(); 32
33
Response.Write("</data>"); 34
} 35
</script> 36
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 37
<html> 38
<head> 39
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> 40
<title>热线财务管理系统</title> 41
<link href="style.css" rel="stylesheet" type="text/css"> 42
<script language="javascript" src="script/function.js"></script> 43
<script language="vbscript" src="script/function.vbs"></script> 44
<script language="javascript" src="script/dialog.js"></script> 45
<script language="javascript"> 46
var selectRow = null; 47
var length = 0; 48
49
function queryDialog() 50
{ 51
var dialogs = new dialog(); 52
dialogs.init(); 53
dialogs.set('width', 300); 54
dialogs.set('height', 100); 55
dialogs.set('title', '系统提示信息'); 56
dialogs.html('<table align="center" style="margin:10px"> <tr><td>按照:<input type="radio" id="radCode" name="radCode">编码 或 <input type="radio" id="radName" name="radName" checked>昵称 进行过滤</td></tr> <tr><td>请输入查询过滤关键字:</td></tr> <tr><td><input maxLength="10" id="Keywords" name="Keywords" style="width:200px"></td></tr> <tr><td colspan="2" height="40" align="center"><input type="button" class="plane" onClick="queryTo()" value="确定" style="width:50px"></td></tr> </table>'); 57
} 58
59
function queryTo() 60
{ 61
if(radCode.checked) 62
{ 63
if(trimStr(Keywords.value)=="") 64
{ 65
alert("请输入队员编码定位!"); 66
return; 67
} 68
Location("code",trimStr(Keywords.value)); 69
} 70
71
if(radName.checked) 72
{ 73
if(trimStr(Keywords.value)=="") 74
{ 75
alert("请输入队员昵称定位!"); 76
return; 77
} 78
Location("name",trimStr(Keywords.value)); 79
} 80
} 81
82
function Location(strType,strCond) 83
{ 84
var intCol; 85
var intRow = 0; 86
87
if(strType=="code") 88
intCol = 1; 89
else if(strType=="name") 90
intCol = 2; 91
92
for(var i=1;i<UsersList.rows.length;i++) 93
{ 94
var objRow = UsersList.rows(i); 95
96
objRow.className = (i%2==0) ? "tr_1" : "tr_2"; 97
98
var strFind = objRow.cells(intCol).innerText; 99
strFind = strFind.toUpperCase(); 100
strCond = strCond.toUpperCase(); 101
if(strFind.indexOf(strCond)!=-1) 102
{ 103
objRow.className = "tr_click"; 104
if(intRow==0) 105
intRow = i; 106
} 107
} 108
109
if(intRow==0) 110
{ 111
alert("没有所要找的队员!"); 112
} 113
else 114
{ 115
UsersList.rows(intRow).scrollIntoView(true); 116
} 117
} 118
119
120
function leaveTo() 121
{ 122
if(length==0) 123
return; 124
125
var arrIds = new Array(); 126
var count = 0; 127
128
for(var i=0;i<length;i++) 129
{ 130
var chk_obj = (length==1) ? $("item") : $$("item")[i]; 131
132
if(chk_obj.checked&&!chk_obj.disabled) 133
arrIds[count++] = chk_obj.value; 134
} 135
136
if(count==0) 137
{ 138
alert("没有选择任何记录!"); 139
return; 140
} 141
142
var action = "member_leave.aspx"; 143
var postdata = arrIds.join(";"); 144
145
if(confirm("你确认要操作这些信息吗?")==true) 146
AddButtonAction(action, postdata); 147
} 148
149
function showDialog() 150
{ 151
var dialogs = new dialog(); 152
dialogs.init(); 153
dialogs.set('width', 320); 154
dialogs.set('height', 80); 155
dialogs.set('title', '系统提示信息'); 156
dialogs.event('', '', '', 'clearCss()'); 157
158
var body_html = '<input type="hidden" id="Value_ID" name="Value_ID">\ 159
<table align="center" style="margin:10px">\ 160
<tr>\ 161
<td>队员编码:</td>\ 162
<td><input name="Value_Code" type="text" id="Value_Code" maxlength="25" style="width:125px;"></td>\ 163
</tr>\ 164
<tr>\ 165
<td>队员昵称:</td>\ 166
<td><input name="Value_Name" type="text" id="Value_Name" maxlength="25" style="width:125px;"></td>\ 167
</tr>\ 168
<tr>\ 169
<td>性 别:</td>\ 170
<td><select id="Value_Sex" name="Value_Sex"><option value=""></option><option value="男">男</option><option value="女">女</option></select></td>\ 171
</tr>\ 172
<tr>\ 173
<td>期初余额:</td>\ 174
<td><input name="Value_Balance" type="text" id="Value_Balance" maxlength="25" style="width:125px;" onChange="textMoney_onchange()" onFocus="this.select()" value="0.00" onKeyPress="DecimalInput()"></td>\ 175
</tr>\ 176
<tr>\ 177
<td colspan="2" height="40px" align="center"><input type="button" class="plane" onClick="saveTo()" value="保 存"></td>\ 178
</tr>\ 179
</table>'; 180
181
dialogs.html(body_html); 182
} 183
184
function textMoney_onchange() 185
{ 186
var obj = $("Value_Balance"); 187
188
if((obj.value=="")||(obj.value==".")) 189
obj.value = "0"; 190
191
obj.value = formatFloatNumber(obj.value); 192
} 193
194
function clearCss() 195
{ 196
if(selectRow==null) 197
return; 198
199
selectRow.className = (selectRow.rowIndex%2==0) ? "tr_2" : "tr_1"; 200
selectRow = null; 201
} 202
203
function addTo() 204
{ 205
showDialog(); 206
207
$("Value_ID").value = $("hidAutoID").value; 208
$("Value_Code").value = ""; 209
$("Value_Name").value = ""; 210
$("Value_Sex").value = ""; 211
$("Value_Balance").value = "0.00"; 212
} 213
214
function modifyTo() 215
{ 216
var oSrc = window.event.srcElement; 217
218
selectRow = oSrc.parentElement.parentElement; 219
selectRow.className = "tr_click"; 220
221
showDialog(); 222
223
var node = xmlDetail.documentElement.childNodes(selectRow.rowIndex-1); 224
225
$("Value_ID").value = node.getAttribute("id"); 226
$("Value_Code").value = node.getAttribute("code"); 227
$("Value_Name").value = node.getAttribute("name"); 228
$("Value_Sex").value = node.getAttribute("sex"); 229
$("Value_Balance").value = node.getAttribute("money"); 230
} 231
232
233
function deleteTo() 234
{ 235
var oSrc = window.event.srcElement; 236
237
selectRow = oSrc.parentElement.parentElement; 238
selectRow.className = "tr_click"; 239
240
var node = xmlDetail.documentElement.childNodes(selectRow.rowIndex-1); 241
242
var action = "member_delete.aspx"; 243
var postdata = node.getAttribute("id"); 244
245
if(confirm("你确认要删除这条信息吗?")==true) 246
AddButtonAction(action, postdata); 247
else 248
clearCss(); 249
} 250
251
function check() 252
{ 253
if($("Value_Code").value=="") 254
{ 255
alert("你忘记输入队员编码了!"); 256
return false; 257
} 258
if($("Value_Name").value=="") 259
{ 260
alert("你忘记输入队员昵称了!"); 261
return false; 262
} 263
264
if(xmlDetail.documentElement==null) 265
return true; 266
267
for(var i=0;i<xmlDetail.documentElement.childNodes.length;i++) 268
{ 269
var node = xmlDetail.documentElement.childNodes(i); 270
271
var code = node.getAttribute("code"); 272
var name = node.getAttribute("name"); 273
var id = node.getAttribute("id"); 274
275
if((code==$("Value_Code").value)&&(id!=$("Value_ID").value)) 276
{ 277
alert("编码已存在,请重新输入!"); 278
return false; 279
} 280
281
if((name==$("Value_Name").value)&&(id!=$("Value_ID").value)) 282
{ 283
alert("昵称已存在,请重新输入!"); 284
return false; 285
} 286
} 287
288
return true; 289
} 290
291
function saveTo() 292
{ 293
if(!check()) 294
return; 295
296
var xmlTemp = new ActiveXObject("Microsoft.XMLDOM"); 297
var root = xmlTemp.createNode(1,"data",""); 298
xmlTemp.appendChild(root); 299
var node = xmlTemp.createNode(1,"row",""); 300
node.setAttribute("id",$("Value_ID").value); 301
node.setAttribute("name",$("Value_Name").value); 302
node.setAttribute("code",$("Value_Code").value); 303
node.setAttribute("sex",$("Value_Sex").value); 304
node.setAttribute("money",parseFloatNumber($("Value_Balance").value)); 305
root.appendChild(node); 306
307
var action = "member_save.aspx"; 308
var postdata = xmlTemp.xml; 309
310
AddButtonAction(action, postdata); 311
} 312
</script> 313
</head> 314
<body> 315
<table class="header"> 316
<tr> 317
<td><img src="images/icon_state.gif" /></td> 318
<td width="100%">队员档案</td> 319
<td><input type="button" class="btn" value=" 查找 " onClick="javascript:queryDialog()" /></td> 320
<td><input type="button" class="btn" value=" 离队 " onClick="javascript:leaveTo()" /></td> 321
<td><input type="button" class="btn" value=" 新增 " onClick="javascript:addTo()" /></td> 322
</tr> 323
</table> 324
325
<table> 326
<tr> 327
<td>共有 <%= intTotalCount.ToString() %> 名球员:其中男队员 人,女队员 人</td> 328
</tr> 329
</table> 330
331
<div id="divMain" style="width:100%; overflow:auto" align="center"></div> 332
333
<input type="hidden" name="hidAutoID" id="hidAutoID" value="<%= GetRandomID("user") %>" /> 334
</body> 335
</html> 336
<script language="javascript"> 337
function displayTree() 338
{ 339
var html = ""; 340
341
if(xmlDetail.documentElement==null) 342
{ 343
html = "<div style=\"margin-top:50px\" class=\"b s\">没有相关的信息!</div>"; 344
} 345
else 346
{ 347
html += "<table id='UsersList' class='table' cellspacing='1' cellpadding='4' border='0'>"; 348
html += "<tr class='header'><td>选择</td><td>队员编码</td><td>队员昵称</td><td>性别</td><td>期初余额</td><td>是否离队</td><td>修改</td><td>删除</td></tr>"; 349
350
length = xmlDetail.documentElement.childNodes.length; 351
352
for(var i=0;i<length;i++) 353
{ 354
node = xmlDetail.documentElement.childNodes(i); 355
356
html += (i%2==0) ? "<tr class='tr_1'>" : "<tr class='tr_2'>"; 357
358
html += "<td align=\"center\"><input name=\"item\" type=\"checkbox\" id=\"item\" value=\""+ node.getAttribute("id") +"\""+ (isBool(node.getAttribute("leave")) ? " disabled" : "") +" /></td>"; 359
html += "<td>"+ node.getAttribute("code") +"</td>"; 360
html += "<td>"+ node.getAttribute("name") +"</td>"; 361
html += "<td>"+ node.getAttribute("sex") +"</td>"; 362
html += "<td align=\"right\">"+ node.getAttribute("money") +"</td>"; 363
html += "<td align=\"center\">"+ (isBool(node.getAttribute("leave")) ? "<font color=red>是</font>" : "") +"</td>"; 364
html += "<td align=\"center\"><img src=\"images/icon_edit.gif\" style=\"cursor:pointer\" onclick=\"javascript:modifyTo()\" /></td>"; 365
html += "<td align=\"center\">"+ (isBool(node.getAttribute("used")) ? "" : "<img src=\"images/icon_delete.gif\" style=\"cursor:pointer\" onclick=\"javascript:deleteTo()\" />") +"</td>"; 366
367
html += "</tr>"; 368
} 369
} 370
371
html += "</table>"; 372
373
divMain.innerHTML = html; 374
} 375
376
function GetOffsetTop(objObject) 377
{ 378
var intTop = objObject.offsetTop; 379
var objParent = objObject.offsetParent; 380
while(null!=objParent) 381
{ 382
intTop += objParent.offsetTop; 383
objParent = objParent.offsetParent; 384
} 385
return intTop; 386
} 387
388
function window.onload() 389
{ 390
divMain.style.height = document.body.offsetHeight - GetOffsetTop(divMain); 391
392
displayTree(); 393
} 394
</script> 395





public 

}
}