New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | using System.Data; |
| | | |
| | | namespace WebAPI.DLL |
| | | { |
| | | public class ClsQC_NoPassProdCheckBill:DBUtility.ClsXt_BaseBill |
| | | { |
| | | public Model.ClsQC_NoPassProdCheckBillMain omodel = new Model.ClsQC_NoPassProdCheckBillMain(); |
| | | public List<Model.ClsQC_NoPassProdCheckBillSub> DetailColl = new List<Model.ClsQC_NoPassProdCheckBillSub>(); |
| | | //public List<Model.ClsQC_NoPassProdCheckBillSub_Item> DetailColl1 = new List<Model.ClsQC_NoPassProdCheckBillSub_Item>(); |
| | | public ClsQC_NoPassProdCheckBill() |
| | | { |
| | | base.MvarItemKeySub = "QC_NoPassProdCheckBillSub"; |
| | | base.MvarItemKeySub2 = ""; |
| | | base.MvarItemKeySub3 = ""; |
| | | base.MvarItemKeySub4 = ""; |
| | | base.MvarItemKey="QC_NoPassProdCheckBillMain"; |
| | | base.MvarReportTitle="不合格评审单"; |
| | | base.BillType="7509"; |
| | | base.HBillSubType = "7509"; |
| | | |
| | | } |
| | | |
| | | #region 固定代码 |
| | | |
| | | ~ClsQC_NoPassProdCheckBill() |
| | | { |
| | | DetailColl = null; |
| | | } |
| | | |
| | | #endregion 自定义方法 |
| | | |
| | | |
| | | //删除单据 |
| | | public override bool DeleteBill(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //删除关联 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | oCn.RunProc("exec h_p_QC_NoPassProdCheckBillToProcExch " + lngBillKey.ToString() + ",-1"); |
| | | //删除明细表 |
| | | DeleteBillSub(lngBillKey); |
| | | DeleteBillSub2(lngBillKey); |
| | | DeleteBillSub3(lngBillKey); |
| | | DeleteBillSub4(lngBillKey); |
| | | //删除主表 |
| | | DeleteBillMain(lngBillKey); |
| | | sReturn = "删除单据成功!"; |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | |
| | | //修改单据 |
| | | public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | // |
| | | oCn.BeginTran(); |
| | | oCn.RunProc("exec h_p_QC_NoPassProdCheckBillToProcExch " + lngBillKey.ToString() + ",-1"); |
| | | //更新主表 |
| | | oCn.RunProc("UpDate QC_NoPassProdCheckBillMain set " + |
| | | " HBillNo='" + omodel.HBillNo + "'" + //固定赋值=============== |
| | | ",HDate='" + omodel.HDate + "'" + |
| | | ",HYear='" + omodel.HYear.ToString() + "'" + |
| | | ",HPeriod='" + omodel.HPeriod.ToString() + "'" + |
| | | ",HBillStatus='" + omodel.HBillStatus + "'" + |
| | | ",HRemark='" + omodel.HRemark + "'" + |
| | | ",HGroupName='" + omodel.HGroupName + "'" + |
| | | //",HBacker='"+omodel.HBacker+"'"+ |
| | | //",HBackDate='" + omodel.HBackDate + "'" + |
| | | //",HBackRemark='"+omodel.HBackRemark+"'"+ |
| | | //",HChecker='" + omodel.HChecker + "'" + |
| | | //",HCheckDate='" + omodel.HCheckDate + "'" + |
| | | //",HMaker='" + omodel.HMaker + "'" + |
| | | //",HMakeDate='" + omodel.HMakeDate + "'" + |
| | | ",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" + |
| | | ",HUpDateDate=getdate()" + |
| | | //",HCloseMan='" + omodel.HCloseMan + "'" + |
| | | //",HCloseDate='" + omodel.HCloseDate + "'" + |
| | | //",HCloseType="+omodel.HCloseType.ToString()+ |
| | | //",HDeleteMan='" + omodel.HDeleteMan + "'" + |
| | | //",HDeleteDate='" + omodel.HDeleteDate + "'" + |
| | | ",HPrintQty="+omodel.HPrintQty.ToString()+ |
| | | //======================================== |
| | | //",HSupID=" + omodel.HSupID.ToString() + |
| | | //",HEmpID=" + omodel.HEmpID.ToString() + |
| | | ",HSourceID=" + omodel.HSourceID.ToString() + |
| | | ",HProcExchQty=" + omodel.HProcExchQty.ToString() + |
| | | ",HICMOInterID=" + omodel.HICMOInterID.ToString() + |
| | | ",HICMOBillNo='" + omodel.HICMOBillNo + "'" + |
| | | ",HInStockQty=" + omodel.HInStockQty.ToString() + |
| | | ",HCheckQty=" + omodel.HCheckQty.ToString() + |
| | | ",HRightQty=" + omodel.HRightQty.ToString() + |
| | | ",HBadQty=" + omodel.HBadQty.ToString() + |
| | | ",HPlanQty=" + omodel.HPlanQty.ToString() + |
| | | ",HBadPNL=" + omodel.HBadPNL.ToString() + |
| | | ",HPlanPNL=" + omodel.HPlanPNL.ToString() + |
| | | ",HFirstCheckEmp=" + omodel.HFirstCheckEmp.ToString() + |
| | | ",HOrderProcNo='" + omodel.HOrderProcNo + "'" + |
| | | ",HCheckerResult='" + omodel.HCheckerResult + "'" + |
| | | ",HNote='" + omodel.HNote + "'" + |
| | | |
| | | ",HMaterID=" + omodel.HMaterID.ToString() + |
| | | ",HProcID=" + omodel.HProcID.ToString() + |
| | | //",HProcExchInterID=" + omodel.HProcExchInterID.ToString() + |
| | | //",HProcExchEntryID=" + omodel.HProcExchEntryID.ToString() + |
| | | //",HProcExchBillNo='" + omodel.HProcExchBillNo + "'" + |
| | | |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //删除关联 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | //删除子表 |
| | | DeleteBillSub(lngBillKey); |
| | | //插入子表 |
| | | omodel.HInterID = lngBillKey; |
| | | foreach (Model.ClsQC_NoPassProdCheckBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into QC_NoPassProdCheckBillSub " + |
| | | " (HInterID,HBillNo_bak,HEntryID,HCloseMan,HMRBChecker" + |
| | | ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSQProcName,HZRProcName,HPSProcName" + |
| | | ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HUnitID,HMustQty,HBadQty,HBadReasonID,HDisposeNote" + |
| | | ",HEmpName,HProcID,HWasterReasonName,HPunishmentBillNo,HBadPCSQty,HQCResultID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HMRBChecker + "'" + |
| | | ",getdate()," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'," + oSub.HSourceInterID.ToString() + ",'" + oSub.HSQProcName + "','" + oSub.HZRProcName + "','" + oSub.HPSProcName + "'" + |
| | | "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HMustQty.ToString() + "," + oSub.HBadQty.ToString() + "," + oSub.HBadReasonID.ToString() + ",'" + oSub.HDisposeNote + "'" + |
| | | ",'" + oSub.HEmpName.ToString() + "'," + oSub.HProcID + ",'" + oSub.HWasterReasonName + "','" + oSub.HPunishmentBillNo + "'," + oSub.HBadPCSQty.ToString() + "," + oSub.HQCResultID.ToString() + |
| | | ") "); |
| | | } |
| | | //foreach (Model.ClsQC_NoPassProdCheckBillSub_Item oSub2 in DetailColl1) |
| | | //{ |
| | | // oCn.RunProc("Insert into QC_NoPassProdCheckBillSub_Item " + |
| | | // " (HInterID,HBillNo_bak,HEntryID,HCloseMan" + |
| | | // ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" + |
| | | // ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | // ",HMaintainItemID,HMaintainItem,HMaintainPart,HClaim,HManagerID" + |
| | | |
| | | // ") values(" |
| | | // + omodel.HInterID.ToString() + ",'" + oSub2.HBillNo_bak + "'," + oSub2.HEntryID.ToString() + ",'" + oSub2.HCloseMan + "'" + |
| | | // ",getdate()," + Convert.ToString(oSub2.HCloseType ? 1 : 0) + ",'" + oSub2.HRemark + "'," + oSub2.HSourceInterID.ToString() + |
| | | // "," + oSub2.HSourceEntryID.ToString() + ",'" + oSub2.HSourceBillNo + "','" + oSub2.HSourceBillType + "'," + oSub2.HRelationQty.ToString() + "," + oSub2.HRelationMoney.ToString() + |
| | | // "," + oSub2.HMaintainItemID.ToString() + ",'" + oSub2.HMaintainItem + "','" + oSub2.HMaintainPart + "','" + oSub2.HClaim + "'," + oSub2.HManagerID.ToString() + |
| | | // ") "); |
| | | //} |
| | | // |
| | | //foreach (Model.ClsQC_NoPassProdCheckBillSub oSub in DetailColl) |
| | | //{ |
| | | // Ds = oCn.RunProcReturn("exec h_p_QC_NoPassProdCheckBill_Qty " + oSub.HICMOInterID, ""); |
| | | // if (Ds.Tables[0].Rows.Count == 0) |
| | | // return; |
| | | // if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBool"]) == "Y") |
| | | // { |
| | | // sReturn = "汇报数量超过计划数量!不允许保存"; |
| | | // return false; |
| | | // } |
| | | //} |
| | | //根据内码 回填对应流转卡 不良关联数量 |
| | | oCn.RunProc("exec h_p_QC_NoPassProdCheckBillToProcExch " + omodel.HInterID.ToString() + ",1"); |
| | | ////////////////////////////// |
| | | //DataSet Ds; |
| | | //Ds = oCn.RunProcReturn("exec h_p_QC_NoPassProdCheckBillQtyCtrl " + omodel.HInterID.ToString(), "h_p_QC_NoPassProdCheckBillQtyCtrl"); |
| | | //if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | //{ |
| | | // oCn.RollBack(); |
| | | // return false; |
| | | //} |
| | | //if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBack"]) == "2") |
| | | //{ |
| | | // sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBackRemark"]); |
| | | // oCn.RollBack(); |
| | | // return false; |
| | | //} |
| | | //////////////////////// |
| | | |
| | | |
| | | // |
| | | sReturn = "修改单据成功!"; |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | //新增单据 |
| | | public override bool AddBill(ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | //得到mainid |
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //若MAINDI重复则重新获取 |
| | | oCn.BeginTran(); |
| | | //主表 |
| | | oCn.RunProc("Insert Into QC_NoPassProdCheckBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark,HGroupName" + |
| | | ",HSourceID,HICMOInterID,HICMOBillNo,HInStockQty,HCheckQty,HRightQty" + |
| | | ",HBadQty,HPlanQty,HBadPNL,HPlanPNL,HFirstCheckEmp" + |
| | | ",HCheckerResult,HNote,HWorkCenterID" + |
| | | ",HMaterID,HProcID,HMainSourceInterID" + |
| | | ",HProcExchInterID,HProcExchEntryID,HProcExchBillNo,HOrderProcNo,HProcExchQty" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HGroupName.ToString() + "'" + |
| | | "," + omodel.HSourceID.ToString() + "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HInStockQty.ToString() + "," + omodel.HCheckQty.ToString() + "," + omodel.HRightQty.ToString() + |
| | | "," + omodel.HBadQty.ToString() + "," + omodel.HPlanQty.ToString() + "," + omodel.HBadPNL.ToString() + "," + omodel.HPlanPNL.ToString() + "," + omodel.HFirstCheckEmp.ToString() + |
| | | ",'" + omodel.HCheckerResult + "','" + omodel.HNote + "'," + omodel.HWorkCenterID.ToString() + "" + |
| | | "," + omodel.HMaterID + "," + omodel.HProcID + "," + omodel.HMainSourceInterID + |
| | | "," + omodel.HProcExchInterID + "," + omodel.HProcExchEntryID + ",'" + omodel.HProcExchBillNo + "','" + omodel.HOrderProcNo + "'," + omodel.HProcExchQty.ToString() + |
| | | ") "); |
| | | //插入子表 |
| | | foreach (Model.ClsQC_NoPassProdCheckBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into QC_NoPassProdCheckBillSub " + |
| | | " (HInterID,HBillNo_bak,HEntryID,HCloseMan,HMRBChecker" + |
| | | ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID,HSQProcName,HZRProcName,HPSProcName" + |
| | | ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HUnitID,HMustQty,HBadQty,HBadReasonID,HDisposeNote" + |
| | | ",HEmpName,HProcID,HWasterReasonName,HPunishmentBillNo,HBadPCSQty,HQCResultID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HMRBChecker + "'" + |
| | | ",getdate()," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'," + oSub.HSourceInterID.ToString() + ",'" + oSub.HSQProcName + "','" + oSub.HZRProcName + "','" + oSub.HPSProcName + "'" + |
| | | "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HMustQty.ToString() + "," + oSub.HBadQty.ToString() + "," + oSub.HBadReasonID.ToString() + ",'" + oSub.HDisposeNote + "'" + |
| | | ",'" + oSub.HEmpName.ToString() + "'," + oSub.HProcID + ",'" + oSub.HWasterReasonName + "','" + oSub.HPunishmentBillNo + "'," + oSub.HBadPCSQty.ToString() + "," + oSub.HQCResultID.ToString() + |
| | | ") "); |
| | | } |
| | | //foreach (Model.ClsQC_NoPassProdCheckBillSub_Item oSub2 in DetailColl1) |
| | | //{ |
| | | // oCn.RunProc("Insert into QC_NoPassProdCheckBillSub_Item " + |
| | | // " (HInterID,HBillNo_bak,HEntryID,HCloseMan" + |
| | | // ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" + |
| | | // ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | // ",HMaintainItemID,HMaintainItem,HMaintainPart,HClaim,HManagerID" + |
| | | |
| | | // ") values(" |
| | | // + omodel.HInterID.ToString() + ",'" + oSub2.HBillNo_bak + "'," + oSub2.HEntryID.ToString() + ",'" + oSub2.HCloseMan + "'" + |
| | | // ",getdate()," + Convert.ToString(oSub2.HCloseType ? 1 : 0) + ",'" + oSub2.HRemark + "'," + oSub2.HSourceInterID.ToString() + |
| | | // "," + oSub2.HSourceEntryID.ToString() + ",'" + oSub2.HSourceBillNo + "','" + oSub2.HSourceBillType + "'," + oSub2.HRelationQty.ToString() + "," + oSub2.HRelationMoney.ToString() + |
| | | // "," + oSub2.HMaintainItemID.ToString() + ",'" + oSub2.HMaintainItem + "','" + oSub2.HMaintainPart + "','" + oSub2.HClaim + "'," + oSub2.HManagerID.ToString() + |
| | | // ") "); |
| | | //} |
| | | // |
| | | //foreach (Model.ClsQC_NoPassProdCheckBillSub oSub in DetailColl) |
| | | //{ |
| | | // Ds = oCn.RunProcReturn("exec h_p_QC_NoPassProdCheckBill_Qty " + oSub.HICMOInterID, ""); |
| | | // if (Ds.Tables[0].Rows.Count == 0) |
| | | // return; |
| | | // if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBool"]) == "Y") |
| | | // { |
| | | // sReturn = "汇报数量超过计划数量!不允许保存"; |
| | | // return false; |
| | | // } |
| | | //} |
| | | //根据内码 回填对应流转卡 不良关联数量 |
| | | oCn.RunProc("exec h_p_QC_NoPassProdCheckBillToProcExch " + omodel.HInterID.ToString() + ",1"); |
| | | // |
| | | ////////////////////////////// |
| | | //DataSet Ds; |
| | | //Ds = oCn.RunProcReturn("exec h_p_QC_NoPassProdCheckBillQtyCtrl " + omodel.HInterID.ToString(), "h_p_QC_NoPassProdCheckBillQtyCtrl"); |
| | | //if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | //{ |
| | | // oCn.RollBack(); |
| | | // return false; |
| | | //} |
| | | //if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBack"]) == "2") |
| | | //{ |
| | | // sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBackRemark"]); |
| | | // oCn.RollBack(); |
| | | // return false; |
| | | //} |
| | | //////////////////////// |
| | | |
| | | // |
| | | 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 QC_NoPassProdCheckBillMain Where HInterID=" + lngBillKey.ToString(), "QC_NoPassProdCheckBillMain"); |
| | | if(Ds.Tables[0].Rows.Count==0) |
| | | { |
| | | sReturn = "单据未找到!"; |
| | | return false; |
| | | } |
| | | //固定赋值=========================================== |
| | | omodel.HInterID =DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]); |
| | | omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim(); |
| | | omodel.HDate =DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]); |
| | | omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]); |
| | | omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]); |
| | | omodel.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNowID"]); |
| | | omodel.HCheckItemNextID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNextID"]); |
| | | omodel.HCheckFlowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckFlowID"]); |
| | | omodel.HRemark = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim(); |
| | | omodel.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"]); |
| | | omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]); |
| | | omodel.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillSubType"]); |
| | | omodel.HMaker = Ds.Tables[0].Rows[0]["HMaker"].ToString().Trim(); |
| | | omodel.HMakeDate = Ds.Tables[0].Rows[0]["HMakeDate"].ToString().Trim(); |
| | | omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim(); |
| | | omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim(); |
| | | omodel.HBackDate = Ds.Tables[0].Rows[0]["HBackDate"].ToString().Trim(); |
| | | omodel.HBacker = Ds.Tables[0].Rows[0]["HBacker"].ToString().Trim(); |
| | | omodel.HCheckDate = Ds.Tables[0].Rows[0]["HCheckDate"].ToString().Trim(); |
| | | omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim(); |
| | | omodel.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim(); |
| | | omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim(); |
| | | omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim(); |
| | | omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim(); |
| | | //======================================================== |
| | | ////== |
| | | //omodel.HWHID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWHID"]); |
| | | //omodel.HSCWHID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSCWHID"]); |
| | | //omodel.HSupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSupID"]); |
| | | //omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]); |
| | | //omodel.HMangerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMangerID"]); |
| | | omodel.HSourceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceID"]); |
| | | omodel.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOInterID"]); |
| | | omodel.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HICMOBillNo"]); |
| | | omodel.HInStockQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInStockQty"]); ; |
| | | omodel.HCheckQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckQty"]); |
| | | omodel.HRightQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRightQty"]); |
| | | omodel.HBadQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBadQty"]); |
| | | omodel.HPlanQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPlanQty"]); |
| | | omodel.HBadPNL = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBadPNL"]); |
| | | omodel.HPlanPNL = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPlanPNL"]); |
| | | omodel.HFirstCheckEmp = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HFirstCheckEmp"]); |
| | | omodel.HCheckerResult = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCheckerResult"]); |
| | | omodel.HNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HNote"]); |
| | | //omodel.HRedBlueFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HRedBlueFlag"]); |
| | | |
| | | omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]); |
| | | omodel.HWorkCenterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWorkCenterID"]); |
| | | omodel.HProcID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcID"]); |
| | | omodel.HProcExchInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcExchInterID"]); |
| | | omodel.HProcExchEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcExchEntryID"]); |
| | | omodel.HProcExchBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcExchBillNo"]); |
| | | omodel.HGroupName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HGroupName"]); |
| | | omodel.HOrderProcNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOrderProcNo"]); |
| | | omodel.HProcExchQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HProcExchQty"]); |
| | | // |
| | | |
| | | //循环 |
| | | DataSet DsSub ; |
| | | DsSub = oCn.RunProcReturn("Select * from QC_NoPassProdCheckBillSub Where HInterID=" + lngBillKey.ToString(), "QC_NoPassProdCheckBillSub"); |
| | | DetailColl.Clear();//清空 |
| | | for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) |
| | | { |
| | | Model.ClsQC_NoPassProdCheckBillSub oSub = new Model.ClsQC_NoPassProdCheckBillSub(); |
| | | // 固定赋值=============================================== |
| | | oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); |
| | | oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HBillNo_bak"]); |
| | | oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCloseMan"]); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEntryCloseDate"]); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[i]["HCloseType"]); |
| | | oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim(); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceInterID"]); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceEntryID"]); |
| | | oSub.HSourceBillType = DsSub.Tables[0].Rows[i]["HSourceBillType"].ToString().Trim(); |
| | | oSub.HSourceBillNo = DsSub.Tables[0].Rows[i]["HSourceBillNo"].ToString().Trim(); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty"]); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationMoney"]); |
| | | //=================================================== |
| | | oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]); |
| | | oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"]); |
| | | oSub.HMustQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMustQty"]); |
| | | oSub.HBadQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HBadQty"]); |
| | | oSub.HBadReasonID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HBadReasonID"]); |
| | | oSub.HDisposeNote = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HDisposeNote"]); |
| | | |
| | | oSub.HEmpName = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HEmpName"]); |
| | | oSub.HProcID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HProcID"]); |
| | | oSub.HBadPCSQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HBadPCSQty"]); |
| | | oSub.HWasterReasonName = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HWasterReasonName"]); |
| | | oSub.HPunishmentBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HPunishmentBillNo"]); |
| | | oSub.HMRBChecker = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMRBChecker"]); |
| | | |
| | | oSub.HSQProcName = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HSQProcName"]); |
| | | oSub.HZRProcName = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HZRProcName"]); |
| | | oSub.HPSProcName = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HPSProcName"]); |
| | | oSub.HQCResultID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HQCResultID"]); |
| | | |
| | | DetailColl.Add(oSub); |
| | | } |
| | | //DataSet DsSub2; |
| | | //DsSub2 = oCn.RunProcReturn("Select * from QC_NoPassProdCheckBillSub_Item Where HInterID=" + lngBillKey.ToString(), "QC_NoPassProdCheckBillSub_Item"); |
| | | //DetailColl1.Clear();//清空 |
| | | //for (int i = 0; i < DsSub2.Tables[0].Rows.Count; i++) |
| | | //{ |
| | | // Model.ClsQC_NoPassProdCheckBillSub_Item oSub2 = new Model.ClsQC_NoPassProdCheckBillSub_Item(); |
| | | // // 固定赋值=============================================== |
| | | // oSub2.HInterID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HInterID"]); |
| | | // oSub2.HEntryID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HEntryID"]); |
| | | // oSub2.HBillNo_bak = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HBillNo_bak"]); |
| | | // oSub2.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HCloseMan"]); |
| | | // oSub2.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub2.Tables[0].Rows[i]["HEntryCloseDate"]); |
| | | // oSub2.HCloseType = DBUtility.ClsPub.isBool(DsSub2.Tables[0].Rows[i]["HCloseType"]); |
| | | // oSub2.HRemark = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HRemark"]); |
| | | // oSub2.HSourceInterID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HSourceInterID"]); |
| | | // oSub2.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HSourceEntryID"]); |
| | | // oSub2.HSourceBillType = DsSub2.Tables[0].Rows[i]["HSourceBillType"].ToString().Trim(); |
| | | // oSub2.HSourceBillNo = DsSub2.Tables[0].Rows[i]["HSourceBillNo"].ToString().Trim(); |
| | | // oSub2.HRelationQty = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[i]["HRelationQty"]); |
| | | // oSub2.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub2.Tables[0].Rows[i]["HRelationMoney"]); |
| | | // //=================================================== |
| | | // //oSub.HWorkerID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HWorkerID"]); |
| | | // //oSub.HWorkerNumber = DsSub.Tables[0].Rows[i]["HWorkerNumber"].ToString().Trim(); |
| | | // //oSub.HSourceID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceID"]); |
| | | // //oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]); |
| | | // //oSub.HPropertyID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPropertyID"]); |
| | | // //oSub.HSecUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSecUnitID"]); |
| | | // //oSub.HSecUnitRate = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HSecUnitRate"]); |
| | | // //oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"]); |
| | | // //oSub.HBatchNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HBatchNo"]); |
| | | // //oSub.HQtyMust = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HQtyMust"]); |
| | | // //oSub.HQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HQty"]); |
| | | // //oSub.HPrice = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPrice"]); |
| | | // //oSub.HMoney = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMoney"]); |
| | | // //oSub.HDesignLife = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HDesignLife"]); |
| | | // //oSub.HLeaveLife = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HLeaveLife"]); |
| | | // //oSub.HUseLife = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HUseLife"]); |
| | | // //oSub.HWHID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HWHID"]); |
| | | // //oSub.HSPID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSPID"]); |
| | | // //oSub.HSCWHID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSCWHID"]); |
| | | // //oSub.HSCSPID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSCSPID"]); |
| | | // //oSub.HSPGroupID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSPGroupID"]); |
| | | // oSub2.HMaintainItemID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HMaintainItemID"]); |
| | | // oSub2.HMaintainItem = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HMaintainItem"]); |
| | | // oSub2.HMaintainPart = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HMaintainPart"]); |
| | | // oSub2.HClaim = DBUtility.ClsPub.isStrNull(DsSub2.Tables[0].Rows[i]["HClaim"]); |
| | | // oSub2.HManagerID = DBUtility.ClsPub.isLong(DsSub2.Tables[0].Rows[i]["HManagerID"]); |
| | | // //oSub.HQtyMust = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQtyMust"]); |
| | | // //oSub.HBadCount = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HBadCount"]); |
| | | // //oSub.HWasterQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HWasterQty"]); |
| | | // //oSub.HSeOrderInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderInterID"]); |
| | | // //oSub.HSeOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderEntryID"]); |
| | | // //oSub.HSeOrderBillNo = DsSub.Tables[0].Rows[i]["HSeOrderBillNo"].ToString().Trim(); |
| | | |
| | | // DetailColl1.Add(oSub2); |
| | | //} |
| | | sReturn = "显示单据成功!"; |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //审核 |
| | | public bool CheckBill(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | |
| | | try |
| | | { |
| | | string HChecker = DBUtility.ClsPub.CurUserName; |
| | | string HCheckDate = DBUtility.ClsPub.GetServerDate(-1); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString()); |
| | | //生成调拨单 |
| | | //得到调拨单 mainid 单据号 |
| | | |
| | | oCn.RunProc("exec h_p_QC_NoPassProdCheckBill_Check " + lngBillKey.ToString() ); |
| | | // |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //反审核 |
| | | public bool AbandonCheck(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | |
| | | try |
| | | { |
| | | string HChecker = DBUtility.ClsPub.CurUserName; |
| | | string HCheckDate = DBUtility.ClsPub.GetServerDate(-1); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null Where HInterID=" + lngBillKey.ToString()); |
| | | //生成调拨单 |
| | | //得到调拨单 mainid 单据号 |
| | | |
| | | oCn.RunProc("exec h_p_QC_NoPassProdCheckBill_AbandonCheck " + lngBillKey.ToString()); |
| | | // |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | throw (e); |
| | | } |
| | | } |
| | | //反审核前判断后面工序是否已经进站 |
| | | public bool UnCheck(long HInterID, ref string sReturn) |
| | | { |
| | | DataSet Ds; |
| | | Ds = oCn.RunProcReturn("exec h_p_QC_NoPassProdCheckBill_UnCheck " + HInterID, "h_p_QC_NoPassProdCheckBill_UnCheck"); |
| | | if (Ds == null) |
| | | { |
| | | sReturn = "判断下道工序是否已经进站时出错!"; |
| | | return false; |
| | | } |
| | | if (Ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | sReturn = "下道工序已经进站扫描,不允许反审核!"; |
| | | return false; |
| | | } |
| | | return true; |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | } |