Beispiel #1
0
        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;
        }
Beispiel #2
0
        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;
        }
Beispiel #3
0
        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();
        }
Beispiel #4
0
        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;
        }
Beispiel #5
0
        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;
        }
Beispiel #6
0
        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);
            }
        }
Beispiel #7
0
        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);
        }
Beispiel #8
0
        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;
        }
Beispiel #10
0
        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;
        }
Beispiel #11
0
        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);
            }
        }
Beispiel #14
0
        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("发放完成");
        }
Beispiel #15
0
        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
        }
Beispiel #17
0
        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;
                    }
                }
            }
        }
Beispiel #18
0
        //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);
        }
Beispiel #19
0
        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);
            }
        }
Beispiel #20
0
        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);
                    }
                }
            }
        }
Beispiel #21
0
        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;
            }
        }
Beispiel #22
0
        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);
            }
        }
Beispiel #23
0
        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("保存成功");
        }//函数结束