private void SetTemplate() { PrintSTTemplate uc = (PrintSTTemplate)Page.LoadControl("PrintSTTemplate.ascx"); uc.NoTunggakan = NoTunggakan; uc.Project = Project; list.Controls.Add(uc); }
private void Print(int NoTunggakan) { //increment Db.Execute("UPDATE MS_TUNGGAKAN SET PrintST = PrintST + 1 " + " WHERE NoTunggakan = " + NoTunggakan); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglTunggakan, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref.]" + ",Unit" + ",Customer" + ",Total" + ",LevelTunggakan AS [Level]" + " FROM MS_TUNGGAKAN WHERE NoTunggakan = " + NoTunggakan); Db.Execute("EXEC spLogTunggakan" + " 'P-ST'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoTunggakan.ToString().PadLeft(7, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_TUNGGAKAN_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_TUNGGAKAN WHERE NoTunggakan = '" + NoTunggakan + "') "); Db.Execute("UPDATE MS_TUNGGAKAN_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); //ConvertPdf(); //Response.Redirect(Param.PathLinkFilePDFCollection + Cf.Tgl(Dari) + "&" + Cf.Tgl(Sampai) + "_STBatch.pdf"); string file = Param.PathFilePDFCollection + Cf.Tgl(Dari) + "&" + Cf.Tgl(Sampai) + "&" + project.SelectedValue + "_STBatch.pdf"; bool exist = System.IO.File.Exists(file); if (exist) { System.IO.File.Delete(file); } ConvertPdf(); Response.Redirect(Param.PathLinkFilePDFCollection + Cf.Tgl(Dari) + "&" + Cf.Tgl(Sampai) + "&" + project.SelectedValue + "_STBatch.pdf"); //Template PrintSTTemplate uc = (PrintSTTemplate)Page.LoadControl("PrintSTTemplate.ascx"); uc.NoTunggakan = NoTunggakan.ToString(); uc.Project = project.SelectedValue; list.Controls.Add(uc); }
private void Print(int NoTunggakan) { //increment Db.Execute("UPDATE MS_TUNGGAKAN SET PrintST = PrintST + 1 " + " WHERE NoTunggakan = " + NoTunggakan); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglTunggakan, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref.]" + ",Unit" + ",Customer" + ",Total" + ",LevelTunggakan AS [Level]" + " FROM MS_TUNGGAKAN WHERE NoTunggakan = " + NoTunggakan); Db.Execute("EXEC spLogTunggakan" + " 'P-ST'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoTunggakan.ToString().PadLeft(7, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_TUNGGAKAN_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_TUNGGAKAN WHERE NoTunggakan = '" + NoTunggakan + "') "); Db.Execute("UPDATE MS_TUNGGAKAN_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); //Template PrintSTTemplate uc = (PrintSTTemplate)Page.LoadControl("PrintSTTemplate.ascx"); uc.NoTunggakan = NoTunggakan.ToString(); uc.Project = Project.ToString(); list.Controls.Add(uc); }