lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/InitialSet/WageSet/FrmPhaseCommissionScheme.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.InitialSet.WageSet
{
    public partial class FrmPhaseCommissionScheme : LYFZ.Software.UI.InitialSet.WageSet.FrmPhaseCommissionScheme
    {
        public string Wcs_TypeName;
        public string Wcs_TypeCode;
        public string Wcs_Type;
        public FrmPhaseCommissionScheme()
        {
        }

        #region 加载
        protected override void FrmPhaseCommissionScheme_Load(object sender, EventArgs e)
        {
           
            try
            {
                if (!string.IsNullOrEmpty(Wcs_TypeName))
                {
                    this.Text = "阶梯提成方案-" + Wcs_TypeName;
                    bind();
                }
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }

        }
        public void bind()
        {
            dgv.Rows.Clear();
            LYFZ.BLL.BLL_ErpWageCommissionSet bll = new BLL.BLL_ErpWageCommissionSet();
            DataTable dt = bll.GetList("Wcs_TypeCode='" + Wcs_TypeCode + "'", "ID asc").Tables[0];
            if (dt.Rows.Count > 0)
            {
                Boolean Wcs_PerformanceHight = Convert.ToBoolean(dt.Rows[0]["Wcs_PerformanceHight"]);
                if (Wcs_PerformanceHight == true)
                {
                    chkWcs_PerformanceHight.Checked = true;
                }
                else { chkWcs_PerformanceHight.Checked = false; }
                for (int t = 0; t < dt.Rows.Count; t++)
                {
                    DataGridViewRow dgvr = new DataGridViewRow();
                    DataGridViewCell cell = null;
                    
                    cell = new DataGridViewTextBoxCell();
                    cell.Value = dt.Rows[t]["Wcs_TypeCode"].ToString().Trim();
                    dgvr.Cells.Add(cell);

                    cell = new DataGridViewTextBoxCell();
                    cell.Value = Convert.ToInt32(dt.Rows[t]["Wcs_PerformanceBeginValue"]) + "-" + Convert.ToInt32(dt.Rows[t]["Wcs_PerformanceEndValue"]) + " 提:" + Convert.ToDecimal(dt.Rows[t]["Wcs_Percentage"]) + "%"; ;
                    dgvr.Cells.Add(cell);

                    cell = new DataGridViewTextBoxCell();
                    cell.Value = dt.Rows[t]["Wcs_PerformanceBeginValue"].ToString().Trim();
                    dgvr.Cells.Add(cell);

                    this.dgv.Rows.Add(dgvr);
                }
                dgv.ClearSelection();

            }

        }
        #endregion

        #region 输入框设置
        protected override void txtWcs_PerformanceBeginValue_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            {
                e.Handled = true;
            }
        }
        protected override void txtWcs_PerformanceEndValue_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            {
                e.Handled = true;
            }
        }
        protected override void txtWcs_Percentage_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsPunctuation(e.KeyChar) && !Char.IsControl(e.KeyChar))
            {
                e.Handled = true;　//获取或设置一个值，指示是否处理过System.Windows.Forms.Control.KeyPress事件
            }
            else if (Char.IsPunctuation(e.KeyChar))
            {
                if (e.KeyChar == '.')
                {
                    if (((System.Windows.Forms.TextBox)sender).Text.LastIndexOf('.') != -1)
                    {
                        e.Handled = true;
                    }
                }
                else
                {
                    e.Handled = true;
                }
            }
        }

        protected override void txtValue_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsPunctuation(e.KeyChar) && !Char.IsControl(e.KeyChar))
            {
                e.Handled = true;　//获取或设置一个值，指示是否处理过System.Windows.Forms.Control.KeyPress事件
            }
            else if (Char.IsPunctuation(e.KeyChar))
            {
                if (e.KeyChar == '.')
                {
                    if (((System.Windows.Forms.TextBox)sender).Text.LastIndexOf('.') != -1)
                    {
                        e.Handled = true;
                    }
                }
                else
                {
                    e.Handled = true;
                }
            }
        }
        #endregion

        #region 添加到规则列表
        protected override void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(txtWcs_PerformanceBeginValue.Text) || string.IsNullOrEmpty(txtWcs_PerformanceEndValue.Text) || string.IsNullOrEmpty(txtWcs_Percentage.Text))
                {
                    MessageBoxCustom.Show("请输入数字！");
                    return;
                }
                if (txtWcs_PerformanceBeginValue.Text.Length >= 11)
                {
                    string Wcs_PerformanceBeginValue = txtWcs_PerformanceBeginValue.Text;
                    txtWcs_PerformanceBeginValue.Text = Wcs_PerformanceBeginValue.Substring(0, 10);
                }
                if (txtWcs_PerformanceEndValue.Text.Length >= 11)
                {
                    string Wcs_PerformanceEndValue = txtWcs_PerformanceEndValue.Text;
                    txtWcs_PerformanceEndValue.Text = Wcs_PerformanceEndValue.Substring(0, 10);
                }
                DataTable dt = new DataTable();
                LYFZ.BLL.BLL_ErpWageCommissionSet bll = new BLL.BLL_ErpWageCommissionSet();
                LYFZ.Model.Model_ErpWageCommissionSet model = new Model.Model_ErpWageCommissionSet();
                dt = bll.GetList("Wcs_TypeCode='" + Wcs_TypeCode + "'", "ID asc").Tables[0];
                if (dt.Rows.Count <= 0)
                {
                    if (Convert.ToInt32(txtWcs_PerformanceBeginValue.Text) != 0)
                    {
                        MessageBoxCustom.Show("业绩范围出错！");
                        return;
                    }

                    if (Convert.ToInt32(txtWcs_PerformanceEndValue.Text) == 0)
                    {
                        MessageBoxCustom.Show("业绩范围出错！");
                        return;

                    }
                }
                else
                {
                    //判断是否合法范围
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        int Range = Convert.ToInt32(dt.Rows[i]["Wcs_PerformanceEndValue"]);
                        if (Convert.ToInt32(txtWcs_PerformanceBeginValue.Text) <= Range)
                        {
                            MessageBoxCustom.Show("起始业绩已包含在已有的规则中");
                            return;
                        }
                        if (Convert.ToInt32(txtWcs_PerformanceEndValue.Text) <= Range)
                        {
                            MessageBoxCustom.Show("终止业绩已包含在已有的规则中");
                            return;
                        }
                    }
                    dt = bll.MaxValue("Wcs_PerformanceEndValue", "Wcs_TypeCode='" + Wcs_TypeCode + "'").Tables[0];
                    int RangeOne = Convert.ToInt32(dt.Rows[0]["value"]) + 1;
                    if (Convert.ToInt32(txtWcs_PerformanceBeginValue.Text) != RangeOne)
                    {
                        MessageBoxCustom.Show("业绩段不连续,起始业绩应比上一规则段终止业绩大1");
                        return;
                    }
                }
                #region 增加
                if (Wcs_Type == "提成点")
                {
                    model.Wcs_Type = "提成点";
                }
                if (Wcs_Type == "后期方案")
                {
                    model.Wcs_Type = "后期方案";
                }
                model.Wcs_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                model.Wcs_TypeCode = Wcs_TypeCode;
                model.Wcs_PerformanceBeginValue = Convert.ToInt32(txtWcs_PerformanceBeginValue.Text);
                model.Wcs_PerformanceEndValue = Convert.ToInt32(txtWcs_PerformanceEndValue.Text);
                model.Wcs_Percentage = Convert.ToDecimal(txtWcs_Percentage.Text);
                model.Wcs_PerformanceHight = false;
                // model.Wcs_Rule = ""; Convert.ToInt32(model.Wcs_PerformanceBeginValue) + "-" + Convert.ToInt32(model.Wcs_PerformanceEndValue) + " 提:" + Convert.ToDecimal(model.Wcs_Percentage)+"%";
                model.Wcs_CreateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                bll.Add(model);
                bind();
                #endregion
            }
            catch (Exception ex) { MessageBoxCustom.Show(ex.Message); }
        }
        #endregion

        #region 删除
        protected override void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.dgv.Rows.Count > 0)
                {
                    if (dgv.SelectedRows.Count == 0)
                    {
                        MessageBoxCustom.Show("请选择你要删除的数据！");
                        return;
                    }
                    if(dgv.CurrentRow.Index!= dgv.Rows.Count-1)
                    {
                        MessageBoxCustom.Show("此条规则不能删除，请删除最后一条（从后往前删）！");
                        return;
                    }
                    if (MessageBoxCustom.Show("你确定要删除此规则吗？", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                        LYFZ.BLL.BLL_ErpWageCommissionSet bllwage = new BLL.BLL_ErpWageCommissionSet();
                        bllwage.DeleteWageCommissionSet("Wcs_TypeCode='" + Wcs_TypeCode + "' and Wcs_PerformanceBeginValue='" + dgv.CurrentRow.Cells["Wcs_PerformanceBeginValue"].Value + "'");
                        MessageBoxCustom.Show("删除成功！");
                        bind();
                    }
                }
            }
            catch (Exception ex) { MessageBoxCustom.Show(ex.Message); }
        }
        #endregion

        #region 业绩超出部分才按高提成
        protected override void chkWcs_PerformanceHight_Click(object sender, EventArgs e)
        {
            try
            {
                if (chkWcs_PerformanceHight.Checked)
                {
                    LYFZ.BLL.BLL_ErpWageCommissionSet bll = new BLL.BLL_ErpWageCommissionSet();
                    bll.UpdateWageCommissionSet(1, "Wcs_TypeCode='" + Wcs_TypeCode + "'");
                    bind();
                }
                else
                {
                    LYFZ.BLL.BLL_ErpWageCommissionSet bll = new BLL.BLL_ErpWageCommissionSet();
                    bll.UpdateWageCommissionSet(0, "Wcs_TypeCode='" + Wcs_TypeCode + "'");
                    bind();
                }
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }

        }
        #endregion

        #region 规则试算
        protected override void btnResults_Click(object sender, EventArgs e)
        {
            try
            {
                if (dgv.Rows.Count == 0)
                {
                    MessageBoxCustom.Show("请设置规则！");
                    return;
                }
                if (string.IsNullOrEmpty(txtValue.Text))
                {
                    MessageBoxCustom.Show("请输入数字！");
                    return;
                }
                if (txtValue.Text.Length >= 11)
                {
                    string Value = txtValue.Text;
                    txtValue.Text = Value.Substring(0, 10);
                }
                LYFZ.BLL.BLL_ErpWageCommissionSet bll = new BLL.BLL_ErpWageCommissionSet();
                txtResults.Text = bll.GetCommissionSpecifications(Wcs_TypeCode, Convert.ToDecimal(txtValue.Text)).ToString("N2");
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }

        }
        

        #endregion
    }
}