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