public static void Insert(string model, IDbInterface helper) { var record = helper.FindFirst <Model, string>("modelName", model); if (record != null) { return; } helper.Insert(new Model() { modelName = model }, false); }
public static void Insert(string code, IDbInterface helper) { var record = helper.FindFirst <MaterialCode, string>("code", code); if (record != null) { return; } helper.Insert(new MaterialCode() { code = code }, false); }
public static void Insert(string name, IDbInterface helper) { var record = helper.FindFirst <Name, string>("materialName", name); if (record != null) { return; } helper.Insert(new Name() { materialName = name }, false); }
public DbQuery(IDbInterface dbInterface) { _dbInterface = dbInterface; _sql = new StringBuilder(); _sql.AppendFormat ( "SELECT {0} " + "\nFROM {1} ", string.Join(", ", DbEntity <TEntity> .GetFields(true, true, true)), DbEntity <TEntity> .EntityInfo.Table ); }
public static void Insert(string code, string name, string model, IDbInterface helper) { var mCode = GetMaterialCode(code); var mName = Name.GetName(name); var mModel = Model.GetModel(model); var mCodeMatch = GetMaterialCode(name, model); if (mName != null && mModel != null && mCode.id == mCodeMatch.id) //组合正确,不用写入新数据,对应excel第2行 { return; } else if (mCode == null) { if (mCodeMatch != null) //对应excel第8行 { throw new Exception("输入错误"); } else //对应excel9-12行 { int nameId = -1; int modelId = -1; //插入没有的数据 if (mName == null) { var insertName = new Name() { materialName = name }; helper.Insert(insertName); nameId = insertName.id; } else { nameId = mName.id; } if (mModel == null) { var insertModel = new Model() { modelName = model }; helper.Insert(insertModel); modelId = insertModel.id; } else { modelId = mModel.id; } //插入MaterialCode helper.Insert(new MaterialCode() { materialModelId = modelId, materialNameId = nameId, code = code }); helper.Commit(); } } else //对应excel文件3-7行条件 { throw new Exception("输入错误"); } }
/// <summary> /// Construct a new DbLayer /// </summary> /// <param name="dbInterface">An interface to an underlying database</param> /// <param name="descriptor">Metadata to enable mapping T's to database tables</param> /// <param name="mapper">An object-relational mapper</param> protected DbLayer(IDbInterface <TDbParameter> dbInterface, IDbObjectDescriptor descriptor, IDbMapper <T> mapper) { DbInterface = dbInterface ?? throw new ArgumentNullException(nameof(dbInterface)); Descriptor = descriptor ?? throw new ArgumentNullException(nameof(descriptor)); Mapper = mapper ?? throw new ArgumentNullException(nameof(mapper)); }
protected ModelBase() { helper = new DbHelper(new SteelRepositoryDbEntities()); }
public GetBaseToonService(IDbInterface <Models.BaseToons.BaseToon> repository) { _repository = repository; }
/// <summary> /// Construct a new MappedDbLayer /// </summary> /// <param name="dbInterface">An interface to an underlying database</param> /// <param name="descriptor">metadata to enable mapping T's to database tables</param> /// <param name="mapper">An object-relational mapper</param> protected MappedDbLayer(IDbInterface <TDbParameter> dbInterface, IMappedDbObjectDescriptor <T> descriptor, IDbMapper <T> mapper) : base(dbInterface, descriptor, mapper) { }
public void BuildDbObject() { obj = DatabaseObjectFactory.GetConnectivityObject(); }