Esempio n. 1
0
        public static string Insert(string gift_id, string sys_user_id, string USER, string TOKEN)
        {
            if (!AccessToken.Read(USER, TOKEN))
            {
                return("登录超时");
            }

            IDictionary <string, string> fdict = new Dictionary <string, string>();

            fdict.Add("id", gift_id);
            fdict.Add("delete_flag", "IS NULL");
            DataSet ds = DBHelper.Select("gift", "title,price,inventory,off_shelf_datetime", string.Empty, fdict, "and");

            if (ds.Tables[0].Rows.Count == 0)
            {
                return("礼品不存在");
            }
            string title              = ds.Tables[0].Rows[0]["title"].ToString();
            string price              = ds.Tables[0].Rows[0]["price"].ToString();
            string inventory          = ds.Tables[0].Rows[0]["inventory"].ToString();
            string off_shelf_datetime = ds.Tables[0].Rows[0]["off_shelf_datetime"].ToString();

            if (inventory.Length > 0 && (Convert.ToInt32(inventory) < 1))
            {
                return("礼品库存不足");
            }
            if (off_shelf_datetime.Length > 0 && (Convert.ToDateTime(off_shelf_datetime) < DateTime.Today))
            {
                return("礼品已下架");
            }

            fdict = new Dictionary <string, string>();
            fdict.Add("id", sys_user_id);
            fdict.Add("delete_flag", "IS NULL");
            ds = DBHelper.Select("sys_user", "balance", string.Empty, fdict, "and");
            if (ds.Tables[0].Rows.Count == 0)
            {
                return("用户不存在");
            }
            if (Convert.ToInt32(ds.Tables[0].Rows[0]["balance"]) < Convert.ToInt32(price))
            {
                return("爱心不足");
            }

            using (MySqlConnection dbConnection = new MySqlConnection(DBHelper.strConnection))
            {
                dbConnection.Open();
                using (MySqlTransaction trans = dbConnection.BeginTransaction())
                {
                    IDictionary <string, string> dict = new Dictionary <string, string>();
                    dict.Add("gift_id", gift_id);
                    dict.Add("sys_user_id", sys_user_id);
                    dict.Add("buy_datetime", DateTime.Now.ToString());
                    DBHelper.Insert("gift_history", dict, dbConnection, trans);

                    dict = new Dictionary <string, string>();
                    dict.Add("balance", "数字相减-" + price);
                    fdict = new Dictionary <string, string>();
                    fdict.Add("id", sys_user_id);
                    DBHelper.Update("sys_user", dict, fdict, "and", dbConnection, trans);

                    sys_user_balance_change.Insert(sys_user_id, "4", "-" + price, "兑换“" + title + "”", "gift", gift_id, dbConnection, trans);

                    if (inventory.Length > 0)
                    {
                        dict = new Dictionary <string, string>();
                        dict.Add("inventory", "数字相减-1");
                        fdict = new Dictionary <string, string>();
                        fdict.Add("id", gift_id);
                        DBHelper.Update("gift", dict, fdict, "and", dbConnection, trans);
                    }

                    trans.Commit();
                }
            }
            return(string.Empty);
        }
        public static string Insert(string football_round_chain_id, string sys_user_id, string football_match_id, string match_result_id, string football_match_ids, string USER, string TOKEN)
        {
            if (!AccessToken.Read(USER, TOKEN))
            {
                return("登录超时");
            }

            IDictionary <string, string> fdict = new Dictionary <string, string>();

            fdict.Add("id", football_round_chain_id);
            fdict.Add("delete_flag", "IS NULL");
            DataSet ds = DBHelper.Select("football_round_chain", "participant_amount,name", string.Empty, fdict, "and");

            if (ds.Tables[0].Rows.Count == 0)
            {
                return("竞猜不存在");
            }
            string participant_amount        = ds.Tables[0].Rows[0]["participant_amount"].ToString();
            string football_round_chain_name = ds.Tables[0].Rows[0]["name"].ToString();

            string[] football_match_idarr = football_match_ids.Split(',');
            if (football_match_idarr.Length != Convert.ToInt32(participant_amount))
            {
                return("接龙长度异常");
            }

            fdict = new Dictionary <string, string>();
            fdict.Add("id", sys_user_id);
            fdict.Add("delete_flag", "IS NULL");
            ds = DBHelper.Select("sys_user", "balance", string.Empty, fdict, "and");
            if (ds.Tables[0].Rows.Count == 0)
            {
                return("用户不存在");
            }
            if (Convert.ToInt32(ds.Tables[0].Rows[0]["balance"]) < 6)
            {
                return("爱心不足6元");
            }

            using (MySqlConnection dbConnection = new MySqlConnection(DBHelper.strConnection))
            {
                dbConnection.Open();
                using (MySqlTransaction trans = dbConnection.BeginTransaction())
                {
                    IDictionary <string, string> dict = new Dictionary <string, string>();
                    dict.Add("football_round_chain_id", football_round_chain_id);
                    dict.Add("sys_user_id", sys_user_id);
                    dict.Add("participant_need", (Convert.ToInt32(participant_amount) - 1).ToString());
                    dict.Add("chain_vote_status_id", "1");
                    dict.Add("vote_datetime", DateTime.Now.ToString());
                    DBHelper.Insert("football_round_chain_vote", dict, dbConnection, trans);

                    string football_round_chain_vote_id = DBHelper.SelectNewId(dbConnection, trans);

                    dict = new Dictionary <string, string>();
                    dict.Add("football_round_chain_vote_id", football_round_chain_vote_id);
                    dict.Add("sys_user_id", sys_user_id);
                    dict.Add("football_match_id", football_match_id);
                    dict.Add("match_result_id", match_result_id);
                    dict.Add("vote_datetime", DateTime.Now.ToString());
                    DBHelper.Insert("football_round_chain_vote_invite", dict, dbConnection, trans);

                    foreach (string football_match_idi in football_match_idarr)
                    {
                        if (football_match_idi.Equals(football_match_id))
                        {
                            continue;
                        }

                        dict = new Dictionary <string, string>();
                        dict.Add("football_round_chain_vote_id", football_round_chain_vote_id);
                        dict.Add("football_match_id", football_match_idi);
                        DBHelper.Insert("football_round_chain_vote_invite", dict, dbConnection, trans);
                    }

                    dict = new Dictionary <string, string>();
                    dict.Add("balance", "数字相减-6");
                    fdict = new Dictionary <string, string>();
                    fdict.Add("id", sys_user_id);
                    DBHelper.Update("sys_user", dict, fdict, "and", dbConnection, trans);

                    sys_user_balance_change.Insert(sys_user_id, "2", "-6", "发起接龙“" + football_round_chain_name + "”", "football_round_chain_vote", football_round_chain_vote_id, dbConnection, trans);


                    trans.Commit();
                }
            }
            return(string.Empty);
        }
        public static string End(string id, string USER, string TOKEN)
        {
            if (!AccessToken.Read(USER, TOKEN))
            {
                return("登录超时");
            }

            IDictionary <string, string> fdict = new Dictionary <string, string>();

            fdict.Add("football_round_chain_vote_id", id);
            DataSet ds = DBHelper.Select("football_round_chain_vote_invite_view", "*", string.Empty, fdict, "and");

            if (ds.Tables[0].Rows.Count == 0)
            {
                return("找不到该记录");
            }
            string price = ds.Tables[0].Rows[0]["price"].ToString();
            string title = ds.Tables[0].Rows[0]["football_round_name"] + " " + ds.Tables[0].Rows[0]["football_round_chain_name"];

            string chain_vote_status_id = "2";

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                if (dr["vote_sys_user_id"].ToString().Length == 0)
                {
                    return("接龙未完成");
                }
                if (dr["match_result_id"].ToString().Length == 0)
                {
                    return("仍有比赛未完成");
                }
                if (!dr["match_result_id"].Equals(dr["vote_match_result_id"]))
                {
                    chain_vote_status_id = "3";
                }
            }

            using (MySqlConnection dbConnection = new MySqlConnection(DBHelper.strConnection))
            {
                dbConnection.Open();
                using (MySqlTransaction trans = dbConnection.BeginTransaction())
                {
                    IDictionary <string, string> dict = new Dictionary <string, string>();
                    dict.Add("chain_vote_status_id", chain_vote_status_id);
                    fdict = new Dictionary <string, string>();
                    fdict.Add("id", id);
                    DBHelper.Update("football_round_chain_vote", dict, fdict, "and", dbConnection, trans);

                    if (chain_vote_status_id.Equals("2") && (price.Length > 0))
                    {
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            dict = new Dictionary <string, string>();
                            dict.Add("balance", "数字相加+" + price);
                            fdict = new Dictionary <string, string>();
                            fdict.Add("id", dr["vote_sys_user_id"].ToString());
                            DBHelper.Update("sys_user", dict, fdict, "and", dbConnection, trans);

                            sys_user_balance_change.Insert(dr["vote_sys_user_id"].ToString(), "2", price, title, "football_round_chain_vote", id, dbConnection, trans);
                        }
                    }

                    trans.Commit();
                }
            }
            return(string.Empty);
        }
