/// <summary> /// 得到一个对象实体 /// </summary> public HR_Test.Model.GBT282892012_Twist GetModel(string testSampleNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,testMethodName,testNo,testSampleNo,reportNo,sendCompany,stuffCardNo,stuffSpec,stuffType,hotStatus,temperature,humidity,testStandard,testMethod,mathineType,testCondition,sampleCharacter,getSample,tester,assessor,sign,L,S0,L0,L1,L2,FMmax,M,isFinish,testDate,condition,controlmode,isUseExtensometer,isEffective from tb_GBT282892012_Twist "); strSql.Append(" where testSampleNo=@testSampleNo"); OleDbParameter[] parameters = { new OleDbParameter("@testSampleNo", OleDbType.VarChar) }; parameters[0].Value = testSampleNo; HR_Test.Model.GBT282892012_Twist model = new HR_Test.Model.GBT282892012_Twist(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void gBtnAddTestSample_Click(object sender, EventArgs e) { string strErr = ""; if (this._testNo.Text.Trim().Length == 0) { strErr += "'试验编号'不能为空!\r\n\r\n"; } if (this._testSampleNo.Text.Trim().Length == 0) { strErr += "'试样编号'不能为空!\r\n\r\n"; } if (string.IsNullOrEmpty(this._sendCompany)) { strErr += "'送检单位'不能为空!\r\n\r\n"; } if (this._stuffCardNo.Text.Trim().Length == 0) { strErr += "'材料牌号'不能为空!\r\n\r\n"; } if (this._stuffSpec.Text.Trim().Length == 0) { strErr += "'材料规格'不能为空!\r\n\r\n"; } if (this._stuffType.Text.Trim().Length == 0) { strErr += "'试样类型'不能为空!\r\n\r\n"; } if (string.IsNullOrEmpty(this._temperature)) { strErr += "'试验温度'不能为空!\r\n\r\n"; } if (string.IsNullOrEmpty(this._condition)) { strErr += "'试验条件'不能为空!\r\n\r\n"; } if (string.IsNullOrEmpty(this._controlMode)) { strErr += "'控制方式'不能为空!\r\n\r\n"; } if (this._testMethod.Text.Trim().Length == 0) { strErr += "'试验方法'不能为空!\r\n\r\n"; } if (string.IsNullOrEmpty(this._sampleCharacter)) { strErr += "'试样标识'不能为空!\r\n\r\n"; } if (this._getSample.Text.Trim().Length == 0) { strErr += "'试样取样'不能为空!\r\n\r\n"; } if (this._tester.Text.Trim().Length == 0) { strErr += "'试验员'不能为空!\r\n\r\n"; } if (this._L.Text.Trim().Length == 0) { strErr += "'L'不能为空!\r\n\r\n"; } else { if (double.Parse(this._L.Text.Trim()) == 0d) { strErr += "'L'不能为0!\r\n\r\n"; } } if (this._L1.Text.Trim().Length == 0) { strErr += "'L1'不能为空!\r\n\r\n"; } else { if (double.Parse(this._L1.Text.Trim()) == 0d) { strErr += "'L1'不能为0!\r\n\r\n"; } } if (this._L2.Text.Trim().Length == 0) { strErr += "'L2'不能为空!\r\n\r\n"; } else { if (double.Parse(this._L2.Text.Trim()) == 0d) { strErr += "'L2'不能为0!\r\n\r\n"; } } if (strErr != "") { MessageBox.Show(this, strErr); return; } string testNo = this._testNo.Text; string testSampleNo = this._testSampleNo.Text; string sendCompany = this._sendCompany; string stuffCardNo = this._stuffCardNo.Text; string stuffSpec = this._stuffSpec.Text; string stuffType = this._stuffType.Text; string hotStatus = this._hotStatus; string temperature = this._temperature; string humidity = this._humidity; string testStandard = this._testStandard.Text; string testMethod = this._testMethod.Text; string mathineType = this._mathineType.Text; string sampleCharacter = this._sampleCharacter; string getSample = this._getSample.Text; string tester = this._tester.Text; Model.GBT282892012_Twist model = new HR_Test.Model.GBT282892012_Twist(); model.testMethodName = this._testMethod.Text; model.testNo = testNo; model.testSampleNo = testSampleNo; model.reportNo = "-"; model.sendCompany = sendCompany; model.stuffCardNo = stuffCardNo; model.stuffSpec = stuffSpec; model.stuffType = stuffType; model.hotStatus = hotStatus; model.temperature = double.Parse(this._temperature); model.humidity = 0; model.testStandard = testStandard; model.testMethod = testMethod; model.mathineType = mathineType; model.testCondition = "-"; model.sampleCharacter = sampleCharacter; model.getSample = getSample; model.tester = tester; model.assessor = "-"; model.L = Convert.ToDouble(this._L.Text.Trim()); model.L1 = Convert.ToDouble(this._L1.Text.Trim()); model.L2 = Convert.ToDouble(this._L2.Text.Trim()); model.L0 = model.L1 / 2 + model.L2;//力矩 model.S0 = 0; model.FMmax = 0; model.M = 0; model.sign = this._sign.Text; model.isEffective = false; model.isFinish = false; //是否使用引申计根据试验方法确定 model.isUseExtensometer = false; model.testDate = this._testDate.Value.Date; model.condition = this._condition; model.controlmode = this._controlMode; BLL.GBT282892012_Twist bll = new BLL.GBT282892012_Twist(); if (bll.GetList("testSampleNo ='" + this._testSampleNo.Text + "'").Tables[0].Rows.Count == 0) { bll.Add(model); this._testSampleNo.Items.Remove(this._testSampleNo.SelectedItem); MessageBox.Show(this, "添加试样信息成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(this, "已经存在相同的编号,请重新设置!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } }
/// <summary> /// 得到一个对象实体 /// </summary> public HR_Test.Model.GBT282892012_Twist DataRowToModel(DataRow row) { HR_Test.Model.GBT282892012_Twist model = new HR_Test.Model.GBT282892012_Twist(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["testMethodName"] != null) { model.testMethodName = row["testMethodName"].ToString(); } if (row["testNo"] != null) { model.testNo = row["testNo"].ToString(); } if (row["testSampleNo"] != null) { model.testSampleNo = row["testSampleNo"].ToString(); } if (row["reportNo"] != null) { model.reportNo = row["reportNo"].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(); } model.L = Convert.ToDouble(row["L"].ToString()); model.S0 = Convert.ToDouble(row["S0"].ToString()); model.L0 = Convert.ToDouble(row["L0"].ToString()); model.L1 = Convert.ToDouble(row["L1"].ToString()); model.L2 = Convert.ToDouble(row["L2"].ToString()); model.FMmax = Convert.ToDouble(row["FMmax"].ToString()); if (row["M"] != null && row["M"].ToString() != "") { model.M = Convert.ToDouble(row["M"].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["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.GBT282892012_Twist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_GBT282892012_Twist("); strSql.Append("testMethodName,testNo,testSampleNo,reportNo,sendCompany,stuffCardNo,stuffSpec,stuffType,hotStatus,temperature,humidity,testStandard,testMethod,mathineType,testCondition,sampleCharacter,getSample,tester,assessor,sign,L,S0,L0,L1,L2,FMmax,M,isFinish,testDate,condition,controlmode,isUseExtensometer,isEffective)"); strSql.Append(" values ("); strSql.Append("@testMethodName,@testNo,@testSampleNo,@reportNo,@sendCompany,@stuffCardNo,@stuffSpec,@stuffType,@hotStatus,@temperature,@humidity,@testStandard,@testMethod,@mathineType,@testCondition,@sampleCharacter,@getSample,@tester,@assessor,@sign,@L,@S0,@L0,@L1,@L2,@FMmax,@M,@isFinish,@testDate,@condition,@controlmode,@isUseExtensometer,@isEffective)"); OleDbParameter[] parameters = { new OleDbParameter("@testMethodName", OleDbType.VarChar, 100), new OleDbParameter("@testNo", OleDbType.VarChar, 100), new OleDbParameter("@testSampleNo", OleDbType.VarChar, 100), new OleDbParameter("@reportNo", 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("@L", OleDbType.Double), new OleDbParameter("@S0", OleDbType.Double), new OleDbParameter("@L0", OleDbType.Double), new OleDbParameter("@L1", OleDbType.Double), new OleDbParameter("@L2", OleDbType.Double), new OleDbParameter("@FMmax", OleDbType.Double), new OleDbParameter("@M", OleDbType.Double), new OleDbParameter("@isFinish", 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.testMethodName; parameters[1].Value = model.testNo; parameters[2].Value = model.testSampleNo; parameters[3].Value = model.reportNo; parameters[4].Value = model.sendCompany; parameters[5].Value = model.stuffCardNo; parameters[6].Value = model.stuffSpec; parameters[7].Value = model.stuffType; parameters[8].Value = model.hotStatus; parameters[9].Value = model.temperature; parameters[10].Value = model.humidity; parameters[11].Value = model.testStandard; parameters[12].Value = model.testMethod; parameters[13].Value = model.mathineType; parameters[14].Value = model.testCondition; parameters[15].Value = model.sampleCharacter; parameters[16].Value = model.getSample; parameters[17].Value = model.tester; parameters[18].Value = model.assessor; parameters[19].Value = model.sign; parameters[20].Value = model.L; parameters[21].Value = model.S0; parameters[22].Value = model.L0; parameters[23].Value = model.L1; parameters[24].Value = model.L2; parameters[25].Value = model.FMmax; parameters[26].Value = model.M; parameters[27].Value = model.isFinish; parameters[28].Value = model.testDate; parameters[29].Value = model.condition; parameters[30].Value = model.controlmode; parameters[31].Value = model.isUseExtensometer; parameters[32].Value = model.isEffective; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }