| | |
| | | //æ ¹æ®å
ç åå¡«å¯¹åºæµè½¬å¡ ä¸è¯å
³èæ°é |
| | | 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; |
| | | //} |
| | | DataSet Ds; |
| | | Ds = oCn.RunProcReturn("exec h_p_QC_NoPassProdCheckBill_QtyCtrl " + omodel.HInterID.ToString(), "h_p_QC_NoPassProdCheckBill_QtyCtrl"); |
| | | 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; |
| | | } |
| | | //////////////////////// |
| | | |
| | | |
| | |
| | | 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; |
| | | //} |
| | | DataSet Ds; |
| | | Ds = oCn.RunProcReturn("exec h_p_QC_NoPassProdCheckBill_QtyCtrl " + omodel.HInterID.ToString(), "h_p_QC_NoPassProdCheckBill_QtyCtrl"); |
| | | 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; |
| | | } |
| | | //////////////////////// |
| | | |
| | | // |