/// <summary>
/// 获取团队计划数据列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-11</remarks>
public DataTable GetTeamPlan(E_TeamPlan data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@EPUserTMRID", SqlDbType.Int),
new SqlParameter("@TeamID", SqlDbType.Int),
new SqlParameter("@Date", SqlDbType.SmallDateTime)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.EPUserTMRID;
parms[2].Value = data.TeamID;
parms[3].Value = data.YearMonty;
return(DbHelperSQL.RunProcedureTable("ProcEP_B_TeamPlanS_PlanDaily", parms));
}
/// <summary>
/// 点击确定按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(lblYearMonth.Text))
{
MLMGC.COMP.Jscript.ShowMsg("请选择年月", this);
return;
}
else if (string.IsNullOrWhiteSpace(txtTradedAmount.Text))
{
MLMGC.COMP.Jscript.ShowMsg("请输入交易数量", this);
return;
}
else if (string.IsNullOrWhiteSpace(txtTradedMoney.Text))
{
MLMGC.COMP.Jscript.ShowMsg("请输入交易金额", this);
return;
}
E_TeamPlan data = new E_TeamPlan();
data.EnterpriseID = EnterpriceID;
data.TeamID = TeamID;
data.YearMonty = Convert.ToDateTime(lblYearMonth.Text);
data.TradedAmount = Convert.ToInt32(txtTradedAmount.Text);
data.TradedMoney = Convert.ToSingle(txtTradedMoney.Text);
bool flag = new T_TeamPlan().Update(data);
if (flag)
{
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "修改团队计划", IP = MLMGC.COMP.Requests.GetRealIP()
});
MLMGC.COMP.Jscript.ShowMsg("操作成功", this);
}
else
{
MLMGC.COMP.Jscript.ShowMsg("操作失败", this);
}
}
/// <summary>
/// 修改或添加团队计划
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-01</remarks>
public bool Update(E_TeamPlan data)
{
int ReturnValue;
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@TeamID", SqlDbType.Int),
new SqlParameter("@YearMonth", SqlDbType.SmallDateTime),
new SqlParameter("@TradedAmount", SqlDbType.Int),
new SqlParameter("@TradedMoney", SqlDbType.Money)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.TeamID;
parms[2].Value = data.YearMonty;
parms[3].Value = data.TradedAmount;
parms[4].Value = data.TradedMoney;
DbHelperSQL.RunProcedures("ProcEP_B_TeamPlan_Update", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 查询团队计划
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-01</remarks>
public E_TeamPlan GetModel(E_TeamPlan data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@TeamID", SqlDbType.Int),
new SqlParameter("@YearMonth", SqlDbType.SmallDateTime)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.TeamID;
parms[2].Value = data.YearMonty;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_TeamPlan_Select", parms);
if (dt != null && dt.Rows.Count == 1)
{
data.TradedAmount = Convert.ToInt32(dt.Rows[0]["TradedAmount"]);
data.TradedMoney = Convert.ToSingle(dt.Rows[0]["TradedMoney"]);
return(data);
}
return(null);
}
protected void databind()
{
DateTime dtNow = DateTime.Now;
ltStartDate.Text = new DateTime(dtNow.Year, dtNow.Month, 1).ToString("yyyy-MM-dd");
ltEndDate.Text = new DateTime(dtNow.Year, dtNow.Month, 1).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
E_TeamPlan data = new E_TeamPlan();
data.EnterpriseID = EnterpriceID;
data.EPUserTMRID = EPUserTMRID;
data.TeamID = TeamID;
data.YearMonty = dtNow;
int planNew = 0, planContact = 0, planTrade = 0, realNew = 0, realContact = 0, realTrade = 0;
float planMoney = 0f, realMoney = 0f;
//获取团队计划
E_TeamPlan dataPlan = new T_TeamPlan().GetModel(data);
//planNew =Convert.ToInt32( row["PlanNew"] ?? 0);
//planContact = Convert.ToInt32(row["PlanContact"] ?? 0);
if (dataPlan != null)
{
planTrade = dataPlan.TradedAmount;
planMoney = dataPlan.TradedMoney;
}
//ltPlanNew.Text = planNew.ToString();
//ltPlanExchange.Text = planContact.ToString();
ltPlanTrade.Text = planTrade.ToString();
ltPlanMoney.Text = planMoney.ToString("f2");
//获取总监下业务个人计划列表
DataTable dtDetail = new T_TeamPlan().GetTeamPlan(data);
rpList.DataSource = dtDetail;
rpList.DataBind();
if (dtDetail != null)
{
foreach (DataRow r in dtDetail.Rows)
{
planNew += Convert.ToInt32(r["NewAmount"] == DBNull.Value ? 0 : r["NewAmount"]);
planContact += Convert.ToInt32(r["ContactAmount"] == DBNull.Value ? 0 : r["ContactAmount"]);
}
planNew = planNew * DateTime.DaysInMonth(dtNow.Year, dtNow.Month);
planContact = planContact * DateTime.DaysInMonth(dtNow.Year, dtNow.Month);
ltPlanNew.Text = planNew.ToString();
ltPlanExchange.Text = planContact.ToString();
}
//获取实际数据
DataTable dt = new T_TeamPlan().GetTeamRealMonth(data);
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
realNew = Convert.ToInt32(row["RealNew"] ?? 0);
realContact = Convert.ToInt32(row["RealContact"] ?? 0);
realTrade = Convert.ToInt32(row["RealTrade"] ?? 0);
realMoney = Convert.ToSingle(row["RealMoney"] == DBNull.Value ? 0f : row["RealMoney"]);
}
ltRealNew.Text = realNew.ToString();
ltRealExchange.Text = realContact.ToString();
ltRealTrade.Text = realTrade.ToString();
ltRealMoney.Text = realMoney.ToString("f2");
//---------设置显示月计划及百分比
ltPercentNew.Text = GetPercent(realNew, planNew);
ltPercentExchange.Text = GetPercent(realContact, planContact);
ltPercentTrade.Text = GetPercent(realTrade, planTrade);
ltPercentMoney.Text = GetPercent(realMoney, planMoney);
//获取最低指标
E_Standard dataStandard = new T_Standard().GetModel(new E_Standard()
{
EnterpriseID = EnterpriceID
});
//---------最低指标
if (dataStandard != null)//领导是否调制最低指标
{
//指标
ltStandardNew.Text = (dataStandard.NewAmount * DateTime.DaysInMonth(dtNow.Year, dtNow.Month)).ToString();
ltStandardExchange.Text = (dataStandard.CommAmount * DateTime.DaysInMonth(dtNow.Year, dtNow.Month)).ToString();
ltStandardTrade.Text = dataStandard.TradedAmount.ToString();
ltStandardMoney.Text = dataStandard.TradedMoney.ToString("f2");
//差值
int num = (dataStandard.NewAmount * DateTime.DaysInMonth(dtNow.Year, dtNow.Month)) - realNew;
ltDifferNew.Text = (num > 0 ? "-" : "+") + Math.Abs(num).ToString();
num = (dataStandard.CommAmount * DateTime.DaysInMonth(dtNow.Year, dtNow.Month)) - realContact;
ltDifferExchange.Text = (num > 0 ? "-" : "+") + Math.Abs(num).ToString();
num = dataStandard.TradedAmount - realTrade;
ltDifferTrade.Text = (num > 0 ? "-" : "+") + Math.Abs(num).ToString();
float money = dataStandard.TradedMoney - realMoney;
ltDifferMoney.Text = (money > 0 ? "-" : "+") + Math.Abs(money).ToString("f2");
}
else
{
//指标
ltStandardNew.Text = "0";
ltStandardExchange.Text = "0";
ltStandardTrade.Text = "0";
ltStandardMoney.Text = "0.00";
//差值
ltDifferNew.Text = "0";
ltDifferExchange.Text = "0";
ltDifferTrade.Text = "0";
ltDifferMoney.Text = "0.00";
}
}
/// <summary>
/// 获取团队某月实际数据
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-11</remarks>
public DataTable GetTeamRealMonth(E_TeamPlan data)
{
return(dal.GetTeamRealMonth(data));
}
/// <summary>
/// 获取团队计划数据列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-11</remarks>
public DataTable GetTeamPlan(E_TeamPlan data)
{
return(dal.GetTeamPlan(data));
}
/// <summary>
/// 查询团队计划
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-01</remarks>
public E_TeamPlan GetModel(E_TeamPlan data)
{
return(dal.GetModel(data));
}
/// <summary>
/// 修改或添加团队计划
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-01</remarks>
public bool Update(E_TeamPlan data)
{
return(dal.Update(data));
}
