MES_Client/TGMES/Core.StlMes.Client.Pms/configure/FrmMainTain.cs

using com.hnshituo.pur.vo;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinGrid;
using Pur.Entity;
using Pur.Entity.configureEntity;
using Pur.Pop_upWindow;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Pur.configure
{
    public partial class FrmMainTain : FrmPmsBase
    {
        public FrmMainTain()
        {
            InitializeComponent();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "doQuery":
                    getPurMainTain();
                    break;
                case "doAdd":
                    addPurMainTain();
                    break;
                case "doDelete":
                    delPurMainTain();
                    break;
                case "Close":
                    this.Close();
                    break;
            }

        }
        /// <summary>
        /// 删除物料
        /// </summary>
        private void delPurMainTain()
        {

            
            UltraGridRow rug = ultraGrid3.ActiveRow;
            if (rug == null)
            {
                MessageUtil.ShowTips("请选择删除物料");
                return;
            }
            String strId = ultraGrid3.ActiveRow.Cells["ID"].Value.ToString();
            String strClassCode = ultraGrid3.ActiveRow.Cells["classCode"].Value.ToString();
            if (String.IsNullOrEmpty(strId))
            {
                MessageUtil.ShowTips("数据异常，物料编号为空");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("确定删除？  备注：若删除，该物料关联的属性将全部删除！")!= DialogResult.Yes)
            {
                return;
            }
            CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMatRelationService", "doDelete_Relation", new object[] { strId });
            if (crt.Resultcode != 0)
            {
                MessageUtil.ShowTips("删除失败");
                return;
            }
            MessageUtil.ShowTips("删除成功");
            doQueryMat(strClassCode);


        }
        /// <summary>
        /// 查询物料
        /// </summary>
        /// <param name="classCode"></param>
        private void doQueryMat(String classCode)
        {
            if(String.IsNullOrEmpty(classCode))
            {

                return;
            }
            PurClassMatRelationEntity purentity1 = new PurClassMatRelationEntity();
            purentity1.ClassCode = classCode;
            DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.configure.service.ClassMatRelationService", "find", new object[] { purentity1, 0, 0 });
            GridHelper.CopyDataToDatatable(dt2, dataTable3, true);
            GridHelper.RefreshAndAutoSize(ultraGrid3);
        }
        /// <summary>
        /// 查询属性
        /// </summary>
        /// <param name="itemCode"></param>
        private void doQueryAttr(String itemCode)
        {
            txt_AttrBZ.Text = "";
            textBox3.Text = "";
            if (String.IsNullOrEmpty(itemCode))
            {
                return;
            }
            PurClassMatAttrEntity purentity1 = new PurClassMatAttrEntity();
            purentity1.ItemCode = itemCode;
            DataTable dt2 = this.execute<DataTable>("com.hnshituo.pur.configure.service.ClassMatAttrService", "find", new object[] { purentity1, 0, 0 });
            GridHelper.CopyDataToDatatable(dt2, dataTable2, true);
            GridHelper.RefreshAndAutoSize(ultraGrid2);
        }
        private void addPurMainTain()
        {
            if (ultraGrid1.ActiveRow == null)
            {
                MessageUtil.ShowTips("请选择类型");
                return;
            }
            String strCLASSCODE = ultraGrid1.ActiveRow.GetCellValue("CLASSCODE").ToString().Trim();
            if (String.IsNullOrEmpty(strCLASSCODE))
            {
                MessageUtil.ShowTips("请选择类型编号为空");
                return;
            }
            ArrayList list=new ArrayList();
            frmPopMatSelect frm = new frmPopMatSelect(this.ob);
            frm.ShowDialog();
            if (frm.tips == "1")
            {
                
                for (int i = 0; i <frm.List_item.Count; i++)
                {
                    PurClassMatRelationEntity purentity = new PurClassMatRelationEntity();
                    purentity.ItemCode = ((MatEntity)frm.List_item[i]).ItemCode;
                    purentity.ItemName = ((MatEntity)frm.List_item[i]).ItemName;
                    purentity.ClassCode = strCLASSCODE;
                    purentity.CreateName = UserInfo.GetUserName();
                    purentity.CreateTime = DateTime.Now;
                    purentity.CreateUserid = UserInfo.GetUserID();
                    list.Add(purentity);
                }
                if (list.Count <= 0)
                {
                    MessageUtil.ShowTips("未选择物料");
                    return;
                }
                CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMatRelationService", "doInsert_Relation", new object[] { list, 0, 0 });
                if (crt.Resultcode != 0)
                {
                    MessageUtil.ShowTips("绑定失败：" + crt.Resultmsg);
                }
                else {
                    MessageUtil.ShowTips("操作成功");
                    doQueryMat(strCLASSCODE);
                }
            }

        }
        /// <summary>
        /// 查询物料类型
        /// </summary>
        private void getPurMainTain()
        {
            dataTable1.Clear();
            dataTable2.Clear();
            dataTable3.Clear();
            textBox1.Text = "";
            txt_ClassBZ.Text = "";
            DataTable dt1 = this.execute<DataTable>("com.hnshituo.pur.configure.service.ClassMainService", "findAll", new object[] {});
           GridHelper.CopyDataToDatatable(dt1, dataTable1,true);
           GridHelper.RefreshAndAutoSize(ultraGrid1);
        }

        private void ultraButton6_Click(object sender, EventArgs e)
        {
            PurClassEntity purentity = new PurClassEntity();
            if (textBox1.Text != "")
            {
                purentity.ClassName = textBox1.Text.Trim();
               
            }
            else
            {
                MessageUtil.ShowTips("类型名称不能为空");
                return;
            }
            purentity.CreateName = UserInfo.GetUserName();
            purentity.CreateUserid = UserInfo.GetUserID();
            purentity.Remark = txt_ClassBZ.Text;
            if (MessageUtil.ShowYesNoAndQuestion("确定添加？") != DialogResult.Yes )
            {
                return;
            }
            CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMainService", "insert_id", new object[] { purentity });
            if (crt.Resultcode != 0)
            {
                MessageUtil.ShowTips("添加失败:"+crt.Resultmsg);
                return;
            }
            MessageUtil.ShowTips("添加成功");
            getPurMainTain();
            ConfigureClassCommon.doActiveSelRow(ultraGrid1, "CLASSNAME", purentity.ClassName);//激活当前行
        }

        private void ultraButton4_Click(object sender, EventArgs e)
        {
            PurClassEntity purentity = new PurClassEntity();
            UltraGridRow rug = ultraGrid1.ActiveRow;
            if (rug == null)
            {
                MessageUtil.ShowTips("请选中修改行");
            }
            if (textBox1.Text == "")
            {
                MessageUtil.ShowTips("修改内容不能为空");
                return;
            }
            if (textBox1.Text == ultraGrid1.ActiveRow.Cells["CLASSNAME"].Value.ToString())
            {
                MessageUtil.ShowTips("修改内容不能重复");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确定修改？") == DialogResult.No)
            {
                return;
            }
            purentity.ClassCode = ultraGrid1.ActiveRow.Cells["CLASSCODE"].Value.ToString();
            purentity.ClassName = textBox1.Text.Trim();
            CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMainService", "doUpdate", new object[] { purentity, 0, 0 });
            if (crt.Resultcode != 0)
            {
                MessageUtil.ShowTips("修改失败");
                return;
            }
            MessageUtil.ShowTips("修改成功");
            getPurMainTain();
            ConfigureClassCommon.doActiveSelRow(ultraGrid1, "CLASSCODE", purentity.ClassCode);

        }

        private void ultraButton5_Click(object sender, EventArgs e)
        {
            if (ultraGrid1.ActiveRow != null)
            {
                String strClassCode = ultraGrid1.ActiveRow.Cells["CLASSCODE"].Value.ToString();
                if (String.IsNullOrEmpty(strClassCode))
                {
                    MessageUtil.ShowTips("类型编号为空");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确定删除类型【" + ultraGrid1.ActiveRow.Cells["CLASSNAME"].Value.ToString() + "】？ 备注：若删除，其关联的物料和物料属性将同步删除") != DialogResult.Yes)
                {
                    return;
                }
                CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMainService", "doDelete_id", new object[] { strClassCode });
                if (crt.Resultcode != 0)
                {
                    MessageUtil.ShowTips("删除失败:" + crt.Resultmsg);
                }
                MessageUtil.ShowTips("删除成功");
                getPurMainTain();
            }
        }

        private void ultraButton1_Click(object sender, EventArgs e)
        {
            if (ultraGrid3.ActiveRow == null)
            {
                MessageUtil.ShowTips("请选择物料");
                return;
            }
            String strItemCode = ultraGrid3.ActiveRow.GetCellValue("itemCode").ToString().Trim();
            if (String.IsNullOrEmpty(strItemCode))
            {
                MessageUtil.ShowTips("选择的物料物料编号为空");
                return;
            }
            PurClassMatAttrEntity puren = new PurClassMatAttrEntity();
            if (textBox3.Text != "")
            {
                puren.AttrName = textBox3.Text.Trim();
            }
            else
            {
                MessageUtil.ShowTips("属性名称不能为空");
                return;
            }
            puren.CreateName = UserInfo.GetUserName();
            puren.CreateUserid = UserInfo.GetUserID();
            puren.CreateTime = DateTime.Now;
            puren.ItemCode = strItemCode;
            puren.Remark = txt_AttrBZ.Text;
            if (MessageUtil.ShowYesNoAndQuestion("确定添加？") != DialogResult.Yes)
            {
                return;
            }
            CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMatAttrService", "insert_id", new object[] { puren });
            if (crt.Resultcode != 0)
            {
                MessageUtil.ShowTips("添加失败："+crt.Resultmsg);
                return;
            }
            MessageUtil.ShowTips("添加成功");
            doQueryAttr(strItemCode);
            ConfigureClassCommon.doActiveSelRow(ultraGrid2, "attrName", puren.AttrName);
            
        }

        private void FrmMainTain_Load(object sender, EventArgs e)
        {
            getPurMainTain();
        }

        private void ultraButton3_Click(object sender, EventArgs e)
        {
            PurClassMatAttrEntity puren = new PurClassMatAttrEntity();
            UltraGridRow rug = ultraGrid2.ActiveRow;
            puren.Id = ultraGrid2.ActiveRow.Cells["ID"].Value.ToString();
            if (rug == null)
            {
                MessageUtil.ShowTips("请选中修改行");
            }
            if (textBox3.Text != "")
            {
                puren.AttrName = textBox3.Text.Trim();
            }
            else
            {
                MessageUtil.ShowTips("属性名称不能为空");
                return;
            }
            //if (textBox3.Text == ultraGrid1.ActiveRow.Cells["ATTRNAME"].Value.ToString())
            //{
            //    MessageUtil.ShowTips("属性名称不能重复");
            //    return;
            //}
            if (MessageUtil.ShowYesNoAndQuestion("是否确定修改？") == DialogResult.No)
            {
                return;
            }
            CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMatAttrService", "doUpdate", new object[] { puren, 0, 0 });
            if (crt.Resultcode != 0)
            {
                MessageUtil.ShowTips("修改失败");
                return;
            }
            MessageUtil.ShowTips("修改成功");

        }

        private void ultraButton2_Click(object sender, EventArgs e)
        {
            UltraGridRow rug = ultraGrid2.ActiveRow;
            if (rug == null)
            {
                MessageUtil.ShowTips("请选择需删除的属性");
                return;
            }
            String strId = ultraGrid2.ActiveRow.Cells["ID"].Value.ToString();
            if(String.IsNullOrEmpty(strId))
            {
                MessageUtil.ShowTips("请选择需删除的属性编号为空");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("确定删除？") == DialogResult.No)
            {
                return;
            }
            CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.configure.service.ClassMatAttrService", "doDelete", new object[] { strId });
            if (crt.Resultcode != 0)
            {
                MessageUtil.ShowTips("删除失败");
                return;
            }
            MessageUtil.ShowTips("删除成功");
            string strItemCode = ultraGrid3.ActiveRow.Cells["ItemCode"].Value.ToString();
            doQueryAttr(strItemCode);
        }

        private void ultraGrid3_AfterRowActivate(object sender, EventArgs e)
        {
            dataTable2.Clear();
            UltraGridRow uge = ultraGrid3.ActiveRow;
            if (uge == null)
            {
                return;
            }
            textBox3.Text = "";
            txt_AttrBZ.Text = "";
            String stritemCode = ultraGrid3.ActiveRow.GetCellValue("itemCode").ToString().Trim();
            doQueryAttr(stritemCode);

        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            dataTable2.Clear();
            dataTable3.Clear();
            UltraGridRow uge = ultraGrid1.ActiveRow;
            if (uge == null)
            {
                return;
            }
            
            String strClassCode = ultraGrid1.ActiveRow.GetCellValue("classCode").ToString().Trim();
            doQueryMat(strClassCode);
        }

        private void ultraGrid2_ClickCell(object sender, ClickCellEventArgs e)
        {
            textBox3.Text = e.Cell.Row.Cells["ATTRNAME"].Value.ToString();
            txt_AttrBZ.Text = e.Cell.Row.Cells["REMARK"].Value.ToString(); ;
        }

        private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
        {
            textBox1.Text = e.Cell.Row.Cells["classname"].Value.ToString();
            txt_ClassBZ.Text = e.Cell.Row.Cells["REMARK"].Value.ToString();
        }
    }
}