/// <summary> /// InsertProductsGen /// </summary> /// <param name="productsGen"></param> /// <returns></returns> public int InsertProductsGen(ProductsGen productsGen) { var returnobj = baseDao.Insert(productsGen); if (returnobj != null) { return(Convert.ToInt32(returnobj)); } return(0); }
/// <summary> /// WriteTest /// </summary> /// <param name="repeatTime"></param> /// <returns></returns> public long WriteTest(int repeatTime) { return(Utility.PerformanceWatch( () => { for (int i = 0; i < repeatTime; i++) { var customer = new CustomersGen { CompanyName = "Newcvompanyname", ContactName = "ccc", Address = "asdcadsdws", ContactTitle = "adsdf", City = "ku2na", Country = "chi2na", Phone = "231", PostalCode = "234", Region = "ASIA", CustomerID = "9011" }; int customerIdFromDb = customersGenDao.InsertCustomersGen(customer); var catagore = new CategoriesGen() { CategoryName = "xdf", Description = "asfb" }; int categoryIDfromDb = categoriesGenDao.InsertCategoriesGen( catagore ); var product = new ProductsGen { ProductName = "Blue Widget234", UnitPrice = 35.56M, CategoryID = categoryIDfromDb }; //Insert product.ProductID = productsGenDao.InsertProductsGen(product ); product.ProductName = "ProductNameChange"; //Update productsGenDao.UpdateProductsGen(product); //Delete productsGenDao.DeleteProductsGen(product); customersGenDao.DeleteCustomersGen(customer); categoriesGenDao.DeleteCategoriesGen(catagore); } })); }
//特别注意,如果是可空类型,建议以如下方式使用: // var data = reader["field"]; // entity.stringData = data == null ? data : data.ToString(); //如需要手工映射,请反注释如下代码,并注意转换类型 /* * /// <summary> * /// 手工映射,建议使用1.2.0.5版本以上的VisitDataReader * /// </summary> * /// <returns>结果</returns> * public ProductsGen OrmByHand(string sql) * { * try * { * return baseDao.VisitDataReader<ProductsGen>(sql, (reader) => * { * ProductsGen entity = new ProductsGen(); * if(reader.Read()) * { * entity.CategoryID = reader["CategoryID"]; * entity.Discontinued = reader["Discontinued"]; * entity.ProductID = reader["ProductID"]; * entity.ProductName = reader["ProductName"]; * entity.QuantityPerUnit = reader["QuantityPerUnit"]; * entity.ReorderLevel = reader["ReorderLevel"]; * entity.SupplierID = reader["SupplierID"]; * entity.UnitPrice = reader["UnitPrice"]; * entity.UnitsInStock = reader["UnitsInStock"]; * entity.UnitsOnOrder = reader["UnitsOnOrder"]; * } * return entity; * }); * * //ProductsGen entity = new ProductsGen(); * //using(var reader = baseDao.SelectDataReader(sql)) * //{ * //if(reader.Read()) * //{ * //entity.CategoryID = reader["CategoryID"]; * //entity.Discontinued = reader["Discontinued"]; * //entity.ProductID = reader["ProductID"]; * //entity.ProductName = reader["ProductName"]; * //entity.QuantityPerUnit = reader["QuantityPerUnit"]; * //entity.ReorderLevel = reader["ReorderLevel"]; * //entity.SupplierID = reader["SupplierID"]; * //entity.UnitPrice = reader["UnitPrice"]; * //entity.UnitsInStock = reader["UnitsInStock"]; * //entity.UnitsOnOrder = reader["UnitsOnOrder"]; * //} * //} * //return entity; * } * catch (Exception ex) * { * throw new DalException("调用ProductsGenDao时,访问OrmByHand时出错", ex); * } * } */ /// <summary> /// 修改ProductsGen /// </summary> /// <param name="productsGen">ProductsGen实体对象</param> /// <returns>状态代码</returns> public int UpdateProductsGen(ProductsGen productsGen) { try { Object result = baseDao.Update <ProductsGen>(productsGen); int iReturn = Convert.ToInt32(result); return(iReturn); } catch (Exception ex) { throw new DalException("调用ProductsGen时,访问Update时出错", ex); } }
/// <summary> /// 检索ProductsGen,带翻页 /// </summary> /// <param name="obj">ProductsGen实体对象检索条件</param> /// <param name="pagesize">每页记录数</param> /// <param name="pageNo">页码</param> /// <returns>检索结果</returns> public IList <ProductsGen> GetListByPage(ProductsGen obj, int pagesize, int pageNo) { try { StringBuilder sbSql = new StringBuilder(200); sbSql.Append(@"select CategoryID, Discontinued, ProductID, ProductName, QuantityPerUnit, ReorderLevel, SupplierID, UnitPrice, UnitsInStock, UnitsOnOrder from Products (nolock) "); sbSql.Append(" order by ProductID desc "); sbSql.Append(string.Format("OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY", (pageNo - 1) * pagesize, pagesize)); IList <ProductsGen> list = baseDao.SelectList <ProductsGen>(sbSql.ToString()); return(list); } catch (Exception ex) { throw new DalException("调用ProductsGenDao时,访问GetListByPage时出错", ex); } }