/// <summary> /// 得到一个对象实体 /// </summary> public HR_Test.Model.Bend GetModel(string testSampleNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,testMethodID,testNo,testSampleNo,sendCompany,stuffCardNo,stuffSpec,stuffType,hotStatus,temperature,humidity,testStandard,testMethod,mathineType,testCondition,sampleCharacter,getSample,tester,assessor,sign,sampleType,testType,d,b,h,L,Ds,Da,R,t,Ls,Le,l_l,lt,m,n,a,f_bb,f_n,f_n1,f_rb,y,Fo,Fpb,Frb,Fbb,Fn,Fn1,Z,S,W,I,Eb,σpb,σrb,σbb,U,εpb,εrb,isFinish,isConformity,testDate,condition,controlmode,isUseExtensometer,isEffective from tb_Bend "); strSql.Append(" where testSampleNo=@testSampleNo"); OleDbParameter[] parameters = { new OleDbParameter("@testSampleNo", OleDbType.VarChar, 200) }; parameters[0].Value = testSampleNo; HR_Test.Model.Bend model = new HR_Test.Model.Bend(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model = DataRowToModel(ds.Tables[0].Rows[0]); return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public HR_Test.Model.Bend DataRowToModel(DataRow row) { HR_Test.Model.Bend model = new HR_Test.Model.Bend(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["testMethodID"] != null && row["testMethodID"].ToString() != "") { model.testMethodID = int.Parse(row["testMethodID"].ToString()); } if (row["testNo"] != null) { model.testNo = row["testNo"].ToString(); } if (row["testSampleNo"] != null) { model.testSampleNo = row["testSampleNo"].ToString(); } if (row["sendCompany"] != null) { model.sendCompany = row["sendCompany"].ToString(); } if (row["stuffCardNo"] != null) { model.stuffCardNo = row["stuffCardNo"].ToString(); } if (row["stuffSpec"] != null) { model.stuffSpec = row["stuffSpec"].ToString(); } if (row["stuffType"] != null) { model.stuffType = row["stuffType"].ToString(); } if (row["hotStatus"] != null) { model.hotStatus = row["hotStatus"].ToString(); } model.temperature = Convert.ToDouble(row["temperature"].ToString()); model.humidity = Convert.ToDouble(row["humidity"].ToString()); if (row["testStandard"] != null) { model.testStandard = row["testStandard"].ToString(); } if (row["testMethod"] != null) { model.testMethod = row["testMethod"].ToString(); } if (row["mathineType"] != null) { model.mathineType = row["mathineType"].ToString(); } if (row["testCondition"] != null) { model.testCondition = row["testCondition"].ToString(); } if (row["sampleCharacter"] != null) { model.sampleCharacter = row["sampleCharacter"].ToString(); } if (row["getSample"] != null) { model.getSample = row["getSample"].ToString(); } if (row["tester"] != null) { model.tester = row["tester"].ToString(); } if (row["assessor"] != null) { model.assessor = row["assessor"].ToString(); } if (row["sign"] != null) { model.sign = row["sign"].ToString(); } if (row["sampleType"] != null) { model.sampleType = row["sampleType"].ToString(); } if (row["testType"] != null) { model.testType = row["testType"].ToString(); } model.d = Convert.ToDouble(row["d"].ToString()); model.b = Convert.ToDouble(row["b"].ToString()); model.h = Convert.ToDouble(row["h"].ToString()); model.L = Convert.ToDouble(row["L"].ToString()); model.Ds = Convert.ToDouble(row["Ds"].ToString()); model.Da = Convert.ToDouble(row["Da"].ToString()); model.R = Convert.ToDouble(row["R"].ToString()); model.t = Convert.ToDouble(row["t"].ToString()); model.Ls = Convert.ToDouble(row["Ls"].ToString()); model.Le = Convert.ToDouble(row["Le"].ToString()); model.l_l = Convert.ToDouble(row["l_l"].ToString()); model.lt = Convert.ToDouble(row["lt"].ToString()); if (row["m"] != null && row["m"].ToString() != "") { model.m = int.Parse(row["m"].ToString()); } model.n = Convert.ToDouble(row["n"].ToString()); model.a = Convert.ToDouble(row["a"].ToString()); model.f_bb = Convert.ToDouble(row["f_bb"].ToString()); model.f_n = Convert.ToDouble(row["f_n"].ToString()); model.f_n1 = Convert.ToDouble(row["f_n1"].ToString()); model.f_rb = Convert.ToDouble(row["f_rb"].ToString()); model.y = Convert.ToDouble(row["y"].ToString()); model.Fo = Convert.ToDouble(row["Fo"].ToString()); model.Fpb = Convert.ToDouble(row["Fpb"].ToString()); model.Frb = Convert.ToDouble(row["Frb"].ToString()); model.Fbb = Convert.ToDouble(row["Fbb"].ToString()); model.Fn = Convert.ToDouble(row["Fn"].ToString()); model.Fn1 = Convert.ToDouble(row["Fn1"].ToString()); model.Z = Convert.ToDouble(row["Z"].ToString()); model.S = Convert.ToDouble(row["S"].ToString()); model.W = Convert.ToDouble(row["W"].ToString()); model.I = Convert.ToDouble(row["I"].ToString()); model.Eb = Convert.ToDouble(row["Eb"].ToString()); model.σpb = Convert.ToDouble(row["σpb"].ToString()); model.σrb = Convert.ToDouble(row["σrb"].ToString()); model.σbb = Convert.ToDouble(row["σbb"].ToString()); model.U = Convert.ToDouble(row["U"].ToString()); model.εpb = Convert.ToDouble(row["εpb"].ToString()); model.εrb = Convert.ToDouble(row["εrb"].ToString()); if (row["isFinish"] != null && row["isFinish"].ToString() != "") { if ((row["isFinish"].ToString() == "1") || (row["isFinish"].ToString().ToLower() == "true")) { model.isFinish = true; } else { model.isFinish = false; } } if (row["isConformity"] != null && row["isConformity"].ToString() != "") { if ((row["isConformity"].ToString() == "1") || (row["isConformity"].ToString().ToLower() == "true")) { model.isConformity = true; } else { model.isConformity = false; } } if (row["testDate"] != null && row["testDate"].ToString() != "") { model.testDate = DateTime.Parse(row["testDate"].ToString()); } if (row["condition"] != null) { model.condition = row["condition"].ToString(); } if (row["controlmode"] != null) { model.controlmode = row["controlmode"].ToString(); } if (row["isUseExtensometer"] != null && row["isUseExtensometer"].ToString() != "") { if ((row["isUseExtensometer"].ToString() == "1") || (row["isUseExtensometer"].ToString().ToLower() == "true")) { model.isUseExtensometer = true; } else { model.isUseExtensometer = false; } } if (row["isEffective"] != null && row["isEffective"].ToString() != "") { if ((row["isEffective"].ToString() == "1") || (row["isEffective"].ToString().ToLower() == "true")) { model.isEffective = true; } else { model.isEffective = false; } } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HR_Test.Model.Bend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Bend("); strSql.Append("testMethodID,testNo,testSampleNo,sendCompany,stuffCardNo,stuffSpec,stuffType,hotStatus,temperature,humidity,testStandard,testMethod,mathineType,testCondition,sampleCharacter,getSample,tester,assessor,sign,sampleType,testType,d,b,h,L,Ds,Da,R,t,Ls,Le,l_l,lt,m,n,a,f_bb,f_n,f_n1,f_rb,y,Fo,Fpb,Frb,Fbb,Fn,Fn1,Z,S,W,I,Eb,σpb,σrb,σbb,U,εpb,εrb,isFinish,isConformity,testDate,condition,controlmode,isUseExtensometer,isEffective)"); strSql.Append(" values ("); strSql.Append("@testMethodID,@testNo,@testSampleNo,@sendCompany,@stuffCardNo,@stuffSpec,@stuffType,@hotStatus,@temperature,@humidity,@testStandard,@testMethod,@mathineType,@testCondition,@sampleCharacter,@getSample,@tester,@assessor,@sign,@sampleType,@testType,@d,@b,@h,@L,@Ds,@Da,@R,@t,@Ls,@Le,@l_l,@lt,@m,@n,@a,@f_bb,@f_n,@f_n1,@f_rb,@y,@Fo,@Fpb,@Frb,@Fbb,@Fn,@Fn1,@Z,@S,@W,@I,@Eb,@σpb,@σrb,@σbb,@U,@εpb,@εrb,@isFinish,@isConformity,@testDate,@condition,@controlmode,@isUseExtensometer,@isEffective)"); OleDbParameter[] parameters = { new OleDbParameter("@testMethodID", OleDbType.Integer, 4), new OleDbParameter("@testNo", OleDbType.VarChar, 100), new OleDbParameter("@testSampleNo", OleDbType.VarChar, 100), new OleDbParameter("@sendCompany", OleDbType.VarChar, 100), new OleDbParameter("@stuffCardNo", OleDbType.VarChar, 100), new OleDbParameter("@stuffSpec", OleDbType.VarChar, 100), new OleDbParameter("@stuffType", OleDbType.VarChar, 100), new OleDbParameter("@hotStatus", OleDbType.VarChar, 100), new OleDbParameter("@temperature", OleDbType.Double), new OleDbParameter("@humidity", OleDbType.Double), new OleDbParameter("@testStandard", OleDbType.VarChar, 100), new OleDbParameter("@testMethod", OleDbType.VarChar, 100), new OleDbParameter("@mathineType", OleDbType.VarChar, 100), new OleDbParameter("@testCondition", OleDbType.VarChar, 100), new OleDbParameter("@sampleCharacter", OleDbType.VarChar, 100), new OleDbParameter("@getSample", OleDbType.VarChar, 100), new OleDbParameter("@tester", OleDbType.VarChar, 100), new OleDbParameter("@assessor", OleDbType.VarChar, 100), new OleDbParameter("@sign", OleDbType.VarChar, 255), new OleDbParameter("@sampleType", OleDbType.VarChar, 255), new OleDbParameter("@testType", OleDbType.VarChar, 255), new OleDbParameter("@d", OleDbType.Double), new OleDbParameter("@b", OleDbType.Double), new OleDbParameter("@h", OleDbType.Double), new OleDbParameter("@L", OleDbType.Double), new OleDbParameter("@Ds", OleDbType.Double), new OleDbParameter("@Da", OleDbType.Double), new OleDbParameter("@R", OleDbType.Double), new OleDbParameter("@t", OleDbType.Double), new OleDbParameter("@Ls", OleDbType.Double), new OleDbParameter("@Le", OleDbType.Double), new OleDbParameter("@l_l", OleDbType.Double), new OleDbParameter("@lt", OleDbType.Double), new OleDbParameter("@m", OleDbType.Integer, 4), new OleDbParameter("@n", OleDbType.Double), new OleDbParameter("@a", OleDbType.Double), new OleDbParameter("@f_bb", OleDbType.Double), new OleDbParameter("@f_n", OleDbType.Double), new OleDbParameter("@f_n1", OleDbType.Double), new OleDbParameter("@f_rb", OleDbType.Double), new OleDbParameter("@y", OleDbType.Double), new OleDbParameter("@Fo", OleDbType.Double), new OleDbParameter("@Fpb", OleDbType.Double), new OleDbParameter("@Frb", OleDbType.Double), new OleDbParameter("@Fbb", OleDbType.Double), new OleDbParameter("@Fn", OleDbType.Double), new OleDbParameter("@Fn1", OleDbType.Double), new OleDbParameter("@Z", OleDbType.Double), new OleDbParameter("@S", OleDbType.Double), new OleDbParameter("@W", OleDbType.Double), new OleDbParameter("@I", OleDbType.Double), new OleDbParameter("@Eb", OleDbType.Double), new OleDbParameter("@σpb", OleDbType.Double), new OleDbParameter("@σrb", OleDbType.Double), new OleDbParameter("@σbb", OleDbType.Double), new OleDbParameter("@U", OleDbType.Double), new OleDbParameter("@εpb", OleDbType.Double), new OleDbParameter("@εrb", OleDbType.Double), new OleDbParameter("@isFinish", OleDbType.Boolean, 1), new OleDbParameter("@isConformity", OleDbType.Boolean, 1), new OleDbParameter("@testDate", OleDbType.Date), new OleDbParameter("@condition", OleDbType.VarChar, 255), new OleDbParameter("@controlmode", OleDbType.VarChar, 255), new OleDbParameter("@isUseExtensometer", OleDbType.Boolean, 1), new OleDbParameter("@isEffective", OleDbType.Boolean, 1), }; parameters[0].Value = model.testMethodID; parameters[1].Value = model.testNo; parameters[2].Value = model.testSampleNo; parameters[3].Value = model.sendCompany; parameters[4].Value = model.stuffCardNo; parameters[5].Value = model.stuffSpec; parameters[6].Value = model.stuffType; parameters[7].Value = model.hotStatus; parameters[8].Value = model.temperature; parameters[9].Value = model.humidity; parameters[10].Value = model.testStandard; parameters[11].Value = model.testMethod; parameters[12].Value = model.mathineType; parameters[13].Value = model.testCondition; parameters[14].Value = model.sampleCharacter; parameters[15].Value = model.getSample; parameters[16].Value = model.tester; parameters[17].Value = model.assessor; parameters[18].Value = model.sign; parameters[19].Value = model.sampleType; parameters[20].Value = model.testType; parameters[21].Value = model.d; parameters[22].Value = model.b; parameters[23].Value = model.h; parameters[24].Value = model.L; parameters[25].Value = model.Ds; parameters[26].Value = model.Da; parameters[27].Value = model.R; parameters[28].Value = model.t; parameters[29].Value = model.Ls; parameters[30].Value = model.Le; parameters[31].Value = model.l_l; parameters[32].Value = model.lt; parameters[33].Value = model.m; parameters[34].Value = model.n; parameters[35].Value = model.a; parameters[36].Value = model.f_bb; parameters[37].Value = model.f_n; parameters[38].Value = model.f_n1; parameters[39].Value = model.f_rb; parameters[40].Value = model.y; parameters[41].Value = model.Fo; parameters[42].Value = model.Fpb; parameters[43].Value = model.Frb; parameters[44].Value = model.Fbb; parameters[45].Value = model.Fn; parameters[46].Value = model.Fn1; parameters[47].Value = model.Z; parameters[48].Value = model.S; parameters[49].Value = model.W; parameters[50].Value = model.I; parameters[51].Value = model.Eb; parameters[52].Value = model.σpb; parameters[53].Value = model.σrb; parameters[54].Value = model.σbb; parameters[55].Value = model.U; parameters[56].Value = model.εpb; parameters[57].Value = model.εrb; parameters[58].Value = model.isFinish; parameters[59].Value = model.isConformity; parameters[60].Value = model.testDate; parameters[61].Value = model.condition; parameters[62].Value = model.controlmode; parameters[63].Value = model.isUseExtensometer; parameters[64].Value = model.isEffective; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
//private void b_caculate_Click(object sender, EventArgs e) //{ // //矩形试样 // if (rbtnB1.Checked) // { // if (b_h.Text.Trim().Length > 0 && b_b.Text.Trim().Length > 0) // { // this.b_S0.Text = (double.Parse(b_h.Text.Trim()) * double.Parse(b_b.Text.Trim())).ToString("0.0000"); // } // } //} private void gBtnAddB_Click(object sender, EventArgs e) { string strErr = ""; if (this.b_testNo.Text.Trim().Length == 0) { strErr += "试验编号不能为空!\r\n"; } if (this.b_testSampleNo.Text.Trim().Length == 0) { strErr += "试样编号不能为空!\r\n"; } if (string.IsNullOrEmpty(this._sendCompany)) { strErr += "送检单位不能为空!\r\n"; } if (this.b_stuffCardNo.Text.Trim().Length == 0) { strErr += "材料牌号不能为空!\r\n"; } if (this.b_stuffSpec.Text.Trim().Length == 0) { strErr += "材料规格不能为空!\r\n"; } if (this.b_stuffType.Text.Trim().Length == 0) { strErr += "材料类型不能为空!\r\n"; } if (string.IsNullOrEmpty(this._temperature)) { strErr += "试验温度不能为空!\r\n"; } if (string.IsNullOrEmpty(this._condition)) { strErr += "试验条件不能为空!\r\n"; } if (string.IsNullOrEmpty(this._controlMode)) { strErr += "控制方式不能为空!\r\n"; } if (this.b_testMethod.Text.Trim().Length == 0) { strErr += "试验方法不能为空!\r\n"; } if (string.IsNullOrEmpty(this._sampleCharacter)) { strErr += "试样标识不能为空!\r\n"; } if (this.b_getSample.Text.Trim().Length == 0) { strErr += "试样取样不能为空!\r\n"; } if (this.b_tester.Text.Trim().Length == 0) { strErr += "试验员不能为空!\r\n"; } if (rbtnB1.Checked) { if (this.b_h.Text.Trim().Length == 0) { strErr += "h不能为空!\r\n"; } else { if (double.Parse(this.b_h.Text.Trim()) == 0d) { strErr += "h 不能为0!\r\n"; } } if (this.b_b.Text.Trim().Length == 0) { strErr += "b不能为空!\r\n"; } else { if (double.Parse(this.b_b.Text.Trim()) == 0d) { strErr += "b 不能为0!\r\n"; } } } if (rbtnB2.Checked) { if (this.b_d.Text.Trim().Length == 0) { strErr += "d不能为空!\r\n"; } else { if (double.Parse(this.b_d.Text.Trim()) == 0d) { strErr += "d 不能为0!\r\n"; } } } if (this.b_L.Text.Trim().Length == 0) { strErr += "L 不能为空!\r\n\r\n"; } else { if (double.Parse(this.b_L.Text.Trim()) == 0d) { strErr += "L 不能为0!\r\n\r\n"; } } if (this.b_Ls.Text.Trim().Length == 0) { strErr += "Ls 不能为空!\r\n\r\n"; } else { if (double.Parse(this.b_Ls.Text.Trim()) == 0d) { strErr += "Ls 不能为0!\r\n\r\n"; } } if (this.b_n.Text.Trim().Length == 0) { strErr += "n 不能为空!\r\n\r\n"; } else { if (double.Parse(this.b_n.Text.Trim()) == 0d) { strErr += "n 不能为0!\r\n\r\n"; } } if (this.b_εpb.Text.Trim().Length == 0) { strErr += "εpb 不能为空!\r\n\r\n"; } else { //if (double.Parse(this.b_εpb.Text.Trim()) == 0d) //{ // strErr += "εpb 不能为0!\r\n\r\n"; //} } if (this.b_εrb.Text.Trim().Length == 0) { strErr += "εrb 不能为空!\r\n\r\n"; } else { //if (double.Parse(this.b_εrb.Text.Trim()) == 0d) //{ // strErr += "εrb 不能为0!\r\n\r\n"; //} } if (this.cmbBendType.SelectedIndex == -1) { strErr += "请选择弯曲类型!\r\n;"; } //if (this.b_S0.Text.Trim().Length == 0) //{ // strErr += "S0不能为空!\r\n\r\n"; //} //else //{ // if (double.Parse(this.b_S0.Text.Trim()) == 0d) // { // strErr += "S0不能为0!\r\n\r\n"; // } //} switch (cmbBendType.SelectedIndex) { case 0: //三点弯曲 break; case 1: //四点弯曲 if (this.b_ll.Text.Trim().Length == 0) { strErr += "力臂不能为空!\r\n\r\n"; } else { if (double.Parse(this.b_ll.Text.Trim()) == 0d) { strErr += "力臂不能为0!\r\n\r\n"; } } break; } if (strErr != "") { MessageBox.Show(this, strErr); return; } HR_Test.Model.Bend model = new HR_Test.Model.Bend(); model.testNo = this.b_testNo.Text; model.testSampleNo = this.b_testSampleNo.Text; model.testMethodID = 0; model.sendCompany = this._sendCompany; model.stuffCardNo = this.b_stuffCardNo.Text; model.stuffSpec = b_stuffSpec.Text; model.stuffType = b_stuffType.Text; model.hotStatus = this._hotStatus; model.temperature = double.Parse(this._temperature); model.humidity = double.Parse(this._humidity); model.testStandard = this._testStandard_B.Text; model.testMethod = b_testMethod.Text; model.mathineType = b_mathineType.Text; model.testCondition = "-"; model.sampleCharacter = this._sampleCharacter; model.getSample = b_getSample.Text; model.tester = b_tester.Text; model.assessor = "-"; model.sign = this.b_sign.Text; model.testType = this.cmbBendType.Text; model.d = Convert.ToDouble(!string.IsNullOrEmpty(this.b_d.Text) ? this.b_d.Text : "0"); model.b = Convert.ToDouble(!string.IsNullOrEmpty(this.b_b.Text) ? this.b_b.Text : "0"); model.h = Convert.ToDouble(!string.IsNullOrEmpty(this.b_h.Text) ? this.b_h.Text : "0"); model.L = Convert.ToDouble(!string.IsNullOrEmpty(this.b_L.Text) ? this.b_L.Text : "0"); model.Ds = this._b_Ds; model.Da = this._b_Da; model.R = this._b_R; model.t = 0; model.Ls = Convert.ToDouble(!string.IsNullOrEmpty(this.b_Ls.Text) ? this.b_Ls.Text : "0"); model.Le = Convert.ToDouble(!string.IsNullOrEmpty(this.b_Le.Text) ? this.b_Le.Text : "0"); model.l_l = Convert.ToDouble(!string.IsNullOrEmpty(this.b_ll.Text) ? this.b_ll.Text : "0"); model.lt = 0; model.m = this._b_m; model.n = Convert.ToDouble(!string.IsNullOrEmpty(this.b_n.Text) ? this.b_n.Text : "0"); model.a = this._b_a; model.εpb = Convert.ToDouble(!string.IsNullOrEmpty(this.b_εpb.Text) ? this.b_εpb.Text : "0"); model.εrb = Convert.ToDouble(!string.IsNullOrEmpty(this.b_εrb.Text) ? this.b_εrb.Text : "0"); model.y = 0; //试验结果 if (this.rbtnB1.Checked) { model.sampleType = "矩形"; model.W = (double)Math.Round((decimal)(model.b * model.h * model.h / 6.0), 3); //bh²/6 model.I = (double)Math.Round((decimal)(model.b * model.h * model.h * model.h / 12), 3); //bh³/12 } else if (this.rbtnB2.Checked) { model.sampleType = "圆柱形"; model.W = (double)Math.Round((decimal)(Math.PI * model.d * model.d * model.d / 32), 3); model.I = (double)Math.Round((decimal)(Math.PI * model.d * model.d * model.d * model.d / 64.0), 3); } model.f_bb = 0; model.f_n = 0; model.f_n1 = 0; model.f_rb = 0; model.Fo = 0; model.Fpb = 0; model.Frb = 0; model.Fbb = 0; model.Fn = 0; model.Fn1 = 0; model.Z = 0; model.S = 0; model.Eb = 0; model.σpb = 0; model.σrb = 0; model.σbb = 0; model.U = 0; //----------- model.isFinish = false; model.isConformity = false; model.testDate = this.b_testDate.Value.Date; model.condition = this._condition; model.controlmode = this._controlMode; model.isUseExtensometer = false; model.isEffective = false; BLL.Bend bllc = new HR_Test.BLL.Bend(); if (bllc.GetList("testSampleNo ='" + this.b_testSampleNo.Text + "'").Tables[0].Rows.Count == 0) { bllc.Add(model); this.b_testSampleNo.Items.Remove(this.b_testSampleNo.SelectedItem); this.b_h.Text = "0"; this.b_b.Text = "0"; MessageBox.Show(this, "添加试样信息成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(this, "已经存在相同的编号,请重新设置!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //TestStandard.MethodControl.ReadMethod(this.treeviewTestMethod); }