using NFine.Application.SystemManage;
using NFine.Code;
using NFine.Data.Extensions;
using NFine.Domain.Entity.SystemManage;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using System.Web.Mvc;

namespace NFine.Web.Controllers
{
    [HandlerLogin]
    public class HomeController : Controller
    {
        [HttpGet]
        public ActionResult Index()
        {
            return View();
        }

        [HttpGet]
        public ActionResult Default()
        {
            return View();
        }

        [HttpGet]
        public ActionResult About()
        {
            return View();
        }
        [HttpGet]
        public ActionResult GetDay(string password)
        {
            string userId = @NFine.Code.OperatorProvider.Provider.GetCurrent().UserId;
            string VenCode = @NFine.Code.OperatorProvider.Provider.GetCurrent().VenCode;
            string UserCode = @NFine.Code.OperatorProvider.Provider.GetCurrent().UserCode;
            if (!string.IsNullOrWhiteSpace(VenCode))
            {
                string sql = @" SELECT b.ID, b.VenCode,c.cVenName,b.FileName,CONVERT(NVARCHAR(20),b.Createtime,23) AS  Createtime, CASE WHEN  b.Status='0' THEN '未提交' WHEN  b.Status='1' THEN '待审核' WHEN  b.Status='2' THEN '已生效'WHEN  b.Status='3' THEN '驳回'END AS Status, CASE WHEN  b.Status='0' THEN '未提交' WHEN  b.Status='1' THEN '待审核' WHEN  b.Status='2' THEN '已生效'WHEN  b.Status='3' THEN '驳回'END AS HIDDSTATUS FROM ICSVendor c
			                    LEFT JOIN [ICSSRMAgreementUpload] b ON c.cVenCode=b.VenCode
			                    LEFT JOIN ICSTemplateManagement a ON b.FileID=a.id
			                    WHERE 1=1    and  b.VenCode='" + VenCode + "' and b.Status='2'";
                DataTable dt = SqlHelper.GetDataTableBySql(sql);
                if (dt.Rows.Count > 0)
                {
                    return Content(new AjaxResult { state = ResultType.success.ToString(), message = "1" }.ToJson());
                }
                else
                {
                    return Content(new AjaxResult { state = ResultType.error.ToString(), message = "请您尽快在协议签署管理模块中进行协议上传，否则将会影响到您其余功能的使用和后续订单的接收" }.ToJson());

                }
            }
            else
            {
                return Content(new AjaxResult { state = ResultType.success.ToString(), message = "1" }.ToJson());
            }

        }
    }
}