private void DgBind()
{
string strAssType = cmbAssType.Text.Trim();
if (strAssType == "全部")
{
strAssType = "";
}
else
{
strAssType = this.GetColEn(strAssType, "AT");
}
string strGoodsType = cmbGoodsType.Text.Trim();
if (strGoodsType == "全部")
{
strGoodsType = "";
}
else
{
strGoodsType = this.GetColEn(strGoodsType, "GT");
}
string strBegin = dtpBegin.Value.ToShortDateString() + " 00:00:00";
string strEnd = dtpEnd.Value.ToShortDateString() + " 23:59:59";
string strDeptID = this.cmbDept.Text.Trim();
if (strDeptID == "全部")
{
strDeptID = "";
}
else
{
strDeptID = this.GetColEn(strDeptID, "MD");
}
Hashtable htPara = new Hashtable();
htPara.Add("strAssType", strAssType);
htPara.Add("strGoodsType", strGoodsType);
htPara.Add("strBegin", strBegin);
htPara.Add("strEnd", strEnd);
htPara.Add("strDeptID", strDeptID);
Exception err = null;
DataTable dt = new DataTable();
string strType1 = "";
if (checkBox1.Checked == true && checkBox2.Checked == true && checkBox3.Checked == true)
{
//dt=cs.GetConsItemQuery(htPara,out err);
//strType1="0";
return;
}
if (checkBox1.Checked == true && checkBox2.Checked == false && checkBox3.Checked == false)
{
dt = cs.GetConsItemQuery1(htPara, out err);
strType1 = "1";
}
if (checkBox1.Checked == false && checkBox2.Checked == true && checkBox3.Checked == false)
{
dt = cs.GetConsItemQuery2(htPara, out err);
strType1 = "2";
}
if (checkBox1.Checked == false && checkBox2.Checked == false && checkBox3.Checked == true)
{
dt = cs.GetConsItemQuery3(htPara, out err);
strType1 = "3";
}
if (checkBox1.Checked == false && checkBox2.Checked == true && checkBox3.Checked == true)
{
dt = cs.GetConsItemQuery4(htPara, out err);
strType1 = "4";
}
if (checkBox1.Checked == true && checkBox2.Checked == true && checkBox3.Checked == false)
{
dt = cs.GetConsItemQuery5(htPara, out err);
strType1 = "5";
}
if (checkBox1.Checked == true && checkBox2.Checked == false && checkBox3.Checked == true)
{
dt = cs.GetConsItemQuery6(htPara, out err);
strType1 = "6";
}
if (checkBox1.Checked == false && checkBox2.Checked == false && checkBox3.Checked == false)
{
//dt=cs.GetConsItemQuery(htPara,out err);
//strType1="0";
return;
}
if (dt != null && dt.Rows.Count >= 0)
{
int iCount = 0;
double dFee = 0;
double dRate = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
iCount += int.Parse(dt.Rows[i]["tolcount"].ToString());
dFee += double.Parse(dt.Rows[i]["tolfee"].ToString());
dRate += double.Parse(dt.Rows[i]["tolrate"].ToString());
}
txtCount.Text = iCount.ToString();
txtFee.Text = Math.Round(dFee, 2).ToString();
txtTolRate.Text = Math.Round(dRate, 2).ToString();
this.dataGrid1.CaptionText = "会员消费分类统计报表";
this.dataGrid1.SetDataBinding(dt, "");
if (strType1 == "0")
{
this.DataTableConvert(dt, "vcAssType", "AT", "vcCommCode", "vcCommName");
this.DataTableConvert(dt, "vcDeptID", "MD", "vcCommCode", "vcCommName");
this.EnToCh("门店,会员类型,商品类型,商品名称,数量合计,金额合计,折扣合计", "100,100,100,100,100,100", dt, this.dataGrid1);
}
if (strType1 == "1")
{
this.DataTableConvert(dt, "vcDeptID", "MD", "vcCommCode", "vcCommName");
this.EnToCh("门店,商品名称,数量合计,金额合计,折扣合计", "100,100,100,100", dt, this.dataGrid1);
}
if (strType1 == "2")
{
this.DataTableConvert(dt, "vcAssType", "AT", "vcCommCode", "vcCommName");
this.EnToCh("会员类型,商品类型,数量合计,金额合计,折扣合计", "100,100,100,100", dt, this.dataGrid1);
}
if (strType1 == "3")
{
this.EnToCh("商品类型,商品名称,数量合计,金额合计,折扣合计", "100,100,100,100", dt, this.dataGrid1);
}
if (strType1 == "4")
{
this.DataTableConvert(dt, "vcAssType", "AT", "vcCommCode", "vcCommName");
this.EnToCh("会员类型,商品类型,商品名称,数量合计,金额合计,折扣合计", "100,100,100,100,100", dt, this.dataGrid1);
}
if (strType1 == "5")
{
this.DataTableConvert(dt, "vcDeptID", "MD", "vcCommCode", "vcCommName");
this.DataTableConvert(dt, "vcAssType", "AT", "vcCommCode", "vcCommName");
this.EnToCh("门店,会员类型,商品名称,数量合计,金额合计,折扣合计", "100,100,100,100,100", dt, this.dataGrid1);
}
if (strType1 == "6")
{
this.DataTableConvert(dt, "vcDeptID", "MD", "vcCommCode", "vcCommName");
this.EnToCh("门店,商品类型,商品名称,数量合计,金额合计,折扣合计", "100,100,100,100,100", dt, this.dataGrid1);
}
if (dt.Rows.Count > 0)
{
this.sbtnExcel.Enabled = true;
}
else
{
this.sbtnExcel.Enabled = false;
}
}
else
{
MessageBox.Show("查询出错，请重试！", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
if (err != null)
{
clog.WriteLine(err);
}
}
}
