Exemplo n.º 1
0
        public bool M_JANOrderPrice_Select(M_JANOrderPrice_Entity mie)
        {
            DataTable dt = mdl.M_JANOrderPrice_Select(mie);

            if (dt.Rows.Count > 0)
            {
                mie.Rate            = dt.Rows[0]["Rate"].ToString();
                mie.PriceWithoutTax = dt.Rows[0]["PriceWithoutTax"].ToString();
                mie.Remarks         = dt.Rows[0]["Remarks"].ToString();
                mie.DeleteFlg       = dt.Rows[0]["DeleteFlg"].ToString();
                mie.UsedFlg         = dt.Rows[0]["UsedFlg"].ToString();

                return(true);
            }
            else
            {
                return(false);
            }
        }
        public DataTable M_JANOrderPrice_Select(M_JANOrderPrice_Entity mje)
        {
            string sp = "M_JANOrderPrice_Select";

            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@AdminNO", new ValuePair {
                      value1 = SqlDbType.Int, value2 = mje.AdminNO
                  } },
                { "@VendorCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mje.VendorCD
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mje.ChangeDate
                  } },
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mje.StoreCD
                  } },
            };

            return(SelectData(dic, sp));
        }