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) + "'")); }