public static string NoInvoice(int Bulan, int Tahun)
{
string pk = "";
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM ISC064_MARKETINGSEWA..MS_TAGIHAN WHERE MONTH(TglJT) = " + Bulan + " AND YEAR(TglJT) = " + Tahun + " AND NoInvoice <> ''"
);
c += 1;
while (true)
{
pk = c.ToString().PadLeft(5, '0') + "/BM/FA/INV-AS/" + Cf.Roman(Bulan) + "/" + Tahun;
int cek = Db.SingleInteger(
"SELECT COUNT(*) FROM ISC064_MARKETINGSEWA..MS_TAGIHAN WHERE NoInvoice = '" + pk + "'"
);
if (cek > 0)
{
c++;
}
break;
}
return(pk);
}
public static string NoInvoice(string Tipe, int Bulan, int Tahun)
{
string pk = "", x = "";
if (Tipe == "ELE")
{
x = "LT";
}
else if (Tipe == "AIR")
{
x = "AR";
}
else
{
x = Tipe;
}
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM ISC064_TENANT..MS_TAGIHAN WHERE Tipe = '" + Tipe + "' AND MONTH(TglJT) = " + Bulan + " AND YEAR(TglJT) = " + Tahun + " AND NoInvoice <> ''"
);
c += 1;
while (true)
{
pk = c.ToString().PadLeft(5, '0') + "/BM/FA/INV-" + x + "/" + Cf.Roman(Bulan) + "/" + Tahun;
int cek = Db.SingleInteger(
"SELECT COUNT(*) FROM ISC064_TENANT..MS_TAGIHAN WHERE NoInvoice = '" + pk + "'"
);
if (cek > 0)
{
c++;
}
break;
}
return(pk);
}
