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);
}
