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