/// <summary>
/// 保存文件
/// </summary>
public void Save()
{
object format = WdSaveFormat.wdFormatDocument; //保存格式
object miss = System.Reflection.Missing.Value;
object fileName = this.FileName.Trim();
wordDoc.SaveAs(ref fileName, ref format, ref miss,
ref miss, ref miss, ref miss, ref miss,
ref miss, ref miss, ref miss, ref miss,
ref miss, ref miss, ref miss, ref miss,
ref miss);
object SaveChanges = WdSaveOptions.wdSaveChanges;
object OriginalFormat = WdOriginalFormat.wdOriginalDocumentFormat;
object RouteDocument = false;
//wordDoc.Close(ref SaveChanges, ref OriginalFormat, ref RouteDocument);
//wordApp.Quit(ref SaveChanges, ref OriginalFormat, ref RouteDocument);
}
public void Izradi_er1()
{
Microsoft.Office.Interop.Word.Application application = new Microsoft.Office.Interop.Word.ApplicationClass();
Microsoft.Office.Interop.Word.Document document = new Microsoft.Office.Interop.Word.DocumentClass();
try
{
decimal num2 = 0;
decimal num9 = 0;
decimal num10 = 0;
decimal num5 = 0;
decimal num6 = 0;
decimal num7 = 0;
decimal num4 = 0;
decimal num8 = 0;
IEnumerator enumerator = null;
application.Visible = false;
object temp = System.Reflection.Missing.Value;
object confirmConversions = true;
object readOnly = true;
object path = System.Windows.Forms.Application.StartupPath + @"\App_Data\Potvrda_o_placi.doc";
document = application.Documents.Open(ref path, ref confirmConversions, ref readOnly, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp);
document.ActiveWindow.View.ReadingLayout = false;
KORISNIKDataSet dataSet = new KORISNIKDataSet();
new KORISNIKDataAdapter().Fill(dataSet);
document.Fields[1].Result.Text = Conversions.ToString(dataSet.KORISNIK.Rows[0]["KORISNIK1NAZIV"]);
int startIndex = 0;
do
{
// Veličina ovog polja u bazi je 11 mjesta, ali se očito kod korisnika dešava da imaju po 10 mjesta
if (dataSet.KORISNIK.Rows[0]["KORISNIK1HZZO"].ToString().Length > startIndex)
{
document.Fields[2 + startIndex].Result.Text = dataSet.KORISNIK.Rows[0]["KORISNIK1HZZO"].ToString().Substring(startIndex, 1);
}
startIndex++;
}while (startIndex <= 10);
document.Fields[13].Result.Text = Conversions.ToString(this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["PREZIME"]);
document.Fields[14].Result.Text = Conversions.ToString(this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["IME"]);
startIndex = 0;
do
{
document.Fields[15 + startIndex].Result.Text = this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["jmbg"].ToString().Substring(startIndex, 1);
startIndex++;
}while (startIndex <= 3);
document.Fields[0x13].Result.Text = "1";
try
{
document.Fields[20].Result.Text = this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["jmbg"].ToString().Substring(4, 1);
document.Fields[0x15].Result.Text = this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["jmbg"].ToString().Substring(5, 1);
document.Fields[0x16].Result.Text = this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["jmbg"].ToString().Substring(6, 1);
}
catch (Exception) { }
startIndex = 0;
do
{
document.Fields[0x17 + startIndex].Result.Text = this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["OIB"].ToString().Substring(startIndex, 1);
startIndex++;
}while (startIndex <= 10);
string str = DB.N2T(RuntimeHelpers.GetObjectValue(this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["BROJZDRAVSTVENOG"]), "");
if (str.Trim() != "")
{
startIndex = 0;
do
{
if (str.Length > startIndex)
{
document.Fields[0x22 + startIndex].Result.Text = str.Substring(startIndex, 1);
}
startIndex++;
}while (startIndex <= 10);
}
startIndex = 0;
do
{
document.Fields[34 + startIndex].Result.Text = this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows[0]["jmbg"].ToString().Substring(startIndex, 1);
startIndex++;
}while (startIndex <= 12);
string str3 = Conversions.ToString(this.UltraCombo1.Value);
string str2 = Conversions.ToString(this.UltraCombo2.Value);
DateTime time = DateAndTime.DateSerial(Conversions.ToInteger(str3.Substring(0, 4)), Conversions.ToInteger(str3.Substring(5, 2)), Conversions.ToInteger("1"));
DateTime time2 = DateAndTime.DateSerial(Conversions.ToInteger(str2.Substring(0, 4)), Conversions.ToInteger(str2.Substring(5, 2)), Conversions.ToInteger("1"));
time = time.AddMonths(1);
time2 = time2.AddMonths(2).AddDays(-1.0);
str3 = time.ToString("ddMMyyyy", CultureInfo.InvariantCulture);
str2 = time2.ToString("ddMMyyyy", CultureInfo.InvariantCulture);
startIndex = 0;
do
{
document.Fields[47 + startIndex].Result.Text = str3.Substring(startIndex, 1);
startIndex++;
}while (startIndex <= 7);
startIndex = 0;
do
{
document.Fields[55 + startIndex].Result.Text = str2.Substring(startIndex, 1);
startIndex++;
}while (startIndex <= 7);
int num = 63;
try
{
enumerator = this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
document.Fields[num].Result.Text = Conversions.ToString(Operators.AddObject(Operators.AddObject(current["mjesecobracuna"], "/"), current["godinaobracuna"]));
document.Fields[num + 1].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["ukupnobruto"]));
document.Fields[num + 2].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["netoplaca"]));
document.Fields[num + 3].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["kolona4"]));
document.Fields[num + 4].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["kolona5"]));
document.Fields[num + 5].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["kolona6"]));
document.Fields[num + 6].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["satiukupno"]));
document.Fields[num + 7].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["kolona8"]));
document.Fields[num + 8].Result.Text = string.Format("{0:#,##0.00}", RuntimeHelpers.GetObjectValue(current["fondmjeseca"]));
num += 9;
num2 = Conversions.ToDecimal(Operators.AddObject(num2, current["ukupnobruto"]));
num9 = Conversions.ToDecimal(Operators.AddObject(num9, current["netoplaca"]));
num5 = Conversions.ToDecimal(Operators.AddObject(num5, current["kolona4"]));
num6 = Conversions.ToDecimal(Operators.AddObject(num6, current["kolona5"]));
num7 = Conversions.ToDecimal(Operators.AddObject(num7, current["kolona6"]));
num10 = Conversions.ToDecimal(Operators.AddObject(num10, current["satiukupno"]));
num8 = Conversions.ToDecimal(Operators.AddObject(num8, current["kolona8"]));
num4 = Conversions.ToDecimal(Operators.AddObject(num4, current["fondmjeseca"]));
if (((this.S_OD_BOLOVANJE_FONDDataSet1.S_OD_BOLOVANJE_FOND.Rows.Count * 9) + 63) == num)
{
document.Fields[117].Result.Text = string.Format("{0:#,##0.00}", num2);
document.Fields[118].Result.Text = string.Format("{0:#,##0.00}", num9);
document.Fields[119].Result.Text = string.Format("{0:#,##0.00}", num5);
document.Fields[120].Result.Text = string.Format("{0:#,##0.00}", num6);
document.Fields[121].Result.Text = string.Format("{0:#,##0.00}", num7);
document.Fields[122].Result.Text = string.Format("{0:#,##0.00}", num10);
document.Fields[123].Result.Text = string.Format("{0:#,##0.00}", num8);
document.Fields[124].Result.Text = string.Format("{0:#,##0.00}", num4);
}
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
if (decimal.Compare(num10, decimal.Zero) > 0)
{
document.Fields[125].Result.Text = string.Format("{0:#,##0.00}", DB.RoundUpDecimale(decimal.Divide(num2, num10), 2));
document.Fields[126].Result.Text = string.Format("{0:#,##0.0000}", decimal.Divide(num9, num10), 2);
}
else
{
document.Fields[125].Result.Text = string.Format("{0:#,##0.00}", 0);
document.Fields[126].Result.Text = string.Format("{0:#,##0.00}", 0);
}
document.Fields[127].Result.Text = Conversions.ToString(dataSet.KORISNIK.Rows[0]["korisnik1mjesto"]);
document.Fields[128].Result.Text = Conversions.ToString(DateAndTime.Year(DateAndTime.Today)).Substring(2, 2);
FolderBrowserDialog dialog = new FolderBrowserDialog();
SaveFileDialog dialog2 = new SaveFileDialog
{
InitialDirectory = @"C:\Desktop",
Filter = "Word datoteke (*.doc)|*.doc|All files (*.*)|*.*",
FileName = "Bolovanje_HZZO_Obrazac",
RestoreDirectory = true
};
dialog2.ShowDialog();
SaveFileDialog dialog3 = dialog2;
object fileName = dialog3.FileName;
document.SaveAs(ref fileName, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp, ref temp);
dialog3.FileName = Conversions.ToString(fileName);
}
catch (Exception exception)
{
MessageBox.Show("Greška u generiranju izvještaja: 'Prosjek bolovanje/HZZO'!" + Environment.NewLine + "Molimo provjerite valjanost/postojanost podataka koji su potrebni za generiranje izvještaja.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error);
new Mipsed7.Emailing.SendException(exception);
}
finally
{
//document.Close(false, Missing.Value, Missing.Value);
((_Document)document).Close(false, Missing.Value, Missing.Value);
//application.Quit(false, Missing.Value, Missing.Value);
((_Application)application).Quit(false, Missing.Value, Missing.Value);
// za svaki slučaj
if (document != null)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(document);
}
if (application != null)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(application);
}
// isprazni varijable
document = null;
application = null;
// force-amo GarbageCollector (za svaki slučaj)
GC.Collect();
this.Cursor = Cursors.Default;
}
}
public static void CreateWordDoc(string name)
{
#region inicialization
Form1.form.SetProc(0);
int namesLen = Data.teacher.Count;
const int pairLen = 4;//Сколько пар в день отображать
string[] daysNames = { "Понедельник", "Вторник", "Среда", "Четверг", "Пятница" };
string[] times = { "9.30-10.30", "11.10–12.45", "13.45–15.20", "15.35–17.10", "17.25–19.00??" };
object nr = 1;
object nc = pairLen;
object start = 0;
object end = 0;
const int dayWidth = 120; //ширина одного дня
const int namesWidth = 95; //ширина имен.
Word.Application app = new Word.ApplicationClass();
Word.Document doc = new Word.DocumentClass();
Object template = Type.Missing;
Object newTemplate = Type.Missing;
Object documentType = Type.Missing;
Object visible = Type.Missing;
app.Documents.Add(ref template, ref newTemplate, ref documentType, ref visible);
Object DefaultTableBehavior = Type.Missing;
Object AutoFitBehavior = Type.Missing;
//Формирование страницы
doc.PageSetup.Orientation = Word.WdOrientation.wdOrientLandscape;
//Создание таблицы
Word.Range cellRange;
Word.Range tableLocation = doc.Range(ref start, ref end);
doc.Tables.Add(tableLocation, namesLen + 2, 7, ref DefaultTableBehavior, ref AutoFitBehavior);
Word.Table table = doc.Tables[1];
table.Borders.Enable = 1;
table.Rows.SetHeight(14f, Microsoft.Office.Interop.Word.WdRowHeightRule.wdRowHeightExactly);
//Формирование Шрифтов
Word.Font TextFont = new Word.Font();
TextFont.Size = 8;
TextFont.Bold = 0;
table.Cell(1, 1).Width = namesWidth;
cellRange = table.Cell(1, 1).Range;
cellRange.Font = TextFont;
#endregion
formatTable(ref table, ref TextFont, pairLen, dayWidth, namesWidth, namesLen, cellRange);
setBorders(ref table, pairLen);
setDateToTable(ref doc, ref TextFont, pairLen, dayWidth, namesWidth, namesLen);
#region save
Object fileName = name;//@"C:\Test\Форматированная_Таблица.doc";
Object fileFormat = Type.Missing;
Object lockComments = Type.Missing;
Object password = Type.Missing;
Object addToRecentFiles = Type.Missing;
Object writePassword = Type.Missing;
Object readOnlyRecommended = Type.Missing;
Object embedTrueTypeFonts = Type.Missing;
Object saveNativePictureFormat = Type.Missing;
Object saveFormsData = Type.Missing;
Object saveAsAOCELetter = Type.Missing;
Object encoding = Type.Missing;
Object insertLineBreaks = Type.Missing;
Object allowSubstitutions = Type.Missing;
Object lineEnding = Type.Missing;
Object addBiDiMarks = Type.Missing;
doc.SaveAs(ref fileName, ref fileFormat, ref lockComments,
ref password, ref addToRecentFiles, ref writePassword,
ref readOnlyRecommended, ref embedTrueTypeFonts,
ref saveNativePictureFormat, ref saveFormsData,
ref saveAsAOCELetter, ref encoding, ref insertLineBreaks,
ref allowSubstitutions, ref lineEnding, ref addBiDiMarks);
Object saveChanges = Word.WdSaveOptions.wdSaveChanges;
Object originalFormat = Type.Missing;
Object routeDocument = Type.Missing;
app.Quit(ref saveChanges, ref originalFormat, ref routeDocument);
#endregion
}
