private void ButtonSave_Click(object sender, EventArgs e)
{
string text9 = "";
string text8 = this.TextBoxGdID.Text.Trim();
string input = this.TextBoxUserName.Text.Trim();
string text2 = this.TextBoxNewpass1.Text.Trim();
string text3 = this.TextBoxNewpass2.Text.Trim();
string text4 = this.TextBoxTrueName.Text.Trim();
string s = this.DropDownListBL.SelectedValue.Trim();
string text6 = MyFunc.DefaultValue(base.Request.Form["DropDownListGsGd"], "");
string text7 = this.TextBoxUseMoney.Text.Trim();
string text10 = this.TextBoxMaxMem.Text.Trim();
if ((((text8 == "") || (input == "")) || ((text4 == "") || (s == ""))) || ((text10 == "") || (text6 == "")))
{
MyFunc.showmsg("请输入股东帐号,名称,成数和最大会员数");
base.Response.End();
}
else
{
Regex regex = new Regex("[^'*%=\"<>/|]");
Regex regex2 = new Regex("[^'*%=\"<>/|]");
if (!regex.IsMatch(input) || !regex2.IsMatch(text4))
{
MyFunc.showmsg("股东帐号或股东名里含有非法字符");
base.Response.End();
}
else
{
if ((text2 != "") && (text3 != ""))
{
if (text2 != text3)
{
MyFunc.showmsg("输入的密码不相同");
return;
}
text9 = ",userpass='******'";
}
if (text4.Length > 8)
{
MyFunc.showmsg("股东名称不能大于8个字符(4个汉字)");
base.Response.End();
}
else
{
try
{
int num = int.Parse(s);
if (((num % 10) == 0) && ((num >= 0) || (num <= 100)))
{
try
{
int num2 = int.Parse(text6);
if ((num2 >= int.Parse(s)) || (num2 <= 100))
{
try
{
if (int.Parse(text7) >= 0)
{
try
{
int.Parse(text10);
}
catch
{
MyFunc.showmsg("请输入正确的最大会员数");
base.Response.End();
return;
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
int num9 = 100 - int.Parse(text6);
if (int.Parse(base2.ExecuteScalar("SELECT COUNT(1) FROM agence WHERE gdid=" + text8 + " AND bl+zdlbl>" + num9.ToString()).ToString()) > 0)
{
MyFunc.showmsg("不能修改股东成数,该股东下有总代理和代理商的成数和大于" + ((100 - int.Parse(s))).ToString());
base.Response.End();
}
else if (int.Parse(base2.ExecuteScalar("SELECT COUNT(*) FROM agence WHERE userid=" + text8).ToString()) < 1)
{
base2.Dispose();
MyFunc.showmsg("没有该股东");
}
else
{
int num4 = int.Parse(base2.ExecuteScalar("SELECT ISNULL(SUM(usemoney),0) FROM agence WHERE gdid=" + this.TextBoxGdID.Text + " AND isuseable=1 AND classid = 3").ToString());
int num5 = int.Parse(base2.ExecuteScalar("SELECT ISNULL(SUM(usemoney),0) FROM agence WHERE gdid=" + this.TextBoxGdID.Text + " AND isuseable=0 AND classid = 3").ToString());
int num6 = (int.Parse(this.TextBoxUseMoney.Text) - num4) - num5;
if (num6 < 0)
{
base2.Dispose();
MyFunc.showmsg("信用额度一定要大于已用额度：" + ((num4 + num5)).ToString());
base.Response.End();
}
else
{
int num7 = int.Parse(base2.ExecuteScalar("SELECT COUNT(1) FROM member WHERE gdid=" + text8).ToString());
if ((num7 > int.Parse(text10)) && (int.Parse(text10) != 0))
{
base2.Dispose();
MyFunc.showmsg("该股东已有 " + num7.ToString() + " 个会员,设置的最大会员数最小为" + num7.ToString());
base.Response.End();
}
else if (base2.ExecuteNonQuery("UPDATE agence SET truename='" + text4 + "'" + text9 + ",gsbl=" + s + ",maxmem=" + text10 + ",usemoney=" + text7 + " WHERE userid=" + text8) > 0)
{
int num8 = int.Parse(text6) - int.Parse(s);
base2.ExecuteNonQuery("UPDATE agence SET gsbl=" + s + " WHERE gdid=" + text8 + " AND classid=4");
base2.ExecuteNonQuery("UPDATE agence SET gdbl=100-bl-zdlbl-gsbl WHERE gdid=" + text8 + " AND classid=4");
base2.Dispose();
MyFunc.JumpPage("修改股东成功!", "gdlist.aspx");
}
else
{
base2.Dispose();
MyFunc.showmsg("修改股东失败!");
}
}
}
}
else
{
MyFunc.showmsg("请输入正确的信用额度");
base.Response.End();
}
}
catch
{
MyFunc.showmsg("请输入正确的信用额度");
base.Response.End();
}
}
else
{
MyFunc.showmsg("请选择正确的公司+股东成数");
base.Response.End();
}
}
catch
{
MyFunc.showmsg("请选择正确的公司+股东成数");
base.Response.End();
}
}
else
{
MyFunc.showmsg("请选择正确的公司成数");
base.Response.End();
}
}
catch
{
MyFunc.showmsg("请选择正确的公司成数");
base.Response.End();
}
}
}
}
}
private void ButtonSave_Click(object sender, EventArgs e)
{
string input = this.TextBoxUserName.Text.Trim().ToLower();
string text2 = this.TextBoxNewpass1.Text.Trim();
string text3 = this.TextBoxNewpass2.Text.Trim();
string text4 = this.TextBoxTrueName.Text.Trim();
string s = this.DropDownListBL.SelectedValue.Trim();
string text6 = MyFunc.DefaultValue(base.Request.Form["DropDownListGsGd"], "");
string text8 = this.TextBoxUseMoney.Text.Trim();
string text7 = this.TextBoxMaxMem.Text.Trim();
if ((((input == "") || (text2 == "")) || ((text3 == "") || (text4 == ""))) || ((s == "") || (text6 == "")))
{
MyFunc.showmsg("请输入股东帐号,密码,名称和比例");
base.Response.End();
}
else if (input.Length < 3)
{
MyFunc.showmsg("股东帐号不能小于3个字符");
base.Response.End();
}
else if (text4.Length > 8)
{
MyFunc.showmsg("股东名称不能大于8个字符(4个汉字)");
base.Response.End();
}
else
{
Regex regex = new Regex("[^'*%=\"<>/|]");
Regex regex2 = new Regex("[^'*%=\"<>/|]");
if (!regex.IsMatch(input) || !regex2.IsMatch(text4))
{
MyFunc.showmsg("股东帐号或股东名里含有非法字符");
base.Response.End();
}
else if (text2 != text3)
{
MyFunc.showmsg("输入的密码不相同");
}
else
{
try
{
int num = int.Parse(s);
if ((num >= 0) || (num <= 100))
{
try
{
int num2 = int.Parse(text6);
if ((num2 >= int.Parse(s)) || (num2 <= 100))
{
try
{
if (int.Parse(text8) >= 0)
{
if (int.Parse(text6) < int.Parse(s))
{
MyFunc.showmsg("公司+股东比例不能小于公司最低比例");
base.Response.End();
}
else
{
try
{
int.Parse(text7);
}
catch
{
MyFunc.showmsg("请输入正确的最大会员数");
base.Response.End();
return;
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
if (int.Parse(base2.ExecuteScalar("SELECT COUNT(*) FROM agence WHERE username='******'").ToString()) > 0)
{
base2.Dispose();
MyFunc.showmsg("该股东帐号已存在!");
base.Response.End();
}
else if (base2.ExecuteNonQuery("INSERT INTO agence(username,userpass,truename,classid,regtime,isuseable,gsbl,gdbl,usemoney,maxmem,gdid,gdname)VALUES('" + input + "','" + text2 + "','" + text4 + "',2,GetDate(),1," + s + "," + text6 + "," + text8 + "," + text7 + ",'" + this.Session["adminuserid"].ToString() + "','" + this.Session["adminusername"].ToString() + "')") > 0)
{
string text9 = base2.ExecuteScalar("SELECT userid FROM agence WHERE username='******'").ToString();
base2.ExecuteNonQuery("UPDATE agence SET arrgd = arrgd+'" + text9.Trim() + ",' WHERE classid = 0 AND userid = '" + this.Session["adminuserid"].ToString() + "'");
base2.ExecuteNonQuery("INSERT INTO hs(userid,type)VALUES(" + text9 + ",'A');INSERT INTO hs(userid,type)VALUES(" + text9 + ",'B');INSERT INTO hs(userid,type)VALUES(" + text9 + ",'C');INSERT INTO hs(userid,type)VALUES(" + text9 + ",'D')");
base2.Dispose();
MyFunc.JumpPage("添加股东成功!", "gdlist.aspx");
}
else
{
base2.Dispose();
MyFunc.showmsg("添加股东失败!");
}
}
}
else
{
MyFunc.showmsg("请输入正确的信用额度");
base.Response.End();
}
}
catch
{
MyFunc.showmsg("请输入正确的信用额度");
base.Response.End();
}
}
else
{
MyFunc.showmsg("请选择正确的公司+股东成数");
base.Response.End();
}
}
catch
{
MyFunc.showmsg("请选择正确的公司+股东成数");
base.Response.End();
}
}
else
{
MyFunc.showmsg("请选择正确的公司成数");
base.Response.End();
}
}
catch
{
MyFunc.showmsg("请选择正确的公司成数");
base.Response.End();
}
}
}
}
private void Updatekygl(string type)
{
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 if ((((base.Request.Form["war_set_w"] != null) && (base.Request.Form["war_set_l"] != null)) && (((base.Request.Form["SC"] != null) & (base.Request.Form["SO"] != null)) && (base.Request.Form["id"] != null))) && (((base.Request.Form["id"].ToString().Trim() != "") && (base.Request.Form["did"] != null)) && (base.Request.Form["did"].ToString().Trim() != "")))
{
string sql = "";
string text2 = "";
string text3 = MyFunc.DefaultValue(base.Request.Form["war_set_w"].ToString().Trim(), "0");
string text4 = MyFunc.DefaultValue(base.Request.Form["war_set_l"].ToString().Trim(), "0");
string s = MyFunc.DefaultValue(base.Request.Form["SC"].ToString().Trim(), "0");
string text6 = MyFunc.DefaultValue(base.Request.Form["SO"].ToString().Trim(), "0");
string text7 = base.Request.Form["id"].ToString().Trim();
string text8 = base.Request.Form["did"].ToString().Trim();
switch (type)
{
case "1":
sql = "UPDATE userhs SET W1=" + text3 + ",L1=" + text4 + ",MAXC1=" + s + ",MAXZ1=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc1,maxz1 FROM agence WHERE userid=" + text8;
break;
case "2":
sql = "UPDATE userhs SET W2=" + text3 + ",L2=" + text4 + ",MAXC2=" + s + ",MAXZ2=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc2,maxz2 FROM agence WHERE userid=" + text8;
break;
case "3":
sql = "UPDATE userhs SET W3=" + text3 + ",L3=" + text4 + ",MAXC3=" + s + ",MAXZ3=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc3,maxz3 FROM agence WHERE userid=" + text8;
break;
case "4":
sql = "UPDATE userhs SET W4=" + text3 + ",L4=" + text4 + ",MAXC4=" + s + ",MAXZ4=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc4,maxz4 FROM agence WHERE userid=" + text8;
break;
case "5":
sql = "UPDATE userhs SET W5=" + text3 + ",L5=" + text4 + ",MAXC5=" + s + ",MAXZ5=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc5,maxz5 FROM agence WHERE userid=" + text8;
break;
case "6":
sql = "UPDATE userhs SET W6=" + text3 + ",L6=" + text4 + ",MAXC6=" + s + ",MAXZ6=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc6,maxz6 FROM agence WHERE userid=" + text8;
break;
case "7":
sql = "UPDATE userhs SET W7=" + text3 + ",L7=" + text4 + ",MAXC7=" + s + ",MAXZ7=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc7,maxz7 FROM agence WHERE userid=" + text8;
break;
case "8":
sql = "UPDATE userhs SET W8=" + text3 + ",L8=" + text4 + ",MAXC8=" + s + ",MAXZ8=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc8,maxz8 FROM agence WHERE userid=" + text8;
break;
case "9":
sql = "UPDATE userhs SET W9=" + text3 + ",L9=" + text4 + ",MAXC9=" + s + ",MAXZ9=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc9,maxz9 FROM agence WHERE userid=" + text8;
break;
case "10":
sql = "UPDATE userhs SET W10=" + text3 + ",L10=" + text4 + ",MAXC10=" + s + ",MAXZ10=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc10,maxz10 FROM agence WHERE userid=" + text8;
break;
case "11":
sql = "UPDATE userhs SET W11=" + text3 + ",L11=" + text4 + ",MAXC11=" + s + ",MAXZ11=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc11,maxz11 FROM agence WHERE userid=" + text8;
break;
case "12":
sql = "UPDATE userhs SET W12=" + text3 + ",L12=" + text4 + ",MAXC12=" + s + ",MAXZ12=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc12,maxz12 FROM agence WHERE userid=" + text8;
break;
case "13":
sql = "UPDATE userhs SET W13=" + text3 + ",L13=" + text4 + ",MAXC13=" + s + ",MAXZ13=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc13,maxz13 FROM agence WHERE userid=" + text8;
break;
case "16":
sql = "UPDATE userhs SET W14=" + text3 + ",L14=" + text4 + ",MAXC14=" + s + ",MAXZ14=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc14,maxz14 FROM agence WHERE userid=" + text8;
break;
case "17":
sql = "UPDATE userhs SET W15=" + text3 + ",L15=" + text4 + ",MAXC15=" + s + ",MAXZ15=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc15,maxz15 FROM agence WHERE userid=" + text8;
break;
case "18":
sql = "UPDATE userhs SET W18=" + text3 + ",L18=" + text4 + ",MAXC18=" + s + ",MAXZ18=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc18,maxz18 FROM agence WHERE userid=" + text8;
break;
case "19":
sql = "UPDATE userhs SET W19=" + text3 + ",L19=" + text4 + ",MAXC19=" + s + ",MAXZ19=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc19,maxz19 FROM agence WHERE userid=" + text8;
break;
case "20":
sql = "UPDATE userhs SET W20=" + text3 + ",L20=" + text4 + ",MAXC20=" + s + ",MAXZ20=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc20,maxz20 FROM agence WHERE userid=" + text8;
break;
case "21":
sql = "UPDATE userhs SET W21=" + text3 + ",L21=" + text4 + ",MAXC21=" + s + ",MAXZ21=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc21,maxz21 FROM agence WHERE userid=" + text8;
break;
case "22":
sql = "UPDATE userhs SET W22=" + text3 + ",L22=" + text4 + ",MAXC22=" + s + ",MAXZ22=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc22,maxz22 FROM agence WHERE userid=" + text8;
break;
case "23":
sql = "UPDATE userhs SET W23=" + text3 + ",L23=" + text4 + ",MAXC23=" + s + ",MAXZ23=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc23,maxz23 FROM agence WHERE userid=" + text8;
break;
case "24":
sql = "UPDATE userhs SET W24=" + text3 + ",L24=" + text4 + ",MAXC24=" + s + ",MAXZ24=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc24,maxz24 FROM agence WHERE userid=" + text8;
break;
case "28":
sql = "UPDATE userhs SET W28=" + text3 + ",L28=" + text4 + ",MAXC28=" + s + ",MAXZ28=" + text6 + " WHERE userid=" + text7;
text2 = "SELECT Maxc28,maxz28 FROM agence WHERE userid=" + text8;
break;
}
if (sql != "")
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
int num = 0;
int num2 = 0;
SqlDataReader reader = base2.ExecuteReader(text2);
if (reader.Read())
{
num = int.Parse(reader[0].ToString().Trim());
num2 = int.Parse(reader[1].ToString().Trim());
}
reader.Close();
if ((num < ((int)float.Parse(s))) || (num2 < ((int)float.Parse(text6))))
{
base2.Dispose();
MyFunc.showmsg("单场限额或单注限额不能大于代理商的单场限额或单注限额");
base.Response.End();
}
else
{
SqlDataReader reader2 = base2.ExecuteReader("SELECT usemoney FROM member WHERE userid=" + text7);
if (!reader2.Read())
{
reader2.Close();
base2.Dispose();
MyFunc.showmsg("没有该会员");
base.Response.End();
}
else
{
int num3 = (int)float.Parse(reader2["usemoney"].ToString().Trim());
reader2.Close();
int num4 = (int)float.Parse(s);
int num5 = (int)float.Parse(text6);
if (num4 > num3)
{
base2.Dispose();
MyFunc.showmsg("单场限额不能大于信用额");
base.Response.End();
}
else if (num5 > num4)
{
base2.Dispose();
MyFunc.showmsg("单注限额不能大于单场限额");
base.Response.End();
}
else
{
base2.ExecuteNonQuery(sql);
base2.Dispose();
base.Response.Redirect("userset.aspx?id=" + text7 + "&did=" + text8);
}
}
}
}
}
}
