/// <summary> /// Code was not auto generate this method /// </summary> /// <param name="customersGen"></param> /// <returns></returns> public int InsertCustomersGen(CustomersGen customersGen) { var returnobj = baseDao.Insert(customersGen); if (returnobj != null) { return(Convert.ToInt32(returnobj)); } return(0); }
public void TestUpdateCustomersGen() { CustomersGen customersGen = new CustomersGen() { CustomerID = "11", CompanyName = "UTChanged" }; int ret = customersGenDao.UpdateCustomersGen(customersGen); Assert.IsTrue(ret > 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 CustomersGen OrmByHand(string sql) * { * try * { * return baseDao.VisitDataReader<CustomersGen>(sql, (reader) => * { * CustomersGen entity = new CustomersGen(); * if(reader.Read()) * { * entity.Address = reader["Address"]; * entity.City = reader["City"]; * entity.CompanyName = reader["CompanyName"]; * entity.ContactName = reader["ContactName"]; * entity.ContactTitle = reader["ContactTitle"]; * entity.Country = reader["Country"]; * entity.CustomerID = reader["CustomerID"]; * entity.Fax = reader["Fax"]; * entity.Phone = reader["Phone"]; * entity.PostalCode = reader["PostalCode"]; * entity.Region = reader["Region"]; * } * return entity; * }); * * //CustomersGen entity = new CustomersGen(); * //using(var reader = baseDao.SelectDataReader(sql)) * //{ * //if(reader.Read()) * //{ * //entity.Address = reader["Address"]; * //entity.City = reader["City"]; * //entity.CompanyName = reader["CompanyName"]; * //entity.ContactName = reader["ContactName"]; * //entity.ContactTitle = reader["ContactTitle"]; * //entity.Country = reader["Country"]; * //entity.CustomerID = reader["CustomerID"]; * //entity.Fax = reader["Fax"]; * //entity.Phone = reader["Phone"]; * //entity.PostalCode = reader["PostalCode"]; * //entity.Region = reader["Region"]; * //} * //} * //return entity; * } * catch (Exception ex) * { * throw new DalException("调用CustomersGenDao时,访问OrmByHand时出错", ex); * } * } */ /// <summary> /// 修改CustomersGen /// </summary> /// <param name="customersGen">CustomersGen实体对象</param> /// <returns>状态代码</returns> public int UpdateCustomersGen(CustomersGen customersGen) { try { Object result = baseDao.Update <CustomersGen>(customersGen); int iReturn = Convert.ToInt32(result); return(iReturn); } catch (Exception ex) { throw new DalException("调用CustomersGen时,访问Update时出错", ex); } }
/// <summary> /// 检索CustomersGen,带翻页 /// </summary> /// <param name="obj">CustomersGen实体对象检索条件</param> /// <param name="pagesize">每页记录数</param> /// <param name="pageNo">页码</param> /// <returns>检索结果</returns> public IList <CustomersGen> GetListByPage(CustomersGen obj, int pagesize, int pageNo) { try { StringBuilder sbSql = new StringBuilder(200); sbSql.Append(@"select Address, City, CompanyName, ContactName, ContactTitle, Country, CustomerID, Fax, Phone, PostalCode, Region from Customers (nolock) "); sbSql.Append(" order by CustomerID desc "); sbSql.Append(string.Format("OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY", (pageNo - 1) * pagesize, pagesize)); IList <CustomersGen> list = baseDao.SelectList <CustomersGen>(sbSql.ToString()); return(list); } catch (Exception ex) { throw new DalException("调用CustomersGenDao时,访问GetListByPage时出错", ex); } }
public void TestInsertCustomersGen() { var customersGen = new CustomersGen { CompanyName = "Newcvompanyname", ContactName = "ccc", Address = "asdcadsdws", ContactTitle = "adsdf", City = "ku2na", Country = "chi2na", Phone = "231", PostalCode = "234", Region = "ASIA", CustomerID = "9012" }; int ret = customersGenDao.InsertCustomersGen(customersGen); Assert.IsTrue(ret > 0); }