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);
}
