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();
}
