Example #1
0
        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();
            }
        }