private bool LoadConfigFile(string FileName) { StreamReader SRObj = new StreamReader(FileName, System.Text.Encoding.GetEncoding("GBK")); try { if (SRObj.EndOfStream == false) { //悼念 string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorTitleObj.FontObj != null) { if (SetFont(FontClass) != null) { FontColorTitleObj.FontObj = SetFont(FontClass); SetFontColor(TitleButton, FontColorTitleObj.FontObj, FontColorTitleObj.ColorObj); } } } if (SRObj.EndOfStream == false) { //LIST字体 string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false) { if (SetFont(FontClass) != null) { FontColorDefault = new FontColorClass(); FontColorDefault.FontObj = SetFont(FontClass); FontColorDefault.ColorObj = Color.Black; } if (FontColorList != null && FontColorList.Count > 0) { for (int i = 0; i < FontColorList.Count; i++) { if (FontColorList[i] != null) { if (((FontColorClass)FontColorList[i]) != null) { if (FontColorDefault != null) { FontColorList[i] = FontColorDefault; GridViewSetFont(i, GridViewControl.ColumnCount - 1, ((FontColorClass)FontColorList[i]).FontObj); } } } } } } } if (SRObj.EndOfStream == false) { //敬挽 string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorTailObj.FontObj != null) { if (SetFont(FontClass) != null) { FontColorTailObj.FontObj = SetFont(FontClass); SetFontColor(TailButton, FontColorTailObj.FontObj, FontColorTailObj.ColorObj); } } } if (SRObj.EndOfStream == false) { //死者 string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorDeadManObj.FontObj != null) { if (SetFont(FontClass) != null) { FontColorDeadManObj.FontObj = SetFont(FontClass); SetFontColor(DeadManButton, FontColorDeadManObj.FontObj, FontColorDeadManObj.ColorObj); } } } if (SRObj.EndOfStream == false) { //称谓前 string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorFObj.FontObj != null) { if (SetFont(FontClass) != null) { FontColorFObj.FontObj = SetFont(FontClass); SetFontColor(DeadManFButton, FontColorFObj.FontObj, FontColorFObj.ColorObj); } } } if (SRObj.EndOfStream == false) { //称谓后 string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorTObj.FontObj != null) { if (SetFont(FontClass) != null) { FontColorTObj.FontObj = SetFont(FontClass); SetFontColor(DeadManTButton, FontColorTObj.FontObj, FontColorTObj.ColorObj); } } } //边距 if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { TopSizeText1.Text = FontClass; } } if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { TopSizeText2.Text = FontClass; } } if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { Name12SizeText.Text = FontClass; } } //姓名之间距离 if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { Text_NameSize.Text = FontClass; } } //单,双行字体 if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorDSObj1.FontObj != null) { if (SetFont(FontClass) != null) { FontColorDSObj1.FontObj = SetFont(FontClass); SetFontColor(Button_SetDSFont1, FontColorDSObj1.FontObj, FontColorDSObj1.ColorObj); } } } if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorDSObj2.FontObj != null) { if (SetFont(FontClass) != null) { FontColorDSObj2.FontObj = SetFont(FontClass); SetFontColor(Button_SetDSFont2, FontColorDSObj2.FontObj, FontColorDSObj2.ColorObj); } } } //序号X,Y 字体 if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { Text_SequenceX.Text = FontClass; } } if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { Text_SequenceY.Text = FontClass; } } if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && FontColorSequenceObj.FontObj != null) { if (SetFont(FontClass) != null) { FontColorSequenceObj.FontObj = SetFont(FontClass); SetFontColor(Button_SequenceFontColor, FontColorSequenceObj.FontObj, FontColorSequenceObj.ColorObj); } } } //行距(单) if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { Text_Spacing1.Text = FontClass; } } //行距(双) if (SRObj.EndOfStream == false) { string FontClass = SRObj.ReadLine(); if (String.IsNullOrEmpty(FontClass) == false && (IsFloatNumber(FontClass) || IsIntegerNumber(FontClass))) { Text_Spacing2.Text = FontClass; } } SRObj.Close(); return true; } catch (Exception ex) { SRObj.Close(); MessageBox.Show(ex.Message, "载入设置错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } }
public MainFrame() { InitializeComponent(); FontControl = new FontDialog(); ColorControl = new ColorDialog(); DeadSexComBoBox.SelectedIndex = 0; DeadManTimeText.Text = DateTime.Now.ToShortDateString(); PrintDialogControl = new PrintDialog(); PrintDocumentControl = new PrintDocument(); PrintDocumentControl.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.PrintDocumentControl_PrintPage); PrintPreviewDialogControl = new PrintPreviewDialog(); FontControl.Font = new Font("隶书", (float)40, FontStyle.Bold); ColorControl.Color = Color.Black; FontColorTitleObj = new FontColorClass(); FontColorTitleObj.FontObj = new Font("隶书", (float)48, FontStyle.Bold); FontColorTitleObj.ColorObj = Color.Black; FontColorDeadManObj = new FontColorClass(); FontColorDeadManObj.FontObj = FontControl.Font; FontColorDeadManObj.ColorObj = ColorControl.Color; BodyList = new ArrayList(); FontColorList = new ArrayList(); PrintList = new ArrayList(); FontColorTailObj = new FontColorClass(); FontColorTailObj.FontObj = new Font("隶书", (float)40, FontStyle.Bold); FontColorTailObj.ColorObj = Color.Black; FontColorFObj = new FontColorClass(); FontColorFObj.FontObj = new Font("隶书", (float)40, FontStyle.Bold); FontColorFObj.ColorObj = Color.Black; FontColorTObj = new FontColorClass(); FontColorTObj.FontObj = new Font("隶书", (float)40, FontStyle.Bold); FontColorTObj.ColorObj = Color.Black; FontColorDSObj1 = new FontColorClass(); FontColorDSObj1.FontObj = new Font("隶书", (float)40, FontStyle.Bold); FontColorDSObj1.ColorObj = Color.Black; FontColorDSObj2 = new FontColorClass(); FontColorDSObj2.FontObj = new Font("隶书", (float)40, FontStyle.Bold); FontColorDSObj2.ColorObj = Color.Black; FontColorSequenceObj = new FontColorClass(); FontColorSequenceObj.FontObj = new Font("宋体", (float)10, FontStyle.Regular); FontColorSequenceObj.ColorObj = Color.Black; SetFontColor(TitleButton, FontColorTitleObj.FontObj, FontColorTitleObj.ColorObj); SetFontColor(DeadManButton, FontColorDeadManObj.FontObj, FontColorDeadManObj.ColorObj); SetFontColor(TailButton, FontColorTailObj.FontObj, FontColorTailObj.ColorObj); SetFontColor(DeadManFButton, FontColorFObj.FontObj, FontColorFObj.ColorObj); SetFontColor(DeadManTButton, FontColorTObj.FontObj, FontColorTObj.ColorObj); SetFontColor(Button_SetDSFont1, FontColorDSObj1.FontObj, FontColorDSObj1.ColorObj); SetFontColor(Button_SetDSFont2, FontColorDSObj2.FontObj, FontColorDSObj2.ColorObj); SetFontColor(Button_SequenceFontColor, FontColorSequenceObj.FontObj, FontColorSequenceObj.ColorObj); TopSizeText1.Text = "100"; TopSizeText2.Text = "100"; Text_NameSize.Text = "10"; Name12SizeText.Text = "20"; Text_SequenceX.Text = SequenceX.ToString(); Text_SequenceY.Text = SequenceY.ToString(); Text_Spacing1.Text = Spacing1.ToString(); Text_Spacing2.Text = Spacing2.ToString(); if (File.Exists(Application.StartupPath + "\\" + "default.txt")) LoadConfigFile(Application.StartupPath + "\\" + "default.txt"); }
private bool InToExcel(string ExcelFile) { Excel.Application ExcelObj = null; try { ExcelObj = new Excel.ApplicationClass(); ExcelObj.Visible = false; Excel.Workbook ExcelBook = ExcelObj.Workbooks._Open(ExcelFile, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); Excel.Worksheet ExcelSheet = (Excel.Worksheet)ExcelBook.Sheets[1]; //死者 DeadManText.Text = ExcelCellToString(ExcelSheet.get_Range("B1", Type.Missing)); //性别 if (ExcelCellToString(ExcelSheet.get_Range("G1", Type.Missing)) == "男") DeadSexComBoBox.SelectedIndex = 0; else DeadSexComBoBox.SelectedIndex = 1; //出殡时间 DeadManTimeText.Text = ExcelCellToDate(ExcelSheet.get_Range("B2", Type.Missing)); //告别厅 DeadManAddressText.Text = ExcelCellToString(ExcelSheet.get_Range("F2", Type.Missing)); //列表用户 if (GridViewControl.RowCount > 1) GridViewControl.Rows.Clear(); int i = 4; int j = 0; while (true) { string Cell1 = ExcelCellToString((Excel.Range)ExcelSheet.Cells[i, 1]); if (String.IsNullOrEmpty(Cell1)) { break; } else { GridViewControl.Rows.Add(); GridViewControl.Rows[j].Cells[0].Value = Cell1; //称谓(前) string Cell2 = ExcelCellToString((Excel.Range)ExcelSheet.Cells[i, 2]); GridViewControl.Rows[j].Cells[1].Value = Cell2; //称谓(后) string Cell3 = ExcelCellToString((Excel.Range)ExcelSheet.Cells[i, 3]); GridViewControl.Rows[j].Cells[2].Value = Cell3; //姓名1 string Cell4 = ExcelCellToString((Excel.Range)ExcelSheet.Cells[i, 4]); GridViewControl.Rows[j].Cells[3].Value = Cell4; //姓名2 string Cell5 = ExcelCellToString((Excel.Range)ExcelSheet.Cells[i, 5]); GridViewControl.Rows[j].Cells[4].Value = Cell5; //项目 string Cell6 = ExcelCellToString((Excel.Range)ExcelSheet.Cells[i, 6]); GridViewControl.Rows[j].Cells[5].Value = Cell6; //价钱 string Cell7 = ExcelCellToString((Excel.Range)ExcelSheet.Cells[i, 7]); GridViewControl.Rows[j].Cells[6].Value = Cell7; FontColorClass FontColorObj = new FontColorClass(); if (FontColorDefault == null) { FontColorObj.FontObj = new Font("隶书", (float)40, FontStyle.Bold); FontColorObj.ColorObj = Color.Black; } else { FontColorObj = FontColorDefault; } FontColorList.Add(FontColorObj); GridViewSetFont(j, GridViewControl.ColumnCount - 1, FontColorObj.FontObj); i++; j++; } } ExcelSheet = null; ExcelBook.Close(false, false, false); ExcelBook = null; ExcelObj.Quit(); ExcelObj = null; //合计 TotalPriceText.Text = SumCellPrice(6).ToString(); return true; } catch (Exception ex) { ExcelObj.Quit(); ExcelObj = null; MessageBox.Show(ex.Message, "导入错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } }
private void GridViewControl_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == GridViewControl.ColumnCount - 2) { string PriceString = GridViewCellToString(GridViewControl[e.ColumnIndex, e.RowIndex]); if (String.IsNullOrEmpty(PriceString) == false) { if (IsFloatNumber(PriceString)) TotalPriceText.Text = SumCellPrice(6).ToString(); else { MessageBox.Show("请输入正确的金额", "请输入正确的金额", MessageBoxButtons.OK, MessageBoxIcon.Error); GridViewControl[e.ColumnIndex, e.RowIndex].Value = ""; return; } } } if (e.ColumnIndex != GridViewControl.ColumnCount - 1 && e.RowIndex == FontColorList.Count) { FontColorClass FontColorObj = new FontColorClass(); if (FontColorDefault == null) { FontColorObj.FontObj = FontControl.Font; FontColorObj.ColorObj = ColorControl.Color; } else { FontColorObj = FontColorDefault; } FontColorList.Add(FontColorObj); GridViewSetFont(e.RowIndex, GridViewControl.ColumnCount - 1, FontColorObj.FontObj); } }
private void GridViewControl_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { if (GridViewControl.Rows[e.RowIndex].Cells[0].Value == null || String.IsNullOrEmpty(GridViewControl.Rows[e.RowIndex].Cells[0].Value.ToString())) GridViewControl.Rows[e.RowIndex].Cells[0].Value = Convert.ToString(e.RowIndex + 1); if (e.ColumnIndex == GridViewControl.ColumnCount - 1) { if (FontColorList.Count > e.RowIndex) { FontControl.Font = ((FontColorClass)FontColorList[e.RowIndex]).FontObj; ColorControl.Color = ((FontColorClass)FontColorList[e.RowIndex]).ColorObj; FontControl.ShowDialog(); ColorControl.ShowDialog(); FontColorClass FontColorObj = new FontColorClass(); FontColorObj.FontObj = FontControl.Font; FontColorObj.ColorObj = ColorControl.Color; FontColorList[e.RowIndex] = FontColorObj; GridViewSetFont(e.RowIndex, GridViewControl.ColumnCount - 1, FontColorObj.FontObj); e.Cancel = true; } else e.Cancel = true; } }
//Right public SizeF Print_Content_Right(string PrintString, FontColorClass FontColorObj, float PostionLR, float PrintY, int SpacingType, PrintPageEventArgs e) { SizeF PrintWH = new SizeF(); if (PrintString.IndexOf("\n") == -1) { PrintWH = e.Graphics.MeasureString(PrintString, FontColorObj.FontObj); e.Graphics.DrawString(PrintString, FontColorObj.FontObj, new SolidBrush(FontColorObj.ColorObj), e.PageBounds.Width / 2 + PostionLR, PrintY, new StringFormat()); PrintWH.Height += PrintY; } else { float Width = 0, Height = 0; string[] PrintString_Array = PrintString.Split(new string[] { "\n" }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < PrintString_Array.Length; i++) { PrintWH = e.Graphics.MeasureString(PrintString_Array[i], FontColorObj.FontObj); e.Graphics.DrawString(PrintString_Array[i], FontColorObj.FontObj, new SolidBrush(FontColorObj.ColorObj), e.PageBounds.Width / 2 + PostionLR, PrintY, new StringFormat()); Width = PrintWH.Width; Height = PrintY + PrintWH.Height; if (i < PrintString_Array.Length - 1) { if (SpacingType == 1) Height += Spacing1; else Height += Spacing2; PrintY = Height; } } PrintWH.Width = Width; PrintWH.Height = Height; } return PrintWH; }