ZJDbSharpManage 2.5.48

DbSharpManage

DbSharpManage是的一个美观、便捷的高性能数据库操作的.net框架

DbSharpManage is a beautiful, convenient and high-performance .net framework for database operations

Insert Table Rows(插入)

var objtarry = new
 {
     SYSID = "XXAA0001",
     CODE = "XXAA0001",
     REMARK = "XXARemark"
 }; 
 //声明对象并调用Insert("TEST")的方法，"TEST"为表，InsertColumns为写入到"TEST"的数据
 DbPublicOracle.OpertionTable tto = new DbPublicOracle.OpertionTable();
 Result rltInsert = tto.Insert("TEST").InsertColumns(objtarry.ToDictionary()); 
 或
var objtarry = new Dictionary<string, object>
 {
     { "SYSID","XXAA0001"},
     { "CODE","XXAA0001"},
     { "REMARK","Update测试"}
 };
 //声明对象并调用Insert("TEST")的方法，"TEST"为表，InsertColumns为写入到"TEST"的数据
 DbPublicOracle.OpertionTable tto = new DbPublicOracle.OpertionTable();
 Result rltInsert = tto.Insert("TEST").InsertColumns(objtarry); 

Update Table Rows(更新)

var Setvalue = new Dictionary<string, object>
{
    { "CODE","UPDATEA00001"},
    { "CREATIONDATE",System.DateTime.Now},
    { "REMARK","Update测试"}
};
var Wherevalue = new Dictionary<string, object>
{
    { "SYSID","B00001"}
};
 //Update("TEST")的方法，"TEST"为表，SetColumns为更新的数据，WhereColumns为更新表"TEST"的条件
Result rltUpdate = tto.Update("TEST").SetColumns(Setvalue).WhereColumns(Wherevalue);

Delete Table Rwos(删除)

var DeleteWherevalue = new Dictionary<string, object>
{
    { "SYSID","741"}
};
//Delete("TEST")的方法，"TEST"为表，WhereColumns为更新表"TEST"的条件
Result rltDelete = tto.Delete("TEST").WhereColumns(DeleteWherevalue);

Data transaction operations(数据事务操作)

 var objtarry = new
 {
     SYSID = "XXAA0001",
     CODE = "XXAA0001",
     CREATIONDATE = System.DateTime.Now,
     REMARK = "XXARemark"
 };
 var Setvalue = new Dictionary<string, object>
{
    { "CODE","UPDATEA00001"},
    { "CREATIONDATE",System.DateTime.Now},
    { "REMARK","Update测试"}
};
var Wherevalue = new Dictionary<string, object>
{
    { "SYSID","B00001"}
};
var DeleteWherevalue = new Dictionary<string, object>
{
    { "SYSID","741"}
};
//声明对象并调用操作命令，最后须调用TranCommit("")方法提交
DbPublicOracle.OpertionTranTable otranle = new DbPublicOracle.OpertionTranTable();
otranle.Insert("TEST").InsertColumns(objtarry.ToDictionary());
otranle.Update("TEST").SetColumns(Setvalue).WhereColumns(Wherevalue);
otranle.Delete("TEST").WhereColumns(DeleteWherevalue);
Result Rult = otranle.TranCommit("");