Example #1
0
        public List <C_SKU_AQL> GetSkuAqlBySkuId(OleExec DB, string SkuId)
        {
            List <C_SKU_AQL> res    = new List <C_SKU_AQL>();
            string           strSql = $@" select A.* from C_SKU_AQL A,C_SKU B where B.SKUNO=A.SKUNO AND B.ID='{SkuId}' ";
            DataSet          ds     = DB.ExecSelect(strSql);

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Row_C_SKU_AQL r = (Row_C_SKU_AQL)this.NewRow();
                r.loadData(item);
                res.Add(r.GetDataObject());
            }
            return(res);
        }
Example #2
0
        public C_SKU_AQL GetSkuAql(OleExec DB, string Skuno)
        {
            C_SKU_AQL res    = new C_SKU_AQL();
            string    strSql = $@" select * from C_SKU_AQL where skuno='{Skuno}' ";
            DataSet   ds     = DB.ExecSelect(strSql);

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Row_C_SKU_AQL r = (Row_C_SKU_AQL)this.NewRow();
                r.loadData(item);
                res = r.GetDataObject();
            }
            return(res);
        }