private void SendCharge_Load(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; var data = from dsl in db.WX_UserChangeLog join dsu in db.WX_UserReply on new { dsl.WX_UserName, dsl.aspnet_UserID, dsl.WX_SourceType } equals new { dsu.WX_UserName, dsu.aspnet_UserID, dsu.WX_SourceType } where dsl.aspnet_UserID == GlobalParam.UserKey && dsl.WX_UserName == UserRow.Field <string>("User_ContactID") && dsl.WX_SourceType == UserRow.Field <string>("User_SourceType") select new { UserName = dsu.WX_UserName , dsl.Remark , dsl.RemarkType , dsl.ChangePoint , dsl.ChangeTime , dsl.GamePeriod , SourceType = dsu.WX_SourceType }; BS_TransLog.DataSource = data; }
private void WX_GetReminder() { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; var datasource = from ds in db.WX_UserChangeLog group ds by new { ds.WX_UserName, ds.WX_SourceType, ds.aspnet_UserID } into g join dm in db.WX_UserReply on new { g.Key.aspnet_UserID, g.Key.WX_UserName, g.Key.WX_SourceType } equals new { dm.aspnet_UserID, dm.WX_UserName, dm.WX_SourceType } where g.Key.aspnet_UserID == GlobalParam.UserKey && g.Key.WX_SourceType == cb_wxsourcetype.SelectedItem.ToString() select new { 玩家 = dm.NickName + "(" + dm.RemarkName + ")" , 余 = g.Sum(t => t.ChangePoint) , g.Key.WX_UserName , g.Key.WX_SourceType }; gv_data.DataSource = datasource; }
static void loginf_OnLoginSuccess(string UserName) { loginf.Hide(); #region Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; string ActiveCode = Linq.Util_Services.GetServicesSetting().ActiveCode; DateTime?EndDate = null; bool Success = NetFramework.Util_MD5.MD5Success(ActiveCode, out EndDate, GlobalParam.UserKey); Success = true; EndDate = Convert.ToDateTime("2020-01-01"); if (Success == false) { MessageBox.Show("激活码异常"); Environment.Exit(0); } else { DateTime Now = db.ExecuteQuery <DateTime>("select getdate()").First(); if (Now >= EndDate) { MessageBox.Show("激活码已过期"); UpdateActiveCode uac = new UpdateActiveCode(); uac.ShowDialog(); MessageBox.Show("激活码已保存,重新启动"); Environment.Exit(0); } } #endregion StartForm sf = new StartForm(); if (UserName == "sysadmin") { sf.SetMode("Admin", ""); } else { sf.SetMode("User", ""); } if (GlobalParam.DataSourceName != "Admin" && GlobalParam.DataSourceName != "User") { Linq.aspnet_UsersNewGameResultSend wsr = Linq.Util_Services.GetServicesSetting(); sf.SetMode("EasyRobot", wsr.OpenMode == null ? "" : wsr.OpenMode); } sf.Show(); }
private void Reload() { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; var source = (from ds in db.WX_UserGameLog_Football where ds.HaveOpen == false && ds.WX_SourceType == cb_wxsourcetype.SelectedItem.ToString() && ds.aspnet_UserID == GlobalParam.UserKey select new GameFormat(ds.GameKey, ds.GameVS)).Distinct(); gv_balls.DataSource = source; }
private void BallGames_Load(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; var source = db.Game_FootBall_VS.Where(t => t.aspnet_UserID == GlobalParam.UserKey //&& (t.LastAliveTime == null || t.LastAliveTime >= DateTime.Today.AddDays(-3)) && t.Jobid == GlobalParam.JobID ); // var classsource = (from ds in source //select new { ds.GameType, ds.MatchClass }).Distinct(); bs_gamelist.DataSource = source; }
private void gv_GameList_SelectionChanged(object sender, EventArgs e) { if (gv_GameList.SelectedRows.Count != 0) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; IQueryable <Linq.Game_FootBall_VSRatios> DbRatios = Linq.ProgramLogic.GameVSGetRatios(db, ((Linq.Game_FootBall_VS)gv_GameList.SelectedRows[0].DataBoundItem)); bs_ratios.DataSource = DbRatios; bs_ratiocurrent.DataSource = RatioConvertToGridData((Linq.Game_FootBall_VS)gv_GameList.SelectedRows[0].DataBoundItem, db); bs_ratiocurrent2.DataSource = Linq.ProgramLogic.VSGetCurRatio((Linq.Game_FootBall_VS)gv_GameList.SelectedRows[0].DataBoundItem, db); } }
private void MI_Delete_Click(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; ep_sql.Clear(); DataGridViewRow dr = GV_GameLog.SelectedRows[0]; string aspnet_UserID = dr.Cells["aspnet_UserID"].Value.ToString(); string WX_UserName = dr.Cells["WX_UserName"].Value.ToString(); string WX_SourceType = dr.Cells["WX_SourceType"].Value.ToString(); string ReceiveTime = dr.Cells["ReceiveTime"].Value.ToString(); DateTime?DT = null; try { DT = DateTime.Parse(ReceiveTime); } catch (Exception) { throw; } Linq.WX_UserGameLog testg = db.WX_UserGameLog.SingleOrDefault(t => t.aspnet_UserID == new Guid(aspnet_UserID) && t.WX_UserName == WX_UserName && t.WX_SourceType == WX_SourceType && t.TransTime == DT); if (testg != null && testg.Result_HaveProcess != false) { ep_sql.SetError(GV_GameLog, "已开或已处理,不能删除"); } Linq.WX_UserReplyLog testrg = db.WX_UserReplyLog.SingleOrDefault(t => t.aspnet_UserID == new Guid(aspnet_UserID) && t.WX_UserName == WX_UserName && t.WX_SourceType == WX_SourceType && t.ReceiveTime == DT); if (testg != null) { db.WX_UserGameLog.DeleteOnSubmit(testg); } if (testrg != null) { db.WX_UserReplyLog.DeleteOnSubmit(testrg); } db.SubmitChanges(); MessageBox.Show("删除成功"); SendManulOrder_Load(null, null); }
private void gv_data_SelectionChanged(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; if (gv_data.SelectedRows.Count != 0) { string WX_UserName = gv_data.SelectedRows[0].Cells["WX_UserName"].Value.ToString(); string WX_SourceType = gv_data.SelectedRows[0].Cells["WX_SourceType"].Value.ToString(); var ReplyLog = from ds in db.WX_UserReplyLog join user in db.WX_UserReply on new { ds.aspnet_UserID, ds.WX_UserName, ds.WX_SourceType } equals new { user.aspnet_UserID, user.WX_UserName, user.WX_SourceType } where ds.aspnet_UserID == GlobalParam.UserKey && ds.WX_UserName == WX_UserName && ds.WX_SourceType == WX_SourceType orderby ds.ReceiveTime ascending select new { 玩家 = (ds.SourceType == "微" || ds.SourceType == "易"? user.NickName + "(" + user.RemarkName + ")":"我") , 内容 = ds.ReceiveContent , 时间 = ds.ReceiveTime }; gv_talk.DataSource = ReplyLog; var changepoint = from ds in db.WX_UserChangeLog join user in db.WX_UserReply on new { ds.aspnet_UserID, ds.WX_UserName, ds.WX_SourceType } equals new { user.aspnet_UserID, user.WX_UserName, user.WX_SourceType } where ds.aspnet_UserID == GlobalParam.UserKey && ds.WX_UserName == WX_UserName && ds.WX_SourceType == WX_SourceType orderby ds.ChangeTime ascending select new { 分数变动 = ds.ChangePoint , 时间 = ds.ChangeTime , 期号 = ds.GamePeriod , 类型 = ds.RemarkType , 注 = ds.BuyValue }; gv_changepoint.DataSource = changepoint; } }
private void Dtp_DownloadDate_ValueChanged(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; BS_GameResult.DataSource = db.Game_Result .Where(t => t.aspnet_UserID == GlobalParam.UserKey && t.GameTime.Value.Date == Dtp_DownloadDate.Value.Date) .Select(t => new { Gr_GamePeriod = t.GamePeriod, Gr_GameTime = (DateTime?)t.GameTime, Gr_GameResult = t.GameResult, Gr_NumTotal = t.NumTotal, Gr_BigSmall = t.BigSmall, Gr_SingleDouble = t.SingleDouble, Gr_DragonTiger = t.DragonTiger, Gr_GamePrivatePeriod = t.GamePrivatePeriod, Gr_Mode = t.GameName }).ToList(); var GameLog = (from ds in db.WX_UserGameLog where (ds.aspnet_UserID == GlobalParam.UserKey) && ( (ds.Result_HaveProcess == false || ds.Result_HaveProcess == null) ) select new GameLogClass ( ds.WX_UserName, ds.WX_UserName, (DateTime?)ds.TransTime, ds.GamePeriod, ds.Buy_Value, ds.Buy_Point , ds.GameLocalPeriod , ds.WX_SourceType , ds.OpenMode ) ).ToList(); BS_GameLogNotDeal.DataSource = GameLog; }
private void btn_refresh_Click(object sender, EventArgs e) { BS_GV_PicSendSetting.DataSource = SF.InjectWins; foreach (Linq.WX_PCSendPicSetting loadset in SF.InjectWins.Where(t => t.Is_Reply == true)) { if (loadset.GroupOwner != null && loadset.GroupOwner != "") { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; QqWindowHelper qh = new QqWindowHelper(new IntPtr(Convert.ToInt32(loadset.WX_UserTMPID)), "", false); qh.ReloadMembers(loadset.GroupOwner, SF.RunnerF.MemberSource, loadset.WX_SourceType, db, new IntPtr(Convert.ToInt32(loadset.WX_UserTMPID))); } } BS_GVRandomTalk.DataMember = null; }
private void SendManulOrder_Load(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; if (dtp_StartDate.Value == null || dtp_EndDate.Value == null || RunnerF == null || _UserRow == null) { return; } var datasource = from ds in db.WX_UserReplyLog join dsgame in db.WX_UserGameLog on new { ds.aspnet_UserID, ds.WX_UserName, ds.ReceiveTime, ds.WX_SourceType } equals new { dsgame.aspnet_UserID, dsgame.WX_UserName, ReceiveTime = dsgame.TransTime, dsgame.WX_SourceType } into leftdsggame from dsgame2 in leftdsggame.DefaultIfEmpty() where ds.ReceiveTime >= dtp_StartDate.Value && ds.ReceiveTime < dtp_EndDate.Value && ds.aspnet_UserID == GlobalParam.UserKey && ds.WX_UserName == _UserRow.Field <string>("User_ContactID") && ds.WX_SourceType == _UserRow.Field <string>("User_SourceType") select new { ds.ReceiveTime, ds.ReceiveContent, ds.aspnet_UserID, ds.WX_UserName, ds.WX_SourceType, TransTime = (DateTime?)dsgame2.TransTime, dsgame2.GamePeriod , GameLocalPeriod = dsgame2.GameLocalPeriod , dsgame2.GameResult , dsgame2.Buy_Value , dsgame2.Buy_Type , dsgame2.Buy_Point, dsgame2.Result_Point }; GV_GameLog.DataSource = datasource; }
private void BtnSaveAndDeal_Click(object sender, EventArgs e) { bool Newdb = false; Linq.ProgramLogic.ShiShiCaiMode subm = Linq.ProgramLogic.ShiShiCaiMode.重庆时时彩; if (cb_gamemode.SelectedItem != null && cb_gamemode.SelectedItem.ToString() == "重庆时时彩") { subm = Linq.ProgramLogic.ShiShiCaiMode.重庆时时彩; } else if (cb_gamemode.SelectedItem != null && cb_gamemode.SelectedItem.ToString() == "五分彩") { subm = Linq.ProgramLogic.ShiShiCaiMode.五分彩; } else if (cb_gamemode.SelectedItem != null && cb_gamemode.SelectedItem.ToString() == "香港时时彩") { subm = Linq.ProgramLogic.ShiShiCaiMode.香港时时彩; } else if (cb_gamemode.SelectedItem != null && cb_gamemode.SelectedItem.ToString() == "澳洲幸运5") { subm = Linq.ProgramLogic.ShiShiCaiMode.澳洲幸运5; } Linq.ProgramLogic.NewGameResult( fd_Num1.Text + " " + fd_Num2.Text + " " + fd_Num3.Text + " " + fd_Num4.Text + " " + fd_Num5.Text, fd_day.Value.ToString("yyMMdd") + fd_Period.Text, ref Newdb, subm); if (Newdb) { StartF.ShiShiCaiDealGameLogAndNotice(subm); } Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; StartF.DrawChongqingshishicai(subm); if (Newdb) { StartF.ShiShiCaiDealGameLogAndNotice(subm); } StartF.SendChongqingResultPic(subm); Dtp_DownloadDate_ValueChanged(null, null);; }
private void btn_save_Click(object sender, EventArgs e) { try { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; var data = db.WX_WebSendPICSetting.SingleOrDefault(t => t.aspnet_UserID == GlobalParam.UserKey && t.WX_SourceType == WX_SourceType && t.WX_UserName == WX_UserName ); if (data != null) { data.ballinterval = Convert.ToInt32(tb_ballinterval.Text); data.footballPIC = cb_footballPIC.Checked; data.bassketballpic = cb_bassketballpic.Checked; data.balluclink = cb_balluclink.Checked; data.card = cb_card.Checked; data.cardname = tb_cardname.Text; data.shishicailink = cb_shishicailink.Checked; data.NumberPIC = cb_NumberPIC.Checked; data.dragonpic = cb_dragonpic.Checked; data.numericlink = cb_numericlink.Checked; data.dragonlink = cb_dragonlink.Checked; data.NumberAndDragonPIC = cb_numericanddragon.Checked; data.ballstart = cb_ballstart.Checked; data.ballend = cb_ballend.Checked; data.balllivepoint = cb_balllivepoint.Checked; data.HKSixResult = cb_SixResult.Checked; data.NumberDragonTxt = cb_NumberDragonTxt.Checked; data.NiuNiuPic = cb_NiuNiuPic.Checked; data.NoBigSmallSingleDoublePIC = cb_NoBigSmallSingleDoublePIC.Checked; data.IsSendPIC = cb_IsSendPIC.Checked; data.PIC_StartHour = Convert.ToInt32(tb_StartHour.Text); data.PIC_StartMinute = Convert.ToInt32(tb_StartMinute.Text); data.PIC_EndHour = Convert.ToInt32(tb_EndHour.Text); data.Pic_EndMinute = Convert.ToInt32(tb_EndMinute.Text); db.SubmitChanges(); } else { Linq.WX_WebSendPICSetting newd = new Linq.WX_WebSendPICSetting(); newd.aspnet_UserID = GlobalParam.UserKey; newd.WX_UserName = WX_UserName; newd.WX_SourceType = WX_SourceType; newd.ballinterval = Convert.ToInt32(tb_ballinterval.Text); newd.footballPIC = cb_footballPIC.Checked; newd.bassketballpic = cb_bassketballpic.Checked; newd.balluclink = cb_balluclink.Checked; newd.card = cb_card.Checked; newd.cardname = tb_cardname.Text; newd.shishicailink = cb_shishicailink.Checked; newd.NumberPIC = cb_NumberPIC.Checked; newd.dragonpic = cb_dragonpic.Checked; newd.numericlink = cb_numericlink.Checked; newd.dragonlink = cb_dragonlink.Checked; newd.balllivepoint = cb_balllivepoint.Checked; newd.NumberAndDragonPIC = cb_numericanddragon.Checked; newd.ballstart = cb_ballstart.Checked; newd.ballend = cb_ballend.Checked; newd.HKSixResult = cb_SixResult.Checked; newd.NumberDragonTxt = cb_NumberDragonTxt.Checked; newd.NiuNiuPic = cb_NiuNiuPic.Checked; newd.NoBigSmallSingleDoublePIC = cb_NoBigSmallSingleDoublePIC.Checked; newd.IsSendPIC = cb_IsSendPIC.Checked; newd.PIC_StartHour = Convert.ToInt32(tb_StartHour.Text); newd.PIC_StartMinute = Convert.ToInt32(tb_StartMinute.Text); newd.PIC_EndHour = Convert.ToInt32(tb_EndHour.Text); newd.Pic_EndMinute = Convert.ToInt32(tb_EndMinute.Text); db.WX_WebSendPICSetting.InsertOnSubmit(newd); db.SubmitChanges(); } DataRow[] list = RunnerF.MemberSource.Select("User_ContactID='" + WX_UserName + "'"); foreach (var rowitem in list) { rowitem.SetField <Boolean?>("User_IsSendPic", cb_IsSendPIC.Checked); } foreach (var item in subsource) { var datasub = db.WX_WebSendPICSettingMatchClass.SingleOrDefault(t => t.aspnet_UserID == GlobalParam.UserKey && t.WX_SourceType == WX_SourceType && t.WX_UserName == WX_UserName && t.MatchBallType == item.MatchBallType && t.MatchClassName == item.MatchClassName ); if (datasub != null) { datasub.SendAny = item.SendAny; db.SubmitChanges(); } else { Linq.WX_WebSendPICSettingMatchClass newsub = new Linq.WX_WebSendPICSettingMatchClass(); newsub.SendAny = item.SendAny; newsub.aspnet_UserID = GlobalParam.UserKey; newsub.WX_SourceType = WX_SourceType; newsub.WX_UserName = WX_UserName; newsub.MatchBallType = item.MatchBallType; newsub.MatchClassName = item.MatchClassName; db.WX_WebSendPICSettingMatchClass.InsertOnSubmit(newsub); db.SubmitChanges(); } } MessageBox.Show("保存成功"); } catch (Exception anyerror) { MessageBox.Show("保存失败" + anyerror.Message); } }
private void BTN_SEND_Click(object sender, EventArgs e) { //Result.Columns.Add("aspnet_UserID", typeof(Guid)); //Result.Columns.Add("WX_UserName"); //Result.Columns.Add("NickNameRemarkName"); //Result.Columns.Add("LocalPeriodDay"); //Result.Columns.Add("PeriodCount", typeof(decimal)); //Result.Columns.Add("TotalBuy", typeof(decimal)); //Result.Columns.Add("TotalResult", typeof(decimal)); //Result.Columns.Add("AverageBuy", typeof(decimal)); //Result.Columns.Add("FixNumber", typeof(decimal)); //Result.Columns.Add("FlowPercent", typeof(decimal)); //Result.Columns.Add("IfDivousPercent", typeof(decimal)); //Result.Columns.Add("BounsCount", typeof(decimal)); //Result.Columns.Add("Remark"); Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; DataTable ToSend = (DataTable)BS_DataSource.DataSource; var SendList = ToSend.AsEnumerable().Where(t => t.Field <decimal?>("BounsCount") > 10); MessageBox.Show("福利少于10的不发"); foreach (var Senditem in SendList) { DataRow[] usrrow = StartF.RunnerF.MemberSource.Select("User_ContactID='" + Senditem.Field <string>("WX_UserName").Replace("'", "''") + "' and User_SourceType='" + cb_SourceType.SelectedItem.ToString() + "'"); var fcl = db.WX_UserChangeLog.Where(t => t.aspnet_UserID == GlobalParam.UserKey && t.WX_UserName == Senditem.Field <string>("WX_UserName") && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.RemarkType == "福利" && t.ChangeLocalDay == Senditem.Field <String>("LocalPeriodDay") ); //取消禁止多次发放 // if (fcl.Count() == 0 && usrrow.Length != 0) if (Senditem.Field <decimal?>("BounsCount").HasValue == false) { NetFramework.Console.WriteLine(Senditem.Field <string>("WX_UserName") + "无福利跳过", true); continue; } if (Senditem.Field <decimal?>("BounsCount").Value == 0) { NetFramework.Console.WriteLine(Senditem.Field <string>("WX_UserName") + "0福利跳过", true); continue; } String Returnstr = Linq.ProgramLogic.WX_UserReplyLog_MySendCreate( "福利" + NetFramework.Util_Math.NullToZero(Senditem.Field <decimal?>("BounsCount")) , null, DateTime.Now, Senditem.Field <string>("WX_UserName"), cb_SourceType.SelectedItem.ToString()); if (Returnstr != "") { if (usrrow.Length != 0) { try { StartF.SendRobotContent( (cb_SourceType.SelectedItem.ToString() != "微" && cb_SourceType.SelectedItem.ToString() != "易" ? ("@" + usrrow.First().Field <string>("User_Contact") + "##") : "") + "发放福利" + NetFramework.Util_Math.NullToZero(Senditem.Field <decimal?>("BounsCount")) + "," + Returnstr , usrrow.First().Field <string>("User_ContactTEMPID") , usrrow.First().Field <string>("User_SourceType") ); } catch (Exception AnyError) { NetFramework.Console.WriteLine(AnyError.Message, true); NetFramework.Console.WriteLine(AnyError.StackTrace, true); } } else { NetFramework.Console.WriteLine(Senditem.Field <string>("WX_UserName") + "福利不能通知", true); } } }//循环发放 MessageBox.Show("发放完成"); }
private void BtnQuery_Click(object sender, EventArgs e) { if (BS_GVResult.DataSource != null) { ((DataTable)BS_GVResult.DataSource).Rows.Clear(); } gv_result.Columns.Clear(); Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; DataTable Result = new DataTable(); Result.Columns.Add("类别"); DataGridViewColumn dc = new DataGridViewColumn(); dc.HeaderText = "类别"; dc.Name = "类别"; dc.DataPropertyName = "类别"; dc.CellTemplate = new DataGridViewTextBoxCell(); dc.Frozen = true; gv_result.Columns.Add(dc); var buys = (from ds in db.WX_UserGameLog where ds.aspnet_UserID == GlobalParam.UserKey && String.Compare(ds.GameLocalPeriod.Substring(0, 8), dtp_startdate.Value.ToString("yyyyMMdd")) >= 0 && String.Compare(ds.GameLocalPeriod.Substring(0, 8), dtp_enddate.Value.ToString("yyyyMMdd")) <= 0 && ds.WX_SourceType == cb_SourceType.SelectedItem.ToString() select ds).ToList(); NetFramework.Console.WriteLine("########################################################################", false); NetFramework.Console.WriteLine("查询日期" + dtp_startdate.Value.ToString("yyyyMMdd"), false); NetFramework.Console.WriteLine("查询日期" + dtp_enddate.Value.ToString("yyyyMMdd"), false); NetFramework.Console.WriteLine("########################################################################", false); var myWXUSERS = buys.Select(t => t.WX_UserName).Distinct(); foreach (var item in myWXUSERS) { DataColumn uc = new DataColumn(); uc.ColumnName = item; DataGridViewColumn dcc = new DataGridViewColumn(); dcc.Name = item; dcc.DataPropertyName = item; dcc.CellTemplate = new DataGridViewTextBoxCell(); gv_result.Columns.Add(dcc); DataRow[] ur = RunnerF.MemberSource.Select("User_ContactID='" + item.Replace("'", "''") + "' and User_SourceType='" + cb_SourceType.SelectedItem.ToString() + "'"); if (ur.Count() != 0) { uc.Caption = ur[0].Field <string>("user_Contact"); } else { var FidnUser = db.WX_UserReply.SingleOrDefault(t => t.aspnet_UserID == GlobalParam.UserKey && t.WX_UserName == item && t.WX_SourceType == cb_SourceType.SelectedItem.ToString()); uc.Caption = (FidnUser == null ? item : (FidnUser.RemarkName != "" && FidnUser.RemarkName != null ? FidnUser.RemarkName + "@#" + FidnUser.NickName : FidnUser.NickName)); } dcc.HeaderText = uc.Caption; Result.Columns.Add(uc); } DataColumn ucfull = new DataColumn(); ucfull.ColumnName = "全部玩家"; Result.Columns.Add(ucfull); DataGridViewColumn dccful = new DataGridViewColumn(); dccful.Name = "全部玩家"; dccful.DataPropertyName = "全部玩家"; dccful.CellTemplate = new DataGridViewTextBoxCell(); gv_result.Columns.Add(dccful); var BuyDays = buys.Select(t => t.GameLocalPeriod.Substring(0, 8)).Distinct().OrderBy(t => t); NetFramework.Console.WriteLine("########################################################################", false); NetFramework.Console.WriteLine("获得天数" + BuyDays.Count(), false); NetFramework.Console.WriteLine("########################################################################", false); #region "天数" foreach (var item in BuyDays) { DataRow newr = Result.NewRow(); newr.SetField("类别", item + "下注"); foreach (var usritem in myWXUSERS) { newr.SetField(usritem, NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item)).Sum(t => t.Buy_Point))); } newr.SetField("全部玩家", NetFramework.Util_Math.NullToZero(buys.Where(t => t.GameLocalPeriod.StartsWith(item) && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point))); Application.DoEvents(); DataRow newr2 = Result.NewRow(); newr2.SetField("类别", item + "得分"); foreach (var usritem in myWXUSERS) { newr2.SetField(usritem, NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item) ).Sum(t => t.Result_Point))); } newr2.SetField("全部玩家", NetFramework.Util_Math.NullToZero(buys.Where(t => t.GameLocalPeriod.StartsWith(item) && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Result_Point))); Application.DoEvents(); DataRow newr6 = Result.NewRow(); newr6.SetField("类别", item + "福利"); foreach (var usritem in myWXUSERS) { newr6.SetField(usritem, NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.RemarkType == "福利" && t.aspnet_UserID == GlobalParam.UserKey && t.ChangeLocalDay.StartsWith(item) ).Sum(t => t.ChangePoint))); } newr6.SetField("全部玩家", NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.RemarkType == "福利" && t.aspnet_UserID == GlobalParam.UserKey && t.ChangeLocalDay.StartsWith(item) ).Sum(t => t.ChangePoint))); Application.DoEvents(); DataRow newr3 = Result.NewRow(); newr3.SetField("类别", item + "合计"); foreach (var usritem in myWXUSERS) { newr3.SetField(usritem, NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item) ).Sum(t => t.Buy_Point)) - NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item) ).Sum(t => t.Result_Point)) - NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.RemarkType == "福利" && t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && t.ChangeLocalDay.StartsWith(item) ).Sum(t => t.ChangePoint)) ); } newr3.SetField("全部玩家", NetFramework.Util_Math.NullToZero(buys.Where(t => t.GameLocalPeriod.StartsWith(item) && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point)) - NetFramework.Util_Math.NullToZero(buys.Where(t => t.GameLocalPeriod.StartsWith(item) && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Result_Point)) - NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.RemarkType == "福利" && t.aspnet_UserID == GlobalParam.UserKey && t.ChangeLocalDay.StartsWith(item) ).Sum(t => t.ChangePoint)) ); Application.DoEvents(); #region 总期数 DataRow newr8 = Result.NewRow(); newr8.SetField("类别", item + "期数"); foreach (var usritem in myWXUSERS) { newr8.SetField(usritem, NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item) ).Select(t => t.GamePeriod).Distinct().Count())); } newr8.SetField("全部玩家", NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item) ).Select(t => new { t.GamePeriod, t.WX_UserName, t.WX_SourceType }).Distinct().Count())); Application.DoEvents(); #endregion #region "平均值" DataRow newr7 = Result.NewRow(); newr7.SetField("类别", item + "平均"); foreach (var usritem in myWXUSERS) { decimal e_TotalBuy = NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.GameLocalPeriod.StartsWith(item) && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point)); decimal e_TotalPeriod = NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item) ).Select(t => t.GamePeriod).Distinct().Count()); newr7.SetField(usritem, (e_TotalPeriod == 0 ? 0 : e_TotalBuy / e_TotalPeriod)); } decimal TotalBuy = NetFramework.Util_Math.NullToZero(buys.Where(t => t.GameLocalPeriod.StartsWith(item) && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point)); decimal TotalPeriod = NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.aspnet_UserID == GlobalParam.UserKey && t.GameLocalPeriod.StartsWith(item) ).Select(t => t.GamePeriod).Distinct().Count()); newr7.SetField("全部玩家", (TotalPeriod == 0 ? 0 : TotalBuy / TotalPeriod)); Application.DoEvents(); #endregion Result.Rows.Add(newr); Result.Rows.Add(newr2); Result.Rows.Add(newr6); Result.Rows.Add(newr3); Result.Rows.Add(newr8); Result.Rows.Add(newr7); }//每日循环 #endregion #region 所有天数 DataRow newr_alldays = Result.NewRow(); newr_alldays.SetField("类别", "所有天数下注"); foreach (var usritem in myWXUSERS) { newr_alldays.SetField(usritem, NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point))); } newr_alldays.SetField("全部玩家", NetFramework.Util_Math.NullToZero(buys.Where(t => t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point))); Application.DoEvents(); DataRow newr2_alldays = Result.NewRow(); newr2_alldays.SetField("类别", "所有天数得分"); foreach (var usritem in myWXUSERS) { newr2_alldays.SetField(usritem, NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Result_Point))); } newr2_alldays.SetField("全部玩家", NetFramework.Util_Math.NullToZero(buys.Where(t => t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Result_Point))); Application.DoEvents(); DataRow newr6_alldays = Result.NewRow(); newr6_alldays.SetField("类别", "所有天数福利"); foreach (var usritem in myWXUSERS) { newr6_alldays.SetField(usritem, NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.RemarkType == "福利" && t.aspnet_UserID == GlobalParam.UserKey && (string.Compare(t.ChangeLocalDay, dtp_startdate.Value.ToString("yyyyMMdd")) >= 0) && (string.Compare(dtp_enddate.Value.ToString("yyyyMMdd"), t.ChangeLocalDay) >= 0) ).Sum(t => t.ChangePoint))); } newr6_alldays.SetField("全部玩家", NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.RemarkType == "福利" && t.aspnet_UserID == GlobalParam.UserKey && (string.Compare(t.ChangeLocalDay, dtp_startdate.Value.ToString("yyyyMMdd")) >= 0) && (string.Compare(dtp_enddate.Value.ToString("yyyyMMdd"), t.ChangeLocalDay) >= 0) ).Sum(t => t.ChangePoint))); Application.DoEvents(); DataRow newr3_alldays = Result.NewRow(); newr3_alldays.SetField("类别", "所有天数合计"); foreach (var usritem in myWXUSERS) { newr3_alldays.SetField(usritem, NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point)) - NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Result_Point)) - NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.RemarkType == "福利" && t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && (string.Compare(t.ChangeLocalDay, dtp_startdate.Value.ToString("yyyyMMdd")) >= 0) && (string.Compare(dtp_enddate.Value.ToString("yyyyMMdd"), t.ChangeLocalDay) >= 0) ).Sum(t => t.ChangePoint)) ); } newr3_alldays.SetField("全部玩家", NetFramework.Util_Math.NullToZero(buys.Where(t => t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point)) - NetFramework.Util_Math.NullToZero(buys.Where(t => t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Result_Point)) - NetFramework.Util_Math.NullToZero(db.WX_UserChangeLog.Where(t => t.RemarkType == "福利" && t.aspnet_UserID == GlobalParam.UserKey && (string.Compare(t.ChangeLocalDay, dtp_startdate.Value.ToString("yyyyMMdd")) >= 0) && (string.Compare(dtp_enddate.Value.ToString("yyyyMMdd"), t.ChangeLocalDay) >= 0) ).Sum(t => t.ChangePoint)) ); Application.DoEvents(); #region 总期数 DataRow newr8_alldays = Result.NewRow(); newr8_alldays.SetField("类别", "所有天数期数"); foreach (var usritem in myWXUSERS) { newr8_alldays.SetField(usritem, NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && (string.Compare(t.GameLocalPeriod, dtp_startdate.Value.ToString("yyyyMMdd")) >= 1) && (string.Compare(t.GameLocalPeriod, dtp_enddate.Value.ToString("yyyyMMdd")) <= 1) ).Select(t => t.GamePeriod).Distinct().Count())); } newr8_alldays.SetField("全部玩家", NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.aspnet_UserID == GlobalParam.UserKey && (string.Compare(t.GameLocalPeriod, dtp_startdate.Value.ToString("yyyyMMdd")) >= 1) && (string.Compare(t.GameLocalPeriod, dtp_enddate.Value.ToString("yyyyMMdd")) <= 1) ).Select(t => t.GamePeriod).Distinct().Count())); Application.DoEvents(); #endregion #region "平均值" DataRow newr7_alldays = Result.NewRow(); newr7_alldays.SetField("类别", "所有天数平均"); foreach (var usritem in myWXUSERS) { decimal e_TotalBuy = NetFramework.Util_Math.NullToZero(buys.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point)); decimal e_TotalPeriod = NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.WX_UserName == usritem && t.WX_SourceType == cb_SourceType.SelectedItem.ToString() && t.aspnet_UserID == GlobalParam.UserKey && (string.Compare(t.GameLocalPeriod, dtp_startdate.Value.ToString("yyyyMMdd")) >= 1) && (string.Compare(t.GameLocalPeriod, dtp_enddate.Value.ToString("yyyyMMdd")) <= 1) ).Select(t => t.GamePeriod).Distinct().Count()); newr7_alldays.SetField(usritem, (e_TotalPeriod == 0 ? 0 : e_TotalBuy / e_TotalPeriod)); } decimal TotalBuy_alldays = NetFramework.Util_Math.NullToZero(buys.Where(t => t.aspnet_UserID == GlobalParam.UserKey ).Sum(t => t.Buy_Point)); decimal TotalPeriod_alldays = NetFramework.Util_Math.NullToZero(db.WX_UserGameLog.Where(t => t.aspnet_UserID == GlobalParam.UserKey ).Select(t => t.GamePeriod).Distinct().Count()); newr7_alldays.SetField("全部玩家", (TotalPeriod_alldays == 0 ? 0 : TotalBuy_alldays / TotalPeriod_alldays)); Application.DoEvents(); #endregion Result.Rows.Add(newr_alldays); Result.Rows.Add(newr2_alldays); Result.Rows.Add(newr6_alldays); Result.Rows.Add(newr3_alldays); Result.Rows.Add(newr8_alldays); Result.Rows.Add(newr7_alldays); #endregion BS_GVResult.DataSource = Result; this.Refresh(); }
private void btn_download_Click(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; bool SendImage = false; //StartF.DownLoad163CaiPiaoV_kaijiangwang(ref SendImage, Dtp_DownloadDate.Value, true,true); //StartF.DownLoad163CaiPiaoV_aozc(ref SendImage, Dtp_DownloadDate.Value, true, true); string LastPeriod = db.Game_Result.Where(t => t.aspnet_UserID == GlobalParam.UserKey).OrderByDescending(t => t.GamePeriod).First().GamePeriod; StartF.ShiShiCaiDealGameLogAndNotice(Linq.ProgramLogic.ShiShiCaiMode.重庆时时彩, true); db.SubmitChanges(); Download163AndDeal_Load(null, null); SendImage = true; #region "有新的就通知,以及处理结果" if (SendImage == true) { DataRow[] dr = RunnerF.MemberSource.Select("User_IsReply='true'"); foreach (var Rowitem in dr) { #region 多人同号不到ID跳过 #endregion string TEMPUserName = dr[0].Field <string>("User_ContactTEMPID"); string WXUserName = dr[0].Field <string>("User_ContactID"); string WX_SourceType = dr[0].Field <string>("User_SourceType"); Linq.WX_WebSendPICSetting webpcset = db.WX_WebSendPICSetting.SingleOrDefault(t => t.aspnet_UserID == GlobalParam.UserKey && t.WX_SourceType == WX_SourceType && t.WX_UserName == WXUserName ); if (webpcset == null) { continue; } if (dr[0].Field <string>("User_SourceType") == "微") { if ((webpcset.dragonpic == true)) { StartF.SendRobotContent(StartForm.ReadVirtualFile("Data3" + GlobalParam.UserName + "_" + (Enum.GetName(typeof(Linq.ProgramLogic.ShiShiCaiMode), Linq.ProgramLogic.GetMode(dr))) + ".txt", db), TEMPUserName, WX_SourceType); } } if (dr[0].Field <string>("User_SourceType") == "易") { if ((webpcset.dragonpic == true)) { StartF.SendRobotContent(StartForm.ReadVirtualFile("Data3_yixin" + GlobalParam.UserName + "_" + (Enum.GetName(typeof(Linq.ProgramLogic.ShiShiCaiMode), Linq.ProgramLogic.GetMode(dr))) + ".txt", db), TEMPUserName, WX_SourceType); } } if ((webpcset.NumberPIC == true)) { StartF.SendRobotImage(Application.StartupPath + "\\Data" + GlobalParam.UserName + ".jpg", TEMPUserName, WX_SourceType); Thread.Sleep(500); } //if ((Mode == "All" && webpcset.NumberAndDragonPIC == true) || (Mode == "图3")) //{ // SendRobotImage(Application.StartupPath + "\\Data" + GlobalParam.UserName + "_v3.jpg", TEMPUserName, SourceType); //} if ((webpcset.NumberAndDragonPIC == true)) { StartF.SendRobotContent(StartForm.ReadVirtualFile("Data数字龙虎" + GlobalParam.UserName + "_" + (Enum.GetName(typeof(Linq.ProgramLogic.ShiShiCaiMode), Linq.ProgramLogic.GetMode(dr))) + ".txt", db), TEMPUserName, WX_SourceType); } if (webpcset.shishicailink == true) { StartF.SendRobotLink("查询开奖网地址", "https://h5.13322.com/kaijiang/ssc_cqssc_history_dtoday.html", TEMPUserName, WX_SourceType); } } //设置为自动监听的用户 } //新开奖 #endregion }
public void ReloadMembers(string GroupOwnerName, DataTable ToJoinIn, string WX_SourceType, Linq.dbDataContext db, IntPtr hwnd) { XmlDocument doc = new XmlDocument(); StartGetAccessibleObjects(_QqWindowHandle, out FindOwner, out FindOwnerParent, GroupOwnerName, out doc); object[] CHILDS = GetAccessibleChildren(FindOwnerParent); Linq.WX_PCSendPicSetting pcset = db.WX_PCSendPicSetting.SingleOrDefault(t => t.WX_UserTMPID == hwnd.ToString()); foreach (var CHILDITEM in CHILDS) { if (CHILDITEM.GetType().ToString().ToUpper().Contains("INT") == false) { continue; } string NewName = ((IAccessible)FindOwnerParent).get_accName(CHILDITEM); DataRow[] testexit = ToJoinIn.Select( "User_ContactID= '" + NewName.Replace("'", "''") + "' and User_SourceType = '" + WX_SourceType + "'" ); if (testexit.Length == 0) { Linq.WX_UserReply userreply = db.WX_UserReply.SingleOrDefault(t => t.aspnet_UserID == GlobalParam.UserKey && t.WX_UserName == NewName && t.WX_SourceType == WX_SourceType ); DataRow usr = ToJoinIn.AsEnumerable().SingleOrDefault (t => t.Field <object>("User_ContactID").ToString() == NewName && t.Field <object>("User_SourceType").ToString() == WX_SourceType ); if (userreply == null) { Linq.WX_UserReply newr = new Linq.WX_UserReply(); newr.aspnet_UserID = GlobalParam.UserKey; newr.WX_SourceType = WX_SourceType; newr.WX_UserName = NewName; newr.IsCaculateFuli = true; db.WX_UserReply.InsertOnSubmit(newr); db.SubmitChanges(); } if (usr == null && userreply == null) { DataRow newset = ToJoinIn.NewRow(); newset.SetField("User_ContactID", NewName); newset.SetField("User_ContactTEMPID", hwnd.ToString()); newset.SetField("User_SourceType", WX_SourceType); newset.SetField("User_Contact", NewName); newset.SetField("User_ChongqingMode", pcset.ChongqingMode); newset.SetField("User_FiveMinuteMode", pcset.FiveMinuteMode); newset.SetField("User_HkMode", pcset.HkMode); newset.SetField("User_AozcMode", pcset.AozcMode); ToJoinIn.Rows.Add(newset); usr = newset; } else if (usr == null && userreply != null) { DataRow newset = ToJoinIn.NewRow(); newset.SetField("User_ContactID", userreply.WX_UserName); newset.SetField("User_ContactTEMPID", hwnd.ToString()); newset.SetField("User_SourceType", userreply.WX_SourceType); newset.SetField("User_Contact", userreply.WX_UserName); newset.SetField("User_IsAdmin", userreply.IsAdmin); newset.SetField("User_IsCaculateFuli", userreply.IsCaculateFuli); newset.SetField("User_ChongqingMode", pcset.ChongqingMode); newset.SetField("User_FiveMinuteMode", pcset.FiveMinuteMode); newset.SetField("User_HkMode", pcset.HkMode); newset.SetField("User_AozcMode", pcset.AozcMode); ToJoinIn.Rows.Add(newset); usr = newset; } } } }
//public List<TeamRowFormat> RatioConvertToGridDataSource = new List<TeamRowFormat>(); public List <TeamRowFormat> RatioConvertToGridData(Linq.Game_FootBall_VS toc, Linq.dbDataContext db) { List <TeamRowFormat> RatioConvertToGridDataSource = new List <TeamRowFormat>(); TeamRowFormat ATEAM = new TeamRowFormat(); TeamRowFormat BTEAM = new TeamRowFormat(); Linq.Game_FootBall_VSRatios cr = Linq.ProgramLogic.VSGetCurRatio(toc, db); if (cr == null) { return(RatioConvertToGridDataSource); } ATEAM.Team = toc.A_Team; ATEAM.R1_0 = cr.R1_0_A; ATEAM.R2_0 = cr.R2_0_A; ATEAM.R2_1 = cr.R2_1_A; ATEAM.R3_0 = cr.R3_0_A; ATEAM.R3_1 = cr.R3_1_A; ATEAM.R3_2 = cr.R3_2_A; ATEAM.R4_0 = cr.R4_0_A; ATEAM.R4_1 = cr.R4_1_A; ATEAM.R4_2 = cr.R4_2_A; ATEAM.R4_3 = cr.R4_3_A; ATEAM.R0_0 = cr.R0_0; ATEAM.R1_1 = cr.R1_1; ATEAM.R2_2 = cr.R2_2; ATEAM.R3_3 = cr.R3_3; ATEAM.R4_4 = cr.R4_4; ATEAM.ROTHER = cr.ROTHER; BTEAM.Team = toc.B_Team; BTEAM.R1_0 = cr.R1_0_B; BTEAM.R2_0 = cr.R2_0_B; BTEAM.R2_1 = cr.R2_1_B; BTEAM.R3_0 = cr.R3_0_B; BTEAM.R3_1 = cr.R3_1_B; BTEAM.R3_2 = cr.R3_2_B; BTEAM.R4_0 = cr.R4_0_B; BTEAM.R4_1 = cr.R4_1_B; BTEAM.R4_2 = cr.R4_2_B; BTEAM.R4_3 = cr.R4_3_B; BTEAM.R0_0 = cr.R0_0; BTEAM.R1_1 = cr.R1_1; BTEAM.R2_2 = cr.R2_2; BTEAM.R3_3 = cr.R3_3; BTEAM.R4_4 = cr.R4_4; BTEAM.ROTHER = cr.ROTHER; RatioConvertToGridDataSource.Add(ATEAM); RatioConvertToGridDataSource.Add(BTEAM); return(RatioConvertToGridDataSource); }
private void Btn_Send_Click(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; try { ep_sql.Clear(); switch (_Mode) { case "Charge": string Result = Linq.ProgramLogic.WX_UserReplyLog_MySendCreate("上分" + tb_ChargeMoney.Text, _UserRow, DateTime.Now); string WXSend = StartF.SendRobotContent(Result , UserRow.Field <string>("User_ContactTEMPID") , UserRow.Field <string>("User_SourceType") ); // string Result = ""; // db.Logic_WX_UserReplyLog_MySendCreate("上分"+tb_ChargeMoney.Text, _UserRow.Field<string>("User_ContactID"), _UserRow.Field<string>("User_SourceType"), GlobalParam.Key, DateTime.Now, ref Result); //string WXResult= StartF.SendWXContent(Result // , UserRow.Field<string>("User_ContactTEMPID") // ); break; case "CleanUp": string Result2 = Linq.ProgramLogic.WX_UserReplyLog_MySendCreate("下分" + tb_ChargeMoney.Text, _UserRow, DateTime.Now); decimal?TotalPointClean = Linq.ProgramLogic.WXUserChangeLog_GetRemainder(UserRow.Field <string>("User_ContactTEMPID"), UserRow.Field <string>("User_SourceType")); string WXSendClean = StartF.SendRobotContent(Result2 , UserRow.Field <string>("User_ContactTEMPID") , UserRow.Field <string>("User_SourceType") ); // string Result2 = ""; //db.Logic_WX_UserReplyLog_MySendCreate("下分"+tb_ChargeMoney.Text, _UserRow.Field<string>("User_ContactID"), _UserRow.Field<string>("User_SourceType"), GlobalParam.Key, DateTime.Now, ref Result2); //string WXResult2 = StartF.SendWXContent(Result2 // , UserRow.Field<string>("User_ContactTEMPID") // ); break; default: break; } SendCharge_Load(null, null); } catch (Exception AnyError) { ep_sql.SetError(Btn_Send, AnyError.Message); } }
private void btn_open_Click(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; Linq.Game_ResultFootBall newgr = new Linq.Game_ResultFootBall(); Linq.Game_ResultFootBall findgr = db.Game_ResultFootBall.SingleOrDefault(t => t.GameID == ((List <GameHalfResult>)gv_result.DataSource).First().OpenGameID); if (findgr == null) { foreach (GameHalfResult item in ((List <GameHalfResult>)gv_result.DataSource)) { newgr.GameID = item.OpenGameID; newgr.aspnet_UserID = GlobalParam.UserKey; newgr.GameVS = ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameVS; if (item.TimeType == "上半场") { newgr.A_FrontHalf = item.TeamA; newgr.B_FrontHalf = item.TeamB; } if (item.TimeType == "下半场") { newgr.A_EndHalf = item.TeamA; newgr.B_EndHalf = item.TeamB; } } db.Game_ResultFootBall.InsertOnSubmit(newgr); db.SubmitChanges(); } else { foreach (GameHalfResult item in ((List <GameHalfResult>)gv_result.DataSource)) { findgr.GameID = item.OpenGameID; findgr.aspnet_UserID = GlobalParam.UserKey; findgr.GameVS = ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameVS; if (item.TimeType == "上半场") { findgr.A_FrontHalf = item.TeamA; findgr.B_FrontHalf = item.TeamB; } if (item.TimeType == "下半场") { findgr.A_EndHalf = item.TeamA; findgr.B_EndHalf = item.TeamB; } } db.SubmitChanges(); } var ToOpenList = db.WX_UserGameLog_Football.Where(t => t.GameKey == (findgr == null ? newgr.GameID : findgr.GameID) && (t.HaveOpen == false || t.HaveOpen == null) && t.aspnet_UserID == GlobalParam.UserKey ); foreach (Linq.WX_UserGameLog_Football item in ToOpenList) { string ToSend = ""; if (findgr == null) { ToSend = Linq.ProgramLogic.OpenBallGameLog(item, db, newgr.A_FrontHalf.Value, newgr.B_FrontHalf.Value, newgr.A_EndHalf.Value, newgr.B_EndHalf.Value); } else { ToSend = Linq.ProgramLogic.OpenBallGameLog(item, db, findgr.A_FrontHalf.Value, findgr.B_FrontHalf.Value, findgr.A_EndHalf.Value, findgr.B_EndHalf.Value); } DataRow findcontact = sf.RunnerF.MemberSource.AsEnumerable().SingleOrDefault(t => NetFramework.Util_Convert.ToString(t.Field <object>("User_SourceType")) == item.WX_SourceType && NetFramework.Util_Convert.ToString(t.Field <object>("User_ContactID")) == item.WX_UserName ); if (findcontact == null) { NetFramework.Console.WriteLine("找不到玩家,开奖结果发不出", true); } else { if (findgr == null) { sf.SendRobotContent(newgr.GameVS + Environment.NewLine + "上半场:" + newgr.A_FrontHalf + "-" + newgr.B_FrontHalf + "下半场" + newgr.A_EndHalf + "-" + newgr.B_EndHalf + Environment.NewLine + Linq.ProgramLogic.BallBuyTypeToChinseFrontShow(item.BuyType) + ",赔率" + item.BuyRatio.ToString() + ((item.BuyType == "A_WIN" || item.BuyType == "B_Win") ?("让球" + item.Winless):"") + ((item.BuyType == "BigWin" || item.BuyType == "SmallWin") ? ("总球" + item.Total) : "") + ToSend, findcontact.Field <object>("User_ContactTEMPID").ToString(), item.WX_SourceType); } else { sf.SendRobotContent(findgr.GameVS + Environment.NewLine + "上半场:" + findgr.A_FrontHalf + "-" + findgr.B_FrontHalf + "下半场" + findgr.A_EndHalf + "-" + findgr.B_EndHalf + Environment.NewLine + Linq.ProgramLogic.BallBuyTypeToChinseFrontShow(item.BuyType) + ",赔率" + item.BuyRatio.ToString() + ((item.BuyType == "A_WIN" || item.BuyType == "B_Win") ? ("让球" + item.Winless) : "") + ((item.BuyType == "BigWin" || item.BuyType == "SmallWin") ? ("总球" + item.Total) : "") + ToSend, findcontact.Field <object>("User_ContactTEMPID").ToString(), item.WX_SourceType); } } } }
private void GV_BallUnOpen_SelectionChanged(object sender, EventArgs e) { if (gv_balls.SelectedRows.Count == 0) { gv_result.DataSource = null; gv_playersbuys.DataSource = null; return; } else if (gv_balls.SelectedRows.Count == 1) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; Linq.Game_ResultFootBall gr_fb = db.Game_ResultFootBall.SingleOrDefault(t => t.GameID == ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameID); if (gr_fb == null) { List <GameHalfResult> gr = new List <GameHalfResult>(); GameHalfResult newr = new GameHalfResult(); newr.TimeType = "上半场"; newr.OpenGameID = ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameID; gr.Add(newr); GameHalfResult newr2 = new GameHalfResult(); newr2.TimeType = "下半场"; newr2.OpenGameID = ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameID; gr.Add(newr2); gv_result.DataSource = gr; } else { List <GameHalfResult> gr = new List <GameHalfResult>(); GameHalfResult newr = new GameHalfResult(); newr.TimeType = "上半场"; newr.OpenGameID = ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameID; newr.TeamA = gr_fb.A_FrontHalf; newr.TeamB = gr_fb.B_FrontHalf; gr.Add(newr); GameHalfResult newr2 = new GameHalfResult(); newr2.TimeType = "下半场"; newr2.OpenGameID = ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameID; newr2.TeamA = gr_fb.A_EndHalf; newr2.TeamB = gr_fb.B_EndHalf; gr.Add(newr2); gv_result.DataSource = gr; } var unplaysource = (from ds in db.WX_UserGameLog_Football join urname in db.WX_UserReply on new { ds.aspnet_UserID, ds.WX_UserName, ds.WX_SourceType } equals new { urname.aspnet_UserID, urname.WX_UserName, urname.WX_SourceType } into urnamr_emp from urnamr_emp_d in urnamr_emp.DefaultIfEmpty() where ds.HaveOpen == false && ds.GameKey == ((GameFormat)gv_balls.SelectedRows[0].DataBoundItem).GameID && ds.WX_SourceType == cb_wxsourcetype.SelectedItem.ToString() && ds.aspnet_UserID == GlobalParam.UserKey select new { WX_UserNameOrRemark = urnamr_emp_d.NickName + "(" + urnamr_emp_d.RemarkName + ")" , aspnet_UserID = ds.aspnet_UserID , transtime = ds.transtime , GameID = ds.GameKey , GameVS = ds.GameVS , BuyType = ds.BuyType , BuyRatio = ds.BuyRatio , BuyMoney = ds.BuyMoney , HaveOpen = ds.HaveOpen , ResultMoney = ds.ResultMoney , A_WIN = ds.A_WIN , Winless = ds.Winless , B_Win = ds.B_WIN , BigWin = ds.BIGWIN , Total = ds.Total , SmallWin = ds.SMALLWIN , R_A_A = ds.R_A_A , R_A_SAME = ds.R_A_SAME , R_A_B = ds.R_A_B , R_SAME_A = ds.R_SAME_A , R_SAME_SAME = ds.R_SAME_SAME , R_SAME_B = ds.R_SAME_B , R_B_A = ds.R_B_A , R_B_SAME = ds.R_B_SAME , R_B_B = ds.R_B_B , R1_0_A = ds.R1_0_A , R1_0_B = ds.R1_0_B , R2_0_A = ds.R2_0_A , R2_0_B = ds.R2_0_B , R2_1_A = ds.R2_1_A , R2_1_B = ds.R2_1_B , R3_0_A = ds.R3_0_A , R3_0_B = ds.R3_0_B , R3_1_A = ds.R3_1_A , R3_1_B = ds.R3_1_B , R3_2_A = ds.R3_2_A , R3_2_B = ds.R3_2_B , R4_0_A = ds.R4_0_A , R4_0_B = ds.R4_0_B , R4_1_A = ds.R4_1_A , R4_1_B = ds.R4_1_B , R4_2_A = ds.R4_2_A , R4_2_B = ds.R4_2_B , R4_3_A = ds.R4_3_A , R4_3_B = ds.R4_3_B , R0_0 = ds.R0_0 , R1_1 = ds.R1_1 , R2_2 = ds.R2_2 , R3_3 = ds.R3_3 , R4_4 = ds.R4_4 , Rother = ds.ROTHER , WX_SourceType = ds.WX_SourceType , A_Team = ds.A_Team , B_Team = ds.B_Team }); gv_playersbuys.DataSource = unplaysource; } else { gv_result.DataSource = null; gv_playersbuys.DataSource = null; return; } }
private void Btn_Load_Click(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; fd_SendTimeEnd1.Enabled = true; fd_SendTimeStart1.Enabled = true; RobotWebAdmin.SysadminServices adws = new RobotWebAdmin.SysadminServices(); adws.CookieContainer = GlobalParam.LoginCookie; RobootWeb.WebService usrws = new RobootWeb.WebService(); try { Newtonsoft.Json.Linq.JObject Juser = null; if (_Mode == "MyData") { Juser = Newtonsoft.Json.Linq.JObject.Parse(usrws.GetUserInfo(GlobalParam.UserKey)); } else { Juser = Newtonsoft.Json.Linq.JObject.Parse(adws.GetUserInfo(fd_username.Text)); } if (Juser != null) { fd_password.Enabled = true; fd_IsLock.Enabled = true; fd_IsLock.Checked = Convert.ToBoolean(Juser["IsLockedOut"].ToString()); btn_Save.Enabled = true; Btn_Build.Enabled = true; fd_ImageEndText.Enabled = true; fd_ImageTopText.Enabled = true; Linq.aspnet_UsersNewGameResultSend newgs = Linq.Util_Services.GetServicesSetting(Guid.Parse(Juser["ProviderUserKey"].ToString())); if (newgs == null) { fd_NewGameSend.Checked = false; fd_IsLock.Checked = false; FD_SendPIC.Checked = false; FD_ReceiveOrder.Checked = false; fd_MaxPlayerCount.Text = "500"; fd_SendTimeStart1.Text = "0"; fd_SendTimeEnd1.Text = "24"; } else { fd_NewGameSend.Checked = newgs.IsNewSend.HasValue ? newgs.IsNewSend.Value : false; fd_activecode.Text = newgs.ActiveCode; DateTime?LastDate = null; NetFramework.Util_MD5.MD5Success(newgs.ActiveCode, out LastDate, newgs.aspnet_UserID); fd_EndDate.Value = LastDate.HasValue ? LastDate.Value : fd_EndDate.MinDate; fd_IsLock.Checked = newgs.IsBlock.HasValue ? newgs.IsBlock.Value : false;; FD_SendPIC.Checked = newgs.IsSendPIC.HasValue ? newgs.IsSendPIC.Value : false;; FD_ReceiveOrder.Checked = newgs.IsReceiveOrder.HasValue ? newgs.IsReceiveOrder.Value : false;; fd_MaxPlayerCount.Text = newgs.MaxPlayerCount.HasValue ? newgs.MaxPlayerCount.ToString() : "50"; //System.Web.Security.MembershipUser boss = System.Web.Security.Membership.GetUser(newgs.bossaspnet_UserID == null ? Guid.Empty : newgs.bossaspnet_UserID); //fd_BossUserName.Text = (boss == null ? "" : boss.UserName); fd_SendTimeStart1.Text = Object2Str(newgs.SendImageStart, "0"); fd_SendTimeEnd1.Text = Object2Str(newgs.SendImageEnd, "24"); fd_SendTimeStart2.Text = Object2Str(newgs.SendImageStart2, "0"); fd_SendTimeEnd2.Text = Object2Str(newgs.SendImageEnd2, "24"); fd_SendTimeStart3.Text = Object2Str(newgs.SendImageStart3, "0"); fd_SendTimeEnd3.Text = Object2Str(newgs.SendImageEnd3, "24"); fd_SendTimeStart4.Text = Object2Str(newgs.SendImageStart4, "0"); fd_SendTimeEnd4.Text = Object2Str(newgs.SendImageEnd4, "24"); fd_ImageTopText.Text = Object2Str(newgs.ImageTopText); fd_ImageEndText.Text = Object2Str(newgs.ImageEndText); Cb_OpenMode.SelectedItem = newgs.OpenMode; cb_SuperUser.Checked = newgs.SuperUser.HasValue ? newgs.SuperUser.Value : false; tb_StartHour.Text = newgs.BlockStartHour.HasValue ? newgs.BlockStartHour.Value.ToString() : ""; tb_StartMinute.Text = newgs.BlockStartMinute.HasValue ? newgs.BlockStartMinute.Value.ToString() : ""; tb_EndHour.Text = newgs.BlockEndHour.HasValue ? newgs.BlockEndHour.Value.ToString() : ""; tb_EndMinute.Text = newgs.BlockEndMinute.HasValue ? newgs.BlockEndMinute.Value.ToString() : ""; cb_TwoTreeNotSingle.Checked = newgs.TwoTreeNotSingle.HasValue ? newgs.TwoTreeNotSingle.Value : false; tb_liushuiratio.Text = newgs.LiuShuiRatio.HasValue ? newgs.LiuShuiRatio.Value.ToString("0.000") : "0.024"; tb_fuliratio.Text = newgs.FuliRatio.HasValue ? newgs.FuliRatio.Value.ToString("0.000") : "0.02"; T_AoZhouCai.Checked = newgs.Thread_AoZhouCai.HasValue ? newgs.Thread_AoZhouCai.Value : true; T_VRChongQingShiShiCai.Checked = newgs.Thread_VRChongqing.HasValue ? newgs.Thread_VRChongqing.Value : true; T_TengXunShiFen.Checked = newgs.Thread_TengXunShiFen.HasValue ? newgs.Thread_TengXunShiFen.Value : true; T_TengXunWuFen.Checked = newgs.Thread_TengXunWuFen.HasValue ? newgs.Thread_TengXunWuFen.Value : true; T_WuFenCai.Checked = newgs.Thread_WuFen.HasValue ? newgs.Thread_WuFen.Value : true; T_XinJiangShiShiCai.Checked = newgs.Thread_XinJiangShiShiCai.HasValue ? newgs.Thread_XinJiangShiShiCai.Value : true; T_chongqingshishicai.Checked = newgs.Thread_ChongQingShiShiCai.HasValue ? newgs.Thread_ChongQingShiShiCai.Value : true; T_TengXunShiFenXin.Checked = newgs.Thread_TengXunShiFenXin.HasValue ? newgs.Thread_TengXunShiFenXin.Value : true; T_TengXunWuFenXin.Checked = newgs.Thread_TengXunWuFenXin.HasValue ? newgs.Thread_TengXunWuFenXin.Value : true; T_HeNeiWuFen.Checked = newgs.Thread_HeNeiWuFen.HasValue ? newgs.Thread_HeNeiWuFen.Value : true; } } else { throw new Exception("用户找不到"); } } catch (Exception AnyError) { ep_wf.SetError(Btn_Load, AnyError.Message + Environment.NewLine + AnyError.StackTrace); } }
private void btn_Save_Click(object sender, EventArgs e) { Linq.dbDataContext db = new Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[GlobalParam.DataSourceName].ConnectionString); //db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; ep_wf.Clear(); RobotWebAdmin.SysadminServices adws = new RobotWebAdmin.SysadminServices(); adws.CookieContainer = GlobalParam.LoginCookie; RobootWeb.WebService usrws = new RobootWeb.WebService(); if (fd_BossUserName.Text != "") { //string checkbossid = Membership.GetUser(fd_BossUserName.Text); //if (checkboss == null) //{ // ep_wf.SetError(fd_BossUserName, "老板号找不到"); // return; // } } switch (_Mode) { case "New": try { JObject usr = JObject.Parse(adws.CreateUser(fd_username.Text, fd_password.Text)); Linq.aspnet_UsersNewGameResultSend newGameResultSend = new Linq.aspnet_UsersNewGameResultSend(); newGameResultSend.aspnet_UserID = Guid.Parse(usr["ProviderUserKey"].ToString()); newGameResultSend.IsNewSend = fd_NewGameSend.Checked; newGameResultSend.IsBlock = Fd_IsBlock.Checked; newGameResultSend.IsSendPIC = FD_SendPIC.Checked; newGameResultSend.IsReceiveOrder = FD_ReceiveOrder.Checked; newGameResultSend.MaxPlayerCount = Convert.ToInt32(fd_MaxPlayerCount.Text); if (fd_activecode.Text == "" || fd_EndDate.Value.Date == DateTime.Today) { fd_EndDate.Value = DateTime.Today.AddMonths(3); Btn_Build_Click(null, null); } newGameResultSend.ActiveCode = fd_activecode.Text; newGameResultSend.BlockStartHour = 3; newGameResultSend.BlockStartMinute = 11; newGameResultSend.BlockEndHour = 7; newGameResultSend.BlockEndMinute = 9; //MembershipUser boss = Membership.GetUser(fd_BossUserName.Text); //newGameResultSend.bossaspnet_UserID = (boss == null ? Guid.Empty : (Guid)boss.ProviderUserKey); newGameResultSend.SendImageStart = Convert.ToInt32(fd_SendTimeStart1.Text); newGameResultSend.SendImageEnd = Convert.ToInt32(fd_SendTimeEnd1.Text); newGameResultSend.SendImageStart2 = Convert.ToInt32(fd_SendTimeStart2.Text); newGameResultSend.SendImageEnd2 = Convert.ToInt32(fd_SendTimeEnd2.Text); newGameResultSend.SendImageStart3 = Convert.ToInt32(fd_SendTimeStart3.Text); newGameResultSend.SendImageEnd3 = Convert.ToInt32(fd_SendTimeEnd3.Text); newGameResultSend.SendImageStart4 = Convert.ToInt32(fd_SendTimeStart4.Text); newGameResultSend.SendImageEnd4 = Convert.ToInt32(fd_SendTimeEnd4.Text); newGameResultSend.ImageTopText = fd_ImageTopText.Text; newGameResultSend.ImageEndText = fd_ImageEndText.Text;; newGameResultSend.OpenMode = (Cb_OpenMode.SelectedItem == null ? "" : Cb_OpenMode.SelectedItem.ToString()); newGameResultSend.SuperUser = cb_SuperUser.Checked; newGameResultSend.BlockStartHour = Convert.ToInt32(tb_StartHour.Text); newGameResultSend.BlockStartMinute = Convert.ToInt32(tb_StartMinute.Text); newGameResultSend.BlockEndHour = Convert.ToInt32(tb_EndHour.Text); newGameResultSend.BlockEndMinute = Convert.ToInt32(tb_EndMinute.Text); newGameResultSend.TwoTreeNotSingle = cb_TwoTreeNotSingle.Checked; newGameResultSend.FuliRatio = Convert.ToDecimal(tb_fuliratio.Text); newGameResultSend.LiuShuiRatio = Convert.ToDecimal(tb_liushuiratio.Text); newGameResultSend.Thread_AoZhouCai = T_AoZhouCai.Checked; newGameResultSend.Thread_VRChongqing = T_VRChongQingShiShiCai.Checked; newGameResultSend.Thread_TengXunShiFen = T_TengXunShiFen.Checked; newGameResultSend.Thread_TengXunWuFen = T_TengXunWuFen.Checked; newGameResultSend.Thread_WuFen = T_WuFenCai.Checked; newGameResultSend.Thread_XinJiangShiShiCai = T_XinJiangShiShiCai.Checked; newGameResultSend.Thread_ChongQingShiShiCai = T_chongqingshishicai.Checked; newGameResultSend.Thread_TengXunShiFenXin = T_TengXunShiFenXin.Checked; newGameResultSend.Thread_TengXunWuFenXin = T_TengXunWuFenXin.Checked; newGameResultSend.Thread_HeNeiWuFen = T_HeNeiWuFen.Checked; Linq.Util_Services.SaveServicesSetting(newGameResultSend); Linq.Game_BasicRatio[] CopyRatio = (Linq.Game_BasicRatio[])JsonConvert.DeserializeObject(usrws.GetTemplateRatios(), typeof(Linq.Game_BasicRatio[])); if (CopyRatio.Count() != 0) { foreach (var item in CopyRatio) { Linq.Game_BasicRatio newr = new Linq.Game_BasicRatio(); newr.aspnet_UserID = Guid.Parse(usr["ProviderUserKey"].ToString()); newr.BasicRatio = item.BasicRatio; newr.BuyType = item.BuyType; newr.BuyValue = item.BuyValue; newr.GameType = item.GameType; newr.IncludeMin = item.IncludeMin; newr.MaxBuy = item.MaxBuy; newr.MinBuy = item.MinBuy; newr.BonusBuyValueCondition = item.BonusBuyValueCondition; newr.WX_SourceType = item.WX_SourceType; newr.Enable = item.Enable; newr.OrderIndex = item.OrderIndex; db.Game_BasicRatio.InsertOnSubmit(newr); db.SubmitChanges(); } } Linq.WX_BounsConfig[] BounsConfig = (Linq.WX_BounsConfig[])JsonConvert.DeserializeObject(usrws.GetTemplateBonus(), typeof(Linq.WX_BounsConfig[])); if (BounsConfig.Count() != 0) { foreach (var item in BounsConfig) { Linq.WX_BounsConfig newr = new Linq.WX_BounsConfig(); newr.aspnet_UserID = Guid.Parse(usr["ProviderUserKey"].ToString()); newr.RowNumber = item.RowNumber; newr.StartBuyPeriod = item.StartBuyPeriod; newr.EndBuyPeriod = item.EndBuyPeriod; newr.StartBuyAverage = item.StartBuyAverage; newr.EndBuyAverage = item.EndBuyAverage; newr.FixNumber = item.FixNumber; newr.FlowPercent = item.FlowPercent; newr.IfDivousPercent = item.IfDivousPercent; db.WX_BounsConfig.InsertOnSubmit(newr); db.SubmitChanges(); } } MessageBox.Show("保存成功"); } catch (Exception anyerror) { ep_wf.SetError(btn_Save, anyerror.Message + Environment.NewLine + anyerror.StackTrace); fd_password.Enabled = true; } break; case "Modify": try { bool success = true; JObject juser = JObject.Parse(adws.GetUserInfo(fd_username.Text)); //MembershipUser user = System.Web.Security.Membership.GetUser(fd_username.Text); if (fd_password.Text != "") { //string NewPassword = user.ResetPassword(); //user.ChangePassword(NewPassword, fd_password.Text); usrws.ChangePassword(Guid.Parse(juser["ProviderUserKey"].ToString()), fd_password.Text); } if (fd_IsLock.Checked == false) { //user.UnlockUser(); success &= adws.SetUserLock(fd_username.Text, false); } //System.Web.Security.Membership.UpdateUser(user); if (fd_IsLock.Checked == true) { //Linq.aspnet_Users aspnet_Users = db.aspnet_Users.SingleOrDefault(t => t.UserId == new Guid(user.ProviderUserKey.ToString())); //aspnet_Users.aspnet_Membership.IsLockedOut = true; //db.SubmitChanges(); success &= adws.SetUserLock(fd_username.Text, true); } #region 开奖立即发送设置 Linq.aspnet_UsersNewGameResultSend finds = Linq.Util_Services.GetServicesSetting(Guid.Parse(juser["ProviderUserKey"].ToString())); if (finds == null) { Linq.aspnet_UsersNewGameResultSend newGameResultSend = new Linq.aspnet_UsersNewGameResultSend(); newGameResultSend.aspnet_UserID = Guid.Parse(juser["ProviderUserKey"].ToString()); //(Guid)userguid.ProviderUserKey; newGameResultSend.IsNewSend = fd_NewGameSend.Checked; newGameResultSend.ActiveCode = fd_activecode.Text; newGameResultSend.IsBlock = Fd_IsBlock.Checked; newGameResultSend.IsSendPIC = FD_SendPIC.Checked; newGameResultSend.IsReceiveOrder = FD_ReceiveOrder.Checked; newGameResultSend.MaxPlayerCount = Convert.ToInt32(fd_MaxPlayerCount.Text); //MembershipUser boss = Membership.GetUser(fd_BossUserName.Text); //newGameResultSend.bossaspnet_UserID = (boss == null ? Guid.Empty : (Guid)boss.ProviderUserKey); newGameResultSend.SendImageStart = Convert.ToInt32(fd_SendTimeStart1.Text); newGameResultSend.SendImageEnd = Convert.ToInt32(fd_SendTimeEnd1.Text); newGameResultSend.SendImageStart2 = Convert.ToInt32(fd_SendTimeStart2.Text); newGameResultSend.SendImageEnd2 = Convert.ToInt32(fd_SendTimeEnd2.Text); newGameResultSend.SendImageStart3 = Convert.ToInt32(fd_SendTimeStart3.Text); newGameResultSend.SendImageEnd3 = Convert.ToInt32(fd_SendTimeEnd3.Text); newGameResultSend.SendImageStart4 = Convert.ToInt32(fd_SendTimeStart4.Text); newGameResultSend.SendImageEnd4 = Convert.ToInt32(fd_SendTimeEnd4.Text); newGameResultSend.ImageTopText = fd_ImageTopText.Text; newGameResultSend.ImageEndText = fd_ImageEndText.Text; newGameResultSend.BlockStartHour = 3; newGameResultSend.BlockStartMinute = 11; newGameResultSend.BlockEndHour = 7; newGameResultSend.BlockEndMinute = 9; newGameResultSend.OpenMode = (Cb_OpenMode.SelectedItem == null ? "" : Cb_OpenMode.SelectedItem.ToString()); newGameResultSend.SuperUser = cb_SuperUser.Checked; newGameResultSend.BlockStartHour = Convert.ToInt32(tb_StartHour.Text); newGameResultSend.BlockStartMinute = Convert.ToInt32(tb_StartMinute.Text); newGameResultSend.BlockEndHour = Convert.ToInt32(tb_EndHour.Text); newGameResultSend.BlockEndMinute = Convert.ToInt32(tb_EndMinute.Text); newGameResultSend.TwoTreeNotSingle = cb_TwoTreeNotSingle.Checked; newGameResultSend.FuliRatio = Convert.ToDecimal(tb_fuliratio.Text); newGameResultSend.LiuShuiRatio = Convert.ToDecimal(tb_liushuiratio.Text); newGameResultSend.Thread_AoZhouCai = T_AoZhouCai.Checked; newGameResultSend.Thread_VRChongqing = T_VRChongQingShiShiCai.Checked; newGameResultSend.Thread_TengXunShiFen = T_TengXunShiFen.Checked; newGameResultSend.Thread_TengXunWuFen = T_TengXunWuFen.Checked; newGameResultSend.Thread_WuFen = T_WuFenCai.Checked; newGameResultSend.Thread_XinJiangShiShiCai = T_XinJiangShiShiCai.Checked; newGameResultSend.Thread_ChongQingShiShiCai = T_chongqingshishicai.Checked; newGameResultSend.Thread_TengXunShiFenXin = T_TengXunShiFenXin.Checked; newGameResultSend.Thread_TengXunWuFenXin = T_TengXunWuFenXin.Checked; newGameResultSend.Thread_HeNeiWuFen = T_HeNeiWuFen.Checked; Linq.Util_Services.SaveServicesSetting(newGameResultSend); } else { finds.IsNewSend = fd_NewGameSend.Checked; finds.IsBlock = fd_IsLock.Checked; finds.IsSendPIC = FD_SendPIC.Checked; finds.IsReceiveOrder = FD_ReceiveOrder.Checked; finds.MaxPlayerCount = Convert.ToInt32(fd_MaxPlayerCount.Text); finds.ActiveCode = fd_activecode.Text; finds.IsBlock = Fd_IsBlock.Checked; finds.IsSendPIC = FD_SendPIC.Checked; finds.IsReceiveOrder = FD_ReceiveOrder.Checked; finds.MaxPlayerCount = Convert.ToInt32(fd_MaxPlayerCount.Text); //MembershipUser boss = Membership.GetUser(fd_BossUserName.Text); //finds.bossaspnet_UserID = (boss == null ? Guid.Empty : (Guid)boss.ProviderUserKey); finds.SendImageStart = Convert.ToInt32(fd_SendTimeStart1.Text); finds.SendImageEnd = Convert.ToInt32(fd_SendTimeEnd1.Text); finds.SendImageStart2 = Convert.ToInt32(fd_SendTimeStart2.Text); finds.SendImageEnd2 = Convert.ToInt32(fd_SendTimeEnd2.Text); finds.SendImageStart3 = Convert.ToInt32(fd_SendTimeStart3.Text); finds.SendImageEnd3 = Convert.ToInt32(fd_SendTimeEnd3.Text); finds.SendImageStart4 = Convert.ToInt32(fd_SendTimeStart4.Text); finds.SendImageEnd4 = Convert.ToInt32(fd_SendTimeEnd4.Text); finds.ImageTopText = fd_ImageTopText.Text; finds.ImageEndText = fd_ImageEndText.Text;; finds.OpenMode = (Cb_OpenMode.SelectedItem == null ? "" : Cb_OpenMode.SelectedItem.ToString()); finds.SuperUser = cb_SuperUser.Checked; finds.BlockStartHour = Convert.ToInt32(tb_StartHour.Text); finds.BlockStartMinute = Convert.ToInt32(tb_StartMinute.Text); finds.BlockEndHour = Convert.ToInt32(tb_EndHour.Text); finds.BlockEndMinute = Convert.ToInt32(tb_EndMinute.Text); finds.TwoTreeNotSingle = cb_TwoTreeNotSingle.Checked; finds.FuliRatio = Convert.ToDecimal(tb_fuliratio.Text); finds.LiuShuiRatio = Convert.ToDecimal(tb_liushuiratio.Text); finds.Thread_AoZhouCai = T_AoZhouCai.Checked; finds.Thread_VRChongqing = T_VRChongQingShiShiCai.Checked; finds.Thread_TengXunShiFen = T_TengXunShiFen.Checked; finds.Thread_TengXunWuFen = T_TengXunWuFen.Checked; finds.Thread_WuFen = T_WuFenCai.Checked; finds.Thread_XinJiangShiShiCai = T_XinJiangShiShiCai.Checked; finds.Thread_ChongQingShiShiCai = T_chongqingshishicai.Checked; finds.Thread_TengXunShiFenXin = T_TengXunShiFenXin.Checked; finds.Thread_TengXunWuFenXin = T_TengXunWuFenXin.Checked; finds.Thread_HeNeiWuFen = T_HeNeiWuFen.Checked; Linq.Util_Services.SaveServicesSetting(finds); } #endregion fd_SendTimeStart1.Enabled = false; fd_SendTimeEnd1.Enabled = false; MessageBox.Show("保存成功"); } catch (Exception anyerror) { ep_wf.SetError(btn_Save, anyerror.Message + Environment.NewLine + anyerror.StackTrace); } break; case "MyData": //MembershipUser usermydata = System.Web.Security.Membership.GetUser(fd_username.Text); if (fd_password.Text != "") { //string NewPassword = usermydata.ResetPassword(); //usermydata.ChangePassword(NewPassword, fd_password.Text); usrws.ChangePassword(GlobalParam.UserKey, fd_password.Text); } // System.Web.Security.Membership.UpdateUser(usermydata); Linq.aspnet_UsersNewGameResultSend findsmydata = Linq.Util_Services.GetServicesSetting(GlobalParam.UserKey); if (findsmydata == null) { Linq.aspnet_UsersNewGameResultSend newGameResultSend = new Linq.aspnet_UsersNewGameResultSend(); newGameResultSend.aspnet_UserID = GlobalParam.UserKey; newGameResultSend.IsNewSend = fd_NewGameSend.Checked; newGameResultSend.ActiveCode = fd_activecode.Text; newGameResultSend.IsBlock = Fd_IsBlock.Checked; newGameResultSend.IsSendPIC = FD_SendPIC.Checked; newGameResultSend.IsReceiveOrder = FD_ReceiveOrder.Checked; newGameResultSend.MaxPlayerCount = Convert.ToInt32(fd_MaxPlayerCount.Text); //MembershipUser boss = Membership.GetUser(fd_BossUserName.Text); //newGameResultSend.bossaspnet_UserID = (boss == null ? Guid.Empty : (Guid)boss.ProviderUserKey); newGameResultSend.SendImageStart = Convert.ToInt32(fd_SendTimeStart1.Text); newGameResultSend.SendImageEnd = Convert.ToInt32(fd_SendTimeEnd1.Text); newGameResultSend.SendImageStart2 = Convert.ToInt32(fd_SendTimeStart2.Text); newGameResultSend.SendImageEnd2 = Convert.ToInt32(fd_SendTimeEnd2.Text); newGameResultSend.SendImageStart3 = Convert.ToInt32(fd_SendTimeStart3.Text); newGameResultSend.SendImageEnd3 = Convert.ToInt32(fd_SendTimeEnd3.Text); newGameResultSend.SendImageStart4 = Convert.ToInt32(fd_SendTimeStart4.Text); newGameResultSend.SendImageEnd4 = Convert.ToInt32(fd_SendTimeEnd4.Text); newGameResultSend.ImageTopText = fd_ImageTopText.Text; newGameResultSend.ImageEndText = fd_ImageEndText.Text;; newGameResultSend.BlockStartHour = 3; newGameResultSend.BlockStartMinute = 11; newGameResultSend.BlockEndHour = 7; newGameResultSend.BlockEndMinute = 9; newGameResultSend.BlockStartHour = Convert.ToInt32(tb_StartHour.Text); newGameResultSend.BlockStartMinute = Convert.ToInt32(tb_StartMinute.Text); newGameResultSend.BlockEndHour = Convert.ToInt32(tb_EndHour.Text); newGameResultSend.BlockEndMinute = Convert.ToInt32(tb_EndMinute.Text); newGameResultSend.TwoTreeNotSingle = cb_TwoTreeNotSingle.Checked; newGameResultSend.FuliRatio = Convert.ToDecimal(tb_fuliratio.Text); newGameResultSend.LiuShuiRatio = Convert.ToDecimal(tb_liushuiratio.Text); newGameResultSend.Thread_AoZhouCai = T_AoZhouCai.Checked; newGameResultSend.Thread_VRChongqing = T_VRChongQingShiShiCai.Checked; newGameResultSend.Thread_TengXunShiFen = T_TengXunShiFen.Checked; newGameResultSend.Thread_TengXunWuFen = T_TengXunWuFen.Checked; newGameResultSend.Thread_WuFen = T_WuFenCai.Checked; newGameResultSend.Thread_XinJiangShiShiCai = T_XinJiangShiShiCai.Checked; newGameResultSend.Thread_ChongQingShiShiCai = T_chongqingshishicai.Checked; newGameResultSend.Thread_TengXunShiFenXin = T_TengXunShiFenXin.Checked; newGameResultSend.Thread_TengXunWuFenXin = T_TengXunWuFenXin.Checked; newGameResultSend.Thread_HeNeiWuFen = T_HeNeiWuFen.Checked; Linq.Util_Services.SaveServicesSetting(newGameResultSend); } else { findsmydata.IsNewSend = fd_NewGameSend.Checked; findsmydata.IsBlock = fd_IsLock.Checked; findsmydata.IsSendPIC = FD_SendPIC.Checked; findsmydata.IsReceiveOrder = FD_ReceiveOrder.Checked; findsmydata.MaxPlayerCount = Convert.ToInt32(fd_MaxPlayerCount.Text); findsmydata.ActiveCode = fd_activecode.Text; //MembershipUser boss = Membership.GetUser(fd_BossUserName.Text); //findsmydata.bossaspnet_UserID = (boss == null ? Guid.Empty : (Guid)boss.ProviderUserKey); findsmydata.SendImageStart = Convert.ToInt32(fd_SendTimeStart1.Text); findsmydata.SendImageEnd = Convert.ToInt32(fd_SendTimeEnd1.Text); findsmydata.SendImageStart2 = Convert.ToInt32(fd_SendTimeStart2.Text); findsmydata.SendImageEnd2 = Convert.ToInt32(fd_SendTimeEnd2.Text); findsmydata.SendImageStart3 = Convert.ToInt32(fd_SendTimeStart3.Text); findsmydata.SendImageEnd3 = Convert.ToInt32(fd_SendTimeEnd3.Text); findsmydata.SendImageStart4 = Convert.ToInt32(fd_SendTimeStart4.Text); findsmydata.SendImageEnd4 = Convert.ToInt32(fd_SendTimeEnd4.Text); findsmydata.ImageTopText = fd_ImageTopText.Text; findsmydata.ImageEndText = fd_ImageEndText.Text; findsmydata.BlockStartHour = Convert.ToInt32(tb_StartHour.Text); findsmydata.BlockStartMinute = Convert.ToInt32(tb_StartMinute.Text); findsmydata.BlockEndHour = Convert.ToInt32(tb_EndHour.Text); findsmydata.BlockEndMinute = Convert.ToInt32(tb_EndMinute.Text); findsmydata.TwoTreeNotSingle = cb_TwoTreeNotSingle.Checked; findsmydata.FuliRatio = Convert.ToDecimal(tb_fuliratio.Text); findsmydata.LiuShuiRatio = Convert.ToDecimal(tb_liushuiratio.Text); findsmydata.Thread_AoZhouCai = T_AoZhouCai.Checked; findsmydata.Thread_VRChongqing = T_VRChongQingShiShiCai.Checked; findsmydata.Thread_TengXunShiFen = T_TengXunShiFen.Checked; findsmydata.Thread_TengXunWuFen = T_TengXunWuFen.Checked; findsmydata.Thread_WuFen = T_WuFenCai.Checked; findsmydata.Thread_XinJiangShiShiCai = T_XinJiangShiShiCai.Checked; findsmydata.Thread_ChongQingShiShiCai = T_chongqingshishicai.Checked; findsmydata.Thread_TengXunShiFenXin = T_TengXunShiFenXin.Checked; findsmydata.Thread_TengXunWuFenXin = T_TengXunWuFenXin.Checked; findsmydata.Thread_HeNeiWuFen = T_HeNeiWuFen.Checked; Linq.Util_Services.SaveServicesSetting(findsmydata); } sf.LoadUserSetting(); break; default: break; }//按模式操作 fd_password.Text = ""; fd_password.Enabled = false; fd_IsLock.Checked = false; fd_IsLock.Enabled = false; db.SubmitChanges(); fd_ImageEndText.Enabled = false; fd_ImageTopText.Enabled = false; MessageBox.Show("保存成功"); }//函数结束