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 } }