using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using web;
using System.Data;
using System.Data.SqlClient;

public partial class control_TreasureLevelup : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (base.Session["userid"] == null)
        {
            base.Response.Redirect("login.aspx?returnurl=" + base.Request.ServerVariables["SCRIPT_NAME"]);
        }
        else if (!this.Page.IsPostBack)
        {
            bind();
        }
    }
    protected void btnedit_Click(object sender, EventArgs e)
    {
        int useridx = int.Parse(base.Session["useridx"].ToString());
        string str = levelup(base.Session["userid"].ToString(), useridx);

    

        base.Response.Write("<script language=javascript>alert('" + str + "')</script>");

        bind();
    }

    private void bind()
    {
        string sql = @"SELECT a.[ITEM_DBIDX]
,a.[ITEM_IDX]
,a.[ITEM_PARAM]
,b.olditemname
,b.newitemid
,cast(a.[ITEM_DBIDX] as varchar(20)) + '|' + cast(b.newitemid as varchar(20)) as xxx
,b.gold
,b.olditemname + ' | ' + cast(b.gold as varchar(20))+ '元寶' as names
FROM [MHGame].[dbo].[TB_ITEM] a join [MHGame].[dbo].TB_ITEM_Levelup b on a.ITEM_IDX=b.olditemid
join [MHGame].[dbo].TB_CHARACTER c on a.CHARACTER_IDX=c.CHARACTER_IDX 
where c.user_idx=" + base.Session["useridx"].ToString();

        DataTable tb = new DataProviders().ExecuteSqlDs(sql, "TB_ITEM_Levelup").Tables[0];

        Session["xxx"] = tb;
        this.ddpetlist.DataSource = tb;
        this.ddpetlist.DataTextField = "names";
       // this.ddpetlist.DataValueField = "ITEM_DBIDX";
        this.ddpetlist.DataValueField = "xxx";
        this.ddpetlist.DataBind();

    }
    public string levelup(string userid, int useridx)
    {
        int num;
        SqlParameter[] parameters = new SqlParameter[] { 
            new SqlParameter("@userid", SqlDbType.VarChar, 50), 
            new SqlParameter("@useridx", SqlDbType.Int, 8), 
            new SqlParameter("@ITEM_DBIDX", SqlDbType.Int, 8) ,
          new SqlParameter("@ITEM_DBIDX2", SqlDbType.NVarChar, 50) 
        };
        parameters[0].Value = userid;
        parameters[1].Value = useridx;
        parameters[2].Value = int.Parse(ddpetlist.SelectedItem.Value.Split('|')[0]);
        parameters[3].Value = int.Parse(ddpetlist.SelectedItem.Value.Split('|')[1]);
        switch (new DataProviders().RunProcedure("Web_TreasureLevelUP", parameters, out num))
        {
            case 0:
                return "升級成功，請登陸遊戲吧。";

            case 1:
                return "請先退出遊戲至登陸界面後再進行升級操作！";

            case 2:
                return "1物品不存在！";

            case 3:
                return "2物品不存在！";

            case 4:
                return "你的元寶不夠哦！";

            default: return "系統級錯誤，請聯繫管理員！";
        }

    }
}