protected void btnAdd_Click(object sender, EventArgs e)
{
int Isuse = 0;
try
{
Isuse = Shove._Convert.StrToInt(tbIsuse.Text.Trim(), 0);
}
catch { }
if (Isuse == 0)
{
Shove._Web.JavaScript.Alert(this.Page, "彩友报期号只能是整数！");
return;
}
System.DateTime StartTime, EndTime;
try
{
StartTime = Convert.ToDateTime(tbStartTime.Text);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "开始时间格式输入错误！");
return;
}
try
{
EndTime = Convert.ToDateTime(tbEndTime.Text);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "截止时间格式输入错误！");
return;
}
if (EndTime < StartTime)
{
Shove._Web.JavaScript.Alert(this.Page, "截止时间应该在开始时间之后！");
return;
}
string Message = Shove._Convert.ToTextCode(tbContent.Value.Trim());
if (Message == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入开奖信息！");
return;
}
if (HidID.Value == "")
{
DataTable dt = new DAL.Tables.T_NewsPaperIsuses().Open("[ID]", "[Name] = '" + Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0') + "'", "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_Admin_NPIsusesAdd");
return;
}
if (dt.Rows.Count > 0)
{
Shove._Web.JavaScript.Alert(this.Page, "期号已经存在，请不要输入重名期号！");
return;
}
DAL.Tables.T_NewsPaperIsuses dt1 = new DAL.Tables.T_NewsPaperIsuses();
dt1.Name.Value = Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0');
dt1.StartTime.Value = StartTime.ToString("yyyy-MM-dd");
dt1.EndTime.Value = EndTime.ToString("yyyy-MM-dd");
dt1.NPMessage.Value = Message;
if (dt1.Insert() < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "添加彩友报期号失败！");
return;
}
else
{
Shove._Web.Cache.ClearCache("Home_Room_NewsPaper_BindNewsPaper_" + this.HidID.Value);
Shove._Web.JavaScript.Alert(this.Page, "添加期号成功！");
}
}
else
{
DataTable dt = new DAL.Tables.T_NewsPaperIsuses().Open("[ID]", "[Name] = '" + Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0') + "' and ID<>" + HidID.Value + "", "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_IsuseAdd");
return;
}
if (dt.Rows.Count > 0)
{
Shove._Web.JavaScript.Alert(this.Page, "期号已经存在，请不要输入重名期号！");
return;
}
DAL.Tables.T_NewsPaperIsuses dt1 = new DAL.Tables.T_NewsPaperIsuses();
dt1.Name.Value = Isuse.ToString().PadLeft(tbIsuse.Text.Length, '0');
dt1.StartTime.Value = StartTime;
dt1.EndTime.Value = EndTime;
dt1.NPMessage.Value = Message;
if (dt1.Update("ID=" + HidID.Value) < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "修改失败！");
return;
}
Shove._Web.Cache.ClearCache("Home_Room_NewsPaper_BindNewsPaper_" + this.HidID.Value);
Shove._Web.JavaScript.Alert(this.Page, "修改成功！");
}
}
private void SaveDataForAliBuy()
{
string request = Shove._Web.Utility.GetRequest("HidIsuseID");
Shove._Web.Utility.GetRequest("HidIsuseEndTime");
string s = Shove._Web.Utility.GetRequest("tbPlayTypeID");
string str3 = Shove._Web.Utility.GetRequest("Chase");
string str4 = Shove._Web.Utility.GetRequest("Cobuy");
string str5 = Shove._Web.Utility.GetRequest("tb_Share");
string str6 = Shove._Web.Utility.GetRequest("tb_BuyShare");
string str7 = Shove._Web.Utility.GetRequest("tb_AssureShare");
string str8 = Shove._Web.Utility.GetRequest("tb_OpenUserList");
string str9 = Shove._Web.Utility.GetRequest("tb_Title");
string str10 = Shove._Web.Utility.GetRequest("tb_Description");
string str11 = Shove._Web.Utility.GetRequest("tbAutoStopAtWinMoney");
string str12 = Shove._Web.Utility.GetRequest("SecrecyLevel");
Shove._Web.Utility.GetRequest("tbPlayTypeName");
string str13 = Shove._Web.Utility.FilteSqlInfusion(base.Request["tb_LotteryNumber"]);
string str14 = Shove._Web.Utility.GetRequest("tb_hide_SumMoney");
string str15 = Shove._Web.Utility.GetRequest("tb_hide_AssureMoney");
string str = Shove._Web.Utility.GetRequest("tb_hide_SumNum");
Shove._Web.Utility.GetRequest("HidIsuseCount");
string str17 = Shove._Web.Utility.GetRequest("HidLotteryID");
Shove._Web.Utility.GetRequest("HidIsAlipay");
string str18 = Shove._Web.Utility.GetRequest("tb_Multiple");
string str19 = "";
StringBuilder builder = new StringBuilder();
int num = 0;
int num2 = 2;
if (str18 == "")
{
str18 = "1";
}
if (str3 == "1")
{
foreach (string str20 in base.Request.Form.AllKeys)
{
if (str20.IndexOf("check") > -1)
{
int num4 = _Convert.StrToInt(str20.Replace("check", ""), -1);
if (num4 > 0)
{
num++;
int num5 = (_Convert.StrToInt(str, -1) * num2) * _Convert.StrToInt(base.Request.Form["times" + num4.ToString()], -1);
builder.Append(base.Request.Form[str20]).Append(",").Append(base.Request.Form["times" + num4.ToString()]).Append(",").Append(num5.ToString()).Append(";");
}
}
}
string str21 = str13;
if (builder.Length > 0)
{
builder.Remove(builder.Length - 1, 1);
}
if (str21[str21.Length - 1] == '\n')
{
str21 = str21.Substring(0, str21.Length - 1);
}
string[] strArray2 = builder.ToString().Split(new char[] { ';' });
int length = strArray2.Length;
string[] strArray3 = new string[length * 6];
DateTime time2 = DateTime.Parse(Functions.F_GetIsuseSystemEndTime(long.Parse(strArray2[0].Split(new char[] { ',' })[0]), int.Parse(s)).ToString());
if (DateTime.Now >= time2)
{
JavaScript.Alert(this.Page, "您选择的追号期号中包含已截止的期，请重新选择。");
return;
}
for (int i = 0; i < length; i++)
{
strArray3[i * 6] = strArray2[i].Split(new char[] { ',' })[0];
strArray3[(i * 6) + 1] = s;
strArray3[(i * 6) + 2] = str21;
strArray3[(i * 6) + 3] = strArray2[i].Split(new char[] { ',' })[1];
strArray3[(i * 6) + 4] = strArray2[i].Split(new char[] { ',' })[2];
strArray3[(i * 6) + 5] = str12;
}
str19 = PF.BuildIsuseAdditionasXmlForChase(strArray3);
}
long num8 = new Tables.T_AlipayBuyTemp
{
SiteID = { Value = 1 },
UserID = { Value = -1 },
Money = { Value = str14 },
HandleResult = { Value = 0 },
IsChase = { Value = str3 == "1" },
IsCoBuy = { Value = str4 == "2" },
LotteryID = { Value = str17 },
IsuseID = { Value = request },
PlayTypeID = { Value = s },
StopwhenwinMoney = { Value = str11 },
AdditionasXml = { Value = str19 },
Title = { Value = str9 },
Description = { Value = str10 },
LotteryNumber = { Value = str13 },
UpdateloadFileContent = { Value = "" },
Multiple = { Value = str18 },
BuyMoney = { Value = str6 },
SumMoney = { Value = str14 },
AssureMoney = { Value = str15 },
Share = { Value = str5 },
BuyShare = { Value = str6 },
AssureShare = { Value = str7 },
OpenUsers = { Value = str8 },
SecrecyLevel = { Value = str12 }
}.Insert();
if (num8 < 0L)
{
new Log("System").Write("T_AlipayBuyTemp 数据库读写错误。");
}
JavaScript.Alert(this.Page, "您的账户余额不足，请先充值，谢谢。", "../Home/Room/OnlinePay/Default.aspx?BuyID=" + num8.ToString());
}
protected void btnSave_Click(object sender, EventArgs e)
{
long SiteID = Shove._Convert.StrToLong(tbSiteID.Text, -1);
long UserID = Shove._Convert.StrToLong(tbUserID.Text, -1);
string bankInProvinceName = Request.Form["selProvince"] == null? "" : Request.Form["selProvince"].ToString(); //银行所在省
string bankInCityName = Request.Form["selCity"] == null? "" : Request.Form["selCity"].ToString(); //银行所在市
string bankTypeName = Request.Form["selBankTypeName"] == null? "":Request.Form["selBankTypeName"].ToString(); //银行类名
string bankName = Request.Form["selBankName"] == null? "" : Request.Form["selBankName"].ToString(); //银行支行名
string bankCardNumber = tbUserBankCardNumber.Text.Trim();
string bankUserName = Shove._Web.Utility.FilteSqlInfusion(this.tbUserCradName.Text.Trim());
bool needBindBankFlag = (bankInProvinceName != "" || bankInCityName != "" || bankTypeName != "" || bankName != "" || bankCardNumber != "" || bankUserName != "");
if ((SiteID < 1) || (UserID < 1))
{
PF.GoError(ErrorNumber.Unknow, "参数错误", "Admin_UserDetail");
return;
}
Users tu = new Users(SiteID)[SiteID, UserID];
if (tu.ID < 1)
{
PF.GoError(ErrorNumber.Unknow, "用户不存在", "Admin_UserDetail");
return;
}
if (tbUserEmail.Text.Trim() == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入电子邮件地址。");
return;
}
if (!Shove._String.Valid.isEmail(tbUserEmail.Text.Trim()))
{
Shove._Web.JavaScript.Alert(this.Page, "电子邮件地址格式不正确。");
return;
}
if (rbUserType2.Checked)
{
if (tbUserRealityName.Text.Trim() == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入真实姓名。");
return;
}
if (tbUserIDCardNumber.Text.Trim() == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入身份证号。");
return;
}
if ((!Shove._String.Valid.isIDCardNumber(tbUserIDCardNumber.Text.Trim())) && (!Shove._String.Valid.isIDCardNumber_Hongkong(tbUserIDCardNumber.Text.Trim())) &&
(!Shove._String.Valid.isIDCardNumber_Macau(tbUserIDCardNumber.Text.Trim())) && (!Shove._String.Valid.isIDCardNumber_Singapore(tbUserIDCardNumber.Text.Trim())) &&
(!Shove._String.Valid.isIDCardNumber_Taiwan(tbUserIDCardNumber.Text.Trim())))
{
Shove._Web.JavaScript.Alert(this.Page, "身份证号格式不正确。");
return;
}
try
{
DateTime.Parse(tbUserBirthDay.Text.Trim());
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "请输入正确的生日。");
return;
}
if (needBindBankFlag)
{
if (bankName == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入开户银行。");
return;
}
if (bankCardNumber == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入银行卡号。");
return;
}
if (!Shove._String.Valid.isBankCardNumber(bankCardNumber))
{
Shove._Web.JavaScript.Alert(this.Page, "银行卡号格式不正确。");
return;
}
if (bankUserName == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入持卡人姓名。");
return;
}
}
double ScoringOfSelfBuy = Shove._Convert.StrToDouble(tbScoringOfSelfBuy.Text, -1);
if (ScoringOfSelfBuy < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "请输入正确的购彩积分比例。");
return;
}
double ScoringOfCommendBuy = Shove._Convert.StrToDouble(tbScoringOfCommendBuy.Text, -1);
if (ScoringOfCommendBuy < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "请输入正确的下级购彩积分比例。");
return;
}
}
tu.UserType = (short)(rbUserType2.Checked ? 2 : rbUserType3.Checked ? 3 : 1);
tu.Email = tbUserEmail.Text.Trim();
tu.RealityName = tbUserRealityName.Text.Trim();
tu.IDCardNumber = Shove._Convert.ToDBC(tbUserIDCardNumber.Text.Trim()).Trim();
tu.CityID = ddlUserCity.City_id;
tu.Telephone = Shove._Convert.ToDBC(tbUserTelephone.Text.Trim()).Trim();
tu.Mobile = Shove._Convert.ToDBC(tbUserMobile.Text.Trim()).Trim();
tu.isMobileValided = (cbUserMobileValid.Checked && (tu.Mobile != ""));
tu.QQ = Shove._Convert.ToDBC(tbUserQQ.Text.Trim()).Trim();
tu.Address = tbUserAddress.Text.Trim();
tu.Sex = rbUserSexM.Checked ? "男" : (rbUserSexW.Checked ? "女" : "");
tu.BirthDay = DateTime.Parse(tbUserBirthDay.Text.Trim());
tu.BankName = bankName;
tu.BankCardNumber = Shove._Convert.ToDBC(tbUserBankCardNumber.Text.Trim()).Trim();
tu.ScoringOfSelfBuy = Shove._Convert.StrToDouble(tbScoringOfSelfBuy.Text, 0);
tu.ScoringOfCommendBuy = Shove._Convert.StrToDouble(tbScoringOfCommendBuy.Text, 0);
tu.isPrivacy = cbPrivacy.Checked;
tu.isCanLogin = cbisCanLogin.Checked;
string ReturnDescription = "";
int returnValue = -1;
if (tu.EditByID(ref ReturnDescription) < 0)
{
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
return;
}
//绑定银行资料
if (needBindBankFlag)
{
if (DAL.Procedures.P_UserBankDetailEdit(SiteID, UserID, bankTypeName, bankName, bankCardNumber, bankInProvinceName, bankInCityName, bankUserName, ref returnValue, ref ReturnDescription) < 0)
{
tu.Clone(_User);
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
return;
}
hfBankInProvince.Value = bankInProvinceName;
hfBankInCity.Value = bankInCityName;
hfBankTypeName.Value = bankTypeName;
hfBankName.Value = bankName;
}
Shove._Web.JavaScript.Alert(this.Page, "用户资料已经保存成功。");
}
private IEnumerator <bool> RegisterForIosPushNotificationsCoroutine()
{
var notifications = UnityEngine.iOS.NotificationType.Alert | UnityEngine.iOS.NotificationType.Badge | UnityEngine.iOS.NotificationType.Sound;
UnityEngine.iOS.NotificationServices.RegisterForNotifications(notifications, true);
int retryCount = 0;
while (this.deviceToken == null)
{
if (this.deviceToken == null && UnityEngine.iOS.NotificationServices.deviceToken != null)
{
this.deviceToken = System.BitConverter.ToString(UnityEngine.iOS.NotificationServices.deviceToken).Replace("-", "").ToLower();
}
retryCount++;
if (retryCount >= RetryCountMax)
{
yield break;
}
// Waiting before we retry again...
float waitTime = 0.0f;
while (waitTime < RetryWaitTime)
{
yield return(default(bool));
waitTime += UnityEngine.Time.deltaTime;
}
}
// if we got here and still no deviceToken, then we timed out
if (this.deviceToken == null)
{
UnityEngine.Debug.LogError("PlayFabIOSPushHandler timed out waiting for the deviceToken.");
// cleaning up this iOS push notification handler so it doesn't take up any cycles
yield break;
}
string registeredUser = LostPlayerPrefs.GetString(HasRegisteredUserForPushNotificationsKey, null);
// Checking if we're already successfully registed this user with PlayFab for push notifications
if (registeredUser == PF.User.PlayFabId)
{
CoroutineRunner.Instance.StartCoroutine(this.CheckForIosPushNotificationsCoroutine());
yield return(true);
yield break;
}
var register = PF.Do(new PlayFab.ClientModels.RegisterForIOSPushNotificationRequest {
DeviceToken = this.deviceToken
});
while (register.IsDone == false)
{
yield return(default(bool));
}
if (register.HasError)
{
var playfabError = register.Exception as PlayFabException;
if (playfabError != null)
{
UnityEngine.Debug.Log("Error Registering for iOS Push Notifications!");
UnityEngine.Debug.Log(playfabError.Error.Error);
UnityEngine.Debug.Log(playfabError.Error.ErrorMessage);
UnityEngine.Debug.Log(playfabError.Error.ErrorDetails);
}
}
else
{
// Saving that we've registed this user for PushNotifications with PlayFab successfully
LostPlayerPrefs.GetString(HasRegisteredUserForPushNotificationsKey, PF.User.PlayFabId);
CoroutineRunner.Instance.StartCoroutine(this.CheckForIosPushNotificationsCoroutine());
UnityEngine.Debug.Log("Push Notification Registration Successful!");
yield return(true);
}
}
private void BindData()
{
DataTable dt = new DAL.Tables.T_Isuses().Open("", "[ID]=" + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "");
if ((dt == null) || (dt.Rows.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
tbIsuse.Text = dt.Rows[0]["Name"].ToString();
tbStartTime.Text = Shove._Convert.StrToDateTime(dt.Rows[0]["StartTime"].ToString(), "0000-00-00 00:00:00").ToString("yyyy-MM-dd HH:mm:ss");
tbEndTime.Text = Shove._Convert.StrToDateTime(dt.Rows[0]["EndTime"].ToString(), "0000-00-00 00:00:00").ToString("yyyy-MM-dd HH:mm:ss");
if (tbLotteryID.Text == SLS.Lottery.SFC.sID || tbLotteryID.Text == SLS.Lottery.ZCSFC.sID || tbLotteryID.Text == SLS.Lottery.ZCRJC.sID)
{
dt = new DAL.Tables.T_IsuseForSFC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
if (dt.Rows.Count != 14)
{
return;
}
for (int i = 0; i < 14; i++)
{
TextBox tb = (TextBox)this.FindControl("tbSFC" + (i + 1).ToString());
TextBox tb_1 = (TextBox)this.FindControl("tbSFC" + (i + 1).ToString() + "_1");
TextBox tb_2 = (TextBox)this.FindControl("tbSFC" + (i + 1).ToString() + "_2");
tb.Text = dt.Rows[i]["HostTeam"].ToString();
tb_1.Text = dt.Rows[i]["QuestTeam"].ToString();
tb_2.Text = dt.Rows[i]["DateTime"].ToString();
}
}
if (tbLotteryID.Text == SLS.Lottery.JQC.sID)
{
dt = new DAL.Tables.T_IsuseForJQC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]");
if ((dt == null) || (dt.Rows.Count < 8))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
for (int i = 0; i < 8; i++)
{
TextBox tb = (TextBox)this.FindControl("tbJQC" + (i + 1).ToString());
TextBox tb_2 = (TextBox)this.FindControl("tbJQC" + (i + 1).ToString() + "_2");
tb.Text = dt.Rows[i]["Team"].ToString();
tb_2.Text = dt.Rows[i]["DateTime"].ToString();
}
}
if (tbLotteryID.Text == SLS.Lottery.LCBQC.sID)
{
dt = new DAL.Tables.T_IsuseForLCBQC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]");
if ((dt == null) || (dt.Rows.Count < 6))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
for (int i = 0; i < 6; i++)
{
TextBox tb = (TextBox)this.FindControl("tbLCBQC" + (i + 1).ToString());
TextBox tb_1 = (TextBox)this.FindControl("tbLCBQC" + (i + 1).ToString() + "_1");
TextBox tb_2 = (TextBox)this.FindControl("tbLCBQC" + (i + 1).ToString() + "_2");
tb.Text = dt.Rows[i]["HostTeam"].ToString();
tb_1.Text = dt.Rows[i]["QuestTeam"].ToString();
tb_2.Text = dt.Rows[i]["DateTime"].ToString();
}
}
if (tbLotteryID.Text == SLS.Lottery.LCDC.sID)
{
dt = new DAL.Tables.T_IsuseForLCDC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]");
if ((dt == null) || (dt.Rows.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
for (int i = 0; i < 1; i++)
{
TextBox tb = (TextBox)this.FindControl("tbLCDC" + (i + 1).ToString());
TextBox tb_1 = (TextBox)this.FindControl("tbLCDC" + (i + 1).ToString() + "_1");
TextBox tb_2 = (TextBox)this.FindControl("tbLCDC" + (i + 1).ToString() + "_2");
tb.Text = dt.Rows[i]["HostTeam"].ToString();
tb_1.Text = dt.Rows[i]["QuestTeam"].ToString();
tb_2.Text = dt.Rows[i]["DateTime"].ToString();
}
}
DataTable dtTestNumber = new DAL.Tables.T_TestNumber().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "");
DataTable dtTotalMoney = new DAL.Tables.T_TotalMoney().Open("", "IsuseID= " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "");
if (dtTestNumber == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
if (dtTotalMoney == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
if (dtTestNumber.Rows.Count > 0)
{
tbTestNumber.Text = dtTestNumber.Rows[0]["TestNumber"].ToString();
hidID.Value = dtTestNumber.Rows[0]["ID"].ToString();
}
if (dtTotalMoney.Rows.Count > 0)
{
tbMoney.Text = dtTotalMoney.Rows[0]["TotalMoney"].ToString();
moneyID.Value = dtTotalMoney.Rows[0]["ID"].ToString();
}
}
private void BindDataForFriendFollowScheme()
{
long UserID = -1;
if (_User != null)
{
UserID = _User.ID;
}
DataTable dt = null;
string sName = Shove._Web.Utility.FilteSqlInfusion(TxtName.Text.Trim());
if (sName != "")
{
string strCmd = "SELECT ID,[NAME],[Level],MaxFollowNumber FROM dbo.T_Users ";
if (sName != "" && sName != "输入用户名")
{
strCmd += " WHERE [Name] LIKE '%" + sName + "%' and ID not in (select FollowUserID from T_CustomFriendFollowSchemes where UserID = " + UserID.ToString() + " and LotteryID in(-1," + ddlLotterySet.SelectedValue + "))";
}
else
{
strCmd += " WHERE 0=1";
}
if (UserID > 0)
{
strCmd += " and ID <> " + UserID.ToString();
}
dt = MSSQL.Select(strCmd);
if (dt == null)
{
PF.GoError(ErrorNumber.Unknow, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
}
else
{
string strCmd = "select FollowUserID from T_CustomFriendFollowSchemes where UserID = " + _User.ID.ToString();
if (ddlLotterySet.SelectedValue != "-1")
{
strCmd += " and LotteryID = " + ddlLotterySet.SelectedValue + "";
}
if (ddlPlayTypeSet.SelectedValue != "-1")
{
strCmd += " and PlayTypeID = " + ddlPlayTypeSet.SelectedValue + "";
}
dt = Shove.Database.MSSQL.Select("SELECT ID,[Name],[Level],MaxFollowNumber FROM dbo.T_Users WHERE ID in (" + strCmd + ")", new Shove.Database.MSSQL.Parameter[0]);
if (dt == null)
{
PF.GoError(ErrorNumber.Unknow, "参数错误，系统异常。", this.GetType().FullName);
}
}
gSetFollowScheme.DataSource = dt;
gSetFollowScheme.DataBind();
gPager.Visible = true;
}
protected void g_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
long SiteID = Shove._Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbSiteID")).Value, -1);
long id = Shove._Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbID")).Value, -1);
long UserID = Shove._Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbUserID")).Value, -1);
double Money = Math.Round(Shove._Convert.StrToDouble(((HtmlInputHidden)e.Item.FindControl("tbMoney")).Value, 0), 2);
HtmlInputHidden tbBankName = (HtmlInputHidden)(e.Item.FindControl("tbBankName"));
HtmlInputHidden tbBankUserName = (HtmlInputHidden)(e.Item.FindControl("tbBankUserName"));
HtmlInputHidden tbBankCardNumber = (HtmlInputHidden)(e.Item.FindControl("tbBankCardNumber"));
HtmlInputHidden tbProvince = (HtmlInputHidden)(e.Item.FindControl("tbProvince"));
HtmlInputHidden tbCity = (HtmlInputHidden)(e.Item.FindControl("tbCity"));
HtmlInputHidden tbRealityName = (HtmlInputHidden)(e.Item.FindControl("tbRealityName"));
HtmlInputHidden tbAlipayID = (HtmlInputHidden)(e.Item.FindControl("tbAlipayID"));
HtmlInputHidden tbAlipayName = (HtmlInputHidden)(e.Item.FindControl("tbAlipayName"));
HtmlInputHidden tbMemo = (HtmlInputHidden)(e.Item.FindControl("tbMemo"));
HtmlInputHidden tbIsCps = (HtmlInputHidden)(e.Item.FindControl("tbIsCps"));
double DistillFormalitiesFeesScale;
if ((SiteID < 0) || (id < 0) || (UserID < 0))
{
PF.GoError(ErrorNumber.Unknow, "参数错误", this.GetType().BaseType.FullName);
return;
}
Users tu = new Users(SiteID)[SiteID, UserID];
if (tu == null)
{
PF.GoError(ErrorNumber.Unknow, "参数错误", this.GetType().BaseType.FullName);
return;
}
if (e.CommandName == "btnNoAccept")
{
TextBox tb = (TextBox)e.Item.FindControl("tbMemo1");
if (tb.Text.Trim() == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入拒绝理由。");
return;
}
string ReturnDescription = "";
if (tu.DistillNoAccept(id, tb.Text.Trim(), _User.ID, ref ReturnDescription) < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().BaseType.FullName);
return;
}
BindData();
return;
}
if (e.CommandName == "btnAccept")
{
TextBox tb = (TextBox)e.Item.FindControl("tbMemo2");
if (tu.Freeze < Money)
{
Shove._Web.JavaScript.Alert(this.Page, "用户冻结账户余额不足以提款。");
return;
}
//吴波修改..
//主要出现的问题是:后台处理提款的时候,若是支付宝用户则会出现 "用户没有输入开户名"，"用户没有输入开户银行"，"用户没有输入银行卡号" 的提示
if (tbBankCardNumber.Value != "")
{
if (tbBankUserName.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入开户名。");
return;
}
if (tbBankName.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入开户银行。");
return;
}
if (tbBankCardNumber.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入银行卡号。");
return;
}
}
//添加了 判断支付宝账号的验证
else
{
if (tbAlipayName.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入支付宝账号");
return;
}
}
if (tbAlipayName.Value != "")
{
DistillFormalitiesFeesScale = so["OnlinePay_Alipay_ForUserDistill_MD5Key_ForPayOut"].ToDouble(0);
}
else
{
DistillFormalitiesFeesScale = so["OnlinePayOut_99Bill_DistillFormalitiesFeesScale"].ToDouble(0);
}
if (DistillFormalitiesFeesScale >= 1)
{
Shove._Web.JavaScript.Alert(this.Page, "提款手续费比例设置错误。");
return;
}
string ReturnDescription = "";
if (tu.DistillAccept(id, tbBankUserName.Value, tbBankName.Value, tbBankCardNumber.Value, tbAlipayID.Value, tbAlipayName.Value, tb.Text.Trim(), _User.ID, ref ReturnDescription) < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "出错:" + ReturnDescription);
return;
}
Shove._Web.JavaScript.Alert(this.Page, "已经接受提款! 请到待付款一览表进行付款操作.");
BindData();
return;
}
}
protected void btnEdit_Click(object sender, System.EventArgs e)
{
string Isuse = "";
try
{
Isuse = Shove._Web.Utility.FilteSqlInfusion(tbIsuse.Text.Trim());
}
catch
{ }
if (Isuse == "")
{
Shove._Web.JavaScript.Alert(this.Page, "期号不能为空！");
return;
}
DataTable dt = new DAL.Tables.T_Isuses().Open("[ID]", "[Name]='" + Isuse + "' and LotteryID=" + Shove._Web.Utility.FilteSqlInfusion(tbLotteryID.Text) + " and [ID] <> " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
if (dt.Rows.Count > 0)
{
Shove._Web.JavaScript.Alert(this.Page, "期号已经存在，请不要输入重名期号！");
return;
}
System.DateTime StartTime, EndTime;
object time = PF.ValidLotteryTime(tbStartTime.Text);
if (time == null)
{
Shove._Web.JavaScript.Alert(this.Page, "开始时间格式输入错误！");
return;
}
StartTime = (DateTime)time;
time = PF.ValidLotteryTime(tbEndTime.Text);
if (time == null)
{
Shove._Web.JavaScript.Alert(this.Page, "截止时间格式输入错误！");
return;
}
EndTime = (DateTime)time;
if (EndTime <= StartTime)
{
Shove._Web.JavaScript.Alert(this.Page, "截止时间应该在开始时间之后！");
return;
}
string AdditionasXml = "";
if ((tbLotteryID.Text == SLS.Lottery.SFC.sID || tbLotteryID.Text == SLS.Lottery.ZCSFC.sID || tbLotteryID.Text == SLS.Lottery.ZCRJC.sID) && (BuildAdditionasXmlForSFC(ref AdditionasXml) < 0))
{
return;
}
if ((tbLotteryID.Text == SLS.Lottery.JQC.sID) && (BuildAdditionasXmlForJQC(ref AdditionasXml) < 0))
{
return;
}
if ((tbLotteryID.Text == SLS.Lottery.LCBQC.sID) && (BuildAdditionasXmlForLCBQC(ref AdditionasXml) < 0))
{
return;
}
if ((tbLotteryID.Text == SLS.Lottery.LCDC.sID) && (BuildAdditionasXmlForLCDC(ref AdditionasXml) < 0))
{
return;
}
if ((tbLotteryID.Text == SLS.Lottery.ZCDC.sID) && (BuildAdditionasXmlForZCDC(ref AdditionasXml) < 0))
{
return;
}
long IsuseID = long.Parse(tbIsuseID.Text);
int ReturnValue = -1;
string ReturnDescription = "";
int Result = DAL.Procedures.P_IsuseEdit(IsuseID, Isuse, StartTime, EndTime, AdditionasXml, ref ReturnValue, ref ReturnDescription);
if (Result < 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
if (ReturnValue < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.Page.GetType().BaseType.FullName);
return;
}
if (tbTestNumber.Text.Trim() != "")
{
DAL.Tables.T_TestNumber t_TestNumber = new DAL.Tables.T_TestNumber();
t_TestNumber.TestNumber.Value = tbTestNumber.Text.Trim();
t_TestNumber.IsuseID.Value = IsuseID.ToString();
if (Shove._Convert.StrToLong(hidID.Value, 0) > 0)
{
t_TestNumber.Update("ID=" + hidID.Value);
}
else
{
t_TestNumber.Insert();
}
}
if (tbMoney.Text.Trim() != "")
{
DAL.Tables.T_TotalMoney t_TotalMoney = new DAL.Tables.T_TotalMoney();
t_TotalMoney.TotalMoney.Value = tbMoney.Text.Trim();
t_TotalMoney.IsuseID.Value = tbIsuseID.Text;
if (Shove._Convert.StrToLong(moneyID.Value, 0) > 0)
{
t_TotalMoney.Update("ID=" + moneyID.Value);
}
else
{
t_TotalMoney.Insert();
}
}
Shove._Web.Cache.ClearCache(CacheKey.LotteryCalendar);
Shove._Web.Cache.ClearCache(DataCache.IsusesInfo + tbLotteryID.Text.Trim());
this.Response.Redirect("Isuse.aspx?LotteryID=" + tbLotteryID.Text, true);
}
private void BindData(int ChaseID)
{
StringBuilder sb = new StringBuilder();
sb.Append("select Title,Name,IsuseCount,IsuseCount*Multiple*Nums*Price as SumMoney,Money,QuashStatus,ExecutedCount,ExecutedCount*Multiple*Nums*Price as ExcutedMoney,")
.Append("IsuseCount-ExecutedCount as NoExecutedCount,Title,StopTypeWhenWin,StopTypeWhenWinMoney from T_Chases a inner join T_Lotteries b ")
.Append("on a.LotteryID = b.ID and a.ID=" + ChaseID.ToString() + " ")
.Append("left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
DataTable dtChase = Shove.Database.MSSQL.Select(sb.ToString());
if (dtChase == null || dtChase.Rows.Count == 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
DataRow dr = dtChase.Rows[0];
lbLotteryName.Text = dr["Name"].ToString();
labTitle.Text = dr["Title"].ToString();
if (dr["StopTypeWhenWin"].ToString() == "1")
{
lbStopCondition.Text = "完成方案";
}
else
{
lbStopCondition.Text = "单期中奖金额达到" + dr["StopTypeWhenWinMoney"].ToString();
}
double SumMoney, BuyedMoney, QuashedMoney;;
int SumIsuseNum, BuyedIsuseNum, QuashedIsuseNum;
SumMoney = Shove._Convert.StrToDouble(dr["SumMoney"].ToString(), 0);
SumIsuseNum = Shove._Convert.StrToInt(dr["IsuseCount"].ToString(), 0);
BuyedIsuseNum = Shove._Convert.StrToInt(dr["ExecutedCount"].ToString(), 0);
QuashedIsuseNum = Shove._Convert.StrToInt(dr["NoExecutedCount"].ToString(), 0);
BuyedMoney = Shove._Convert.StrToDouble(dr["ExcutedMoney"].ToString(), 0);
QuashedMoney = Shove._Convert.StrToDouble(dr["Money"].ToString(), 0);
lbDescription.Text = "</font>共<font color=\'red\'>" + SumIsuseNum.ToString() + "</font>期<font color=\'red\'>" +
SumMoney.ToString("N") + "</font>元; 已完成<font color=\'red\'>" + BuyedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (BuyedMoney).ToString("N") + "</font>元; 未执行<font color=\'red\'>" +
QuashedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (QuashedMoney).ToString("N") + "</font>元。";
string sql = "select c.Name as PlayTypeName,b.ID,d.Name as IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed " +
"from T_ExecutedChases a inner join T_Schemes b on a.SchemeID = b.ID and a.ChaseID =@ChaseID " +
"inner join T_PlayTypes c on b.PlayTypeID = c.ID " +
"inner join T_Isuses d on b.IsuseID = d.ID";
//sb = new StringBuilder();
//sb.Append("select PlayTypeName,ID,IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed from T_ExecutedChases a inner join V_Schemes b ")
// .Append("on a.SchemeID = b.ID and a.ChaseID =" + ChaseID.ToString() + "");
DataTable dt = Shove.Database.MSSQL.Select(sql, new Shove.Database.MSSQL.Parameter("ChaseID", SqlDbType.BigInt, 0, ParameterDirection.Input, ChaseID.ToString()));
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
if (dt.Rows.Count > 0)
{
lbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString(); //买法类型
}
PF.DataGridBindData(g, dt);
}
protected override void OnLoad(EventArgs e)
{
string ReturnDescription = "";
#region 获取站点
_Site = new Sites()[1];
if (_Site == null)
{
PF.GoError(ErrorNumber.Unknow, "域名无效，限制访问", this.GetType().BaseType.FullName);
return;
}
#endregion
#region 获取用户
_User = Users.GetCurrentUser(_Site.ID);
if (isRequestLogin && _User == null)
{
GoLogin(RequestLoginPage);
return;
}
if (isRequestLogin && _User.cps.ID < 0)
{
_User.Logout(ref ReturnDescription);
PF.GoError(ErrorNumber.Unknow, "您不是 CPS 用户", this.GetType().BaseType.FullName);
return;
}
if (isRequestLogin && _User.cps.ID != BusinessID && _User.cps.ParentID != BusinessID)
{
_User.Logout(ref ReturnDescription);
PF.GoError(ErrorNumber.DataReadWrite, "您不是本站的推广商家，禁止登录", this.GetType().BaseType.FullName);
return;
}
if (isRequestLogin && !_User.cps.ON)
{
_User.Logout(ref ReturnDescription);
PF.GoError(ErrorNumber.Unknow, "用户被冻结", this.GetType().BaseType.FullName);
return;
}
#endregion
HtmlMeta hm = new HtmlMeta();
hm.HttpEquiv = "X-UA-Compatible";
hm.Content = "IE=EmulateIE7";
base.OnLoad(e);
}
private void BindData()
{
if (ddlYear.Items.Count == 0)
{
return;
}
if (tbID.Text == "")
{
tbID.Text = Shove._Web.Utility.GetRequest("id");
if (tbID.Text == "")
{
return;
}
}
long UserID = Shove._Convert.StrToLong(tbID.Text, -1);
if (UserID < 0)
{
PF.GoError(ErrorNumber.Unknow, "参数错误", "Admin_UserAccountDetail");
return;
}
if (tbUserName.Text.Trim() == "")
{
Users tu = new Users(_Site.ID)[_Site.ID, UserID];
if (tu == null)
{
Shove._Web.JavaScript.Alert(this.Page, "用户名不存在。");
return;
}
tbUserName.Text = tu.Name;
}
int ReturnValue = -1;
string ReturnDescription = "";
ReturnValue = DAL.Procedures.P_GetUserAccountDetail(ref ds, _Site.ID, UserID, int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), int.Parse(ddlDay.SelectedValue), ref ReturnValue, ref ReturnDescription);
if (ReturnValue < 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().FullName);
return;
}
if ((ds == null) || (ds.Tables.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_UserAccountDetail");
return;
}
PF.DataGridBindData(g, ds.Tables[0], gPager);
}
/// <summary>
/// 从支付结果页面的URL请求参数中获取结果信息
/// </summary>
/// <param name="querystring">支付结果页面的URL请求参数</param>
/// <param name="errmsg">函数执行不成功的话,返回错误信息</param>
/// <returns>函数执行是否成功</returns>
private bool GetPayValueFromUrl(NameValueCollection querystring, out string errmsg)
{
#region 进行参数校验
if (querystring == null || querystring.Count == 0)
{
errmsg = "参数为空";
return(false);
}
if (querystring["state"] == null)
{
errmsg = "没有state参数或state参数不正确";
return(false);
}
if (querystring["customerid"] == null)
{
errmsg = "没有customerid参数";
return(false);
}
if (querystring["sd51no"] == null)
{
errmsg = "没有sd51no参数";
return(false);
}
if (querystring["sdcustomno"] == null)
{
errmsg = "没有sdcustomno参数";
return(false);
}
if (querystring["ordermoney"] == null)
{
errmsg = "没有ordermoney参数";
return(false);
}
if (querystring["cardno"] == null)
{
errmsg = "没有cardno参数";
return(false);
}
if (querystring["mark"] == null)
{
errmsg = "没有mark参数";
return(false);
}
if (querystring["sign"] == null)
{
errmsg = "没有sign参数";
return(false);
}
#endregion
errmsg = "";
try
{
state = Shove._Convert.StrToInt(querystring["state"].Trim(), 2);
sd51no = querystring["sd51no"];
sdcustomno = querystring["sdcustomno"];
ordermoney = Shove._Convert.StrToDouble(querystring["ordermoney"], 0);
cardno = querystring["cardno"];
mark = querystring["mark"];
//要进行解密
userId = Shove._Convert.StrToLong((Shove._Security.Encrypt.UnEncryptString(PF.GetCallCert(), mark)).Split('|')[0], -1);
buyId = Shove._Convert.StrToLong((Shove._Security.Encrypt.UnEncryptString(PF.GetCallCert(), mark)).Split('|')[1], -1);
if (querystring["customerid"] != customerid)
{
state = PAYSPERROR;
return(true);
}
string strsign = querystring["sign"];
string sign = GetPayResultSign();
if (sign != strsign)
{
state = PAYMD5ERROR;
}
return(true);
}
catch (Exception err)
{
errmsg = "解析参数出错:" + err.Message;
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.so["OnlinePay_Alipay_Status_ON"].ToBoolean(false);
if (WebConfig.GetAppSettingsInt("OnlinePayType", 2) == 2)
{
base.Response.Redirect("../Alipay02/Default.aspx", true);
}
else
{
double num2 = _Convert.StrToDouble(Utility.GetRequest("PayMoney"), 0.0);
string request = Utility.GetRequest("BankCode");
if (!base.IsPostBack)
{
if (base._User.Competences.CompetencesList.IndexOf("Administrator") > 0)
{
if (num2 < 0.01)
{
base.Response.Write("<script type=\"text/javascript\">alert(\"请输入正确的充值金额！再提交，谢谢！\"); window.close();</script>");
return;
}
}
else if (num2 < 1.0)
{
base.Response.Write("<script type=\"text/javascript\">alert(\"请输入正确的充值金额！再提交，谢谢！\"); window.close();</script>");
return;
}
double num3 = this.so["OnlinePay_Alipay_PayFormalitiesFeesScale"].ToDouble(0.0) / 100.0;
double formalitiesFees = Math.Round((double)(num2 * num3), 2);
num2 += formalitiesFees;
this.gateway = "https://www.alipay.com/cooperate/gateway.do?";
this.service = "create_direct_pay_by_user";
this.sign_type = "MD5";
this.payment_type = "1";
this._input_charset = "utf-8";
this.return_url = Utility.GetUrl() + "/Home/Room/OnlinePay/Alipay01/Receive.aspx";
this.notify_url = Utility.GetUrl() + "/Home/Room/OnlinePay/Alipay01/AlipayNotify.aspx";
this.partner = this.so["OnlinePay_Alipay_UserNumber"].ToString("");
this.show_url = "http://www.alipay.com";
this.seller_email = this.so["OnlinePay_Alipay_UserName"].ToString("");
this.key = this.so["OnlinePay_Alipay_MD5Key"].ToString("");
this.paymethod = "bankPay";
this.buyer_email = base._User.Email;
this.subject = Encrypt.EncryptString(PF.GetCallCert(), base._User.ID.ToString());
this.body = "TicketMoney";
double num6 = Convert.ToDouble(num2.ToString());
this.total_fee = num6.ToString();
long newPayNumber = -1L;
string returnDescription = "";
if (Procedures.P_GetNewPayNumber(base._Site.ID, base._User.ID, "Alipay", num6 - formalitiesFees, formalitiesFees, ref newPayNumber, ref returnDescription) < 0)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
}
else if ((newPayNumber < 0L) || (returnDescription != ""))
{
PF.GoError(1, returnDescription, base.GetType().BaseType.FullName);
}
else
{
this.out_trade_no = newPayNumber.ToString();
if (request.ToLower() == "alipay")
{
this.AlipayPay();
}
else
{
this.BankClick(request);
}
}
}
}
}
private void btnReportAnalisys_Click(object sender, EventArgs e)
{
ReportDocument ReportDoc = new ReportDocument();
string path = Meta.GetUsr("localreportdir").ToString();
string fName = txtFile.Text;
string repFileName = Path.Combine(path, fName);
try {
// Open a temporary copy of the report.
ReportDoc.Load(repFileName, OpenReportMethod.OpenReportByTempCopy);
}
catch (Exception ee) {
QueryCreator.ShowException(this, "Impossibile caricare il report " + repFileName, ee);
return;
}
//ReportDispatcherClass.setReportLogon(ReportDoc, Conn as Easy_DataAccess);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
crDatabase = ReportDoc.Database;
crTables = crDatabase.Tables;
//Nome SP = spName;
StringBuilder sbParam = new StringBuilder();
foreach (ParameterFieldDefinition PF in ReportDoc.DataDefinition.ParameterFields)
{
//solo se appartengono al report in elaborazione
if (PF.ReportName != "")
{
continue;
}
if (PF.IsLinked())
{
continue;
}
//PF.Name @ayear
//PF.ValueType Numberfield StringField
sbParam.AppendLine($"{PF.Name} type:{PF.ValueType}");
}
StringBuilder sbFormula = new StringBuilder();
foreach (FormulaFieldDefinition FFD in ReportDoc.DataDefinition.FormulaFields)
{
sbFormula.AppendLine($"{FFD.FormulaName} kind: {FFD.ValueType}");
}
StringBuilder sbSP = new StringBuilder();
sbSP.AppendLine($"Report principale: {ReportDoc.FilePath} Stored Procedure: {getSPName(ReportDoc)}");
//mi scorro tutti i subreport (se presenti) del report principale
ReportDefinition repDef = ReportDoc.ReportDefinition;
foreach (Section sec in repDef.Sections)
{
foreach (ReportObject repObj in sec.ReportObjects)
{
if (repObj.Kind != ReportObjectKind.SubreportObject)
{
continue;
}
SubreportObject subRep = (SubreportObject)repObj;
ReportDocument SubReport = subRep.OpenSubreport(subRep.SubreportName);
sbSP.AppendLine($"SubReport: {SubReport.Name} Stored Procedure: {getSPName(SubReport)}");
SubReport.Close();
}
}
FrmShowParams p = new FrmShowParams(sbParam.ToString(), sbFormula.ToString(), sbSP.ToString(), Conn, getSPName(ReportDoc));
ReportDoc.Close();
p.Show(this);
}
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(Home_Room_Receive), this.Page);
if (this.Request.QueryString.Count < 1)
{
Shove._Web.JavaScript.Alert(this.Page, "接口调用失败，请重新登录。", "../../Index.aspx");
return;
}
string alipayNotifyURL = "http://notify.alipay.com/trade/notify_query.do?";
string partner = so["MemberSharing_Alipay_UserNumber"].ToString(""); //卖家商户号
alipayNotifyURL = alipayNotifyURL + "partner=" + partner + "¬ify_id=" + Request.QueryString["notify_id"];
//获取支付宝ATN返回结果，true是正确的订单信息，false 是无效的
string responseTxt = Get_Http(alipayNotifyURL, 120000);
if (responseTxt == "false")
{
Shove._Web.JavaScript.Alert(this.Page, "接口调用失败，请重新登录。", "../../Index.aspx");
return;
}
if (Shove._Web.WebConfig.GetAppSettingsBool("DebugUserControl", false))
{
tbName.Text = "为了设计页面而进入调试状态，本控件的功能并不运行";
return;
}
string key = so["MemberSharing_Alipay_MD5"].ToString(""); //partner 的对应交易安全校验码（必须填写）和alipay.cs文件中值是一样的
string _input_charset = "utf-8";
int i;
String[] requestarr = Request.QueryString.AllKeys;
//进行排序；
string[] Sortedstr = Shove.Alipay.Alipay.BubbleSort(requestarr);
//构造待md5摘要字符串 ；
StringBuilder prestr = new StringBuilder();
for (i = 0; i < Sortedstr.Length; i++)
{
if (String.IsNullOrEmpty(Sortedstr[i]))
{
continue;
}
if (Request.QueryString[Sortedstr[i]] != "" && Sortedstr[i] != "sign" && Sortedstr[i] != "sign_type" && Sortedstr[i].ToLower() != "pn")
{
if (i == Sortedstr.Length - 1)
{
prestr.Append(Sortedstr[i] + "=" + Request.QueryString[Sortedstr[i]]);
}
else
{
prestr.Append(Sortedstr[i] + "=" + Request.QueryString[Sortedstr[i]] + "&");
}
}
}
prestr.Append(key);
//生成Md5摘要；
string mysign = Shove.Alipay.Alipay.GetMD5(prestr.ToString(), _input_charset);
string sign = (Request.QueryString["sign"] == null ? "" : Request.QueryString["sign"].ToString());
string Success = (Request.QueryString["is_success"] == null ? "" : Request.QueryString["is_success"].ToString().ToUpper());
string User_id = (Request.QueryString["user_id"] == null ? "" : Request.QueryString["user_id"].ToString());
string Email = (Request.QueryString["email"] == null ? "" : Request.QueryString["email"].ToString()); //获得用户EMail
string User_Type = (Request.QueryString["user_type"] == null ? "" : Request.QueryString["user_type"].ToString());
string User_Status = (Request.QueryString["user_status"] == null ? "" : Request.QueryString["user_status"].ToString());
string Firm_Name = (Request.QueryString["firm_name"] == null ? "" : Request.QueryString["firm_name"].ToString());
string Real_Name = (Request.QueryString["real_name"] == null ? "" : Request.QueryString["real_name"].ToString());
string Cert_NO = (Request.QueryString["cert_no"] == null ? "" : Request.QueryString["cert_no"].ToString()); //获得证件号码
string Cert_Type = (Request.QueryString["cert_type"] == null ? "" : Request.QueryString["cert_type"].ToString());
string Gender = (Request.QueryString["gender"] == null ? "" : Request.QueryString["gender"].ToString());
string Province = (Request.QueryString["province"] == null ? "" : Request.QueryString["province"].ToString());
string City = (Request.QueryString["city"] == null ? "" : Request.QueryString["city"].ToString());
string Address = (Request.QueryString["address"] == null ? "" : Request.QueryString["address"].ToString());
string Zip = (Request.QueryString["zip"] == null ? "" : Request.QueryString["zip"].ToString());
string Phone = (Request.QueryString["phone"] == null ? "" : Request.QueryString["phone"].ToString());
string Mobile = (Request.QueryString["mobile"] == null ? "" : Request.QueryString["mobile"].ToString());
string Is_Bank_Auth = (Request.QueryString["is_bank_auth"] == null ? "" : Request.QueryString["is_bank_auth"].ToString());
string Is_Mobile_Auth = (Request.QueryString["is_mobile_auth"] == null ? "" : Request.QueryString["is_mobile_auth"].ToString());
string Is_Id_Auth = (Request.QueryString["is_id_auth"] == null ? "" : Request.QueryString["is_id_auth"].ToString());
//******************************************************************************
if (mysign != sign) //验证支付发过来的消息，签名是否正确（防止有伪造消息）
{
PF.GoError(ErrorNumber.Unknow, "您不是有效的支付宝会员不能登录本站，请您注册成为本站会员，再登录，谢谢！(-1001)", this.GetType().FullName);
return;
}
if (Success != "T")
{
PF.GoError(ErrorNumber.Unknow, "您不是有效的支付宝会员不能登录本站，请您注册成为本站会员，再登录，谢谢！(-1002)", this.GetType().FullName);
return;
}
//处理数据
if (String.IsNullOrEmpty(User_id))
{
PF.GoError(ErrorNumber.Unknow, "您不是有效的支付宝会员不能登录本站，请您注册成为本站会员，再登录，谢谢！(-1003)", this.GetType().FullName);
return;
}
Sites site = new Sites()[Shove._Web.Utility.GetUrlWithoutHttp()];
if (site == null)
{
PF.GoError(ErrorNumber.Unknow, "会员数据校验错误。", this.GetType().FullName);
return;
}
if (_User != null && Shove._Web.Cache.GetCache("BindAlipay_" + _User.ID.ToString()) != null)
{
string AlipayRealityName = "";
long AlipayMemberID = new Alipay.Gateway.Member().Query(Email, ref AlipayRealityName);
if (AlipayMemberID < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "输入的账号在支付宝网站验证失败(不存在账号或者网络通讯故障，" + AlipayMemberID.ToString() + ")，请重新填写一个账号名称。");
return;
}
if (Real_Name != _User.RealityName && AlipayRealityName != _User.RealityName && _User.RealityName != "")
{
Shove._Web.JavaScript.Alert(this.Page, "您输入的支付宝账号的真实姓名与您在本站注册时提供的真实姓名不一致，请更换新的支付宝帐号进行绑定，谢谢！", "Login.aspx");
return;
}
Shove._Web.Cache.ClearCache("BindAlipay_" + _User.ID.ToString());
System.Threading.Thread.Sleep(500);
Users tu = new Users(_Site.ID);
_User.Clone(tu);
_User.AlipayID = AlipayMemberID.ToString();
_User.AlipayName = Email;
_User.RealityName = AlipayRealityName;
_User.isAlipayNameValided = true;
string ReturnDescription = "";
if (_User.EditByID(ref ReturnDescription) < 0)
{
tu.Clone(_User);
Shove._Web.JavaScript.Alert(this.Page, ReturnDescription);
return;
}
Shove._Web.JavaScript.Alert(this.Page, "支付宝绑定成功！", "BindAlipay.aspx");
}
DAL.Tables.T_Users t_users = new DAL.Tables.T_Users();
DataTable dt = t_users.Open("[ID], [Name]", "SiteID = " + site.ID.ToString() + " and AlipayID = '" + Shove._Web.Utility.FilteSqlInfusion(User_id) + "'", "[ID]");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().FullName);
return;
}
if (!IsPostBack)
{
labAccount.Text = Email;
labAccount2.Text = Email;
if (dt.Rows.Count < 1)
{
// 不存在，注册为新会员
tbAlipayID.Text = User_id;
tbName.Text = Email.Split('@')[0];
//tbIDCardNumber.Text = Cert_NO;
Script = "btn_CheckUserName('" + tbName.Text + "')";
btnSelect.Enabled = false;
tableSelect.Visible = false;
return;
}
else if (dt.Rows.Count == 1)
{
long UserID = Shove._Convert.StrToLong(dt.Rows[0]["ID"].ToString(), -1);
if (UserID < 0)
{
PF.GoError(ErrorNumber.Unknow, "会员数据校验错误。", this.GetType().FullName);
return;
}
Users user = new Users(site.ID)[site.ID, UserID];
if (user == null)
{
PF.GoError(ErrorNumber.Unknow, "会员数据校验错误。", this.GetType().FullName);
return;
}
string ReturnDescription = "";
if (user.LoginDirect(ref ReturnDescription) < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().FullName);
return;
}
Response.Redirect("../../Index.aspx", true);
return;
}
// 绑定了多个用户
tableRegister.Visible = false;
btnOK.Enabled = false;
tableSelect.Visible = true;
btnSelect.Enabled = true;
Shove.ControlExt.FillDropDownList(ddlName, dt, "Name", "ID");
ddlName.SelectedIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SiteID = _Site.ID;
Admin = ResolveUrl("~/Admin/Default.aspx");
NotifyImg = ResolveUrl("~/Home/Room/Images/notify_bg.gif");
Message = ResolveUrl("~/Home/Room/Message.aspx");
RefreshImg = ResolveUrl("~/Home/Room/Images/icon_shuaxin.gif");
ForgetPassword = ResolveUrl("~/UserForgetPassword.aspx");
Register = ResolveUrl("~/UserReg.aspx");
Reg = ResolveUrl("~/Index.aspx");
MyIcaile = ResolveUrl("~/Home/Room/UserEdit.aspx");
LoginUrl = ResolveUrl("~/UserLogin.aspx?ReturnUrl=" + Shove._Security.Encrypt.EncryptString(PF.GetCallCert(), this.Request.Url.AbsoluteUri));
if (_User != null)
{
hUserID.Value = _User.ID.ToString();
UserAddValue.Visible = true;
UserDistill.Visible = true;
this.span1.Visible = true;
this.span2.Visible = true;
}
string UseLotteryList = Shove._Web.Cache.GetCacheAsString("Site_UseLotteryList" + _Site.ID, "");
string[] LotteryList = null;
if (UseLotteryList == "")
{
UseLotteryList = DAL.Functions.F_GetUsedLotteryList(_Site.ID);
if (UseLotteryList != "")
{
Shove._Web.Cache.SetCache("Site_UseLotteryList" + _Site.ID, UseLotteryList);
}
}
LotteryList = UseLotteryList.Split(',');
for (int i = 0; i < LotteryList.Length; i++)
{
if (LotteryList[i].Equals("5"))
{
this.aHref5.Disabled = false;
this.aHref5.HRef = "~/Lottery/BuySSQ.aspx";
//this.aHref5.Target = "_blank";
}
else if (LotteryList[i].Equals("6"))
{
this.aHref6.Disabled = false;
this.aHref6.HRef = "~/Lottery/Buy3D.aspx";
// this.aHref6.Target = "_blank";
}
else if (LotteryList[i].Equals("13"))
{
this.aHref13.Disabled = false;
this.aHref13.HRef = "~/Lottery/BuyQLC.aspx";
// this.aHref13.Target = "_blank";
}
else if (LotteryList[i].Equals("59"))
{
this.aHref59.Disabled = false;
this.aHref59.HRef = "~/Lottery/Buy15X5.aspx";
//this.aHref59.Target = "_blank";
}
else if (LotteryList[i].Equals("58"))
{
this.aHref58.Disabled = false;
this.aHref58.HRef = "~/Lottery/BuyDF6J1.aspx";
// this.aHref58.Target = "_blank";
}
else if (LotteryList[i].Equals("3"))
{
this.aHref3.Disabled = false;
this.aHref3.HRef = "~/Lottery/BuyQXC.aspx";
// this.aHref3.Target = "_blank";
}
else if (LotteryList[i].Equals("39"))
{
this.aHref39.Disabled = false;
this.aHref39.HRef = "~/Lottery/BuyCJDLT.aspx";
// this.aHref39.Target = "_blank";
}
else if (LotteryList[i].Equals("9"))
{
this.aHref9.Disabled = false;
this.aHref9.HRef = "~/Lottery/Buy22X5.aspx";
// this.aHref9.Target = "_blank";
}
else if (LotteryList[i].Equals("63"))
{
this.aHref63.Disabled = false;
this.aHref63.HRef = "~/Lottery/BuyPL3.aspx";
//this.aHref63.Target = "_blank";
}
else if (LotteryList[i].Equals("64"))
{
this.aHref64.Disabled = false;
this.aHref64.HRef = "~/Lottery/BuyPL5.aspx";
//this.aHref64.Target = "_blank";
}
else if (LotteryList[i].Equals("65"))
{
this.aHref65.Disabled = false;
this.aHref65.HRef = "~/Lottery/Buy31X7.aspx";
//this.aHref65.Target = "_blank";
}
else if (LotteryList[i].Equals("74"))
{
this.aHref1.Disabled = false;
this.aHref1.HRef = "~/Lottery/BuySFC.aspx";
// this.aHref1.Target = "_blank";
}
else if (LotteryList[i].Equals("75"))
{
this.aHref1_9.Disabled = false;
this.aHref1_9.HRef = "~/Lottery/BuySFC_9_D.aspx";
// this.aHref1_9.Target = "_blank";
}
else if (LotteryList[i].Equals("2"))
{
this.aHref2.Disabled = false;
this.aHref2.HRef = "~/Lottery/BuyJQC.aspx";
// this.aHref2.Target = "_blank";
}
else if (LotteryList[i].Equals("15"))
{
this.aHref15.Disabled = false;
this.aHref15.HRef = "~/Lottery/BuyLCBQC.aspx";
// this.aHref15.Target = "_blank";
}
else if (LotteryList[i].Equals("29"))
{
this.aHref29.Disabled = false;
this.aHref29.HRef = "~/Lottery/BuySSL.aspx";
//this.aHref29.Target = "_blank";
}
else if (LotteryList[i].Equals("62"))
{
this.aHref62.Disabled = false;
this.aHref62.HRef = "~/Lottery/BuySYYDJ.aspx";
//this.aHref62.Target = "_blank";
}
else if (LotteryList[i].Equals("61"))
{
this.aHref61.Disabled = false;
this.aHref61.HRef = "~/Lottery/BuySSC.aspx";
//this.aHref61.Target = "_blank";
}
else if (LotteryList[i].Equals("28"))
{
this.aHref28.Disabled = false;
this.aHref28.HRef = "~/Lottery/BuyCQSSC.aspx";
//this.aHref28.Target = "_blank";
}
else if (LotteryList[i].Equals("70"))
{
this.aHref70.Disabled = false;
this.aHref70.HRef = "~/Lottery/BuyJX11X5.aspx";
//this.aHref70.Target = "_blank";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
bool OnlinePay_Alipay_Status_ON = so["OnlinePay_Alipay_Status_ON"].ToBoolean(false);
int OnlinePayType = Shove._Web.WebConfig.GetAppSettingsInt("OnlinePayType", 2);
if (OnlinePayType == 2)
{
Response.Redirect("../Alipay02/Default.aspx", true);
return;
}
double Money = Shove._Convert.StrToDouble(Shove._Web.Utility.GetRequest("PayMoney"), 0);
string BankCode = Shove._Web.Utility.GetRequest("BankCode");
if (!IsPostBack)
{
if (_User.Competences.CompetencesList.IndexOf(Competences.Administrator) > 0)
{
if (Money < 0.01)
{
Response.Write("<script type=\"text/javascript\">alert(\"请输入正确的充值金额！再提交，谢谢！\"); window.close();</script>");
//Shove._Web.JavaScript.Alert(this.Page, "请输入正确的充值金额！");
return;
}
}
else
{
if (Money < 1)
{
Response.Write("<script type=\"text/javascript\">alert(\"请输入正确的充值金额！再提交，谢谢！\"); window.close();</script>");
return;
}
}
double FormalitiesFeesScale = so["OnlinePay_Alipay_PayFormalitiesFeesScale"].ToDouble(0) / 100;
double FormalitiesFees = Math.Round(Money * FormalitiesFeesScale, 2);
Money += FormalitiesFees;
//业务参数赋值；
gateway = "https://www.alipay.com/cooperate/gateway.do?"; //支付接口
service = "create_direct_pay_by_user";
sign_type = "MD5";
payment_type = "1"; //支付类型
_input_charset = "utf-8"; //编码类型
return_url = Shove._Web.Utility.GetUrl() + "/Home/Room/OnlinePay/Alipay01/Receive.aspx"; //服务器通知返回接口
notify_url = Shove._Web.Utility.GetUrl() + "/Home/Room/OnlinePay/Alipay01/AlipayNotify.aspx"; //服务器通知返回接口(暂时不用
partner = so["OnlinePay_Alipay_UserNumber"].ToString(""); //卖家商户号
show_url = "http://www.alipay.com";
seller_email = so["OnlinePay_Alipay_UserName"].ToString(""); //卖家支付宝名称(邮箱)
key = so["OnlinePay_Alipay_MD5Key"].ToString("");
paymethod = "bankPay"; //赋值:bankPay(网银);cartoon(卡通); directPay(余额) 三种付款方式都要，参数为空
buyer_email = _User.Email;
//构造商品名称
subject = Shove._Security.Encrypt.EncryptString(PF.GetCallCert(), _User.ID.ToString()); //商品名称,作为加密的用户ID用
body = "TicketMoney"; //商品描述
double PayMoney = Convert.ToDouble(Money.ToString());
total_fee = PayMoney.ToString(); //总金额 0.01～50000.00
long NewPayNumber = -1;
string ReturnDescription = "";
if (DAL.Procedures.P_GetNewPayNumber(_Site.ID, _User.ID, "Alipay", (PayMoney - FormalitiesFees), FormalitiesFees, ref NewPayNumber, ref ReturnDescription) < 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
if ((NewPayNumber < 0) || (ReturnDescription != ""))
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().BaseType.FullName);
return;
}
out_trade_no = NewPayNumber.ToString();
if (BankCode.ToLower() == "alipay")
{
AlipayPay();
}
else
{
BankClick(BankCode);
}
}
}
protected void DataListZCDC_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
{
if (e.CommandName == "btEdit")
{
this.DataListZCDC.EditItemIndex = e.Item.ItemIndex;
}
if (e.CommandName == "btUpdate")
{
try
{
TextBox tb1 = (TextBox)(DataListZCDC.Items[e.Item.ItemIndex].FindControl("tb1ZCDC"));
TextBox tb2 = (TextBox)(DataListZCDC.Items[e.Item.ItemIndex].FindControl("tb2ZCDC"));
TextBox tb3 = (TextBox)(DataListZCDC.Items[e.Item.ItemIndex].FindControl("tb3ZCDC"));
DropDownList ddlLetBall = (DropDownList)(DataListZCDC.Items[e.Item.ItemIndex].FindControl("ddlLetBall"));
DropDownList ddlLeagueType = (DropDownList)(DataListZCDC.Items[e.Item.ItemIndex].FindControl("ddlLeagueType"));
HiddenField hf1 = (HiddenField)(DataListZCDC.Items[e.Item.ItemIndex].FindControl("hfId"));
if ((tb1.Text.Trim() == "") || (tb2.Text.Trim() == "") || (tb3.Text.Trim() == ""))
{
Shove._Web.JavaScript.Alert(this.Page, "本场比赛球队名称输入不完整！");
return;
}
object dt = PF.ValidLotteryTime(tb3.Text.Trim());
if (dt == null)
{
Shove._Web.JavaScript.Alert(this.Page, "本场比赛球队时间输入不正确！(格式：0000-00-00 00:00:00)");
return;
}
int id = int.Parse(hf1.Value);
long IsuseID = int.Parse(tbIsuseID.Text);
//int return_int = 0;
//string return_str = "";
//DAL.Procedures.P_IsuseEditOneForZCDC(id, int.Parse(ddlLeagueType.SelectedValue), tb1.Text.Trim(), tb2.Text.Trim(), tb3.Text.Trim(), IsuseID, ddlLeagueType.SelectedValue, ref return_int, ref return_str);
//if (return_int < 0)
//{
// Shove._Web.JavaScript.Alert(this.Page, return_str);
// return;
//}
//Shove._Web.JavaScript.Alert(this.Page, "更新成功!");
}
catch
{
PF.GoError(ErrorNumber.Unknow, "单场信息更新错误。", this.Page.GetType().BaseType.FullName);
return;
}
this.DataListZCDC.EditItemIndex = -1;
}
BindData();
}
}
private void BindData()
{
//合买方案缓存 60 秒
string CacheKey = "Home_Room_UserAllBuy_BindData";
string strCmd = @"select LotteryName, InitiateName,Level,
Money, Schedule,Title,case Schedule when 100 then 1 else 0 end as IsFull,LotteryID,SchemeBonusScale, ID, QuashStatus,(Share-BuyedShare) as ResShare,AssureMoney,Money/Share as ShareMoney,IsuseID,EndTime,AtTopStatus,PlayTypeID
from V_Schemes with (nolock) where IsuseID in
(select id from T_Isuses where getdate() between StartTime and EndTime)
and Share > 1 and LotteryID in (" + DAL.Functions.F_GetUsedLotteryList(_Site.ID) + ") order by QuashStatus asc,IsFull asc,Schedule desc,[Money] desc";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(CacheKey);
if (dt == null)
{
dt = MSSQL.Select(strCmd);
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().FullName);
return;
}
Shove._Web.Cache.SetCache(CacheKey, dt, 600);
}
DataTable dtData = dt.Clone();
dtData.Columns.Add("Count", typeof(Int32));
string Condition = "1=1";
if (ddlLottery.SelectedValue != "-1")
{
if (ddlLottery.SelectedValue == "0")
{
Condition += " and LotteryID not in(5,6,1,19,39,62,29)";
}
else
{
if (ddlLottery.SelectedValue == "19")
{
Condition += " and (PlayTypeID = 103 or PlayTypeID = 104) and LotteryID = 1";
}
else
{
Condition += " and LotteryID=" + ddlLottery.SelectedValue + "";
if (ddlLottery.SelectedValue == "1")
{
Condition += " and (PlayTypeID = 101 or PlayTypeID = 102)";
}
}
}
}
if (ddlMoney.SelectedValue != "-1")
{
Condition += " and " + ddlMoney.SelectedValue;
}
if (ddlBonus.SelectedValue != "-1")
{
Condition += " and SchemeBonusScale<=" + ddlBonus.SelectedValue;
}
if (ddlCondition.SelectedValue != "-1")
{
Condition += " and " + ddlCondition.SelectedValue;
}
if (tbName.Text != "")
{
Condition += " and InitiateName like '%" + Shove._Web.Utility.FilteSqlInfusion(tbName.Text) + "%'";
}
int i = 0;
foreach (DataRow dr in dt.Select(Condition, "QuashStatus asc,IsFull asc, Schedule desc,[Money] desc"))
{
dtData.Rows.Add(dr.ItemArray);
dtData.Rows[i]["Count"] = i + 1;
i++;
}
PF.DataGridBindData(g, dtData, gPager);
}
/// <summary>
/// 绑定名人合买
/// </summary>
private void BindCollect()
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("DataCache_CelebrityHall_Collects");
if (dt == null)
{
dt = Shove.Database.MSSQL.Select("select s.ID,u.ID as UserID,s.ID as SchemeID,l.ID as LotteryID ,s.[Money],s.Share,s.BuyedShare,i.Name,l.Name as LotteryName,u.Name as UserName,[WinMoney]=(select SUM(WinMoneyNoWithTax) from T_Schemes where InitiateUserID = s.InitiateUserID and WinMoney > 0 and DateTime > dateAdd(mm,-1,getdate())) from T_Schemes as s ,T_Isuses as i,T_PlayTypes as p,T_Lotteries as l,T_Users as u where s.Share > s.BuyedShare and s.QuashStatus = 0 and s.PlayTypeID = p.ID and s.IsuseID = i.ID and l.ID = p.LotteryID and s.InitiateUserID in (select UserID from T_Personages group by UserID) and u.ID in (select UserID from T_Personages group by UserID) and u.ID = s.initiateUserID");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试(131)", this.GetType().BaseType.FullName);
return;
}
if (dt.Rows.Count > 0)
{
// 1200M
Shove._Web.Cache.SetCache("DataCache_CelebrityHall_Collects", dt, 1200);
}
}
if (dt == null)
{
return;
}
if (dt.Rows.Count < 1)
{
return;
}
// 区分UserID
string UserIDState = "";
StringBuilder sb = new StringBuilder();
sb.AppendLine("<div class=\"mrhm_list\" id=\"_mr_info\"><div class=\"LeftBotton\" id=\"LeftArr\"></div><div></div><div class=\"Cont\" id=\"ISL_Cont_1\"><ul>");
int index = 0;
bool state = false;
foreach (DataRow dr in dt.Rows)
{
if (!UserIDState.Equals(dr["UserID"].ToString()))
{
index = 0;
if (state)
{
sb.AppendLine("</div></li>");
}
else
{
state = true;
}
sb.AppendLine("<li><div class=\"mr_info\"><h2><img src=\"images/icon.gif\" width=\"58\" height=\"58\" /></h2>")
.AppendLine("<dl><h3><a href=\"../Home/Web/Score.aspx?id=" + dr["UserID"] + "&LotteryID=" + dr["LotteryID"] + " \" target=\"_blank\">" + dr["UserName"] + "</a></h3><dt>")
.AppendLine("<span></span>近期中奖 <em>" + Shove._Convert.StrToDouble(dr["WinMoney"].ToString(), 0).ToString("F2") + "</em>元</dt><dt></dt></dl>")
.AppendLine("<div class=\"mr_fangan_tit\"><dl><a href=\"../Home/Web/Score.aspx?id=" + dr["UserID"] + "&LotteryID=" + dr["LotteryID"] + " \" target=\"_blank\">更多>></a></dl><h3>他的方案</h3></div>")
.AppendLine("<div class=\"mr_fangan_list\">");
// 计算进度
double sacle = Shove._Convert.StrToDouble(dr["BuyedShare"].ToString(), 0) / Shove._Convert.StrToDouble(dr["Share"].ToString(), 0) * 100;
sb.AppendLine("<dl style=\"width:210px\" ><span><a href=\"../Home/Room/Scheme.aspx?id=" + dr["SchemeID"] + "\" target=\"_blank\">抢购</a></span><a href=\"../Home/Room/Scheme.aspx?id=" + dr["SchemeID"] + "\" target=\"_blank\">" + dr["LotteryName"] + "" + dr["Name"] + "期</a> <em>￥" + Shove._Convert.StrToDouble(dr["Money"].ToString(), 0).ToString("F2") + "</em> 进度<em>" + sacle.ToString("F2") + "%</em></dl>");
}
else
{
if (index < 2)
{
double sacle = Shove._Convert.StrToDouble(dr["BuyedShare"].ToString(), 0) / Shove._Convert.StrToDouble(dr["Share"].ToString(), 0) * 100;
sb.AppendLine("<dl style=\"width:210px\" ><span><a href=\"../Home/Room/Scheme.aspx?id=" + dr["SchemeID"] + "\" target=\"_blank\" >抢购</a></span><a href=\"../Home/Room/Scheme.aspx?id=" + dr["SchemeID"] + "\" target=\"_blank\">" + dr["LotteryName"] + "" + dr["Name"] + "期</a> <em>￥" + Shove._Convert.StrToDouble(dr["Money"].ToString(), 0).ToString("F2") + "</em> 进度<em>" + sacle.ToString("F1") + "%</em></dl>");
}
index++;
}
UserIDState = dr["UserID"].ToString();
}
sb.AppendLine("</div></div></li>");
sb.AppendLine("</ul></div><div class=\"RightBotton\" id=\"RightArr\"></div></div>");
innerHTML = sb.ToString();
}
/// <summary>
/// 购买彩票
/// </summary>
/// <param name="_User"></param>
private void Buy(Users _User)
{
string HidIsuseID = Shove._Web.Utility.GetRequest("HidIsuseID");
string HidIsuseEndTime = Shove._Web.Utility.GetRequest("HidIsuseEndTime");
string playType = Shove._Web.Utility.GetRequest("tbPlayTypeID");
string Chase = Shove._Web.Utility.GetRequest("Chase");
string CoBuy = Shove._Web.Utility.GetRequest("CoBuy");
string tb_Share = Shove._Web.Utility.GetRequest("tb_Share");
string tb_BuyShare = Shove._Web.Utility.GetRequest("tb_BuyShare");
string tb_AssureShare = Shove._Web.Utility.GetRequest("tb_AssureShare");
string tb_OpenUserList = "";
string tb_Title = Shove._Web.Utility.GetRequest("tb_Title");
string tb_Description = Shove._Web.Utility.GetRequest("tb_Description");
string tbAutoStopAtWinMoney = Shove._Web.Utility.GetRequest("tbAutoStopAtWinMoney");
string tbSecrecyLevel = Shove._Web.Utility.GetRequest("SecrecyLevel");
string tb_LotteryNumber = Shove._Web.Utility.FilteSqlInfusion(Request["tb_LotteryNumber"]);
string tb_hide_SumMoney = Shove._Web.Utility.GetRequest("tb_hide_SumMoney");
string tb_hide_AssureMoney = Shove._Web.Utility.GetRequest("tb_hide_AssureMoney");
string tb_hide_SumNum = Shove._Web.Utility.GetRequest("tb_hide_SumNum");
string HidIsuseCount = Shove._Web.Utility.GetRequest("HidIsuseCount");
string HidLotteryID = Shove._Web.Utility.GetRequest("HidLotteryID");
string HidIsAlipay = Shove._Web.Utility.GetRequest("HidIsAlipay");
string tb_Multiple = Shove._Web.Utility.GetRequest("tb_Multiple");
string HidIsuseName = Shove._Web.Utility.GetRequest("HidIsuseName");
string tbPlayTypeName = Shove._Web.Utility.GetRequest("tbPlayTypeName");
string ChaseBuyedMoney = Shove._Web.Utility.GetRequest("tb_hide_ChaseBuyedMoney");
string tb_SchemeBonusScale = Shove._Web.Utility.GetRequest("tb_SchemeBonusScale");
string tb_SchemeBonusScalec = Shove._Web.Utility.GetRequest("tb_SchemeBonusScalec");
int Price = 2;
if ((playType == "3903") || (playType == "3904") || (playType == "3908"))
{
Price = 3;
}
else
{
Price = 2;
}
// 结束
if (tb_Multiple == "")
{
tb_Multiple = "1";
}
double SumMoney = 0;
int Share = 0;
int BuyShare = 0;
double AssureMoney = 0;
int Multiple = 0;
int SumNum = 0;
short SecrecyLevel = 0;
int PlayTypeID = 0;
int LotteryID = 0;
long IsuseID = 0;
double AutoStopAtWinMoney = 0;
double SchemeBonusScale = 0;
double SchemeBonusScalec = 0;
try
{
SumMoney = double.Parse(tb_hide_SumMoney);
Share = int.Parse(tb_Share);
BuyShare = int.Parse(tb_BuyShare);
AssureMoney = double.Parse(tb_hide_AssureMoney);
Multiple = int.Parse(tb_Multiple);
SumNum = int.Parse(tb_hide_SumNum);
SecrecyLevel = short.Parse(tbSecrecyLevel);
PlayTypeID = int.Parse(playType);
LotteryID = int.Parse(HidLotteryID);
IsuseID = long.Parse(HidIsuseID);
AutoStopAtWinMoney = double.Parse(tbAutoStopAtWinMoney);
SchemeBonusScale = double.Parse(tb_SchemeBonusScale);
SchemeBonusScalec = double.Parse(tb_SchemeBonusScalec);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
if ((SumMoney <= 0) || (SumNum < 1))
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
if (AssureMoney < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
if (Share < 1)
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
if ((BuyShare == Share) && (AssureMoney == 0))
{
Share = 1;
BuyShare = 1;
}
if ((SumMoney / Share) < 1)
{
Shove._Web.JavaScript.Alert(this.Page, "每份金额最低不能少于 1 元。");
return;
}
double BuyMoney = BuyShare * (SumMoney / Share) + AssureMoney;
if (Chase != "")
{
BuyMoney = double.Parse(ChaseBuyedMoney);
}
if (BuyMoney > _User.Balance)
{
SaveDataForAliBuy();
return;
}
if (BuyMoney > PF.SchemeMaxBettingMoney)
{
Shove._Web.JavaScript.Alert(this.Page, "投注金额不能大于" + PF.SchemeMaxBettingMoney.ToString() + "，谢谢。");
return;
}
if (Multiple > 999)
{
Shove._Web.JavaScript.Alert(this.Page, "投注倍数不能大于 999 倍，谢谢。");
return;
}
//佣金比例的计算
if (!(SchemeBonusScale >= 0 || SchemeBonusScale <= 10))
{
Shove._Web.JavaScript.Alert(this.Page, "佣金比例只能在0~10之间");
return;
}
if (SchemeBonusScale.ToString().IndexOf("-") > -1 || SchemeBonusScale.ToString().IndexOf(".") > -1)
{
Shove._Web.JavaScript.Alert(this.Page, "佣金比例输入有误");
return;
}
if (!(SchemeBonusScalec >= 0 || SchemeBonusScalec <= 10))
{
Shove._Web.JavaScript.Alert(this.Page, "佣金比例只能在0~10之间");
return;
}
if (SchemeBonusScalec.ToString().IndexOf("-") > -1 || SchemeBonusScalec.ToString().IndexOf(".") > -1)
{
Shove._Web.JavaScript.Alert(this.Page, "佣金比例输入有误");
return;
}
SchemeBonusScale = SchemeBonusScale / 100;
SchemeBonusScalec = SchemeBonusScalec / 100;
string LotteryNumber = tb_LotteryNumber;
if (LotteryNumber[LotteryNumber.Length - 1] == '\n')
{
LotteryNumber = LotteryNumber.Substring(0, LotteryNumber.Length - 1);
}
#region 对彩票号码进行分析，判断注数
SLS.Lottery slsLottery = new SLS.Lottery();
string[] t_lotterys = SplitLotteryNumber(LotteryNumber);
if ((t_lotterys == null) || (t_lotterys.Length < 1))
{
Shove._Web.JavaScript.Alert(this.Page, "选号发生异常，请重新选择号码投注，谢谢。(-694)");
return;
}
int ValidNum = 0;
foreach (string str in t_lotterys)
{
string Number = slsLottery[LotteryID].AnalyseScheme(str, PlayTypeID);
if (string.IsNullOrEmpty(Number))
{
continue;
}
string[] str_s = Number.Split('|');
if (str_s == null || str_s.Length < 1)
{
continue;
}
ValidNum += Shove._Convert.StrToInt(str_s[str_s.Length - 1], 0);
}
if (ValidNum != SumNum)
{
Shove._Web.JavaScript.Alert(this.Page, "选号发生异常，请重新选择号码投注，谢谢。");
return;
}
#endregion
StringBuilder ChaseXML = new StringBuilder();
int RpTodayDataCount = 0;
string AdditionasXml = "";
string ReturnDescription = "";
//追号
if (Chase == "1")
{
foreach (string key in Request.Form.AllKeys)
{
if (key.IndexOf("check") > -1)
{
int row = Shove._Convert.StrToInt(key.Replace("check", ""), -1);
if (row > 0)
{
RpTodayDataCount++;
int money = Shove._Convert.StrToInt(Request.Form["tb_hide_SumNum"], -1) * Price * Shove._Convert.StrToInt(Request.Form["times" + row.ToString()], -1);
ChaseXML.Append(Request.Form[key]).Append(",")
.Append(Request.Form["times" + row.ToString()]).Append(",")
.Append(money.ToString()).Append(";");
}
}
}
if (ChaseXML.Length > 0)
{
ChaseXML.Remove(ChaseXML.Length - 1, 1);
}
if (LotteryNumber[LotteryNumber.Length - 1] == '\n')
{
LotteryNumber = LotteryNumber.Substring(0, LotteryNumber.Length - 1);
}
try
{
SumMoney = double.Parse(tb_hide_SumMoney);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。(-1325)");
return;
}
if (SumMoney < 2)
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。(-1332)");
return;
}
string[] XML = ChaseXML.ToString().Split(';');
int CompetitionCount = XML.Length;
string[] Xmlparams = new string[CompetitionCount * 6];
string str_EndTime = DAL.Functions.F_GetIsuseSystemEndTime(long.Parse(XML[0].Split(',')[0]), PlayTypeID).ToString();
DateTime EndTime = DateTime.Parse(str_EndTime);
if (DateTime.Now >= EndTime)
{
Shove._Web.JavaScript.Alert(this.Page, "您选择的追号期号中包含已截止的期，请重新选择。");
return;
}
//构建格式：期号,玩法类别,方案,倍数,金额,方案保密级别
for (int i = 0; i < CompetitionCount; i++)
{
Xmlparams[i * 6] = XML[i].Split(',')[0]; //期号
Xmlparams[i * 6 + 1] = PlayTypeID.ToString(); //玩法类别
Xmlparams[i * 6 + 2] = LotteryNumber; //方案
Xmlparams[i * 6 + 3] = XML[i].Split(',')[1]; //倍数
Xmlparams[i * 6 + 4] = XML[i].Split(',')[2]; //金额
Xmlparams[i * 6 + 5] = SecrecyLevel.ToString();
if (Shove._Convert.StrToDouble(Xmlparams[i * 6 + 3], 0) * SumMoney != Shove._Convert.StrToDouble(Xmlparams[i * 6 + 4], 1))
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
if (Shove._Convert.StrToDouble(Xmlparams[i * 6 + 3], 0) < Multiple)
{
Shove._Web.JavaScript.Alert(this.Page, "追号倍数有错误，请仔细检查！");
return;
}
if (double.Parse(Xmlparams[i * 6 + 3]) * SumNum * Price != double.Parse(Xmlparams[i * 6 + 4]))
{
Shove._Web.JavaScript.Alert(this.Page, "追号金额有错误，请仔细检查！可能原因：浏览器不兼容，建议使用IE 7.0");
return;
}
}
AdditionasXml = PF.BuildIsuseAdditionasXmlForChase(Xmlparams);
if (AdditionasXml == "")
{
Shove._Web.JavaScript.Alert(this.Page, "追号发生错误。");
return;
}
if (_User.InitiateChaseTask(tb_Title.Trim(), tb_Description.Trim(), LotteryID, AutoStopAtWinMoney, AdditionasXml, LotteryNumber, SchemeBonusScalec, ref ReturnDescription) < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().FullName + "(-754)");
return;
}
Shove._Web.Cache.ClearCache("Home_Room_CoBuy_BindDataForType" + IsuseID.ToString());
Shove._Web.Cache.ClearCache("Home_Room_SchemeAll_BindData" + IsuseID.ToString());
Shove._Web.Cache.ClearCache(_Site.ID.ToString() + "AccountFreezeDetail_" + _User.ID.ToString());
Response.Redirect("../Home/Room/UserBuySuccess.aspx?LotteryID=" + LotteryID.ToString() + "&Type=2&Money=" + BuyMoney.ToString() + "");
return;
}
else
{
if (DateTime.Now >= Shove._Convert.StrToDateTime(HidIsuseEndTime.Replace("/", "-"), DateTime.Now.AddDays(-1).ToString()))
{
Shove._Web.JavaScript.Alert(this.Page, "本期投注已截止，谢谢。");
return;
}
if (Price * SumNum * Multiple != SumMoney)
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
long SchemeID = _User.InitiateScheme(IsuseID, PlayTypeID, tb_Title.Trim() == "" ? "(无标题)" : tb_Title.Trim(), tb_Description.Trim(), LotteryNumber, "", Multiple, SumMoney, AssureMoney, Share, BuyShare, tb_OpenUserList.Trim(), short.Parse(SecrecyLevel.ToString()), SchemeBonusScale, ref ReturnDescription);
if (SchemeID < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().FullName + "(-755)");
return;
}
Shove._Web.Cache.ClearCache("Home_Room_CoBuy_BindDataForType" + IsuseID.ToString());
Shove._Web.Cache.ClearCache("Home_Room_SchemeAll_BindData" + IsuseID.ToString());
if (SumMoney > 50 && Share > 1)
{
Shove._Web.Cache.ClearCache("Home_Room_JoinAllBuy_BindData");
}
Response.Redirect("../Home/Room/UserBuySuccess.aspx?LotteryID=" + LotteryID.ToString() + "&&Money=" + BuyMoney.ToString() + "&SchemeID=" + SchemeID.ToString() + "");
return;
}
}
/// <summary>
/// 绑定playtyoe的值
/// </summary>
/// <param name="type">判断绑定的是哪个ddl</param>
private void BindDataForPlayType(int type)
{
DataTable dt = null;
if (type == 1)
{
if (ddlLottery.Items.Count < 1)
{
return;
}
ddlPlayType.Items.Clear();
ddlPlayType.Items.Add(new ListItem("全部玩法", "-1"));
dt = new DAL.Views.V_PlayTypes().Open("ID,LotteryID,Name,LotteryName,BuyFileName", "LotteryID=" + ddlLottery.SelectedValue, "");
}
else if (type == 2)
{
if (ddlLotterySet.Items.Count < 1)
{
return;
}
ddlPlayTypeSet.Items.Clear();
ddlPlayTypeSet.Items.Add(new ListItem("全部玩法", "-1"));
dt = new DAL.Views.V_PlayTypes().Open("ID,LotteryID,Name,LotteryName,BuyFileName", "LotteryID=" + ddlLotterySet.SelectedValue, "");
}
else if (type == 3)
{
if (ddlWhoLottery.Items.Count < 1)
{
return;
}
ddlWhoPlaytype.Items.Clear();
ddlWhoPlaytype.Items.Add(new ListItem("全部玩法", "-1"));
dt = new DAL.Views.V_PlayTypes().Open("ID,LotteryID,Name,LotteryName,BuyFileName", "LotteryID=" + ddlWhoLottery.SelectedValue, "");
}
if (dt == null)
{
PF.GoError(ErrorNumber.Unknow, "暂无玩法", this.GetType().FullName);
return;
}
if (type == 1)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
string strLotteryName = dt.Rows[j]["Name"].ToString().ToString();
if (dt.Rows[j]["Name"].ToString() == "61")
{
strLotteryName = strLotteryName.Replace("江西", "");
}
if (dt.Rows[j]["Name"].ToString() != "混合投注")
{
ddlPlayType.Items.Add(new ListItem(strLotteryName, dt.Rows[j]["ID"].ToString()));
}
}
}
else if (type == 2)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
string strLotteryName = dt.Rows[j]["Name"].ToString().ToString();
if (dt.Rows[j]["Name"].ToString() == "61")
{
strLotteryName = strLotteryName.Replace("江西", "");
}
if (dt.Rows[j]["Name"].ToString() != "混合投注")
{
ddlPlayTypeSet.Items.Add(new ListItem(strLotteryName, dt.Rows[j]["ID"].ToString()));
}
}
}
else if (type == 3)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
string strLotteryName = dt.Rows[j]["Name"].ToString().ToString();
if (dt.Rows[j]["Name"].ToString() == "61")
{
strLotteryName = strLotteryName.Replace("江西", "");
}
if (dt.Rows[j]["Name"].ToString() != "混合投注")
{
ddlWhoPlaytype.Items.Add(new ListItem(strLotteryName, dt.Rows[j]["ID"].ToString()));
}
}
}
}
/// <summary>
/// 余额不足时，保存数据
/// </summary>
private void SaveDataForAliBuy()
{
string HidIsuseID = Shove._Web.Utility.GetRequest("HidIsuseID");
string HidIsuseEndTime = Shove._Web.Utility.GetRequest("HidIsuseEndTime");
string playType = Shove._Web.Utility.GetRequest("tbPlayTypeID");
string Chase = Shove._Web.Utility.GetRequest("Chase");
string Cobuy = Shove._Web.Utility.GetRequest("Cobuy");
string tb_Share = Shove._Web.Utility.GetRequest("tb_Share");
string tb_BuyShare = Shove._Web.Utility.GetRequest("tb_BuyShare");
string tb_AssureShare = Shove._Web.Utility.GetRequest("tb_AssureShare");
string tb_OpenUserList = Shove._Web.Utility.GetRequest("tb_OpenUserList");
string tb_Title = Shove._Web.Utility.GetRequest("tb_Title");
string tb_Description = Shove._Web.Utility.GetRequest("tb_Description");
string tbAutoStopAtWinMoney = Shove._Web.Utility.GetRequest("tbAutoStopAtWinMoney");
string tbSecrecyLevel = Shove._Web.Utility.GetRequest("SecrecyLevel");
string tbPlayTypeName = Shove._Web.Utility.GetRequest("tbPlayTypeName");
string tb_LotteryNumber = Shove._Web.Utility.FilteSqlInfusion(Request["tb_LotteryNumber"]);
string tb_hide_SumMoney = Shove._Web.Utility.GetRequest("tb_hide_SumMoney");
string tb_hide_AssureMoney = Shove._Web.Utility.GetRequest("tb_hide_AssureMoney");
string tb_hide_SumNum = Shove._Web.Utility.GetRequest("tb_hide_SumNum");
string HidIsuseCount = Shove._Web.Utility.GetRequest("HidIsuseCount");
string HidLotteryID = Shove._Web.Utility.GetRequest("HidLotteryID");
string HidIsAlipay = Shove._Web.Utility.GetRequest("HidIsAlipay");
string tb_Multiple = Shove._Web.Utility.GetRequest("tb_Multiple");
string AdditionasXml = "";
StringBuilder ChaseXML = new StringBuilder();
int RpTodayDataCount = 0;
int Price = 2;
if ((playType == "3903") || (playType == "3904"))
{
Price = 3;
}
else
{
Price = 2;
}
// 结束
if (tb_Multiple == "")
{
tb_Multiple = "1";
}
if (Chase == "1")
{
foreach (string key in Request.Form.AllKeys)
{
if (key.IndexOf("check") > -1)
{
int row = Shove._Convert.StrToInt(key.Replace("check", ""), -1);
if (row > 0)
{
RpTodayDataCount++;
int money = Shove._Convert.StrToInt(tb_hide_SumNum, -1) * Price * Shove._Convert.StrToInt(Request.Form["times" + row.ToString()], -1);
ChaseXML.Append(Request.Form[key]).Append(",")
.Append(Request.Form["times" + row.ToString()]).Append(",")
.Append(money.ToString()).Append(";");
}
}
}
string LotteryNumber = tb_LotteryNumber;
if (ChaseXML.Length > 0)
{
ChaseXML.Remove(ChaseXML.Length - 1, 1);
}
if (LotteryNumber[LotteryNumber.Length - 1] == '\n')
{
LotteryNumber = LotteryNumber.Substring(0, LotteryNumber.Length - 1);
}
string[] XML = ChaseXML.ToString().Split(';');
int CompetitionCount = XML.Length;
string[] Xmlparams = new string[CompetitionCount * 6];
string str_EndTime = DAL.Functions.F_GetIsuseSystemEndTime(long.Parse(XML[0].Split(',')[0]), int.Parse(playType)).ToString();
DateTime EndTime = DateTime.Parse(str_EndTime);
if (DateTime.Now >= EndTime)
{
Shove._Web.JavaScript.Alert(this.Page, "您选择的追号期号中包含已截止的期，请重新选择。");
return;
}
//构建格式：期号,玩法类别,方案,倍数,金额,方案保密级别
for (int i = 0; i < CompetitionCount; i++)
{
Xmlparams[i * 6] = XML[i].Split(',')[0]; //期号
Xmlparams[i * 6 + 1] = playType; //玩法类别
Xmlparams[i * 6 + 2] = LotteryNumber; //方案
Xmlparams[i * 6 + 3] = XML[i].Split(',')[1]; //倍数
Xmlparams[i * 6 + 4] = XML[i].Split(',')[2]; //金额
Xmlparams[i * 6 + 5] = tbSecrecyLevel;
}
AdditionasXml = PF.BuildIsuseAdditionasXmlForChase(Xmlparams);
}
DAL.Tables.T_AlipayBuyTemp tbp = new DAL.Tables.T_AlipayBuyTemp();
tbp.SiteID.Value = 1;
tbp.UserID.Value = -1;
tbp.Money.Value = tb_hide_SumMoney;
tbp.HandleResult.Value = 0;
tbp.IsChase.Value = Chase == "1";
tbp.IsCoBuy.Value = Cobuy == "2";
tbp.LotteryID.Value = HidLotteryID;
tbp.IsuseID.Value = HidIsuseID;
tbp.PlayTypeID.Value = playType;
tbp.StopwhenwinMoney.Value = tbAutoStopAtWinMoney;
tbp.AdditionasXml.Value = AdditionasXml;
tbp.Title.Value = tb_Title;
tbp.Description.Value = tb_Description;
tbp.LotteryNumber.Value = tb_LotteryNumber;
tbp.UpdateloadFileContent.Value = "";
tbp.Multiple.Value = tb_Multiple;
tbp.BuyMoney.Value = tb_BuyShare;
tbp.SumMoney.Value = tb_hide_SumMoney;
tbp.AssureMoney.Value = tb_hide_AssureMoney;
tbp.Share.Value = tb_Share;
tbp.BuyShare.Value = tb_BuyShare;
tbp.AssureShare.Value = tb_AssureShare;
tbp.OpenUsers.Value = tb_OpenUserList;
tbp.SecrecyLevel.Value = tbSecrecyLevel;
long Result = tbp.Insert();
if (Result < 0)
{
new Log("System").Write("T_AlipayBuyTemp 数据库读写错误。");
}
Shove._Web.JavaScript.Alert(this.Page, "您的账户余额不足，请先充值，谢谢。", "../Home/Room/OnlinePay/Default.aspx?BuyID=" + Result.ToString());
}
private void BindData()
{
long SiteID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("SiteID"), -1);
long UserID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("id"), -1);
if ((SiteID < 1) || (UserID < 1))
{
this.Response.Redirect("Users.aspx", true);
return;
}
DataTable dt = new DAL.Views.V_Users().Open("", "SiteID = " + SiteID.ToString() + " and [ID] = " + UserID.ToString(), "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_UserDetail");
return;
}
if (dt.Rows.Count < 1)
{
PF.GoError(ErrorNumber.Unknow, "用户不存在", "Admin_UserDetail");
return;
}
tbSiteID.Text = SiteID.ToString();
tbUserID.Text = UserID.ToString();
Users tu = new Users(SiteID)[SiteID, UserID];
if (tu.ID < 1)
{
PF.GoError(ErrorNumber.Unknow, "用户不存在", "Admin_UserDetail");
return;
}
tbUserName.Text = tu.Name;
tbUserEmail.Text = tu.Email;
if (tu.UserType == 1)
{
rbUserType1.Checked = true;
}
else if (tu.UserType == 2)
{
rbUserType2.Checked = true;
}
else if (tu.UserType == 3)
{
rbUserType3.Checked = true;
}
tbUserRealityName.Text = tu.RealityName;
tbUserIDCardNumber.Text = Shove._Convert.ToDBC(tu.IDCardNumber);
ddlUserCity.City_id = tu.CityID;
tbUserTelephone.Text = Shove._Convert.ToDBC(tu.Telephone);
tbUserMobile.Text = Shove._Convert.ToDBC(tu.Mobile);
cbUserMobileValid.Checked = (tu.isMobileValided && (tu.Mobile != ""));
tbUserEmail.Text = tu.Email;
tbUserQQ.Text = Shove._Convert.ToDBC(tu.QQ);
tbUserAddress.Text = tu.Address;
if (tu.Sex == "男")
{
rbUserSexM.Checked = true;
}
else if (tu.Sex == "女")
{
rbUserSexW.Checked = true;
}
tbUserBirthDay.Text = tu.BirthDay.ToShortDateString();
tbUserBankCardNumber.Text = Shove._Convert.ToDBC(tu.BankCardNumber).Trim();
tbScoringOfSelfBuy.Text = tu.ScoringOfSelfBuy.ToString();
tbScoringOfCommendBuy.Text = tu.ScoringOfCommendBuy.ToString();
cbPrivacy.Checked = tu.isPrivacy;
cbisCanLogin.Checked = tu.isCanLogin;
string bankTypeName = "";
string bankName = "";
string bankCardNumber = "";
string bankInProvinceName = "";
string bankInCityName = "";
string bankUserName = "";
int returnValue = -1;
string returnDescription = "";
if (DAL.Procedures.P_GetUserBankDetail(SiteID, UserID, ref bankTypeName, ref bankName, ref bankCardNumber, ref bankInProvinceName, ref bankInCityName, ref bankUserName, ref returnValue, ref returnDescription) < 0)
{
Shove._Web.JavaScript.Alert(this.Page, returnDescription);
return;
}
tbUserCradName.Text = bankUserName;
tbUserBankCardNumber.Text = bankCardNumber;
hfBankInProvince.Value = bankInProvinceName;
hfBankInCity.Value = bankInCityName;
hfBankTypeName.Value = bankTypeName;
hfBankName.Value = bankName;
btnResetPassword.Enabled = (_User.Competences.IsOwnedCompetences(Competences.Administrator));
}
private void BindData()
{
string Key = "Admin_ChaseList_BindData_" + ddlType.SelectedValue == "1" ? tbID.Text : ddlIsuses.SelectedValue;
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
if (dt == null)
{
StringBuilder sb = new StringBuilder();
sb.Append("select ChaseTaskID, QuashStatus, Executed, SUM(Num) as Num, SUM(Money) as Money into #TempT_ChaseTaskDetails from (select 1 as Num, * from T_ChaseTaskDetails) as a group by ChaseTaskID, QuashStatus, Executed ");
sb.Append(@"select '我的追号' as Type, tc.ID, tu.Name, tc.DateTime, tl.Name as LotteryName, tc.Title, a.SumMoney, a.SumIsuseNum, a.BuyedIsuseNum, a.QuashedIsuseNum, tc.QuashStatus,2 as StopType, tc.StopWhenWinMoney from T_ChaseTasks tc inner join (
select ID,
isnull(sum(isnull(SumMoney, 0)), 0) as SumMoney,
isnull(sum(isnull(SumIsuseNum, 0)), 0) as SumIsuseNum,
isnull(sum(isnull(BuyedIsuseNum, 0)), 0) as BuyedIsuseNum,
isnull(sum(isnull(QuashedIsuseNum, 0)), 0) as QuashedIsuseNum
from (
select ChaseTaskID as ID, isnull(sum(isnull([Money], 0)), 0) as SumMoney, sum(isnull(Num, 0)) as SumIsuseNum, 0 as BuyedIsuseNum, 0 as QuashedIsuseNum from #TempT_ChaseTaskDetails group by ChaseTaskID
union all
select ChaseTaskID as ID, 0 as SumMoney, 0 as SumIsuseNum, sum(isnull(Num, 0)) as BuyedIsuseNum, 0 as QuashedIsuseNum from #TempT_ChaseTaskDetails where Executed = 1 and QuashStatus = 0 group by ChaseTaskID
union all
select ChaseTaskID as ID, 0 as SumMoney, 0 as SumIsuseNum, 0 as BuyedIsuseNum, sum(isnull(Num, 0)) as QuashedIsuseNum from #TempT_ChaseTaskDetails where QuashStatus <> 0 group by ChaseTaskID
) a group by ID) a
on tc.ID = a.ID
left join T_Users tu on tc.UserID = tu.ID
left join T_Lotteries tl on tc.LotteryID = tl.ID ");
if (ddlType.SelectedValue == "1")
{
sb.Append("where UserID=" + Shove._Web.Utility.FilteSqlInfusion(tbID.Text.Trim()) + " ");
}
else
{
sb.Append("where ID in(select ChaseTaskID from T_ChaseTaskDetails where IsuseID = " + ddlIsuses.SelectedValue + ") ");
}
sb.Append(" union select '追号套餐' as Type,a.ID,d.Name,DateTime,b.Name,Title,IsuseCount*Multiple*Nums*Price as SumMoney,IsuseCount,ExecutedCount,")
.Append(" IsuseCount-ExecutedCount as NoExecutedCount,QuashStatus,StopTypeWhenWin,StopTypeWhenWinMoney from T_Chases a inner join T_Lotteries b ")
.Append(" on a.LotteryID = b.ID ");
if (ddlType.SelectedValue == "1")
{
sb.Append("and UserID=" + Shove._Web.Utility.FilteSqlInfusion(tbID.Text.Trim()) + " ");
}
else
{
sb.Append("and (a.ID in (select ChaseID from T_ExecutedChases where SchemeID in(select ID from T_Schemes where IsuseID = " + ddlIsuses.SelectedValue + ")) ");
if (new DAL.Tables.T_Isuses().GetCount("ID=" + ddlIsuses.SelectedValue + " and getdate() between StartTime and EndTime") > 0)
{
sb.Append("or a.ID in (select ChaseID from T_ExecutedChases where QuashStatus = 0 and Money > 0 and LotteryID=" + ddlLottery.SelectedValue + "))");
}
else
{
sb.Append(")");
}
}
sb.Append("left join T_Users d on a.UserID = d.ID ");
sb.Append(" left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
sb.Append(" drop table #TempT_ChaseTaskDetails ");
dt = Shove.Database.MSSQL.Select(sb.ToString());
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_ChaseList");
return;
}
Shove._Web.Cache.SetCache(Key, dt);
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
long num = _Convert.StrToLong(this.HidLotteryID.Value, 0L);
long num2 = _Convert.StrToLong(Utility.FilteSqlInfusion(this.HidIsuseID.Value), 0L);
string str = this.HidSearch.Value;
string str2 = this.HidSort.Value;
int num3 = _Convert.StrToInt(this.HidFilter.Value, 7);
int num4 = _Convert.StrToInt(this.HidPageNumber.Value, 1);
this.HidSortID.Value = this.HidSortID.Value;
string key = "Home_Room_SchemeAll_BindData" + num2.ToString();
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
if (cacheAsDataTable == null)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("select a.ID,b.Name as InitiateName,AtTopStatus,b.Level,Money, c.Name as PlayTypeName, Share, BuyedShare, Schedule, AssureMoney, ").AppendLine("\tInitiateUserID, QuashStatus, PlayTypeID, Buyed, SecrecyLevel, EndTime, d.IsOpened, LotteryNumber,case Schedule when 100 then 1 else 0 end as IsFull ").AppendLine("from").AppendLine("\t(").AppendLine("\t\tselect ID, EndTime,IsOpened from T_Isuses where ID = @ID ").AppendLine("\t) as d").AppendLine("inner join T_Schemes a on a.IsuseID = d.ID").AppendLine("inner join T_Users b on a.InitiateUserID = b.ID").AppendLine("inner join T_PlayTypes c on a.PlayTypeID = c.ID").AppendLine("order by a.QuashStatus asc,IsFull asc, a.AtTopStatus desc, a.[Money] desc");
cacheAsDataTable = MSSQL.Select(builder.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("ID", SqlDbType.BigInt, 0, ParameterDirection.Input, num2.ToString()) });
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().FullName);
return;
}
if (num == 1L)
{
DataTable table2 = cacheAsDataTable.Clone();
DataRow[] rowArray = null;
if (this.HidNumber.Value == "9")
{
rowArray = cacheAsDataTable.Select("PlayTypeID in (103,104)", "QuashStatus asc,IsFull asc, AtTopStatus desc, [Money] desc");
}
else
{
rowArray = cacheAsDataTable.Select("PlayTypeID in (101,102)", "QuashStatus asc,IsFull asc, AtTopStatus desc, [Money] desc");
}
foreach (DataRow row in rowArray)
{
table2.Rows.Add(row.ItemArray);
}
cacheAsDataTable = table2;
}
DataTable table3 = new DataTable();
DataColumn[] columns = new DataColumn[cacheAsDataTable.Columns.Count];
for (int k = 0; k < columns.Length; k++)
{
columns[k] = new DataColumn(cacheAsDataTable.Columns[k].ColumnName, typeof(string));
}
table3.Columns.AddRange(columns);
table3.Columns["Money"].DataType = Type.GetType("System.Double");
table3.Columns["Share"].DataType = Type.GetType("System.Int32");
table3.Columns["Schedule"].DataType = Type.GetType("System.Double");
foreach (DataRow row2 in cacheAsDataTable.Rows)
{
table3.Rows.Add(row2.ItemArray);
}
table3.Columns.Add("TmpID", Type.GetType("System.Int32"));
table3.Columns.Add("EachMoney", typeof(string));
table3.Columns.Add("Color", typeof(string));
table3.Columns.Add("State", typeof(string));
table3.Columns.Add("Join", typeof(string));
for (int m = 0; m < cacheAsDataTable.Rows.Count; m++)
{
table3.Rows[m]["EachMoney"] = (_Convert.StrToDouble(cacheAsDataTable.Rows[m]["Money"].ToString(), 0.0) / _Convert.StrToDouble(cacheAsDataTable.Rows[m]["Share"].ToString(), 0.0)).ToString("N");
table3.Rows[m]["Money"] = _Convert.StrToDouble(cacheAsDataTable.Rows[m]["Money"].ToString(), 0.0).ToString("N");
table3.Rows[m]["Color"] = ((m % 2) > 0) ? "#F7FEFA" : "White";
string str4 = cacheAsDataTable.Rows[m]["InitiateName"].ToString();
if (str4.Length > 10)
{
str4 = str4.Substring(0, 10);
}
if (_Convert.StrToDouble(cacheAsDataTable.Rows[m]["AssureMoney"].ToString(), 0.0) > 0.0)
{
str4 = str4 + "<font color='#FF0065'>(保)</font>";
}
int num11 = _Convert.StrToInt(cacheAsDataTable.Rows[m]["Level"].ToString(), 0);
if (num11 > 5)
{
num11 = 5;
}
table3.Rows[m]["InitiateName"] = "<a style='cursor:hand' href='../Web/Score.aspx?id=" + cacheAsDataTable.Rows[m]["InitiateUserID"].ToString() + "&LotteryID=" + this.HidLotteryID.Value + "' title='点击查看历史战绩' target='_blank'>" + str4 + "</a>";
if (num11 > 0)
{
string[] strArray2 = new string[] { "<a style='cursor:hand' href='../Web/Score.aspx?id=", cacheAsDataTable.Rows[m]["InitiateUserID"].ToString(), "&LotteryID=", this.HidLotteryID.Value, "' title='点击查看历史战绩' target='_blank'> <div style='background-image:url(Images/gold.gif); width:", (9 * num11).ToString(), "px;background-repeat:repeat-x;'></div></a>" };
table3.Rows[m]["Level"] = string.Concat(strArray2);
}
else
{
table3.Rows[m]["Level"] = " ";
}
string str5 = table3.Rows[m]["ID"].ToString();
string str6 = table3.Rows[m]["LotteryNumber"].ToString().Trim();
short num13 = _Convert.StrToShort(table3.Rows[m]["QuashStatus"].ToString(), 0);
bool flag = _Convert.StrToBool(table3.Rows[m]["Buyed"].ToString(), false);
short num14 = _Convert.StrToShort(table3.Rows[m]["SecrecyLevel"].ToString(), 0);
bool flag2 = _Convert.StrToDateTime(table3.Rows[m]["EndTime"].ToString(), DateTime.Now.ToString()) <= DateTime.Now;
bool flag3 = _Convert.StrToBool(table3.Rows[m]["IsOpened"].ToString(), false);
long num15 = _Convert.StrToLong(table3.Rows[m]["InitiateUserID"].ToString(), 0L);
if (((num14 == 1) && !flag2) && ((base._User == null) || (((base._User != null) && (num15 != base._User.ID)) && !base._User.isOwnedViewSchemeCompetence())))
{
table3.Rows[m]["LotteryNumber"] = "已保密，截止后公开";
}
else if (((num14 == 2) && !flag3) && ((base._User == null) || (((base._User != null) && (num15 != base._User.ID)) && !base._User.isOwnedViewSchemeCompetence())))
{
table3.Rows[m]["LotteryNumber"] = "已保密，开奖后公开";
}
else if ((num14 == 3) && ((base._User == null) || (((base._User != null) && (num15 != base._User.ID)) && !base._User.isOwnedViewSchemeCompetence())))
{
table3.Rows[m]["LotteryNumber"] = "已保密";
}
else if (str6.Length > 0x1c)
{
table3.Rows[m]["LotteryNumber"] = "<a href='Scheme.aspx?id=" + str5.ToString() + "' target='_blank' title='点击查看方案详细信息'><font color=\"#FF0065\">投注内容</font></a>";
}
else if ((((num == 1L) || (num == 2L)) || (num == 15L)) && (str6 == ""))
{
table3.Rows[m]["LotteryNumber"] = "<a href='Scheme.aspx?id=" + str5.ToString() + "' target='_blank'><font color=\"#FF0065\">未上传方案</font></a>";
}
else
{
table3.Rows[m]["LotteryNumber"] = "<a href='Scheme.aspx?id=" + str5.ToString() + "' target='_blank' title='点击查看方案详细信息'>" + str6 + "</a>";
}
switch (num13)
{
case 0:
goto Label_0A63;
case 2:
table3.Rows[m]["State"] = "<font color='blue'>撤单</font>";
break;
default:
table3.Rows[m]["State"] = "撤单";
break;
}
table3.Rows[m]["Join"] = "<Font color='#000000'>--</font>";
continue;
Label_0A63:
if (flag)
{
table3.Rows[m]["State"] = "<Font color='#FF0065'>已成功</font>";
table3.Rows[m]["Join"] = "<Font color='#000000'>--</font>";
}
else if (table3.Rows[m]["Schedule"].ToString() == "100")
{
table3.Rows[m]["State"] = "<Font color='#FF0065'>满员</font>";
table3.Rows[m]["Join"] = "<Font color='#000000'>--</font>";
}
else if (flag2)
{
table3.Rows[m]["State"] = "未成功";
table3.Rows[m]["Join"] = "<Font color='#000000'>--</font>";
}
else
{
table3.Rows[m]["State"] = "未满";
table3.Rows[m]["Join"] = "<a href='Scheme.aspx?id=" + str5.ToString() + "' target='_blank' title='点击查看方案详细信息'><font color=\"#FF0065\">入伙</font></a>";
}
}
cacheAsDataTable = table3;
Shove._Web.Cache.SetCache(key, cacheAsDataTable, ((this.HidLotteryID.Value == "29") || (this.HidLotteryID.Value == "62")) ? 60 : 600);
}
DataRow[] rowArray3 = null;
if ((str != "") && (str != "输入用户名"))
{
rowArray3 = cacheAsDataTable.Select("InitiateName like '%" + Utility.FilteSqlInfusion(this.TxtName.Text.Trim()) + "%'");
}
switch (num3)
{
case 1:
rowArray3 = cacheAsDataTable.Select("Convert([Money],System.Double) >= 1000");
break;
case 2:
rowArray3 = cacheAsDataTable.Select("Convert([Money],System.Double) < 1000");
break;
case 3:
rowArray3 = cacheAsDataTable.Select("Convert(Share,System.Int32) >= BuyedShare");
break;
case 4:
rowArray3 = cacheAsDataTable.Select("Convert(Share,System.Int32) > BuyedShare");
break;
case 5:
rowArray3 = cacheAsDataTable.Select("Convert(QuashStatus,System.Int32) <> 0");
break;
case 6:
rowArray3 = cacheAsDataTable.Select("Convert(AssureMoney,System.Double) > 0");
break;
}
if (str2 != "")
{
rowArray3 = cacheAsDataTable.Select("", str2 + " " + this.HidOrder.Value);
}
if (rowArray3 != null)
{
cacheAsDataTable = cacheAsDataTable.Clone();
foreach (DataRow row3 in rowArray3)
{
cacheAsDataTable.Rows.Add(row3.ItemArray);
}
}
int count = cacheAsDataTable.Rows.Count;
for (int i = 0; i < count; i++)
{
cacheAsDataTable.Rows[i]["TmpID"] = i + 1;
}
int num20 = 20;
int num21 = cacheAsDataTable.Rows.Count;
int num22 = ((num21 % num20) == 0) ? (num21 / num20) : ((num21 / num20) + 1);
if (num4 > num22)
{
num4 = num22;
}
int num23 = 10;
int num24 = ((num4 % num23) == 0) ? ((num23 * ((num4 / num23) - 1)) + 1) : ((num23 * (num4 / num23)) + 1);
int num25 = (((num24 / num23) + 1) == 1) ? 1 : ((num23 * ((num24 / num23) - 1)) + 1);
int num26 = (num22 > (num23 * ((num4 / num23) + 2))) ? ((num23 * ((num4 / num23) + 1)) + 1) : num22;
if ((num24 + num23) > num22)
{
num24 = (num22 - num23) + 1;
}
if (num24 <= 0)
{
num24 = 1;
}
DataRow[] rowArray5 = cacheAsDataTable.Select("TmpID > " + ((num20 * (num4 - 1))).ToString() + " and TmpID < " + (((num20 * num4) + 1)).ToString());
DataTable table4 = cacheAsDataTable.Clone();
foreach (DataRow row4 in rowArray5)
{
table4.Rows.Add(row4.ItemArray);
}
this.rptSchemes.DataSource = table4;
this.rptSchemes.DataBind();
StringBuilder builder2 = new StringBuilder();
builder2.Append("<tr>").Append("<td width='31%' height='36' align='left' class='black12'>").Append("第<span class='red'>").Append(num4.ToString()).Append("/").Append(num22.ToString()).Append("</span>页 <span class='red'>").Append(num20.ToString()).Append("</span>条/页 共<span class='red'>").Append(num21.ToString()).Append("</span>条").Append("</td>").Append("<td width='69%' align='right'>").Append("<table border='0' cellspacing='4' cellpadding='0'>").Append("<tbody style='text-align:center; width:20px;'>").Append("<tr>").Append("<td valign='middle' class='ball' onclick='showPage(1);'>").Append("<img src='images/page_first.gif' width='9' height='8' />").Append("</td>").Append("<td class='ball' onclick='showPage(").Append(num25.ToString()).Append(");'>").Append("<img src='images/page_previous.gif' width='9' height='8' />");
for (int j = num24; (j < (num24 + num23)) && (j <= num22); j++)
{
builder2.Append("</td>").Append("<td id='page_").Append(j.ToString()).Append("' class='ball").Append((num4 == j) ? "_r" : ((j <= num22) ? "" : "_c")).Append("'");
if (j <= num22)
{
builder2.Append(" onclick='showPage(").Append(j.ToString()).Append(");'");
}
builder2.Append(">").Append(j.ToString()).Append("</td>");
}
builder2.Append("<td class='ball' onclick='showPage(").Append(num26.ToString()).Append(");'>").Append("<img src='images/page_3.gif' width='9' height='8' />").Append("</td>").Append("<td class='ball' onclick='showPage(").Append(num22.ToString()).Append(");'>").Append("<img src='images/page_4.gif' width='9' height='8' />").Append("</td>").Append("<td >").Append("<input type='text' class='ball_50' id='txtgopage' maxlength='").Append(num22.ToString().Length.ToString()).Append("' />").Append("</td>").Append("<td style='width:25px; height=5; font-family:tahoma;font-weight:bold; color:#FFFFFF; cursor:hand; background:#6B96CB;font-size: 13px;' onclick=\"showPage(document.getElementById('txtgopage').value);\">").Append("GO").Append("</td>").Append("</tr>").Append("</tbody>").Append("</table>").Append("</td>").Append("</tr>");
this.tbPaging.InnerHtml = builder2.ToString();
}
/// <summary>
/// 购买彩票
/// </summary>
/// <param name="_User"></param>
private void Buy(Users _User)
{
string HidIsuseID = this.HidIsuseID.Value;
string HidIsuseEndTime = this.HidIsuseEndTime.Value;
string playType = "501";
string tb_Share = "1";
string tb_BuyShare = "1";
string tb_hide_SumMoney = "2";
string tb_Title = "";
string tb_Description = "";
string tb_Multiple = "1";
string tb_OpenUserList = "";
int Price = 2;
double SumMoney = 0;
int Share = 0;
int BuyShare = 0;
double AssureMoney = 0;
int Multiple = 0;
int SumNum = 1;
short SecrecyLevel = 0;
int PlayTypeID = 0;
int LotteryID = 5;
long IsuseID = 0;
double SchemeBonusScale = double.Parse(new DAL.Tables.T_Sites().Open("Opt_InitiateSchemeBonusScale", "ID=1", "").Rows[0]["Opt_InitiateSchemeBonusScale"].ToString());
try
{
SumMoney = double.Parse(tb_hide_SumMoney);
Share = int.Parse(tb_Share);
BuyShare = int.Parse(tb_BuyShare);
Multiple = int.Parse(tb_Multiple);
PlayTypeID = int.Parse(playType);
IsuseID = long.Parse(HidIsuseID);
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
string LotteryNumber = tb_LotteryNumber.Value + "\r";
if (LotteryNumber[LotteryNumber.Length - 1] == '\n')
{
LotteryNumber = LotteryNumber.Substring(0, LotteryNumber.Length - 1);
}
#region 对彩票号码进行分析，判断注数
SZJS.Lottery slsLottery = new SZJS.Lottery();
string[] t_lotterys = SplitLotteryNumber(LotteryNumber);
if ((t_lotterys == null) || (t_lotterys.Length < 1))
{
Shove._Web.JavaScript.Alert(this.Page, "选号发生异常，请重新选择号码投注，谢谢。(-694)");
return;
}
int ValidNum = 0;
foreach (string str in t_lotterys)
{
string Number = slsLottery[LotteryID].AnalyseScheme(str, PlayTypeID);
if (string.IsNullOrEmpty(Number))
{
continue;
}
string[] str_s = Number.Split('|');
if (str_s == null || str_s.Length < 1)
{
continue;
}
ValidNum += Shove._Convert.StrToInt(str_s[str_s.Length - 1], 0);
}
//解析的号码和选择的号码要一致
if (ValidNum != SumNum)
{
Shove._Web.JavaScript.Alert(this.Page, "选号发生异常，请重新选择号码投注，谢谢。");
return;
}
#endregion
string ReturnDescription = "";
if (DateTime.Now >= Shove._Convert.StrToDateTime(HidIsuseEndTime.Replace("/", "-"), DateTime.Now.AddDays(-1).ToString()))
{
Shove._Web.JavaScript.Alert(this.Page, "本期投注已截止，谢谢。");
return;
}
if (Price * SumNum * Multiple != SumMoney)
{
Shove._Web.JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
long SchemeID = _User.InitiateScheme(IsuseID, PlayTypeID, tb_Title.Trim() == "" ? "(无标题)" : tb_Title.Trim(), tb_Description.Trim(), LotteryNumber, "", Multiple, SumMoney, AssureMoney, Share, BuyShare, tb_OpenUserList, short.Parse(SecrecyLevel.ToString()), SchemeBonusScale, ref ReturnDescription);
if (SchemeID < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().FullName + "(-755)");
return;
}
Shove._Web.Cache.ClearCache("Home_Room_CoBuy_BindDataForType" + IsuseID.ToString());
Shove._Web.Cache.ClearCache("Home_Room_SchemeAll_BindData" + IsuseID.ToString());
if (SumMoney > 50 && Share > 1)
{
Shove._Web.Cache.ClearCache("Home_Room_JoinAllBuy_BindData");
}
Response.Redirect("Home/Room/UserBuySuccess.aspx?LotteryID=" + LotteryID.ToString() + "&&Money=2&SchemeID=" + SchemeID.ToString() + "");
return;
}
private void Buy(Users _User)
{
string request = Shove._Web.Utility.GetRequest("HidIsuseID");
string str2 = Shove._Web.Utility.GetRequest("HidIsuseEndTime");
string s = Shove._Web.Utility.GetRequest("tbPlayTypeID");
string str4 = Shove._Web.Utility.GetRequest("Chase");
Shove._Web.Utility.GetRequest("CoBuy");
string str5 = Shove._Web.Utility.GetRequest("tb_Share");
string str6 = Shove._Web.Utility.GetRequest("tb_BuyShare");
Shove._Web.Utility.GetRequest("tb_AssureShare");
string str7 = Shove._Web.Utility.GetRequest("tb_OpenUserList");
string str8 = Shove._Web.Utility.GetRequest("tb_Title");
string str9 = Shove._Web.Utility.GetRequest("tb_Description");
string str10 = Shove._Web.Utility.GetRequest("tbAutoStopAtWinMoney");
string str11 = Shove._Web.Utility.GetRequest("SecrecyLevel");
string str12 = Shove._Web.Utility.FilteSqlInfusion(base.Request["tb_LotteryNumber"]);
string str13 = Shove._Web.Utility.GetRequest("tb_hide_SumMoney");
string str14 = Shove._Web.Utility.GetRequest("tb_hide_AssureMoney");
string str15 = Shove._Web.Utility.GetRequest("tb_hide_SumNum");
Shove._Web.Utility.GetRequest("HidIsuseCount");
string str16 = Shove._Web.Utility.GetRequest("HidLotteryID");
Shove._Web.Utility.GetRequest("HidIsAlipay");
string str17 = Shove._Web.Utility.GetRequest("tb_Multiple");
Shove._Web.Utility.GetRequest("HidIsuseName");
Shove._Web.Utility.GetRequest("tbPlayTypeName");
string str18 = Shove._Web.Utility.GetRequest("tb_hide_ChaseBuyedMoney");
string str19 = Shove._Web.Utility.GetRequest("tb_SchemeBonusScale");
string str20 = Shove._Web.Utility.GetRequest("tb_SchemeBonusScalec");
int num = 2;
if (str17 == "")
{
str17 = "1";
}
double money = 0.0;
int share = 0;
int buyShare = 0;
double assureMoney = 0.0;
int multiple = 0;
int num7 = 0;
short num8 = 0;
int playType = 0;
int lotteryID = 0;
long isuseID = 0L;
double stopWhenWinMoney = 0.0;
double schemeBonusScale = 0.0;
double schemeBonusScalec = 0.0;
try
{
money = double.Parse(str13);
share = int.Parse(str5);
buyShare = int.Parse(str6);
assureMoney = double.Parse(str14);
multiple = int.Parse(str17);
num7 = int.Parse(str15);
num8 = short.Parse(str11);
playType = int.Parse(s);
lotteryID = int.Parse(str16);
isuseID = long.Parse(request);
stopWhenWinMoney = double.Parse(str10);
schemeBonusScale = double.Parse(str19);
schemeBonusScalec = double.Parse(str20);
}
catch
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
if ((money > 0.0) && (num7 >= 1))
{
if (assureMoney < 0.0)
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
}
else if (share < 1)
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
}
else
{
if ((buyShare == share) && (assureMoney == 0.0))
{
share = 1;
buyShare = 1;
}
if ((money / ((double)share)) < 1.0)
{
JavaScript.Alert(this.Page, "每份金额最低不能少于 1 元。");
}
else
{
double num15 = (buyShare * (money / ((double)share))) + assureMoney;
if (str4 != "")
{
num15 = double.Parse(str18);
}
if (num15 > _User.Balance)
{
this.SaveDataForAliBuy();
}
else if (num15 > 10000000.0)
{
JavaScript.Alert(this.Page, "投注金额不能大于" + 0x989680.ToString() + "，谢谢。");
}
else if (multiple > 0x3e7)
{
JavaScript.Alert(this.Page, "投注倍数不能大于 999 倍，谢谢。");
}
else if ((schemeBonusScale < 0.0) && (schemeBonusScale > 10.0))
{
JavaScript.Alert(this.Page, "佣金比例只能在0~10之间");
}
else if ((schemeBonusScale.ToString().IndexOf("-") > -1) || (schemeBonusScale.ToString().IndexOf(".") > -1))
{
JavaScript.Alert(this.Page, "佣金比例输入有误");
}
else if ((schemeBonusScalec < 0.0) && (schemeBonusScalec > 10.0))
{
JavaScript.Alert(this.Page, "佣金比例只能在0~10之间");
}
else if ((schemeBonusScalec.ToString().IndexOf("-") > -1) || (schemeBonusScalec.ToString().IndexOf(".") > -1))
{
JavaScript.Alert(this.Page, "佣金比例输入有误");
}
else
{
schemeBonusScale /= 100.0;
schemeBonusScalec /= 100.0;
string number = str12;
if (number[number.Length - 1] == '\n')
{
number = number.Substring(0, number.Length - 1);
}
SLS.Lottery lottery = new SLS.Lottery();
string[] strArray = this.SplitLotteryNumber(number);
if ((strArray == null) || (strArray.Length < 1))
{
JavaScript.Alert(this.Page, "选号发生异常，请重新选择号码投注，谢谢。(-694)");
}
else
{
int num17 = 0;
foreach (string str22 in strArray)
{
string str23 = lottery[lotteryID].AnalyseScheme(str22, playType);
if (!string.IsNullOrEmpty(str23))
{
string[] strArray3 = str23.Split(new char[] { '|' });
if ((strArray3 != null) && (strArray3.Length >= 1))
{
num17 += _Convert.StrToInt(strArray3[strArray3.Length - 1], 0);
}
}
}
if (num17 != num7)
{
JavaScript.Alert(this.Page, "选号发生异常，请重新选择号码投注，谢谢。");
}
else
{
StringBuilder builder = new StringBuilder();
int num19 = 0;
string detailXML = "";
string returnDescription = "";
if (str4 == "1")
{
foreach (string str26 in base.Request.Form.AllKeys)
{
if (str26.IndexOf("check") > -1)
{
int num20 = _Convert.StrToInt(str26.Replace("check", ""), -1);
if (num20 > 0)
{
num19++;
int num21 = (_Convert.StrToInt(base.Request.Form["tb_hide_SumNum"], -1) * num) * _Convert.StrToInt(base.Request.Form["times" + num20.ToString()], -1);
builder.Append(base.Request.Form[str26]).Append(",").Append(base.Request.Form["times" + num20.ToString()]).Append(",").Append(num21.ToString()).Append(";");
}
}
}
if (builder.Length > 0)
{
builder.Remove(builder.Length - 1, 1);
}
if (number[number.Length - 1] == '\n')
{
number = number.Substring(0, number.Length - 1);
}
try
{
money = double.Parse(str13);
}
catch
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。(-1325)");
return;
}
if (money < 2.0)
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。(-1332)");
}
else
{
string[] strArray5 = builder.ToString().Split(new char[] { ';' });
int length = strArray5.Length;
string[] str = new string[length * 6];
DateTime time2 = DateTime.Parse(Functions.F_GetIsuseSystemEndTime(long.Parse(strArray5[0].Split(new char[] { ',' })[0]), playType).ToString());
if (DateTime.Now >= time2)
{
JavaScript.Alert(this.Page, "您选择的追号期号中包含已截止的期，请重新选择。");
}
else
{
for (int i = 0; i < length; i++)
{
str[i * 6] = strArray5[i].Split(new char[] { ',' })[0];
str[(i * 6) + 1] = playType.ToString();
str[(i * 6) + 2] = number;
str[(i * 6) + 3] = strArray5[i].Split(new char[] { ',' })[1];
str[(i * 6) + 4] = strArray5[i].Split(new char[] { ',' })[2];
str[(i * 6) + 5] = num8.ToString();
if ((_Convert.StrToDouble(str[(i * 6) + 3], 0.0) * money) != _Convert.StrToDouble(str[(i * 6) + 4], 1.0))
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
return;
}
if (_Convert.StrToDouble(str[(i * 6) + 3], 0.0) < multiple)
{
JavaScript.Alert(this.Page, "追号倍数有错误，请仔细检查！");
return;
}
if (((double.Parse(str[(i * 6) + 3]) * num7) * num) != double.Parse(str[(i * 6) + 4]))
{
JavaScript.Alert(this.Page, "追号金额有错误，请仔细检查！可能原因：浏览器不兼容，建议使用IE 7.0");
return;
}
}
detailXML = PF.BuildIsuseAdditionasXmlForChase(str);
if (detailXML == "")
{
JavaScript.Alert(this.Page, "追号发生错误。");
}
else if (_User.InitiateChaseTask(str8.Trim(), str9.Trim(), lotteryID, stopWhenWinMoney, detailXML, number, schemeBonusScalec, ref returnDescription) < 0)
{
PF.GoError(1, returnDescription, base.GetType().FullName + "(-754)");
}
else
{
Shove._Web.Cache.ClearCache("Home_Room_CoBuy_BindDataForType" + isuseID.ToString());
Shove._Web.Cache.ClearCache("Home_Room_SchemeAll_BindData" + isuseID.ToString());
Shove._Web.Cache.ClearCache(base._Site.ID.ToString() + "AccountFreezeDetail_" + _User.ID.ToString());
base.Response.Redirect("../Home/Room/UserBuySuccess.aspx?LotteryID=" + lotteryID.ToString() + "&Type=2&Money=" + num15.ToString());
}
}
}
}
else if (DateTime.Now >= _Convert.StrToDateTime(str2.Replace("/", "-"), DateTime.Now.AddDays(-1.0).ToString()))
{
JavaScript.Alert(this.Page, "本期投注已截止，谢谢。");
}
else if (((num * num7) * multiple) != money)
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
}
else
{
long num25 = _User.InitiateScheme(isuseID, playType, (str8.Trim() == "") ? "(无标题)" : str8.Trim(), str9.Trim(), number, "", multiple, money, assureMoney, share, buyShare, str7.Trim(), short.Parse(num8.ToString()), schemeBonusScale, ref returnDescription);
if (num25 < 0L)
{
PF.GoError(1, returnDescription, base.GetType().FullName + "(-755)");
}
else
{
Shove._Web.Cache.ClearCache("Home_Room_CoBuy_BindDataForType" + isuseID.ToString());
Shove._Web.Cache.ClearCache("Home_Room_SchemeAll_BindData" + isuseID.ToString());
if ((money > 50.0) && (share > 1))
{
Shove._Web.Cache.ClearCache("Home_Room_JoinAllBuy_BindData");
}
base.Response.Redirect("../Home/Room/UserBuySuccess.aspx?LotteryID=" + lotteryID.ToString() + "&&Money=" + num15.ToString() + "&SchemeID=" + num25.ToString());
}
}
}
}
}
}
}
}
else
{
JavaScript.Alert(this.Page, "输入有错误，请仔细检查。");
}
}
public long Query(string Account, ref string RealityName)
{
SystemOptions options = new SystemOptions();
string gateway = options["MemberRegister_Alipay_Gateway"].ToString("");
string service = "user_query";
string partner = options["MemberRegister_Alipay_UserNumber"].ToString("");
string key = options["MemberRegister_Alipay_MD5"].ToString("");
string charset = "utf-8";
string str6 = "MD5";
if (((gateway == "") || (partner == "")) || (key == ""))
{
return(-1L);
}
Utility ul = new Gateway.Utility();
string url = ul.Createurl(gateway, service, partner, key, str6, charset, new string[] { "email", Account });
string str8 = "";
try
{
str8 = PF.GetHtml(url, "utf-8", 20);
}
catch
{
return(-2L);
}
if (string.IsNullOrEmpty(str8))
{
return(-3L);
}
XmlDocument document = new XmlDocument();
try
{
document.Load(new StringReader(str8));
}
catch
{
return(-4L);
}
XmlNodeList elementsByTagName = document.GetElementsByTagName("is_success");
if ((elementsByTagName == null) || (elementsByTagName.Count < 1))
{
return(-5L);
}
if (elementsByTagName[0].InnerText.ToUpper() != "T")
{
return(-6L);
}
XmlNodeList list2 = document.GetElementsByTagName("user_id");
if ((list2 == null) || (list2.Count < 1))
{
return(-7L);
}
XmlNodeList list3 = document.GetElementsByTagName("real_name");
if ((list3 != null) && (list3.Count >= 1))
{
RealityName = list3[0].InnerText;
}
else
{
RealityName = "";
}
return(_Convert.StrToLong(list2[0].InnerText, -8L));
}
private void BindData()
{
//获取当前查看的CPS ID参数
long commenderID = Shove._Convert.StrToLong(hfCommenderID.Value, -1);
if (commenderID < 1)
{
PF.GoError(ErrorNumber.DataReadWrite, "参数错误", this.GetType().BaseType.FullName);
return;
}
//处理日期
DateTime fromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);// 默认查询本月明细
DateTime toDate = DateTime.Now;
if (tbBeginTime.Text != "" && tbEndTime.Text != "")
{
fromDate = Shove._Convert.StrToDateTime(tbBeginTime.Text.Trim() + " 0:0:0", DateTime.Now.ToString());
toDate = Shove._Convert.StrToDateTime(tbEndTime.Text.Trim() + " 23:59:59", DateTime.Now.ToString());
}
tbBeginTime.Text = fromDate.ToString("yyyy-MM-dd");
tbEndTime.Text = toDate.ToString("yyyy-MM-dd");
//获取数据
string key = "Cps_Administrator_CpsCommenderBuyDetail_" + commenderID + "_" + tbBeginTime.Text + tbEndTime.Text;
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(key);
if (dt == null)
{
int returnValue = -1;
string returnDescription = "";
DataSet ds = null;
int Result = DAL.Procedures.P_CpsGetCommenderBuyDetailByDate(ref ds, _Site.ID, commenderID, fromDate, toDate, ref returnValue, ref returnDescription);
if (Result < 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
if (returnValue < 0)
{
Shove._Web.JavaScript.Alert(this.Page, returnDescription);
return;
}
if ((ds == null) || (ds.Tables.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
dt = ds.Tables[0];
Shove._Web.Cache.SetCache(key, dt, 100000);
}
PF.DataGridBindData(g, dt, gPager);
}
// checking type of our active pet
public static bool family(PF checkFamily)
{
return MyPets.ActivePet.PetType == (int)checkFamily;
}