Esempio n. 4
0
        public static string Insert(string football_match_id, string sys_user_id, string match_result_id, string amount, string USER, string TOKEN)
        {
            if (!AccessToken.Read(USER, TOKEN))
            {
                return("登录超时");
            }

            if (amount.Length == 0 || Convert.ToInt32(amount) <= 0)
            {
                return("竞拍额异常");
            }

            IDictionary <string, string> fdict = new Dictionary <string, string>();

            fdict.Add("id", sys_user_id);
            fdict.Add("delete_flag", "IS NULL");
            DataSet ds = DBHelper.Select("sys_user", "balance", string.Empty, fdict, "and");

            if (ds.Tables[0].Rows.Count == 0)
            {
                return("用户不存在");
            }
            if (Convert.ToInt32(ds.Tables[0].Rows[0]["balance"]) < Convert.ToInt32(amount))
            {
                return("爱心不足");
            }

            fdict = new Dictionary <string, string>();
            fdict.Add("id", football_match_id);
            fdict.Add("vote_deadline", ">='" + DateTime.Now.ToString() + "'");
            ds = DBHelper.Select("football_match_view", "id,football_round_name,home_football_team_name,away_football_team_name", string.Empty, fdict, "and");
            if (ds.Tables[0].Rows.Count == 0)
            {
                return("竞猜已结束");
            }
            string round_name = ds.Tables[0].Rows[0]["football_round_name"].ToString();
            string home_football_team_name = ds.Tables[0].Rows[0]["home_football_team_name"].ToString();
            string away_football_team_name = ds.Tables[0].Rows[0]["away_football_team_name"].ToString();

            fdict = new Dictionary <string, string>();
            fdict.Add("football_match_id", football_match_id);
            fdict.Add("sys_user_id", sys_user_id);
            ds = DBHelper.Select("football_match_vote", "id,match_result_id,amount", string.Empty, fdict, "and");

            using (MySqlConnection dbConnection = new MySqlConnection(DBHelper.strConnection))
            {
                dbConnection.Open();
                using (MySqlTransaction trans = dbConnection.BeginTransaction())
                {
                    IDictionary <string, string> dict = new Dictionary <string, string>();
                    if (ds.Tables[0].Rows.Count == 0)
                    {
                        dict.Add("football_match_id", football_match_id);
                        dict.Add("sys_user_id", sys_user_id);
                        dict.Add("match_result_id", match_result_id);
                        dict.Add("amount", amount);
                        dict.Add("vote_datetime", DateTime.Now.ToString());
                        DBHelper.Insert("football_match_vote", dict, dbConnection, trans);
                    }
                    else
                    {
                        if (amount.Equals(ds.Tables[0].Rows[0]["amount"].ToString()) && match_result_id.Equals(ds.Tables[0].Rows[0]["match_result_id"].ToString()))
                        {
                            return(string.Empty);
                        }

                        dict.Add("match_result_id", match_result_id);
                        dict.Add("amount", amount);
                        dict.Add("vote_datetime", DateTime.Now.ToString());
                        fdict = new Dictionary <string, string>();
                        fdict.Add("id", ds.Tables[0].Rows[0]["id"].ToString());
                        DBHelper.Update("football_match_vote", dict, fdict, "and", dbConnection, trans);
                        amount = (Convert.ToInt32(amount) - Convert.ToInt32(ds.Tables[0].Rows[0]["amount"])).ToString();
                    }

                    dict = new Dictionary <string, string>();
                    dict.Add("balance", "数字相减-" + amount);
                    fdict = new Dictionary <string, string>();
                    fdict.Add("id", sys_user_id);
                    DBHelper.Update("sys_user", dict, fdict, "and", dbConnection, trans);

                    sys_user_balance_change.Insert(sys_user_id, "3", "-" + amount, round_name + " " + home_football_team_name + "VS" + away_football_team_name + " " + dict_match_result.GetName(match_result_id), "football_match", football_match_id, dbConnection, trans);

                    trans.Commit();
                }
            }
            return(string.Empty);
        }