public static string NamaPT(string ProjectID)
{
return(Db.SingleString("SELECT ISNULL(Pers, '') FROM ISC064_SECURITY..REF_PROJECT WHERE Project = '" + ProjectID + "'"));
}
public static string SMSEditor(string Tipe, string Project)
{
return(Db.SingleString("SELECT ISNULL(Format, '') FROM " + Mi.DbPrefix + "SECURITY..SmsFormat WHERE Project = '" + Project + "' AND Tipe = '" + Tipe + "'"));
}
//Numerator Builder
//public static string PK(string Kode, int Count)
//{
// return PK(Kode, 0, 0, Count);
//}
public static string PK(string Kode, int Tahun, int Bulan, int Count, string Project)
{
string x = "";
var rs = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "SECURITY..Numerator WHERE Kode = '" + Kode + "' AND Project = '" + Project + "'");
if (rs.Rows.Count > 0)
{
var r = rs.Rows[0];
string Pemisah = r["Pemisah"].ToString();
x = r["Komposisi"].ToString();
string Prefix = r["Prefix"].ToString();
string Num = Count.ToString().PadLeft(Convert.ToInt16(r["DigitNum"]), '0');
string Thn = "";
if (Tahun != 0)
{
if (Convert.ToInt16(r["FormatTahun"]) == 0)
{
Thn = Tahun.ToString().Substring(2, 2);
}
if (Convert.ToInt16(r["FormatTahun"]) == 1)
{
Thn = Tahun.ToString();
}
}
string Bln = "";
if (Bulan != 0)
{
if (Convert.ToInt16(r["FormatBulan"]) == 0)
{
Bln = Bulan.ToString().PadLeft(2, '0');
}
if (Convert.ToInt16(r["FormatBulan"]) == 1)
{
Bln = Cf.TglNamaBln(Bulan, true);
}
if (Convert.ToInt16(r["FormatBulan"]) == 2)
{
Bln = Cf.TglNamaBln(Bulan, false).Substring(0, 3).ToUpper();
}
}
//khusus panahome
string Pers = Db.SingleString("SELECT Pers FROM " + Mi.DbPrefix + "SECURITY..REF_PROJECT WHERE Project='" + Project + "'");
x = x.Replace("{Prefix}", Prefix + Pemisah);
x = x.Replace("{Project}", Pers + Pemisah);
if (Tahun != 0)
{
x = x.Replace("{Thn}", Thn + Pemisah);
}
else
{
x = x.Replace("{Thn}", "");
}
if (Bulan != 0)
{
x = x.Replace("{Bln}", Bln + Pemisah);
}
else
{
x = x.Replace("{Bln}", "");
}
x = x.Replace("{Num}", Num + Pemisah);
if (x.EndsWith(Pemisah))
{
x = x.Remove(x.Length - 1);
}
}
return(x);
}
public static string Href(string NoStock)
{
string x = "";
string strSql = "SELECT Status, NoUnit FROM ISC064_MARKETINGJUAL..MS_UNIT WHERE NoStock = '" + NoStock + "'";
DataTable rs = Db.Rs(strSql, Conn);
if (rs.Rows.Count != 0)
{
if (rs.Rows[0]["Status"].ToString() == "B")
{
int c = Db.SingleInteger("SELECT COUNT(*) FROM ISC064_MARKETINGJUAL..MS_KONTRAK"
+ " WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
if (c != 0)
{
string NoKontrak = Db.SingleString("SELECT TOP 1 NoKontrak FROM ISC064_MARKETINGJUAL..MS_KONTRAK WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
int NoTTS = 0;
DataTable tts = Db.Rs("SELECT TOP 1 NoTTS FROM ISC064_FINANCEAR..MS_TTS WHERE Ref = '" + NoKontrak + "' AND Status <> 'VOID' ORDER BY NoTTS ASC", Conn);
if (tts.Rows.Count != 0)
{
NoTTS = Convert.ToInt32(tts.Rows[0][0]);
}
x = "TabelStok3.aspx?NoKontrak=" + NoKontrak + "&NoTTS=" + NoTTS; //sold
}
else
{
x = "javascript:popUnit(\"" + NoStock + "\")"; //hold internal
}
}
else if (rs.Rows[0]["Status"].ToString() == "H")
{
int c = Db.SingleInteger("SELECT COUNT(*) FROM ISC064_MARKETINGJUAL..MS_HOLD"
+ " WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
if (c != 0)
{
string NoHold = Db.SingleString("SELECT TOP 1 NoHOLD FROM ISC064_MARKETINGJUAL..MS_HOLD WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
x = "HoldUnitDaftarDone.aspx?NoHold=" + NoHold + "";
}
else
{
x = " ";
}
}
else
{
int c = Db.SingleInteger("SELECT COUNT(*) FROM ISC064_MARKETINGJUAL..MS_RESERVASI"
+ " WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
if (c != 0)
{
x = "TabelStok2.aspx?NoStock=" + NoStock;//"KontrakDaftar2.aspx?NoStock=" + rs.Rows[0]["NoStock"]; //booked
}
else
{
if (Act.SecLevel == "AG")
{
x = "javascript:popUnit(\"" + NoStock + "\")"; //available
}
else
{
x = "TabelStok2.aspx?NoStock=" + NoStock; //available
}
}
}
}
return(x);
}
public static Color WarnaUnit(string NoStock)
{
string strSql = "SELECT Status,Project"
+ " FROM ISC064_MARKETINGJUAL..MS_UNIT "
+ " WHERE NoStock = '" + NoStock + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count != 0)
{
Color color = new Color();
string WarnaJual = Db.SingleString("SELECT ISNULL(MAX(Value), '#FFFFFF') FROM ISC064_SECURITY..REF_PARAM WHERE ParamID='WarnaUnitJual" + rs.Rows[0]["Project"] + "'", Conn);
string WarnaBooked = Db.SingleString("SELECT ISNULL(MAX(Value), '#FFFFFF') FROM ISC064_SECURITY..REF_PARAM WHERE ParamID='WarnaUnitBooked" + rs.Rows[0]["Project"] + "'", Conn);
string WarnaAvailable = Db.SingleString("SELECT ISNULL(MAX(Value), '#FFFFFF') FROM ISC064_SECURITY..REF_PARAM WHERE ParamID='WarnaUnitCancel" + rs.Rows[0]["Project"] + "'", Conn);
string WarnaHold = Db.SingleString("SELECT ISNULL(MAX(Value), '#FFFFFF') FROM ISC064_SECURITY..REF_PARAM WHERE ParamID='WarnaUnitHold" + rs.Rows[0]["Project"] + "'", Conn);
if (rs.Rows[0]["Status"].ToString() == "B")
{
int c = Db.SingleInteger("SELECT COUNT(*) FROM ISC064_MARKETINGJUAL..MS_KONTRAK"
+ " WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
if (c != 0)
{
string NoKontrak = Db.SingleString("SELECT NoKontrak FROM "
+ " ISC064_MARKETINGJUAL..MS_KONTRAK WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
color = Color.FromName(WarnaJual); //sold
}
else
{
color = Color.FromName(WarnaHold); //hold internal
}
}
else if (rs.Rows[0]["Status"].ToString() == "H")
{
string seclevel = Db.SingleString("SELECT SecLevel FROM ISC064_SECURITY..USERNAME WHERE UserID = '" + Act.UserID + "'", Conn);
if (seclevel == "SALES")
{
color = Color.FromName(WarnaHold); //reserved
}
else
{
color = Color.FromName(WarnaHold); //reserved
}
}
else
{
int c = Db.SingleInteger("SELECT COUNT(*) FROM ISC064_MARKETINGJUAL..MS_RESERVASI"
+ " WHERE Status = 'A' AND NoStock = '" + NoStock + "'", Conn);
if (c != 0)
{
string seclevel = Db.SingleString("SELECT SecLevel FROM ISC064_SECURITY..USERNAME WHERE UserID = '" + Act.UserID + "'", Conn);
if (seclevel == "SALES")
{
color = Color.FromName(WarnaJual); //reserved
}
else
{
color = Color.FromName(WarnaBooked); //reserved
}
}
else
{
color = Color.FromName(WarnaAvailable); //available
}
}
return(color);
}
else
{
return(Color.White);
}
}
//Driver
public static string GetParam(string ParamID)
{
return(Db.SingleString("SELECT Value FROM REF_PARAM WHERE ParamID = '" + Cf.Str(ParamID) + "'"));
}
