protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strOldDeptName = ((Label)this.GridView1.Rows[e.RowIndex].Cells[9].Controls[1]).Text;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
try
{
bool success = busiq.DeleteDeptInfo(strOldDeptName);
if (!success)
{
this.SetErrorMsgPageBydir("门店信息删除出错，请重试！");
return;
}
else
{
this.Query();
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("门店信息删除错误，请重试！");
return;
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strSerial = this.GridView1.Rows[e.RowIndex].Cells[0].Text;
string strDeptId = this.GridView1.Rows[e.RowIndex].Cells[11].Text;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
try
{
bool success = busiq.DeleteConsItemUndo(strSerial, strDeptId);
if (!success)
{
this.SetErrorMsgPageBydir("取消撤销出错，请重试！");
return;
}
else
{
this.btQuery_Click(null, null);
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("取消撤销错误，请重试！");
return;
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string month = GridView1.Rows[e.RowIndex].Cells[2].Text;
string deptId = GridView1.Rows[e.RowIndex].Cells[3].Text;
string strAmount = (GridView1.Rows[e.RowIndex].Cells[5].Controls[0] as TextBox).Text;
if (string.IsNullOrEmpty(strAmount))
{
this.Popup("请输入指标");
return;
}
if (!this.JudgeIsNum(strAmount))
{
this.Popup("指标请输入数字");
return;
}
decimal amount = Convert.ToDecimal(strAmount);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
if (!busiq.UpdateKPI(month, deptId, amount))
{
this.Popup("编辑指标失败，请重试！");
}
else
{
GridView1.EditIndex = -1;
Button1_Click(null, null);
}
}
private void Query()
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
try
{
DataTable dtout = busiq.DeptInfoQuery();
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
this.GridView1.DataSource = dtout;
this.GridView1.DataBind();
Session["DeptInfo"] = dtout;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strSerial = this.GridView1.Rows[e.RowIndex].Cells[0].Text;
string strDeptId = this.GridView1.Rows[e.RowIndex].Cells[11].Text;
string strFlag = this.GridView1.Rows[e.RowIndex].Cells[8].Text;
if (strFlag != "正常消费")
{
this.Popup("撤销已审核");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
try
{
busiq.CheckConsItemUndo(strSerial, strDeptId, ls1.strLoginID);
this.btQuery_Click(null, null);
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("审核出错，请重试！");
return;
}
}
private void DBBind()
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
BusiComm.BusiQuery bq = new BusiComm.BusiQuery(strcons);
DataTable dt = bq.GetExpInvList();
Session["ExpInvList"] = dt;
this.DataGrid1.DataSource = dt;
this.DataGrid1.PageSize = 10;
this.DataGrid1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
//查询
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable dtout = busiq.GetKPIOfMonth(ddlMonth.SelectedValue, ddlDeptId.SelectedValue);
this.DataTableConvert(dtout, "vcDeptId", "tbCommCode", "vcCommSign='MD'");
this.GridView1.DataSource = dtout;
this.GridView1.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string strDeptName = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[0].Controls[1]).Text;
string strAddress = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[1]).Text;
string strTel = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[1]).Text;
string strManager = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[1]).Text;
string strManagerPhone = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[4].Controls[1]).Text;
string strAdsl = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[5].Controls[1]).Text;
string strAdslPwd = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[6].Controls[1]).Text;
string strVpn = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[7].Controls[1]).Text;
string strVpnPwd = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[8].Controls[1]).Text;
string strOldDeptName = ((Label)this.GridView1.Rows[e.RowIndex].Cells[9].Controls[1]).Text;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
try
{
bool exist = busiq.ExistDeptInfo(strDeptName);
if (strDeptName != strOldDeptName && exist)
{
this.Popup("门店已存在");
return;
}
bool success = busiq.UpdateDeptInfo(strOldDeptName, strDeptName, strAddress, strTel, strManager, strManagerPhone, strAdsl, strAdslPwd, strVpn, strVpnPwd);
if (!success)
{
this.SetErrorMsgPageBydir("门店信息修改出错，请重试！");
return;
}
else
{
this.GridView1.EditIndex = -1;
this.Query();
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("门店信息修改错误，请重试！");
return;
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(ddlMonth.SelectedValue))
{
this.Popup("请选择月份");
return;
}
if (string.IsNullOrEmpty(ddlDeptId.SelectedValue))
{
this.Popup("请选择门店");
return;
}
if (string.IsNullOrEmpty(txtAmount.Text))
{
this.Popup("请输入指标");
return;
}
if (!this.JudgeIsNum(txtAmount.Text))
{
this.Popup("指标请输入数字");
return;
}
//添加
string month = ddlMonth.SelectedValue;
string deptId = ddlDeptId.SelectedValue;
decimal amount = Convert.ToDecimal(txtAmount.Text);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
if (busiq.ExistKPI(month, deptId))
{
this.Popup("指标已存在，请重新选择！");
return;
}
if (!busiq.InsertKPI(month, deptId, amount))
{
this.Popup("添加指标失败，请重试！");
}
else
{
Button1_Click(null, null);
}
}
protected void btQuery_Click(object sender, EventArgs e)
{
if (this.txtBegin.Text == "" || this.txtEnd.Text == "")
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
string strBeginDate = Convert.ToDateTime(this.txtBegin.Text).ToString("yyyy-MM-dd");
string strEndDate = Convert.ToDateTime(this.txtEnd.Text).AddDays(1).ToString("yyyy-MM-dd");
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
string strSerial = txtSerial.Text.Trim();
string strOperName = ddlOper.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
string strIsUndo = this.DropDownList1.SelectedValue;
try
{
DataTable dtout = busiq.ConsItemUndoQuery(strSerial, strBeginDate, strEndDate, strOperName, strDeptID, strIsUndo, "0");
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
this.GridView1.DataSource = dtout;
this.GridView1.DataBind();
Session["ConsItemUndo"] = dtout;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string strSerial = this.GridView1.Rows[e.RowIndex].Cells[0].Text;
string strDeptId = this.GridView1.Rows[e.RowIndex].Cells[11].Text;
string strFlag = this.GridView1.Rows[e.RowIndex].Cells[8].Text;
if (strFlag != "正常消费")
{
this.Popup("撤销已审核");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
try
{
bool exist = busiq.ExistConsItemUndo(strSerial, strDeptId);
if (exist)
{
this.Popup("已撤销");
return;
}
bool success = busiq.InsertConsItemUndo(strSerial, ls1.strOperName, strDeptId);
if (!success)
{
this.SetErrorMsgPageBydir("零售撤销出错，请重试！");
return;
}
else
{
this.GridView1.EditIndex = -1;
this.btQuery_Click(null, null);
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("零售撤销错误，请重试！");
return;
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string month = GridView1.Rows[e.RowIndex].Cells[2].Text;
string deptId = GridView1.Rows[e.RowIndex].Cells[3].Text;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
if (!busiq.DeleteKPI(month, deptId))
{
this.Popup("删除指标失败，请重试！");
}
else
{
Button1_Click(null, null);
}
}
private void GetKPI(bool IsUpdate)
{
//查询数据
if (string.IsNullOrEmpty(txtDate.Text))
{
this.Popup("请输入日期");
return;
}
DateTime dtDate = DateTime.Parse(txtDate.Text);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataSet ds = busiq.GetKPI(dtDate, txtWeather.Text, txtException.Text, IsUpdate);
lblWeek.Text = "......";
txtWeather.Text = "";
txtException.Text = "";
lblMonthAmount.Text = "......";
lblLastYearMonthAmount.Text = "......";
lblAmount.Text = "......";
lblLastYearDateAmount.Text = "......";
lblDifLastYearDateAmount.Text = "......";
lblSum.Text = "......";
lblRatio.Text = "......";
lblMonthRatio.Text = "......";
lblQuantity.Text = "......";
lblPrice.Text = "......";
//去年同月业绩
if (ds.Tables.Contains("LastYearKPIOfDept"))
{
DataTable dt1 = ds.Tables["LastYearKPIOfDept"];
object obj = dt1.Compute("Sum([Sum])", "");
if (obj != null)
{
lblLastYearMonthAmount.Text = obj.ToString();
}
}
//去年同一天
decimal lastYearDateAmount = 0;
if (ds.Tables.Contains("LastYearDateKPIOfDept"))
{
DataTable dt3 = ds.Tables["LastYearDateKPIOfDept"];
object obj = dt3.Compute("Sum([Amount])", "");
if (obj != null)
{
string strLastYearDateAmount = obj.ToString();
lastYearDateAmount = Convert.ToDecimal(strLastYearDateAmount);
lblLastYearDateAmount.Text = strLastYearDateAmount;
}
}
//业绩
decimal amount = 0;
decimal sum = 0;
if (ds.Tables.Contains("KPIOfDay"))
{
DataTable dt4 = ds.Tables["KPIOfDay"];
DataRow dr = dt4.Rows[0];
string strAmount = dr["Amount"].ToString();
if (!string.IsNullOrEmpty(strAmount))
{
lblAmount.Text = strAmount;
amount = Convert.ToDecimal(strAmount);
}
string strSum = dr["Sum"].ToString();
if (!string.IsNullOrEmpty(strSum))
{
sum = Convert.ToDecimal(strSum);
lblSum.Text = strSum;
}
lblDifLastYearDateAmount.Text = (amount - lastYearDateAmount).ToString();
lblQuantity.Text = dr["Quantity"].ToString();
lblPrice.Text = dr["Price"].ToString();
txtException.Text = dr["Exception"].ToString();
txtWeather.Text = dr["Weather"].ToString();
string strWeek = dr["Week"].ToString();
if (!string.IsNullOrEmpty(strWeek))
{
int iWeek = Convert.ToInt32(strWeek);
switch (iWeek)
{
case 0:
lblWeek.Text = "日";
break;
case 1:
lblWeek.Text = "一";
break;
case 2:
lblWeek.Text = "二";
break;
case 3:
lblWeek.Text = "三";
break;
case 4:
lblWeek.Text = "四";
break;
case 5:
lblWeek.Text = "五";
break;
case 6:
lblWeek.Text = "六";
break;
}
}
}
//门店业绩
if (ds.Tables.Contains("KPIOfDept"))
{
DataTable dt2 = ds.Tables["KPIOfDept"];
//指标
decimal kpi = 0;
if (ds.Tables.Contains("KPIOfMonth"))
{
DataTable dt6 = ds.Tables["KPIOfMonth"];
//object obj = dt6.Compute("Sum([Amount])", "");
//if (obj != null)
//{
// string strKpi = obj.ToString();
// lblMonthAmount.Text = strKpi;
// kpi = Convert.ToDecimal(strKpi);
// lblRatio.Text = (Math.Round(sum / (kpi == 0 ? 1 : kpi),2) * 100).ToString() + "%";
// lblMonthRatio.Text = (Math.Round(sum / dtDate.Day * DateTime.DaysInMonth(dtDate.Year, dtDate.Month) / (kpi == 0 ? 1 : kpi), 2) * 100).ToString() + "%";
//}
this.DataTableConvert(dt2, "vcDeptId", "tbCommCode", "vcCommSign ='MD'");
lKPIOfDept = new List <KPIOfDept>();
int serial = 0;
decimal deptKpiSum = 0;
decimal deptAmountSum = 0;
decimal deptSumSum = 0;
foreach (DataRow dr in dt2.Rows)
{
KPIOfDept dept = new KPIOfDept();
serial += 1;
dept.Serial = serial.ToString();
dept.vcDeptName = dr["vcDeptIdComments"].ToString();
string strDeptId = dr["vcDeptId"].ToString();
DataRow[] drs = dt6.Select("vcDeptId='" + strDeptId + "'");
if (drs.Length > 0)
{
dept.Kpi = drs[0]["Amount"].ToString();
}
dept.Amount = dr["Amount"].ToString();
dept.Sum = dr["Sum"].ToString();
decimal deptkpi = 0;
decimal deptSum = 0;
decimal deptAmount = 0;
if (!string.IsNullOrEmpty(dept.Kpi))
{
deptkpi = Convert.ToDecimal(dept.Kpi);
deptKpiSum += deptkpi;
}
if (!string.IsNullOrEmpty(dept.Sum))
{
deptSum = Convert.ToDecimal(dept.Sum);
deptSumSum += deptSum;
}
if (!string.IsNullOrEmpty(dept.Amount))
{
deptAmount = Convert.ToDecimal(dept.Amount);
deptAmountSum += deptAmount;
}
dept.Ratio = (Math.Round(deptSum / (deptkpi == 0 ? 1 : deptkpi), 2) * 100).ToString() + "%";
dept.MonthRatio = (Math.Round(deptSum / dtDate.Day * DateTime.DaysInMonth(dtDate.Year, dtDate.Month) / (deptkpi == 0 ? 1 : deptkpi), 2) * 100).ToString() + "%";
lKPIOfDept.Add(dept);
}
KPIOfDept deptTotal = new KPIOfDept();
deptTotal.Serial = "合计";
deptTotal.Kpi = deptKpiSum.ToString();
deptTotal.Amount = deptAmountSum.ToString();
deptTotal.Sum = deptSumSum.ToString();
deptTotal.Ratio = (Math.Round(deptSumSum / (deptKpiSum == 0 ? 1 : deptKpiSum), 2) * 100).ToString() + "%";
deptTotal.MonthRatio = (Math.Round(deptSumSum / dtDate.Day * DateTime.DaysInMonth(dtDate.Year, dtDate.Month) / (deptKpiSum == 0 ? 1 : deptKpiSum), 2) * 100).ToString() + "%";
lKPIOfDept.Add(deptTotal);
lblMonthAmount.Text = deptTotal.Kpi;
lblRatio.Text = deptTotal.Ratio;
lblMonthRatio.Text = deptTotal.MonthRatio;
}
}
//新品及重点产品业绩
if (ds.Tables.Contains("KPIOfGoods"))
{
DataTable dt5 = ds.Tables["KPIOfGoods"];
if (ds.Tables.Contains("tbGoods"))
{
DataTable dt8 = ds.Tables["tbGoods"];
int inew = 0;
int ikey = 0;
lKPIOfGoods = new List <KPIOfGoods>();
foreach (DataRow dr in dt8.Rows)
{
KPIOfGoods goods = new KPIOfGoods();
string strNew = dr["IsNew"].ToString();
bool bNew = false;
if (!string.IsNullOrEmpty(strNew))
{
bNew = Convert.ToBoolean(strNew);
}
string strKey = dr["IsKey"].ToString();
bool bKey = false;
if (!string.IsNullOrEmpty(strKey))
{
bKey = Convert.ToBoolean(strKey);
}
if (bNew)
{
inew += 1;
goods.Desc = "新品名称" + inew.ToString();
}
if (bKey)
{
ikey += 1;
goods.Desc = "重点产品" + ikey.ToString();
}
goods.vcGoodsName = dr["vcGoodsName"].ToString();
string strNewDate = dr["NewDate"].ToString();
if (!string.IsNullOrEmpty(strNewDate))
{
goods.NewDate = DateTime.Parse(strNewDate).ToString("yyyy-MM-dd");
}
goods.Unit = dr["Unit"].ToString();
string strGoodsId = dr["vcGoodsId"].ToString();
DataRow[] drs = dt5.Select("vcGoodsId='" + strGoodsId + "'");
if (drs.Length > 0)
{
goods.Quantity = drs[0]["Quantity"].ToString();
goods.Amount = drs[0]["Amount"].ToString();
}
lKPIOfGoods.Add(goods);
}
}
}
//前一天
if (ds.Tables.Contains("BeforeDateKPIOfDept"))
{
DataTable dt7 = ds.Tables["BeforeDateKPIOfDept"];
object obj = dt7.Compute("Sum([Amount])", "");
if (obj != null)
{
string strLastDateAmount = obj.ToString();
decimal lastDateAmount = Convert.ToDecimal(strLastDateAmount);
lblDifLastDateAmount.Text = (amount - lastDateAmount).ToString();
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strDeptName = "";
string strAddress = "";
string strTel = "";
string strManager = "";
string strManagerPhone = "";
string strAdsl = "";
string strAdslPwd = "";
string strVpn = "";
string strVpnPwd = "";
if (e.CommandName == "EmptyInsert")
{
strDeptName = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtDeptName")).Text;
strAddress = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtAddress")).Text;
strTel = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtTel")).Text;
strManager = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtManager")).Text;
strManagerPhone = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtManagerPhone")).Text;
strAdsl = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtAdsl")).Text;
strAdslPwd = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtAdslPwd")).Text;
strVpn = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtVpn")).Text;
strVpnPwd = ((TextBox)GridView1.Controls[0].Controls[0].Controls[0].FindControl("txtVpnPwd")).Text;
}
else if (e.CommandName == "Insert")
{
strDeptName = ((TextBox)GridView1.FooterRow.Cells[0].Controls[1]).Text;
strAddress = ((TextBox)GridView1.FooterRow.Cells[1].Controls[1]).Text;
strTel = ((TextBox)GridView1.FooterRow.Cells[2].Controls[1]).Text;
strManager = ((TextBox)GridView1.FooterRow.Cells[3].Controls[1]).Text;
strManagerPhone = ((TextBox)GridView1.FooterRow.Cells[4].Controls[1]).Text;
strAdsl = ((TextBox)GridView1.FooterRow.Cells[5].Controls[1]).Text;
strAdslPwd = ((TextBox)GridView1.FooterRow.Cells[6].Controls[1]).Text;
strVpn = ((TextBox)GridView1.FooterRow.Cells[7].Controls[1]).Text;
strVpnPwd = ((TextBox)GridView1.FooterRow.Cells[8].Controls[1]).Text;
}
else
{
return;
}
if (string.IsNullOrEmpty(strDeptName))
{
this.Popup("门店不能为空");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
try
{
bool exist = busiq.ExistDeptInfo(strDeptName);
if (exist)
{
this.Popup("门店已存在");
return;
}
bool success = busiq.InsertDeptInfo(strDeptName, strAddress, strTel, strManager, strManagerPhone, strAdsl, strAdslPwd, strVpn, strVpnPwd);
if (!success)
{
this.SetErrorMsgPageBydir("门店信息添加出错，请重试！");
return;
}
else
{
this.GridView1.EditIndex = -1;
this.Query();
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("门店信息添加错误，请重试！");
return;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
//查询
Session.Remove("QUERY");
Session.Remove("toExcel");
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable tbCommCode = (DataTable)Application["tbCommCode"];
DataRow[] drs = tbCommCode.Select("vcCommSign ='GT'");
string strGoodsType = "[累计业绩],";
foreach (DataRow dr in drs)
{
strGoodsType += "[" + dr["vcCommName"].ToString() + "],[" + dr["vcCommName"].ToString() + "占比],";
}
strGoodsType = strGoodsType.TrimEnd(',');
DataTable dtout = busiq.GetSaleRatio(ddlMonths.SelectedValue, strGoodsType);
foreach (DataRow dr in dtout.Rows)
{
decimal sum = 0;
foreach (DataRow dr1 in drs)
{
string value = dr[dr1["vcCommName"].ToString()].ToString();
if (!string.IsNullOrEmpty(value))
{
sum += decimal.Parse(value);
}
}
dr["累计业绩"] = sum;
if (sum > 0)
{
foreach (DataRow dr1 in drs)
{
string value = dr[dr1["vcCommName"].ToString()].ToString();
if (!string.IsNullOrEmpty(value))
{
dr[dr1["vcCommName"].ToString() + "占比"] = Math.Round(decimal.Parse(value) / sum * 100, 2);
}
}
}
}
dtout.TableName = "月份各类产品销售占比表";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
Session["toExcel"] = dtexcel;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (dtout.Rows.Count <= 0)
{
Button2.Enabled = false;
}
else
{
if (ls1.strLimit == "CL001")
{
Button2.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception ex)
{
this.clog.WriteLine(ex);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
