using Gm_WMS.DataAccess.DataService;
using Stone.Common;
using Stone.Entity;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace Stone.WinBiz.SystemData
{
    public class F_BillNo
    {
        public static string GetBillNo(LocalDBService db, string type, int len)
        {
            string sql = $"exec p_GetBillNo '{type}'";
            int ret = Convert.ToInt32(db.Exec_Object(sql));

            return ret.ToString().PadLeft(len, '0');

        }

        public static void CancelBillNo(LocalDBService db, string type)
        {
            Entity_t_BillNo t_BillNo = new Entity_t_BillNo(db);
            DataTable dtBillNo = t_BillNo.GetData($"[type]='{type}'").Tables[0];
            if(dtBillNo.Rows.Count > 0)
            {
                dtBillNo.Rows[0]["value"] = Convert.ToInt32(dtBillNo.Rows[0]["value"]) - 1;

                if(Convert.ToInt32(dtBillNo.Rows[0]["value"]) <= 0)
                {
                    t_BillNo.Del(dtBillNo.Rows[0]);
                }
                else
                {
                    t_BillNo.Edit(dtBillNo.Rows[0]);
                }

                
            }
        }

        public static int GetID(LocalDBService db)
        {
            string year = MyDateTime.GetServerDateTime().Year.ToString();
            year = year.Substring(2, 2); //取两位年

            return Convert.ToInt32(year + GetBillNo(db, year, 5));

        }

    }
}