温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:热线球队财务管理系统源码
当前文件:
SmallFinance/member_save.aspx[1K,2009-6-12 11:54:22],打开代码结构图
SmallFinance/member_save.aspx[1K,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
private void Page_Load(object sender, EventArgs e) 5
{ 6
CheckSession(); 7
8
if(Request.HttpMethod.ToLower()=="post") 9
{ 10
string post_data = Request.Form["post_data[]"]; 11
12
if(post_data==null||post_data=="") 13
return; 14
15
XmlDocument root = new XmlDocument(); 16
root.LoadXml(post_data); 17
XmlElement node = (XmlElement)root.DocumentElement.ChildNodes[0]; 18
19
string request_id = node.GetAttribute("id"); 20
21
ArrayList array_strsql = new ArrayList(); 22
array_strsql.Add("if exists(Select * From TeamUser Where fchrCodeID='"+ request_id +"') Update TeamUser Set fchrCode='"+ node.GetAttribute("code") +"', fchrCodeName='"+ node.GetAttribute("name") +"', fchrSex='"+ node.GetAttribute("sex") +"', fchrModifierID='"+ md5((string)Session["Operator"]) +"', fdtmModify=GetDate() Where fchrCodeID='"+ request_id +"' else Insert TeamUser(fchrCodeID, fchrCode, fchrCodeName, fchrSex, fbitIsLeave, fchrCreatorID, fdtmCreate) Values('"+ request_id +"', '"+ node.GetAttribute("code") +"', '"+ node.GetAttribute("name") +"', '"+ node.GetAttribute("sex") +"', 0, '"+ md5((string)Session["Operator"]) +"', GetDate())"); 23
array_strsql.Add("if exists(Select * From TeamBalance Where fchrUserID='"+ request_id +"') Update TeamBalance Set flotAmount="+ node.GetAttribute("money") +" Where fchrUserID='"+ request_id +"' else Insert TeamBalance(fchrUserID, fdtmDate, flotAmount) Select '"+ request_id +"', DateAdd(Day,-1,fdtmAccount), "+ node.GetAttribute("money") +" From TeamSetting"); 24
RetrieveCountWithSqlTrans(array_strsql); 25
26
27
Response.Write("<script language=\"javascript\">;\r\n"); 28
Response.Write("alert('数据保存成功啦!^_^');\r\n"); 29
Response.Write("window.parent.location.reload();\r\n"); 30
Response.Write("</"+"script>"); 31
} 32
} 33
</script>





private 

}
}