示例#1
0
        public FdpSpecialFeature FdpSpecialFeatureGet(int fdpFeatureId)
        {
            FdpSpecialFeature retVal = new EmptyFdpSpecialFeature();

            using (IDbConnection conn = DbHelper.GetDBConnection())
            {
                try
                {
                    var para = new DynamicParameters();
                    para.Add("@FdpSpecialFeatureId", fdpFeatureId, DbType.Int32);
                    retVal = conn.Query <FdpSpecialFeature>("dbo.Fdp_SpecialFeatureMapping_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
                }
                catch (Exception ex)
                {
                    Log.Error(ex);
                    throw;
                }
            }
            return(retVal);
        }
示例#2
0
        public FdpSpecialFeature FdpSpecialFeatureSave(FdpSpecialFeature specialFeature)
        {
            FdpSpecialFeature retVal = new EmptyFdpSpecialFeature();

            using (IDbConnection conn = DbHelper.GetDBConnection())
            {
                try
                {
                    var para = DynamicParameters.FromCDSId(CurrentCDSID);
                    para.Add("@FeatureCode", specialFeature.FeatureCode, DbType.String);
                    para.Add("@FdpSpecialFeatureTypeId", specialFeature.Type.FdpSpecialFeatureTypeId, DbType.Int32);
                    para.Add("@DocumentId", specialFeature.DocumentId, DbType.Int32);

                    retVal = conn.Query <FdpSpecialFeature>("dbo.Fdp_SpecialFeatureMapping_Save", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
                }
                catch (Exception ex)
                {
                    Log.Error(ex);
                    throw;
                }
            }
            return(retVal);
        }