using Dapper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using VueWebApi.Models;

namespace VueWebApi.Tools
{
    public class AppLableBarCode
    {
        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象

        #region [获取规则编码]
        /// <summary>
        /// 根据功能编码获取最新规则编码
        /// </summary>
        /// <param name="rightcode">功能编码</param>
        /// <param name="partcode">物料编码</param>
        /// <param name="qty">数量</param>
        /// <param name="onelabqty">单标签数量</param>
        /// <returns></returns>
        public static ToMessage EncodingSeach(string rightcode,string partcode, string qty, string onelabqty)
        {
            string sql, year="", month="", day="", fdate="", q="", cunm2 = "", Encode="", cunm = "";
            int digit2 = 0, value2 = 0, digit3 = 0, digitdiff = 0;
            bool stf;
            List<object> list = new List<object>();
            List<string> listdt = new List<string>();
            List<AppLabCode> lab = new List<AppLabCode>();
            var dynamicParams = new DynamicParameters();
            //获取标签个数:向下取整
            decimal labcum = Math.Floor(decimal.Parse(qty) / decimal.Parse(onelabqty));
            try
            {
                sql = @"select prefix,filingdate,incbit,value from  T_CodeRules  where rightcode=@rightcode";
                dynamicParams.Add("@rightcode", rightcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    string prefix = data.Rows[0]["PREFIX"].ToString();  //固定字段
                    string filingdate = data.Rows[0]["FILINGDATE"].ToString();  //提交日期
                    int incbit = int.Parse(data.Rows[0]["INCBIT"].ToString());  //自增位数
                    string value = data.Rows[0]["VALUE"].ToString();  //流水号                                               
                    decimal sumqty = 0;//定义累计单标签数量
                    if (int.Parse(value) >=0)  
                    {
                        switch (filingdate)
                        {
                            case "年月日":
                                lab = Labcode(partcode,year, month, day, prefix, fdate, digit2, value2, digit3, digitdiff, q, cunm2, Encode, value, labcum, sumqty, onelabqty, rightcode, qty,out  cunm);
                                break;
                            case "年月":
                                lab = Labcode(partcode,year, month, day, prefix, fdate, digit2, value2, digit3, digitdiff, q, cunm2, Encode, value, labcum, sumqty, onelabqty, rightcode, qty, out cunm);
                                break;
                            case "年":
                                lab = Labcode(partcode,year, month, day, prefix, fdate, digit2, value2, digit3, digitdiff, q, cunm2, Encode, value, labcum, sumqty, onelabqty, rightcode, qty, out cunm);
                                break;
                            default:
                                break;
                        }
                        //更新规则表位数及流水号
                        sql = @"update T_CodeRules set incbit=@incbit,value=@cunm2  where rightcode=@rightcode";
                        dynamicParams.Add("@incbit", cunm.Length);
                        dynamicParams.Add("@cunm2", cunm);
                        dynamicParams.Add("@rightcode", rightcode);
                        list.Add(new { str = sql, parm = dynamicParams });
                        stf = DapperHelper.DoTransaction(list);
                        if (stf)
                        {
                            mes.code = "200";
                            mes.Message = "成功!";
                            mes.data = lab;
                        }
                        else
                        {
                            mes.code = "300";
                            mes.count = 0;
                            mes.Message = "失败!";
                            mes.data = null;
                        }
                    }
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "未设置编码规则,生成单号失败,请设置编码为【" + rightcode + "】的编码规则!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[生成条码]
        /// <summary>
        /// 生成条码
        /// </summary>
        /// <param name="partcode">物料编码</param>
        /// <param name="year">年</param>
        /// <param name="month">月</param>
        /// <param name="day">日</param>
        /// <param name="prefix">固定字段</param>
        /// <param name="fdate">年(2位)+月(2位)+日(2位)</param>
        /// <param name="digit2">流水号长度</param>
        /// <param name="value2">自增流水号</param>
        /// <param name="digit3">自增流水号长度</param>
        /// <param name="digitdiff">位数差</param>
        /// <param name="q">补位(0)</param>
        /// <param name="cunm2">最终流水号(包含补位)</param>
        /// <param name="Encode">最终标签码(固定字段+规则+最终流水号)</param>
        /// <param name="value">初始查询最新流水号</param>
        /// <param name="labcum">标签个数</param>
        /// <param name="sumqty">累计单标签数量</param>
        /// <param name="onelabqty">单标签数量</param>
        /// <param name="rightcode">功能编码</param>
        /// <param name="qty">数量</param>
        /// <param name="cunm">输出最终流水号</param>
        /// <returns></returns>
        public static List<AppLabCode> Labcode(string partcode,string year,string month,string day,string prefix, string fdate,int digit2,int value2,int digit3,int digitdiff,string q,string cunm2,string Encode, string value, decimal labcum, decimal sumqty,string onelabqty,string rightcode,string qty,out string cunm) 
        {
            List<AppLabCode> lab = new List<AppLabCode>();
            year = DateTime.Now.Year.ToString().Substring(2, 2);//获取年(2位)
            month = DateTime.Now.Month.ToString().PadLeft(2, '0');//获取月(2位)
            day = DateTime.Now.Day.ToString().PadLeft(2, '0');//获取日(2位)
            fdate = year + month + day;

            //获取查询流水号的位数
            digit2 = value.Length;//获取string类型位数  
            for (int i = 1; i <= labcum; i++)
            {
                sumqty += decimal.Parse(onelabqty);
                AppLabCode lb = new AppLabCode();
                lb.rightcode = rightcode;
                if (i == labcum)  //最后一张标签
                {
                    lb.labqty = (decimal.Parse(qty) - sumqty).ToString(); //单标签数量
                }
                else
                {
                    lb.labqty = onelabqty; //单标签数量
                }

                //流水号循环自增
                value2 = int.Parse(value) + i;
                //获取自增后流水号位数
                digit3 = value2.ToString().Length;
                //获取位数之差
                digitdiff = digit2 - digit3;
                //重新获取流水号位数
                digit2 = digit3;
                q = "";
                if (digitdiff < 0) //位数差为负数需要进补位
                {
                    cunm2 = value2.ToString();//最终流水号
                }
                else
                {
                    for (int j = 1; j <= digitdiff; j++)
                    {
                        q = q + "0";
                    }
                    cunm2 = q + value2.ToString();//最终流水号
                }
                Encode = prefix + fdate + cunm2; //最终编码
                lb.labcode = Encode;
                lb.partnumber = partcode;
                lab.Add(lb);  
            }
            cunm = cunm2;
            return lab;
        }
        #endregion
    }
}