private void DgBind()
{
string strBegin = dtpBegin.Value.Year.ToString();
if (dtpBegin.Value.Month < 10)
{
strBegin += "0" + dtpBegin.Value.Month.ToString();
}
else
{
strBegin += dtpBegin.Value.Month.ToString();
}
if (dtpBegin.Value.Day < 10)
{
strBegin += "0" + dtpBegin.Value.Day.ToString();
}
else
{
strBegin += dtpBegin.Value.Day.ToString();
}
string strEnd = dtpEnd.Value.Year.ToString();
if (dtpEnd.Value.Month < 10)
{
strEnd += "0" + dtpEnd.Value.Month.ToString();
}
else
{
strEnd += dtpEnd.Value.Month.ToString();
}
if (dtpEnd.Value.Day < 10)
{
strEnd += "0" + dtpEnd.Value.Day.ToString();
}
else
{
strEnd += dtpEnd.Value.Day.ToString();
}
this.label1.Text = strBegin + strEnd;
string strDeptID = this.cmbDept.Text.Trim();
this.label2.Text = strDeptID;
if (strDeptID == "全部")
{
strDeptID = "%%";
}
else
{
strDeptID = this.GetColEn(strDeptID, "MD");
}
Exception err = null;
DataTable dt = new DataTable();
dt = ca.BusiIncomeReport(strDeptID, strBegin, strEnd, out err);
if (dt != null && dt.Rows.Count >= 0)
{
this.dgStyle();
if (strDeptID == "%%")
{
this.dataGrid1.CaptionText = SysInitial.CP + "业务量报表--所有门店";
}
else
{
this.dataGrid1.CaptionText = SysInitial.CP + "业务量报表--" + this.cmbDept.Text.Trim();
}
DataTable dtnew = this.ReportConvert(dt);
this.dataGrid1.ColumnHeadersVisible = false;
this.dataGrid1.RowHeadersVisible = false;
this.dataGrid1.SetDataBinding(dtnew, "");
if (dt.Rows.Count > 0)
{
this.sbtnExcel.Enabled = true;
this.sbtnPrint.Enabled = true;
}
else
{
this.sbtnExcel.Enabled = false;
this.sbtnPrint.Enabled = false;
}
}
else
{
MessageBox.Show("业务量报表统计出错，请重试！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
if (err != null)
{
clog.WriteLine(err);
}
}
}
