public static void AhpTopUpdAfd(AHP ahp) { Db.Transact(() => { //Tuple<double, double> res = Db.SQL<Tuple<double, double>>("SELECT SUM(r.Brc), SUM(r.Alc) FROM AFD r WHERE r.ObjAHP = ? and r.ObjAFB.Drm = ?", ahp, "K")?.FirstOrDefault(); Tuple <double, double> res = Db.SQL <Tuple <double, double> >("SELECT SUM(r.Brc), SUM(r.Alc) FROM AVD r WHERE r.AHP = ?", ahp)?.FirstOrDefault(); if (res != null) { ahp.Brc = res.Item1; ahp.Alc = res.Item2; if (ahp.P != null) // Ust hesabi varsa { AHP pAHP = ahp.P; double Brc = 0, Alc = 0; do { Brc = 0; Alc = 0; foreach (var m in Db.SQL <AHP>("select m from AHP m where m.P = ?", pAHP)) { Brc += m.Brc; Alc += m.Alc; } pAHP.Brc = Brc; pAHP.Alc = Alc; pAHP = pAHP.P; }while (pAHP != null); } } }); }
public static void PopAHP() { if (Db.SQL <AHP>("select r from AHP r").FirstOrDefault() != null) { return; // Kayit var yapma } // Kod|Ad using (StreamReader sr = new StreamReader($@"C:\Starcounter\M2Data\AHP.csv", System.Text.Encoding.UTF8)) { string line; Db.Transact(() => { while ((line = sr.ReadLine()) != null) { if (!line.StartsWith("#")) { string[] ra = line.Split('|'); new AHP { Kd = ra[0], Ad = ra[1] }; } } }); } Db.Transact(() => { var MK = new AHP { Kd = "01", Ad = "Merkez Kasa", P = Db.SQL <AHP>("SELECT r FROM AHP r WHERE r.P IS NULL and r.Kd = ?", "100").FirstOrDefault() }; new AHP { Kd = "01", Ad = "TL", P = MK }; new AHP { Kd = "02", Ad = "USD", P = MK }; new AHP { Kd = "03", Ad = "EUR", P = MK }; }); }
public static bool IsAhpKdUnique(AHP pAhp, string newKd) { AHP ahp; if (pAhp == null) { ahp = Db.SQL <AHP>("select r from AHP r where r.P IS NULL and r.Kd = ?", newKd).FirstOrDefault(); } else { ahp = Db.SQL <AHP>("select r from AHP r where r.P = ? and r.Kd = ?", pAhp, newKd).FirstOrDefault(); } if (ahp == null) { return(true); } return(false); }