/// <summary>
/// 点击确定按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
string newAmount = txtNewAmount.Text;
string commAmount = txtCommAmount.Text;
string tradeAmount = txtTradedAmount.Text;
string tradeMoney = txtTradedMoney.Text;
if (newAmount == "" || commAmount == "" || tradeAmount == "" || tradeMoney == "")
{
MLMGC.COMP.Jscript.ShowMsg("请认真填写以上内容", this);
return;
}
E_Standard data = new E_Standard();
data.EnterpriseID = EnterpriceID;
data.NewAmount = Convert.ToInt32(newAmount);
data.CommAmount = Convert.ToInt32(commAmount);
data.TradedAmount = Convert.ToInt32(tradeAmount);
data.TradedMoney = Convert.ToSingle(tradeMoney);
bool flag = new T_Standard().Update(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "最低标准设置", IP = MLMGC.COMP.Requests.GetRealIP()
});
if (flag)
{
MLMGC.COMP.Jscript.ShowMsg("操作成功", this);
}
else
{
MLMGC.COMP.Jscript.ShowMsg("操作失败", this);
}
}
protected void databind()
{
E_Standard data = new E_Standard();
data.EnterpriseID = EnterpriceID;
data = new T_Standard().GetModel(data);
if (data == null)
{
return;
}
txtNewAmount.Text = data.NewAmount.ToString();
txtCommAmount.Text = data.CommAmount.ToString();
txtTradedAmount.Text = data.TradedAmount.ToString();
txtTradedMoney.Text = data.TradedMoney.ToString("f2");
}
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";
}
}
protected void databind()
{
DateTime dtTime;
if (!DateTime.TryParse(txtDate.Text, out dtTime))
{
MLMGC.COMP.Jscript.ShowMsg("日期错误", this);
return;
}
if (dtTime > DateTime.Now)
{
MLMGC.COMP.Jscript.ShowMsg("不能超过今天", this);
return;
}
phNoPlan.Visible = false;
//获取指定月计划
T_UserPlan bll = new T_UserPlan();
E_UserPlan data = new E_UserPlan()
{
EnterpriseID = EnterpriceID,
EPUserTMRID = EPUserTMRID,
YearMonty = dtTime
};
E_UserPlan dataPlan = bll.GetModel(data);
//获取最低指标
E_Standard dataStandard = new T_Standard().GetModel(new E_Standard()
{
EnterpriseID = EnterpriceID
});
//获取当天数据
DataTable dt = bll.UserDaily(data);
int realNewAmount = 0, realExchAmount = 0;
if (dt != null && dt.Rows.Count == 1)
{
realNewAmount = int.Parse(dt.Rows[0]["NewAmount"].ToString());
realExchAmount = int.Parse(dt.Rows[0]["ExchangeAmount"].ToString());
}
ltRealNew.Text = realNewAmount.ToString();
ltRealExchange.Text = realExchAmount.ToString();
//---------设置显示月计划及百分比
if (dataPlan != null)//是否制定该用计划
{
//实际数据
ltPlanNew.Text = dataPlan.NewAmount.ToString();
ltPlanExchange.Text = dataPlan.ContactAmount.ToString();
//百分比数据
ltPercentNew.Text = GetPercent(realNewAmount, data.NewAmount);
ltPercentExchange.Text = GetPercent(realExchAmount, data.ContactAmount);
}
else
{
//计划数量
phNoPlan.Visible = true;
ltPlanNew.Text = "0";
ltPlanExchange.Text = "0";
//百分比
ltPercentNew.Text = "0";
ltPercentExchange.Text = "0";
}
//---------最低指标
if (dataStandard != null)//领导是否调制最低指标
{
//指标
ltStandardNew.Text = dataStandard.NewAmount.ToString();
ltStandardExchange.Text = dataStandard.CommAmount.ToString();
//差值
int num = dataStandard.NewAmount - realNewAmount;
ltDifferNew.Text = (num > 0?"-":"+") + Math.Abs(num).ToString();
num = dataStandard.CommAmount - realExchAmount;
ltDifferExchange.Text = (num > 0 ? "-" : "+") + Math.Abs(num).ToString();
}
else
{
//指标
ltStandardNew.Text = "0";
ltStandardExchange.Text = "0";
//差值
ltDifferNew.Text = "0";
ltDifferExchange.Text = "0";
}
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind(DateTime yearmonth)
{
E_UserPlan data = new E_UserPlan();
data.EnterpriseID = EnterpriceID;
data.EPUserTMRID = EPUserTMRID;
data.YearMonty = yearmonth;
//获取该月的天数
int dayNum = DateTime.DaysInMonth(yearmonth.Year, yearmonth.Month);
DataTable dt = new T_UserPlan().UserMonthDetail(data);
int planNew = 0, realNew = 0, planContact = 0, realContact = 0, planTrade = 0, realTrade = 0;
float planMoney = 0f, realMoney = 0f;
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
planNew = Convert.ToInt32(row["NewAmount"]);
ltPlanNew.Text = (planNew * dayNum).ToString();
planContact = Convert.ToInt32(row["ContactAmount"]);
ltPlanContact.Text = (planContact * dayNum).ToString();
planTrade = Convert.ToInt32(row["TradedAmount"]);
ltPlanTrade.Text = planTrade.ToString();
planMoney = Convert.ToSingle(row["TradedMoney"]);
ltPlanMoney.Text = planMoney.ToString("f2");
realNew = Convert.ToInt32(row["RealNewAmount"]);
ltRealNew.Text = realNew.ToString();
realContact = Convert.ToInt32(row["RealExchAmount"]);
ltRealContact.Text = realContact.ToString();
realTrade = Convert.ToInt32(row["RealTradedAmount"]);
ltRealTrade.Text = realTrade.ToString();
realMoney = Convert.ToSingle(row["RealTradedMoney"]);
ltRealMoney.Text = realMoney.ToString("f2");
//---------设置显示月计划及百分比
ltPercentNew.Text = GetPercent(realNew, planNew * dayNum);
ltPercentContact.Text = GetPercent(realContact, planContact * dayNum);
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.ToString();
ltStandardContact.Text = dataStandard.CommAmount.ToString();
ltStandardTrade.Text = dataStandard.TradedAmount.ToString();
ltStandardMoney.Text = dataStandard.TradedMoney.ToString("f2");
//差值
int num = dataStandard.NewAmount - realNew;
ltDifferNew.Text = (num > 0 ? "-" : "+") + Math.Abs(num).ToString();
num = dataStandard.CommAmount - realContact;
ltDifferContact.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";
ltStandardContact.Text = "0";
ltStandardTrade.Text = "0";
ltStandardMoney.Text = "0.00";
//差值
ltDifferNew.Text = "0";
ltDifferContact.Text = "0";
ltDifferTrade.Text = "0";
ltDifferMoney.Text = "0.00";
}
}
