/// <summary> /// 3.2.7.删除不合格品记录 /// </summary> /// <param name="_list"></param> /// <param name="strTpeName">类型名称</param> private void DelBHGPJL(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.BuHeGePinJiLuInfo) { strIDList = strIDList + ((KPS.Model.BuHeGePinJiLuInfo)_obj).ID + ","; } } if (strIDList.Contains(",")) { strIDList = strIDList.Substring(0, strIDList.Length - 1); } if (strIDList.Length > 0) { KPS.BLL.BuHeGePinJiLuManager manager = new BLL.BuHeGePinJiLuManager(); 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 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); } } }
/// <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); }