ET9_WebGL_Base/CSharp/App/Modules/Robot/RobotView.xaml.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel.Composition;
using System.IO;
using System.Windows;
using Infrastructure;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

namespace Robot
{
    /// <summary>
    /// RobotView.xaml 的交互逻辑
    /// </summary>
    [ViewExport(RegionName = "RobotRegion"), PartCreationPolicy(CreationPolicy.NonShared)]
    public partial class RobotView
    {
        public RobotView()
        {
            this.InitializeComponent();
        }

        [Import]
        private RobotViewModel ViewModel
        {
            get
            {
                return this.DataContext as RobotViewModel;
            }
            set
            {
                this.DataContext = value;
            }
        }

        private void menuReload_Click(object sender, RoutedEventArgs e)
        {
            this.ViewModel.Reload();
        }

        private async void btnFindPlayer_Click(object sender, RoutedEventArgs e)
        {
            await this.ViewModel.GetCharacterInfo();
            this.tcCharacterInfo.IsEnabled = true;
            this.btnForbidCharacter.IsEnabled = true;
            this.btnAllowCharacter.IsEnabled = true;
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private void menuLogin_Click(object sender, RoutedEventArgs e)
        {
            this.ViewModel.ReLogin();
        }

        private async void menuServers_Click(object sender, RoutedEventArgs e)
        {
            await this.ViewModel.Servers();
            this.tcAll.SelectedIndex = 0;
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private async void btnForbidCharacter_Click(object sender, RoutedEventArgs e)
        {
            await
                    this.ViewModel.ForbidCharacter(this.cbForbiddenType.SelectedValue.ToString(),
                            this.tbForbiddenTime.Text);
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private async void btnAllowCharacter_Click(object sender, RoutedEventArgs e)
        {
            await
                    this.ViewModel.ForbidCharacter(this.cbForbiddenType.SelectedValue.ToString(),
                            "-1");
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private async void btnSendCommand_Click(object sender, RoutedEventArgs e)
        {
            await this.ViewModel.SendCommand();
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private async void btnForbiddenLogin_Click(object sender, RoutedEventArgs e)
        {
            await
                    this.ViewModel.ForbiddenLogin(this.cbForbiddenLogin.SelectedValue.ToString(),
                            this.tbForbiddenLoginContent.Text, this.tbForbiddenLoginTime.Text);
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private async void btnAllowLogin_Click(object sender, RoutedEventArgs e)
        {
            await
                    this.ViewModel.ForbiddenLogin(this.cbForbiddenLogin.SelectedValue.ToString(),
                            this.tbForbiddenLoginContent.Text, "-1");
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private async void btnSendMail_Click(object sender, RoutedEventArgs e)
        {
            await this.ViewModel.SendMail();
            this.tbLog.AppendText(Environment.NewLine + this.ViewModel.ErrorInfo);
            this.tbLog.ScrollToEnd();
        }

        private void btnExcel_Click(object sender, RoutedEventArgs e)
        {
            var dict = new Dictionary<string, int>
            {
                { "英雄令", 1 },
                { "英雄令材料", 2 },
                { "双倍", 3 },
                { "会员", 4 },
                { "聊天", 5 },
                { "材料", 6 },
                { "印记页", 7 },
                { "血统页", 8 },
                { "坐骑", 9 },
                { "染色", 10 },
                { "星之魂玉", 11 },
                { "月之魂玉", 12 },
                { "日之魂玉", 13 },
                { "技能书", 14 },
                { "混沌之玉", 15 },
                { "战绩", 16 },
                { "坐骑翅膀", 17 },
                { "变身", 18 },
                { "将星", 19 },
                { "平台装备", 20 },
                { "将星装备", 21 },
                { "血魄", 22 },
                { "装饰", 23 },
                { "烟花", 24 },
                { "英雄礼包", 25 },
                { "套装", 26 },
            };

            HSSFWorkbook hssfWorkbook;
            const string path = @"F:\MallItemProto.xls";
            using (var file = new FileStream(path, FileMode.Open, FileAccess.Read))
            {
                hssfWorkbook = new HSSFWorkbook(file);
            }
            var sheet = hssfWorkbook.GetSheetAt(0);
            IEnumerator rows = sheet.GetRowEnumerator();

            const int nameIndex = 'Z' - 'A';
            rows.MoveNext();
            rows.MoveNext();
            rows.MoveNext();
            rows.MoveNext();
            while (rows.MoveNext())
            {
                var row = (HSSFRow) rows.Current;
                if (row.GetCell(nameIndex) == null)
                {
                    continue;
                }
                var name = row.GetCell(nameIndex).ToString();

                if (!dict.ContainsKey(name))
                {
                    continue;
                }

                ICell cell = row.GetCell(nameIndex - 1) ?? row.CreateCell(nameIndex - 1);
                cell.SetCellValue(dict[name].ToString());
            }

            using (var file = new FileStream(path, FileMode.Open, FileAccess.Write))
            {
                hssfWorkbook.Write(file);
            }
            this.lblShowResult.Content = "OK";
        }
    }
}