private void SetTemplate(string NoTTS)
{
PrintBKMTemplate uc = (PrintBKMTemplate)Page.LoadControl("PrintBKMTemplate.ascx");
uc.NoTTS = NoTTS;
list.Controls.Add(uc);
}
private void SetTemplate()
{
PrintBKMTemplate uc = (PrintBKMTemplate)Page.LoadControl("PrintBKMTemplate.ascx");
uc.NoTTS = NoTTS;
uc.Project = Project;
list.Controls.Add(uc);
}
private void Print(int NoTTS)
{
//increment
Db.Execute("UPDATE MS_TTS SET PrintBKM = PrintBKM + 1 WHERE NoTTS = " + NoTTS);
//Logfile
DataTable rs = Db.Rs("SELECT "
+ " CONVERT(varchar, TglTTS, 106) AS [Tanggal]"
+ ",Tipe"
+ ",Ref AS [Ref.]"
+ ",Unit"
+ ",Customer"
+ ",CaraBayar AS [Cara Bayar]"
+ ",Ket AS [Keterangan]"
+ ",Total"
+ ",NoBG AS [No. BG]"
+ ",CONVERT(varchar, TglBG, 106) AS [Tanggal BG]"
+ ",NoBKM AS [No. BKM]"
+ ",CONVERT(varchar, TglBKM, 106) AS [Tanggal BKM]"
+ " FROM MS_TTS WHERE NoTTS = " + NoTTS);
Db.Execute("EXEC spLogTTS"
+ " 'P-BKM'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rs) + "'"
+ ",'" + NoTTS.ToString().PadLeft(7, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_TTS_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_TTS WHERE NoTTS = '" + NoTTS + "')");
Db.Execute("UPDATE MS_TTS_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
//Template
PrintBKMTemplate uc = (PrintBKMTemplate)Page.LoadControl("PrintBKMTemplate.ascx");
uc.NoTTS = NoTTS.ToString();
list.Controls.Add(uc);
}
private void SetTemplate(string id, string project)
{
//increment
Db.Execute("UPDATE MS_TTS SET PrintBKM = PrintBKM + 1 WHERE NoTTS = " + id);
//Logfile
DataTable rs = Db.Rs("SELECT "
+ " CONVERT(varchar, TglTTS, 106) AS [Tanggal]"
+ ",Tipe"
+ ",Ref AS [Ref.]"
+ ",Unit"
+ ",Customer"
+ ",CaraBayar AS [Cara Bayar]"
+ ",Ket AS [Keterangan]"
+ ",Total"
+ ",NoBG AS [No. BG]"
+ ",CONVERT(varchar, TglBG, 106) AS [Tanggal BG]"
+ ",NoBKM AS [No. BKM]"
+ ",CONVERT(varchar, TglBKM, 106) AS [Tanggal BKM]"
+ " FROM MS_TTS WHERE NoTTS = " + id);
Db.Execute("EXEC spLogTTS"
+ " 'P-BKM'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rs) + "'"
+ ",'" + id.ToString().PadLeft(7, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_TTS_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE MS_TTS_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
PrintBKMTemplate uc = (PrintBKMTemplate)Page.LoadControl("PrintBKMTemplate.ascx");
uc.NoTTS = id;
uc.Project = project;
list.Controls.Add(uc);
}
