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

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

        public ClsSc_WorkProcInfoBoard()
        {
            base.MvarItemKeySub = "Sc_WorkProcInfoBoard";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey="Sc_WorkProcInfoBoard";
            base.MvarReportTitle = "产线小看板";
            base.BillType="3779"; 
        }

        #region 固定代码

        ~ClsSc_WorkProcInfoBoard()
        {
            
        }
       
        #endregion   自定义方法
        //修改单据
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            return true;
             //
        }
        //新增单据
        public override bool AddBill(ref string sReturn)
        {
            return true;
            //
        }
        //显示单据
        public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //查询主表
                DataSet Ds ;
                Ds = oCn.RunProcReturn("Select * from Sc_WorkProcInfoBoard Where HSourceID=" + lngBillKey.ToString(), "Sc_WorkProcInfoBoard");
                if(Ds.Tables[0].Rows.Count==0)
                {
                    sReturn = "记录未找到！";
                    return false;
                }
                //赋值
                omodel.HCaption = Ds.Tables[0].Rows[0]["HCaption"].ToString().Trim();
                omodel.HDay = Ds.Tables[0].Rows[0]["HDay"].ToString().Trim();
                omodel.HWeek = Ds.Tables[0].Rows[0]["HWeek"].ToString().Trim();
                omodel.HTime = Ds.Tables[0].Rows[0]["HTime"].ToString().Trim();
                omodel.HUnitPlanQty = Ds.Tables[0].Rows[0]["HUnitPlanQty"].ToString().Trim();
                omodel.HUnitQty = Ds.Tables[0].Rows[0]["HUnitQty"].ToString().Trim();
                omodel.HUnitDiff = Ds.Tables[0].Rows[0]["HUnitDiff"].ToString().Trim();
                omodel.HUnitBadCount = Ds.Tables[0].Rows[0]["HUnitBadCount"].ToString().Trim();
                omodel.HSumBadCount = Ds.Tables[0].Rows[0]["HSumBadCount"].ToString().Trim();
                omodel.HBadRate = Ds.Tables[0].Rows[0]["HBadRate"].ToString().Trim();
                omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim();
                omodel.HMaterModel = Ds.Tables[0].Rows[0]["HMaterModel"].ToString().Trim();
                omodel.HSumPlanQty = Ds.Tables[0].Rows[0]["HSumPlanQty"].ToString().Trim();
                omodel.HSumQty = Ds.Tables[0].Rows[0]["HSumQty"].ToString().Trim();
                omodel.HRemark = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim();
                 
                sReturn = "显示单据成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }
       
        
    }

}