using dccdc.BLL;
using System;
using System.Collections.Generic;
using System.Data;
using System.Globalization;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using dccdc.DAL;
using dccdc.Models;
using static dccdc.Controllers.DictionariesController;
using static dccdc.Controllers.QueryStatisticsController;
using Aliyun.Acs.Core.Profile;
using Aliyun.Acs.Core;
using Aliyun.Acs.Dysmsapi.Model.V20170525;
using System.Reflection;
using Aliyun.Acs.Core.Exceptions;
using dccdc.Models.DTO;
using System.IO;
using NPOI.HSSF.UserModel;
using NPOI.HPSF;
using NPOI.HSSF.Util;
using NPOI.POIFS.FileSystem;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System.Net;
using System.Security.Cryptography;
using System.Text;

namespace dccdc.Controllers
{
    public class Charge4Controller : Controller
    {
        public ActionResult ymzs()
        {
            return View();
        }
        public ActionResult tfsq()
        {
            return View();
        }
        public ActionResult YMDJJL()
        {
            return View();
        }

        public ActionResult getJFDJ(string xm)
        {
            var bll = new YMDJBll();
            var result = bll.getJFDJ(xm);
            return Json(new { Rows = result });
        }

        public ActionResult getTFDJ(string xm)
        {
            var bll = new YMDJBll();
            var result = bll.getTFDJ(xm);
            return Json(new { Rows = result });
        }

        public ActionResult saveTFSQ(string id)
        {
            var bll = new ymzsBll();
            OperationResult or = bll.tfsq(id, Session["loginUser"] as Models.ERPUser);
            return Json(new { State = or.State, Message = or.Message });
        }
        public ActionResult ZSYM(string id)
        {
            var bll = new ymzsBll();
            OperationResult or = bll.zsym(id, Session["loginUser"] as Models.ERPUser);
            return Json(new { State = or.State, Message = or.Message });
        }
        public ActionResult delDj(string id)
        {
            var bll = new YMDJBll();
            OperationResult or = bll.delDj(Session["loginUser"] as Models.ERPUser, id);
            return Json(new { State = or.State, Message = or.Message });
        }


        public ActionResult getYMDJMX(string ymdjbid)
        {
            var bll = new YMDJMXBll();
            var result = bll.getMX(ymdjbid);
            return Json(new { Rows = result });
        }


        // GET: Charge2
        public ActionResult Index()
        {
            ViewBag.jfbmD = new SelectList(new ERPBuMenBll().GetAllList(""), "bumenname", "bumenname", (Session["loginUser"] as Models.ERPUser).Department);
            ViewBag.jffs = new SelectList(new List<Droplist> { new Droplist { Value = "现金", Title = "现金" }, new Droplist { Value = "转账", Title = "转账" } }, "Value", "Title");
            ViewBag.rylb = new SelectList(new List<Droplist> { new Droplist { Value = "儿童", Title = "儿童" }, new Droplist { Value = "成人", Title = "成人" } }, "Value", "Title", "儿童");
            return View();
        }

        public String GetYmyyjl(string id)
        {
            var bll = new YMDJMXBll();
            var result = bll.getYmyyjl(id);
            return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        }

        public String GetJzymTmdy(string id)
        {
            var bll = new YMDJMXBll();
            var result = bll.GetJzymTmdy(id);
            return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        }

        public String GetYmsList(string ymList)
        {
            var bll = new YMDJMXBll();
            var result = bll.GetYmsList(ymList);
            return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        }

        public String GetYmjzlcList(string jdid)
        {
            var bll = new YMDJMXBll();
            var result = bll.GetYmjzlcList(jdid);
            return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        }

        public ActionResult getCharge(string start, string end, string tm)
        {
            if (string.IsNullOrEmpty(start) || string.IsNullOrEmpty(end))
                return Json(null);
            var bll = new chargeBll();

            var result = bll.GetAllList3(start, end, tm, (Session["loginUser"] as Models.ERPUser).TrueName);
            return Json(new { Rows = result });
        }

        #region 疫苗统计
        public ActionResult Ymtj()
        {
            return View();
        }

        public ActionResult Ymtj2()
        {
            return View();
        }
        [AllowAnonymous]
        public string getYmtjList(string rq, string xm, string alluser = "false")
        {
            if (string.IsNullOrEmpty(rq))
                return null;
            return Newtonsoft.Json.JsonConvert.SerializeObject(new BLL.chargeBll().getYmList(rq.Split('|')[0].ToString(), rq.Split('|')[1].ToString(), xm));
        }
        public string getYmtj(string start, string end, string alluser = "false")
        {
            if (string.IsNullOrEmpty(start) || string.IsNullOrEmpty(end))
                return "";
            var bll = new chargeBll();
            DataTable dt = new DataTable();
            dt.Columns.Add("ymname1", typeof(string));
            dt.Columns.Add("sl1", typeof(string));
            dt.Columns.Add("je1", typeof(string));
            dt.Columns.Add("ymname2", typeof(string));
            dt.Columns.Add("sl2", typeof(string));
            dt.Columns.Add("je2", typeof(string));

            var result = bll.getYmList(start, end, alluser == "true" ? "" : (Session["loginUser"] as Models.ERPUser).TrueName);
            int i = 1;
            if (result != null)
            {
                DataRow dr = dt.NewRow();
                foreach (var r in result)
                {
                    if (i % 2 != 0)
                    {
                        dr["ymname1"] = r.name;
                        dr["sl1"] = r.sl;
                        dr["je1"] = r.je;
                        if (result.Count() == i)
                        {
                            dr["ymname2"] = "";
                            dr["sl2"] = "";
                            dr["je2"] = "";
                            dt.Rows.Add(dr.ItemArray);
                        }
                    }
                    else
                    {
                        dr["ymname2"] = r.name;
                        dr["sl2"] = r.sl;
                        dr["je2"] = r.je;
                        dt.Rows.Add(dr.ItemArray);
                    }
                    i++;
                }
            }
            List<cols> cls = new List<cols>();
            cls.Add(new cols { name = "ymname1", display = "疫苗名称", width = 120 });
            cls.Add(new cols { name = "sl1", display = "数量", width = 120 });
            cls.Add(new cols { name = "je1", display = "金额", width = 120 });
            cls.Add(new cols { name = "ymname2", display = "疫苗名称", width = 120 });
            cls.Add(new cols { name = "sl2", display = "数量", width = 120 });
            cls.Add(new cols { name = "je2", display = "金额", width = 120 });
            var data = new { Rows = dt };
            return Newtonsoft.Json.JsonConvert.SerializeObject(new { columns = cls, data = data });
        }
        #endregion


        public ActionResult getSFXMData(string id, string sfxm)
        {
            var bll = new vaccineBll();
            var result = bll.getAllList(sfxm);
            return Json(new { Rows = result });
        }

