/// <summary>
        /// 7.处理不合格品记录
        /// </summary>
        private void ManagerBHGPJL()
        {
            bool bolState = false;

            try
            {
                KPS.Model.BuHeGePinJiLuInfo _Modelinfo = (KPS.Model.BuHeGePinJiLuInfo)_control.GetSaveData();
                _Modelinfo.DataType = thisdeviceinfo.DeviceID;

                KPS.BLL.BuHeGePinJiLuManager bhgpmanager = new BuHeGePinJiLuManager();
                if (ModelData != null)
                {
                    _Modelinfo.ID = ((BuHeGePinJiLuInfo)ModelData).ID;
                    bolState      = bhgpmanager.Update(_Modelinfo);
                }
                else
                {
                    bolState = bhgpmanager.Add(_Modelinfo);
                }
            }
            catch (Exception ex)
            {
                bolState = false;
            }

            ShowMsgStateInfo(bolState, ModelData);
        }
Beispiel #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string strBeginTime   = dateTimePicker1.Value.ToString("yyyy-MM-dd 00:00:00");
            string strEndTime     = dateTimePicker2.Value.ToString("yyyy-MM-dd 23:59:59");
            string strProductName = txtProductName.Text.Trim(); //去除空格,产品名称
            string strGYSName     = txtGYS.Text.Trim();         //去除空格,供应商
            string strSCSName     = txtSCS.Text.Trim();         //去除空格,生产/制造商

            string strWhereCondition = string.Format("(y_date>=#{0}# and y_date<=#{1}#)", strBeginTime, strEndTime);

            if (thisdevice != null && !string.IsNullOrEmpty(thisdevice.DeviceType))
            {
                strWhereCondition = strWhereCondition + string.Format(" and DataType={0}", thisdevice.DeviceID);
            }
            if (!string.IsNullOrEmpty(strSCSName))
            {
                strWhereCondition = strWhereCondition + string.Format(" and y_sccj like '%{0}%'", strSCSName);
            }
            if (!string.IsNullOrEmpty(strGYSName))
            {
                strWhereCondition = strWhereCondition + string.Format(" and y_ghdw like '%{0}%'", strGYSName);
            }
            if (!string.IsNullOrEmpty(strProductName))
            {
                strWhereCondition = strWhereCondition + string.Format(" and y_pm like '%{0}%'", strProductName);
            }

            BuHeGePinJiLuManager manager = new BuHeGePinJiLuManager();

            try
            {
                List <BuHeGePinJiLuInfo> listData = manager.GetModelList(strWhereCondition);

                if (ListLoadingEvent != null)
                {
                    ListLoadingEvent(listData, true, "获取记录列表成功!");
                }
            }
            catch (Exception ex)
            {
                if (ListLoadingEvent != null)
                {
                    ListLoadingEvent(null, false, ex.Message);
                }
            }
        }