MES_Client/TGMES/Core.StlMes.Client.Lims.Resource/资源管理/设备管理/FrmDmFixedAssetsDetail.cs

using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA03;
using CoreFS.CA04;
using CoreFS.CA06;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using System;

namespace Core.StlMes.Client.Lims.Resource
{
    //1通过记录名称控制设备使用运行记录
    //2可查看附属设备以及附属设备的主设备
    //设备档案以及档案位置 设备图片等说明书的保存路径FILE_POSITION
    public partial class FrmDmFixedAssetsDetail : FrmBase
    {
        private string[] arr;
        public FrmDmFixedAssetsDetail()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            arr = this.ValidDataPurviewIds;
        }

        private void FrmDmFixedAssetsDetail_Load(object sender, EventArgs e)
        {
            InitColumns();
            arr = this.ValidDataPurviewIds;
            ultraQueryDEPT_ID.QueryDept_Id(ob, arr);
            ultraDEPT_ID.QueryDept_Id(ob, arr);
        }

        private void InitColumns()
        {
            string[] arrColumnsBase = new string[] { "DEVICE_TYPE", "DEVICE_ID", "DEVICE_NAME", "SPEC", "DEVICE_NO", "SELF_NO", "EQUIP_NO", "USE_FUNCTION", "MEASURE_UNIT", "DEVICE_COUNT", "CAPACITY", "WEIGHT", "START_PRICE", "MANUFACTURER", "FACTORY_TIME", "PRODUCT_TIME", "DEPT_ID", "DEPT_NAME", "ROOM_NO", "RECORD_NAME", "POINT_CHECK_STD", "PARA", "PRECISION_RANGE", "FIND_WAY", "FILE_POSITION", "REMARK", "CREATE_NAME", "CREATE_TIME" };
            string[] arrCaptionBase = new string[] { "资产类别", "资产编号", "资产名称", "规格型号", "设备编号", "自编号", "设备部编号", "用途", "单位", "数量", "装机容量", "重量(Kg)", "原值", "制造厂商", "出厂日期", "投产日期", "安装位置", "安装位置", "房间号", "记录名称", "点检标准", "性能参数", "精度", "溯源方式", "文件地址", "备注", "创建人", "创建时间" };

            PublicResource.InitColumns(arrColumnsBase, arrCaptionBase, dataTable1, ultraGrid1, new string[] { "FILE_NO", "DEPT_ID", "VALIDFLAG" }, false, null);
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //新增修改删除退出
            switch (ToolbarKey)
            {
                case "Query":
                    QueryFixedAssetsDetail();
                    break;
                case "Add":
                    AddFixedAssetsDetail();
                    break;
                case "Update":
                    UpdateFixedAssetsDetail();
                    break;
                case "Delete":
                    DeleteFixedAssetsDetail();
                    break;
                case "Clear":
                    ClearFixedAssetsDetail();
                    break;
                case "Export":
                    ExportFixedAssetsDetail();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void QueryFixedAssetsDetail()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                if (chkISVALID.Checked)
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                else
                {
                    arrayList.Add("显示");
                    arrayList.Add("显示");
                    arrayList.Add("显示");
                }
                if (chkDEPT_ID.Checked)
                {
                    arrayList.Add(ultraQueryDEPT_ID.UltDept_ID);
                    arrayList.Add(ultraQueryDEPT_ID.UltDept_ID);
                    arrayList.Add(ultraQueryDEPT_ID.UltDept_ID);
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkDEVICE_TYPE.Checked)
                {
                    arrayList.Add(ultraQueryDEVICE_TYPE.Text.Trim());
                    arrayList.Add(ultraQueryDEVICE_TYPE.Text.Trim());
                    arrayList.Add(ultraQueryDEVICE_TYPE.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkDEVICE_NAME.Checked)
                {
                    arrayList.Add(txtQueryDEVICE_NAME.Text.Trim());
                    arrayList.Add(txtQueryDEVICE_NAME.Text.Trim());
                    arrayList.Add(txtQueryDEVICE_NAME.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }
                if (chkDEVICE_ID.Checked)
                {
                    arrayList.Add(txtQueryDEVICE_ID.Text.Trim());
                    arrayList.Add(txtQueryDEVICE_ID.Text.Trim());
                    arrayList.Add(txtQueryDEVICE_ID.Text.Trim());
                }
                else
                {
                    arrayList.Add("");
                    arrayList.Add("");
                    arrayList.Add("");
                }

                DataTable dt = PublicServer.GetData("com.steering.lims.resource.device.FrmDmFixedAssetsDetail.QueryFixedAssetsDetail",
                new Object[] { arrayList, arr }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    ClearFixedAssetsDetail();
                    dataTable1.Rows.Clear();
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid1);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private string IsValid()
        {
            if (ultraDEPT_ID.UltDept_Name == "")
            {
                return "安装位置不能为空！";
            }

            if (txtDEVICE_ID.Text.Trim() == "")
            {
                return "资产编号不能为空！";
            }
            if (ultraCAPITAL_SOURCE.Text.Trim() == "")
            {
                return "资金来源不能为空！";
            }
            return "";
        }

        private void AddFixedAssetsDetail()
        {
            try
            {
                string strTips = IsValid();
                if (strTips != "")
                {
                    MessageUtil.ShowWarning(strTips);
                    return;
                }
                //资金来源为检测中心的资产编号 JCZX + 年 + 四位流水
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string strDEVICE_ID = txtDEVICE_ID.Text.Trim();

                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(strDEVICE_ID);
                    arrayList.Add(txtDEVICE_NO.Text.Trim());
                    arrayList.Add(txtSELF_NO.Text.Trim());
                    arrayList.Add(txtEQUIP_NO.Text.Trim());
                    arrayList.Add(txtDEVICE_NAME.Text.Trim());

                    arrayList.Add(ultraDEVICE_TYPE.Text.Trim());//资产类别
                    arrayList.Add(txtSPEC.Text.Trim());
                    arrayList.Add(ultraMEASURE_UNIT.Text.Trim());
                    arrayList.Add(ultraDEVICE_COUNT.Text.Trim());
                    arrayList.Add(txtCAPACITY.Text.Trim());

                    arrayList.Add(txtWEIGHT.Text.Trim());
                    arrayList.Add(txtSTART_PRICE.Text.Trim());//原值
                    arrayList.Add(txtMANUFACTURER.Text.Trim());
                    arrayList.Add(FACTORY_TIME.Text.Trim());//出厂日期
                    arrayList.Add(PRODUCT_TIME.Text.Trim());//投产日期

                    arrayList.Add(ultraDEPT_ID.UltDept_ID);//安装科室
                    arrayList.Add(ultraDEPT_ID.UltDept_Name);
                    arrayList.Add(txtDEPT_SEQ.Text.Trim());
                    arrayList.Add(txtROOM_NO.Text.Trim());
                    arrayList.Add(txtCHANGE_STATE.Text.Trim());//变动情况

                    arrayList.Add(txtTRANSFER_CER.Text.Trim());
                    arrayList.Add(ultraUSE_STATE.Text.Trim());
                    arrayList.Add(txtHEAD_SEQ.Text.Trim());//原序号
                    arrayList.Add(txtWAIT_DELETE.Text.Trim());
                    arrayList.Add(ultraRECORD_NAME.Text.Trim());//记录名称........跟使用运行记录有关

                    arrayList.Add(ultraDEVICE_FILE.Text.Trim());//设备档案 跟设备的档案维护有关
                    arrayList.Add(txtFILE_LOCATION.Text.Trim());
                    arrayList.Add(ultraCAPITAL_SOURCE.Text.Trim());//资金来源 跟资产编号有关 不同的来源编号规则不同
                    arrayList.Add(chkISBELONG.Checked == true ? "是" : "否");//是否附属
                    arrayList.Add(chkSHOW_FLAG.Checked == true ? "不显示" : "显示");//显示标记

                    arrayList.Add(ultraPOINT_CHECK_STD.Text.Trim());//点检标准
                    arrayList.Add(txtPARA.Text.Trim());
                    arrayList.Add(ultraCERTIFICATE.Text.Trim());
                    arrayList.Add(ultraGRADE.Text.Trim());
                    arrayList.Add(txtPRECISION_RANGE.Text.Trim());//精度

                    arrayList.Add(ultraFIND_WAY.Text.Trim());//溯源
                    arrayList.Add(ultraCOUNTRY.Text.Trim());
                    arrayList.Add(txtCHANGE_RECORD.Text.Trim());//调拨记录
                    arrayList.Add(txtUSE_FUNCTION.Text.Trim());
                    arrayList.Add(txtREMARK.Text.Trim());//备注

                    arrayList.Add(UserInfo.GetUserName());//创建人

                    PublicServer.SetData("com.steering.lims.resource.device.FrmDmFixedAssetsDetail.AddFixedAssetsDetail",
new Object[] { arrayList }, this.ob);//strDEVICE_ID,

                    QueryFixedAssetsDetail();

                    PublicResource.ActiveOperateRow(ultraGrid1, "DEVICE_ID", strDEVICE_ID);//定位保存的行

                    MessageUtil.ShowTips("新增成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void UpdateFixedAssetsDetail()
        {
            try
            {
                string strTips = IsValid();
                if (strTips != "")
                {
                    MessageUtil.ShowWarning(strTips);
                    return;
                }
                if (ultraGrid1.ActiveRow == null)
                {
                    MessageUtil.ShowWarning("请选择一条需要修改的记录！");
                    return;
                }
                //资金来源为检测中心的资产编号 JCZX + 年 + 四位流水
                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    string strDEVICE_ID = txtDEVICE_ID.Text.Trim();

                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(strDEVICE_ID);
                    arrayList.Add(txtDEVICE_NO.Text.Trim());
                    arrayList.Add(txtSELF_NO.Text.Trim());
                    arrayList.Add(txtEQUIP_NO.Text.Trim());
                    arrayList.Add(txtDEVICE_NAME.Text.Trim());

                    arrayList.Add(ultraDEVICE_TYPE.Text.Trim());//资产类别
                    arrayList.Add(txtSPEC.Text.Trim());
                    arrayList.Add(ultraMEASURE_UNIT.Text.Trim());
                    arrayList.Add(ultraDEVICE_COUNT.Text.Trim());
                    arrayList.Add(txtCAPACITY.Text.Trim());

                    arrayList.Add(txtWEIGHT.Text.Trim());
                    arrayList.Add(txtSTART_PRICE.Text.Trim());//原值
                    arrayList.Add(txtMANUFACTURER.Text.Trim());
                    arrayList.Add(FACTORY_TIME.Text.Trim());//出厂日期
                    arrayList.Add(PRODUCT_TIME.Text.Trim());//投产日期

                    arrayList.Add(ultraDEPT_ID.UltDept_ID);//安装科室
                    arrayList.Add(ultraDEPT_ID.UltDept_Name);
                    arrayList.Add(txtDEPT_SEQ.Text.Trim());
                    arrayList.Add(txtROOM_NO.Text.Trim());
                    arrayList.Add(txtCHANGE_STATE.Text.Trim());//变动情况

                    arrayList.Add(txtTRANSFER_CER.Text.Trim());
                    arrayList.Add(ultraUSE_STATE.Text.Trim());
                    arrayList.Add(txtHEAD_SEQ.Text.Trim());//原序号
                    arrayList.Add(txtWAIT_DELETE.Text.Trim());
                    arrayList.Add(ultraRECORD_NAME.Text.Trim());//记录名称........跟使用运行记录有关

                    arrayList.Add(ultraDEVICE_FILE.Text.Trim());//设备档案 跟设备的档案维护有关
                    arrayList.Add(txtFILE_LOCATION.Text.Trim());
                    arrayList.Add(ultraCAPITAL_SOURCE.Text.Trim());//资金来源 跟资产编号有关 不同的来源编号规则不同
                    arrayList.Add(chkISBELONG.Checked == true ? "是" : "否");//是否附属
                    arrayList.Add(chkSHOW_FLAG.Checked == true ? "不显示" : "显示");//显示标记

                    arrayList.Add(ultraPOINT_CHECK_STD.Text.Trim());//点检标准
                    arrayList.Add(txtPARA.Text.Trim());
                    arrayList.Add(ultraCERTIFICATE.Text.Trim());
                    arrayList.Add(ultraGRADE.Text.Trim());
                    arrayList.Add(txtPRECISION_RANGE.Text.Trim());//精度

                    arrayList.Add(ultraFIND_WAY.Text.Trim());//溯源
                    arrayList.Add(ultraCOUNTRY.Text.Trim());
                    arrayList.Add(txtCHANGE_RECORD.Text.Trim());//调拨记录
                    arrayList.Add(txtUSE_FUNCTION.Text.Trim());
                    arrayList.Add(txtREMARK.Text.Trim());//备注

                    arrayList.Add(UserInfo.GetUserName());//创建人

                    PublicServer.SetData("com.steering.lims.resource.device.FrmDmFixedAssetsDetail.UpdateFixedAssetsDetail",
new Object[] { strDEVICE_ID, arrayList }, this.ob);//strDEVICE_ID,

                    QueryFixedAssetsDetail();

                    PublicResource.ActiveOperateRow(ultraGrid1, "DEVICE_ID", strDEVICE_ID);//定位保存的行

                    MessageUtil.ShowTips("修改成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void DeleteFixedAssetsDetail()
        {
            try
            {
                //string strTips = IsValid();
                //if (strTips != "")
                //{
                //    MessageUtil.ShowWarning(strTips);
                //    return;
                //}
                if (ultraGrid1.ActiveRow == null)
                {
                    MessageUtil.ShowWarning("请选择一条需要删除的记录！");
                    return;
                }
                //资金来源为检测中心的资产编号 JCZX + 年 + 四位流水
                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                {
                    string strDEVICE_ID = txtDEVICE_ID.Text.Trim();

                    PublicServer.SetData("com.steering.lims.resource.device.FrmDmFixedAssetsDetail.DeleteFixedAssetsDetail",
new Object[] { strDEVICE_ID }, this.ob);//strDEVICE_ID,

                    QueryFixedAssetsDetail();

                    MessageUtil.ShowTips("删除成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ClearFixedAssetsDetail()
        {
            PublicResource.ClearBaseInfo(panel5, new string[] { "DEVICE_TYPE", "DEVICE_ID", "DEVICE_NAME", "SPEC", "DEVICE_NO", "MEASURE_UNIT", "DEVICE_COUNT", "CAPACITY", "WEIGHT", "START_PRICE", "MANUFACTURER", "FACTORY_TIME", "PRODUCT_TIME", "DEPT_ID", "DEPT_NAME", "ROOM_NO", "POINT_CHECK_STD", "PARA", "PRECISION_RANGE", "FIND_WAY", "REMARK", "CREATE_NAME", "CREATE_TIME" });
        }

        private void ExportFixedAssetsDetail()
        {
            ArrayList alUltraGrid = new ArrayList();//需要导出的GRID
            ArrayList alSheeft = new ArrayList();//Sheeft名称

            alUltraGrid.Add(ultraGrid1);

            alSheeft.Add("固定资产信息");
            if (ultraGrid1.Rows.Count == 0)
            {
                return;
            }

            GridHelper.ulGridToExcel(alUltraGrid, alSheeft, DateTime.Now.ToString("yyyyMM") + "固定资产信息");//导出excel
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            PublicResource.ShowBaseInfo(ultraGrid1.ActiveRow, panel5);
            ultraDEPT_ID.UltDept_ID = ultraGrid1.ActiveRow.Cells["DEPT_ID"].Text.Trim();
        }

        private void chkDEVICE_ID_CheckedChanged(object sender, EventArgs e)
        {
            txtQueryDEVICE_ID.Enabled = chkDEVICE_ID.Checked;
        }

        private void chkDEVICE_NAME_CheckedChanged(object sender, EventArgs e)
        {
            txtQueryDEVICE_NAME.Enabled = chkDEVICE_NAME.Checked;
        }

        private void chkDEVICE_TYPE_CheckedChanged(object sender, EventArgs e)
        {
            ultraQueryDEVICE_TYPE.Enabled = chkDEVICE_TYPE.Checked;
        }

        private void chkDEPT_ID_CheckedChanged(object sender, EventArgs e)
        {
            ultraQueryDEPT_ID.Enabled = chkDEPT_ID.Checked;
        }

        private void btnAuto_Click(object sender, EventArgs e)
        {
            try
            {
                if (ultraCAPITAL_SOURCE.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("资金来源不能为空！");
                    return;
                }

                //资金来源为检测中心的资产编号 JCZX + 年 + 四位流水
                DataTable dt = PublicServer.GetData("com.steering.lims.resource.device.FrmDmFixedAssetsDetail.QueryMaxDeviceId",
                new Object[] { ultraCAPITAL_SOURCE.Text.Trim() }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    txtDEVICE_ID.Text = "";
                    return;
                }
                txtDEVICE_ID.Text = dt.Rows[0]["DEVICE_ID"].ToString();
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        private void View_Click(object sender, EventArgs e)
        {
            UltraGridRow ur = ultraGrid1.ActiveRow;
            if (ur == null)
            {
                MessageUtil.ShowWarning("请选择一条需要查看上传文件的记录！");
                return;
            }

            if (ur.Cells["FILE_POSITION"].Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请先上传再查看！");
                return;
            }

            string strTableName = "RMDM_FIXEDASSETS_DETAIL";
            string strId = ur.Cells["DEVICE_ID"].Text.Trim();
            string path = "Lims/resource/file/" + this.Name + "/" + strId + "/";
            if (PublicResource.ViewFilePosition(this.ob, path) == false)
            {
                PublicResource.UpdateFilePosition(strTableName, "", "DEVICE_ID", strId, this.ob);//更改数据库存储路径
                QueryFixedAssetsDetail();
                PublicResource.ActiveOperateRow(ultraGrid1, "DEVICE_ID", strId);//定位保存的行
            }
        }

        private void Upload_Click(object sender, EventArgs e)
        {
            UltraGridRow ur = ultraGrid1.ActiveRow;

            if (ur == null)
            {
                MessageUtil.ShowWarning("请选择一条需要上传文件的记录！");
                return;
            }
            string strTableName = "RMDM_FIXEDASSETS_DETAIL";
            string strId = ur.Cells["DEVICE_ID"].Text.Trim();
            string path = "Lims/resource/file/" + this.Name + "/" + strId + "/";
            if (PublicResource.UploadFilePosition(this.ob, path))
            {
                PublicResource.UpdateFilePosition(strTableName, path, "DEVICE_ID", strId, this.ob);//更改数据库存储路径
                QueryFixedAssetsDetail();
                PublicResource.ActiveOperateRow(ultraGrid1, "DEVICE_ID", strId);//定位保存的行
            }
        }
    }
}