/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.TestStandard_3D model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_TestStandard_3D set "); strSql.Append("Type=@Type,"); strSql.Append("RCO_Min=@RCO_Min,"); strSql.Append("RCO_Max=@RCO_Max,"); strSql.Append("AO_Min=@AO_Min,"); strSql.Append("AO_Max=@AO_Max,"); strSql.Append("FH_Min=@FH_Min,"); strSql.Append("FH_Max=@FH_Max,"); strSql.Append("AE_Min=@AE_Min,"); strSql.Append("AE_Max=@AE_Max,"); strSql.Append("OrderID=@OrderID,"); strSql.Append("ID_Key=@ID_Key"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@Type", SqlDbType.VarChar, 15), new SqlParameter("@RCO_Min", SqlDbType.VarChar, 15), new SqlParameter("@RCO_Max", SqlDbType.VarChar, 15), new SqlParameter("@AO_Min", SqlDbType.VarChar, 15), new SqlParameter("@AO_Max", SqlDbType.VarChar, 15), new SqlParameter("@FH_Min", SqlDbType.VarChar, 15), new SqlParameter("@FH_Max", SqlDbType.VarChar, 15), new SqlParameter("@AE_Min", SqlDbType.VarChar, 15), new SqlParameter("@AE_Max", SqlDbType.VarChar, 15), new SqlParameter("@OrderID", SqlDbType.VarChar, 15), new SqlParameter("@ID_Key", SqlDbType.Decimal, 9) }; parameters[0].Value = model.Type; parameters[1].Value = model.RCO_Min; parameters[2].Value = model.RCO_Max; parameters[3].Value = model.AO_Min; parameters[4].Value = model.AO_Max; parameters[5].Value = model.FH_Min; parameters[6].Value = model.FH_Max; parameters[7].Value = model.AE_Min; parameters[8].Value = model.AE_Max; parameters[9].Value = model.OrderID; parameters[10].Value = model.ID_Key; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.TestStandard_3D DataRowToModel(DataRow row) { Maticsoft.Model.TestStandard_3D model = new Maticsoft.Model.TestStandard_3D(); if (row != null) { if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["RCO_Min"] != null) { model.RCO_Min = row["RCO_Min"].ToString(); } if (row["RCO_Max"] != null) { model.RCO_Max = row["RCO_Max"].ToString(); } if (row["AO_Min"] != null) { model.AO_Min = row["AO_Min"].ToString(); } if (row["AO_Max"] != null) { model.AO_Max = row["AO_Max"].ToString(); } if (row["FH_Min"] != null) { model.FH_Min = row["FH_Min"].ToString(); } if (row["FH_Max"] != null) { model.FH_Max = row["FH_Max"].ToString(); } if (row["AE_Min"] != null) { model.AE_Min = row["AE_Min"].ToString(); } if (row["AE_Max"] != null) { model.AE_Max = row["AE_Max"].ToString(); } if (row["OrderID"] != null) { model.OrderID = row["OrderID"].ToString(); } if (row["ID_Key"] != null && row["ID_Key"].ToString() != "") { model.ID_Key = decimal.Parse(row["ID_Key"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.TestStandard_3D model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_TestStandard_3D("); strSql.Append("Type,RCO_Min,RCO_Max,AO_Min,AO_Max,FH_Min,FH_Max,AE_Min,AE_Max,OrderID)"); strSql.Append(" values ("); strSql.Append("@Type,@RCO_Min,@RCO_Max,@AO_Min,@AO_Max,@FH_Min,@FH_Max,@AE_Min,@AE_Max,@OrderID)"); SqlParameter[] parameters = { new SqlParameter("@Type", SqlDbType.VarChar, 15), new SqlParameter("@RCO_Min", SqlDbType.VarChar, 15), new SqlParameter("@RCO_Max", SqlDbType.VarChar, 15), new SqlParameter("@AO_Min", SqlDbType.VarChar, 15), new SqlParameter("@AO_Max", SqlDbType.VarChar, 15), new SqlParameter("@FH_Min", SqlDbType.VarChar, 15), new SqlParameter("@FH_Max", SqlDbType.VarChar, 15), new SqlParameter("@AE_Min", SqlDbType.VarChar, 15), new SqlParameter("@AE_Max", SqlDbType.VarChar, 15), new SqlParameter("@OrderID", SqlDbType.VarChar, 15) }; parameters[0].Value = model.Type; parameters[1].Value = model.RCO_Min; parameters[2].Value = model.RCO_Max; parameters[3].Value = model.AO_Min; parameters[4].Value = model.AO_Max; parameters[5].Value = model.FH_Min; parameters[6].Value = model.FH_Max; parameters[7].Value = model.AE_Min; parameters[8].Value = model.AE_Max; parameters[9].Value = model.OrderID; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.TestStandard_3D GetModel(string _strSql) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Type,RCO_Min,RCO_Max,AO_Min,AO_Max,FH_Min,FH_Max,AE_Min,AE_Max,OrderID,ID_Key from tb_TestStandard_3D "); strSql.Append(" where " + _strSql + ""); Maticsoft.Model.TestStandard_3D model = new Maticsoft.Model.TestStandard_3D(); DataSet ds = dbs.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }