/// <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"; } }