public int getWipQtyByPo(string custorderno, string styleno, string size, string color) { bool res = false; try { WipDal dal = new WipDal(this.dbInstance); DataSet ctlDtl = dal.GetGoodWIP(custorderno, styleno, size, color); if (ctlDtl.Tables[0].Rows.Count <= 0) { return 0; } else { return int.Parse(ctlDtl.Tables[0].Rows[0]["pairqty"].ToString()); } } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }