public void GetSerialNoTest() { //IFormatSerialNoPersistent persisten= var persistent = MockRepository.GenerateStub<IFormatSerialNoPersistent>(); Dictionary<string, int> dict = new Dictionary<string, int>(); dict.Add("1", 4); persistent.Stub(x => x.GetAll()).Return(dict); persistent = new NDAL.DALFormatSerialNo() as IFormatSerialNoPersistent; NLibrary.FormatSerialNoUnit fu = new NLibrary.FormatSerialNoUnit(persistent); //Assert.AreEqual("100001", fu.GetFormatedSerialNo("1")); //Assert.AreEqual("100002", fu.GetFormatedSerialNo("1")); //Assert.AreEqual("200001", fu.GetFormatedSerialNo("2")); fu.GetFormatedSerialNo("01.032.00003"); fu.GetFormatedSerialNo("1"); }
public void GetSerialNoTest() { //IFormatSerialNoPersistent persisten= var persistent = MockRepository.GenerateStub <IFormatSerialNoPersistent>(); Dictionary <string, int> dict = new Dictionary <string, int>(); dict.Add("1", 4); persistent.Stub(x => x.GetAll()).Return(dict); persistent = new NDAL.DALFormatSerialNo() as IFormatSerialNoPersistent; NLibrary.FormatSerialNoUnit fu = new NLibrary.FormatSerialNoUnit(persistent); //Assert.AreEqual("100001", fu.GetFormatedSerialNo("1")); //Assert.AreEqual("100002", fu.GetFormatedSerialNo("1")); //Assert.AreEqual("200001", fu.GetFormatedSerialNo("2")); fu.GetFormatedSerialNo("01.032.00003"); fu.GetFormatedSerialNo("1"); fu.Save(); }
/// <summary> /// 导入总方法 /// </summary> public void Import(BizProduct bizProduct, BizSupplier bizSupplier,IFormatSerialNoPersistent formatSerialnoPersisitent) { //1 读取Excel列表 IList<Product> ProductsInExcel = ReadProductsFromExcel(CheckExcelFile()); //2 检查图片是否存在 CheckProductImages(ProductsInExcel); //检查数据库 if (NeedCheckWithDB) { //1 检查 供应商是否存在 IList<string> supplierCodeList = GetSupplierCodeList(ProductsInExcel,bizSupplier); IList<string> supplierCodeList_NotExists; IList<Supplier> supplierList = bizSupplier.GetListByCodeList(supplierCodeList, out supplierCodeList_NotExists); if (supplierCodeList_NotExists.Count > 0) { foreach (string supplierCode in supplierCodeList_NotExists) { sbImportMsg.AppendLine("不存在该供应商:" + supplierCode); } return; } //2 检查数据是否已经导入 && 更新产品的供应商信息 IList<Product> productsExisted; ProductsPassedDBCheck = bizProduct.CheckSupplierExisted(ProductsHasImage, out productsExisted); ProductsExistedInDB = productsExisted; foreach (Product productExist in ProductsExistedInDB) { sbImportMsg.AppendLine("已存在该产品.供应商/型号:"+bizSupplier.GetByCode(productExist. SupplierCode).Name+"/"+productExist.ModelNumber); } } //数据保存到数据库-- 分配NTS编码 FormatSerialNoUnit serialNoMgr=new FormatSerialNoUnit(formatSerialnoPersisitent); foreach(Product p in ProductsPassedDBCheck) { p.NTSCode=serialNoMgr.GetFormatedSerialNo(p.CategoryCode+"."+p.SupplierCode ); } bizProduct.SaveList(ProductsPassedDBCheck); serialNoMgr.Save(); //图片复制至web的虚拟路径, 不合格数据拷贝 }