using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DAL
{
    public class ClsKf_ICBal : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsKf_ICBal omodel = new Model.ClsKf_ICBal();

        public ClsKf_ICBal()
        {
            base.MvarItemKey = "Kf_ICBal";
            base.MvarReportTitle = "期初结存";
        }

        #region 固定代码

        ~ClsKf_ICBal()
        {

        }

        #endregion   自定义方法
        //修改单据
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //oCn.BeginTran();
                ////更新主表
                //oCn.RunProc("UpDate " + MvarItemKey + " set " +
                //" HYear=" + omodel.HYear.ToString() +
                //",HPeriod=" + omodel.HPeriod.ToString() +
                //",HMaterID=" + omodel.HMaterID.ToString() +
                //",HBatchNo='" + omodel.HBatchNo + "'" +
                //",HBeginQty=" + omodel.HBeginQty.ToString() +
                //",HReceive=" + omodel.HReceive.ToString() +
                //",HSend=" + omodel.HSend.ToString() +
                //",HYtdReceive=" + omodel.HYtdReceive.ToString() +
                //",HYtdSend=" + omodel.HYtdSend.ToString() +
                //",HEndQty=" + omodel.HEndQty.ToString() +
                //",HBeginBal=" + omodel.HBeginBal.ToString() +
                //",HDebit=" + omodel.HDebit.ToString() +
                //",HCredit=" + omodel.HCredit.ToString() +
                //",HEndBal=" + omodel.HEndBal.ToString() +
                //",HYtdDebit=" + omodel.HYtdDebit.ToString() +
                //",HYtdCredit=" + omodel.HYtdCredit.ToString() +
                //",HBeginDiff=" + omodel.HBeginDiff.ToString() +
                //",HReceiveDiff=" + omodel.HReceiveDiff.ToString() +
                //",HSendDiff=" + omodel.HSendDiff.ToString() +
                //",HEndDiff=" + omodel.HEndDiff.ToString() +
                //",HYtdReceiveDiff=" + omodel.HYtdReceiveDiff.ToString() +
                //",HYtdSendDiff=" + omodel.HYtdSendDiff.ToString() +
                //" where HInterID=" + lngBillKey.ToString());
                ////删除关联
                //DeleteRelation(ref sReturn, lngBillKey);

                sReturn = "修改单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
        //新增单据
        public override bool AddBill(ref string sReturn)
        {
            try
            {
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                //主表
                oCn.RunProc("Insert Into " + MvarItemKey + " " +
                "(HMaker,HMakeDate" +
                ",HYear,HPeriod,HMaterID,HBatchNo,HBeginQty" +
                ",HReceive,HSend,HYtdReceive,HYtdSend,HEndQty" +
                ",HBeginBal,HDebit,HCredit,HEndBal,HYtdDebit" +
                ",HYtdCredit,HBeginDiff,HReceiveDiff,HSendDiff,HEndDiff" +
                ",HYtdReceiveDiff,HYtdSendDiff" +
                ") " +
                " values('" + DBUtility.ClsPub.CurUserName + "',getdate()" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + "," + omodel.HMaterID.ToString() + ",'" + omodel.HBatchNo + "'," + omodel.HBeginQty.ToString() +
                ", " + omodel.HReceive.ToString() + "," + omodel.HSend.ToString() + "," + omodel.HYtdReceive.ToString() + "," + omodel.HYtdSend.ToString() + "," + omodel.HEndQty.ToString() +
                ", " + omodel.HBeginBal.ToString() + "," + omodel.HDebit.ToString() + "," + omodel.HCredit.ToString() + "," + omodel.HEndBal.ToString() + "," + omodel.HYtdDebit.ToString() +
                ", " + omodel.HYtdCredit.ToString() + "," + omodel.HBeginDiff.ToString() + "," + omodel.HReceiveDiff.ToString() + "," + omodel.HSendDiff.ToString() + "," + omodel.HEndDiff.ToString() +
                ", " + omodel.HYtdReceiveDiff.ToString() + "," + omodel.HYtdSendDiff.ToString() +
                ") ");
                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
        //显示单据
        public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                ////查询主表
                //DataSet Ds;
                //Ds = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HInterID=" + lngBillKey.ToString(), MvarItemKey);
                //if (Ds.Tables[0].Rows.Count == 0)
                //{
                //    sReturn = "单据未找到！";
                //    return false;
                //}
                //omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"].ToString());
                //omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"].ToString());
                //omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"].ToString());
                //omodel.HBatchNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBatchNo"].ToString());
                //omodel.HBeginQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HBeginQty"].ToString());
                //omodel.HReceive = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HReceive"].ToString());
                //omodel.HSend = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HSend"].ToString());
                //omodel.HYtdReceive = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HYtdReceive"].ToString());
                //omodel.HYtdSend = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HYtdSend"].ToString());
                //omodel.HEndQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HEndQty"].ToString());
                //omodel.HBeginBal = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HBeginBal"].ToString());
                //omodel.HDebit = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HDebit"].ToString());
                //omodel.HCredit = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HCredit"].ToString());
                //omodel.HEndBal = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HEndBal"].ToString());
                //omodel.HYtdDebit = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HYtdDebit"].ToString());
                //omodel.HYtdCredit = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HYtdCredit"].ToString());
                //omodel.HBeginDiff = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HBeginDiff"].ToString());
                //omodel.HReceiveDiff = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HReceiveDiff"].ToString());
                //omodel.HSendDiff = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HSendDiff"].ToString());
                //omodel.HEndDiff = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HEndDiff"].ToString());
                //omodel.HYtdReceiveDiff = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HYtdReceiveDiff"].ToString());
                //omodel.HYtdSendDiff = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HYtdSendDiff"].ToString());
                ////
                //omodel.HMaker = Ds.Tables[0].Rows[0]["HMaker"].ToString().Trim();
                //omodel.HMakeDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HMakeDate"].ToString());
                //omodel.HCheckMan = Ds.Tables[0].Rows[0]["HCheckMan"].ToString().Trim();
                //omodel.HCheckDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HCheckDate"].ToString());
                sReturn = "显示单据成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }


        //重复会计年+会计月+物料
        public bool HavBillCode(Int64 sHYear, Int64 sHPeriod, Int64 sHMater)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " where HYear='" + sHYear + "'and HPeriod='" + sHPeriod + "'and HMaterID='" + sHMater + "'", MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }


    }
}