private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(0) || !MyTeam.OnlineList.OnlineList.isUserLogin(0))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader("SELECT top 1 convert(nvarchar,updatetime,11) as updatetime,content,qishu,kaisai,isclose FROM affiche WHERE le=1 ORDER BY updatetime DESC");
if (reader.Read())
{
this.msg = this.msg + MyFunc.ConvertStr(reader["content"].ToString().Trim());
this.qishu = reader["qishu"].ToString().Trim();
this.kaisai = reader["kaisai"].ToString().Trim();
this.isclose = reader["isclose"].ToString();
}
reader.Close();
base2.Dispose();
this.AHHTContent();
this.DataBind();
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(0))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if ((!base.IsPostBack && (base.Request.QueryString["userid"] != null)) && (base.Request.QueryString["userid"].ToString().Trim() != ""))
{
string text = base.Request.QueryString["userid"].ToString().Trim().Replace(" ", "").Replace("'", "");
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader("SELECT * FROM PLUSER WHERE userid=" + text);
if (reader.Read())
{
this.TextBoxUserName.Text = reader["username"].ToString().Trim();
this.TextBoxUserPass1.Text = "";
this.TextBoxUserPass2.Text = "";
this.TextBoxUserid.Text = reader["userid"].ToString().Trim();
this.TextBoxTrueName.Text = reader["truename"].ToString().Trim();
this.DropDownListIsuseable.SelectedValue = (reader["isuseable"].ToString().Trim().ToUpper() == "TRUE") ? "1" : "0";
reader.Close();
base2.Dispose();
}
else
{
reader.Close();
base2.Dispose();
MyFunc.showmsg("没有该用户");
base.Response.End();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!base.IsPostBack)
{
int num = 0;
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
this.DropDownListGd.Items.Clear();
this.DropDownListGd.Items.Add(new ListItem("请选择", "00"));
SqlDataReader reader = base2.ExecuteReader("SELECT userid,username FROM agence WHERE classid=2");
while (reader.Read())
{
num++;
this.DropDownListGd.Items.Add(new ListItem(reader["username"].ToString().Trim(), reader["userid"].ToString().Trim()));
}
reader.Close();
this.DropDownListGd.SelectedIndex = 0;
base2.Dispose();
if (num == 0)
{
MyFunc.showmsg("还没有股东，请先添加股东！");
base.Response.End();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
this.startTime = DateTime.Now;
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!base.IsPostBack)
{
if ((base.Request.QueryString["action"] != null) && (base.Request.QueryString["action"].ToString().Trim() != ""))
{
string ballid = base.Request.QueryString["ballid"].ToString().Trim().Replace(" ", "").Replace("'", "").Replace("%", "");
if (base.Request.QueryString["action"].ToString().Trim() == "stop")
{
this.StopGame(ballid);
}
else if (base.Request.QueryString["action"].ToString().Trim() == "open")
{
this.OpenGame(ballid);
}
}
string sql = "SELECT Ball_PL1.ballid,Ball_PL1.balltime,Ball_PL1.matchname,Ball_PL1.matchcolor,Ball_PL1.team1,Ball_PL1.team2, Ball_PL1.homeway,Ball_PL1.isautoshow,Ball_PL1.iszd,";
sql = sql + "Ball_PL1.iscurzd,Ball_PL1.iszdclose,Ball_PL1.iszddt,Ball_BF.isshow,Ball_BF.isclose,Ball_BF.iscancel FROM Ball_BF RIGHT OUTER JOIN Ball_PL1 ON Ball_BF.ballid = Ball_PL1.ballid WHERE (Ball_PL1.isautoshow = 1)";
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader(sql);
while (reader.Read())
{
string kyglContent = this.kyglContent;
this.kyglContent = kyglContent + "<tr bgcolor=\"#FFFFFF\"><td>" + reader["balltime"].ToString().Trim() + "</td><td><span style=\"background-color:" + reader["matchcolor"].ToString().Trim() + "; color: '#ffffff';\">" + reader["matchname"].ToString().Trim() + "</font></td><td>" + reader["team1"].ToString().Trim() + " <font color=red>" + reader["homeway"].ToString().Trim() + "</font><br>" + reader["team2"].ToString().Trim() + "</td><td>";
if (reader["iscurzd"].ToString().Trim().ToUpper() == "TRUE")
{
this.kyglContent = this.kyglContent + "当前走地";
}
else if (reader["iszd"].ToString().Trim().ToUpper() == "TRUE")
{
this.kyglContent = this.kyglContent + "走地";
}
else
{
this.kyglContent = this.kyglContent + " ";
}
this.kyglContent = this.kyglContent + "</td><td>";
if (reader["isshow"].ToString().Trim().ToUpper() == "TRUE")
{
this.kyglContent = this.kyglContent + "收单";
}
else
{
this.kyglContent = this.kyglContent + "停止";
}
string text4 = this.kyglContent;
this.kyglContent = text4 + "</td><td><a href=mgrgame.aspx?action=stop&ballid=" + reader["ballid"].ToString().Trim() + ">停押</a> / <a href=mgrgame.aspx?action=open&ballid=" + reader["ballid"].ToString().Trim() + ">启用</a></td></tr>";
}
reader.Close();
base2.Dispose();
this.DataBind();
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(0) || !MyTeam.OnlineList.OnlineList.isUserLogin(0))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
string table = "";
string url = "";
if ((base.Request.Form["action"] != null) && (base.Request.Form["action"].ToString().Trim() != ""))
{
this.kygl = base.Request.Form["action"].ToString().Trim();
if (base.Request.Form["fr_league"] != null)
{
this.SetSessionLeague(base.Request.Form["action"].ToString().Trim(), base.Request.Form["fr_league"].ToString().Trim());
url = this.GetUrl((base.Request.Form["action"].ToString().Trim() == "") ? "AH" : base.Request.Form["action"].ToString().Trim());
base.Response.Redirect(url);
}
}
if ((base.Request.QueryString["kygl"] != null) && (base.Request.QueryString["kygl"].ToString().Trim() != ""))
{
this.kygl = base.Request.QueryString["kygl"].ToString().Trim().ToUpper();
table = this.GetTableName(this.kygl);
this.MainTable.Rows[1].Cells[0].InnerHtml = this.GetLeague(table, this.kygl);
this.DataBind();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
}
else if (!base.IsPostBack)
{
string text;
string text2;
if (((base.Request.QueryString["date_start"] != null) && (base.Request.QueryString["date_start"].ToString().Trim() != "")) && ((base.Request.QueryString["date_end"] != null) && (base.Request.QueryString["date_end"].ToString().Trim() != "")))
{
text = base.Request.QueryString["date_start"].ToString().Trim();
text2 = base.Request.QueryString["date_end"].ToString().Trim();
}
else
{
text = DateTime.Now.ToShortDateString();
text2 = DateTime.Now.ToShortDateString();
}
DataSet set = new DataBase(MyFunc.GetConnStr(2)).ExecuteDataSet("SELECT ballid,matchname,team1,team2,sortballtime FROM ball_bf WHERE sortballtime between '" + text + " 00:00:00' and '" + text2 + " 23:59:59' ORDER BY sortballtime");
this.DataGrid1.DataSource = set;
this.DataGrid1.DataBind();
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
((CheckBox)this.DataGrid1.Items[i].FindControl("cbxStatus")).Attributes["OnClick"] = "AddToList(this,'" + set.Tables[0].Rows[i]["ballid"].ToString().Trim() + "');";
}
}
}
private void UpdateAllBallMsg()
{
if (!MyFunc.CheckUserLogin(0) || ((this.Session.Contents["classid"].ToString().Trim() != "1") && (this.Session.Contents["classid"].ToString().Trim() != "2")))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
string text3 = base.Request.Form["maxc1"].ToString().Trim();
string text4 = base.Request.Form["maxc2"].ToString().Trim();
string text2 = base.Request.Form["plvalue"].ToString().Trim();
string sql = "SELECT bk.ballid,bk.balltime,bk.matchname,bk.team1,bk.team2,bk.homeway,bk.isautoshow,bf.isshow,bf.isclose,bf.iscancel,bf.isauto,bf.serverlist,bf.maxc1,bf.maxc2 ";
sql = sql + "FROM Ball_BF as bf RIGHT OUTER JOIN BK_Ball_PL1 as bk ON bf.ballid = bk.ballid WHERE bf.isbk = 1 AND " + text2 + " = convert(numeric(6,3),bk.giveup1) + convert(numeric(6,3),bk.giveup2) and bk.isautoshow = 1 AND DATEDIFF(d,bf.sortballtime,getdate()) = 0 ORDER BY bf.sortballtime";
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
DataBase base3 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader(sql);
while (reader.Read())
{
string text = reader["ballid"].ToString().Trim();
base3.ExecuteNonQuery("UPDATE ball_bf SET maxc1=" + text3 + ",maxc2=" + text4 + " WHERE isbk = 1 AND ballid=" + text);
}
base2.Dispose();
base3.Dispose();
base.Response.Redirect("basketballlist.aspx");
}
}
private void del_Click(object sender, EventArgs e)
{
if (!MyFunc.CheckUserLogin(this.Session.Contents["adminusername"].ToString().Trim(), this.Session.Contents["adminuserpass"].ToString().Trim(), "1", 1))
{
MyFunc.goToLoginPage("../");
base.Response.End();
}
else if (this.username.Text.Trim() == "")
{
MyFunc.showmsg("请输入要删除的用户帐号！");
base.Response.End();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
if (this.selects.SelectedItem.Value == "1")
{
string userId = this.GetUserId(this.username.Text.Trim());
string dlsId = this.GetDlsId(this.username.Text.Trim());
base2.ExecuteNonQuery("delete userhs where userid = '" + userId + "'");
base2.ExecuteNonQuery("delete ball_order where username = '******'");
base2.ExecuteNonQuery("delete member where username = '******'");
base2.ExecuteNonQuery("update agence set memcount = memcount-1 where userid = '" + dlsId + "'");
base.Response.Write("<script>alert('成功删除会员" + this.username.Text + "和该会员的注单');</script>");
}
else if (this.selects.SelectedItem.Value == "2")
{
int num = 0;
num = base2.ExecuteNonQuery("delete ball_order where username = '******' and updatetime between '" + this.starTime.Text.Trim() + "' and '" + this.endTime.Text.Trim() + "'");
base.Response.Write("<script>alert('共删除会员" + this.username.Text + "的" + num.ToString() + "个注单');</script>");
}
base2.CloseConnect();
base2.Dispose();
}
}
private void UpdateBf(string ballid, string btype, string fen1, string fen2)
{
if (!MyFunc.CheckUserLogin(0) || ((this.Session.Contents["classid"].ToString().Trim() != "1") && (this.Session.Contents["classid"].ToString().Trim() != "2")))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader("SELECT fen1,fen2 FROM ball_bf WHERE ballid=" + ballid);
string sql = "";
if (reader.Read())
{
if (btype == "2")
{
reader.Close();
sql = "UPDATE ball_bf SET fen2='" + fen1 + ":" + fen2 + "' WHERE ballid = " + ballid + " AND isBK = 1";
base2.ExecuteNonQuery(sql);
base2.Dispose();
}
}
else
{
reader.Close();
base2.Dispose();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if ((!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1)) || !MyFunc.CheckUserLogin(this.Session.Contents["adminusername"].ToString().Trim(), this.Session.Contents["adminuserpass"].ToString().Trim(), "1", 1))
{
MyFunc.goToLoginPage();
}
else if (!base.IsPostBack)
{
if ((base.Request.QueryString["ballid"] != null) && (base.Request.QueryString["ballid"].ToString().Trim() != ""))
{
this.kyglBallid = base.Request.QueryString["ballid"].ToString().Trim();
if ((base.Request.QueryString["jstype"] != null) && (base.Request.QueryString["jstype"].ToString().Trim() != ""))
{
this.kyglJstype = base.Request.QueryString["jstype"].ToString().Trim();
}
if ((base.Request.QueryString["thisdate"] != null) && (base.Request.QueryString["thisdate"].ToString().Trim() != ""))
{
this.kyglThisdate = base.Request.QueryString["thisdate"].ToString().Trim();
}
this.DataBind();
}
else
{
MyFunc.showmsg("请选择要结算的球赛");
base.Response.End();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
if ((base.Request.QueryString["takeOut"] != "") && (base.Request.QueryString["takeOut"] != null))
{
MyTeam.OnlineList.OnlineList.DelUser(base.Request.QueryString["takeOut"]);
}
if (!base.IsPostBack)
{
if ((base.Request.QueryString["kygl"] != null) && (base.Request.QueryString["kygl"].ToString().Trim() != ""))
{
this.DropDownListShowType.SelectedValue = base.Request.QueryString["kygl"].ToString().Trim();
}
this.kyglClass = this.DropDownListShowType.SelectedValue;
string[][] onlineLists = MyTeam.OnlineList.OnlineList.GetOnlineList();
this.OnlineListTable.Rows[1].Cells[0].InnerHtml = this.printOnlineUserTable(onlineLists, "", this.DropDownListShowType.SelectedValue, "");
this.DropDownListShowType.AutoPostBack = true;
this.OnlineListTable.Rows[2].Cells[0].InnerHtml = "<font color=red><div align=left>共有" + MyTeam.OnlineList.OnlineList.CountUser().ToString() + "人在线</div></font>";
this.DataBind();
}
}
}
private void BfUserMod(string userid, int flag)
{
if (!MyFunc.CheckUserLogin(0) || ((this.Session.Contents["classid"].ToString().Trim() != "1") && (this.Session.Contents["classid"].ToString().Trim() != "2")))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!MyFunc.CheckUserLogin(0) || ((this.Session.Contents["classid"].ToString().Trim() != "1") && (this.Session.Contents["classid"].ToString().Trim() != "2")))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
if (flag == 1)
{
base2.ExecuteNonQuery("UPDATE Pluser SET isuseable=1 WHERE userid=" + userid + " and classid=3");
}
else
{
base2.ExecuteNonQuery("UPDATE Pluser SET isuseable=0 WHERE userid=" + userid + " and classid=3");
}
base2.Dispose();
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if ((!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1)) && (!MyFunc.CheckUserLogin(2) || !MyTeam.OnlineList.OnlineList.isUserLogin(2)))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!this.Page.IsPostBack)
{
if (base.Request.QueryString["search"] != null)
{
if (base.Request["search"].ToString() != "")
{
this.GetValue();
this.PrintBarTitle();
this.SetShowPage();
}
}
else
{
base.Response.Write("查询页面出错，请检测你的查询条件！");
base.Response.End();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
}
else if ((base.Request.QueryString["id"] != null) && (base.Request.QueryString["id"].ToString().Trim() != ""))
{
this.TextBoxBorder(true);
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader("SELECT userid,username,userpass,truename,usemoney,maxmem FROM agence WHERE userid=" + base.Request.QueryString["id"].ToString().Trim());
if (reader.Read())
{
this.TextBoxGsID.Text = reader["userid"].ToString().Trim();
this.pubshowpass = reader["userpass"].ToString().Trim();
this.TextBoxUserName.Text = reader["username"].ToString().Trim();
this.TextBoxTrueName.Text = reader["truename"].ToString().Trim();
this.TextBoxUseMoney.Text = reader["usemoney"].ToString().Trim();
this.TextBoxMaxMem.Text = reader["maxmem"].ToString().Trim();
reader.Close();
base2.Dispose();
}
else
{
reader.Close();
base2.Dispose();
MyFunc.showmsg("没有该公司! ");
}
}
}
}
public void DelDls(string id, string zdlid)
{
if (!MyFunc.CheckUserLogin(this.Session.Contents["adminusername"].ToString().Trim(), this.Session.Contents["adminuserpass"].ToString().Trim(), this.Session.Contents["adminclassid"].ToString().Trim(), 1))
{
MyFunc.goToLoginPage();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
int num = (int)base2.ExecuteScalar("SELECT COUNT(*) FROM member WHERE dlsid=" + id);
if (num > 0)
{
base2.Dispose();
MyFunc.showmsg("该代理商下还有会员,不能删除该代理商");
base.Response.End();
}
else if (base2.ExecuteNonQuery("DELETE FROM agence WHERE userid=" + id + " AND classid=4") > 0)
{
base2.ExecuteNonQuery("UPDATE agence SET memcount=memcount-1 WHERE userid=" + zdlid);
base2.Dispose();
MyFunc.JumpPage("删除该代理商成功", "dlslist.aspx");
base.Response.End();
}
else
{
base2.Dispose();
MyFunc.showmsg("删除代理商失败");
base.Response.End();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!this.Page.IsPostBack)
{
this.setstartdatagrid();
}
else if (base.Request.Form["submitflag"].ToString() != "")
{
if (this.subid.Value != "")
{
this.editdeal();
}
else
{
this.adddeal();
}
this.submitflag.Value = "";
this.subid.Value = "";
this.editsubdiv.Style.Add("DISPLAY", "none");
this.setstartdatagrid();
}
}
private void Page_Load(object sender, EventArgs e)
{
if ((this.Session.Contents["adminsubid"] != null) && (this.Session.Contents["adminsubid"].ToString() != ""))
{
if (!MyFunc.CheckUserLogin(2) || !MyTeam.OnlineList.OnlineList.isUserLogin(2))
{
MyFunc.goToLoginPage();
base.Response.End();
return;
}
}
else if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
return;
}
if (base.Request.QueryString["search"] != null)
{
if (base.Request["search"].ToString() != "")
{
this.GetValue();
this.SetShowPage();
}
}
else
{
base.Response.Write("查询页面出错，请检测你的查询条件！");
base.Response.End();
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!base.IsPostBack)
{
if ((base.Request.QueryString["id"] != null) && (base.Request.QueryString["id"].ToString().Trim() != ""))
{
string text = base.Request.QueryString["id"].ToString().Trim();
DataBase db = new DataBase(MyFunc.GetConnStr(2));
this.DropDownListRate.Items.Clear();
SqlDataReader reader = db.ExecuteReader("SELECT * FROM rate");
while (reader.Read())
{
this.DropDownListRate.Items.Add(new ListItem(reader["type"].ToString().Trim(), reader["rate"].ToString().Trim()));
}
reader.Close();
this.LabelGd.Text = this.Session.Contents["adminusername"].ToString().Trim();
this.LabelUseMoney.Text = "";
SqlDataReader reader2 = db.ExecuteReader("SELECT userid,username,userpass,zdlid,zdlname,dlsid,dlsname,usemoney,moneysort,usertype,pltype,tel,truename,abc FROM member WHERE userid=" + text);
if (!reader2.Read())
{
reader2.Close();
db.Dispose();
MyFunc.showmsg("没有该会员");
base.Response.End();
return;
}
this.LabelZdl.Text = reader2["zdlname"].ToString().Trim();
this.LabelDls.Text = reader2["dlsname"].ToString().Trim();
this.TextBoxDlsid.Text = reader2["dlsid"].ToString().Trim();
this.TextBoxUserName.Text = reader2["username"].ToString().Trim();
this.pubshowpass = reader2["userpass"].ToString().Trim();
this.TextBoxTrueName.Text = reader2["truename"].ToString().Trim();
this.TextBoxTel.Text = reader2["tel"].ToString().Trim();
this.DropDownListABC.SelectedValue = reader2["abc"].ToString().Trim().ToUpper();
this.DropDownListPlType.SelectedValue = reader2["pltype"].ToString().Trim();
if (reader2["usertype"].ToString().Trim() == "信用")
{
this.RadioButton1.Checked = true;
}
else
{
this.RadioButton2.Checked = true;
}
this.DropDownListRate.Items.FindByText(reader2["moneysort"].ToString().Trim().ToUpper()).Selected = true;
this.TextBoxUseMoney.Text = reader2["usemoney"].ToString().Trim();
this.TextBoxUserID.Text = reader2["userid"].ToString().Trim();
reader2.Close();
this.DlsUseMoney(db);
db.Dispose();
}
this.TextBoxUseMoney.Attributes["OnKeyUp"] = "setCurrentCreditLocal()";
this.DropDownListRate.Attributes["OnChange"] = "setCurrentCreditLocal()";
}
}
private void adddeal()
{
if (!MyFunc.CheckUserLogin(this.Session.Contents["adminusername"].ToString().Trim(), this.Session.Contents["adminuserpass"].ToString().Trim(), "0", 1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
string sql = "SELECT subid FROM subAgence WHERE subname = '" + base.Request.Form["subname"].ToString().Trim() + "' and classid = '10' union SELECT userid FROM agence WHERE username ='******'";
SqlDataReader reader = base2.ExecuteReader(sql);
if (reader.Read())
{
reader.Close();
base2.CloseConnect();
base2.Dispose();
MyFunc.showmsg("此帐号已经存在！");
}
else
{
reader.Close();
sql = "INSERT INTO subAgence (userid,classid,subname,truename,subpass,regtime,isuseable) VALUES ('" + this.Session["adminuserid"].ToString() + "','10','" + base.Request.Form["subname"].ToString().Trim() + "','" + base.Request.Form["truename"].ToString().Trim() + "','" + base.Request.Form["subpass"].ToString().Trim() + "','" + DateTime.Now.ToString() + "'," + base.Request.Form["isuseable"].ToString().Trim() + ")";
base2.ExecuteNonQuery(sql);
base2.CloseConnect();
base2.Dispose();
}
}
}
public void DelUser(string id, string dlsid)
{
if (!MyFunc.CheckUserLogin(this.Session.Contents["adminusername"].ToString().Trim(), this.Session.Contents["adminuserpass"].ToString().Trim(), "1", 1))
{
MyFunc.goToLoginPage();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
int num = (int) base2.ExecuteScalar("SELECT xzcount FROM member WHERE userid=" + id);
if (num > 0)
{
base2.Dispose();
MyFunc.showmsg("该会员有注单,不能删除该会员");
base.Response.End();
}
else
{
string text = base2.ExecuteScalar("SELECT dlsid FROM member WHERE userid=" + id).ToString();
if (base2.ExecuteNonQuery("DELETE FROM member WHERE userid=" + id) > 0)
{
base2.ExecuteNonQuery("UPDATE agence SET memcount=memcount-1 WHERE dlsid=" + text);
base2.Dispose();
MyFunc.JumpPage("删除该会员成功", "dlslist.aspx");
base.Response.End();
}
else
{
base2.Dispose();
MyFunc.showmsg("删除会员失败");
base.Response.End();
}
}
}
}
private void Page_Load(object sender, EventArgs e)
{
if ((this.Session.Contents["adminsubid"] != null) && (this.Session.Contents["adminsubid"].ToString() != ""))
{
if (!MyFunc.CheckUserLogin(2) || !MyTeam.OnlineList.OnlineList.isUserLogin(2))
{
MyFunc.goToLoginPage();
base.Response.End();
return;
}
}
else if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
return;
}
string flag = "all";
if (base.Request.QueryString["tztype"] != null)
{
flag = base.Request.QueryString["tztype"].ToString();
}
this.Deal(flag);
}
private void DelGd(string id)
{
if (!MyFunc.CheckUserLogin(this.Session.Contents["adminusername"].ToString().Trim(), this.Session.Contents["adminuserpass"].ToString().Trim(), this.Session.Contents["adminclassid"].ToString().Trim(), 1))
{
MyFunc.goToLoginPage();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
if (((int)base2.ExecuteScalar("SELECT COUNT(*) FROM agence WHERE gdid=" + id)) > 0)
{
base2.Dispose();
MyFunc.showmsg("该股东下还有总代理,代理商或会员,不能删除股东");
base.Response.End();
}
else if (base2.ExecuteNonQuery("DELETE FROM agence WHERE userid=" + id + " AND classid=2") > 0)
{
base2.Dispose();
MyFunc.JumpPage("删除股东成功!", "gdlist.aspx");
base.Response.End();
}
else
{
base2.Dispose();
MyFunc.showmsg("删除股东失败");
base.Response.End();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
string table = "";
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!this.Page.IsPostBack)
{
if ((base.Request.QueryString["path"] != null) && (base.Request.QueryString["path"].ToString().Trim() != ""))
{
this.pathStr = base.Request.QueryString["path"].ToString().Trim();
table = this.GetTableName(this.pathStr);
this.tableSelect.Rows[1].Cells[0].InnerHtml = this.SetBallList(table, this.pathStr);
}
}
else
{
this.pathStr = base.Request.QueryString["path"].ToString().Trim();
if (base.Request.Form["fr_league"] != null)
{
this.SetSessionLeague(this.pathStr, base.Request.Form["fr_league"].ToString().Trim());
}
else
{
this.Session.Contents[this.pathStr] = "";
}
base.Response.Redirect(this.pathStr);
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else
{
if (base.Request.Params["MySelDate"] == null)
{
if (this.Session.Contents["basketthisDay"] == null)
{
this.Session.Contents["basketthisDay"] = DateTime.Today.ToShortDateString();
}
}
else
{
this.Session.Contents["basketthisDay"] = base.Request.Params["MySelDate"];
}
this.selday = this.Session.Contents["basketthisDay"].ToString();
if (!base.IsPostBack)
{
for (int i = 0; i < 7; i++)
{
this.SelectDay.Items.Add(new ListItem(DateTime.Today.AddDays((double)-i).ToShortDateString() + " " + MyFunc.DayToWeek(DateTime.Today.AddDays((double)-i)), DateTime.Today.AddDays((double)-i).ToShortDateString()));
}
}
this.FillDataGrid(this.selday);
this.DataGrid1.DataBind();
}
}
public void DelZdl(string id)
{
if (!MyFunc.CheckUserLogin(this.Session.Contents["adminusername"].ToString().Trim(), this.Session.Contents["adminuserpass"].ToString().Trim(), this.Session.Contents["adminclassid"].ToString().Trim(), 1))
{
MyFunc.goToLoginPage();
}
else
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
int num = (int)base2.ExecuteScalar("SELECT COUNT(*) FROM agence WHERE zdlid=" + id + " AND classid=4 AND gdid=" + this.Session.Contents["adminuserid"].ToString().Trim());
if (num > 0)
{
base2.Dispose();
MyFunc.showmsg("该总代理下还有代理商个数不为0,不能删除");
base.Response.End();
}
else if (base2.ExecuteNonQuery("DELETE FROM agence WHERE userid=" + id + " AND classid=3 AND gdid=" + this.Session.Contents["adminuserid"].ToString().Trim()) > 0)
{
base2.ExecuteNonQuery("UPDATE agence SET memcount=memcount-1 WHERE userid=" + id + " AND gdid=" + this.Session.Contents["adminuserid"].ToString().Trim());
base2.Dispose();
MyFunc.JumpPage("删除该总代理成功", "zdllist.aspx");
base.Response.End();
}
else
{
base2.Dispose();
MyFunc.showmsg("删除总代理失败");
base.Response.End();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!base.IsPostBack)
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader("SELECT userid,username,gdbl FROM agence WHERE classid=2 AND gdid = '" + this.Session["adminuserid"].ToString() + "'");
this.DropdownlistGd.Items.Clear();
this.DropdownlistGd.Items.Add(new ListItem("请选择", "00"));
while (reader.Read())
{
this.DropdownlistGd.Items.Add(new ListItem(reader["username"].ToString().Trim(), reader["userid"].ToString().Trim()));
}
reader.Close();
if (this.DropdownlistGd.Items.Count < 2)
{
base2.Dispose();
MyFunc.showmsg("请先添加股东");
base.Response.End();
}
else
{
this.DropdownlistGd.SelectedIndex = 0;
base2.Dispose();
}
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!base.IsPostBack)
{
if ((((base.Request.QueryString["action"] != null) && (base.Request.QueryString["id"] != null)) && ((base.Request.QueryString["id"].ToString().Trim() != "") && (base.Request.QueryString["did"] != null))) && (base.Request.QueryString["did"].ToString().Trim() != ""))
{
if (base.Request.QueryString["action"].ToString().Trim().ToUpper() == "OPEN")
{
this.OpDls("1", base.Request.QueryString["id"].ToString().Trim());
}
else if (base.Request.QueryString["action"].ToString().Trim().ToUpper() == "CLOSE")
{
this.OpDls("0", base.Request.QueryString["id"].ToString().Trim());
}
else
{
if (base.Request.QueryString["action"].ToString().Trim().ToUpper() != "DEL")
{
return;
}
this.DelDls(base.Request.QueryString["id"].ToString().Trim(), base.Request.QueryString["did"].ToString().Trim());
}
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
this.DropDownListGd.Items.Clear();
this.DropDownListGd.Items.Add(new ListItem("请选择", "0"));
SqlDataReader reader = base2.ExecuteReader("SELECT userid,username FROM agence WHERE classid=2");
while (reader.Read())
{
this.DropDownListGd.Items.Add(new ListItem(reader["username"].ToString().Trim(), reader["userid"].ToString().Trim()));
}
reader.Close();
this.DropDownListGd.Items.Add(new ListItem("全部", ""));
this.DropDownListGd.SelectedIndex = 0;
if ((base.Request.QueryString["gdid"] != null) && (base.Request.QueryString["gdid"].ToString().Trim() != ""))
{
this.DropDownListGd.SelectedValue = base.Request.QueryString["gdid"].ToString().Trim();
}
this.ZdlList();
if ((base.Request.QueryString["zid"] != null) && (base.Request.QueryString["zid"].ToString().Trim() != ""))
{
this.DropDownListZdl.SelectedValue = base.Request.QueryString["zid"].ToString().Trim();
}
if ((base.Request.QueryString["flag"] != null) && (base.Request.QueryString["flag"].ToString().Trim() != ""))
{
this.DropDownListAccountStatus.SelectedValue = base.Request.QueryString["flag"].ToString().Trim();
}
this.countmem();
this.PageList(this.DropDownListAccountStatus.SelectedValue);
base2.Dispose();
this.DataGridDataBind(this.DropDownListAccountStatus.SelectedValue, this.TextBoxSortField.Text, int.Parse(this.DropDownListPage.SelectedValue));
}
}
private void Page_Load(object sender, EventArgs e)
{
if (!MyFunc.CheckUserLogin(2))
{
MyFunc.goToLoginPage();
base.Response.End();
}
}
private void Page_Load(object sender, EventArgs e)
{
if (!MyFunc.CheckUserLogin(2) || !MyTeam.OnlineList.OnlineList.isUserLogin(2))
{
MyFunc.goToLoginPage("../manager/");
base.Response.End();
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
}
