设备维修记录单，增加 选择 设备维修登记单 为源单的功能

zzr99

2021-11-22 076c536729efb1434705942fec302ea98db9d0f3

设备维修记录单，增加 选择 设备维修登记单 为源单的功能

 DAL/生产管理/模具管理/ClsSb_MouldRepairWorkBill.cs

@@ -65,6 +65,9 @@
                ",HSupID=" + omodel.HSupID.ToString() +
                ",HRepairType='" + omodel.HRepairType + "'" +
                ",HNewModel='" + omodel.HNewModel + "'" +
                ",HMainSourceBillType='"+ omodel.HMainSourceBillType+"'"+
                ",HMainSourceInterID=" + omodel.HMainSourceInterID.ToString()+
                ",HMainSourceEntryID="+ omodel.HMainSourceEntryID.ToString()+
                ",HNewDesignLife=" + omodel.HNewDesignLife.ToString() +
                " where HInterID=" + lngBillKey.ToString());
                //鍒犻櫎鍏宠仈
@@ -124,14 +127,14 @@
                ",HEquipID,HRepairID,HRepairBeginDate,HRepairEndDate,HRepairContent" +                
                ",HCycleUnit,HPlanTimes,HTimes,HEmpID,HManagerID"+
                ",HDeptID,HExplanation,HInnerBillNo,HMouldID" +
                ",HSupID,HRepairType,HNewModel,HNewDesignLife" +
                ",HSupID,HRepairType,HNewModel,HNewDesignLife,HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID" +
                ") " +
                " values('" + this.BillType + "','"  + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" +
                "," + omodel.HEquipID.ToString() + "," + omodel.HRepairID.ToString() + ",'" + omodel.HRepairBeginDate + "','" + omodel.HRepairEndDate + "','" + omodel.HRepairContent + "'" +
                ",'" + omodel.HCycleUnit + "'," + omodel.HPlanTimes.ToString() + "," + omodel.HTimes.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() +
                "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HMouldID.ToString() +
                 ", " + omodel.HSupID.ToString() + ",'" + omodel.HRepairType + "','" + omodel.HNewModel + "'," + omodel.HNewDesignLife.ToString() +
                 ", " + omodel.HSupID.ToString() + ",'" + omodel.HRepairType + "','" + omodel.HNewModel + "'," + omodel.HNewDesignLife.ToString() +",'"+ omodel.HMainSourceBillType+"',"+ omodel.HMainSourceInterID.ToString()+","+ omodel.HMainSourceEntryID.ToString()+
                ") ");
                //鎻掑叆瀛愯〃
                foreach (Model.ClsSb_MouldRepairWorkBillSub oSub in DetailColl)

 WebAPI/DLL/ClsSb_EquipRepairWorkBill.cs

@@ -61,6 +61,9 @@
                ",HExplanation='" + omodel.HExplanation + "'" +
                ",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
                ",HRepairContent='" + omodel.HRepairContent + "'" +
                ",HMainSourceBillType='"+ omodel.HMainSourceBillType+"'"+
                ",HMainSourceInterID="+ omodel.HMainSourceInterID.ToString()+
                ",HMainSourceEntryID="+ omodel.HMainSourceEntryID.ToString()+
                ",HCycleUnit='" + omodel.HCycleUnit + "'" +
                
                " where HInterID=" + lngBillKey.ToString());
@@ -120,12 +123,13 @@
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HEquipID,HRepairID,HPlanTimes,HEmpID,HManagerID,HTimes" +
                ",HDeptID,HExplanation,HInnerBillNo,HRepairBeginDate,HRepairEndDate,HRepairContent,HCycleUnit" +
                ",HDeptID,HExplanation,HInnerBillNo,HRepairBeginDate,HRepairEndDate,HRepairContent,HCycleUnit,HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID" +
                ") " +
                " values('" + this.BillType + "','"  + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" +
                ", " + omodel.HEquipID.ToString() + "," + omodel.HRepairID.ToString() + "," + omodel.HPlanTimes.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HTimes.ToString() +
                ", " + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','" + omodel.HRepairBeginDate.ToShortDateString() + "','" + omodel.HRepairEndDate.ToShortDateString() + "','" + omodel.HRepairContent + "','" + omodel.HCycleUnit + "'" +
                ", " + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','" + omodel.HRepairBeginDate.ToShortDateString() + "','" + omodel.HRepairEndDate.ToShortDateString() + "','" + omodel.HRepairContent + "','" + omodel.HCycleUnit + "','" +
                 omodel.HMainSourceBillType+"',"+ omodel.HMainSourceInterID.ToString()+","+ omodel.HMainSourceEntryID.ToString() +
                ") ");
                //鎻掑叆瀛愯〃
                foreach (Models.ClsSb_EquipRepairWorkBillSub oSub in DetailColl)

 WebAPI/Models/ClsSb_EquipRepairWorkBillMain.cs

@@ -23,6 +23,6 @@
        public string HCycleUnit;//varchar(10)    --鏃堕棿鍗曚綅(灏忔椂锛屽ぉ)
        public Single HPlanTimes;// money         --璁″垝缁翠慨宸ユ椂
        public Single HTimes;// money       --瀹為檯缁翠慨宸ユ椂

        
    }
}