TG.WXCRM.V4/WEB/Controllers/Sms/SmsQueryAmtController.cs

using System;
using System.Web.Mvc;
using WX.CRM.Common;
using WX.CRM.IBLL.Sms;
using WX.CRM.WebHelper;

namespace WX.CRM.WEB.Controllers.Sms
{
    public class SmsQueryAmtController : BaseController
    {
        private readonly ISMS_ACCOUNT_Q _smsAccountQ;
        public SmsQueryAmtController(ISMS_ACCOUNT_Q q)
        {
            _smsAccountQ = q;
        }

        public ActionResult Index()
        {
            var tableId = "tablist";
            var tab = new Table(tableId);
            tab.AddHeadCol("CLIENTCODE", "10%", "帐号代码 ");
            tab.AddHeadCol("CLIENTNAME", "10%", "短信平台 ");
            tab.AddHeadCol("DISABLED", "10%", "是否禁用");
            tab.AddHeadCol("SORTNO", "10%", "排序号");
            tab.AddHeadCol("SMSSP_CODE", "10%", "短信平台代码");
            tab.AddHeadCol("SMSACCOUNT", "10%", "用户名 ");
            tab.AddHeadCol("REMARK", "", "备注");
            tab.AddHeadCol("amt", "", "帐户余额");
            tab.AddHeadRow();

            ViewBag.List = tab.GetTable();
            return View();
        }

        public JsonResult GetHtmlList(Pager pager, string columns)
        {

            var table = new Table(columns, true);
            var list = _smsAccountQ.GetList();
            table.gridPager = pager;
            foreach (var model in list)
            {
                if ("ENT,ENT2,YX,HJ,HJ2".IndexOf(model.SMSSP_CODE.Trim()) >= 0)
                {
                    table.AddCol(model.CLIENTCODE);
                    table.AddCol(model.CLIENTNAME);
                    table.AddCol(model.DISABLED == 0 ? "是" : "否");
                    table.AddCol(model.SORTNO);
                    table.AddCol(model.SMSSP_CODE);
                    table.AddCol(model.SMSACCOUNT);
                    table.AddCol(model.REMARK);
                    table.AddCol(GetMoney(model.SMSSP_CODE, model.EXTINFO1, model.SMSACCOUNT, model.SMSPASSWORD));
                    table.AddRow();
                }
            }
            var json = new
            {

                rowsList = table.GetRows()
            };
            return Json(json, JsonRequestBehavior.AllowGet);
        }
        public string GetMoney(string interfaceId, string basurl, string account, string password)
        {
            //string ent_url = "http://222.73.107.12:9016/gateway/quota?userid={0}&pwd={1}"; //
            //string yx_url = "http://mt.yeion.com/userinfo.do?Account={0}&Password={1}";
            //string hj_url = "http://www.qymas.com/smsSendServlet.htm?command=balance&uid={0}&flag=1&rstype=text";

            string money = "";
            string url = "";
            string results = "";
            switch (interfaceId.Trim())
            {
                case "ENT":
                    url = string.Format("{0}?userid={1}&pwd={2}", basurl, account, password);
                    break;
                case "ENT2":
                    url = string.Format("{0}?userid={1}&pwd={2}", basurl, account, password);
                    break;
                case "YX":
                    url = string.Format("{0}?Account={1}&Password={2}", basurl, account, password);
                    break;
                case "HJ":
                    url = string.Format("{0}?command=balance&uid={1}&flag=1&rstype=text", basurl, account);
                    break;
                case "HJ2":
                    url = string.Format("{0}?command=balance&uid={1}&flag=1&rstype=text", basurl, account);
                    break;
            }
            try
            {
                if (url == "")
                    return money = "查询地址为空";

                results = Utility.PostData(url, System.Text.Encoding.UTF8);
                if (interfaceId.Trim() == "ENT" || interfaceId.Trim() == "ENT2")
                {
                    money = results;
                }
                if (interfaceId.Trim() == "YX")
                {
                    YueXin yx = Utility.JSONToObject<YueXin>(results);
                    if (yx.code == "9001")
                    {
                        money = yx.money;
                    }
                    else
                    {
                        money = yx.code;
                    }
                }
                if (interfaceId.Trim() == "HJ" || interfaceId.Trim() == "HJ2")
                {
                    results = results.Replace("\r", "").Replace("\n", "");
                    switch (results)
                    {
                        case "1":
                            money = "非法uid";
                            break;
                        case "3":
                            money = "余额不足";
                            break;
                        case "5":
                            money = "参数错误";
                            break;
                        case "9":
                            money = "提交失败";
                            break;
                        default:
                            money = results.Substring(2);
                            break;
                    }
                }
            }
            catch (Exception ex)
            {
                money = "Error！";
                LogHelper.Error("SmsQueryAmtController:" + ex.Message + ex.StackTrace);
            }
            return money;
        }
        public class YueXin
        {
            public string username { get; set; }
            public string price { get; set; }
            public string msgNum { get; set; }
            public string money { get; set; }
            public string code { get; set; }
            public string suffix { get; set; }
        }
    }
}