Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

沈泽

2021-08-20 e3ae7f17842fe7de358ced5398ef792a961f80eb

 DAL/»ù´¡×ÊÁÏ/InterFace»ù´¡×ÊÁÏ/ClsIF_Property_View.cs

@@ -2,6 +2,7 @@
using System.Collections.Generic;
using System.Text;
using System.Data;
using DBUtility;

namespace DAL
{
@@ -17,8 +18,10 @@
        public ClsIF_Property_View()
        {
            base.MvarReportTitle = "辅助属性设置";
            base.MvarItemKey = "h_v_IF_Property";
            base.SQLName = "Select HItemID,HNumber è¾…助属性代码,HName è¾…助属性 from h_v_IF_Property where HStopflag=0  ";
            base.MvarItemKey = "h_v_IF_PropertyByMaterID";
            base.SQLName = "Select HItemID,HNumber è¾…助属性代码,HName è¾…助属性 from h_v_IF_PropertyByMaterID ";
            base.SQLWhere = " where HStopflag=0 ";
            base.SQLOrder = " ";
            //下拉SQL
            base.SQLNameForDown = " Select top 30 HItemID,HNumber è¾…助属性代码,HName è¾…助属性 from h_v_IF_Property ";
            base.SQLOrderForDown = "  Order by HNumber ";
@@ -94,5 +97,71 @@
                throw (e);
            }
        }

        /// <summary>
        /// åŸºç¡€èµ„料帮助-全部型
        /// </summary>
        /// <returns></returns>
        public override bool RefreshView(string sLike)
        {
            try
            {//
                Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
                //
                string sSQL = SQLName + SQLWhere + sLike + SQLOrder;
                //编辑ofrm
                ofrm.sTitle = MvarReportTitle;
                ofrm.sBill = MvarItemKey;
                ofrm.txtFindInfo.Text = WherePart;

                //
                DataSet Ds;
                Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
                Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
                if (Ds == null || Ds.Tables[0].Rows.Count == 0)
                {
                    return false;
                }

                //绑定
                ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
                Ds.Dispose();
                Ds = null;
                ofrm.grdShow.SuspendLayout();
                ofrm.grdShow.Columns[0].Visible = false;
                ofrm.ShowDialog();
                //得到对应列 
                int HItemIDCol = 0;
                int HNumberCol = 1;
                int HNameCol = 2;
                //
                if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
                {
                    if (ofrm.grdShow.CurrentRow == null)
                    {
                        return false;
                    }
                    oModel = new ClsGy_Base_Model();
                    oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value);
                    oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value);
                    oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value);
                }
                else
                {
                    return false;
                }
                //
                ofrm.Dispose();
                ofrm = null;
                //
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }


    }
}