using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
using SyntacticSugar.constant;

namespace WebAPI.Controllers
{
    //销售核销
    public class Cg_POStockInBillList_SecController : ApiController
    {
        //获取系统参数
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;


        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;
        #region 加入单据到待核销队列
        [Route("Cg_POStockInBillList_Sec/addBillToWaitSecList")]
        [HttpGet]
        public object addBillToWaitSecList(int hmainid, string user)
        {
            try
            {
                string sql = "select * from Kf_ICStockBillMain where HBillType = '1201' and HInterID = " + hmainid;
                ds = oCN.RunProcReturn(sql, "Kf_ICStockBillMain");

                string sql1 = "insert into Cg_POStockInBillList_Sec(HMaker,HMakeDate,HMainSourceInterID,MainSourceBillNo,HMainSourceBillType) " +
                    " values(" +
                    "'" + user + "'" +
                    "," + "getdate()" + "" +
                    "," + hmainid + "" +
                    ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "'" +
                    ",'" + "1201" + "'" +
                    ")";
                oCN.RunProc(sql1);

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 核销生成应收单
        [Route("Cg_POStockInBillList_Sec/SecToPayableBill")]
        [HttpGet]
        public object SecToPayableBill(string hmainidList, string user)
        {
            oCN.BeginTran();
            try
            {
                //将待核销列表中的数据标记为已核销
                string sql0 = $"update Cg_POStockInBillList_Sec set HSecEmp = '{user}',HSecTime = getdate() where HMainSourceInterID in ({hmainidList})";
                oCN.RunProc(sql0);

                //生成应付单
                string sql = $"select * from h_v_Kf_POStockInBillEdit where hmainid in ({ hmainidList})";
                ds = oCN.RunProcReturn(sql, "h_v_Kf_POStockInBillEdit");
                DAL.ClsCg_PayableBill oBill = new DAL.ClsCg_PayableBill();
                oBill.omodel.HInterID = DBUtility.ClsPub.CreateBillID("1114", ref DBUtility.ClsPub.sExeReturnInfo);
                oBill.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode_Prod("1114", ref DBUtility.ClsPub.sExeReturnInfo,false);
                oBill.omodel.HDate = DateTime.Now;
                oBill.omodel.HPeriod = DateTime.Now.Month;
                oBill.omodel.HYear = DateTime.Now.Year;
                oBill.omodel.HMainSourceInterID = 0;
                oBill.omodel.HMainSourceEntryID = 0;
                oBill.omodel.HMainSourceBillNo = "";
                oBill.omodel.HMainSourceBillType = "1201";
                oBill.omodel.HMaker = user;
                oBill.omodel.HMakeDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                oBill.omodel.HSSID = 0; ;
                oBill.omodel.HPSStyleID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HPSStyleID"]); ; ;
                oBill.omodel.HReceiveDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                oBill.omodel.HSupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSupID"]);
                oBill.omodel.HCurID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HCurID"]);
                oBill.omodel.HExRate = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[0]["汇率"]);
                oBill.omodel.HEmpID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HEmpID"]);
                oBill.omodel.HMangerID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HManagerID"]);
                oBill.omodel.HDeptID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]);
                oBill.omodel.HExplanation = "";
                oBill.omodel.HInnerBillNo = "";
                oBill.omodel.HRemark = "";
                oBill.omodel.HInvoiceBillNo = "";
                oBill.omodel.HProjectID = 0;

                for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    Model.ClsCg_PayableSub oItemSub = new Model.ClsCg_PayableSub();
                    oItemSub.HInterID = oBill.omodel.HInterID;
                    oItemSub.HEntryID = (i + 1);
                    oItemSub.HBillNo_bak = oBill.omodel.HBillNo;
                    oItemSub.HMaterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["HMaterID"]);
                    oItemSub.HUnitID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["HUnitID"]);
                    oItemSub.HQty = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["实收数量"]);
                    oItemSub.HPrice = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["单价"]);
                    oItemSub.HTaxPrice = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["含税单价"]);
                    oItemSub.HDiscountRate = 1; ;
                    oItemSub.HRelTaxPrice = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["含税单价"]);
                    oItemSub.HTaxRate = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["税率"]);
                    oItemSub.HTaxMoney = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["金额"]) * DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["税率"]);
                    oItemSub.HlineTotal = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["含税金额"]);
                    oItemSub.HlineTotalBB = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["含税金额"]) * oBill.omodel.HExRate;
                    oItemSub.HMoney = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["金额"]);
                    oItemSub.HMoneyBB = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["金额"]) * oBill.omodel.HExRate;
                    oItemSub.HRemark = "";
                    oItemSub.HSourceInterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["hmainid"]);
                    oItemSub.HSourceEntryID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["hsubid"]);
                    oItemSub.HSourceBillNo =  DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["单据号"]);
                    oItemSub.HSourceBillType = "1201";
                    oItemSub.HRelationQty = 0;
                    oItemSub.HRelationMoney = 0;

                    oBill.DetailColl.Add(oItemSub);
                }

                bool bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);

                if (bResult)
                {
                    oCN.Commit();
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "核销成功！";
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
                else
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "核销失败！" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}