/// <summary> /// 增加一条数据 /// </summary> public string Add(业务.Model.检验值 model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.接收数据 != null) { strSql1.Append("接收数据,"); strSql2.Append("N'" + model.接收数据 + "',"); } if (model.发射器编号 != null) { strSql1.Append("发射器编号,"); strSql2.Append("" + model.发射器编号 + ","); } if (model.测量数值 != null) { strSql1.Append("测量数值,"); strSql2.Append("" + model.测量数值 + ","); } if (model.原始值 != null) { strSql1.Append("原始值,"); strSql2.Append("" + model.原始值 + ","); } if (model.dtmCreate != null) { strSql1.Append("dtmCreate,"); strSql2.Append("getdate(),"); } strSql.Append("insert into 检验值("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); return(strSql.ToString()); }
private void SaveChkValue(string sProtValue) { try { if (sProtValue.Trim() == "") { return; } SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { Model.检验值 mod = new 业务.Model.检验值(); mod.接收数据 = sProtValue; int i发射头 = BaseFunction.ReturnInt(sProtValue.Substring(1, 2)); decimal d测量数值 = BaseFunction.ReturnDecimal(sProtValue.Substring(3, 8)); mod.发射器编号 = i发射头; mod.测量数值 = d测量数值; mod.原始值 = d测量数值; sSQL = string.Format(sSQL, mod.发射器编号); DAL.检验值 dal = new 业务.DAL.检验值(); sSQL = dal.Add(mod); int iCou = DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); if (iCou > 0) { tran.Commit(); GetGrid(); txtChkValue.Text = ""; txtChkValue.Focus(); } } catch (Exception ee) { tran.Rollback(); throw new Exception(ee.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } catch (Exception ee) { txtChkValue.Text = ""; txtChkValue.Focus(); } txtChkValue.Text = ""; }