/// <summary>
/// ֱ�Ӵ�ӡ
/// </summary>
public void PrintExcel(bool saveInk)
{
GoldPrinter.ExcelAccess excel = new GoldPrinter.ExcelAccess();
if (!saveInk)
{
string strExcelTemplateFile = Application.StartupPath + "/template/" + "��ʻ֤�����";
strExcelTemplateFile += "-" + this.Student.LearnType + ".xlt";
//System.IO.Path.GetFullPath(@"��ʻ֤�����.xlt");
excel.Open(strExcelTemplateFile);
}//��ģ���ļ�
else
{
string strExcelTemplateFile = Application.StartupPath + "/template/" + "�״�-��ʻ֤�����";
//System.IO.Path.GetFullPath(@"��ʻ֤�����.xlt");
strExcelTemplateFile += "-" + this.Student.LearnType + ".xlt";
excel.Open(strExcelTemplateFile);
//excel.Open();
}
excel.IsVisibledExcel = false;
Code39 code39 = new Code39();
code39.WidthCU = 2;
code39.LineHeight = 20;
try
{
//SizeF titleSize = MyGraphics.MeasureString("1", code39.titleFont);
code39.Height = code39.topHeight + code39.LineHeight + (int)20;//����ͼƬ�߶�
Bitmap map = code39.CreateBarCode(Student.IdCard);
string pathcode39 = Application.StartupPath + "/tempcode39.jpg";
ImageHelper.SaveCoderPic(map, pathcode39);
// map.Save(pathcode39, System.Drawing.Imaging.ImageFormat.Jpeg);
excel.InsertPicture(3, 1, pathcode39, 155, 26, 0);
}
catch (Exception ex)
{
//LogFactoryWrapper.Debug("����֤�������к��֣���֧��code39���룡");
}
//excel.SetCellText(1, 24, 1, 30, "����" + Fm.Windows.Forms.CompanyInfoForm.Info.NickName);
//excel.SetCellText(2, 24, 2, 30, "��У-" + Fm.Windows.Forms.CompanyInfoForm.Info.NickName);
// excel.SetCellText(1, 1, " " + this.name);
// excel.SetCellText(1, 20, " " + this.name);
//excel.SetCellText(1, 21, " " + this.name);
CompanyInfo comp = StaticCacheManager.GetConfig<CompanyInfo>();
excel.SetCellText(1, 22, "����" + comp.NickName);
//excel.SetCellText(1, 23, " " + this.name);
// excel.SetCellText(2, 24, 2, 30, " " + this.name);
excel.SetCellText(4, 3, 4, 11, " " + Student.Name);
excel.SetCellText(4, 14, 4, 15, Student.Sex);
excel.SetCellText(4, 19, 4, 24, Student.Birthday);
excel.SetCellText(4, 27, 4, 30, Student.Nation);
excel.SetCellText(5, 3, 5, 4, Student.IdCardType);
if (Student.IdCardType.Length < IdCardTypeMaxLen)
{
excel.SetFont(5, 3, 6, 4, new Font("����", 15f));
}
for (int i = 0; i < Student.IdCard.Length; i++)
{
excel.SetCellText(5, 7 + i, Student.IdCard[i].ToString());
}
if (Student.TempId.Length > 0)
{
excel.SetCellText(6, 3, 6, 4, "��ס֤");
for (int i = 0; i < Student.TempId.Length; i++)
{
excel.SetCellText(6, 7 + i, Student.TempId[i].ToString());
}
}
excel.SetCellText(7, 3, 7, 24, " " + Student.RegAddress);
string connadd=this.GetConnAddress();
excel.SetCellText(8, 3, 8, 24, " " + connadd);
if(connadd.Length<ConnAddressMaxLen)
{
excel.SetFont(8, 3, 8, 24, new Font("����", 15f));
}
excel.SetCellText(9, 3, 9, 13, " " + Student.Phone);
excel.SetCellText(9, 18, 9, 24, Student.PostCode);
excel.SetCellText(10, 11, 10, 17,Student.NewCarType);
DateTime regDate = System.DateTime.Now;
if (AllPrinterConfig.GetPrinterConfig().ApplyConfig.PrintApplyDate)
{
excel.SetCellText(35, 25, 36, 30, regDate.Year + " �� " + regDate.Month + " �� " + regDate.Day + "��");
}
string path = Application.StartupPath + "/temp.jpg";
if (Student.LearnType == "��ѧ")
{
if (AllPrinterConfig.GetPrinterConfig().ApplyConfig.Allow2Dimension)
{
//this.GetQRImage(Student.Dimension).Save(path, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageHelper.SaveCoderPic(this.GetQRImage(Student.Dimension), path);
//excel.InsertPicture(25, 23, path, 110, 110, 5);
excel.InsertPicture(27, 16, path, 100, 100, 5);
}
}
else
{
excel.SetCellText(10, 25, 10, 30, Student.OldCarType);
if (AllPrinterConfig.GetPrinterConfig().ApplyConfig.PrintProfile)
{
excel.SetCellText(3, 25, 3, 30, Student.Profile);
}
}
/*if (this.LearnTypeString == "��ѧ")
{
if (!this.saveInk)
{
excel.SetCellText(10, 3, "����������");
}
else
{
excel.SetCellText(10, 3, "��");
}
}
else
{
if (!this.saveInk)
{
excel.SetCellText(11, 3, "�������ݳ���");
}
else
{
excel.SetCellText(11, 3, "��");
}
excel.SetCellText(10, 25, 10, 30, this.HaveCarType);
}
*/
GlobalPrintSetting printSetting = StaticCacheManager.GetConfig<GlobalPrintSetting>();
if (printSetting.PrintModel == "ֱ�Ӵ�")
{
excel.Print();
}
else
{
excel.PrintPreview();
}
excel.Close();
}
/// <summary>
/// 直接打印
/// </summary>
public void PrintExcel(bool saveInk)
{
GoldPrinter.ExcelAccess excel = new GoldPrinter.ExcelAccess();
if (!saveInk)
{
string strExcelTemplateFile = Application.StartupPath + "/template/" + "驾驶证申请表";
strExcelTemplateFile += "-" + this.Student.LearnType + ".xlt";
//System.IO.Path.GetFullPath(@"驾驶证申请表.xlt");
excel.Open(strExcelTemplateFile);
}//用模板文件
else
{
string strExcelTemplateFile = Application.StartupPath + "/template/" + "套打-驾驶证申请表";
//System.IO.Path.GetFullPath(@"驾驶证申请表.xlt");
strExcelTemplateFile += "-" + this.Student.LearnType + ".xlt";
excel.Open(strExcelTemplateFile);
//excel.Open();
}
excel.IsVisibledExcel = false;
Code39 code39 = new Code39();
code39.WidthCU = 2;
code39.LineHeight = 20;
try
{
//SizeF titleSize = MyGraphics.MeasureString("1", code39.titleFont);
code39.Height = code39.topHeight + code39.LineHeight + (int)20;//定义图片高度
Bitmap map = code39.CreateBarCode(Student.IdCard);
string pathcode39 = Application.StartupPath + "/tempcode39.jpg";
ImageHelper.SaveCoderPic(map, pathcode39);
// map.Save(pathcode39, System.Drawing.Imaging.ImageFormat.Jpeg);
excel.InsertPicture(3, 1, pathcode39, 155, 26, 0);
}
catch (Exception ex)
{
//LogFactoryWrapper.Debug("由于证件号码有汉字，不支持code39编码！");
}
//excel.SetCellText(1, 24, 1, 30, "驾校：" + Fm.Windows.Forms.CompanyInfoForm.Info.NickName);
//excel.SetCellText(2, 24, 2, 30, "驾校-" + Fm.Windows.Forms.CompanyInfoForm.Info.NickName);
// excel.SetCellText(1, 1, " " + this.name);
// excel.SetCellText(1, 20, " " + this.name);
//excel.SetCellText(1, 21, " " + this.name);
CompanyInfo comp = StaticCacheManager.GetConfig <CompanyInfo>();
excel.SetCellText(1, 22, "驾校：" + comp.NickName);
//excel.SetCellText(1, 23, " " + this.name);
// excel.SetCellText(2, 24, 2, 30, " " + this.name);
excel.SetCellText(4, 3, 4, 11, " " + Student.Name);
excel.SetCellText(4, 14, 4, 15, Student.Sex);
excel.SetCellText(4, 19, 4, 24, Student.Birthday);
excel.SetCellText(4, 27, 4, 30, Student.Nation);
excel.SetCellText(5, 3, 5, 4, Student.IdCardType);
if (Student.IdCardType.Length < IdCardTypeMaxLen)
{
excel.SetFont(5, 3, 6, 4, new Font("宋体", 15f));
}
for (int i = 0; i < Student.IdCard.Length; i++)
{
excel.SetCellText(5, 7 + i, Student.IdCard[i].ToString());
}
if (Student.TempId.Length > 0)
{
excel.SetCellText(6, 3, 6, 4, "暂住证");
for (int i = 0; i < Student.TempId.Length; i++)
{
excel.SetCellText(6, 7 + i, Student.TempId[i].ToString());
}
}
excel.SetCellText(7, 3, 7, 24, " " + Student.RegAddress);
string connadd = this.GetConnAddress();
excel.SetCellText(8, 3, 8, 24, " " + connadd);
if (connadd.Length < ConnAddressMaxLen)
{
excel.SetFont(8, 3, 8, 24, new Font("宋体", 15f));
}
excel.SetCellText(9, 3, 9, 13, " " + Student.Phone);
excel.SetCellText(9, 18, 9, 24, Student.PostCode);
excel.SetCellText(10, 11, 10, 17, Student.NewCarType);
DateTime regDate = System.DateTime.Now;
if (AllPrinterConfig.GetPrinterConfig().ApplyConfig.PrintApplyDate)
{
excel.SetCellText(35, 25, 36, 30, regDate.Year + " 年 " + regDate.Month + " 月 " + regDate.Day + "日");
}
string path = Application.StartupPath + "/temp.jpg";
if (Student.LearnType == "初学")
{
if (AllPrinterConfig.GetPrinterConfig().ApplyConfig.Allow2Dimension)
{
//this.GetQRImage(Student.Dimension).Save(path, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageHelper.SaveCoderPic(this.GetQRImage(Student.Dimension), path);
//excel.InsertPicture(25, 23, path, 110, 110, 5);
excel.InsertPicture(27, 16, path, 100, 100, 5);
}
}
else
{
excel.SetCellText(10, 25, 10, 30, Student.OldCarType);
if (AllPrinterConfig.GetPrinterConfig().ApplyConfig.PrintProfile)
{
excel.SetCellText(3, 25, 3, 30, Student.Profile);
}
}
/*if (this.LearnTypeString == "初学")
* {
* if (!this.saveInk)
* {
* excel.SetCellText(10, 3, "□初次申领");
* }
* else
* {
* excel.SetCellText(10, 3, "√");
* }
*
* }
* else
* {
* if (!this.saveInk)
* {
* excel.SetCellText(11, 3, "□增加准驾车型");
* }
* else
* {
* excel.SetCellText(11, 3, "√");
* }
* excel.SetCellText(10, 25, 10, 30, this.HaveCarType);
* }
*/
GlobalPrintSetting printSetting = StaticCacheManager.GetConfig <GlobalPrintSetting>();
if (printSetting.PrintModel == "直接打")
{
excel.Print();
}
else
{
excel.PrintPreview();
}
excel.Close();
}