private void btnOK_Click(object sender, EventArgs e) { if (cmbPlaneType.SelectedIndex == -1) { MessageBox.Show("请选择飞机型号!"); return; } if (cmbFailSystem.SelectedIndex == -1) { MessageBox.Show("请选择故障系统!"); return; } if (cmbTimePoint.SelectedIndex == -1) { MessageBox.Show("请选择故障时机!"); return; } BLL.fault_history fhBll = new BLL.fault_history(); Model.fault_history editFhModel = new Model.fault_history(); editFhModel.fh_id = editModel.fh_id; editFhModel.fh_adduser = editModel.fh_adduser; editFhModel.fh_addtime = editModel.fh_addtime; editFhModel.fh_caseid = editModel.fh_caseid; editFhModel.fh_cause = rchCause.Text; editFhModel.fh_description = rchtxtDescription.Text; editFhModel.fh_experience = rchTxtExperiance.Text; editFhModel.fh_explain = rchTxtExplain.Text; editFhModel.fh_keywd = txtKeyWds.Text.Trim(); editFhModel.fh_phenomenon = rchTxtPhnmn.Text; editFhModel.fh_reference = rchTxtReferance.Text; editFhModel.fh_suggest = rchTxtSuggest.Text; editFhModel.fh_title = txtTtl.Text; editFhModel.ptype_id = plnTypIdLst[cmbPlaneType.SelectedIndex]; editFhModel.system_id = flSysIdLst[cmbFailSystem.SelectedIndex]; editFhModel.tpoint_id = tmPntIdLst[cmbTimePoint.SelectedIndex]; fhBll.Update(editFhModel); MessageBox.Show("修改成功!"); BLL.v_fail_history vfhBll = new BLL.v_fail_history(); father.vfhList = vfhBll.GetModelList("fh_id=" + editFhModel.fh_id); father.ListViewLoadData(); this.Close(); }
private void btnOK_Click(object sender, EventArgs e) { if (cmbPlaneType.SelectedIndex == -1) { MessageBox.Show("请选择飞机型号!"); return; } if (cmbFailSystem.SelectedIndex == -1) { MessageBox.Show("请选择故障系统!"); return; } if (cmbTimePoint.SelectedIndex == -1) { MessageBox.Show("请选择故障时机!"); return; } BLL.fault_history fhBll = new BLL.fault_history(); Model.fault_history addFhModel = new Model.fault_history(); addFhModel.fh_addtime = DateTime.Now; addFhModel.fh_adduser = constants.currentUser.user_id; addFhModel.fh_caseid = fhBll.createCaseID(fhBll.getMaxCaseID()); addFhModel.fh_cause = rchCause.Text; addFhModel.fh_description = rchtxtDescription.Text; addFhModel.fh_experience = rchTxtExperiance.Text; addFhModel.fh_explain = rchTxtExplain.Text; addFhModel.fh_keywd = txtKeyWds.Text.Trim(); addFhModel.fh_phenomenon = rchTxtPhnmn.Text; addFhModel.fh_reference = rchTxtReferance.Text; addFhModel.fh_suggest = rchTxtSuggest.Text; addFhModel.fh_title = txtTtl.Text; addFhModel.ptype_id = plnTypIdLst[cmbPlaneType.SelectedIndex]; addFhModel.system_id = flSysIdLst[cmbFailSystem.SelectedIndex]; addFhModel.tpoint_id = tmPntIdLst[cmbTimePoint.SelectedIndex]; fhBll.Add(addFhModel); MessageBox.Show("添加成功!"); BLL.v_fail_history vfhBll = new BLL.v_fail_history(); father.vfhList = vfhBll.GetModelList("fh_phenomenon='" + addFhModel.fh_phenomenon + "' and fh_caseid='" + addFhModel.fh_caseid + "'"); father.ListViewLoadData(); this.Close(); }
private void initFaultHistory() { progressBar1.Value = 90; DataSet ds = LoadDataFromExcel(fileName, "故障案例库信息"); BLL.fault_history bll = new BLL.fault_history(); Model.fault_history model = new Model.fault_history(); BLL.time_point tpBll = new BLL.time_point(); BLL.fail_system fsBll = new BLL.fail_system(); BLL.plane_type ptBll = new BLL.plane_type(); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["案例编号"].ToString() == "") { return; } model.fh_addtime = DateTime.Now; model.fh_adduser = constants.currentUser.user_id; model.fh_caseid = dr["案例编号"].ToString(); model.fh_cause = dr["故障原因"].ToString(); model.fh_description = dr["相关描述"].ToString(); model.fh_experience = dr["经验教训"].ToString(); model.fh_explain = dr["解释"].ToString(); model.fh_keywd = dr["关键词"].ToString(); model.fh_phenomenon = dr["故障现象"].ToString(); model.fh_reference = dr["参考资料"].ToString(); model.fh_suggest = dr["维修建议"].ToString(); model.fh_title = dr["案例标题"].ToString(); model.ptype_id = ptBll.GetModel(dr["飞机型号"].ToString()).ptype_id; model.system_id = fsBll.GetModel(dr["故障系统"].ToString()).system_id; model.tpoint_id = tpBll.GetModel(dr["发生时机"].ToString()).tpoint_id; bll.Add(model); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(fds.Model.fault_history model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(fds.Model.fault_history model) { return(dal.Add(model)); }