public void EnumTest1()
{
var g = new DefaultSqlServerCommandGenerator();
var method = typeof(IUserDao).GetMethod(nameof(IUserDao.SelectByState));
var d = g.Generate(method, new object[] { UserStates.Normal });
Assert.AreEqual(1, d.Parameters["State"].Value);
}
public void FillTest()
{
Type type = typeof(IUserDao);
MethodInfo mi = type.GetMethod("SelectById");
DefaultSqlServerCommandGenerator g = new DefaultSqlServerCommandGenerator();
SqlCommandDescription d = g.Generate(mi, new object[] { 1 });
Console.WriteLine(d);
}
public void GenCmd_DelByStr()
{
var g = new DefaultSqlServerCommandGenerator();
Type daoType = typeof(IUserDao);
MethodInfo methodInfo = daoType.GetMethod(nameof(IUserDao.DeleteByName));
var desc = g.Generate(methodInfo, new object[] { "Shiori" });
Console.WriteLine(desc);
Assert.AreEqual("Shiori", desc.Parameters["Name"].Value);
}
public void GenCmd_SelectById2()
{
var g = new DefaultSqlServerCommandGenerator();
Type daoType = typeof(IUserDao);
MethodInfo methodInfo = daoType.GetMethod(nameof(IUserDao.SelectById));
var desc = g.Generate(methodInfo, new object[] { 1 });
Console.WriteLine(desc);
Assert.AreEqual(1, desc.Parameters["Id"].Value);
}
public void DiyQueryByIdAndName()
{
var g = new DefaultSqlServerCommandGenerator();
var method = typeof(IUserDao).GetMethod(nameof(IUserDao.DiyQueryByIdAndName));
var d = g.Generate(method, new object[] { 1, "fc" });
Assert.AreEqual(2, d.Parameters.Count);
Assert.AreEqual(1, d.Parameters["id"].Value);
Assert.AreEqual("fc", d.Parameters["name"].Value);
}
public void GenCmd_IdInByArray()
{
var g = new DefaultSqlServerCommandGenerator();
Type daoType = typeof(IUserDao);
MethodInfo methodInfo = daoType.GetMethod(nameof(IUserDao.GetByIdIn));
var desc = g.Generate(methodInfo, new object[] { new int[] { 1, 2, 3 } });
Console.WriteLine(desc);
Assert.AreEqual(1, desc.Parameters["Id0"].Value);
Assert.AreEqual(2, desc.Parameters["Id1"].Value);
Assert.AreEqual(3, desc.Parameters["Id2"].Value);
}
public void UpdatePasswordEqualsNewpasswordByUseridAndPasswordIsOldpassword()
{
var g = new DefaultSqlServerCommandGenerator();
StackFrame sf = new StackFrame();
Type type = typeof(IUserDao);
var method = type.GetMethod(sf.GetMethod().Name);
var d = g.Generate(method, new object[] { "888888", "123", "123456" });
Console.WriteLine(d);
Assert.AreEqual("888888", d.Parameters["Newpassword"].Value);
Assert.AreEqual("123", d.Parameters["Userid"].Value);
Assert.AreEqual("123456", d.Parameters["Oldpassword"].Value);
}
public void BetweenTest()
{
var g = new DefaultSqlServerCommandGenerator();
var method = typeof(IUserDao).GetMethod(nameof(IUserDao.GetByAgeBetween));
var d = g.Generate(method, new object[]
{
new BetweenParameter(1, 2)
});
Console.WriteLine(d);
Assert.AreEqual(2, d.Parameters.Count);
Assert.AreEqual(1, d.Parameters[string.Format("{0}{1}", "Age", Constant.PARAMETER_SUFFIX_BETWEEN_BEGIN)].Value);
Assert.AreEqual(2, d.Parameters[string.Format("{0}{1}", "Age", Constant.PARAMETER_SUFFIX_BETWEEN_END)].Value);
}
public void PagingSelectOrderbyId()
{
var g = new DefaultSqlServerCommandGenerator();
Type daoType = typeof(IUserDao);
MethodInfo methodInfo = daoType.GetMethod(nameof(IUserDao.PagingSelectOrderbyId));
var desc = g.Generate(methodInfo, new object[] { new Paging()
{
PageSize = 10, PageIndex = 0
} });
Console.WriteLine(desc);
Assert.AreEqual(0, desc.Parameters["BEGINRN"].Value);
Assert.AreEqual(10, desc.Parameters["ENDRN"].Value);
}
public void GenCmd_Insert()
{
var g = new DefaultSqlServerCommandGenerator();
Type daoType = typeof(IUserDao);
MethodInfo methodInfo = daoType.GetMethod(nameof(IUserDao.Insert));
User user = new User()
{
CreateTime = DateTime.Now,
Id = 1,
Name = "Test",
Password = "******"
};
var desc = g.Generate(methodInfo, new object[] { user });
Console.WriteLine(desc);
}
public void GenerateCommand()
{
var g = new DefaultSqlServerCommandGenerator();
Type daoType = typeof(IUserDao);
MethodInfo[] infos = daoType.GetMethods();
foreach (var info in infos)
{
System.ComponentModel.DescriptionAttribute desc = info.GetCustomAttribute <System.ComponentModel.DescriptionAttribute>();
if (desc == null)
{
continue;
}
var d = g.Generate(info, null);
Console.WriteLine(d);
Assert.AreEqual(desc.Description, d.SqlCommand.Trim(), info.Name);
}
}
public void UpdateWithoutCreatetimeById()
{
var g = new DefaultSqlServerCommandGenerator();
StackFrame sf = new StackFrame();
Type type = typeof(IUserDao);
var method = type.GetMethod(sf.GetMethod().Name);
var d = g.Generate(method, new object[] { new User()
{
Id = 1,
Name = "NewName",
Password = "******"
} });
Console.WriteLine(d);
Assert.AreEqual(3, d.Parameters.Count);
Assert.AreEqual(1, d.Parameters["Id"].Value);
Assert.AreEqual("NewName", d.Parameters["Name"].Value);
Assert.AreEqual("NewPassword", d.Parameters["Password"].Value);
}