/// <summary>
///
/// </summary>
/// <param name="xmlPath"></param>
public static void testOracleDate()
{
TABLEMANAGE_BLL tBll = new TABLEMANAGE_BLL();
//List<TABLEMANAGE> list = tBll.Query();
//list.ForEach(p=>{
// Console.WriteLine(p.TABLENAME + " " + p.TABLEMANAGEDDSC + " " + p.TABLECURENTID);
//});
//TABLEMANAGE ta = tBll.QueryByTableName("bw3716_2019");
//bool b = tBll.UpdateByTableName("bw3716_2019", "2858");
//获取所有字段
//FieldInfo[] fields = typeof(TABLEMANAGE).GetFields(BindingFlags.NonPublic | BindingFlags.Instance); //获取私有字段
TABLEMANAGE tab = new TABLEMANAGE();
//方法插入数据库
//1.创建有参构造方法
//2.调用Insert方法
//foreach (var item in fields)
//{
// Console.WriteLine(item.FieldType.Name+" "+item.Name);
//}
TABLEMANAGE t = new TABLEMANAGE("Rina", 111, "测试");
bool b = tBll.Insert(t);
Console.WriteLine(b);
//Console.WriteLine(ta.TABLECURENTID);
}
public bool UpdateByTableName(string tablename, string id)
{
TABLEMANAGE t = new TABLEMANAGE();
string sql = @"UPDATE TABLEMANAGE SET TABLECURENTID = '" + id + "' WHERE TABLENAME = '" + tablename + "'";
return(OracleHelper.Update <TABLEMANAGE>(sql, t));
}
public TABLEMANAGE QueryByTableName(string tablename)
{
TABLEMANAGE t = new TABLEMANAGE();
string sql = @"SELECT * FROM TABLEMANAGE WHERE TABLENAME = '" + tablename + "'";
TABLEMANAGE tABLEMANAGE = OracleHelper.Select <TABLEMANAGE>(sql, t);
return(tABLEMANAGE);
}
/// <summary>
/// 查询TABLEMANAGE表集合
/// </summary>
/// <returns></returns>
public List <TABLEMANAGE> Query()
{
TABLEMANAGE t = new TABLEMANAGE();
string sql = @"select * from TABLEMANAGE";
List <TABLEMANAGE> list = OracleHelper.Query <TABLEMANAGE>(sql, t).ToList();
return(list);
}
