/// <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); } } }