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

using LYFZ.ComponentLibrary;
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
{
    public partial class FrmSupplierSet : LYFZ.Software.UI.InitialSet.FrmSupplierSet
    {
        public FrmSupplierSet()
        {
            this.txtQQ.KeyPress += txtQQ_KeyPress;
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void FrmSupplierSet_Shown(object sender, EventArgs e)
        {
            WaitForm wf = new WaitForm();
            wf.ShowForm(this);
            try
            {
                Random action = new Random();
                txtVd_Number.Text = "SPH" + LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime().ToString("yyyyMMddHHmmss") + action.Next(100, 1000);
                Bind();

                #region 权限设置

                #region  保存新供应商
                if (dgv.SelectedRows.Count == 0)
                {
                    if (LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.SupplierCompetence, CustomAttributes.OperatingAuthority.Add))
                    {
                        btnSave.Enabled = true;
                    }
                    else
                    {
                        btnSave.Enabled = false;
                    }
                }
                #endregion

                #region  删除供应商
                if (LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.SupplierCompetence, CustomAttributes.OperatingAuthority.Delete))
                {
                    btnDelete.Enabled = true;

                }
                else
                {
                    btnDelete.Enabled = false;
                }

                #endregion

                #endregion
                wf.CloseForm();
                wf = null;
            }
            catch
            {
                wf.CloseForm();
                wf = null;
            }
        }
        /// <summary>
        /// 绑定供应商
        /// </summary>
        public void Bind()
        {
            dgv.Rows.Clear();
            LYFZ.BLL.BLL_ErpOrder Orderbll = new BLL.BLL_ErpOrder();
            //获取供应商表
            DataTable dt_s = Orderbll.GetView_Custom("tb_ErpVendor", StrWhere: "", ShowColumnName: "  ID,Vd_Name,Vd_QQ,Vd_Address,Vd_Telephone,Vd_Fax,Vd_URL,Vd_Remark").Tables[0];
            if (dt_s.Rows.Count > 0)
            {
                for (int t = 0; t < dt_s.Rows.Count; t++)
                {
                    #region
                    DataGridViewRow dgvr = new DataGridViewRow();
                    DataGridViewCell cell = null;

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

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

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

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

                    cell = new DataGridViewTextBoxCell();
                    cell.Value = dt_s.Rows[t]["Vd_Telephone"].ToString();
                    dgvr.Cells.Add(cell);

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

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

                    this.dgv.Rows.Add(dgvr);
                    dgv.ClearSelection();
                    #endregion
                }
            }
        }
        /// <summary>
        /// 保存供应商
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                #region 判断资料不能为空
                if (string.IsNullOrEmpty(this.txtVd_Number.Text.Trim()))
                {
                    MessageBoxCustom.Show("供应商编号能为空！");
                    return;
                }
                if (string.IsNullOrEmpty(this.txtVd_Name.Text.Trim()))
                {
                    MessageBoxCustom.Show("供应商名称不能为空！");
                    return;
                }
                if (this.txtVd_Name.Text.Trim().Contains(","))
                {
                    MessageBoxCustom.Show("供应商名称不能含有','！");
                    return;
                }
                if (string.IsNullOrEmpty(this.txtVd_Address.Text.Trim()))
                {
                    MessageBoxCustom.Show("供应商地址不能为空！");
                    return;
                }
                if (string.IsNullOrEmpty(txtVd_Telephone.Text.Trim()))
                {
                    MessageBoxCustom.Show("电话不能为空！");
                    return;
                }
                //if (!string.IsNullOrEmpty(txtVd_Telephone.Text))
                //{
                //    if (txtVd_Telephone.Text.Length != 11)
                //    {
                //        MessageBoxCustom.Show("手机号码必须为11位数！");
                //        return;
                //    }
                //}
                //if (CheckPhoneNumber(txtVd_Telephone.Text) == false)
                //{
                //    MessageBoxCustom.Show(txtVd_Telephone.Text + "   手机号码格式不正确！");
                //    return;
                //  }
                #endregion

                LYFZ.BLL.BaseBLL.BaseBLL_ErpVendor bll = new BLL.BaseBLL.BaseBLL_ErpVendor();
                LYFZ.Model.Model_ErpVendor model = new Model.Model_ErpVendor();
                DataTable dt = new DataTable();

                #region 增加
                try
                {
                    if (this.dgv.SelectedRows.Count == 0)
                    {
                        dt = bll.GetList("Vd_Name='" + txtVd_Name.Text + "'", "ID desc").Tables[0];
                        if (dt.Rows.Count > 0)
                        {
                            MessageBoxCustom.Show("供应商名称已经存在！");
                            this.txtVd_Name.Text = "";
                            this.txtVd_Name.Focus();
                            return;
                        }
                        model.Vd_Category = "0";
                        model.Vd_Number = txtVd_Number.Text;
                        model.Vd_Name = txtVd_Name.Text;
                        model.Vd_QQ = this.txtQQ.Text.Trim();
                        model.Vd_Address = txtVd_Address.Text;
                        model.Vd_Telephone = txtVd_Telephone.Text;
                        model.Vd_Fax = txtVd_Fax.Text;
                        model.Vd_URL = txtVd_URL.Text;
                        model.Vd_Remark = txtVd_Remark.Text;
                        model.Vd_ContactPerson = "";
                        if (bll.Add(model) == true)
                        {
                            MessageBoxCustom.Show("保存成功！");
                            BindClear();
                        }
                        else
                        { MessageBoxCustom.Show("保存失败！"); }
                    }
                }
                catch (Exception ex)
                { MessageBoxCustom.Show(ex.Message); }
                #endregion

                #region 更新
                try
                {
                    if (this.dgv.SelectedRows.Count > 0)
                    {
                        int id = Convert.ToInt32(dgv.CurrentRow.Cells["ID"].Value);
                        #region  判断供应商是否存在
                        if (!string.IsNullOrEmpty(txtVd_Name.Text))
                        {
                            dt = bll.GetList("id=" + id + "", "ID desc").Tables[0];
                            string Vd_Name = dt.Rows[0]["Vd_Name"].ToString();
                            if (Vd_Name != txtVd_Name.Text)
                            {
                                dt = bll.GetList("Vd_Name='" + txtVd_Name.Text + "'").Tables[0];
                                if (dt.Rows.Count > 0)
                                {
                                    MessageBoxCustom.Show("供应商名称已经存在！");
                                    return;
                                }
                            }
                        }
                        #endregion

                        model.ID = Convert.ToInt32(id);
                        model.Vd_Category = "0";
                        model.Vd_Number = txtVd_Number.Text;
                        model.Vd_Name = txtVd_Name.Text;
                        model.Vd_QQ = this.txtQQ.Text.Trim();
                        model.Vd_Address = txtVd_Address.Text;
                        model.Vd_Telephone = txtVd_Telephone.Text;
                        model.Vd_Fax = txtVd_Fax.Text;
                        model.Vd_URL = txtVd_URL.Text;
                        model.Vd_Remark = txtVd_Remark.Text;
                        if (bll.Update(model) == true)
                        {
                            MessageBoxCustom.Show("保存成功！");
                            BindClear();
                        }
                        else { MessageBoxCustom.Show("保存失败！"); }
                    }
                }
                catch (Exception ex) { MessageBoxCustom.Show(ex.Message); }
                #endregion
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 显示控件单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void dgv_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.dgv.SelectedRows.Count > 0)
                {
                    //更新赋值
                    LYFZ.BLL.BaseBLL.BaseBLL_ErpVendor userbll = new BLL.BaseBLL.BaseBLL_ErpVendor();
                    int id = Convert.ToInt32(this.dgv.CurrentRow.Cells["iD"].Value.ToString());
                    DataTable dt = userbll.GetList("id=" + id + "").Tables[0];
                    this.txtVd_Number.Text = dt.Rows[0]["Vd_Number"].ToString();
                    this.txtVd_Name.Text = dt.Rows[0]["Vd_Name"].ToString();
                    this.txtQQ.Text = dt.Rows[0]["Vd_QQ"].ToString().Trim();
                    this.txtVd_Address.Text = dt.Rows[0]["Vd_Address"].ToString();
                    this.txtVd_Telephone.Text = dt.Rows[0]["Vd_Telephone"].ToString();
                    this.txtVd_Fax.Text = dt.Rows[0]["Vd_Fax"].ToString();
                    this.txtVd_URL.Text = dt.Rows[0]["Vd_URL"].ToString();
                    this.txtVd_Remark.Text = dt.Rows[0]["Vd_Remark"].ToString();
                }
                #region  更新供应商
                if (LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.SupplierCompetence, CustomAttributes.OperatingAuthority.Update))
                { btnSave.Enabled = true; }
                else
                { btnSave.Enabled = false; }
                #endregion
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 增加供应商
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnAdd_Click(object sender, EventArgs e)
        {
            try
            { BindClear(); }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <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;
                }
                int id = Convert.ToInt32(dgv.CurrentRow.Cells["ID"].Value);
                LYFZ.BLL.BaseBLL.BaseBLL_ErpVendor bll = new BLL.BaseBLL.BaseBLL_ErpVendor();
                DataTable dt = bll.GetList("id=" + id + "", "ID desc").Tables[0];
                if (MessageBoxCustom.Show("你确定要删除吗？", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    if (bll.Delete(id) == true)
                    {
                        #region 写入操作日志
                        string logsContent = "删除供应商名称：" + txtVd_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);
                        //LYFZ.BLL.BLL_ErpSystemLogs systemLogsBll = new BLL.BLL_ErpSystemLogs();
                        //LYFZ.Model.Model_ErpSystemLogs systemLogsModel = new Model.Model_ErpSystemLogs();
                        //systemLogsModel.Slogs_Type = "user";
                        //systemLogsModel.Slogs_Topic = "删除供应商";
                        //systemLogsModel.Slogs_Content = "删除供应商名称：" +txtVd_Name.Text.Trim();
                        //systemLogsModel.Slogs_UserName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
                        //systemLogsModel.Slogs_IP = "";
                        //systemLogsModel.Slogs_CreateDatetime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                        //systemLogsModel.Slogs_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                        //systemLogsBll.Add(systemLogsModel);
                        #endregion
                        MessageBoxCustom.Show("删除成功！");
                        BindClear();
                    }
                    else
                    { MessageBoxCustom.Show("删除失败！"); }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 关闭供应商页面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnClose_Click(object sender, EventArgs e)
        { this.Close(); }
        /// <summary>
        /// 输入框设置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void txtVd_Telephone_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>
        void txtQQ_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// 清空与刷新
        /// </summary>
        public void BindClear()
        {
            txtVd_Number.Text = "";
            txtVd_Name.Text = "";
            this.txtQQ.Text = "";
            txtVd_Address.Text = "";
            txtVd_Telephone.Text = "";
            txtVd_Fax.Text = "";
            txtVd_URL.Text = "";
            txtVd_Remark.Text = "";
            FrmSupplierSet_Shown(this, null);
        }

    }
}