예제 #1
0
        protected FNA_FeeApplyDetail_BrandRate FillBrandRateModel(IDataReader dr)
        {
            FNA_FeeApplyDetail_BrandRate m = new FNA_FeeApplyDetail_BrandRate();

            if (!string.IsNullOrEmpty(dr["ID"].ToString()))
            {
                m.ID = (int)dr["ID"];
            }
            if (!string.IsNullOrEmpty(dr["DetailID"].ToString()))
            {
                m.DetailID = (int)dr["DetailID"];
            }
            if (!string.IsNullOrEmpty(dr["Brand"].ToString()))
            {
                m.Brand = (int)dr["Brand"];
            }
            if (!string.IsNullOrEmpty(dr["Rate"].ToString()))
            {
                m.Rate = (decimal)dr["Rate"];
            }
            if (!string.IsNullOrEmpty(dr["ExtPropertys"].ToString()))
            {
                m.ExtPropertys = SpiltExtProperty(m.ModelName, (string)dr["ExtPropertys"]);
            }

            return(m);
        }
예제 #2
0
        public int AddBrandRate(FNA_FeeApplyDetail_BrandRate m)
        {
            #region     设置参数集
            SqlParameter[] prams =
            {
                SQLDatabase.MakeInParam("@DetailID",     SqlDbType.Int,        4, m.DetailID),
                SQLDatabase.MakeInParam("@Brand",        SqlDbType.Int,        4, m.Brand),
                SQLDatabase.MakeInParam("@Rate",         SqlDbType.Decimal,    9, m.Rate),
                SQLDatabase.MakeInParam("@ExtPropertys", SqlDbType.VarChar, 4000, CombineExtProperty(m.ExtPropertys, m.ModelName))
            };
            #endregion

            m.ID = SQLDatabase.RunProc(_ProcePrefix + "Detail_BrandRate_Add", prams);

            return(m.ID);
        }
예제 #3
0
        public static int AddBrandRate(FNA_FeeApplyDetail_BrandRate m)
        {
            FNA_FeeApplyDAL dal = (FNA_FeeApplyDAL)DataAccess.CreateObject(DALClassName);

            return(dal.AddBrandRate(m));
        }