public bool UpdateProductsFieldValue(int ProductsID, ProductFieldValueJson fJson)
{
try {
if (fJson != null)
{
string tID = "";
StringBuilder strSql = new StringBuilder();
foreach (FieldValue fv in fJson.FieldValue)
{
if (fv != null)
{
if (fv.ProductFieldValueID > 0) //Old Data Update
{
tID += fv.ProductFieldValueID + ",";
strSql.Append("update tbProductsFieldValueInfo set ");
strSql.Append("ProductsID=@ProductsID,");
strSql.Append("ProductFieldID=" + fv.ProductFieldID + ",");
strSql.Append("pfvType=" + fv.Type + ",");
strSql.Append("pfvData='" + fv.value + "'");
strSql.Append(" where ProductsFieldValueID=" + fv.ProductFieldValueID + " ;");
}
else //New Data Insert
{
strSql.Append("insert into tbProductsFieldValueInfo(");
strSql.Append("ProductsID,ProductFieldID,pfvType,pfvData,pfvAppendTime)");
strSql.Append(" values (");
strSql.Append("@ProductsID," + fv.ProductFieldID + "," + fv.Type + ",'" + fv.value + "',@pfvAppendTime);");
}
}
}
SqlParameter[] parameters =
{
new SqlParameter("@ProductsID", SqlDbType.Int, 4),
new SqlParameter("@pfvAppendTime", SqlDbType.DateTime)
};
parameters [0].Value = ProductsID;
parameters [1].Value = DateTime.Now;
//删除不在该列表内的记录
if (tID.Trim() != "")
{
tID = Utils.ReSQLSetTxt(tID);
strSql.Append("delete from tbProductsFieldValueInfo where ProductsFieldValueID not in(" + tID + ") and ProductsID=@ProductsID;");
}
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
return(true);
}
else
{
return(false);
}
} catch {
return(false);
}
}
public bool AddProductsFieldValue(int ProductsID, ProductFieldValueJson fJson)
{
try {
if (fJson != null)
{
StringBuilder strSql = new StringBuilder();
foreach (FieldValue fv in fJson.FieldValue)
{
if (fv != null)
{
strSql.Append("insert into tbProductsFieldValueInfo(");
strSql.Append("ProductsID,ProductFieldID,pfvType,pfvData,pfvAppendTime)");
strSql.Append(" values (");
strSql.Append("@ProductsID," + fv.ProductFieldID + "," + fv.Type + ",'" + fv.value + "',@pfvAppendTime);");
}
}
SqlParameter[] parameters =
{
new SqlParameter("@ProductsID", SqlDbType.Int, 4),
new SqlParameter("@pfvAppendTime", SqlDbType.DateTime)
};
parameters [0].Value = ProductsID;
parameters [1].Value = DateTime.Now;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
return(true);
}
else
{
return(false);
}
} catch {
return(false);
}
}
public static bool UpdateProductsFieldValue(int ProductsID, ProductFieldValueJson fJson)
{
return(DatabaseProvider.GetInstance().UpdateProductsFieldValue(ProductsID, fJson));
}
