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 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("验证此测试方法的正确性。");
}
/// <summary>
///GetGoodsCodeRange_DTToList 的测试
///</summary>
//[TestMethod()]
//[Test]
public void GetGoodsCodeRange_DTToListTest()
{
// string ConnectionString = string.Empty; // TODO: 初始化为适当的值
//ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon");// DatabaseSetup.CONNTXT.Connection.ConnectionString;
DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值
DataTable dt = null; // TODO: 初始化为适当的值
List <LendingManager> expected = null; // TODO: 初始化为适当的值
List <LendingManager> actual;
actual = target.GetGoodsCodeRange_DTToList(dt);
// Assert.AreEqual(expected, actual);
Assert.IsNotNull(actual);
// Assert.Inconclusive("验证此测试方法的正确性。");
}
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("验证此测试方法的正确性。");
}
public void IsGoodInRangeTest()
{
// string ConnectionString = string.Empty; // TODO: 初始化为适当的值
// ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon"); //DatabaseSetup.CONNTXT.Connection.ConnectionString;
DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值
int nLendingType = 1; // TODO: 初始化为适当的值
int strLendingExInfo = 0; // TODO: 初始化为适当的值
strLendingExInfo = 402;
string WorkShopGUID = string.Empty; // TODO: 初始化为适当的值
WorkShopGUID = "3b50bf66-dabb-48c0-8b6d-05db80591090";
bool expected = true; // TODO: 初始化为适当的值
bool actual;
actual = target.IsGoodInRange(nLendingType, strLendingExInfo, WorkShopGUID);
Assert.AreEqual(expected, actual);
// Assert.Inconclusive("验证此测试方法的正确性。");
}
public void GetGoodsCodeRangeTest()
{
// string ConnectionString = string.Empty; // TODO: 初始化为适当的值
// ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon");// DatabaseSetup.CONNTXT.Connection.ConnectionString;
DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值
string WorkShopGUID = string.Empty; // TODO: 初始化为适当的值
WorkShopGUID = "3b50bf66-dabb-48c0-8b6d-05db80591090";
int lendingType = 0; // TODO: 初始化为适当的值
List <LendingManager> expected = null; // TODO: 初始化为适当的值
//准备期望值
List <LendingManager> actual;
actual = target.GetGoodsCodeRange(WorkShopGUID, lendingType);
//Assert.AreEqual(expected, actual);
Assert.IsNotNull(actual);
// Assert.Inconclusive("验证此测试方法的正确性。");
}
public void DeleteGoodsCodeRangeTest()
{
// string ConnectionString = string.Empty; // TODO: 初始化为适当的值
// ConnectionString = DatabaseSetup.GetConnectionStringsConfig("MyCon");// DatabaseSetup.CONNTXT.Connection.ConnectionString;// "Data Source=192.168.1.166;Initial Catalog=goodtestdb;User ID=sa;PassWord=Think123";
DBLendingManager target = new DBLendingManager(connstr); // TODO: 初始化为适当的值
string rangeGUID = string.Empty; // TODO: 初始化为适当的值
bool expected = true; // TODO: 初始化为适当的值
bool actual;
string strguid = "867F086C-AF3C-4D88-88A4-63C85729F820";
actual = target.DeleteGoodsCodeRange(strguid);
//// var sqlHelperMock = new Mock<LendingManagerInterface>();
//sqlHelperMock.Setup(x => x.DeleteGoodsCodeRange(strguid)).Returns(true);
//actual= sqlHelperMock.Object.DeleteGoodsCodeRange(strguid);
Assert.AreEqual(expected, actual);
// Assert.Inconclusive("验证此测试方法的正确性。");
}