        public JsonResult opSave(string jfdw, string register_num, string jfbm, string jffs, string ysje, string items, string jmsq, string jdbm, string ertbm)
        {
            if (string.IsNullOrEmpty(jfdw) || string.IsNullOrEmpty(items))
                return Json(new { count = 0 });
            var bll = new chargeBll();
            var result = bll.opSave1(jfdw, register_num, jfbm, jffs, ysje, items, Session["loginUser"] as Models.ERPUser, "疫苗收费", jmsq, jdbm, ertbm);// Session["loginUser"] as Models.ERPUser
            return Json(result);
        }

        public JsonResult getJZMYTM(string id)
        {
            var bll = new BLL.JiezhongmianyitiaomaModelBll();
            List<Models.JiezhongmianyitiaomaModel> ctList = bll.getList(id);
            if (ctList.Count > 0)
            {
                return Json(new { obj = ctList[0] });
            }
            else
            {
                return Json(new { obj = "" });
            }

        }

        public JsonResult getFJX(string id)
        {
            var bll = new BLL.ChargeProjectMaintainBll();
            List<Models.ChargeProjectMaintainModel> ctList = bll.getAddList(id);
            return Json(ctList);
        }

        #region 疫苗预约
        public ActionResult Jmyy(string ertbm)
        {
            ViewData["vaccine"] = new SelectList(new BLL.vaccineBll().getAllList(""), "id", "name");
            ViewData["ymjd"] = new SelectList(new BLL.ym_jzlcBll().getAllYMJDList(), "id", "name");
            ViewBag.ertbm = ertbm;



            var bll = new BLL.ym_jzlcBll();
            var list = bll.getAllListByErtbm(ertbm);
            ym_jzlcjl jl = bll.getYmjzlcjlByErtbm(ertbm);
            ym_jzlc lc = bll.getYmjzlcByErtbm(jl.jdid.ToString());
            DateTime dt1 = Convert.ToDateTime(jl.jzsj).AddDays(lc.jgts);
            ViewBag.yysj = dt1;

            ViewData["list"] = list;

            return View();
        }

