//选择记录 public override bool SelectRecord() { try { macls = new MaterialCls(); int[] rows = gridView1.GetSelectedRows(); macls = (MaterialCls)gridView1.GetRow(rows[0]); this.txtMaterialName.Text = macls.MaterialName; this.txtElasticModulus.Text = macls.ElasticModulus.ToString(); this.txtTensileStrength.Text = macls.TensileStrength.ToString(); this.txtYieldSrength.Text = macls.YieldSrength.ToString(); this.txtReductionOfArea.Text = macls.ReductionOfArea.ToString(); this.txtUltimateElongation.Text = macls.UltimateElongation.ToString(); this.txtHardenablityValue.Text = macls.HardenablityValue.ToString(); this.txtStrainOfWidthAndThickness.Text = macls.StrainOfWidthAndThickness.ToString(); //macls.TensileStrength = Convert.ToDouble(this.txtTensileStrength.Text.ToString()); //macls.YieldSrength = Convert.ToDouble(this.txtYieldSrength.Text.ToString()); //macls.UltimateElongation = Convert.ToDouble(this.txtUltimateElongation.Text.ToString()); //macls.ReductionOfArea = Convert.ToDouble(this.txtReductionOfArea.Text.ToString()); //macls.HardenablityValue = Convert.ToDouble(this.txtHardenablityValue.Text.ToString()); //macls.StrainOfWidthAndThickness = Convert.ToDouble(this.txtStrainOfWidthAndThickness.Text.ToString()); return(true); } catch (System.Exception ex) { return(false); } }
//删除 public override bool DeleteData() { try { if (XtraMessageBox.Show("是否删除选中的数据?", "友情提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { macls = new MaterialCls(); int[] rows = gridView1.GetSelectedRows(); for (int i = 0; i < rows.Length; i++) { macls = (MaterialCls)gridView1.GetRow(rows[i]); MaterialDAL.DeleteMaterialById(macls.Id); } } //QueryAll(); init_cmbBox(); return(true); } catch (System.Exception ex) { return(false); } }
public MaterialFrm() { InitializeComponent(); this.layoutControlGroup1.Enabled = false; macls = new MaterialCls(); maList = new List <MaterialCls>(); init_cmbBox(); }
public static int ModifyMaterialByid(MaterialCls _mac) { using (HullShellContainer hs = new HullShellContainer()) { Material mal = hs.MaterialSet.Where(m => m.Id == _mac.Id).FirstOrDefault(); mal.MaterialName = _mac.MaterialName; mal.ElasticModulus = _mac.ElasticModulus; mal.YieldSrength = _mac.YieldSrength; mal.TensileStrength = _mac.TensileStrength; mal.UltimateElongation = _mac.UltimateElongation; mal.ReductionOfArea = _mac.ReductionOfArea; mal.HardenablityValue = _mac.HardenablityValue; mal.StrainOfWidthAndThickness = _mac.StrainOfWidthAndThickness; return(hs.SaveChanges()); } }
public override bool RefreshData() { try { string UserName = this.ItemObjectList.EditValue.ToString(); MaterialCls val = MaterialDAL.QueryMaterialByName(UserName); MaterialBindingSource.DataSource = val; gridControl1.DataSource = MaterialBindingSource; return(true); } catch (System.Exception ex) { return(false); } }
//增加 public static int AddMaterial(MaterialCls _mac) { using (HullShellContainer hs = new HullShellContainer()) { Material mal = new Material { MaterialName = _mac.MaterialName, ElasticModulus = _mac.ElasticModulus, YieldSrength = _mac.YieldSrength, TensileStrength = _mac.TensileStrength, UltimateElongation = _mac.UltimateElongation, ReductionOfArea = _mac.ReductionOfArea, HardenablityValue = _mac.HardenablityValue, StrainOfWidthAndThickness = _mac.StrainOfWidthAndThickness }; hs.AddToMaterialSet(mal); return(hs.SaveChanges()); } }
//查询 public static MaterialCls QueryMaterialByName(string _name) { using (HullShellContainer hs = new HullShellContainer()) { Material mal = hs.MaterialSet.Where(m => m.MaterialName == _name).FirstOrDefault(); MaterialCls _mac = new MaterialCls(); _mac.Id = mal.Id; _mac.MaterialName = mal.MaterialName; _mac.ElasticModulus = mal.ElasticModulus; _mac.YieldSrength = mal.YieldSrength; _mac.TensileStrength = mal.TensileStrength; _mac.UltimateElongation = mal.UltimateElongation; _mac.ReductionOfArea = mal.ReductionOfArea; _mac.HardenablityValue = mal.HardenablityValue; _mac.StrainOfWidthAndThickness = mal.StrainOfWidthAndThickness; return(_mac); } }
//保存 public override bool SaveDataA() { try { if (AddorModify == AddOrModifyEnum.Add) { macls = new MaterialCls(); macls.MaterialName = this.txtMaterialName.Text.ToString(); macls.ElasticModulus = Convert.ToDouble(this.txtElasticModulus.Text.ToString()); macls.TensileStrength = Convert.ToDouble(this.txtTensileStrength.Text.ToString()); macls.YieldSrength = Convert.ToDouble(this.txtYieldSrength.Text.ToString()); macls.UltimateElongation = Convert.ToDouble(this.txtUltimateElongation.Text.ToString()); macls.ReductionOfArea = Convert.ToDouble(this.txtReductionOfArea.Text.ToString()); macls.HardenablityValue = Convert.ToDouble(this.txtHardenablityValue.Text.ToString()); macls.StrainOfWidthAndThickness = Convert.ToDouble(this.txtStrainOfWidthAndThickness.Text.ToString()); int re = MaterialDAL.AddMaterial(macls); if (re > 0) { MaterialBindingSource.DataSource = macls; this.gridControl1.DataSource = MaterialBindingSource; this.layoutControlGroup1.Enabled = false; this.txtMaterialName.Text = ""; this.txtElasticModulus.Text = ""; this.txtTensileStrength.Text = ""; this.txtYieldSrength.Text = ""; this.txtUltimateElongation.Text = ""; this.txtReductionOfArea.Text = ""; this.txtHardenablityValue.Text = ""; this.txtStrainOfWidthAndThickness.Text = ""; init_cmbBox(); MessageBox.Show("材料信息增加成功!"); return(true); } else { MessageBox.Show("材料信息增加失败!"); return(false); } } else if (AddorModify == AddOrModifyEnum.Modify) { macls.MaterialName = this.txtMaterialName.Text.ToString(); macls.ElasticModulus = Convert.ToDouble(this.txtElasticModulus.Text.ToString()); macls.TensileStrength = Convert.ToDouble(this.txtTensileStrength.Text.ToString()); macls.YieldSrength = Convert.ToDouble(this.txtYieldSrength.Text.ToString()); macls.UltimateElongation = Convert.ToDouble(this.txtUltimateElongation.Text.ToString()); macls.ReductionOfArea = Convert.ToDouble(this.txtReductionOfArea.Text.ToString()); macls.HardenablityValue = Convert.ToDouble(this.txtHardenablityValue.Text.ToString()); macls.StrainOfWidthAndThickness = Convert.ToDouble(this.txtStrainOfWidthAndThickness.Text.ToString()); MaterialDAL.ModifyMaterialByid(macls); this.layoutControlGroup1.Enabled = false; init_cmbBox(); return(true); } else { MessageBox.Show("材料信息添加/修改失败!"); return(false); } } catch (System.Exception ex) { MessageBox.Show("材料信息添加失败:{0}!", ex.Message.ToString()); return(false); } }