public void LoadProfile(string Auser) { dbt = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); tdb.Season sai = new tdb.Season(); tdb.Language lang = new tdb.Language(); tdb.Customer pers = new tdb.Customer(); ProfileDS prof; string sql; // load profile from DB by user name prof = new ProfileDS(); sql = String.Format("Select * from tdbadmin.mp_profil where mpuser like '{0}'", Auser); dbt.FillDS(prof, sql, new string[] { "mp_profil" }); ProfileDS.mp_profilRow Rprof = prof.mp_profil[0]; // set now the user profile data // Console.WriteLine("Prof Id {0}", Rprof.MPID); Useclevel = Rprof.SECLEVEL; Ulangid = Rprof.S_ID; if (Ulangid > 0) Ulang = lang.GetBez(Ulangid); else Ulang = ""; Uofficeid = Rprof.BCHST; if (Uofficeid > 0) Uoffice = pers.GetBez(Uofficeid); else Ulang = ""; Udlatid = Rprof.DLAT_ID; Usaiid = Rprof.SAI_ID; if (Usaiid > 0) Usai = sai.GetBez(Usaiid); else Usai = ""; }
private void btnLoad_Click(object sender, System.EventArgs e) { string sql; org.swyn.foundation.utils.DBtools db = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); this.objProfileDS.Clear(); sql = String.Format("Select * from tdbadmin.mp_profil"); db.FillDS(this.objProfileDS, sql, new string[] { "mp_profil" }); }
private void btnUpdate_Click(object sender, System.EventArgs e) { org.swyn.foundation.utils.DBtools db = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); db.UpdDS(this.objProfileDS, "tdbadmin.tdb_insprof", new string[] { "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE" }, "tdbadmin.tdb_updprof", new string[] { "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE" }, "tdbadmin.tdb_delprof", new string[] {"MPID"}, "mp_profil"); // IDbCommand inscmd = tdb.User.Uhelper.CreateCommand(dbc, "tdbadmin.tdb_insprof", // "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE"); // IDbCommand updcmd = tdb.User.Uhelper.CreateCommand(dbc, "tdbadmin.tdb_updprof", // "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE"); // IDbCommand delcmd = tdb.User.Uhelper.CreateCommand(dbc, "tdbadmin.tdb_delprof", "MPID"); // tdb.User.Uhelper.UpdateDataset(inscmd, delcmd, updcmd, this.objProfileDS, "mp_profil"); }