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(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; } } } }