using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Pub_Class;
using SyntacticSugar.constant;
using SyntacticSugar.enums;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.DLL.SBGL.SBBB;
using WebAPI.Models;
using WebAPI.Models.SBGL.SBBB;

namespace WebAPI.Controllers.SBGL.SBBB
{
    public class Sb_EquipMentCollectionTechParamController : ApiController
    {
        //获取系统参数
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="sWhere"></param>
        /// <param name="user"></param>
        /// <returns></returns>
        [HttpGet]
        [Route("EquipMentCollection/list")]
        public json list(string sWhere, string user)
        {
            json res = new json();
            try
            {
                string sql = "select * from h_v_Sb_EquipMentCollectionTechParamList where 1 = 1" + sWhere;
                DataSet ds =  oCN.RunProcReturn(sql, "h_v_Sb_EquipMentCollectionTechParamList");

                //数据遍历, 获取列名
                List<object> columnNameList = new List<object>();
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                //返回结果
                res.code = CodeConstant.SUCCEED;
                res.count = CountConstant.SUCCEED;
                res.Message = "查询成功";
                res.data = ds.Tables["h_v_Sb_EquipMentCollectionTechParamList"];
                res.list = columnNameList;
                return res;
            }
            catch (Exception e)
            {
                res.code = CodeConstant.FAIL;
                res.count = CountConstant.FAIL;
                res.Message = e.Message;
                res.data = null;
                return res;
            }
        }

        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="eMCollection"></param>
        /// <param name="user"></param>
        /// <returns></returns>
        [HttpPost]
        [Route("EquipMentCollection/save")]
        public json SaveSb_EquipMentCollectionTechParam([FromBody] JObject oMain)
        {
            var _value = oMain["oMain"].ToString();
            string msg1 = _value.ToString();
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString(); //主表数据
                                                //主表反序列化
            msg2 = "[" + msg2.ToString() + "]";

            //对象转化
            List<Sb_EquipMentCollectionTechParam> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Sb_EquipMentCollectionTechParam>>(msg2);
            Sb_EquipMentCollectionTechParam eMColllection = list[0];
            json res = new json();
            try
            {              
                //if (!ClsPub.Security_Log(msg5, (int)SecurityEnum.JUDGE_AND_WRITE, false, msg4))
                //{
                //    res.code = CodeConstant.FAIL;
                //    res.count = CountConstant.FAIL;
                //    res.Message = "无保存权限！";
                //    return res;
                //}

                if (!DBUtility.ClsPub.AllowNumber(eMColllection.HSourceCode))
                {
                    res.code = CodeConstant.FAIL;
                    res.count = CountConstant.FAIL;
                    res.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                    return res;
                }
                Sb_EquipMentCollectionTechParam_Ctl collectionTechParam_Ctl = 
                                                    new Sb_EquipMentCollectionTechParam_Ctl(oCN, eMColllection);
                //数据库新增
                    collectionTechParam_Ctl.AddNew();

                res.code = CodeConstant.SUCCEED;
                res.count = CountConstant.SUCCEED;
                res.Message = "新增成功";
                return res;
             }catch (Exception e)
             {
                     res.code = CodeConstant.FAIL;
                     res.count = CountConstant.FAIL;
                     res.Message = e.Message;
                     return res;
             }
    }

        /// <summary>
        /// 获取最大基础资料ID
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("EquipMentCollection/GetMAXBillID")]
        [HttpGet]
        public object GetMAXBillID()
        {
            json res = new json();
            try
            {
                DataSet ds = oCN.RunProcReturn("select isnull(max(HItemID), 0)+1 HItemID from Sb_EquipMentCollectionTechParam", "Sb_EquipMentCollectionTechParam");

                res.code = CodeConstant.SUCCEED;
                res.count = CountConstant.SUCCEED;
                res.Message = "";
                res.data = ds.Tables[0];
                return res;
            }
            catch (Exception e)
            {
                res.code = CodeConstant.FAIL;
                res.count = CountConstant.FAIL;
                res.Message = "Exception！" + e.ToString();
                res.data = null;
                return res;
            }
        }
    }
}