/// <summary> /// 增加一条数据 /// </summary> public int AddProductsFieldValue(ProductsFieldValueInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbProductsFieldValueInfo("); strSql.Append("ProductsID,ProductFieldID,pfvType,pfvData,pfvAppendTime)"); strSql.Append(" values ("); strSql.Append("@ProductsID,@ProductFieldID,@pfvType,@pfvData,@pfvAppendTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@ProductFieldID", SqlDbType.Int, 4), new SqlParameter("@pfvType", SqlDbType.Int, 4), new SqlParameter("@pfvData", SqlDbType.NText), new SqlParameter("@pfvAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductsID; parameters[1].Value = model.ProductFieldID; parameters[2].Value = model.pfvType; parameters[3].Value = model.pfvData; parameters[4].Value = model.pfvAppendTime; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void UpdateProductsFieldValue(ProductsFieldValueInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbProductsFieldValueInfo set "); strSql.Append("ProductsID=@ProductsID,"); strSql.Append("ProductFieldID=@ProductFieldID,"); strSql.Append("pfvType=@pfvType,"); strSql.Append("pfvData=@pfvData,"); strSql.Append("pfvAppendTime=@pfvAppendTime"); strSql.Append(" where ProductsFieldValueID=@ProductsFieldValueID "); SqlParameter[] parameters = { new SqlParameter("@ProductsFieldValueID", SqlDbType.Int, 4), new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@ProductFieldID", SqlDbType.Int, 4), new SqlParameter("@pfvType", SqlDbType.Int, 4), new SqlParameter("@pfvData", SqlDbType.NText), new SqlParameter("@pfvAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductsFieldValueID; parameters[1].Value = model.ProductsID; parameters[2].Value = model.ProductFieldID; parameters[3].Value = model.pfvType; parameters[4].Value = model.pfvData; parameters[5].Value = model.pfvAppendTime; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public ProductsFieldValueInfo GetProductsFieldValueModel(int ProductsFieldValueID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ProductsFieldValueID,ProductsID,ProductFieldID,pfvType,pfvData,pfvAppendTime from tbProductsFieldValueInfo "); strSql.Append(" where ProductsFieldValueID=@ProductsFieldValueID "); SqlParameter[] parameters = { new SqlParameter("@ProductsFieldValueID", SqlDbType.Int, 4) }; parameters[0].Value = ProductsFieldValueID; ProductsFieldValueInfo model = new ProductsFieldValueInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.pfvData = ds.Tables[0].Rows[0]["pfvData"].ToString(); if (ds.Tables[0].Rows[0]["ProductsFieldValueID"].ToString() != "") { model.ProductsFieldValueID = int.Parse(ds.Tables[0].Rows[0]["ProductsFieldValueID"].ToString()); } if (ds.Tables[0].Rows[0]["ProductsID"].ToString() != "") { model.ProductsID = int.Parse(ds.Tables[0].Rows[0]["ProductsID"].ToString()); } if (ds.Tables[0].Rows[0]["ProductFieldID"].ToString() != "") { model.ProductFieldID = int.Parse(ds.Tables[0].Rows[0]["ProductFieldID"].ToString()); } if (ds.Tables[0].Rows[0]["pfvType"].ToString() != "") { model.pfvType = int.Parse(ds.Tables[0].Rows[0]["pfvType"].ToString()); } if (ds.Tables[0].Rows[0]["pfvAppendTime"].ToString() != "") { model.pfvAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["pfvAppendTime"].ToString()); } return(model); } else { return(null); } }
public static void UpdateProductsFieldValue(ProductsFieldValueInfo model) { DatabaseProvider.GetInstance().UpdateProductsFieldValue(model); }
public static int AddProductsFieldValue(ProductsFieldValueInfo model) { return(DatabaseProvider.GetInstance().AddProductsFieldValue(model)); }