public void TestUpdateMysql()
{
cqssc obj = mapMysql.Get <cqssc>("select * from cqssc where idx=124");
Assert.AreNotEqual(obj, null);
Console.WriteLine("before update:");
Console.WriteLine(obj.pnum + "," + obj.pdate + "," + obj.Nums + "," + obj.kjshijian + "," + obj.Idx);
obj.Nums = "55666555";
obj.kjshijian = DateTime.Now;
obj.pnum = 6;
mapMysql.Update <cqssc>(obj, "", mapMysql.Include("nums").Columns);
Console.WriteLine("after update:");
Console.WriteLine(obj.pnum + "," + obj.pdate + "," + obj.Nums + "," + obj.kjshijian + "," + obj.Idx);
}
public void TestMySqlINsert()
{
cqssc ssc = new cqssc()
{
CpType = 1,
Idx = 1,
kjshijian = DateTime.Now,
Nums = "1|2|3|4|5",
pdate = 20140505,
pnum = 023
};
int rows = mapMysql.Insert <cqssc>(ssc);
Assert.AreEqual(1, rows);
}
public void TestGetMysql()
{
cqssc obj = mapMysql.Get <cqssc>("select * from cqssc where idx=124");
Assert.AreNotEqual(obj, null);
Console.WriteLine(obj.pnum + "," + obj.pdate + "," + obj.Nums + "," + obj.kjshijian + "," + obj.Idx);
List <cqssc> litss = new List <cqssc>();
litss = mapMysql.GetList <cqssc>("select * from cqssc order by idx limit 0,10 ");
foreach (cqssc obj1 in litss)
{
Console.WriteLine(obj1.pnum + "," + obj1.pdate + "," + obj1.Nums + "," + obj1.kjshijian + "," + obj1.Idx);
}
Assert.AreEqual(10, litss.Count);
}
