Beispiel #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);
        }
        /// <summary>
        /// 3.2.8.删除不良事件记录
        /// </summary>
        /// <param name="_list"></param>
        /// <param name="strTpeName">类型名称</param>
        private void DelBLSJ(System.Collections.IList _list, string strTpeName)
        {
            if (new ConfirmFrm("确认删除", string.Format("您确定需要删除所选的 {0} 条【{1}】记录?", _list.Count, strTpeName), "是", "否", 3).ShowDialog() == DialogResult.OK)
            {
                string strIDList = "";
                foreach (object _obj in _list)
                {
                    if (_obj is KPS.Model.BuLiangShiJianInfo)
                    {
                        strIDList = strIDList + ((KPS.Model.BuLiangShiJianInfo)_obj).ID + ",";
                    }
                }
                if (strIDList.Contains(","))
                {
                    strIDList = strIDList.Substring(0, strIDList.Length - 1);
                }

                if (strIDList.Length > 0)
                {
                    KPS.BLL.BuLiangShiJianManager manager = new BLL.BuLiangShiJianManager();
                    if (manager.DeleteList(strIDList))
                    {
                        MessageBox.Show("删除成功!");
                        this.RecordListView.RemoveObjects(_list);
                    }
                    else
                    {
                        MessageBox.Show("删除失败!");
                    }
                }
            }
        }
        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);
                }
            }
        }