        public String GetAllYmJzlc(string ertbm)
        {
            var bll = new BLL.ym_jzlcBll();
            var list = bll.getAllJzlcList(ertbm);
            return Newtonsoft.Json.JsonConvert.SerializeObject(new { Rows = list });
        }
        public JsonResult SaveYmyy(string ertbm, string yysj, string jdid, string yms)
        {
            ym_yyjl ymyy = new ym_yyjl();
            ymyy.ertbm = ertbm;
            ymyy.yysj = Convert.ToDateTime(yysj);
            ymyy.jdid = Convert.ToInt32(jdid);
            ymyy.ymList = yms.TrimStart(new char[] { ',' }).TrimEnd(new char[] { ',' });

            var bll = new chargeBll();
            var result = bll.saveYmyy(ymyy);

            return Json(result);
        }
        #endregion
        /// <summary>
        /// 减免申请
        /// </summary>
        /// <returns></returns>
        public ActionResult Jmsq(string chargeid)
        {
            ViewBag.chargeid = chargeid;
            return View();
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="chargeid"></param>
        /// <param name="jmlx"></param>
        /// <returns></returns>
        public JsonResult JmsqsfxmData(string chargeid, string jmlx)
        {
            charge_detailBll bll = new charge_detailBll();
            List<charge_detailModel> al = bll.GetModelsBychargeId(chargeid, jmlx);
            return Json(new { Rows = al });
            //根据疫苗ID获取收费项目  （根据减免类型查询不同收费项目）
        }

        /// <summary>
        /// 减免审核界面
        /// </summary>
        /// <returns></returns>
        public ActionResult JmsqListResult()
        {
            ViewBag.lx = new SelectList(new List<Droplist> { new Droplist { Value = "0", Title = "审核中" }, new Droplist { Value = "1", Title = "通过" }, new Droplist { Value = "2", Title = "未通过" } }, "Value", "Title");
            return View();
        }

        /// <summary>
        /// 获取减免申请列表
        /// </summary>
        /// <returns></returns>
        public JsonResult GetJmsqList(string lx, string xm, string sqsjb, string sqsje, string all)
        {
            DateTime dte;
            if (DateTime.TryParse(sqsje, out dte))
            {
                sqsje = (dte.AddDays(1)).ToString("yyyy-MM-dd");
            }
            JmsqBll bll = new JmsqBll();
            //此处参数配置根据管理员可查询不同减免类型数据先写死
            BLL.Common combll = new BLL.Common();
            string jffjid = combll.getParm_Value("jmfjid", "1", "可减免附件项的用户ID");
            string jfqbid = combll.getParm_Value("jmqbid", "1", "可减免全部项的用户ID");
            if (all == "true")
            {
                return Json(new { Rows = bll.GetJmsqList(lx, "-1", xm, sqsjb, sqsje) });
            }
            var user = Session["loginUser"] as Models.ERPUser;
            if (user.ID.ToString() == jfqbid)
            {
                string jmlx = "-1";

                return Json(new { Rows = bll.GetJmsqList(lx, jmlx, xm, sqsjb, sqsje) });
            }
            else if (user.ID.ToString() == jffjid)
            {
                string jmlx = "0";

                return Json(new { Rows = bll.GetJmsqList(lx, jmlx, xm, sqsjb, sqsje) });
            }
            else
            {
                return Json(new { Rows = new List<JmsqModel>() });
            }
        }
        public JsonResult expJMJL(string lx, string xm, string sqsjb, string sqsje, string all)
        {
            DateTime dte;
            if (DateTime.TryParse(sqsje, out dte))
            {
                sqsje = (dte.AddDays(1)).ToString("yyyy-MM-dd");
            }
            JmsqBll bll = new JmsqBll();
            //此处参数配置根据管理员可查询不同减免类型数据先写死
            BLL.Common combll = new BLL.Common();
            string jffjid = combll.getParm_Value("jmfjid", "1", "可减免附件项的用户ID");
            string jfqbid = combll.getParm_Value("jmqbid", "1", "可减免全部项的用户ID");
            DataTable expdt;
            if (all == "true")
            {
                expdt = bll.expJMJL(lx, "-1", xm, sqsjb, sqsje);
            }
            var user = Session["loginUser"] as Models.ERPUser;
            if (user.ID.ToString() == jfqbid)
            {
                string jmlx = "-1";

                expdt = bll.expJMJL(lx, jmlx, xm, sqsjb, sqsje);
            }
            else if (user.ID.ToString() == jffjid)
            {
                string jmlx = "0";

                expdt = bll.expJMJL(lx, jmlx, xm, sqsjb, sqsje);
            }
            else
            {
                return Json(new { State = 0, Message = "没有导出的数据" });

            }
            string path = Server.MapPath("~/export");
            if (!System.IO.Directory.Exists(path))
            {
                System.IO.Directory.CreateDirectory(path);
            }
            string fn = Guid.NewGuid().ToString("N") + ".xlsx";
            path += "\\" + fn;
            if (expdt == null)
            {
                return Json(new { State = 0, Message = "没有要导出的数据！" });
            }
            try
            {
                xiaoy.Excel.ExcelFile.SetData(expdt, path, xiaoy.Excel.ExcelVersion.Excel12, xiaoy.Excel.HDRType.Yes);
                return Json(new { State = 1, Message = Url.Content("~/export/" + fn) });
            }
            catch (Exception ex)
            {
                return Json(new { State = 0, Message = ex.Message });
            }
        }

        public ActionResult JmmxResult(string jmid)
        {
            ViewBag.jmid = jmid;
            return View();
        }
        public JsonResult GetJmmxList(string jmsqid)
        {
            JmmxBll bll = new JmmxBll();
            List<JmmxModel> models = bll.GetJmmxList(jmsqid);
            List<JmmxVModel> vmmodels = new List<JmmxVModel>();
            ChargeProjectMaintainBll bll1 = new ChargeProjectMaintainBll();
            List<ChargeProjectMaintainModel> sfxmal = bll1.GetAllList("", "是");
            foreach (var m in models)
            {
                JmmxVModel m1 = new JmmxVModel
                {
                    sfxm = sfxmal.First(i => i.id.ToString() == m.sfxmid).charge_project_name,
                    jmdj = Convert.ToDouble(m.jmdj),
                    sfxmid = Convert.ToInt32(m.sfxmid),
                    jmsl = m.jmsl
                };
                vmmodels.Add(m1);
            }

            return Json(new { Rows = vmmodels });
        }
        
        public JsonResult UpdateJmsqLx(string jmsqid, string lx)
        {
            JmsqBll bll = new JmsqBll();
            var erpUser = Session["loginUser"] as Models.ERPUser;
            Models.DTO.ymshjg f = bll.UpdateJmsq(jmsqid, lx, erpUser);
            if (f.jz != "")
            {
                var commonbll = new BLL.Common();
                string yddx = commonbll.getParm_Value("qyyddx", "false", "是否启用移动短信");
                f.sp = erpUser.TrueName;
                if (yddx == "false")
                {
                    
                    string AccessKeyID = commonbll.getParm_Value("AccessKeyID", "LTAIWq3410bmP7hi", "阿里AccessKeyID");
                    string AccessKeySecret = commonbll.getParm_Value("AccessKeySecret", "F953Ru3uZN2ZbS5741zvO9OvHrthNV", "阿里AccessKeySecret");
                    string qm = commonbll.getParm_Value("aldxqm", "三才网络", "短信签名");
                    string dxmb = commonbll.getParm_Value("aldxtzmb", "SMS_91930060", "短信模版");
                    //string smsurl = System.Configuration.ConfigurationManager.AppSettings["smsurl"];
                    //string yznr = "你好，欢迎你注册天瑞体检中心会员，你的验证码是：" + yzm.smscode + "。有效期10分钟。回TD退订【天瑞体检】";
                    //var zysms = new zyer.smsservice.SmsServiceSoapClient("SmsServiceSoap");
                    //var smsjg = zysms.SendEx(username, userpassword, "808", sjh, "", yznr);
                    //var fz = Session["FenZhan"] as Model.FenZhan;
                    //Common.SendMsg.Send(sjh, yznr, fz.id);
                    String product = "Dysmsapi";//短信API产品名称
                    String domain = "dysmsapi.aliyuncs.com";//短信API产品域名
                    String accessKeyId = AccessKeyID;//你的accessKeyId
                    String accessKeySecret = AccessKeySecret;//你的accessKeySecret

                    IClientProfile profile = DefaultProfile.GetProfile("cn-hangzhou", accessKeyId, accessKeySecret);
                    //IAcsClient client = new DefaultAcsClient(profile);
                    // SingleSendSmsRequest request = new SingleSendSmsRequest();

                    DefaultProfile.AddEndpoint("cn-hangzhou", "cn-hangzhou", product, domain);
                    IAcsClient acsClient = new DefaultAcsClient(profile);
                    SendSmsRequest request = new SendSmsRequest();
                    try
                    {
                        //必填:待发送手机号。支持以逗号分隔的形式进行批量调用，批量上限为20个手机号码,批量调用相对于单条调用及时性稍有延迟,验证码类型的短信推荐使用单条调用的方式
                        request.PhoneNumbers = commonbll.getParm_Value("ymjmdxtz", "18653582965", "疫苗减免通知手机");
                        //必填:短信签名-可在短信控制台中找到
                        request.SignName = qm;
                        //必填:短信模板-可在短信控制台中找到
                        request.TemplateCode = dxmb;
                        //可选:模板中的变量替换JSON串,如模板内容为"亲爱的${name},您的验证码为${code}"时,此处的值为
                        request.TemplateParam = Newtonsoft.Json.JsonConvert.SerializeObject(f);
                        //可选:outId为提供给业务方扩展字段,最终在短信回执消息中将此值带回给调用者
                        //request.OutId = "21212121211";
                        //请求失败这里会抛ClientException异常
                        SendSmsResponse sendSmsResponse = acsClient.GetAcsResponse(request);

                        //System.Console.WriteLine(sendSmsResponse.Message);
                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(sendSmsResponse.Message);

                    }
                    catch (ServerException e)
                    {
                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);
                        //System.Console.WriteLine("Hello World!");
                        //return Json(new { State = 0, Message = e.Message});
                    }
                    catch (ClientException e)
                    {
                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);
                        //return Json(new { State = 0, Message = e.Message});
                    }
                }
                else
                {
                    //http://112.35.1.155:1992/sms/norsubmit
                    string ydhttp = commonbll.getParm_Value("ydhttp", "http://112.35.1.155:1992/sms/tmpsubmit", "移动短信地址");
                    var req = new Models.duanxin.msend();
                    req.ecName = commonbll.getParm_Value("yddxqymc", "德州市德城区疾病预防控制中心", "企业名称");
                    req.apId = commonbll.getParm_Value("yddxapId", "jkoa", "接口账号用户名");
                    req.mobiles = commonbll.getParm_Value("ymjmdxtz", "18653582965", "疫苗减免通知手机");
                    req.sign = commonbll.getParm_Value("yddxsign", "d37CYmrbG", "签名编码");
                    //req.content = "由" + f.sp + "审批的疫苗缴费减免已生效；接种者" + f.jz + "应缴费" + f.yj + "实际缴费" + f.sj;
                    req.templateId = "44b9ed56aebc4b8fb4014f7c4c0ff00d";
                    req.addSerial = "";

                    string[] parms = new string[4];
                    parms[0] = f.sp;
                    parms[1] = f.jz;
                    parms[2] = f.yj;
                    parms[3] = f.sj;
                    req.parms = Newtonsoft.Json.JsonConvert.SerializeObject(parms);
                    var md5 = MD5.Create();
                    //secretKey
                    var bs = md5.ComputeHash(Encoding.UTF8.GetBytes(req.ecName + req.apId + commonbll.getParm_Value("yddxsecretKey", "a7551898", "短信接口密码") + req.templateId + req.mobiles + req.parms + req.sign));
                    var sb = new StringBuilder();
                    foreach (byte b in bs)
                    {
                        sb.Append(b.ToString("x2"));
                    }
                    req.mac = sb.ToString().ToLower();
                    WebClient wc = new WebClient();
                    string upstr = Newtonsoft.Json.JsonConvert.SerializeObject(req);
                    upstr = upstr.Replace("parms", "params");
                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(upstr);
                    //new {params }
                    //upstr.Insert(upstr.Length-1,",")
                    byte[] resp = wc.UploadData(ydhttp, System.Text.Encoding.UTF8.GetBytes(Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(upstr))));
                    var nres = Newtonsoft.Json.JsonConvert.DeserializeObject<Models.duanxin.nrecive>(System.Text.Encoding.UTF8.GetString(resp));
                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(System.Text.Encoding.UTF8.GetString(resp));
                }
            }
            return Json(new { State = 1, Message = "操作成功！" },JsonRequestBehavior.AllowGet);
        }

        public JsonResult jmsqAdd(string chargeid, string jmlx, string ids)
        {
            JmsqDal dal = new JmsqDal();
            charge_detailBll bll = new charge_detailBll();
            List<JmmxModel> al = new List<JmmxModel>();
            List<charge_detailModel> chargeDetailModels = bll.GetModelsBychargeId(chargeid, jmlx, ids);
            chargeBll chbll = new chargeBll();
            var chm = chbll.getModel(chargeid);
            YMDJBll ymbll = new YMDJBll();
            var ymdjm = ymbll.getDJByChargeID(chargeid);
            var erpUser = Session["loginUser"] as Models.ERPUser;
            if (erpUser != null)
            {
                JmsqModel model = new JmsqModel
                {
                    lx = 0,
                    jmlx = Convert.ToInt32(jmlx),
                    sqrid = erpUser.ID,
                    sqrxm = erpUser.TrueName,
                    sqsj = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
                    xm = chm.person,
                    ymdjid = ymdjm.id.ToString()
                };
                foreach (charge_detailModel m in chargeDetailModels)
                {
                    JmmxModel m1 = new JmmxModel
                    {
                        jmdj = m.money,
                        jmsl = m.count,
                        jmsqid = 1,
                        sfxmid = m.projectid,
                        detailid = m.id
                    };
                    al.Add(m1);
                }

                bool f = dal.Add(model, al);
            }
            return Json(new { State = 1, Message = "申请成功！" });
        }


        public ActionResult YMZSJL()
        {
            return View();
        }

        public JsonResult getYMZSJL(int page, int pagesize, ymzscxm cx)
        {
            var bll = new BLL.ymzsBll();
            int count = bll.getZSCount(cx);
            var list = bll.getZSList(page, pagesize, cx);
            return Json(new { Total = count, Rows = list });
        }
        public JsonResult getYMDJJL(int page, int pagesize, string zsr, string djr, string djsjb, string djsje)
        {
            var bll = new BLL.YMDJBll();
            int count = bll.getDJCount(zsr, djr, djsjb, djsje);
            var list = bll.getDJList(page, pagesize, zsr, djr, djsjb, djsje);
            return Json(new { Total = count, Rows = list });
        }

        public ActionResult ymjmshjl()
        {
            ViewBag.lx = new SelectList(new List<Droplist> { new Droplist { Value = "0", Title = "审核中" }, new Droplist { Value = "1", Title = "通过" }, new Droplist { Value = "2", Title = "未通过" } }, "Value", "Title");
            return View();
        }

        public JsonResult delJMSQ(int id)
        {
            var erpUser = Session["loginUser"] as Models.ERPUser;
            return Json(new BLL.JmsqBll().delJMSQ(id, erpUser));
        }

        //儿童疫苗导入
        public ActionResult etdr()
        {
            return View();
        }
        public string impETDR(string drsj)
        {
            if (Request.Files.Count == 0)
            {
                return Newtonsoft.Json.JsonConvert.SerializeObject(new { State = 0, Message = "没有要处理的文件" });
            }
            else
            {
                try
                {
                    string path = Server.MapPath("~/exec/");
                    if (!Directory.Exists(path))
                    {
                        Directory.CreateDirectory(path);
                    }
                    path = path + Guid.NewGuid().ToString("N") + Request.Files[0].FileName.Substring(Request.Files[0].FileName.LastIndexOf("."));
                    Request.Files[0].SaveAs(path);
                    FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);
                    HSSFWorkbook workbook = null;


                    workbook = new HSSFWorkbook(fs);
                    HSSFSheet sheet = workbook.GetSheetAt(0) as HSSFSheet;
                    //var bll = new BLL.JiezhongmianyitiaomaModelBll();
                    List<JiezhongmianyitiaomaModel> ymtl = new List<JiezhongmianyitiaomaModel>();
                    List<string> cols = new List<string>();
                    IRow row1 = sheet.GetRow(0);
                    for (int i = 0; i < row1.LastCellNum; i++)
                    {
                        cols.Add(row1.GetCell(i).StringCellValue);
                    }
                    var bll = new JiezhongmianyitiaomaModelBll();
                    for (int i = 1; i <= sheet.LastRowNum; i++)
                    {
                        string barcode = "";
                        //string username = "";
                        string csrq = "";
                        string sex = "";
                        //string sjh = "";
                        barcode = sheet.GetRow(i).GetCell(cols.IndexOf("受种者编号")).StringCellValue;
                        csrq = sheet.GetRow(i).GetCell(cols.IndexOf("出生日期")).StringCellValue;
                        sex = sheet.GetRow(i).GetCell(cols.IndexOf("性别")).StringCellValue;
                        HSSFRichTextString username = sheet.GetRow(i).GetCell(cols.IndexOf("受种者姓名")).RichStringCellValue as HSSFRichTextString;
                        HSSFRichTextString sjh = sheet.GetRow(i).GetCell(cols.IndexOf("移动电话")).RichStringCellValue as HSSFRichTextString;
                        string strusername = "";
                        int endl = username.String.Length;
                        for (int j = username.NumFormattingRuns - 1; j >= 0; j--)
                        {
                            IFont f = workbook.GetFontAt(username.GetFontOfFormattingRun(j));
                            if (f.FontHeightInPoints > 5)
                            {
                                strusername = strusername.Insert(0, username.String.Substring(username.GetIndexOfFormattingRun(j), endl - username.GetIndexOfFormattingRun(j)));

                            }
                            endl = username.GetIndexOfFormattingRun(j);
                        }
                        if ((sheet.GetRow(i).GetCell(cols.IndexOf("受种者姓名")) as HSSFCell).CellStyle.GetFont(workbook).FontHeightInPoints > 5)
                        {
                            strusername = strusername.Insert(0, username.String.Substring(0, endl));
                        }




                        string strsjh = "";
                        endl = sjh.String.Length;
                        for (int j = sjh.NumFormattingRuns - 1; j >= 0; j--)
                        {
                            IFont f = workbook.GetFontAt(sjh.GetFontOfFormattingRun(j));
                            if (f.FontHeightInPoints > 5)
                            {
                                strsjh = strsjh.Insert(0, sjh.String.Substring(sjh.GetIndexOfFormattingRun(j), endl - sjh.GetIndexOfFormattingRun(j)));

                            }
                            endl = sjh.GetIndexOfFormattingRun(j);
                        }
                        if ((sheet.GetRow(i).GetCell(cols.IndexOf("移动电话")) as HSSFCell).CellStyle.GetFont(workbook).FontHeightInPoints > 5)
                        {
                            strsjh = strsjh.Insert(0, sjh.String.Substring(0, endl));
                        }
                        var m = new Models.JiezhongmianyitiaomaModel
                        {
                            barcode = barcode,
                            username = strusername.Replace("身份证", ""),
                            csrq = DateTime.Parse(csrq),
                            sex = sex,
                            sjh = strsjh
                        };
                        bll.save(m);
                        //ymtl.Add(m);
                    }
                    return Newtonsoft.Json.JsonConvert.SerializeObject(new { State = 1, Message = "导入成功！" });
                }
                catch (Exception ex)
                {
                    return Newtonsoft.Json.JsonConvert.SerializeObject(new { State = 0, Message = ex.Message });
                }
            }
        }

        #region 疫苗预约
        //public ActionResult Jmyy(string ertbm)
        //{
        //    ViewData["vaccine"] = new SelectList(new BLL.vaccineBll().getAllList(""), "id", "name");
        //    ViewData["ymjd"] = new SelectList(new BLL.ym_jzlcBll().getAllYMJDList(), "id", "name");
        //    ViewBag.ertbm = ertbm;



        //    var bll = new BLL.ym_jzlcBll();
        //    var list = bll.getAllListByErtbm(ertbm);
        //    ym_jzlcjl jl = bll.getYmjzlcjlByErtbm(ertbm);
        //    ym_jzlc lc = bll.getYmjzlcByErtbm(jl.jdid.ToString());
        //    DateTime dt1 = DateTime.Now;
        //    if (lc == null)
        //    {

        //    }
        //    else
        //    {
        //        dt1 = Convert.ToDateTime(jl.jzsj).AddDays(lc.jgts);
        //    }

        //    ViewBag.yysj = dt1.ToString("yyyy-MM-dd");

        //    ViewData["list"] = list;

        //    return View();
        //}

        //public String GetAllYmJzlc(string ertbm)
        //{
        //    var bll = new BLL.ym_jzlcBll();
        //    var list = bll.getAllJzlcList(ertbm);
        //    return Newtonsoft.Json.JsonConvert.SerializeObject(new { Rows = list });
        //}
        //public JsonResult SaveYmyy(string ertbm, string yysj, string jdid, string yms)
        //{
        //    ym_yyjl ymyy = new ym_yyjl();
        //    ymyy.ertbm = ertbm;
        //    ymyy.yysj = Convert.ToDateTime(yysj);
        //    ymyy.jdid = Convert.ToInt32(jdid);
        //    ymyy.ymList = yms.TrimStart(new char[] { ',' }).TrimEnd(new char[] { ',' });

        //    var bll = new chargeBll();
        //    var result = bll.saveYmyy(ymyy);
        //    if (result.State == 1)
        //    {
        //        var yyxx = bll.getyyxx(result.Tag);
        //        var yyymlist = bll.getyyymlist(result.Tag);
        //        if (yyymlist == null || yyymlist.Count == 0)
        //        {

        //        }
        //        else
        //        {
        //            string ymmc = " ";
        //            yyymlist.ForEach(p => {
        //                ymmc += p.lcmc + ",";
        //            });
        //            ymmc= ymmc.TrimEnd(',');
        //            ymmc += " ";
        //            var wxlist = bll.getbdxx(result.Tag);
        //            var etxx = bll.getetxx(result.Tag);
        //            if (wxlist == null || wxlist.Count == 0)
        //            {
                       
        //                if (etxx != null&&!string.IsNullOrEmpty(etxx.sjh))
        //                {
        //                    var commonbll = new BLL.Common();
        //                    string AccessKeyID = commonbll.getParm_Value("AccessKeyID", "LTAIWq3410bmP7hi", "阿里AccessKeyID");
        //                    string AccessKeySecret = commonbll.getParm_Value("AccessKeySecret", "F953Ru3uZN2ZbS5741zvO9OvHrthNV", "阿里AccessKeySecret");
        //                    string qm = commonbll.getParm_Value("aldxqm", "三才网络", "短信签名");
        //                    string dxmb = commonbll.getParm_Value("aldxyymb", "SMS_136160758", "疫苗预约成功短信模版");
        //                    //string smsurl = System.Configuration.ConfigurationManager.AppSettings["smsurl"];
        //                    //string yznr = "你好，欢迎你注册天瑞体检中心会员，你的验证码是：" + yzm.smscode + "。有效期10分钟。回TD退订【天瑞体检】";
        //                    //var zysms = new zyer.smsservice.SmsServiceSoapClient("SmsServiceSoap");
        //                    //var smsjg = zysms.SendEx(username, userpassword, "808", sjh, "", yznr);
        //                    //var fz = Session["FenZhan"] as Model.FenZhan;
        //                    //Common.SendMsg.Send(sjh, yznr, fz.id);
        //                    String product = "Dysmsapi";//短信API产品名称
        //                    String domain = "dysmsapi.aliyuncs.com";//短信API产品域名
        //                    String accessKeyId = AccessKeyID;//你的accessKeyId
        //                    String accessKeySecret = AccessKeySecret;//你的accessKeySecret

        //                    IClientProfile profile = DefaultProfile.GetProfile("cn-hangzhou", accessKeyId, accessKeySecret);
        //                    //IAcsClient client = new DefaultAcsClient(profile);
        //                    // SingleSendSmsRequest request = new SingleSendSmsRequest();

        //                    DefaultProfile.AddEndpoint("cn-hangzhou", "cn-hangzhou", product, domain);
        //                    IAcsClient acsClient = new DefaultAcsClient(profile);
        //                    SendSmsRequest request = new SendSmsRequest();
        //                    try
        //                    {
        //                        //必填:待发送手机号。支持以逗号分隔的形式进行批量调用，批量上限为20个手机号码,批量调用相对于单条调用及时性稍有延迟,验证码类型的短信推荐使用单条调用的方式
        //                        request.PhoneNumbers =etxx.sjh;
        //                        //必填:短信签名-可在短信控制台中找到
        //                        request.SignName = qm;
        //                        //必填:短信模板-可在短信控制台中找到
        //                        request.TemplateCode = dxmb;
        //                        //可选:模板中的变量替换JSON串,如模板内容为"亲爱的${name},您的验证码为${code}"时,此处的值为
        //                        request.TemplateParam = Newtonsoft.Json.JsonConvert.SerializeObject(new { jzrq=yyxx.yysj.ToString("yyyy-MM-dd"), ymmc=ymmc });
        //                        //可选:outId为提供给业务方扩展字段,最终在短信回执消息中将此值带回给调用者
        //                        //request.OutId = "21212121211";
        //                        //请求失败这里会抛ClientException异常
        //                        SendSmsResponse sendSmsResponse = acsClient.GetAcsResponse(request);

        //                        //System.Console.WriteLine(sendSmsResponse.Message);
        //                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(sendSmsResponse.Message);

        //                    }
        //                    catch (ServerException e)
        //                    {
        //                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);
        //                        //System.Console.WriteLine("Hello World!");
        //                        //return Json(new { State = 0, Message = e.Message});

        //                    }
        //                    catch (ClientException e)
        //                    {
        //                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);
        //                        //return Json(new { State = 0, Message = e.Message});
        //                    }
        //                }
        //            }
        //            else
        //            {
        //                try
        //                {
        //                    wxlist.ForEach(wx =>
        //                    {
        //                        var data = new
        //                        {
        //                            touser = wx.openid,
        //                            template_id = "60jRADxdFNgDQQZSRh1dH4FyRFM_Im-jbKjWUwyMJqY",

        //                            data = new
        //                            {
        //                                first = new { value = "您的宝宝应在" + yyxx.yysj.ToString("yyyy-MM-dd") + "接种以下疫苗。", color = "#173177" },
        //                                keyword1 = new { value = etxx.username, color = "#173177" },
        //                                keyword2 = new { value = yyxx.yysj.ToString("yyyy-MM-dd"), color = "#173177" },
        //                                keyword3 = new { value = ymmc, color = "#173177" },
        //                                remark = new { value = "请及时前往指定接种门诊进行接种。", color = "#173177" },
        //                            }
        //                        };

        //                        WebClient wc = new WebClient();
        //                        wc.UploadData("https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=" + Common.Global.getAccessTokenYM.access_token, System.Text.Encoding.UTF8.GetBytes(Newtonsoft.Json.JsonConvert.SerializeObject(data)));
        //                    });
        //                }
        //                catch(Exception ex)
        //                {
        //                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(ex.Message);
        //                }
        //            }
        //        }

        //    }
        //    return Json(result);
        //}
        #endregion

        #region 疫苗接种预约相关
        //public String GetYmyyjl(string id)
        //{
        //    var bll = new YMDJMXBll();
        //    var result = bll.getYmyyjl(id);
        //    return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        //}
        //public String GetYmsList(string ymList)
        //{
        //    var bll = new YMDJMXBll();
        //    var result = bll.GetYmsList(ymList);
        //    return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        //}
        //public String GetJzymTmdy(string id)
        //{
        //    var bll = new YMDJMXBll();
        //    var result = bll.GetJzymTmdy(id);
        //    return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        //}
        //public String GetYmjzlcList(string jdid)
        //{
        //    var bll = new YMDJMXBll();
        //    var result = bll.GetYmjzlcList(jdid);
        //    return Newtonsoft.Json.JsonConvert.SerializeObject(result, new Newtonsoft.Json.JsonSerializerSettings { DateFormatString = "yyyy-MM-dd" });
        //}
        #endregion


        #region 短信群发
        public ActionResult dunxinqunfa()
        {
            return View();
        }
        public JsonResult senddx(string sjhs, string ymmc)
        {
            var commonbll = new BLL.Common();
            string yddx = commonbll.getParm_Value("qyyddx", "false", "是否启用移动短信");
            if (yddx == "false")
            {
                int t = 0;
                string AccessKeyID = commonbll.getParm_Value("AccessKeyID", "LTAIWq3410bmP7hi", "阿里AccessKeyID");
                string AccessKeySecret = commonbll.getParm_Value("AccessKeySecret", "F953Ru3uZN2ZbS5741zvO9OvHrthNV", "阿里AccessKeySecret");
                string qm = commonbll.getParm_Value("aldxqm", "三才网络", "短信签名");
                string dxmb = commonbll.getParm_Value("aldxtzmbbz", "SMS_136170955", "漏种催补种模板");
                //string smsurl = System.Configuration.ConfigurationManager.AppSettings["smsurl"];
                //string yznr = "你好，欢迎你注册天瑞体检中心会员，你的验证码是：" + yzm.smscode + "。有效期10分钟。回TD退订【天瑞体检】";
                //var zysms = new zyer.smsservice.SmsServiceSoapClient("SmsServiceSoap");
                //var smsjg = zysms.SendEx(username, userpassword, "808", sjh, "", yznr);
                //var fz = Session["FenZhan"] as Model.FenZhan;
                //Common.SendMsg.Send(sjh, yznr, fz.id);
                String product = "Dysmsapi";//短信API产品名称
                String domain = "dysmsapi.aliyuncs.com";//短信API产品域名
                String accessKeyId = AccessKeyID;//你的accessKeyId
                String accessKeySecret = AccessKeySecret;//你的accessKeySecret

                IClientProfile profile = DefaultProfile.GetProfile("cn-hangzhou", accessKeyId, accessKeySecret);
                //IAcsClient client = new DefaultAcsClient(profile);
                // SingleSendSmsRequest request = new SingleSendSmsRequest();

                DefaultProfile.AddEndpoint("cn-hangzhou", "cn-hangzhou", product, domain);
                IAcsClient acsClient = new DefaultAcsClient(profile);
                SendSmsRequest request = new SendSmsRequest();
                try
                {
                    string[] hms = sjhs.Split('|');
                    foreach (var hm in hms)
                    {
                        if (string.IsNullOrEmpty(hm))
                            continue;
                        //必填:待发送手机号。支持以逗号分隔的形式进行批量调用，批量上限为20个手机号码,批量调用相对于单条调用及时性稍有延迟,验证码类型的短信推荐使用单条调用的方式
                        request.PhoneNumbers = hm;
                        //必填:短信签名-可在短信控制台中找到
                        request.SignName = qm;
                        //必填:短信模板-可在短信控制台中找到
                        request.TemplateCode = dxmb;
                        //可选:模板中的变量替换JSON串,如模板内容为"亲爱的${name},您的验证码为${code}"时,此处的值为
                        request.TemplateParam = Newtonsoft.Json.JsonConvert.SerializeObject(new { ymmc = ymmc });
                        //可选:outId为提供给业务方扩展字段,最终在短信回执消息中将此值带回给调用者
                        //request.OutId = "21212121211";
                        //请求失败这里会抛ClientException异常
                        SendSmsResponse sendSmsResponse = acsClient.GetAcsResponse(request);

                        //System.Console.WriteLine(sendSmsResponse.Message);
                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(sendSmsResponse.Message);
                        t++;
                    }
                }
                catch (ServerException e)
                {
                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);
                    //System.Console.WriteLine("Hello World!");
                    //return Json(new { State = 0, Message = e.Message});

                }
                catch (ClientException e)
                {
                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);
                    //return Json(new { State = 0, Message = e.Message});
                }
                return Json(new { State = 1, Message = "成功发送条" + t + "通知短信" });
            }
            else
            {
                int t = 0;
                //http://112.35.1.155:1992/sms/norsubmit
                string ydhttp = commonbll.getParm_Value("ydhttp", "http://112.35.1.155:1992/sms/tmpsubmit", "移动短信地址");
                var req = new Models.duanxin.msend();
                WebClient wc = new WebClient();

                string[] hms = sjhs.Split('|');
                foreach (var hm in hms)
                {
                    if (string.IsNullOrEmpty(hm))
                        continue;
                    req.ecName = commonbll.getParm_Value("yddxqymc", "德州市德城区疾病预防控制中心", "企业名称");
                    req.apId = commonbll.getParm_Value("yddxapId", "jkoa", "接口账号用户名");
                    req.mobiles = hm;
                    req.sign = commonbll.getParm_Value("yddxsign", "d37CYmrbG", "签名编码");
                    //req.content = "您的宝宝还未接种" + ymmc + ",请尽快带宝宝到接种门诊进行补种。微信关注“德城区疾病预防控制中心”即可预约接种。";
                    req.templateId = "cbb76eac353842aaaa8bceeb074237a4";
                    req.addSerial = "";

                    string[] parms = new string[1];
                    parms[0] = ymmc;
                    req.parms = Newtonsoft.Json.JsonConvert.SerializeObject(parms);
                    var md5 = MD5.Create();
                    //secretKey
                    var bs = md5.ComputeHash(Encoding.UTF8.GetBytes(req.ecName + req.apId + commonbll.getParm_Value("yddxsecretKey", "a7551898", "短信接口密码") + req.templateId + req.mobiles +  req.parms +  req.sign));
                    var sb = new StringBuilder();
                    foreach (byte b in bs)
                    {
                        sb.Append(b.ToString("x2"));
                    }
                    req.mac = sb.ToString().ToLower();
                    string upstr = Newtonsoft.Json.JsonConvert.SerializeObject(req);
                    upstr = upstr.Replace("parms", "params");
                    byte[] resp = wc.UploadData(ydhttp, System.Text.Encoding.UTF8.GetBytes(Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(upstr))));
                    var nres = Newtonsoft.Json.JsonConvert.DeserializeObject<Models.duanxin.nrecive>(System.Text.Encoding.UTF8.GetString(resp));

                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(System.Text.Encoding.UTF8.GetString(resp));
                    t++;
                }
                return Json(new { State = 1, Message = "成功发送条" + t + "通知短信" });
            }
        }

        public JsonResult senddx2(string sjhs, string dxnr)
        {
            var commonbll = new BLL.Common();
            string yddx = commonbll.getParm_Value("qyyddx", "false", "是否启用移动短信");
            if (yddx == "false")
            {
                int t = 0;
                string AccessKeyID = commonbll.getParm_Value("AccessKeyID", "LTAIWq3410bmP7hi", "阿里AccessKeyID");
                string AccessKeySecret = commonbll.getParm_Value("AccessKeySecret", "F953Ru3uZN2ZbS5741zvO9OvHrthNV", "阿里AccessKeySecret");
                string qm = commonbll.getParm_Value("aldxqm", "三才网络", "短信签名");
                string dxmb = commonbll.getParm_Value("aldxtzmbbz", "SMS_136170955", "漏种催补种模板");
                //string smsurl = System.Configuration.ConfigurationManager.AppSettings["smsurl"];
                //string yznr = "你好，欢迎你注册天瑞体检中心会员，你的验证码是：" + yzm.smscode + "。有效期10分钟。回TD退订【天瑞体检】";
                //var zysms = new zyer.smsservice.SmsServiceSoapClient("SmsServiceSoap");
                //var smsjg = zysms.SendEx(username, userpassword, "808", sjh, "", yznr);
                //var fz = Session["FenZhan"] as Model.FenZhan;
                //Common.SendMsg.Send(sjh, yznr, fz.id);
                String product = "Dysmsapi";//短信API产品名称
                String domain = "dysmsapi.aliyuncs.com";//短信API产品域名
                String accessKeyId = AccessKeyID;//你的accessKeyId
                String accessKeySecret = AccessKeySecret;//你的accessKeySecret

                IClientProfile profile = DefaultProfile.GetProfile("cn-hangzhou", accessKeyId, accessKeySecret);
                //IAcsClient client = new DefaultAcsClient(profile);
                // SingleSendSmsRequest request = new SingleSendSmsRequest();

                DefaultProfile.AddEndpoint("cn-hangzhou", "cn-hangzhou", product, domain);
                IAcsClient acsClient = new DefaultAcsClient(profile);
                SendSmsRequest request = new SendSmsRequest();
                try
                {
                    string[] hms = sjhs.Split('|');
                    foreach (var hm in hms)
                    {
                        if (string.IsNullOrEmpty(hm))
                            continue;
                        //必填:待发送手机号。支持以逗号分隔的形式进行批量调用，批量上限为20个手机号码,批量调用相对于单条调用及时性稍有延迟,验证码类型的短信推荐使用单条调用的方式
                        request.PhoneNumbers = hm;
                        //必填:短信签名-可在短信控制台中找到
                        request.SignName = qm;
                        //必填:短信模板-可在短信控制台中找到
                        request.TemplateCode = dxmb;
                        //可选:模板中的变量替换JSON串,如模板内容为"亲爱的${name},您的验证码为${code}"时,此处的值为
                        request.TemplateParam = Newtonsoft.Json.JsonConvert.SerializeObject(new { ymmc = "" });
                        //可选:outId为提供给业务方扩展字段,最终在短信回执消息中将此值带回给调用者
                        //request.OutId = "21212121211";
                        //请求失败这里会抛ClientException异常
                        SendSmsResponse sendSmsResponse = acsClient.GetAcsResponse(request);

                        //System.Console.WriteLine(sendSmsResponse.Message);
                        log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(sendSmsResponse.Message);
                        t++;
                    }
                }
                catch (ServerException e)
                {
                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);

                }
                catch (ClientException e)
                {
                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(e.Message + e.RequestId);
                }
                return Json(new { State = 1, Message = "成功发送条" + t + "通知短信" });
            }
            else
            {
                int t = 0;
                //http://112.35.1.155:1992/sms/norsubmit
                string ydhttp = commonbll.getParm_Value("ydhttp", "http://112.35.1.155:1992/sms/tmpsubmit", "移动短信地址");
                ydhttp = "http://112.35.1.155:1992/sms/norsubmit";
                var req = new Models.duanxin.msend();
                WebClient wc = new WebClient();

                string[] hms = sjhs.Split('|');
                foreach (var hm in hms)
                {
                    if (string.IsNullOrEmpty(hm))
                        continue;
                    req.ecName = commonbll.getParm_Value("yddxqymc", "德州市德城区疾病预防控制中心", "企业名称");
                    req.apId = commonbll.getParm_Value("yddxapId", "jkoa", "接口账号用户名");
                    req.mobiles = hm;
                    req.sign = commonbll.getParm_Value("yddxsign", "d37CYmrbG", "签名编码");
                    //req.content = "您的宝宝还未接种" + ymmc + ",请尽快带宝宝到接种门诊进行补种。微信关注“德城区疾病预防控制中心”即可预约接种。";
                    req.content = dxnr;
                    req.addSerial = "";

                    var md5 = MD5.Create();
                    //secretKey
                    var bs = md5.ComputeHash(Encoding.UTF8.GetBytes(req.ecName + req.apId + commonbll.getParm_Value("yddxsecretKey", "a7551898", "短信接口密码") +  req.mobiles + req.content + req.sign + req.addSerial));
                    var sb = new StringBuilder();
                    foreach (byte b in bs)
                    {
                        sb.Append(b.ToString("x2"));
                    }
                    req.mac = sb.ToString().ToLower();
                    byte[] resp = wc.UploadData(ydhttp, System.Text.Encoding.UTF8.GetBytes(Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(Newtonsoft.Json.JsonConvert.SerializeObject(req)))));
                    var nres = Newtonsoft.Json.JsonConvert.DeserializeObject<Models.duanxin.nrecive>(System.Text.Encoding.UTF8.GetString(resp));

                    log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType).Info(System.Text.Encoding.UTF8.GetString(resp));
                    t++;
                }
                return Json(new { State = 1, Message = "成功发送条" + t + "通知短信" });
            }
        }
        public string uploadsjh()
        {
            if (Request.Files.Count == 0)
            {
                return Newtonsoft.Json.JsonConvert.SerializeObject(new { State = 0, Message = "没有要处理的文件" });
            }
            else
            {
                try
                {
                    string path = Server.MapPath("~/exec/");
                    if (!Directory.Exists(path))
                    {
                        Directory.CreateDirectory(path);
                    }
                    path = path + Guid.NewGuid().ToString("N") + Request.Files[0].FileName.Substring(Request.Files[0].FileName.LastIndexOf("."));
                    Request.Files[0].SaveAs(path);
                    //DataTable[] dts = xiaoy.Excel.ExcelFile.GetData(path, xiaoy.Excel.ExcelVersion.Excel12, xiaoy.Excel.HDRType.Yes, false);
                    FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);
                    HSSFWorkbook workbook = null;
                    workbook = new HSSFWorkbook(fs);
                    HSSFSheet sheet = workbook.GetSheetAt(0) as HSSFSheet;
                    //var bll = new BLL.JiezhongmianyitiaomaModelBll();
                    List<JiezhongmianyitiaomaModel> ymtl = new List<JiezhongmianyitiaomaModel>();
                    List<string> cols = new List<string>();
                    IRow row1 = sheet.GetRow(0);
                    for (int i = 0; i < row1.LastCellNum; i++)
                    {
                        cols.Add(row1.GetCell(i).StringCellValue);
                    }
                    for (int i = 1; i <= sheet.LastRowNum; i++)
                    {
                        string barcode = "";
                        //string username = "";
                        string csrq = "";
                        string sex = "";
                        //string sjh = "";
                        barcode = sheet.GetRow(i).GetCell(cols.IndexOf("受种者编号")).StringCellValue;
                        csrq = sheet.GetRow(i).GetCell(cols.IndexOf("出生日期")).StringCellValue;
                        sex = sheet.GetRow(i).GetCell(cols.IndexOf("性别")).StringCellValue;
                        HSSFRichTextString username = sheet.GetRow(i).GetCell(cols.IndexOf("受种者姓名")).RichStringCellValue as HSSFRichTextString;
                        HSSFRichTextString sjh = sheet.GetRow(i).GetCell(cols.IndexOf("移动电话")).RichStringCellValue as HSSFRichTextString;
                        string strusername = "";
                        int endl = username.String.Length;
                        for (int j = username.NumFormattingRuns - 1; j >= 0; j--)
                        {
                            IFont f = workbook.GetFontAt(username.GetFontOfFormattingRun(j));
                            if (f.FontHeightInPoints > 5)
                            {
                                strusername = strusername.Insert(0, username.String.Substring(username.GetIndexOfFormattingRun(j), endl - username.GetIndexOfFormattingRun(j)));

                            }
                            endl = username.GetIndexOfFormattingRun(j);
                        }
                        if ((sheet.GetRow(i).GetCell(cols.IndexOf("受种者姓名")) as HSSFCell).CellStyle.GetFont(workbook).FontHeightInPoints > 5)
                        {
                            strusername = strusername.Insert(0, username.String.Substring(0, endl));
                        }




                        string strsjh = "";
                        endl = sjh.String.Length;
                        for (int j = sjh.NumFormattingRuns - 1; j >= 0; j--)
                        {
                            IFont f = workbook.GetFontAt(sjh.GetFontOfFormattingRun(j));
                            if (f.FontHeightInPoints > 5)
                            {
                                strsjh = strsjh.Insert(0, sjh.String.Substring(sjh.GetIndexOfFormattingRun(j), endl - sjh.GetIndexOfFormattingRun(j)));

                            }
                            endl = sjh.GetIndexOfFormattingRun(j);
                        }
                        if ((sheet.GetRow(i).GetCell(cols.IndexOf("移动电话")) as HSSFCell).CellStyle.GetFont(workbook).FontHeightInPoints > 5)
                        {
                            strsjh = strsjh.Insert(0, sjh.String.Substring(0, endl));
                        }
                        var m = new Models.JiezhongmianyitiaomaModel
                        {
                            barcode = barcode,
                            username = strusername,
                            csrq = DateTime.Parse(csrq),
                            sex = sex,
                            sjh = strsjh
                        };
                        //bll.save(m);
                        ymtl.Add(m);
                    }
                    return Newtonsoft.Json.JsonConvert.SerializeObject(new { State = 1, Message = new { Rows = ymtl } });
                }
                catch (Exception ex)
                {
                    return Newtonsoft.Json.JsonConvert.SerializeObject(new { State = 0, Message = ex.Message });
                }
            }
        }
        #endregion
    }

}