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 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("输入错误");
}
}
