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

namespace DAL
{
    public class ClsCB_EntrustMoneyCost_D:DBUtility.ClsXt_BaseBill 
    {

        public Model.ClsCB_EntrustMoneyCost_M omodel = new Model.ClsCB_EntrustMoneyCost_M();
        
        public ClsCB_EntrustMoneyCost_D()
        {
            base.MvarItemKeySub = "";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "CB_EntrustMoneyCost";
            base.MvarReportTitle="委外成本表";
            base.BillType="1815";
            base.HBillSubType = "1815";

        }

        #region 固定代码

        ~ClsCB_EntrustMoneyCost_D()
        {
            //DetailColl = null;
        }
       
        #endregion   自定义方法
        //新增
        public override bool AddBill(ref string sReturn)
        {
            
            try
            {
                oCn.BeginTran();
                //foreach (Model.ClsCB_MaterMoneyCost_M omodel in DetailColl)
                //{
                oCn.RunProc("Insert into CB_EntrustMoneyCost " +
                    " (HYear,HPeriod,HBillType,HRelationInterID" +
                    ",HMaterID,HQty,HPrice,HMoney" +
                    ",HDeptID,HRemark,HMaker,HMakeDate" +
                    ",HPrice_New,HPrice_H,HPrice_L,HProcID)" +
                    " Values("
                    + omodel.HYear.ToString() + "," +omodel.HPeriod.ToString() + ",'" + omodel.HBillType+"',"+ omodel.HRelationInterID.ToString() +
                    "," + omodel.HMaterID.ToString() +"," + omodel.HQty.ToString() +","+omodel.HPrice.ToString() +"," +omodel.HMoney.ToString() +
                    "," + omodel.HDeptID.ToString() +",'" +omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + 
                    "," + omodel.HPrice_New.ToString() +"," +omodel.HPrice_H.ToString() +"," +omodel.HPrice_L.ToString() + ","  +omodel.HProcID.ToString() +

                     ") ");
                //修改上级为非末级代码
                //}
                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }

        //修改
     

    
    }
}