using BizCom;
using SiteCore.Redis;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Utils;

namespace SiteCore.Handler
{
    public partial class sync
    {

        public void clear_loginredis()
        {
            erpRedis.RedisHelper.clearFilterKeys("gzh_svr_*");
            erpRedis.RedisHelper.clearFilterKeys("svr_*");
            erpRedis.RedisHelper.clearFilterKeys("user_*");
            returnSuccessMsg("清除成功");
        }

        public void get_erp_site()
        {
            DataStruct dStruct = GetStruct();
            List<string> lw = new List<string>();
            dStruct.Order = "sort asc";
            DataTable dt = WebCache.GetData("S_ErpServer", dStruct);
            writeGridJson(dStruct.TotalCount, Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void save_erp_site()
        {
            if (UrlPostParmsCheck("name"))
            {
                int sid = GetPostInt("sid");
                string name = GetPostString("name");
                string server = GetPostString("server");
                string transfer = GetPostString("transfer");
                string latlng = GetPostString("latlng");
                string perms = GetPostString("perms");
                int sort = GetPostInt("sort");
                int st = GetPostInt("st");
                bool isnew = false;
                SErpServer entity = null;
                if (sid > 0) entity = SErpServer.Get(sid);
                else
                {
                    entity = new SErpServer();
                    isnew = true;
                }
                entity.Name = name;
                entity.Server = server;
                entity.Sort = sort;
                entity.Transfer = transfer;
                entity.State = st;
                entity.Perms = perms;
                if(latlng!="")
                {
                    entity.LatLng = latlng;
                }
                if (isnew) entity.Create();
                else entity.Update();

                erpRedis.RedisHelper.KeyDelete("erp_server");
                erpRedis.RedisHelper.KeyDelete("erp_serverdic");
                ErpUtil.ServerDics.Clear();
                returnSuccessMsg("保存成功");
            }
        }

        public void del_erp_site()
        {
            if (UrlPostParmsCheck("sid"))
            {
                int sid = GetPostInt("sid");
                SErpServer.Del(sid);
                erpRedis.RedisHelper.KeyDelete("erp_server");
                erpRedis.RedisHelper.KeyDelete("erp_serverdic");
                ErpUtil.ServerDics.Clear();
                returnSuccessMsg("删除成功");
            }
        }

        public void get_erp_user()
        {
            DataStruct dStruct = GetPostStruct();
            List<string> lw = new List<string>();
            string key = GetPostString("key");
            if (key.Length > 0) lw.Add(string.Format("lgname like '%{0}%'", key));

            int sid = GetPostInt("sid");
            if (sid > 0) lw.Add(" serverid=" + sid);

            int utype = GetPostInt("utype");
            if (utype > 0) lw.Add(" usertype=" + utype);

            dStruct.Order = "addtime desc";
            dStruct.MainWhere = string.Join(" and ", lw.ToArray());
            DataTable dt = WebCache.GetData("view_erpuser", dStruct);

            foreach(DataRow dr in dt.Rows)
            {
                dr["lgpwd"]=SecurityHelper.DecryptSymmetric(dr["lgpwd"].ToString());
            }
            writeGridJson(dStruct.TotalCount, Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }


        public void save_erp_user()
        {
            if (UrlPostParmsCheck("sid,utype,acc"))
            {
                int uid = GetPostInt("uid");
                int sid = GetPostInt("sid");
                string uname = GetPostString("acc");
                string upwd = "010101";
                int utype = GetPostInt("utype");
                
                SErpUser entity = null;
                if (uid > 0) entity = SErpUser.Get(uid);
                else
                {
                    entity = new SErpUser();
                    entity.AddTime = DateTime.Now;
                    entity.lgPwd = SecurityHelper.EncryptSymmetric(upwd);
                }
                entity.ServerID = sid;
                entity.UserType = utype;
                entity.lgName = uname;
                
                if (uid > 0) entity.Update();
                else entity.Create(); 

                returnSuccessMsg("操作成功");
            }
        }

        public void del_erp_user()
        {
            if(UrlPostParmsCheck("mid"))
            {
                int mid = GetPostInt("mid");
                int sid = GetPostInt("sid");
                SErpUser.Del(mid, sid);
                returnSuccessMsg("删除成功!");
            }
        }
    }
}