private void printMonth()
{
try
{
string strCaption=this.dataGrid3.CaptionText.Trim();
if(strCaption.IndexOf("��")<0)
{
MessageBox.Show("���ȵ��[ȷ��]��ť��");
return;
}
this.strPrintTitle=this.dataGrid3.CaptionText.Replace("���վ������ͳ�Ʊ�","");
if(this.m_xDocPrint==null)
{
this.m_xDocPrint=new XmlDocument();
this.m_xDocPrint.Load("repPrint.xml");
}
XmlNode xNode=this.m_xDocPrint.DocumentElement.SelectSingleNode("./rep[@val='3']");
DataGridTableStyle dgts=new DataGridTableStyle();
DataTable dt=new DataTable();
for(int i=0;i<xNode.ChildNodes.Count;i++)
{
string strField=xNode.ChildNodes[i].Attributes.GetNamedItem("field").Value.Trim();
string strHeader=xNode.ChildNodes[i].Attributes.GetNamedItem("headerText").Value.Trim();
string strWidth=xNode.ChildNodes[i].Attributes.GetNamedItem("width").Value.Trim();
dt.Columns.Add(strField);
DataGridColoredTextBoxColumn dgtc=new DataGridColoredTextBoxColumn();
dgtc.Width=int.Parse(strWidth);
dgtc.HeaderText=strHeader;
dgtc.MappingName=strField;
dgts.GridColumnStyles.Add(dgtc);
}
this.dgPrint.TableStyles.Clear();
this.dgPrint.TableStyles.Add(dgts);
this.dgPrint.DataSource=dt;
DataTable dtPrint=(DataTable)this.dgPrint.DataSource;
DataTable dtDetail=(DataTable)this.dataGrid3.DataSource;
for(int i=0;i<dtDetail.Rows.Count;i++)
{
dtPrint.ImportRow(dtDetail.Rows[i]);
}
this.clearBlankRow(dtPrint);
cutePrint.cutePrinter dgp=new cutePrint.cutePrinter(this.dgPrint,"���վ������ͳ�Ʊ�",30);
int iTimeMinus=int.Parse(xNode.Attributes.GetNamedItem("iTimeMinus").Value.Trim());
dgp.iTimeMinus=iTimeMinus;
dgp.leftMargin=int.Parse(xNode.Attributes.GetNamedItem("leftMargin").Value.Trim());
dgp.strTitle=this.strPrintTitle;
dgp.Print();
}
catch(Exception ex)
{
cSaveErr.CSaveErr.msgboxErr(ex.ToString());
}
}
private bool paintGrid()
{
try
{
if(this.m_xDocRep==null)
{
this.m_xDocRep=new XmlDocument();
this.m_xDocRep.Load("report.xml");
}
XmlNode xNodeRep=this.m_xDocRep.DocumentElement.SelectSingleNode("./report[@name='tb1']");
string strSql=xNodeRep.Attributes.GetNamedItem("sql").Value.Trim();
DataTable dt=new DataTable();
//BengZhan.CDBConnection.getDataTable(ref dt,strSql,"tb1");
DataGridTableStyle dgts=new DataGridTableStyle();
for(int i=0;i<xNodeRep.ChildNodes.Count;i++)
{
DataGridColoredTextBoxColumn dgtb;
XmlNode xNodeHeader=xNodeRep.ChildNodes[i];
string strText=xNodeHeader.Attributes.GetNamedItem("text").Value.Trim();
string strField=xNodeHeader.Attributes.GetNamedItem("field").Value.Trim();
string strWidth=xNodeHeader.Attributes.GetNamedItem("width").Value.Trim();
dgtb=new DataGridColoredTextBoxColumn();
dgtb.HeaderText=strText;
dgtb.MappingName=strField;
dt.Columns.Add(strField);
int iWidth=int.Parse(strWidth);
dgtb.Width=iWidth;
dgts.GridColumnStyles.Add(dgtb);
}
this.dataGrid1.TableStyles.Clear();
this.dataGrid1.TableStyles.Add(dgts);
dgts.AllowSorting=false;
this.dataGrid1.AllowSorting=false;
this.dataGrid1.DataSource=dt;
this.dataGrid1.ReadOnly=true;
this.dataGrid1.CaptionText="��ϸ��";
xNodeRep=this.m_xDocRep.DocumentElement.SelectSingleNode("./report[@name='tb2']");
dgts=new DataGridTableStyle();
dt=new DataTable();
for(int i=0;i<xNodeRep.ChildNodes.Count;i++)
{
DataGridColoredTextBoxColumn dgtb;
XmlNode xNodeHeader=xNodeRep.ChildNodes[i];
string strText=xNodeHeader.Attributes.GetNamedItem("text").Value.Trim();
string strField=xNodeHeader.Attributes.GetNamedItem("field").Value.Trim();
string strWidth=xNodeHeader.Attributes.GetNamedItem("width").Value.Trim();
dgtb=new DataGridColoredTextBoxColumn();
dgtb.HeaderText=strText;
dgtb.MappingName=strField;
dt.Columns.Add(strField);
int iWidth=int.Parse(strWidth);
dgtb.Width=iWidth;
dgts.GridColumnStyles.Add(dgtb);
}
this.dataGrid2.TableStyles.Clear();
this.dataGrid2.TableStyles.Add(dgts);
this.dataGrid2.DataSource=dt;
this.dataGrid2.CaptionText="��ͳ�Ʊ�";
this.dataGrid2.ReadOnly=true;
xNodeRep=this.m_xDocRep.DocumentElement.SelectSingleNode("./report[@name='tb3']");
dgts=new DataGridTableStyle();
dt=new DataTable();
for(int i=0;i<xNodeRep.ChildNodes.Count;i++)
{
DataGridColoredTextBoxColumn dgtb;
XmlNode xNodeHeader=xNodeRep.ChildNodes[i];
string strText=xNodeHeader.Attributes.GetNamedItem("text").Value.Trim();
string strField=xNodeHeader.Attributes.GetNamedItem("field").Value.Trim();
string strWidth=xNodeHeader.Attributes.GetNamedItem("width").Value.Trim();
dgtb=new DataGridColoredTextBoxColumn();
dgtb.HeaderText=strText;
dgtb.MappingName=strField;
dt.Columns.Add(strField);
int iWidth=int.Parse(strWidth);
dgtb.Width=iWidth;
dgts.GridColumnStyles.Add(dgtb);
}
this.dataGrid3.TableStyles.Clear();
this.dataGrid3.TableStyles.Add(dgts);
this.dataGrid3.DataSource=dt;
this.dataGrid3.CaptionText="��ͳ�Ʊ�";
this.dataGrid3.ReadOnly=true;
///this.dataGrid3.CaptionText="��ͳ�Ʊ�";
return true;
}
catch(Exception ex)
{
cSaveErr.CSaveErr.msgboxErr(ex.ToString());
return false;
}
}
private void printDetail()
{
try
{
if(this.m_xDocPrint==null)
{
this.m_xDocPrint=new XmlDocument();
this.m_xDocPrint.Load("salRepPrint.xml");
}
XmlNode xNode=this.m_xDocPrint.DocumentElement.SelectSingleNode("./rep[@val='1']");
DataGridTableStyle dgts=new DataGridTableStyle();
DataTable dt=new DataTable();
for(int i=0;i<xNode.ChildNodes.Count;i++)
{
string strField=xNode.ChildNodes[i].Attributes.GetNamedItem("field").Value.Trim();
string strHeader=xNode.ChildNodes[i].Attributes.GetNamedItem("headerText").Value.Trim();
string strWidth=xNode.ChildNodes[i].Attributes.GetNamedItem("width").Value.Trim();
dt.Columns.Add(strField);
DataGridColoredTextBoxColumn dgtc=new DataGridColoredTextBoxColumn();
dgtc.Width=int.Parse(strWidth);
dgtc.HeaderText=strHeader;
dgtc.MappingName=strField;
dgts.GridColumnStyles.Add(dgtc);
}
this.dgPrint.TableStyles.Clear();
this.dgPrint.TableStyles.Add(dgts);
this.dgPrint.DataSource=dt;
// for(int i=0;i<this.dgPrint.TableStyles[0].GridColumnStyles.Count;i++)
// {
// this.dgPrint.TableStyles[0].GridColumnStyles[i].HeaderText="text"+i.ToString();
// this.dgPrint.TableStyles[0].GridColumnStyles[i].MappingName="field"+i.ToString();
// }
//
// for(int i=0;i<this.dataGrid1.TableStyles[0].GridColumnStyles.Count;i++)
// {
// this.dgPrint.TableStyles[0].GridColumnStyles[i].MappingName=this.dataGrid1.TableStyles[0].GridColumnStyles[i].MappingName;
// this.dgPrint.TableStyles[0].GridColumnStyles[i].HeaderText=this.dataGrid1.TableStyles[0].GridColumnStyles[i].HeaderText;
// }
DataTable dtPrint=(DataTable)this.dgPrint.DataSource;
DataTable dtDetail=(DataTable)this.dataGrid1.DataSource;
for(int i=0;i<dtDetail.Rows.Count;i++)
{
dtPrint.ImportRow(dtDetail.Rows[i]);
}
this.clearBlankRow(dtPrint);
string strTitle=this.dataGrid1.CaptionText.Trim();
string strTitleE="";
if(strTitle.IndexOf("����Ա")>=0)
{
strTitleE="����Ա��ˮ��ϸ��";
}
else
{
strTitleE="���վ��ˮ��ϸ��";
}
strTitle=strTitle.Replace(strTitleE,"");
cutePrint.cutePrinter dgp=new cutePrint.cutePrinter(this.dgPrint,strTitleE,30);
int iTimeMinus=int.Parse(xNode.Attributes.GetNamedItem("iTimeMinus").Value.Trim());
dgp.iTimeMinus=iTimeMinus;
dgp.leftMargin=int.Parse(xNode.Attributes.GetNamedItem("leftMargin").Value.Trim());
dgp.strTitle=strTitle;
dgp.Print();
}
catch(Exception ex)
{
cSaveErr.CSaveErr.msgboxErr(ex.ToString());
}
}
private void print(int iDex)
{
try
{
DataTable dtZ = (DataTable)this.dataGrid1.DataSource;
if (dtZ == null)
{
MessageBox.Show("没有可打印数据！");
return;
}
if (dtZ.Rows.Count == 0)
{
MessageBox.Show("没有可打印数据！");
return;
}
if (this.m_xDocPrint == null)
{
this.m_xDocPrint = new XmlDocument();
this.m_xDocPrint.Load("iniRepP.xml");
}
XmlNode xNode = this.m_xDocPrint.DocumentElement.SelectSingleNode(string.Format("./report[@name='tb{0}']", iDex.ToString()));
DataGridTableStyle dgts = new DataGridTableStyle();
DataTable dt = new DataTable();
for (int i = 0; i < xNode.ChildNodes.Count; i++)
{
string strField = xNode.ChildNodes[i].Attributes.GetNamedItem("field").Value.Trim();
string strHeader = xNode.ChildNodes[i].Attributes.GetNamedItem("text").Value.Trim();
string strWidth = xNode.ChildNodes[i].Attributes.GetNamedItem("width").Value.Trim();
dt.Columns.Add(strField);
DataGridColoredTextBoxColumn dgtc = new DataGridColoredTextBoxColumn();
dgtc.Width = int.Parse(strWidth);
dgtc.HeaderText = strHeader;
dgtc.MappingName = strField;
dgts.GridColumnStyles.Add(dgtc);
}
this.dgPrint.TableStyles.Clear();
this.dgPrint.TableStyles.Add(dgts);
this.dgPrint.DataSource = dt;
for (int i = 0; i < this.dgPrint.TableStyles[0].GridColumnStyles.Count; i++)
{
this.dgPrint.TableStyles[0].GridColumnStyles[i].HeaderText = "text" + i.ToString();
this.dgPrint.TableStyles[0].GridColumnStyles[i].MappingName = "field" + i.ToString();
}
for (int i = 0; i < this.dataGrid1.TableStyles[0].GridColumnStyles.Count; i++)
{
this.dgPrint.TableStyles[0].GridColumnStyles[i].MappingName = this.dataGrid1.TableStyles[0].GridColumnStyles[i].MappingName;
this.dgPrint.TableStyles[0].GridColumnStyles[i].HeaderText = this.dataGrid1.TableStyles[0].GridColumnStyles[i].HeaderText;
}
DataTable dtPrint = (DataTable)this.dgPrint.DataSource;
DataTable dtDetail = (DataTable)this.dataGrid1.DataSource;
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
dtPrint.ImportRow(dtDetail.Rows[i]);
}
this.clearBlankRow(dtPrint);
string strTitle = this.dataGrid1.CaptionText.Trim();
if (strTitle.Trim() != "")
{
int iStart = strTitle.LastIndexOf(" ");
string strTitleEx = strTitle.Substring(iStart);
strTitle = strTitle.Substring(0, iStart);
cutePrint.cutePrinter dgp = new cutePrint.cutePrinter(this.dgPrint, strTitleEx.Trim(), 30);
int iTimeMinus = int.Parse(xNode.Attributes.GetNamedItem("iTimeMinus").Value.Trim());
dgp.iTimeMinus = iTimeMinus;
dgp.leftMargin = int.Parse(xNode.Attributes.GetNamedItem("leftMargin").Value.Trim());
dgp.strTitle = strTitle.Trim();
dgp.Print();
}
else
{
cutePrint.cutePrinter dgp = new cutePrint.cutePrinter(this.dgPrint, xNode.Attributes.GetNamedItem("title").Value.Trim(), 30);
int iTimeMinus = int.Parse(xNode.Attributes.GetNamedItem("iTimeMinus").Value.Trim());
dgp.iTimeMinus = iTimeMinus;
dgp.leftMargin = int.Parse(xNode.Attributes.GetNamedItem("leftMargin").Value.Trim());
dgp.strTitle = " ";
dgp.Print();
}
}
catch (Exception ex)
{
cSaveErr.CSaveErr.msgboxErr(ex.ToString());
}
}
private void print(int iDex)
{
try
{
DataTable dtZ=(DataTable)this.dataGrid1.DataSource;
if(dtZ==null)
{
MessageBox.Show("û�пɴ�ӡ���ݣ�");
return;
}
if(dtZ.Rows.Count==0)
{
MessageBox.Show("û�пɴ�ӡ���ݣ�");
return;
}
if(this.m_xDocPrint==null)
{
this.m_xDocPrint=new XmlDocument();
this.m_xDocPrint.Load("iniRepP.xml");
}
XmlNode xNode=this.m_xDocPrint.DocumentElement.SelectSingleNode(string.Format("./report[@name='tb{0}']",iDex.ToString()));
DataGridTableStyle dgts=new DataGridTableStyle();
DataTable dt=new DataTable();
for(int i=0;i<xNode.ChildNodes.Count;i++)
{
string strField=xNode.ChildNodes[i].Attributes.GetNamedItem("field").Value.Trim();
string strHeader=xNode.ChildNodes[i].Attributes.GetNamedItem("text").Value.Trim();
string strWidth=xNode.ChildNodes[i].Attributes.GetNamedItem("width").Value.Trim();
dt.Columns.Add(strField);
DataGridColoredTextBoxColumn dgtc=new DataGridColoredTextBoxColumn();
dgtc.Width=int.Parse(strWidth);
dgtc.HeaderText=strHeader;
dgtc.MappingName=strField;
dgts.GridColumnStyles.Add(dgtc);
}
this.dgPrint.TableStyles.Clear();
this.dgPrint.TableStyles.Add(dgts);
this.dgPrint.DataSource=dt;
for(int i=0;i<this.dgPrint.TableStyles[0].GridColumnStyles.Count;i++)
{
this.dgPrint.TableStyles[0].GridColumnStyles[i].HeaderText="text"+i.ToString();
this.dgPrint.TableStyles[0].GridColumnStyles[i].MappingName="field"+i.ToString();
}
for(int i=0;i<this.dataGrid1.TableStyles[0].GridColumnStyles.Count;i++)
{
this.dgPrint.TableStyles[0].GridColumnStyles[i].MappingName=this.dataGrid1.TableStyles[0].GridColumnStyles[i].MappingName;
this.dgPrint.TableStyles[0].GridColumnStyles[i].HeaderText=this.dataGrid1.TableStyles[0].GridColumnStyles[i].HeaderText;
}
DataTable dtPrint=(DataTable)this.dgPrint.DataSource;
DataTable dtDetail=(DataTable)this.dataGrid1.DataSource;
for(int i=0;i<dtDetail.Rows.Count;i++)
{
dtPrint.ImportRow(dtDetail.Rows[i]);
}
this.clearBlankRow(dtPrint);
string strTitle=this.dataGrid1.CaptionText.Trim();
if(strTitle.Trim()!="")
{
int iStart=strTitle.LastIndexOf(" ");
string strTitleEx=strTitle.Substring(iStart);
strTitle=strTitle.Substring(0,iStart);
cutePrint.cutePrinter dgp=new cutePrint.cutePrinter(this.dgPrint,strTitleEx.Trim(),30);
int iTimeMinus=int.Parse(xNode.Attributes.GetNamedItem("iTimeMinus").Value.Trim());
dgp.iTimeMinus=iTimeMinus;
dgp.leftMargin=int.Parse(xNode.Attributes.GetNamedItem("leftMargin").Value.Trim());
dgp.strTitle=strTitle.Trim();
dgp.Print();
}
else
{
cutePrint.cutePrinter dgp=new cutePrint.cutePrinter(this.dgPrint,xNode.Attributes.GetNamedItem("title").Value.Trim(),30);
int iTimeMinus=int.Parse(xNode.Attributes.GetNamedItem("iTimeMinus").Value.Trim());
dgp.iTimeMinus=iTimeMinus;
dgp.leftMargin=int.Parse(xNode.Attributes.GetNamedItem("leftMargin").Value.Trim());
dgp.strTitle=" ";
dgp.Print();
}
}
catch(Exception ex)
{
cSaveErr.CSaveErr.msgboxErr(ex.ToString());
}
}
private void iniGrid(string strXFileName,System.Windows.Forms.DataGrid dg,string strRepName)
{
try
{
XmlDocument xDoc=new XmlDocument();
xDoc.Load(strXFileName);
//5���¹�ˮվͳ��
XmlNode xNodeRep=xDoc.DocumentElement.SelectSingleNode(string.Format("./report[@name='{0}']",strRepName));
DataGridTableStyle dgts=new DataGridTableStyle();
DataTable dtE=new DataTable();
for(int i=0;i<xNodeRep.ChildNodes.Count;i++)
{
DataGridColoredTextBoxColumn dgtb;
XmlNode xNodeHeader=xNodeRep.ChildNodes[i];
string strText=xNodeHeader.Attributes.GetNamedItem("text").Value.Trim();
string strField=xNodeHeader.Attributes.GetNamedItem("field").Value.Trim();
string strWidth=xNodeHeader.Attributes.GetNamedItem("width").Value.Trim();
dgtb=new DataGridColoredTextBoxColumn();
dgtb.HeaderText=strText;
dgtb.MappingName=strField;
dtE.Columns.Add(strField);
int iWidth=int.Parse(strWidth);
dgtb.Width=iWidth;
dgts.GridColumnStyles.Add(dgtb);
}
dg.TableStyles.Clear();
dg.TableStyles.Add(dgts);
dg.DataSource=dtE;
//dg.CaptionText=xNodeRep.Attributes.GetNamedItem("Title").Value.Trim();
dg.ReadOnly=true;
}
catch(Exception ex)
{
cSaveErr.CSaveErr.msgboxErr(ex.ToString());
}
}
