Esempio n. 1
0
        /// <summary>
        /// 8.不良事件
        /// </summary>
        private void ManagerBLSJ()
        {
            bool bolState = false;

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

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

            ShowMsgStateInfo(bolState, ModelData);
        }
        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 strSYDWName    = txtGYS.Text.Trim();         //去除空格,使用单位
            string strSCSName     = txtSCS.Text.Trim();         //去除空格,生产/制造商

            string strWhereCondition = string.Format("(b_bgsj>=#{0}# and b_bgsj<=#{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 b_sccj like '%{0}%'", strSCSName);
            }
            if (!string.IsNullOrEmpty(strSYDWName))
            {
                strWhereCondition = strWhereCondition + string.Format(" and b_sydw like '%{0}%'", strSYDWName);
            }
            if (!string.IsNullOrEmpty(strProductName))
            {
                strWhereCondition = strWhereCondition + string.Format(" and b_ylqxmc like '%{0}%'", strProductName);
            }

            BuLiangShiJianManager manager = new BuLiangShiJianManager();

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

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