/*
 * 仓库编号关联仓库Id
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using MySystem.Models.Main;
using Library;
using LitJson;

namespace MySystem.Service.Main
{
    public class StoreForCodeService
    {
        static string _conn = ConfigurationManager.AppSettings["SqlConnStr"].ToString();

        /// <summary>
        /// 通过仓库编号查询一条记录
        /// </summary>
        /// <param name="StoreNo">仓库编号</param>
        /// <returns></returns>
        public static StoreForCode QueryByStoreNo(string StoreNo)
        {
            WebCMSEntities db = new WebCMSEntities();
            StoreForCode editData = db.StoreForCode.FirstOrDefault(m => m.Code == StoreNo) ?? new StoreForCode();
            db.Dispose();
            return editData;
        }

        /// <summary>
        /// 查询记录数
        /// </summary>
        /// <param name="Id">主键Id</param>
        /// <returns></returns>
        public static int Count(string condition = "")
        {
            int result = 0;
            DataTable dt = CustomerSqlConn.dtable("select count(Id) from StoreForCode where 1=1" + condition, _conn);
            if (dt.Rows.Count > 0)
            {
                result = int.Parse(function.CheckInt(dt.Rows[0][0].ToString()));
            }
            return result;
        }

        /// <summary>
        /// 查询是否存在
        /// </summary>
        /// <param name="Id">主键Id</param>
        /// <returns></returns>
        // public static bool Exist(int Id)
        // {
        //     WebCMSEntities db = new WebCMSEntities();
        //     bool check = db.StoreForCode.Any(m => m.Id == Id);
        //     db.Dispose();
        //     return check;
        // }

        /// <summary>
        /// 添加数据
        /// </summary>
        /// <param name="Fields">要设置的字段</param>
        /// <returns></returns>
        public static AppResultJson Add(Dictionary<string, object> fields, bool check = true)
        {
            int Id = new DbService(AppConfig.Base.mainTables, _conn).Add("StoreForCode", fields, 0);
            return new AppResultJson() { Status = "1", Data = Id };
        }

        /// <summary>
        /// 逻辑删除
        /// </summary>
        /// <param name="Id">主键Id</param>
        public static void Remove(int Id)
        {
            Dictionary<string, object> fields = new Dictionary<string, object>();
            fields.Add("Status", -1);
            new DbService(AppConfig.Base.mainTables, _conn).Edit("StoreForCode", fields, Id);
        }

        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="Id">主键Id</param>
        public static void Delete(int Id)
        {
            new DbService(AppConfig.Base.mainTables, _conn).Delete("StoreForCode", Id);
        }

        /// <summary>
        /// 导出excel表格
        /// </summary>
        /// <param name="fields">查询条件(单个字段)</param>
        /// <param name="condition">查询条件(sql语句)</param>
        /// <returns></returns>
        // public void ExportExcel(List<RelationData> relationData, string condition)
        // {

        // }
    }
}