Friday, January 22, 2010

admin_log.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class admin_admin_log : Sp.baseadmin
{
protected override void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender,e);
}
}

admin_repass.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class admin_admin_repass : Sp.baseadmin
{
protected override void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);

}
protected void Submit1_ServerClick(object sender, EventArgs e)
{
string UserPass, UserPass1;
UserPass1 = Sp.Functions.Encrypt(Sp.Functions.Tosql(this.Password1.Value), 1);
UserPass = Sp.Functions.Encrypt(Sp.Functions.Tosql(this.Password3.Value), 1);

DataTable dt = Sp.Base.ExecuteSql4Ds("SELECT * FROM Sp_admin Where id='" + admin_id + "' and adminpass='" + UserPass1 + "'").Tables[0];
if (dt.Rows.Count < 0)
{ msg.Text = "您的原始密码输入有错!"; }
else
{
string sql = "UPDATE Sp_admin SET adminpass='" + UserPass + "' where id='" + admin_id + "'";
Sp.Base.ExecuteSql(sql);
MessageBox.Show(this,"修改成功!");
}
}
}

Admin_Login.aspx.cs

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace admin
{
///
/// Admin_Login 的摘要说明。
///

public partial class Admin_Login : System.Web.UI.Page
{

protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}


protected void Submit1_ServerClick(object sender, EventArgs e)
{
string usn, pwd, vstr;
usn = Request.Form["UserName"];
pwd = Sp.Functions.Tosql(Request.Form["Password"]);
vstr = Sp.Functions.Tosql(Request.Form["vnumber"]);
//Response.Write(vstr.CompareTo(Session["Vnumber"].ToString()));
if (vstr.CompareTo(Session["Vnumber"].ToString()) == 1)
{
MessageBox.Show(this, "您输入的验证码不正确,请重新输入!");
return;
}
Sp.login lo = new Sp.login();
lo.usn = usn;
lo.pwd = pwd;
string sid=lo.adminlo();
//Response.Write(sid);
//return;
if (sid == "1")
{ MessageBox.ResponseScript("top.location.href='index.htm'"); }
else
{ MessageBox.Show(this, "您输入的密码不正确,请重新输入!"); }
}
}
}

userwin.cs

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
//该源码下载自www.51aspx.com(51aspx.com)

public class userwin
{
private string u_id;//用户id
private decimal win_money;//赢的资金+输或者是赢,有可能是负数

private DataTable user_dt;//返回用户的数据表
private DataRow this_dr;//该用户的数据行

private string maxP_uid;//该用户向上的最高一级代理用户id
private decimal maxP_gufen;//该用户向上的最高一级代理
private decimal maxP_pay;//该用户向上的最高一级代理抽水


private string[] allParen_uid;//所有我的父级代理名
private string[] allParen_gufen;//所有我的父级代理股份
private string[] allParen_pay;//所有我的父级代理抽水


public string sq="";

private string log;//操作日志
private string doone = "";

///
/// 预处理函数
///

public userwin()
{

init();
}
///
/// 预处理函数
///

private void init()
{
}

///
/// 结算
///

public void domoney(string uid,decimal winmo)
{
this.u_id = uid;
this.win_money = winmo;

//取得用户表
user_dt = Sp.SQLServerDAL.DbHelperSQL.Query("select * from Sp_user").Tables[0];

this_dr = user_dt.Select("id=" + u_id)[0];

//开始递归,的到代理参数
Parent_agent();
sq += reSqlStr();
Sp.SQLServerDAL.DbHelperSQL.ExecuteSql(sq);

}
///
/// 查看该会员是否需要抽水
///

///
private bool isneedchoushui()
{ //内部会员不抽水
bool b1 = this_dr["Prentid"].ToString() != "-1";
return b1;
}
///
/// 得到需要执行的sql语句
/// 返回sql语句字符串
///

///
private string reSqlStr()
{ //资金大于0 就抽水,否则不抽
decimal mymoney=win_money;
decimal paymoney = 0;
if (win_money > 0)
{
mymoney = win_money * (1 - maxP_pay / 100);
paymoney = win_money - mymoney;
}


//更改当前用户的的资金
string sql1 = "update sp_user set Truemoney=Truemoney+"+mymoney+" where id="+u_id+";";
sql1 += Sp.SQLServerDAL.Sp_Money_log.readdsql(mymoney.ToString(), u_id, "系统结算", "游戏输赢");
//把抽的水中的差分配给该用户所属的代理
//Sp.Functions.ResT("
k:"+allParen_pay.Length.ToString());
for (int i = allParen_pay.Length - 2; i >0 ; i--)
{
decimal pc = decimal.Parse(allParen_pay[i]) - decimal.Parse(allParen_pay[i-1]);
decimal tmoney = win_money * ( pc / 100);
sql1 += "update sp_user set Truemoney=Truemoney+" + tmoney + " where id=" + allParen_uid[i] + ";";
sql1 += Sp.SQLServerDAL.Sp_Money_log.readdsql(tmoney.ToString(), allParen_uid[i], "系统结算", "游戏抽水代理分成");
}



return sql1;

}

///
/// 递归出所有上级代理
///

private string temp1 = "0,";
private string temp2 = "0,";
private string temp3 = "0,";
private void Parent_agent()
{
string my_prentid = string.Empty;
my_prentid = this_dr["parentid"].ToString();

DrParent(my_prentid);
allParen_uid = temp1.Split(',');
allParen_gufen = temp2.Split(',');
allParen_pay = temp3.Split(',');


maxP_uid=allParen_uid[allParen_uid.Length-1];
//Sp.Functions.ResT(temp1);
maxP_gufen = decimal.Parse(allParen_gufen[allParen_gufen.Length - 2]);
maxP_pay = decimal.Parse(allParen_pay[allParen_pay.Length - 2]);

}
///
/// 执行递归
///

private void DrParent(string uid)
{
DataRow[] srows = user_dt.Select("id=" + uid);
if (srows.Length >0)
{
temp1 += srows[0]["id"] + ",";
temp2 += srows[0]["gufen"] + ",";
temp3 += srows[0]["pay"] + ",";

DrParent(srows[0]["parentid"].ToString());
}
else
{ return; }

}
///
/// 返回与我相关的代理需要添加或修改的值
///

private string up_agent()
{
throw new System.NotImplementedException();
}

}

Sp_log.cs

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

///
/// 类Sp_log。
///

public class Sp_log
{
public Sp_log()
{ }
#region Model
private int _id;
private string _loger;
private string _idname;
private DateTime _dtt;
///
///
///

public int id
{
set { _id = value; }
get { return _id; }
}
///
///
///

public string loger
{
set { _loger = value; }
get { return _loger; }
}
///
///
///

public string idname
{
set { _idname = value; }
get { return _idname; }
}
///
///
///

public DateTime dtt
{
set { _dtt = value; }
get { return _dtt; }
}
#endregion Model


#region 成员方法

///
/// 增加一条数据
///

public int Add()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sp_log(");
strSql.Append("loger,idname,dtt)");
strSql.Append(" values (");
strSql.Append("@loger,@idname,@dtt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@loger", SqlDbType.Text),
new SqlParameter("@idname", SqlDbType.VarChar,50),
new SqlParameter("@dtt", SqlDbType.DateTime)};
parameters[0].Value = loger;
parameters[1].Value = idname;
parameters[2].Value = dtt;

object obj = Sp.SQLServerDAL.DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
#endregion 成员方法
}