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