private void SetTemplate() { PrintPJTTemplate uc = (PrintPJTTemplate)Page.LoadControl("PrintPJTTemplate.ascx"); uc.NoPJT = NoPJT; uc.Project = Project; list.Controls.Add(uc); }
private void Print(string NoPJT) { //increment Db.Execute("UPDATE MS_PJT SET PrintPJT = PrintPJT + 1 " + " WHERE NoPJT = '" + NoPJT + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglPJT, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref]" + ",Unit" + ",Customer" + ",Total" + " FROM MS_PJT WHERE NoPJT = '" + NoPJT + "'"); Db.Execute("EXEC spLogPJT" + " 'P-PJT'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoPJT.ToString() + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_PJT_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_PJT WHERE NoPJT = '" + NoPJT + "') "); Db.Execute("UPDATE MS_PJT_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(dari.Text); ConvertPdf(); Response.Redirect(Param.PathLinkFilePDFCollection + Cf.Tgl(Dari) + "&" + Cf.Tgl(Sampai) + "&" + project.SelectedValue + "_PJTBatch.pdf"); string file = Param.PathFilePDFCollection + Cf.Tgl(Dari) + "&" + Cf.Tgl(Sampai) + "&" + project.SelectedValue + "_PJTBatch.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 + "_PJTBatch.pdf"); //Template PrintPJTTemplate uc = (PrintPJTTemplate)Page.LoadControl("PrintPJTTemplate.ascx"); uc.NoPJT = NoPJT.ToString(); uc.Project = project.ToString(); list.Controls.Add(uc); }
private void Print(string NoPJT, string project) { //increment Db.Execute("UPDATE MS_PJT SET PrintPJT = PrintPJT + 1 " + " WHERE NoPJT = '" + NoPJT + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglPJT, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref]" + ",Unit" + ",Customer" + ",Total" + " FROM MS_PJT WHERE NoPJT = '" + NoPJT + "'"); Db.Execute("EXEC spLogPJT" + " 'P-PJT'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoPJT.ToString() + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_PJT_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_PJT WHERE NoPJT = '" + NoPJT + "') "); Db.Execute("UPDATE MS_PJT_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); //Template PrintPJTTemplate uc = (PrintPJTTemplate)Page.LoadControl("PrintPJTTemplate.ascx"); uc.NoPJT = NoPJT.ToString(); uc.Project = project.ToString(); list.Controls.Add(uc); }