lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/CustomerSatisfactionRecord/Satisfaction/FrmRatingSet.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.CustomerSatisfactionRecord.Satisfaction
{
    public partial class FrmRatingSet : LYFZ.Software.UI.CustomerSatisfactionRecord.Satisfaction.FrmRatingSet
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpSatisfactionRatingSet bll = new BLL.BLL_ErpSatisfactionRatingSet();
        public FrmRatingSet()
        {

        }

        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void FrmRatingSet_Shown(object sender, EventArgs e)
        {
            dgv.Rows.Clear();
            DataTable dt = new DataTable();
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                dt = bll.GetAllList().Tables[0];
            });
            if (dt.Rows.Count > 0)
            {
                for (int t = 0; t < dt.Rows.Count; t++)
                {
                    DataGridViewRow dgvr = new DataGridViewRow();
                    DataGridViewCell cell = null;

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

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

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

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

                    this.dgv.Rows.Add(dgvr);
                    dgv.ClearSelection();
                }
            }
        }
        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                LYFZ.Model.Model_ErpSatisfactionRatingSet model = new Model.Model_ErpSatisfactionRatingSet();
                if (string.IsNullOrEmpty(txtSfrs_Name.Text))
                { MessageBoxCustom.Show("满意项目名称不能为空！"); return; }
                if (string.IsNullOrEmpty(txtSfrs_Scores.Text))
                { MessageBoxCustom.Show("满意分值不能为空！"); return; }

                #region 增加
                if (dgv.SelectedRows.Count == 0)
                {
                    if (dgv.Rows.Count >= 5)
                    { MessageBoxCustom.Show("最多只能添加5个项目！"); return; }
                    if (bll.Exists("Sfrs_Name", this.txtSfrs_Name.Text) == true)
                    { MessageBoxCustom.Show("满意项目已经存在！"); return; }
                    model.Sfrs_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                    model.Sfrs_Name = txtSfrs_Name.Text.ToString();
                    model.Sfrs_Scores = Convert.ToInt32(txtSfrs_Scores.Text);
                    model.Sfrs_CreateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                    model.Sfrs_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
                    if (bll.Add(model))
                    {
                        MessageBoxCustom.Show("保存成功！");
                        this.FrmRatingSet_Shown(this, null);
                        txtSfrs_Name.Text = "";
                        txtSfrs_Scores.Text = "";
                    }
                }
                #endregion

                #region 修改
                if (dgv.SelectedRows.Count > 0)
                {
                    #region  判断满意项目是否存在
                    if (!string.IsNullOrEmpty(txtSfrs_Name.Text))
                    {
                        DataTable dt = bll.GetList("id=" + dgv.CurrentRow.Cells["ID"].Value + "", "ID desc").Tables[0];
                        if (dt.Rows.Count > 0)
                        {
                            string Sfrs_Name = dt.Rows[0]["Sfrs_Name"].ToString();
                            if (Sfrs_Name != txtSfrs_Name.Text)
                            {
                                dt = bll.GetList("Sfrs_Name='" + txtSfrs_Name.Text + "'").Tables[0];
                                if (dt.Rows.Count > 0)
                                { MessageBoxCustom.Show("满意项目名称已经存在！"); return; }
                            }
                        }
                        DataTable dt1 = bll.GetList("id != " + dgv.CurrentRow.Cells["ID"].Value + " And Sfrs_Scores = " + txtSfrs_Scores.Text.Trim() + "", "ID desc").Tables[0];
                        if (dt1.Rows.Count > 0)
                        { MessageBoxCustom.Show("满意项目分值已经存在！"); return; }
                    }
                    #endregion

                    model = bll.GetModel(Convert.ToInt32(dgv.CurrentRow.Cells["ID"].Value));
                    model.Sfrs_Name = txtSfrs_Name.Text.ToString();
                    model.Sfrs_Scores = Convert.ToInt32(txtSfrs_Scores.Text);
                    model.Sfrs_UpdateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                    model.Sfrs_UpdateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
                    if (bll.Update(model))
                    {
                        MessageBoxCustom.Show("保存成功！");
                        this.FrmRatingSet_Shown(this, null);
                        txtSfrs_Name.Text = "";
                        txtSfrs_Scores.Text = "";
                    }
                }
                #endregion
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 文本框限制
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void txtSfrs_TotalPoints_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// 文本框限制
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void txtSfrs_Scores_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// dgv控件赋值
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void dgv_Click(object sender, EventArgs e)
        {
            if (dgv.SelectedRows.Count > 0)
            {
                DataTable dt = bll.GetList("ID=" + Convert.ToInt32(dgv.CurrentRow.Cells["ID"].Value) + "").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    txtSfrs_Name.Text = dt.Rows[0]["Sfrs_Name"].ToString();
                    txtSfrs_Scores.Text = dt.Rows[0]["Sfrs_Scores"].ToString();
                }
            }
        }
        /// <summary>
        /// 取消
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnCanle_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.dgv.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选中你要删除的数据！"); return; }
                DataTable dt = bll.GetList("ID='" + dgv.CurrentRow.Cells["Id"].Value + "'", "ID desc").Tables[0];
                if (MessageBoxCustom.Show("你确定要删除吗？", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    if (bll.Delete(Convert.ToInt32(dgv.CurrentRow.Cells["Id"].Value)) == true)
                    {
                        string logsContent = "删除满意度设置名称：" + txtSfrs_Name.Text.Trim();
                        LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.删除满意度调查, logsContent, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);

                        MessageBoxCustom.Show("删除成功！");
                        this.FrmRatingSet_Shown(this, null);
                    }
                    else
                    { MessageBoxCustom.Show("删除失败！"); }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
    }
}