public static DataTable getMMYY(string dblinks_server)
{
Accessdata acc = new Accessdata();
try
{
return(acc.get_data("select mmyy from " + acc.User + ".syn_manager_schema@" + dblinks_server + " where syn=1").Tables[0]);
}
catch
{
return(null);
}
}
public Thongso()
{
sql = "select * from " + a.User + ".syn_thongso where 1=0";
try
{
DataTable temp = a.get_data(sql).Tables[0];
}
catch
{
sql = "CREATE TABLE " + a.User + ".syn_thongso(ten varchar2(100), giatri varchar2(3))";
a.execute_data(sql);
}
}
public static DataSet SynTable_KSK(string dblink)
{
Accessdata acc = new Accessdata();
if (dblink != "")
{
dblink = "@" + dblink;
}
try
{
return(acc.get_data("select * from " + acc.User + ".syn_dmtable_ksk" + dblink + " where hide=0 order by stt "));
}
catch
{
return(null);
}
}
private void load_table()
{
if (dmtable == null)
{
string xxx = dal.User + mm.Value.ToString().PadLeft(2, '0') + yy.Value.ToString().Substring(2, 2);
//dmtable = dal.get_data("select 0 as stt, schemaname,table_name from sys.all_tables where lower(schemaname)='" + dal.User + "' union " +
// "select schemaname as schema_name,table_name from sys.all_tables where lower(schemaname)='" + xxx + "' order by schemaname").Tables[0];
dmtable = dal.get_data("select stt, schemaname,table_name from medibv.syn_dmtable order by stt").Tables[0];
}
try
{
dmtable.Columns.Add("chon", typeof(bool)).DefaultValue = false;
}
catch { }
//dmtable.Columns.Add("done", typeof(int)).DefaultValue = 0;
dataGridView1.DataSource = dmtable;
}