lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/MarketingAllPerson/SetSmallForm/AddNewActiveSmallForm.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.MarketingAllPerson.SetSmallForm
{
    public partial class AddNewActiveSmallForm : LYFZ.Software.UI.MarketingAllPerson.SetSmallForm.AddNewActiveSmallForm
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpTeamActiveSet tasbll = new BLL.BLL_ErpTeamActiveSet();
        public AddNewActiveSmallForm()
        {
            this.Load += AddNewActiveSmallForm_Load;
            this.Shown += AddNewActiveSmallForm_Shown;
            this.btnNew.Click += btnNew_Click;
            this.btnSaveed.Click += btnSaveed_Click;
            this.btnDelete.Click += btnDelete_Click;
            this.btnClose.Click += btnClose_Click;
            this.dgvData.CellMouseClick += dgvData_CellMouseClick;
            this.chkShow.Click += chkShow_Click;
            this.chkHide.Click += chkHide_Click;
            this.txtName.KeyPress += txtName_KeyPress;
            this.txtBaodiTask.KeyPress += txtBaodiTask_KeyPress;
            this.txtTargetTask.KeyPress += txtTargetTask_KeyPress;
            this.txtSprintTask.KeyPress += txtSprintTask_KeyPress;
        }
        /// <summary>
        /// 是否保存
        /// </summary>
        public bool IsSaveed = false;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AddNewActiveSmallForm_Load(object sender, EventArgs e)
        {
            DataTable dt = orbll.GetView_Custom("tb_ErpTeamActiveSet", StrWhere: "", ShowColumnName: "ID,Tas_Name AS 活动名称,(dbo.fn_CheckDateTimeReturn_Date(dbo.fn_CheckDateTime(Tas_DateTimeStart)) + '至' + dbo.fn_CheckDateTimeReturn_Date(dbo.fn_CheckDateTime(Tas_DateTimeEnd))) AS 截止日期,Tas_BaodiTask AS 保底任务,Tas_TargetTask AS 目标任务,Tas_SprintTask AS 冲刺任务,(case when Tas_IsEnabled = 0 then '隐藏' else '显示' end) AS 是否显示").Tables[0];
            this.dgvData.DataSource(dt, strHideField: "ID");
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AddNewActiveSmallForm_Shown(object sender, EventArgs e)
        {

        }
        /// <summary>
        /// 新建
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnNew_Click(object sender, EventArgs e)
        {
            this.IntClickID = 0;
            this.txtName.Text = "";
            this.dtpDateTimeStart.DateValue = "";
            this.dtpDateTimeEnd.DateValue = "";
            this.chkShow.Checked = true;
            this.chkHide.Checked = false;
            this.txtBaodiTask.Text = "";
            this.txtTargetTask.Text = "";
            this.txtSprintTask.Text = "";
            this.btnSaveed.Text = "  保  存";
        }
        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnSaveed_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
            { MessageBoxCustom.Show("活动名称不能为空！"); return; }
            if (string.IsNullOrEmpty(this.dtpDateTimeStart.DateValue.Trim()))
            { MessageBoxCustom.Show("开始日期不能为空！"); return; }
            if (string.IsNullOrEmpty(this.dtpDateTimeEnd.DateValue.Trim()))
            { MessageBoxCustom.Show("结束日期不能为空！"); return; }
            if (string.IsNullOrEmpty(this.txtBaodiTask.Text.Trim()))
            { MessageBoxCustom.Show("保底任务不能为空！"); return; }
            if (string.IsNullOrEmpty(this.txtTargetTask.Text.Trim()))
            { MessageBoxCustom.Show("目标任务不能为空！"); return; }
            if (string.IsNullOrEmpty(this.txtSprintTask.Text.Trim()))
            { MessageBoxCustom.Show("冲刺不能为空！"); return; }
            if (Convert.ToDateTime(this.dtpDateTimeStart.DateValue) > Convert.ToDateTime(this.dtpDateTimeEnd.DateValue))
            { MessageBoxCustom.Show("开始日期不能大于结束日期！"); return; }
            if (Convert.ToDecimal(this.txtBaodiTask.Text.Trim()) > Convert.ToDecimal(this.txtTargetTask.Text.Trim()))
            { MessageBoxCustom.Show("目标任务不能小于保底任务！"); return; }
            if (Convert.ToDecimal(this.txtTargetTask.Text.Trim()) > Convert.ToDecimal(this.txtSprintTask.Text.Trim()))
            { MessageBoxCustom.Show("冲刺任务不能小于目标任务！"); return; }

            DateTime StrTime = SDateTime.Now;
            string StrUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
            LYFZ.Model.Model_ErpTeamActiveSet model = null;
            if (this.IntClickID <= 0)
            {
                DataTable dt = orbll.GetView_Custom("tb_ErpTeamActiveSet", StrWhere: "Tas_Name = '" + this.txtName.Text.Trim() + "'", ShowColumnName: "ID").Tables[0];
                if (dt.Rows.Count > 0)
                { MessageBoxCustom.Show("活动名称已存在，不能重复命名！"); return; }
                model = new Model.Model_ErpTeamActiveSet();
                model.Tas_Number = "MAN_" + LYFZ.WinAPI.CustomPublicMethod.GenerateId().ToString().Trim();
                model.Tas_Name = this.txtName.Text.Trim();
                model.Tas_DateTimeStart = Convert.ToDateTime(this.dtpDateTimeStart.DateValue);
                model.Tas_DateTimeEnd = Convert.ToDateTime(this.dtpDateTimeEnd.DateValue).AddDays(1).AddSeconds(-1);
                model.Tas_BaodiTask = Convert.ToDecimal(this.txtBaodiTask.Text.Trim());
                model.Tas_TargetTask = Convert.ToDecimal(this.txtTargetTask.Text.Trim());
                model.Tas_SprintTask = Convert.ToDecimal(this.txtSprintTask.Text.Trim());
                model.Tas_IsEnabled = this.chkShow.Checked;
                model.Tas_CreateDateTime = StrTime;
                model.Tas_CreateName = StrUserID;
                if (tasbll.Add(model))
                {
                    this.IsSaveed = true;
                    MessageBoxCustom.Show("添加成功！");
                    this.AddNewActiveSmallForm_Load(this, null);
                    this.btnNew_Click(this, null);
                }
                else
                { MessageBoxCustom.Show("添加失败！"); }
            }
            else
            {
                DataTable dt = orbll.GetView_Custom("tb_ErpTeamActiveSet", StrWhere: "Tas_Name = '" + this.txtName.Text.Trim() + "' And ID != '" + this.IntClickID + "'", ShowColumnName: "ID").Tables[0];
                if (dt.Rows.Count > 0)
                { MessageBoxCustom.Show("活动名称已存在，不能重复命名！"); return; }
                model = tasbll.GetModel(this.IntClickID);
                model.Tas_Name = this.txtName.Text.Trim();
                model.Tas_DateTimeStart = Convert.ToDateTime(this.dtpDateTimeStart.DateValue);
                model.Tas_DateTimeEnd = Convert.ToDateTime(this.dtpDateTimeEnd.DateValue).AddDays(1).AddSeconds(-1);
                model.Tas_BaodiTask = Convert.ToDecimal(this.txtBaodiTask.Text.Trim());
                model.Tas_TargetTask = Convert.ToDecimal(this.txtTargetTask.Text.Trim());
                model.Tas_SprintTask = Convert.ToDecimal(this.txtSprintTask.Text.Trim());
                model.Tas_IsEnabled = this.chkShow.Checked;
                model.Tas_UpdateDateTime = StrTime;
                model.Tas_UpdateName = StrUserID;
                if (tasbll.Update(model))
                {
                    this.IsSaveed = true;
                    MessageBoxCustom.Show("修改成功！");
                    this.AddNewActiveSmallForm_Load(this, null);
                }
                else
                { MessageBoxCustom.Show("修改失败！"); }
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnDelete_Click(object sender, EventArgs e)
        {
            if (this.IntClickID > 0)
            {
                DataTable dt = orbll.GetView_Custom("tb_ErpTeamActiveSet", StrWhere: "ID = '" + this.IntClickID + "'", ShowColumnName: "Tas_Number").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    dt = orbll.GetView_Custom("tb_ErpTeamMaxTaskSet", StrWhere: "Tmxt_TasNumber = '" + dt.Rows[0]["Tas_Number"].ToString().Trim() + "'", ShowColumnName: "ID").Tables[0];
                    if (dt.Rows.Count > 0)
                    { MessageBoxCustom.Show("此活动名称已设置了大队，不能删除！"); return; }
                }
                if (MessageBoxCustom.Show("您确定要删除吗？", "温馨提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    if (tasbll.Delete(this.IntClickID))
                    {
                        this.IsSaveed = true;
                        MessageBoxCustom.Show("删除成功！");
                        this.AddNewActiveSmallForm_Load(this, null);
                        this.btnNew_Click(this, null);
                    }
                    else
                    { MessageBoxCustom.Show("删除失败！"); }
                }
            }
            else
            { MessageBoxCustom.Show("请选择你要删除的活动！"); }
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        int IntClickID = 0;
        /// <summary>
        /// 列表点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
            {
                if (this.dgvData.Rows.Count > 0)
                {
                    this.IntClickID = Convert.ToInt32(this.dgvData.Rows[e.RowIndex].Cells["ID"].Value);
                    this.txtName.Text = this.dgvData.Rows[e.RowIndex].Cells["活动名称"].Value.ToString().Trim();
                    string[] StrArray = this.dgvData.Rows[e.RowIndex].Cells["截止日期"].Value.ToString().Trim().Split('至');
                    this.dtpDateTimeStart.DateValue = StrArray[0].Trim();
                    this.dtpDateTimeEnd.DateValue = StrArray[1].Trim();
                    this.txtBaodiTask.Text = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(this.dgvData.Rows[e.RowIndex].Cells["保底任务"].Value);
                    this.txtTargetTask.Text = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(this.dgvData.Rows[e.RowIndex].Cells["目标任务"].Value);
                    this.txtSprintTask.Text = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(this.dgvData.Rows[e.RowIndex].Cells["冲刺任务"].Value);
                    if (this.dgvData.Rows[e.RowIndex].Cells["是否显示"].Value.ToString().Trim() == "显示")
                    {
                        this.chkShow.Checked = true;
                        this.chkHide.Checked = false;
                    }
                    else
                    {
                        this.chkHide.Checked = true;
                        this.chkShow.Checked = false;
                    }
                    this.btnSaveed.Text = "  修  改";
                }
            }
        }
        /// <summary>
        /// 显示
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkShow_Click(object sender, EventArgs e)
        {
            this.chkShow.Checked = true;
            this.chkHide.Checked = false;
        }
        /// <summary>
        /// 隐藏
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkHide_Click(object sender, EventArgs e)
        {
            this.chkHide.Checked = true;
            this.chkShow.Checked = false;
        }
        /// <summary>
        /// 活动名称限制输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtName_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar) && !Char.IsLetterOrDigit(e.KeyChar) && e.KeyChar != '_' && e.KeyChar != ' ')
            { e.Handled = true; }
            if (Char.IsNumber(e.KeyChar))
            {
                if (!System.Text.RegularExpressions.Regex.IsMatch(e.KeyChar.ToString(), "[0-9]") && e.KeyChar != '\b')
                { e.Handled = true; }
            }
        }
        /// <summary>
        /// 保底限制输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtBaodiTask_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
            if (!System.Text.RegularExpressions.Regex.IsMatch(e.KeyChar.ToString(), "[0-9]") && e.KeyChar != ' ' && e.KeyChar != '\b')
            { e.Handled = true; }
        }
        /// <summary>
        /// 目标限制输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtTargetTask_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
            if (!System.Text.RegularExpressions.Regex.IsMatch(e.KeyChar.ToString(), "[0-9]") && e.KeyChar != ' ' && e.KeyChar != '\b')
            { e.Handled = true; }
        }
        /// <summary>
        /// 冲刺限制输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtSprintTask_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
            if (!System.Text.RegularExpressions.Regex.IsMatch(e.KeyChar.ToString(), "[0-9]") && e.KeyChar != ' ' && e.KeyChar != '\b')
            { e.Handled = true; }
        }
    }
}