/// <summary> /// 更新一条数据 /// </summary> public bool Update(MesWeb.Model.T_Specification model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Specification set "); strSql.Append("SpecificationTypeID=@SpecificationTypeID,"); strSql.Append("SpecificationName=@SpecificationName,"); strSql.Append("SpecificationScale=@SpecificationScale,"); strSql.Append("SpecificationColor=@SpecificationColor,"); strSql.Append("ODMax=@ODMax,"); strSql.Append("ODMin=@ODMin,"); strSql.Append("SpecificationPrice=@SpecificationPrice"); strSql.Append(" where SpecificationID=@SpecificationID"); SqlParameter[] parameters = { new SqlParameter("@SpecificationTypeID", SqlDbType.Int, 4), new SqlParameter("@SpecificationName", SqlDbType.NVarChar, 50), new SqlParameter("@SpecificationScale", SqlDbType.NVarChar, 50), new SqlParameter("@SpecificationColor", SqlDbType.NChar, 10), new SqlParameter("@ODMax", SqlDbType.Float, 8), new SqlParameter("@ODMin", SqlDbType.Float, 8), new SqlParameter("@SpecificationPrice", SqlDbType.Decimal, 9), new SqlParameter("@SpecificationID", SqlDbType.Int, 4) }; parameters[0].Value = model.SpecificationTypeID; parameters[1].Value = model.SpecificationName; parameters[2].Value = model.SpecificationScale; parameters[3].Value = model.SpecificationColor; parameters[4].Value = model.ODMax; parameters[5].Value = model.ODMin; parameters[6].Value = model.SpecificationPrice; parameters[7].Value = model.SpecificationID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MesWeb.Model.T_Specification DataRowToModel(DataRow row) { MesWeb.Model.T_Specification model = new MesWeb.Model.T_Specification(); if (row != null) { if (row["SpecificationID"] != null && row["SpecificationID"].ToString() != "") { model.SpecificationID = int.Parse(row["SpecificationID"].ToString()); } if (row["SpecificationTypeID"] != null && row["SpecificationTypeID"].ToString() != "") { model.SpecificationTypeID = int.Parse(row["SpecificationTypeID"].ToString()); } if (row["SpecificationName"] != null) { model.SpecificationName = row["SpecificationName"].ToString(); } if (row["SpecificationScale"] != null) { model.SpecificationScale = row["SpecificationScale"].ToString(); } if (row["SpecificationColor"] != null) { model.SpecificationColor = row["SpecificationColor"].ToString(); } if (row["ODMax"] != null && row["ODMax"].ToString() != "") { model.ODMax = decimal.Parse(row["ODMax"].ToString()); } if (row["ODMin"] != null && row["ODMin"].ToString() != "") { model.ODMin = decimal.Parse(row["ODMin"].ToString()); } if (row["SpecificationPrice"] != null && row["SpecificationPrice"].ToString() != "") { model.SpecificationPrice = decimal.Parse(row["SpecificationPrice"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(MesWeb.Model.T_Specification model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Specification("); strSql.Append("SpecificationTypeID,SpecificationName,SpecificationScale,SpecificationColor,ODMax,ODMin,SpecificationPrice)"); strSql.Append(" values ("); strSql.Append("@SpecificationTypeID,@SpecificationName,@SpecificationScale,@SpecificationColor,@ODMax,@ODMin,@SpecificationPrice)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SpecificationTypeID", SqlDbType.Int, 4), new SqlParameter("@SpecificationName", SqlDbType.NVarChar, 50), new SqlParameter("@SpecificationScale", SqlDbType.NVarChar, 50), new SqlParameter("@SpecificationColor", SqlDbType.NChar, 10), new SqlParameter("@ODMax", SqlDbType.Float, 8), new SqlParameter("@ODMin", SqlDbType.Float, 8), new SqlParameter("@SpecificationPrice", SqlDbType.Decimal, 9) }; parameters[0].Value = model.SpecificationTypeID; parameters[1].Value = model.SpecificationName; parameters[2].Value = model.SpecificationScale; parameters[3].Value = model.SpecificationColor; parameters[4].Value = model.ODMax; parameters[5].Value = model.ODMin; parameters[6].Value = model.SpecificationPrice; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MesWeb.Model.T_Specification GetModel(int SpecificationID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SpecificationID,SpecificationTypeID,SpecificationName,SpecificationScale,SpecificationColor,ODMax,ODMin,SpecificationPrice from T_Specification "); strSql.Append(" where SpecificationID=@SpecificationID"); SqlParameter[] parameters = { new SqlParameter("@SpecificationID", SqlDbType.Int, 4) }; parameters[0].Value = SpecificationID; MesWeb.Model.T_Specification model = new MesWeb.Model.T_Specification(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }