public int Save(ProductSpecTemp saveTemp)
{
saveTemp.Replace4MySQL();
StringBuilder stb = new StringBuilder("insert into product_spec_temp (`writer_id`,`spec_type`,`spec_name`,`spec_sort`,`spec_status`,`spec_id`,`spec_image`,`product_id`)");
stb.AppendFormat(" values({0},{1},'{2}',{3},{4},{5},'{6}'", saveTemp.Writer_Id, saveTemp.spec_type, saveTemp.spec_name, saveTemp.spec_sort, saveTemp.spec_status, saveTemp.spec_id, saveTemp.spec_image);
stb.AppendFormat(",'{0}')", saveTemp.product_id);
return _access.execCommand(stb.ToString());
}
public string Update(ProductSpecTemp pSpec, string updateType)
{
pSpec.Replace4MySQL();
StringBuilder strSql = new StringBuilder("set sql_safe_updates = 0; update product_spec_temp set ");
strSql.AppendFormat(" spec_status={0} ", pSpec.spec_status);
if (updateType == "image")
{
strSql.AppendFormat(",spec_image='{0}'", pSpec.spec_image);
}
if (!string.IsNullOrEmpty(pSpec.spec_name))
{
strSql.AppendFormat(" ,spec_name='{0}'", pSpec.spec_name);
}
if (pSpec.spec_sort != 0)
{
strSql.AppendFormat(" ,spec_sort={0}", pSpec.spec_sort);
}
strSql.AppendFormat(" where spec_id='{0}';set sql_safe_updates = 1;", pSpec.spec_id);
return strSql.ToString();
}
