public void UpdateGoodsCodeRangeTest() { // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 // ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon");// DatabaseSetup.CONNTXT.Connection.ConnectionString; // ConnectionString = "Data Source=192.168.1.166;Initial Catalog=goodtestdb;User ID=sa;PassWord=Think123"; DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值 LendingManager model = null; // TODO: 初始化为适当的值 model = new LendingManager(); model.nID = 11; model.strGUID = "606C3E5D-0EFC-4E12-9E47-DFB512085D02"; model.nLendingTypeID = 1; model.nStartCode = 300; model.nStopCode = 400; model.strExceptCodes = ""; model.strWorkShopGUID = "3b50bf66-dabb-48c0-8b6d-05db80591090"; bool expected = true; // TODO: 初始化为适当的值 bool actual = target.UpdateGoodsCodeRange(model); // var sqlHelperMock = new Mock<LendingManagerInterface>(); // sqlHelperMock.Setup(x => x.UpdateGoodsCodeRange(model)).Returns(true); // bool actual = sqlHelperMock.Object.UpdateGoodsCodeRange(model); Assert.AreEqual(expected, actual); // Assert.Inconclusive("验证此测试方法的正确性。"); }
public void GetGoodsCodeRangeTest1() { // Data Source=192.168.1.166;Initial Catalog=goodtestdb;User ID=sa;Pooling=False // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 //ConnectionString = "Data Source=192.168.1.166;Initial Catalog=goodtestdb;User ID=sa;PassWord=Think123"; // ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon"); //DatabaseSetup.CONNTXT.Connection.ConnectionString; DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值 string strguid = string.Empty; // TODO: 初始化为适当的值 strguid = "867F086C-AF3C-4D88-88A4-63C85729F820"; LendingManager expected = null; // TODO: 初始化为适当的值 expected = new LendingManager(); expected.nID = 3; expected.strGUID = "867F086C-AF3C-4D88-88A4-63C85729F820"; expected.nLendingTypeID = 0; expected.nStartCode = 1; expected.nStopCode = 100; expected.strExceptCodes = ""; expected.strWorkShopGUID = "3b50bf66-dabb-48c0-8b6d-05db80591090"; LendingManager actual; actual = target.GetGoodsCodeRange(strguid); Assert.IsNotNull(actual); //bool r = actual.Equals(expected); Assert.AreEqual(actual.nStartCode, expected.nStartCode); // Assert.AreSame(expected, actual); //bool ret= compareobj(expected, actual); // Assert.Inconclusive("验证此测试方法的正确性。"); }
public override Book Delete(Book entity) { return(base.Delete(entity)); ILendingService lendingService = new LendingManager(); lendingService.Delete(b => b.BookID == entity.ID); }
public LendingManager GetObj(string strguid) { try { LendingManager obj = db.GetGoodsCodeRange(strguid); return(obj); } catch { return(null); } }
/// <summary> /// 反射获取类的属性 /// </summary> /// <param name="t1"></param> /// <param name="t2"></param> /// <returns></returns> public bool compareobj(LendingManager t1, LendingManager t2) { Type tone = typeof(LendingManager); System.Reflection.PropertyInfo[] properties = tone.GetProperties(); foreach (System.Reflection.PropertyInfo info in properties) { string str = "name=" + info.Name + ";" + "type=" + info.PropertyType.Name + ";value=" + GetObjectPropertyValue <LendingManager>(t1, info.Name); string str2 = "name=" + info.Name + ";" + "type=" + info.PropertyType.Name + ";value=" + GetObjectPropertyValue <LendingManager>(t2, info.Name); } return(true); }
public void InsertGoodsCodeRangeTest() { // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 // ConnectionString = "Data Source=192.168.1.166;Initial Catalog=goodtestdb;User ID=sa;PassWord=Think123";. // ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon");// DatabaseSetup.CONNTXT.Connection.ConnectionString; DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值 LendingManager model = null; // TODO: 初始化为适当的值 LendingManager expected = null; // TODO: 初始化为适当的值 model = new LendingManager(); model.nID = 3; model.strGUID = "867F086C-AF3C-4D88-88A4-63C85729F820"; model.nLendingTypeID = 0; model.nStartCode = 1; model.nStopCode = 100; model.strExceptCodes = ""; model.strWorkShopGUID = "3b50bf66-dabb-48c0-8b6d-05db80591090"; // bool result = true; // TODO: 初始化为适当的值 // bool actual; bool inbol = true; //actual = target.InsertGoodsCodeRange(model); // var sqlHelperMock = new Mock<LendingManagerInterface>(); // sqlHelperMock.Setup(x => x.InsertGoodsCodeRange(model)).Returns(true); bool actual = false;// sqlHelperMock.Object.InsertGoodsCodeRange(model); actual = target.InsertGoodsCodeRange(model); //bool ret = false; //try //{ Assert.AreEqual(inbol, actual); // sqlHelperMock.VerifyAll(); // ret = true; //} //catch(Exception error) //{ // ret = false; //} // return ret; // expected = target.GetGoodsCodeRange("867F086C-AF3C-4D88-88A4-63C85729F820"); // Assert.AreEqual(result, actual); //Assert.IsTrue(actual); // Assert.AreSame(model, expected); // Assert.Inconclusive("验证此测试方法的正确性。"); }
/// <summary> ///GetGoodsCodeRange_DRToModelDTToList 的测试 ///</summary> //[TestMethod()] //[Test] public void GetGoodsCodeRange_DRToModelDTToListTest() { //string ConnectionString = string.Empty; // TODO: 初始化为适当的值 //ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon"); //DatabaseSetup.CONNTXT.Connection.ConnectionString; DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值 DataRow dr = null; // TODO: 初始化为适当的值 LendingManager expected = null; // TODO: 初始化为适当的值 LendingManager actual; actual = target.GetGoodsCodeRange_DRToModelDTToList(dr); // Assert.AreEqual(expected, actual); Assert.IsNotNull(actual); // Assert.AreSame(expected, actual); // Assert.Inconclusive("验证此测试方法的正确性。"); }
public LendingManager GetGoodsCodeRange_DRToModelDTToList(DataRow dr) { LendingManager model = new LendingManager(); if (dr != null) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]); model.nLendingTypeID = ObjectConvertClass.static_ext_int(dr["nLendingTypeID"]); model.nStartCode = ObjectConvertClass.static_ext_int(dr["nStartCode"]); model.nStopCode = ObjectConvertClass.static_ext_int(dr["nStopCode"]); model.strExceptCodes = ObjectConvertClass.static_ext_string(dr["strExceptCodes"]); model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); } return(model); }
public bool InsertGoodsCodeRange(LendingManager model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tab_Base_LendingManager"); strSql.Append("(strGUID,nLendingTypeID,nStartCode,nStopCode,strExceptCodes,strWorkShopGUID)"); strSql.Append("values(@strGUID,@nLendingTypeID,@nStartCode,@nStopCode,@strExceptCodes,@strWorkShopGUID)"); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@strGUID", model.strGUID), new SqlParameter("@nLendingTypeID", model.nLendingTypeID), new SqlParameter("@nStartCode", model.nStartCode), new SqlParameter("@nStopCode", model.nStopCode), new SqlParameter("@strExceptCodes", model.strExceptCodes), new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID) }; return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), sqlParameters) > 0); }
/// <summary> /// 获取单个实体 /// </summary> /// <param name="strguid"></param> /// <returns></returns> public LendingManager GetGoodsCodeRange(string strguid) { LendingManager model = new LendingManager(); StringBuilder strSql = new StringBuilder(); strSql.Append("Select * from Tab_Base_LendingManager where strGUID = '" + strguid + "'"); DataTable mydt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString()).Tables[0]; int rowsCount = mydt.Rows.Count; if (rowsCount > 0) { for (int n = 0; n < rowsCount; n++) { model = GetGoodsCodeRange_DRToModelDTToList(mydt.Rows[n]); break; } } return(model); }
public bool UpdateGoodsCodeRange(LendingManager model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update Tab_Base_LendingManager set "); strSql.Append(" nLendingTypeID = @nLendingTypeID, "); strSql.Append(" nStartCode = @nStartCode, "); strSql.Append(" nStopCode = @nStopCode, "); strSql.Append(" strExceptCodes = @strExceptCodes, "); strSql.Append(" strWorkShopGUID = @strWorkShopGUID "); strSql.Append(" where strGUID = @strGUID "); SqlParameter[] parameters = { new SqlParameter("@strGUID", model.strGUID), new SqlParameter("@nLendingTypeID", model.nLendingTypeID), new SqlParameter("@nStartCode", model.nStartCode), new SqlParameter("@nStopCode", model.nStopCode), new SqlParameter("@strExceptCodes", model.strExceptCodes), new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID) }; return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0); }